PROFESSIONAL SUMMARY:

• Over 18 years of experience in the areas of Database Design, Development, Testing, implementations, operations and user training of various Software applications in Financial, Manufacturing and Commercial environments.
• Over 4 years of experience in ETL Informatica Power Center using mappings, mapplets, transformations, workflow manager and workflow monitor, etc. for loading, manipulating data, to ODS and Data Warehouse from flat files and Database files .
• Experienced in Oracle 11g, 10g, PL/SQL, Stored Procedures, packages, functions, Sybase, Netezza.
• SQL Performance tuning, Materialized Views, Analytical functions, used extensively TOAD.
• Unix, Perl, SQR, ControlM, Autosys job schedulers, Clear Case, Mercury Quality Center QC .
• Work on SDLC and agile methodologies depending on the project.
• Co - ordinate with the Business team, DBA team, Transformation Server team TS provides on-line Trading data, Informatica admin team and QA team.
• Excellent written and oral communications, Interface with users.
• Individual Contributor as well as Hands on Technical Lead to multiple Projects in multiple locations.
• Participation in production support 24 x 7 on call rotations

PROJECT DETAILS

Confidential

• Work extensively on Oracle Products, Netezza and Performance Tuning, Materialized Views and Analytical functions.
• Working on Data warehouse projects using DIM and FACT tables populating data from OLTP transactions of individual profile, email, subscriptions, products, segment, social media etc.,
• Working as hands on Lead database developer with Business Analysts, DBAs, Production Analysts Unix Admins.
• Worked on the backend development of new build for one of the prestigious clients.

ENVIRONMENT: LINUX, ORACLE, NETEZZA, PERL, PYTHON.

Confidential

Fixed Income Group

• Developed many Data Quality Reports using home grown DQ Framework, oracle packages, functions. Developed and maintained Informatica mappings to load data to staging and dimension tables.
• Responsible for small projects, performance improvements, bug fixes.
• Interact with the DBAs, Unix Admins, Informatica admins, and business users to resolve issues and participate in upgrades.
• Corporate Compliance Group uses the vendor product built on Database Layer Oracle 10g, java etc. for the surveillance by creating patterns or models based on the trading data. Responsible for Decom Project: The group was using four separate servers for running the models. The purpose of the project is to migrate all the objects and the data to a single server from the four servers. Successfully designed and wrote the export utility to export the oracle database data of Actimize from of one of the servers and eliminated one of the four servers as proof of concept.
• I created multiple models for FCM: These include models concerning Excise Discretion on Held Orders, Principal Trading for Affiliated Customers, Price Manipulations, etc. using agile methodology.

ENVIRONMENT: LINUX, ORACLE PL/SQL, PROCEDURES, packages, functions, NETEZZA, SYBASE, INFORMATICA, ACTIMIZE, AUTOSYS, CONTROL-M, PERL, XML, XSL.

Confidential

• Holdings Hub HH brings Holdings, Assets, kick trades and Corporate Actions and Pricing information from Accounting. Utilized vendor product GIM Global Investment Manager, to provide consistent and accurate start-of-day and end-of-day views of holdings data and Assets data to Boston based portfolio managers, traders and analysts, reflecting up-to-date executed trades, corporate actions, and last known US market closing prices. Provide data expertise and centralized business support model for holdings Data Warehouse.
• Developed the Fund Accounting module in Informatica Power Centor using mappings, mapplets, transformations, workflow manager and workflow monitor, etc. .
• Hands on individual developer and act as project lead when needed using Oracle PL/SQL, Informatica, unix, perl, autosys, writing TSD and TPD etc.,
• Hands on Technical lead for the re-design of ODS Operational Data Store and Data-warehouse projects with the responsibility of 2 resources each from US, from India.
• Worked on the UPGRADE of Vendor Product GIM.
• Maintenance and production support 24 x 7, writing Operations Doc etc.

ENVIRONMENT: AIX, ORACLE, STORED PROCEDURES, INFORMATICA, AUTOSYS, PERL, TS.

Confidential

• Performance and Data Policy P DP brings Pricing and Asset information from Accounting, holding breakdowns from Performance Attribution fund/portfolio only and other fund information from security reference databases and third party vendors. P DP also maintains a broad set of funds, portfolio and manager level information internally. P DP then manufactures performance and performance-based data e.g. standard period returns, risk measures for funds, benchmarks and peer groups. This data is designed to provide a high level look at HOW a fund has performed against benchmarks and /or peer groups.
• Responsible for development, maintenance and production support of P DP 24 x 7.
• Responsible for the Operations Day time Production support and testing.

ENVIRONMENT: UNIX, PERL, SYBASE, SQR, STORED PROCEDURES, INFORMATICA, AUTOSYS.

Confidential

• Hill Stores -Responsible for writing design documents for Interface of data feeds on Purchases Sales from RMS Retail Management System to MAKOROMP. Coded, tested PL/SQL, UNIX scripts.
• Motorola - ORACLE APPLICATIONS - Responsible for writing design document for Interfaces of Fringe Accruals, Vacation and Labor Accruals Reports and the creation of Journal Entry Transactions from their SAP Payroll to the Oracle Application. Coded, tested programs using Oracle Concurrent Manager.
• Private Health Care - CYCLE TAPES module of FACETS integrated Network and Medical Management System extracts information about the Provider, Contract, Participation, Location etc., This information is passed on to clients, who are Insurance companies. Responsible for the common functions, data extracts and Perl scripts of CYCLE TAPES.

ENVIRONMENT: UNIX, ORACLE APPLICATIONS, PL/SQL, SQL LOADER, SQL PLUS, SYBASE, ORACLE, PERL, SQR

CONTRACTOR

• Dealer Web Locator is designed to provide a client with the ability to find the nearest location of the Dealer. The Monster Board is a www based application which provides Internet users an opportunity to look for various employers offering jobs.
• Responsible for Development and Maintenance of Dealer Locator including the PL/SQL scripts, Loading of Dealers production Data and the reports of Monster Board.

ENVIRONMENT: SUN AND DEC ALPHA, ORACLE 7.3, UNIX, PL/SQL, PRO C, PERL, HTML.

Confidential

• Referential Integrity RI Tool checks for the Child Foreign keys to Parent Primary keys and Allowed Values constraints.
• Responsible for extensive development, product testing and implementation and support of RI. The RI tool handles a volume of 75,000,000 rows. Responsible for the development and maintenance of reporting module of Audit Trail Project.

ENVIRONMENT: SUN AND PYRAMID, ORACLE PARALLEL SERVER, UNIX, PRO C, C AND SQR.