SUMMARY:

• Over 8 Years of experience in the Information Technology field with extensive experience in Database development and RDBMS based application.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Highly experienced in Software Design, Analysis, Coding, Development and Testing with specialization in ORACLE 12c/11g/10g/9i/8i based on Client - Server & Three-Tier Computing Architecture, Database Design and Development, Implementation, Production Support & Maintenance and Quality Assurance.
• Experience with various technologies such as Oracle, SQL, PL/SQL, Oracle APEX, Oracle Forms and Oracle Reports, SQL*Loader, SQL*Plus, Dynamic SQL, TOAD, PL/SQL Developer, SQL Navigator.
• Extensive experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Views, Cursors, Ref Cursors, Collections, Records, Object Types, Database Triggers, Exception Handling, Forms, Reports, Table Partitioning.
• Experience in development of database objects like tables, indexes, Materialized Views, synonyms, Bulk Binds, Inline Views.
• Hands on experience writing Queries, Stored Procedures, Functions, PL/SQL Packages and Triggers in Oracle and reports and scripts.
• Good Knowledge on Technical architecture and functional flow of Oracle Applications modules such as General Ledger, Account Payables, Account Receivables, Purchasing, Inventory and Order Management.
• Skilled in Database modeling, Loading and performance Tuning.
• Experienced in handling different versions of Oracle Databases.
• Experience in Query Optimization, Debugging, Tuning and improvising performance of the database, using the Oracle tools like Hints, Explain Plan, and TKPROF.
• Knowledge in schema structure design and involved in estimation and optimization of data storage.
• Involved in ETL process from design, development, testing and migration to production environments. 
• 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.
• Excellent ability in writing specifications and gathering requirements from the user to develop reports using Oracle Forms, Oracle Reports and APEX as per the needs of the client and maintain documentation of the reports for future reference.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating data to load data from staging tables to production tables.
• Refine conceptual systems design requirements into the technical design Involved in review and Gap Analysis of Functional Requirement documents. Creation of Technical Documents and related Test Case Document.

Databases: Oracle MS SQL Server 2008, MYSQL, HIVE, MS Access 2000.

DB Dev. Tools: TOAD 8.x/9.x, ERWIN, SQL Developer, PL/SQL Developer, Power Builder , SQL*Plus, SQL*Loader, SQL Server Management Studio.

Business Intelligence Tools/Utilities: Eclipse, CVS, MS Access Reports, SQL, PL/SQL, JIRA, Win SQL, SQL Navigator.

Operating System: UNIX, LINUX, Windows.

Languages/Web: C, Java, SQL, PL/SQL, SQL* Plus, HTML, PIG Scripting, Shell Scripting and MS-Excel, XML.

Reporting Tools: Oracle Forms and Reports 10g/9i/6i, Apex Reports 4.2 Data Warehousing OLAP, OLTP, ETL Informatica, Data Marts, Star Schema, Snowflake Schema.

WORK EXPERIENCE:

Confidential, FL

Oracle Developer

Responsibilities:

• Worked on WICNET (Women’s, Infants and Children) application to register family, clients, Vendors and issuing checks. The application has modules like Vendor Management, Certification and enrollment, Food Instruments, Appointment scheduler, Nutrition eligibility, financial management.
• Involved in gathering requirements and preparing technical documentation.
• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data. 
• Created the test scripts and complex queries to test the application and to quality assurance of the data. 
• Wrote complex SQL queries using joins, sub queries and inline views to retrieve data from the database. 
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. 
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements. 
• Implemented Data ingestion process using UNIX Korn shell scripts resolved application issues in UNIX production environment. Read and interpreted UNIX logs
• Implemented various UNIX scripts to generate the data in CSV and txt format
• Wrote custom support modules for implementation using PL/SQL, Unix Shell Scripts.
• Involved in developing and scheduling using cron jobs to load the data into the database and export/import mechanism for data migration for bulk upload 
• Involved in writing the database triggers to furnish the audit details 
• Used various LOVS (List of Values) and record groups at various points in runtime. 
• Created Various Form Level, Block Level and Field Level Triggers. 
• Developed Master Detail reports using tabular and Group above reports. 
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, Explain plan. 
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc. 
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan. 
• Created indexes on the tables for faster retrieval of the data to enhance database performance. 
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines. 
• Developed Unix Shell Scripts to automate backend jobs, load data into the database. 
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER and Optimized SQL queries, created Materialized views for better performance. 
• wrote modules/packages for application involving Oracle AQ (Advanced Queuing) Streams systems for back-end data transfers with XML type objects wrote modules/packages for application involving Oracle AQ (Advanced Queuing) Streams systems for back-end data transfers with XML type objects.
• Partitioned the fact tables and materialized views to enhance the performance. 
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching. 
• Developed new reports as per Oracle Applications development (OAF)standards and customized existing reports in the PO module according to the client’s requirements.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger. 
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Provided Tier3 Application support with 24/7 production support.

