SUMMARY

• Over 10+ years of experience in the Information Technology with full system application development life cycle (SDLC) experience ranging from analysis & design, development, testing, implementation, documentation and production support
• Actively involved in end to end implementation of 5 different legacy system to Oracle EBS with focus in procurement suite of products.
• Participated from requirements gathering to design to implementation to support from the beginning.
• Expertise in Oracle EBS Procure To Pay (P2P) and Order To Cash (O2C) modules - Inventory (INV), Purchasing (PO), General Ledger (GL), Accounts Payable (AP), Order Management (OM).
• Extensive experience in Procure To Pay and Order To Cash Business flows.
• Implemented iSupplier and iProcurement modules.
• Functional knowledge in Human Resources (HR) and Oracle Self Service Human Resources (SSHR).
• Expert knowledge in integrating 3rd party software.
• Good working knowledge in Oracle AIM methodology.
• Experiencing in configurations and setups of all procure to pay modules.
• Proficient in creating User Requirement Specification, Functional Specification and Business Process Flow.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance testing (UAT)
• Part of the Production Support team helping user for resolve any production critical issues.
• Extensive experience in conducting training sessions for users to give them knowledge about how the system is going to work.
• Good documentation skills and proficient in Microsoft Office
• Good organization skills and ability to interact at all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well proven track in achieving the timeline for deliverables
• Highly motivated with excellent interpersonal and communication skills.

TECHNICAL SKILLS

Operating System: Windows, Unix/Linux

Database System: SQL Server, Oracle (12x)

Database Language: PL/SQL, T-SQL, MySQL

Hardware: PC Troubleshooting, Assembly, Installation

EBS Modules: INV, PO, AP, OM, AR, iProcurement, iSupplier

Other EBS: Product Data Hub (PDH)

Other: Informatica (ETL), Informatica CDC, Unix Shell Microsoft (Excel, Word, PowerPoint, Vision, Projects), Visual Studio, C#, SSIS (Sql Server Integration Services), SQL Developer, PL/SQL Developer, Data Warehouse, Oracle EBS, APICS, Six Sigma, Project Management, Implementation, Integration, JIRA, Confluence, HP Quality Center, HP Project and Portfolio Management

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Oracle Solution Analyst

Responsibilities:

• Managed team for daily support of Oracle production, enhancement projects and other initiatives related to Oracle ERP.
• Provided daily support for 3rd party applications and Custom applications.
• Highly experience working in Oracle EBS Procure to Pay (P2P) and Order To Cash (O2C) modules that includes of iProcurement, iSupplier, Purchasing, Receiving, Inventory, Account Payables, Order Management
• Perform setups and configurations necessary across multiple Oracle EBS modules like Purchasing, Order Management, HR, Payables etc. as per business requirement.
• Setup Buyers, Bill-To, Ship-To, Freight Terms, FOB and Account Expense Rule in Purchasing module.
• Setup Customers, Bill-To, Ship-To, Sales Person, Transaction Types, Document Sequencing, Price List, Shipping Methods and Payment Terms in Order Management module.
• Setup new Descriptive Flex Fields (DFF) for reporting purposes or for other business needs.
• Updated Profile Options as required to change the behavior of an application.
• Expert in designing, guiding development, testing and deploying Reports, Interfaces, Customizations, Extensions and Workflows (RICEW) to address custom business needs.
• Worked with the development team onsite/offshore model in reviewing the technical design, validating that the development delivers to the design.
• Provide functional analysis, design, configuration and testing support for Oracle and the other 3rd party/custom application in scope.
• Maintain knowledge of current and future functionality and capabilities around Oracle application.
• Actively worked on HR module to update the Jobs, Position and Supervisor information for approval routing.
• Built interfaces for disparate system to communicate effectively and efficiently.
• Perform Oracle form personalization as per the business requirement.
• Help modify current approval process that were too complicated and prone to error.
• Assess, prioritize, and enlist appropriate resources to support requirements and issues, and facilitates entry of project requests into the IT Project Life Cycle (ITPLC)
• Interpret and translate business process requirements into Oracle capability, effectively and rapidly, assuring continuity with instance setups and compliance with standards
• Designed transactional capture to enable production of information for execution and business performance analysis
• Collaborated with the Business Solution Managers in order to implement data standards and provide technical requirements to enable compliance.
• Facilitate and mediate optimal setup requirements for business process design; and assist in ongoing development of KPI measurements
• Facilitate rapid delivery test instance environments for business units on-boarding to Oracle or for development of new requirements for value propositions.
• Drive documentation, escalation and resolution of instance constraints, technical problems or availability issues (e.g. errant configurations bugs, table sizing, indexing)
• Participate in User Acceptance Testing and user training
• Meeting(s) with relevant operating company functional managers, subject matter expert (SMEs) to determine new functionality or enhancements that may be required, and translating those requests into business requirements.
• Provide Quality Assurance (QA) and testing as needed
• Promote and participate in the Project Management (PM) methodology

