SUMMARY

• Over 9 years of experience in Information Technology providing professional service as Oracle developer in planning, analysis, design, development, enhancement, testing and maintenance using Oracle database.
• Involved in system study, design, development, and implementation stages of various projects until the maintenance level.
• Grouping Sets, Merge/Multiple Table Insert/Loading and logging error in a single statement/Grouping sets/Analytical Functions.
• Extensive experience in writing Oracle PL/SQL Packages, Procedures, Functions, Database Triggers and SQL queries.
• Involved in full software development life cycle for PL/SQL, SQL and SQL*PLUS backend development for Data warehouse and OLTP applications.
• Experience in data migration using SQL*Loader and PL/SQL scripts.
• Experience in implementing Forms 6i applications.
• Extensive experience in Analyzing, Designing, Testing, Documenting Database systems and Business applications.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity - Relationship Diagrams.
• Developed UNIX Shell scripting, korn shell scripting.
• Good Programming knowledge with Visual Basic 6.0, ASP, Java Script, VBScript and HTML.
• Involved in administrative roles like installing/configuring databases, creating databases, partitioning, creating indexes and migration of databases.
• Experience on different data modeling techniques using Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Understanding of Database Installation, Configuration, Support, Space management, and User management, Backup, Recovery, Oracle Net and Performance Tuning in the production database environment.
• Good knowledge in Relational Database Design and Development using Oracle 8i / 9i /10g.
• Good knowledge on SQL Navigator, PL/SQL Developer Tools, SQR reporting.
• Worked on unit and integration testing
• Assisted in various configuration and support operations which included Logical/Physical Backup methods.
• Assisted in performance testing of databases, creating indexes, creation and migration of databases.
• Thorough understanding of Database Concepts of Oracle 8i/9i/10g/11g and very good knowledge of performance tuning.
• Worked with unique and rare combination of Technical and Management skills, also a great team player..
• Strong communication and team skills with proven ability to work on projects with minimum guidance and specifications.

TECHNICAL SKILLS

Operating Systems: Windows 98 / 2000 / NT / XP, LINUX

Scripting: SQL, PL/SQL, and UNIX, Perl, Shell Scripting

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

GUI: Forms 6i / 5.0 / 4.5, Reports 6i / 3.0 / 2.5

Query Tools: SQL*Loader, TOAD, SQL Navigator

Languages: C, C++, JAVA, HTML, XML, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Sr.Oracle Developer

Responsibilities:

• Designed and built Base table load programs.
• Involved in design discussions on mapping of sources to the targets while identifying the required staging tables and transformations.
• Involved in creation of temporary tables.
• Developed PL/SQL scripts to support Data Transfer.
• Worked in creation of Tables using storage parameters and clusters.
• Worked in writing Sub Queries, PL/SQL procedures and Database triggers.
• Developed stored procedures, functions to check the data integrity in Intermediate tables.
• Designed and built Scrub to Base shell changes.
• Unit tested Base table load programs.
• Built one time logic for Transaction history executed 18 months of transaction history conversion and validated the conversion results.
• Control M Scheduling - Design the Production Job Streams, Create On-Line Requests for Control M and document the Control M Processes.
• Created PL/SQL packages, Stored Procedures, Functions and Triggers.
• Used Exception handling for validation of input and the ease of debugging and displaying the error messages in the application.
• Tuning of queries, procedures and functions for better performance using TKPROF and explain plan utilities.
• Loaded data using SQL Loader.
• Performed unit testing and integration testing.
• Involved in Production Support, Problem resolutions and Bug fixing.

Environment: Oracle 11g/10g, Windows XP, UNIX, PL/SQL, SQL, TOAD, OEM, SQL* PLUS, PUTTY, Control M.

