Oracle Consultant

SURESH

408-***-**** *****.****@*****.***

SUMMARY:

Over 12 years of IT experience with Ten plus years of Oracle applications 11i & R12 and Oracle Tools experience in IT industry in various modules of Oracle Applications and PLSQL Developer.

Extensive knowledge in working with business users Identifying functional and technical gaps, estimation of works and programming.

Extensively worked on Implementation, Support and R12 Upgrade Projects, as well as on Oracle11g/10g/9i

Well experienced in Design to Delivery of different EBS customizations (Alerts, Custom Library, OAF, Procedure and Packages etc.) Worked on OAF customizations & RICE components (Reports, Interfaces, Conversions and Extensions (RICE), Oracle Workflow and Oracle E-Business Suite data model.

Extensive experience in Database design, PL/SQL programming, performance tuning, UNIX Shell scripting, writing Complex SQL queries, Analytical functions, Query optimization, inbuilt database packages, SQL Loader, Import/Export, Datapump.

Possess strong skills in performing Functionality Testing, User Acceptance Testing, Systems Integration Testing, Regression Testing, Data Migration, Data Integrity, End-to-End testing of Web and Client/Server based applications.

Experienced in maintaining, tuning and upgrading Web servers and Web applications on Unix platform

Expertise in reporting using various oracle reporting tools includes Oracle Reports, XML publisher, Oracle Discoverer (Desktop, Administrator, Plus, Viewer), Crystal Reports, knowledge in tableau.

Worked on identifying/ owning OM related setups like OM Holds, validation templates, processing constraints, Transaction types, Defining and Assigning Document sequences, Defaulting rules, Attachment categories, OM system parameters

Worked on the setups as part of Change Management to define Organizations, Organization Parameters, defining locations, sub inventories, Unit of measure, Defining Conversions, and setting up the org for Container Items

Development methodologies Waterfall, Agile and Strong knowledge and understanding of ITIL

Technically proficient in Order-to-Cash (O2C) and Procure-to-Pay (P2P).

Good understanding of new SLA process by R12

Worked on the Deliver setups like shipping parameters, Release rules, ship confirm rules, defining freight carriers and ship method codes.

Customized OAF pages (EO, VO, AM, Controllers) to satisfy the business requirements.

Interacted with business users for requirement gathering, prepared Requirement Document (RD20s) and Functional Design Documents (MD50s).

Expertise on the following Oracle HRMS modules. Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources(HR), Oracle Payroll, Oracle Advanced Benefits(OAB), Oracle Time and Labor(OTL), knowledge in Oracle iRecruitment, Oracle Learning Management and Oracle Self Service Human Resources(SSHR).

Setup AP Invoice ACH Payment formats.

Implemented ACH Payment for both Domestic and international Customers.

Co-ordinated with US bank for payment formats and their validations.

Customized Domestic and international ACH payment formats as per the US bank requirement

Broadly involved in release planning, supporting testing activities of deliverables in different stage cycle environments, supporting Production Go-live.

Experienced in Black Box testing, White Box testing, Smoke testing, Regression testing, Integration testing, End-to-End testing, User Acceptance testing and planning release work items with Sanity checks.

Lead offshore support team and worked extensively on onsite offshore model and proven customer management skills with business users.

As a Technical Consultant, extensively worked on Oracle Applications modules like GL, AP, AR, PO, OM, Oracle Time & Expenses (OTL).

Got Trained Oracle Fusion Modules (OM, BOM, Core HR, Core Implementing, Web ADI, Payroll Essentials, Time & Labor Functional, CRM)

Trained the teams on different Reporting tools and concepts in EBS.

TECHNICAL SKILLS:

ERP Tool

Oracle Apps 11i, R12

Database

Oracle9i, Oracle 10g

Languages

C, C++, SQL, PL/SQL, Shell Scripting,HTML,XML,CSS

Tools

TOAD, Sql Developer SQL *Plus, SQL *Loader, SQL Server, JIRA, Rally, Kintana, PVCS, Artifactory, SharePoint Administrator 2007,Remedy, SVN

GUIs

Developer 2000 (Forms 6i and Reports 6i), Reports 10g,

Oracle Discoverer 4i, XML Publisher, OAF, Crystal Reports XI

FUNCTIONAL SKILLS:

Financials

Accounts Payables (AP), Accounts Receivables (AR), General Ledger(GL),

SCM

Order Management (OM), Inventory, Purchasing(PO)

CRM

Install Base (IB), TCA.

HRMS

Oracle Time and Labor OTL, Payroll, Absence Management

EDUCATION:

Masters Degrees (MBA) Marketing from Sikkim Manipal University in 2010

MSC(Computer Science) from Osmania University in 2003

B.Sc (MSCs) from Osmania University in 2001

PROFESSIONAL EXPERIENCE:

Cisco Systems Inc, San Jose, CA May’16 – Till Date

Oracle Techno Functional Consultant

Responsibilities:

Understand the DCG (Data Centre Group) –UCS (Unified Computing System) and Security Biz flows and Product structures.

Coordinated the escalation, tracking and follow-up on issue resolution in accordance with end-user

Served as a technical liaison, resource and primary point of contact between application end-users and IT.

Update the Biz team with Issue - analysis – Root Cause Analysis, if there is any system issue need to ensure a Problem Incident is raised and a Short Term fixed is provided by the team

Weekly meetings with Customer partner and services team, to understand the pain points, and any IT issues which need immediate attention to be fixed. Any user training issues report to the Order Entry Team to document and any enhancements if required need to be discussed and addressed.

Problem Incident raised, based on the Biz impact, need to get it prioritized and escalate to the respective Monthly Release teams/ Quarterly teams to get the issue fixed in upcoming releases.

Bug Fixing And providing Support to RICE /CEMLI components.

Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles

Reduced redundancy of report requests from business users by creating daily, weekly, and monthly reports using SQL Query.

Increased knowledge and allowed for quicker turnaround on incoming requests by providing process and procedure documentation for colleagues and business users for software applications being supported, which led to better understanding of application and functionality.

Log, monitor, and follow up on service requests (SRs) online- Oracle MetaLink

Participating in WEB-EX conference with the user and solving the issues.

Environment: Oracle Applications R12, TOAD, XML Publisher, CCW, Egenie, ConnectDots, MDM, Rally, Jive.

Cisco Systems Inc Mar ’13 – Apr 16

Oracle EBS Technical Lead

Responsibilities:

Build of Packages & Object types in order to achieve the business process with system functionality.

Worked as team using agile scrum methodology to achieve the goals.

Worked on Cisco Customized Reports, migrated reports from 11i to R12

Performing analysis of the functional changes from 11i and R12 and modifying the R12 objects accordingly. Examples include introduction of new tables in R12, functionality change etc.

Worked on auto confirm printed check payments issue (PPR) to resolve and outline the needs to update existing custom program.

Handled show-stopper issues like: Identify PPR related data corruption issues, Invoice not being selected by PPR Validate BI Publisher configuration, Separate Remittance Advice failures.

Documenting the discussions with the business relating to the Business Requirements

Requirement gathering and prepared documentation for new reports

Preparing the POC (Proof of Concept)

Design, coding, testing and providing support.

Provided MD 050 for creating new reports.

Supported to QA team in SIT, UAT, Load and Smoke test.

Good functional knowledge in O2C and P2P cycles

Troubleshoot issues, including creation/follow-up of Oracle service requests (SRs)

Customized OAF pages (EO, VO, AM, Controllers) to satisfy the business requirements.

Customized EBS using Forms Personalization and OAF personalization.

Worked on the customization of Cisco Credit Outbound E Credit BID Interface.

Incorporated Additional process between OTL and Payroll to add customer logic.

Through understanding of OTL to payroll process.

Preparing Testing Documents (TE-040)

Sanity Testing of the new instance after DB Upgrade

Developed staging tables, conversion routines and PL/SQL API to load the Open Sales Order (OM) to integration of legacy system (EDI).

Prepared Training documents for specific topics

Prepared necessary migration plan for smooth Migration to PRODUCTION

To ensure resource is allocated in the most effective way

Responsible for overseeing the day-to-day operations of the team, distributing the workload amongst the team and making sure motivation & performance are maintained. Lead a Team of 10 People.

Environment: Oracle Applications 11i, R12, PL/SQL, TOAD, OAF, Forms & Reports 10g, XML Publisher, CCW, Egenie, ConnectDots, MDM, Rally, Jive, PVCS, SVN, Kintana, AppsDB, Quality Center.

EIS Technologies, Hyderabad Sep ’12 – Feb 13

All Scripts

Oracle EBS Technical Lead /Consultant

Responsibilities:

Understand client business requirements and Assist client in providing solutions.

Worked on development and upgradation of XML/BI Publisher, Form Personalization, Interfaces, and Conversions in Order Management (OM), O2C,Oracle Process manufacturing (OPM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Oracle Product Data Hub (PDH) & OKC/OKS.

Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Order to Cash (O2C) and Procure to Pay (P2P) cycles

Worked on UNIX Shell Scripts, Workflow and Intrusive Customization of Standard PL /SQL Programs.

Development and Personalization of Purchasing Forms using Oracle Application Framework (OAF)

Extensively worked on Performance Tuning.

Developed Automatic Customer Credit Hold Inbound Conversion in (Accounts Receivables )AR module to upload the customer data from flat file to Oracle apps base tables.

Developed Customer Hold Inbound Conversion in AR module to upload the Customer data from flat file to Oracle apps base tables.

Developed Inbound Conversion in AP module to upload the Banks data from flat file to Oracle apps base tables

Worked on the Eis reporting tool in the support and maintenance of the reporting cases.

Customization of Reports integrating with OAF.

Customize a LOV in OAF (VO Extension)

Created XML Publisher reports for Audit reports for Employee change details( Assignment change details, salary change details)

Participated in detailed Payroll requirement information gathering needed for Reports Customization

Developed Custom OTL and integrated with Oracle Projects

Assign AME Roles and Responsibilities

Training new team members.

Lead a Team of 6 People along with individual contribution on development.

Preparation of MD070s, Design Level Documents, Test Plans.

Reviewed and Modified Functional Design Documents (MD-050)

Provide Customer Training as required & Dealt with variety of client issues related to system design as well as to business.

Environment: Oracle Applications R 12, TOAD, Pl/Sql, Eis Reporting Tool, Forms & Reports 10g, OAF.

Prithvi Information Solutions, Hyderabad July ’11 – Sep 12

IDT

System Analyst

Responsibilities:

Coordination with Functional Team and Client Key users for Gathering requirements, analyzing, solution design & deliverables.

Development and Personalization of Purchasing Forms using Oracle Application Framework (OAF)

Worked on development and upgradation of XML/BI Publisher, Form Personalization, Interfaces, and Conversions in Order Management (OM), Oracle Process manufacturing (OPM), Purchasing (PO), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Oracle Product Data Hub (PDH) & Service Contracts

Planning and Managing Service life cycle that mainly includes 1) Creating Contracts 2) Approving Contracts 3) Extending and Renewing Contracts 4) Terminating Contracts

