SUMMARY:

• Senior Oracle E - Businees Suite Applications ERP Techno-Functional Consultant with 13+ years strong experience in Software implementation and support projects. Strong functional expertise on Financials and Supply Chain modules
• Experienced in Developing, Customizing and Implementation General Ledger (GL), Account Payables (AP), Account Receivables (AR), Fixed Asset (FA), Cash Management (CM), Purchase Order (PO), Inventory (INV), Order Management (OM), Bill of Materials (BOM), Work In Process (WIP), Project Accounting (PA), Human Resources (HR), Material Resource Planning (MRP), Oracle Process Manufacturing (OPM), Quality (QA)
• Implementation of Order-to-Cash & Procure-to-Pay Business Process flows of Oracle EBS Applicaitons R12/11i
• Experience in Implementation and RICE Customization of Oracle EBS Applications Release 12/11i modules.
• Experience in database programming using Oracle 8i/9i/10g/11g databases.
• Expertise in creating Procedures, Functions, Packages, Triggers and other DB objects using SQL and PL/SQL.
• Experience in Tuning SQL statements to improve execution performance using TKPROF, SQL Trace, etc.
• Good knowledge on end to end data flow in Oracle EBS Applications
• Experience in conversion of standard Oracle reports using BI/XML publisher
• Expertise in data analysis and data mapping

TECHNICAL SKILLS:

Applications: Oracle E-Business Suite 11i, R12Modules:PO, OM, INV, AP, AR, GL, FA, CM, HRMS, OPM, WIP, BOM,MRP, Quality

Programming languages: SQL, PLSQL, C, COBAL, Java

Database: Oracle8i, 9i, 10g, 11g

Oracle Products: Oracle Developer Suite 6i&10g, Oracle BI Publisher, SQL*Plus, SQL*Loader

Other Tools: Optio 7.8, Toad, Kintana ITG, Stat, Test Director, WinCVS, PVCS, WinScp, Putty, SQL Developer, JIRA, SAP BO 4.1, HP ALM, VSM

PROFESSIONAL EXPERIENCE:

Confidential, MA

Techno Functional Consultant

Responsibilities:

• Perform Impact Analysis for BO 4.1 reports due to Oracle EBS Applications R12 upgrade
• Design entity relationship diagram for Universe with Oracle Applciations R12 tables and custom tables
• Identify the functionalities difference between 11i & R12 and bring in new R12 tables, remove obsolete tables, build proper joins between standard tables and custom tables in Universe and reports
• Evaluating requirements, work with BO dev team and product managers to provide solutions to end users
• Review the Functional Specification and prepare technical specifications for reports
• Second level of review on developed reports the ensure the coding standings and performance
• Test reports and verify the report pulls data for the periods before and after R12 upgrade
• Develop complex freehand SQL which would be source for reports and performance tuning
• Provide assistance during user acceptance testing and own the responsibility for deliverables
• Interact with business users to understand the business needs and for clarifications
• Worked on maintaining the quality standards on BO, Universe and report level
• Update, Track and manage defects in HP ALM tool
• Responsible for onsite and offshore communication and coordination
• Provide post production support and interact with business stakeholders and users throughout the ticket lifecycle

Environment: Oracle EBS Applications R12 (AP, AR, GL, FA, PA, PO, OM, INV, OPM), SAP BO 4.1

Confidential

Techno Functional Consultant

Responsibilities:

• Analyze legacy application data (Monogram, Kubra, Vanco, Volta) and identify data mappings for interfaces
• Prepare Functional Specification, Technical Specification, BR100, TE020, MD120, User manuals.
• Design and develop interface programs to bring in master data, transactional and custom data used for interest calculation and ratings from legacy application to Oracle EBS Applications
• Automation of Invoice Processing and email invoices to customers
• Prepare data flow diagrams and data mapping documents for interfaces
• Identify opportunities for process optimization, process redesign and development of new process
• Coordinate delivery of development and production releases that meet quality assurance standards
• Develop custom reports using BI publisher
• Status report & customer reviews on regular basis
• Lead technical team in design and development tasks
• Lead testing team in creating test plans and testing efforts
• Anticipate consequences of actions and potential problems
• Set and meet realistic deadlines
• Provide post go live production support

Environment: Oracle EBS Application R12 (AP, AR, GL, FA, CM)

Confidential

Techno Functional Consultant

Responsibilities:

• Analyze legacy system and prepare data mapping document for Oracle EBS Application
• Provide data mapping for conversion & interfaces from custom application and validate master data
• Develop conversions for suppliers, customers, inventory items, item categories, Price list
• Review functional specification document and prepare technical design documents
• Develop custom API’s, custom reports using BI Publisher
• Responsible for code review and test cases review
• Responsible for migration of components to Production Instance
• Mentor team members on technical activities
• Conduct SIT, UAT and to Business users
• Provide post production support.

