SUMMARY

• Professional with Over 8 years of experience with expertise in Data Base Design, Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Oracle Data Integration, AbInitio and Cognos.
• Experience in development, testing, and deployment of custom reports, forms, and workflows.
• Good experience of Performance AnalysisandSQL query tuning, while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, TK - Prof and Explain Plan.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading, Database Modeling and Data ware housing tools and technologies such as Ab Initio, ODI and Erwin.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Arrays), Records, Object types and Database Triggers.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, iSQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Strong knowledge of UNIX Shell Script on Sun Solaris 2.8/2.7 and HP UNIX 12.x/11.x. and Worked on KORN Shell Scripts to write maintenance script for Oracle.
• Exposure in Business Process Execution Language (BPEL) and Good knowledge on Enterprise Service Bus (ESB), Oracle Service Bus (OSB) Administration and troubleshooting on Windows, and Unix Environment.
• Exposure in Oracle Applications 11i Oracle Financials (AR, AP, GL modules of Oracle Applications 11i in multi Org, multicurrency environment
• Experience in writing ANT build scripts to automate the compilation, creating directory structures, generate classes from WSDL, deploy the services onto the Web Server, and generate JAR and WAR files.
• Ability to work in a team environment and as an individual with strong technical and communication skills, and good zeal in adapting new technologies in a fast paced environment.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 7/2000, MS Access.

Languages: C, C++, COBOL, Java, HTML/DHTML, XML, PERL and T-SQL.

Scripting: SQL, PL/SQL, UNIX Shell Scripting, ASP.

Reporting Tool: Business Objects, Crystal Reports and COGNOS 8.

ETL Tool: Ab-Initio, ODI.

Query Tools: TOAD, SQL Developer, SQL Navigator, SQL* Plus, iSQL * Plus.

Operating Systems: HPUX, Solaris 7.0/8.0,MVS, Windows 2000/NT/XP/7/98 and UNIX.

GUI: Developer 2000-Forms 6i/9i/10g/11g, Reports 6i/9i/10g/11g.

Packages: Micro Soft Office Suite- MS-Word, MS-Excel, MS-Power point.

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCS,VSS, IBM Rational ClearCase, Autosys, Opalis, ESP.

PROFESSIONAL EXPERIENCE

Confidential, Apex, NC

Sr. PL/SQL Developer

Responsibilities:

• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Created data accuracy and consistency reports.
• Created complex relational database queries/SQL, dynamic SQL.
• Used various report items like tables, sub report and charts to develop standard and customized reports.
• Worked on designing, coding, testing and maintaining database objects, tables, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
• Developed the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
• OWB repository creation/configuration/monitoring, mapping/process flow development.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Built physical data structures like tables, views, constraints & Indexes.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel, Flat files to SQL Server 2008.
• Review modifications to existing software to improve efficiency and performance.
• Analyze Korn shell scripts on UNIX platforms.
• Involvedinphysical and logical data modelingusingErwin.
• Involved interfacing with the following tools: PL/SQL, Oracle Forms, Oracle Reports, Crystal Reports, and/or Oracle APEX.
• Part of a development team for creation and maintenance of custom apps/reports.
• Created complex stored procedures to collect, analyze, and report on data across multiple functional and line of business systems in response to customer requirements.
• Created ETL design specifications.
• Solid understanding of both the business and the technical aspects of BI Solutions.
• Created table partitioning based on the systems and date range.
• Used SQL*Loader with both direct and indirect load methodologies.
• Query optimization using Explain Plan & TK Prof utility.
• Developed extraction, transformation and loading scripts using SSIS.
• Created SQL and PL/SQL scripts to detect data defects/anomalies in systems.
• Converted T-SQL to PL/SQL or vice versa to report data consistency cross multiple databases.
• Created business rules to report all expected missing/defect data.
• Involved in Huge data migrations, transfers using utilities like SSIS, Bulk Copy Program (BCP) and Bulk Insert.

Environment: Oracle 11g,PL/SQL, SQL Loader, Cognos, Korn shell, ODI, SQL*Plus,, Microsoft SQL server 2008.

Confidential, Denver, CO

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Designed and developed a huge database of 120 tables and its data load process from flat files and also designed complex functional views for Payroll application.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data. Also worked on creating users and roles as needed for the applications.
• Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled load processes and backup jobs.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, functions, procedures, packages, triggers and cursors.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Involved in the design and development of user interfaces and customization of Reports using ASP and as well as COGNOS.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Worked on Production support for the backend database and reporting applications.
• Involved in importing Source Tables from the different databases.
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.

Environment: Oracle 10g/11g,PL/SQL, SQL Loader, Cognos, ODI, SQL*Plus, Windows NT 4.0/2000/XP and UNIX

Confidential - Sunbury, PA

Sr. ETL/ Data warehouse Developer

Responsibilities:

• Analyzed Business Documents, Internal & External Source systems and Requirements to develop Enterprise Data warehouse (Star Schema) Logical and Physical Model (Facts and Dimensions) and Business Process Model.
• With Business Analysts and clients, Analyzing and assessing the business specifications and designing and developing the POPS and Confidential applications.
• Involved in Extraction, Transformation and Loading (ETL) of the data from the Heterogeneous databases.
• Extensively used SQL Loader and UTL FILE methods to load the fixed length, csv and pipe delimited flat files from Mainframe and DB2 into the Oracle database.
• Used UNIX Shell scripts (KORN) for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files.
• Developed stored procedures, functions, packages and DB triggers extending the functionality and for retrieving the data from the database for solving complex queries.
• Created Stored Procedures, functions and Packages in Oracle 10g using SQL and PL/SQL for the Audit Trail using Oracle 10g as backend.
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database using Explain Plan, hints and also worked on Partition tables using Range method.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Creating Test scripts for the generated final Reports.
• Provided the Production and Technical support the users.
• Prepared technical documentation of all modules for user level and system level maintenance.
• Created promotion scripts and documents for migrating objects from once database instance to other instances.

Environment: Oracle 10g, SQL PLUS, PL/ SQL, SQL*Loader, XML, Korn Shell Scripts, Cognos, Windows XP, MS-Excel, Solaris and HP-UX, TOAD.

Confidential - Dublin, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in gathering business requirements, clarification and system design.
• Extensively worked in End-to-End phases of the application design, development, testing, production deployment and documentation.
• Prepared proto-types for the system design & approach and participated in business users presentations.
• Developed Complex UNIX shell scripts and Autosys jobs for the scheduling and automation of the application jobs execution.
• Involved in Source code release to higher environments (QA, UAT and Production) using the IBM Rational ClearCase version control tool.
• Developed PL/SQL packages, procedures, functions, Indexes, sql scripts for the implementation of the very complex business requirements.
• Implemented the COPY command successfully to insert huge amounts of data into the target system from ODS.
• Developed validation programs to validate the data before importing into the payables table.
• Designed, developed, tested and implemented using Oracle Forms using Forms 6i/9i.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Developed PL/SQL packages and database triggers and Improved performance of the extract - loads and existing applications for huge volumes of data by optimizing the queries, indexing and redesigning some of the scripts.
• Extensively supported production for all the UNIX, Autosys, Oracle and Reporting issues.
• Used Cron Jobs to schedule various reports.
• Prepared test data and expected results for the system testing with possible business functional scenarios to make the system bug-free.
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Supported BOXI reports testing and prepared expected results using complex sql queries.
• Involved in System testing, Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and walkthroughs.

Environment: Oracle 10g,PL/SQL, SQL*Plus COPY, BOXI, SQL*Plus, Windows XP and UNIX, IBM Rational ClearCase.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Developed severalPackages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle10g database, checking the most queries.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE’s) relationships.
• Customer Data Load from flat files into Oracle tables using SQL*Loader, and PL/SQL procedures.
• Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
• Created Korn Jobs to perform regular updates to database tables to keep in sync with the data coming from other sources.
• Performed review and analysis of deadlocks and database performance tuning.
• Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely with the Application Development teams to identify and implement continuous improvements and effective problem resolution strategies.