Confidential - Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Involved in analysis, Design, Development phases of the project.
• Developed PL/SQL Packages, Procedures, Functions, and Database Triggers to meet the business requirements.
• Created PL/SQL Packages, Procedures, Functions with Dynamic SQL.
• Used Database trigger for making history of insertion, updating, deletion.
• Extensively used Nested tables, PL/SQL tables, Varrays to code Procedures and Functions
• Extensively used Bulk Collections to improve Performance
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Optimizing PL/SQL code and SQL queries (Using Explain Plan, Analyze, Indexes and Hints)
• Responsible for Unit Testing and Integration Testing of PL/SQL Packages, Procedures, Functions and Triggers.
• Proactively resolved QA,UAT and Production Issues

Environment: Oracle 10g, Oracle Forms 10g, Reports 10g, Designer 2000, SQL, PL/SQL, SQL loader, Unix Shell Scripts, Oracle Procedure Builder, HTML, XML

Confidential - Louisville, KY

Oracle PL-SQL developer

Responsibilities:

• Involved in walkthrough sessions with Business Analysts and End users during Development phase
• Developed Triggers, Procedures, Functions and Packages.
• Produced detail design specifications of the system.
• Worked on implementing enhancements to business and logical data models to make the appropriate changes to the physical data model.
• Involved in writing Unix Korn Shell Scripts
• Worked on Performed tuning and optimization of Database Queries, Scripts and Procedures.
• Worked on Crystal Reports for reporting needs of application.
• Worked on converting and manipulating data using SQL Queries
• Supported development effort by building comprehensive data model and documenting Requirements.
• Worked on developing Crystal Reports to design and generate reports.
• Performed audits and System testing.
• Re-wrote stored procedures and optimized data warehouses.
• Involved in writing complex queries to generate reports as per client request as a part of production Support
• Wrote Unit test plans and test cases.

Environment: Oracle Database 9i, Forms 9i and Reports 9i, PL/SQL, SQL*Plus, TOAD, Windows NT, UNIX, PRO *C.

Confidential - NJ

Oracle Consultant

Responsibilities:

• Developed stored Packages, Procedures, Functions and Triggers.
• Worked on designing and developing functional components to determine business requirements.
• Written database triggers to Populate history tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Wrote complex SQL Scripts to manipulate data.
• Extensively worked on developing oracle Forms and Reports using Oracle Developer
• Developed and modified forms as per customer needs.
• Used Server-side Scripting Language PHP for creating dynamic and interactive websites.
• Loaded data from SQL*Loader to Oracle Database tables.
• Actively involved in all phases of Unit and System Testing.
• Actively involved in System Integration testing on the client as well as on the users end.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, OEM, PL/SQL Developer, UNIX and Shell Scripting, VB.Net, HTML, PHP, Perl, Oracle Developer 6i,.

Confidential, Denver, CO

Oracle Developer

Responsibilities:

• Developed stored Packages, Procedures, Functions and Triggers.
• Worked on designing and developing functional components to determine business requirements.
• Written database triggers to Populate history tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments
• Wrote complex SQL Scripts to manipulate data.
• Developed and modified forms as per customer needs.
• Designed, developed and tested reports for various modules.
• Used Server-side Scripting Language PHP for creating dynamic and interactive websites.
• Loaded data from SQL*Loader to Oracle Database tables.
• Actively involved in all phases of Unit and System Testing.
• Actively involved in System Integration testing on the client as well as on the users end.

Environment: Oracle 9i, Forms 9i,Reports 9i,Designer 2000, UNIX, Windows NT, windows 98/2000, MS Outlook 98 and MS Office.

Confidential

Oracle Developer

Responsibilities:

• Actively participated in understanding business requirements, analysis and designing ETL process.
• Effectively applied all the business requirements and transforming the business rules into mappings.
• Translate customer requirements into formal requirements and design documents.
• Developed Mappings between source systems and Warehouse components.
• Used Informatica designer to create complex mappings using different transformations to move data to a Data Warehouse.
• Used aggregator, router, joiner, stored procedures, look up, filter, source qualifier and update strategy transformations extensively.
• Created reusable transformations and mapplets to use in multiple mappings.
• Prepare PLSQL scripts for data loading into warehouse and mart.
• Self-Review of Unit test cases, Integration test cases of all the assigned modules.

Environment: Informatica 6.2, Microsoft Visio 2000, UNIX, PL/SQL.