SUMMARY

• Over 15 years of extensive US experience in the entire software development life cycle in analysis, design, development, enhance, implementation, Troubleshooting, coding, testing and customize various database/web applications
• Over 15 years of experience in Database technologies using Oracle, Netezza and Teradata
• Strong Data Warehouse development using ETL Informatica, DataStage and PL/SQL.
• Expertise in Netezza NZSQL, NZLOAD, external Tables, and Analytical functions.
• Oracle Programming using PL/SQL Packages, Procedures, SQL*Loader
• Advanced Oracle programming using Collections, VARRAY, Objects, Scheduler, SMTP.
• Experienced Informatica Mapping/Mapplet Designer, sessions and Workflow.
• Created Data Load Jobs, Sequences in DataStage
• Experienced in Performance Tuning
• Sound knowledge in Data Warehouse, ETL concepts such as Dimensional, Star, SnowFlake
• Used data modeling tools Erwin, SQL Developer.
• Strong experience in Batch Process using Unix Scripts, Autosys, File handling etc.
• Experienced in OLTP application development with strong performance and reliability.
• Good team player with excellent communication skills and the ability to work well in teams as well as individual.

TECHNICAL SKILLS

RDBMS: Oracle 11/10/9i/8i/7.x, Netezza, Teradata, Rdb, SQLServer 2000

Languages: PL/SQL, SQL, NZSQL, Shell Script, Visual Basic, C, Java, Pro*C, Perl, XML

ETL Tools: Informatica, DataStage, ETI*Extract

Operating System: HP - UX 11.x, Sun Solaris, Linux, UnixWare 7.x, Novel, Windows & VMS

Tools: Oracle Forms 3.x/4.x/6i, Reports 2.x/6i, Business Objects, SQL LoaderSQL*Plus, SQL Developer, WinSQL, Aginity, Spring Batch

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Database Developer

Responsibilities:

• Involved in entire SDLC, Agile Scrums and data mapping.
• Developed ETL scripts to load CV tables using Oracle PL/SQL, DataStage, Unix Sripts
• Involved in ETL framework design for inbound/outbound data loads/extracts
• Developed Oracle Stored Procedures, Packages, Triggers, Ref Cursor
• Used Oracle Advanced features such as Collections, Objects, Scheduler, SMTP etc
• Data sent to DW using DataStage with corporate Framework.

Environment: Oracle 11G, Linux, DataStage 8.x, SQL Developer, Informatica 9.x. PL/SQL

Confidential, Charlotte, NC

Sr. Oracle Developer

Responsibilities:

• Involved in requirements gathering and data analysis.
• Developed ETL scripts using Oracle PL/SQL, XML, Java and Spring Batch
• XML data used to communicate via MQ series with external projects
• Designed and developed materialized views, packages for various reports
• Data extracted and transferred to DW using NDM.
• Developed interface between CRMS to various third party applications.
• Involved in documentation for the business requirement, change control, training etc.

Environment: Oracle 11G, Linux, Actimize CDD, WebSphere, PL/SQL, Java, Spring Batch 2.0

Confidential, Charlotte, NC

Sr. Netezza Developer

Responsibilities:

• Involved in requirements gathering, defect and data analysis.
• Developed ETL mapping, ETL scripts to implement business logic on Netezza.
• NZSQL used to transfer data from Data Warehouse to Datamarts.
• Involved in data migration from Oracle to Netezza.
• Assisted development and QA teams by providing clarifications for their data/technical issues.
• Involved in root cause analysis, defect resolutions and prod fixes.
• Data analysis for adhoc request from management team

Environment: Netezza Twinfin 6.0, NZSQL, NZPLSQL, Oracle 10G, PL/SQL, Informatica 8.6, Winsql, Toad and UNIX.

Confidential, Pittsburgh, PA

Sr. Oracle Developer

Responsibilities:

• Designed and developed data migration process to migrate from legacy (Oracle) to new (Teradata) using Oracle PL/SQL, Unix Scripts, Teradata utilities BTEQ, Fastload etc.
• Designed and developed various loads and extract using Oracle PL/SQL packages, sql*loader, bteq and Teradata procedures.
• Wrote Teradata procedure for the use of GUI based java applications
• Troubleshooting day to day issues and enhance the batch process and database applications

Environment: Solaris 5.9, Oracle 10/11, Teradata, BTEQ, Fastload. PL/SQL, Java, Shell Scripts, SQL*Navigator, J2EE, WebSphere 5.x and Perl

Confidential, Pittsburgh, PA

Sr. Database Developer

Responsibilities:

• Analyzed and Designed clinical process using Oracle PL/SQL, Unix Scripts, Java, etc
• Designed and developed batch process using shell scripts
• Used advanced PL/SQL features such as Bulk Collect, Collections, Arrays, MERGE, etc
• Designed and automated daily batch processing and involved in 24x7 production supports.
• Java program to integrate oracle PL/SQL programs, EJB applications and as/400 API libraries
• Managed Change control procedure using tools such as dimension/ sharepoint.

Environment: Solaris 5.9, Oracle 10/11. SQL Server, PL/SQL, SQL 2000, Java, Shell Scripts, SQL*Navigator, J2EE, WebSphere 5.x

Confidential

Backend/Oracle Developer

Responsibilities:

• Developed Oracle PL/SQL Packages
• Developed reports with OLE2 ie Database report are presented in formats such as Excel, PDF
• Designed and developed Forms for web environment produce reports in XML, HTML, etc
• Developed web environment Reports using Report 6i

Environment: Unix, Oracle 8.1.7, PL/SQL, SQL, Forms 6i, Reports 6i, IIS Web Server, COM, ASP, JavaScript, HTML, XML, Windows NT

Confidential, Boston, MA

ETL Developer

Responsibilities:

• PL/SQL Packages, Pro*C, C, JavaScript, XML, ASP and Shell Scripts to load dimensional and summary table
• ETI*Extract used to create mapping between source and target tables.
• Procedure and Function to add data transformation logic
• Performed SQL tuning, SQL*Loader to load dimensional tables
• Generated report using Business Object, IIS, ASP, HTML etc.
• Used Sync Sort to sort or remove duplicate on data files (flat file).

Environment: HP-UX 11.0 E9000, Oracle 8.x, Pro*C, PL/SQL, C++, COM, SQL Server, SQL 2000, IIS, HTML, XML, Business Objects, ASP, JavaScript, Shell Script

Confidential, Minneapolis, MN

ETL Developer

Responsibilities:

• Analyzed and implemented conversion of conventional partition tables to 8i partition tables
• Pro*C/Pro*C++ programs to load data to Transaction tables.
• Scripts to various jobs like ftp from different servers, automatic mailing, file maintenance, etc.
• Managed Metadata and wrote triggers, functions and Procedures using PL/SQL
• C/C++ and shell scripts used to process flat file.
• Performance tuning on backend programs.
• For Pilot, created Mappings/Transforms/Sessions using Informatica 5.x
• Involved in report enhancement using SQL Server, SQL, Visual Basic

Environment: Solaris 2.6, E10000, Oracle 8i, PL/SQL,Pro*C, C/C++, COM, Visual Interdev, Visual Basic, IIS, ASP, Java Scripts and Informatica 5.1

Confidential

Programmer Analyst

Responsibilities:

• Studied system and prepared requirement
• Wrote Triggers, Procedure and Packages using PLSQL to add business logic.
• Wrote shell scripts to automate the day to day backups, moving up the archive log files
• Wrote VB application to user interface and reports
• Created pro-type screens for user interfaces using Visual Basic 5
• Used ODBC connectivity to read/write Oracle Database.
• Generated reports using Oracle Reports and Visual Basic
• Wrote Pro*C programs to data extract for various external applications
• Prepared Test plan, implementation steps etc.

Environment: Oracle 8x on Solaris 2.5, SCO UNIX, SQL Server, COM, PL/SQL, Visual Interdev, Visual Basic 5.0, Reports 2.5 ODBC, Windows NT

Confidential

Application Programmer

Responsibilities:

• Developed 52 forms using Visual Basic.
• Wrote stored procedure to add the complex business and functionality and calculations.
• Wrote Pro*C programs to generate reports such as slow moving, short or excess delivery.
• Wrote user-friendly PL/SQL functions/procedures to serve ad-hoc queries for users.
• PL/SQL, Pro*C programs to populate summary tables.
• Wrote Batch programs to run data loads, reports and schedules.

Environment: Oracle 7.2 on Windows 95, Developer 2000, Forms 3.0, PL/SQL and Pro*C, and Visual Basic, Windows 95/NT

Confidential

Programmer

Responsibilities:

• Visual Basic was used to create interface screens and reports.
• Involved in user training and implementation of the system.
• Created view for the calculated values.
• Written 20 Pro*Cobol programs to generate the reports.
• Wrote Batch programs to run reports and schedules.
• Wrote Triggers and Procedures using PL/SQL to post data from Journal to Ledgers.

Environment: Rdb on VAX 3400/VMS 5.0, Pro*Cobol, Visaul Basic