SUMMARY

• Over 6 years of Oracle EBS expertise in enterprise - wide Oracle Applications design, development, and support for 11i / R12 implementations and upgrades.
• Expertise on the following Oracle HRMS modules. Human Resource Management System (HRMS) of Oracle Applications including Oracle Human Resources(HR), Oracle Payroll, Oracle Absence Management, Oracle Advanced Benefits(OAB), Oracle Time and Labor(OTL), Oracle iRecruitment, Oracle Learning Management, Oracle Self Service Human Resources(SSHR), Workforce Deployment and Workforce Development (Goal Management, Performance Management, Talent Review and Succession). Extensive experience in implementation, Migration, Customization, Production support of various modules in Oracle Applications with major focus in Purchasing (PO), General Ledger (GL), Sub Ledger Accounting (SLA), Accounts Payable (AP), Accounts Receivable (AR), Projects (PA), Order Management (OM), Inventory (INV), and iProcurement.
• Experience and proficiency in the Identity Management with hands on experience in implementation and management of Oracle Identity Manager (OIM), Oracle Access Manager (OAM), and Oracle Internet Directory (OID).
• Rich experience on RICE components (Reports, Interfaces, Customization and Extensions of Oracle Applications 11i/R12) on Oracle Projects, HRMS, Financials, SCM modules.
• Experienced in configuring Workflow routing rules for all Manager Self-services and Employee Self-services.
• Familiarity with Contract Lifecycle Management (CLM), Human Resources (HR) and Oracle Time and Labor (OTL).
• Extensive experience in SQL, PL/SQL, Procedures, Functions, Packages and Triggers, Forms, Reports, XML Publisher, Conversions, Interfaces and Forms Personalization effectively to accomplish specific business validations.
• Strong Knowledge of Application Implementation Methodology (AIM), Application object Library (AOL) implementation standards and software Development Life Cycle (SDLC).
• Expertise in translating functional specifications into technical specifications for development of Oracle Applications R12 modifications and integrations including system interfaces, reports, data conversions and custom extensions.
• Strong knowledge on Oracle AOL concepts like Multi-Org, System and User Profiles, Executable, Concurrent Programs, Request Groups, Responsibility, Flex fields (DFF and KFF), Lookups, Menus, Functions, Value Sets, WHO Columns, Oracle Alerts and Messages.
• Expertise in Oracle Taleo cloud services with focus on areas like of Taleo Recruiting, Taleo Onboarding transitions, Taleo Learn, Taleo Performance, Taleo Connect Client (TCC), Business object /OBI reporting.
• Experience in building new reports and troubleshooting the existing reports using Fusion reposting tool OTBI (Oracle Transactional Business Intelligence).

PROFESSIONAL EXPERIENCE

Confidential - Dallas, TX

Sr. Oracle EBS Consultant

Responsibilities:

• Worked with Management, Business Users and third-party vendors to understand the requirements and guide the team on designing and mapping the requirements to Oracle HCM system.
• Involved in successful implementation of HCM Cloud (Talent Management- Goals, Performance, Profiles, Talent Review & Succession Planning).
• Performed Oracle E-Business Suite (EBS or Apps) integration with Oracle Identity Manager (OIM) for User Provisioning and Reconciliation.
• Involved in the implementation of core HRMS functionality for multi-currency and multi legislations (Global) and integration with financial and manufacturing modules.
• Conducted requirement gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD) using Rational Requisite Pro.
• Created business process design documents and functional specification documents for interfacing Global Vendor Portal (GVP) with Oracle EBS R12.1.
• Performed gap analysis between business requirements and HCM Compensation and Benefits functionality.
• Created basic HRMS user in EBS and link record in HRMS with record in FND USER by utilizing the User Management with HR Foundation connector of OIM.
• Worked on Benefits extracts to the third-party vendors and loaded feedback to EBS pay elements using Batch Element Entry.
• Prepared Unit test cases and execution of test cases before migrating to production and documenting the test cases.
• Used Custom PL/SQL API'S for converting open AP Invoices, Suppliers, Supplier Sites, Supplier Contacts, Customers using TCA, Open AR Invoices, and open Purchase Orders from legacy system (Mainframe) to Oracle Applications.
• Ensured that the application meets the business requirements and system goals and fulfill end user requirements.
• Wrote PL/SQL packages for different validations, for processing data in order to create Valid POs and Receipts and for populating the PO interface tables and called the Seeded import programs to populate the base tables.
• Customized Self Service Time Expenses responsibilities using the Time and Expense Self Service Menu with menu exclusions, Mass Timecard Approval using the OTL Self Service Approval Menu and Worklist Timecard Approval using the OTL Worklist Timecard Approval menu.
• Managed multi-phased project planning efforts, including the formulation of the overall project vision, program roadmap, implementation strategy, program scope, definition of the deliverables and the required delivery dates.
• Actively involved in day-to-day support activities for Oracle EBS R12 Finance Multi-Org stream by troubleshooting, providing solutions and communicating with the users through Support tickets.
• Performed End to End Regression testing on Core HR, Talent management module such as Goal management and Performance management and Benefits modules on every patch bundle application and new Releases.
• Developed Enhancements, Interfaces and Reports for Oracle Receivables, Purchasing and Order Management, using Oracle PL/SQL, Oracle Forms, Reports, Workflow and Unix shell scripts.
• Performed troubleshooting and resolved issues found in parallel tests scripts, validated payroll setup, payroll elements and payroll fast formulas.
• Integrated TALEO system with Oracle HR system, worked on fast formulas for payroll, and balances configurations, wrote procedure balances adjustment.
• Provided onsite support during the payroll consolidation and implementation of Oracle HRMS including co-ordination of internal resources, data clean-up, conversion, and development of procedures to continually ensure data integrity, facilitate user training as well as to define and document user security and access levels.
• Engaged various stakeholders to provide assessment for the Oracle Payroll, Benefits and HR applications and to provide functional expertise to review, analyze, test, and troubleshoot the client’s present configuration.

