Power BI Instructor

ETL (ADF, SSIS) / Power BI Developer

Supporting the development and maintenance of scalable data stores that supply data in forms needed for business analysis.• Builds ELTL pipelines in Azure Data Lake Storage, Azure Synapse, Azure Data Factory, Databricks and Power BI.• Builds ML pipelines using Azure Machine Learning Studio.• Converted SSIS packages to Azure Data Factory.• Translates business requirements into Power BI dashboards and reports.

Microsoft Dynamics Great Plains (GP) migration to Oracle Financials ERP Cloud - $1.4B in project costs, purchase orders, contracts, BOM, budget.• Eliminated data migration bottlenecks by using SSIS to automate retrieval of GP data and population of Oracle File-Based Data Import (FBDI) files.• Increased client’s understanding of the limitations and subsequent workarounds of Oracle Transactional Business Intelligence (OTBI) reporting tool.

Application database performance improvement.• Implemented SQL stored procedure performance improvements by replacing inefficient code.• Responsible for Azure DevOps build, test and deploy of developer solutions to Microsoft SQL Server.

Microsoft SSIS, SSRS and SQL Server database programming.• Accelerated business initiatives by applying my mortgage industry and NMLS certification knowledge.• Accelerated project completion by coordinating tasks among multiple developers.• Used SSIS to load multiple sources – Ellie Mae Encompass, ARMCO ACES, Five9, Survey Monkey, Velocify, Equifax, GR Insurance – into a star schema data warehouse.• Maintained SSRS reports from the Encompass data warehouse.

Responsible for all finance department reporting.• Administered, populated and reported from Microsoft SQL Server, SAS Financial Management and BancWare Asset Liability Management financial systems.• Automated balance sheet and income statement data preparation for planning and forecasting.

Microsoft SSRS and data warehouse administration for 60+ hosted clients.• Developed SSRS matrix reports on auto insurance contracts and claims using subreports, cascading parameters, shared data sources, T-SQL stored procedures.• Developed reinsurance data mart and reporting.• Maintained T-SQL stored procedures used in data warehouse loading. • Managed three offshore SSRS developers and assisted client developers.

Teaching Microsoft Access, Excel and SQL.• Excellent lecturing and facilitation resulting in outstanding performance reviews from administrators and students.• Authored all course documents (syllabus, lectures, assignments, tests).

Completed a data migration to Finance and Insurance Administration Solutions (FIAS) SQL Server consisting of $781M in contract sales and $118M in paid claims.• Established daily migration strategy with C-suite to ensure accuracy of migration.• Performed all T-SQL data migration programming.• Achieved 100% data migration quality by using data profiling analysis.