SUMMARY

• Over 8 years of IT experience covering the complete phase of Designing, Developing, Integrating and Testing Applications
• Around 7 years of extensive experience with Oracle Applications, SQL, PL/SQL, UNIX, Data Warehouse & Business Intelligence tools experience spanning dimension modeling, Informatica, Oracle Data Integrator, Data warehouse Administration Console which involve analyzing of business requirements, design, development, implementation, customization and support of various enterprise applications.
• Strong understanding of off shore, onsite model
• Commended for dedicated work ethic
• Acquired Oracle Certification (Oracle Certified Associate) EBS
• Extensive experience in Oracle Workflow, Oracle Reports, Oracle Forms, SQL, PL/SQL, SQL*Loader Utilities, UNIX Shell Scripts, Crystal Reports, XML, BI Publisher.
• Worked on Data Migrations, Extractions, Interfaces, Workflows and customization of Oracle Applications 10.7, 11i and R12
• Highly experienced in developing complex queries
• Very proficient in performance tuning of Batch jobs, Forms and Reports, using tkprof and Explain Plan.
• Good programming experience in creating Functions, Procedures, Packages, APIs, Triggers and also other database objects using SQL and PL/SQL
• Experience in various modules INV, AP, OM, IStore, IExpense, ISupplier, IB, AR, PO, FA, ONT, FA, GL, Configurator, SYSADMIN, WORKFLOW, ORACLE DISCOVERER 10G, ORACLE BI/XML PUBLISHER
• Worked extensively on order - to-cash and procure-to-pay life cycles using the Workflow in the modules Inventory, Account Payables, Fixed Assets, Order Management and Account Receivables
• Developed workflows for Confidential and Confidential in AR, AP and OM Modules using PL/SQL and workflow
• Responsibilities include analyzing user requirements, designing technical documents, Onsite- coordination, database designing, development, support and testing
• Proficient in understanding and preparing various AIM documents (Business Requirements, Technical, Installation etc...)
• Used Metalink extensively to solve technical issues and raise TAR and also used VSS, WINCVS, Wsftp, Putty and many data transfer tools
• Recognized for problem solving skills, professionalism and a team player
• Trained users in Order Management and Purchasing modules.
• Experience in customizing Oracle Business Analytics Warehouse.
• Experience in configuring different ETL Tools like ODI (10.x) (Oracle Data Integrator) and Informatica 8.x for Administration and maintenance of Data warehouse.
• Configured OBIEE presentation layer with reporting capabilities like Visual Analysis, Drill-Down, Ad-hoc, Multi- Dimensional, Slice/Dice, Alerts, Graphs and Guided Analytics
• Implemented aggregation navigation capability within OBIIE platform based on summary data analysis requirements
• Hands on experience on development of OBIEE repository, dashboards, Delivers, Ibots scheduling.
• Extensive experience in database administration, database design, data modeling, and data warehousing with Oracle.
• Involvement with creation of test scripts for data validation and validate Integration/Regression test results.

TECHNICAL SKILLS

Programming languages & Tools: SQL, PL/SQL, C, C#, Pascal, COBOL, HTML, .NET, UNIX Shell Script, Java, JSP, MYSQL, C#.NET

Databases: Oracle 9i, MS-Access 2003

Operating Systems: Windows NT, Windows 95/98/2000, LINUX

Oracle Applications: Order Management, Inventory, BOM, Purchasing, Accounts Payables, WIP, HRMS, Installed Base, Receivables, SYSADMIN, Fixed Assets, General Ledger, Service Requests, Service Contracts, Oracle Pricing, Oracle Alerts, WMS

Oracle Products and Tools: TOAD, SQL *Loader, SQL plus, Reports 6i, Forms 6i.Oracle Workflow Builder, Crystal Reports, XML, BI Publisher, Oracle Configurator

BI: OBIEE 10.1.3.4, ODI, Informatica 8.6.1, BI Apps 7.9.6.1