Environment: Oracle EBS Application R12 (AP, AR, GL, PO, OM, INV, OPM, QA)

Confidential

Techno Functional Consultant

Responsibilities:

• Responsible for Project execution, Co-ordination activities, Requirements analysis, effort estimation
• Prepare documents for RRC (Requirement Review Committee) meeting and freeze Request
• Review of Functional Specification and prepare Technical design documents
• Provide data mapping for conversions and interfaces
• Developed Customer &Transaction related conversions, Interfaces and reports
• Involved in co-ordination for setting up new bank to process auto lockbox interface
• Prepared Migration list, MD120 and created archive sets for migration using stat tool
• Coordinated with DBA’s for migration and validating the migrated objects
• Involved in and providing assistance to AR collectors and end users
• Resolving the post production issues.

Environment: Oracle EBS Application 11i (AR, GL)

Confidential

Project Lead / Techno Functional Consultant

Responsibilities:

• Involved in requirements analysis, review of Technical/Functional Specification documents
• Design and develop technical solutions to a pre-defined requirement and components including extensions, views, customizations, modifications, reports, independently and as a part of a team
• Meet service level agreements for production support response and resolution
• Resolving the production issues and provided day to day production support on Purchasing (PO), Order Management (OM), Inventory (INV), Work in process (WIP), Bill of Materials (BOM), Materials Requirement Planning (MRP) Modules.

Environment: Oracle EBS Application 11i (AP, AR, GL, FA, CM, PO, OM, INV, WIP, BOM, MRP)

Confidential

Project Lead / Techno Functional Consultant

Responsibilities:

• As a Project Lead, Involved in development of detailed Business Requirements Documents
• Responsible for design and development of reports
• Providing technical assistance to the team members
• Involved in code reviews and managing the deliverables to meet the time line
• Resolving the production issues.

Environment: Oracle EBS Application R12 (AP, AR, GL, FA, CM)

Confidential

Techno Functional Consultant

Responsibilities:

• Requirement gathering for Schedule & Dispatch custom application enhancement along with BA’s Design data modeling for Schedule & Dispatch enhancement
• Design entity relationship diagrams custom application and Oracle EBS applications integrations
• Proactively monitored the potential year end issues and resolving them in the system
• Resolving production issues related to integrations and performance tuning
• Enhance performance, Tuning code, reviewing table and applying indexes were needed
• Meet service level agreements for production support response and resolution
• Provided day to day production support on Purchase Order (PO), Order Management (OM), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Quality Modules
• Provided functional and technical support to Schedule & Dispatch (Shipping) Custom Application.

Environment: Oracle EBS Application 11i (AP, AR, GL, FA, CM, PO, OM, INV, WIP, BOM, MRP)

Confidential

Senior Software Engineer

Responsibilities:

• Requirements Analysis, review of Functional Specification docs
• Prepared documents like MD070, TE020 and MD120
• Proactively monitored the potential month end, Quarter end issues and resolving
• Resolving the p2 and p3 production issues
• Resolving the data corruption issues by providing data fixes and applying them
• Maintaining Technical BR100, object migration list, Defect/Enhancement list for the Monthly SR release
• Coordinating with MIS OPS (DBA) team for code migration to PROD environment
• Monitoring and controlling the object versions through ITG Kintana
• Developed XML layouts for Invoice printing
• Developed custom programs to bucket customers and send email notifications for Collections
• Provide technical assistance to the Informatica Team members for Oracle Apps data extract
• Prepare SQL Scripts for AP & AR module and create Oracle Views using base tables for ETL extract
• Performance tuning of SQL queries which was developed in VFBI Phase-1 Project.

Environment: Oracle EBS Application 11i (AP, AR, GL, PO, OM, INV, HRMS)

Confidential

Software Engineer

Responsibilities:

• Upgrade 10.7 Objects to 11.5.10, Customization of 11.5.10 standard objects as per the client requirements
• Provided Oracle EBS Application support
• Development of new reports according to client specifications
• Worked on enhancement requests involving the Oracle EBS Application customizations
• Prepared technical design document for the enhancement requests.

Environment: Oracle EBS Applications 11i (AP, AR, GL, FA, CM, PO, OM, INV)

Confidential

Software Engineer

Responsibilities:

• Prepared Technical Design Docs
• Developed interface programs, PO Interface and GL Interface
• Developed new reports and customized the existing one as per the client requirement
• Developed components including extensions, views, customizations, modifications, reports, as independently and a part of a team

Environment: Oracle EBS Applications 11i (AP, AR, GL, FA, CM PO, OM, INV)

Confidential

Software Engineer

Responsibilities:

• Prepared technical design documents
• Build Forms, Reports, Database Triggers, Stored Procedures and Functions

Environment: Oracle Developer 6i, Oracle 9i