Experience Summary

• Over 7.5 years of Experience with 1.5 yrs. US exp in software.
• Exposure to client side with Onsite Co-coordinator profile for International Bank.
• Active contribution in all phases of software development life cycle from initial requirement gathering to design , coding , testing and implementation.
• Worked with Leading Clients from Banking Domain such as JP Morgan Chase, Credit Suisse, and First American Financial Corporation.
• Expertise in Oracle SQL, PL SQL and Performance Tuning.
• Worked on different Oracle version 9i, 10g and 11g
• Worked on Advanced Oracle concepts as Nested Tables, Varray , Ref Cursors and Bulk Collections
• Knowledge of Data warehousing Concepts , Sybase and UNIX Commands
• Performed SQL Performance Tuning, which includes concepts like B- Tree Indexes, Bit Map Indexes, Function Based Indexes, Materialized Views, and Bulk Binding.
• Developed Functions, Packages, Cursor, Stored Procedures, Views and Triggers.
• Proficient in SQL, PL/SQL, Query Optimization using optimizer hints, Explain plan, MV and FBI etc
• Worked on Dynamic SQL, Global Temporary Tables, PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect as performance improvement process.
• Have good knowledge of Data Warehousing concepts as Star Schema, Fact Tables and Dimension Tables.
• Exposure to Reporting tools such Cognos and OBIEE
• Exposure to Sybase, SQL Loader, and UNIX Commands.
• Worked on Various Database Tools like TOAD, SQL Developer, PL SQL Developer, Rapid SQL and SQL Advantage.
• Possess exceptional communication skills and the ability to develop high performances projects.
• Worked on Version Control Tools as VSS and SVN

Experience

Working with Cognizant Technology Solutions - From Jan 2007 Till Date

Technical Skills

Operating Systems

Windows 2000/2003/2007/XP, UNIX

RDBMS

Oracle 11 g , 10g and 9i

Tools

PL/Sql Developer ,SQL Developer , TOAD, SQL advantage ,Rapid SQL etc

Programming Languages

Oracle SQL and PL/SQL

Version Control

VSS , SVN

Familiarity with

UNIX,Sybase,Dot Net , Db2 and Oracle APEX , Informatica

Relevant Project Experience

Confidential

Client

Confidential

Application

Confidential

Technology

Oracle 11g and UNIX

Duration

Confidential

Familiarity

Oracle APEX

PROJECT SUMMARY

Confidential stands for Bank Data Repository .This Application serves as Bank data Warehouse system. It acts as a center Data repository for all the Reports and Ad Hoc Data Request.

It uses Technologies as Oracle Database, UNIX Shell Scripting and Oracle APEX. It receives data from all the various sources, defines transformation and loads selected data in to the Warehouse. It also builds Materialized Views that provides access to Data.

TECHNOLOGIES

Oracle 11g, UNIX and Oracle APEX

REPONSIBILITIES

Perform Data Base Development

Data Modeling and Data Validation at the root level

Involved in Requirements Gathering and Creating Business Requirements Document

Developed complete flow of File transfer from Source To Destination

Creation of Views , Stored Procedures , Packages , Materialized Views

Confidential

Client

Confidential

Application

PMTM Project Management Tool Modernization

Technology

Oracle 11g

Duration

Confidential

PROJECT SUMMARY

PMTM is Project Management Tool Modernization it is a front end application which enables users to View reports. These reports were earlier created in GEMS Database, which is old database. This project mainly involves migration from GEMS database to New Database called as AMSRP. GEMS receive data from EAGLE PACE DB there are various Upload and export jobs which sends data from GEMS to PACE. In this migration Data stage jobs load data from GEMS to AMSRP. The entire database Objects are newly constructed in AMSRP.

Data stage jobs are mainly of two types, one which loads the historical Data from GEMS to AMSRP and another one which load current data from GEMS to AMSRP. OBIEE reports are created on new tables in AMSRP. These reports are enhanced with new features and are generated very fast. This gives users new and improved reports with much faster speed

TECHNOLOGIES

Oracle 11g

REPONSIBILITIES

