Profileimage by Rabi Debnath Expert &Senior Developer in SQL Server & End to End Enterprise BI Analytical Solution Implementation from Mumbai

Rabi Debnath

available

Last update: 01.11.2023

Expert &Senior Developer in SQL Server & End to End Enterprise BI Analytical Solution Implementation

Company: Freelancer
Graduation: Bachelors Degree in Computer Science and Engineering
Hourly-/Daily rates: show
Languages: English (Native or Bilingual)

Attachments

Rabindra-Debnaths-BIAIDW-Expert-PrincipalConsultant-CV_011123.pdf

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.

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.
Profileimage by Rabi Debnath Expert &Senior Developer in SQL Server & End to End Enterprise BI Analytical Solution Implementation from Mumbai Expert &Senior Developer in SQL Server & End to End Enterprise BI Analytical Solution Implementation
Register