Oct 2018 – Jun 2022 · 3 yrs 8 mos

Jul 2014 – Sep 2018 · 4 yrs 2 mos

Dec 2012 – Jun 2014 · 1 yr 6 mos

Jul 2010 – Dec 2012 · 2 yrs 5 mos · New York, NY

• Requirement analysis, architecture, design, and creation of database objects in Oracle database. Responsible for developing and supporting programs which load numerous supplies with huge volume, develop/support applications to calculate exposures for various clients and reporting appliations. Also support reference and Market Data applications using Oracle and PL/SQL. Performance Tuning of the applications, database and for many user ad-hoc queries

Mar 2010 – Jul 2010 · 4 mos

• Responsible for supporting few applications, which are used for reporting of Securities management, holdings, Capital Management and hedge funds.

Jun 2007 – Dec 2009 · 2 yrs 6 mos

• Lead Developer for supporting major AIG Investments applications which are used for data warehouse, Securities management, holdings, pricing, equities/fixed income, performance management and Capital Management. Responsibilities include Development, Design, Analysis, PL/SQL complex coding, perfomance tuning, ETL development, testing.

Jan 2007 – Dec 2012 · 5 yrs 11 mos

Jan 2006 – Jan 2007 · 1 yr

• Lead developer responsible for managing all database objects, write complex PL/SQL code to support OLTP data and batch jobs for award calculation of securities to preferred and non-preferred bidders through auction. Also data modeling of logical and physical diagrams and reverse engineering of database to capture all latest changes and deploy on various environments. Key activities PL/SQL development, application DBA, Data Modeling, Performance Tuning.

Jan 2001 – Jan 2006 · 5 yrs

• Responsible for managing offshore team, sole responsibility of managing database objects, writing complex PL/SQL code for application, reports and batch jobs.
• Interaction with managers and users across the globe to resolve their queries/issues for data. Key activities development, data analysis, data maintenance and administration to some extent.

Jan 1999 – Jan 2001 · 2 yrs

Jan 1998 – Jan 1999 · 1 yr

• Write computer programs to manage inventory of the stock.
• Keep track of sales, delivered goods and pending delivery using software tools.