SUMMARY

• Over 7 years of experience as anOracleapplications (E - Business Suite) Techno-FunctionalConsultantwith expertise in General Ledger (GL), Accounts Payables(AP), Account Receivables (AR), Order Management (OM), Payroll, Supply Chain Management (SCM), Inventory (INV), Purchasing (PO), Human Resource (HR).
• Expertise in Financials, Supply Chain and Manufacturing (SCM), Procure-to-Pay (P2P) and Order-to-Cash (O2C) ofOracleEBS11i & R12. Good Knowledge of Multi organization Access control (MOAC) architecture and Sub-Ledger Accounting (SLA).
• Extensive experience inOracleApplications Modules Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Purchasing (PO), iProcurement(ICX), Inventory (INV), Order Management (OM), Advanced Pricing (QP), Bill of Materials (BOM), Project (PA), Project Costing (PJC) and Project Billing (PJB).
• Extensive experience inOracleFusion Middleware 11g and 12c includingOracleSOA suite,OracleBPEL Process Manager,OracleData Integrator (ODI) &OracleService Bus (OSB).
• Experience in creating SOA components like DB Adapters, File Adapters and integrating with third party sources using BPEL processes.
• Expertise on the followingOracleHRMS modules. Human Resource Management System (HRMS) ofOracleApplications includingOracleHuman.
• Resources(HR),OraclePayroll,OracleAbsence Management,OracleAdvanced Benefits (OAB),OracleTime and Labor(OTL),OracleiRecruitment,OracleLearning Management,OracleSelf Service Human Resources(SSHR), Workforce Deployment and Workforce Development (Goal Management, Performance Management, Talent Review and Succession).
• Experience and proficiency in the Identity Management with hands on experience in implementation and management ofOracleIdentity Manager (OIM),OracleAccess Manager (OAM), andOracle Internet Directory (OID).
• Hands on experience in 11i & R12 implementation and rollout financial modules like GL, AP, and AR.
• Designing, developing, customizing and supporting the Inbound and Outbound Interfaces inOracle Applications which includes AP, PO, AR, OM, SCM, INV, EAM, GL, HRMS modules.
• Hands on experience in design and development in Extraction, Transformation & Loading (ETL) of data from multiple sources (oracle, flat file and ftp) using oracle PL/SQL, SQL loader.
• Proven experience in writing moderate to complex SQL queries and reviewing PL/SQL and Unix shell scripts.
• Extensive experience in Solution Design, Integration, Analysis, Development, Testing and post-production support forOracleEBSSuite R11 & R12 version.
• Experience withOracleEBSFinancials, Supply Chain (SCM) and Manufacturing modules.
• Expertise in Order to Cash (OTC) and Procure to Pay (P2P) business flows, have multiple Project experiences in working directly with business users to gather functional requirements and developing technical components.
• Worked withOraclesupport to resolve seeded application issues. Created service requests (SRs) withoraclesupport and tracking them to closure.
• Experience and proficiency in the Identity Management with hands on experience in implementation and management ofOracleIdentity Manager (OIM),OracleAccess Manager (OAM) andOracle Internet Directory (OID).
• Experience in developing functional and technical design and documentation forOracleHCM Cloud using data conversions, interfaces, custom reporting.
• Strong experience inOracleFusion HCM - Functional Setup Manager, Enterprise structure configuration, Employment model, Workforce structures, Personalization's and OTBI reports.
• Expertise in business Analyst role to understand the HR business needs, requirements and convert them intoOracleHCM product solution and liaison between technical solution team and Business team.
• Expertise in designing of payroll inbound and outbound interfaces which is related to non-Oracle Payroll entrainments like ADP, Integral as well andOraclePayroll base environment.
• Strong experience in Fusion HCM Cloud Implementation, HCM Cloud Upgrade, Patch updates, Cloud Testing, Support & Maintenance.
• Experience in Requirement Analysis, JAD sessions, Requirements Interviews, Brainstorming, Running Scrum Meetings, Sprint review, Business and Systems reviews and working sessions to communicate with the team and to ensure the understanding of the requirements and system design.
• Proficient in Data retrieval using SQL queries and supporting the necessary service requested logged withoracle. Ability to assist and guide technical team in Technical Design and Development of business requirements.

PROFESSIONAL EXPERIENCE

Sr. Oracle EBS Consultant

Confidential - Waterloo, WI

Responsibilities:

• Worked on the implementation of Oracle EBS R12 modules AP, AR & GL modules and was involved in all phases of the implementation and post production support.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process’ and revenue streams aimed towards problem solving.
• Worked on Oracle Inventory modules for completing standard functional setups such as Organizations, locations, Sub-inventory, locators, Planners, Inventory Parameters.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Coordinated and collaborated with business owners for their needs assessment & simplification of process flow to achieve revenue and income goals, utilizing the Oracle EBs R12.1.3 ERP.
• Improved and stabilized CRM integration with financial business process by implementing number of permanentsolutions like Code improvement, Form Personalization, Setup change, StandardOraclepatch application and adding new improved customizations.
• Assisted customer on Functional areas particularly in Manufacturing areas (PO, RCV, iProcurement, Inventory, Oracle Quality, BOM and WIP) and Prepare detailed Work plan and activities.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Addressing and Solving production issues which were Business Critical, Major and Normal in nature and requireddeep understanding of custom business process and end to end knowledge of various modules oforacleapps like CRM, SCM and Finance to resolve it within the pre-specified business SLA (Service Level Agreement).
• Actively participated in addressing post-implementation issues and errors in Financials (AP, AR, FA, CM, GL), Oracle Project Accounting (PA) (Costing, Billing, Resource Management, Oracle Time and Labor (OTL).
• Solid experience in Implementation, Rollout, supporting and delivering Oracle EBS Financial modules for several clients in Telecom, Retail, Insurance and Medical sectors.
• Supported a production of Oracle financial system, including modules like HR, AR, GL, AP, and PO, with problems resolution, installations, and business solutions.
• Automated the Billing system using Oracle database for billing various customers. Implement solution to provide accurate billing and save lot of money for company.
• Prepared Standard operating procedures (SOP s), end-user training material for Project Costing, Billing, Project Contracts and other customized modules.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Worked on various Customizations for Change Controls and created multiple package, function and stored procedureto support it.
• Functionally discussed the requirement with Business and worked on all MajorOracleApps ERP functional moduleslike CRM, SCM and Finance.

Oracle EBS Consultant

Confidential - Miami, FL

Responsibilities:

• Involved in Setup and configuration of Fusion HCM Workforce deployment - Core HR and workforce development modules like Performance, Goal management and Benefits.
• Utilized OIM's pre-built connectors to provision accounts or reconcile users with LDAP Servers, Databases, Operating Systems and Business Applications includingOracleE-Business Suite.
• Configured and maintained the following servers:OracleBI Analytics Server,OracleBI Analytics Web Server, andOracleBI Analytics Scheduler.
• Involved in troubleshooting problems encountered in the integration and up-gradation processes ofOracleIdentity Management suite components.
• Worked in the environment involving Agile PLM (Product lifecycle management) Administration and configuration and customization, this includes the discussion and understanding the customer issues and defining the Agile Users/ Workflows/ Roles and Privileges.
• Accountable to work with the Business Partners and other IT Leads to scope potential business demand and determine capabilities and resources would be required to achieve strategic business goals.
• Responsible for leading solution activities and getting the right stakeholders involved in the downstream design and build activities, deployment plan and support rollout.
• Identify key technology trends and determine how new technologies might be leveraged to make enterprise information services more efficient and effective in providing solutions to the business.
• Participate in post-implementation continuous-improvement efforts to enhance performance and provide increased functionality.
• Designed solution, end to end process flow diagrams in Visio, configurations, CRP, UAT for Corolla merger and acquisition (AP, AR, GL, FA) integration and Concur to GL integration.
• Builds strong relationships with Accounting and Finance department to build trust and support, and to optimize satisfaction at all levels.
• Involved inOracleHyperion andOracleOFSA (Profitability, Rate Mgr., Allocation and Transfer pricing) projects integrated withOracleEBS.
• Managed technical deliverables, ongoing development and deployment, release management, off shore management and reported team's progress and issues to the Project management office.
• AME integration with iProcurement and iExpense. AME setup for iExpense and iProcurement applications. Approval process setup by defining / modifying Attributes, Conditions, Actions, Approval Groups, and Rules.
• Analysed the custom code components in proc to pay process and retrofitted custom PL/SQL Packages, Reports, Forms, and Workflows to make them work in R12. Personalization and Extension of OAF pages in various modules.
• Created multiple Complex OAF Pages for Purchasing, Order Management, and iExpense which included Partial page rendering functionality.
• Worked as Functional Analyst forOraclePurchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
• Setup of Cash Management, General Ledger, Account Receivables, Accounts Payable, Purchasing, Cost Management and Advanced Collections.
• Understanding complex business requirements and processes and liaising between Business Analyst / External Partners and development team.

Oracle Analyst

Confidential - Redwood City, CA

Responsibilities:

• Demonstrated expertise as FunctionalAnalystin OracleEBSenvironment, working and supporting P2P stream of business.
• Functional Design confirmation of Concur (expense system used by MIDSTREAM acquired by Williams) integration with Oracle R12 during WONERP project.
• Used my detailed knowledge of Oracle Financials to identify and design solutions that meet business requirements.
• Setup, testing and supported various customizations related to Suppliers, requisitions, purchase orders and invoice creation related to various OracleEBSP2P interfaces.
• Provided support to the development of a cutover plan for theEBSfinance system as well as cross Project Cut-over activities and dependencies.
• Supported the project team efforts to provide post production support to the county during the month after Go Live by providing functional OracleEBSexpertise and troubleshooting and resolving issues escalated from the help desk.
• Developed interfaces, Built and used API's in Oracle E-Business suite (EBS) Financials and HR Modules.
• Ran payroll, Pre-Payments, Costing, Quick Pay, Retro Pay, Retro Pay by Element, Retro Costing, Import payroll transactions from HRMS.
• Participated in the Oracle upgrade from version 11i to R12.1.2, including designing executing test scripts for Unit Testing, as well as User Acceptance Testing.
• Created basic HRMS user inEBSand link record in HRMS with record in FND USER by utilizing the User Management with HR Foundation connector of OIM.
• Modified the seeded HR workflow processes as per their needs for Oracle Self Service and Payroll.
• Worked in the environment involving Agile PLM (Product lifecycle management) Administration and configuration and customization, this includes the discussion and understanding the customer issues and defining the Agile Users/ Workflows/ Roles and Privileges.
• Worked across all areas of the organization coreEBSapplications, ATC, HTR, PAC, PJM, Taleo and PTP to identify, prioritize, and mitigate risks to the responsiveness and scalability.
• Responsible for entering in all assigned time cards along with the necessary information into payroll software based on client protocols.
• Created and assigning respective responsibilities to Users and provide SOX compliance documentation.
• Helped client for successful testing of developed solution including System Integration Testing (SIT), User Acceptance Testing (UAT) and working with business users to validate the converted data in HCM Cloud.
• Worked with offshore resources on day to day basis. Managed the deliverables and validated development work to present to client for sign/off.
• Responsible for working with Oracle Support, Oracle Product Development, third party vendors to ensure an On-Time Go-Live.
• Created security profiles to avoid departments to access another departments Information.
• Assisted client in extracting data from PeopleSoft HCM by providing table mapping between PeopleSoft HCM and Oracle HCM Cloud.

Business Analyst

Confidential - NYC, NY

Responsibilities:

• Conducted Joint Application Development (JAD) and interview sessions to elicit requirements from the users and subject matter experts.
• Involved in the documentation of extraction, of the data from various tables in the Data warehouse.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Involved in Software Development Life Cycle (SDLC) Requirement Analysis, Testing and Implementation.
• Collaborated with the QA team in designing test plans and test cases for the User Acceptance Testing.
• Conducted Worked with Business users and co-ordinate with them to understand and capture requirements.
• Gathered Business Requirements, interacted with the users, Project manager and SMEs to get a better understanding of the business processes.
• Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Requests. Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams.
• Involved in the review of Test Plans, Test Cases with QA team to verify implementation of new features and enhancements.
• Responsible for creating business workflows and processes, and created management reports based on the analysis.
• Came up with Test Cases for various reports on the data marts and identified that the Test Case Documents were updated timely.
• Gathered, analyzed, documented Business Requirements and Technical Requirements from both formal and informal sessions and validated the needs of the business Stakeholders.
• Performed GAP and Risk analysis of existing manual process and evaluated benefits of new functionalities.
• Worked closely with Business team and Technical development teams to communicate business requirements and priorities.
• Conducted GAP analysis to understand the shortcomings of the existing system and evaluated the benefits of the new system.
• Conducted review sessions with Business and IT teams to baseline the BRD (Business Requirement Document) to get better understanding of the Enrollment requirement changes.
• Defined Data Modeling and ETL load required to integrate into Micro Strategy Platform.
• Reviewed outcome of the EDI Tests to ensure everything processed correctly according to Test Plan, if not then acted.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.