SUMMARY

• Over 8 years of experience in the software industry in Analysis, Design, Development, Testing and Implementation of Software Applications and 6 years of experience in Oracle E - Business Suite/Oracle Applications in Implementation, Rollout, Support and upgrade projects. (Financials, Sales & Distribution Modules).
• Expertise in data migration/conversions, interfacing, workflows, forms and reports customizations and testing (Unit, UAT) of applications involving Oracle Applications R12, 11i,
• Expertise in Financials (General ledger (GL), Account Receivables (AR), Account Payable (AP), Cash Management, Fixed Assets (FA), SCM (Order Management (OM), Purchase Order (PO), Oracle Inventory (INV), shipping (WSH), and CRM (Service Contracts, Install Base), System Administrator(FND).
• Expert in Oracle E-Business Suite/Oracle Applications preparing Technical specifications (MD070), Understanding Functional Specification (MD050), Conversion Mapping Documents (CV050), Installation Document (MD-120)
• Experience in developing, customizing and personalizing the Data entry Pages (forms) and creating backend tables.
• Expertise in developing Reports, Interfaces, Conversions and Extensions (RICE) Components.
• Extensively worked on PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Expert in developing XML Publisher reports and their integration.
• Expert in System Administration (AOL) in defining users, menus, access level responsibilities and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities.
• Experience in integrating/ converting none legacy data formats including flat-file (CSV), XML, and SOAP to Oracle database system PL/SQL, SQL*Loader
• Ability to work wif and enhance complex, highly integrated enterprise applications.

TECHNICAL SKILLS

Operating System: Windows, XP/NT/2000/98/95, UNIX, LINUX

Programming languages: SQL, PL/SQL, C/C++,VB.NET, C#, Java, XML,HTML

ERP: Oracle applications 11i/R12 (Financials, SCM, CRM, OPM).

ERP Modules: OM (Order Management), PO (Purchasing), AP (Account Payables), AR (Account Receivables), INV (Inventory), GL (General Ledger), AOL (Application Object Library), System Administration

RDBMS: Oracle 11g/10g/9i/8i, SQL Server2008/2005, MS Access 2007/2005

Development Tools: Oracle Reports10g/9i/6i, Oracle Forms 10g/9i/6i/, Oracle Workflow, SQL*PLUS, SQL*Loader, SQL Developer, XML/BI Publisher 10.1.3.2, JDeveloper 10g

Database Tools: SQL*PLUS, SQL*LOADER, SQL Developer

Microsoft Software Packages: Microsoft Office (Word, Excel, PowerPoint), Microsoft Visual Studio 2005/2010, Microsoft Visual Studio, Team Foundation Server2010, Microsoft Project 2010

Requirement/Data Modeling: Microsoft Visio 2010 (UML and DFD diagrams)

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Oracle Applications Technical Consultant

Responsibilities:

• Worked on building an interface for AP Invoices and AP Invoice Lines and Distribution information.
• Worked on Custom Interface to send the Debrief Information from Field Service to Legacy System.
• Worked on Inbound/Outbound Interfaces in AR, AP.
• Worked on Enhancements wif the Journal Import in GL.
• Involved in Documents; BR100, MD50, and MD70.
• Worked on Oracle Reports.
• Worked on Purchase Orders, Check Templates, and Order Detail Reports using BI Publisher/XML Publisher.
• Was involved in GL Details analysis report for gathering requirements from the users to identify the data to be archived.
• Customized the Standard Business rules provided by Informatica as per the requirements of the client.

Environment: Oracle R12, GL, (AP, PO, AR, OM, INV and GL modules), sql*plus, Oracle DB11g, Pl/Sql, Forms 10g, Reports 10g, XML/BI PUBLISHER

Confidential, NY

Oracle Apps Technical Consultant

Responsibilities:

• Writing the functional design and technical design for all customizations (forms, concurrent programs), so that business users and technical developers had a common understanding of the solution.
• Extensively worked on Project Accounting (PA), module to set up Project WBS Templates, Tasks, and Billing Event types.
• Developed Project Conversion Program to import the projects from the legacy system into Oracle Project module by using the API.
• Imported Active Project labor Hours from Legacy system into Oracle Projects.
• Developed Billing events and revenue events creation program by using APIs in Oracle PA module
• Developed custom revenue calculation program to generate the revenue as per the business rule.
• Modified standard Project Billing Extensions to generate the revenue as per the client requirement.
• Developed Project Milestone exceptions report which will be more useful to the executive team and finance team for every month end close process.
• Developed Customer interface in Accounts Receivables (AR)
• Customized standard PO print report by using XML Publisher.
• Developed form customizations for Purchase Order Form, Import Journals form and Sales Order Form using forms builder for Oracle Financial applications.
• Customized standard AP Invoice aging report, Check printing report in Account Payables.
• Provided analysis, design, installation, and rollout of Oracle 11i General Ledger, Accounts Payable, Fixed Assets and Purchasing.
• Developed PL/SQL Procedures for Customer interface in Accounts Receivables (AR).
• Developed custom workflows for specialized AR transactions.
• Developed control Files to load the data from legacy System to Oracle Staging Tables using SQL Loader, from which data is transferred to the base tables using the conversion programs.
• Developed form customizations using forms builder for Oracle Financial applications, Purchase Order Form, Oracle Financials Import Journals form, Sales Order Form.
• Developed Oracle Alerts to send the notifications to the users based on the business requirements.
• Developed web based reports by using the ASP and deployed into company’s internal website
• Customized standard packing slip report to show the bar codes and individual component serial numbers.
• Developed Supplier conversion program to convert the supplier from legacy system into Oracle EBS TCA
• Customized Standard FSG reports (Balance Sheet, Income Statement and Department Expenses) in General Ledger module.
• Implemented Web ADI to import journals by using the Journal import templates
• Developed custom forms in AP using Oracle Form Builder.
• Developed custom reports such as Schedule Outstanding Bills, custom invoices and statements.
• Created XML Publisher reports from existing oracle reports.
• Involved in Production support issues on Daily Basis.
• Provided production support for existing financial applications.
• Application Modules:- GL, AR, AP, PO, FA, OM, INV BOM, WIP, PA

Environment: Oracle Applications E-Business, Oracle 11i, PL/SQL, Oracle form builder 10g, Oracle Report builder 10g, BI/XML Publisher, UNIX, Workflow Builder, SQL*Developer.

Confidential, Schaumburg, IL

Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked on Order to Cash Cycle, from entering orders to move order stage followed by the ship confirm and updating the GL.
• Extensive experience in technical specification design, development, unit testing, system integration testing, UAT and maintenance of Oracle e-business suite of Applications.
• Customized the Order Header level workflow, which will send a notification to collectors when exceeded a threshold limit.
• Developed a custom report to review the reasons for Return Material Authorizations (RMAs), which shows the reason, items returned, order number and customer name for a given date range.
• Worked on Auto Invoice Conversion Program to validate, load Credit memos, Debit memos and Invoices from legacy system.
• Worked Service Contracts Conversion Program to import from Legacy system.
• Developed Order Management Pickslip and Sales Order Acnoledgement reports, service contracts detail report and inventory transaction report using XML Publisher to display in excel format.
• Setup Descriptive Flex Fields, Value sets for various components in OM, Inventory modules.
• Defining System Profile Options, Descriptive and Key Flex fields.
• Various ad-hoc SQL queries and bear SQL reports for taking business decisions were developed whenever requested by user.
• Requirements gathering for the Interface and custom program development through meetings wif functional team and business users.
• Worked on Design and Development Requirements for various Motorola Legacy Financial applications.
• Worked on Separation Activities for Motorola and involved in coordinating and leading the activities for Confidential .
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Analysis, Design and Development of MD70 technical documents based on MD50 functional documents and business requirements and documented in Doors.

Environment: Oracle applications 11i,R12, HP Unix, Oracle Database 10g/8i, OM, Oracle Receivables, Payables, BOM,WIP General Ledger, Developer 2000/6i, Xml Publisher

Confidential, Hartford, CT

Oracle Apps Technical Consultant

Responsibilities:

• Designed and developed GL, AR, AP, OM, PA and WIP related Interface programs to synchronize the data between existing Legacy system and Oracle Database
• Developed GL Account Balances Conversion Programs
• Developed Item conversion program for assigning Items to Item category set and Categories
• Developed PO interface to import PO orders from legacy systems. Used API’s to update quantities and to cancel Orders
• Developed PL/SQL scripts to load order data from external system to OM interface tables
• Used SQL * Loader and UTL FILE packages for data conversion and interfaces
• Converted pricing information from legacy systems into Oracle applications using SQL*Loader and pricing API
• Designed and developed Data Audit System scripts to capture the data from "before" system (10.7) and after system (11i) based on the business requirements
• Developed database triggers on few tables to keep track of changes
• Registered the automation scripts as concurrent programs and created a scheduling process that invokes the script periodically
• Coordinating wif the offshore team wif daily status calls
• Proficient wif the System administrator responsibility, which included customizing the menus, Adding new concurrent requests, request sets, registering the custom applications etc
• Developed Pick slip template using XML Publisher
• Developed XML template for invoice report using XML Publisher
• Created EUL and BA’s using Discoverer Admin 9i
• Handled security and privilege issues using Discoverer Admin 9i
• Handled performance issues for several reports, which involved code optimizations using auto summary management (ASM) using Discoverer Admin 9i
• Created and scheduled workbooks as per the user requirement using Discoverer
• Developed custom AR Adjustments Aging Report wif fixed aging buckets. Designed the technical and user training documents
• Customized Inactive Item Report and Cancelled Sales Order Report
• Developed reports to compare the captured data and report the discrepancies in the migrated data
• Built custom reports using Oracle Report builder 6i and integrated them wif the application (based on the descriptive flex fields) to solve the client’s reporting needs
• Built custom forms using Oracle Forms 6i Builder to fulfill the business requirements of the client
• Worked wif end users to facilitate issue resolution, troubleshooting functional application issues
• Customized existing forms to add search criteria on descriptive flex fields
• Developed forms using ZOOM functionality that pops up appropriate form based on the item context. Modified CUSTOM.PLL to activate zoom
• Developed Application Extension CV70s using AIM methodology by reviewing CV40s

Environment: Oracle Apps R12(12.1.2), OM, INV, BOM, WIP, PO, AP, AR, GL, AOL, ORACLE 8i, 9i, PL/SQL, Forms 6i, XML Publisher, Reports 6i

Confidential, Pittsburgh, PA

Technical Consultant

Responsibilities:

• As an Oracle Apps Technical Consultant, my responsibilities included:
• Development of reports for various Apps. Modules and testing of the same.
• Unit testing and Bug fixing.
• Interacting wif clients for successful completion of report development.
• Wrote Technical MD70 design documents and Conversion Mapping Documents for various interfaces.
• Work on interface conversions for oracle apps.

Environment: Oracle applications 11i Unix, Oracle Database 10g/8i, OM, Oracle Receivables, Payables, General Ledger, form builder and report builder tool, Xml Publisher

Confidential

Software Engineer

Responsibilities:

• Prepared documents (functional design and technical design) for the system.
• Designed and developed database table.
• Created database Procedures and triggers.
• Developed user interface forms for data entry and each functional area; agents, flights and commodity information, Account Receivable and Account payable (General Ledger, sub ledgers for each airline, Multiple payment methods and bank accounts, Invoice and statement printing (billing).
• Created reports such as; Customer Invoices, Sales Journal, Cash Receipts Journal, Agents Listing, Trial Balance, Monthly Sales Report, Monthly Cash Receipts Report, Daily Transaction Register, Invoice Payment Selection Register, Checks and Vouchers, Invoice History Report, Customer Statements

Environment: PL/SQL, JDeveloper wif ADF frame work, Oracle 9i database.