PROFESSIONAL SUMMARY:

• Experienced IT professional with extensive experience in Oracle ERP Assignments Implementations, Production Support, Enhancements, Development and Customizations .
• Over 11 years of experience in IT industry that includes Techno-Functional in Oracle ERP for Ten years. Worked in various roles such as Consultant, Developer, Technical Lead, RICEW Lead, Business Analyst, Project Manager
• Extensive experience in Financial Modules General Ledger, Fixed Assets, Accounts Receivables and Accounts Payables , Order Management, Purchasing, Inventory Project Accounting, EBTax, TCA, IEO
• Have extensive knowledge in implementation, support and testing of Procure to Pay process P2P , Order to Cash O2C , Assets to GL FA2GL and Rate to Regime cycles.
• Strong experience in Oracle Database, Oracle Tools like Discoverer, ADI, SQL Loader, PL/SQL and adequate exposure to Reports Forms. Proficient in using utilities like Data-load etc which are used in system setup
• Extensive experience in Oracle open interface tables. Held positions where major responsibilities included coding and unit testing reports, interfaces, conversions and Extensions RICE of programs in an Oracle Applications environment
• Experience in System Administration activities like creation and maintenance of users, creating responsibilities, changing profile options, etc.,
• Extensively worked on AIM documents like RD50, BR100, MD050, MD070 and CV40. Also client specific documents like MD200 etc.,
• Worked as liaison between Business users, DWH team for creating a data model and BI reports.
• Extensive experience in identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored SR/TARs.
• Expertise in planning, estimation, presentation and developing design documentation using the AIM Methodology, MS Visio, MS Project, etc
• Extensively worked in conversions and interfaces, using standard interfaces and APIs.
• Expertise in Customizing Oracle reports and developing custom reports by using Report 9i/10g, Discoverer 4i/10g and BI/ XML Publisher.
• Hands on Experience in Customizing Oracle Forms with Forms personalization, Custom.pll on Forms 9i/6i
• Expert in preparing Technical specifications MD070 , Functional Specification MD050 , Conversion Mapping Documents CV050 , Installation Document MD-120
• Involved in 4 implementations, which includes full-cycle implementations. As well provided support during go live critical times and post-production maintenance phase to different clients.
• Extensive experience in PL/SQL procedures, functions, packages, triggers, UTL File, UNIX and Shell scripting
• Understanding the Oracle Applications base Tables, Views and Workflows for the Troubleshooting and resolution of Production issues.
• Ensured all Project deliverables are of high quality before implementing them to the production environment. Adhering to SLAs. FTR First Time Right and OND On Time Delivery
• Expert in coordinating with various teams that includes legacy systems, users, DBA team, clients and app-leads enabling competent production support
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Very good exposure in working at various geographical locations via USA, Europe and India

TECHNICAL SKILLS:

Database Oracle 11i and prior versions, MS Access.

Oracle Applications 12.1.3, 11i 11.5.9, 11.5.10.2 , 11.0.35

Oracle Apps Cycles O2C, P2P, FA2GL, R2R

Oracle Apps Modules Oracle Financials GL, FA, AR, AP, CE, EBTax, TCA

OM, Pur, IEO, PA PB, PC

Languages and Tools PL/SQL, MS Office

Front End/GUI D2K, Visual Basic

OS/Environment Windows 95/98, Windows NT, UNIX

Reporting Tools Oracle BI/ XML Publisher, Oracle FSG, Oracle Discoverer10g, Crystal Reports.

Utilities EDI, Oracle ADI, Dataload, SQL Tools, Toad, PL/SQL developer, SQL Loader, Kintana: Mercury, ServiceNow, TFS etc.

PROFESSIONAL EXPERIENCE:

Confidential

Lead Oracle Apps Techno Functional Consultant

Responsibilities:

• Lead system enhancement projects. Proper planning, distribution/ assigning work to enhancement team.
• Take the ownership of tickets logged by users and responsible for closing them before or on expected time.
• Creating on Functional MD50 , Technical MD70 design documents, presentation and seek approvals.
• Update maintain Configurations documents BR100 and Security documents BR110
• Production support and User support, adhering the SLAs. Provide update in ticketing tool. Debug and resolve the issues raised
• Jointly worked with the QA team in formulating the Test Cases Test Scenarios.
• Involved in Customization of Standard Oracle Reports
• Work with AP, AR, PO on various Oracle reports like Returns report, Purchase Order received not invoiced, Custom Asset report, Receipt Balancing report, AR Bill Balancing report, Vendor exposure report, Discount taken and lost report.
• Coordinate with users, enhancement team, leads for questions raised and tickets logged.
• Support UAT and SIT, and seek approvals. Create MD120 document and co-ordinate with migration team, test confirm the migrated objects.
• Perform sanity checks after instance is refreshed, and patches applied etc.,
• Work with key members of various departments and other members of the IT team to identify and resolve application issues, system enhancements.
• Perform SysAdmin activities that include Create users, provide them apt responsibilities
• Work with cross-functional teams to design and implement business process improvement strategies.
• Support of EDI 850 Purchase orders and 860 Purchase order revisions
• Designed and Developed Staging table, SQL Loader Control Program and Custom PL/SQL API to convert required Employees from Legacy System to Production.
• Designed and Developed Staging table, written a PL/SQL API for disabling Users
• Created Supplier History Report, with WHO columns in the report.

