SUMMARY

Over 10 years of experience in Analysis, Design, Development and implementation of Relational Database (OLTP) and Data Warehousing Systems (OLAP).

• Proficient in understanding business processes / requirements and translating them into technical requirements. Communicating with business customers and End Users in understanding and gathering requirements.
• Extensively worked on relational databases like ORACLE 11.x/10.x/9.x/8.x/7.x, SQL Server 2000/7.0/6.5.
• Experience in developing Conceptual/logical & physical Database design using Sybase Power Designer and Erwin.
• Expertise in developing ETL Strategies and Data Migration using PL/SQL
• Extensive experience in developing PL/SQL Packages, Procedures Functions, Cursors and Triggers.
• Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing and Hints.
• Extensively worked on Materialized Views, Table Partitioning, IOT';s, and various oracle built-in packages like UTL_FILE and UTl_SMTP.
• Strong in Database and Data Warehousing concepts.
• Experience in UNIX Shell (Korn, C, BASH) Scripting.
• Extensive experience using Import / Export utilities, SQL Loader and External tables.
• Designing and executing test plans and performing gap analysis to ensure that business requirements and functional specifications are tested and fulfilled.
• Experience working with Business Objects, Microstrategy, Oracle Apex, Oracle Forms and Reports and Informatica.
• Experience preparing project plans and providing project estimates.
• Experience with DBA activities.
• Providing 24/7 Production Support.

• Operating Systems: Windows 95/ NT/ 98 / 2000, DOS, LINUX, UNIX, HP-UX.
• Languages: C, C++, VB, SQL, PL/ SQL, Java, J2EE. UNIX shell scripting, HTML, XML VB Script, Java script.
• Databases: Oracle 11.x/10.x/9.x/8.x/7.x, SQL Server 2000/7.0/6.5, MS Access 2000/97, DB2 8.0/7.0
• Reporting Tools: Crystal Reports, Business Objects XI R2, Microstrategy, Oracle Apex 3.2, Oracle Forms 10g, 9i, 6i, 6.0, Reports 10g, 9i, 6i, 6.0.
• Database Tools / Utilities: SQL*Plus, TOAD, SQL Developer, SQL Navigator, Oracle Enterprise Manager, SQL*Loader, import / Export utilities
• ETL Tools: Informatica Power Center 7.1/6.2/5.1/4.7, Power Mart 7.1/6.2/5.1/4.7 (Source Analyzer, Data warehousing designer, Mapping Designer, Mapplets, Transformations),
• Data Modeling tools: Sybase Power Designer 7.1.3, Erwin, Designer 2000.
• Version Control: VSS 8.0, Clearcase 3.2, PVCS/CVS

EDUCATION

• Masters in Computer Science.
• Bachelors in Computer Applications.

PRODESSIONAL EXPERIENCE

Client : Confidential, new York, NY Jun 12 - Present
Position : Sr. Oracle / ETL Developer
Environment : Oracle 10g/11g, TOAD, SQL*Plus, ERWIN,

Confidential is the oldest and the largest supplier of independent network base healthcare cost management solutions. Multiplan contracts with doctors, hospitals and outpatient facilities who agree to accept pre-negotiated rates for their services. These healthcare facilities and professionals makeup a network. Multiplan sells access to its networks and the discounted rates for the services to its clients such as insurance companies and other healthcare entities.

Responsibilities:

• Responsible for automating the data masking process to encrypt important information that could be used by any system.
• Responsible for creating logical/Physical design using ERWIN.
• Developed Stored Procedures using Oracle PL/SQL packages, procedures, functions and triggers.
• Responsible for preparing Technical Design documents.

PRODESSIONAL EXPERIENCE

Client : Confidential, Wilkes Barre, PA Mar 09 - Jun 12
Position : Sr. Oracle / ETL Developer
Environment : Oracle 9i/10g/11g, TOAD, SQL Developer, SQL*Plus, UNIX, LINUX,
Windows NT, Microstrategy, Oracle Forms 10g, 9i, 6i, 6.0, Oracle Reports 10g,
9i, 6i, 6.0, Control-M,

Corporate Customer Contact (CCC) maintains and manages customer requests like pickups, redeliveries, mail holds and facility data across United States. Various applications write to this system and are accessed by call center agents to respond to customer inquiries. Case management that was once a part of CCC has been redesigned and is now serviced by a new application called eCC that has its own database. RPM is a reporting module that reports on data in CCC and eCC and is accessed by higher management for analysis.

Responsibilities:

• Responsible for maintaining and development of new work on three of the databases at USPS.
• Involved in LINUX migrations for a number of systems, migrating data, converting jobs from DBMS to contromM, Modifying/changing existing interfaces to point to the new system.
• Responsible for architecting and developing the interface from the case management system into the reporting module.
• Responsible for new development efforts on the Transactional and Reporting databases.
• Responsible for reconciling/Synchronizing data between 4 different databases.
• Extensively used Materialized Views, Table Partitioning and Import/Export Utilities.
• Tuning SQL and PL/SQL using Explain plans, Indexes and Hints.
• Developed UNIX shell scripts to run oracle stored procedures via Control-M.
• Loading flat files using SQL Loader and External tables into the database.
• Developing various interfaces to the transactional and Reporting databases.
• Involved in DBA activities.
• Developed Stored Procedures using Oracle PL/SQL packages, procedures, functions and triggers.
• Responsible for writing test cases for Unit testing the application.
• Wrote shell scripts to schedule tasks for automation via controlM and for scheduling various data cleansing scripts and loading processes.
• Responsible for preparing Technical Design documents.
• Responsible for preparing project plans and providing estimates.
• Providing production support.
• Responsible for ad-hoc reports on a daily basis for higher management.

Client : Confidential Stamford CT June 08 - Jan 09
Position : Sr. PL/SQL Developer
Environment : Oracle 9i/10g, TOAD, SQL * Loader, UNIX, Windows NT, Microstrategy.

Confidential is the central repository for Avon that maintains product data and provides information to all upstream and downstream systems. All the product development and maintenance takes place here.

PLS attributing is currently being done manually in excel by the Marketing Data Cleansing (MDC) in Argentina and respective Marketing groups. The purpose of this project is to add PLS attributes into Central Master where the attributes can be maintained and sent to upstream and downstream systems that reference the product data.

Responsibilities:

• Responsible for analyzing the requirements.
• Responsible for preparing Technical System Design document.
• Developed Stored Procedures using Oracle PL/SQL packages, procedures, functions and triggers.
• Responsible for writing test cases for Unit testing the application
• Extensively used dynamic SQL and External tables.
• Migrating code from one schema to another.
• Wrote shell scripts to schedule tasks for automation.
• Providing production support for the application.
• Responsible for other ad-hoc reports.

Client : Confidential, Boston, MA Feb 08 - April 08
Position : Sr. Oracle / PL/SQL Developer
Environment : Oracle 9i, TOAD, Business Objects XI Release 2, ERWIN.

Confidential is a proprietary marketing decision support system - a secure warehouse for all marketing data, plus reporting tool which will help understand the following

Which creative is most effective at reaching - and converting - desired audience?
How many impressions are ideally needed to generate a visit to the site?
What are the cross-effects between search and ad campaigns?
How much of the traffic generated by the ads is from returning customers vs. a new audience?
What string of keywords consumers click on before eventually converting on your site?

Responsibilities:

• Responsible for modifying existing PL/SQL Procedures, Functions, triggers and Packages and developing new ones.
• Extensively used various data transformation functions of PL/ SQL.
• Responsible for making decisions on coding standards and documentation.
• Developed Error Logging and Message Logging to better understand the performance of the procedures and to associate the errors to the procedures.
• Migrating Code from one schema to another.
• Creating new reports in Business Objects.
• Documenting the procedures.
• Responsible for writing test cases for Unit testing the procedures.
• Optimized the performance of the SQL queries in procedures with the help of Explain Plan, Indexes and Hints.

Client : Confidential, Boston, MA May 07 - Jan 08
Position : PL/SQL Developer
Environment : Oracle 9i, TOAD, Microsoft Visio, Informatica Power Center 7.1.3.
Control-M Enterprise Manager 6.2.01, Power Designer 12.0, Microsoft Visual
Source Safe 8.0, Clear Quest, UNIX.

OnLine Reference (OLR) provides critical on-the-job information about Fidelity policies, procedures, products, and services. It is the central policy repository for FBC. Representatives in FPI, OSG, and FFOS use OLR every day to answer questions during customer interactions and to guide their work in key processing tasks. The Goal of this project is to find out what links are being used the most by the representatives in answering the customer queries.

Responsibilities

• Involved in complete software development life cycle.
• Involved in Database designing using Sybase Power Designer 12.0.
• Involved in understanding the SRA (System Requirements Analysis) document for designing the Database.
• Responsible for preparing System Delivery Specifications / Technical System Design (SDS/TSD) document.
• Extensively used tools like TOAD 9.0, Microsoft Visio 2003, and Informatica Power Center 7.1.3.
• Successfully ran the batch cycle in Development and QA using Informatica for loading the fact tables.
• Developed mappings and transformations in Informatica PowerCenter Designer 7.1.3.
• Scheduled Informatica workflows to run on a daily basis.
• Involved in writing test cases for Unit testing the application.
• Involved in scheduling jobs through UNIX Cron job.
• Wrote shell scripts to run batch jobs and to invoke pl/sql procedures.
• Responsible for writing Install Scripts for migrating the code through various environments.
• Involved in preparing OpDocs to schedule daily, weekly and monthly cycles using control-M.
• Developed various PL/SQL Procedures, Functions, triggers and Packages.
• Extensively used Microsoft Visual Source Safe for maintaining the different versions of the code.

