SUMMARY:

• More than 13 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, and Database Triggers for Oracle Relational Databases.
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Experience in Query optimization & Performance tuning using Explain Plan, Performance Monitor.
• Implemented performance tuning techniques at application, database and system levels
• Proficient in Oracle Tools and Utilities such as SQL*Loader, TOAD, SQL Developer, and PL/SQL Developer
• Experience in Design and Implementation of PL/SQL Stored Procedures, Functions, Packages, Ref Cursors, Constraints, Database Links, UTL file and Triggers for Oracle Relational Databases.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism
• Proficient in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Extensive development experience in data designing, mapping, Loading data, Testing and Tuning databases.
• Extensively worked in Client - Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
• Very Good experience with UNIX Cron Jobs, shell scripting, Batch Processing with highly complex data model.
• 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.
• Experience in data extraction from heterogeneous sources using Informatica Power center
• Experience in UNIX shell programming.
• Solid understanding of Relational (ROLAP) and Multidimensional (MOLAP) modeling, broad understanding of data warehousing concepts, star and snowflake schema database design methodologies and Meta data management.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge etc
• Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Experience in developing user interface for database applications using the Oracle Apex.
• Strong analytical skills with ability to quickly understand clients’ business needs and identify available data sources and the relationships that exist within them.
• Experience in Oracle Apps 11i GL, AP, AR, OM modules.
• Ability to learn and adapt quickly in a dynamic environment and Ability to work on multiple projects against aggressive deadlines.
• Good Communication, Writing, Presentation, Workforce Management, Interpersonal and Analytical skills, along with the ability to work on multiple projects and prioritize workload
• Self starter can work independently as well as a good team player.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, SQL server 2000/2005, MS Access (2000, XP)

DB Utilities: SQL*Plus, SQL*Loader

IDE s: Oracle SQL Developer 1.2/1.5

RAD tools: Oracle Reports 6i, WinScp, and FTP etc

Languages: SQL, PL/SQL, C, Java.

Version Control tools: PVCS, IBM Rational Synergy 7.1

Operating Systems: Windows95/98/2000/XP/NT4.0,UNIX (Sun Solaris, HP-UX)

Developer Tools: Reports 6i, TOAD 10.1, 9.6.1, 8.5, 8.1, Eclipse IDE

Web Technologies: HTML, XML Publisher

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh NC

Solution Architect /Sr. Oracle Developer

Responsibilities:

• Implemented Archiving process for security tables to improve performance and reduce the batch run time from 18 hours to less than 5 hours.
• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using TOAD tool.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Created and modified database objects such as Tables, Views, Materialized views, Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
• Designed and developed several complex database procedures, packages. Extensively used features like Cursors, autonomous transactions, distributed transactions, exception handling, Dynamic, pl/sql tables, bulk load methods, optimizer Hints, Cursor variables and returning of multi record set from procedures and functions
• Partitioned Tables using Range Partitioning, List Partitioning and created local indexes to increase the performance and to make the database objects more manageable
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance.
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Improved the performance of Materialized View Refresh from 4 hrs to 25 min using WITH clause/MATERIALIZE HINT, Indexes and Bulk Processing.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, Indexing and Hints.
• DBMS STATS is used to collect and build various Data statistics to provide information to COST based optimizer, to find chained rows, to build histograms.
• Implemented CTAS (Create Table As Select) approach to optimize archive process.
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Used Bind Variables while writing Dynamic SQL to improve performance.
• Involved in performance tuning using Indexes, Hints, Explain Plan, Stats gathering etc.
• Involved in writing complex SQL Queries to implement the business requirements.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.

Environment: Oracle 10g/11g, SQL, PLSQL, SQL*Loader, Oracle Exadata Database Machine X2, Java, ETL, Actimize, SVN, JIRA, RNOW, UNIX Shell scripting, Framesoft, TOAD, HP Quality Center, Control M, Tortoise SVN

Confidential, NY

Sr. Programmer Analyst/Oracle Developer

Responsibilities:

• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures, Records and Collections using TOAD tool.
• Used Bulk Collect, PL/SQL tables, arrays and other collection for huge data manipulations and improve the performance of the system. Involved in the detailed data mapping from the source legacy systems (WWCOM, CSPORTAL) extract files to the Oracle Payables tables.
• Implemented CTAS (Create Table As Select) approach to optimize an update process reducing runtime from 14 hours to 4 min 36 sec.
• Provide quality operations support for production environment. Work with QA and provide support to provide timely technical resolutions for defects.
• Gathered the business requirement from clients and translated the business details into technical requirements.
• 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.
• 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.
• AUTONOMOUS TRANSACTION PRAGMA is used in the procedures to log the status when error occurs.
• Involved in the LOGICAL & PHYSICAL MODELING of the CSPORTAL application.
• Involved in performance tuning using HINTS, EXPLAIN PLAN.
• Involved in writing complex SQL Queries to implement the business requirements.
• Used SQL* Loader and UTL FILE Packages for data conversions and interfaces.
• Expertise in handling System Analysis and Business Analysis related issues when the application is in earlier stages.
• Involved in client interaction, handling change requests and implementing the application on the client side.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Coordinated with the business analysts for requirements analysis.
• Used techniques like direct path load, external tables for loading the data faster.
• Developed technical design documents by reviewing functional requirement documents.
• Involved in preparing the test scenarios and performed unit tests on PL/SQL programs.

Environment: Oracle 10g/11g, PL/SQL Developer, SQL*Plus, TOAD 10.1, SQL*Loader, Windows Server 2003/Windows XP/Windows 7, UNIX, IBM Rational Synergy 7.1, Eclipse IDE, Bing Maps API.

