SUMMARY:

• 11+ years of IT experience in implementation and support as a technical consultant in Oracle Applications ERP/E - Business Suite (EBS) for 11i/R12 in full lifecycle implementation End to End solution developments, rollout and support.
• Experience in developing XML Publisher, packages, procedures. Experience in developing and modifying reports using Oracle Reports 6i and XML/BI Publisher.
• Proficient in SQL, PL/SQL, D2k Reports, XML/BI Publisher reports development and customizations, Interfaces, Conversions, Forms, Forms personalization, SQL Loader, Alerts and Web ADI.
• Experience in Application Implementation/Enhancement, Unit testing, Integration Testing, Production Support and Maintenance of RICE Components.
• Experience on PO, INV,OM, AP, AR, GL, OPM, ASCP and CRM related Modules.
• Developed reports using XML publisher, Reports 6i.
• Proficient in writing procedures, packages, functions, API & triggers using PL/SQL.
• Excellent perspective on converting Functional specifications into technical design and development.
• Well versed with client server environment and tools like SQL*Loader and TOAD.
• Familiar with AIM Methodology in Implementing Oracle Applications.
• Expertise in testing the application and good functional knowledge in Procure to Pay (P2P) and Order to Cash (O2C) Cycles.
• Capable to work on multiple tasks and to work independently with minimum supervision with people from all levels of corporate management.
• Experience on Master Data techniques to maintaining Master Data Management, Enrichment, Data Cleansing, Data Conversion, Data Migration for multiple Oracle projects.
• Expertise in Business Process Designing, Blueprinting, Configuration, Unit & Integration testing, Training, Documentation & Production support.
• Excellent skills in preparing the test plans as per the business processes, testing along with

  core team, results were recorded, documented & analyzed.

• Developed RICEFW objects revolving around master data.
• Experience in Go-Live and Hypercare support for functional and technical expertise area of specific master data objects and identify the issues and provided the resolution.
• Responsibilities for test scenarios and test scripts, executing system testing, Unit testing, Functional testing and Integration testing etc. for Data Team, Conversion Team, Deployment Team and Support teams.
• Responsible for allocating resources for Cutover and Migration activities and release planning and included building and managing all the tasks in relation to the cutover activities.
• Experience in Troubleshooting Production problems and Configuration issues through Prioritization.
• Converted business requirements as Functional and Technical specifications.
• Experience on various Oracle ERP projects engagement as ERP techno functional resource.
• Experience on complex ERP integration delivery and supported deployment, data conversion and cutover activities.
• Strong Customer Support experience that includes Post Implementation Production Support and training the end-users coupled with good oral and written communication skills.

TECHNICAL SKILLS:

ERP: Oracle applications 11.0.3,11i/ 11.5.9/11.5.10 , 12.1.3, 12.2.5 and 12.2.7

Oracle ERP Application Modules: System Admin, Receivables, Payables, Ledger, Inventory, Order Management, Purchasing, Projects, Alerts and HRMS, OTL and Self Services

RDBMS: 9i, 10g, 11g and 12 C

Software: Toad, SQL Developer, Kintana, PVCS, Clearcase, Citrix, Putty, ServiceNow, Support and TortoiseSVN, HP ALM, WINSCP

Tools: Developer 6i/10g, Forms and Reports, Oracle Discoverer, Web ADI, Data Loader, Oracle Workflow Builder, XML Publisher reports.

Operating Systems: Windows NT, Windows 2000, Unix

Languages: SQL, PL/SQL, C, Data Structures

PROFESSIONAL EXPERIENCE

Oracle Applications EBS Consultant

Confidential, OH

• Responsible for maintaining end to end deployment and cutover work, managed maintenance efforts and applications.
• Experience on interactions with business users, release management and IT stakeholders on change deployment.
• Developed XML Reports, Interfaces and Conversions.
• Worked on procure to pay custom processes and involved in designing the technical documents and the process flow.
• Maintained high quality deliverables for business enhancements, fixing production defects and post production support.
• Experience on managing and performing test all migration processes.
• Responsible for process communication with respective teams on process, data setup (upstream and downstream impacts) implications and decisions.
• Responsible for managing data loads for different data objects related data from various Non-oracle systems to Oracle systems.
• Handled multiple tasks and activities in a prescribed schedule, within the changing schedule, and prioritize accordingly for relevant tasks.
• Experience as a tester for oracle system new developments, changes and enhancements.
• Experience on troubleshoot and resolve assigned Service Desk incidents in a timely fashion related to data issues and update tickets accordingly.
• Experience on Data migration techniques - GPIS, CIA methods and migrated legacy data using FTP design and execution for different data objects.
• Experience in SQL query reports and excel sheets etc.
• Responsible for communicating with different Functional, Technical, Data, Sales, Operations and Finance teams to continually improve processes of client business requirements.
• Responsible for performing QA activities like data quality, completeness, duplicity, prior and post migration activities for data loads.

Oracle Applications EBS Consultant

Confidential, OR

