PROFESSIONAL SUMMARY

• Around 7 years of experience with expertise in Data Base Design, Data warehouse, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8i, SQL, PL/SQL.
• 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 such as Ab Initio, ODI, Informatica and Erwin.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Triggers, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections, Records, Object types.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD, SQL*plus, iSQL*plus, SQL Developer.
• Strong experience in SQL, PL\SQL and used in RICE(Reports, Interfaces, Conversions and Extensions) components.
• Experience in providing solutions of capacity, replication data issues.
• Expertise in Oracle Developer/ PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System.
• Good programming knowledge in Oracle 11g/10g/9i, Oracle developer Suite10g (Oracle Forms, Oracle Reports).
• Experience in maintenance of relational databases including backup and recovery, scheduling jobs, trouble shooting/problem diagnosis and performance tuning.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, Triggers, cursors and views for processing data, enforcing referential integrity and needed business rules.
• Experience in creating different kind of partitions on large tables and creating indexes in order to improve performance. Worked on several Oracle provided packages such as UTL FILE and DBMS JOB.
• Tuning SQL queries using explain plan, tkprof, sqltrace.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Expertise in Performance Tuning and Query Optimization using utilities like EXPLAIN PLAN and TKPROF. Used Hints, Bulk techniques, Indexes and Table partitioning.
• Worked on Oracle Forms 10g/9i/6i Reports10g/9i/6i.
• Extensively used PL/SQL to build Oracle Reports 10g and views for processing data, enforcing referential integrity and needed business rules.
• Strong in Data warehouse tools like Oracle Data Integrator (ODI), Oracle Warehouse Builder (OWB).
• Experience in Oracle workflow Builder.
• Good Knowledge of UNIX Shell Script. Knowledge on EXADATA.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICALSKILLS:

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

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

Languages: C, C++, COBOL, Java, HTML/DHTML, XML Publisher

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

Operating Systems: HPUX, Solaris 7.0/8.0, MVS, Windows 2000/NT/XP/7/98 & Unix

GUI: Developer 2000-Forms 6i/9i, Reports 6i/9i

Packages: Microsoft Office MS-Word, MS-Excel, MS-Power point

Other Tools: SQL*Loader, MS-Visio, MS Project Professional 2003, PVCS

WORK EXPERIENCE PROFILE

Confidential, Detroit

Oracle PL/SQL Developer

Responsibilities

• Worked with Business Users to gather requirements for developing new Reports and also Changes in the existing Reports.
• Designed and developed Reports according to user specification. Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Used XML Publisher to generate the report design as per business need.
• Extensively Involved in Performance tuning and Optimization of the SQL queries.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes and also performed code debugging using TOAD
• Set up batch and production jobs through Autosys.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Designed processes to extract, transform, and load data to the Data Mart. And extensively used SQL*LOADER method to load data from flat files.
• Extensively used SQL*Loader to load Data from flat files from various Data Sources to Database tables in Oracle.
• Developed the PL/SQL home -grown applications using advanced features like Native dynamic SQL (NDS) and INDEX BY TABLES, Hints, Indexes, FORALL statements to improve the performance.
• Optimized SQL used in Reports and Files to improve performance to higher extent.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Extensively used IMPORT utility to load the exported files.
• Migrated reports from Crystal Reports Version 10 to Crystal Reports Version 11.
• Responsible for the production issues and bug fixing.

Environment: Oracle 9i, Oracle Reports 6i, SQL, PL/SQL, Erwin, TOAD, Unix, ETL, PVCS Version Manager, Exceed, Test Director, XML Publisher.

Confidential, New Jersey

PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes and also performed code debugging using TOAD
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, triggers and cursors.
• Wrote SQL queries to extract data from different source tables and then do the transformation as we need and load them in to our Oracle database objects.
• Created Perl Scripts, SQL scripts, Stored procedures and Constraints according to the Data transfer from Legacy systems to Oracle Database (Interfaces).
• Created various Data Models using Erwin - Normalized and Dimensional Modeling.
• Generated reports using complex SQL queries.
• Enhanced performance of the application through SQL tuning using TOAD
• Created Materialized Views for Aggregator Facts.
• Created various server side objects such as Tables, Views, Materialized Views, Stored Procedures, Functions and Triggers.Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Mainly responsible for developing PL/SQL packages and procedures using SQL and PL/SQL 9i advanced features.Developed the PL/SQL applications using advanced features like Native dynamic SQL (NDS) and INDEX BY TABLES.
• Developed PL/SQL applications using new features like FORALL statements to improve performance in insert and update statements
• Extensively worked on writing the SQL queries using new features like FULL OUTER JOIN, and LEFT OUTER JOIN.
• Extensively worked on performance of SQL queries using Indexes.
• Used UC4 tool for scheduling the jobs in production and worked on JIRA.
• Involved in System testing, Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and walkthroughs.
• Provided technical support to the user with regard to operational aspects.

Environment: Oracle 11g,PL/SQL, SQL Loader, UC4, UNIX, Windows 7, JIRA, Toad.

Confidential - Tampa, FL

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, triggers and cursors.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Extract data from different sources through flat files and then do the transformation as we need and load them in to our Oracle database objects.
• 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 11g,PL/SQL, SQL Loader, Informatica, Cognos, ODI, SQL*Plus, Windows NT 4.0/2000/XP.

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.
• 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.
• Developed validation programs to validate the data before importing into the payables table.
• Responsible for Designing, development, testing and deployment of Oracle Alerts, Triggers and debugging for Oracle Forms.
• Created Records, Tables, Objects, Collections (Nested Tables), Views, Procedures Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader
• Involved in writing procedures, functions, triggers, streams, and packages for new requirements
• Involved in developing a customized Data Warehouse wherein analysis is done in the warehouse for comparing the sales of the different products
• Worked on Oracle workflow Builder for meeting the Business needs.
• Responsible for writing PL/SQLs from DBA.
• Responsible for DDL/DML operations in databases and remove any deadlock aroused and removal of locks obtained by users and creation of DBA triggers to maintain consistency in databases.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to online production environment using SQL*LOADER.
• Participated in performance tuning, unit test case preparation and execution.
• Utilized tools like TOAD during development of the application.
• 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.
• 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, Windows XP and UNIX, IBM Rational ClearCase.

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.
• 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.
• Worked with the team in creating UNIX Shell Scripts for automating the execution process.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• 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, UNIX, Windows NT/2000, SQL Navigator, Windows NT/2000/.