EXPERIENCE SUMMARY

• Around 7 Years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle 8i/9i/10g,11gR1 and 11gR2, SQL, PL/SQL that includes Complete System Development Life Cycle from Analysis and Design to Implementation.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite 10g and other front - end tools.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Proficient knowledge in HTML and JavaScript.
• Exposure to concepts of Data warehouse like Design, Data Modeling, ETL and Reporting
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries, migrating the code to different databases and schemas.
• Involved in migrating the code from old legacy systems to the new systems.
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Around 4 Years of Experience in Pearl Scripting & UNIX Shell scripting Perl/sh/awk.
• Designed and developed the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query
• Hands on experience in tracking down the bottlenecks in query using trace files.
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Participated in all Business Intelligence activities related to data warehouse, ETL and report development methodology.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Excellent analytical and interpersonal skills, oral and written communication skills.
• Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.
• Strong personal drive and ability to work individually and in team environments.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators at all levels.

TECHNICAL SKILLS:

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

Languages: JAVA,C,C++,VB6.0,SQL,PL/SQL,FOXPRO

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD,SQL*Plus, SQL*Loader, Oracle procedure Builder, Bugzilla

Development Tools: Developer 10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

Reporting Tools: Crystal Reports, Oracle Reports

Scripting Languages: Java Script, UNIX Scripting

Web Technologies: HTML

PROFESSIONAL EXPERIENCE

Confidential, MS

PL/SQL Programmer

Responsibilities:

• Involved in system analysis design, coding, data conversions, development and implementation.
• Developed PL/SQL Packages, Procedures, Functions and Triggers, cursors accordance with Business requirements for loading static data into database tables.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Experience working on oracle databases using SQL and PL/SQL queries.
• Hands on experience on SQL loader and TOAD.
• Modifying existing packages, procedures, functions and triggers according to the new business requirements.
• Fixing bugs in Oracle Server for a bug free application.
• Creating/Updating packages, stored procedures, functions, tables, databases in Oracle Server.
• Experience in migrating the code from one database to the other environments like Teat and UAT.
• Involved in migration of data from old systems to the new systems.
• Experienced in Version Control Tool like Tortoise SVN.
• Debugging packages in Oracle Server and modifying them according to the business and application requirements.
• Solving and fixing issues or defects in the application.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Knowledgeable on HIPAA compliance regulations and worked in HIPAA compliance environment.
• Developed Test cases for Unit testing and user interface testing.
• Performed unit and integration testing for the front end application.
• Support for the development, pre-production, documentation and the production databases.
• Responsible for coding and modifications to enforce business rules and to improve performance of the system.

Environment: Oracle 11gR1, WINDOWS 7, PL/SQL developer, Tortoise SVN, Bugzilla, beyond compare3.

Confidential OH

Oracle PL/SQL Developer

Responsibilities:

• Developing complex Sql scripts to accommodate multi-dimensional hierarchies in Unix Evironment.
• Working on APEX forms to all CTE in one place
• Generating Dynamic SQL and running them at run time.
• Involved in generating reports and forms using Oracle Developer 11g R1.
• Altered the procedures and functions according new business requirement.
• Unit testing the complex data loaded and METRICs
• Working with Macys and Kroger requirements individually to meet their individual requirements.
• Experience in working with Business Intelligence tool (Enterprise Guide) Software for analytical tasks.
• Involved in Developing and Generating Reports.
• Involved in designing and developing the Extraction, Transformation, and Loading (ETL) program to move data from source to target.
• Preparation of the Test Cases and involvement in Unit Testing and Integration Testing.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed performance tuning using Explain Plan, Hints the newly generated scripts.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes
• Involved in tuning of SQL queries manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle 11g, UNIX, PL/SQL Developer, SOA

Confidential, VA

Oracle PL/SQL Developer

Responsibilities:

• Wrote stored PL/SQL Procedures for reports.
• Developed PL/SQL scripts for data processing.
• Created Indexes, Views and Tables
• Optimized the existing UNIX scripts to achieve better performance.
• Wrote triggers and procedures to handle the data processing.
• Created scripts to trigger nightly batch processes.
• Involved in Developing and Generating Reports.
• Experience with Enterprise Guide in generating analytical reports.
• Preparing Unit test scripts, setting up a test environment and unit testing the code.
• Tuning of the SQL statements for application developers.

Environment: Oracle 10g, PL/SQL, Report Builder 10.1.2.0.2, Toad 7.5.2.0, Unix, Perl

Confidential, OH

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Development was done extensively on collections (Associative Arrays, Nested Tables)
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment Oracle 10g, UNIX, MS visual studio 2005

Confidential,

Oracle PL/SQL Developer

Responsibilities

• Involved in creation of Tables using storage parameters and clusters.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Created user defined Exceptions while handling exceptions.
• Wrote stored procedures, Functions and Database triggers using PL/SQL.
• Conducted training sessions for the end-users.

Environment: Oracle 8i, SQL*Plus, Windows 2000