Professional Summary:

• I am a US Citizen and Software Professional with around 10 years of IT experience.
• Around 8 years of Functional experience in Analysis, Design, Implement, Maintain various releases of Oracle E Business Suite 11i.
• Worked extensively on Financials Both Commercial and Federal AR, AP, GL, CE and FA , Purchasing PO and Inventory INV , Projects Contracts, Costing, Billing along with HR pertaining to Procurement and Projects in Oracle E-Business Suite.
• Experienced in full life cycle implementation projects.
• Strong skills in performing requirement gathering, gap analysis, recommending gap closure alternatives, designing and implementing business process solutions and perform testing.
• Very good at using Application Objects Library AOL , System Administration modules.
• Worked extensively on designing functional documents for various customizations, Data Conversions, Interfaces to third party systems, Reports, Workflows etc.
• Having good experience in Oracle backend objects like Views, Tables, Database Triggers, Stored Procedures, Functions, and Packages using PL/SQL.
• Excellent Communication and Problem solving skills, Self-motivated, Ability to learn and apply new technologies, highly committed to responsibilities, ability to work independently as well as in teams.

Skill Highlights:

• Experienced in various releases of Oracle E-Business Suite.
• Excellent skills in analysis, design, problem resolution, suggesting alternatives etc.
• Excellent Team worker as well as working independently.
• Experienced in Oracle Tools and Products.

Professional Experience:

Client : Confidential

Environment : Oracle E-Business Suite 11.5.10.2 GL, AR, AP, FA, Procurement, FV, Inventory, CE, HRMS, OTL, Payroll and Projects , Linux RedHat 4.0, Oracle 9i.

• Other Activities before go-live and post production scenarios:
• Performed Requirement Analysis, Fit/Gap Analysis, recommended business and system solutions for Gaps.
• Working with Subject Matter Experts SME for defining Best Business Practices in various business areas.
• Confidential is a professional information technology management services providing company in performance-based environments. They provide technology solutions to their federal, state and local government, Commercial customers while delivering high performance levels in secure environments.
• This project is an Oracle E-Business Implementation project to migrate various existing legacy systems for day-to-day operations and services for their client.
• As an Oracle Financial Functional Specialist I am responsible to implement and support Payables, Procurement and HR related to Purchasing and Payables modules and support GL module. Following are some of the tasks performed at this client:
• Configured Purchasing options, Financials options.
• Defined Buyers, Purchasing lookups, Payment Terms, Standard attachments, line types, Transaction Reasons etc.
• Setup Enhanced Transaction Codes.
• Defined Employees in Human Resources HR related to Buyers and Approval Groups.
• Assigned Positions in HR to different employees for setting up Approvals.
• Defined Requisition and Purchase Order Approval Hierarchies in HR.
• Configured Inventory Key Flexfields to meet the business requirements
• Configured item categories to categorize different items based on requirement and flexible reporting.
• Configured various item templates to create different kinds of items like finished goods, services etc.
• Setup receiving controls for receiving in different organizations
• Setup System Controls for 2-way and 3-way matching.
• Designed PO Output to accommodate business requirements. This involved customization of PO Output Program using XML Publisher. This is to avoid using any third party software and reduce the cost for maintaining it.
• Designed custom interface from OTL to Procurement to create purchase receipts based on number of hours charged by the sub-contractors.
• Enabled various descriptive Flexfields to handle specific client requirements.
• Setup Tolerances, Quality Inspection Controls.
• Designed and tested various other configurations to meet business requirements.
• Configured Payable options to suite the business requirements.
• Defined Invoice Tolerances, Payables Lookups, Distribution Sets, etc
• Implemented sequential voucher numbering for all types of invoices and payments.
• Configured AP to interface Expense Reports from Projects to pay employees.
• Defined user defined Invoice Holds and Releases.
• Setups various Payables profile options.
• Defined special calendars for recurring invoices.
• Defined AP Invoice Approval Hierarchy.
• Configured Approvals Management Module AME for setting up AP Invoice Approval Workflow.
• Setup 1099 Reporting.
• Prepared BR100 documents for AP, PO modules to capture the configurations.
• Documented different As-Is and To-Be business process flows.
• Prepared MD50 documents for developing Requisition and Purchase Order account generator, customizing RFQ, PO output, Requisition interface, AP invoice interface and various custom reports.
• Prepared CV40 documents to convert Requisitions, Open POs, Releases and Open Receipts.
• Prepared Test Scripts to perform SIT and UAT.
• Responsible for training end users.
• Responsible for conducting unit, System Integration, User Acceptance Test before go-live.
• Responsible for resolving Month-End closing and reconciliation issues.
• Worked with core users, contracting officers to resolve production support issues like fixing invoices with incorrect transaction codes, de-obligating funds on cancelled purchase orders, resolving approval status problems on purchase orders, resolving holds on invoices.

