Profile Summary

• Oracle PLSQL Senior Developer/Analyst with 10 years of IT experience in N-Tier System Architecture, Design, Analysis, and Application Development, full SDLC and deploying Business solutions using Oracle 11g/10g/9i, PL SQL, SQL Server, Teradata on UNIX and Windows platforms.
• 8 years of experience in Finance and Banking domain including Money Market, Foreign Exchange and Derivatives Fixed Income Securities, IRS, CCS, FX Swaps, Options Modules. Experience in working with B2B functionality.
• Hands on experience working in Healthcare, Aviation and Powerplant Utility Domains.
• Extensive experience in Oracle Back-end server-side PL/SQL Development i.e. Packages, Stored Procedures, Indexes, Functions Triggers.
• Extensive experience in Creating and working with Database Objects like Tables, Views, Materialized views, Constraints, Sequences, Synonyms, Grants and Database Link.
• Experience in working with complex SQL queries, Performance tuning, Bug fixing and Data patches.
• Experience in working with Oracle Forms and Reports.
• Involved in Extracting large volumes of data from different data sources and loading data into other data sources.
• Experience in working with MQ series, Tivoli batch processing, Designing and generation of the Banking reports using Crystal Reports 2008/10.0/8.0.
• Development Experience in VB form designing for Windows application.
• Experience in handling Production support, Client calls. Proficiency in understanding Clients requirements and generate, modify reports existing in Oracle database Applications according to the requirements and specifications.
• Hands on experience in Microsoft Project Plans, Monthly Metrics, Effort Estimates, Project review meetings, PMG calls, Requirements gathering, Functional specifications, Design specifications, Preparing test plans and Test cases.
• Experience in Status Updates, Project Updates, Version Management, Change Management and Release Process.
• Excellent written and verbal communication. Able to communicate effectively in business terms with business partners up to the VP level.
• Strong communication, excellent client interaction skills and interpersonal competencies along with detail-oriented problem solving skills in the Technical and Functional arena.
• Willing to learn new functionalities. Like to learn and work with new tools, and environments.

Functional Proficiency

• Money market
• Derivatives MMFR, IR Swaps , Currency Swaps, Mutual Funds, Fixed Income
• Foreign Exchange
• Options

Technical Proficiency:

PROFESSIONAL EXPERIENCE

Confidential

IT Sys Analyst/Integrator

Maximo Powerplan Consolidation Project

• Maximo is the asset management system for the Powerplant Generation, Transmission Distribution and Facilities.
• Maximo interfaces with Powerplan to send various work orders information through online and batch interfaces. Powerplan is an accounting system which manages and processes the work orders.

Roles Responsibilities

• Worked extensively on creating new and modifying existing PLSQL Packages, Stored Procedures and Functions based on the Business requirements.

• Creation and alterations of the new and existing Tables, Views and Triggers.
• Worked extensively on Bug fixing, applying Data patches by writing new and modify existing complex SQL queries and automate SQL Scripts.
• Understanding the Data flow, Data Analysis and researching issues with the data, providing root cause analysis.
• Participated in Project meetings and code reviews, interacting with the other application teams.
• Worked closely with the business and the accounting teams to support SIT, UAT and project cutover activities.
• Worked on designing and modifying Technical design documents.

Environment - Oracle11g, PLSQL, TOAD, Rapid SQL 8.7.1, Windows 7

Confidential

Sr. PLSQL Developer/ Analyst

Project deals with the Maintenance and Repair operations of the Aircrafts. The Applications deals with the following features.

• Aircraft operations
• Heavy maintenance
• Line maintenance,
• Modification and Transition services
• Aircraft storage, Paint, Disassembly and Consignment parts sales.

Roles Responsibilities

• Worked on gathering Business/Data requirements with various Business counterparts and provide them with accurate and appropriate solutions.
• Designed and modified new and existing Oracle Forms and Reports.
• Worked extensively on creating new and modifying existing PLSQL Packages, Stored Procedures, Functions and Database links based on the Business requirements.

• Creation and alterations of the new and existing Tables, Views, Triggers and Grants.
• Worked extensively on Bug fixing, applying Data patches by writing new and modify existing complex SQL queries and automate SQL Scripts
• Understanding the functional Data flow, Data Analysis and researching issues with the data, providing root cause analysis using Business Terminology.
• Worked on the complex reports with multiple Tables and multiple joins.
• Working on Adhoc requirements and providing the end solutions to the Clients and the Business partners.
• Work with version control tool SVN for maintaining the sources and participate in the Code review meetings.

