Business Analyst, Project manager, PeopleSoft Developer

PROFESSIONAL SUMMARY:

• Around * years of IT Experience in Application analysis, Business analysis, Planning, Design, Implementing and testing business process and design of Oracle Application Modules.

• Expertise in Functional and Technical aspects of Oracle EBS (R12,11i) in Oracle Purchasing (PO), Inventory (INV), Order Management (OM), Account Payables(AP) ,General Ledger(GL), Account Receivables(AR),CRM(Tele service, Email Center), HRMS, Oracle Projects, EAM, System Administrator, Application Object Library (AOL).

• Extensive experience in source/existing/legacy system business functionality and preparing the functional and Technical Design Documents using Oracle AIM Methodology (MD050, MD070, BR100, MD120).

• Experienced in Customization, Implementation and Support of Oracle Apps Order to Cash (OTC) and Procure to Pay (P2P) life cycles.

• Extensive technical experience in SQL, PL/SQL, Oracle Alerts, workflow, API’s, AOL concepts, Discoverer, XML Publisher, SQL*Loader and UNIX Shell script.

• Thorough in usage of various Oracle API’s, Interfaces and Conversions.

• Involved in production support of Oracle Applications 11i.

• Extensive experience with End to End, Unit Testing, Integration Testing and also involved in BAT testing.

• Used Quality Center for tracking the defects in test cycles.

• Good interpersonal skills, dedicated, disciplined, hardworking and a team player.

• Strong communication skills.

• Extensively used Metal ink to debug technical issues and have knowledge of creating SRs.

• Used VSS, Winscp, Wsftp and Putty Version control and data transfer tools.

• Proficient in using MS-Word, MS-excel and Microsoft Visio.

Achievements

Peer to Peer Recognition Award by Cisco

Quarterly Team Work and Collaboration Award By Cisco

Technical Skills: ERP (Oracle)

Packages : Oracle e Business Suite R12 / 11i

Modules: Order Management(OM), BOM,WIP,CRM(Teleservices, Email Center, Universal Work Queue, Install Base), HRMS, Projects, Oracle Purchasing(PO), Accounts Receivables(AR), Accounts Payables(AP), GL, Inventory, AOL, Oracle Alerts

Database: Oracle 8i/9i/10g

Programming Language: SQL, PL/SQL, Unix

Tools: SQL Loader, TOAD, 9iAS, 10gAS, Workflow and Discoverer, XML Publisher, Reports 10g/6i, Forms 10g/6i, SQL Loader, SQL*Plus, TOAD,OBIEE

Operating System: Windows, UNIX, Linux & Sun Solaris

Project‘s Details:

Client: VISA Inc, Foster City, CA Sep’ 10 to Till Date

Role: Techno Functional Consultant

GIFS (Global Integrated Financial System) 1.0 & GIFS2.0

Visa Inc. is a global payments technology company that connects consumers, businesses, financial institutions and governments in more than 200 countries and territories, enabling them to use digital currency instead of cash and checks. Visa has implemented Oracle Apps Financials 11.5.10.

As a Techno Functional Analyst, responsible for:

• Technical analysis & Customization of Oracle Average Rates and Period End Rates Process as per business requirements.

• Functional Design of Oracle Translation Rates process.

• Functional &Technical Design and development of Intermediary Payments report for Anti-Bribery group using XML publisher.

• Functional &Technical Design and development of SOE Payments report for Anti-Bribery group using XML publisher.

• Supporting GIFS2.0 project.

• Requirements gathering and analysis, Preparing Functional & Technical design documentation and reviews of business requirement documents and Test Plans.

• Addressing the defects raised by testing team.

• Fix/Clarify the Functional & Technical issues that may come up during the Test Cycles.

• Participating in the Business Acceptance Testing and User Acceptance Testing.

• Conducting User Training sessions.

• Creation and follow up of Technical Assistance Requests (TARs) with Oracle during setting up and testing of Development, Test and Production instances.

• Keeping Client-Management informed on important TARs having implications on the various implementation stages.

• Preparing status reports and presenting to the management & business.

Environment: Oracle Applications 11.5.10 (Account Payables (AP), Purchase Order (PO), General Ledger (GL)), Oracle 9i/10g, Linux, PL/SQL, XML Publisher and Oracle Reports.

Client: Cisco Systems Inc, Milpitas, CA Feb’ 10 to Sep’ 10

