Gautam Kandalgaonkar

Teaching assistant for MIS 331 course 'Database Management Systems' under Prof. Rich Yeuh

• Developed SQL Server & SQL/400 queries to extract & perform data profiling using Informatica for recognizing standardization scope • Delivered PoC revenue dashboard with ability to analyze KPI’s & trends in revenue based on different sources, verticals & geography • Built revenue forecasting model by time-series analysis using Holts-Winter exponential and correlated it with stock market predictions • Collaborated with FBSA's to automate ‘monthly-weekly-daily’ report in Infopro using Qlik Server for Operations Staff Management team

Worked with the client to perform the cost-benefit analysis of Industry 4.0 implementation and studied its impact on automation Researched the Industry 4.0 implementation plan adopted by General Motors; RMS is planning to incorporate it in its own design Designed a proof of concept infographic for RMS depicting an automated missile assembly line process as conceived in Industry 4.0 Delivered bi-weekly project status presentations to the client, and a final project analysis presentation to the CIO and VP of RMS 

• Provided techno-functional solutions to business client for a leading P&C Insurance company based in USA • Facilitated 30% reduction of policy output errors by analyzing and enhancing 100+ programs spanned over various change requests • Developed 70+ database scan queries to compile and generate insightful reports used to take critical business decisions • Mined 50+ COBOL programs for business rules to support pre-sales team in project bid which Accenture won for $ 2m • Led the incident remedy team and provided business solutions for over 1200 + incidents under Gold level SLA’s thereby increasing the customer satisfaction index by 14% • Automated daily incident data reporting process and created project incident dashboard to assist management in analytics • Analyzed incident data to identify trends and recommended RCA bug fixes resulting in 25% reduction in remedy tickets • Assisted in translation of client systems IMS-DB tables to Oracle RDBMS using Insurance data migration factory (IDMF) tool • Improved policy creation & update process by developing & modifying UI screens for the client CLA system • Delivered defect free release for a total of 14 / 18 major quarterly business work requests • Played a pivotal role to successfully implement a complex (200 man day project) business functionality by providing key technical analysis • Coordinated with client onshore teams through active collaboration in a virtual team setting to understand business issues and gather technical requirements • Delivered release coordination: Create, update, close, change work requests, prepare and face quarterly audits, monthly release metrics etc. • Supervised a batch of 40 associates for talent pool management helping them improve resource allocation by preparing daily status reports • Conducted 9 training sessions on system functionality & incident remedy process for client team during project handover phase

• Worked on 20+ change management work requests performing System analysis, creating technical design documents and development • Performed root cause analysis for the functional issues faced by debugging program modules in COBOL, showcasing a blend of functional and technical skills • Provided the client business team with documented technical solution for 200+ recurrent issues • Drafted Work request status reports that were presented to Project management and client business team every week • Acquired domain knowledge in COBOL programming language, JCL, CICS & IMS DB • Successfully completed Insurance Foundation Program with 98% to qualify for the project role • Awarded ‘Most Promising Associate’ award for exemplary performance in FY13 Q13