Summary

• Over Eighteen years of IT experience as System - Business Analyst of software applications. Over Sixteen years of experience in Oracle Applications E-Business suite R12, 11i, 11.x and 10.7 as Techno Functional consultant - General Ledger, Oracle Payables, Oracle Receivables, Oracle Assets, Project Costing, Oracle Purchasing, Cash Management, Inventory, Service Contracts, Installed Base, Order Management, etc.. Over Eight years of combined Public Sector / Federal Oracle EBS experience. Involved in all aspects of system life cycle. Expertise in implementation, upgrade and maintenance and design of WRICE Workflow, Reports, Interface, Conversion and Enhancement components. Involved in GAP analysis, design, defining and implementing business rules. Design architecture of custom applications and its integration with Oracle E-Business Suite.
• Involved in support of business processes post implementation of ERP, CRM and MFG suite. Responsible for Corporate Consolidation, Translation and Revaluation processes. Team member for implementation and support of Global Implementations, which includes MOAC / Multi-Org and Multi-Language installations.
• Worked with Clients in business process review, analysis, Business Process Reengineering and Automation for their business processes.
• Lead support and development team for worldwide support, which involved direct interactions with different end user communities and off-shore teams. Excellent inter-personal and trouble shooting skills. Team player outlook with proven record to meet business goals within allotted time and budget. Ability to interact and communicate with clarity at all level of organization. Ability to work on multiple projects in fast pace environment and quickly learn new relevant technologies as per client's need.

Years of Experience

• 18 Years of IT Experience
• 16 Years related to Oracle E-Business Suites ERP, CRM, MFG, SCM
• 8 Years of combined Public Sector / Federal Oracle EBS

Oracle Applications Expertise

• Over 16 years of Oracle E-Business Suite experience.
• Expertise in multiple Implementation and upgrade of Oracle E-Business Suite R12, 11i .
• Support Oracle E-Business Suite R12, 11i, 11, 10.7

PROFESSIONAL EXPERIENCE

Confidential

Role : Techno - Functional Consultant

• Modules : GL, AR, TCA, FA, Projects Billing / Costing / Manufacturing , HRMS, Application Object Library, System Administration, BI Publisher
• Version : Oracle E-Business Suite R12 12.1.3
• Tools : Linux Shell Script, Oracle Developer Suite 10g Oracle Forms / Oracle Reports , SQL PLUS, PL/SQL, SQL Developer, BI Publisher, FNDLOAD
• Project Details: Working as Sr. techno functional consultant on multiple end clients with CSC that are Defense Contractor. Joined the project at the start of phase 1 implementation of R12 12.1.3 requiring technical and functional expertise.

Responsible for:

• Review AN100 and identify any gaps for technical team for Contracts conversion, Projects Billing customizations.
• Design and develop DS140 for custom Projects Billing custom forms, customer conversion, etc.
• Design and develop Project Billing custom forms as per AN100 and DS140 documents and Oracle EBS R12 standards.
• Team member to develop document standards.
• Core team member of team conceptualizing and developing generic conversion tool for another client.
• Designing and developing customer, sites and contacts conversion.

Confidential

Role : Techno - Functional consultant

• Modules : GL, AP, AR, TCA, EAM, PO, Projects Billing / Costing / Manufacturing , Inventory, BOM, WIP, HRMS, Application Object Library, System Administration, BI Publisher
• Version : Oracle E-Business Suite R12 12.1.3
• Tools : Linux Shell Script, Oracle Developer Suite 10g Oracle Forms / Oracle Reports , SQL PLUS, PL/SQL, SQL Developer, Workflow, BI Publisher, FNDLOAD
• Project Details: The end client is a Defense Contractor. Joined this project post go-live of R12 12.1.3 implementation. The client is scheduled for Defense Contract Audit Agency DCAA audit and needed help with identifying potential concern areas to be in compliance with Earned Value Management systems EVMS . This is a complex process since multiple reporting systems, including EBS, are in use.
• The end client was going live with EBS R12 at another company that was acquired few months ago. It was essentially go-live of the merged company processes with the existing EBS R12. The go-live process required that it meet the upcoming Sarbanes Oxley audit and ensure compliance with SOX guidelines.