PROFESSIONAL EXPERIENCE

Confidential, Huntington, WV

Staff consultant/Tech Developer

Environment: and Tools: Oracle EBS - Oracle Apps 11.0.3, Oracle Apps 11.5.10, 11g Oracle RDBMS, SQL, PL/SQL, Oracle Forms Personalizations, Oracle Reports 6i, Workflow 2.6.3.5, Unix.

Modules Involved: INV, WIP, OM. PO, AP, AR, Quality.

Responsibilities:

• Gathered the objects’ details from the users and discussed the possibilities of the requirements in the new instance.
• Worked on Reports in INV, OM and AR module. Consolidated many reports into one for better maintenance.
• Worked on Forms Personalizations on sales orders form and users form. Moved the customizations from fmb file in the old instance to the Form Personalizations to reduce the impact of the customizations on the system.
• Worked on several outbound interfaces which populate the Datawarehouse tables, which in turn were accessed by users through Oracle Discoverer reports. Covered all the modules shown above.
• Also created Datawarehouse tables for the AR module. Designed their structure and the way information is presented in the tables. The entire AR Invoices and Receipts data are denormalized into four custom tables for increased system performance.
• Given lectures and also trained the inhouse technical team on Form Personalizations and Oracle Workflow. Also trained them on the concepts of tuning the procedures and sql queries.
• Developed various ldt scripts for various requirements like concurrent program registrations, Personalization migrations, adding menus etc..
• Created documents for the users to understand the link between populate programs and their discoverer reports, So it would be easier for them to run the populate programs to vie a particular Discoverer Report.

Confidential, Hudson, NY

Staff consultant/Tech Developer

Environment: Oracle EBS - Oracle Apps R12.1.2, SQL, PL/SQL, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, Workflow, JDeveloper 10, Oracle Configurator

Modules Involved: OM, INV, AP, AR, BOM, iExpense, iRecruitment, PO, OLM.

Responsibilities:

• Involved in the requirement gathering and providing status updates to the client.
• Worked on OLM (Oracle Learning Management) on the functionalities of enrolling to the classes, Resource bookings, Evaluations and other setups.
• Worked on forms of sales order and purchase orders addressing the customizations requested by the user.
• The customizations done on forms mostly consist of personalizations and Custom.pll modifications.
• Worked on various reports plsql, Reports 10g and XML Reports mostly on the customizations of the existing reports.
• Developed various scripts for the implementation and also registered them as concurrent programs for various requirements.
• Worked on the workflows relating to the iExpense on issues relating to the expense reports approval flow and credit card transactions.
• Worked on various incidents involving many modules in supply chain and finance which obstruct the smooth flow of client’s business.
• Created Structures, Rules and Interfaces of many models in the configuration and assisted in publishing them. Also modified the existing BOM models.
• Improved efficiency of PLSQL reports and forms.

Confidential, Chelmsford, MA

Staff consultant/Tech Developer

Environment: Oracle EBS - Oracle Apps 11.5.10, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i and XML Publisher

Modules Involved: OM, AR, Service Contracts

Responsibilities:

• Extended the functionality of the customized forms in the Receivables module.
• Created many Procedures, Functions, Views and queries on the customized data and also in the AR module which are used for building Forms, Reports and for other functionalities.
• Created FNDLOAD scripts for the migration of Responsibilities, Forms, Form Functions, Concurrent Programs, Request groups, Value Sets, Menus, XML metadata, RTF files etc…
• Involved in the requirement gathering and providing status updates to the client.
• Created several Oracle 6i reports, XML Reports and converted few of the existing 6i reports to XML as per the customer requirement.
• Performed tuning for the existing 6i reports.
• Tuned Sql statements using Explain Plan, hints and also by indexing appropriately.
• Discussed with the users on the business requirements and informed them whether they are possible technically.
• Created a customized API similar to the order capture Integration Program according to the client requirements.
• Given demos to the client on how the customization would work in the real time.

