8+ years of experience as a BI developer with a proven track record in Business Intelligence (BI), Data
Warehouse (DWH) and Data Analytics related consulting projects.
Proven ability to identify business
needs and develop valuable solutions to drive accuracy and process efficiency.
Experienced in developing, implementing, documenting, monitoring and maintaining the data warehouse
extracts, transformations and ETL process in various industries like Financial, Health Care, Government and Airline Industry.
Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.
Experience with all phases of software development life cycle (SDLC) and Agile methodologies.
Have delivered as a team member, team
lead and as an independent consultant on medium to large scale projects.
Tools: MS SQL Server Integration (SSIS), Analysis Services (SSAS)
Development Skills: T-SQL, DAX, MDX, C#
BI Reporting Tools: Power BI, Reporting Services Services (SSRS), Tableau and MicroStrategy
Data Quality and Standards
Lead Power BI Data Analyst / SQL Developer12/2016 to CurrentPricewaterhouseCoopers United AirlinesChicago, IL
Led the development of reporting solution suite containing 16 Power BI Reports for United Airline's Corporate and Agency customers using Microsoft's latest in memory database technology.
Participated in requirements
meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
Developed at least two - three visual options for each report for discussion with United stakeholders
(product owners and leadership) and customers.
Integrated Custom Visuals based on business requirements using Power BI desktop.
Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary
table to support Power BI and SSRS reports.
Developed complex calculated measures using Data Analysis Expression language (DAX).
Embedded Power BI reports on the Salesforce portal page and also managed access of reports and data for
individual users using Roles.
Worked with Microsoft team on product limitations and communicate limitations and tool capabilities to
the United IT and business stakeholders.
Provided continued maintenance and development of bug fixes for the existing and new Power BI
Sr. SQL BI Data Warehouse Developer10/2015 to 11/2016State of WashingtonOlympia, United States, Washington
Led the development of Data Mart for budget and health services department along with analysis of existing data warehouse for performance improvements.
Worked on all phases of data warehouse development life cycle, from gathering requirements,
implementation, testing, training and support.
Interviewed Business Users of the Data Warehouse and the Business Analysts to understand and troubleshoot the
existing bottlenecks and problem areas.
Developed automated data dictionary for Enterprise Data Warehouse using SSRS and SQL.
Completed a thorough analysis of the issues with the cube processing and query processing to identify
bottleneck for the existing facts and dimensions.
Designed and developed ETL packages to facilitate incremental load process.
Created aggregates, partitions, attribute relationships and user defined hierarchies with the goal to reduce
the cube processing time from over 2 hours to under 60 minutes and query processing time to less than
Created stored procedures and performed index analysis for slow performing SSRS reports to bring down
the report rendering time from 15 mins to 30 seconds.
Developed Enterprise wide cascading reports in SSRS that were used throughout the agency to monitor
the performance of the cube, logging of the nightly ETL loads and also to monitor most active users of the
Migrated existing self-service reports and adhoc reports to Power BI.
Developed custom calculated measures using DAX in Power BI to satisfy business needs.
Development Engineer06/2010 to 10/2015Duke University Medical CenterDurham, United States, North Carolina
Worked on ambitious project to develop an Enterprise Wide Health Record system data warehouse
connecting 4 Hospitals and 300+ ambulatory clinics.
Worked with Business Intelligence Manager to plan BI strategies, create BI road map and budget plans to
deliver on organizations Business Intelligence needs.
Assessed the impact of current business processes on users and stakeholders.
Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business
requirements using SSRS to support executive business needs.
Created SSIS packages for loading data from disparate sources using best practices from scratch to perform ETL process and load the data warehouse.
Implemented Query Optimization and performance tuning for slow performing SQL queries.
Involved in writing complex T-SQL queries and stored procedures to perform data transformations and to
support SSRS Reports.
Supported maintenance of Data Quality Service's (DQS) knowledge base and development of Master
Data Service's database.
T-SQL Developer08/2006 to 08/2007Anuva Technologies - Pune
Created tables and define their relations by using foreign key and primary key relationship.
Involved in creating database objects using stored procedures, Triggers, Functions, Views and T-SQL
Joins using T-SQL.
Performed normalization of database to reduce redundancy and achieve maximum system performance.
Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential
integrity, and provide additional application functionality.
Education and Training
Bachelor of Science2006University of PunePune, Maharashtra, India