Summary

• Over 8 years of information technology experience with 5 years as oracle applications techno-functional consultant in system study, development, maintenance, upgrades, production and support of E-Business Suite applications using Oracle Applications R12/11i and Oracle databases 10g, 11g .
• Results oriented professional successful in Design, Customization, Implementation, Enhancement, Fine Tuning and Support of Oracle Applications to meet evolving business and organizational needs.
• Proficient in Designing, Implementing, Migrating, Customizing all phases of Oracle Applications with major focus in the domain of CRM modules including Service Contracts, Installed Base, Field Service, Mobile Field Service, Depot Repair, Tele service, Customer Support, Order Management, Inventory INV , Bill of materials BOM , Accounts Receivables AR , Approvals Management Engine AME , Governance Risk Compliance GRC , Sales and Marketing, Telesales, Quoting, General Ledger GL and Human Resource HR .
• Proficient in writing the technical design documents for conversions, extensions, interfaces, reports including creation/follow-up of Oracle service requests SRs with my oracle support.
• Very good understanding of Software Development Life Cycle SDLC .
• Extensively worked in developing Functional Design and Documents like BR100s, MD50s and Technical Design Documents using Application Implementation Methodology AIM .
• Expertise in Designing, Personalizing, and customizing Forms using Oracle Forms Builder 11g/10g/9i/6i and Reports using Oracle Report Builder 11g/10g/9i/6i , XML publisher/BI Publisher.
• Expert Proficiency in Customizing the Forms through Forms Personalization.
• Strong knowledge of business flows like Order-to- Contracts and Service calls for Installs and Training.
• Proficient in RICEW Reports, Interfaces, Conversions, Extensions, workflow components including Implementation, Interfacing, Data Migration and Data Conversion.
• Experienced in customization by extension and modification of the standard application suite using Application Object Library AOL .
• Proficient in writing SQL queries. Good understanding of Packages Procedures/Functions to handle validations for various data loads and Error-Handling.
• Extensively used Oracle tools like TOAD, SQL DEVELOPER and developed database objects like tables, views and DDL scripts.
• Fairly experienced in Multi-Org, Trading community Architecture TCA and System Admin activities.
• Adept in importing data from legacy systems to Oracle Applications using Oracle Interfacing, Oracle packaged APIs etc.,
• Experience in Oracle interfacing programming, Concurrent Manager, Flex fields, and Value sets.
• Responsible for various phases of Oracle Applications Technical Design and Development, Testing and Post Implementation Support.
• Conducted CRPs and training workshops

Business System Analysis / Quality Assurance Testing

• Extensive knowledge in: building business processes, identifying risks and preparing impact analyses and UML models using Rational Unified Process RUP and UML Methodology, requirement gathering, management analysis of specification and requirement documentation as a part of Change Control Management CCR , Process Re-Design and Business Process Re-Engineering
• Experienced in Object Oriented Analysis and Design OOAD , Object Oriented Analysis OOA , Data Analysis Requirement Analysis
• Worked on Test Cases, User Acceptance Testing / Manual Testing.
• Reported bugs and proposed solutions to resolve open tickets.

TECHNO FUNCTIONAL SKILLS:

• ERP Skills: Oracle Applications R12/11i Service Contracts, Installed Base, Field Service, Mobile Field Service, Depot Repair, Tele service, Customer Support, Discoverer, Order Management, Inventory, Bill of materials, Accounts Receivables, Approvals Management Engine AME , Governance Risk Compliance GRC , Sales and Marketing, Telesales, Human Resource,Quoting, General Ledger.
• Languages: SQL, PL-SQL
• Data Loading Tools: Data Loader, TOAD, SQL Loader
• Web Technologies: Familiarity with HTML, XML, Java JSP
• GUI: Familiarity with Oracle Workflow Builder, Oracle Forms, Oracle Reports, TOAD, Discoverer, JDeveloper, UIX, XML Publisher/BI Publisher, PL/SQL Developer, SQL Plus
• RDBMS / DBMS: SQL, PL/SQL, Oracle 11g/10g, SQL Server 2000, MS Access
• Operating Systems: Android, Windows, iOS

Confidential

Responsibilities:

• Studied the existing system, reviewed it and suggested possible enhancements and implemented the changes as per the new business process upon approval.
• Designed and implemented the call avoidance feature for Teleservice and MWA users, where the call takers or the Techs could resolve Service call via phone using an online knowledge base. This feature drastically reduced the number service calls and the cost of tech's visit to the customer sites.
• Closely worked with the users, technicians, networking and development teams in designing, developing and implementing CSA's Android Mobile Field Service app.
• Enhanced Oracle service requests SRs debrief and billing process from various sources like Teleservice, Mobile FS App, eManage, ePartners, MDS Cloud and Canon web portal.
• Successfully designed and completed multiple rounds of Data conversions from Oce's SAP Canon acquired in year 2012 and CSA Legacy systems into Oracle EBS particularly in the service modules and customer support.
• Intensively worked on the Service Territories, Technician skills, group hierarchies, employee resources, Calendars, sub inventories and auto schedulers, productivity reports etc.
• Coordinated with development and DBA teams for various customizations and performance enhancements.
• Resolved production issues and system bugs
• Trained and assisted users in User Acceptance Testing.
• Assisted users in their day to day issues including Oracle workflows, alerts, resource management, usage counters, debriefs, reports etc.

Confidential

Project- Implementation R12.1.1: Service Contracts, Installed Base, Depot Repair, Customer Support, CRM Foundation, Depot Repair, BOM, Field Service, Inventory and Discoverer

Responsibilities:

• Promethean implementation at TIG to capture Service Sales Orders flowing into Service contracts tied up with other Service Requests and Repair orders with additional System enhancements and bugs resolution
• Collaborated with business users at multiple office locations to capture their business process flows and requirements
• Designed and implemented service modules with focus on Service Requests, Service contracts, Depot Repair Bulk receive functionality, Order Management, Field Service
• Identified gaps and designed customizations to address them particularly in depot repair and bulk receive form
• Created and resolved issues surrounding Contact Center and Customer Profile Setup.
• Coordinated with development teams both onshore and offshore for various customizations and reports
• Resolved production issues and system bugs
• Trained and assisted users in User Acceptance Testing.
• Worked closely with Oracle Support to troubleshoot and resolve issues with the R12.1.1 Depot Repair, Install Base and other service modules.

Confidential

Project- Implementation R12.1: Service Contracts, Installed Base, Depot Repair, Teleservices, Field Service, CRM Foundation

Responsibilities:

• Project involved the design and implementation of Multi Org Oracle CRM, Supply chain and financial modules and their interfaces with Motorola's systems.
• Gathered system requirements to complete Fit Gap analysis through super users from various Operating Units and departments
• Designed a consistent and integrated design for the Oracle R12.1 Implementation.
• Gathered requirements and provided guidance on designs done on Visio
• Configured Service contracts, Install base and Depot Repair Multi-Org structure.
• Defined business processes in Service contracts for New orders and Renewals, Contract Extensions, Terminations, Co-terms, consolidations, Update contracts from OM on RMAs, Invoices and billing, Warranty contracts etc
• Defined Approval AME and Billing Processes for Service Contracts.
• Defined business processes for RMAs, change owners, item statuses, OM to IB and IB to OKS updates.
• Created CRM resources, groups, user access, user roles, responsibility restrictions and custom menus.
• Conducted CRPs sessions for both onsite and off-shore user.
• Assisted other teams in both CRM EBS modules like Order Admin and Finance
• Followed AIM documentation BR100 for System Configuration, RD050 and RD060's for Business Requirements, BR010 for Fit-Gap Analysis.

Confidential

Project- Implementation R12.0.6: Service Contracts, Installed Base, CRM Foundation, GRC

Responsibilities:

• Implementing and providing on-going support for Service Contracts and Install base
• Implementing On-Demand Oracle project for Governance, Risk and Compliance GRC SOX Audit Application Access Control Governance AACG Version 8.5 module
• Gathered system requirements to complete Fit Gap analysis through super users from various departments
• Configured Service contracts, Install base, GRC and CRM modules for the Multi-Org client.
• Defined business processes in Service contracts for New orders, Renewals, Extensions, Terminations, Co-terms, contract consolidations, Update contracts from OM on RMAs, Invoices and billing Squs, Warranty contracts etc
• Defined business processes for RMAs through IB, change owners, item instance statuses and processes, OM to IB updates and IB to OKS updates.
• Created CRM resources, groups, user access, user roles, responsibility restrictions and custom menus.
• Created new policies, analyzed and resolved conflicts through GRC
• Conducted CRPs sessions for presenting solutions and end user training
• Mapped legacy data from several databases to the Oracle database for data migration
• Ran SQL queries using Oracle SQL developer TOAD for issue resolution and data quality analysis.
• Configured Approval Management Engine AME for approvals in Service Contracts module
• Trained end users on the new system and created training manuals for future troubleshooting
• Assisted other Oracle teams in both CRM EBS modules like Order Management, A/R Finance, TCA, Customer Support/CRMOD, Universal Productivity Kit and Human Resources
• Gathered requirements and provided guidance on designs and outputs of custom reports through Discoverer
• Followed AIM documentation BR100 for System Configuration, RD050 and RD060's for Business Requirements, BR010 for Fit-Gap Analysis, TE020 for Test Scripts, MD050 for functional Specifications CV040 for functional design