Client : Confidential

Environment : Oracle Applications 11.5.9 implemented and upgraded to 11.5.10 GL, AR, AP, FA, PO, CE , Sun Solaris, Oracle 9i.

• Responsible for period closing and reconciliation in post-production scenario.
• Making sure we are up to date in patch levels
• Prepared functional design documents for developing various custom reports in AP, AR and PO modules.
• Prepared CV40 to load the legacy Customers using TCA architecture, Legacy AR invoices, Receipts into Oracle.
• AR Setup: Receivables options, defined sales tax location Flexfield structure, Aging Buckets, lockboxes, customer profile classes, AutoCash Rules, Application Rule Sets, Transaction Types, and Sources, dunning letters etc.
• Prepared CV40 to load the legacy suppliers/vendors and Legacy AP invoices into Oracle.
• Prepared Functional Design document MD50 for AP Inbound Invoice interface to load vendor invoices.
• AP setup: QuickCodes, Pay Groups, Payment methods, Payables Options Financial Options, Tax Codes, Tax groups, Withholding Tax Groups, recurring invoices, distribution sets etc.
• PO setup: Positions, Jobs, Position Hierarchy, Document approval groups, Security Groups, setup various workflows etc.
• Played a key role during the functional setup of all mentioned modules. Helped the first time users in understanding and adapting them to the new structure based on their old methods and technology.
• Involved in brainstorming sessions to go over the current business process, document the AS-IS process, Analyze the gaps, define and document the TO-BE business process.
• This is a Multi-Org implementation.
• Confidential, a leader in the private finance industry, provides debt and equity financing to primarily private, middle market companies. The project was an implementation of Oracle E-Business Suite 11i Financials.
• As a functional consultant I was responsible for implementing AP, AR and partial PO. Following are some of the activities I performed at Allied:
• Following are some of the responsibilities, which I had during the upgrade process:
• Responsible for analyzing new features in 11.5.10, documenting the customizations done in 11.5.9 and impact of the upgrade from 11.5.9 to 11.5.10 from functional point of view.
• Used EMM Easy Path Migration methodology to track the impact on various customizations.
• Responsible for making sure configurations are intact during and post upgrade process.
• Fixing the problems if any in post upgrade.

Client : Confidential

Environment : Oracle E-Business Suite 11.5.8 GL, AP, AR, FA, PO, OM , Oracle 8i, SUN Solaris.

• Confidential is a global biotechnology company focused on the discovery, development and commercialization of breakthrough drugs for a range of serious diseases.
• As a Functional consultant, I was responsible for analysis, design, implement, test and document GL, PO modules. Following are some of activities performed at Vertex Pharma:
• GL Set up: Defined Chart of Accounts, Accounting Calendar, Accounting Segments Segment Values, Set of Books, Cross Validation Rules etc.
• Implemented Journal Approval Hierarchy by defining Journal Authorization Limits for employees.
• Prepared Functional Conversion Documents CV040 for converting Legacy account balances and details which involved data mapping, cleaning strategy, legacy to oracle account mapping etc.
• Responsible for Accounts reconciliation with Sub ledger Accounts and Period Closing process.
• Designed various Ad-hoc financial reports using FSGs.
• PO Setup: Setup Purchasing lookups, Profile Options, Requisition Templates, Requisition and Purchase Order Approval Hierarchies, defined Document Types, Receiving Options, Standard attachments, matching controls etc.
• Prepared CV40 Documents for converting Legacy open Requisitions, POs, Releases, Receipts into Oracle.
• Responsible for testing the applications after configurations and conversions.
• Prepared test cases for System Integration, User Acceptance Tests.
• Prepare User and Operational manuals and Conduct training classes for users in various departments.