Confidential, Burlington, MA

Staff consultant/Tech Developer

Environment: Oracle EBS - Oracle Apps 11.5, SQL, PL/SQL, Oracle Workflow, HTML

Modules Involved: OM, PO, AR

Responsibilities:

• Involved in the requirement gathering and providing status updates to the client.
• Written various queries and procedures in the order management and purchasing modules as per the business requirements.
• Developed various scripts for the implementation and also registered them as concurrent programs for various requirements.
• Created a custom workflow of the shipping execution process in Oracle which helps in sending emails to the customers every time an order is shipped.
• Created queries in order management required for the workflows.
• Improved performance in AR Invoices materialized views.
• Written interfaces to extract the data database from the Inventory module and send it to a third party software, to manage its warehouse management system.
• Created an interface to load the rules of configuration from a text format file to the Oracle Configurator.
• Also created many PL/SQL programs for the creation and deletion of the projects in the Oracle Configurator.
• Improved efficiency of PL/SQL reports.
• Coordinated with offshore for doing various tasks by communicating the user requirements.
• Maintained the various customized workflows and tuned them.
• Involved in adding a descriptive flexfield in the order management transaction types functionality to differentiate few order types based on some custom requirements. .
• Tuned Sql statements using Explain Plan, hints and also by indexing appropriately.
• Proficient with the System Administrator, which includes adding concurrent requests, Customizing Menus, Request Sets etc...
• Raised Oracle TARs covering the priorities 1, 2 and 3 for the issue solving purposes.
• Prepared Technical documents specifying the ways of using the packages, procedures and queries.

Confidential, Bedford, MA

Staff consultant/Tech Developer

Modules Involved: Order Management, IExpense and Receivables, Service Requests, Service Contracts, Payables, Inventory,WMS, Purchasing, Fixed Assets, General Ledger, IStore, BOM, Oracle Configurator and Receivables

Environment: Oracle EBS - Oracle Apps 11.5, SQL, PL/SQ, UNIX, Oracle Workflow, AME (Approvals Management Engine)

Responsibilities:

• Developed queries, procedures, Workflows and packages for the implementations and created tables, logical and physical designs and concurrent programs.
• Tested the packages and also checked the setups for the issues.
• Prepared Technical documents specifying the ways of using the packages, procedures and queries.
• Involved in getting the details from the user and providing the updates.
• Created procedures, packages, queries and concurrent programs in order to solve the technical tickets.
• Implemented RICE objects in Purchasing, Order Management, Receivables, Payables, Fixed Assets and General Ledger.
• Implemented AME(Approvals Management Engine) with IExpense and PO Requisitions.
• Performed performance tuning in reports in Purchasing responsibility.
• Developed sql*loader scripts for data loading of Journals from other sources and writing PL/SQL packages to validate, inserting them into GL interface table and posting them to GL.
• Written update scripts for the suppliers and supplier sites updates to satisfy the client requirements.
• Improved performance in forms in Inventory.
• Developed a custom workflow to send a notification to the customer once the service request is created.
• Developed extracts of Sales Orders and Purchase Orders as a data feed for a third party software.
• Developed auto- email shell script to send the email containing the BI/XML Publisher reports through the UNIX box.
• Designed and Developed an Extension for “Automated Configurator Testing”. Extension allows the super-user/tester submit their test cases using an Excel spreadsheet at any given time, location and see the test result without going through the usual process. Excel spread sheet will have the same choices as available in the Configurator User Interface, to create a look alike feel.
• Test results can be saved for future testing when there is an enhancement or addition or change of items. This helps the tester to determine whether the rules and extensions written inside the Configurator are creating a valid configuration or not. The test cases are independent of the Rules and extensions developed inside the Configurator.
• Created packages to upload data for the Problem Code Mappings in the Service Requests.
• Written update scripts for the credit card transactions in the Payables.
• Solved functional tickets also in the IExpense, OM, INV, PO, AR, Oracle Configurator and AP.
• Coordinated with the offshore by passing the requirements and communicating with the users.
• Provided Go Live support, addressed open issues if any.
• Created Solution documents for the users to follow to solve the ticket.

