SUMMARY

• Experienced IT Consultant with 11 years of experience in Oracle EBS R11i/R12/Fusion Applications, Fusion Middleware and 3 years in Java technology Experience of one year in manufacturing domain
• Key roles played - Developer, Team Lead, Technical Consultant, Functional / Implementation Consultant and activities related to Project Management Expertise in following technologies Oracle Applications R11.5.10/R12.1, Fusion Applicat i ons, Fusion Middleware, Hyperion, Unix, Oracle, J2EE
• Exposure to Mainframe technologies
• End to End implementation experience in Oracle Fusion Applications RUP4, Oracle Fusion Middleware
• Good Experience in the following domains - Finance, Manufacturing, Insurance, Hospitality, Retail, Fuel Accounting, Retail Banking Good implementation background in Oracle Supply Chain Management, Financials, Project modules
• Excellent experience in complete Software Life Cycle Development - Requirements Gathering, Fit / Gap analysis, Solution Design, Implementation, Development, System Integration Testing and good experience in Consulting, facilitating User Acceptance Testing, Production support Excellent experience in preparing As-is and To-be business process flows and in Oracle AIM methodology
• Good experience in conducting CRP sessions with business users, facilitate and resolve issues between various project stake holders Good experience in conducting integration workshops with various project stakeholders
• > Experience in preparing RD20, BR10, BR30, BR100, BR110, BP80, MD50, MD70, CV40, CV60, TE20, TE40 documents Experience in analyzing functional requirements and converting the same into technical specifications for RICEF / CEMLI objects Excellent experience in configuring Oracle R12 / Fusion ERP Applications as per business processes and requirements Experience in preparing Integration Test Strategy, Integration Test Plan, Test Scenarios, Test Cases, Test data
• Experience in Quality Assurance Unit Testing, System Testing, Functional Testing, System Integration Testing and facilitating User Acceptance Testing Experience in conducting Defect Triage meetings and resolving issues
• Experience in conducting End User Training and preparation of User Manuals for end users Experience in creating service requests and resolve them through interaction with Oracle Support team
• Excellent functional knowledge in following modules in Oracle Applications R11i/R12 iProcurement, Purchasing, Payables, Receivables, Inventory, Order Management, Cost Management, General Ledger, Fixed Asset, Project Costing, SLA, iExpense, Site Hub, Supplier Hub, iExpense, iSupplier Portal Excellent functional knowledge in Fusion Applications RUP4 - Product Information Management (PIM), Inventory, Procurement, Receiving, Supplier Portal, Sourcing, Project Costing, Sub Ledger Accounting, General Ledger, Payables, Fixed Asset
• Good exposure to R12 - CRM Resource Manager, Core HR, Payroll, Time and Labor, SSHR, Financial Accounting Hub Good exposure to Fusion Cost Management, OIM11g
• Experience in implementing solutions using Fusion Middleware 11g SOA11g, BPEL, Mediator, Human Task, Business Rules, XSD, XML, XPath, XSLT, WSDL,
• Jdeveloper 11g, Web Services
• Experience in Defect Management tools like HP QC and reporting daily / weekly status to project stake holders Excellent verbal and written communication skills and responsive to new learning opportunities
• Worked with leading IT consultancy organizations like Tata Consultancy Services, UST Global, Electronic Data Systems, Polaris, Cognizant Technology Solutions in various geographies

TECHNICAL SKILLS

• Purchasing, iProcurement, Inventory, Order Management, Payables, Receivables, General Ledger, Fixed Assets, Project Costing, SLA, iExpense, iSupplier Portal, Site Hub, Supplier Hub, BOM, WIP, Sourcing
• Good exposure to Core HR, Payroll, Time and Labor, Self Service HR, Financial Accounting Hub (FAH)
• Oracle 10g/11g/XE, PL/SQL, SQL, SQL Developer, TOAD
• SOA 10g/ 11g / 12c, XML, XSD, XPath, XSLT, WSDL, JMS, Web Services, Jdeveloper 10g /11g/12c, BAM, BPEL, Mediator, Business Rules, Human Task, WebLogic, Enterprise Manager HTML, CSS, Core Java, JSP, JSF, Servlet, JavaScript, EJB 3.x, NetBeans, Eclipse, Tomcat, JBoss / Wildfly, Glassfish, Weblogic 11g/ 12c
• DRM 11.1.2.4
• Visio, Tortoise Subversion, Altova XML Spy, WinSCP, HP Quality Center/ ALM, Putty, Unix / Linux, Shell scripting, Data Loader, SQL Server 2012, SoapUI 5.2, Mainframe technologies