Confidential

Project Implementation 11.5.10: Service Contracts, Install Base, CRM Foundation and Field Service

Responsibilities:

• Project involved Implementation of Oracle Service Contract, Installed Base and Field Service including designing customized data entry screens.
• Interacted with Super Users, various other departments to gather the system requirements and do the Fit Gap analysis.
• Responsible for implementing Service Contracts, Installed Base, Inventory and Field Service.
• Mapped Contract's legacy data from various databases to the OKS.
• Responsible for data mapping from Global Install Base to the Sub Lines into Contracts and their coverage's.
• Intensively worked on the Contract Terms, Templates in Terms library and defined a process to crate legal terms within the Service contracts module.
• Configured the approval process using AME for both contracts as well as Legal terms.
• Set up DFFs for Header, Lines, Sub-lines and Party fields.
• Prepared BR100 for Setups, BR010 for Fit-Gap Analysis and TE020 for Test Scripts and CV040 for functional design.
• Created design documents to facilitate conversion of customer information from legacy custom tables to SC
• Created design documents to facilitate validation testing by technical team on staging table's data.
• Did data validations and functionality tests after data migrations.
• Conducted CRPs and assisted users in UATs.

Confidential

Business Analyst / Quality Assurance Tester

Environments: RUP, Agile Methodology, MS Paint, MS PowerPoint, SQL

Responsibilities:

• Working on continuous upgrades and enhancement features depending upon the user inputs.
• Designed the enhancements and upgrades logically Re-Design , using Object Oriented Analysis and Design, and UML concepts into the existing system.
• Created documents such as Use Cases, Business and Functional Requirement Documents.
• Participated in team reviews and requirement gathering sessions
• Participated in detailed technical design sessions, ensured completion of all appropriate artifacts, including business partner signoff/authorizations
• Created new UI screens for the newly added features
• Created the Data Dictionary through Traceability directly from the existing system.
• Tested newly developed software/application/features both prior and post release.

Confidential

Business Analyst

Environments: UML, RUP, HTML, Waterfall, Front Page

Responsibilities:

• Completed the GAP Analysis from the existing Asset Management system to the To-Be state.
• Prepared High Level Logical Data Models and Business Requirement Document supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements
• Analyzed the requirements of the end Users and designed a direct and user friendly approach to create activity based new projects under Asset Management.
• Re-Designed the existing Website to a more secure and user friendly design.
• Designed an Asset Management Homepage accessible by various user groups.
• Prepared User Interfaces UI for Project Creation, Bridge, Dashboard and Fleet Management systems.
• Identify data elements from the source systems, performed data analysis to come up with data cleansing and integration rules for the Data ware housing.
• Initiated and delivered a complete re-write of the existing AMS through Screens.
• Created a Traceability Matrix to map the fields from the legacy AMS to the Phase II release of Asset Management.
• Assisted in the development of project milestones by providing Work Breakdown Schedule WBS .
• Created Functional specifications Document of the Phase II AMS.
• Conducted team review meetings and meetings with Line of Business user group to gather requirements.

Confidential

Business Analyst / Quality Assurance Tester

Environments: UML, Rational Unified Process, SCRUM, Microsoft Visio, Enterprise Architect, MS Paint

Responsibilities:

• Involved in migration of the existing data from various data bases to SQL server platform. Performed various DB activities like refining, cleansing and avoids duplication of data amongst various Products of CCH.
• Enhanced the overall Single Sign On process for various applications of Pfx. products.
• Analyzed, gathered and documented the Non Functional requirements of all projects including the changing of existing Non Functional requirements of all CCH products.
• Participated in some side projects which required regular enhancements and re-design of the existing software.
• Helped develop the Project Scope and Project Plan by providing Work Breakdown Schedule WBS .
• Performed Comprehensive Analysis of the Existing system and the Proposed Process, through Work Flows and Data Flows using Visio to identify Gaps in the existing system.
• Used RUP Software Methodology for gathering requirements by facilitating JAD sessions.
• Communicated effectively with cross functional teams such as Stakeholders, and various project teams like business and Technical, UI, Development, Testing, Architecture and Documentation.
• Involved in an extensive data mapping exercise to Migrate Legacy data to the new system.
• Developed screen mock-ups to aid web development. Participated in UI reviews and made sure that everything is within the scope of the requirements.
• Coordinated weekly milestone meetings with team members. Created Use Case Diagrams, Data Flow diagrams and Work Flow Diagrams, Activity Diagrams and Sequence Diagrams to define the business Process Model and Data Process Model.
• Created Business Requirement Document, Use Cases, UI Document and Functional Requirement Document for documenting the requirements and Functionalities.
• Played a key role in the User Acceptance Testing.