Role: Techno Functional Consultant

Cisco International 4.0

Cisco Int’l 4.0 release primarily focuses on activating Cisco Product & Services in Brazil operating Unit. Cisco Product & Services in Brazil operating unit will assume primary selling responsibilities for Brazilian customers. The Cisco Int’l releases are significant steps in the process of transforming Cisco's legal entity selling structure. Cisco Int’l 4.0 will activate the Brazil Product and Service selling capabilities and position Cisco to:

• Grow Top Line sales in Brazil

• Control Product Distribution into Brazil (e.g. control risk)

• Improve the Localized Cost Structure (e.g. VAT recovery)

• Preserve the Bottom Line for the Brazil business and the Global corporation

As a Techno Functional Analyst, responsible for:

• Technical analysis & Customization of OM workflow as per business requirements in Oracle Apps R12.

• Functional analysis, Design and development of order transfer from one order managemet instance to MFG instance for shipment of the order.

• Functional Analysis, Design and development of a custom API which validates & inserts the data into Auto invoice interface tables.

• Converting Cisco service requirements into oracle order management service functionality with minimal customization.

• Technical Design and development of an API which pushes service lines to third party system for Contract creation and pulls the contract information and updates the custom & base tables in order management.

• Functional analysis, design & development of delivering the license products and software products electronically.

• Functional analysis, design and development of an interface for software subscription items which will be used by crossflow teams to read the order data.

• Requirements gathering and analysis, Preparing Functional & Technical design documentation and reviews of business requirement documents and Test Plans.

• Designing the solution to meet the business requirements as part of To Be Flows. Discussing Gaps and Workarounds at the To Be stage with the business and obtaining concurrence.

• Effective communication with development team for technical analysis.

• Addressing the defects raised by testing team.

• Fix/Clarify the Functional & Technical issues that may come up during the Test Cycles.

• Participating in the Business Acceptance Testing and User Acceptance Testing.

• Conducting User Training sessions.

• Regular interaction with the client’s Functional Managers, Cross flow teams (Teams working on different applications), Business and Application Users – all belonging to different departments and divisions of client to ensure the smooth implementation and running of the applications.

• Addressing the functional/technical queries raised by offshore team.

• Creation and follow up of Technical Assistance Requests (TARs) with Oracle during setting up and testing of Development, Test and Production instances.

• Keeping Client-Management informed on important TARs having implications on the various implementation stages.

• Used Quality Center for tracking the defects in test cycles.

Environment: Oracle Applications 11.5.9/12 (Order Management (OM), Account Receivables (AR)), Oracle 9i/10g, Linux, PL/SQL and Oracle Reports.

Client: Electronic Arts, Redwood city, CA May’ 09 to Jan’ 10

Role: Techno Functional Consultant

iClick+ Oracle P2P

Electronic Arts Inc is the world's leading interactive entertainment software company. EA develops, publishes, and distributes interactive software worldwide for video game systems, personal computers, cellular handsets and the Internet. There is an existing region wise Oracle Applications implemented in 11.5.9 to support its operations. The current project is a reimplementation of the P2P and P2R tracks in 12i to be followed subsequently by an O2C and other tracks.

As a Techno Functional Analyst, responsible for:

• Solution design for Payments and EFT customizations.

• Involved in the customization of GL and AP reports using oracle reports and XMLP.

• Development of an interface to upload invoices from third party systems to AP using Open Invoice Interface.

• Customized the PO workflow as per business requirements.

• Customized Account Analysis Download Report and Trail Balance Summary Report in R12 as per business requirements.

• Customized the AP Open Interface Import Workflow to send notifications to users in case of in correct data in interface tables.

• Involved in Technical analysis of Supplier Conversion from 11i to R12.

• Thorough understanding of TCA data model as Suppliers have been moved to TCA data model in R12.

• Involved in Functional and Technical analysis of PO conversion from 11i to R12.

• Uploaded Contract purchase agreements in R12 using Data Loader.

• Planning and estimation of report and EFT deliverables for P2P and P2R tracks.

• Designed Discoverer reports.

• Customer communication with Requirement discussion, Scope and Change control activities

• Support the deployment of customizations

• Involved in the review of Business requirement and Functional specific documents

• Understanding the existing process and involved in the analysis of identifying all the objects to be customized.

• Supporting end-to-end testing during test-cycles.

