Mike Ebele Email & Phone Number

United States

• Use SSIS tools (Derived Columns, Condition Split, Data Conversion, Aggregations, and Multicasting).• Use SSIS tool to create packages to ETL data to data warehouse databases.• Collaborating with development team in the creating and modification of coding standards for the team to ensure consistency, efficiency, improvement, and accuracy in reporting and data analysis.• Use SQL SSRS to create parameters reports, list, cascading, table, drill through, drilldown reports… Show more • Use SSIS tools (Derived Columns, Condition Split, Data Conversion, Aggregations, and Multicasting).• Use SSIS tool to create packages to ETL data to data warehouse databases.• Collaborating with development team in the creating and modification of coding standards for the team to ensure consistency, efficiency, improvement, and accuracy in reporting and data analysis.• Use SQL SSRS to create parameters reports, list, cascading, table, drill through, drilldown reports etc.• Involved in creation and maintenance of SSAS cubes, perspectives, aggregations, and named sets for reporting.• Creating data visualization solution and report dashboard using Power BI.• Perform tuning of Queries and Stored Procedures as well as ETL packages.• Involved in creating new stored procedures and optimizing existing queries and stored procedures.• Use Power BI, Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.• Publishing of Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.• Creation and development of dashboards, tabular, matrix, reports, charts, Graphs, Drill through, Drill down, parameter reports using Power BI.• Gathering and analyzing business requirements, creating process flow charts, database flow charts and reporting tools for different reports.• Design, develop, and implement test plans, user documentation and complete projects on schedule.• Develop analysis reports and visualization using DAX functions like table function, aggregation function and iteration functions. Show less