SUMMARY:

• I have 10+ years of extensive experience in in Oracle Apps R12 Implementation, Support and Testing of Oracle EBS module
• Expertise in Oracle Project Accounting (Costing, Billing, Project Management, Resource Management) modules and integration with Finance, Supply Chain and Manufacturing modules
• Proficient in design, development & rollout of RICE (Reports, Interfaces, Configuration, Enhancements), Forms, Workflows, API’s, Conversion and Data Migration within Oracle platform
• Strong understanding of AIM’s methodology and conversant with document preparation/review of RD, BP, BR, CV, TE & MD documents.
• Designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, CRP and UAT.
• Performed period end closing activities with end users to transfer the SLA balances to GL on time.
• Conducted Audit work on accounting data such as supplier, customer & GL balances, maintain integrity of application data.
• Experience in identifying gaps in business process flows, initiate and conduct review meetings with finance and accounts teams on periodic basic to resolve the gaps in business process flows.
• Monitor and control post production operational activities such as handle calls with end users, prioritization of tickets, delegation of tickets to internal support teams & follow up for resolution of issues on a timely basis.
• Organized and handled conference calls with Oracle Global support - critical accounts team on service requests status, provide business case documents for priority and urgent issues and subsequent follow up for bug resolution.
• Experience in Project Management and working experience in Schedule Management, Resource Management, Change Management, Risk Management and Project Controlling.
• Conducted Steering Committee Meetings with Project Managers and Business Stakeholders on project status & to review project progress.
• Provided 24/7 on call support to the development team in both testing and production environment, and analysis(troubleshooting) of log files to resolve issues.
• Excellent problem-solving skills with a strong technical background and good communication and interpersonal skills. Self-motivated and a good team player.
• L1 and L2 level support for oracle projects and finance modules
• Worked as system administrator to assign responsibilities, providing access & terminating user access, creating concurrent programs, value sets, request sets

TECHNICAL SKILLS:

Ticketing Tools: BMC, Manage Engine, Cayzu

Testing Tools: HP Quality Center, TCS MasterCraft ALM

Language/ Tools: Oracle R12.2.4, Oracle R12.0.6, TOAD, SQL* Loader, PL/SQL Developer, Reports 10g, Discover 10g,XML Publisher,FTP, Putty, Workflow, Web-Adi

Databases: Oracle 10g and 11g

Operating Systems: Windws2000, Windows XP, Windows7, WINDOWS 8, LINUX, UNIX

PROFESSIONAL EXPERIENCE:

Confidential

Support Lead

Responsibilities:

• Conducted analysis of organizational needs and goals for the development and implementation of application systems by involving with business personnel
• Onsite Lead for Projects track and closely working with Business Process Leads, Technical leads and Offshore team
• Raising and Handling tickets for issues related to SunEdison users through Manage engine Tool
• Collaborate with Business to identify the requirements for change request and enhancements for the system
• Review and finalize the customer requirements and suggest the best possible solution to implement the same
• Studying and analyzing existing system and interfaces and resolving integration related issues
• Involved in daily or weekly status calls with clients on the application and performance related issues
• Scheduling daily, weekly and Monthly meeting with business process owners to discuss on production related issues & progress
• Prepared Functional Design documents for enhancement request and Test Scripts for business users Testing
• Performing/prepared Code and Data Fix when required in test and production instance
• Involved in creating and extracting data from database using SQL Queries, PL/SQL and packages on Oracle database.
• Scheduling the concurrent programs as per the requirement to run daily and weekly
• Responding to User Queries and issue tracking for incidents raised under Oracle EBS application
• Coordinating with Offshore resources in analyzing the incidents and determining impact on the system
• Keep track of new go live activities in production application
• Involved in preparing the RCA (Root Cause Analysis) or Impact analysis document for P1 Issues
• Involved in creating the test evidence document to migrate the components from one environment to another environment
• Monitoring the performance of concurrent managers and database. Coordinating with DBA’s on how to improve the performance of the system
• Supporting of downstream applications of Oracle Apps Finance which are utilized for activities such as reporting and data support
• Provided the solution for recurring issue and Debug the code to identify the cause
• Worked with Technical team to provide the interface designs and developing the reports
• Creating new responsibilities & functions as per the business requirement
• Creating the SOP documents for recurring issues
• Working with cross module functional owners when it is required
• Involved in period closing activities and resolve exception issues which was highlighted by the Business team

