SUMMARY

• 8+ years of Experience in the field of Software Design, Development and Implementation wif Proficiency in Oracle, SQL, PL/SQL, Oracle Forms.
• Have exceptional record overseeing all facets of Software Development Life Cycle from analysis and design to implementation and maintenance
• Expertise in developing business applications using Oracle SQL,PL/SQL 9i, 10g and 11g databases and Forms 6i, 9i, 10g and Reports 6i, 9i.
• Created and maintained Forms and Reports (Designing the new forms as a GUI to make interactions wif the database transactions for the end user to make changes in the database which includes many validations. Modified the existing forms as the requirement changes. Designed the reports as the business requirements needs)
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Extensively used SQL* Loader and Datastage as an ETL tool, TOAD and SQL* PLUS for writing several SQL queries to pull the data, and for determining the optimization level of the query.
• Good Experience in Analysis, Designing and Normalization of Databases
• Expert in developing Functions, Procedures, Packages, Cursors and Triggers
• Expert in using oracle tools - PL/SQL Developer, TOAD and SQL*Plus
• Experienced in Troubleshooting and Maintenance of Database Objects
• Experienced in developing reports using Oracle Developer Reports suite 6i,9i
• Extensive experience in creating Forms using Oracle Developer Forms suite 6i,9i and 10g
• Good experience in Test Case Preparation, Test Case Execution, Bug Reporting and Bug Fixing
• Extensive experience of working in different environments like Unix and Windows
• Experienced in Unix Programming(Shell Scripting)
• Worked extensively on PARTITIONS to enhance performance and archiving of a DW.
• Worked on the physical transformation of the data model which involved creating the database objects like Tables, Indexes, Stored Procedures, Functions, DB Links, Packages and Triggers, Materialized Views
• Designed database schema's using Entity relationship modeling wif ER diagrams & database normalization principles
• Experience in application development like Bulk Collect, for all, Dynamic SQL, Autonomous Transactions, and Global Temporary Tables.
• Knowledge of Oracle application in General Ledger, Account Payable, Account Receivable.
• Experience in Back ends Testing of the applications by executing complex SQL commands.
• Experience in requirements gathering, functional gap analysis, application design, configuration, and module setup, test script generation, writing training guides, training end users, and production support.
• Working Knowledge in .Net & Java Script.
• Good experience in working Onsite - Offshore Model.
• Exposure to all stages of a software development life cycle methodologies - from inception to end user testing in a developer role.
• Self-motivated, flexible, proactive, responsive, goal oriented and rapid learner.
• Good team player wif excellent Communication, Presentation and Interpersonal skills.

TECHNICAL SKILLS

Languages/Tools: Toad 9i, PL/SQL Developer, SQL*Plus, SQL*Loader, C/C++, JavaSQL Developer, SmarTerm, Attachmate, UC4 Scheduler, Subversion, .NET

ERP: Oracle Applications 11i/R12

GUI/Reporting Tools: Forms 6i/10g/11g, Reports 6i/10g/11g

Databases: Oracle 11g/10g/9i/8i, Sql Server

Operating Systems: Windows 7/XP/NT/2000/98/95, LINUX, UNIX, MAC OS

Web Tools: HTML, JavaScript, XML, UNIX Shell Script, Perl

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. Oracle PL SQL Developer

Responsibilities:

• Worked wif Data migration team, provided the mapping between the source and Confidential systems
• Involved in gathering requirements from Business users.
• Coordinated wif offshore and performed a team lead role.
• Developed Java modules, PL/SQL packages, procedures, functions.
• Modified interfaces for an application using Oracle Forms.
• Involved in design, development and modified of most of the business critical Oracle Forms modules, PL/SQL stored procedures, functions, packages, triggers to implement business rules into the application.
• Worked in .NET environment to support developer as per their requirement.
• Designed intermediate database tables as per technical specifications
• Involved in coding of data extraction scripts as per technical specifications
• Coordinated wif DBA in creating and managing tables, sequences, indexes and privileges.
• Worked to translate business information requirements into technical data definitions.
• Worked closely wif business analysts to understand and document business needs for decision support data.
• Performed code reviews and implemented the code.
• Created stored program units like functions, triggers and procedures for implementing complex database intensive business rules.
• Generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Developed procedures using native dynamic SQL (EXECUTE IMMEDIATE), dynamic SQL, Ref cursors.
• Used PL/SQL collections like PL/SQL tables, V-arrays and nested tables.
• Developed Unix Shell Scripts to automate backend jobs and load data into the database using SQL* Loader.
• Involved in data modeling and design (physical and logical) as per the requirement given by business.
• Developed and delivered LRT data warehouse classes in beginning, intermediate, and advanced logical and physical data modeling and the use of the ER/Studio modeling tool.
• Executed and maintained the data warehouse extract transform load (ETL) process.
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. Created Partitions on the tables to improve the performance.
• Extensively used Bulk Binds (BULK COLLECT and FORALL) wherever applicable.
• Made use of performance tuning utilities like explain plan, SQL Trace and dbms profiler to reduce the run time of complicated queries on Oracle 12c.
• Used performance tuning techniques like Partitioning, Partition pruning, Index by Tables, Bulk Collect, materialized views and Oracle hints.
• Performed DBA activities for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Implemented RDBMS (normalization) concepts in Data modeling.
• Used analytical functions like RANK, LAG, LEAD and PARTITION BY.
• Analyzed business requirements, preparation of source- Confidential mapping documents, conducted unit testing and code walkthroughs to ensure there are no missing elements, and performed integration testing.
• Constructed complex SQL queries wif sub-queries, inline views as per the functional needs. Create SQL scripts to perform unit and component testing.
• Migrated the data from excel sheets, text files into the respective Oracle Database tables using SQL *Loader * Benthic Import Export Utilities.
• Used Pragma Autonomous Transactions.
• Worked on Oracle APEX for development of functional capability.
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Separated Tables and Indexes on different locations for reducing Disk me/O Contention.
• Wrote new code based on existing complex code to make it more understandable to person working in the same process.
• Worked wif Informatica for ETL purpose and transformation.
• Implemented External tables and created Sequences to generate numbers on the fly.
• Co-ordinated between Development, Testing and Production teams and attending bridge calls and technical discussions regarding future developments and releases.
• Involved in Technical Documentation, Unit test, Integration test and created the Test plan and Production Support documents.

Environment: Oracle 9i/11g, SQL*Plus, PL/SQL, SQL, Java, UNIX Shell scripting, TOAD, Jdeveloper, .NET.

Confidential, Jasper, IN

Sr. Oracle PL SQL Developer

Responsibilities:

• Worked wif Data migration team, providing the mapping between the source and Confidential systems.
• Worked to translate business information requirements into Functional Requirements and technical data definitions.
• Worked closely wif business analysts to understand and document business needs for decision support data.
• Document and communicate changes to theOLTP, OLAPsystems and data warehouse teams, includingData Modeling, ETLand Database teams.
• Coordinated wif offshore and performed a team lead role.
• Developed PL/SQL packages, procedures, functions.
• Processed the files from other systems and loaded in external tables to manipulate data obtained daily before loading them into the tables.
• Developed ETL Process to load the data through batch jobs.
• Scheduled and monitored the batch jobs in Production environment.
• Designed intermediate database tables as per technical specifications.
• Involved in coding of data extraction scripts as per technical specifications. to return large response.
• Coordinated wif DBA in creating and managing tables, indexes, db links and privileges.
• Developed cross reference tables needed for the data migration from the source to Confidential systems.
• Performed code reviews and implemented the code.
• Develop logical and physical data models dat capture current state/future state data elements and data flows using Erwin.
• Worked wif SQL*Loader and External Tables to load weekly flat files into staging tables.
• Developed procedures to move data from staging tables to production tables.
• Created PL/SQL packages, procedures, functions applying the business logic to calculate Communication Volumes (by touchpoint & communication channel), Response Rates (Customer Pay & Warranty Pay breakouts), Dealer ROI Metrics, Key Program Headquarters Statistics, Revenue Generated Statistics (cumulative and per CP RO), Services Purchased (e.g. Brakes, Batteries, Tires, etc.), etc.
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• Created data for Crystal Reports using procedures and complex Queries.
• Exclusively worked on UNIX environment and rewrote complex UNIX shell scripts as per the requirement.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Documented design specifications and architecture using Microsoft Visio.
• Involved in Technical Documentation, Unit test, Integration test and writing the Test plan and Production Support documents.

Environment: Oracle 10g/11g, SQL*Plus, PL/SQL, SQL, UNIX Shell scripting, TOAD, Attchmate tool,.NET.

Confidential, Durham,NC

Oracle Forms & PL/SQL Developer

Responsibilities:

• Involved in design, development and modified of most of the business critical Oracle Forms modules, PL/SQL stored procedures, functions, packages, triggers to implement business rules into the application.
• Created SQR reports and file reading processes to generate business reports and to load the external data to the Security Database.
• Oracle modules to parse XML CLOB to support front-end security application. After parsing the XML, we store the data to respective tables.
• Oracle modules to generate XML CLOB to send the data to front-end screens.
• Data Migration to three systems and used ETL process and batch jobs to transfer data.
• Supporting the project from feasibility, analysis, development, testing, Implementation.
• Developed detailed ETL Plan for loading the staging area from the Oracle database and tan from Staging area to the Data Mart.
• Created database objects like Tables, Indexes, Sequences and Views.
• Modified interfaces for an application using Oracle Forms 6i.
• Responsible for writing and modifying shell scripts in UNIX.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Created the Shell script to call loader and PL-SQL scripts and to get the data from other systems and to FTP data from our server to other server.
• Written UNIX shell scripts and scheduled cron jobs.
• Involved in Database Tuning and Improved Application performance using Explain Plan and SQL trace.
• Loading of the data from flat files into staging tables using SQL Loader.
• Created Stored Procedures to perform validations on data and to move data from staging tables into the base tables.
• Loading of data from flat files into the user interface forms using Data Loader.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance phases.

Environment: Oracle 9i/10g/11g, SQL*Plus, PL/SQL, SQL, UNIX Shell scripting, Forms 6i/10g, SQL*Loader, TOAD, .NET, SmarTerm.

Confidential, Minneapolis,MN

Oracle PL SQL Developer

Responsibilities:

• Analyzed the requirements and specifications accordingly.
• Responsible for creating the Database Objects.
• Prepared program specifications for PL/SQL Packages, Procedures, and functions to do the migration and conversion.
• Processed XML files as CLOB using DOM parser and stored the information into respective tables.
• Retrieved data from DB2 system as external files and loaded to Data mart using External Tables.
• Scheduled ETL jobs for loading data from external systems to Data Mart.
• Building SQL*Loader scripts, Oracle Warehouse Builder Scripts to load XML files, Flat files and Excel Files into tables.
• Analyzed the data in the Data Warehouse after the ETL process to ensure if all the data TEMPhas been captured and also to ensure the accuracy of data.
• Written complex SQL statements using joins and sub queries.
• Used Dynamic SQL (DBMS SQL, DBMS DDL) in functions and procedures.
• Responsible for writing shell scripts in UNIX.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from flat file intotemporary staging table and developed PL/SQL program to load data from temporary staging tableinto base tables.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Joins, Database Links and formatted the results into reports and kept logs.
• Developed Control Files for loading staging tables from Flat Files using SQL*Loader.
• Have modified a PL/SQL procedure to change the Oracle Incentive Compensation processing part of the web application developed wif PL/SQL.
• Developed forms using Forms6i using based on client requirement.
• Prepared technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.
• Modified the existing database objects to meet the expanding business requirements.
• Loaded the data from flat files into staging tables using SQL Loader.
• Created Stored Procedures to perform Validations on data and to move data from staging tables into the Base tables.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance of the System.
• Created UNIX shell scripts and scheduled Cron jobs.
• Performed Unit, Regression and System testing and documentthe test plan and test results.
• Used TOAD and Developer tools for faster application design and developments.
• Tested the application to ensure proper functionality, data accuracy, and dat modifications haveno adverse Impact on integrated system environment.
• Involved in creating user manuals and End User training.

Environment: Oracle 10g, Oracle 9i AS, SQL*Plus, PL/SQL, SQL, UNIX Shell scripting, Oracle JDeveloper, Forms 6i/10g, SQL*Loader, Discoverer, T

Confidential

Oracle Developer

Responsibilities:

• Creation of PL/SQL Stored Procedures, Functions and Packages and Triggers.
• Creation of database objects like Tables, Views, Materialized views, Procedures, Packagesusing Oracle utilities like PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions
• Developed many packages using PL/SQL to do the validations as per requirements.
• Generate SQL Scripts and created views for reports.
• Used Toad to Extract and test the data in the database.
• Developed Database Triggers to enforce security.
• Involved in Data Extraction using UTL FILES in PL/SQL.
• Developed forms using Forms6i using based on client requirement.
• Prepared technical documents for all the programs developed & generated.
• Responsible in coding, trouble shooting and debugging.
• Modified the existing database objects to meet the expanding business requirements.
• Loaded the data from flat files into staging tables using SQL Loader.
• Created Stored Procedures to perform Validations on data and to move data from staging tables into the Base tables.
• Responsible for creating the technical design document.
• Involved in Development, Testing and Maintenance of the System.
• Created UNIX shell scripts and scheduled cron jobs.

Environment: SQL, PL/SQL, Oracle 9i/10g, Sql developer, SQL*Plus, UNIX shell scripting, Perl