Confidential, Watertown, MA

Staff consultant/Tech Developer

Environment: Oracle EBS - Oracle Apps 11.5.10, SQL, PL/SQL, AME (Approvals Management Engine).

Modules Involved: Purchasing, IExpense, Order Management, HRMS

Responsibilities:

• Involved in the requirement gathering and providing status updates to the client
• Implemented AME (Approvals Management Engine) in Oracle Applications.
• Developed queries, functions and procedures for the AME and conducted Unit Testing
• Implemented custom workflow in Purchasing Module, to send notifications when a purchase order is approved.
• Implemented packages in Purchasing and IExpense module to get the approval hierarchy list according to the specifications for the AME.
• Created Package for the update of the price lists of the service contracts.
• Tested the package and the queries.
• Prepared Technical documents specifying the ways of using the functions, procedures and queries in AME.
• Developed SQL* Loader programs to load data into the staging tables which were later usedin various packages for the updates in Purchasing.
• Prepared installation documents for the already developed reports.

Confidential, Hopkinton, MA

Staff consultant/Tech Developer

Environment: Oracle EBS /OBIEE - Oracle OBIEE 10.1.3.4.0 , Oracle Apps 10.7, Oracle Apps 11.5.10, Oracle Apps R12, SQL, PL/SQL, Linux, Oracle Data Integrator (ODI)

Modules Involved: Purchasing, OM, AR, AP, INV, GL, PA, Service Contracts

Responsibilities:

• Analyzed the business requirements by interacting with the users.
• Managed the OBI and EBS tasks simultaneously, ensuring high delivery standards with thorough testing.
• Written many API Interfaces and extractions on the service contracts.
• Developed a custom ETL program to handle their complex business logic.
• Written few interfaces and extraction programs in R12
• Provided technical solutions to the client in their OBIEE implementation.
• Implemented AD integration and external table authentication for OBIEE dashboards.
• Written queries for extraction in General Ledger.
• Implemented Usage Tracking on the dashboard.
• Setup the environment in OBIEE related to emailing, using Oracle-Delivers.
• Improved the productivity of projects involving data transfer and and/or transformation like migration, installation of packages, construction of secured databases for the Internet, installation of datawarehouse and datamarts, and synchronization of heterogeneous applications using Oracle Data Integrator (ODI)
• Provided timely solutions to the business to carry out their tasks in EBS domain
• Ensured proper communication to the offshore team providing them the necessary information on the client requirements.

Confidential, Athol, MA

Staff consultant/Tech Developer

Environment: Oracle EBS - Oracle Apps 10.7, Oracle Apps 11.5.10, SQL, PL/SQL, Linux.

Modules Involved: OM, AR, AP, INV, FA, Purchasing and Service Contracts.

Responsibilities:

• Involved in the requirement gathering and providing status updates to the client
• Performed data migration from 10.7 to 11.5.10 in the modules INV, BOM, FA,OM and Service Contracts
• Developed queries for data Extraction and conducted Unit Testing
• Developed interfaces for OM and AR Modules
• Did performance tuning on existing queries, which resulted in improving performance by 10-30%
• Prepared Technical documents specifying the ways of using the queries in order to extract the data.
• Analyzed the business requirements and the MD50 documents.
• ‘Developed PL/SQL package required for the interface to be used for a concurrent program
• Did the performance tuning and unit testing.
• Prepared Installation documents as part of the deliverables.
• Coordinated with the offshore team in communicating the requirements.

Confidential, Athol, MA

Programmer

Environment: Oracle EBS - Oracle Apps 11.5.9/11.5.10 , SQL, PL/SQL, Linux.