Confidential, Houston, TX

Oracle EBS Supply Chain Business Analyst

Responsibilities:

• Successfully converted 5 legacy systems to Oracle EBS suite focusing on supply chain modules.
• Actively been part of the end to end implementation of multiple legacy system into Oracle EBS.
• Act as a primary go to person for all the Purchasing and Payables requirements.
• Configuring the application modules based on the business requirements
• Performed Purchasing and Payables setups like Payment Terms, PO Lookups, Purchasing Options, Payables Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees
• Analyzed and verified existing Setup and Configurations are working as intended
• Assisted Finance team in setting up Fiscal Calendar, Functional Currencies, Chart of Accounts and Accounting Conventions.
• Helped create General Ledger (GL) and Operating Unit (OU)
• Captured the business processes in form of scenario matrix for testing various process alternatives
• Tested the new developed components and custom objects as per the business needs.
• Successfully completed Purchasing, Payables and Inventory conversion data from legacy system
• Good understanding on Approval hierarchy and Approval Management Engine (AME)
• Ability to interact directly with client and/or end users / Super users to solicit information and define solution requirements.
• Set up Assignment Set, Sourcing Rules and the Approved Supplier List.
• Set up vendors and vendor sites on multiple Operating Units(OU)
• Customized forms with descriptive flex fields (DFF) to capture additional information.
• Assist users in creating Standard Purchase order and Blanket agreement.
• Provided post Production Support and assisted user community with all the issues.
• Established and drove Conference Room Pilots (CRP) from start to finish.
• Conducted User Acceptance Testing (UAT - End to End Integration testing.
• Conducted meetings with Super Users/SME’s to gather requirements for Procure To Pay and documented in BR-30.
• Worked closely with finance user team and oracle finance consultant on issues like Intercompany invoicing, auto invoicing, tax codes and inventory valuation and resolved them by explaining the standard Oracle functionality.
• Worked closely with on site and off site technical team on Master and Transactional data conversion and validation issues.

Informatica ETL Developer

Confidential

Responsibilities:

• Successfully designed, developed, tested ETL code and implemented on 9 US and 5 International facilities into Oracle EBS.
• Performed all the conversion projects on time and within scope that ultimately saved company hundred and thousands of dollars.
• Designed and developed database objects like tables, store procedure, triggers, cursors etc. on SQL Server and Oracle using T-SQL and PL/SQL.
• Ensure accuracy & integrity of data & applications through analysis, coding, documentation & problem resolution.
• Analyze & translate functional specifications & change requests into technical specifications.
• Develop, test & implement program logic.
• Translate business needs into end user applications.
• Design and implement Extract, Transformation and Load (ETL) processes, programs and scripts using Informatica Integration Tool.
• Assist with design and implementation of data warehouse and reporting.
• Successfully designed and implemented ETL processes for multi million dollars project within the time and scope.
• Perform critical update in production server by designing, developing, testing and implementing ETL processes through Informatica.

Confidential, OMAHA, NE

Voice Services Manager/Project Manager

Responsibilities:

• Managed project development from beginning to end.
• Defined project scope, goals and deliverables that support business goals.
• Help Company saved significant amount of money by completing all the projects within time and scope.
• Effectively communicated project plans and expectations to team members and stakeholders in a timely and clear fashion.
• Identified and resolved issues and conflicts within the project team.
• Identified and manage project dependencies and critical path.
• Kept record of project milestones and deliverables.
• Developed best practices and lesson learn documentation for management.
• Responsible and 100% accountable for proactively coordinating and managing complex voice lifecycle support for clients.
• Provide complex voice aftermarket ordering and service support.