Responsible for:

• Working closely with EVMS expert and generate report and data extract from Project billing and costing modules.
• Review and analyze this data and identify gaps within the system that would potentially cause a DCAA audit failure. Present the findings to the business owner
• Modify report as necessary per business owners request to include additional data in extract that would help mitigate audit issues.
• Successfully completed data extract as required by business owners prior to DCAA audit.
• Review and identify gaps in business processes and control that would potentially cause concern during SOX audit.
• Assisted in reviewing control processes to be SOX compliance.
• Review and prepare requirement documents, technical documents, implementation and installation documents, test script documents and peer review documents.
• Lead and mentor the EAM, BOM and WIP test team to ensure that the test scripts are SOX compliant for the upcoming EBS R12 go-live integration of the merged company with the existing EBS R12instance. Identify and fix gaps that would potentially cause SOX audit failure.

Confidential

Role : Techno - Functional Analyst

• Modules : GL, AP, AR, TCA, FA, PO, Oracle Service, HRMS, Application Object Library, System Administration, BI Publisher
• Version : Oracle E-Business Suite R12 12.1.3 , 11i 11.5.10.2
• Tools : Linux Shell Script, Oracle Developer Suite 10g Oracle Forms / Oracle Reports , Forms6i, Reports6i, SQL PLUS, PL/SQL, SQL Developer, Workflow, TOAD, BI Publisher
• Project Details: Joined this project almost at the start for implementation of EBS R12 12.1.3 . A decision was made to implement Oracle EBS R12 as a fresh install rather than upgrade from 11i 11.5.10.2 . The legacy 11i system has lot of overheads that are no longer needed in R12 due to business consolidation. R12 is implemented for Oracle Financials, CRM and HRMS modules. Working as techno-functional analyst in Oracle e-Business Suite with MIS department, responsible for identifying data eligibility from 11i and convert it to MOAC compliant R12 data in various modules. Also responsible to identify and mitigate any GAP in business processes. The system is successfully live since first week of January 2014 and later worked on post-implementation support in OTC, PTP and RTR track.

Responsible for:

• Working closely with business to identify valid customers eligible for conversion from 11i to R12. Prepare MD50 and maintain track of various change requests over the course of implementation.
• Design, develop and test 11i customer data extraction process. Complete MD50 / MD70 documentation for the process.
• Design, develop and test MOAC compliant R12 customer conversion process using 11i extracted data. Used TCA APIs to create all customer accounts related components. Complete MD50 / MD70 documentation for the process.
• Working closely with business to identify valid open invoices, on-account receipts and unapplied receipts for conversion. Review MD50 and maintain track of various change requests.
• Design, develop and test 11i open invoices, on-account receipts and unapplied receipts data extraction processes. Complete MD50 / MD70 documentation for these processes.
• Design, develop and test MOAC compliant R12 open invoices, on-account receipts and unapplied receipts conversion processes. Complete MD50 / MD70 documentation for these processes.
• Working closely with business to identify valid assets and tax books eligible for conversion from 11i to R12. Review MD50 and maintain track of various change request.
• Design, develop and test 11i assets and tax books data extraction processes. Complete MD50 / MD70 documentation for these processes.
• Design, develop and test R12 assets and tax books conversion processes. Complete MD50 / MD70 documentation for these processes.
• Design, develop, test and document various custom reports using BI Publisher / Reports10g. Used bursting feature for some of these reports.
• Working with business to identify and plan for recommended patch collection RPC patching schedule for Financials modules.
• Oracle forms personalization for CLE Swiss add-on localizations and Cash Management forms.
• Identify and configure patch wizard utility and register flagged file tools. Pre-patch application analysis using patch wizard utility.
• CRP1, CRP2 and UAT issue management team member.
• Design and develop custom reports in GL and AR post go-live and prepare its documentation.
• Design, develop and test Fixed Assets tax lines interface post go-live. Complete MD50 / MD70 documentation for these processes.
• Modify custom GL form to activate DFF.
• Modify custom workflow to include additional details for custom GL form.

