Raghav Gupta

• Stakeholder Management: Anchoring weekly conference calls and Live meets with all concerned Stakeholders and Management for discussions around business achievements, targets, strategizing to increase sales and status updates. Responsible for Quarterly sales report, Forecast Vs Actuals Variance analysis report and Monthly Financial Forecast. • Leading the Data Analytics and Data Innovation teams to gather and understand requirements from business stakeholders and vendors and then to perform data sourcing and data engineering to provide relevant data solutions.Built predictive classification models for Indo Crop Solutions to detect the distributers working on credit payment are likely to default based on the historic pattern, using NLT models on the web server logs to check the warning/error messages and assigned them to the correct team. • Integrated accounting software using ETL's with the web server to enable free flow of sales data and making it easily accessible on mobile phone for sales employees working in rural areas. • Designed and implemented multiple dashboards on Power BI to gauge the effectiveness of deliverables. Formulated strategies to improve sales by 30 to 40%. • Conceptualized, designed, developed and maintaining the IT system for the entire organization from scratch. Functionality of Sales Management, Customer Management, Inventory Management, Raw material management, Costing analysis, Staff reporting system, Staff expense management and various admin and control panels were included. • Assisted HR head in drafting the Contracts with various clauses. • Further, the functionality of Claims, TA, DA and timesheets incorporated in another IT system.

Job Title: Team Lead (onshore/offshore) Client Name: BOOTS(Retail domain) BOOTS is one of the largest retail chains across UK having nearly 2500 stores, providing health & beauty products and advice to enhance personal wellbeing. Steria is responsiblefor ensuring seamless service to Logistics system, which is backbone of BOOTS’ supply chain management system. Responsibilities:  Handled 4 teams for Boots account o Logistics - Supply chain | Customer & data - Customer spending pattern analysis o Impact - Financial reporting for Boots account | ABACUS (IBM balanced warehouse)  SPOC in CAST Assessment tool for all the mainframes application.  Responsible for Service Gateways and Service Delivery of Mainframe and UNIX team from off-shore location.  Responsible for handling the Production Support team.  Worked on various ITSM tools like Incident management, Change management and Problem management.  Provided seamless and continuous Service Improvement plans by exploring existing systems and finding bugs.  Liaised with relevant stakeholders for any changes in process to be taken into account and subsequently prepared change control notes.  Single point of contact for resolving Critical SEV-1, SEV-2 incidents. Knowledge acquisition during transition period from Infosys.  Onsite Coordinator for mainframe & ABACUS (Data warehousing) team.  Provided Knowledge training sessions for Mainframes and Analytics (Data Warehouse)

Job Title: Senior Software Engineer Client Name: AIG, Prudential, MassMutual (Life Insurance) Responsibilities:  Worked for life insurance products developed by CSC like VANTAGE & WMA.  Worked on client requirement gathering, interfaced directly with clients.  Created design documents based on the requirements finalized.  Did the software coding and reviewed the codes developed by the junior team members.  Responsible for System Testing and Regression Testing for various codes developed along with database conversion.  Monitored and reported the progress of the ongoing projects to the clients.  Responsible for resolving Critical Production SPRs and providing status report to clients directly.  Responsible for Production and Model Office Support for Prudential Client.  Single point of contact for Onsite coordination for Mass Mutual Client.  Onshore Visits :USA (East Hartford) for 5 weeks (Mass Mutual project)

Job Title: Software Engineer Project: SSP (System Strategic Plan), Health Insurance SSP was an enhancement project, which aims to add new functionalities like automatic assignment of plans and benefits to members enrolled with AETNA based on family status. Responsibilities:  Awarded as the Promising Fresher based on the coding skill expertise.  Worked with the development team in various roles as Designer, Coder, Tester and defect fixer during project lifecycle.  Played the role of a Backup DP and Backup KM.