Motivated and results-driven 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.
Have excellent skills in Data Warehouse, Relational and Multi-Dimensional databases, Data Migration, System & Data Integration, Reporting, Analysis and Software Development and Data Management.
Experienced in developing, implementing, documenting, monitoring and maintain the data warehouse extracts, transformations and ETL process in various industries like Financial, Health Care, Retail etc.
Extensive professional experience in design, development, implementation and support of mission-critical Business Intelligence (BI) applications.
Experience across entire Microsoft BI suite of products including SQL Server, SSIS,SSAS, SSRS and Power BI SDLC from prototyping to deployment.
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.
Worked on small and large scale projects. Believe in team work. Have delivered as a team member, team lead and as independent consultant.
Excellent communication and leadership skills.
Tools: MS SQL Server Integration Services (SSIS), Analysis Services (SSAS)
Development Skills: T-SQL, DAX, MDX, C#
BI Reporting Tools: Power BI, Reporting Services (SSRS), Tableau and MicroStrategy
Data Quality and Standards
Lead Power BI Data Analyst / SQL Developer, 11/2016 to Current Pricewaterhouse Coopers LLP (End Client: United Airlines) – Chicago, IL
Led the design and development of reporting data module for a sales integration portal built for Agency and Corporate customers of United Airlines.
Gathered and documented business requirements for analytical reports. 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 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 Reports.
Sr. SQL BI Data Warehouse Developer, 09/2015 to 10/2016 State of Washington – Olympia, Washington, United States
This project was primarily a development of Data Mart for budget and health services department along with analysis of existing data warehouse for performance improvements.
Participated in requirements meetings and data mapping sessions to understand business needs. Documented requirements in Business Requirement Documents (BRD)
Designed and developed schema data models.
Updated and maintained logical and physical model using ERwin Modeler.
Worked on all phases of data warehouse development life cycle, from gathering requirements, implementation, testing, training and support.
Interviewed Business Users of the DWH and Business Analysts to understand and troubleshoot the existing bottlenecks and problem areas.
Developed automated data dictionary for Enterprise Data Warehouse using SSRS and SQL.
Designed and developed ETL SSIS 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 500ms.
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 cube.
Migrated existing self service reports and adhoc reports to Power BI.
Developed custom calculated measures using DAX in Power BI to satisfy business needs.
Used Team Foundation Server (TFS) for source control and sprint planning.
Development Engineer, 05/2010 to 09/2015 Duke University Medical Center – Durham, North Carolina, United States
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.
Conducted interviews with key business users to collect information on business processes and user requirements. Documented business processes and analyzed procedures to see that they would meet changing business 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. Developed interactive Super Bill report in SSRS to support transition from ICD-9 to ICD-10
Designed and developed a full-scale BI reporting solution using SSRS.
SSIS packages using best practices from scratch to perform ETL process and
load the data into destination table.
Performed Extraction & Migration of Data (ETL) from heterogeneous data sources using SSIS.
Created and managed schema objects such as tables, views,
cursors, indexes, stored procedures.
in working with Star Schema and Snow Flake Schema to develop MOLAP
Cubes using MS SQL Server Analysis Services (SSAS).
T-SQL Developer, 07/2006 to 07/2007 Anuva Technologies – Pune, Maharashtra, India
Performed normalization of database to reduce redundancy and achieve maximum system performance.
in creating database objects using stored procedures, Triggers, Functions,
Views and T-SQL Joins using T-SQL.
query analyzer to optimize query performance.
analyzed business needs to translate the needs into deliverables.
Bachelor of Science: 2006 University of Pune - Pune, Maharashtra, India
Master of Science: 2010 Old Dominion University - Norfolk, VA