Confidential

Role : Techno - Functional Analyst

• Modules : GL, AP, AR, TCA, FA, Oracle Projects and Oracle HR, Application Object Library
• Version : Oracle Public Sector E-Business Suite 11.5.10.2 CU2 , R12
• Tools : UNIX Shell Script, Oracle Developer Suite 10g Oracle Forms / Oracle Reports , Forms6i, Reports6i, SQL PLUS, PL/SQL, TOAD, SQL Developer, Workflow
• Project Details: Joined this project post upgrade from 11.5.9 to 11.5.10.2 in Oracle Public Sector Financials and new implementation of Oracle HRMS Suite that includes HR, Payroll, OAB and HRMS Self Service. Responsible for high level review of upgrade to R12. Working as techno-functional analyst in Oracle Public Sector e-Business Suite with I.T.S. department supporting various Oracle E-Business Suite modules. In Oracle Financials resolve / troubleshoot issues in General Ledger, Oracle Assets, Purchasing, Grants / Projects, review GL year end process, Receivables, Payables, etc. Design and execute third party integration with Oracle E-Business Suite.

Responsible for:

• Review impact on existing 11i customizations for R12 upgrade.
• Modify existing 11i customizations to seamlessly work with R12.
• Successfully implemented procurement Procurement RUP12.
• Reviewed and recommended creating Receivables setup for Fire Mobile Eyes project to streamline revenue recording in Oracle E-Business Suite.
• Modify Workflow for Purchasing and Requisition Account Generator.
• Designed, develop and tested Fire Mobile Eyes to DRMS Receivables interface. Used standard Oracle interface processes.
• Reviewed, designed and developed Functional and Technical Design specification documents for Fire Mobile Eyes interface project.
• Successfully Setup and implemented Receivables lockbox processing.
• Design and developed third party interface PPS for Payables module.
• Reviewed, design and developed functional and technical design document for Oracle HRMS UIA customization. Configure, Setup and tested HRMS for UIA.
• Co-ordinated with Purchasing Department, ITS department and Oracle Support resolving high priority Purchasing issues related to encumbrance accounting and other business critical issues as part of Purchasing Oracle Insight initiative.
• Reviewed, designed and developed Functional and Technical Design Specification Documents for Oracle Purchasing, Receivables, Payables, HRMS, etc. customizations.
• Troubleshoot and fix issues in Oracle Purchasing customizations for Contract History POs, outbound interfaces from Oracle E-Business Suite, etc.
• Worked independently with Oracle Support Metalink and Business Support Specialist to successfully resolve issues and close TARs for General Ledger, Oracle Assets, Purchasing, Grants / Projects, Receivables, Payables, HR, etc.
• Establish standards and co-ordinate with bank's customer relations and transmission team for file transmissions from and to City Of Detroit to various banks.
• Designed, developed and tested custom VBScripts script for encrypting or decrypting and transmitting City Of Detroit's files to / from vendors.
• Involved in reviewing mapping document for HRMS implementation with SMEs.
• End-To-End Application Testing Strategies Unit, System Integration, Quality Assurance, User Acceptance Test, Sign-Off .
• Assist COD employees to design and develop technical aspects of new customizations for Oracle HRMS.
• Conducted SQL and Query Builder training for select group of City Of Detroit's employees.

Confidential

Role : Techno - Functional Analyst

