Rupak De Email & Phone Number

Kolkata, West Bengal, India

London, England, United Kingdom

Designed and programmed a data reconciliation process for "Customer Profile Dashboard" which reportsdata trustworthiness metrics like Coverage, Volume, Relative Volume and Data Quality Control. -Streamlined complex ecosystem of multiple source systems including Experian's matched and merged data. -Reconciled duplicate customer profiles with databricks to.

Kolkata, West Bengal, India

• I liaised with business analysts or data scientists to understand theanalytics needs or how the data has been collected at source and convertthem into workable solutions for them.
• Built a solution ingesting Clickstream data for marketing team to createcustomised promotions, few challenges that I overcame
• No availability of standard data dictionary to decode the non-delimitedtext files.
• Duplicate information without a unique primary key.
• Sensitive and personal data made functional tests difficult.
• Mentored and supervised a team of 10+ members team deliveringreliability driven operations on BI & Azure technology.

Kolkata, West Bengal, India

• This part of my career I have worked on cloud modernization projects:
• Led a 10+ member team on reliability driven operations as tech-lead on BI & Azure technology.
• Led a team building a single version cloud (Snowflake) warehouse from different sources of on premises warehouses and DataMart which includes converting complex ETL and procedural transformation into spark sql.
• Led a team working for Datawarehouse modernization, i.e. migration of on premises Datawarehouse to cloud Datawarehouse including required conversion of code and database objects.
• Received On The Spot award for providing a quick solution for a repetitive production bug in BI area in Nov '20.
• Received On The Spot (Team) Award for getting 100% CSI from customer

Greater Grand Rapids, Michigan Area, Boca Raton, Florida

By now I have accomplished ETL integration specialist with more than 8 years of rich and versatile experience of different traditional and cloud-based technologies. Have expertise my skills in retail merchandise domain. Proudly Completed multiple implementations of harmonized data integration solution which can process both RDBMS and unstructured 3rd party.

Kolkata Area, India, Grand Rapids, Michigan

• Designed a custom Business Intelligence (BI) tool that was used as a primary financial and operational management tool for entire company’s reporting (50 + users) that resulted in accurate data usage, graphing, and.
• Achieved 60% reduction in operational incidents, 80% reduction in after-hours callouts, and cross-skilling of Database Administration (DBA) resources.
• Worked on integration of the Statistical Safety Stock project including complete infrastructure redesign and database physical reorganization for all databases.
• Received On The Spot Award for commendable performance as ETL Designer for US based customer.

Pune Area, India

Worked at ETL developer for assessing business rules; performing source to target data mapping; designing, reviewing, implementing optimized Extract, Transform and Load (ETL) processes.

Engineer'S Degree, Pharmaceutical Technology, First Class

High School, Science