Confidential - Rochester, NY

Oracle EBS Analyst

Responsibilities:

• Worked on Custom programs for converting Legacy data into Oracle HRMS system for Employees, Assignments, Elements, Pay Methods, Salaries, Contacts, Addresses, Contact Addresses, Phones and Costing including history and involved in Benefits conversion.
• Created functional requirements as an input to application design for migrating applications from Oracle EBS to Oracle Applications R11.
• Created business process design documents MD050 functional setup documents, MD070 technical design documents and BR100 configuration and set up documents.
• Wrote complex PL/SQL database packages and configured concurrent programs for data conversion, data uploading, data retrieval, data testing, and for interfacing between Oracle EBS and custom made software LRS (Leave Request System).
• Created custom Forms for HRMS Module using Oracle Forms 6i and uploaded them in Oracle E-Business Suite.
• Bridged gap between AS-IS and TO-BE business process flows, integration of process flow diagrams to show end-to-end business model, and process mapping exercise by including swim lanes to distinguish roles and responsibilities.
• Involved in extensive Data validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.
• Conducted User Acceptance Testing (UAT) and collaborated with the client stakeholders and QA team to develop the test plans, use cases and test data to be used in testing.
• Provided various reports, and advised HR Comp and HRIS teams on best practices of Oracle EBS system, tool, reports, or software usages.
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project requirement study, Project planning, High-level design, Low-level design, Coding, Implementation, Testing and Quality assurance Documentation.
• Worked on Customer conversion to import data from Legacy System into Oracle Account Receivables by using Customer Interface.
• Designed technical specifications for month-end Benefit Balance validate and update to Oracle payroll, developed programs to upload time from contingent worker time system to OTL which includes time and project attributes for OTL module.
• Maintained user access and privileges within Oracle Agile PLM application, creating documents and associated components as required and adjustments to existing objects, lists, searches, and workflows Confidential user request.
• Involved in troubleshooting problems encountered in the integration and up-gradation processes of Oracle Identity Management suite components.
• Responsible for business requirements gathering, process analysis and design, gap analysis, functional system design and specification, development of system tests, business process procedures and training documentation.
• Facilitated the development of custom Oracle XML publisher reports by creating Functional Specification, Testing and Deployment.
• Created Oracle Data warehouse mapping and transformed the online transaction data to Data warehouse tables using Oracle Data warehouse builder.
• Created Inbound Interfaces using PL/SQL packages in Oracle Manufacturing and Order to Cash Cycle to import legacy system data into Oracle EBS.

Confidential - Dallas, TX

Business System Analyst

Responsibilities:

• Involved the functional implementation of Oracle Core HCM, Benefits, Compensation, Absence Management, Payroll, Performance Management and Goals, for an HCM implementation.
• Worked on the Data migration activities of Core HR/Payroll, OTL SSHR and OAB through conversion scripts(like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc).
• Worked on enhancements for MDM Interface which includes gathering the requirements (Mapping document), developing the code, writing test scripts, writing technical documents.
• Performed data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data between Oracle EBS R12 and legacy systems.
• Utilized database, SQL and Excel/Google sheets skills to collect, organize, and analyse data to support forecasting efforts.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Worked with OBIEE to perform detailed data analysis to identify appropriate data sources, key facts, and dimensions that support the business requirements.
• Prepared AIM technical documentations (MD70, CV60) and aided functional team in Oracle HRMS technical areas to prepare functional documents.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Involved in Requirement Gathering, Technical Design, and Gap Analysis, Data mapping, development and testing of Custom Module Development for R12 Inbound Shipping Module.
• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments and worked on retro pay process.
• Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
• Participated in implementation of ERP system and integrated with different Systems like Oracle HRMS and Oracle Payroll.
• Facilitated smooth testing during SIT and UAT for Core HR and Self Service HR and played a vital role in tracking/resolving all issues.
• Captured functional and technical requirements and mapped requirements to the standard Oracle R12 functionality and identified the gaps.
• Managed bugs using Defect Tracking Tool JIRA, reviewed each defect and assigned development team to resolve problems.
• Involved in managing instances across SDLC stream, specifically involved in setting up responsibilities, new users, profile options, menus, functions as per SOX standard.

Confidential, Hyderabad, IN

Business Analyst

Responsibilities:

• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio, MS Word and MS Excel.
• Involved in Conversion of Benefit Enrollments from Third Party to Oracle for Open Enrollments and worked on retro pay process.
• Documented Business process flow as per the UML standards using Use Case Diagram, Activity Diagram and Sequence Diagram in MS Visio.
• Evaluated the work effort to complete requirements and UAT testing to provide project estimates, project plans, business impact analysis and project charters.
• Converted reports to XML version (BI publisher) to generate XML output, thus avoiding the use of RDF and resulted in better performance.
• Used HP Quality Center to maintain test Cases and scripts also involved in preparation of Test Cases, Test Scripts for the Core HR, Benefits, Talent and Global Compensation.
• Ensured that the application meets the business requirement and system goals, fulfil end user requirements, and to identify and resolve system issues.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the code and made the changes according to the new business requirements.
• Performed functional setups, create design documents, user requirement specification, analyze the AS-IS process and provide gap analysis.
• Conducted requirement-gathering sessions with the purpose of creating and defining the Business Requirement Document (BRD) and the Functional Requirement Document (FRD).