• Coordinated with cross-functional teams to plan, monitor, and manage production activities/transactions to ensure accuracy and adherence to standards and mitigation of operational risk • Subject matter expert for production; performed end-to-end operations in multiple IMS data panels- data collection, job executions on the Mainframe and Production Tool, completion of batch processes, root cause analysis and debugging of failed jobs/processes, execution and maintenance of DTS and SSIS packages as well as other SQL Server objects and application systems in operation to ensure timely completion of monthly and quarterly reports • Provided timely status updates to team manager and stakeholders • Provided L1/L2 support for applications from all internal business lines; triage tickets, troubleshoot and debug to resolve issue, properly escalate and follow up unresolved issues • Collaborated with business users, application owners, and other affected parties during issue resolution • Critically analyzed client requests; extracted data from complex data sets on the MS SQL Server database, validated trends in data, performed tracing and modifications on predefined procedural scripts to meet client requirements • Generated reports with MS Excel spreadsheets using pivot tables and macros, converted data using formulas and VLOOKUPs, performed formatting of .csv files for proper output readability • Created and maintained documents with detailed logical flow of the processes; updated document on issue tracking for the team’s reference; helped maintain knowledge database • Helped lead successful migration to Manila Hub; created training materials and trained new users after successful migration •Spearheaded Kaizen automation projects for continuous process improvement; successfully eliminated hand-offs and redundancies in the process flow, coordinated with development team to build a software for automating manual tasks in data collection, overall resulting to reduced production cycle time