Developer Data

CHAVAN, SHAHAJI 551-***-**** *******@*******.***

OBJECTIVE Senior Application Developer

SUMMARY 12 years of IT experience.

** ***** ** ********* ** database design and development in terabyte data environment.

More than 8 years of financial domain experience in Equities, Fixed income, Bonds, Derivatives and Risk Management.

Worked on designing physical and logical data models using ERWIN and Visio.

Technical expertise using Oracle 12c/11g, PL/SQL, SQL, SQL Server Database, XML and JSON file processing. Knowledge of Oracle Private Cloud.

Strong experience using Python and familiar with Big data technologies – Hadoop, Hive and Scoop.

Design and development of ETL tools using Oracle, Pentaho and Informatica

Expertise in analyzing and tuning of SQL queries using Explain Plan and HINTS.

Good experience in data integration and migration using Oracle Export, Import, SQL*Loader, ETL, and data pump utilities.

Strong organizational, interpersonal competencies and problem solving skills.

Excellent analytical and logical skills to solve complex problems. SKILLS UNIX, Windows, SQL, PL/SQL, Toad, Oracle 12c/11g, SQL Loader, Python, Unix shell scripting, Control M Job Scheduling, XML/JSON file processing, Informatica Data Migration, Performance Tuning, Automation

WORK HISTORY JP MORGAN CHASE CO. ASSET MANAGEMENT

Senior Application Developer, Nov 2010 – Present, Consultant until Apr 2012 PRISM: A Portfolio management system used to manage and analyze client portfolio. This platform enables Orders, Trade and Trade confirmation, P&L, Position valuation and Reporting. A 4 tire application with Oracle database, Gemfire for caching, Middle layer for business logic and a dot net client application.

Manage a geographically dispersed team (3 locations) in support of the application suite. Infohub is a multi-terabyte data store that houses Reference, Market data, Asset, Accounts, Valuation, Benchmarks and Analytics. The trading application Minerva and the portfolio management system relay on the quality of infohub data.

Responsibilities

Analyze business requirements by engaging with the Business users.

Database design and development using ERWIN.

ETL design, development and enhancements using informatica.

Designed and developed applications packages, using Oracle object types, analytical functions, pipeline functions, collections, partitioning, ref cursors, procedures, functions and packages.

Optimize processes and SQL queries for performance.

Designed interfaces using Metadata to customize data loads and extracts.

Data Migration for historical Index into reservoir using python extractor.

Provide leadership and guidance to the team using refactoring and improve resiliency. Page 2 Chavan, Shahaji 551-***-**** *******@*******.***

User Support for production issues and adhoc queries. CONSULTANT TO CITI, MARLABS INC.

Program Analyst, Sep 2007 – Oct 2010

1. Risk Reporting DWH and Portfolio Management (Lead Developer) The Risk Data Warehouse was sourced from multiple systems with more than a terabyte of data. The data was transformed and distributed to various systems. Generated feeds for downstream systems. The Warehouse held financial data for Trades (Cash and Derivatives Assets), Securities, Bonds, Loans and Risk information derived from analytics. The Portfolio application provides customized portfolios saved for future reference and ability to slice and dice the data. 2. MIDAS – GCD Data Warehouse and Risk Reporting System. The Portfolio trading desk application receives trades and risk data from various sources and load into the warehouse in nightly batch, later this data is pushed into the OLAP Cube, which in turn is used for various reporting tools. GCD warehouse sizes around a terabyte and the Cube server all business reporting needs. OLAP tool, Cube browser sit on top of the OLAP Database for adhoc reporting needs. The project uses SQL Server Database 2005, stored procedure, and functions, Triggers, SSIS packages and SSAS development.

CONSULTANT TO ALLIANCE BERNSTEIN AND ERNST & YOUNG LLP, HEXAWARE TECHNOLOGIES Senior Technical Lead, Oct 2004 – Aug 2007

1. Asset Management DWH

Understand the business requirement and convert the same in the technical specification. Understanding the fundamentals of investment management, Financial Instruments like Equities, Stocks, Bonds, Derivatives, Securities, Trading and Portfolio Management. Manage the data feeds from upstream and to downstream systems. Support batch jobs and carry out optimization for the oracle processes to improve performance. Provide impact analysis and alternate solutions. Design and develop code using Oracle stored procedure, functions, packages, Trigger. Job Automating using PCS scheduling tool.

2. Engagement Reporting Development Rel2.0, Consultant to Ernst & Young LLP Study functional and high level technical specs to carry out the development work, brake down into small task for project management and tracking. Understand and provide impact analysis and alternative solution. Developing code using oracle stored procedure, functions and packages to handle the business logic. Automating the process using job card and job sequence for scheduling. 3. Global Finance Information System (GFIS)

Understand and analyze the new Business requirements and carry out the development. Developed complex business logic reports and procedures. Execute and enhance the ODS data processing. CONSULTANT TO GENERAL ELECTRIC, PATNI COMPUTER SYSTEMS LTD. Lead/Developer, Jan 2001 – Sep 2004, Consultant to General Electric - GE AE, GE TIP Fleet Management Operations (FMO) - GEAE

Communicate with the Client. Develop Interface to map the changed source. Testing and validation the data interface built for Oracle Projects and GL. Perform data Quality Check. SANA INTERNATIONAL WLL. BAHRAIN

Developer, Dec 1997 – Oct 2000

Page 3 Chavan, Shahaji 551-***-**** *******@*******.*** EDUCATION BACHELOR OF COMPUTER SCIENCE

POST GRADUATE IN COMPUTER APPLICATION

CERTIFICATION SIX SIGMA GREEN BELT CERTIFICATION

BRAIN BENCH CERTIFIED - ORACLE DATABASE

REFERENCES Available on Request

Contact this candidate