Environment: Oracle 11g, SQL * Plus, HIVE,TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX Shell Scripting, Windows XP, Oracle Form Builder 10g and Report Builder 10g.

Confidential, Framingham, MA

PL/ SQL Developer

Responsibilities:

• Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
• Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE and AP INVOICE LINES INTERFACE tables.
• Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
• Created PL/SQL Packages for easier application OAF design and improved Performance.
• Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader Control files to load the data into the temporary tables.
• Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
• Design, Develop, implementation and Deployment of Self Service Web Applications using Oracle Applications Framework(OAF) Personalization and Extensions to PROD
• Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
• Developed PL/SQL programs using Toad, temporary tables, views as part of OAF customization and development.
• Develop SQL* Loader scripts for data extraction and transformation.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs
• Developed technical design documents (MD70s) using AIM methodology by reviewing MD50s.
• Involved in customization of several reports to serve important business processes very specific to the client. Such reports include GR MRP Monthly Demand Supply Report, GR Vendor Payments Report, GR Demand Push Out Report, GR Payment Register etc.
• Creation of Concurrent Programs for executables like PL/SQL, Reports, SQL*Loader.
• Extensively utilized the Application Object Library to register SQL*Loader programs, PL/SQL procedures and reports.
• Worked extensively with Application Object Library (AOL) by registering OAF forms, reports, creating value sets, lookups, key flex fields, descriptive flex fields.
• Created Concurrent programs and executables and attached it to various request groups, and responsibilities.
• Extensively used error and exception handling techniques for validation purposes in code.
• Involved in the production support of existing systems.
• Extensive use of Collections like V-arrays and nested tables.
• Extensive use of Sub-queries and joins in stored procedures.
• Coordinated with the business users to collect requirements.
• Wrote Test Plans and Involved in Unit testing.
• Worked with the Business users to resolve issues rose through SR’s (Service Requests). The solution is fully tested to ensure the outcome is accepted by the business before moving it to the production environment.

Environment: Oracle Applications(OAF) 11.5.10.2(AP, AR, GL, PO), Oracle 10g/9i, SQL*Plus, TOAD 8.5, SQL Developer, SQL*Loader, UNIX.

Confidential, Durham, NC

Oracle/ Unix/ Informatica Developer

Responsibilities:

• Analyzed Database of Source 9i and target 11g database before and after migration
• Involved in getting the User Requirements, Data Modeling & Development of the system
• Worked on logical and physical data modeling and created Materialized views.
• Played key role in designing and implementing Strategic and Tactical sourcing of data from various systems, processing it and feeding into Data marts and various external systems
• Used PLSQL to Extract Transform and Load (ETL) the data into Data Warehouse and Developed PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Developed stored procedures / packages to run ETL jobs to extract customer information from OLTP database into data warehouse.
• Responsible for decreasing Load times of Data Warehouse by optimizing ETL procedures using PL/SQL
• Involved in ETL (EXTRACT, TRANSFORM and LOAD) in OLAP database to transfer data from source tables into the data warehouse tables using PL/SQL.
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M
• Involved in the LOGICAL & PHYSICAL DATA MODELING of the CSPORTAL application
• Used DBMS SQLTUNE.REPORT SQL MONITOR package to generate sql monitoring report and tune the queries
• Extensively used TOAD and SQL Developer tool for effective Oracle application(OAF) development.
• Improved the performance of Materialized View Refresh from 4 hrs to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the application.
• Upgrade/Migrated the production and development databases from 9i to 11g.
• Involved in the implementation of Database Backup before code release and Recovery
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Enhanced a Champ module's performance in a preexisting product by 2800% faster (reducing runtime from 16 hours to 40 mins) adopting a more efficient data accessing path than the old one.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data.
• Used Oracle Analytical functions such as RANK, DENSE RANK, LEAD, LAG, LISTAGG & ROW NUMBER Functions for sorting data.
• Involved in writing complex hierarchical queries using CONNECT BY PRIOR clauses.
• Handle the Stability/Improvement project - Analyze the Oracle AWR/ADDM report and suggest for performance improvement for slow running reports or jobs, review the database tablespace with DBA and add space to the tablespace, Investigate Major job failure and come up with solution.
• Validation of database after migration from oracle 9i to 11g Exadata.
• Extensively worked on creating partition indexes for large tables.
• Optimized code for the better functionality of several procedures, packages, functions and Triggers.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER, Optimized SQL queries and created Materialized views for better performance.
• HP-Ux Unix shells Scripts migrated to Fedora Linux environment.
• Worked on Several Unix/Linux Wrapper shell scripts like .ksh, .Csh, .sh
• Successfully validated all shell scripts on new Linux environment.
• Worked on control-M Scheduler for successfully working of these validated scripts to run in daily and weekly basis
• Implemented Temp table of rowid’s - Primary key approach to update user id/week no coming from CHAMP (Point of Sale) system into DOTCOM system.
• Developed Informatica mappings and Workflows for some of the sqlldr control files which are actively called in current shell scripts to update staging and master tables.
• Manual and control -M web methods data files catch up are done for parallel database environment.
• Developed shell scripts in Linux environment for automotive load process using existing procedures and packages related to sales/orders, service and manufacturing data.
• Worked extensively on Ref cursors and alter table exchange partition and implemented in many procedures.
• Developed Informatica Workflows as the part of the project as old BODI tool to be eliminated and all Acta jobs to be converted to latest ETL Informatica.
• Worked with Fixed width flat files to load into staging tables.
• Informatica workflows are successfully incorporated inside shell scripts to run accordingly when the control - M triggers the shell scripts based on the schedule.

Environment: Oracle 11g, SQL, PLSQL, SQL*Loader, ETL, SVN, JIRA, OBIEE, RNOW, UNIX Shell script, TOAD, HP Quality Center, Control M

Confidential, Houston TX

Oracle PLSQL Programmer

Responsibilities:

• Generated SQL Script for various services for creating the menu items in the web page.
• Developed PL/SQL Procedures, Functions, Packages and Triggers using Oracle Utilities like PL/SQL, SQL*Loader and Handled Exceptions to handle key business logic.
• Created and used extensively various types of triggers like row level, statement level.
• Created Views, Tables, and Constraints during the design phase of the application.
• Involved in gathering the requirements from the users and write the specs for the project.
• Created scripts for validating extracted data from Legacy systems before loading into target system.
• Wrote Shell scripts for calling SQL scripts to automate the loading and extraction process from legacy system.
• Used Bulk Collect, Bulk Insert, for all statements as needed.
• Worked on User-defined and also the System defined exceptions to handle different types of errors like NO DATA FOUND, ROWTYPE MISMATCH, and PRAGMAEXCEPTION INIT .
• USED SQLCODE and SQLERRM for Error handling.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application(OAF).
• Developed Metadata repository (.rpd), configured metadata the Business Model layer & Physical Data Model and Web Catalogs Objects as per the reporting requirements using OBIEE Admin and Web tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• xtensively used Dynamic SQL wherever necessary in the application.
• Used Dbms job to schedule some procedures, which need to run in every night.
• Used External tables to load the data from excel files.
• Involved in performance tuning using Oracle Hints and Explain Plan for existing Views and Queries.
• Created Materialized Views to reduce query run time for the end user.
• Utilized explain plan, TKPROF, dbms profiler. Dbms stats to gather stats as needed to improve performance.
• Loaded Data from different sources using PL/SQL routines, UTL FILE, EXTERNAL TABLES to the oracle database tables.
• Created relevant staging tables to load data identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting and PL/SQL
• Build several Unix Shell scripts for PLSQL programs to schedule them on Control M

