EXPERIENCE SUMMARY:

• Senior Oracle E - Business Suite 12 Supply Chain Certified Implementation Specialist in Oracle Applications with experience in Supply Chain Domain.
• Having 7+years of result oriented expertise over s in managing projects and providing business solution on Oracle EBS Projects with strong functional knowledge coupled with technical, work ethics and strategical thinking and comfortable working with resources across onsite and offshore locations.
• Have undertaken activities including Requirement gathering and analysis; Participated in Conference Room Pilots; Preparation of Functional and technical design documents; Data Conversions; Development, Testing, Customization and Extension activities in Reports and Interfaces (RICE); ensuring quality of deliverables and meeting customer expectations with on-time deliveries by leveraging the capabilities of onsite-offshore model.
• Expertise in Order to Cash and Procure to Pay business cycles
• Expertise in Business Process Analysis and “AS IS” Vs “TO BE” process modelling
• Experience in preparing AP322 Configuration Documents.
• Experience in handling Oracle R12 Application - Localizations
• Experienced in new implementation from legacy systems to Oracle EBS
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers and SQL * Loader scripts.
• Experienced in Configuring Alerts and Form Personalization.
• Experience in Application Object Library (AOL) set ups such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, look ups, list of values, Enabling and setup of DFF etc.
• As Business Transformation - Techno functional Analyst actively involved in
• Business Process Analysis and Requirement Gathering
• Functional and Technical design
• Development of interfaces/Reports
• E2E Testing
• Deployment
• Post Production Support
• Experience in Incident Management, Problem Management, Change Management and Release Management of ITIL processes.
• Strong proven background on Oracle E-Business Service Contracts and Install Base modules
• Expertise in Web-Adi
• Knowledge on Smart Client application and CPQ Tool
• Strong Knowledge of Project Management Process (PMP), SDLC - Waterfall (initiation, planning, analyzing, design, build, testing, implementation, support and closure), AGILE methodologies (Scrum, Sprint Process, Sprint Meeting and Reviews, Daily Scrum Meetings and Product Backlogs) and Oracle - AIM and OUM Methodologies.

SKILL:

E.R.P: Oracle E-Business Suite (R12)

Modules: Oracle Order management (OM), Oracle Inventory (INV), Oracle Purchasing (PO) , Oracle Shipping, Oracle Advanced Pricing, Oracel wareshouse Management (WMS), Oracle Work in Process(WIP), Receivables (AR), Payables (AP), Oracle Alerts, Oracle Sys Admin, Applications Developer, Oracle Service contracts, Depot Repair, Install Base, iProcurement, iStore and iSupplier

Operating Systems: Windows 7/XP, UNIX Sun OS, DOS

Languages: PL/SQL, OAF, Oracle Forms, Oracle Reports, Oracle Workflow, XML/BI publisher Reports

Packaged Apps: BMC Remedy, Clear Case, Kintana, Service now, JIRA,Quality Center.

DBMS & Tools: Oracle 10g, TOAD and PL/SQL Developer and Data Loader

WORK EXPERIENCE:

Confidential, Chicago

BSA Functional and Production Support Executive

Responsibilities:

• Creating new service contracts and renewing the existing contracts based on the request from customer service management team (CSM).
• Create or modify the IB records based on requirements
• Identifying business gaps during contract creation process and communicate to business SMEs for permanent fixes through IT tickets
• Load serialized contracts using data loader or Web ADI process
• Creation of contracts in smart system for the contracts created in R12 for end customer access and updates
• Coordinating with CSM team through smart cases and updating the work logs in the smart cases until closure.
• Creating Change Request for modifying the existing active service contract.
• Provide Month-end, Quarter end and Year end support.
• Preparation of Standard Operating procedures of repeated issues.
• Co-ordinate with Oracle supports, DBAs, System administrators and Business users.
• Assisted in production support issues and user issues in the service and repair modules.

Solution Environment: Oracle R12 - OM, PO, INV, Shipping, Services

Confidential, Chicago

Technical Analyst

Responsibilities:

• Analysis of the technical issues faced in the Confidential customers’ data
• Develop program scripts that help to identify the customer data with issues
• Deduce action plan to fix the data with issues and implement them in production environment
• Coordination with multiple track teams on identifying and fixing the customers data thus ultimately fixing the transactions from errors
• Provide on call support during the month/quarter close weeks to ensure successful closure without any revenue impact
• Proactive monitoring on the new customer data that are created everyday and fix any errors/issues
• Identify the old data that were migrated from legacy applications and apply the fixes as necessary
• Preparation of maintenance manuals for the identified issues and their fixes
• Daily status reporting to all stakeholders in the project to ensure smooth operations

Confidential, Chicago

BSA Functional and Developer

Responsibilities:

• Created DQM rules to provide powerful searching and matching functionality for search, duplicate identification, duplicate prevention, and other data management features.
• Created custom packages to include custom attributes in the DQM Rules per business requirement.
• Administering Data Quality Management by
• Creating Word Replacements
• Created and Updated Word Replacement Lists
• Created Custom Word Replacement Conditions
• Defining Attributes and Transformations
• Created Custom Attributes
• Created Custom Transformations
• Defining Single Match Rules
• Entering Match Rule Details
• Selecting Attributes and Defining Usage
• Assigning Scores, Transformations, and Thresholds.
• Defining Match Rule Sets.
• Involved in Production Implementation
• Post Implementation Support

Solution Environment: Oracle R12 - DQM

Confidential, Chicago

BSA Functional and Test Lead

Responsibilities:

• Involved in Requirement analysis
• Participated in CRPs
• Prepared Functional Design Documents
• Documented all required configurations related to IR, ISO, B2B process.
• Involved in development which includes PL/SQL Packages, New Concurrent Programs(for placing IR).
• Prepared Unit Test cases based on requirements (Traceability Matrix) and execution of Unit Test Cases.
• Supported System & Regression Testing.
• Worked with Oracle support to resolve seeded application issues. Created service requests (SRs) with oracle support and tracking them to closure.
• Attending Defect triage calls and Responsible for Delivering fixes reported in Quality Center raised by testing team.
• Supported Customer acceptance test (UAT)
• Prepared Release Rollout Plan Document
• Attend Change Advisory Board meetings and provide release related information to get CAB Approval
• Get the Change Request approved from all stake holders and conduct Sustenance/KT Calls with Support
• Involved in Production Implementation
• Post Implementation Support (WAR Room)
• Worked closely with Suppliers/Business Team/Support Team for any Functional/Technical Issues.
• Analyzing the existing application code and proposing technical solutions and alternatives for future enhancements.

Solution Environment: Oracle R12 - OM, PO, INV, WMS, Pricing, Shipping, AP and AR Modules.

Confidential

BSA Functional.

Responsibilities:

• Involved in Requirement analysis
• Participated in CRPs
• Developed reports as per customer requirements
• Developed conversion data validation reports
• Worked with business as part of SIT and CAT testing and fixed issues encountered during testing.
• Worked with Vendor Oracle through Service requests for standard Oracle issues.
• Supported System & Regression Testing
• Supported Customer acceptance test (UAT)
• Involved in Production Implementation
• Post Implementation Support

Solution Environment: Oracle R12 - OM, PO, INV, Pricing, Shipping

Confidential

Production Support Executive

Responsibilities:

• Work closely with IT and business Champions to ensure alignment with business and technical requirements
• Involved in Monitoring and providing solutions to the Customers by using BMC Remedy ticketing tool.
• Finding the root causes to the production issues and providing the solutions to fix the issues.
• For any production outages, need to co-ordinate with different teams to resolve the issues.
• Providing on time work around for continuity of business with less impact on Production.
• Creating automation jobs for reoccurring issues until a permanent fix is provided.
• Involved in performing feasibility analysis wherever applicable for enhancement requests.
• Analyzing the existing application code and proposing technical solutions and alternatives for future enhancements. This involves informing the client about potential bottlenecks in application performance.
• Coordinate the team for following the ITIL standards
• Generating the Reports for SLA’s, Process Compliance & Backlog Management.
• Worked with Vendor Oracle through Service requests for standard Oracle issues.

Solution Environment: Oracle R12 - OM, PO, INV, BOM, AP, AR, Pricing, Shipping.