Project Name: Business Intelligence Repository (BIR) Role: Senior Oracle Developer Technology Stack: Oracle 12c/19c, Pentaho, SSRS Project Overview:BIR is a Data Warehouse (DW) and reporting solution utilized by JPMorgan Chase's regulatory team to generate critical transactional reports on a daily and monthly basis. These reports are used for regulatory compliance, data analysis, and business intelligence. Key Responsibilities:- Report Logic Development: Designed and implemented complex report generation logic to meet various business and regulatory requirements.- Data Center and Database Migration: Led the migration of the BIR infrastructure to a new data center while upgrading the database from Oracle 12c to Oracle 19c. This involved ensuring seamless data transfer, minimizing downtime, and validating data integrity post-migration.- ETL and Data Integration: Worked with ETL tools (Pentaho, SSRS) to integrate and transform data, ensuring the reporting system was both efficient and aligned with business needs.- Performance Tuning: Performed database optimizations and queries tuning to ensure fast data retrieval and optimal system performance.- Collaboration: Coordinated with cross-functional teams including infrastructure, data scientists, and business analysts to ensure successful implementation and smooth operation of the BIR platform. Technologies and Tools:- Database: Oracle 12c/19c, PL/SQL, SQL- Reporting Tools: Pentaho, SSRS- ETL Tools: Pentaho Data Integration (PDI)- Data Warehousing:ETL processes- Version Control: Git Key Achievements:- Successful migration of the entire BIR infrastructure to the new data center, minimizing downtime and ensuring continuity of service.- Worked on the Oracle database upgrade from version 12c to 19c, ensuring a smooth transition and leveraging new features for better performance and security.

Project Name: Revenues and Benefits Role: Lead Software EngineerTechnology Stack: Oracle 21c, Oracle Apex, Unix, XML,XSL-FO,Oracle HTML DBThis is a product called Revenues and Benefits which is widely used by the Local Authorities in the UK. • It is a platform that is used by LA’s to collect the revenues and taxes from the citizen. This platform is also used by the LA’s to help its citizens give the housing benefits.Key Responsibilities:Manage design and documentation processes to ensure clear and efficient implementation of new features and improvements.Handle client communication, including project estimations and root cause analysis for any issues or enhancements.Approve leave requests and ensure smooth team operations, while maintaining project timelines and quality standards.Key Achievements:Spearheaded the development and continuous enhancement of the Revenues and Benefits platform, supporting Local Authorities in tax collection and housing benefit distribution.Streamlined the process of revenue and tax collection for citizens, improving efficiency for both citizens and local government agencies.Integrated features to simplify access to housing benefits, directly benefiting citizens and enhancing the platform’s usability for local authorities.

Project Name: Claims & Advance | Ultimatix GESS (Global Employment Self Service) Role: System Software Engineer Technology Stack:- Backend: Oracle 11g, SQL/PL-SQL - Frontend: JSF, Weblogic 9.2, Java - Support & Maintenance: Production Support, Impact Analysis, Query Optimization, Manual Testing, Release ManagementAs the Module Lead for the Claims and Advance module of the Ultimatix GESS platform, I manage the tracking of claims/advances and the payment/repayment of expenses incurred by TCS employees (TCSers). My role involves both development and maintenance of the backend database, as well as providing production support and optimizing performance. Key Responsibilities:- Backend Development: Worked with Oracle 11g for database development, ensuring seamless tracking of claims/advances and their payment/repayment through the approval workflow.- Production Support & Maintenance: Provide daily support for database activities, perform impact analysis of Change Requests (CRs), and contribute to database optimizations and query tuning.- Development & Revamp: Contributed to the Claims Module Revamp by participating in development and ensuring improvements to functionality and user experience.- Module Leadership: Lead the DB Maintenance & Support activities, managing a team to ensure timely resolution of production issues and maintaining system stability. Key Achievements:- Enhanced the Claims and Advance Module, improving the accuracy and efficiency of expense tracking and approval workflows for TCSers.- Spearheaded performance optimizations in SQL/PL-SQL queries, significantly improving the platform’s efficiency.- Played a key role in the revamp of the Claims Module, aligning it with organizational needs and providing a more intuitive user interface.- Managed successful release management and deployments, ensuring smooth transitions to production with minimal downtime.

Project Name: STG Billing - AMS Billing Role: Senior Software Engineer Technology Stack:- Backend: Oracle, PL/SQL - Tools: SQL/PL-SQL, Performance Tuning, Release ManagementAs a Senior Software Engineer at Mastek Limited, I worked on the STG Billing system, a policy billing platform that facilitates property and casualty insurance billing for multiple clients. The system integrates with various other platforms to meet the business requirements of clients, leveraging Oracle for backend development and Java, Oracle Reports, and Adobe Flash Builder for frontend development. Key Responsibilities:- Production Support: Provided critical production support, ensuring the smooth functioning of the AMS Billing system by analyzing and resolving production issues.- Impact Analysis & Change Requests: Analyzed Change Requests (CRs), assessing their impact on the system and implementing necessary updates or fixes.- SQL/PL-SQL Programming: Wrote complex SQL and PL/SQL queries for backend data processing, optimized performance, and ensured data integrity.- Performance Optimization: Worked extensively on performance tuning to improve system efficiency and address performance bottlenecks.- Configuration Management: Acted as the Configuration Manager for three tracks/portfolios, ensuring proper configuration and version control for various modules. Additional Contributions:- Client Interaction: Actively engaged with clients, handling client calls and addressing their concerns or requirements.- Automation: Developed and maintained scripts to automate daily batch processes and summary reports, streamlining manual activities.- Utility Tool Development: Created a utility tool to extract data from various environments, enabling developers and analysts to save time and enhance productivity.- Documentation: Authored and maintained detailed project documentation for system updates, deployments, and configurations.

Project Name: Provida - MetLife Mexico Insurance Project Role: Systems Associate Technology Stack:- Backend: Oracle, PL/SQL - Tools: Defect Prevention, Ticket Analysis, Documentation (Functional and Technical Design)As a PL-SQL Developer on the Provida project, I worked on the MetLife Mexico Insurance System, which handles the entire lifecycle of life insurance products. My role spanned both development (1 year 9 months) and maintenance (9 months), where I contributed to enhancing system functionality and ensuring smooth operations for life insurance policy management. Key Responsibilities:- Development & Coding: Developed new functionalities using PL/SQL for key processes like Partial Withdrawal, Cancellation of Partial Withdrawal, Surrender of Policy, and Claim Processes.- System Analysis & Impact Assessment: Analyzed the impact of changes in the business processes and designed solutions to incorporate new functionality, including the new Reserve Process.- Ticket Analysis & Defect Prevention: Acted as a Defect Prevention Representative (DPR), performing ticket analysis to prevent issues and ensure code quality.- Documentation: Authored detailed Functional and Technical Design Documents, outlining the current system functionality and documenting changes required for new features.- Maintenance & Issue Resolution: Contributed to system maintenance, troubleshooting issues, and supporting ongoing functionality enhancements. Key Achievements:- Successfully implemented new business functionality in Oracle, enhancing the system's capability to manage life insurance policyholder activities.- Played a critical role in maintaining the integrity of the Provida application, ensuring smooth operation of insurance processes like policy withdrawals and claims.- Contributed to comprehensive documentation for system changes, ensuring clear communication and understanding between development, testing, and client teams.