SUMMARY

• Domain experience in multiple industries, including Sales, Finance, Retail, Health Care, and Marketing.
• Strong Knowledge with Normalization and De - normalization on OLTP and OLAP systems, Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, Fact & Dimensions tables, for designing Data Warehouse / Data Marts. Participated in full life cycle of development of a Teradata financial Data Warehouse.
• Strong experience in creating, testing, and maintaining Stored Procedures, Views, Indexes, User Defined Functions, Sub-Queries, CTEs, and other objects.
• Proficient in data Extraction, Transformation, and Loading using query editor, power pivot through Power BI APIs. Built normalized relational data model, created calculated columns, measures using DAX, defined parameters, and variables to design interactive visualization.
• Strong experience in developing Drill Down, Drill Through, Cascading, Parameterized, Linked, and Sub-Reports using Variables, Expressions, and Functions in SSRS. Professional experience in data integration solution (SSIS), and cube creation, and data mining (SSAS).
• Excellent Knowledge of Software Development Life Cycle (SDLC) methods like Waterfall and Agile / Scrum.
• Expertise in Gathering Business Requirements, Conducting QA Testing Performing Data Quality Validation, Debugging, and Processing Documentation.
• Excellent skills in communication & collaboration, Strong analytical skills, problem solving skills and ability to quickly adapt to new technologies by self- learning.

PROFESSIONAL EXPERIENCE

BI Analyst

Confidential

Responsibilities:

• Independently lead dashboard implementation for visual best-practices (color themes, visualization layout, interactivity, drill-through capabilities, filtering, etc.)
• Developed complex dashboards using multiple chart types (Bar/Line/Pie/Gantt, charts, Scatter plots, KPI, Gauge, geographical maps, etc.) and functionalities (filters, parameters, bookmarks, slicers, etc.) in Power BI Desktop.
• Published reports to Power BI Service, and monitoring usage/data refreshes/security access. Managed Apps workspaces. Installed and Configured gateway (Personal/Enterprise) to schedule daily jobs, to refresh reports/dashboards, familiar with implementing Power BI Embedded analytics.
• Developed calculated columns and measures using DAX, expertise in DAX functions such as Sumx, Calculate, All, Value, Filter, Related, Summarized, etc.
• Possess strong knowledge of database management in writing SQL queries using complex joins, grouping, aggregation, subqueries, and resolving key performance issues.
• Accomplished the work includes the development and implementation the full suite of Data Warehouse solution: Data Warehouse and Data Marts, Cubes, Snowflake Schema, and ETL processes.
• Generated a variety of business reports using SSRS, configured report server, and deployed reports on web server and SharePoint. Built reports from Analysis Services cube using MDX query designer; Provided report subscription and snapshot. Conducted Data Quality Testing, Data Validation.
• Rebuilt, expanded, and migrated all legacy reports on the reporting platform. Maintained existing reports. Worked closely with client to determine report’s specifications and coordinated with DBA for performance tuning, QA testing, debugging, data accuracy validation, and optimization.
• Accomplished the work includes the development and implementation the full suite of Data Warehouse solution: Data Warehouse and Data Marts, Cubes, Snowflake Schema, and ETL processes.

Data Analyst

Confidential

Responsibilities:

• Generated a variety of business reports using SSRS, configured report server, and deployed reports on web server and SharePoint. Built reports from Analysis Services cube using MDX query designer; Provided report subscription and snapshot. Conducted Data Quality Testing, Data Validation.
• Rebuilt, expanded, and migrated all legacy reports on the reporting platform. Maintained existing reports. Worked closely with client to determine report’s specifications and coordinated with DBA for performance tuning, QA testing, debugging, data accuracy validation, and optimization.
• Strong SQL programming creates database objects such as tables, indexes, views, constraints, temp tables, stored procedures, and user-defined functions. Write high-quality SQL queries to retrieve and analyze data from database tables, data marts, data warehouse, and Azure Cloud database.
• Hands-on experience in Performance Tuning, Query Optimization using Execution Plan, and SQL Profiler.
• Loaded large volume data from various sources to database tables using bulk insert, BCP command, T-SQL, and SSIS Package. Generated various reports using SSRS, Crystal Reports, Excel, Access, and Power BI to provide efficient solutions.
• Developed project using SSAS, created data source/data source view/cubes with measure and dimensions, configured attributes of dimension table with hierarchy relationships; modified cubes and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions.
• Helped the departments in fetching the desired data between SQL Server database, MySQL, Access database, and Excel, successfully generated daily, weekly, monthly, yearly, and Ad-Hoc reports for different departments.
• Involved in reviewing business requirements and analyzing data sources from Excel/Access/ SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Power BI Desktop.
• Migrated Excel, SSRS, Crystal reports to Power BI.
• Robust MS Access and Excel skills with V-Look up, H-Look up, Macro, Index match, Pivot tables, Power pivot, Pivot Charts.

Reporting Analyst

Confidential

Responsibilities:

• Collaborated with business management and IT teams to define business requirements, drive new insights and actions through data exploration.
• Utilized Power Query to collect into various data sources, used merge, append, filters, parameters, slicers while dealing with large sets of data, Pivot and Un-pivot the data model, Power View (charts, graphs, maps) to design multiple dashboards, scorecards and reports.
• Built reports using SSRS like parameterized reports, Drilldown reports and Drill through report that displays a breakdown of Regional/Segments sales, utilizing data aggregation.
• Developed complex calculated measures/columns using Data Analysis Expression Language.
• Improved the performance of existing SSRS reports. Ran the stored procedure from SSMS and viewed the query, checked and eliminated unnecessary joins, unneeded selected columns etc.
• Published reports on to SharePoint instance and cloud, created Web Parts to show various reports generated from Power BI/SSRS/Excel in one page.
• Designed SSIS package that extract data from data warehouse by using Lookup task, Foreach Loop Container. Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
• Developed projects using SSAS, created tabular model, data source/view/OLAP cubes with measures and dimensions, configured attributes of dimension table with hierarchy relationships, modified cube and dimensions,
• Provided training and customer service to 200 end-users (in person, over the phone and through email), provided security and user roles for all the end users of the various mod