SUMMARY

• Over 8 years of extensive experience as Oracle PL/SQL Developerwhich 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. Proficiency in writingPL/SQLPackages, 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 privilegesusing SQL and PL/SQL.
• 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.
• 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.
• 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 using DBMS SCHEDULER to 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

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

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.

Version Control: TFS and VSS.

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

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

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, Florida

Oracle Sr. PL/SQL Developer

Responsibilities:

• Extensive experience in design and maintenance of databases for .net and Java applications.
• Developed SQL scripts to create temporary tables.
• Participated in R12 upgrade project - upgrading from 11.5.10.2 to R 12.1.3.
• Worked on Designing the Oracle Data Model for Wealth management of Wells Fargo External and Internal Clients Projects.
• 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 Nightcycle 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 Highloadsql 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.
• 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, XML Publisher, XML, UNIX Shell Script, SQL *Plus, SQL *Loader,Data Loader, PL/SQL, BOM, TOAD, SQL Developer, D2K, Interfaces, Forms9i/10g/11g, Reports 9i/10g/11g.

Confidential, Herndon, VA

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 InformaticaPowerCenter client tools like Repository Manager, Designer, Workflow Manager, and Workflow Monitor.
• Worked with various active and passive transformations in InformaticaPowerCenter.
• 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, POand 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, San Jose, CA

Oracle Developer/ Oracle Forms and 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 creatingtables, 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, WI

Oracle Developer/ Oracle Forms and Reports Developer

Responsibilities:

• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Write SQL queries, understanding requirements, writing functional specs, TBD documents, create workflow using MS VISIO.
• Extract data from multiple SOR’s residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses using PL/SQL.
• Developed Queries in Oracle database using TOAD to produce ad hoc reports as requested by web service.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Created and modified primary database objects, such as Triggers, Procedures, Functions, Synonyms, Packages and bulk collections to populate various types of health care members.
• Created materialized viewsfor data replication, read-only option and enhance security.
• Collaborated with the QA team in reviewing and validating test plans and test cases, ensuring that the final application catered to the user requirements.
• Worked on SQLPLUS and SQL*Loader calls from shell scripts for data auditing and automation.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basiswith Crontab.
• Writing UNIX shell scripting to generate data extract files and sends emails.
• Extensively wrote various scripts like Dispatch, Manifest Extract and Margin Analysis Extract programs to extract data into flat files in user specified format in order to export them to third party applications.
• Created PO Vendor Report, Vendor ledger report using XML Publisher.
• Prepared design documents (MD50) and technical documents (MD70) for all the customizations and supported Production environment.

Environment: Oracle EBS 11.5.10, AR, AP, GL, Oracle 10g, Workflow Builder, Oracle Alerts, Forms 10g, Reports 10g, SQL, PL/SQL, TOAD, XML Publisher,OBIEE, SQL*Developer, Discoverer, UNIX, AOL.

Oracle Developer

Responsibilities:

• 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.
• Participated in analysis, design, development, testing, and implementation of various financial Systems using Oracle 11i, Developer 2000 and PL/SQL.
• Coordinated between management, users and technical teams forRequirement Gathering.
• Worked with various functional experts to implement their functional knowledge into business rules in turn as working code modules like procedures and functions.
• Imported data from numerous sources for companies acquired by client, into Oracle AR.
• Work closely with functional and development team to implement Oracle Financial Modules (AP, GL, AR), create Applications Users, Responsibilities, Report Sets, Menu and Functions.
• Involved in generation of custom XML reports incorporating client’s emblems and other JPEG images for the fancy and quality facilitated reports.
• Upgraded of Custom Reports in payables. EMP ADD/BANK Exception report-(list the employees who are vendors and got incomplete address or bank details), Vendor information report (display vendor information), AP extract summary report (display sum of amount by vendor & account).
• Used AOL & Sys Admin to register new reports, forms, functions, menus and created validation sets, request sets and concurrent programs.
• Developed new and modified existing packages, Database triggers, stored procedure and other code modules using PL/SQL in support of business requirements.
• Developed Shell Scripts, PL/SQL procedures, for creating/dropping of table and indexes of performance for pre and post session management.
• Defined database structure, mapping and transformation logic. Creation of External Table scripts for loading the data from source for ETL (Extracting Transforming and Loading) Jobs.
• Used SQL *Loader to load the data.
• Generated UNIX shell scripts for automating daily load processes.
• Developed Pre and Post SQL scripts, PL/SQL stored procedures and functions.
• Used TOAD and SQL navigator extensively.

Environment: SQL Developer, UNIX, SQL, AOL, PL/SQL, XML, Forms 6i/10g, Discoverer(d2k), SQL*Loader, Reports 6i/10g, TOAD.