Sql Sales
Resume:
Edward Kosciuszko
Charlotte, NC 28277
Professional Highlights
Over 35 years experience in ORACLE application development, DBA activities and training. ORACLE V2 - V12
Expert in SQL specification and optimization. Generally used to diagnose performance problems or assist developers to SQL specification.
Designed first SQL optimization product; ExplanSQL, now owned by Computer Associates and renamed to SQL*Station.
Developed numerous PL/SQL systems plus APEX applications and web services.
Patent for simulating virtual indexes to view impact on SQL execution plan (patent 6,317,736) used in original ExplainSQL product
Frequent lecturer on DBA and developer topics (SQL & PL/SQL).
Well-known writer for publications Database Programming & Design, Pinnacle’s ORACLE Developer, and local ORACLE user group newsletters. Editor's Choice Award from IOUG for best technical article in 2002.
Accomplished trainer. Trained for ORACLE Corp and independently. Designed SQL courses taught at various companies/user groups.
Expert in ORACLE application issues, such as OCI interface, security, transaction processing, cursor management, and locking. Guided developers in optimal interface to ORACLE.
Database design; implemented generally advisor or reviewer of design.
PL/SQL experience starting with ORACLE V6.
Employment/Consulting History
2006-Present
Pearson Inc
Designed and implemented MDM-like system to consolidate Pearson products from all divisions. DB design based on "columnar design" and implemented with composite partitions to separate each source. Entire system defined with metadata (object oriented for inheritance). Views of metadata, similar to ORACLE dictionary views, displayed all global tables and subsets for individual sources. Developed PL/SQL procedures to read metadata via views to automatically adjust repository data structures, create schemas for individual data sources along with staging tables, triggers, load procedures, views and XML views, and all granting of privileges. XML views and web services used to deliver change data to consumers. APEX dashboard created to manage/edit metadata. Other APEX applications created to provide views of data and extract change data information.
Created HR system to assist in determining employee bonuses. All employees from all divisions consolidated with MDM-like processing to merge employees listed in various foreign locations to identify management structure. System populated by feeds from all world-wide divisions with feedback to assist divisions in correctly identifying employees and management. APEX used.
Provided SQL and API optimization consulting to various groups. Tools used, TKPROF, V$ tables, LogMiner, custom batch procedures.
During years 2011-2013 worked part-time providing support for systems.
2015-2016
CNA National
Phase 2 of project to manage car warranty products for dealers and agents. Modified expansion and publishing of "aggregated product details" via PL/SQL. Rule-based system automated via metadata to procedurally generate trigger code containing rules. (Consulted part-time from Dec 2015 to July 2016)
2011-2013
CNA National
Provided SQL and SQL optimization training course. Provided SQL specification and optimization expertize to various groups. Consulting on DB design.
Implemented sections of car warranty application to simplify customization of complex warranty contracts using "aggregated product details", allowing a rule-based system to allow expansion of "aggregated product details". Used rule-based system to publish authorized contracts.
2000-2006
Kosware Inc
ORACLE training and consulting. Working on design for new SQL Optimization product that parses syntax to determine run-time/reporting errors and using a knowledge base to determine the optimal transformation without user interaction.
1997-2000
Platinum Technologies
Instrumental in evolving ExplainSQL (renamed PAFO) into an automatic SQL tuner. Significant enhancements include detection of valid SQL syntaxes that produce invalid results; algorithm to transform syntax yet maintain semantics of original SQL allowing ORACLE’s optimizer to better optimize plus giving user more tuning control; and patented algorithm to simulate affect of various indexing structures on execution plans on production systems without interference.
Consulted to other development groups. Analyzed technical differences of competing products such as SQL Expert, and SQLab to assist sales force.
1995-1997
SQL Tools
Company founder. Designed first SQL optimization tool, ExplainSQL, to assist users in optimization process and monitoring of SQL utilization. Instructed C++ code on OCI interface. Wrote documentation and sales brochures, gave seminars nation-wide to promote product, established sales distribution, and provided customer support. Company purchased by Platinum Technologies.
1992-1998
Merrill Lynch
Implemented HR recruiting system using SQL*Windows from Gupta Technologies.
Designed Pro*C applications to simulate OLTP processing on various SMP hardware to evaluate HW.
Evaluated other DBMS products; Sybase, SQL*Base, and Informix.
Instructed DBA on ORACLE configuration and maintenance.
Provided SQL specification and optimization expertise to various groups in Investment Banking group.
Analyzed applications for ORACLE access methods and performance.
Created and taught SQL and OCI courses to developers.
1989-1992
Pfizer
Implemented New Drug Application (first electronic NDA application) used for drugs trials with a combination of IAG/IAP (SQL*Forms) linked with MS Assembler and C program used to generating reports. Application allowed FDA quick, flexible access when evaluating drug.
1988-1989
Allied Signal
Assisted various groups in SQL specification and optimization; SQL*Forms instruction; taught SQL course to various divisions.
Fortex Corporation
1986-1987
Using technical knowledge of ORACLE, redesigned an in-house product that generated C applications for ORACLE as alternative to SQL*Forms. Wrote manuals for product, Passport. Demonstrated and marketed product at user conferences.
1981-1986
Oracle Corporation
As one of the first employees (~27th), initially trained and supported clients, assisted sales force giving product demonstrations and building client demo applications. In 1983 opened and managed the NYC sales office.
Education
1978-1983MS Computer Science, George Washington University, Washington, DC
(Completed all requirements but did not take final comprehensive exam due to moving to NYC to manage ORACLE office.)
1975-1976 Graduate Work Physics, University of Wyoming, Laramie, WY
1970-1974 BS Physics, Norwich University, Northfield, VT
Publications/Seminars
ORACLE Developer (Pinnacle Publishing): Eventually renamed Oracle Professional
Use PL/SQL's New Messaging Techniques to Create Better Client/Server Applications - (1994)
How to Stop Mutating Triggers - February 1995
User Triggers for Table Audits and Row-Level Security - April 1995
Beware of NULLs and Outer Joins - May 1995
The Trouble with Outer Joins - June 1995
Why Optimize SQL? - July 1995
Create Better Optimization Plans - August 1995
Best Practices for Writing DML Statements - September 1995
Best Practices for Cursor Management - October 1995
Best Practices for Transaction Management - November 1995
Use an EXPLAIN PLAN to Understand Oracle SQL Optimizer - January 1996
Best Practices for Error Handling - February 1996
Best Practices for Locking and Read Consistency - March 1996
Optimizing SQL: Rewriting SQL Subqueries Into Joins - September 1998
Optimizing SQL: Rewriting Non-Correlated Subqueries - November 1998
SQL Optimization: Optimizing with Bind Variables - January 1999
Review: Automating SQL Transformations - February 1999
SQL Optimization: It Ain't the Cost - March 1999
Points of Contention, Part 1 - March 2000
Points of Contention, Part 2 - April 2000
Points of Contention, Part 3 - May 2000
Database Programming & Design (magazine): Published 4 articles on SQL optimization and database application developer and administrator issues.
Putting Confidence In Your Integrity - June 1992
Implementing Integrity in Oracle, Part II - July 1992
Optimizing the ORACLE SQL Outer Join - February 1992
Oracle User Groups: Published numerous articles and lectured throughout the years on various ORACLE topics.
SELECT Journal (International Oracle Users Group magazine) Received Editor’s Choice Award for 2002 for article “Analytical Functions in ORACLE 8i”.
Contact this candidate