• Modules : GL, AP, AR, TCA, FA, CE and Oracle Projects and Oracle HR, System Administration, Application Object Library, Applimation
• Version : Upgrade from Oracle E-Business Suite 11.5.10 to 11.5.10.2CU2
• Tools : UNIX Shell Script, Forms6i, Reports6i, SQL PLUS, PL/SQL, TOAD, Applimation.
• Project Details: It is a complex project where numbers of multiple projects were successfully executed in parallel. Worked as techno-functional analyst from client-side with Bearingpoint, that was the implementing partner of Cendant. The data for Travelport was identified and filtered into a new instance using Applimation and migrated to Oracle On Demand OOD from Solaris platform to Linux. Oracle Project costing, Accounts Payables configuration and HR are also implemented post the OOD go-live.

Responsible for:

• Involved in creating project plan for identifying technical and functional tasks and resources.
• Involved in Configuration Management and setting up instances based on BR100 baselines.
• Configuration setup for Oracle Project Costing and Accounts Payables new Operating Unit .
• Designed and developed Functional and Technical Design Specification Documents for Oracle Project Costing module. Design and develop customization reversing the cost of overtime charged on a project by employees.
• Develop Document possible business scenarios and creating Crude Matrix for capturing different combinations of business rules.
• Configuration setup for Oracle Assets for new corporate book to test an alternative to proposed solution.
• Interface design and development of Fixed Assets for the new corporate book.
• Designed and develop customization to identify employees in HR base tables and link it with TCA tables.
• Design and develop approach to identify and filter Travelport data from Cendant instance.
• Configured Applimation to identify Travelport related data from the Cendant instance for General Ledger, Accounts Payables, Accounts Receivables and Cash Management modules. Data in Oracle Assets and Oracle Projects were handled separately. Verify data integrity post Applimation process in new Travelport instance.
• Design and developed data cleanup script to identify and flag data in shared operating units and set of books.
• Addressed Security Access issues for OOD for custom objects. Designed and develop scripts to grant access to custom objects as per OOD's standards.
• Worked with teams in Australia, UK and Hong Kong.
• Involved in developing Testing strategy capturing different business scenarios from Subject Matter Experts SMEs .
• Involved in providing strategic solutions for phased implementation.
• Extensively involved in User interaction and capturing requirements.
• Involved in documentation of Functional Specifications, Technical Design of various custom extensions including code review and conducting Walkthroughs and Final Signoffs.
• Extensively involved in cross-functional teams in providing efficient solutions.
• Involved in meetings with end user both offsite and on site. Interactively participated throughout the project, debugged, tested, implemented and documented all the tasks assigned

Confidential

Role : Techno - Functional Analyst

• Modules : GL, AP, AR, FA, INV and PO, System Administration, Application Object Library, VISTA CPG , IMI
• Version : Upgrade from Oracle E-Business Suite 11.5.9 to 11.5.10
• Tools : UNIX Shell Script, Forms6i, Reports6i, SQL PLUS, PL/SQL, TOAD, FNDLOAD utility, Discoverer Admin / Desktop Edition, Kintana, PVCS.
• Project Details: Worked as a techno functional consultant for upgrading Oracle Applications Suite 11.5.9 to 11.5.10. Modules involved in Oracle E-Business suite 11i are Oracle General Ledger, Payables, Receivables, Fixed Assets, Inventory and Purchasing, Oracle System Administration, AOL, etc. on 10g database. There is strong custom integration between VISTA, IMI and Oracle E-Business suite that needs to be maintained in the upgrade as well as customizations forms, reports, discoverer views, packages, etc within Oracle E-Business suite that needs to function consistently. The 11.5.10 installation is also a multi-language or multi-lingual installation.

Responsible for:

• Design and develop approach to upgrade custom forms, reports, package, UNIX scripts, etc.
• Designed, developed and deploy custom reports and forms.
• Designed and developed new customization to interface data from VISTA, IMI to Oracle E-Business Suite.
• Troubleshoot and resolve issues in custom reports. Many reports working correctly in 11.5.9 failed in 11.5.10. The cause was the multi-lingual setup in 11.5.10. Modified the reports as per the customization standards.
• Designed and developed database triggers in VISTA instance for auditing promotions data. This was part of Promotion Audit process integrating VISTA / IMI and Oracle E-Business Suite.
• Involved in developing testing strategy capturing different business scenarios. Conducting Walkthroughs and Final Signoffs.
• Developed Functional and Technical Design documents for customization.
• Involved in Database architecture and process handling and implementation of coding standards.

