Fredi Garcia

I am a highly adaptable Business Intelligence Analyst with expertise in Power BI, Tableau, SQL, and a diverse background in IT and data analysis.

Business Intelligence Analyst

Remsoft Inc, Fredericton, NB. Canada

June 2023 – Present

• Develop and deliver Power BI dashboards and reports using Remsoft's cloud and optimization platform, enhancing business value for Remsoft and clients.
• Create intuitive Power BI dashboards to facilitate the implementation and utilization of Remsoft's solutions for both internal and external stakeholders.
• Designed and developed customized applications using Power Apps, enabling efficient data input, visualization, and user interaction, ultimately enhancing data-driven decision-making across the organization.
• Ensure data quality by identifying and rectifying missing values, outliers, and inconsistencies.
• Translate complex data insights into actionable recommendations for non-technical stakeholders.
• Provide hands-on support to clients for implementing product-specific and custom project-based dashboards.
• Contribute to Quality Assurance testing of features, reports, and product dashboards.
• Participate in the design and documentation of Remsoft Operations features, including feature requirements, user stories, user personas, and mock-ups.
• Utilized advanced DAX (Data Analysis Expressions) functions in Power BI to perform complex calculations, create calculated columns, and develop custom measures, enhancing the depth and accuracy of analytical insights.
• Proficient in SQL Azure for optimizing data storage, retrieval, and transformation, ensuring seamless integration with Power BI dashboards and reports.
• Leveraged Power Automate to automate data workflows and streamline data integration processes, improving data accessibility and reducing manual data handling.

Data and Business Analyst Internship              
Remsoft Inc, Fredericton, NB. Canada

April 2023 – June 2023

• Formulated comprehensive use cases and user stories to guide forest resource harvesting, delivery, and transportation.
• Defined project and product scopes, ensuring clear objectives and boundaries.
• Documented intricate business processes to enhance transparency and understanding.
• Generated requirements based on insightful analytics findings, contributing to informed decision-making.
• Utilized advanced analytical and BI tools like SQL and Power BI to craft insightful reports and analytics.
• Collaborated effectively on cross-functional teams to communicate and present findings.

Data Analyst Coordinator

Bio Pappel SAB, Mexico City. Mexico.

March 2021 – August 2022

• Deliver dynamic Tableau dashboards and Microsoft Excel reports in presentations, conveying results effectively.
• Apply ETL techniques, utilizing VBA, SQL, and Excel files, to extract, transform, and load data from ERP systems for auditing, finance, and HR analysis.
• Utilize ACL Analytics, SQL, Microsoft Excel, and R programming for comprehensive data analysis.
• Lead stakeholder engagement and facilitate collaborative decision-making through strategic questioning and data insights.

IT Analyst

Bio Pappel SAB, Mexico City. Mexico.

May 2015 – February 2021

• Collected, cleansed, and analyzed Payroll and HR ERP systems data, providing valuable insights to stakeholders.
• Employed SQL for complex calculations, merging data from diverse sources to generate informative tables and results.
• Developed, optimized, and managed SQL objects, including stored procedures, queries, views, and triggers, enhancing database efficiency.
• Created impactful visualizations using SQL Server Reporting Services, aiding data-driven decision-making.
• Defined and monitored essential KPIs to manage employee processes effectively.
• Provided comprehensive software and hardware support for internal ERP users, assisting via various channels.

EDUCATION 

New Brunswick Community College, Fredericton, NB. Canada. 

Post Graduate Certification in IT: Business Analysis. September 2022- June 2023. 

Technological Of Higher Studies of Cuautitlan Izcalli, Mexico. 

University Degree in Computer Systems Engineering.  September 2008 – February 2013. 

CERTIFICATIONS

Google Data Analytics April 2022.