PROFESSIONAL EXPERIENCE

Confidential - Irving

SQL Developer

Technology: SOA12c, SoapUI 5.2, PLSQL, SQL, Hyperion DRM 11.1.2.4, OBIEE 11g, Oracle Applicat i ons 12.1.3 — Site Hub, Supplier Hub, Contracts, Procurement Contracts, PO, AP, GL, FA, Project Costing, Core HR Domain - Retail

Responsibilities:

• Interact with business users and understand retail merchandising and non-merchandising line of business Study existing process in Location hierarchy, Vendor master and prepare current state process flows Study current state process of franchise management and franchise accounting system and document the process flows Document requirements of site and vendor master for future state system
• Involved in preparing L0/L1/L2/L3 process flows, Requirement Analysis, Design, Fit/ Gap analysis, Reporting analysis Contributed to preparation of conceptual Integration Architecture and participated in architectural reviews Involved in CRP sessions, demonstrated business flows and involved in end-to-end integration workshops Interact with business users and documented audit and security requirements Prepare / Review BR30 Requirements mapping, BR10 Gap Analysis document Identify all attributes needed to be configured in Site Hub, Supplier Hub and DRM
• Analyze interfaces between mainframe location master / vendor master and all interfacing applications which consume the master data along with the mapping Prepare / Review BR100, BR110, BP80, MD50, MD70 documents
• Prepare / Review CV40, CV60 documents for location, vendor data conversion from mainframe to Oracle R12 Configure Site Purpose, Attribute Groups, Attributes, Attribute Page
• Lead functional/technical review sessions for requirement review. Utilize tools like SQL Developer, Web ADI to enhance functionality and user experience Involved in code reviews / defect fixes
• Identify Test Environments for System Integration Testing and User Acceptance Testing
• Interact with business users and document SIT and UAT Test Scenarios and Cases for site and vendor master Validate business processes as per requirements, perform technical unit testing, identify issues and resolve them Facilitate User Acceptance Testing and end user training, contribute to effort estimation, project plan and status reporting

Confidential

Technology: Oracle Applications 12.1.3 - Domain

SQL Developer Responsibilities:

• Involved in detailed discussions with the business to understand the fuel line of business and document the same Prepare To-be business processes in the consolidated environment
• Prepare / review functional design document addressing the changes needed in the interface from PDI Enterprise to Oracle R12 for fuel invoices and journal entries Review technical design document
• Validate the business process, provide feedback and resolve issues Involved in supporting business users during User Acceptance testing Contribute to preparation of production cut off document

Confidential — Stamford

Technology: Oracle Applications 12.1.3 — Financial Accounting Hub, GL, SLA, SQL, SQL Developer, HP ALM, SQL Server Domain

Responsibilities:

• Perform detailed requirement analysis and clarify queries with Business Users Prepare functional process flows related to Insurance calculation components Review Oracle R12 functional / technical specification document for RICE objects
• Participate and contribute to CRP sessions and facilitate discussions between business and project stakeholders Identify Integration scenarios for various business process flows
• Map requirements to Test Cases in HP ALM to establish traceability and ensure complete requirements coverage
• Validate business requirements for various components like Premium Actual, Premium Accrual, Expenses Actual, Expense Accrual, Premium Tax, Unearned Premium Reserve (UPR), Deferred Acquisition Cost (DAC), Internal Quota Share, Claims, Cash
• Validate interface between Hyperion DRM, PeopleSoft and Oracle EBS and verify master data like COA values, Cross Validation Rules, Exchange Rates are interfaced correctly alidate import of daily / monthly transaction data from insurance and corporate applications to FAH stage tables, populate Transaction Objects, create events and verify accounting as per ADRs
• Verify consolidation in Reporting Ledger across all XL group companies
• Validate setup / configuration of FAH Event Model, Entity, Event Classes, Event Types, Transaction Objects, JLT, ADR, JLD, AAD, SLAM as per BR100 document Validate setup of Primary and Secondary ledgers, Cross Validation Rules in R12 Perform reconciliation by comparing Trial Balance report in FAH / EBS / PeopleSoft Validate Revaluation in Oracle GL and verify results
• Review Integration Test Strategy and Integration Test Plan documents, participate in defect triage meetings