Stuttgart Region
*A passionate and keen person with strong Leadership and communication skills having capability to successfully navigate multiple tasks and priorities in a fast-paced environment.I am Willing to take new roles and responsibilities as Technical support or product owner. * Well versed in developing complex SQL queries ,analysis and debugging and dashboard presentation to management. * Worked as Team Lead for Maintenance and Support project in Property and Casualty Insurance(AIG client). * Agile methodology and Scrum master for team with Hands-on experience with ITIL and ITSM * 6 years experience in training and grooming more than 15 associates in the project related activities. Tools handled: Service now,Websphere application server 6,Mainframe DB2 and Datastage basic trouble shooting,Windows server 2008 & 2012. Trained in AWS, linux & HTML. Mail: [email protected]
* Handled international L2 support for procure2pay web App. * optimised SQL stored procedures to improve app response time & supported end user report requests. * responsible for technical onboarding,user training, infrastructure support & Documentation. * contributed to platform stabilization.
AIG-AIWCS production support- L2 Scrum Master-'Synergy' model. As production support Lead , Offshore SME and Scrum Master I am accountable for 7+ applications in Workers Compensation area. Key responsibilities include to: * Faciliate daily kanban meeting to review open incidents and brainstorm the blockers with team and guide to resolution. * Actively involved in monthly governance for SLA reporting , monitor application availability,track outages and perform casual analysis to take preventive measures. * Effective resource management and played effective role in cross training associates to reduce FTE as per synergy contract. * Track software issues through to resolution, within agreed time limits(SLA) * Developed complex SQL queries for user report request on immediate basis. * 30+ Batch jobs monitoring and error fixes in DB2 ,written queries to view ,retrieve data and perform DML in DB2. * Fixing any batch job issue to ensure timely reporting of data to downstream application. * Prioritize open issues and Document technical knowledge in the form of notes and manuals. * Driving continous improvement initiatives (Automation/Elimination/Shift-left) thereby reducing ticket inflow.Also Created really feature(agile central) and problem Ticket for repetitive tickets. * Guiding and mentoring offshore team and involved in appraisal of subordinates,managing associate expectations enhancing capabilities and cross training. * Responsible for defect free standard releases(less than 40PD) from L2. * Involved in Automation of windows service monitoring and supported configuration of application alerts in Splunk. * Correction of issues through DML to fix data as per Devops process.
AIWCS -SQL 2014 and Win12 migration * Performed role of module lead for AIWCS server migration project to upgrade the existing SQL and windows server versions. * Involved in code walkthrough and IQA and FI process coordination. * Coordinated with multiple interfaces and also support team such as DBA/Middle ware/Wintel/Citrix/packaging team. * Impact analysis and code changes implementation to impacted SQL and vb and windows server components. * Unit and integration Testing of 100+ batch jobs and coordination with QA team. * Fixed few existing issues and ensured both phases of migration was successfully implemented. * Coordinated with onsite and business for both phases of migration. * Coordinated with team to ensure delivery dates are met.Also facilitated discussion between various teams to identify and resolve any conflicts during migration. * Provided environment support and post production support ensuring application availability. * Involved in periodic reporting of project status to TCS projects managers in weekly basis.
AIWCS is a workers'compensation policy underwriting system performing business functions like new/renewal issuance,rating, reinsurance, endorsement,quoting and auditing of Workers compensation line of business. * Gathering detailed Business and technical requirements from client and analysed the change and impact. * Acted as module lead & made code changes as part of Maintanence Release (waterfall model)and ensured all milestone related to schedule and delivery was met. * Carried out RCA of defects for defect prevention ,worked on fixing inherited code bug & Automated few frequent business requested reports through autosys. * Coordinating with 10+ interfacing team and ensuring all impacts analysis were addressed. * Prepared test plan and test data for QTP regression suite and performing unit and integration testing for defect free implementation. * Prepared System/User documentation and documentation of business rules.