Michael A

About Michael A

I have 5+ years’ experience as a BI Developer MS SQL server using SSIS, SSRS and Power BI.• Microsoft Certified Professional in Sql Server 2012/2016. • Develop technical design specifications and code specifications to meet business requirements/specifications.• Building, Maintaining SSIS package, Package Configuration, ETL Process, Package deployment. Enabling new packages with companies’ framework.• Extracting data from Excel files, Flat files, OLE DB source, XML Files, Json Files and so on and loading the data into different destinations. Within the data flow, I have utilized various sources, transformations and destination to manage packages.• Imported data from SQL Server DB, Excel File, Flat File, Azure SQL DB…etc to Power BI to generate reports.• Created Dax Queries to generated computed columns in Power BI• Generated computed tables in Power BI by using Dax.• Involved in creating new stored procedures and optimizing existing queries and stored procedures.• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and• Power Map to visualize reports• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps• Used Power BI Gateways to keep the dashboards and reports up to date.• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.• Published reports and dashboards using Power BI.

Experience

1. Power Bi Technology Analyst

   Microsoft

   Sep 2021 — Present · US