• Involved in requirement gathering and design the solutions, business blueprinting, prepared documents for functional requirements, customizing and configuring based on business requirements.
• Coordinated with different data and technical teams for data conversion load, testing, environment setup, cutover activities and go-live support.
• Plan and manage execution of go-live simulations.
• As a technical lead, involved in design and development and support the application.
• Ensure adherence of deployment activities to all quality management plans and standards.
• Manage cross release, cross unit ownership of deployment issues and interdependencies.
• Ensure organizational readiness and sponsor commitment for deployment.
• Responsible for developing and manage all aspects of the deployment effort, including the plans, interdependencies, schedule, budget, tools, and required personnel
• Responsible for defining, implement, and maintain project process guidance related to deployment
• Experience on provide technical leadership to project resources and the client to meet deployment deadlines and objectives
• Responsible for overall Application Maintenance delivery, Incident Management and first point of contact on any escalations on Application Maintenance backfill Lead Role.
• Responsible for consult with and develop technical resources for methods, procedures, and standards to use during the deployment milestones.
• Experience on deployment / cutover execution for Client CenturyLink designed, develop and executed couple of Mock and Dress Rehearsal deployment cutover execution.
• Strong Customer Support experience that includes Post Implementation Production Support and training the end-users coupled with good oral and written communication skills.
• Prepared a detailed document of AS-IS study and developed the detailed TO-BE processes to suit the company's objectives.
• Responsible for gathering business requirement process and data conversion process and interaction with Business SME's to finalize the business requirement.
• Responsible for Functional and Integration testing signoff from other teams.
• Experience on supporting project and different tickets and tools.
• Represented the team in several meetings with client’s business and management team especially in weekly activity status calls, defects call, cutover activity etc.

Oracle Applications EBS Consultant

Confidential, UT

• Provide solutions around Oracle Application Order Management, Inventory, Purchasing, Receivables, HR and Payroll applications.
• Responsible for importing different type of source files Excel, Delimited Text and XML into Oracle though Automation of Import process.
• Lead the Support and enhancement bug fixes efforts on Oracle SCM streams applications.
• As a technical lead, involved in design and development and support the application.
• Responsible for designing solutions around Oracle Projects, Inventory Management and Oracle Order to Cash Streams and integration solutions between systems.
• Support data migration and deployment of Oracle Finance, Oracle Manufacturing applications and Oracle HR & Payroll
• Analyze impacts of business decisions, code changes, deployment on infrastructure and resources.
• Worked with internal and external Vendor on product bug fixes and performance issues.
• Responsible for communicating the solution architecture with customers and further technical issues.
• Identify and communicate technical problems, processes and solutions
• Participate in preparing the test cases and in system & integration testing.
• Promoting team spirit and mentoring team members by having connect with team members.
• Present the metrics and weekly status reports on Incidents to Client Leadership.
• Responsible for managing data loads for different data objects related data from various Non-ORACLE systems to ORACLE systems.
• Handled multiple tasks and activities in a prescribed schedule, within the changing schedule, and prioritize accordingly for relevant tasks.
• Experience as a tester for Oracle system new developments, changes and enhancements.
• Good experience on troubleshoot and resolve assigned Service Desk incidents in a timely fashion related to data issues and update tickets accordingly.
• Worked with Functional, Technical, and Data, Sales, Operations and Finance teams to continually improve processes of client business requirements.
• Responsible for performing QA activities like data quality, completeness, duplicity, prior and post migration activities for data loads.

Oracle Applications EBS Consultant

Confidential, OH

• Help to understand the current context of the client, mapping Client requirements and creating artifacts required for proposal response.
• Requirement gathering and design the solutions as per client landscape.
• Developed functional RICEW objects revolving around master data. Designed the system architecture document of different Oracle systems.
• Coordinated with different data and technical teams for data conversion load, testing, environment setup, cutover activities and go-live support.
• Worked with plants to gather and review manufacturer and manufacturer part number data etc.
• Responsible for Functional and Integration testing signoff from other teams.
• Represented the team in several meetings with client’s business and management team especially in weekly activity status calls, defects call, cutover activity etc.
• Expertise on Data Extraction/Data Conversion/Data Transformation/Data Loading skills.
• Expertise on implement project implementation life cycles through SDLC, ASAP methodologies and business process integration.
• Translates nonfunctional and functional requirements into design, within enterprise context
• Work closely with the Client Architecture, Technical & Application Architects, Performance Engineer, and Business Architect to evaluate key technology decisions.
• Defines application subsystems and major components associated.
• Provide solution performance improvements based on performance engineering.
• Provide functional and technical expertise, guidance, presentations and Instructions on Master Data solutions to the client.
• Importing data from various legacy/non-Oracle and Oracle systems data into the Oracle eBS system.
• Responsible for Functional and Integration testing signoff from other teams.
• Conducted GAP analysis between current and future processes and system functionality.
• Responsibility to sort, manipulate and analyze large quantities of data with identifying errors and gaps.
• Involved in end-user training and knowledge transfer documentation preparing training manuals.
• Participated in preparation of test cases for unit & integration testing and User acceptance testing.

Oracle Applications EBS Consultant

Confidential

• Involved in analysis, design and development, testing phases of application.
• Interaction with client team to understand business requirements and develop the System design and involved in technical discussions, design reviews with Architects.
• Involved actively in frequent calls with business to gather requirements from the client and analyze the technical feasibility
• Participated in preparation of test cases for unit & integration testing and User acceptance testing.
• Coordinates documentation, testing, and training efforts related to project
• Produce and Review high-level, detailed application / technical design for enhancements and additions
• Minimize aging and counts of ticket backlogs assigned to self and team members.
• Responsible for developing the solutions based on the customer requirements, created the technical and unit test plans.
• Prepared the Technical Design and UTP documents.
• Developed Code, Bug Fixing and Testing.
• Investigate problems and develop detailed suggestions for resolution of issues
• Provide resolution for Oracle specific daily/weekly (Inbound / Outbound) custom or seeded interface queries/audits
• Documentation on issue resolution when required for process change.
• Creates test scenarios and assists project team members in performing tests to insure all processes work according to predetermined goals.
• Based on the customer requirements, created the technical and unit test plans.
• Proactive maintenance of applications, interface data and vendor interactions to minimize issues and rework.
• Responsibilities for requirement gathering phase to production support phase of the project.
• Coordinated with different data and technical teams for data conversion load, testing, environment setup, cutover activities and go-live support.
• Experience on preparing the Functional Specifications for the data cleansing and governance processes for maintaining business partners.l Kit.