Technology: Oracle Applications: 12.1.3 AP, PA, AR, PB, GL, FA, OIE

Confidential

Lead Oracle Apps Techno Functional Consultant

Responsibilities:

• Work in business analysis, gathering requirements and preparing flow charts.
• Requirement gathering from the client for the enhancement and maintenance projects. Preparation of Estimation Documents, Functional and Technical Specs, development and migration of the change requests. Preparation of test scenarios and test cases
• Create EUL, Discoverer Folders and other Discoverer objects
• Take the ownership of tickets logged by users and responsible for closing them before or on expected time.
• Production support and User support for trading application.
• Used AIM methodology documentation by studying functional design document MD50 and created technical design document MD 070 for ATP Report.
• Extensively used form personalization on OM and Procurement forms
• Setting up and supporting the SO Processing Constraints, Defaulting rules, modifiers and qualifiers.
• Maintain custom Trading application. And support back to back sales order processing.
• Lead system enhancement projects. Proper planning, distribution/ assigning work to enhancement team.
• Developed Extracts in GL and AR modules and the extracted files are sent via FTP to other systems using the UNIX Shell Script
• Extensively worked on SQL Tuning and troubleshooting of Interfaces
• Developed PL/SQL scripts to load data from external system to Fixed Assets interface tables.
• Developed several Procedures and Database Triggers as per Business requirement
• Creating Generic reports in Discoverer for users and guiding them to create on their own reports according to their needs.
• Creating FSG reports, and BI/XML Publisher reports.
• System Admin activates that included security implementation using user and responsibilities setups.
• Work with cross-functional teams to design and implement business process improvement strategies.
• Defined Employees, Security Profiles, System Profiles, Define Payable Lookups, Expense Clearing Account, Expense Report Options, Expense Report Templates, Expense Types, Payment Terms, Pay Group, Payment priority. Defined various expense policies. Troubleshooting various issues from the end users relating to the expense reports they have raised. Helped in modifying the default accounts for the segments while raising the expense reports.
• Providing Adhoc data to business and other stake holders. Eg: Items setup in last month etc.

Technology: Oracle Applications AP, AR, GL, OM, INV, FA SreviceNow

Confidential

Business Analyst/ Lead Oracle Apps

Responsibilities:

• Designing the Reports and developing the SQL quires as and when required.
• Worked with team for gathering requirements for developing BI publisher reports.
• Involved in study of Jaros reports, preparing the Functional MD50 , and Technical MD70 design document.
• Developed an interfaces from AP, AR PA to transfer the payments, AR transactions project expenditures, events related data
• Designing the Reports and developing the SQL quires as and when required.
• Act as liaison between PA BI team and End users, Functional/ technical consultants of Oracle.
• Understand the requirement from the End-users for OLAP and doing the feasibility study. And provide the relevant information to the users as per data available in Oracle and setup in Oracle.
• To generate the SQL, this can be used by MS team to validate it in MS-server and eventually to create a report.
• BA for PGS Operations metrics and SM dashboard
• To monitor overall progress of engagement and address any resource concerns from a technical development standpoint
• Conducts training with end users on data availability.

Technology: Oracle Applications R11.5.10.2 R12.1.1 PA, AP, GL, AR

Confidential

Role: Business Analyst/ Lead Oracle Apps

Responsibilities:

• Designing the Reports and developing the SQL quires as and when required.
• Medium between BI team MS server, IQ4Bis, MSRS and End users, Functional/ technical consultants of Oracle.
• Understand the requirement from the End-users for OLAP and doing the feasibility study. And provide the relevant information to the users as per data available in Oracle and setup in Oracle.
• Designing the OLAP reports like Discount taken and lost, SR report etc., after gathering the requirements from users
• To generate the SQL, this can be used by MS team to validate it in MS-server and eventually to create a report.
• Help team whenever required technically

Technology: Oracle Applications R11.5.10.2, Oracle 9i, MSRS, IQ4Bis, etc.,

Confidential

Role: Lead Oracle Apps Techno Functional Consultant

Responsibilities:

• Responsible for understanding the CF250, functional solution document and design the technical solution. Creating MD200 GE Standard technical design document.
• Implementation and support of Accounts Receivables and Custom Costing module
• Perusing POC of design and approach reviewing PL/SQL stored procedures, packages, functions etc., for validating the data according to the business needs. Customization of reports and development of new forms
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications
• Created test scripts for UAT User Acceptance Testing in TE040 documentation with detailed testing of all the above modules
• Worked on debugging of PL/SQL code for automatic and manual update of Secondary priority
• Designed and developed the reusable components which are used across the tracks.
• Design and developed GL interface
• Registered customized Oracle reports and XML Publisher reports using System Administrator and Application Developer
• Worked with several other teams like ETL team etc.,
• Trained business owners and business end-users on OM, INV, PO, AR, AP and GL modules as part of User Training Strategy
• Responsible for two levels of CRP and SIT, Proper tracking of issues raised and changes requested and assigning work on priority to team.