Client : Confidential, Cleveland, OH Oct 05 -May 07
Position : PL/SQL Developer
Environment : Oracle 9i, 10g (SQL, PL/SQL), Forms 6i, Reports 6i, TOAD, Discoverer,
Microsoft Visio 2003, PVCS.
They specialize in originating residential mortgage loans through there retail, wholesale and telemarketing channels. They are a full-service mortgage company that originates, acquires, markets and services those loans. Worked on existing data marts for Current loan information, Tax and Insurance payment, Transaction History, Updating personal contact information.
Responsibilities:

• Involved in complete software development life cycle.
• Gathered the business requirements by interacting with users.
• Responsible for making decisions on coding standards and documentation.
• Extensively developed pl/sql packages with procedures, functions.
• Developed various test cases including stress tests to test the efficiency and speed of the application.
• Developed procedures to run the SQL*Loader to load data from flat files into the target database tables.
• Optimized the performance of the application with the help of Explain Plan for SQL queries.
• Wrote SQL, PL/SQL, stored procedures, views and cursors for implementing business rules and data transformations.
• Extensively used various data transformation functions of PL/ SQL.
• Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
• Used Stored Procedures for accessing and retrieving the data from database to Crystal Reports 9
• Used parameters for filtering data in Crystal Reports 9.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports 9
• Used Crystal Repository for reusability of objects.
• Optimizing, and fine-tuning the Crystal Reports for efficiency.
• Participated in the DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Involved in unit testing & user support.
• Involved in integration of the application.
• Involved in 24/7 on call production support.

Client : Confidential, Boston, MA Apr 04 - Sep 05
Position : PL/SQL Developer
Environment : Oracle PL/SQL, SQL Loader, TOAD, UNIX, CVS.

Involved in the backend development of the FNOL (First Notice of Loss), which is a J2EE/Web/Java based insurance system. It processes auto claims for glass and other auto related claims. The system is interfaced with the Policy System for pulling policy information for all auto claims.

Responsibilities:

• Involved in the Data modeling process to create the technical blue print of the data base.
• Created new tables in the database and associated Shell scripts to schedule and execute them.
• Wrote SQL scripts including SQL LOADER, SQL procedures, packages, functions and cursors for special data loads.
• Wrote shell scripts to invoke PL/SQL Scripts.
• Creation of users, roles, indexes etc.
• Wrote database triggers and created log tables for debugging.
• Generation of procedures, which return REF cursors as result sets.
• Scheduled the shell scripts in various environments through the crontab.
• Performed thorough UNIT and UAT testing with SQL queries to check the correctness of the code and business rules.
• Performed Data base Code Optimization using Explain Plans.
• Worked with the Java development team for creating class and sequence diagrams with Rational Rose.

Client : Confidential, NY Jun 02 - Mar 04
Project : AOC - SMS
Position : PL/SQL Developer
Environment : Oracle 9i, UNIX, TOAD, SQL*Loader.

AOC - SMS is a support system of IJMS software of AOC, which enables the sales persons to handle their day-to-day activities in an easier and faster way. The system loads the software in laptop machines, which are connected offline to the server. The software allows the authorized sales persons to enter new customer information, sales transaction details like purchase orders, invoices, receipts, sp memo out/returns etc., in the local database and the entered data will be uploaded to central database server by process. The sales persons can get details of latest modals, stock; price lists etc., by connecting to central sever. Various reports such as sales analysis, open order info, commission reconciliation etc., are generated with various selection criteria.

Responsibilities:

• Extraction of data from different flat files into Oracle Database using SQL*Loader.
• Developed Stored Procedures using Oracle PL/SQL packages, procedures, fucntions.
• Gather Business rules from the end users that are to be incorporated into the system.
• Changed existing logic within the packages for optimum Performance.
• Tested the original and optimized codes thoroughly for failures before exporting to other environments.
• Created Test Specification & Test Servers to simulate voluminous transactions.
• Generate scripts for testing the output and making available data for testing using Unix.
• Used Korn Shell scripts to automate Oracle script execution.
• Involved in regular User Managed Hot and Cold physical database backups.
• Created Shell Scripts for Regular backup, instance start, shutdown
• Involved in successfully upgrading from Oracle 8i to 9i.
• Used ADO, ODBC for accessing and retrieving the data from database to Crystal Reports 8
• Used parameters for filtering data in Crystal Reports 8
• Optimizing, and fine-tuning the Crystal Reports for efficiency.
• Creating and Maintaining of different levels of users with different levels of securities by creating User Roles and Privileges.
• Tuned SQL by using Explain Plan, Indexing and Hints.