SUMMARY

• Confidential is an experienced Oracle Applications e - business Suite Techno-Functional Consultant, who possesses over 9 years of IT experience. Currently working with leading corporations and provides his expertise in developing Oracle Applications projects. He also possesses strong leadership skills.
• 9 years of experience in full lifecycle software development, support, testing and maintenance of applications developed in Oracle SQL, PL/SQL, Developer 2000 (Reports 6i and Forms 6i), Data Conversions and Interfaces in which over 6+ years as an Oracle Apps Techno-Functional consultant.
• Strong Technical Consultant in implementing, customizing, supporting and maintaining Oracle Applications /Oracle e-business Suite R11i the main concentration being in the modules: Oracle Account Payables (AP), Oracle Inventory, Oracle General ledger(GL), Oracle Receivables (AR), Oracle Purchasing (PO), Application Object Library (AOL), System Administration.
• Strong Consultant in implementing, supporting and maintaining Procure to pay (P2P) process.
• Expertise in SQL and PL/SQL programming to develop stored procedures, functions, packages and triggers.
• Extensive experience in Design, Development and Testing of Oracle Reports/Oracle Forms
• Worked with Workflow builder, writing PL/SQL procedures for Workflow
• Well versed with AIM Methodology and documenting the work done in a well-fashioned manner.
• Worked with Oracle Utilities like SQL*Loader, Toad, Putty
• Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills
• Technical leadership with responsibility for delivering technical services and delivery of on-time, Quality data. Act as a technical liaison with project team members and managers to drive the Technical aspects of project delivery.
• Writing and maintaining Technical Specification document MD70 and Functional Specification document MD50.
• Excellent analytical, presentation, and communication skills. Strong logic, solid business acumen, Strong leadership, facilitation and organizational skills
• Ability to effectively gather and refine report requirements from Users and Management and give appropriate attention to details. Proficient troubleshooting skills.
• Ability to manage time spent on multiple projects to meet deadlines. Ability to work independently and as part of a team.

TECHNICAL SKILLS

ERP: Oracle Financial modules like AP/PO/GL/AR, Oracle Applied Technologies like Workflow,System Administrator, Oracle Apps 11i

RDBMS: Oracle 8i/9i/10g

Tools: Oracle Developer(Forms 6i/9i, Reports 6i), Java, HTML Oracle Workflow 2.5/2.6,Toad, Putty.

Operating System: Solaris, MS Windows (9x, NT, 2K, XP), UNIX

Other Software: CVS, Kintana

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Technical consultant

Responsibilities:

• Designed and developed interface program Developed concurrent programs to interface customer data from legacy systems to oracle Financial modules like Purchasing, Accounts Payables.
• Worked on customer standard invoices and Debit/Credit Invoices conversion in AP. Created request set for calling sql loader control files, custom pl/sql procedures and seeded auto invoice interface program.
• Developed a custom interface, to send payment information from AP to external system.
• Technical support on GL interface and AR invoice interface worked on AR transaction distributions Report using Reports Developer.
• Developed Order compliance report that generates all the possible information related with the orders using Reports 9i.
• Worked on custom report in AR (receivables).
• Contributed in business and process prospective during design review.
• Involved in the development of solutions to need business needs and support process improvements.
• Involved in gap analysis, creation of setup documents and in the process of mapping the business requirements.
• Customized and enhanced transactions register report in purchasing.
• Was able to work successfully in a fast paced environment and developed the reports in time.
• Designed and developed Inbound Interfaces using PL/SQL and SQL*Loader and UNIX Shell
• Scripts, to extract the data from Legacy into Oracle tables.
• Customized Printed Purchase Order and Payments by Supplier reports.
• Customizations on forms using custom.pll
• Activities involved creation of Loader File, porting Invoices into the AP INVOICES INTERFACE and AP INVOICE LINES INTERFACE tables using SQL*Loader and then using Payables Open Interface to import the data into the actual tables.

Environment: Oracle Application 11.5.7, Oracle Workflow, Oracle 9i, SQL, PL/SQL, SQL*Loader, TOAD, Windows NT Module: GL, AP, AR, FA.

Confidential, Reading, PA

Technical consultant

Responsibilities:

• Involved in analysis, design and development of reports for oracle applications.
• Extensively worked on Purchasing requisition import (PO) process to import requisition file to oracle applications using PL/SQL programming.
• Responsible for developing Libraries, Packages, Procedures and Functions using PL/SQL for HRMS.
• Customized and developed forms using CUSTOM.pll and TEMPLATE.fmb to meet the clients requirements
• Created and Scheduled Jobs from time to time.
• Created Records, Tables, Objects, Collections (Nested Tables and VArrays), and Error Handling.
• Performed Unit Testing on Forms and Reports and PL/SQL Stored Procedures, Functions, Triggers and Packages.
• Created UNIX scripts for automating the conversion from the legacy system
• Worked on Print Purchase Order, Printed Requisitions reports of Oracle Purchasing Module
• Designed MD50 and MD70 documents using AIM Methodology .
• Scheduled Concurrent programs based on user need.

