PROFESSIONAL SUMMARY:

• Over 20 years of experience in the software industry as a Team leader, Systems Analyst and Programmer Analyst with excellent knowledge, understanding and proficiency of the Full Project Development Life Cycle, including design, development, implementation, data manipulation, data testing, support and training.
• Experienced in ETL, including study of data models, large volume data transfer and data cleansing techniques used in a variety of applications such as Financial, Banking, Manufacturing, Payroll, Purchase, Sales and Distribution.
• I am committed to achieving both excellent customer relations and client satisfaction.
• Team player, highly results oriented, and a quick learner, who possesses excellent written and verbal communication skills.
• Experience on a variety of platforms including ORACLE 11g, 10g, 9i, 8, 7.x, PL/SQL, SAS V 9.1, SAS V 8.2, SQL*PLUS, UNIX, SHELL SCRIPT, SAP R/3, ABAP/4, COBOL, L INC.

TECHNICAL SKILLS:

LANGUAGES: ORACLE PL/SQL, SQL*PLUS, SAS v9.1, SAS v8.2,SHELL SCRIPT(KSH), ABAP/4, COBOL, LINCII, BASIC

RDBMS: ORACLE 11G,10G, 9i, 8, 7.3.2

ERP: SAP R/3.1H, SAP R/3 4.0 GUI

OS: UNIX, OPEN - VMS, VAX-VMS, WINDOWS NT, WINDOWS 2000, WINDOWS XP, OS/2 for MAINFRAME

PACKAGES: Oracle Enterprise Manager, Oracle Report Builder 6.0, TOAD, JDEVELOPER

Report Tool: Business Objects.

HARDWARE: AIX, HP-UX, Sun Solaris, VAX, UNISYS A-Series, IBM-PC compatible, MAINFRAME

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Senior Oracle PL/SQL Developer

Responsibilities:

• Senior Oracle PL/SQL and SQL Developer responsible for developing packages, procedures and views for ETL processes and post valuation processing of policy data for Liability warehouse.
• This include currency translation from Issued to functional currency and vice versa, calculation of differed acquisition cost, roll forward adjustment etc.
• Generate complex views using PolicyLInk data for reporting purposes.
• Utilized advance Oracle features like, Native Dynamic SQL, With Clause, UNPIVOT, LISTAGG function, CTAS and Exchange Partition.
• To keep track of the progression of the Procedures data was logged in log tables using Autonomous Transaction feature.
• Responsibilities included taking the ownership of the project and function as the lead, worked closely with the business group to understand their requirement, and make recommendations as required.
• The application were developed using Oracle 12C PL/SQL and SQL in Windows environment. Used SQL Developer as the development tool.

Confidential, NY

Senior Oracle PL/SQL and SAS Developer

Responsibilities:

• Senior Oracle PL/SQL, SQL and SAS developer responsible for developing package to download few hundred tables from SQL Server database over DB Link into Oracle database. One of the features of the procedure was to make it restart able after a failure, the progress of the load was logged in CONTROL DATA table using autonomous transaction.
• In support of the MARS actuarial project developed and modified SAS programs to load data from numerous external data sources, The requirement of MARS project is the row count and amount fields must match with the control file, the programs ensured prevention of data duplication. Windows .BAT files were modified to automate the load process.
• Developed numerous ETL processes using combination of Oracle, PL/SQL, SQL and SAS programs for data from various vendors like, CareMark, Value Options, HealthPlex.
• Responsibilities included taking the ownership of the project and function as the lead, raise data issues with the business, understand the requirement, and make recommendations as required.
• The development was done using Oracle 11G PL/SQL and SQL and SAS ver 9.2.

Confidential, Princeton, NJ

Lead Oracle PL/SQL Developer

Responsibilities:

• Senior Oracle PL/SQL Developer, responsible for modifying and developing DDL and SQL scripts to support the annual Rollover of table partitions to history and archive tables for their ETS Information Bank system which serves as data warehouse to the user for their analytical study.
• Converted COBOL programs to ORACLE PL/SQL and SQL code to speed up data load. Used features like WITH clause and INLINE hint to improve the query performance.
• Responsibility included understanding the ETL process, study the flow of the existing Autosys jobs and Linux shell scripts developed for the ETL process. The development and modifications are made using SQL and PL/SQL in Oracle 10G using Toad in Linux environment

Confidential, Jersey City, NJ

Senior Oracle 10G PL/SQL Developer

Responsibilities:

• Senior Oracle PL/SQL Developer, responsible for developing packages, procedures, functions to load data from the operational data store to Oracle Database for their Fund Accounting System.
• Developed views and tuned queries using hints like index, use nl, leading etc. to generate reports for the fund accounting system. Developed very complex VIEWS using scalar queries, inline views, and subqueries. Utility SQL scripts were develop to perform daily monitoring of the system and to replicate code modification across development, test and QA regions. Modified Unix scripts as per the requirement.
• As a production support team member monitored the delivery of the daily or monthly files after the fund audit closes. Numerous SQL scripts were developed to see the progression of files, e.g. queries to check which fund group has audit closed, pending messages for the event based files, etc. The task also involved troubleshooting issues in a timely fashion, manually regenerate files per clients request, execute Unix script to stop and restart stalled queues etc.
• The development or enhancements were made using Oracle 10g SQL and PL/SQL using TOAD in SunOS 5.10 environment.

Confidential, Skillman, NJ

Senior Oracle 10G PL/SQL Data Base Developer

Responsibilities:

• Senior Oracle PL/SQL Developer, responible for developing Alert Monitoring System and SU Munis Project.The Alert monitoring system generated alerts when problem tickets stayed unattended past a threshold period or stayed in transient state for more than the permitted time.
• The SU Munis project entailed loading the Municipal Securities data in to Oracle Database. The data came in as XML document that was transformed and used to populate multiple Oracle tables.
• Developed various objects like tables, indexes, sequences, procedure and functions using SQL Developer and Oracle PL/SQL 10G. The development effort included converting XML document to store data and generate XML document to feed Java program. Utilized BULK COLLECT operation and DYNAMIC SQL to provide flexibility and improve efficiency of the load process.
• The application were developed using Oracle PL/SQL on a Unix platform. The report development team utilized JAVA and C++ to enable user to create and maintain data for the SU Muni project. Completed the development task ahead of schedule.

Confidential, New York, NY

Senior Oracle 10G PL/SQL Data Base Developer

Responsibilities:

• Senior Developer responsible for development and testing of the ETL process that was developed to report activities of SMS messages transmitted from one carrier to another. The ETL process obtained the input from a range partitioned table on hour of the day and utilizing CTAS the data was loaded into a staging table and subsequently loaded in a date partitioned table, sub partitioned by hour using partition exchange. Every hour about 100 million Activity Records were loaded into staging tables taking less than 7 minutes.
• Using Oracle 10G developed Stored Procedures, Functions and SQL scripts for the ETL process and to test the loaded data. Developed bitmapped indices, local indices on sub partitions and statistics gathering scripts to enhance performance.
• Generated query execution plan using Explain Plan to see the optimal query path the Cost based optimizer has generated. Based on the query plan Index Hints were used if required and wherever appropriate Full tables scans hints where utilized to improve query efficiency. To optimize INSERT statement efficiency APPEND NOLOGGING hint was utilized.
• Developed anonymous block to generate test data to populate Activity records using nested tables and FORALL bulk insert statement. Multiple instances of anonymous block were executed to load data simultaneously into different hour of the range partitioned by hour Activity Record table. Utilized DBMS RANDOM.VALUE function to generate test data for some of the columns of Activity record. The development was completed as per schedule with great client satisfaction. Used SQLLDR direct path to alternatively populate Activity record table.
• All development was done using Oracle 10G PL/SQL and SQL. The report development team utilized the data to generate variety of reports using Confidential .

Confidential, Morris Plains, NJ

Analysis & Design Specialist

Responsibilities:

• Analysis and Design Specialist, responsible for providing all aspects of dimension load for their in house data warehouse for their Sales System utilizing the data that is initially extracted from SAP sales module and stored into the ODS Datamart.
• Data manipulation and data conversion was performed to adhere to business rules.
• Catered to adhoc client requirements to analyze the loaded data and research any discrepancies.
• Ensure data integrity .
• Responsibilities include gathering, understanding and analyzing the requirements and develop PL/SQL scripts to meet the requirement using HP-UX on Sun Microsystem.
• Developed ORACLE 10g PL/SQL PACKAGES, STORED PROCEDURES, FUNCTIONS and SQL SCRIPTS for dimension load. SQL scripts were developed to initialize the dimensions, test and compare the loaded data with the source data based on test plans and test scenarios.
• The PACKAGE to load dimensions where invoked using Unix Shell script. Utilized SUM and CASE functions to generate counts based on the value of fields to report discrepancies.
• Existing UNIX shell scripts were modified to invoke appropriate PACKAGE for various dimension loads. Study of the flow of UNIX scripts was made to make the necessary changes.

Confidential, Long Island City, NY

Senior PL/SQL Developer

Responsibilities:

• Senior Developer, responsible for providing all aspects of Confidential for the Strategy and Analytics group involving large volume of data. Generate analytic reports based on client requirements. Responsibilities included gathering and understanding the requirements and develop PL/SQL code to meet the requirement.
• Developed ORACLE 9i PL/SQL, STORED PROCEDURES, FUNCTIONS and SQL SCRIPTS.
• Developed SQL scripts to extract data from the database based on the user requirement. All PROCEDURES and FUNCTIONS were bundled in to a PACKAGE to provide capability to run all the MODULES within the PACKAGE with a touch of button. Utilized SUM and CASE functions to generate household level account balances and volume statistics used for analytical study.
• Embedded SQL within SAS programs were utilized to generate summary reports.

Confidential

Senior PL/SQL Developer

Responsibilities:

• Senior Developer, responsible for writing elaboration artifacts based on the inception artifacts, develop DDL scripts to create tables, Indexes, triggers, constraints and sequences to facilitate the conversion of an existing system to the new system. Developed SQL Scripts to extract data from the old system, transform and load into the new system. This included developing SQL scripts for DDLS, PL/SQL package, stored procedures, functions for the ETL process using ORACLE 9i and TOAD.
• Worked on a team to develop Data Warehouse based on Star Schema. SQL scripts were developed to load data into the various dimensions and fact tables for their Trade Structure Finance application.
• Also involved in assigning the development task to members in the team and verifying the code to ensure it meets the requirement and specification. Design test plans for Development, QA, Model and Production environment..
• Also catered to adhoc requirement for their Market Data System to load Historical data on commodity pricing and developed SQL and PL/SQL scripts for the Teams project to load French translations based on Short name of commodities. This task was achieved using Oracle 9i PL/SQL, Toad and studying the ER diagrams both physical and logical model to understand relationship between business entities.
• Confidential application will serve as a Front end tool to utilize the converted data.

Confidential, Long Island City, NY

Senior PL/SQL Developer

Responsibilities:

• Senior Developer, responsible for providing all aspects of Strategy Tagging programs and Thank You reward points program for Debit and Credit card user involving large volume of data. Cater to adhoc client requirements to generate reports.
• Responsibilities include gathering and understanding the requirements and develop PL/SQL code to meet the requirement.
• Developed ORACLE 9i PL/SQL PACKAGES, STORED PROCEDURES, PL/SQL SCRIPTS to add functionality to the existing online system for customers to access their account online.
• Used REF Cursors to enable the record set to be displayed online. Developed SQL scripts to extract data from the database based on the user requirement.
• Utilized MAINFRAME SAS to extract data from the DB2 database and generate EXCEL reports.
• Embedded SQL within SAS programs were utilized to aggregate account values by grouping them based on the requirement.
• Responsibilities also include executing and monitoring the programs.

Confidential, New York, N.Y

Senior PL/SQL, SAS developer

Responsibilities:

• Senior PL/SQL, SAS developer, responsible for the creation of database subsets used in campaign, Portfolio and Customer Value Management analysis.
• Responsibility included requirement gathering, understanding the requirements, occasionally provide recommendations on requirements.
• Subsequently Spec the requirements and develop programs to either enhance the current processes or build new programs.
• Automated the creation of reports used in tracking customer financial behavior and performed data extraction in support of modeling activities for the Portfolio Analysis Department. Additional responsibilities include Ad-hoc queries as requested. All development efforts were performed using a combination of Oracle PL/SQL scripts and various STORED PROCEDURES.
• Extensive use of the SUM and DECODE functions were used to generate customer level account balances and volume statistics used for analytical study.
• A combination of ORACLE PL/SQL scripts and SAS MACROS (Equivalent of Oracle Procedure with IN and OUT variable and DYNAMIC SQL) were used to support the creation of both regularly scheduled analytic reports and Ad-hoc requests.
• Calls to ORACLE STORED PROCEDURE were invoked from JDEVELOPER. MATERIALIZED VIEWS were widely used to get snapshot of the remote databases. INLINE VIEWS were also used to enhance query performance. Additionally, SAS MACROS containing embedded SQL were created to automate campaign data processing for various promotional campaigns.
• A SAS MACRO containing embedded DB2 UDB SQL scripts running on an AIX platform was created to extract account level data from the CFS DATA WAREHOUSE. Engaged in user acceptance testing for migration from Oracle to DB2 UDB. UNIX Shell scripts were used to execute the scripts in batch mode to accomplish nightly processing of long running processes.
• JAVA Calls to ORACLE STORED PROCEDURE were made using Oracle JDEVELOPER. As a support person was involved in making changes to the existing Java Code as per user requirement.
• Established connectivity using JAVA code to extract and / or insert data from Oracle database on a new server.