Environment: Oracle 10g/9i, SQL, PLSQL, SQL*Loader, KORN Shell script, Erwin, TOAD, Web Logic, HTML, Java, J2EE, Unix.

Confidential

Database Developer

Responsibilities:

• Gained experience in C & C++ programming on UNIX for RAMINFO Applications and also developed PL/SQL Code for updating the payment terms.
• Interacting with Business users, gathering and analyzing requirements and Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes.
• Provided technical solutions in the form of MDD (Minor Development Document) for the Process Change Requests from Business.
• Involved in the design of database schemas and data mapping of client’s databases with DCX’s transactions databases.
• Involved in the design of logical and physical data modeling using ERWIN Tool. And also designed star schemas using dimensional modeling and created fact and dimensional tables.
• Writing complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Involved in Performance tuning and optimization of SQL queries for data warehouse consisting of many tables with large amount of data.
• Created PL/SQL packages, procedures and functions that extensively used PL/SQL cursors, user defined object types, exception handling.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes etc as.
• Designed ETL to extract external data (Oracle, Excel file) and load data using SQL*Loader.
• Designed UML Models (Visio) and Relational data Models for applications.
• Worked on Business Objects (BO) to deploy various reports onto production.
• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes.
• Developed UNIX Shell Scripts for automating the execution process.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Created an induction manual for the ETL process and production support document
• Involved in preparing documentation and user support documents.

Environment: PL/SQL, Oracle 9i, Maestro Scheduler, ERWIN 3.5, AIX UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/.