Oracle, JAVA, JSP, ADF, OAF

Contact Information: ***************@*****.***

Phones: 630-***-**** /630-***-****

Professional Skills:

Over 17 years of experience in the IT industry as Project Lead, Sr. Oracle Developer/Oracle E-Business Suite 11i Applications Techno Functional expert/ Applications DBA/Architect/ Sr. e-commerce developer/ Sr. ETL Developer/ Sr. Designer / Sr. Analyst in various environments. Skilled in building interfaces, customization of Oracle E-Business suite R12 (ERP) for Financials, Supply Chain, HRMS, Manufacturing, Service Modules and CRM along with Oracle Business Intelligence (BIS) Reports using Oracle Reports, Discoverer and BI Publisher. Proven success in systems analysis, designing interfaces to legacy systems, upgrades and third-party software integrations. Adept at problem solving and developing positive working relationships with individuals and teams .

Hardware:

Sun Enterprise Servers, IBM RS 6000

Technical Skills:

Oracle modules Supply Chain modules (Order Management, Order Capture, Oracle

Inventory) Finance modules (Account Receivables, Cash Management, Account Payables, Cash Management, Fixed Assets), Human Resources, Payroll, OTL, Istore, Isupport, Iprocurement, Oracle Business Intelligence (OBI), Purchasing, General Ledger, BOM, SYSADMIN, Tele service, Field service, Knowledge Management, Universal Work Queue, Scripting, Email Center, Calendar, Service Contract, Install Base, RXi Reports, TCA, BPEL, eBTax

UML Rational Rose 2000

Operating System Win NT 4.0/ Win 2000 Server, Solaris 8, Sun OS 5.8, OS2, IBM AIX

Language XML, Java, HTML, DHTML, JavaScript, VBScript,

C++, C, COBOL, Pascal, FORTRAN, Basic

GUI Oracle Forms, JDeveloper, Visual FoxPro, Vignette, Reflection, Visual C++ with MFC and API Library and OLE, Visual Basic with COM/DCOM, ActiveX, NSDK, Q+E, Oracle Forms

Middleware Active server pages, Java sever pages, Moai server pages, Microsoft

Transaction Server (MTS)

Database Oracle, Ms- Access, SQL Server, Sybase

Reporting Software SQR Workbench, Oracle Reports, Oracle Discoverer, XML/BI

Publisher

Web Server Netscape Enterprise server, IIS and PWS, Apache, Jserv, Oracle

9iAS

Protocol HTTP, TCP/IP, FTP, SMTP, POP3

HTML Editor Front Page, Microsoft Interdev.

Data loader Comstar DataLoader

Other Oracle Portal (Content Management), Oracle Workflow,

Reflection, Shell scripting, AK Developer, AOL, XML Integrator, ADF, OAF, Microsoft template Builder, Auto Lockbox, Auto Reconciliation

Microsoft Tools Microsoft Visio, Access, Word, Excel, PowerPoint, Outlook

Education

B.S in Computer Science and Engineering. Trained in Oracle Application Development Framework, BPEL, OBIEE . Participated in demo of OIPM .

Project Experience

Confidential, IL, USA

Duration: Jun 2013 to till date

Project Description: Web based Sales Applications implementation.

Role and Responsibilities: SME (Subject Matter Expert). Responsible for production support, development and maintenance of Sales Applications . Extensive experience in conducting Feasibility Studies and Root Cause Analysis (RCA) . Facilitate business and technical sessions with system stakeholders. Communicated with business stakeholders on projects, status and issues . Involved in integration of legacy. Developed IT Standards . Mentored and Assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in design, development and testing. Lead some of the client’s internal projects. Provided Gap Fit analysis, review design architecture, functionality and enhancement requests. Created functional specifications and technical specifications from the business requirements. Troubleshoot issues of Reports, Forms, ETL, ADF, JAVA, JSF, SQL, PL/SQL.

Environment:

Sun Solaris, Oracle 11g, Java

Auto Parts Manufacturer, IL, USA

