SUMMARY

• Over 7 years of experience in analysis, design, development, and testing of business applications in OLTP, web based, Client/Server AND ETL architectures.
• Strong Knowledge on oracle architecture and database design.
• Strong expertise in Oracle 9i/10g, PL/SQL.
• Extensive hands-on experience in data warehousing projects using Informatica PowerCenter8.x/7.x/6.x
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Expertise in creating stored procedures, functions packages, collections and bulk collections using PL/SQL.
• Experience in creating master detail forms and adding alerts.
• Expertise in loading data from legacy systems using SQL*Loader.
• Worked with various performance tuning techniques using tools provided by Oracle like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE, HINTS, DBMS_PROFILER etc.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Scheduling batch jobs using Autosys.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader, Forms6i/9i/10g, Reports6i/9i/10g using SQL, PL/SQL and UNIX Shell Scripting.
• Advanced Knowledge of Informatica Designer, Workflow Manager, Workflow monitor and Repository Manager.
• Experience in writing Technical design documents and developing unit test documents.
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Supported integration and end user testing with efficient defect management process.
• Strong Analytical, Problem solving and communication skills.
• Strong communication and inter-personal skills at the technical and user level.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Ability to learn new tools, concepts and environments.
• Good team player, Self-motivated, quick learner.
• Excellent communication and interpersonal skills.

Operating Systems

Windows 98 / NT / 2000 / XP, UNIX, Linux

Languages

SQL, PL/SQL, Flash MX 2004, C/C++, Java, .NET Framework 2.0/3.5

Databases

Oracle 8i/9i/10g/11g, SQL Server 2000/2005. Netezza

Oracle Tools

ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, iSQL*Plus, SQL*Loader, SQL Developer

Development Tools

Powerbuilder

DataWarehouse Tools

Informatica, ETL, Microstrategy

Scripting Languages

Java Script, UNIX Shell Scripting

Web Technologies

HTML, XML, DHTML

Design Tools

ERWIN

Other Tools

MS Visual Source Safe 6.0, Clear Case, Edit Plus

Professional Experience:

Confidential,Burlington, NJ Feb 2011 to Till Date

• Role: Data Warehouse/ ETL Developer

Confidential,a $3.5 billion dollar retailer is a Value / Off-Price Department Store that offers a broad selection of designer label merchandise. BCF operates 433 stores located throughout 44 states and Puerto Rico. Store sales are augmented through on-line B2C and Gift Registry channels. Privately held by affiliates of Bain Capital.

Responsibilities:

• Developed Procedure, Package, Functions to update and maintain the database
• Wrote PL/SQL procedures & triggers to validate database records.
• Created Stored Procedures for Batch Processing, and also involved in moving large data using Bulk Insert for all Methods.
• Involved in ETL-Informatica design and developed various mappings/transformations.
• Coordinating with source systems owners, day-to-day ETL progress monitoring, Data warehouse target schema design (star schema) and maintenance.
• Used extensively Informatica Designer, Workflow Manager, Workflow monitor and Repository Manager.
• Created Sessions, Workflows/Worklets and scheduled them in the Workflow manager and Performance tune them.
• Wrote Scheduler Scripts in UNIX to run the developed PL/SQL scripts. Loaded data from flat files into tables by using the SQL * Loader.
• Worked with different databases like Netezza and Oracle.
• Scheduled the Scripts using Autosys.
• Worked on performance and tuning Oracle queries.
• Analyze the source systems data.
• Identify issues, debug and resolving issues.
• Coordinate with Oracle DBA and Unix Admin to achieve better dB performance and identify performance bottlenecks.

Environment: Oracle 10g, SQL*PLUS, SQL*Loader, TOAD 8.5, Informatica, PL/SQL, Netezza, Microstrategy, UNIX/AIX, ERWIN4.14/4.0.

Confidential, NYC, NY Sep 09 to Jan 2011

• Role: Data Warehouse/ETL Developer

The project involved the development of an application, which provides a web-based user interface that serves as a single point of entry into the integrated systems environment. The developed software also provides access to generate custom reports, queries and reports from the Central Data Repository. Developed and customized queries for some of the main modules in the system like Provider, Recipient and financial modules.

Responsibilities:

• Gathered and documented business requirements. Created the initial conceptual design and created the database objects.
• Involved in the development of data model of ER Diagrams/ Dimensional diagrams for business requirements using ERWIN.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Developed various transformations in Informatica and supported Data warehouse design and development extensively
• Developed Procedure, Package, Functions to update and maintain the database
• Oracle PL/SQL procedures used for migrating data from interchange to present DSS (Design Sub system).
• Wrote PL/SQL procedures & triggers to validate database records.
• Created Stored Procedures for Batch Processing, and also involved in moving large data using Bulk Insert for all Methods.
• Wrote Scheduler Scripts in UNIX to run the developed PL/SQL scripts. Loaded data from flat files into tables by using the SQL * Loader.
• Indexing/Loading data & exposing webservice over search engine for clients to consume.
• Created batch executable scripts and to manipulate files and directories using PERL.
• Wrote Shell Scripts using that are required for day-to-day operations for all environments.
• Involved in performance tuning the application. Analyzed TKProf results to tune SQL for improved performance of the stored procedures and created indexes on tables on a case-by-case basis.
• Involved in unit testing and Integration testing of the Modules.
• Tested the applications with production data