Environment - Oracle11g, PLSQL, SQL Server 2008, Oracle Forms 11g and Reports 11g, UNIX, Windows 7

Confidential

Sr. Oracle PLSQL Developer/Analyst

Advisor Services MIS AS MIS

MIS team is responsible to collaborate with the clients by building and supporting effective state-of-the-art systems that deliver timely, accurate, and meaningful information.

This includes:

• Management reporting on business metrics dashboards, etc .
• Decision support applications, particularly with financial implications incentives tracking, pricing models, etc .
• Ad hoc reporting for decision support.
• Some Operational reporting, particularly around regulatory, audit, and legal needs.
• Marketing Communications: Mailing lists, customer contact, etc, in specific instances where data complexities and knowledge dictate MIS involvement.
• Business process automation to increase productivity as time and resources permit.

Roles Responsibilities

• Worked on gathering Business/Data requirements with various Business counterparts as part of the OptionsXpress data integration project.
• Worked extensively on ASMIS requests by interacting with business partners of various departments like, AS Sales, Trading, AS Services, Infrastructure support, Schwab Technology Services to gather/understand the reporting requirements.
• Worked directly with business partners to define requirements, design and implement appropriate solutions, using Oracle, Teradata, Sql Server, SQL Navigator and Oracle Forms and Reports.
• Understanding Data flow, Data Analysis and researching issues with the data, providing root cause analysis using Business Terminology
• Working on Adhoc Data requirements and providing the end solutions to the Clients and the Business partners.
• Designed and modified new and existing Oracle Forms and Reports.
• Bug fixing, applying Data patches by writing the modifying the complex SQL queries, writing and automating SQL Scripts, modification of the business functionality based on the requirements by modifying the existing PLSQL Packages, Stored Procedures, Functions, creation of Database links, and Tables.
• Creation and the alterations of the new and existing Tables, Triggers, Grants, New Functions.
• Involved in the Data extraction from the data sources and Loading data into the data sources.
• Worked on modifying UNIX shell scripts for creating the Cron jobs for the Data Extraction and Data upload.
• Creation and the alterations of the new and existing Tables, Triggers, Grants, New Functions.
• Worked on automating/scheduling the reports using Business Objects Central Management Console CMC to schedule reports.
• Handled Automated Customer Account Transfer ACAT UAT successfully. Participated in the Code and Design review meetings and followed coding standards.
• Worked on the developing and modifying SQL queries, Tables, Views in both Oracle SICROPS and Teradata IDW Databases following ANSI Standards.

Environment - Oracle11g, UNIX, SQL Navigator 6.4, Windows NT, SQL Server 2008, Teradata 13.1, Excel 2010, Oracle Forms 11g and Reports 11g.

Confidential

RRM Regulatory Reporting Management and Performance Improvement

• Quantros RRM takes quality and performance data beyond the data submission requirements mandated by The Joint Commission and CMS. RRM can:
• Quantros RRM streamlines and simplifies reporting to a growing list of organizations such as The Joint Commission, CMS, ACC, STS, states and many others. RRM reaches far beyond quality reporting requirements and delivers opportunities for improved pay-for-performance P4P reimbursement. Automation allows real-time access to performance indicator data so proactive interventions can be enacted rapidly.
• Collect data once and use it for multiple reporting activities. This increased efficiency helps you participate in multiple quality measurement and data registry activities without increased labor.
• Immediately review and act upon computed performance metrics in real-time.
• Leverage Quantros concurrent quality data processing for enhanced care management and clinical guideline compliance.
• Use our clinical upload utility to eliminate up to 60-80 percent of manual data collection requirements.
• Preview public data reports prior to final release.

Roles Responsibilities

• Work on the Healthcare data processing, Upload and process the files sent by the facilities like QHS, TENET, MEDAI, MEDIQUAL
• Work on the Data Extracts and the Daily dump files to the facilities like QHS, TENET, MEDAI, MEDIQUAL
• Work with the Sales force tickets, Bug fixing, Issue Resolution, applying Data patches by writing the modifying the SQL queries.
• Modifying the application functionality based on the requirements by modifying the existing PLSQL Packages, Stored Procedures, Functions, modifying the triggers, creation of Database links and Tables.
• Involved in the Data extraction from the data sources and Loading data into the data sources.
• Worked on modifying UNIX shell scripts for creating the Cron jobs for the Data Extraction and Data upload.
• Creation and the alterations of the new and existing Tables, Triggers, Grants, New Functions.
• Work with the Flow charts, Algorithms, and version control tool SVN for maintaining the sources.
• Designed and modified new and existing Oracle Forms and Reports.
• Experience working with the Java application and closely work with the QA team and the GUI team.

