Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
PROFESSIONAL PROFILE
Results Oriented, twenty+ years experience
in Information Systems. Broad expertise,
including Data Modeling, Data Warehousing, Database Administration, System
Architecture, Web Applications, Oracle Training, and Unix System Administration;
high level of technical aptitude and analytical ability. Special talents include development of System
Architectures and Project Leadership. Industry Experience includes Healthcare,
Telecommunications, Oil & Gas, Medical, Legal, Manufacturing, Education and
Financial.
COMPUTER RELATED EXPERIENCE
*** Oracle 9i Professional DBA Certification – July
12, 2003
|
·
20 years Oracle Consulting
from v5 => v11g
|
·
20 years Oracle Database
Administration Experience
|
|
·
20 years Data Modeling,
Transactional and Data Warehousing
|
·
16 years C experience,
familiar with C++ - 16 Years of Pro*C
|
|
·
20 years Oracle Tools,
SQL*Plus, PL/SQL, PRO*C, SQL*Loader,
SQL Developer, TOAD
·
6 months of Oracle Warehouse
Builder v10.2 and 1 month of Cognos v8 Reporting.
|
·
14 years CASE Tool experience
including Oracle Designer 2000; ERwin (4.x and 7.x) , IBM InfoSphere Data
Architect 7.5
·
Rational Software Architect
Suite of Tools – 6 months.
|
|
·
16 years Data Warehousing
using both Dimensional Data Modeling and Classic Inmon Style Data Warehousing
|
·
12 years of Java/J2EE
experience, Including JDBC access of Oracle DB, Java
Servlets, Server Pages,
Enterprise Java Beans, STRUTS and Spring
|
|
·
15 years of HTML/JavaScript
experience
|
·
25 years Application
Programming
|
|
·
14 years Web Architecture,
including Oracle Fusion Middleware v10.1.2.3., Oracle Portal, BEA WebLogic 8.1 & 9.2
App Server, Apache/Tomcat
|
·
18 years UNIX (Sun, HP/UX,
Sequent NUMAQ, AIX) , 18 Years Windows 95/98/NT/2000/XP, 3 years Digital VMS
|
|
·
Internet Explorer, Mozilla
Firefox, Microsoft Office Applications, Open Office, various other PC
Database Packages, CVS, Microsoft Source Safe and Tortoise.
|
·
J2EE Tools - Ant v1.4->1.6
, Struts v0.5 thru 1.2.7 , Struts Console 3.x, 4.x, various XML editors,
JUnit, Eclipse IDE 2.x, 3.1, familiar with Oracle JDeveloper 9i, 10g and
NetBeans 4.1, Spring Framework
|
MAJOR ACCOMPLISHMENTS
Data
Warehouse Architect
Working with the US Forest Service and IBM
to manage the FAMWeb Data Warehouse that the Forest Service uses to manage
aircraft. I am responsible for using
Oracle Warehouse Builder to perform ETL on Source Tables and Load the Data
Warehouse. I am also starting to become
involved with Cognos for reporting.
Data
Warehouse Architect
Working with the US Forest Service and IBM
to port Oracle 8.x databases from local FS offices all over the country to
Oracle 10.2 in a central facility in Kansas City. I am providing database administration
support to database admistrators and developers that are upgrading existing
applications to current technology. I am also providing support to FS offices
around the country who are migrating their MS Accsss applications to the new
data center in Kansas City.
Data
Warehouse Schema Model Cleanup
Assisted InfoNow Corporation with cleanup
of customer schemas in their Oracle RAC Cloud Based Data Warehouse to
standardize the physical data structures and the PL/SQL ETL based code used to
load customer files into the staging, transform them and then load them into
the customer reporting schemas.
Data
Warehouse Data Modeling
Worked as Lead Data Modeler with IBM &
Alameda County Social Services to build dimensional star schema models that
integrate five separate OLTP systems into a Data Warehouse of Data Marts to
facilitate building integrated reports for ACSS clients. I am also teaching the ACSS Staff the basics
of Dimensional Modeling and how to use the IBM IDA Modeling tool so that they
can continue modeling the Data Mart on their own.
Oracle
Database and Fusion Middleware Application Support
Worked with the National Business Center,
US Dept of Interior as an Oracle DBA/Oracle Fusion Ware/Application
Administrator. Some of my
accomplishments while I have been there have included:
·
Upgraded Oracle Fusion
Middleware and all associated products to its current level of 10.1.2.3.
·
Configured an Oracle Reverse
Proxy for Oracle Application Server with an Apache 2.2 proxy
·
Configured custom
Login/Logoff/Change Password Pages to replace Oracle Standard Pages
·
Installed a Custom Stored
Procedure to report on expiring passwords in Oracle LDAP.
·
Reconfigured Custom ACI rules
in Oracle LDAP
·
Used command line utilities to
modify Oracle LDAP Objects
·
Exported Transport Sets and
Imported them into Test and Production
Reporting:
·
Authored Multi-Schema,
Multi-Instance Data Warehouse Reports
·
Authored Bourne Shell Scripts
to automate the process of consolidating report data
·
Authored Program Generators to
automate adding additional reports
Business Objects:
·
Upgraded Business Objects to Xi
v3.1
Security:
·
Repaired Security holes in
Oracle App Server, Apache, Apache Tomcat and JBoss detected with Scanning
Software
·
Designed a plan to move
authentication for all Oracle databases into an Oracle LDAP
Database Administration:
·
Moved multiple databases to new
servers for Disaster Recovery Testing using Oradim
·
Applied Custom Security to
Oracle Databases
·
Oracle Quarterly CPU Patching
·
Coded Sql*Plus scripts to get
all Database Parameters and file system usage from all databases in local
network
Owner/Designer/Developer/Administrator
Designed,
developed, researched all content, built and An internet wiki devoted to
Electronic Book Hardware, Software and many other aspects of Electronic Books.
Data
Modeling/Physical DBA
Worked with Borland International assisting them
bringing their newest product, Team Analytics, to market. I am advising on issues surrounding the
Dimensional Data Warehouse based on the Oracle 10g database that is feed from
multiple other Borland products.
Data Modeling/System Architect
I have lately returned to the same Medical
Manufacturing Company in Denver, CO cited below to continue modeling a Blood
Component Process Control System with multiple Subject Areas. I am also the physical and logical
Development DBA assigned to the project.
I was asked to return because they were so pleased with the results they
have obtained from using Universal Data Models which I had recommended to them.
Data
Modeling/System Architect
Spent three
weeks in Helsinki, Finland assisting Nokia in creating a Conceptual Data Model
for their planned 360 degree view of Consumers.
They plan to move to a Logical model then a Physical Data Warehouse
later this year.
Architect/Java Spring Development
Worked with Comcast helping design and
develop their NGVOD products. I was
tasked with Designing and Developing Oracle Tables and Spring Web MVC/PLSQL
GUI's that allow editing of raw data of to configure Video on Demand. I have also built a GUI that allows editing
of Metadata to control automated up/downloads of raw data used for the VOD
products into a central hub. I was
responsible for developing cryptographic programs used to store user data in
the database and writing a generalized login/logout library to be used with all
GUI's that I developed.
Data Modeling/Data Warehousing Architect
Used
Universal Data Modeling Techniques to assist Novell Inc, in designing
their Data Warehouse/Data Marts and Metadata Management Solution that will
integrate Oracle Financials with their implementation of Siebel Sales and
Marketing in Provo Utah
Part Time Oracle DBA Instructor
Taught Oracles DBA I course at the University
of Colorado. The course was certified by Oracle and is part of the University of Colorado's Continuing Education Curriculum in partnership with
Oracle Corporation.
Data Modeling/System Architect
At the same time as I was teaching at CU I
was working with a Medical Manufacturing Company in Denver, CO to model a Blood
Component Process Control System with multiple Subject Areas. Using Oracles Transparent Data Encryption and
Oracle Wallet to encrypt some of the data in the database. Using Universal Data Models as a beginning
point to model both the logical and physical database models.
Data
Modeling/System Architect
Worked with a
startup company in Boulder, CO to modify the Universal Data Model Party Subject
Area to fit in with the architecture that they are using to build portable
digital identities using Public Key Infrastructure. Their database will be used to store
identities, control access to online health care applications and provide
privacy to health care patients as mandated by the federal government.
Lead
DBA
Lead
DBA/Manager of a team of five Database Administrators for a 4 Tera byte Billing
Database. Primarily responsible for
instance tuning, interfacing with clients and managing the DBA team.
Sr. Application Architect/Data Modeler/Developer
Modeled and
developed a Star Schema Data Mart for the State of Colorado to track Special
Education student data. The data mart
was loaded from a non-normalized OLTP application and required extensive ETL operations
to extract and load it into the Star Schema.
It has an Oracle 9i AS v.9.02/Struts 1.1/EJB Web Application front end
that was built on an Eclipse IDE with Ant and JUnit using XP Methodology. The Application is used to define reports for
the Data Mart and set up various summarizing definitions to be used with the
reports. It enables downloading of
reports and uploading of data into the Data Mart via the application front end.
Ported a BEA
Weblogic 6.0 J2EE application to track child nutrition data to an Oracle 9i
Application Server. This included
getting the application running on Weblogic 7.0 first so that the department
could review it for potential modifications.
Next was reverse engineering the Data Model and modifying it where
necessary to the client’s specifications.
I then rewrote all Weblogic and database specific code including
deployment descriptors, Struts code and EJBs to Oracle 9i App Server compatible
code. Next was debugging and
re-factoring the original code so that it worked. That involved rewriting several Servlets,
adding some custom tags and rewriting most of the Java Server Pages. It also involved debugging the Oracle Stored
Objects associated with the system. The
system has 965+ Java classes and 330+ Oracle Stored Objects.
Modeled and
developed a Data Mart Portal for the State of Colorado to allow the storage and
definition of multiple heterogeneous data sets that were downloaded from
mainframe applications and transformed into appropriate star schemas. The front end of the data mart was written in
Java Servlets/Java Server Pages. The
front end of the data mart allowed the definition of input/update web pages
that were dynamically created by the application. The Web front end allows for uploading and
downloading of both comma-delimited files and binary files (PDF, Word,
etc). The binary files were stored as
binary large objects (Oracle Blob). The
data sets were downloadable in comma-delimited format as well as binary
format. Administration of the
application was also handled through the same Web front end and featured the
ability to create users and assign them user privileges and privileges to
read-only or read-update data sets.
I also mentored
and held formal training classes for Colorado Dept. of Education IT personnel
in various facets of Data Modeling/Data Warehousing, Java, and Oracle J2EE
technologies.
Sr.
Application Developer/Architect
Designed and
developed an economic forecasting system at Sun Microsystems that uses
invoicing history from the education database to forecast quarterly revenue for
Sun Education in the Americas.
Designed and
developed a back-end server interface from an Education Ordering Database to
the Oracle General Ledger at Sun Microsystems.
The application was written in Java/JDBC/RMI/Java Mail API and included
an application to verify the information in the Orders themselves and another
application that pushed orders to the Oracle GL interface tables. The verification system included an interface
to Sun’s LDAP directories. The system is
able to bill $3 Million of orders per month without manual intervention and
saves Sun approximately $1.5 Million/year in previously lost charges. The automation also saves 40-person
hours/month in labor costs.
Sr. Application Architect/Data Modeler/Developer
Modeled and
developed a Supply Chain Management data mart for a major food manufacturing
company using Oracle Application Server.
The development included design of a system to import Transportation
rates from Spreadsheets returned from trucking vendors. The browser interface allowed Trucking System
administrators to verify, compare and negotiate trucking rates from various
vendors to choose the best rate available at any given point in time.
Sr. System Architect /Data Modeler/ Tech Lead
I modeled an
OLTP Relational Database for a Banking Compliance Software Firm that was
originally modeled as a very de-normalized Object Store Database. After modeling I helped redesign the J2EE
system used to access it and mentored the developers that were creating
it. The system uses Java Servlets, Java
Server Pages, Enterprise Java Beans (BMP), and JDBC to allow Service
Representatives to gather information from customers to fill out the
appropriate documents online and then print completed documents for signoff
after compliance verification is complete.
System
Architect/Data Modeler/Database Administrator
Modeled and Architected a Customer
Relationship Management System (CRM) using downloads from Enterprise Shared
Databases. The system uses Java
Servlets, Java Server Pages, Enterprise Java Beans, JDBC and a RightPoint
Campaign Server to present Intelligent Scripts to Service Representatives to
assist them with up-sell and cross-sell opportunities on inbound calls.
System
Architect/Lead Data Modeler/Lead Database Administrator
Lead Modeler and
Architect for eight different Data Warehousing projects at US West. Four of the Warehouses were Data
Mart/Operational Data Stores. Two of
them involved modeling databases for Work Effort for Professional Services. In all of these projects I was also the lead
physical database administrator. In five
of the cases I also architected and constructed Oracle Stored Procedures,
PL/SQL, PRO*C or HTML-CGI interfaces to access the database.
Lead
Data Modeler/Architect/Database Administrator
Lead Data
Modeler/Architect/DBA for a Service Order Entry GUI that was developed as a
Java Applet with JDBC database access to an Oracle Database where definitions
of pages used in the GUI were stored in a database and written to the screen
dynamically.
Lead
Developer/Database Administrator
GUI Project
Leader/Developer for a team customizing Telecordia’s Media Vantage
Modules. We developed an
L/C++ CGI
Intranet front end to access a DCE/Oracle Database application (ALOC/CNUM) that
was used to store service addresses and telephone numbers available for Qwest
Communications. I wrote two JAVA applications to assist in generating the C++
code necessary for the CGI piece of this application. One of the JAVA apps generated C++ classes
with constructors and assessor methods for private instance variables; another
JAVA app was used to convert HTML code into C++ methods callable in the
CGI. The second app was called by the
make file and allowed easier editing of the HTML files. Both of these apps saved us a remarkable
amount of time and money writing the C++ CGI.
I also modeled, designed and developed a HTML/C++ CGI Routing Table
Editor to allow System Administrators to configure a daemon used to allow the
HTML/CGI front end to communicate with various legacy and non-legacy
applications on the back end. I also set
up an Oracle Gateway to access legacy data in the DB2 databases. The final part of the project included
modeling and building a replicated database for read only access by reporting
applications.
Lead
Database Administrator/Lead Data Modeler
Lead DBA/Data
Modeler for an Enterprise Wide Customer Profile database that included multiple
smaller Data Mart Operational Data Stores that were accessed through PL/SQL
Stored Procedures.
Oracle
Application Trainer
Multiple
Training Projects including:
·
Developing and Teaching a
one-day Oracle Forms 4.5 – Oracle Reports 2.5 class for a local government
accounting Facility.
·
Training the primary developer
for a Cable TV Concern while helping model and construct a cable inventory
application.
·
Initial Training of an Oracle
Application Developer being converted to a Database Administrator at a local
medical facility.
·
Training two inexperienced
database administrators for a large mining company while consulting on backup
and recovery methods for their distributed VLDB. During the same contract I was assisting them
with the design of their laboratory database and developed multiple customized
classes on SQL, PL/SQL, SQL*Loader and SQL*Forms that I presented to the entire
IS development staff.
·
Training application developers
for the State of Colorado in J2EE Technology and access of Oracle database
through Application Servers using J2EE technology.
Lead
Architect/Modeler/Developer/DB Administrator
The Logical/Physical Modeling, Database
Administration and development of an “Integrated Staffing Model” Oracle data
warehouse accessed via a Visual Basic Client application on the Desktop. In this case, I designed the system, modeled
and built the database and designed & built the “warehousing engine”. This application provided a back end to a
monthly forecasting model. It took the
monthly forecast and converted it into either an hourly, half-hourly or 15min
forecast spread over a month. I wrote
the application in a combination of Oracle PRO*C and Stored Packages.
Lead
Architect/Modeler/Developer/Database Administrator
The Logical/Physical Modeling, Database
Administration and partial development of an Operational Data Store used by
management to track the work activity and availability of install & repair
technicians. This was an Oracle Database
accessed via Netscape on a corporate Intranet protected by a Firewall.
EMPLOYMENT HISTORY
LightWorx Technology Consulting, LLC., Boulder, CO (Consultant) 1993
– present Owner
Miaco Corporation -
Englewood, CO (Consultant) 1990
– 1993 Principal Consultant
Davis, Graham and Stubbs -
Denver, CO (Consultant) 1989
– 1990 Programmer/Analyst
Micro Analysis and Design
- Boulder, CO 1988
– 1989 Programmer/Analyst
Rose Medical Center -
Denver, CO 1985
– 1988 Programmer/Analyst
Storage Technology Corporation
- Louisville, CO. 1980
– 1984 Test Engineering Programmer
PUBLICATIONS
Rocky
Mountain Oracle User Group Newsletter, Aug 1997 A Simple HTML Form in
Oracle Web Server
Feb
1997 Replication
Part 1: Read-Only Snapshots
Rocky
Mountain Oracle User Group Training Days, Jan 1998 Accessing
Oracle with Java Database Connectivity
Oracle
Developer Tools User Group Conference, Jan 1997 Building
a Robust Oracle Web Server Application
EDUCATION
|
·
University of Colorado, Denver, CO
|
BS Electrical Engineering
|
1986
|
|
·
University of Massachusetts, Amherst, MA
|
BS Biology, cum Laude
|
1976
|
|
·
Oracle Corporation, Englewood, CO
|
Basic Oracle for Application Programmers
Relational
Database Design
Advanced
Oracle for Application Programmers
|
1990
1991
1991
|
|
·
Miaco Corporation, Englewood, CO
|
V6 Oracle Database Administration
V7
Oracle Database Administration
V7
Database Performance Tuning
|
1995
1995
1995
|
|
·
Batky-Howell, Englewood, CO
|
Introduction to Java
|
1997
|
|
·
Universal Data Models, LLC, Castle Rock, CO
|
Universal Data Model Boot Camp for Consultants
|
2004
|
Download Resume Format
0 comments:
Post a Comment