Technology: Oracle Applications R11.5.10.2 AR, INV, GL, CST , Oracle 9i, UNIX, Reports 6i, PL/SQL, Toad 9.0 and XML Publisher, Workflow builder.

Confidential

Role: RICEW Lead

Responsibilities:

• Responsible for legacy systems data capabilities, provide extracts for SysTest and coordination with different teams.
• Involved in customizing workflows in Purchasing PO and Order Management OM , especially on Back to Back Sales Orders and RMA Process flow.
• Personalized Oracle Core Forms by using Form level, Item Level and Block Level Triggers in several modules such as GL, AR, AP, FA and OM, as per the Business requirements
• Coding in windows shell to enable File transfer between different protocols SFTP, FTPS, FTP and local shared drives.
• Designed and developed staging tables, conversion routines, custom PL/SQL on AP, AR Lockbox .
• Review technical deliverables FD's, TD's and keep track of the development work.
• Review, suggest and keep track of Legacy extracts and data cleaning.
• To participate in mock conversions/conversions and provide inputs.
• Developed Generic Packages using PL/SQL to build flat files to migrate data from Legacy to Oracle Systems. Wrote PLSQL Procedures, Packages, and Functions as of when required
• Responsible for RICEW Reports, Interfaces, Conversions, Extensions and Workflow work and be the point contact for all RICEW development related work.
• To code and extract data it is work relating to Oracle programing - SQL, PLSQL, and D2K. Configure and create Discoverer application and reports

Technology: Oracle Applications 11.5.10.2 OOD modules GL, AP, AR, CM, PO, OM, Oracle 9i PL/SQL , Oracle Form6i.Oracle Report6i

Confidential

Role: Lead Oracle Apps Techno Functional Consultant

Responsibilities:

• Production support and user support of Application
• Development work in Oracle Report6i and PL/SQL
• Handling daily tickets related to various user problems in GL.
• Month End Closing Activity For Hungary Business

Technology: Oracle Applications 11.5.10.2 modules GL, PO, AP, OM, AR and Inventory, Oracle 9i PL/SQL , Oracle Form6i.Oracle Report6i

Confidential

Role: Team-lead, Developer

Responsibilities:

• Production support and User support for CDR application.
• Providing 24 7 support and co-ordinate between various functional groups.
• Take the ownership of tickets logged by users and responsible for closing them before or on expected time.
• Lead system enhancement projects. Proper planning, distribution/ assigning work to team-members.
• Coordinating with users, offshore team and leads for questions raised and tickets logged.
• Work with key members of various departments and other members of the IT team to identify and resolve application issues, system enhancements, and new user requirements.
• Responsible for maintaining the Custom Maintenance Application, which is used for maintaining Flex Filed Values
• Creating End User Layer for Oracle Discoverer.
• Creating folders and other discoverer objects.
• Creating Generic reports in Discoverer for users and guiding them to create on their own reports according to their needs. Design and development of various processes related to check-in of files and their validations.
• Creating FSG reports.
• Creating users, providing them apt responsibilities adhering to SOx using kintana.
• Scheduling and monitoring of monthly/ quarterly/yearly processes. And fill the notification tool GE-PACT with proper timings of the run.
• Making manual Journal Entries/ reversals, reviewing and posting using ADI or by populating B tables.
• Enhancing PL/SQL scripts, forms and reports following the release procedure using kintana.
• Resolving the user related issues and making production changes using Wing-2-wing process.
• Maintaining the customizing the Oracle Workflow.
• Creating interface scripts to load the data from mainframe.
• Work with cross-functional teams to design and implement business process improvement strategies.
• Using of APIs for making user access changes like setting up the password expiration as 365 days, end-dating the set of users etc.,
• Providing data and coordinating with GE-IDM Identity Management .

Confidential

Role Team-lead, developer

Technology Oracle Financials 11.0.35

Responsibilities:

• Setup of SOB for Assets, Asset-key FF, Category FF, Location FF, Valuesets etc.,
• Creation of Dataload scripts. Populating key, Category and Location FF using Dataload.
• Development of Inbound Interface for Asset mass additions
• Creating Technical Specifications and Unit Test Cases
• Creating different level of users by giving proper responsibilities.
• Coding of SQL Queries, Triggers, and other PL/SQL codes
• Preparing, reviewing, deleting, and posting the mass additions.
• Mass additions of CIP, capitalized assets using stranded oracle interface using custom validations.
• Work with key members of various departments and other members of the team to identify and resolve application issues, system enhancements, and new user requirements.
• Involved in Integration testing, User acceptance testing and documentation.
• Adhering to standards and quality control processes, in accordance with GEAE protocols
• Creation of discoverer EUL, BA folders and generic reports.
• Creation of user manuals.