Shubham Chaudhary
Chicago, USA
shubhamchaudhary.adm@gmail.com
3127527461
Skills
R
Python
Tableau
MS Excel
SQL
Projects
Statistical analysis(Excel)
Sales Data Transformation(Tableau and SQL)
Profit Analysis(Tableau and SQL)
Sales Dashboard(Tableau and Excel)
Best Loans Returns Prediction(R Studio)
Work Experience
Cognizant Technology Solutions
Programmer Analyst
March 2021 - July 2021
- Improved efficiency by 25% by resolving data discrepancies in MDM caused by updating downstream systems and analyzed missing data attributes in database saving 30% time spent in querying
- Analyzed missing data from downstream systems in the Informatica Master Data Management (MDM) by querying approx 10000+ records loaded in Oracle SQL and determined the root cause of it
- Reported critical issues to senior leadership and performed analysis to help timely intervention to prevent system failures and ensure data safety
Programmer Analyst Trainee
July 2020 - March 2021
- Served as Tableau Site administrator for 20+ Tableau applications and performed analysis on existing 30+ KPIs in dashboard by enhancing their calculations when published on Tableau server
- Developed interactive dashboards from different data sources like Excel and SQL server and developed KPIs indicating customer segmentation, sales by region and forecasting product sales
- Resolved business users’ queries regarding calculations and functions used in dashboards by backtracking fields in SQL server and identifying specific schema, table and column names used
Education
University Of Illinois Chicago
Expected Dec 2022
Master of Science in Business Analytics
SRM Institute of Science and Technology
2016 - 2020
Bachelor of Technology in Electronics and Communication