Duration: Sep 2011 to Apr 2013

Project Description: Oracle ERP Release R12 implementation for Automotive manufacturing firm .

Role and Responsibilities: SME (Subject Matter Expert). Responsible for implementation, development, maintenance and support of Oracle Applications . Extensive experience in conducting Feasibility Studies and Root Cause Analysis (RCA) . Facilitate business and technical sessions with system stakeholders. Communicated with business stakeholders on projects, status and issues . Involved in integration of legacy and Oracle Application System . Developed IT Standards . Mentored and Assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in design, development and testing. Lead some of the client’s internal projects. Provided Gap Fit analysis, review design architecture, functionality and enhancement requests. Created functional specifications (MD50) and technical specifications (MD70) from the business requirements (BR100) . Review specifications and developed test plans. Designed, developed, tested and deployed BI Publisher Reports (Developed RTF templates, developed custom reports using BI Publisher for Finance department, evaluating OBIEE-FA). Implemented and completed full cycle implementation of Finance and SCM modules, personalize OA Framework pages (OAF). Resolved issues with the Bank payment file formats. Resolved issue with supply chain modules. Customization of Oracle Forms and Reports . Troubleshoot issues of oracle modules like Sysadmin, eBTax, HR, AP, AR, GL, Alerts, Cash Management, PO, HR, Web ADI, WIP, Advanced Pricing, Shipping, BOM, Inventory, Order Management, Reports, Forms, ETL, XML/BI Publisher, ADF, SQL, PL/SQL.

Environment:

Sun Solaris, Oracle 10g and Oracle R12

Engineering Company, IL, USA

Duration: Sep 2008 to Mar 2011

Project Description: Oracle ERP Release 11i implementation for Power plant design consulting firm.

Role and Responsibilities: SME (Subject Matter Expert). Responsible for implementation, development, maintenance and support of Oracle Applications and BPEL projects . Facilitate client in choosing the right product by participating in evaluation of product. Participated in crisis calls, business and technical meetings, Communicated with business stakeholders on projects, status and issues. Involved in integration of legacy and Oracle Application System . Provided Gap Fit analysis, review design architecture, functionality and enhancement requests. Assist client in IT infrastructure planning and development. Developed IT Standards . Mentored and Assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in architecture, design, development and testing. Taking lead role in some of the client’s internal projects . Created functional specifications (MD50) and technical specifications (MD70) from the business requirements (BR100), review specifications and develop test plans. Designed, developed, tested and deployed BPEL processes, Framework pages, BI Publisher Report (created RTF templates, integrated with ERP, configured profitability analytics transaction reports). Attend training in OBIEE. Evaluated OBIEE Financial Analytics for financial department . Implementing Lockbox, Auto Reconciliation features of Receivables (AR) . Resolving some of the issues with the Bank file formats. Troubleshoot oracle modules like Sysadmin, HR, GL, AP, Cash Management, Fixed Assets, Workflow, Discoverer, Reports, Forms, JAVA, JSP, ADF, JSF, JDeveloper, XML/BI Publisher, SQL, PL/SQL. Created reports and interfaces using Oracle Technology stack.

Environment:

Sun Solaris, Oracle 10g and Oracle 11i

Products & Services Company, IL, USA

Duration: Dec 2007 to Apr 2008

Project Description: Oracle ERP Release 11i implementation for a global products and services company .

Role and Responsibilities: SME (Subject Matter Expert). Responsible for Supporting Oracle Applications Services and Sales to Order modules . Participate in crisis calls and business and technical meetings. Troubleshoot oracle modules like Sysadmin/Teleservice, Field Service, isupport, Knowledge Management, UWQ, Email Center, Calendar, Resource Manager, Service Contracts, Install Base, Order Management, Trading Community Architecture (TCA), HR, GL, Workflow, Discoverer Reports, ODBI using JAVA/ JSP, XML,SQL, PL/SQL, OA Framework. Also involved in validating functionality, setups, logging bugs, execute needed sqls .

Environment:

Sun Solaris, Oracle 10g and Oracle 11i

Multiple Overlapping Projects

Duration: Jun 2006 to Sep 2007

Community College, IL, USA

Project Description: Automate education institution’s Financial, Human Resources and Payroll process

Role and Responsibilities: Involved in requirement Analysis, design and development of Sysadmin, Accounts Receivables, Payables, General Ledger, Human Resources and Payroll. Customization using SQL, PL/SQL, Discoverer, Oracle Reports (BIS Reports), XML, workflow and Production Support. Participated in crisis calls, business and technical meetings . Involved in integration of legacy and Oracle Application System . Developed IT Standards . Assisted team members . Present strategies and recommendations to management. Adhere to the industry best practices in architecture, design, development and testing.

Environment:

Sun Solaris, Oracle 9i and Oracle 11i

Government Organization, IL, USA

Project Description: Oracle ERP 11i implementation for government organization.

Role and Responsibilities: Involved in customization and extensions of Oracle Application modules like Sysadmin, AR, GL, HR, Payroll with SQL, PL/SQL, Forms, Reports, JAVA, JSP, XML. Requirement Analysis, Gap Analysis, Functional Design, Technical Design, Code Walkthrough, Testing, Production Support . Participated in crisis calls, business and technical meetings. Involved in IT Standards creation . Mentored and assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in architecture, design, development and testing.

Environment:

Sun Solaris, Oracle 9i and Oracle 11i

Mobile Device Manufacturer, IL, USA

Project Description: Data warehousing implementation for Mobile Device Manufacturing Organization

Role and Responsibilities: Involved in requirement Analysis, design and development of management and analytical reports (BIS Reports) utilizing Java, JSP, SQL and PL/SQL. Participated in crisis calls, business and technical meetings. Mentored and assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in architecture and design.

Environment:

Sun Solaris, Oracle 9i and Oracle 11i

Retail Company, IL, USA

Duration: Apr 2004 to May 2006

Project Description: Oracle ERP Release 11i implementation for a leading CDs & DVDs retail company.

Role and Responsibilities: Facilitate client in choosing the right product by participating in product evaluation. Participated in crisis calls, business and technical meetings. Involved in integration of legacy and Oracle Application System . Assist client in IT infrastructure planning and development. Developed IT Standards . Mentored and assisted team members. Present strategies and recommendations to management. Adhere to the industry best practices in architecture, design, development and testing. Involved in setup and Implementation of iStore, Sysadmin, Order Management, Inventory, Accounts Receivables, ( order to cash modules ) General Ledger, Human Resources, imarketing and Advance Pricing and Customization of iStore with JAVA, JSP and PL/SQL. Setup and implementation of Oracle Workflow, Interfaces and Discoverer Reports . Requirement Analysis, Gap Analysis, Functional Design, Code Walkthrough, Product evaluation, Technical Design, Testing, Production Support . Extensive analysis and development with SQL, PL/SQL, Workflow, JAVA, JSP and XML .

Environment:

Sun Solaris, Oracle 9i and Oracle 11i

Government Organization, NE, USA

Duration: Jun 2003 to Mar 2004

Project Description: Oracle ERP Release 11i implementation for City of Omaha.

Role and Responsibilities: Setup and Implementation of iprocurement and Customization of iprocurement with XML, JAVA, JSP, and PL/SQL. Setup and implementation of Oracle Time and Labor (OTL) and interfaces . Requirement Analysis, Gap Analysis, and Functional Design and Setup of Sysadmin,Oracle Human Resources, Oracle Payroll, AR and AP Interfaces (Inbound and Outbound). Involved in legacy data conversion and API conversion . Extensive analysis and development with Oracle Reports and Discoverer, SQL, PL/SQL, Forms, Workflow, JAVA, JSP, Participated in crisis calls, business and technical meetings. Involved in integration of legacy and Oracle Application System . Involved in developing IT Standards . Present strategies and recommendations to management. Adhere to the industry best practices in architecture, design, development and testing.

Environment:

Sun Solaris 8, Oracle 9i and Oracle 11i

Greeting Card Manufacturer, IL, USA

Duration: Mar 2003 to Jun 2003

Project Description: Oracle ERP Release 11i implementation for a world's leading greeting card company.

Role and Responsibilities: Configure and Customize Sysadmin, Oracle Portal, Oracle Receivables, Order management, Oracle Pricing, Oracle Inventory, (Order to Cash modules ), Oracle Discoverer, Data warehousing, ETL reports. SQL, PL/SQL, Forms, Reports, Interfaces for Order Entry.

Environment:

Sun Solaris 8, Oracle 8.1.7.3 and Oracle 11i

Food Service Organization, IL, USA

Duration: Jun 2002 to Dec 2002

Project Description: Oracle ERP Release 11i implementation for a world's leading food service organization.

Role and Responsibilities: Setup, implementation, customization and Testing of Sysadmin,Oracle Portal, Setup implementation of BIS, Oracle Discoverer, ETL reports. Testing of ireceivables, iprocurement, Purchasing and Human Resources . Clearcase, Kintana, AccessMCD, JAVA, JSP, J2EE, SQL, PL/SQL, Forms, JBuilder .

Environment:

Sun Unix, Oracle 8.1.6 and Oracle 11i

Food & Health Product Manufacturer, IL, USA

Duration: Mar 2001 to Oct 2001

Project Description: Oracle ERP Release 11i implementation for a manufacturing and distribution company .

Role and Responsibilities: Setup and implementation of BIS, Oracle Discoverer, Setup, implementation and Customization of Sysadmin, istore, isupport and imarketing, Client interaction in preparing istore questionnaire/analysis, Oracle Portals, Order management, Order capture, ( Order to Cash modules), Conversion of legacy system data, unit testing, system integration testing and QA for HR, JAVA, JSP, J2EE, Comstar DataLoader, SQL, PL/SQL, Forms, JBuilder.

Environment:

IBM AIX RS 6000, Oracle 8.1.6, Oracle 11i

Toy Manufacturer, IL, USA

Duration: September 2000 to Feb 2001

Project Description: Auction and selling their products are the main aim of this site.

Role and Responsibilities: NT Administration, Developed Moai server pages, Vignette pages and istore and java classes, setup and implementation of BIS, Reports with Discoverer which involves developing reports, administering workbooks and business areas, working with EUL etc., setup, implementation and customization of Istore, implementation, unit testing, acceptance testing and QA reviews

Environment:

Oracle Applications 11i, of HR, Vignette 5.6, Live Exchange, Oracle Web Application Server 4.0, Oracle RDBMS 8.0.5 and Oracle RDBMS 8i, HP-UX, Sun Sparc Solaris, J2EE, XML, Java, TCL/TK, JSP, and Servlets

Research Organization, CT, USA

Duration: May 2000 to August 2000

Project Description : This system was developed for a research company. The goal of the Alumni Web Site is to create a forum for interaction and networking among alumni with one another and with the company as a whole, and to showcase the ongoing accomplishments of alumni. More specifically, this goal includes the following technical service components:

Fast Alumni lookup service

Easy to use Tool for broadcasting email campaign communications

Up to date Job Listings and News Profile features.

Secure system accessible to Alumni and Administrators via valid User ID and Password.

Role and Responsibilities: Clients Interaction to complete the Requirements Specification. Involved in designing and developing the Legacy System Interaction, Email Tool & Customer Service, User ID / Password & Registration Profile, Job Listings, Alumni News Profile, Administrator Tool, Reporting . Involved in preparing standards for the site . Involved in integrating the system, NT Administration .

Environment:

Rational Rose, Visual Basic 6.0, ASP, Visual Interdev 6.0, ActiveX dlls (COM/DCOM objects), MTS, Oracle 8.0, Windows NT4.0, IIS, HTML, DHTML, DOM, VBScript, JavaScript, Visual Source Safe 6.0, Microsoft Site Server Express 2.0 (Post acceptor).

