SUMMARY:

• 17 years of functional industry experience, delivering technology solutions to improve organizational productivity and efficiency including business systems analysis, solution design, application development and deployment of Enterprise business solutions.
• Oracle Applications (R12, 11i, 11.03, 10.7): Oracle Distributions Modules R12, 11i, 11.03, 10.7(specializing in Order - to-cash), Order Management, Shipping, Pricing, BI Publisher, Inventory, Procure-to-pay, Confidential, AR, B2B, EDI, WMS, Service Contracts and Install Base.
• Hands on experience in design and handling of Service Contract Warranty, Extended Warranty and complete flow from OM, WSH into Oracle AR Invoicing and posting into GL.
• Hands on experience in creating, articulating writing the business process into documentation like FSD, TSD, BRD, MD50 and MD70.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization, forms personalization, reports using Report builder 6i, XML Publisher and exposure to WF and Oracle Discoverer.
• Excellent technical knowledge in Oracle Forms/Reports, Workflow builder, PL/SQL and Oracle AOL.
• Proficient in server-side programming - Store Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Proven record of success successfully working with senior business teams and delivering IT solutions on time within allocated budget.
• Ability to credibly and effectively liaise with IT partners and manages technology vendors.
• Proven ability to manage projects across organizational boundaries and lead cross-functional initiatives within complex enterprise environment.
• Solid exposure in aligning technology, architecture, & application with overall business strategy.
• Design creative solutions using standard Oracle functionality, thus limiting customizations.
• Conduct excellent training and testing sessions for end users and production support.
• Ability to mentor consultants and team members, as well as, build consensus between parties.
• Outstanding communication skills and commitment to superior customer service
• Interacted with Oracle Support to resolve application issues, Bugs and TAR/SR management.
• Strong Communication, Presentation and Analytical Skills.
• Coordinated project deliverables with various businesses & IT teams working across the globe (global blended delivery model).
• Hands on Experience in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
• Solid requirement gathering, design and development of custom applications in Oracle Applications Framework (OAF) environment.
• Hands-on Oracle EBS specialist with full life-cycle implementations and upgrades, System enhancement projects, and ongoing daily support.

C ORE COMPETENCIES:

• Process improvement
• Project Management
• Business Process Analysis
• Solution Architecture
• Software Development Life Cycle
• ERP Consulting Experience
• Strategic planning

TECHNICAL SKILLS:

Tools: /Systems: Oracle EBS R12, 11i, 11.03, 10.7, SFDC, Data load, Visio, MS Project, FIMS, ServiceNow

Languages: SQL, PL/SQL, XML, UNIX Shell Scripts

Others: Middleware, Web Methods, Web Logic, SOA, Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Fremont CA

FIMS Project Manager/EBS Senior BA

Responsibilities:

• Responsible for monthly enhancement release using agile scrum methodology for Stryker Europe and Stryker US from FIMS stand point.
• Responsible for co-ordination of day to day support for both FIMS EU and FIMS US mobile and work bench applications.
• On site coordination between FIMS technical vendor team and Oracle support team for the better support of field representatives and commercial operations specialists who manage the field.
• Responsible for monthly enhancement release / QA SOX impact clearance and CCB approval for every production deployment.
• Active participant for Confidential ’s Accelerate program which will in corporate the FIMS mobile application into Salesforce platform for better integration with SAP implementation.
• Agile Scrum methodology for monthly Sprints - Scrum Master, Daily standup management as FIMS manager
• User Story as FIMS BA URS creation UAT / BAT Script creation and BAT completion for every sprint.
• CSI/Change Task handling in SN (cab review meeting / QA /SOX approvals) End to end creation to post deployment verification.
• Responsible for all vendor documentation for any enhancement (User Story / unit test / Design doc / built deployment in DEV/ QA, AIQ doc for final deployment)
• Responsible for deployment co-ordination with deployment team and SQL DBA team (weekend schedule) AIQ review verification / Post deployment verification / Business communication.

Confidential, Milpitas CA

Techno functional BSA /EBS Senior Consultant

Responsibilities:

• Worked as Techno functional BSA for O2C and P2P tracks of JDS Uniphase Corporation in Oracle E-Business Suite software.
• Currently backfill and support enhance Confidential ERP applications:
• OM, Shipping, Pricing, B2B & EDI, outbound & inbound integrations with boundary applications
• POC, Feasibility study, assessment, requirements, gap analysis, design, testing for R12 upgrade and conversion project.
• Executed Internet Procurement punch-out supplier configuration and setup in CXML for the existing suppliers those who are in native XML configuration. Along with configuration, Unit testing setup verification, UAT and go live are the main future activities for this project.
• Provided solution for New Co. Data separation project and feasibility of running standalone system on both R12 & 11i.
• Provided expertise and guidance on Oracle R12 O2C and P2P modules best practices and functional opportunities while leading the upgrade tasks for multiple modules within large-scale Oracle R12 upgrade project across the globe.
• Recommended system functionality to business managers to better utilize the application features, thereby improving effectiveness of business processes.
• Supporting the production issues during Pacific Standard Time hours in Oracle E-business suite for the entire business group related issues logged in as Service Requests (SR) and taking ownership and resolving the tickets based on their priority.
• Performed application support in single and multi-Org environment for Oracle Order to Cash (Order Management (OM), Shipping (WSH) Accounts Receivable (AR) Oracle Inventory (INV) and Cash Management (CM) and General Ledger (GL) modules).
• Co-ordination between on-site and offshore resources for business created Service now work order resolution. Handling setup and configuration related issues and enabling/trouble shooting new setups and configurations with in Oracle Procure to Pay track modules of Confidential .

Confidential, San Bruno, CA

Business Systems Analyst / IT Senior Consultant

Responsibilities:

• Worked as IT Business Systems Analyst for SC, IB, AR and Fixed Assets techno-functional side of Oracle ERP implementation for Confidential in Oracle E Business Suite R12.
• Handled all the setup related issues and enabling/ trouble shooting new setups and configurations.
• Worked as over all data migration lead from Confidential legacy systems to Oracle EBS.
• Worked on Customer data migration together with their active Invoices into Oracle from Intaact.
• Worked as IT business analyst between the implementation team and Confidential business for all requirement gathering and gap analysis for intitial design and further implementation.
• Played IT Business Analyst role in Oracle EBS and Service Contract integration together with IB.
• Played design discussion of Sales force to Oracle integration using the integration software Boomi.
• Worked as IT analyst for Vertex tax system implementation and Budget planning tool ‘Adaptive Planning.
• Working as Senior Consultant IT in Oracle Applications Lab Confidential implementations and advance collections.
• Apex Web Template integration project which will replace the current HTML Global WT and include the legacy DM Inbound Matching. Phase B of WT to include EDQ matching in bound.
• POC, Feasibility study, assessment, requirements, gap analysis, design, testing for R12 upgrade and conversion project.
• Managed multiple projects, enhancements and production issues (This includes - define and assign tasks, prioritize works for team members. Ensure project timeliness and report project status regularly to stakeholders).
• Thoroughly perform process improvements in customer business process, resolve production Incidents, deliver enhancements & seek feedback from customer.
• Collaborate with tech leads, process architects, PMO, business users, DBA’s and other teams during various stages of project including design, test, development, deployment and production support
• Created high level requirement document, design document and detail design document for customization and interface development.
• Managed the interfacing between the offshore team & business users for day-to-day functional issues & testing application functionality for different modules.
• Phase B to include integration with Apex Disposition of workflow generated by EDQ matching
• At present working in Phase C Web Quote Integration for Customer Request Application tool this is an alternate for PAL Tool.
• In Oracle Confidential side of project working on FSD, TSD and development of PL/SQL packages from development point of view.

Confidential, Fremont CA

Oracle EBS Techno Functional Consultant

Responsibilities:

• Worked as a Techno-functional resource in Order to Cash track of ActivIdentity Oracle E Business Suite.
• Handled all the setup related issues and enabling/ trouble shooting new setups and configurations.
• Fixed Assets deployment for EMEA and France region of the company. Played techno-functional role for configuration of Book Controls, Asset Categories, Fiscal Year, Depreciation Method and Asset mass addition. Technical stuff like work flow customization, table function package creation etc. Coordinating and fixing the issues from UAT. Supported the Mass addition, depreciation run and GL entries generation. Project up and running in PROD.
• Supported OM to GL track with actual OTC track like OM - Shipping - AR and GL together with OM service lines via Service contact and AR - GL flow.
• Supported the Warranty extended warranty and subscription type of lines in OTC and SC.
• Co-ordination between on-site and offshore resources for business created work order resolution.
• Interacting with the business groups in the U.S. and France for their day to day production issues and month end quarter end supports for issue resolution.
• Supporting the production issues during Pacific Standard Time hours in Oracle E-Business Suite for the entire business group related issues logged in as work orders and taking ownership and resolving the tickets based on their priority.
• Developed customized pages using OA Framework. Modifying existing Field Service Technical Portal by customizing lov, button events, hiding regions, extending Application modules (AM) adding new view objects (VO) and customizing the controllers (CO) as per the functional specification.

Confidential, Milpitas CA

Oracle IT Business Analyst

Responsibilities:

• Worked as an ITA with Onsite co-ordination techno-functional role for the COVC OM IC Engine and NGC Integration project.
• This project is about Auto validation, Configuration and booking of UCS family based configurable order lines.
• Involved in all the phase of Functional Specification Document design, creation, internal review, SME review and External review with Cross functional teams. This scope is for Q4FY12 release.
• Worked on CC gate documents like Impact Analysis, Perforomance Analysis, ERIM Impact Assessment, Architecture process engagement kind of all documents.
• Currently working between Dev team and Confidential Tech lead and Solution lead for this engagement and also directly working with business, Performance, QA and PMO teams.
• Collect and co-ordinate and look for resolution of the issues faced by the dev team from Offshore.
• Design is about auto validation and configuration and auto booking of Legacy order source based order lines in ICEngine.
• Instead of changing the IC Engine designed logic through independent concurrent program which will do this validation and call the booking API to auto book the legacy order source based order lines.
• Failure cases will be handled by GTMSS team manually based on the tele service case raised thru email alert notification program.
• Main focus is on analysis and discussion at the initial stage and provided the solution for the BRD designed by the business.
• FSD created and modified and walk through with different cross function teams on an external review. At present its in development and TSD phase.

Confidential, Emeryville, CA

Oracle EBS Consultant

Responsibilities:

• Worked as a senior techno-functional consultant in SCM / Operations and Merchandising area of Oracle R12 EBS. At present involved in the frameworks of upgrade of 12.1 version. Current system support version is 12.0.4.
• Currently liaising between Business analyst and Oracle developer of Confidential for converting the business requirements into setups / configurations and concurrent programs like UNIX script (HOST) Plsql packages XML publisher reports and sql reports for the higher management forcast analysis.
• Worked with implementing new business requirements using Purchase Orders cancellation API / Price list API / Inventory Item in bound and Item outbound APIs.
• Developed and implemented successfully as per the business requirement for Mass Purchase Order cancellation thru concurrent program using purchasing API.
• Part of Lowes implementation Condenast implementation, allposters.com integration, Drop ship implementation for specific partners.
• Developed custom packages using AR Invoice creation API, customer level attribute update, Customer additional update API for various partner specific projects.
• Configured an important customer facing document “Pack slip” which was deployed successfully in the prod environment working for 14 countries with country specific requirements. All the business requirements configured and executed thru value sets. According to the new partner only the framework and configuration needs to be modified instead of modifying the report for each country specific changes. Changes will be updated only in the flex fields and values sets and the report will print based on the framework parameters specified for the country or region.
• Technical work further extended with the areas of tuning, data bouncing, debugging, sql trace, tkprof and explains plan type tuning activities. Data export/import activities using Sql loader and plsql UTL packages.

Confidential, Santa Carla

SCM Fulfillment Lead

Responsibilities:

• Worked as a lead of Development / production support team in SCM Fulfillment track. SUN Oracle integration project.
• Main focus on providing support to the ongoing SW (Oracle) system along with integration of HW(Sun)
• Components into a Global single instance of Oracle R12 (GSIAP)
• Production support: Oracle shipping / OM / BOM / WIP modules related issues resolution for Business created SRs and daily hand over activity with off shore team for critical P1 issues.
• Active participant of client requirement gathering meetings, creating new TDDs, modification and maintenance of existing TDDs as per new changes.
• Involved in system Integration testing (SIT) in UAT environment before implement the corrections and changes done to the existing components and new components in production.
• Role includes develop and perform system integration testing for the enhancements and changes received from the business of Oracle and SUN.
• Developed Shipping Label, RTV label programs of SUN-Oracle External and Internal Manu development for around 22 suppliers of Oracle and SUN. As part of shipping documents, the ASN flow will trigger the label automatically for every Internal and External manufacturing supplier.
• B2B suppliers will be sftped, for iportal customers zpl file will be attached to the PO line. Internal manufacturer’s zpl file will be attached to the respective delivery as attachment.
• Worked as part of IBIS team on supporting deployment1 to 3 in production and deployment4 development and business validation.
• Map the Business Process Flow to the Out of Box 11i Order Management Functionality
• Prepared Technical Design Specifications (MD70) for areas of Customizations and Extensions needed to support the Client Business Rules.
• Customization/Extension of the Oracle Standard Order Header/Line Workflow (OEOH & OEOL Item Types) to align with the Customer Business Processes.
• Defined New PL/SQL Function Workflow Activities, Notification Activities using Standard Activities like Start, End, and Wait etc.
• Code PL/SQL procedures called by the PL/SQL Function Activities in the specified format.
• Involved in Liaison between Business teams and users to analyze and investigate the issues related to the ERP 11i and 10.7 related Interfaces and Information Highway related issues.

Confidential, Alameda CA

Oracle EBS Techno-Functional Consultant

Responsibilities:

• Worked in data extraction for various requirements of Business Intelligence team.
• Worked as Liaison between Business Intelligence team and users to reconcile the ERP 11i and R12 data (Order to Cash modules) for their BIEE Dashboard report creations.
• Worked on specific requirement like Bookings report data, Shipping report data, Recognized Revenue data, and Revenue Backlog data for Business Intelligence team.
• Handled the Database object creation, CR creation for any new packages or synonym to be used for BI team.
• Designed and developed solution delivery (MD50 & MD70) for OM, PO and Inventory modules.
• Involved in developing new reports and PL/SQL based extract programs for BU reporting and application extensions.
• Involved in providing the most suitable technical solution where there is a gap in out-of-the-box functional solution.
• Involved in Data Migration (Conversion) for GL, AP, AR and OM Modules.
• Involved in enhancement and development of reports using Reports 6i for Iexpenses and OM.
• Extensively worked on Order Management API’s and Pricing API’s for generating Custom Price using functions in Pricing Formulas.
• Extensively worked with PL/SQL Procedures, Functions, Triggers and Packages and Custom.pll
• Involved in Production Support, Month end and Quarter end support.

Confidential, Duncan, SC

SCM Techno Functional Consultant

Responsibilities:

• Project involved new setup, data migration, data cleanup and up gradation of 10.0.3 instance into an 11i instance also setting up a new inventory organization.
• Developed an extension for Pricing and Trading Database in Oracle Applications for USAC
• Support for USAC business users in the area of OM, Shipping and PO and INV.
• Creation of descriptive flex fields in extension.
• Testing and migration of Order Entry related customized reports in Oracle Apps. Rel. 11.0.3 to 11.x.
• Part of design team to finalize on implementation strategy to use Oracle Order Entry, Shipping and Pricing.
• Involved in functional and technical design to use Oracle OM module related various interfaces
• Involved in pricing design for various price lists and modifiers using qualifier rules.
• Developed price list upload program for price list / modifiers with Oracle API Normal Price list set up as well as Price Break set up in Listing.
• Involved in data conversion of Advanced Pricing with Oracle API for Various Types of Modifiers and qualifier setup for the Modifiers.

Confidential

EBS IT Business Analyst

