ALLISON CHIRINOS
Miramar,FL
Summary
Proactive BI Analyst with 3+ years accomplished at processing large-scale stores of disorganized data into harmonious and accessible Business Intelligence tools.
Wide knowledge using Power Query (M language), Power Pivot and Data Analysis Expressions (DAX); as well as T-SQL to write queries, store procedures, functions and troubleshoot.
Deft at providing easily understood dashboards and tools in Power BI, by designing, developing, and testing enhancements. Noted creator of media accessible to anyone from senior executives to customer service personnel.
Overview
4
4
years of professional experience
Work History
BI Analyst
Foundation Risk Partners
09.2022 - Current
- Collected data from wide-ranging sources.
- Developed intelligence-sharing dashboards, providing company-wide access to collected data (set up gateways, frequency of refreshes and RLS in Power BI Service).
- Collaborated with stakeholders to identify business needs and data sources, and transform them into requests.
- Responded to specific BI requests from Finance, Sales and Enterprise Services personnel, creating data packets with requested information in easily understandable formats.
- Provided technical support for troubleshooting analytics and reporting issues.
- Developed SQL scripts to validate, process, clean, insert and migrate data between data bases.
- Analysis of data using DAX queries, functions in M language (Power Query) and SQL scripts.
- Documentation for projects and processes using Smartsheets.
- Lead of analytics team, manage workload, used concepts of agile framework.
BI Developer
Credito Real USA Finance
12.2021 - 08.2022
- Developed and managed dashboards (set up gateways, frequency of refreshes and RLS) using Power BI.
- Designed customized data collection models for specific visualization tasks.
- Connect data sources, import data, and transform data per business needs
- Wrote and optimized SQL statements to assist business intelligence practices.
- Analysis of data using DAX queries and functions in M language (Power Query)
- Develop flows for processing and exporting data into CSV files using Power Automate.
- Prepared targeted documentation, specifications and resources to analyze business data.
Data Analyst
Corporación Rico SAC
12.2019 - 03.2021
- Produced monthly reports using advanced Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Utilized data visualization tools (Power BI) to effectively communicate business insights.
- Extract, load and transform data in Power Query, develop measures using DAX queries
- Documented effective and replicable methods for extracting data and organizing data sources.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Education
Data Analyst in Power BI - Data Management Technology
Datacamp
New York, NY09.2023
Data Analyst in SQL - Data Processing Technology
Datacamp
New York, NY06.2023
Diploma - Project Management
Coursera
California City, CA01.2022
Bachelor's degree - Industrial Engineering
Catholic University San Pablo
Arequipa, PE07.2018
Skills
- Critical Thinking
- Data Analysis
- Data Visualization
- Extraction Transformation and Loading (ETL)
- User Acceptance Testing (UAT)
- Quality Assurance
Languages
English
Professional Working
French
Limited Working
Timeline
BI Analyst
Foundation Risk Partners
09.2022 - Current
BI Developer
Credito Real USA Finance
12.2021 - 08.2022
Data Analyst
Corporación Rico SAC
12.2019 - 03.2021
Data Analyst in Power BI - Data Management Technology
Datacamp
Data Analyst in SQL - Data Processing Technology
Datacamp
Diploma - Project Management
Coursera
Bachelor's degree - Industrial Engineering
Catholic University San Pablo