Rajasekar Raju

• Project Name
• Hp: Corona-Inc –LTO Tech services- HPI DCE Solutions
• Description:
• CORONA Inc is a Mission critical business Data hub asset as part Lead to order Tech services of HP Inc DCE solutions.
• Roles:
• Collaborated with stakeholders for requirement gathering and with cross-functional teams throughout the project lifecycle.
• Conducted regular reviews of operations and identified areas for improvement.
• Contributed to High Level Design Documents and interface document preparation for enhancements.
• Generated reports detailing findings and recommendations.
• Participated in peer review processes for design and code changes across project deliveries.
• Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
• Developed PLSQL packages, procedures, functions, and complex SQL queries for application development.
• Developed innovative strategies to address complex business challenges, resulting in increased profitability for clients.
• Created Linux scripts for batch processing jobs and reports during asset onboarding to Corona.
• Executed performance tuning and query optimization for jobs, reports, and stored procedures.
• Supported SIT/UAT activities during multiple test phases involving diverse assets.
• Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
• Played important role in ecomcat application sunset and onboarding GSA module into Corona systems
• Played important role in HP2B price optimization design solution through Corona
• Project Name
• Hp: Oneconfig/OCPLC
• Description: TOMS to OCPLC application migration project
• Roles:
• Collaborated with stakeholders for requirement gathering and with cross-functional teams throughout the project lifecycle.
• Involved in Oneconfig OCPLC application development as part of existing TOMS application sunset. Data migration , postgresql DB stroe procedure development to support the application functionality and also batch job development to support the business requirements.

Project Name: Deutsche Bank UK –Connectivity-Report Manager CTB

Description: Report Manager is a centralized reporting application designed to become the standard reporting tool across multiple banking business areas

Roles:

• Participated in all phases of the SDLC—analysis, design, development, testing, and maintenance—ensuring timely delivery for reporting solutions across Client Service Systems (CSS), Financial Supply Chain Management (FSCM), and EBILLS applications.
• Developed PL/SQL packages, procedures, and functions to support integration of new applications into Report Manager.
• Designed data models and created data extracts for both standard and ad-hoc reporting requirements.
• Collaborated with stakeholders for requirement gathering and with cross-functional teams throughout the project lifecycle.
• Handled incident and problem management, ensuring adherence to Service Level Agreements (SLAs).
• Created materialized views with DB links for replicating source data into Report Manager during the ETL process.
• Conducted performance tuning and query optimization to enhance reporting efficiency for CSS and FSCM modules

Project Name: UBS Private Bank - Development T&M

Description: The Integrated ICRM with FATCA Provision is a web-based client-server solution developed to replace existing third-party applications (ICRM and BO Registry) in UBS WMA’s Private Banking division

• Roles:
• Actively participated in all phases of the Software Development Life Cycle (SDLC), including requirement analysis, system design, development, testing, implementation, and ongoing support.
• Designed and developed PL/SQL packages, procedures, functions, and other database objects to implement core business functionalities across multiple modules.
• Developed and maintained UNIX shell scripts to manage import/export batch processes and automate routine tasks.
• Focused on performance tuning and SQL query optimization to enhance the efficiency of critical batch jobs and reporting components.
• Collaborated with cross-functional teams (Operations, Compliance, CA, and CAA users) to ensure that business needs were accurately captured and translated into technical solutions.
• Played a key role in the successful delivery and deployment of the application, ensuring high availability and reliability post go-live.

Project Name: Telstra Australia : TCPS (Telstra commission Payment systems)

Description : The Telstra Commission Payment System (TCPS) is a mission-critical application used by Telstra’s Channel Commission Group (CCG) to calculate and manage commission payments for internal staff and external mobile dealers.

Roles: PL/SQL Developer / Application Support Engineer

• Executed Change Requests (CRQs) for transaction remediation, clawback processes, dealer migrations, and reference data updates using PL/SQL and UNIX shell scripts.
• Conducted detailed requirement analysis for system enhancements, aligning initiatives with business objectives.
• Designed architecture and developed technical solution documents, including design specifications and interface documentation.
• Created and executed comprehensive test plans and cases for functional and integration testing.
• Collaborated with cross-functional teams for development, QA, deployment, and production support activities.
• Ensured compliance with organizational quality standards while fostering innovation and service excellence.
• Played a pivotal role in designing, developing, testing, and deploying the IR7324 TAG Interface Release.
• Led automation initiatives within TCPS application, reducing manual interventions and enhancing reliability.

Project Name : EEP( Efficient Enterprise project)

Description : The Enterprise Efficiency Platform (EEP) is a MySQL-based ERP application integrating four core components: Business Analytics/Intelligence, Enterprise Resource Planning, Management Information Systems, and Decision Support Systems. EEP enables organizations to streamline operations, make data-driven decisions, and improve overall business performance through a unified software solution.

Roles : Project Lead / Database Developer

• Conducted in-depth requirement analysis and designed databases for various ERP modules.
• Oversaw project management to ensure on-time and within-scope delivery of product features.
• Participated in peer reviews of code and database modules to uphold quality standards.
• Facilitated user training sessions and review meetings to enhance adoption and gather feedback.

Project Name : UBSW-UK : RAMBO Equity settlements

Description : RAMBO is an Equity Settlement system which mainly handles Exotic and Vanilla products. User access is arranged through Open Step Client

Roles : Database Developer / Application Support Engineer

Location : London,UK

• Implemented system enhancements and change requests using Oracle PL/SQL and UNIX shell scripting.
• Designed and optimized scripts for data extraction, batch processing, and trade settlement workflows.
• Participated in incident and change management processes to ensure smooth transitions in production environments.

Project Name :UBS PnL Applications (NEPAL, RANGER, EQUITY AND UBSW CONSOL)

Description : Ubsw consol applications are primarily a Profit & Loss (P&L) data warehouse and reporting tool designed principally for use by Equities Financial.

Roles: Database Developer/ Application Support Engineer

Location : Singapore

Project Name : UBSW UK: MEMPHIS IR SETTLEMENTS SYSTEM

Description : MEMPHIS is a strategic straight-through processing (STP) solution for the settlement, accounting, funding, and confirmation of OTC Derivatives and Banking Products, specifically covering Interest Rates and Equitie

Roles : Database Developer/ Application Support Engineer

Project Name : Citi-India : GILS (Generalized Installment Loan systems)

Description : GILS is a core loan processing application developed for Citibank India to manage the complete lifecycle of installment loans, including booking, processing, and closure.

Roles : Database Developer/ Application Support Engineer

• Conducted end-to-end development activities, including requirement analysis, design, coding, testing, and deployment for AHFS Pre/Sal Closure and STP modules.
• Maintained and supported EOD and EOM batch processes to ensure timely loan interest calculations.
• Provided production support to troubleshoot system issues and monitor daily batch operations.
• Collaborated with business and QA teams to analyze and resolve issues in production environments.