Summary

• An accomplished professional with over Eight years of IT Industry experience with specialization in Analysis, Design, Development, Implementation, Maintenance, and Support of various applications on a wide spectrum of platforms using Oracle Tools.

• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development Life Cycle SDLC .
• Highly experienced in Agile Development process for diverse requirements.

• Experience in Implementation, Data Conversion and Customization of various modules.

• Detailed knowledge of Order-to-Cash and Procure-to-Pay business flows along with the dependencies and relationships between various application modules.
• Expertise in Database design: Entity Relationship, logical/physical, Data Modeling.
• Extensive knowledge of the Oracle architecture, Oracle Memory structures, Logical Physical Structures, Data Dictionaries and with PL/SQL.
• Proficient in Database Normalization to improve the data quality by removing redundant data in database.
• Extensive experience in Oracle Back-end server-side PL/SQL Development i.e. Stored Procedures, Packages, Functions Triggers using PL/SQL Developer and Toad as development tools.
• Created and maintained Database Objects using Oracle Designer 6 like Materialized Views, Global Temporary Tables, Collections PL-SQL Tables, VARRAY and Nested Tables , Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and Privileges.
• Extensively worked on database Cursors, Ref Cursors in Oracle database.
• Good experience in UTL FILE, UTL SMTP, TEXT IO, DBMS SQL and DBMS JOB.
• Proficient in coding Interface Programs for importing data from Legacy Systems and Flat Files using SQL Loader.
• Strong Knowledge in Data Warehousing, Data mining and Data Modeling Techniques.
• Expertise in using migration and version control software PVCS, Rational Rose and Clear Case
• Experienced with UNIX operating environment in developing Korn Shell Scripts and Perl scripts.
• Worked on creating SQL LOADER control programs and PL/SQL validation scripts, oracle built-in utilities for validating and pre-import processing data from legacy systems to Oracle ERP.
• Good understanding of Oracle built-in utilities like Explain plan and TK-PROF, bulk-binding and Optimizer hints which are useful in Performance Tuning.
• Monitoring TAR' to resolve the known issues in coordination to Oracle support.
• Ability to work as part of a team with aggressive schedules.
• Possess strong interpersonal, communication and client-facing skills.

Technical Skills

Databases: Oracle 11g/10g/9i/8i, MS SQL Server, MS Access

Oracle Tools: Oracle Forms 9i/6i/4.5 , Oracle Reports 10g/9i/6i/2.5 , SQL Plus, PL/SQL Developer, TOAD

Languages: PL/SQL, SQL, UNIX Scripting, Perl Scripting, Java, Java Script, HTML, C

Operating Systems: Windows 98/2000/NT/2003, UNIX

Version Control Tools: Clear Case, Kintana, PVCS, CVS

Professional Experience:

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in project planning sessions with Project Managers and development team members to analyze business / technology requirements and outline the proposed technology solution.
• Collaborated with clients in interpreting requirements, providing iterative demo/presentations during development and support User Testing.
• Design and develop PL/SQL packages or stored procedures to pull data from remote database using database links and load into intermediate staging tables and eventually into target tables on monthly, weekly, hourly basis.
• Design and develop PL/SQL packages or procedures for data transformation processes for reports that require aggregations or any activity requiring background processing.
• Utilized SQL Loader to load FOTA data feeds from Infovista into PWOM database on daily or hourly basis.
• Design, develop and test Unix Shell Scripts to automate job scheduling using crontab for various database related program execution like SQL script, PL/SQL Script and Data Loading. Also send notifications in case of errors or violation of business requirement to appropriate users.
• Utilized Bulk Binding techniques, Explain Plan, SQL Hints and Indexes widely to improve SQL performance in back-end databases.
• Create requirements, design, test case, and implementation documentation. Receive approval and sign-off from USCC.

Confidential

Role: Oracle Developer

Responsibilities:

• Worked as Business Analyst and Developer on the Customer and Supplier Incentive System Application for US Foods. Data Warehouse is built on Oracle with Java as front end tool and CMOD as reporting tool.
• Followed Agile scrum methodologies of 2 weeks sprint in delivery which helped minimize overall risk, and adapt to changes quickly.
• Created intermediate staging tables for data migration.
• Developed PL/SQL packages to migrate large volumes of data through database links.
• Developed complex PL/SQL packages and stored procedures using UTL FILE to create reports for business users.
• Worked on creating the application to extract the data, transform and loading it to target tables, which involves in using advanced features such as bulk collects, for all, merge, multi insert/update statements and error handling.
• Developed Shell Scripts to automate job scheduling for various database related program execution like SQL script, PL/SQL Script and Data Loading.
• Created shell scripts to transfer reports using sftp.
• Utilized SQL Hints and Indexes widely to improve SQL performance in back-end databases.
• Utilized SQL Loader to load MDM data feeds to the database tables.
• SQL to create and execute complex queries to assist in data investigation.
• Collected User Requirements by participating in meetings and studying existing System.
• Developed technical specification documents for various back end modules from business requirements. Also wrote test plan documents for unit testing.
• Worked effectively with QA trackers.

Environment:

Oracle Database 11g, PL/SQL, SQL Developer, Unix, SQL Loader, Java.

Confidential

Role: Oracle Developer

Responsibilities:

• Designed various detailed data mapping documents.
• Extensively developed complex PL/SQL packages, stored procedures for Data Migration.
• Worked on designing and coding the utility to clean-up the data for failed migration clients.
• Developed complex reports which provides statistical representation of key fields of an Organization. This output is to provide evidence to the business of the successful or failed data conversion.
• Extensively worked with Dynamic SQL, Composite data types, PL/SQL tables, and array structures as a part of oracle collections.
• Optimization of the query and performance tuning.
• Associated with DBA in monitoring the performance related issues.
• Installing, updating, monitoring and tuning multiple Oracle databases.
• Involved in partitioning of very large tables.
• Used Data Pump utility to import various database objects like schemas, tables, indexes from the dump file.
• Developed Perl Scripts to automate job scheduling for various database related program execution.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Worked effectively with QA trackers.
• Support monthly releases and resolve production defects.

Environment:

Oracle Database 11g/10g, SQL Server, PL/SQL, Unix, Perl Scripting, Toad.

Confidential

Role: Oracle Developer

Responsibilities:

• Developed custom interfaces in MRP, OM, WSH, BOM, WIP, CST and INV.
• Developed a custom interface to load data coming from the legacy system MDB Web Interface into the Oracle custom staging table.
• Developed a custom interface to perform necessary UI level validations on the approved/unapproved demand data entered by the users.
• Developed a custom interface program to create forecasts for unapproved demand so that ASCP can use that information during holistic planning.
• Developed Google Operations Sales Order Interface Program to create Sales orders for budget approved demand which is considered as firm demand to the ASCP planning process for inline forecast consumption.
• Developed a custom interface to make changes on the sales orders considering the changes in the BOM.
• Developed a custom interface to perform shipments of the sales orders using shipping API's.
• Developed a custom interface to perform valuation and material transaction of the return parts into the inventory.
• Developed a custom BOM conversion program using Bill Import program.
• Developed a custom interface to associate overhead to resources using Import Cost Information Program.
• Worked on and Payables Invoices Interface in Account Payables.
• Developed Google Work Order Interface Program to create, release and complete Work Orders.
• Developed a custom XML publisher report that compares Budgeted Plan Vs Actual Production Plan for each quarter.
• Developed a custom XML publisher metrics report that provides the dollar spent for component items QTD.
• Involved in the preparation of MD70 documents as per AIM standards.
• Involved in post-production support for resolving critical issues.
• Extensively worked on tuning of applications to increase performance using Explain Plan and Bulk Binding techniques.

Environment:

Oracle Applications 11.5.9 Order Management, Inventory, Shipping Execution, BOM, MRP, AP, WIP, CST , Reports 10g, XML Publisher, Oracle Database 9i, SQL, PL/SQL, Perl Scripting, TOAD

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in development of custom interface and conversion programs in order management, inventory and shipping.
• Developed Interface for Miscellaneous Issue/Receipt of item transactions in the internal sub-inventory.
• Developed a custom interface to send back the errors in Item Import as an email attachment.
• Developed custom Interface to flush out the materials from sub-inventories to make it locator control and flush in back.
• Implementation of BOM involves bills, departments, resources, operations and routing. Helped the planners for purchasing the actual quantity of each item to be purchased.
• Worked with standard API's in Oracle Order management module to import Sales Orders from flat files into oracle tables.
• Worked on generating OM INTERFACE ERROR Report to display the orders with errors in the custom interface.
• Worked on the OM-QP Advanced Pricing integration to process custom pricing according to the client requirements.
• Worked on Oracle Advanced Pricing using Modifiers Discount, Surcharge, Deal, Promotional, Buckets, Competing, and Recurring and Qualifiers.
• Developed custom interfaces in shipping using shipping APIs to create deliveries, trips and firming deliveries.
• Designed and tested reports like Change report, Spares report, and Pricebook report in Pricing.

• Customized reports like Sales Order Acknowledgement, Orders by Item in Order Management as per the client requirements.
• Developed a form to mass update the orders Scheduled Ship Date and Promise Date .
• Customized various XML Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Customized the RMA workflow to add additional functionality to validate the RMA items.

• Involved in the preparation of MD70 documents as per AIM standards.
• Involved in production support for resolving critical issues raised by end-users.
• Extensively worked in Performance tuning of applications as required.

Environment: Oracle Applications 11.5.10 Order Management, Inventory, Shipping Execution, Advanced Pricing, BOM , Oracle Workflow Builder 2.6, Oracle Database 10g, Reports 10g, Forms 6i, XML Publisher, SQL, PL/SQL, TOAD

Confidential

Role: Oracle Developer

Responsibilities:

• Developed SQL scripts to create temporary tables and SQL Loader control files to load the item legacy data into the temporary tables
• Preparation of technical and Solution Design document for the offshore developer
• Code reviews to check the functionality and the coding standards
• Developed PL/SQL procedures to validate the data and insert the validated data into Oracle Standard interface tables.
• Collected User Requirements by participating in meetings and studying existing System.
• Involved in analysis and designed conceptual and physical schema based on business requirements.
• Developed PL/SQL packages to dynamically construct the select statements, extensively used native dynamic SQL, bind variables and oracle supplied Package DBMS SQL in the packages.
• Created new concurrent programs using PL/SQL scripts.
• Migrated data from legacy systems into Oracle Applications tables using one-time conversion scripts.
• Creating technical specifications and test scripts for all customizations.
• SQL to create and execute complex queries to assist in data investigation.
• Developing ETL's to pull data from different databases.
• Created audit tables, audit triggers to audit the table changes.
• Performed Oracle Imports and Exports for recovery.
• Created the Install scripts for all the database objects for go live.
• Resolving the productions issues by verifying the tickets.
• Tuned the SQL queries using Explain plan.
• Scheduled the DBMS JOB to run daily that will purge the data which is 90 days old.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization, and recovery of databases

Environment:

Oracle Database 9i/10g, PL/SQL, SQL, Windows 2000/XP environment, Toad, SQL Loader.

Confidential

Role: Oracle PL/SQL Developer

Responsibilities:

• Analysis, Design of the Database Model , Definition of Data Model and data Flow, Functional Hierarchy, Entities Relations, and Prepare Layout Formats.

• Full Life Cycle Development of the system using PL/SQL Scripts.
• Development of various database triggers, stored procedures and functions, Packages for the application using PL/SQL.
• Development of various database triggers, stored procedures and functions, packages for the application using PL/SQL and procedure builder to implement Business Logic.
• Involved in preparation of technical documents and end user training.
• Involved in the design and development of user interface GUI in Forms and table design using Oracle.
• Developed various Business and ad-hoc Reports.
• Created Data Flow Diagram, Entity Relationship Diagram from Designer 2000.
• Involved in writing PL/SQL Triggers, Procedures, Functions and Packages.
• Various stored procedures were written to achieve the back end functionality.
• Integrity constraints, database triggers and indexes were planned and created to maintain data integrity and to facilitate better performance.

Environment:

Oracle Database 8i, PL/SQL, Forms 6i, Reports 6i, TOAD, Designer 2000, ERWin