• Responsible for Oracle Database Development
• Created low level design docs for Data stage Jobs
• Involved in the Requirements walkthrough sessions with the Business
• Understanding the existing Database in order to make new database model.
• Analyzing the new requirements and estimation of the Efforts accordingly.
• Prioritize outstanding defects and system problems, ensuring accuracy and deadlines were met
• Involved in delivery of Deliverables on time for various releases.
• Performed Performance Tuning on queries and jobs
• Worked on High Volumes of Data , in a Data Warehousing System
• Exposure to Data Warehousing Concepts.
• Creating Data Model , Partioning Tables , Indexing , using Collections for development
• Design Doc creation.
• Fix the production defects

Confidential

Client

Confidential

Application

ARMS Account Relationship Management System

Technology

Oracle 11g Dot Net

Duration

Confidential

Familiarity with

DoT Net

PROJECT SUMMARY

ARMS is the Account Relationship Management system, a front office private banking application for High Net Worth Individuals that creates and manages client's profile and all the accounts created legally for Credit Suisse.

In ARMS, RMS is Relationship Management System i.e. Client based system which manages clients at relationship level by introducing client opening process over the account opening process to improve and streamline the delivery of the Credit Suisse 'On Boarding' process.

Client/Account creation is done through the various stages and requires approval at various levels. Client/Account could be either approved or rejected at every level.

TECHNOLOGIES

Oracle SQL, PL/SQL and Dot Net

REPONSIBILITIES

• Solely handling the Database Development
• Involved in the Requirements walkthrough sessions with the Business
• Re Designing and construction of the current workflow which majorly involves DB changes.
• Analyzing the new requirements and estimation of the Efforts accordingly.
• Complete construction along with Design Doc creation.
• Performance Tuning on the Application and various sections which run slow or cause higher response time.
• Used Tkprof for Performance Tuning
• Creation of Unit Test Case Document
• Fix the production defects , and mainly the sync job related changes
• Performed Unit Testing and resolved the defect during SIT /UAT phase

Confidential

Client

Confidential

Role

Team Lead

Application

P2P Implementation

Technology

Oracle 10g

Duration

Confidential

Familiarity with

ODI Oracle Data Integrator

PROJECT SUMMARY

First Confidential is joining the Oracle Fusion Early Adaptor program EAP for implementation of Procure to pay processes. Cognizant is providing implementation services to replace existing ARIBA procurement system, consolidate procurement functions, and integrate other procurement tools using Oracle's Fusion procurement

Phase 1: Fusion Implementation

1 This phase will implement the P2P process.

2 PO only related transactions

TECHNOLOGIES

Oracle SQL, PL/SQL, ODI, UNIX

REPONSIBILITIES

• Understood the Business Requirement from the Client
• Designed and Developed the Approval Process for Requisition in Oracle 10g.
• Developed complex Procedures and Packages using various Oracle advanced features.
• Understood the ERP implementation concepts related to HRMS and Procurement
• Created MD070 Technical Specs for the requirement of Requistion Approval.
• Created the ODI Interfaces to transfer data from CSV file to Table
• Performed Unit Testing and resolved the defect during SIT /UAT phase

Confidential

Client

Confidential

Role

Team Lead

Application

Core Logic

Technology

DB2 , Informatica

Duration

Confidential

PROJECT SUMMARY:

Core Logic is the leading provider of the following Information solutions-

Property data, Mortgage risk analytics, Tax monitoring and flood determinations, Risk mitigation solutions, Employment information services Credit information.

Core Logic balances the information, updates database with payment information, and forwards the information and payment to the Taxing Authority.

TECHNOLOGIES

DB2, Informatica

REPONSIBILITIES

• Team lead for 5 people at offshore.
• Requirement gathering from the Business People and transform those into low level design documents.
• Involved in the data validation process and reported the data discrepancies to the data vendors
• Performed data analysis on various types of files in Mainframe and provided the design documents to developers.
• Worked on various jobs in Mainframes for correctly analyzing the file.
• Resolving the Defects raised during the SIT/UAT
• Have exposure to Informatica
• Verify the Data in Production
• Ensure timely delivery for various releases.
• Involved in the training session for the New Joiners.