Frank Berrocal
pm/ba/sd
Experience the fusion of imagination and expertise
project manager, business analyst, and software developer.
“Years of experience in multiple roles and industries have led me to gain the skills, knowledge, and abilities to merge my expertise in multiple areas and provide the best service and product possible to both internal and external customers.”
“I aim to learn more each day and improve the work I create.”
portfolio
/pôrt-fō′lē-ō″/
A portable case for holding material, such as loose papers, photographs, or drawings.
The materials collected in such a case, especially when representative of a person’s work.
An ample spectrum of resources
Multitude of services to companies from all industries and several roles.
Current projects
- Freelance Software Developer
- *** Developing a new business ***
- Portfolio webpage (hosting provider, URL management, WordPress, design).
- AI applied research.
- Automated marketing research tool (No-Code, Javascript, online database).
- Working at G2VOptics providing Software Development services for maintenance / improvement / documentation / testing of BI system. (June, 2024)
Equium Group
- Data Analyst / Zendesk Admin
- Zendesk Admin. Working on analysis, requirement gathering, process mapping, solution design, implementation, testing, and future expansion of the customer support system.
- Created a webform channel to improve the added value of the customer support operation to users, applying automation, segmentation, and analysis of inquiries. Created a system with automated routing, specific measurement tags, improved reporting, and access to the database of tickets and their comments, enhancing the capabilities to understand the customer.
ProfileTree Digital Marketing Agency
- Technical Project Manager / Software Developer
- Software Developer, working with JavaScript, React, HTML, Rest APIs, WordPress, and SQL.
- The output of this project will create tools aimed to improve internal productivity of content authoring.
- Translation of metrics from Google Analytics 4 to UA.
G2V Optics Inc.
- Marketing Ops – Software Engineer – Data Engineer.
- I quickly developed skills related to knowledge and expert usage of internal tools.
- Consolidation of the data-oriented vision of the Marketing VP with tangible products: sales funnels, corporate revenue information in real-time, combining data from Finance, Production, Marketing, and Sales. (#BusinessIntelligence).
- I implemented automatization interfaces using #Make to automatize the extraction of information while considering the runtime complexity reflected as cost. Output: All the data from the datasets updates the repositories without human intervention (insertion and updating).
TechData
- Business Analyst II
- Providing analysis support for Kaspersky as part of TechData. This involves creation of the reporting structure, capture of business requirements, creation and develop of KPIs, migration of original functional structure from Excel to Access and Power BI.
- Development of ETL framework.
- Prototyping in Excel to test business rules provided.
- Continuous revision and improvement of the system.
- Migration of the system using limited resources, with Power BI, power Query, Excel Data Connection and SharePoint.
- Multi user dashboards in Power BI service.
- Disaster Recovery Process design, test and implementation.
More information: