Paola Andino
Guaynabo
Summary
Data-driven public health professional providing visibility to organizations and companies through rigorous qualitative and quantitative analysis allowing data-driven decisions. With 10 years of experience, focused on identifying the risks in the sales area, creating smart and automated reports to define strategies that allow us to optimize and track results. Experienced in business intelligence and data analytics using SQL, Power Query, Access, R Program, Power Apps, Power Automate, DAX Language and Power Bi.
Overview
3
3
years of professional experience
Work History
Regional Power Bi/ Data Analyst
McCain Foods, Inc.
11.2023 - Current
- Applied professional knowledge of computer science, mathematical, statistical theories, techniques, and methods to gather, analyze, design, and construct new processes for analytical modeling, interpreting models, and/or reporting quantitative information, trends, relationships, and correlations among or within data
- Lead the digital data and analysis efforts related to developing and implementing customer strategy, digital design of products and services, and support platform development
- Collaborated with the business for requirement, defines metrics and measures of effectiveness, and expected outcomes; identified and developed innovative and effective approaches and methodologies; applied advanced operations research and data science techniques for quantitative analysis, statistical analysis, forecasting, predictive modeling, prescriptive analysis, and optimization; and validated analysis and outcomes
- Identified the methods, processes, algorithms, tools, and systems to extract and interpret findings from various structured and unstructured data sets related to the data science lifecycle
- Lead regional assessment to recommend plans for short- and long-term analytics opportunities, based on business priorities and vision
- Mapped cross-functional of key internal relationships to identify processes in need of strategic improvement
- Determined if the current technology/systems meet or misses at driving process efficiencies
- Designed dashboards on-demand from SQL-generated data
- Created visualizations in Power Bi for data analysis
- Identified data metrics through data analysis
- Developed reports based on the needs of the business unit
- Created models based on analytical platform to obtain 20% more efficient for a better visualization of indicators
- Created databases, which allowed us to reduce query time project information
- Coordination of 100% of Projects assigned to my position.
Supply Chain Analyst
McCain Foods, Inc.
06.2022 - 11.2023
- Ensured the company’s supply meets the customers’ demand
- Created reports with Power Bi (using Power Query and DAX) to report company KPI’s daily
- This includes management reports, financial reports, forecast reports and sales reports
- Create and maintain reports and dashboards for order to cash process
- Improved the efficiency of supply chain operations through descriptive and predictive analytics, data collection and rigorous analysis
- Guaranteed the company’s supply chains, ensuring timely delivery, ensuring that the company customers are billed correctly, and keeping the company on budget
- Responsible to create, implement and enforce procedures and policies, as well as streamlining effective processes across multiple markets
- Analysis and optimization area information (routes courier, parcel, truckload (LTL) and logistics solutions)
- Reduced customer claim email inbounds by 85% by improving and automating order to cash process
- Created automated order tracker reports by integrating data bases and data segmentation
- Responsible for the development of algorithms and/or tools to support data manipulation and processing as well as the use of data visualization techniques to articulate findings.
Senior Pharmacy Business Analyst
Medical Card System (MCS)
02.2022 - 06.2022
- Develop and create reports integrating several databases, multiple table relationships with complex criteria to perform the analyzes requested by management
- Automated processes carried out and/or reports used in the unit to achieve greater cost efficiency in the department
- Supervised and mentored lower-level analysts to improve processes across the company
- Make price comparisons of generic and brand drugs to prepare reports that help the Management to make the corresponding decisions
- Identified financial impact processes or trends related to drug costs and referred them to management for the corresponding actions
- Participated in the bidding process with the actuarial unit to develop utilization and cost reports
- Serves as a subject matter expert to other business analysts in the process of developing, automating, and modifying reports
- Participated in related corporate projects that are of high impact in the company in which must define the strategy, metrics and carry out the necessary analysis and recommendations to senior management for decision making.
Statistical Analyst
Triple S, Inc.
08.2021 - 02.2022
Education
Doctor in Public Health - Health Administration
University of Puerto Rico, Medical Sciences Campus
Rio Piedras05.2022
Master in Public Health - Public Health
University of Puerto Rico, Medical Sciences Campus
Rio Piedras05.2017
Bachelor of Science - Biology
University of Puerto Rico, Río Piedras Campus, PR
Rio Piedras05.2016
Skills
- Data Visualization and Presentations
- Data Analysis
- Excel Functions
- Analytical skills
- Database Management
- Diagnostic and predictive analysis
- Quality control management
- Research
- Proactive
- Communication
- Adaptability
- Leadership
- Organizational skills
Languages
Spanish
Native language
English
Proficient
C2
Timeline
Regional Power Bi/ Data Analyst
McCain Foods, Inc.
11.2023 - Current
Supply Chain Analyst
McCain Foods, Inc.
06.2022 - 11.2023
Senior Pharmacy Business Analyst
Medical Card System (MCS)
02.2022 - 06.2022
Statistical Analyst
Triple S, Inc.
08.2021 - 02.2022
Doctor in Public Health - Health Administration
University of Puerto Rico, Medical Sciences Campus
Master in Public Health - Public Health
University of Puerto Rico, Medical Sciences Campus
Bachelor of Science - Biology
University of Puerto Rico, Río Piedras Campus, PR
Similar Profiles
Thiago NUNES SIMÕESThiago NUNES SIMÕES
Procurement Sr. Manager Europe at McCain Foods Europe, Lutosa, McCain Appetizer’s and Ad Van GelovenProcurement Sr. Manager Europe at McCain Foods Europe, Lutosa, McCain Appetizer’s and Ad Van Geloven
Stephanie SchultzStephanie Schultz
EMP Coordinator at McCain Foods USAEMP Coordinator at McCain Foods USA
Varun BhalodwalaVarun Bhalodwala
Project Manager at McCain FoodsProject Manager at McCain Foods
Carolina TorresCarolina Torres
Babysitter at RelativeBabysitter at Relative
Daniel Armando Rios FelicianoDaniel Armando Rios Feliciano
Photographer at Mets De GuaynaboPhotographer at Mets De Guaynabo