SUMMARY

• 8+ years of corporate IT experience in design, development and implementation of client-server applications/products.
• Worked as Senior consultant in Oracle Financial Services (Formerly I-flex Solutions) since October 2005 and contributed to implementing Flexcube product for banks across the world viz., Vakif bank (New York), Silicon Valley Bank (California), Federal Home Loan bank (Pittsburg), Abu Dhabi commercial bank (Abu Dhabi, UAE).
• Functional expertise in various financial Flexcube modules like CASA (customer accounts & savings accounts), FT (funds transfer), Loans, Trade Finance, Retail teller, SMS (security management system) and Gateway interfaces.
• Good experience in Understanding and Managing Business Requirements.
• Responsible for preparing the Gap Analysis & Requirements Traceability Matrix document for Flexcube implementation at various banks.
• Presenting Solution to the Client Requirements.
• Followed all the Quality Related Activities and Involved in supporting various QA teams.
• Capable of working in-group as well as independently.
• Worked as Onsite coordinator for Implementation of Flexcube at various Banks.
• Expert level engagement in conversion/migration of data from legacy to Flexcube using oracle database tooling.
• Oracle certified associate with extensive experience in Oracle PL/SQL Programming, Data Migration/ETL using oracle tooling viz., external tables, SQL loader, oracle Jobs on Oracle 10g/11g, Unix.
• Experience in DBA activities like maintenance of PL/SQL Stored Procedures, Constraints, Indexes, Views, Cursors, Triggers, Query Analyzer script, Database Backup, Recovery, DBMS_UTILITY, DBMS_STATS, DBMS_JOB, DBMS_Scheduler, Hints, Dynamic Sql, SQL Trace, UTL_FILE, TKPROF, Generating AWR Reports, DBA, Oracle Advance Queues.
• Conversant with software development life cycle (SDLC) methodologies.
• Work Authorization GC.

• Bachelor of Engineering
• Oracle Certified Associate (OCA) in database administration.

Oracle PL/SQL, SQL, Oracle 10g/11g, Oracle Forms, Oracle BIP, PL/SQL Developer, TOAD, SQL* PLUS, Oracle sql developer, SQL Loader, SQL Navigator, Oracle Apex, IBM Websphere MQ, IBM Websphere Application Server, Windows 2000 Server, Windows NT 4.0, Windows XP, Java, UNIX, Java, Quality Center, VSS,SVN, Sharepoint.

Confidential,Jersey city, NJ Aug 15 – Current
(Flexcube Senior consultant)
As part of Citi group’s global Flexcube rollout program, i’m currently working for FC rollout Brazil, Columbia. Involves in identifying gaps, writing functional requirement documents (giving use cases, UML diagrams etc), high level design, development, unit testing, support to SIT, UAT.
Current day to day activities involves database design, development, preparing the schema definitions (XSD), Catering the services of external system requests etcs for all the requirements for BZTE.

Confidential, Dec 11 – Jun 12
(Sr. Software Engineer)
Client: Confidential,
Part of the development and DBA team responsible for database maintenance and enhancements for Clinical trials IT product suite of Merck & Co.
Responsibilities:

• Responsible for performing DBA activities viz., daily backup & recovery on Oracle databases.
• Responsible for data analysis, transformation & data migration using SQL Loader.
• Responsible for oracle job scheduling and maintenance for extranet vendor data feeds into the clinical trials system
• Responsible for troubleshooting/debugging oracle pl/sql to identify and resolve data integrity issues.

Confidential,Edison, NJ Oct 05 – April 11
(Flexcube Senior consultant)
Confidential,FlexCube suite which includes solutions for core, corporate, retail, internet banking among others is preferred by more than 390 financial institutions in over 125 countries.

Client: Confidential,New York, NY July 10 - April 11
(Flexcube Senior consultant)
Key contributor to oracle FLEXCUBE implementation, at Confidential,NY for various functional modules viz., FT(Funds Transfer) Core, CASA (Current and savings accounts) , Loans, Retail teller, Trade Finance, Money market , Interaction with Flexcube Direct Banking, EMS (Electronic message service), STP (Straight Through Processing).
Responsibilities:

• Responsible for provisioning Flexcube.
• Gathering requirements from the client for Interfaces and Flexcube.
• Analysed change requests for the existing bank systems.
• Understanding the client requirements and analysing the requirements with that of Flexcube and involved in preparing Gap analysis and Requirements Traceability Matrix.
• Presenting Solution to the Client Requirements.
• Followed all the Quality Related Activities and Involved in supporting various QA teams.
• Capable of working in-group as well as independently.
• Participated in Business meeting for understanding client must-haves.
• Assisting System Analyst in converting Business Requirements into Functional Specification.
• Onsite coordinator.
• Presenting solution to the Requirements.
• Follow all the Quality and Process related Activities.
• Preparing Use Cases and Assisting QA team for User Acceptance testing.
• Creating change requests in Quality Centre and follow up from development phase to testing phase.
• Involved in all the phases of Software Development Life Cycle.
• Designed & developed client specific product customizations through Oracle PLSQL programming, Oracle 11g, UNIX.
• Responsible for performing DBA activities viz., daily backup & recovery on Oracle databases during implementation.
• Responsible for configuring and testing both Universal Banking Solution (Flexcube) and Direct Banking Solution.
• Responsible for data analysis, transformation & data migration using SQL Loader and/or macros to replace bank’s current/existing information system (I-Bank) with Flexcube on Oracle 11g, Unix.
• Customized/enhanced the product by designing & developing client specific reports using Oracle BIP.
• Responsible for troubleshooting/debugging oracle pl/sql to identify and resolve data integrity issues during User Acceptance Testing.
• Responsible for provisioning and overseeing daily End Of Day(EOD) banking processes and Job scheduling during User Acceptance Testing.
• Proactively conducted oracle PLSQL unit/regression testing for Flexcube modules before every client hand-off.
• Direct interaction with client to mitigate unforeseen issues during user acceptance testing.
• Involved in sustaining engineering to support go-live issues.

