Experience

Moneris

• Canada
• Financial Services
• 700 & Above Employee

• Power Bi Developer

  • Mar 2022 - Present

  ● Translate business logic into dashboards, charts, reports, and presentations in support of the Sales & Marketing department. ● Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports. Designing Microsoft Power BI dashboards and managing the power BI gateways with a focus on usability, performance, flexibility, testability, and standardization. ● Designing OTLP, OLAP databases and creating ETL packages, tabular models, and dashboards. ● Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services. ● Using Power BI, and Power Pivot to develop data analysis prototypes, and used Power View a Power Map to visualize reports available in Web clients and mobile apps. ● Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management. ● Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. ● Designed SSAS Cube and developed MDX queries for Analysis. ● Document steps needed to migrate database objects between environments including Development, UAT, Staging and production ● Meet with the business for defined requirements of the project. ● Provide production support of existing ETL process and develop cross-validation rules to ensure mapping accuracy for newly added business rules. ● Develop SQL queries or use available data profiling applications to perform data analysis based on the business requirement and created data profiling reports for data discovery. ● Develop new data integration and support existing datasets for BI teams. Show less



UnitedHealth Group

• Hospitals and Health Care
• 700 & Above Employee

• Power BI

  • Aug 2020 - Feb 2022

  ● Expertise in Data Cleansing using Power Query in Power BI Desktop Editor. ● Worked on all types of transformations that are available in the power bi query editor. ● Wrote DAX expressions to create new measures, and calculations per business requirements. ● Effectively used data blending, filters, actions, and hierarchies feature in Power BI. ● Published the developed dashboard, reports on the Power BI Services so that the end-users can view the data. ● Participated in the configuration of an on-premises Power BI gateway to refresh datasets of Power BI reports and dashboards. ● Hands-on expertise in SQL reporting, development, analytics, or BI. ● Created Tables, Views, SQL joins and defined roles and privileges to implement business rules and control access to database. ● Scheduled Automatic refresh and scheduling refresh in power bi service. ● Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements. ● Wrote complex SQL queries in database Access and created various joins (inner, outer joins) to fetch the desired output for Data Analysis. ● Used various sources to pull data into Power BI such as SQL Server, excel, cloud, SQL Azure, etc. ● Created Power BI Visualizations and Dashboards as per the requirements ● Wrote DAX Expressions, Power Query, Functions in Power BI. ● Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models. ● Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map, kpi etc. in Power BI. ● Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services. ● Strong experience on connecting various Data Sources in Power BI. Show less



Android Industries

• United States
• Motor Vehicle Manufacturing
• 700 & Above Employee

• Business Intelligence Developer

  • Sep 2017 - Jul 2020

  ● Designed, developed, and tested solutions for business user-specified requirements to achieve desired business results. ● Participated in the daily standup with business teams to resolve business issues and Data challenges. ● Hands-on experience in the design, and development of end-user applications for data presentation and analytics, including scorecards, dashboards, reports, monitors, and graphic presentation (Information Visualization &Analysis) using BI. ● Experience using formula languages such as Data Analysis Expressions (DAX). ● Create reports in BI Desktop and Service utilizing the connectors and content pack. ● Expertise in creating reports from importing, Direct Query, and Live data from several data sources. ● Expertise in data transformations such as adding calculated columns, managing relationships, creating different measures, removing rows, replacing values, split columns, Date & Time Column, etc. ● Created different reports in BI Desktop and publish to Power BI online. ● Skilled at querying relational databases (SQL) and the ability to pull data from various sources. ● Imported data from different data sources to create Power BI reports and dashboards. ● Utilized BI (Power View) to create various analytics dashboards that depict critical KPI along with slicers and dicers enabling end-user to make filters. ● Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts, etc. Show less



Floor & Decor

• United States
• Retail
• 700 & Above Employee

• SQL Developer

  • Feb 2015 - Aug 2017

  • Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS). • Created a partition table for a very large database for good performance. • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS. • Utilized SSIS to produce a Data Mapping and Data Mart for reporting worked with Multi-Threading Concepts with Synchronous and Asynchronous transactions. • Designed and developed jobs using Data Stage/Quality Stage 8.x for loading the data into Dimensions and Fact Tables. • Schedule and plan all Data Stage tasks. • Created logging, custom logging and error-handling packages. • Deployed SSIS packages and Reports to Production Servers. • Recovering the databases from Backup in Disasters, and also having Good knowledge on rebuilding s. • Involved in developing Life Cycle using Agile Methodology. • Creating testing processes and documentation in agile environment. • Involved in Data modeling and design of database and schema • Data Warehouse and Data Mart business requirements collecting and auditing. Interview with internal users and document business requirements. • Expertise in writing complex DAX functions. Show less