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.

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.

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.

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.