Jorge Cervantes

Data Analyst/Power BI Developer

Blue Water Thinking

May 2020 - Current (6 years 6 months)

• Lead Developer and Data Analyst overseeing the development of Power BI projects to meet client information needs.
• Created a coaching and teaching program for new Power BI users utilizing existing data, promoting best practices, data modeling concepts, use of calculated columns, calculated measures, and introduction to the DAX language.
• Consulted on other Power BI development projects on other government contracts, providing insights and assisting in troubleshooting reporting issues.
• Leveraging multiple sources of data; Salesforce, MS Access, Excel, SharePoint, SQL, and other organizational data sources for BI reporting.
• Managed projects using Scrum fundamentals and using TFS Agile project monitor to track all d

Quality Assurance Analyst

Concorde Battery Corporation

Dec 2019 - Mar 2020 (4 months)

• Evaluated database requirements for the migration of AS400 and MS Access data to SQL server services and automated reporting.
• Identified and corrected data gaps between legacy systems to meet the SQL implementation.
• Designed and implemented daily, weekly, ad hoc reports using Excel and Power BI.

Data Analyst/Power BI Developer

PSG, a Dover company

Jun 2017 - Nov 2019 (2 years 6 months)

• Introduced/developed dashboard reports using Power BI for strategic management decisions and visualization of logistics data.
• Extraction, data cleaning, and loading of data from multiple data sources including Excel sheets, CSV files, and Oracle.
• Developed and implemented interactive dashboard utilized for root cause analysis to pinpoint costs associated with customer returns as well as internal rejections.
• Developed and implemented budget analysis tool using Power BI for visualization utilized to analyze costs of new product development and tooling.
• Working closely with quality engineers, analyzed data for customer returns trending out repeated issues. Resulting in a reduction of 52% in customer returns. Show

Power BI Developer

ATI

Sep 2016 - Mar 2017 (7 months)

• Published metrics relating to the impact of internal rejected material using the Power BI service.
• Applying data analytics with the use of Power BI, graphically present key performance indicators to pinpoint contributing factors leading to product failures.
• Working closely with Quality Engineers, drafted, and implemented evaluation model to salvage $1.3 million in potential scrap materials from a $2.1 million rejected inventory.

About

Detail

Timeline

Résumé

Jorge Cervantes

About

Detail

Behavioral traits