Environment: Oracle Apps (HR, Payroll, Financials), Oracle 8.x, Discoverer 4.x, Windows NT/2000, UNIX, TOAD, PL/SQL.

Confidential, Baltimore,Maryland

Oracle Apps Technical Consultant

Responsibilities:

• Worked on both Inbound and Outbound Interface Financials.
• Involved in designing of customized Interface Architecture.
• Developed PL/SQL packages as per business requirements for transformation and loading of data from flat files.
• Worked on element entry, indicative, single client feed and data warehousing interfaces.
• Worked extensively on multithreading of concurrent programs while loading bulk data files.
• Involved in Unit, system and Integration testing of Interfaces.
• Involved in customization of several standard reports to serve important business processes very specific to the client. These Reports were developed since the already existing Oracle Report was not friendly enough to suit the client needs include Purchase Order, vendor, payments, and analysis reports in AP, and also Customer, receipts, invoice, and adjustment reports in AR.
• Extensively worked on workflow builder on Purchasing requisition Workflow.
• Involved in requirement gathering of Interfaces.
• Worked on forms development, registration and customizations of forms.
• Well versed with FTP commands( Used in Interface Development)

Environment: Oracle Apps, Oracle 9.x, Windows NT/2000, TOAD, SQL Navigator, UNIX.

Confidential, San Jose, CA

Techno functional consultant

Responsibilities:

Environment:

• As an onsite co - coordinator, Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs. Developing custom interfaces between various Applications for integration.
• Develop custom reports based on the Business requirement
• Developed data fix scripts for identifying the issues related to Invoices that are stuck in the interface table.
• Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.
• Created and Registered concurrent executables and concurrent programs.
• Interacted with users to resolve any issues during the production, development and enhancement phases.
• Coordinating with Oracle Support through Meta link to resolve issues.
• Scheduled maintenance of business specific processes.
• Supported all go-live activities and post-production troubleshooting.
• Technical and Functional support for Period close and Quarter close for Sun Microsystems.
• Worked on listing the POXML WF errors, that occurs when transmitting the Pos to the external supplier.
• Preparation of technical specifications. Coding, testing and test plan preparation.
• Prepare/Report the daily/Weekly status reports

Confidential, San Jose, CA

Responsibilities:

• Involved in implementation of Procure to Pay, Quote to Cash, AR, and GL functionality of Oracle E-Business suite.
• Have done module configuration, solution design, and code analysis to migrate Accounts Receivable, Accounts Payables, Cash Management, Order Management, Purchasing, AOL and General Ledger in release 12.1.2.
• Analyzed the existing functionality of 11i to transform the same functionality in R12 by developing functional designs, technical designs and code development.
• Proactively interacted with users to understand their business practices and performing the business functionality testing accordingly by configuring the system with required setup data.
• Have defined Legal Entity, Ledgers, Operating Units, Locations and Organizations.
• Developed purchase order conversion, Requisition Import by validating required fields.
• Have defined employees (Buyers), Customers, Suppliers, Banks, Bank Branches and Bank Accounts, Resources and Projects.
• Documenting the configured data and setups done for that functionality to update in oncoming instances.
• Coordinating offshore team for giving support to their development components by providing business requirements and have developed conversions and interfaces in the modules OM, INV, PO, AP, AR, GL.
• Created custom extended warranty automatically by using custom package.
• Reviews done on technical designs, codes and test cases as per the functional requirements and also have done peer reviews to functional designs.
• I have prepared test plans, test cases and done UAT testing by testing all business functionalities of each component to the user given data.
• Raised TAR’s with Oracle for problems that needed Oracle assistance; followed up on TARs and implemented solution given by Oracle.

Environment: Oracle 11i (AP, PO)

Confidential

Oracle Developer

Responsibilities:

• Creating SQL, Object Views, PL/SQL database objects.
• Developed Unix scripts based on client requirements.
• Developed Adhoc queries using SQL
• Performed Unit/System Testing.
• Improved the performance by adding new functional features
• Interaction with the Client.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Tested the entire application in Testing environment and exported to Production.
• Development of PL/SQL Scripts and Forms
• Extensively involved on conversions of Finance, HR and Payroll.
• Developed mapping documents and specifications for the data migration into new programs
• Imported Employee, Addresses, contacts information from the legacy system into the temporary table using SQL*Loader control file. Used the following packages/procedures. hr employee api.create employee,hr person address api.create person address,Hr contact api.create person to transfer the data to Oracle Human resource Application.
• Performed setup steps for defining Key Flex Fields and Descriptive Flex Fields.
• Performed setup steps for Profile Options, Lookups, and Value sets.
• Was involved in conversion of element data from legacy system to oracle payroll.
• Extensively worked on System Administrator Tasks like Creating Users, Responsibilities, Menus, Request Set/ Groups, Security Profiles etc.,
• Experience in setting up and scheduling Concurrent Processes.
• Involved in review of functional requirements and wrote Technical Design (MD 070).

Environment: SQL, PL/SQL, Java Applets, Basic HTML, Oracle 9, UNIX