Summary:

• Sr. Oracle developer with extensive experience in analysis, data modeling, design, development for Insurance (Enterprise Risk Management) , Financial, Inventory and Film Distribution Industries; Extensive experience interacting with system users and gathering business requirements and Logical and Physical Data modeling and ETL implementation for data centric systems.
• Extensive experience with Credit Derivatives, Swaps, Swaptions, Options, Trade/Counterparty level MTM/future Exposure Calculations, Fixed Income (Bonds) calculating index data, summary for different products such as commodities, ABS, MBS, High Yield, Callable & Puttable bonds, Retail Banking (credit & debit, private banking), FX and Corporate banking projects. Understanding of Reference data like Instrument, Accounts, Market data like prices etc. Custom Applications like Counter Party Exposure, Counter Party Risk.
• Experienced with Sales Forecasting (Actual vs. Projected sales analysis) & Prediction analysis.
• Expert in PL/SQL procedures, functions, packages, Monitor and assist onshore/offshore development team, assign tasks, and verify code. Complete SDLC -- Waterfall, Prototyping, RAD approaches
• Involved in Conceptual/Logical/Physical data modeling, ETL design and implementation.
• Wrote complex SQL, Procedures, Functions, Triggers, Cursors in Oracle and Performance tuning techniques including partitioning and indexing strategies.
• Worked with AIX, Sun Solaris, Shell Scripts, get and put files from/to FTP servers Scripts to execute Datastage command line, stored procedures & SQL loader scripts.
• Used AutoSys, Control-M tools to create jobs dependencies and schedules. File watcher & token files job orchestration.
• Involved in Data Architecture and Design, ER Modeling, ETL, Business Problem Analysis
• Involved in all phases of SDLC (requirement analysis, design, development and testing) for the projects of AIG – ERM.
• Have utilized Risk Tools like Algorithmics Risk Suite (v4.6.1)
• Used reporting tools like crystal Reports 2008 and 10, BOXI server
• Performed Business Problem Analysis, Mapping document, Identify Data discrepancies, Create Data Flow Diagrams, Analyze Information flow between systems, Test Plans

Professional Experience:

Confidential,New York, NY Feb 2011 - Present
(Enterprise Risk Management Group)
Project: Credit Portfolio Manager (Credit Risk Management)
Description:
Credit portfolio provides multiple measures of AIG’s credit risk to support applications such as portfolio management, capital allocation and Solvency II.

Credit portfolio model provides an aggregate view of an institution’s credit risk profile and the potential losses the institution may face due to these risks as well as an understanding of concentrations and marginal contribution of positions to aggregate risk.

Moody’s KMV RiskFrontier is an industry standard for measurement of credit risk that takes into account
Internal and/or external credit rating, Portfolio concentrations and correlations, Impairment and migration risk. This tool calculates economic capital for credit risk – a foundational measure of risk employed across multiple applications
Responsibilities:

• Involved in Analysis, Design, development, testing and production support for enterprise related databases.
• Involved in High and detail level design activities including indexing, partitioning for optimal performance.
• Point of contact for Data Integration for Phase 3 and 4 Development.
• Phase 3 is mainly related to business enhancements.
• Phase 4 is to simplify the architecture of the in-house application based on the use cases that users identified as necessary
• Involved in Data Modeling and Database design using Erwin.
• Provided Quarterly support for AIG ERM for credit risk.
• Wrote complex procedures, functions using analytical functions, Query tuning, explain plan, hints
• Converted the long running (ETL) datastage jobs to Oracle and implemented the business logic in Oracle PL/SQL (oracle 11g)
• Implemented sql loader scripts to load the data in database on UNIX environment.
• Designed database to provide multiple users to be able to run portfolios
• Ability to the users to be able to view the supporting, counterparty, instrument and portfolio related information before pushing it to Risk Frontier
• Significantly improved the time taken to create a portfolio and load the data it to Risk Frontier (compared to existing production instance)
• Developed autosys jobs to run the batch process in UNIX server.
• Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
• Experience of credit and market risk reporting
• Involved in Unit Testing and data validation
• Provided UAT support during testing deployment and User testing.
• Wrote reconciliation queries to validate the use cases in QA/UAT/PROD.

Environment: Oracle11g/10g, Datastage , PL/SQL Developer, Erwin, AutoSys, Moody’s KMV RiskFrontier.

Project: Confidential,Risk Analysis (Market Risk Management)
Description:
Confidential, is the platform to provide the MTM values and generate VaR reports based on Historical/Basis points/MC scenarios over the defined Asset classes from AIG BU.This project extracts the data from Bloomberg over the instruments, positions and calculate the scenarios using the market models defined by AIG ERM.
Responsibilities:

• Involved in development of applications using Algo Risk Suite.
• Involved in Analysis, Design, development, testing and production support for enterprise related databases.
• Involved in High and detail level design activities including indexing, partitioning for optimal performance.
• Assisted DBAs in physical implementation
• Wrote complex procedures, functions using analytical functions, Pipelined functions, Query tuning, explain plan, hints
• Developed interfaces to load instrument and positions data, and incorporated the business logic using ETL to load the Raw data
• Developed shell scripts to load the Risk Watch data into Algo UDS data.
• Developed different instruments, market model data using SQL scripts and Risk watch scripts in CSV format. Involved in building data dictionary objects.
• Developed autosys jobs to run the batch process in UNIX server.
• Implemented sql loader and perl scripts to load the data in database on UNIX environment.
• Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
• Experience of credit and market risk reporting
• Wrote Shell scripts using sed, awk, grep, comm etc
• Involved in Unit Testing and data validation
• Involved in Migration planning as projects moved along SDLC

Environment: Oracle11g/10g, Datastage , PL/SQL Developer, AutoSys, Algo Risk Suite (Risk watch (RW), Algo Batch Editor (ABE))

Confidential,Tampa, Florida Oct 2008 – Feb 2011
Project: Confidential,
Description:
In The web application, employees will enter their expense report information. This system will include data required for passing the accounting entries to the Local Ledger, and the information required for passing the payment information and also the Credit Card number of the employee, if applicable. (Web T&E does not hold any banking information). Required data will be passed through Procure to pay system.
Responsibilities:

• Developed Unix Shell Scripts to automate back end jobs, loading data into the Database using SQL* Loader
• Wrote QL scripts to create objects like tables, views and sequences
• Designed and developed PL/SQL functions / stored procedures / cursors / packages / triggers
• Used SQL loader to convert/load the data from the files to oracle tables and vice versa
• Involved in writing complex queries to generate reports as per client request as a part of production support
• Wrote Job Information Language (JIL) scripts to create Autosys jobs
• Involved in conversion of project from Visual Basic to Oracle
• Involved in Optimization of SQL queries
• Involved in the continuous enhancements and fixing of production problems
• Resolved errors reported during system test and user acceptance test
• Coordinated with onsite team in resolving the issues in live environment
• Coordinated various levels of teams to resolve the critical issues of the application
• Involved in Implementation of change requests in live environment after successful migrations
• Involved in Understand existing business model and client requirements.
• Created Minor development documents and Release Notes for all development activities
• Created unit test cases of the each release with respect to user requirement documents

Environment: Oracle 10g, toad 8.6.1, SQL Developer, AutoSys, Visual Basic, Core Java

Confidential,Los Angeles, CA Oct 2005 – Oct 2008
Project: Confidential,
Description:
Confidential, is one of their Legacy systems, used for automation of Finance and Administration divisions. It handles the Contracts, Payments and Distribution Licenses etc. It is the main system of the 20th Fox business’s International Television Distribution.
Responsibilities:

• Created Procedures, Functions and packages using PL/SQL
• Wrote SQL scripts to objects like tables, views and sequences
• Developed the reports using Crystal Reports
• Involved in the continuous enhancements and fixing of production problems
• Deployed the reports in Crystal APS and updating the settings using SSH
• Involved in writing complex queries to generate reports as per client request as a part of production support
• Involved with the various levels of Leads for gathering requirements and analysis
• Involved in Unit testing of the application and user requirement documents.

Project: Confidential,
Description:
Confidential,is a custom developed, web-based Material Servicing Application which facilitates the accurate requisition of materials, the creation and monitoring of lab orders and dispatching and tracking of the broadcast materials that are sent and received back from TVD customers.
Responsibilities:

• Created Procedures, Functions and packages using PL/SQL
• Wrote SQL scripts to objects like tables, views and sequences
• Involved in Query optimization for the SQL queries those are executed by business users
• Developed the reports using Crystal Reports
• Involved in the continuous enhancements and fixing of production problems
• Deployed the reports in Crystal APS and updating the settings on SSH
• Involved with the various levels of Leads for gathering requirements and analysis
• Involved in UAT/PROD support for major releases in the project
• Involved in Unit testing of the application and user requirement documents.

Environment: Java, Oracle10g, toad 8.6.1, Crystal Reports2008 and BOXI server

Education/Certification:
Bachelor of Technology in Computer Science and Information Technology