Worked as a system business analyst for the final 6 months of a project to expand the implementation of Service Contracts (SC/OKS/OKC) and Install Base (IB/CSI). Involved in testing (both standard functionality and custom functionality), working with Oracle on bugs, developing new business processes, writing training documentation, and configuring the application during go-live.

Worked on UNIX Shell Scripts, OAF, and Workflow Customizations.

Worked on go-live post-production troubleshooting and enhancement activities.

Optimization and simplification of the existing custom objects.

Preparation of Technical and Functional documents based on User Specifications.

Worked on the Change Requests (CRs) given by business.

Reconciliation of Receivables GL Codes from Legacy to ERP and find out the differences and provide solution.

Prepared Test scripts for specific flows in OM (Sales Order Creation) and PO (Purchase Order Creation).

Provided Functional Support for developing New Forms

Preparing Functional Design Documents (MD-050) for the New Forms

Reviewed and Modified Functional Design Documents (MD-050)

Root cause analysis and data/system fix for CR’s.

Developed an interface to load journal entries from the generated information into base tables by using the Journal Import provided by Oracle General Ledger.

Worked on forms Personalization.

Worked extensively on AOL Objects

Developed various shell, sql and pl/sql scripts for verification.

Designed and developed various PL/SQL packages, stored procedures, functions, cursors and triggers and shell scripts to meet business requirements.

