• Designed and developed a solution to automate input file generation for removing and adding recurring charges and rate plan changes, eliminating manual data gathering for the customer, speeding up delivery time, and improving accuracy.• Proactively analyzed product data using SQL to identify and address potential revenue loss, demonstrating self-motivation to deliver exceptional benefits for the customer.• Performed data analysis, gathered user requirements, and managed end-to-end processes such as design, development, testing, and demonstrations in an Agile environment.• Provided support and mentorship for less experienced developers.

• Performed thorough analysis, testing, and troubleshooting on a data warehouse/financial reportingmainframe system in an Agile environment. Proactively identified issues, meticulously documentedfindings, and created detailed test plans and test cases. This resulted in the efficient identification andresolution of software defects, significantly enhancing product excellence.• Collaborated with developers and stakeholders to clarify user story requirements, activelyparticipated in code reviews, ensuring consistency and completeness, contributing to improvedproject alignment and software quality.• Actively participated in daily stand-up meetings, providing essential project updates to theProduct Owner, Scrum Master, and Development team, fostering a collaborative workenvironment, and enhancing project coordination and efficiency.• Demonstrated innovation by automating processes, resulting in significant time and resourcesavings. For example, created SQL queries using bulk insert functionality for efficient dataextraction from mainframe files, expediting data analysis, validation, and productivity.• Proficiently crafted and documented hundreds of complex SQL queries in Confluence, essentialfor report validation, file accuracy, and database updates, fostering knowledge sharing within theteam.• Designed and implemented custom batch files and VBScripts for logging into the mainframethrough WebEnabler, initiating CANDE, and automating program execution, reducing the needfor development team intervention, significantly saving testing time.• Recommended the removal of hardcoding and adoption of a table-driven approach in ourcodebase, significantly reducing project delivery timelines and enhancing value delivery to ourbusiness.

• Provided architectural solutions and design recommendations throughout high-level and low-level phases, addressing testing issues and leading the monthly production implementations to ensure theimplementation of all user stories and defects. Proactively identified issues through performancemonitoring.• Led the production area for a Linux server-based billing system (Singleview) serving governmentagencies and multi-national corporations, coordinating with key stakeholders to ensure efficiency.• Collaborated closely with internal and external stakeholders to support day-to-day activities,resolve issues, and maintain SLA compliance.• Demonstrated extensive expertise in performance and SQL tuning, utilizing Oracle explain plans,AWR reports, query optimization, indexing, and query hints.• Reduced production defects from 150 to 10 in 3 months by guiding the global development teamwith solutions and testing procedures.• Developed complex SQL statements for back-end solutions, monitoring, and reporting in a 24x7production support role.

• Led a mainframe-based billing platform (COBOL, DB2, JCL, CICS) responsible for billingapproximately $1 million monthly across 9 cycles for small to medium-sized businesses.• Engaged in the full development lifecycle, enabling the rollout of new products and services viathe rating, billing, and invoicing framework, producing accurate and on-time billing.• Developed a solution to automate the rerun of the billing cycle, saving hours and eliminating usererrors on resubmission.• Provided 24x7 on-call rotation support for inquiries, debugging production issues, and resolving batch abends.