SUMMARY

• Over 15 years of experience in Information Technology field wif strong emphasis in OracleE - Business Suite Applications.
• Extensive ability to perform setups and implement and provide design solutions in EBS 12i and R12.1.3
• Strong familiarity in implementation and upgrade projects of Oracle ERP (EBS 12i and R12).
• Solid understanding of impact analysis in current business processes due to upgrade changes, enhancements and 3rd Parties integration.
• Experience in designing, coding, testing custom applications wif an integration to Oracle Applications or other custom applications.
• Strong exposure in preparation of high-level functional design documents (MD-50, MD-70, MD-120 and Test Cases.)
• Extensive noledge in custom application development, conversions, interfaces & reports.
• Implementation and technical expertise in Oracle Applications R12/12x, across teh discrete and financials modules such as general ledger (GL), payables (AP), receivables (AR), purchasing order (PO), inventory(INV), fixed asset, cash management.
• Experience in developing inbound and outbound interfaces for Oracle General Ledger, accounts receivables, purchasing, quoting, order management and inventory modules.
• Engaged business users wif project team, developer team and production support team to design and implement TEMPeffective solutions.
• 10 years of hands-on experience wif business objects as a reporting tool for building report, designing, and managing user profiles.
• Experience in customizing standard Oracle Reports using Reports 12g/12i in GL, AP, INV, AR and PO modules as per business user requirements.
• Experience in customizing Oracle workflows such as teh PO approval process, order/line flow to send user notifications based on teh business requirement.
• Strong understanding and experience in setting up repository, managing users and user groups and publishing reports.
• Possess excellent communication skills, quick learner, possess excellent analytical and technical skills.
• Experience in converting teh standard oracle reports to a more in-depth report using XML publisher and rdf.
• Extensive experience in creating Stored Procedures, Functions, Packages, Triggers and other database objects using SQL and PL/SQL.
• Strong noledge of SQL, PL / SQL, Forms 10g/6i, Reports 10g/6iOracle workflow XML publisher and rdf.
• Experience includes exposure to all teh phases of software development life cycle including analysis, design, development, testing, implementation, production support and maintenance.
• Involved in understanding teh end user requirements and business processes in modifying stored procedures and creating reports.
• Excellent problem-solving skills and ability to work independently wif minimal supervision.
• Involved in full software development life cycle.

TECHNICAL SKILLS

ERP Suite: 12i, 11i, R12, GL, AP, AR, PO, INV, FA Invoice, P2P and O2C

Oracle Tools: Oracle forms 12c, Reports 12c, Workflow Builder.

Database Tools: SQL* PLUS, Loader, SQL Navigator, Toad, SQL developer

BI Tools: XML BI Publishers, Business Objects XIR2, Import Report Conversion Tool, Info View, Crystal Reports 9/10/R11/XIR2.

ELT Tools: ODI

RDBMS: Oracle8i/9i/10g/11g/12g, MS Access.

Languages: SQL/PL SQL, C, C++, and Java, JDBC, JSP, J2EE, Servlets.

Tool & Utilities: TOAD 10.6, PVCS, Workflow, WinSCP.

Office Tools: MS Office Products.

Document methodologies: MD-50, MD-70, MD-120

PROFESSIONAL EXPERIENCE

Confidential ST. LOUIS MO

Oracle 12i Enhancement Support

Role & Responsibilities:

• Maintained all projects documentations following MSD standard & program version control. dis includes weekly status reporting, service request management, change management, incident management, problem management, project management and noledge management.
• Worked wif business users in 12i to Scale R12 upgrade project, which includes 12i analysis for inquiry to order, order to revenue and procure to fulfill processes in 12i.
• Performed systems analysis, design, implementation, maintenance, and enhancement for oracle finance, procurement, cash management, asset management.
• Involved in planning and implementing data conversion methodology and modified teh data collection process.
• Developed a custom program to update teh P2P Purchase Orders and PO Requisitions as soon as teh sales order is updated.
• Developed reports and customized standard Oracle reports like customer order acceptance report, bank account single daily report, balance report, AR cash receipt voucher report, Payable invoice voucher report etc. using report builder 12c, and BI/XML publisher.
• Using report builder 10g and BI/XML publisher.
• Developed shell scripts to schedule Oracle concurrent programs.
• Developed an outbound interface program to transfer invoice and GL extracts from Oracle.
• Designed integration of Oracle, Maximo and GIS asset information report, Maximo purchasing order details report.
• Developed and customized reports in AR, AP and PO like aging by amount report, accrual reconciliation report, purchasing activity register report, lot by expiration report, unpaid invoices report using reports 6i.
• Created and used stored procedures, packages, cursors and functions to do teh validations on teh legacy data, created indexes to enhance teh performance of teh application.
• Extensively worked on GL, AP, AR and PO interface and conversions.
• Worked on conversion of journal entries from old set of books to new set of books.
• Created staging tables to load teh records and uploaded teh flat files using SQL*loader.
• Configured concurrent executable, concurrent programs, request sets, request groups, functions, menus, sub-menus, and custom responsibilities.
• Customized teh existing forms as per teh client requirement.
• Developed custom AR interface program which validates and modifies data in teh interface tables. dis program is designed to update sales order based data in AR interface tables. validations and changes based on different custom tables and forms.
• Developed an outbound Interface to export GL data to third party systems, also inbound Interfaces to import into GL by populating GL INTERFACE table.
• Developed and customized various custom reports like PO requisition details report, open PO report by buyer, open receipts report and PO unsourced requisitions report in reports 10g builder.
• Registered teh PL/SQL scripts using concurrent programs and attached teh programs to request Sets.
• Designed and developed fixed assets conversion by running mass additions concurrent program to transfer teh data from interface to base tables in fixed assets (FA).
• Involved in teh user acceptance testing and post production support.
• Created and customized reports in AP, AR, FA and credit & collections & GL using reports 10g.
• Created UNIX shell scripts to automate teh process of loading teh external data.
• Used FND LOAD utility to migrate responsibility, request sets, concurrent programs, value sets, concurrent managers, context-sensitive DFF, profile options, form personalization’s etc.
• Developed interface program to close old Purchase Orders in teh ERP system.
• Defined payment terms, locations, and Invoice approvals and setting up account information in Oracle financials AR.
• Customized requisition approval and PO approval workflow for procurement.

Environment: Oracle EBS 12i & R12 (GL, INV, AP, AR, CE, PO, FA), OBIEE, PLSQL, TOAD, XML BI Publisher, Unix Shell Script, Report builder(rdf), Oracle 10g, Reports 10g .

Oracle 11i Enhancement Support

Role & Responsibilities:

• Involved in planning and implementing data conversion methodology and modified teh data collection process.
• Developed interfaces to create internal purchase order requisitions and purchase orders.
• Responsible for support activities on an on-demand basis for both custom applications and Oracle applications
• Performed systems analysis, design, implementation, maintenance, and enhancement for Oracle finance, procurement, cash management, asset management.
• Worked on AR, AP, GL, PO to maintain consistency between legacy system and Oracle apps. Teh interface components include 'Journal Import', 'Payables Invoice Import', 'AR Invoice Import', 'PO Outbound interface for vendors', 'Outbound interface for Customers' etc.
• Developed a custom program to update teh P2P purchase Orders and PO requisitions as soon as teh purchase order is updated.
• Customized standard PO approval workflow to send user notifications for PO approvals based on preset teh approval limits
• Developed various RICEW components in modules like GL, AP, INV, AR and PO.
• Created new concurrent request sets and scheduled teh Order import interface program to run periodically
• Developed custom reports using Report 10g and customized seeded reports.
• Wrote SQL scripts to create temporary tables and developed SQL*loader control files to load teh legacy data into teh temporary tables.
• Customized standard purchase order request form for output communication and created bursting file and RTF template to generate XML report. responsible for requirement analysis and reviewing MD-50 and writing of technical design MD-70.
• Designed and developed PL/SQL packages to import AR invoices and AR receipts legacy information into Oracle.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * loader.
• Written procedures and database triggers for teh validation of input data and to implement business rules.
• Involving in teh complete Order to Cash and Procure to pay cycle.
• Creating XML publisher reports and using various templates to publish teh reports as per user requirements.
• Worked on check printing, AP cleared checks, Invoice aging reports for payables to accomplish customization according to business requirements.
• Worked on auto lock box interface in AR.
• Involved in AP invoices conversion, customer conversion, vendor conversion, AR invoice conversion and GL year end and monthly balances conversion.
• Developed interface programs to load order information from legacy system-to-system tables. Interim tables created to hold teh data from teh flat file. dis was done to load data in CSV file obtained from teh External system. To achieve dis, few concurrent programs were developed to load data from a flat file into interim tables.
• Customization of Oracle forms like, account receivables, payment transactions, scheduled payments and various other forms using custom.pll, as per teh client requirements.
• Provided post go-live support and involved in user training sessions

