Oracle Management

SUMMARY

. SENIOR APPLICATION CONSULTANT WITH OVER 15 YEARS OF IT EXPERTISE.

. 7+ years of experience in system design, installation, testing &

implementing, production and development environments, and

supporting application functionalities in Oracle ERP

. Extensive experience as Principal Analyst, Technical Lead, Senior

Applications Analyst, Specialist Developer and Computer Programmer.

Complete team player with excellent temperament adjusting and

synergizing with different team members and client members.

. Expert with Oracle Applications E Business Suite. Worked with

Order Management, Advanced Pricing, Service Contracts, General

Ledger, Accounts Payable and Accounts Receivable modules

extensively.

. Involved in performing Setups, GAP Analysis, requirements

gathering, testing, customizations, implementation, upgrade and

post implementation/production support expertise with different

versions of Oracle Applications across different operating systems.

. Excellent knowledge of Oracle Application Business processes/Flows,

Order to Cash and Procure to pay business.

. Expertise with setting up KFF (Key Flexfields) and DFF (Descriptive

Flexfields) to capture essential information for the clients.

. Scheduling/generation of Advanced Supply Chain Planning process for

all Organizations.

. Gained expertise to work with SOX (Sarbanes Oxley) regulations.

Worked with business users to determine and segregate

responsibility access to particular users to be in tune with SOX

regulations.

. Designed and implemented the complete interface Application

