Shubham Raj Email & Phone Number

Pune, Mh, In

Pune, Mh, In

Pune, Maharashtra, India

Provided AWS cloud solution for migration of project Census Area Projections Estimate - Experian on SAS.Designed and improved the existing architecture of SAS on AWS, encompassing its components, Build pipelines utilising layered architecture.Developed equivalent PySpark code on Glue, parallel execution of non inter dependent modules, performed EDA, addressed and resolved DQ issues.Enhanced existing system yielding more accurate reporting data, tunned modules with spark optimisations leading to 90% improvement in TAT.Worked on ad-hoc tasks and assisted team members on writing the code and optimising it, appreciated by client for code enhancement and bringing up better data quality.

Pune, Maharashtra, India

Worked for the client CITI Bank to migrate data from Compliance Data Warehouse to Enterprise Analytics Platform as Business Analyst and Data Engineer.Prepared Data Models and mapping spreadsheets, build pipelines for AML, improvised existing system logic leading to billions of quality data points.EDA using Hive Query Language and Excel on reference data(Bank Customers), developed PySpark code and did necessary fixes, automated task of data reconciliation.Generated informative reports yielding value additions to stakeholders, addressed ad-hoc requests, appreciated for proficiency in data analysis.

Mumbai, Maharashtra, India

Worked on building Data Models for The International Bank of Reconstruction and Development on non-performing loans.Data wrangling, ETL, efficient data storage & querying, experimented treating batch data as stream data, analysed and bring up insights on aggregated data.Collaborated with team members and received appreciation for remarkable project solution.