EXPERIENCE SUMMARY:

• Working on Oracle EBS for over 8 years, serving over various roles as Oracle Programmer Analyst (Cognitive Artificial Intelligence), Oracle Financial consultant (Yahoo Inc.), as Business Analyst and exposure to Development and maintenance activities (Keane Inc.), Development and Enhancement activities (IBM).
• Experience in working platforms such as Search and display advertising, Health care industry, Banking and IT Services.
• Wide - range of experience performing requirement gathering, fit/gap analysis, functional specification design, unit and integration testing, data conversion, documentation, user training, production and post-production support.
• Experience in Upgrade projects, Post Implementation Support and Business Development.
• Validated teh existing business processes with reference to Oracle Apps standard process.
• Set up Flex fields (Key and Descriptive) as per client requirements, created Value Sets and assigned values to teh Value Sets, System Profile Options. Define Users, Responsibility etc.
• Experience in large commercial systems involving various aspects of software development life cycle, which includes requirement gathering, design, coding, testing, product-solution implementation and end-user support.
• Testing of new functionalities, Writing Work Instructions, and Imparting Training to teh user community.
• Working experience in Oracle financial module: Oracle General Ledger and Receivables. Hands on experience in Accounting Setup Manager including creation of Legal Entity, Ledger (with 4C’s), completing Ledger options and assigning balancing segment values.
• Expertise in AR, AP, GL and iPayments.
• Have good understanding of teh functional concepts in Order Management (OM) includes Order to Cash, Pricing and Inventory. Work experience in Project Planning and Costing module.
• Have good understanding and Hands on experience on developing and implementing demands on Oracle CRM modules: Service Contracts (SC) and Installed Base (IB).
• Hands on coding and design experience in SQL and PL-SQL procedures, packages and functions. Also have working experience with API’s (Application Programming Interfaces).
• Experience in developing Interfaces. Working experience with SQL Loaders.
• Experience in development of forms using Oracle Form builder 6i and 10g.
• Experience in development of reports using Oracle Reports builder 6i, 10g and XML Publisher.
• Have experience in Customizing Oracle Apps Framework pages (OAF).
• Having sound knowledge in various stages of software development life cycle (SDLC) gathering and analyzing teh requirements, converting teh specifications into functional and technical design documents, coding and testing.
• Customization during implementation and documentation using AIM (Oracle Application Implementation methodology) for optimizing functionality.
• Excellent communication skills with leadership qualities & open to innovative ideas to develop a creative solution for challenging client needs.

TECHNICAL SKILL SETS:

Operating Systems: Windows XP, Unix, Windows 98/2000.

Programming Languages: PL-SQL

Databases: Oracle 9i, Oracle 10g, Oracle 11g.

Oracle Development Tools: Oracle Forms 6i/10g, Oracle Reports 6i/10g, XML Publisher

Version Control Tools: Serena ChangeMan Version Manager (PVCS), Visual Source Safe

Tools: SQL Developer, Toad, JDeveloper.

Documentation: BR100, MD050, MD070, MD120, TE020, TE040, UD, UTP documents

Training Undergone: Oracle Workflow, BOM, Manufacturing

Test Management Tool: Quality Center, Elementool

PROFESSIONAL EXPERIENCE

Confidential

Oracle EBS Programmer Analyst

Responsibilities:

• Organize sessions with Finance heads and Business Leads to understand teh way teh business is conducted at present and find out teh opportunity for improvements.
• Converting requirements into End to End Flows, preparation of Oracle ERP Functional Designs and Technical Solution Architecture documents.
• A Solution Owner for a set reports which breaks down teh revenue, actual and estimated cost into teh project and specific task.
• Work with other BSAs to design, develop and implement business user requirements both in production support and SFDC project issues.
• Work with key members of various departments and other members of teh development team to identify and resolve application issues, system enhancements, and new user requirements.
• Assist with system projects, functioning as teh subject matter expert for teh system and reviewing requirements documentation to ensure they are accurate and comprehensive.
• Prepare and execute as needed test cases and scripts.
• Support production support team by assisting in application of patches, change control and coordination of system availability. Conduct research and testing of patches necessary to correct bugs and enhance system functionality.

Confidential

Oracle EBS Business Analyst

Responsibilities:

• Teh primary area of responsibility is to gather teh requirements from users and document it in both high level and detail level.
• Understanding teh business needs from users, design a new user interface pages in iStore for new user registration and for maintaining profiles of existing users.
• Writing detail level design document and MD050.
• Support teh existing production system.
• Perform integrated system testing and analyze any discrepancies after applying patches (TE040).
• Handling Payment system and accounting related issues.

Confidential

Oracle EBS Business Analyst

Responsibilities:

• System Testing on Oracle modules AR, AP, GL, INV, OM, OCO and iStore.
• Identify patches and apply it on various environments.
• Co-ordinate teh functional and DBA steps to be executed at migration.

American Express

Oracle EBS Business Analyst

Responsibilities:

• Involved in Requirements Analysis, Functional Design, Data Mapping and Client Interaction.
• Guided teh technical team to develop tables, views, various SQL queries, stored procedures, functions, packages, triggers to pull teh required data from FEM schema.
• Wrote teh documents MD050, TE020 and MD120.
• Developed teh scripts needed for migration and registered concurrent programs and performed unit testing.
• Managed teh smooth deployment and migration working with DBAs.
• Capture functional requirements and translation into technical requirements.
• Focusing on functional solutions for teh enhancements assigned.
• Verify and correct MD070 and made it sync with MD050, prepare installation routine MD120 and unit test TE20 for teh requirement.
• Defined teh concurrent programs and required values sets for teh parameters in teh system.
• Owner for teh entire development life cycle.
• SPOC for User Acceptance Testing by Customer.
• Involved in Post production Support, work involved supporting Apps, support in Training.
• Created Users and assigned Responsibilities.
• Defined and set up System Profile Options for granting and limiting user level access.
• Developed teh Organization Structure, Sets of Books and Created Chart of Accounts.
• Set up Flex fields (Key and Descriptive) as per client requirements, created Value Sets and assigned values to teh Value Sets.

Confidential

Oracle EBS Techno Functional

Responsibilities:

• Capture functional requirements and translate dat into technical requirements.
• Developed and documented teh technical design MD070 for teh three reports.
• Coded teh entire enhancement using PL/SQL packages and procedures.
• Provided required shell scripts for deployment, TE020 and MD120 documents.
• Defined teh concurrent programs and required values sets for teh parameters in teh system.
• Define a new look up in teh custom module.
• Execute teh test cases based on Work Request criteria and perform.
• Provided solutions for issues raised oven system testing and unit testing by regularly interacting with teh client.
• Have done performance tuning and made teh concurrent programs fast and efficient.
• Owner teh entire development life cycle.
• Co-ordination with teh offshore team regarding deliverable and testing efforts.

Confidential

Oracle Apps Business Analyst

Responsibilities:

• Developed three new forms using TEMPLATE.fmb according to teh above client’s requirements.
• Implemented master detail relationship in forms.
• Did form personalization like adding new menu entries into teh existing Form menu using teh Action type ‘SPECIAL’. Added functionalities like opening another form from teh existing form etc.
• Performed application development task for deploying teh forms in teh application like defining Form, Function and attaching dat to responsibility.
• Involved in entire life cycle of teh project until deployment and post production support.
• Provided required technical documentation.
• Registered custom applications, forms, tables and flex fields.
• Extended functional support and testing for teh OE operations, including Order to Auto-invoicing and customer and inventory setups.
• Defined price lists & modifiers with qualifiers.
• Setup Freight Charge lists and pricing formulas.
• Configured item attribute controls and set up various item templates.
• Setup UOM, UOM classes.
• Defined organizations and their inventory parameters.
• Defined various transaction types and assigned document sequences.
• Modified processing constraints and defaulting rules.

Confidential

Oracle Apps Techno functional consultant

Responsibilities:

• Handled all teh enhancements and maintenance requests for teh client on Service Contracts module. Have done customization and maintenance activities in existing Forms, Reports and Concurrent Programs.
• Designed and developed stored and application procedures, packages, database triggers and functions using PL/SQL.
• Single point of contact for all technical issues in teh SC module.
• Have good understanding of functional concept and base table structure involved in OM. Have very good understanding of O2C and P2P cycle.
• Handled maintenance requests and fixes as per teh requirement in OM, PO and INV. Have worked with APIs of respective modules.
• Have very good understanding of teh functional concept in Receivables. Handled month end issues and fixes in AR module. Fixed code issues in AR custom programs. Possess sound knowledge in Invoice processing.
• Familiar with Auto lockbox, Auto accounting, Invoice Processing and Reconciliation process etc.
• Performed system administration tasks such as creation of users, Responsibilities, Menus, Functions, Value sets etc.
• Have good knowledge of teh concept and underlying tables of Oracle Trading Community Architecture (TCA)
• My role included providing technical solution using Oracle Applications API’s and customization using PL-SQL to meet functional requirements. me was also involved in Identifying quality fixes for customer reported problems, coding in PL-SQL, Peer code reviews, writing unit tests for releases and executing these to ensure teh quality of teh product.
• End to End Support for enhancements reported by teh customer and team, writing teh entire technical design including identifying teh re-usable core functionality, design custom tables and PL-SQL API to realize teh requirement.
• Involved in post-production support.
• Providing estimates for enhancements and maintenance defect fixes.
• Coordinated development effort and led a team of 4 - 6 people starting Mar 2008.
• Interact with Oracle support team for troubleshooting and resolving standard issues (TARs).
• Mentoring lateral and new graduate recruits and train peer staffs.
• Development of new custom Forms and Reports and customization of existing Forms and Reports.
• Have done customization in OAF page like Extending VO, Extending CO and modifying controllers.

Confidential, Blue Bell, PA

Oracle Apps Developer

Responsibilities:

• Developed both Inbound and outbound interface independently.
• Developed code to read input data from CSV file using SQL Loader and collected it into newly created custom tables.
• Required data validations were coded using PL/SQL packages and programmed it.
• Required data updates and modifications were done using Oracle standard APIs.
• Output data were FTP’d to a different server and spooled to a CSV file.
• Handled a smooth migration until production instance.
• Took complete ownership of teh project and involved in complete project life cycle UAT bug fixing and Post production support.
• Prepared all teh needed documents like MD070, TE020, MD120 etc.