SUMMARY

• 20 + years of extensive experience in the full lifecycle development of large Oracle based Applications. Responsible for systems analysis, database design, database development, software testing and implementation as well as technical support.
• Extensive experience in Oracle Applications (11i and R12). As a Techno - Functional consultant extensively involved in interfacing with users, identifying functional and technical gaps, estimating work, architecting system interfaces, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support.
• Extensive Experience in E-Business Suite 11i, R12 including Oracle Financials (GL, AP, AR, FA, CM), INV, BOM, PA, OM, Install Base, WMS, WIP, MRP, PO and HRMS (HR, Payroll, Advanced Benefits, OLM) modules.
• Extensively involved in Forms Customizations using Custom library, Report generation using Oracle Reports and Discoverer, Creating extensions/ Interfaces with Oracle E-Business suite 11i/R12.
• Extensively involved in OAF Customization using JDeveloper.
• Very Strong in data loading using Interfaces, APIs and Data Pumps.
• Solid experience in creation of numerous custom applications, reports, programs and scripts to extend missing or required functionality, from Release 10.7SC, 11i and R12.
• Thorough understanding for Oracle’s open interface tables and related data conversions for Inventory/Items/ Onhand, OM, Routing, BOM, Installed Base, WIP, Costing, PO, G/L,AR, AP, PA,HRMS.
• Solid experience in creating Data Models including Logical & Physical design using ERWIN, Designer & ER-Studio.
• Strong experience in creating Technical specifications, developing code, User acceptance testing, Implementation and GAP analysis.
• Strong experience in root cause analysis.
• Very Strong in Gathering business requirements, GAP analysis and propose changes for customizations using Oracle Forms/ Reports/ Custom Library, Form personalization and Workflow changes
• Very strong in creating functional specification document MD 50 and converting it into technical specification document MD 70 using AIM methodology
• Proficient in applying business logic using SQL Scripts, PL/SQL packages, stored procedures, functions and triggers.
• Highly proficient in GUI based software development using tools such as Developer/2000, Developer 6i, Developer 9i/10g Forms & Reports, Discoverer, OBIEE, BI Answers, SQL Navigator and TOAD.
• Providing 24x7 on call Technical Support to Bank Users on Technical and Functional Issues

TECHNICAL SKILLS

Operating System: HP-Unix, Solaris, Linux, Windows XP Pro, Windows 2000/NT, AIX & MS DOS

Databases: Oracle 7/8/8i/9i/10g, MS SQL Server 7/2000, MS Access, Visual Basic, .NET

Languages: SQL, PL/SQL, Pro *C, C, Java, Shell scripting, HTML, JavaScript

Tools: Oracle Designer 6/6i/9i/10g, Erwin, ER-Studio, Optima, Visio, Oracle Forms and Reports (9i/10g/6i/ 6/5/4.5/3.0/2.5 ), SQL*plus, SQL *Loader, PRO *C, OWB, Oracle Discoverer, Concurrent Manager, Oracle InterMedia, Microsoft Project, Workflow Builder, JDeveloper, Informatica

DBA Tools: Oracle Enterprise Manager (OEM), RMAN, DBA Studio, SQL*Loader, Stats pack, TOAD, SQL Navigator, PL/SQL Developer

BI Tools: OBIEE, BI Answers, BI Lawyers, Dimensional Modeling, Data Warehouse Design

Enterprise Applications: Oracle E-Business Suite 11i/R12 Oracle Financials (GL, AP, AR, FA), Oracle Purchasing, (Supply Chain, Service, OM, INV, BOM, PA, HR, Payroll), Oracle Property, iProcurement, Outsourcing

Web Servers: Oracle 9i/ 10g Application Server, Apache

Networking: SQL*Net, TCP/IP, Listeners, Database Links

Hardware: HP Servers, Compaq, Sun Ultra 60, Sun Sparc 20, Ethernet Hubs, Fast Ethernet Switches, IBM Server

PROFESSIONAL EXPERIENCE

Senior Techno Functional Consultant

Confidential, Tampa

Responsibilities:

• Currently working in Confidential Bank enhancement project related to Finance, Outsourcing, SCM and iProcurement modules.
• Extensively involved with O2C cycle design and implementation
• Extensively involved with Importing ISO using WIP Completion. Involved with WIP partial, overfill and under shipment using Oracle Interfaces/ APIs
• Involved with Oracle EBS integration with SARIE local payment system.
• Involved with writing different AP, AR, PO, and PN Interfaces.
• Responsible for creation / updation of all RICEW components for major modules like AP, GL, AR, FA, PO, CM (Reports, Interfaces, Customizations and Extensions).
• Extensively involved with Supplier creation/ conversion from legacy applications into Oracle AP using APIs.
• Extensively involved with Customer creation/ conversion from legacy applications into Oracle AR using APIs.
• Designed and deployed many reports using Oracle BI publisher and Oracle report builder
• Designed and developed many inbound/ outbound interfaces using XML publisher and SOA gateway repository.
• Designed and developed Petty Cash self-services to submit petty cash from different branches and interface with AP invoices.
• Designed and developed interface between Petty Cash self-service and Expense Report.
• Designed and developed interface to integrate with T24 core banking applications to process the daily files received and in corporate into GL.
• Designed and developed interface with outsourcing and property.
• Designed and developed custom pages and enhanced the existing standard pages in OAF for iProcurement, Outsourcing, GL and AP modules.
• Designed and developed custom interface for draft AP invoices in OAF.
• Designed and developed web service solution to consume the payment application web service for automatic payment processing.
• Reviewing and approving functional specifications (MD050) for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software and verifying that they provide the required clarity and explanation of the solutions to requirements
• Working with the data migration team to ensure that AP, Payment Processing, HR, INV, AR and Billing data was appropriately validated and migrated for Go Live
• Post Go Live Support

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Quality Centre, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEEXML Gateway, SOA Gateway Repository, JDeveloer, Business Events

Senior Technical Consultant

Confidential, Tampa FL

Responsibilities:

• Involved with Global rollout of Oracle Financials, SCM and MFG modules
• Extensively involved with data conversion of major modules like OM, AR, PO, INV, BOM and Routing
• Extensively involved with analysis, solution design and deployment of HRMS new interface
• Extensively involved in writing MD 50, MD 70 for data conversion for major modules like INV, AR. Also wrote complex PL/SQL packages for data conversion of above modules.
• Extensively involved in writing outbound/ inbound interfaces between Oracle and PeopleSoft/ MacPac
• Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents.
• Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
• Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
• Responsible for creation of concurrent programs, value sets, parameters for the generated reports

Environment: Forms 6i/10g, Reports 6i//10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, UNIXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, PVCS

Senior Technical Consultant

Confidential, Chicago

Responsibilities:

• Currently involved as a Senior Techno-Functional consultant for upgradation project from 11i to R12
• Extensively involved with Oracle Corporation in analysis, design and development of inbound/ outbound interfaces using standard interfaces and APIs. Example of interfaces include Oracle Projects to Concur Outbound interface, Conversion of Item master, Conversion of customers, Vendors, Customer Invoices, Payable invoices
• Extensively involved as a Techno-Functional Consultant solving day to day problems of users around the globe
• Worked on modifying the burdened cost using Burden Cost Accounting Extension
• Identified standard system functionality, analyzed GAP document and designed solutions for GL,AP, AR, FA, PA depending on Business requirement.
• Involved in end user training and user acceptance testing, preparation on test scripts (TE 040) and integration testing.
• Responsible for upgradation of all RICE components (Reports, Interfaces, Customizations and Extensions)
• Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents. Components designed and tested include e.g.: (i) Sales Order conversion into OM, BOM and Routing Conversion and Customer conversion into TCA; (ii) Invoice conversion into AR; (iii) Invoice and Supplier conversion into AP (iv) Item master conversion into Inventory (v) various reports
• Extensively involved in writing MD 70 for data conversion for major modules like GL, AR, AP, OM, INV, PO, BOM, Routing. Also wrote complex PL/SQL packages for data conversion of above modules
• Extensively involved in modifying/ updating 11i PL/SQL packages to be used in R12
• Created/ Modified workflows and Alerts using Workflow Builder/ Alerts
• Extensively used Custom.pll and Forms personalization for Forms customization for AR and AP modules
• Involved in creating, modifying and repairing various custom reports using Report 6i/10g, Discoverer, XML Publisher and OBIEE
• Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository
• Designed new Forms and Reports using Oracle Forms 6i/10g, Report 6i/10g that interface with Oracle Applications 11i/R12
• Created various shell script to move the files to required TOPs and registered them as HOST concurrent program
• Responsible for creation of concurrent programs, value sets, parameters for the generated reports
• Involved in creating, enhancing and optimizing simple to complex reports using Oracle Discoverer reporting tool. Granted access privileges to specific users and granted security access to use related business areas using Oracle Discoverer
• Labeled information in a business area to help end users identify the information they will want to access
• Improved the association between folders by creating the necessary joins between folders in the business area

