Post Job Free

Resume

Sign in

Oracle Management

Location:
Carmel, IN, 46032
Posted:
November 02, 2010

Contact this candidate

Resume:

Satish Gummalla

***** ***** ***** ( Carmel, IN 46032 ( 317-***-**** ( abic3z@r.postjobfree.com

Career Direction

Providing senior management expertise for mission critical Information

Technology projects, including system integration, migration, security,

outsourcing management, software product design & development, techno-

functional expertise in Oracle ERP life cycle implementations, data

migration, Oracle Discoverer administration, COGNOS Business Intelligence

tools & Business Analysis.

Skilled in managing IT departments, quality assurance & compliance

management, root cause analysis, quality management systems (ISO9001), and

Sarbanes-Oxley compliance. Leading enterprise-wide technology initiatives

and partnering with leaders of business units.

Education

Executive MBA, Krannert School of Management, Purdue University

M.S. Math/Computer Science, Indiana State University, Terre Haute, Indiana

Project Management Certification Credits, Indiana University/Purdue

University, Indianapolis

Member of American Society for Quality (ASQ)

Skills

SKILL NAME SKILL LEVEL EXPERIENCE LAST USED

Process knowledge Oracle 11i, Expert 8 Years Current

12i(Oracle Financials, Manufacturing

Processes, Shop Floor, Mfg.

Execution, Order management,

Contracts, Purchasing, Inventory,

BOM, WIP, INV, MPS/MRP/AP/AR/GL,

Purchasing and fixed assets)

Project Management, Quality Assurance Expert 5 years Current

Management, tools used, TestDirector,

LoadRunner

Oracle 11i - Manufacturing (Process, Expert 5 years Current

Flow and Discrete)

Oracle 11i - Order Management & Expert 5 years Current

Advanced Pricing

Oracle 11i - Advanced Planning and Intermediate 2 years Current

GOP, Oracle XML Publisher

Process Knowledge(Clinical, & Expert 5 years Current

Telesales Modules)

Oracle 9i, Oracle 10g, Toad, Power Expert 5 Years Current

Builder

Oracle AIM Methodology, Rational Expert 5 Years Current

ClearQuest, SDLC & Sarbanes-Oxley

compliance, Quality & Compliance

MS Project, MS Office, Visio, CITRIX, Expert 7 Years Current

UNIX Admin

Renaissance CS (ERP) (Mfg, SOP, POP, Expert 5 Years 2004

ATP, etc.)

Application Development (Oracle 9i, Expert 7 Years Current

Oracle 10g, Forms, Reports 6i/9i,

Oracle Discoverer 4i/9i/10g, Crystal

Reports, DBA, Backup & Recovery,

System Administration, Systems

Support, SQL Tuning, COGNOS BI,

BI-Publisher, Web-ADI, Discoverer,

Workflow, and SQL Loader, SDLC, etc.)

MES Systems (GE - Cimplicity, Expert 3 Years 2002

POMS-MES)

Data Base Administration (Oracle, Intermediate 5 years Current

Sybase, Backup and Recovery, database

tuning SQL Server)

Source Code Control and Software Expert 5 Years Current

Change Management (Mercury ITG, PVCS,

ETL, EDI Gateway and Source Safe)

Internet Programming (ASP, Cold Expert 4 Years Current

fusion, .NET, ASP.NET, JSP, HTML,

Perl, Informatica programming

experience, Data Warehouse

experience)

Gummalla, page 2

Professional Experience

EXACTTARGET, Indianapolis, Indiana. U.S.A

August 2009 to present

Oracle E-business suite Global support and Implementations

. Integration of accounting/finance, salesforce.com systems with Oracle

E-Business financial systems, managing/support and execution of

coordinated Global E-Business suite Enhancements for UK and US

operating units.

. Training, Integration, design and development of RICE

(reports/interfaces/conversions/enhancements)

sVN ASSOCIATES, INC, Georgia, Atlanta. U.S.A. July

2003 to August 2009

Sr Manager/Management consulting

. Responsible for the project management and full-life cycle

implementations of Oracle ERP Financial applications, design and

development of oracle e-business suite custom applications. Extensively

worked on AR, GL and AP interfaces developed customized payable and

invoice reports.

. Managing and key contribution to design and development of data

conversations and data warehouse project life cycle implementations &

Business Analysis and provided effective resolutions to improve the QA

testing practices for web technologies, Oracle Financial applications.

. Managing Corporate Information Systems Strategies, SOX Compliance Data

Analysis, Business Development and Management Consulting. Lead

implementation stages such as discovery, design, configuration, testing

and deployment of multiple IT projects with a defined beginning and end.

. Responsible for ERP- Oracle financial production support for various

financial modules, designed and developed custom Oracle discoverer

reports for Oracle financials modules.

. Responsible for the project management and full-life cycle

implementations of Oracle ERP Financial/Manf applications. Defined

project scope, gathered requirements, researched and designed and

developed various custom applications in Oracle11i Modules, Oracle

Warehouse Builder, Oracle Application Server and Oracle Portal.

. Designed and developed data model for migrating G2 AR/AP accounts into

Oracle Financials E-Business suite. Implementation of SOX compliance

process, QA testing and execution process, life cycle document

management.

. Oracle E-Business Suites enhancements including Design and Development

Custom Oracle discoverer reports for AR/AP/Order Entry/Manufacturing

modules.

. Design & development of custom reports using Oracle Reports 6i and

Oracle Discoverer 4i for Order Entry process. Developed data

transmission between financial applications using XML publisher.

. Migrated inbound data files using Oracle EDI Gateway into Order Entry

and Oracle Financials. Developed effective QA strategies and provided

specification for testing case scenarios and defect tracking mechanism.

. Design and Developed Specifications for Migration of data and

customization of existing Oracle Applications Customization of Telesales

Modules, enhancements to existing applications.

. Extensively worked on migrating the data from Oracle 10.7 to 11i,

Involved in Data conversion into interface tables of manufacturing

modules. Developed various Packages and Triggers for Data Migration and

Validation checks.

. Designed and developed various reports and customized the existing

.pll for enhancements. Created Packages and procedures to extract 10.7

Financial Applications Data to 11i applications.

. Work closely with Big 5 consulting companies such as Accenture with focus

on software implementation, provided expertise in processes change

management, Implemented SOX compliance process, evaluation of business

and system requirements and project related research on business and

technical trends and dependencies.

Gummalla, page 3

Client assignments:

> Indiana State Dept of Child Care/Health Services,

Indianapolis, Indiana. U.S.A

Kaplan Financials, Indianapolis, Indiana. U.S.A

> Accenture

> Alcoa Closure Systems International, Indianapolis, U.S.A

> Midmark Corporation, Dayton, Ohio, U.S.A

> ATA Airlines Indianapolis, Indiana, U.S.A

> Arrow Electronics, Cleveland, Ohio, U.S.A (Electronics and

Electric Industry)

Ingersoll-Rand, Indianapolis, Indiana, U.S.A.

Sr Oracle ERP Manufacturing Applications Development/Quality Testing

March 2001 - June 2003

. Design, development, Support and enhancements of existing ERP

Financial/Manufacturing applications. Development of Quality

Specifications concerning with regard to user testing case scenarios and

issue tracking.

. Designed specifications for development of custom reports extracts from

manufacturing and financial modules. Developed Custom Oracle discoverer

reports for Oracle financials modules

. Production support for Oracle Discoverer administrations, EUL, security

setups etc. Managed and contributed to enhancement to existing Oracle

Discover software, and have also provided administrative support.

. Created Several Shell Scripts to enable the data loading process and

also to enable the users get the database information.

Automotive Finance Corporation, Indiana, U.S.A.

Sr Oracle ERP Applications Analyst/Application testing

October 1998 - March 2001

. Developed data load scripts using Oracle SQL*Loader for migration of

legacy data into Oracle. Customization of existing Oracle forms.

Created various Data Validation Packages.

. Designed and Developed Customized reports to extract Data from AP

Modules. Wrote several Procedures, Packages and Functions on Financial

Interfaces.

. Involved in testing various developed applications, test case scenarios,

and Error Tracking issues. Data migration into AR, AP financial

interfaces from external mainframe systems.

. Designed and developed technical specification document to generate

Oracle Reports for AP and AR financial modules.

. Worked on various custom .pll to incorporate new business requirements.

Indiana State University, Terre Haute, Indiana, U.S.A.

Graduate Assistant

January 1997 - October

1998

. Management of Networking and Computer labs.

. Assisted professors in Chemical Laboratory analysis, testing and

computing test results.

. Assisting professors in various academic and networking projects.

. Assisted students in web designing and networking issues.



Contact this candidate