Keywords
Data Modeling
DocumentDb
Data Lake
SQL Business Analytics
SQL performance tuning
SQL Data mining
Custom reporting
SQL Troubleshooting
Data Science and Analysis
MS Cortana Intelligence Suite 2016
Data Catalog
SSAS / SSRS Reports
SQL Azure
SQL
SSIS
Hadoop
Enterprise Data Warehousing
Application
MDX
DAX
Design
power bi
Database
Pivot Services and custom developments
azure data factory
Python
SQL Server 2019
SQL Server 2017
Microsoft SQL Server SSRS
Data migration
PowerApps Power Automate and Power BI
Skills
Strong hands on and consulting skills of several years in Design, Development and Implementing end to end practical enterprise SQL database business application and analytical solutions. Expert in implementing DW, BI, SSAS, SSIS, SSRS, Data Mining, Power BI, SQL Server database, supporing SQL 2016, 2014, 2012, 2018/R2, 2019, SQL Azure Suites, ADF, Power BI, Power App connects, Cortaina Intelligence Suites and in their respective previous versions.
Successfully developed all stages of sustainable architecture and specialist in custom solution in transformation of data to relate the governing business rules supporting single version of truth at all stages. Expert in performance tuning, optimization, troubleshooting and implementing best practices using SQL Server technology and its services. Expert in mission critical CXO MIS having global footprints.
Several years of working remote as Virtual lead developer and consultant for top global corporation and IT majors.
Successfully developed all stages of sustainable architecture and specialist in custom solution in transformation of data to relate the governing business rules supporting single version of truth at all stages. Expert in performance tuning, optimization, troubleshooting and implementing best practices using SQL Server technology and its services. Expert in mission critical CXO MIS having global footprints.
Several years of working remote as Virtual lead developer and consultant for top global corporation and IT majors.
Project history
Ford Financials - ASR Project
Society General - Trading Analytics on all instrument and hierarchies
Ashland Products: Enterprise Marketing Campaign - TSR - Revenue forcasting analytical
MakeMyTrip: - Performance Tuning, Troubleshooting and optimization of financial application.
Infosys: Consulted in improving performance and tuning their key financial application from 2.5 hrs to 13 sec
Unilever Asia: Architected and provided solution for 10+TB enterprise DW-Analytical project for sales -marketing - production activities.
Product Launch: Helped client team performance tune their product launch application to scale from 5000 concurrent users to 300K concurrent users in short notice.
Global Online Event Platform: End to end DW and Analytical solution for global event and user participation project
Global Online Learn Platform: End to end DW and Analytical solution for global education and training corporation
Global Online Social Platform: End to end DW and Analytical solution for global social media and its user activities
Analytical Tool Development: Developed few custom analytical tools for top global customers using Microsoft SQL Server technology and Hyperion (nowOracle - Analytical suites)
Local Availability
Only available for remote work
Available for remote 10 hrs a day at any timezone.
Other
[Healthcare ]: Designed, provided roadmap, and solution architecture for next generation global healthcare solution using latest MS SQL Azure and its latest BI suite with various data component for large data processings. SQL Server2014,MS Azure, MS BI Suite
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Troubleshooted and optimized client application to scale minimum of 75K concurrent users tuned for a global launch of major software maker in 7 days, where client system was failing to support 5000 concurrent users. Actual launch on AWS EC2 support 300K concurrent users and with minimal lag. Client application was in SQL Server 2008R2
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Migrated Data from SQL 2008 R2 to SQL 2014 and Designed, developed and implemented a new Analytical solution with 120 parameter based global social media division of learn27.
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Migrated Data from SQL 2008 to SQL 2012 and Designed, developed and implemented a new Analytical solution with 80 parameter based global Event launch division of event27.
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Designed, developed and implemented using SQL 2008 R2 a new Analytical solution with 50 parameter based global social media division of Social27.
SME/ SQL BI Sr. Consultant
[Global Largest Product Manufacturer] : Won compete and Provided solution architecture and product based end to end enterprise marketing sales solution for major product manufacturer in ASIA AMET. Data warehouse design would manage upt 40 TB of data.
SME/ SQL BI Sr. Consultant
[Major Global IT Vendor]: Troubleshooted, Redesigned, Performance tuned and optimized enterprise BI analytical financial solution for global major IT Vendor and its client ABB
SME/ SQL BI Sr. Consultant
[Major Global IT Vendor]:Troubleshooted, Redesigned, Performance tuned and optimized enterprise BI analytical financial solution for global major IT Vendor and its client World Bank
Role: SME/ SQL BI Sr. Consultant
[Travel and Leisure Company]: Redesigned, Performance tuned and optimized enterprise analytical financial solution for Travel and Leisure vendor-MakeMyTrip.com
SME/ SQL BI Sr. Consultant
[Top Global IT Consulting Vendor]: Redesigned, Performance tuned and optimized enterprise analytical financial solution for global major IT provider
SME/ SQL BI Sr. Consultant
Designed, Developed and implemented end to end DW-BI-Reporting Solution for a Large hospital group/provider based care analytical solutions. Bed capacity exceeding 8K, care was based on CPT/ICD/HIPPA/HL7 and other standards
Role:Principal Consultant
Developed and Delivered Financial reports based on Division - Department - BusinessUnit- and other segmentation of global Auto maker
Role: Consultant
Designed, Developed and Implemented Analytical enterprise forecasting and sales reporting system for global speciality product manufacturer having presence in over 90 countries. Reports presented long time return pespective on TSR (test sample results- to campaigns - events-product-actual sales and mapping to expected revenue in 20+ years)
Role: Consultant
There are more interesting BI/DW/Analytical Reporting projects in total of 14 domains and industries.
Please feel free to contact.
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Troubleshooted and optimized client application to scale minimum of 75K concurrent users tuned for a global launch of major software maker in 7 days, where client system was failing to support 5000 concurrent users. Actual launch on AWS EC2 support 300K concurrent users and with minimal lag. Client application was in SQL Server 2008R2
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Migrated Data from SQL 2008 R2 to SQL 2014 and Designed, developed and implemented a new Analytical solution with 120 parameter based global social media division of learn27.
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Migrated Data from SQL 2008 to SQL 2012 and Designed, developed and implemented a new Analytical solution with 80 parameter based global Event launch division of event27.
SME/ SQL BI Sr. Consultant
[Global Virtual Social/Event Corporation]: Designed, developed and implemented using SQL 2008 R2 a new Analytical solution with 50 parameter based global social media division of Social27.
SME/ SQL BI Sr. Consultant
[Global Largest Product Manufacturer] : Won compete and Provided solution architecture and product based end to end enterprise marketing sales solution for major product manufacturer in ASIA AMET. Data warehouse design would manage upt 40 TB of data.
SME/ SQL BI Sr. Consultant
[Major Global IT Vendor]: Troubleshooted, Redesigned, Performance tuned and optimized enterprise BI analytical financial solution for global major IT Vendor and its client ABB
SME/ SQL BI Sr. Consultant
[Major Global IT Vendor]:Troubleshooted, Redesigned, Performance tuned and optimized enterprise BI analytical financial solution for global major IT Vendor and its client World Bank
Role: SME/ SQL BI Sr. Consultant
[Travel and Leisure Company]: Redesigned, Performance tuned and optimized enterprise analytical financial solution for Travel and Leisure vendor-MakeMyTrip.com
SME/ SQL BI Sr. Consultant
[Top Global IT Consulting Vendor]: Redesigned, Performance tuned and optimized enterprise analytical financial solution for global major IT provider
SME/ SQL BI Sr. Consultant
Designed, Developed and implemented end to end DW-BI-Reporting Solution for a Large hospital group/provider based care analytical solutions. Bed capacity exceeding 8K, care was based on CPT/ICD/HIPPA/HL7 and other standards
Role:Principal Consultant
Developed and Delivered Financial reports based on Division - Department - BusinessUnit- and other segmentation of global Auto maker
Role: Consultant
Designed, Developed and Implemented Analytical enterprise forecasting and sales reporting system for global speciality product manufacturer having presence in over 90 countries. Reports presented long time return pespective on TSR (test sample results- to campaigns - events-product-actual sales and mapping to expected revenue in 20+ years)
Role: Consultant
There are more interesting BI/DW/Analytical Reporting projects in total of 14 domains and industries.
Please feel free to contact.