EXPERIENCE SUMMARY:

• I have around 9 years of experience as a Techno - Functional Consultant in Oracle Applications ERP (R12, 11i) and ETL Informatica/ODI Developer, OBIEE and BI Publisher Reports Developer.
• I have hands-on experience with OBIA 11g implementation with BIACM, FSM, ODI and OBIEE components.
• Experience in Software Analysis, Data modeling, Design, Development and Testing in ORACLE based Data warehousing and Client-Server technologies. I have been involved in all phases of the SDLC as well as a release cycle of a product and have excellent understanding of Data warehousing concepts.
• Extensively worked in Oracle back-end programming and Front-end development using tools like TOAD, PL/SQL*Plus, SQL Developer SQL*Loader, Oracle*Forms 10g/6.0, Oracle*Reports 10g/6.0, BI Publisher, Discoverer, WED ADI, Business Events, Oracle Alerts.
• Extensive experience in Implementations, version upgrades, Personalization, data conversions, customization of Reports and Forms in Oracle Applications.
• Experienced in debugging, testing and deploying the applications designed and developed interactive GUI screens and reports using oracle forms/reports, creating LDT files and creation of SR with Oracle Support, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
• Strong programming experience in creating Procedures, API, Packages, Functions, Triggers and other database objects using SQL, PL/SQL, UTL File and UNIX etc.
• Possess knowledge on Workflow, OAF and SOA.
• Experience in Application Object Library (AOL) such as creating custom responsibilities, custom menus, menus exclusion, form functions, Concurrent programs, creating value sets, profile options, messages, look ups, list of values, Flex Fields.
• Good understanding of MOAC Impact on custom programs development like reports and forms.
• Experienced in preparing Technical specs (MD070), Functional Specs (MD050), Installation Documents (MD120), User Training Documents, test procedures document preparation using SDLC/AIM methodology.
• Good skills in the use of Informatica Power Center and Oracle RDBMS. I have also been involved in the performance tuning of Informatica mappings and stored procedures.
• Experience in requirements gathering analysis, data mapping, data migration, and application remediation across different platforms enabling usage of standard ETL platform for improved processing power, standardized infrastructure.
• Knowledge of complete Software Development Lifecycle including requirement analysis, design, development, implementation and testing.
• Experience in interacting with the off-shore development team.
• Strong analytical, Inter-personal and communication skills.

TECHNICAL SKILLS:

RDBMS: Oracle RDBMS 9i, 10g, 11g and R12

Development Tools: ETL - Informatica PowerCenter Designer, Workflow designer, workflow manager and repository manager, Metadata Manager, ODI ERP - Developer 2000, BI Publisher, and Oracle Forms 10g/9i/6i, Reports 10g/9i/6i, OA Framework, BI Discoverer BI - OBIA, OBIEE

Tools: SQL Loader, SQL PLUS, TOAD, SQL Developer, BI Publisher, OBIEE (RPD)

Languages: C, C++, UNIX, SQL, PL/SQL.

ETL: Informatica, ODI

ERP: Oracle Apps 11i, R12 (TCA).

PROFESSIONAL EXPERIENCE:

Confidential

OBIEE Developer

Responsibilities:

• I have worked closely with users to provide enhancements and defect resolutions in OBIEE.
• Worked with an implementation team on all major stages of a development lifecycle throughout multiple releases of a reporting platform transition.
• Designed, developed and tested OBIEE reports and dashboards using advanced OBIEE functionality to satisfy client requirements.
• I served as a proctor to one HHS OpDivs. I supported creation and communication of release schedule with client.
• I also facilitated SIT and UAT testing, test script creation and result documentation to ensure successful testing.

Confidential

SR. Oracle Apps Technical Consultant

Responsibilities:

• Responsible for time management to each and every component and assigning to team mates.
• Responsible to monitor daily activity on team mates to meet project timelines.
• Developed new Oracle Reports in HRMS, AP, AR, FA Module using reporting tool BI Publisher / BI Discoverer
• Leading HRMS (Core HR, Payroll, Advanced Benefits) stream of the project.
• Doing the Data migration activities of Core HR/Payroll through conversion scripts(like personal, assignment, job, position, grade, qualifications, phones, SIT's, initial balance, bank details, element entry, pay proposals etc)
• Development of new reports and customization using Reports.(BI publisher, rdf Reports)
• Analysis of Report/Interface Specifications and preparing CV040, CV060, CV070, CV120, MD50,MD120,BR100 and MD 070.
• Adding additional parameters and value sets for upgraded concurrent programs.
• Preparing and capturing test cases for each component for Ondemand Oracle Support Conversion.
• Creation of new Product effective from given date.
• Creation of new job effective from given date.
• Creation of new department effective from given date.
• Loading the AP Invoices from the legacy system to Oracle Apps using Custom Interface.

Environment: Oracle Applications R12 Human Resource Management System (HRMS), Financials (AP, AR, GL, CM), Fixed Asset (FA), SQL, PL/SQL, D2K (Forms and Reports 10g), BI Publisher with RDF Reports.

Confidential

SR. Oracle Apps Technical Consultant

Responsibilities:

• Upgrading the code in old reports to work in R12 version in SCM and financial modules.
• Upgrading the custom oracle forms from 11i to R12 and also done minor changes to add on functionality.
• Developing new BI Publisher reports in Oracle Finance Module i.e. Aging Report, Deferred Revenue, Item / Account wise Revenue, etc.
• Upgrading forms personalization from 11i to R12.
• Upgrading the Alerts from 11i to R12.
• Adding additional parameters and value sets for upgraded concurrent programs.
• Developing the new discoverer reports to meet client requirements in R12.
• Responsible for unit testing and comparing out puts in 11i and R12 for various test cases.
• Preparing and capturing test cases for each component.
• Responsible for creating LDT files for concurrent programs.
• Responsible for preparing MD-70 for each component by using AIM.
• Responsible for loading the data from old legacy system to Oracle R12 System using SQL Loader, APIs.
• Requirement gathering and solution designing for implementing the design of common error handling process across all interfaces.
• Testing all the functionalities if it’s working as intended Post Upgrade Process from 12.1.1 to 12.1.3
• Developed the error handling process in the interfaces for OM and AR.
• Developed the form for end user to view and correct each individual error in all interfaces.
• Developed report to view the errors in all interfaces.
• Prepared the error handling process user guide for all the interfaces.
• Prepared the document for consolidating all the custom objects for support team reference.
• Prepared the Master BR100 for AR, Sys Admin and GL across all the customization.

Environment: Oracle Applications R12 Financials (AP, AR, GL), Cash Management, Purchasing Modules (PO), Supply Chain Modules (OM, INV), Fixed Asset (FA), SQL, PL/SQL, TOAD, D2K (Forms and Reports).

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Developed Vendor conversion program to import vendors from the legacy system into Oracle with required validations.
• Designed and developed reports using combination of Report 6i and BI publisher for modules like Purchasing, Payables, Receivables and Order management.
• Developed reports in Discoverer and created various business areas, user views, custom folders and joins for reporting. Created Workbooks based on the Custom Folders with multiple parameters and calculations using Discoverer Plus and Discoverer Desktop.
• Involved in Workflow customization for approval hierarchy level in Purchasing.
• Created several Requests and Request Set to attach the PL/SQL procedures, Reports with Application.
• Created packages, procedures, functions, synonyms, tables, views, cursors, indexes, database links, triggers etc.
• Handling Configuration management related activities like maintaining the source code. Interaction with the team during technical discussions and development process.
• Defining New Users, Creating Responsibilities and assign responsibilities to the Users
• Defining Request Groups, functions, menus, Assigning Request Group to Users.
• Defining Key flexfields and values sets.

Environment: Oracle Applications 9i (AR, AP, GL, PO, FA, CM), Forms 10g, Reports 10g, PL/SQL, Toad 9.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Worked with the end user and FA's for requirement gathering and solution designing.
• Designed interface for Journal data upload in oracle General Ledger.
• Worked on mapping of account code values for Varian (Agilent's subsidiary) and Agilent's Chart of Accounts for journal data interface.
• Developed customized report for Journal reconciliation and error report for data validation error.
• Prepared the MD070 for all customizations.
• Worked on debugging production issues of importing a Journal data.
• Defining concurrent programs, executable, forms, request set, values set.
• Worked on the design and approach to correct the customer addresses in production environment.
• Developed an interface to load the new customers in Oracle application.
• Developed custom forms using Oracle Forms 10g.

Environment: Oracle Applications 11.5.10 Financials (GL, AR, AP FA CM), SQL, PL/SQL, TOAD, Oracle D2K (Forms and Reports)

Confidential

Techno-functional Consultant

Responsibilities:

• Interacted with the functional team to understand the business and user requirements
• Developed PL/SQL program to perform validations and to move the AR data from staging table to interface tables
• Designed and customized the following reports using Oracle Reports Builder in SCM and Finance Modules (AP, AR, GL)
• HR Report to give details of the Employees, their reporting Manager, VP details, project they are working on, etc.
• Creating dump of different data according to the user’s requirement in AP, AR, GL, CM, PO, and INV, HR, FA.
• Created API to upload Equity in the system.
• Creating complex queries for Decision Support Systems and integrating with Financial, Human Resources and ERP systems
• Good Experience with writing functional, technical documentation and User Manuals

Environment: Oracle Applications (GL, AP, OM, PO, AR, CM, HR), UNIX, Reports and forms, PL/SQL, SQL*Loader and Toad