Creation of JIRA for any bug or changes in the existing code or data fixes.

Creation of Technical Documentation and User Test Cases.

Environment: Oracle Applications 11i, TOAD, Pl/Sql,Oracle Forms & Reports 6i, XML Publisher

Kenexa Technologies, Vizag Feb 07’ – Jul 11

Software Engineer

Responsibilities:

Worked in Kenexa In-house projects in Oracle Applications worked on AR/AP/GL/PO, OTL modules for all day to day help with end users on technical side

Strong Domain knowledge in various business flows including Financial Modules like Account Receivables, Account Payables, Procure to Pay (P2P) cycles

Developed Technical Design Documents as per the Client coding standards & Project Quality plan.

Developed the code and Completed Unit testing for Interfaces and Reports as per client requirements.

Created Procedures, Functions, Triggers, Values Sets, Lookups, Descriptive Flex Fields (DFF) and other AOL/database objects using SQL and PL/SQL.

Defining Concurrent Programs, Executables. Request Sets.

Writing Unit Test cases and testing after completion of the Object.

Supported all go-live activities and post-production troubleshooting.

Preparation of MD070 Technical specification documents based on Functional Specifications.

Used SQL loader to load data from legacy system and developed PL/SQL programs to dump the data from the staging tables to the Interface Tables.