Hospitality Organization, AZ, USA

Duration: December 1999 to May 2000

Project Description: This System covers the Front office Information for the Property with Availability, Reservations, Check-In, Checkout, Folio Transactions, and Fully Automated Night-Audit. The System was built on N-tier architecture. The user services were developed using Visual Basic 6.0. The Business services and data services were developed as ActiveX components using Visual Basic 6.0. ADO 2.0 was used to assess MS SQL Server 7.0 database.

Role and Responsibilities: Involved in developing the Availability, Reservation, Folio Transaction, Folio Transfer, Guest Messages, Special Services Notes, Active Server Pages (ASP) providing support for implementation of the system at the internet web publishing site, Atlanta, USA.

Environment:

Visual Basic 6.0, ASP, Visual Interdev 6.0, ActiveX, COM, MS SQL Server 7.0, Windows NT 4.0 Workstation Clients, Windows NT 4.0 Server, HTML, DHTML, DOM, XML, VBScript, JavaScript, Crystal Reports 7.0, Visual Source Safe 6.0.

Project Based Organization, CHENNAI, IN

Duration: From December’1998 to November 1999

Project Description: The Human Resources Reporting systems (HR) is an intranet web application designed to track Project, Employee and Allocation of Resources and Reports about the Project. The system generates various summaries and statistical reports based on the organization hierarchy. The main objective of this system is to provide accurate reporting to the management and easy maintainability. This system integrated with Human Resource planning system, identify employee skill set, Project details and allocation of resources and take reports on it.

Role and Responsibilities: My role in this project is to design, develop and test the reports in Active Server Pages as well as design the back end. Interacting with the Management official in finding the data sources for the report. Used Microsoft Interdev and Extensive Manual Coding in HTML and DHTML. Used ActiveX controls with MTS. Developed Browser Compliant Package. Used VBScript for Backend processing as it is stable at the backend and JavaScript for Front-end processing

Environment:

ASP, HTML, DHTML, VB script, Java script, MS-SQLServer with ODBC, MTS, COM/DCOM

Insurance Company, LONDON, UK

Duration: June 1998- November 1998

Project Description: This system provides a long -term integrated Human Resources System solution and Insurance company in United Kingdom. It takes into account the dynamic nature of the company’s needs to cope with the present and future human resource requirements.. It enables fast information retrieval and enhances efficiency for the operation of Human Resources Department (HRD) and Passport And Government affairs Department (PGAD). This system also ensures that the data is managed with functionally modularity of these departments and at the same time allows the necessary data integration.

Role and Responsibilities: My role in this project is to design and develop the Active Server Pages. Used HTML, DHTML with VBScript and JavaScript. Extensive utilization of COM/DCOM and ActiveX controls with MTS.

Environment:

ASP with SQL Server 6.5 as Backend and Microsoft Interdev as case tool.

Insurance Company, CHENNAI, IN

Duration: April 1997 – May 1998

Project Description:

This is an offshore development project for the world Leader in Disability Insurance Company. This is downsizing project from IBM ES 9000 mainframe to Client server using Re-engineering approach with the extensive 3-tier architecture. This project deals with handling insurance for individual policies of Long Term Disability Insurance.

Role and Responsibilities: Involved in the study, Analysis and Design of dairy and calendar Module (DAC) of the system to complete the activities of Development testing, Enhancement and documentation of the Module. Involved in analysis of report programming. Involved in Y2K compliance in IPAS. Testing of reports from On-site which involves logical check up, analysis, enhancement and fine tuning performance of batch process.

Environment:

Sybase 11.0/ NSDK / SQR Workbench as the Reporting software

Book Store, CHENNAI, IN

Duration: January1996-March 1997

Project Description: This is a stores Automation project for a college. This software involves the speed of catering, alerts the store manager when an item reaches record level. It is possible to view the end day stock and print the bill.

Role and Responsibilities: Involved in the Analysis, design, development and system testing:

Environment:

Oracle 7.1,Developer 2000 and Oracle Reports

Contact this candidate