Power BI/Sr. Data Analyst/ Project Manager Resume

SUMMARY:

Solutions - oriented Data & Power BI Analyst with proven expertise analyzing various large datasets for the e-commerce, healthcare, aerospace, financial, and telecommunication industries for over 25 years.
Proven qualifications in data modeling, analyzing requirements, planning, designing and implementing innovative database solutions that meet or exceed challenging business needs.
Designed, developed and implemented Power BI Dashboards, Scorecards & KPI Reports.
Project Lead accountable for providing strategic and tactical leadership to ensure full project life cycle design, development and implementation of database solutions.
Software development life cycle (SDLC): from initial feasibility analysis and conceptual design through testing and documentation.
Designed, developed and implemented test plans, user documentation and completing projects on schedule.
Combined expertise in strategic planning with strong technical qualifications. Strength in developing projects planning, tracking and reporting strategies.
Interface effectively with clients, team members and management.
United States Air Force Veteran - served for 5 ½ years, honorably discharged

TECHNICAL SKILLS:

Databases: SQL Server, SSIS, SSAS, SSRS, Visual Studio 2010, MS Access, Oracle

Languages: DAX, SQL, PLSQL, TSQL, MySQL, Tabular Cubes, VBA, ODBC

Software: Power BI, Excel - Power Pivot & Power Query, Data Models, BPMN

PROFESSIONAL EXPERIENCE:

Confidential

Power BI/Sr. Data Analyst/ Project Manager

Responsibilities:

Created Power BI visualization of Dashboards & Scorecards (KPI) for Finance Department
Designed and implemented a Monthly Resource Allocations system using Excel Power Query & Power Pivots to be included in dashboard reporting.
Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards & Scorecards (KPI) and MySQL, AWS & Data warehouse data sources.
Analyzed business requirements, created business/process flow charts, database flow charts and reporting tool database for Research Revenue Management tracking for Expedia.
Manage Departmental Reporting systems, troubleshooting daily issues, and integrating existing Access databases with numerous external data source including (SQL, Visual Studio 2010, Excel, & Access).
Redesign of queries for implementation in to SSIS (Visual Studio 2010)
Designed and implemented multiple dashboards using Power BI - PowerPivot & Power Query tools for in house metrics.
Scorecard ADHOC development of SQL to Excel dashboards, charts, graphs, and Pivot tables.

Confidential

Project Lead/Business/Data & Database Analyst

Responsibilities:

Created documentation and reversed engineered existing Access Databases to consolidate and automate the databases. Integrated numerous external data source including (Oracle, SQL, MS Office products)
Acted as Subject Matter Expert (SME) for the AGILE team on the redesign of the Access databases to Oracle web-based system.
Documented business, process and data flow documentation on multiple data systems
Designed Data models on multiple database systems Customer support, troubleshooting and modifying databases to meet the customer’s requirements.
Developed multiple databases that have saved time and money for the various organizations.
Improved an Oracle database download process from Access and improved running time from 12 hours to 30 minutes.
Designed and developed Employee’s Training database system that exported data to an on-demand excel spreadsheet, this new system improves processing time from 30 days to 30 minutes a month.
Improved, redesigned, and maintained 100’s of individual Access databases which tracked work statements & work load for testing of instrumentation of aircraft within Boeing Instrumentation Flight Test.