Environment: Oracle 11g/10g/9i, SQL*PLUS, SQL*Loader, TOAD 8.5, SQL Developer,PL/SQL, Informatica, MS ACCESS, UNIX/AIX, ERWIN4.14/4.0.

Confidential,Mt Laurel, NJ Nov 08 Aug 09
Role Data warehouse Developer

Confidential,is one of the nation’s largest and most dynamic mortgage companies. It treats customers like family, while making the mortgage experience smooth and easy.

Project: The business processes that support evaluation of what loans are eligible for funding from the warehouse. I was involved in testing the Loan origination Application;
This application pulls the mortgage loan applications data from different vendors for processing all loans data will be loaded in to the staging database, then processed according to business rule and types of the loan and will send to the respective departments according to the loan type for eligibility process. Once loan is approved application will be send back to lender for conformation.

Responsibilities:

• Created Stored Procedures, Functions, and Triggers to maintain various business rules.
• Extensively worked towards optimizing the Queries toenhance theperformance.
• Analyzed Indexes on regular basis.
• Used BULK SQL and BULK BINDING to minimize the execution time of PL/SQL cod
• Created SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Analyzed the existing Stored Procedures, Functions, Triggers and Cursors on performance issues.
• Managing Tables, Indexes, Constraints, Views, Sequences, and stored program units.
• Resolved various optimizing problems to maintain high level of customer satisfaction.
• Implemented Triggers based on the business rules.
• Created users privileges and managed user roles and grants.
• Worked on DBMS_SCHEDULER to automate jobs.
• Loading data into the Database using SQL* LOADER.
• Used the Oracle Import/Export utilities for taking the backup of a particular partition data.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning.
• Made use of DB LINKS for accessing data across different databases.
• Stored data in the audit log tables using the old and new column attributes.
• Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.

Environment: Oracle 10.2g, HP-Unix, Oracle Enterprise Manager, VSS, SQL*Loader, SQL*Plus, SQL Developer 1.5.4, VB.net, Toad Data Modeler.

Confidential,NJ Aug 07 Oct 08
Role Sr. Oracle PL/SQL Developer

Project: Insight Mobile database project is Sales Force Automation for Schering plough, Inc. The project involves three tiers. The Representatives enter their call details using their Insight front end. All the details are synchronized and distributed to the oracle database as its middle tier. The data from the oracle middle tier is passed to Db2 mainframe database through OMNI replication.

Responsibilities:

• Involved in System Analysis.
• Coordinated between management, users and technical teams for Requirement Gathering.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions and Triggers using Oracle.
• Involved in Code Standardization and Documentation.
• Involved in database Performance Tuning and Optimization of SQL queries.
• Used TKPROF and Explain Plan for Optimization.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers using Toad to implement the business logic.
• Used data Normalization techniques.
• Designed the screens through which the end users could control the quote.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Used Designer 6i for Data Modeling, Design Specifications and to analyze Dependencies.
• Created Control Files and used SQL* Loader to upload bulk data.
• Design automated interfaces using UNIX scripts to transform and load data.
• Provided support to design/break fix issues in SQL Server 2000/2005 and track to a closure.
• Responsible for troubleshooting the errors that occurred when the production and testers hit a roadblock.
• Used PERL scripting.
• Involved in developing screens and generating reports.
• Developed Forms and Reports.
• Participated in migrating database from oracle 9i to 10g database.
• Involved in production deployment and production support 24x7.
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment:Oracle RDBMS 9i, 10g, TOAD, PL/SQL Developer, PL/SQL, Erwin, Oracle Forms and Reports 9i, SQL Scripting, Perl, SQL Server 2000/2005, UNIX Scripting.

Confidential,NJ Feb 06 Jul 07

Role: Oracle PL/SQL- ETL Developer

Confidential, developed a Rater application for Life and Disability insurance for an easy interface for the underwriters and business administrators. The application interfaces with calc engine to calculate the insurance policies and premium for different sets of conditions. The application is developed in ASP.Net interfacing with SQL Server.

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Involved in maintaining and updating the procedure for ETL process.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, synonyms, procedures, functions and database triggers to meet the business requirements.
• Executed upload and load procedures to check the data feed is correctly getting loaded in to the tables.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, and Sorter and Sequence Generator transformations.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Extensively used Informatica Client tools Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Modification of the existing forms and reports and registering those in Application.
• Modeled the Data Warehousing Data marts using Star Schema.
• Direct interaction with users and helped in the development of functional specifications.
• Written technical specifications for all the procedures developed in the module. Maintained log files during analysis and subsequently report any performance defects.
• Coordinate with the front end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.
• Written UNIX shell scripts to automate processes like data load and sending notification mails.

Environment: PL/SQL, TOAD, SQL*Loader, Oracle 10g, UNIX, Erwin, SQL* Plus, Informatica power center, Oracle Forms.

Confidential, India Nov 03 - Dec 05
Role: Software Developer

Confidential, is an advertising company. The project work included development in Oracle PL/SQL programming and Report Generation. Developed front-end windows using Powerbuilder custom framework. The system was a financial & customer servicing reporting structure designed using Oracle PL/SQL and PowerBuilder. Designing and creating complex reports, data grids and views using different types of PowerBuilder Data Windows. I have Developed and maintained business logic using Oracle PL/SQL. Performed fine-tuning of the stored procedures, functions, views and triggers.

Environment: Oracle 8, PL / SQL, PowerBuilder 6.5, HTML, Java, XML, Java Script, Windows NT.