Development of new enhancements as and when need arises from the business and proficient in Post-production activities.

Log, monitor, and follow up on service requests (SRs) online- Oracle MetaLink

Build and maintain repository for deliverables & business development documents.

Actively involved in day-to-day support activities for Oracle EBS 11i Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.

Worked at Onsite location Wayne to understand the business needs and functionalities of the project

Developed and customized reports in Oracle Reports 6i, Oracle Discoverer Reports for Oracle Timesheets(OTL), XML Publisher Reports

Developed Fast formulas for OTL and absence management modules. Developed various inbound and outbound interface in HCM modules

Developed AP invoice Interface.

Developed Account Receivable Auto Invoice interface.

Involved in Quality Audits.

Performed logical backups using Oracle Import / Export

Crystal Reports Developer experience: Converted project specifications and statements of problems in order to create and modify programs. Development experience with customized in-house applications provided applications

SharePoint Administrator: Responsible for administering & managing the Share Point farms and databases, Ensure the integrity and security of Share Point data in accordance with business needs and industry best-practices regarding privacy, security, and regulatory compliance

Environment: Oracle Applications 11i, TOAD, Pl/Sql, Oracle Reports, Conversions, Interfaces, Discover Reports, Crystal Reports, SharePoint Administrator

Arral Technologies, Hyderabad Jan 05 - Feb 07

CNS

Software Engineer

Responsibilities:

Development & customization of Reports, conduct Technical analysis for developing new reports.

Preparing Technical Documents and Preparing Unit Test Scripts.

Developing interfaces in purchasing and payables modules as per business requirement.

Responsible for preparing procedures, functions, packages as per requirements.

Developed PO requisition interface.

Developed and Customized the Discoverer by using Discoverer tool as per the client requirement.

Developed and customized the Forms and worked with the Custom.pll for doing modifications to the Standard Forms.

Developed Extensions to custom business flow from Order management, install base to service contracts for raising credit memos and invoices in AR.

Part of production as well as enhancement team on support

Mapping functional specifications to technical for customizing existing reports

Other issues related to reports in Production.

Developed OM interface

Environment: SQL, PLSQL, Oracle Applications 11i, TOAD, Interfaces, Forms & Reports

Contact this candidate