Environment - Oracle10g, PLSQL, TOAD, Crystal Reports 2008, Windows 7, SVN, Oracle Forms 11g and Reports 11g.

Confidential

Senior Oracle PL/SQL Developer

• The scope of the Project is to implement the Treasury functionality, TCON in various countries i.e. in various branches of Citibank in Europe. This application provides the entire processing of Treasury in bank. This provides end-to-end features such as
• Supports Front, Middle Back office
• Centralizing Risk management
• Money Market, Foreign Exchange, IR Swaps, FX Swaps, Fixed Income Securities, MMFR

Roles Responsibilities

• Work in the team responsible for

1. New country rollouts

2. New feature implementations

3. Technical /Software migration

• Work on the business functionalities like Money Market, Foreign Exchange, IR Swaps, FX Swaps, Fixed Income Securities, MMFR.
• Work on the Borrows, Loans, Mark to Market, Exchange Rate, NPV, Bonds, Coupon, Face Value, Maturity date, Call Option, Put Option.
• Bug fixing, applying Data patches by writing the modifying the SQL queries, modification of the business functionality based on the requirements by modifying the existing PLSQL Packages, Stored Procedures, Functions, creation of Database links, and Tables.
• Involved in the Data extraction from the data sources and Loading data into the data sources.
• Worked on modifying UNIX shell scripts for creating the Cron jobs for the Data Extraction and Data upload.
• Creation and the alterations of the new and existing Tables, Triggers, Grants, New Functions.
• Design and modify Crystal reports. Sending and Receiving MQ messages.
• Modify and Fix the existing VB screens as part of the UAT fixes.
• Designed and modified new and existing Oracle Forms and Reports.
• Worked with Java applications for the application work flow.
• Interacting with the Back office, Middle office and Front office Users in the preparation of the Test cases.
• Setting up the Environment for UAT and support UAT Conducting the End of Day Batch Runs, Generation of the Reports.
• Scheduling the Production Cutover activities and providing Post Implementation support.
• Following the Change management and Version management processes using the tools like Infoman, Intellect Vault and Intellect Solve while deploying the application.
• Worked with various teams during the course of the project as part of the application support.
• As a senior developer mentoring the team members, conducting and participating in the PMG calls, Conducting PSR meetings, Project Status Reviews. Preparation of the Microsoft Project Plans, Monthly metrics, Effort estimates and Test Plans.

Environment - Oracle 9i/10g, PLSQL, SQL, VB, VB Dot net, Seagate Crystal Reports, Microsoft Project Plans, Windows 2000, Oracle Forms 10g and Reports 10g.

Confidential

Oracle PL/SQL Developer

• EGG is a Credit Card System bank which was taken over by Citibank London. EGG has an existing treasury system called Murex. Atlantis will replace Murex and its interfaces to the various systems with the implementation of this project.
• The scope of this project is to implement the Money market, MMFR, IRS, FX, Options modules of the treasury product Atlantis/TCON for EGG bank. Project development consists of MM, IRS, FX swaps, new interfaces, and new reports for MTM of IR swaps, Income expense Balance sheet.

Roles Responsibilities

• Interacting with the EGG bank users and gathering the Business requirements. Preparation of the Functional specifications and the Design Specifications.
• Mentoring the team with the application functionality and the Business Logic.
• Work on the Business functionalities like, MMFR, FX Swaps, Cross Currency Swaps and Mark to Market.
• Development and modification of the back end interfaces using PL/SQL Packages, Stored Procedures, Functions and Crystal Reports for implementing the complex business functionality.
• Work on creation of Database links, views and materialised views.
• Worked with Java applications for the application work flow.
• Work on tuning the SQL Queries for better performance and troubleshooting development problems.
• Work on the Data extraction from the data sources and Loading data into the data sources.
• Modify the existing VB screens in the application as per the new EGG enhancements.

Environment PLSQL, SQL, VB, VB Dot net, Oracle 9i, 10g, Seagate Crystal Reports, Windows 2000

Confidential

Oracle PL/SQL, UNIX Developer and Support

• The scope of the project is to implement Two step Deal booking in FX, SNA to MQ migration for the Customer interface, Funding interface and Designing new reports.
• SNA to MQ is the technical migration from SNA link to the MQ series to establish a link between TCON and the Customer data system.