Confidential

Role : Team Lead

• Modules : GL, AP, AR, FA, Purchasing, BOM, Inventory, WMS, System Administration, Application Object Library
• Version : Upgrade from Oracle E-Business Suite 11.03 to 11.5.10 CU2 Off-Site , Upgrade from 10.7SC to 11.5.10 CU2 On-Site
• Tools : UNIX Shell Script, Forms6i, Reports6i, SQL PLUS, PL/SQL, TOAD, FNDLOAD utility, Discoverer Admin / Desktop Edition.
• Project Details: Worked as a techno-functional lead for upgrading the Oracle Applications Suite 11.0.3 to 11.5.10 for financial modules and Oracle Applications Suite 10.7SC to 11.5.10 CU2 for manufacturing modules. Modules involved were Oracle General Ledger, Oracle Payables, Oracle Receivables, Oracle Assets, Purchasing, Inventory, BOM, Warehouse Management, Oracle System Administration, AOL, etc. on 9i database. There were extensive customizations in 11.0.3 and 10.7 that were upgraded to 11.5.10 viz. forms, reports and discoverer views. Lead on-site and offshore team in India. Offshore team upgraded most of the 11.0.3 and 10.7 customizations forms, reports, discoverer views, packages, etc . Offshore team comprised of 5 technical developers and 2 DBAs. The project was successfully executed as per the scheduled go-live date.

Responsible for:

• Application Configuration, setup requirements for 11i and plan for migration.
• Data Model transformation Migration for 11i.
• CRP Setup, testing strategies test scenarios development, organize QA testing.
• Migration to 11i, QA Testing for 11i, Writing Test Script, Testing and verification of results with the existing application results.
• Assessment of workloads of customization.
• Managed TAR SR with Oracle Metalink Support. Hosted daily scheduled call with Oracle for expediting resolutions and priorities for SRs.
• Lead team in conducting Working Sessions and make business decisions. Involved in providing solutions to meet requirements from business user community.
• Conduct Status Meetings, obtain Status reports and include updates on Project plans.
• Trained business users to use workflow processes Approval / Rejection, notifications, etc.
• Meeting with user departments. Resolving the problems in the applications area, defining new requirements.
• Developed Functional and Technical Design documents for customization.
• Involved in Technical Design of various custom extensions including code review.
• Coding, Develop Test Strategy, Unit Testing, System Testing and identifying system readiness criteria.

Confidential

Role : Techno Functional Consultant

• Modules : FA, AR, TCA, AP, Cash Management, System Administration, Application Object Library
• Version : Oracle E-Business Suite 11i - 11.5.9
• Tools : UNIX Shell Script, Forms6i, Reports6i, SQL PLUS, PL/SQL, TOAD, FNDLOAD utility.
• Project Details: Worked as a techno functional consultant for data conversion in Oracle E-Business Suite 11.5.9 . The site has more than 20 Oracle Applications modules installed viz. GL, AR, AP, Inventory, OM, IStore, FA, Cash Management, Oracle System Administration, AOL, Workflow, Purchasing, etc. on 8i database. Conversion project was restricted to Vendor Sites Conversion, Fixed Assets Configure and Conversion , Payables Transactions Conversion, Cash Management Conversion Bank Reconciliation .

Responsible for:

• Conduct meetings with various financial department heads to discuss conversion and implementation strategies.
• Documenting BRD Business Requirement Document , Functional MD60 Technical MD70 Specifications.
• Involved in Technical Design of various conversions from legacy / Oracle database to Oracle E-Business Suite.
• Design, Develop and Deploy custom Forms for the Payables Transactions conversion. This conversion was to generate invoices based on the credit card transaction file received from a bank.
• Activated descriptive flexfield on value set to identify operating unit for a company code. This was used only for Payables Transactions conversion.
• Created BR100 document and configured Oracle Assets.
• Designed Interface to Oracle Assets for creating Assets from flat files generated from the legacy Fixed Assets system. Used mix of SQL LOADER and PL/SQL for loading and validating legacy data.
• Review and Correct Oracle Payables and Cash Management setups and configuration.
• Designed customization to create Vendor Sites based on existing data but for a new operating unit.
• Designed Interface to Cash Management for importing bank statements for reconciliation.
• End-To-End Application Testing Strategies Unit, System Integration, Quality Assurance, User Acceptance Test .

Confidential

Role : Techno Functional Consultant / Lead

• Modules : TCA , OM, AR, Oracle Purchasing, Oracle Contracts, Oracle Order Capture, Oracle Installed Base, System Administration, and Application Object Library
• Version : Oracle Applications E-Business Suite 11i - 11.5.7
• Tools : UNIX Shell Script, Reports6i, SQL PLUS, PL/SQL, Discoverer Admin and User Edition , TOAD, FNDLOAD utility.
• Project Details: Joined this project as techno functional consultant for Oracle Applications 11.5.7 and later on worked as tech lead and on-site coordinator for off-shore team. The site has 23 Oracle Applications modules installed viz. GL, AR, AP, Inventory, BOM / WIP, OM, Oracle Contracts, Oracle Installed Base, Oracle Order Capture, Oracle System Administration, AOL, Workflow, Purchasing, etc. on 8i / 9i database. As an on-site coordinator and tech lead he is responsible for gathering requirements and preparing functional and technical document design for off shore team. Off-shore team comprised of 3 technical developers.

Responsible for:

• Resolving Open issues in applying business rules with user community and other Cross Product teams.
• Creating documentation standards.
• Design Change Management System comprising of review and sign-offs at various levels.
• Documenting BRD Business Requirement Document , Functional MD60 Technical MD70 Specifications.
• Design, Develop and Deploy various custom Reports involving data from multiple modules.
• Design various custom lookups giving control to IT personnel to manage variables in custom reports instead of hard coding.
• Gather requirements and created functional and technical specs for off-shore team.
• Unit tested and implemented UAT strategies for off-shore developed customizations.
• Design and develop outbound interface data files and reports to ADP.
• Design and develop customization to automate contract renewal reminder process. The automation reduced process times from weeks to hours. The process created custom reports that were integrated with OPTIO to print the desired letters.
• Design and Register discoverer views using Discoverer Admin. Design and Develop Discoverer reports.
• Introduce use of FNDLOAD utility to increase productivity and reduce migration time for customizations.

Confidential

Role : Techno Functional Consultant

• Modules : GL, GIS/GCS, AR, Inventory, OE, OM, BOM/WIP, HR, Oracle Alerts, System Administration, Application Object Library
• Version : Upgrade from 11.0.3 to Oracle Applications E-Business Suite 11i - 11.5.8
• Tools : UNIX Shell Script, Reports6i, SQL PLUS, PL/SQL, Discoverer Admin and User Edition , TOAD.
• Project Details: Worked as techno functional consultant for Oracle Applications upgrade from 11.0.3 to 11.5.8 from initiation phase. Modules included are GL, AR, AP, Inventory, BOM / WIP, HR, Oracle Alerts, System Administration, AOL, GIS/GCS, Workflow, OM, Purchasing, etc. on 9i. Primary responsibilities include review and update setups, upgrade Forms, Reports, Packages, Procedures, Functions, Shell scripts, Alerts and Workflow in 11.0.3 to 11.5.8. Also responsible for Workflow Customization. Project was implemented by Oracle for Core Laboratories.

Responsible for:

• Review and correct setups for Order Management as per BR100 document.
• Review and correct setups for General Ledger as per BR100 document.
• Upgrade various Order Entry custom reports from 11.0.3 Application architecture to 11.5.8 Order Management architecture.
• Upgrade various Oracle Alerts from 11.0.3 architecture to 11.5.8 architecture. Custom Alerts for Purchasing, OE to OM, BOM, WIP, AR, etc. modules were modified.
• Customize cost of goods sold COGS workflow in Order Management.
• Upgrade and Tune various HR discoverer views from 11.0.3 to 11.5.8.
• Designed and develop GIS related customization for Unsettled Intercompany Invoices. The customization comprised of creating database triggers, modifying CUSTOM.pll for validation and creating custom reports.
• Design and Develop MD60 functional and MD70 technical specification documentation.

Confidential

Role : Technical Lead

• Modules : GL, AR, TCA, AP, PO, FA, Inventory, Installed Base, Oracle Service Contracts, Telesales, EDI Gateway, System Administration, Application Object Library
• Version : Oracle Applications E-Business Suite 11i - 11.5.5 and 11.5.8
• Tools : UNIX Shell Script, Reports6i, Forms6i, SQL LOADER, SQL PLUS, PL/SQL, Discoverer, TOAD.
• Project Details: Worked as technical lead from the conception of the project for designing and maintaining RICE components. Medela is implementing various modules of Oracle Applications 11i Suite ver. 11.5.5 and later 11.5.8 - both ERP and CRM. Conversion project started with 11.5.5 and was later upgraded to 11.5.8. Team comprised of 6 persons including self. Modules implemented include GL, AR, AP, PO, Inventory, BOM, Fixed Assets, EDI Gateway, CRM, System Administration and Application object Library. Conversion project was restricted to Vendor Conversion, Customer Conversion, Prospects Conversion, Items Conversion, BOM/Routings, AR Transactions Includes Receipts and Adjustments , Installed base, Fixed Assets, On-Hand Quantities and Service Contracts.

Responsible for:

• Prepare conversion project plan and integrate with the functional implementation vendor's project plan.
• Conduct Status Meetings, obtain Status reports and if necessary, update the Project plans.
• Conduct meetings with top management in weekly review.
• Identifying and resolving bottlenecks for RICE components.
• Documenting BRD Business Requirement Document , Business Requirement Mapping, Data Conversion CV10 / CV50 , Functional MD60 Technical MD70 Specifications.
• Conduct conversion data mapping meetings with business users and respective team members.
• Review and correct Oracle Assets, Oracle Receivables, Oracle Payables, Installed Base, Service and Core Contracts configuration.
• Designed Interface to Oracle Assets for creating Assets from flat files generated from the legacy system.
• Designed Interface to Prospects conversion for creating Prospects from flat files generated from the legacy system. Used TCA APIs for importing validated prospects data into Oracle Receivables base tables.
• Designed Interface to Oracle Payables for creating Vendors and Vendor Sites from flat files generated from the legacy system.
• Designed Interface to Installed Base IB for creating Customer Products from flat files generated from the legacy system. Used Installed Base APIs to create data in IB's base tables.
• Designed Interface to Oracle Service Contracts for creating Service Contracts from flat files generated from the legacy system. Used Oracle Service's APIs to create service contracts in base tables.
• Create test scripts for conversion process to verify data integrity and business processes.
• End-To-End Application Testing Strategies Unit, System Integration, Quality Assurance, User Acceptance Test, Sign-Off .

Confidential

Role : Techno Functional Consultant

• Modules : GL, AP, System Administration, Application Object Library, Custom Application
• Version : Oracle Federal Application E-Business Suite - 11.0.1 and 11.5.4 11i
• Tools : UNIX Shell Script, Reports6i, Forms6i, Reports2.5, Form4.5, SQL PLUS, PL/SQL, Discoverer, TOAD.
• Project Details: The end client is Government of United States of America. Worked as techno functional consultant on Pell Grant Systems post Oracle Applications Federal 11.0.1 implementation to review and redesign GL and AP processes. The project involved developing a system to eliminate use of Oracle Payables and have Oracle General Ledger meet the requirements of ED the Education department . Regular releases of customization was planned and implemented successfully. Designed, developed and integrated customization successfully. Member of core team for 11i 11.5.4 upgrade prototype. He planned, gathered requirement, design, develop and successfully integrate a custom application that required merging and managing data from diverse data sources.