Client : Confidential.

Environment : Oracle E-Business Suite 11.5.6 GL, AR, FA, OM, CE, INV , Oracle 8i, IBM AIX.

• As a Functional consultant, I was responsible for analysis, design, implement, test document AP, FA modules.
• Following are some of the activities I performed at ATMI:
• Setup Payables according to the business requirements.
• Setup Credit Card Programs, Tax groups, Recovery rules, Compound Taxes, Tax Proration using allocation feature across different invoice lines, enabled vendor site level DFFs.
• Setup Special Calendar, Distribution Sets for recurring invoices.
• Configured AP for Expense Reports like Applying Advances, etc.
• Developed CV40 to load suppliers/vendors, Legacy Expense Reports, AP Checks into Oracle Payables.
• Designed MD050 documents for customizing the AP check printing, various reports.
• Defined Asset, Location Key Flexfields according to Business requirements.
• Define FA Calendar, FA Book, Book Controls, Depreciation Methods, Rates, Asset Categories, Quick Codes etc.
• Responsible for preparing the CV040 documents for converting Legacy assets into Oracle Fixed Assets using FA Mass Additions.
• Designed MD050 documents for customizing existing reports / developing new reports.
• Responsible for developing the test cases for SIT, UAT.
• Developed user guides / Training materials based on ATMI business processes.
• Trained end users on AP and FA.
• Responsible for maintaining AP and FA after go-live.
• Responsible for fixing AP and FA production issues in functional area.
• Responsible for Period-End AP- GL reconciliation and period closing process.

Client : Confidential.

Environment : Oracle 8i, HPUX, Pl/Sql, Sql Plus, Developer 2000.

• As a business analyst, I was responsible for designing application. Following are some of the activities performed at Falcon:
• The system maintains data on suppliers, selected stores and customer's related transactions thus enabling management to do strategic planning and quick decision making to run the company's operations in an efficient manner.
• Involved in the implementation of reports module to meet reporting requirements.
• Responsible for functional design of form for maintaining master items.
• Functional Designed forms for different kinds of Transactions like Receipts, Purchase Returns, Issues, adjustments etc.,
• Making sure coding is done to meet all requirements in the design document.
• Functional designing of different Screens/Forms for front end user interaction. These are used for the data entry and enquiry like defining items, setting Sub-inventories, Stock Locators Area, Row, Bin , Purchase Order Entry etc.
• Analyze, design and suggest the ways to incorporate the requirements in the new system.
• Documented the system requirements / specification.
• Participated in requirement analysis/ business requirements.
• This project is to design and develop an integrated system for Inventory Management. The major components of this system are - purchasing, stores, sales and system administration. This is a menu driven system and also keeps track of the Item details, customer details, Company details, Branch details and Staff details.
• Conducted testing with on-site data entry and queries.

Client : Confidential

Environment : Oracle 7.3, Developer/2000 and Win NT/ 98

This project has been designed to handle the automation of patient Registration, Admission details, case sheets, ward administration, operation theater activities, and lab reports. It also keeps track of patients' medical records. The role for this project involved development, testing, training users and maintaining the system.

Following are some of the activities:

• Study existing information processing to evaluate effectiveness and develop new systems to improve production or workflow as required.
• Confer with personnel of organizational units involved to analyze current operational procedures, identify problems, and learn specific input and output requirements, such as forms of data input, how to summarize the data and format the reports.
• Conduct studies pertaining to development of new information to meet current and future projected needs.
• Analyze our requirements, procedures, and problems to automate processing and to improve existing system using Oracle for the Database.
• Review computer system capabilities, workflow and scheduling limitations to determine if requested program or program change is possible within existing system.
• Use the required tools to monitor the databases and suggest the required software or tools to be acquired.
• Write detailed description of user needs, program function and steps required to develop or modify computer program..
• Analysis, design and suggest the ways to incorporate the requirements in the new system.
• Responsible for testing the technical pieces developed by the developers.
• Preparing the Test Plans for testing functions and Procedures.
• Preparing the functional designs for the forms and reports required.
• Studying the incidents issued by the client and analyzing the resolution.
• Examining different module's Interactive Response Time.
• Plan and prepare user instructional manuals for day-to-day operations.