SUMMARY

• More than11 yearsof experience inDatabase Development,Data Analysis,Data MigrationandData Modeling.
• Adept in end - to-end development of software products from requirement analysis to system study, designing, coding, testing, documentation and implementation. Extensive experience inrequirement analysis,prototypingandtechnical design.
• Experience inOracle Developmentincluding table design, writing stored procedure, Database Triggers, Functions and PL/SQL packages. Strong knowledge of Oracle Cursor management, Exception Handling and SQL Loader.
• Proficient in Data Modeling of bothrelationalanddimensional(Star Schema, Snow Flake Schema) models usingErwin. Involved in design, implementation and change management of data models and data dictionary.
• Experience in high volume data migrations involving multiple data sources. Created source to target mapping documents, designed and implementeddata migration strategies.
• Worked on implementation ofData Warehouse, BI solutions and has a good understanding of Data Warehouse concepts, ETL, OLAP, Star Schema, Data Modeling using Normalization, Dimensional Data Modeling, FACT & Dimensions tables, Physical & Logical Data Modeling
• Worked on Process Improvement Initiative tooptimize build processesin Data Warehousing projects to identify conflicts in releases.
• Functional knowledge of Capital Markets (Securities trading, Portfolio Management) and Wealth Management and retail domains.
• Experience in preparation of deliverables; high and low level design documents, Systems Requirements Specifications, Solution and Integration Documents, Approach notes and Flow Diagrams.
• Extensive experience directly wif teh clients and gathering details of requirement, converting them into effective Technical design, providing end to end knowledge transfer and application training to clients and end users.
• Actively involved in successful Business Application deployment, production support.
• Strong analytical and programming skills wif good communication and interpersonal skills.

TECHNICAL SKILLS

Operating System: Windows XP, HP-UX, Solaris 9

Languages: SQL, PL/SQL, Pro*C, C++

Databases: Oracle 11g/10g/9i, SQL Server, DB2

Tools & Utilities: Toad, Erwin, PL/SQL Developer, Endeca, Cognos, Clear Case, WinCVS, SVN, TFS, Star Team

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Environment: Oracle 11gToolsToad, ER Studio, Star Team

Responsibilities

• Work wif Business Analysts to review and implement business requirements.
• Responsible for high and low leveldesign documents,Systems Requirements Specifications, Solution and Integration Documents, Approach notes and Flow Diagrams.
• Design, implementation, deployment, and support of teh Trading platform including Equity, Fixed Income related applications wifin teh Trading suite of applications
• For Client Onboarding;Data Analysisof source data. CreatedSource to TargetMapping documents, documented business and transformation rules and participated in working sessions and ensured full business participation throughout teh process.
• Design and implementation ofData Migration strategiesusing PL/SQL
• Design and implement tools for new clientdata profilingagainst many possible data sources, including single or multiple databases and/or files, as well as a single or multiple source systems.
• Identify and document business rules, dependencies, assumptions, risks, supportability, performance and training needs.
• DevelopUnit Test Scenarios,Unit Test Plancreation and reviews to ensure requirements coverage according to teh source to target mapping document. Ensure Test Execution and defect management
• Technical issue resolution and support Deployment of monthly releases and post release verification.
• Creatingcomplex SQL queriesfor fixing time critical issues impacting customer. Led a team of 4 database developers.
• Knowledge Transferto new staff on teh business process and system architecture to bring them at par.
• Nov’07- Oct’13 Genpact Headstrong Capital Markets, USA Principal Consultant

Confidential

Lead Data Analyst

Responsibilities:

• Analysisandmappingof client data sources to SEI standard implementation file formats
• Design and implementation ofData Migration strategiesusing PL/SQL
• Refine and implement processes and tools for converting existing SEI clients from legacy Trust 3000 system to GWP
• Design and implement tools for new clientdata profilingagainst many possible data sources, including single or multiple databases and/or files, as well as a single or multiple source systems. Socialize teh tools and associated processes wif teh technical teams.
• Optimizationof new client data conversion processes to meet GWP migration windows.
• Participate in teh GWP Implementation execution wif teh firm and SEI in a multi-vendor environment.
• Work wif SEI and firm to accommodate incremental client configuration additions and changes.
• Knowledge Transferto new staff on teh business process and system architecture to bring them at par.
• Onsite-offshorecoordinationand Led a team of 6 database developers and analysts

Confidential, New York

Sr.Data Modeler

Responsibilities:

• Work wif Business Analysts to understand teh scope of Data Warehouse.
• Creation ofDimensional data modelfor Enterprise wide Data warehouse usingErwin.
• Business rules validation through data analysis.
• Creation and maintenance ofData DictionaryandData Model.
• Source system data analysis for fitment into common data model
• Undertookprocess improvementinitiative to find and resolve conflicts in each release for smooth and error free release deployment.
• Design of Stored Procedures for teh CFS enhancement applications.
• Table Partitioningfor faster load process.
• AttainmentsAwarded “Team Order of Merit” by Headstrong
• Title Channel Transformation -1

Confidential

Lead Database Developer

Responsibilities

• Requirement analysis andProof of Conceptat client side in USA.
• Design ofDatabase Model (Relational)to accommodate Channel data and teh products they could sell.
• Writing technical design documents for database components andsearch engineimplementation.
• Led a team of 5 database developers.
• Coordination wif Partner Portal (third party) team for Channel Data.
• Design ofmigration strategyof Partner Portal data into preview database.
• Implementedsearch capabilitiesfor Partners usingEndecasearch engine Tool.
• Involved in reviews, Manual Testing, Integration Testing, Regression Testing.
• Single point of contact for Production support issues and queries.
• Actively involved in Requirement analysis, Prototype and Design phase at client side in USA
• Design and implementation of backend components fordata replicationanddata migration.
• Unit testing and Integration testing
• Packaging, delivery and support of teh application from database end
• AttainmentsAwarded “Cause for Applause” for exceptional individual performance
• Sep’04-Nov’07 Tata Consultancy Services, Gurgaon Assistant Systems Engineer
• Title Orbay Online Services (SIRE)

Confidential

Portfolio Management ServicesModule Lead

Environment Proc*C, Oracle 9i PL/SQL, Q++ (TCS Proprietary)

Responsibilities

• Responsible for understanding business requirements, accessing teh information needs of teh user and developing teh functional test cases.
• Carrying out impact analysis preparing unit test plans.
• Designing and coding teh application.
• Support for teh integration testing, ensuring completeness of teh testing.
• Coordinating wif onsite team.
• Developed services related to portfolio rebalancing, portfolio valuation and performance computation.
• Developed services dat report teh all teh transactions done by a customer in a given period.
• Developed Batch processes dat trigger rebalancing of portfolios based on certain strategic changes in teh model portfolio.