AddThis Social Bookmark Button
Frank Koconis ( Available )
Matthews, NC - 28105 USA
Expertise :DB2, Data Modeling, FileNet
Status :Citizen
Job Type :
All -
Position :

Resume
 
Summary


DATA MODELER or ANALYST and DATABASE DESIGNER or ADMINISTRATOR
Certified database professional with extensive experience in all phases of database and data-warehouse design, development, implementation and administration. Excellent communication skills and the ability to learn new technologies very quickly. Experienced and proficient in
Requirements Analysis
OLTP and Data Warehouse Design
Implementation and Administration
Application Development
Performance Analysis and Tuning
Business Intelligence Solution Design
Report Generation and Cube Analysis
Enterprise Search Systems
Enterprise Content Management ECM


Employment

1998 -  2009

IBM Corporation Charlotte , NC

Data Management Business Partner Technical Enablement Consultant
Provided technical assistance to partners in requirements analysis, architecture design, development and implementation of transactional OLTP, data-warehouse, ECM and enterprise search applications
Solved difficult performance tuning, troubleshooting and administration issues for partners

Developed and presented technical training workshops for business partners

Presented at partner-related technical conferences and other events :
IBM Information OnDemand
IBM s Software University
The IBM Software Symposium
The DB2 Users Group conference
IBM s Technical Leadership Exchange
IBM s Data Management Technical Conference
IBM s ECM Partner Summit
The Informix User Forum

Assisted partners in pre-sales, post-sales, proof-of-concept and pending-customer situations
Influenced our product development to better support partner needs by soliciting and documenting partner requirements and business needs
Wrote and published articles on RDBMS- and ECM-related topics for technical journals hired by Informix, then Informix was acquired by IBM in 2001


1996 -  1998
System Architect

Broadway and Seymour Charlotte , NC
Designed object model for the client side of a retail banking transaction-entry system, participated in the implementation of the system in Java/JDBC on Oracle
Designed and developed a generic form creation and processing tool

Designed and led training courses on Java programming and RDBMS theory and design Oracle


1995 -  1996
Senior Software Specialist

Management Systems Designer Charlotte , NC
Developed user interfaces and Oracle database applications in C with embedded SQL


1995 -  1998
Part-time evening Computer Technology Instructor

concurrent with above 2 jobs


1994 -  1995
Computer Technology Instructor

York Technical College Rock Hill , SC

Taught curriculum courses in RDBMS, programming, operating systems and IBM PC applications
Introduced the UNIX operating system into the Computer Technology curriculum


1992 -  1994

Environmental Data Resources Southport , CT
Environmental research, reporting and information services
Geographic Information Systems Application Developer
Developed GIS applications in C using embedded SQL for the Oracle database and ArcInfo
Administered the Oracle database and the ArcInfo geodatabase


1988 -  1992
Self-employed Application Development Consultant

Contract Programming Charlotte , NC
Developed custom database and engineering applications using the C and Clipper languages
Developed ORACLE database applications using embedded SQL and C
Engaged in cooperative sales efforts with clients re-selling custom applications software

C and Oracle database Application Development on UNIX systems




Education

MS in Computer Science
University of N.C. at Charlotte

BS with high honors in Information and Computer Science
Georgia Institute of Technology
PRODUCT CERTIFICATIONS AND TRAINING

* = Official Certification
Database Administrator DBA - DB2 UDB* , Informix* , Red Brick Warehouse* , Oracle
Business Intelligence Solution Designer - DB2 UDB*
Application Developer - Oracle Pro - C , JDBC , Information Integrator Content Edition , OmniFind
ECM System Installer , Administrator and Solution Designer - FileNet P8* , IBM Content Manager*
Enterprise Search Administrator and Developer - OmniFind
System Administrator - AIX , WebSphere Application Server



Training

Overview of Technical Skills
Database Systems
DB2 , Oracle , SQL Server , Informix , Red Brick Warehouse , Cloudscape , MySQL , Access , Unify , RDB , Focus and others
Data Modeling
Erwin , Rational Rose , Normalization , OLAP star- and snowflake-schema design
Database Application Development
Java or JDBC , PL/SQL , Embedded SQL in C Oracle Pro-C , J2EE , EJB s , JSP s , JavaScript
ETL and Reporting
DataStage , Crystal Reports , Brio Query , Informix MetaCube
Enterprise Search
OmniFind
Enterprise Content Management
FileNet , IBM Content Manager , Information Integrator Content Edition , IBM Classification Module , eDiscovery Manager
Geographic Information Systems
ArcInfo , ArcGIS
Operating Systems
AIX , Solaris , Linux , HP/UX , UNIX , Windows 2000 or 2003 or XP or Vista
Application Servers
Websphere Application Server


Miscellaneous

MS in Computer Science
University of N.C. at Charlotte
BS with high honors in Information and Computer Science
Georgia Institute of Technology
PRODUCT CERTIFICATIONS AND TRAINING
Official Certification
Database Administrator DBA - DB2 UDB*, Informix*, Red Brick Warehouse*, Oracle
Business Intelligence Solution Designer - DB2 UDB*
Application Developer - Oracle Pro - C, JDBC, Information Integrator Content Edition, OmniFind
ECM System Installer, Administrator and Solution Designer - FileNet P8*, IBM Content Manager*
Enterprise Search Administrator and Developer - OmniFind
System Administrator - AIX, WebSphere Application Server