Environment: Forms 6i/10g, Reports 6i//10g, Discoverer 9i/10g, HP Service Desk, Oracle 10g, UNIXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, PVCS, XML Gateway

Senior Techno Functional Consultant

Confidential

Responsibilities:

• Involved with writing up Technical specifications (MD 70) for reports/alerts/workflow/ customizations/inbound outbound interfaces and creating detailed-level technical design documents
• Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents, Components designed and tested include e.g.: (i) Sales order conversion into OM (ii) Customer conversion into TCA; (iii) Invoice conversion into AR (iv) Item and routing conversion (v) PO and BOM Conversion.
• Extensively involved with creating Logical and Physical design for RICEW components.
• Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository.
• Designed and developed custom module for LC, LG and loaning facility in Oracle Forms.
• Extensively in designing solutions for vendor invoices to check printing using R12 payments.
• Designed and Developed technical requirement documents for inbound/ outbound interfaces using XML Gateways and Oracle EBS SOA Gateways.
• Liaising directly with stakeholders across a diverse range of business and technology functions.
• Reviewing and approving detailed Solution Design Documents, and verifying that they provide the required clarity and explanation of the solutions to requirements
• Created MD50 and MD70 for Supplier and Payment Interfaces
• Developed eText and RTF templates for AP Checks and for EFT programs using BI Publisher in R12
• Responsible for creation/ updation of all RICEW components for major modules like AP, OM, WIP, GL, AR, FA, PO, CM, HCM (Reports, Interfaces, Customizations and Extensions)
• Extensively involved with Supplier creation/ conversion from legacy applications into Oracle AP using APIs.
• Extensively involved with Customer creation/ conversion from legacy applications into Oracle AR using APIs.
• Designed and deployed many reports using Oracle BI publisher and Oracle report builder
• Designed and developed many inbound/ outbound interfaces using XML publisher and SOA gateway repository
• Extensively involved in implementing and designing custom report in OBIEE and customized ETL process in Informatica.
• Reviewing and approving functional specifications (MD050) for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software and verifying that they provide the required clarity and explanation of the solutions to requirements
• Working with the data migration team to ensure that AP, Payment Processing, HR, OM, INV, AR and Billing data was appropriately validated and migrated for Go Live
• Post Go Live Support

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Quality Centre, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, ETL INFORMATICA, XML Gateway, SOA Gateway Repository

Senior Oracle Consultant

Confidential

Responsibilities:

