Berly (Alejandro) BACA-REYES

Power Platform Developer Data Analyst

ad06ag@r.postjobfree.com linkedin.com/in/albarey

Updated: November 2023

GOAL

My goal is to elevate my professional expertise by leveraging Power Platform tools to deliver swift solutions for automating web processes. Concurrently, I aim to establish a robust foundation for well-informed, data-driven decisions, providing valuable insights through a comprehensive approach to data - analyzing, interpreting, and visualizing results. I am eager to apply my skills in PowerApps projects of varying sizes and topics, with the goal of incorporating them into my portfolio as successfully concluded works.

TECHNICAL SKILLS

Software Development: Power Apps canvas, R, Python, T-SQL, M, DAX. Data Processing: Tidyverse, Dplyr, NumPy, Pandas. Data Visualization: MS Power BI, ggplot2, Matplotlib, Seaborn, Tableau. Predictive Analysis - Machine Learning Libraries: Scikit-learn, TensorFlow, Keras, Caret. IDEs: Jupyter Notebooks, RStudio, SQL Server Management Studio (SSMS), Azure SQL Database, Azure Data Studio, Visual Studio Code. Microsoft Suite: Excel Advanced, SharePoint, Microsoft365 (Office).

SOFT SKILLS

Committed to high-quality work, with a results-driven and time-optimized approach.

Detail-oriented, analytical with a problem-solving mindset.

Continuous learner, and open to constant evaluations.

Capable of working independently while coordinating and collaborating within a team.

Languages: English (Proficient), Spanish (Native).

EDUCATION

Data Analysis / Data Science Certificates

oData Science Certificate - Microsoft Professional Program (ten courses and a capstone) on Microsoft Academy EDX. 2017 - 2019

oFour online courses in Machine Learning and Data Science using Python and R languages. Udemy. 2020 – 2022

B.Sc. in Industrial Engineering University of Lima, Peru. 1986 – 1993

EXPERIENCE

Data Analyst / Power Platform Developer Carolina Collaborative Community Care (4C). Fayetteville, NC. Jan. 2015 – Present

oGoal Achievement: Established a strong foundation for data-driven decision-making by developing user-friendly applications and dashboards. Connected data from various sources, processed hundreds of thousands of records, cleaned, analyzed, and normalized data, delivering valuable insights.

oInnovation: Initiated the creation of ‘Newborns Follow-up’ and 'Mailings' applications within PowerApps and Power Automate, streamlining daily tasks and integrating them with SharePoint lists as data repositories.

oData Visualization Expertise: Designed and developed numerous interactive Power BI charts, incorporating dynamic filters and key performance indicators (KPIs) and business parameters using DAX code and Power Query editor (M language). Published them on the web for easy user access while ensuring the confidentiality of patient information. Also experienced in using Tableau.

oBig Data Handling: Proficiently managed large datasets, wrote SQL, R, and Python code scripts, developed ETL data pipelines, emphasizing data quality, accuracy, and consistency, linking references to data sources for verification.

oVersatile Reporting: Designed and produced a variety of ad-hoc reports using Excel, with features to automatically update using SQL, macros, and VBA code.

oHealthcare Analytics: Leveraged data to prioritize the recipients of care management services through risk scoring models, medical and behavioral health indicators, and hospital claims, enhancing intervention impact.

oHIPAA Compliance: Accessed and processed Private Health Information (PHI) from North Carolina state health systems strictly adhering to HIPAA regulations.

Data Analyst and Industrial Cost Accountant Alicorp Food Company – Priox.

Lima, Peru. 2013.

oAnalytical Proficiency: Performed data analysis on big data from the company’s ERP system, specializing in identifying unbalances and outliers in cost-to-profit ratios, categorizing and sorting products.

oStrict Procedure Adherence: Executed transactions in the Finance and Controlling module of the company’s ERP system, conducted month-end closing procedures, and performed account reconciliations.

oEfficiency Audits: Focus on efficiency in cost analysis and production timelines to contribute to cost reduction and operational optimization.

Data Analyst & Industrial Cost Accountant ARIN Gold & Silver Industrial Jewelry Company. Lima, Peru. 2006 –2012

oPerformance Enhancement: Monitored and analyzed monthly cost-to-profit ratios by product line, utilizing data from Accounting and Production Systems. Established performance metrics with statistical methods.

oCash Flow Optimization: Developed an Excel-based system to control cash flow control and forecast transactions, incorporating macros for automation.

oRatio Automation: Automated the calculation of the Cost of Goods Sold ratio, a crucial input for accounting / financial statements.

oExcel Expertise: Devised a comprehensive Manufacturing Resource Planning system (MRP) in Excel, for estimating and forecasting process capacity, connecting with data from the production system and using macros to automate calculations. This system used source data such as the Bill of Materials, Item Master, Inventory, Order book, and process capacities for the production department.

oProcess Enhancement: Collected, analyzed, and shared reports from processed data, aimed at cost reduction and operational efficiency across production phases.

WORK ELIGIBILITY

Legally eligible to work in the United States for any employer.

Contact this candidate