SUMMARY

• Experienced Consultant specializing in modern cloud and on prem enterprise data warehousing and business intelligence for the Industrial and Healthcare domains, serving Fortune 500 clients for over 14 years.
• In - depth knowledge and practice of Data Vault and Data Warehouse concepts, dimensional modeling, enterprise data warehouse and data marts with slowly changing and conformed dimensions.
• In-depth knowledge and experience in Azure Cloud and SQL Server On prem Data Warehousing, ETL pipelines, OLAP Cubes, BI Reports, and Dashboards (Microsoft BI Stack).
• Proficient in SQL, PL/SQL, and T-SQL for query optimization and scripting.
• Expertise in implementing complex ETL systems and Data Warehouses using Azure Synapse, Analysis Services, Data Factory, SQL Server SSIS and SSAS.
• Specialized in creating Enterprise BI Reports and Dashboards with Power BI, SSRS, and JET Reports.
• Certified in Azure Data Solutions and Microsoft SQL BI Stack.
• Worked with Netezza and DB2 databases for data analysis and extraction.
• Skilled in SQL Server administration and monitoring of ETL loads.
• Led BI projects across various business domains.
• Conducted in-house training on Power BI, Azure, and SQL Server SSIS.
• Extensive knowledge of Data Warehouse tools like Snowflake, TimeXtender, Kalido BIM, DIW.
• Strong analysis, documentation, and communication skills.
• Proficient in programming and scripting (PowerShell, Python, C#, PHP).
• Proven problem solver and quick learner.

TECHNICAL SKILLS

Microsoft Specific: Power BI, Azure Analysis Services, Azure Data factory, Azure Synapse, SQL Server, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services 2008 R2/2012/2014, Power Pivot, Power View, T-SQL, DAX, MDX, Sql Server Agent, and Microsoft SQL Profiler for optimization debugging.

Other: TimeXtender, ThoughtSpot, JET Enterprise Reports, SiSense, Dimensional Modeling and Design, Data Modeling, Tealium, Adobe Analytics, Kalido DIW & BIM, IBM, Netezza Distributed Database, IBM DB2, Oracle 10g and PLSQL, MS Office.

PROFESSIONAL EXPERIENCE

Confidential, Tennessee

BI Consultant - Data and Analytics

Responsibilities:

• Created a reusable Enterprise Scorecard Dashboard using dimensional modeling, enhancing the development speed of Power BI Dashboards.
• The dashboard provides a centralized one-page Scorecard Summary and a detailed Reports view, showcasing over 50 Scorecards and 100+ KPIs for Ambulatory Quality area.
• Introduced Power BI in the organization. Built Power BI infrastructure, for Data Analytics team that include UI template
• Theme, certified reusable shared datasets and dataflows, distribution Azure security groups and development lifecycle process with best practices.
• Successfully migrated multiple reports and dashboards from Tableau and Webi to Power BI, including Respiratory Disease Hospital Utilization, Resource Management, and others.
• Wrote complex SQL scripts to ingest data from Caboodle and Clarity into Azure and Power BI.
• Conducted Power BI training sessions for IT and Business Teams.

Confidential, Brookfield, Wisconsin

Lead Data Consultant

Responsibilities:

• Received Culture Coin "Award" for driving business impact through agile Data and BI solutions.
• Led Data Engineering Team for building and maintaining a centralized Azure Cloud and On Prem (SQL Server and TimeXtender) Data Warehouse Solutions for ERPs and systems including Dynamics AX, NetSuite. Tealium, APIs, internal databases and flat files.
• Utilized the Azure Apache Spark framework to build a Modern Lake warehouse for data modeling and development on AX Dynamics and Oracle ERPs. Developed ETL pipelines, implemented Data Vault methodology, and created Data Warehouse (DWH) objects for efficient data management and analysis.
• Created Azure Cloud Data Warehouse with Data Factory Pipelines for Power BI Admin Tenant. Integrated Power BI Audit JSON APIs into Data Factory for seamless monitoring and management of Power BI users and capacity to help Governance team.
• Developed Azure Data Factory ETL Pipelines for moving and transforming data from various sources into Azure Data Lakes and Azure SQL Database Staging.
• Created ETLs and Data Warehouse using TimeXtender for complex business problems.
• Led end-to-end delivery of Dimensional Data Modeling in ThoughtSpot Cloud, including gathering requirements, building Data Model, and delivering Reports and Dashboards.
• Collaborated with Business Team to gather BI Reports requirements for multiple domains.
• Designed and developed Data Warehouse for Sales, Services, and Warranty Reports.
• Design and developed over 50 Power BI Reports and Dashboards for Service, Sales and Inventory.
• Integrated online data sources into Power BI Reports using SSIS ETL System and Azure Cloud Data Factory Pipelines.
• Conducted training sessions to educate Business Users on the use of ThoughtSpot and Power BI.
• Wrote complex SQL Scripts and DAX expressions for reporting needs.
• Designed and developed Tabular Models for Sales, Finance, Inventory, and Services using SQL Server Analysis Services.

Confidential, Boca Raton, Florida

Solution Architect - Azure and Power BI

Responsibilities:

• Built and trained a team of Data Engineers and BI developers onsite and offshore for JCI Service Area.
• Designed complicated Star and Snowflake Data Model for JCI Global Service to cover 100+ KPIs across globe (North America, Europe and Asia) with several different product domains.
• Lead the onsite and offshore Data and BI teams to develop
• Data Models in the Azure Analysis Services Tabular Model.
• Global Service Power BI Dashboards and Reports.
• Data Warehouse in Azure Data Lake, Azure HDInsights and Synapse Analytics
• Performed weekly Code reviews to ensure maximum reusability and performance
• Implemented critical solutions in Azure DWH, Analysis Services, Power BI and DAX whenever required my expertise.
• Introduced and implemented some out of the box solutions to overcome challenges. Some highlights include
• Azure Analysis Services Cube to Cube Integration to reuse one of their existing data model with our Service Data Model.
• Created Power Apps solutions to take Manual Inputs (Comments and Feedback) from business experts on monthly
• KPIs outcomes and integrated those feedback in the Azure Data Model and Power BI Dashboards.
• Power Automation to schedule Power BI Pagination Reports PDF delivery on emails.

Confidential, St. Louis, Missouri

Solution Architect - Data and Analytics

Responsibilities:

• Designed Dimensional Models for Encounter, Utilization, and Sales domains. Assisted the Data team in implementing tables and ETL pipelines in Azure Synapse Analytics.
• Designed and implemented Azure Analysis Services Tabular Model Cube using Dimensional Data Models with Star Schema for Finance.
• Designed and implemented Composite Data Models and Authorized and Certified Shared Datasets in Power BI for IT and Business team consumption to ensure reusability and maximum performance.
• Introduced the Power BI in the organization. Built Power BI infrastructure, Power BI development lifecycle, approval processes and best practice.
• Created a Distribution Framework for BJC Power Solutions (Power BI primarily, Power Apps and Power Automation) to enable them sharing Power Solutions with IT and Business across the organization. This Framework became the base to:
• Define and reduce Azure Active Directory Groups
• Efficiently managing cost to buy Power BI Pro and other development licenses
• Encouraging office 365 Free Licenses for business users
• Ensure maximum data security with the help of Row Level Security.
• Design and developed Data Dimensional Models on Azure Synapse and build Power BI Dashboards that overcome the limitation of their previously adopted BI tools. Some highlights are
• Profitability Explorer Dashboard and Reports
• Encounter Audit Tool Dashboard.
• Conducted Power BI and Azure Data Engineering weekly training sessions for BJC Data and Analytics and business team.

Confidential, Winston-Salem, North Carolina

Senior Data Analyst

Responsibilities:

• Worked with the Health Department, HR Department and Data Analytics and Information Management team to gather requirements for three different areas to build COVID-19 Dashboards.
• Proposed and built Power BI Dashboards Designs and Templates.
• Proposed all the metrics, visuals and insights to be covered in COVID-19 Dashboards for three different areas: Public, Students and HR Employee COVID-19 Dashboards.
• Designed and developed COVID-19 Student Dashboard using Power BI and MySQL and SQL Server Database.
• Designed and developed COVID-19 HR Employee Dashboard using Power BI and MySQL and SQL Server Database.
• Designed and developed COVID-19 Dashboard available for Public using Power BI and MySQL and SQL Server Database.
• Integrated this Dashboard in Confidential Official Website using Power BI published embedded code and link.
• Created SQL Views in MySQL to encapsulate SQL Codes to extract required datasets for Power BI Dashboards.
• Wrote PowerShell Script code using Power BI API to trigger Power BI Reports
• Datasets outside Power BI UI and integrated it with Wake Forest Data ETL Jobs system to create dependency as ETL job for this Power BI Refresh to trigger.

Confidential, Madison, Wisconsin

Senior Data Engineer

Responsibilities:

• Created BI Dashboards and reports for Drugs Compounding, hospitals sites Infection Preventions documented data and Comparison Matrices in Power BI and SiSense.
• Used various graphical visuals in Power BI like Bubble charts, Stacked bar charts, Pie charts, Shape map to compare Infections Ratios
• Group hospital sites performance by locations of the parent institutes.
• Developed Power BI Paginated Reports for various sites (hospitals).
• Setup email delivery with excel and pdf format attachments for multiple sites using Power BI subscriptions with current custom parameters values for each site location.
• Created Datasets for Power BI Model using sql scripts and Data Mart reporting tables.
• Created DAX Measures for time pattern calculations and calculated columns in Power BI.
• Created SSIS Packages to gather data from clients/hospitals’ databases and generated Excel Reports for all hospitals sites for daily, weekly and monthly reports Delivery.
• These reports execute for more than 300 client sites (Hospital) in a single batch run.
• The connection string and variables were dynamically setup in the SSIS Foreach loop transformation to extract data per hospital and generate and send report per client (hospital).

Confidential, Baltimore, MD

Senior BI/Data Analyst

Responsibilities:

• Worked with business team to gather requirements of SSAS Tabular Model and BI Reports for Sales, Reordering and Inventory.
• Designed a star schema dimensional model for SSAS Sales Tabular Model.
• Integrated SAP HANA database with SSAS Tabular model, created dimensions, Facts and derived tables in the Sales tabular model.
• Applied DAX in Sales Tabular cube to add calculated measures for reorders, distribution, PODS, Accounts Sold and their time pattern calculations - (MTD, YTD, QTD, LYQTD, LYTD, LYMTD and Rolling12Months etc.). This Tabular model was being used by business users in Excel Pivot table for Ad-hoc reporting and Power BI Reports.
• Created Power BI summary reports for reordered products, inventory and sales.
• Implemented Slicers by locations and date filters. Created Maps and visualizations to categorize Sales by store locations in the States/ Cities.
• Created Power BI DAX calculated measures and calculated columns to implement 9LCases, Reorders, Sales, PODS, Accounts Sold Calculations and their relative dates calculations.
• Optimized complicated DAX Measures like PODS and its relative time pattern calculations to execute less than 20 seconds for 20m records from 15 mins execution time.
• All these commitments were successfully delivered in a very tight deadline.

Confidential

Senior Data Engineer

Responsibilities:

• Interact with business users and analysts to understand requirements.
• Designed and developed databases and data warehouse structures utilizing Client Digital Experience and Insurance (Life Insurance, Annuity, Long Term Care and Disability) Data.
• Developed stored procedures, views and ETL Scripts in SQL Server, IBM DB2, IBM Netezza, Sybase and MySQL Databases to pull data from source systems and apply business logics before processing and load data into Enterprise Analytics and Reporting Databases and Data Warehouse.
• Used SQL Server Integration Services to perform ETL tasks.
• Created C# Scripts in SSIS Script Component to get data from third parties data sources e.g. Amazon S3 Buckets.
• Designed and developed BI Reports and Dashboards to provide Insights Services of Client Experience Journey and Sales utilizing Microsoft Power BI and SQL Server Reporting Services.
• Used SQL Server Analysis Services to create Tabular Models and Cubes, which will be further utilized to develop reports and dashboards in Microsoft Power BI and SQL Server Reporting Services.
• Wrote DAX and MDX queries to create Calculated Measures and Calculated fields in SSAS Tabular Models, Cubes and Power BI Reports and Dashboards.
• Worked in Microsoft Azure environment.
• Performed optimization and performance tuning of databases.
• Designed and implemented standards, loggings and automations for Data Warehouse, databases and ETL Processes.
• Used Adobe Analytics Tool to pull and analyze data for Clients Digital Experience on Confidential website and mobile app.
• Perform code deployment activities and fix post-deployment production issues.

Confidential, Louisville, Kentucky

Technical Team Lead

Responsibilities:

• Leading Data Mart and BI Reporting team
• Design and Implementing real-time data Mart that synchronizes data on every minute frequency
• Designed and developed parameterized and non-parameterized reports in SSRS. The reports consist of tables, charts and KPIs
• Integrated Healthcare PDH application with data mart using SSIS ETL
• The ETL accounts for all business required components including Plans, packages, sub packages and their associations
• Created multiple stored procedures for ETL including delta procedure that retrieve incremental data every minute
• Implemented logging exception handling and retry logic using SSIS and Oracle PLSQL
• Used PLSQL Merge statements for inserting updating data in to data mart dimensions and facts
• Used Oracle Attunity to improve the performance of SSIS data source destination
• Used variable expression in SSIS to implement dynamic SQL queries

Confidential, Cranbury, NJ

BI Consultant

Responsibilities:

• Created data marts for Customer Sales and Inventory Availability and designed ETL in SSIS to populate them
• Developed a tabular model for Sales module in SSAS with DAX expression for complex calculations.
• This model was specifically used by business analyst and higher management to design and develop Ad hoc reports
• Designed and develop complex SSRS Reports for Inventory and Shipping modules using multiple datasets, multiple filters, multiple data regions, and multiple sub-reports
• Designed and developed views, functions and stored procedures to implement back end business logic
• Integrated SSRS Reports with Microsoft Dynamics AX 2012 using Dynamics AX Model projects
• Set up automated report delivery through emails based on subscriptions and shared schedules; reports were designed and developed for PDF and Excel formats
• Did SSRS reports data validation on MS Excel 2012 using excel Lookup function and formulae
• Fixed bugs and issues related to reporting for staging and production environments
• Provided deployment checklist and deployment guide to the configuration manager for deployments to staging and production environments
• Implemented query optimization and improved performance on slow running queries
• Used JIRA Tool for bugs and issues tracking.

Confidential, Stamford, CT

Technical Consultant BI & DWH

Responsibilities:

• Daily EDW Load monitoring, troubleshooting and fixing of EDW reporting and production servers over 2 years.
• The DWH was built in Kalido DIW and ETL was done in SSIS
• Modifications in existing Data Warehouse and ETL systems SCBMS (Supplier Customer Broker Management System) and MDM.
• Created ETL packages in SSIS and DWH Dimensions and Facts using Kalido DIW
• Designed and developed an ETL System of the newly added module Financial Data Mart J.D. Edwards into existing Data Warehouse Model.
• Created ETL Packages in SSIS to extract data from Mart J.D. Edwards source (IBM DB2 Database) to the landing/staging tables in SQL Server.
• Then made loads (batch files of Kalido DIW) and executed those using SSIS packages to populate the Data Warehouse
• Used SSIS Web Service task in combination with XML task to pull product information from web service
• Developed a report on SSRS that shows EDW Daily Load Summary. The report included tabular and graphical charts.
• Reporting server scheduler used to send the report to the EDW team over email
• Designed and developed a dashboard for EDW Load Summary using SSRS.
• The dashboard used to see the daily load and/or history load details
• Optimized some ETL scripts and stored procedures to reduce the execution time of the load
• Created a tabular model for Financial Datamart to be used for Ad-hoc reporting at high management level
• Used Team Foundation Server (TFS) for Bug Tracking and Deployment.