Environment: Oracle SQL 11g, RHEL 5, SQL*Developer, OBIEE, PLSQL Developer, Putty, Python, XML

Confidential, Los Angeles CA

Oracle PLSQL developer

Responsibilities:

• Experience in writing Technical design documents and developing unit test documents.
• Created or Modified the SQL Script (.sql file) to point to the current source.
• Experience in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Created the tables and sequences for the experimental data load capture.
• Wrote Packages to store the business rules and exceptions and wrote PL/SQL code to load data from the flat file to the tables.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Modified the queries by using less functions in the Where condition for reduction of time for Performance issues.
• Loading the Data into tables using SQL loader and using PLSQL Package UTL FILE (ETL).
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Wrote the Unix scripts for scheduling or running the scripts for day to day transactions.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Modifying the queries by using BULK COLLECT and FOR ALL to reduce the time for performance issues.
• High End-Client Interactions for solving User Acceptance Testing (UAT) issues.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL Enhanced it with creating exceptions for error handling.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Hands on Exposure on 2010 TFS Version Control. This includes splitting and merging of code branches in various Release and Version Management. Experience in Checking in checking out the code in TFS (Team Foundation Server).
• Written complex Oracle SQL queries with complexity using Inner/Outer joins, Indexes, Sequences, Union All, Intersect & Minus set operators.
• Rich experience in writing SQL queries, Anonymous blocks, Views, Materialized views, PL/SQL procedures, functions, packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor, Dynamic SQL.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view on source side.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect.
• Experience in using the Trace files and TK proof whenever required for performance issues.
• Responsible for Unit, System and UAT testing the data.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Resolving the Tickets and pulling the data from the Transactional database and Archive database for the reports.

Environment: Oracle 10g, PL/SQL, SQL*Plus, OBIEE, PL/SQL Developer 6.0, Toad, UNIX, LINUX, TFS.

Confidential

PL/SQL Developer

Responsibilities:

• Wrote and modified Oracle PL/SQL , SQL statements procedures and functions in Toad for Oracle 11.0.
• Created Stored Program Units like Functions, Triggers and procedures for implementing complex database intensive business rules.
• Used features like bulk collect to process large amount of data in data base.
• Improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL.
• Worked as a SQL developer to support business applications using Oracle SQL and PL and SQL.
• Created Tables , Indexes, views, Sequences, Synonyms and stored program units.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the database using SQL* Loader .
• Involved in analysis, design, coding and Testing .
• Built and maintained SQL scripts, indexes, reports and queries for data analysis and extraction.
• Involved in creating Database Design (Physical and logical) as per the requirement given by business.
• Analyzed tables and indexes for Cost Based Optimization (CBO) to work efficiently.
• Work towards a balanced, risk-driven SDLC target.
• Gathered Statistics and Analyzed Tables and Indexes for Performance tuning .
• Extracted data from Flat files using SQL*LOADER.
• 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.
• Executing and maintaining the data warehouse extract transform load (ETL) process
• Made use of performance tuning utilities like explain plan, SQL Trace and DBMS PROFILER to reduce the run time of complicated queries on Oracle 11g.
• 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.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Migrated data from MS Excel sheets to Flat files.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.
• Interacted with client to gather the requirements and implement the same in the project.

Environment: Oracle 10g, Toad for Oracle 10.0, Oracle Enterprise manager, SQL*Loader, Unix Shell Scripting, Humming Bird 10.0.0.1