Responsible for:

• Upgrading custom forms and reports for 11i 11.5.4 upgrade. Review and change General Ledger Federal setups for 11i upgrade.
• Designed Interface to General Ledger for creating Journals from flat files imported from ED Education Department . Used mix of SQL LOADER and PL/SQL for loading and validating legacy data. Used Oracle Standard import process to create data in General Ledger base tables.
• Design, develop and integrate custom form with Oracle Applications.
• Design, develop and maintain Discoverer reports.
• Review and tune custom code to improve processing times from hours to minutes.
• Documenting BRD Business Requirement Document , Business Requirement Mapping, Data Conversion CV10 / CV50 , Functional MD60 Technical MD70 Specifications.
• End-To-End Application Testing Strategies Unit, System Integration, Quality Assurance, User Acceptance Test, Sign-Off .
• Created and integrated custom application with Oracle Applications. It involved processing data from mainframes and generating reports.

Confidential

Role : Technical Consultant

• Modules : GL, AR, Oracle Service, System Administration, Application Object Library, Custom Application
• Version : 11.0.3
• Tools : UNIX Shell Script, UNIX Shell Script, Reports2.5, Forms4.5, SQL PLUS, PL/SQL.
• Project Details: Joined as technical consultant during post - implementation of Oracle Applications Release 11.0.3 viz. Oracle Order Entry, Oracle Receivable, Oracle Payable, Oracle General Ledger and Oracle Service modules . The project tasks included activities ranging from gathering of requirements to providing production support and customization.

Responsible for:

• Design, develop and integrate custom Reports using data from Order Entry, Oracle Service, GL, etc..
• Prepare Functional MD60 and Technical MD70 documentation.
• Design, develop and integrate custom application with Oracle Application. The custom application processed and exported data from Oracle Service to custom applications schema.
• Design, develop and integrate custom form with Oracle Applications.

Confidential

Role : System Analyst

• Modules : WebDB
• Tools : SQL PLUS, PL/SQL, WebDB.
• Responsible for:
• Gather requirements for in-house employee time management system.
• Design and develop architecture, web layout and reports in WebDB .

Confidential

Role : Analyst programmer

• Modules : GL, AR, AP, System Administration, Application Object Library, Custom Application
• Tools : Reports2.5, Forms4.5, SQL PLUS, PL/SQL, SQL LOADER.
• Project Details: Worked as an ERP consultant for in-house and off shore project management of Oracle Applications 10.7 SC. Modules implemented were GL, AR, AP, System Administration and Application Object Library. Project tasks included activities of co-coordinating with on-site resources to understand specifications. Project involved customizing GL forms, creating and integrating custom applications with Oracle Applications, creating reports for GL, AR, AP etc..
• Role: Responsible for customizing forms in GL, create and integrate custom application with Oracle Applications suite. Responsible for in house and off shore implementation and customization of GL, AR, AP in Oracle Applications 10.7 using System Administration and Application Object Library. Designed, developed and customized forms and reports to meet business requirements using Developer 2000 with Oracle 8 as main database for in house projects as well off shore projects. He used customization by modification rule of Oracle Applications for customizing forms

Confidential

Role : System / Programmer

• Tools : Reports2.5, Forms4.5, SQL PLUS, PL/SQL, SQL LOADER, Foxpro2.5, Visual Foxpro.
• Ashwamedh Infotech is a software and management consulting firm that engages with clients in Transportation / Agro Chemical Industries. Worked on-site and off-site in different roles varying from imparting end users training to designing, understanding requirement of clients and developing applications for system integration using Oracle tools like Forms 4.5, Reports2.5, SQL PLUS, etc. and non-oracle tools like Foxpro2.5 and Visual Foxpro.