SUMMARY:

• 9 plus years of excellent hands on experience in Oracle, PL/SQL
• 3 plus years of hands on experience in Java, Sybase
• Proficient in Data Modelling, Data Migration and Performance Tuning activities
• Efficient programming skills using PL/SQL and Java
• Strong interpersonal communication skills and a dynamic team player

TECHNICAL SKILLS:

Development Tools: SQL, PL/SQL, SQL Loader, Shell Scripting

Java Technologies: JSP, JDBC

Languages: Java, XML, HTML, Java Script

Software Engineering Tools: PVCS, Clear Case, Rational Rose, Autosys

Web/Application Servers: OC4J

Databases: Oracle 9i/10g/12c, Sybase

Operating Systems: Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Whippany, NJ

Senior Oracle Lead

Environment: Oracle 12C, PL/SQL, SQL*Plus, Toad

• Interaction with Vendors in gathering/understanding the requirements
• Designed a common file template for vendors to receive the ODS data
• Implemented processes(Packages and Stored procedures) specific to each vendors requirement to extract the data and generate files.

Confidential, New York

Senior Developer

Environment: Oracle 12C, PL/SQL, SQL*Plus, PL/SQL Developer 11.0

• Interaction with Business Analysts in understanding the requirements
• Developed row level and statement level triggers to implement unique key constraint on member data avoiding mutating trigger error
• Designed tables and wrote packages and functions to implement oracle 9i feature Virtual Private Database(VPD) to implement advanced security
• Wrote stored procedures(Batch Programs) to auto apply payments to invoice transactions
• Used DYNAMIC SQL(Execute Immediate) to create backup tables and execute queries at runtime
• Wrote Stand alone Functions to calculate enrollment premium values
• Wrote overloaded functions to get EFT(electronic fund transfer) authorization data
• Created Nested and Index - bys tables to store array of data. Used BULK COLLECT to collect array of values.
• Used analytical function ROW NUMBER and PARTITION BY clause to convert data from rows to columns while retrieving medicare data for a member
• Wrote stand alone procedures for reporting requirements, Used REF CURSOR to return data for REPORTS
• Created Global Temporary tables to store intermediate processing data for reports
• Created User defined exceptions for customized program errors
• Used Explicit cursor to handle resultsets with multiple rows, Implicit Cursor attributes to check the status of the last SQL executed.
• Wrote datafix scripts to clean up duplicate data and to fix data which was incorrect in production
• Used DBMS STATS package to gather statistics on the tables and TKPROF utility for performance tuning,
• Brought down the execution time of previous cycle comp report to 15 mins which was originally taking 4 hours by creating Indexes, Using UNION ALL instead of UNION and removing NOT which is expensive on the optimizer
• Used FORALL and Bind variables to improve performance

Confidential,New York

Analyst/Developer

Environment: Sybase, Java, Linux

• Analyze requirements for each project in a release cycle and translate into technical solutions
• Extensive collaboration with other development teams
• Provide support for goldman.com business users
• Designed and developed Mortgage Project for Private Banking using Core java and Sybase. Wrote stored procedures to extract & process the mortgage data from reporting database and return the data through Java API using JDBC to private banking team for reporting on goldman.com website.
• Enhancements to Alternative Investments - Project to recompute the Contributions and Distributions using Fx Rates as of the flow date instead of current date in stored procedures
• Sedona Project - Retrieved Reportable and Non reportable income using stored procedures and returned the data to the front end team for Tax Center on goldman.com website
• Enhancements to Positions - Wrote logic in Sybase stored procedures to deduct the tax from different income buckets for a position in a portfolio
• Rewrote the Positions Stored procedures to reduce the number of stored procedures from 24 to 6, hence reducing the maintenance effort

Confidential

Senior Developer

Environment: Oracle 9i, PL/SQL, SQL*Plus, PL/SQL Developer 6.0

• Interaction with the client ( Confidential ), in understanding the requirements.
• Involved in design, development, implementation and testing.
• Writing high Quality System Use Cases after several quality discussions with the client on the Capital System
• Designing a schema(warehouse) to store the finance data, Developed E-R diagrams
• Developed data model to implement the Warehouse
• Developed New packages/procedures for the data upload requirements using PL/SQL
• Created Nested and Index-by tables to store array of data. Used BULK COLLECT to collect array of values.
• Created User defined exceptions for customized program errors
• Used Explicit cursor to handle resultsets with multiple rows, Implicit Cursor attributes to check the status of the last SQL executed.
• Wrote procedures for reporting requirements, Used REF CURSOR to return data for REPORTS
• Involved in writing SQLs which were highly tuned for performance. Hence reducing the response time to the users
• Responsible for writing PL/SQL batch programs which pulls data weekly from external systems called as eCAR and CATS and loads data in to Capital Optimization Oracle tables.

Confidential,Minneapolis

Senior Developer

Environment: Oracle 9i, PL/SQL, SQL*Plus, PL/SQL Developer 6.0

• Used DBMS STATS package to analyze the tables and Explain Plan, TKPROF utility for performance tuning,
• Used Range partitioning on a set of columns to partition the data to increase the performance
• Used Index, First rows and several other hints and changed the driving table to speed up the SQL execution time
• Creating Function based Indexes on the functions being used in the reporting SQL
• Brought down the report execution time by 40% for six reports

Confidential

Developer, Onsite Coordinator

Environment: Data Modelling, Oracle 8i, PL/SQL, SQL*LOADER, SQL*PLUS, JSP, Javascript, Java, JDBC, HTML, XML, OC4J, Rational Rose, Linux, Shell Scripting

• Had been the onsite coordinator for Data Migration Requirements interacting with the client directly and co-ordinating with a 4 member team in offshore for the data migration work.
• Had been the Functional Lead for the module Network Model(Models Gas transportation network)
• Involved in in-depth analysis of the various requirements of the users and have provided complete solution to the requirements
• Involved in Data Modelling, Data Migration, Data Fixes
• Extracted data from several legacy systems to intermediate staging database either through dblinks or through SQL Loader by loading into a CSV file
• Wrote PL/SQL scripts to transform data based on the functionality and loaded the data to corresponding Network model oracle tables
• Generated DML statements in Excel for loading data
• Wrote PL/SQL datafix scripts to fix incorrect data
• Responsible for designing interfaces for Network Model Maintainer application
• Used MVC pattern for developing applications
• Developed applications using JSP, Servlets, EJB and JDBC
• Also responsible for several validation components using java script which helped in increasing the productivity.
• User guides and explanation of the various terms and a quick guide on using the various objects were documented.
• Wrote highly tuned SQL scripts for select, insert, update into Oracle using JDBC
• Wrote UNIX shell scripts to call stored procedures and packages
• Active involvement in Database design, development and coding of Stored Procedures, SQL DDL, DML statements, functions and triggers using Oracle.

Confidential

Developer

Environment: Oracle 8i, PL/SQL, SQL, Cool: Gen, Unix

• Effective support to the SPA system
• Data Fixes to the existing SPA database using PL/SQL
• Code Fixes to the existing SPA application using Cool:Gen
• Monitoring of daily batch jobs
• Resolving TSM’s

Confidential

Developer

Environment: Oracle 8i, PL/SQL, SQL, Cool: Gen, Unix

• Technical Design for the changes required satisfying the need to unbundle the Meter Reading Services, from Transco's perspective.
• Coding & Unit testing for the enhancements needed to the existing system.
• Actively involved in reviews for Technical Design, Code reviews
• Tuning SQL queries for performance