SUMMARY

• Proficiency in writing PL/SQL Packages, Stored Procedures, Functions, Packages, Database Triggers, views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects, Indexes, Sequence, Synonyms, Roles and privileges using SQL and PL/SQL.
• Around 8 years of extensive experience as Oracle PL/SQL Developer which involves Data analysis, design, development, implementation, integration, testing and support.
• Besides the PL/SQL development, have experience in developing Oracle Forms & Reports using Reports 10g/6i and Forms 10g/6i.
• Extensive experience in Oracle backend objectslike: Database Triggers, Stored Procedures, Functions, and PackagesusingPL/SQL.
• Robust experience in RICEW modules and held positions where major responsibilities included coding, unit testing reports, interfaces, conversions & enhancement programs, workflows and performance tuning on the backend side and considerable experience in UNIX Scripting.
• Experience with Partitioned Tables, DB Stats, PL/SQL object types.
• Extensive experience working with database structure, DDL.
• Experience with data flow diagrams, data dictionary, and database normalization design techniques.
• Experience in the Client - Server application development using Oracle 11g/10g/PL/SQL, SQL PLUS, TOAD and SQL Loader.
• Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Indexes, Explain plan, Trace utility & TKProf.
• Hands-on experience working with Smart BPM Methodology and Direct Capture of Objectives tool (DCO Tool- Application Profile and Application Document) for capturing business requirements.
• Proficient in DB Pharmacy tool to monitor performance.
• Proficient in making changes to the existing DB objects without impacting the other logic.
• Proficient in writing complex queries wherever required with the optimized plan.
• Proficient in implementing Autonomous Transactions and Exception Handling in a well-structured manner.
• Registering of Custom Applications/Table/Schemas in Oracle Applications.
• Extensive experience in using database tools like TOAD, SQL Developer, SQL*Loader, SQL *Plus, MS Access.
• Implemented SQL program to load data from Excel files, Flat files into temporary table using UTL FILE utilities and SQL loader.
• Experience in using several built-in database packages such asDBMS JOB, DBMS OUTPUT, UTL FILE, andDBMS SQLto name a few.
• Immensely worked on System Administration responsibilities such as registration of concurrent programs, creation of Users, Responsibilities, Forms, Menus, Functions, Value sets and Flex fields in Oracle Applications using AOL, UNIX shell scripts.
• Involved in development of custom reports using Reports 10g and XML/ BI Publisher.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions based on the client’s requirements.
• Worked on Forms Personalization to handle the form customizations.
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Developed reports using Oracle Discoverer (D2k) by creating EUL, Business area, custom views, new folders, custom folders, complex folders, conditions, joins and building discoverer workbooks.
• Involved in generation of custom XML reports incorporating client’s emblems and other JPEG images for the fancy and quality facilitated reports.
• Experienced in Database Design, Migration, Data Modeling, and Systems Architecture, Planning, Testing and Trouble Shooting, Schema Design.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Experience in usingDBMS SCHEDULERto run jobs in parallel to improve time-constrained performance.
• Worked with both Onsite-Offshore project models and proven characteristics of being highly motivated.
• Strong interpersonal, problem-solving and analytical skills. Self-Starter and ability to work independently without any supervision.

TECHNICAL SKILLS

Development Tools: TOAD, SQL*Developer, SQL*Loader, BI Publisher, FND LOAD, SQL*PLUS, Forms & Reports 10g/9i/6i, Oracle Discoverer10g, XML Publisher, Workflow Builder, ADI & EDI Gateway, Putty, Citrix, EditPlus, Beyond Compare.

ERP Versions: Oracle E-Business Suite R12, 11i

Languages: SQL, PL/SQL, J2SE, UNIX, PowerShell/Perl scripting HTML, XML, C and Java Scripts.

Database: Oracle 9i/10g/11g, SQL Server 2005/2008/2012 , MS Access

Version Control: TFS and VSS.

Tracking Tools: Quality Center, DB Doppler, PEGA related Tools-PMF

Document Methodologies: BR100, BP80,MD.070, MD.120, TE.020, CV.040

Operating Systems: Windows, UNIX, SUN SOLARIS, LINUX.

PROFESSIONAL EXPERIENCE

Confidential - Malvern - PA

Oracle Sr. PL/SQL Developer

Responsibilities:

• Understanding existing functionality, carryout impact analysis for the requested enhancements and present it to customer.
• Ability to create Functional Spec document based on business requirements
• Developing Complex SQL & PL/SQL code for supply chain application.
• Analyzed the database tables and indexes and then rebuilt the indexes if there is fragmentation in indexes.
• Tuned database SQL statements and procedures by monitoring run times and system statistics. Inserted hints and rewrote code as required.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Developing various PL/SQL stored procedures, functions and packages.
• Understand key business performance levers (on-time delivery, cost, feasibility, etc.) and seek solutions to improve these metrics.
• Work within GSSC to identify, define, develop and execute modeling approaches and projects under the direction of project managers or sponsors; Participate in development of modeling approaches in partnership.
• Tasks included development and execution of Unit Testing, source code management via Subversion (SVN) and construction of SQL deployment scripts for the various test environments, DEV.
• Apply creative analysis to identify performance improvement opportunities and effectively communicate findings within the leadership team.
• Review and validate data, build and validate models, run scenarios, and assist in the preparation of business proposals.
• Document modeling approach, data sources and transformations, assumptions and constraints.
• Maintain record of all maintenance release for all applications and maintain knowledge of all enhancements.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan and DBMS PROFILER.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Assisted QA Teams for bug testing, User Acceptance Testing (UAT).
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.

Environment: SQL *Plus, SQL *Loader, Data Loader, PL/SQL, BOM, TOAD, SQL Developer, SQL Trace, Hints, Indexes, Materialized views, Stored Procedures, Triggers, Explain Plan, TkProf, and DBMS PROFILER.

Confidential, Atlanta - GA

Oracle Sr. PL/SQL Developer

Responsibilities:

• Developed SQL scripts to create temporary tables.
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Designed Design document for Migration of Oracle Database from 10g to 11g.
• Identified the new features in 11G and implemented them in our Data base architecture for better Partitioning( Space utilization and better Performance)
• Identified Daily Night cycle process scheduled which call PL/SQL, Procedures/ Packages / Triggers and Tuned them for Performance by use of various Oracle Performance Monitoring tools ( Explain Plan/ TKprof, V$ tables for identifying High load sql statements in code). Performance tuned 4hours Replication process to 20 min.
• Generated AWR reports to identify issues like Highload sql statements, Cursor Leak issues and resolved them.
• Worked on the Data Replication from Source systems to Target systems. Designed Datamodel and new Schemas to maintain daily transactional data.
• Identified high Volume tables which contain more than 40 million and partitioned them by range /hash based on the data.
• Modified database structure, DDL, where required.
• Improved the performance of databases by Table compression, Indexing data, and also by using shared servers.
• Analyzed Tables and Ran Gather Stats on table to keep the Stats updated so as to achieve Optimal Path in Explain Plan.
• Resolved Table Lock issues (Dead Lock issues) delaying Jobs while Data Loading.
• Created Night Cycle jobs using job Scheduler. ( Millions of Data loaded every day)
• Experience in developing Dynamic SQL and Ref cursors and Use of Immediate Execute to run the SQL statements build during Run time.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors in Oracle 11g.
• Performed Bulk Loading of Data using PL/SQL (Bulk Load Features from Staging Environment to individual Schemas for Loan Approval Process at regular Refresh Rates.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import data from legacy system.
• Involved in development of shell scripts to send invoices to customer through mailing.
• Used variousLOVS(List of Values) and record groups at various points in runtime.
• By using different application tuning techniques, performed tuning on customized application including reports and back end programs.
• Planned and implemented backup strategy of data in both archive and non-archive mode.
• Handled the Back up and Restoration Strategy, Executed Shell Scripts using Cron jobs, Planned and scheduled Backups, took Logical Backups (with Export / Import utilities).
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Created various tabular, Matrix, Chart, Drill-down/Drill through, sub reports and linked reports using Reports 10g/11g.
• Improved the performance of the database by proper table space management.
• Used Oracle Discoverer for querying base tables and defining ad-hoc reports for users.
• Analyze the various project requirements and transferring the knowledge to offshore team.
• Identifying and developing the reusable modules and templates, this will help in improving the productivity of the team.

Environment: Oracle Apps Release 12.1.3, RICEW, GL, AR, Discoverer, DDL, XML Publisher, XML, UNIX Shell Script, SQL *Plus, SQL *Loader, Data Loader, PL/SQL, BOM, TOAD, SQL Developer, D2K, Interfaces, Forms 9i/10g/11g, Reports 9i/10g/11g.

Confidential, Charlotte - NC

Oracle Sr. PL/SQL Developer

Responsibilities:

• Responsible for Business meetings, conversion of business rules into technical specifications
• Developed ETL metadata driven mappings based on the Functional Requirements
• Developed the packages, procedures and functions.
• Developed the stored procedures with the dynamic SQL’s to call from the SRT front end.
• Worked with Informatica PowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked with various active and passive transformations in Informatica PowerCenter.
• Worked with Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Developer, and Mapping Designer.
• Developed UNIX shell scripts to run the workflows and automated the scripts to run daily loads using TIDAL scheduler.
• Extensively worked with Slowly Changing Dimensions Type1, Type2, and Type3 for Data Loads.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Extensively worked with Look up Caches like Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations.
• Worked with re-usable objects like Re-Usable Transformation and Mapplets.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables and Mapping Parameters.
• Handled various loads like Daily Loads, Weekly Loads, Monthly Loads, and Quarterly Loads using Incremental Loading Technique.
• Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Extensively worked with the Debugger for handling the data errors in the mapping designer.
• Developed the reports using SQL’s and automated through UNIX shell scripts.
• Developed the application to create and handle the Affiliations, SRT errors with the APEX.
• PerformedSQL and PL/SQLtuning and Application tuning using various tools likeTKPROF, AUTOTRACE and DBMS SQLTUNE.
• Improved the performance of databases by Table compression, Indexing data.
• DevelopedMaster Detail, Detail reports usingtabular and Group above reports.
• Developed PL/SQL packages to validate legacy data for items conversion with categories in Oracle Inventory (INV) module.
• Customized reports for inquiry report, summary report and reconciliation reports using GL, AP, AR, PO and FA.
• Atomized routine jobs usingDBMS JOB.On completion of these jobs an email will be sent out automatically with the help ofUTL MAIL.
• Performed performance tuning using theDBMS PROFILERpackage, this checks the run time behavior.

Confidential

Oracle Developer / Forms & Reports Developer

Responsibilities:

• Besides the database responsibilities, also had the opportunity to involve in developing Oracle Forms & Reports.
• Involved in development of custom reports using Reports 10g and XML/ BI Publisher.
• Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions based on the client’s requirements.
• Worked on Forms Personalization to handle the form customizations.
• Performing full analysis to divest the unnecessary DB Schemas/Objects and to make sure that there is no impact to the up-stream and down-stream systems/links.
• Preparing ER Diagrams and Reverse Engineering document through Reverse Engineering.
• Preparing the STM for Core and DM Objects and adding the missing core attributes to the DM which is directly used by upstream and downstream links.
• Interfaced data from the Flat Files into Interface tables of Oracle Receivables using SQL*Loader.
• Designed a custom Interface to: Update the customer account numbers that are no longer active, Create a relationship with the newly added customer account numbers.
• Delete the existing outdated customer account number relationship and Update the shipping details of the existing customer account numbers.
• Developed reports like Packing Slip, Pick Slip, and Mailing Label for Shipping and Credit Order Detail, Freight Carrier, Orders by Item, Order Detail & Summary Reports for Order Management and also Created New Reports as per client requests using XML Publisher.
• Designed relational databases from scratch for different applications in a way that maximum performance is achieved.
• Improved the performance of the database by proper table space management.
• Involved in deploying the database to various environments.
• Extensively worked on migration of deliverables such as PL/SQL packages, LDTs, shell scripts, rdf, and rtf templates to different environments.
• Wide knowledge in creating tables, sequences, views. Wrote and maintained stored procedures, PL/SQL and SQL statements, and triggers to be used in Oracle environment and created standardized exceptions handling.
• Responsible for Review and Mapping of business requirements, preparation of functional design document (MD50) and technical design document (MD70) and providing solutions using oracle AIM methodologies.
• Performed Unit Testing of various objects and performed defect analysis during the pre-production stage.

Environment: Oracle Applications R12, Oracle 10g, Oracle Reports 10g, Oracle Forms 10g, BI/XML Publisher, SQL, PL/SQL, UNIX, TOAD, Workflow Builder, SQL*Developer, MD50, MD70, Interfaces, AIM, LDT, shell scripts, Discoverer.

Confidential

Oracle Developer

Responsibilities:

• Involved in the creation of database schema, roles, table spaces, rollback segments.
• Extensively created packages, database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Engrossed in setting the integrity constraints.
• Involved in the migration of data from different source to Oracle using SQL Loader and from Oracle to Oracle using PL/SQL.
• Wrote UNIX Shell Scripts to run database jobs on server side and scripts for automating daily load processes.
• Developed user screens, reports and menu using Forms 6i, Reports 6i.
• Monitored database using Oracle Enterprise Manager and TOAD (Table spaces, Data files, Jobs, Users, Sessions and Processes).
• Created Complex Dynamic / Static / parameterized reports and Charts using Report 6i.
• Check statements and alert statements were also designed using triggers, procedures and functions.
• Involved in tuning SQL code and loading process tuning.
• Involved in user acceptance testing of the application.
• Used Sybase and SQL navigator extensively.

Environment: Oracle 9i, SQL, PL/SQL, UNIX, TOAD, SQL*Loader, SQL Server, SQL Navigator, SQL*Plus, Windows, Forms 6i, Reports 6i, HTML, Sybase.