Steve Purtee
PO Box 323
Carmel, IN 46082 [Send email using form at bottom]
Performance Specialist DBA
Summary
* Twenty (20) years experience with Oracle Databases beginning with Version5
through the latest release 11g.
His broad work experience has been focused on Performance activities in the
specification, design, architecture
and implementation of Oracle database applications. He has held numerous
technical leadership roles.
* Deep experience in 11i eBiz implementations. Performed workload
characterization and capacity planning,
profiling key Business transactions to improve Business performance. RAC and
single node configurations.
* Demonstrated outstanding technical skill and leadership, coaching and
mentoring teams engaged in the
development, implementation and performance tuning of Oracle Financial, Custom
applications.
* Experience with non-Oracle databases as Technical Lead for custom application
and database system migrations,
SQL Server, Sybase, Ingres.
* Experience includes the use of Oracle’s complete toolset including OEM,
Designer and Developer. CDM and
AIM “deliverable based” methodologies and management tools. He has broad
technical experience with
Oracle’s complete technical architecture, tools, and database administration
capabilities on Unix, Linux, and
Windows operating systems.
* Prior to working for Oracle he has been a CASE Administrator, Senior Database
Administrator and Developer
for engineering, pharmaceutical and insurance service corporations in central
Indiana.
Career Experiences
August2006 – October2008 Hotsos Enterprises, Ltd.
Performance Specialist responsible for helping customers to design a high
performance Oracle-based architecture
and to optimize the interactions of packaged or custom applications with the
Oracle database.
Workload characterization, Method-R, workload profiling. Performance assessment
and workload
characterization of Oracle 11i E-Business Suite implementations. Identification
of primary
contributors to System resource consumption allowing focused tuning to improve
Response Time
and reduce Server CPU utilization. The improved Response Time and reduced
resource
consumption provided for $100,000s in cost savings.
Clients: NCR, Pfizer, IntraLinks, MidwestISO, MI-SWACO, Motorola, Imation,
Citigroup, GE, Mattel, BBU, …
March2006 – May2006 Independent Consultant
Performed as Developer Analyst for DOD Contractor General Dynamics developing a
conversion process to
reverse and reapply Oracle Projects transactions from a legacy ERP. Gave
instruction to a dozen
members of the client staff on ‘Release 11i Applications Systems
Administration’.
April2004 – February2006 Oracle Corporation, Application IT Systems (AIT)
Performance Analyst on the daily Production monitoring and support of Oracle
internal Financials Global Single
Instance, GSI – a 4 node RAC of SunE25Ks with 9TB database. Primary
responsibilities were
focused on Human Resources, AP, Trade Community Architecture, CRM, and
Territories business
line areas. Developed and maintained an internal application, JSP J2EE enabled,
for monitoring of
Project-Service Request relationships and status change frequency trend
analysis.
Performance DBA, Oracle GIT EMEA Instance Consolidation project, recommendations
for configuration and
processing improvement for VLDB data migration, import, export, in a multi-node
RAC
environment. Developed variable worker load tools based on CPU usage efficiency
to facilitate
transfers.
December1993 – March2004 Oracle Corporation, Commercial Consulting
Technical Manager for the North Central Performance Architecture group, provided
broad experience in all aspects
of Oracle database operation and implementation. Release 11i implementations of
Oracle
Financial Applications; Order Management, Accounts Receivable, Accounts Payable,
Order
Interface, Customer Interface, Inventory Interface, Warehouse Management and
iPayment..
Numerous performance tuning engagements. Engagements included Operational
reviews of
Business and systems performance on escalated accounts.
Performance Architect & DBA. Oracle Financials 11i implementation. Many of the
engagements were situations
where the Company was suffering from internal systems instability. Served in
the Escalation
Consulting Support team providing Production monitoring and support. Identified
and managed
issues to resolve performance barriers to enhance Business productivity.
Performance Architect DBA, Major Internet Company Incubator Online Auction
Community, Oracle Financials
11i implementation, Led performance tuning team, focus on Order Management,
Accounts
Receivable, Warehousing, with specific attention to Order interface, Customer
interface, Inventory
interface, iPayment authorizations, and custom application implementations for
Performance
Architecture. Escalated engagement with high throughput demands from client
achieved
approximately 300% improvement in processing from original baselines.
Skills Summary
* Performance Tuning
* Data Modeling / Design and Requirements Facilitator
* Technical Architecture
* Applications Development
* Project Management
* Database Administration
* Database and Applications, Design and Implementation
* Business & Technical Process Reengineering
* R11i – OM/OE, WMS, INV, AR, TCA
* Develop technical architecture strategy
* Order Management, 11i – 10.7
* Data Conversion
Methodology
* Method-R
* CDM Classic
* Oracle Applications Implementation Methodology
* Oracle FastForward Implementation Methodology
* Yourdon
Technology
Software, Tools & Languages
Database
Oracle Applications Versions 11i,
10.7NCA, 10.7SC; Forms Versions 5.0,
4.5, 4.0, 3.0; Reports Versions 2.5, 2.0;
Designer 6i, 2, CASE 5.1, 5.0,
SQL*Loader; SQL*Plus; PL/SQL
VI, XEDIT, KEDIT, MS-Word, Excel,
Powerpoint, MS-Project, Lotus Notes,
3 & 4 GL Languages, JSP, C
Oracle RDBMS 10g, 9i, 8i, 8, 7, 6, 5; Sybase,
SqlServer, Clipper-dBase
Oracle Application Server, iAS
Oracle Enterprise Manager
Performance Tuning, RAC, Disaster Recovery
Planning, Data Guard, Benchmarking, Stress
Testing, Backup and Recovery
Hardware & Operating Systems
UNIX (AIX, HP-UX, Sequent/Dynix, Sun Solaris), Linux, Windows Vista, XP, NT 4.0,
MS-
Windows (3.1, 95, 2K), DOS 3.1
Industry & Process Expertise
* Retail - Order->Cash, Call Center, Inventory Mgmt
* Insurance – Actuarial and Rate calculation.
* Pharmaceutical - Drug Interaction and price lists.
* Consumer Packaged Goods – Inventory
Management, Formulation.
Other Accomplishments
Education
* BS Computer Science, with Honors, Ball State University - Muncie, Indiana
Organizations &
Certifications
* Oracle Developer Tools User Group
* ACM
* Oracle Master Certificate Database Administration (V6)
Presentations &
Publications
* Presentation and article, Oracle CASE SIG Spring 95 (ODTUG):
Management and Administration of CASE 5.X in a Multi-Application Environment.
|