Roles Responsibilities

• Setting up the SIT and UAT Environments. Create and Schedule EOD Batch runs.
• Developing the business functionalities by writing the PL/SQL Procedures, Functions.
• Modifying the UNIX shell scripts based on the given requirements.
• Creating the MQ links and validating the MQ messages sent and received by the application.
• Fixing the Bugs by modifying the SQL queries in the Procedures, Functions and Packages.
• Participation in the PMG calls and weekly status review meetings and providing User support.
• Interaction with the other host systems like FMS and deploying the application.
• Design and fix the Crystal reports based on the requirements.

• Writing complex queries to generate ad-hoc reports as per client request as a part of Production support.
• Following the Change management and Version management processes using the tools like Infoman, Intellect Vault and Intellect Solve while deploying the application.
• Worked with various teams during the course of the project as part of the application support.

Environment - VB 6.0, Oracle 9i, SQL, MQ series, Pro C, UNIX, Seagate Crystal Reports Windows 2000

Confidential

Oracle PL/SQL Developer and UAT Support

• The scope of the project is to implement the Plain vanila Money market module and the maintenance module of the treasury product TCON for Citifinancial in Denmark and Finland.
• Release activities should follow the process of CCB Change control board . Intellect vault is used to control all the Version control activities and Intellect Solve for all the Change control activities.

Roles Responsibilities

• Interacting with the Users in the Preparation of the Test cases.
• Setting up the Environment for UAT and Support UAT
• Scheduling the Production Cutover activities and providing the Post Implementation support.
• Resolve the issues given by the users and Fix the Bugs by modifying the SQL queries in the Procedures, Functions and Packages.
• Perform End of day Batch runs. Generate EOD Reports, Transfer Handoff files to the other applications through NDM transfer.
• Participation in the PMG calls and Interacting with the other application teams to verify the correctness of the data in the file transfer.
• Following the Change management and Version management processes using the tools like Infoman, Intellect Vault and Intellect Solve while deploying the application.
• Worked with various teams during the course of the project as part of the application support.

Environment - VB 6.0, Oracle 9i, PLSQL Developer, Windows 2000

Confidential

Oracle PL/SQL Developer and Support

• The scope of the project is to provide online production support for the ongoing business of APCB treasury.
• Countries supported: Singapore, Hong Kong, Taiwan, Guam, Thailand, Malaysia, and Indonesia

Roles and Responsibilities

• Providing timely support by answering user calls, understanding user problems and resolving technical issues immediately.
• Handled SMRs System modification requests by gathering user requirements.
• Handled BAU activities, worked on the closure of GPMS. Participate in the COB activities.
• Develop monitoring / Automation scripts to ensure efficient follow up and timely resolution of user queries and Support activities.
• Ensuring the completeness of the End of day Batch runs and resolve the issues and fix the aborted jobs during the Batch run. Automated the EOD Batch
• Design the Adhoc Crystal reports requested by the Users and Train the users to design and use the Crystal reports.
• Following the Change management and Version management processes using the tools like Infoman, Intellect Vault and Intellect Solve while deploying the application.
• Worked with various teams during the course of the project as part of the application support.

Environment - VB 6.0, Oracle 9i, Seagate crystal reports version 8.0, 10.0, HP-Unix 11, Windows 2000.

Confidential

VB, Oracle PL/SQL developer and Support

• CPB-ESP stands for Citigroup Private Bank - European Strategic Platform. This project covers 4 geographical countries, viz-a-viz Switzerland Confidential
• Jersey and the United States of America. A rollout of the International Banking Systems -Enhanced Banking System IBS/EBS will be required to replace the existing Multi-branch system. The ESP project helps the Europe booking centre both to reduce cost and to leverage the global capabilities of Citigroup - supporting one of the strategic goals of the Confidential

Roles Responsibilities

• Involved in Development, SIT, UAT and Implementation phases.
• Design and develop the front end report forms in VB, design the crystal reports and write the backend Oracle 9i Stored Procedures, functions, design and create the backend work tables.
• Interacted with the Co-Application teams and the Users for the requirements in various phases of the project like UAT and PAT.
• Handled project roll out activities and managed version control.
• Adhering coding standards as per the CMMI level standards, following process and version control.
• Preparation of the test cases, test plan and the IUT of the Module assigned. Worked on PCRs

Environment - VB 6.0, Oracle 9i, PL/SQL developer, Seagate crystal reports version 8.0 HP-Unix 11, Windows 2000.