Oracle Business Analyst Resume
SUMMARY:
Senior Oracle E-Business Consultant having over 10 yrs of experience deploying Oracle Applications with Fortune 500 companies with strong consulting background in the areas of process improvement and technology implementation.
Expertise in
Oracle E-Business Suite CRM and SCM modules - Order Management , Service Contracts , Inventory , Install Base , Field Service, Depot Repair, CRM Foundation , Sales & Marketing.
Excellent interpersonal, written/verbal communication, and leadership skills with the ability to quickly build credibility, influence and make recommendations at all levels. Lead and manage a team towards common goal.
Domain knowledge of Hi-Tech, Manufacturing, Energy,Healthcare and Telecom industry verticals. Valuable cross-functional resource with expertise in interactions and business flows between the ERP and CRM business processes.
Experience includes 5 full life cycle implementations and 4 yrs. of onsite experience in United States.
- Masters in Management Studies (Systems).
- Bachelors in Electrical Engineering.
- Engagement Experience: Project management, Requirement gathering, Process redesign, Fit/Gap analysis, Configuration and Setup, Business Process documentation, End user training, SIT and UAT Testing
- Oracle eBusiness Suite: Order Management, Inventory Field Service, Depot Repair, BOM, CRM Foundation, Sales Online, TeleService, Marketing Online, Install Base, AR - Invoicing, TCA
- Oracle Certification: Completed Oracle University Trainings for following R12i modules -
R12i Oracle AR Fundamentals ,R12i Oracle Bill of Materials ,R12i Oracle Inventory Fundamentals, R12i Oracle Advanced Supply Chain Planning ,R12i Oracle Order Management,R12i Oracle Field Service - Software Tools: MS Office, Visio, SQL Developer, Sharepoint,Toad, Data Loader and Kintana,
Client - Confidential, SF, USA
Employer - IBM Jan 12 - Till date
Role: CRM Track Lead
Project - BIMS - Enhancements
- Manage the Order to Cash track which includes Oracle modules such as Order Management , Inventory , Shipping, Service Contracts , Install Base , AR - Billing , Invoicing and other applications such as SFDC , Service Source and Key server
- Implement the IT Enhancements and support business users and make sure the solution is designed and deployed within agreed timelines and with complete user satisfaction.
- Prepare BRD / MD050 documents by interacting with business users and client IT team for enhancements and new product introductions.
- Following are some of the major enhancements handled -
- Order Management ITM integration with Kewill for Export Compliance
- AR - RMA Optimization and Credit Memo Generation process
- Order Management - define process flows for new product launches.
- Order Management - Removal of Fulfillment Sets
- Service Renewals Management - Service Contracts Integration with SFDC , Service Source
- Service Contracts QA Check / Approval Process.
- Service Contacts Subscription Based Billing
- Oracle Install Base and Contracts integration with Support Portal
- Data Conversion for Customers, SC, and IB for newly acquired business
- Co-ordinate with offshore Functional Team by providing BRD documents and getting MD050 developed. Provide details / clarity on issues. (Coordinating with business users at onsite.)
- Co-ordinate with offshore Technical team for getting code fix, reports, and interfaces developed. Providing them with test cases, functional spec for development purposes.
- Conduct bi-weekly meeting with offshore team to track progress on O2C Track Enhancements and issues
- Conduct weekly meeting with Client IT team to share progress of IT Enhancements and process improvements.
Client -Confidential, USA
Employer - IBM Apr 11 - Jan 12
Role: Senior Consultant - C2C (Customer to Cash)
Project - R12i implementation Global Business Transformation (GBT)
KCI has launched Global business transformation, the purpose of this implementation is to carry out their business globally, which will help bring about synergy in the technology and help synchronize various business processes. The project team will be involved in the design, configuration, testing and support of the ERP systems for Kinetic Concepts, Inc. for its Global Business Transformation program. This involves configuring, installing and implementing the Oracle Business Suite Release 12 for the client in locations spanning Europe and the U.S.
- Interacted with the client SME in order to validate requirements for Global/Local Design which involved understanding existing business processes/flows and existing legacy systems.
- Provided Oracle Solution mapping for the Call Centre Order Management, Order Entry Custom UI, Field Service and Service Rental requirements.
- Performed the setups in the Oracle e-Biz suite, Order management - Transaction Types, Defaulting Rules, Document Sequencing, Automatic holds, Processing Constraints, Price Lists and Modifiers.
- Solution design of new modules - Install base, inventory setup, Field Service and Depot Repair in the KCI initiatives for the Global Business Transformation Program
- Developed the BR100 and MD50 documents for OM , Depot Repair, Field Service in Global Business Transformation as per Oracle AIM methodology
- Prepared test cases and scenarios to assist Technical Team for development of custom components such as interfaces, workflows, reports to achieve the business requirements.
- Facilitated of Global CRP/SIT1/SIT2/UAT with business users and documented the defects and defect resolution in agreement with the client.
- Worked with Oracle Support / Metalink to resolve bugs by logging SR.
- Prepared test Scripts, executed them and updated the Test results / defects in HPQC Quality tool
Client - Confidential, Mumbai, India
Employer - IBM Jun 09 - Mar 11
Role: Project Lead
Project - CRM Sales Force Automation (SFA-COMET).
- Understood the functional business processes and collaborated with business unit personnel to document business requirements and technical design specifications for following Oracle Modules - - Sales Online, Teleservice and Order Management
- Demonstrated functionality of Lead to Order fulfillment cycle in Oracle EBS R11i ,
- Perform POC for Oracle Sales Online, Telesales module like - Lead Mgmt, Opportunity Mgmt, Account and Contact Mgmt., Sales Forecasting, Content Development and Order Fulfillment.
- Prepared Conversion strategy for following components - Customers, contacts, Opportunities, Service Requests, Tasks / Activities.
- Configured above modules in Dev , Test and Production instances
- Conducted Train the Trainer and UAT for business users for above Modules.
- Phased Roll-out to production instance for different business verticals - Enterprise, SME and Carrier Data.
- Assign tasks to team - Functional Setups, Documentation, Technical developments, data migration, Instance setups, JSP Reports, JSP Customizations.
- Prepared Estimate, project plan, sharing timelines for various phases of the Project.
- Reviewed weekly progress of project with Business and Client IT team.
- Team size - 2 functional 5 technical
Employer: Confidential, San Diego, USA July 08 - Apr 09
Role: Oracle Business Analyst.
- Providing functional support, administration and configuration of the eBS 11.5.10 based CRM system including Sales Online, Telesales, Marketing, Advanced Pricing, CDM and Partner Management modules. Participate in existing projects to expand our deployment of the partner modules adding CRM, telesales and integrated marketing in an indirect, B2B tiered sales model. Support the integration of the Oracle applications with other global systems to provide a consolidated business intelligence platform, employee and partner facing web services
- Supporting reporting, analysis and business intelligence needs including developing SQL queries and using both Oracle and other (eg Cognos) reporting tools.
- Working with functional users to analyze business processes and align with existing software capabilities and data structures, deploy new features, adjust configurations or specify customizations or enhancements as needed. Create requirements and training documentation for following Modules - Marketing Online, Telesales, Advanced Pricing and iStore (Partner Facing)
- Demonstrated functionality of Oracle Sales and Marketing modules like - Collateral Fulfillment, Events Setup and Registration, Campaign Setup and Flow, Email Blasts and Lead Generation, Advanced Pricing Setups, Sales Forecasting, iStore Partner facing setups.
- Designed solution for lead to email campaigns , Conducted end user testing with business users for above Modules preparing test cases
- Performed setups for above modules in test and Production environment and Roll-out to production instance
- Worked with Oracle Support / Metalink to resolve bugs and defect management.
- Provided production support, Evaluate and escalate support issues as required internally for modules Sales Online, Marketing Online, Telesales, Universal Work Queue, Partner Management, Advanced Pricing and iStore (1000+ external users and 50 internal users)
- Evaluated R12 version of oracle, feature comparison, effort estimation for upgrade, redesign - conversion effort
Client: Confidential, Jan 08 - Jul 08
Employer: Confidential
Role: Sr Oracle Service Consultant
Project: DBU Next GEN Program 11.5.10, R12
- Requirement Mapping for Oracle Modules - Field Service, Service Contracts, Depot Repair, Quoting and Order Management
- Worked closely with Service business users in US and UK to gather requirements and provide solution in Oracle
- Coordinated with cross functional teams like Inventory, Quoting, Financials, Purchasing finalize a rental process and Upfit process.
- Map and Gap analysis of R11 v/s R12 version for above Service modules
- Demonstrate R12 new features to client for Service Modules like Depot Repair - Bulk receiving, High volume depot Repair etc
- Offshore Co-ordination - Documentation, technical design , development and reporting
- Authored various Setup, Training and Functional Specification documents i.e. BR100, MD50 etc.
- Conducted demos and Conference Room pilots, Proof of concepts for various modules like - Field Service, Depot repair, advanced scheduler
- Documenting and managing CRP issues and resolution
- Configuration of Above modules in Dev, and CRP instances
- Involved in setups pertaining to Oracle Service Modules - Field Service, Order Management and Depot Repair in 11.5.10 i.e. SR types, Task Types, Task Status Transition, Debrief, Calendar Setups, Coverage templates, Item definition - Service items, counter items, usage items, Service and billing Activities, Transaction SubTypes, Business Process , Repair Types, Assignment Manager, Part Requirements
- Prepared test cases and conducted CRP with business users for above Modules
- Provided bug fixes and support during the testing cycle of the project.
- Worked with Oracle Support to resolve issues during CRP and development
Client: Confidential, USA Jul 07 - Jan 08
Employer: Confidential
Role: Oracle Services Lead
Project: Eaton Electrical CRM Implementation 11.5.10
- Conducted workshops for requirement gathering, requirement mapping for Oracle Field Service, Depot Repair, Spares Management, Inventory and Order Management.
- Prepared functional specification MD050 and co-ordinated with Offshore team for technical development, interface design and development, Report generation
- Designed solution for end to end flows such Repair and Return, Replacement , Exchange, Adv. Exchange and also client specific requirement - Failure Analysis, ERC and Manual Repairs in Depot Repair Module
- Prepared conversion strategy for SR and Task Conversions and Repair Orders.
- Performed Oracle setups relating to Field Service, Depot Repair, Inventory and Order Management modules in Dev, UAT and Production environments
- Worked with technical team members in running API scripts to load data in Resource Manager. Territory Manager, Task creation , Task Open SR conversion for Field Service and Depot repair
- Prepared test cases and conducted UAT and SIT with business users for above Modules
- Authored various documents like AS-IS and TO-BE business processes, Functional Design documents, UAT test scripts, training documents etc
- Performed Oracle Resource Manager Roles and Groups setups, Item addition to Price List, Modifiers using Data loader in Oracle applications.
- Provided functional support to business team during UAT and post production
Client: Confidential, USA Apr 07 - Jul 07
Employer: Confidential
Role: Project Lead
Project: Eaton Truck CRM Implementation 11.5.10.2
- Requirement Mapping for Customer Model-TCA, iSupport -Self Serve, Sales Online -Contact Management & Account Management.
- Present comparative analysis on Old AR TCA model v/s Best Practices TCA model
- Map and Gap Analysis for Sales Online, iSupport modules
- Design end to end solution for iSupport portal
- Prepare AS-IS and TO-BE process documents
- Impact Analysis on existing system - Extensions, interfaces, Personalization due to change in TCA model.
Client: Confidential, USA Apr 06 - Apr 07
Employer: Confidential
Role: Project Lead
Project - ITO LEAN ERP Simplification 11.5.10
- Participated in the LEAN process of identifying waste steps in the existing business process of Order to Cash.
- Presented solution for minimized steps - Single Screen Order Management , Pricing Analysis Tool , Single Login ( Custom workflow process for Quote approvals)
- Demonstrated through Proof of Concept, functionality of already implemented Oracle Modules (Procurement - Quoting, Sourcing and Order Management), which can be leveraged in existing process. (Eg Price breaks, Multi- Currency etc.)
- Prepared CF 250 Functional design for all components, relating to Oracle Order Management, Quoting and Sourcing.
- Collaborated and co-ordinated with GE ERP CoE for review and approval of documentation BR150, CF250, MD200
- Co-Ordinated with Offshore team for technical development - Oracle Forms and Oracle Workflow Builders
- Scheduled weekly project review status meetings with offshore team and Client Manager.
- Facilitated and carried out SIT, UAT with business users, documented the test results and shared across GE IT and business leaders
- Co-ordinated across cross function team for Production Deployment and Cut-over Activities.
Client: Confidential, USA Oct 05 - Apr 06
Employer: Confidential
Role: Functional Consultant - CRM
Project - ERP Design and Delivery (EDD) 11.5.10.2
- Member of the ERP Design and Delivery (EDD) team, responsible for consolidating 80% of the business into two core Oracle Application instances.
- Coordinated with individual businesses and other ERP Design/Support groups to ensure a standardized operational design while catering to the needs of each business unit, which will be implemented in these two core instances.
- Authored Functional Design/Setup documents for Installed Base, Service Contracts and Field Service modules.
- Demonstrated through Proof of Concept, functionality of Oracle CRM modules (Install Base, Field Service, Service Contracts) which can be leveraged across P&Ls
- Established CRM common process designs which can be leveraged across businesses i.e. Common Install Base Design using a Single Product view for multiple businesses.
- Co-ordinated with various Shared Services Teams (CMF, GIB, SMF) for Functional Design of Integration with Services ERP. Prepare CF 250 for the Functional design of Integrations
- Analyzed the impact and functionality of various custom applications interfacing with the ERP system
- Reviewed and approved CRM Functional design for business specific RICE components
- Researched and demonstrated through Proof of Concept, new features of Oracle CRM modules which can be leveraged by and across businesses
- Defined and Implemented Instance level application setups.
- Extensively coordinated with the offshore support team for monitoring the issues.
- Formulated common integrations design across businesses for interaction with external systems.
- Setting up Oracle Service Contracts and Installed Base: Instance statuses, Transaction types, Contract categories, QA checks, Groups, Coverage templates, Billing profile and DFFs.
- Worked with Inventory module to setup the service items.
- Setting up Oracle Field Service and Depot Repair : Service Request types, Field Service Representatives roles and groups, Dispatch Center, Service Activities in multi-org environment, Debrief items (Material, Labor and Expense) etc.
Client: Confidential, India Oct 03 - Oct 05
Employer:Confidential
Role: Oracle CRM Business Analyst
Project - Oracle CRM Implementation (Sales and Marketing) 11.5.9
- Interviewed senior business process owners in Sales and Marketing to collect requirements, designed processes in Oracle to support these requirements
- Presented Conference Room Pilot to sales and marketing business users
- Conducted Map and Gap Analysis
- Documented - AS-IS, To-Be process, Map and Gap, BR100, BP 080 and MD050
- Conducted unit as well as integration testing.
- Prepared System Test Plans.
- Configured the above modules in Test, CRP and Production environments
- Conducted User Acceptance Test to client for Oracle Marketing Online and Sales Online
- Prepared Training Document for users and Conducted training for end users on Oracle Marketing Online and Sales Online
- Coordinated with the technical team for development of reports and jsp customizations
- Conducted Knowledge transfer to production support team.
- Member of the Telecom Process consulting team responsible for documenting and reviewing process related to Functional areas like Sales, Marketing and Customer Service
- Process Detailing - Discuss findings with Process owners / Function Heads and process writers and follow up for revision and improvement.
- Working with Client process manager in formulating plans for process approvals and rollout of the process across various divisions
- Co-ordinate with Training team and conduct Quality Audit before preparing Training Material.
- Defect Management - Tracking and resolving
Employer: Confidential Jul 03 - Oct 03
Role: Pre-Sales Consultant - Oracle ERP
- Worked on pipeline management, presales activities , Develop industry specific solutions
- Conducted Demos for clients during RFP , evaluations stages
- Client engagement for RFP, Proposal presentation
- Prepared Work plan and Effort estimation for Oracle Apps CRM proposals
- Prepared CRM Assets - Field Service Offerings
- Prepared presentations for CRM consulting domain areas like Sales, Marketing and Service
- Formulated framework, methodology and offerings
Employer: Patni Computers Oct 03 - Apr 03
Role: Pre-Sales IT Services
- Worked on pipeline management, presales activities
- Client engagement for RFP, Proposal presentation
- Public Sectors - Tenders
- Conducted Demos for clients during RFP , evaluations stages
- Prepared Sales Assets , IT Service Offerings for Facilities Management
Employer: Confidential Dec 99 - Aug 00
Project: Confidential
Role: IT Support Engineer
- Worked as IT support for Passenger Reservation Systems - PRS
- Development , Testing and Support of Advanced Railway Ticketing System
- Deployment of ARTS across various locations in India , Central and Western Railways.
Oracle Certification of Completion for following R12i modules -
- R12i Oracle AR Fundamentals
- R12i Oracle Bill of Materials
- R12i Oracle Inventory Fundamentals
- R12i Oracle Advanced Supply Chain Planning
- R12i Oracle Order Management
- R12i Oracle Field Service
Oct 2003
- Introduction to CRM
- Siebel 7.5 Training
April 2004
- Oracle E-Business suite overview
- Oracle CRM Overview
- Teleservice application
- CRM Foundation
June 2004
- Depot Repair
- Service Contracts
Dec 2004
Oracle CRM New Feature Training for 11.5.10
Apr 2008
Oracle CRM New Feature Training for R12
Apr 2010
R12i Oracle AR Fundamentals
May 2010
R12i Oracle Bill of Materials
June 2010
R12i Oracle Inventory Fundamentals
Sept 2010
R12i Oracle Advanced Supply Chain Planning
Dec 2010
R12i Oracle Order Management
May 2011
R12i Oracle Field Service
Oct 2011
Leadership Training
ERSONAL DETAILS:
Date of Birth : 2nd Feb 1978.
Gender : Male
Marital Status : Married
Work Permit : H1B