Client: Confidential,Santa Clara CA July 09 - July 10
(Flexcube Senior consultant)
Contributed to Flexcube implementation at Confidential,CA, by taking ownership for requirement gathering, analysis , design, development and implementation of ODS(offline data store) interface in an oracle database which was critical to smooth implementation of end user reporting modules.

Client: Confidential,Pittsburgh PA Mar 09 - June 09
(Senior consultant)
Contributed to implementation of the product and was part of user acceptance testing and sustaining engineering.
Responsibilities:

• Involved in deployments for Flexcube - CORE product implementation.
• Gathering requirements from the client for Interfaces and Flexcube.
• Analysed change requests for the existing bank systems.
• Understanding the client requirements and analysing the requirements with that of Flexcube and involved in preparing Gap analysis and Requirements Traceability Matrix.
• Presenting Solution to the Client Requirements.
• Follow all the Quality Related Activities and Involved in supporting various QA teams.
• Capable of working in-group as well as independently.
• Developed the data interfaces through oracle Pl/Sql, Oracle 10g/11g, UNIX.
• Responsible for testing and implementation of interfaces.
• Responsible for Oracle Job scheduling.
• Conducted Unit Testing for Flexcube modules viz., BAI, PSGL and ODS interfaces.
• Web service deployment (Customer information inquiry, account inquiry, loan status etc.
• Direct Interaction with client to solve Technical Issues and UAT Data Issues.
• Involved in sustaining engineering to support go-live issues.
• Participated in requirements gathering for understanding client must-haves.
• Prepared design documents, program specifications and unit test cases as per the functional Specification.

Client: Confidential,UAE Mar 07 - July 08
Contributed to FLEXCUBE XML Gateway (FLEXML) which is a common channel for data exchange between FLEXCUBE and any External system. This data exchange can happen via delivery mechanisms such as online interfaces (Queue based, API based, Support for XML and ASCII message, Feasibility to transform xml messages using XSLT) and Batch Interfaces (ASCII files) Worked with the interfaces like CCS (Cheque Clearing System), IVR, SMS etc.
Responsibilities:

• Participated in requirements gathering for understanding client must-haves.
• Prepared design documents, program specifications and unit test cases as per the functional Specification.
• Point person for review & deployment of Flexcube - CORE oracle pl/sql product customizations using Oracle 10g on Unix Platform.
• Responsible for deployment & testing of Universal Banking Solution and Direct Banking.
• Direct Interaction with client to solve Technical Issues and UAT Data Issues
• Involved in sustaining engineering & user acceptance testing.

Client: Confidential,Bulgaria Nov 06 - Mar 07
(Oracle Consultant)
Took the ownership in design & development of product customizations involving Oracle Pl/sql programming, for the client must-haves in payments module of the Flexcube product
Responsibilities:

• Prepared the Program specification and unit test plan for Oracle PL/SQL product customizations.
• Developing new oracle forms to do Multiple Payment Upload.
• DBA support for deployment product customizations.

Client: Confidential,USA Oct 05 - Nov 06
(Oracle Consultant)
Contributed to FLEXCUBE XML Gateway (FLEXML) which is the common channel for data exchange between FLEXCUBE and any External system. This data exchange can happen via delivery mechanisms such as online interfaces (Queue based, API based, Support for XML and ASCII message, Feasibility to transform xml messages using XSLT) and Batch Interfaces (ASCII files).The bank uses Oracle Financials General Ledger (OGL) as a central repository for hosting the banks general ledger. Hence all the entries posted to the Flexcube’s GL during the day needs to be consolidated. It was required to generate a daily ASCII handoff from Flexcube to Oracle GL.
Responsibilities:

• Interface implementation (Queue set up activities using IBM Websphere MQ).
• Creation of database schemas. FLEXML (INTERFACE) and FCC (FLEXCUBE) schemas have to be setup and FLEXML schema should communicate with FCC (FLEXCUBE) schema for completeness.
• Preparing design documents, program specifications and unit test cases as per the Functional Specification.
• Deployment of Bean on IBM Websphere Application server.
• Creation of database objects (package, tables, synonyms, views), SQL, PL/SQL, Oracle 10g on UNIX.
• Interface screen design using Forms builder.
• Schema set up for the test environment.
• Preparing design documents, program specifications and unit test cases as per the Functional Specification.

Confidential,USA - Bangalore India Jan 05 - Oct 05
(Oracle Developer, Junior DBA).

Project: Change Control Service Manager Jan 05 - Oct 05
Co-developed the persistence tier in PL/SQL for the product that supports the IT change control process.
Responsibilities:

• Prepared design documents, program specifications and unit test cases as per the Functional Specification.
• Creation of database objects (procedures, Packages, triggers….)

Performed statistical analysis using query stats through