Confidential, PA

Oracle Developer

Responsibilities:

• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve the selected data from the Data repository using cursors and exception handling.
• 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.
• Before ETL, Involved in Data Analysis, Data Design, Data Integration and Data Mapping.
• After ETL, Involved in Data Validation, Data Performance in loading target table and for reporting purpose.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data
• Developed various Mappings to load data from various sources using different Transformations.
• 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.
• Created and modified database objects such as Tables, Views, Materialized views,Indexes, Sequences and constraints, SQL queries (Sub queries and Join conditions).
• Used Bulk Collect, Bulk Insert, Update functions in the ETL Programs.
• Created and used Table Partitions to further improve the performance while using tables containing large number of columns and rows.
• Extensive use of Oracle External Tables which is used to load the flat files (Essbase Extract) into Oracle Database.
• Extensively involved in performance tuning using Explain Plan, DBMS PROFILER and Optimized SQL queries, created Materialized views for better performance.
• Over 80 objects are analyzed to ensure modifying existing structure will not create potentially unwanted behavior to downstream processes.
• Documented the PL/SQL packages, log files, locations and descriptions, log tables and possible error codes and message descriptions
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle 9i, SQL*Plus, TOAD 10.1, SQL*Loader, Windows Server 2003, Windows XP.

Confidential, PA

Sr. Oracle Developer

Responsibilities:

• Used SQL*Loader and PL/SQL programs to Convert data from many legacy systems to Oracle 10g and to store data in the Oracle database from different types of flat files.
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.
• Designed, developed and enhanced custom Oracle Reports 9i according to the functional specification.
• Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.
• Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling.
• Generated DDL scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, Records and Collections using TOAD tool.
• Creating test plans for Unit and system integration test for the Metrics Tracking and Change Tool (MTACT), XTACT, eCPR applications and performed end to end tests of the system when it was migrated to a new data center for Frontier communications The Applications are web based used by Verizon to create controlled repeatable process to support the Wholesale Metrics Change Control process and to assure Verizon management, external state commissions and competitive Local Exchange Carriers (CLECs) that metric-related changes are made in a systematic and auditable manner.
• Extensive use of Collections like Varrays, nested tables and Sub-queries and joins in stored procedures.
• Support and modify existing PL/SQL code (Flow Through’s) in various legacy systems.
• Performed SQL and PL/SQL tuning to improve the performance with the help of SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• Used Bulk Collect, PL/SQL tables, arrays and other collection to improve the performance of the system.

Environment: Oracle 9i/10g, PL/SQL Developer, SQL*Plus, TOAD 9.6, SQL*Loader, Oracle Forms & Reports 10g/6i, Windows Server 2003, Sun Solaris, UNIX

Confidential, TX

Sr. Oracle 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.
• Created tables, schemas, views, Materialized Views, Indexes etc using TOAD tool created complex Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections using PL/SQL for implementing complex business logic.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS PROFILER.
• Extensively used TOAD and SQL Developer tool for effective application development.
• Extensive experience in using Oracle Utilities like export/import utility and SQL Loader
• Used SQL*Loader and PL/SQL programs to Convert data from legacy system to Oracle 10g and to store data in the Oracle database 10g from different types of flat files.
• Developed Packages to validate the new raw data which was loaded into the database tables from the flat files by SQL* Loader.
• Optimized critical queries to eliminate Full Table scans.
• Legacy Data mapping with Oracle system 10g.
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
• Created several Oracle Reports with master-detail, matrix, and label report styles
• Used Savepoints, Commits, and Rollbacks to maintain transactional consistency and database integrity.
• Used SQL*Loader, Oracle Import, Export to load data into the data mart schemas from flat files for data transformation and processing
• Performed unit and integration testing of the applications created using Oracle Forms 10g and PL/SQL modules and used PVCS for version control in team development
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables from different systems and validating the data.
• Developed complex SQL queries using Joins, nested queries, in line Views, in built Packages, Functions and clauses
• Performed PL/SQL code reviews for maintaining standards and to identify inefficient SQL statements
• Interacted with developers and Quality Assurance team for resolving application and database related problems.

Environment: Oracle Applications 11.5.10.2, Oracle 10g, SQL*Plus, TOAD 9.0, SQL*Loader, Windows NT, Sun Solaris

Confidential, CA

Oracle 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.
• 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.
• Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
• 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.
• 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 Varrays 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 11.5.10.2(AP, AR, GL, PO), Oracle 10g/9i, SQL*Plus, TOAD 8.5, SQL Developer, SQL*Loader, UNIX.

Confidential

Oracle Developer

Responsibilities:

• Developed technical design documents (MD70s) using AIM methodology by reviewing MD50s and interacted with functional team to build technical extensions.
• Developed new reports as per Oracle Applications development standards and customized existing reports in the PO module according to the client’s requirements.
• Analysis, Development and documentation of Importing Vendor Information from external systems.
• Designed and developed multi reports using Oracle Reports 2.5
• Designed and developed PL/SQL functions, stored procedures, packages
• Developed Oracle PL/SQL Packages/Procedures for importing and exporting of hierarchies into the database. Used UTL FILE package to export the data from relational tables to flat file. Inserting Hierarchical data into relational tables using Oracle pl/sql package.
• Coordinated with the business users to collect requirements.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging.
• Worked on logical and physical data modeling and created Materialized views.
• 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.
• Utilized tools like TOAD during development of the application.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Plus, UNIX, Windows 2000.