Programming Interface (API's) to Oracle applications to be used in

Job scheduling effectively and optimally using Appworx scheduling

tool.

. Familiar with concepts and specific usage of BPEL, SPEL, SOA, ESB

(Enterprise Service Bus), OAF, and Jdeveloper.

. Written numerous Interface programs for importing data from feeder

systems to Oracle using SQL*Loader, PL/SQL.

. Expertise in writing UNIX shell scripts.

. Expertise at various levels of software development, which includes

conception, design, development, coding, testing, implementation,

QA, deployment and presentation of software.

. Strong conceptual, business and analytical skills.

TECHNICAL SKILLS

Application Oracle Manufacturing 11i, 11.x, 10.7 SC/10.6 (Order

Suites Entry, Purchasing,

Inventory, Bill of Materials, Work in Progress, ASCP)

Oracle Financials 11i, 11.x, 10.7 SC/10.6(GL, AP, AR,

AOL, FA, SYS

ADMIN, FSG Reports, Oracle Alerts)

Databases Oracle 10g/9i/8i, Oracle 8.x / 7.x

Development Developer 6i(Forms 6i, Reports 6i), Oracle 6i Toolkit,

Tools Designer 6i/2000, Oracle 9i AS, Oracle Portal/WebDB,

SQL*Loader, Import/Export, PL/SQL Web toolkit

Languages PL/SQL, Java, JavaScript, Pro*C, C, C++, Visual Basic,

HTML, XML

Hardware IBM COMPATIBLES PENTIUMS, DEC ALPHA, HP-9000

3rd Party Tools Microsoft Project, Microsoft Visio, MS Office, FTP

7.0/6.0/5.0, TOAD, SQL Navigator, ERWIN, Macromedia

Generator, PVCS ERP Change Manager, PVCS Tracker, Crystal

reports. Secure CRT, Formatter Plus 1.4.0, Data Loader,

AppWorx System Scheduler, Smart dB Workbench

O/S Windows Professional, NT, 2000, Sun Solaris 2.4,7,8 HP-UX

10,11

PROFESSIONAL EXPERIENCE

Oct 06 To Feb 10, TRACO, Cranberry PA

SENIOR ORACLE PROGRAMMER ANALYST

ORDER MANAGEMENT/INVENTORY/PROCUREMENT

PRINCIPAL ANALYST FOR THE ORGANIZATION ORDER MANAGEMENT, INVENTORY CONTROL,

MASTER PRODUCTION SCHEDULE AND ADVANCED SUPPLY CHAIN PLANNING. INVOLVED IN

ANALYSIS, PLANNING AND DESIGN OF BILL OF MATERIAL RESTRUCTURE PROJECT.

PREPARING SCOPE DOCUMENTS, GAP ANALYSIS/ TECHNICAL SPECIFICATIONS FOR THE

PROJECT. MANAGING ORGANIZATION CUSTOM APPLICATION INTERFACES TO ORACLE.

DESIGNED AND DEVELOPED CUSTOM REPORTS TO SHOP FLOOR USING ORACLE REPORTS,

REPLACING THE EXISTING PAPER WORK. MANAGED ASCP PROCESSES AND DAILY PLAN

GENERATION TO THE PRODUCTION SHOP FLOOR. ANALYSIS, DESIGN AND DEVELOPMENT

OF CUSTOM INVOICES TO THE NEW BUSINESS UNITS IN AP/AR MODULES. ALSO

DEVELOPED DUNNING LETTER CUSTOMIZATION AND CUSTOMER RECEIVABLES AGING

SUMMARY REPORTS. PREPARING TEST SCRIPTS FOR IMPLEMENTING BUSINESS RULES

RESPONSIBILITIES:

. SUPPORT ORACLE APPLICATIONS END USER POPULATION AND THE BUSINESS

ANALYSTS

. Extensively utilized the Application Object Library to register

SQL*Loader programs, shell scripts, PL/SQL Procedures, Forms and

Reports. In addition, also used the System Administrator

responsibility to responsibilities, Value Sets and Request Sets

. DEFINED KEY AND DESCRIPTIVE FLEX FIELDS TO CAPTURE ADDITIONAL

INFORMATION ABOUT ORDERS AND TRANSACTIONS IN ORDER MANAGEMENT

. TROUBLESHOOTING CUSTOM ORDERS THROUGH INTERFACES

. FIXING ISSUES ARISING DUE TO INTERORG TRANSFERS OF ORDERS, MAKE VS BUY

PARAMETER

. INVOLVED IN DESIGNING AND DEVELOPING VARIOUS REUSABLE PACKAGES (STORED

PROCEDURES AND FUNCTIONS) USING PL/SQL, WHICH WERE UTILIZED BY VARIOUS

PROGRAMS

. Interfacing and integrating legacy systems with ORACLE E-Business

Suite

. Implement and integrate surrogate(SIEBAN) keys across oracle modules

. Modified bills and routings at the level of the product category to

improve performance

. Interfacing items/bills/routings/orders from a non Oracle quoting-

engineering bill of materials system into Oracle Order Management

. Design, develop and deploy custom retail and commercial Invoices

. Customizing the dunning letters per business needs

. Defined customer profiles, customers, payment terms, payment methods

and exceptions in account receivables

. Interface redesign for Bill of Materials

. CREATED FUNCTIONAL DESIGN DOCUMENTS FOR CUSTOM INSTALL BASE APIS AND

FOR INTERFACES TO INTEGRATE ORDER MANAGEMENT, CONFIGURATOR, AND THIRD

PARTY APPLICATIONS.

. PERFORMANCE TUNING OF APPLICATIONS

. EXTRACTING DATA FROM ORACLE DATABASE AND GENERATING EXECUTIVE REPORTS

IN MICROSOFT EXCEL, MICROSOFT ACCESS AND ORACLE REPORTS.

ENVIRONMENT: ORACLE APPLICATIONS 11I, ASCP, HP UNIX 11.0, WINDOWS

PROFESSIONAL/NT, SHELL SCRIPTING, ORACLE 10G/9I/8I, PL/SQL, PRO*C, HTML,

XML, JAVA, JSP, .NET, TOAD, CVS, ORACLE FORMS 6I, REPORTS 6I, SOFTTECH

CONFIGURATOR, FENETECH, BOSS SYSTEMS, MS OFFICE TOOLS

Sep. 04 - Oct. 06, DTE Energy, Detroit MI

PRINCIPAL ANALYST

MAJOR ACCOUNTS BILLING/ORACLE FINANCIALS

ANALYSIS, DESIGN, ENHANCEMENTS AND PRODUCTION SUPPORT TO THE CUSTOM BUILT

APPLICATION DEVELOPED USING ORACLE FORMS/REPORTS, PRO C AND VISTA IN HP

UNIX ENVIRONMENT. CUSTOMIZING ORACLE FINANCIALS MODULES. PERFORMANCE

TUNING AND RE-DESIGN OF APPLICATION TO INTEGRATE CHANGING BUSINESS NEEDS

AND TO COMPLY WITH IN SARBANES-OXLEY(SOX) REGULATIONS. . AUTOMATION AND

ENHANCEMENTS TO ELECTRONIC BANKRUPTCY PROCESS USING WEB SERVICES. DATA

MODELING/ DATA MAPPING AND DEVELOPMENT OF INTERFACES BETWEEN SAP AND

ORACLE. FIRST LEVEL PRODUCTION SUPPORT TO MAB (MAJOR ACCOUNTS BILLING) AND

MULTI VENDOR METER READING SYSTEMS.

. APPLICATION ANALYSIS AND DESIGN OF MAJOR ACCOUNTS BILLING MODULES.

. DATA MODELING FOR ELECTRONIC BANKRUPTCY PROCESS

. ANALYSIS, DESIGN, DEVELOPMENT AND IMPLEMENTATION OF ELECTRONIC

BANKRUPTCY

. INTEGRATED COMPLEX BUSINESS LOGIC UTILIZING PL/SQL PACKAGES,

PROCEDURES AND FUNCTIONS

. AUTOMATED OPEN/CLOSE PERIODS PROCESS IN GL, AR, AND AP

. DESIGNED AND DEVELOPED THE CONVERSION PROCESS FOR HISTORICAL AR

TRANSACTIONS INTO RECEIVABLES DURING THE IMPLEMENTATION PROCESS

. DEVELOPED INTERFACES FROM MAINFRAME AND CUSTOM DATA SOURCES TO ORACLE.

. 24X7 ON-CALL PRODUCTION SUPPORT TO THE KCS (KEY CUSTOMER SERVICE)

APPLICATIONS.

. DATA MINING AND DATAFLOW ANALYSIS FROM MULTIPLE SOURCES OF DATA

. INITIATING PRODUCTION CONTROL BILLS TO 4MILLION CUSTOMERS

. CREATING MAESTRO SCHEDULES, IMPLEMENT AUTOMATIC BATCH JOBS USING SHELL

SCRIPTS IN HP UNIX, PROCEDURES IN ORACLE 9I AND REPORTS USING VISTA

ENTERPRISE SOLUTIONS

. CROSS PLATFORM INTEROPERABILITY BETWEEN WINDOWS NT/UNIX OPERATING

SYSTEMS

. INTERFACES BETWEEN SAP AND ORACLE. ETL PROCESS USING INFORMATICA

. CUSTOMIZED REPORTS TO BUSINESS PARTNERS USING ORACLE REPORTS

. DESIGNED AND IMPLEMENTED THE COMPLETE INTERFACE (API'S) TO ORACLE

APPLICATIONS TO BE USED IN JOB SCHEDULING EFFECTIVELY AND OPTIMALLY

USING MAESTRO ENTERPRISE SCHEDULING TOOL

Environment: HP UNIX 11.0, Windows Prof/2000/NT, Shell Scripting, Oracle

8i/9i, PL/SQL, Pro*C, TOAD, Oracle Applications 11i, SOA, BPEL Maestro

Enterprise Scheduler, Informatica, ERWIN, Clearcase and Lighthouse LDAP,

VISTA.

Sep. 03 - Sep. 04, Dominion, Pittsburgh, PA

SENIOR PROGRAMMER ANALYST

DATA WAREHOUSE

DEVELOPMENT AND PRODUCTION SUPPORT TO ORGANIZATION DATAWARE HOUSE

APPLICATIONS, DESIGN, DEVELOP AND IMPLEMENT PROGRAMS, AUTOMATE THE PROCESS,

DEVELOP SHELL SCRIPTS/ FRONT-END APPLICATION USING ORACLE BACKEND AND

COGNOS FRONT-END. IMPLEMENT SCHEDULER AND CRON JOBS FOR BATCH PROCESSING.

RESPONSIBILITIES:

. DEVELOPMENT OF TECHNICAL SPECIFICATIONS, CODING THE BUSINESS LOGIC

USING ORACLE PL/SQL, GENERATING CONTROL CARDS, DEVELOPMENT OF SQL

SCRIPTS AND ORACLE PROCEDURES TO INTERACT WITH DATA WAREHOUSE

. PRODUCTION SUPPORT TO THE ORGANIZATION DATA WAREHOUSE

. DATA MINING AND DATAFLOW ANALYSIS FROM MULTIPLE SOURCES OF DATA

. PERFORM APPLICATION MAINTENANCE; TROUBLESHOOT PRODUCTION PROBLEMS, AND

IMPLEMENT-REVISED SCRIPTS, DESIGN CHANGES TO DATA WAREHOUSE SCHEDULES,

MONITORING JOBS AS PER CRON SCHEDULER

. ANALYSIS AND DESIGN OF MARKETING DATABASE MODULE, ER DIAGRAMS, CODING

USING PL/SQL AND FRONT-END DEVELOPMENT USING COGNOS

. DEVELOP KORN SHELL SCRIPTS AND AUTOMATE THE PROCESS FOR CRON JOBS

ENVIRONMENT: SUN SOLARIS 5.8, WINDOWS 2000/NT, SHELL SCRIPTING, ORACLE

APPLICATIONS 11I, ORACLE 9I, PL/SQL, JAVA, SQL NAVIGATOR, TOAD AND CC

HARVEST.

Jan 03 - Aug 03, Armstrong World Industries, Lancaster, PA

SR. TECHNICAL CONSULTANT

WOOD REBATE INTEGRATION

INVOLVED IN DEVELOPMENT OF CUSTOM APPLICATION AND INTEGRATED IT WITH ORACLE

APPLICATIONS.

. Involved in loading data from flat file to Accounts Receivable through

Customer Interface

. Developed custom forms and reports to enhance rebate business process.

. Used CUSTOM.pll to implement change in behavior of Standard Oracle

Application forms in Order Management

. Involved in customization of Payables open interface

Environment: Sun Solaris, Oracle Applications 11i, OM, AP, AR, Oracle

9i/8i, Forms 6i, Reports 6i, Discoverer, PVCS, Windows 2000

Sep. 02 - Nov. 02, Federated Investors, Inc., Pittsburgh, PA

Applications Analyst/Systems Programmer

Worldwide Investment Tracking Database System

Enhancements to the custom application

. Migrated the application to Oracle 9.2 and Forms to 6i in HP UNIX

environment

. Converted Oracle Forms from 4.5 to 6i version.

Performed unit testing, data testing and application integration

testing.

. Worked in HP UNIX environment

. Developed Shell Scripts and C Programs to perform business logic

. Coverted jobs from 'C' Shell to 'Korn' Shell

. Developed BMC enterprise scheduler jobs

Environment: Windows 2000 Workstations, HP Unix, Oracle Applications 11i,

Oracle 9.2/7.3, Oracle Developer 6i, Forms 6i, Reports 6i, Designer

6i/2000, MS Access, JAVA, Oracle 6i Toolkit, PL/SQL, TOAD

Feb. 01 - Feb. 02, Allegheny Power, Greensburg, PA

Specialist, Developer

GAS MANAGEMENT INTRANET APPLICATION

Intranet based Gas Management comprehensive system with six (6) modules

performing the tasks of gas nominations, distribution, delivery,

billing/invoicing and payments. Performed repository management and

versioning tasks to the application.

. Maintained gas management intranet application in a team environment.

Enhanced application modules, performance tuning and optimization

. Developed custom Forms and Reports on Oracle9i Application Server

. Modified Date Flow Diagrams to incorporate the Pooling implementation

logic and performed repository management, version control, branching

and dependency analysis

. Fixed bugs to the system for inconsistent run time problems. Client

side validation performed using JavaScript. Front-end design and

development carried out using Oracle WebDB and Portal

. Developed gas interfaces using Pro * C and C Programming

. Prepared project documentation for different areas of gas management

system. Provided on site training to the end users

. Met with user groups to discuss and design enhancements to system.

Commended for quick response time and ability to coordinate diverse

needs into coherent system

Environment: Oracle 8i, Oracle Designer 6i, Oracle Forms 6i, Reports 6i,

WebDB 2.3/Oracle Portal 3.0, JDeveloper, PL/SQL, SQL Navigator, VSS 6.0,

JavaScript 1.2, HTML 3.2, Pro*C, C

Oct. 94 - Feb. 01, Vapco Engineering, Punxsutawney, PA

Computer Engineer / Programmer

CONSOLIDATED PENN LABORATORIES

Analysis, design and development of relational data base management system

. Designed schema for the system, migration of data to Oracle using SQL

Loader and developed data types, tables and indexes

. Developed complex PL/SQL packages, stored procedures and database

triggers for the process of the data

. Front-end developed using Developer 2000 (Forms 4.5 and Reports 2.5)

. Initiated, designed and developed user interface screens/custom

reports

. Developed modules using Pro*C to perform business logic,

. Migrated reports to the FTP server so that clients can access data

remotely.

. Program enhancements to trigger when the data reaches certain

department of environmental protection allowable limits

. Created object groups (.olb) and PL/SQL libraries (.pll) for the

coding standard and inheritance

. User modules designed using Oracle WebDB and client validation with

JavaScript

Environment: Windows NT Workstations, Windows NT, Oracle 8.1, Oracle

Designer, Developer 2000 (Forms 4.5/5.0, Reports 2.5/3.0), Microsoft

Access, Visual Basic, VBA, Dbase, SQL Navigator, PL/SQL, SQL & C

Jan. 92 - Jun. 94, Rural Development, Government of A.P. India

Information Systems Engineer

WORLD BANK AIDED MUNICIPAL ROAD PROJECT

. Designed and developed organization information systems

. Instrumental in design and development of the database

. Data migration and generated executive reports

. Municipal roads and cyclone relief programs were implemented using GUI

tools

EDUCATION

. MS in Engineering, Osmania University, India

. Professional courses in Oracle, Java, C++

Contact this candidate