Modules Involved: Inv, BOM, AP, AR and Pricing.

Responsibilities:

• Analyzing the business requirements and documenting the same.
• Written queries to extract the data from the source system.
• Developed Staging table Scripts and Control files.
• Developing packages required for the data migration for the objects Inventory, UOM and BOM.
• Involved in loading the item transactions data and category data into catalogs from external data sources.
• Imported Items, BOM from the legacy system into the Oracle Inventory and Bill of Materials using the standard Items interface and BOM and Routing interface program.
• Developed and registered the concurrent programs in the front end.
• Developed functions and procedures which were reused throughout the rest of data migration code especially for the Price lists.
• Performed testing, documentation of the objects.
• Communicated with the end users in order to analyze their requirements.
• Performed the testing of various objects which include procedures, queries, functions and reports.

Confidential, Westborough, MA

Programmer

Environment: Oracle EBS - Oracle Apps 11.5.9, SQL, PL/SQL, Reports 6i, SQL*Loader, Oracle Alerts, Oracle Workflows, UNIX

Modules Involved: OM, INV, AP, Service Contracts and AR.

Responsibilities:

• Developed Reports as per the requirements of the client.
• Developed and registered the concurrent programs in the front end.
• Assisted in Data Mapping, Modifications of Reports and Forms.
• Developed Alerts in Oracle Apps.
• Tuned the performance of the various packages, reports, workflows and queries.
• Written various interface programs and created workflows in Service Contracts, Order Management and Inventory.
• Key member of offshore team for OM and INV modules.
• Developed Unix scripts according the client requirements.
• Raised TAR for issues which are critical and followed up with the oracle.
• Developed the User Training Manuals to support the users.
• Analyzed many problems and recommended the solutions.
• Prepared testing plans.
• Documented many objects.

Confidential, HUDSON, NH

Programmer

Environment: Oracle EBS - Oracle Apps 11.5.9, SQL, PL/SQL, Forms 6i.

Responsibilities:

• Developed Interfaces (PL/SQL Package), Database tables, constraints and indexes in Oracle 10g .
• Developed and registered the concurrent programs in the front end.
• Performed tuning of the queries in the database by using Explain Plan, Indexes and Optimizer hints.
• Developed user interfaces with Forms 6i.
• Performed unit testing on the many objects including Reports, Interfaces, Packages and Procedures.
• Maintained, managed and modified existing interfaces as per business requirement changes.
• Prepared MD70 and MD120 documents as part of the deliverables.

Confidential, Chelmsford, MA

Programmer

Environment: Oracle Application 11.5.9,11i, SQL, PL/SQL, Reports 6i,Forms 6i, Unix Shell Script, SQL Loader & MS Excel 2000,Toad.

Responsibilities:

• Reviewed the specification document.
• Loaded the legacy data into the staging tables.
• Developed custom packages and staging tables for the conversions.
• Identified the set-ups required for the conversion and documented them.
• Ensured proper coding standards and maintained error logs to debug and identify the error data.

Programmer

Environment: Oracle EBS - Oracle Apps 11.5, SQL, PL/SQL, Forms 6i.

Modules Involved: various modules

Responsibilities:

• Developed custom packages and procedures to facilitate the form customization.
• Developed the custom form adding the folder functionality.
• Followed the standards by documentation and testing.

Confidential

Programmer

Environment: Java, JSP, SQL.

Responsibilities:

• Understood the requirements documents.
• Developed the code and the queries as per the requirement.
• Performed unit testing on the Application.
• Documented the development.

Confidential

Programmer

Environment: VB.Net, PL/SQL, Crystal Reports, Oracle 9i.

Responsibilities:

• Assisted in developing the database schema by developing the ER diagrams for the database.
• Created the tables for the database
• Developed forms to enter, update, issue, return and delete the mapsheets.
• Developed the reports for the users to enable them to get the information on Mapsheets which were issued to the departments.
• Documented the development.