• Coordination with offshore as it is an onsite/offshore model project.

• Code Review of the components

• Setting up the solution in a Development instance as a Proto-type to demonstrate the proposed solution to the client. Testing out adherence to business processes described in the core solution before demonstrating to client.

• Devising Data Conversion Strategy for Data Conversion from 11i instance of each region.

• Design of Customized reports in GL & AP, Testing and Deployments.

• Creation and follow up of Technical Assistance Requests (TARs) with Oracle during setting up and testing of Development, Test and Production instances.

• Keeping Client-Management informed on important TARs having implications on the various implementation stages.

• Involved in User Training sessions, preparing functional and Technical Design Documents.

• Co-coordinated with users for business capability testing and acceptance testing.

• Used Quality Center for tracking the defects in test cycles.

Environment: Oracle Applications 11.5.9/12 (Account Payables (AP), TCA, Purchasing (PO), General Ledger (GL)), iProcurement, iExpense Oracle 9i/10g, Linux, PL/SQL, XML Publisher, Workflow and Oracle Reports.

Client: Cisco Systems, RTP, NC Jun’ 08 to Apr’ 09

Role : Techno Functional Consultant

Single Trading Company (STC)

The STC Initiative will benefit Cisco and its Partners by being able to

• Pursue direct sales opportunities in emerging markets where the facilitation through a partner is unacceptable to the end customer

• Reclaim VAT costs

• Maintain Cisco’s consolidated Tax rate and thereby allow for growth at an affordable rate.

• Cisco wants to use the Multi Org functionality supported by Oracle and so it wants to decouple the association between Customer and Business entity.

Responsibilities:

• Involved in the review of Business requirements and Functional specific documents and responsible to call out the gaps and suggested the solutions.

• Understanding the existing process and involved in the analysis of identifying all the objects to be customized to decouple the association between Customer and Business Entity in OM, AR and GL.

• Provided support for Order Management work flow in test cycles.

• Thorough understanding of TCA data model for customer information.

• Cisco wants to create a separate structure for the customer freight exceptions and service levels which will lead to easy maintenance of data after creating new Business Entities.

• Involved in the design and customization of complex Cisco customized Move Rules process to derive customer freight exceptions from the new structure and to validate service level against the new structure." MOVE plays a critical role in assigning freight attributes required for Sales Order creation and booking.

• Involved in the customization of SOWB (Sales Order Work Bench) form and Cisco customized IC Engine Process to successfully create and book the orders though the addresses are replicated from existing buy-sells to new buy-sells.

• Involved in the customization of Cisco customized SOM process.

• Tested existing client customizations and confirmed issues and suggested resolutions.

• Contributed in BAT testing.

• Supported end-to-end testing during test-cycles.

• Coordination with offshore as it is an onsite/offshore model project.

• Code Review of the components

• Involved in unit testing as well as integration testing of the components.

• Used Quality Center for tracking the defects in test cycles.

• Review of Test plans and Test scripts prepared by QA and to call out if any gaps found in test scripts

Environment: Oracle Applications 11.5.9 (Order Management (OM), AR, GL), TCA, Oracle 9i, Linux, PL/SQL and Oracle Forms.

Client: Cisco Systems, San Jose, CA Feb’ 08 to May’ 08

Role : Techno Functional Consultant

Customer Account Foundation (CAF)

Responsibilities:

• Involved in the implementation of Cisco Customized ‘Name Only Search’ service in customer entry form.

• Responsible to customize the Customer Entry form to decouple the association between customer account and business entity.

• Involved in the review of Business requirement and Functional specific documents and responsible to call out the gaps and suggested the solutions.

• Coordination with offshore as it is an onsite/offshore model project.

• Code Review of the components

• Involved in unit testing as well as integration testing of the components.

• Given Kintana & PVCS training to the team to create the KPs for the modified objects and to make the KPs to be ready for deployment to Test/Production instances.

• Review of Test plans and Test scripts prepared by QA and to call out if any gaps found in test scripts

• Code Review of the components

• Involved in unit testing as well as integration testing of the components.

• Used Quality Center for tracking the defects in test cycles.

• Involved in the support of existing OM, AR and GL custom objects during test cycles.

• Given Kintana & PVCS training to the team to create the KPs for the modified objects and to make the KPs to be ready for deployment to Test/Production instances.

Environment: Oracle Applications 11.5.9 (Order Management (OM), AR), TCA, Oracle 9i, Linux, PL/SQL and Oracle Forms.