Responsibilities:

• As an IT Business analyst major involvement in EDI project implementation with different Trade Partners with different EDI methodologies (XML / Traditional and Web form, HTTP, FTP) using Rosetta net and X12 standards.
• Involved in supporting OM and OC modules of Asia Pac Region of the major integration project called OASIS (Symantec and VERITAS integration) as well as day to day productions support activities especially in OM/ INV / BOM and WIP modules.
• Responsible for designing & documenting the functional specifications for various customizations and extensions as part of the business process gap analysis.
• Implementing OM functionalities such as Manual order numbering, Sales order auditing, Ship sets, Fulfillment sets, RMA, Configuration etc. and applied them to standardize the OM process.
• Avoided major customizations of the application by introducing the concept of form personalization (11.5.9) and utilizing it across modules for fitting many process gaps.
• Mapped the requirements to design the solution using standard and custom functionalities
• Designed and developed the Sales order conversion through Standard Oracle Interface.
• Responsible for supporting the production environment for OM, Shipping & WMS other Distribution modules and month end close activities including B2B interfaces.
• Accountable for managing & testing application functionality for new patches.
• Designed and implemented Global sales order acknowledgment, developed this system for saving paper works and automating the system as customers contacts get the acknowledgment as soon as there is a noticeable change on sales order.
• Auto Approval Process for order booking: Designed and implemented a system for auto booking in order management. Orders were booked based on approval hierarchy defined on custom GUI. Ordered were booked in US for saving taxes and control booking with approval hierarchy.
• Performed feasibility study and gap analysis based on BRD requirements
• Mapped the requirements to Oracle Standard functionalities, Identified and designed customizations for requirements that cannot be done thru Standard oracle functionality
• Collaborated with E2E functional and tech leads to design and test end to end solution

Confidential

Oracle Apps Techno Functional Consultant

Responsibilities:

• Involved in two implementations and post go live and production support activities. RICE components development and deployment along with data migration and conversion are the key tasks in this role.
• Technical team member for various upgrade and enhancement projects of Confidential in their Oracle Application implementations.
• Daily checklist activities include day-to-day Production Support Activities and troubleshooting of Oracle Order Entry, Shipping and Pricing Modules of OM and the related modules Inventory and PO. Every month end closing activities of OM order /RMA and items in staging sub inventories
• Before opening of every financial Inventory and GL periods, technical fix related to the above production support Activities.
• Customization of forms to facilitate user updates, before transactions can be interfaced to GL.
• Participation in designing of implementation, finalizing the segment values
• Understanding of business requirements and mapping with the standard functionality- included design for using of descriptive flex fields.
• Part of design team to finalize on implementation strategy to use Oracle Order Entry, Shipping and Pricing.
• Involved in functional and technical design to use Oracle OM module related various interfaces
• Developed price list upload program for price list / modifiers with Oracle API Normal Price list set up as well as Price Break set up in Listing.
• Uploaded almost 7 operating companies of Fuji Xerox braches all over APACJ related pricelists.
• Involved in functional and technical design to use Oracle OM interface tables to create financial transactions and customized OM, PO, and BOM related reports.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• As a part of IBM implementing team involved in:
• Oracle Pricing Setup, Modifier Setup, RMA Interface set up
• Design to Import orders using Order Import Interface based on the client requirements
• Design and developed transactions interface using standard Transaction Open interface for sub inventory transfers.
• Conversion of custom procedures and reports (6i). Creation of Database triggers to support required customization.
• Designed and developed the interface logic to receive RMA items and close or split the order line according to the quantity received
• Design and developed automation of Pick Release and ship confirmation using the SHIPPING INTERFACE APIs according to client requirements, which required automating the process of splitting of order lines according to an external shipment file, creating deliveries, assigning deliveries. Further the design accommodated splitting and shipment of serial items.
• Design to Import orders using Order Import Interface depend on the client requirements
• Design and developed transactions interface using standard Transaction Open interface for sub inventory transfers.
• Customized Service Contracts Summary Report, Detail Report, Setup Report and Generate Quote Report.
• Extended the support as part of post go live support team.