SUMMARY

• Over 12 years in IT with extensive experience in design, development, implementation and maintenance of application software.
• Functional experience in configuration, setup, unit and integration testing of Advanced Pricing, Oracle Order Management, Purchasing, Inventory, customizations on Cycle Count, test script generation, writing training guides, training end users and production support.
• Highly skilled in Performance tuning - analyzing query plans and query tuning using the tools such as EXPLAIN PLAN and use hints wherever required.
• Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL, Open Interfaces, and APIs.
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages.
• Extensively used Cubes & Rollups for making cross tabular reports.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP).
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Excellent in team collaboration, quick adaptation and problem solving with good communication skills.

TECHNICAL SKILLS

ERP Suite: Oracle E-Business Suite R12/11.x, PO, OM, WIP, BOM, Quoting, INV, Advanced Pricing, AOL. Database Tools SQL *Plus, SQL * Loader, Toad, SQL Navigator

RDBMS: Oracle 11g/10g/9i/8i.

Oracle Tools: Forms 10g/9i/6i, Reports 10g/9i/6i, Discoverer 10g/4i, Developer 2000,Workflow,ERWin,Putty, XML Publisher.

Other Languages: PLSQL, C/C++, Visual Basic, Unix shell scripting.

Document Methodologies: MD.050, TE.020,MD.120 .

Operating System: SCO UNIX (Shell Scripting), Windows 8.1/7/XP/NT/95, DOS.

Other Tools: BO,PVCS, Kintana, Selectica Model Builder 7.1, Dollar Universe, Mercury Quality Center, SoapUI, BMC Remedy.

PROFESSIONAL EXPERIENCE

Application Programmer/IT Analyst

Confidential, Research Triangle Park, NC

Responsibilities:

• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design (Relational and Dimensional models) using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Developed Database Triggers for audit and validation purpose.
• Developed Installation scripts for all the deliverables.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Providing the suggestions/options of the best way to implement the developed code with the SOX approval.
• Analyzing the issues using TOAD, providing the workaround to fix the issues, testing the workaround in TEST instances and providing the updates to Business.
• Fully involved in month/quarter/year end closing developed code for the application support activities.
• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Work on major upgrades of database and application that included testing of major upgrades and releases.
• Responsible for training of end-users and provided the aggressive support to resolve the UAT, Production issues.

Environment: Oracle E-Business Suite R12 / 11i.x, Oracle 9i/10g/11g, SQL, PL/SQL,Forms 6i/10g, Report 6i/10g,Toad, SQL* Plus, SQL* Loader, Oracle 10g, Quality Center,SQL Navigator, ERwin, Windows XP, UNIX.

Oracle Technical Consultant

Confidential

Responsibilities:

• Imported BOM data from Legacy system to Oracle through Open BOM Interface.
• Customization of Pallet reservation form in Order Management as per the customer requirements.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.
• Worked on modifying CUSTOM.pll to enable zoom functionality and to store customer UOM, Lot UOM, Total Line Quantity, Requested Quantity, Reserved Quantity for sales order form.
• Worked on customization on BOM Routing Form.
• Customized the standard oracle reports such as AR Invoice Print Report, Inventory Cycle Count Report, Transaction Register Report, Payment Receipt Report etc and converted them to XML Publisher format.
• Writing Stored Procedures, Function and Triggers for Auditing.
• Developed PL/SQL Triggers, Stored Procedures, Functions and Packages.
• Testing of the migrated changes in QA Instance and giving sign-off to move production.

Environment: Oracle 11i(11.5.9), Oracle 10g/9i, Oracle Application Framework(OAF), JDeveloper, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Oracle BI Publisher, Oracle Workflow, Oracle PL/SQL, UNIX, SQL*LOADER, TOAD.

Sr System Analyst

Confidential

Responsibilities:

• Imported BOM data from Legacy system to Oracle through Open BOM Interface.
• Performed system administration functions such as creation of users, creation of responsibilities, defining value sets, creation of concurrent programs and executables, registering applications.
• Registered concurrent programs, request groups for reports.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.
• Customization of Pallet reservation form in Order Management as per the customer requirements.

Confidential

Responsibilities:

• Involved in creating secondary price lists, qualifier groups and promotional modifiers.
• Used GET CUSTOM PRICE function to calculate price of orders as part of formula.
• Developed Price list, Formulae, modifiers that gives promotional upgrade for specific item and attached qualifiers to it.
• Registered concurrent programs, request groups for reports.
• Interacted with end users and prepared functional doc MD 50/ Technical doc MD 70 / Design doc with all test cases TE 20/ Implementation manual MD 120 as per AIMS standard.

Environment: Oracle 11i(11.5.9), Oracle 9i, Oracle Forms 10g/9i, Oracle Reports 10g/9i, Oracle PL/SQL, UNIX, SQL*LOADER, TOAD.

Software Engineer

Confidential

Responsibilities:

• Involved in creating secondary price lists, qualifier groups and promotional modifiers.
• Used GET CUSTOM PRICE function to calculate price of orders as part of formula.
• Developed Price list, Formulae, modifiers that gives promotional upgrade for specific item and attached qualifiers to it.
• Registered concurrent programs, request groups for reports.

Confidential

Responsibilities:

• Worked on Enhancement and Implementation support.
• Writing Stored Procedures, Function, Triggers and Packages.
• Bug fixes, Enhancements and test the application.
• Installation of Oracle 8i database in UNIX server.
• Involved in developing various Custom reports, Customization on existing reports for several modules according to clients requirements.

Environment: Oracle 8i, Oracle Forms 6i, Oracle Reports 6i, Oracle PL/SQL, UNIX and TOAD.