Client: Cisco Systems, Sanjose, CA Mar’ 07 to Jan’ 08

Role : Techno Functional Consultant

CRM Customization & Implementation

Responsibilities:

• Responsible for the Setups of the module ‘Email Center’.

• Customized the process of classifying the incoming mails as the standard oracle process does not fit for Cisco requirements.

• Designed and developed an automation process for the creation and updating of service requests for the incoming mails using PL/SQL packages.

• Used CS_SERVICE_REQUESTS_PUB package to create & update service requests automatically if the service requests are created/updated through Email/legacy system.

• Technical Lead and responsible to customize the Service Request form and the development of Concurrent programs.

• Implemented a custom package to get the sales order details from Order Managements and to show in service request form.

• Involved in resource & group setups.

• Customized Universal Work Queue as per the business requirements.

• Customized Contact Center form to restrict users to create only person party and to restrict users to modify only those parties & contacts created by Contact Center module.

• Involved in design and implementation of custom workflow using Workflow Builder 2.6.

• Involved in the review of Business requirement and Functional specific documents and responsible to call out the gaps and suggested the solutions.

• Implemented monitors which will send a notification if the download processor is down and any of the Email Accounts are inactive and also if the concurrent programs are error out and pending for long time.

• Coordination with offshore as it is a onsite/offshore model project

Environment: Oracle Applications R12, CRM (Email Center, Teleservices, Universal Work Queue), TCA, Oracle 10g, Sun Solaris, PL/SQL, Workflow and Oracle Forms.

Client: Balfour Beatty, UK Sep’ 05 to Feb’ 07

Role :Techno Functional Consultant

Customization & Implementation of Plant Hire Module

Responsibilities:

• Designed and developed the Custom Store Issue/Receipts and Internal Movements forms.

• Involved in the Design and Development of Custom Drivers form and the integration of this component with other components.

• Development of Setup forms

• Development of Custom Accrual Adjustment form

• Designing and development of Damage Notification work flow using Workflow Builder 2.6

• Design and Development of Interfaces loading Expenditures from custom module into Project Expenditure screen using Oracle Projects APIs.

• Implemented monitors which will send a notification if the concurrent programs are error out and pending for long time.

• Designed and Developed EUL, Business area, custom folders, item classes, joins and hierarchies using Discoverer 4i.

• Created alerts for several events in Projects modules

• Code Review of the components

• Involved in unit testing as well as integration testing of the components.

• Raised support requests with Oracle Support & Development for client issues of above projects and test patches before suggest applying at production.

Environment: Oracle Applications 11.5.10 (Oracle Projects, EAM, Plant Hire Module), Oracle 9i, Linux, PL/SQL, Workflow, Oracle Forms, Reports, Discoverer Administrator and Desktop Plus.

Client: Covad Communications, CA Aug’ 03 to Sep’ 05

Role :Technical Consultant

Responsibilities:

• Employee Conversion: Used HRMS API’s for converting employees’ addresses, phones, contact, special information and other descriptive flex field information from Legacy to Oracle.

• OTL Automation: A program developed to automate OTL Assignments whenever job changes occur in HR. Whenever job changes in HR an Alert will fire which will call this program to automate OTL assignments.

• Employee Special Information: A Conversion program developed to read the list of trainings undergone by employee from a flat file and process them through seeded HRMS APIs.

• Employee Termination: A conversion program developed to read the list of employees needs to be terminated from a flat file and terminate the employees using the seeded HRAPI.

• HRMS Alerts: Created alerts for several events in HRMS modules.

• Work Flow Customization: Added a function to the customized workflow (PO requisition workflow) as per the business requirements. Customized the ‘OTL workflow for employees’ to change the URL attribute as per the business requirements.

• Coordinating with onsite for understanding the functional documents, issues resolution.

• Preparing technical design documents and UTPs, Developing code and performing unit testing. Code includes shell scripts, pl/sql packages, SQL*Loader programs and SQL reports.

Environment: Oracle Applications 11.5.9 (Oracle HRMS, OTL), Oracle 9i, Linux, PL/SQL and Workflow

Trainings Undergone/Given:

Workflow2.6, Oracle AOL

Developer 6i, TCA, Oracle Projects

Education:

Masters in Computer Applications (MCA), from Nagarjuna University, India.

Contact this candidate