Environment: Oracle EBS 12i & R12 (GL, INV, AP, AR, CE, PO, FA), OBIEE, PL/SQL, TOAD, XML BI Publisher, Unix Shell Script, Report builder(rdf), Oracle 10g, Reports 10g,,Forms 10g .

Confidential

Role & Responsibilities:

• Writing PL/SQL code using teh technical and functional specifications.
• Generated SQL and PL/SQL scripts to install create database objects including tables, views, primary Keys, Indexes, constraints, packages and sequences.
• Involved in writing PL/SQL packages, function and stored procedures and data base triggers.
• Developed complex queries using joins and correlated sub queries.
• Worked on teh entire SDLC of teh project starting from requirements gathering, analysis, design, development, testing and production support.
• Developed PL/SQL packages, procedures and functions for validation of teh invoices and payment information from teh legacy system to import into Oracle application.
• Designed and developed PL/SQL packages to import AR invoices and AR receipts legacy information into Oracle.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL * loader.
• Written procedures and database triggers for teh validation of input data and to implement business rules.
• Used exception handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Proactively suggested certain ideas which improved teh system performance.
• Responsible for system and integration testing of several modules.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Plus, TOAD, MS office Products.

Confidential

Role & Responsibilities:

• Gathered requirements for reports to support reporting needs and report requirements for standard reports from teh users.
• Indentify teh tables to be used and all possible relation between teh tables to build teh universes.
• Involved in teh design of teh universe and joined various tables using joins.
• Involved in teh development of reports by using BO and Oracle 9i as database.
• Generated and published several reports in Info view.
• Developed drill down reports for in-depth analysis.
• Organized data in teh reports by using filters, sorting, ranking and highlighted data wif alert.
• Created complex reports using user defined function and condition objects.
• Improved reports response time by tuning business object queries.
• Experience in tuning complex SQL, worked wif DBA to create aggregate tables, indexes to speed up query time, scheduled client report.
• Scheduled reports based on specific time, events, and calendars in various formats such as PDF.
• Utilized dash board manager to has access to pivotal business metrics for performance management.
• Involved in migration from existing 8.5 reports to BO XI R2.
• Created users /groups and defined their roles and set privileges using CMC.

Environment: Business Objects XI-R2, import wizard, report conversion tool, Info View, Crystal reports XI-R2, Oracle 9i, PL/SQL, toad, window 2003 server.

Confidential

Role & Responsibilities:

• Developed teh UI using JSPs (including custom JSP tag, JAVA scripts and CSS).
• Implemented teh business logic using java classes.
• Integrated wif exchange server to confirm acceptance or rejection.
• Used JBoss web application server.
• Created teh service layer using JDBC for database, JNDI.
• Performed unit testing manually and using JUnits.

Environment: JSP, JAVA Scripts, CSS JAVA’s JBoss web applications, JDBC, Struts, Servlets, PVCS, Ant, Builder Shell scripting, Oracle 9i JUnit.

Confidential

Role & Responsibilities:

• Involved in design, development, and implementation.
• Conceptualization of basic design.
• Design and development of website.
• Published of completed websites.
• Tested teh websites to make sure it TEMPhas no missing links and images search engines registration.

Environment: MS FrontPage, HTML, JavaScript’s, Flash, Gif Animation, J2EE, JWS, Struts.