Shashwat Kumar

Project- John Hancock Retirement plan

Sept'2021- Jan'24

• Created data models and documented data flows to improve system architecture and data quality
• Collaborated with cross-functional teams to identify and resolve data-related issues, resulting in a 95% improvement in data accuracy and lower the failure rate to 5%
• Automated the batch run process to increase the success rate and minimize delay in sending NAV data to business
• Monitored system performance to identify and address potential issues before they impacted customers
• Performed complex SQL queries to extract data from the database.
• Performed development and validation for mappings created for data transformation
• Worked on DB querying for Validating data pre and post batch processing.

• Learned data visualization and reporting tools to perform data analysis
• Learned data warehousing concepts, SQL server, and scripting
• Created dashboards and published reports that can be easily read and utilized by non-technical staff
• Analyzed transcripts of customer service calls to identify and rank customer service issues.