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.