• Involved with writing up Technical specifications (MD 70) for reports/alerts/workflow/ customizations/inbound outbound interfaces and creating detailed-level technical design documents
• Extensively involved in writing functional specifications for reports/alerts/customizations (including working with users on requirements) and creating high-level technical design documents, Components designed and tested include e.g.: (i) Sales order conversion into OM (ii) Customer conversion into TCA; (iii) Invoice conversion into AR (iv) Item and routing conversion (v) PO and BOM Conversion.
• Extensively involved with creating Logical and Physical design for RICEW components.
• Designed real time inbound/ outbound interfaces using XML Gateway/ SOA gateway repository.
• Designed and developed custom module for LC, LG and loaning facility in Oracle Forms.
• Extensively in designing solutions for vendor invoices to check printing using R12 payments.
• Designed and Developed technical requirement documents for inbound/ outbound interfaces using XML Gateways and Oracle EBS SOA Gateways.
• Liaising directly with stakeholders across a diverse range of business and technology functions.
• Reviewing and approving detailed Solution Design Documents, and verifying that they provide the required clarity and explanation of the solutions to requirements
• Created MD50 and MD70 for Supplier and Payment Interfaces
• Developed eText and RTF templates for AP Checks and for EFT programs using BI Publisher in R12
• Responsible for creation/ updation of all RICEW components for major modules like AP, OM, WIP, GL, AR, FA, PO, CM, HCM (Reports, Interfaces, Customizations and Extensions)
• Extensively involved with Supplier creation/ conversion from legacy applications into Oracle AP using APIs.
• Extensively involved with Customer creation/ conversion from legacy applications into Oracle AR using APIs.
• Designed and deployed many reports using Oracle BI publisher and Oracle report builder
• Designed and developed many inbound/ outbound interfaces using XML publisher and SOA gateway repository
• Extensively involved in implementing and designing custom report in OBIEE and customized ETL process in Informatica.
• Reviewing and approving functional specifications (MD050) for data migrations, reporting & analyses, systems integrations, and customizations to standard packaged software and verifying that they provide the required clarity and explanation of the solutions to requirements
• Working with the data migration team to ensure that AP, Payment Processing, HR, OM, INV, AR and Billing data was appropriately validated and migrated for Go Live
• Post Go Live Support

Environment: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 9i/10g, HP Quality Centre, Oracle 10g, LINUXWindows XP, SQL*Plus, PL/SQL, TOAD, XML Publisher, Workflow Builder, Alerts, OBIEE, ETL INFORMATICA, XML Gateway, SOA Gateway Repository

Confidential

Responsibilities:

• Senior Oracle Specialist responsible for the analysis, design, development, implementation, testing and support of the Billing and Customer Care System.
• Worked extensively with User base to get the specification, Created Software Requirement Specification document and developed the Solution design.
• Build logical & physical data models, generated Schema using Designer 9i.
• Responsible for development and deployment of Forms as well as reports using Developer 9i/10g and 9iAS.
• Created parameterized report using reports 9i, which are able to query data according to business area.
• Developed Object Libraries and PL/SQL Libraries.
• Developed and Implement different reusable modules that are consistent throughout the applications.
• Designed Tables, Constraints, Views, and Indexes etc. independently.
• Conversion of existing data from COBOL into oracle database using SQL*LOADER.
• Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design.
• Wrote PL/SQL packages, functions and procedures to enforce business rules and relationship uncovered in the Data model.
• Created the routine in Pro*C for processing customers daily orders.
• Developed a complete Security system for BDF Management. System was developed to allow management to define and implement security levels for different group of users while accessing the billing application.
• Supported developers in tuning database and applications for optimal performance, monitor database growth and provide database capacity planning for applications expansion.
• Daily Maintenance involved performance monitoring, backup monitoring, analyzing indexes, tables, schemas, and Database as needed, checking export/imports, space management, instance/SQL tuning, process scheduler maintenance, performing ad-hoc SQL for users and reviewing production process logs
• Tuning of the Database by monitoring performance of SGA, Rollback Segments.
• Provided 24x7 on call Technical Support resolving high priority issues.
• Provided support on daily basis operations.

Environment: Forms 9i/10g, Reports 9i/10g, Oracle Designer 9i, Discoverer 9i, 9iAS, Oracle 9i, Pro*C, HP-Unix, Windows 2000/XP, SQL*Plus, PL/SQL, C

Software Developer / Data Modeler

Confidential

Responsibilities:

• Involved in managing the team of Software professionals working on the different modules of the system
• Interacted with end users and senior management to understand and define the business requirement and preparing the required document and E/R diagrams.
• Involved in the analysis, design and development of the Client Registration, Loan Calculation and disbursement management modules.
• Responsible for Integration of all the modules. Build process models using Optima.
• Created the control files and data files for SQL*Loader to input the voluminous data.
• Used TOAD to check the performance of SQL statements.
• Created the routine in Pro*C for connecting to different DB instances.
• Installed and configured the Oracle server on the client side.
• Participated in DBA activities like Installation, performance tuning, creation of Data files, tablespaces, tables, views, synonyms, DB link etc.

Environment: Oracle 9i, Forms 6i, Reports 6i, SQL*Loader, SQL*Plus, PL/SQL, ERWIN, TOADImport/Export, MS Project, Pro*C, Windows 2000, Optima