Environment: Oracle R12.2.4, Projects Accounting, Receivables, Payables, Purchasing, General ledger,Toad, PL/SQL Developer, Workflow, Putty, Reports 10g, XML Publisher

Confidential

Test Lead

Responsibilities:

• Involved Analyzing the Business Requirements and System Specifications to understand the application
• Creating the test cases are the business process requirement
• Mapping of test cases to Business Scenarios in TCS MasterCraft ALM and defining the testing scope
• Involved in verifying the test cases and scenarios with Implementation team
• Testing the Business Scenarios provided by client in Test instance and taking sign off from the client for pass/fail test cases
• Provided the support to business users while execution of UAT
• Involved in project preparation and resource estimation activities to complete the project
• Prepared the daily status reports using TCS MasterCraft ALM tool
• Involved in daily or weekly status calls with clients on the testing related issues
• Published the daily testing progress status reports to all business stake holders
• Coordinating with Offshore resources for analyzing the progress of work and Issues

Environment: Oracle R12.2.4, Projects Accounting, Receivables, Payables, Purchasing, Toad, PL/SQL Developer, Workflow, Putty, Reports 10g, XML Publisher, MasterCraft ALM tool

Confidential, Wilmington, NC

Test Lead

Responsibilities:

• Reviewing the Business process document provided by client
• Mapping of test cases to Business Scenarios in HP Quality Center and defining the testing scope
• Testing the Business Scenarios provided by client in Test instance and taking sign off from the client for pass/fail test cases
• Provided the support to business users while execution of UAT
• Have worked on test data planning and test management for integration testing between Oracle EBS AP module and third party applications
• Involved in project preparation and resource estimation activities to complete the project
• Prepared the daily status reports using HP QC ALM tool
• Involved in daily or weekly status calls with clients on the testing related issues
• Published the daily testing progress status reports to all business stake holders
• Coordinating with Offshore resources for analyzing the progress of work and Issues

Environment: Oracle R12.2.4, Projects Accounting, Purchasing, Toad, PL/SQL Developer, Workflow, Reports 10g, XML Publisher, HP QC ALM tool

Confidential, Chicago, IL

Support Analyst

Responsibilities:

• Raising and Handling tickets for issues related to SunEdison users through BMC engine Tool
• Scheduling daily, weekly and Monthly meeting with business process owners to discuss on production related issues & progress
• Involved in daily or weekly status calls with clients on the application and performance related issues
• Understanding Functional Design documents for new enhancement requests which was developed by the enhancement team
• Involved in creating and extracting data from database using SQL Queries, PL/SQL and packages on Oracle database.
• Scheduling the concurrent programs as per the requirement to run daily and weekly and Monitoring the same
• Responding to User Queries and issue tracking for incidents raised under Oracle EBS application
• Coordinating with Offshore resources in analyzing the incidents and determining impact on the system
• Keep track of new go live activities in production application
• Involved in preparing the RCA (Root Cause Analysis) or Impact analysis document for P1 Issues
• Involved in creating the test evidence document to migrate the components from one environment to another environment
• Provided the solution for recurring issue and Debug the code to identify the cause
• Creating new responsibilities & functions as per the business requirement
• Creating the SOP documents for recurring issues
• Working with cross module functional owners when it is required
• Involved in period closing activities and resolve exception issues which was highlighted by the Business team
• Unit tested the service components and participated in regression testing

Environment: Oracle R12.2.0, Projects Accounting, Project Management, Resource Management, Receivables, Payables, Toad, PL/SQL Developer, Workflow, Putty, Reports 10g, XML Publisher

Confidential, Chicago, IL

Test Analyst

Responsibilities:

• Analyzing the Business Requirements and System Specifications to understand the application
• Involved in daily and weekly review call with client and onsite test lead on ongoing test execution status
• Preparation of test plan and test scenarios for Projects, Order Management, Inventory, Receivables and Payables module
• Preparation test cases for Projects, Order Management, Inventory, Receivables, i-Expense and Payables module
• Uploading ad Executing the Test Scenarios using Quality Center Tool
• Actively involved in SIT, Regression & UAT test case preparation and test case execution
• As a lead I have verified all the test cases prepared and test cases executed by the team members
• Involved in preparing and execution of standalone and end to end test cases and test execution
• Involved in performance testing
• Raised the defects in QC tool
• Involved in defect analysis and defect status reporting for management
• Resolving issues raised by customers at the time of UAT testing
• Defect Prevention and Reviews to ensure the overall quality of the Project
• Functional assistance to team members to understand the process & prepare the test cases

Environment: Oracle R12.2.0, Projects Accounting, Order Management, Receivables, Inventory, Toad, PL/SQL Developer, Workflow, Putty, Reports 10g, XML Publisher, HP QC ALM tool

Confidential

Oracle Functional Consultant

Responsibilities:

• System Analysis (As-Is and To-Be), Requirement Study, Specification generation and prepared Current Business Baseline Document or Business Requirement Definition Document (RD.020), Gather Business Requirement Document (RD.050)
• Prepared Future Process Model document (BP.080)
• Documented all the identified GAPs functionalities in Document (BR.010) which are not addressed by the Oracle Application and provided work-around for the same
• Prepared BR-100 document to capture the application setup information
• Configured oracle R12 system as per the business requirement
• Involved in Sign-off documents from business for all process documents
• Involved in designing the custom forms for preparing estimates and interface with Oracle Sourcing for Tendering process with technical team
• Prepared data migration templates for all the modules and related functionalities for Conversion
• Prepared Functional Design documents (MD-50) for extension of Custom functionalities
• Prepared Unit Test Scripts documents ( TE020) and develop System Test Script (TE040) for Testing
• Conducted CRP/SIT/UAT training sessions to business users
• Involved in Data conversion and prepared data conversion mapping document (CV040)
• Prepared User Manuals by using User Productivity Kit (UPK) for business users with detailed navigation steps
• Involved in Go-Live activities to implement the Projects module
• Involved in creating and extracting data from database using SQL Queries, PL/SQL and packages on Oracle database

Environment: Oracle R12.0.6, Projects Accounting, Project Management, Receivables, Payables, Purchasing, Inventory, Toad, PL/SQL Developer, Workflow, Putty, Reports 10g, XML Publisher

Confidential, Atlanta, GA

Oracle Functional Consultant

Responsibilities:

• Prepared data migration templates for all projects modules for data Conversion
• Prepared Functional Design documents (MD-50) for extension of Custom functionalities
• Prepared Unit Test Scripts documents ( TE020) and develop System Test Script (TE040) for Testing
• Conducted CRP/SIT/UAT training session with business users
• Prepared User Manuals for business users with detailed navigation steps
• Involved in creating and extracting data from database using SQL Queries, PL/SQL and packages on Oracle database
• Provided functional & technical support when required
• Resolved the user queries which was raised by the business users

Environment: Oracle R12.0.6, Projects Accounting, Project Management, Resource Management, Receivables, Payables, Toad, PL/SQL Developer, Workflow, Reports 10g, XML Publisher

Confidential

Oracle Support Consultant

Responsibilities:

• Involved in Implementation of Project Management, Resource Management, Costing & Billing
• Involved in resolving resource schedules and resource assignments
• Created the projects templates to create the projects
• Provided the support to project managers to track the project progress and deliverables using project management module
• Provided the support to create the budgets & agreements
• Prepared Functional Design documents (MD-50) for extension of Custom functionalities
• Conducted CRP/SIT/UAT training session to business users
• Prepared User Manuals for business users with detailed navigation steps

Environment: Oracle R12.0.6, Projects Accounting, Project Management, Resource Management, Receivables, Payables, Toad, PL/SQL Developer, Workflow, Reports 10g, XML Publisher