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
309
Stone Creek Lane · Layton UT 84001
801-390-1230
· morgan@me.com
Summary
Data warehouse
specialist with Oracle Certifications in SQL, Advanced PL/SQL, and Database
Administration. More than 20 years’ experience designing, developing and
administering databases, including requirements analysis, dimensional and E/R
modeling, PL/SQL programming, ETL
development, physical database design, Multiple-DBMS data integration,
system and application level performance tuning, and teaching & mentoring
database development best practices.
Certifications
•
Oracle Database SQL Certified Expert
•
Oracle Advanced PL/SQL Developer Certified
Professional
•
Oracle 9i Database Administrator Certified
Professional
Education
•
Bachelors of Arts, Biology State
University of New York College at Buffalo
•
Skill-specific courses: Oracle Database
Administration, Oracle Performance Tuning, Oracle 10g New Features for
Administrators, Oracle Warehouse Builder, Oracle Data Warehouse Administration,
Data Warehouse Requirements Analysis, Dimensional
Modeling, Multi-dimensional Database Design.
Technical Skills
•
Data Modeling: Strong dimensional and E/R data modeling skills. Data warehouse
methodologies including Kimball Dimensional, Inmon CIF and hybrid. Extensive
experience with data modeling tools including ERwin, ER/Studio, Sybase Data
Architect, Oracle SQL Developer Data Modeler, TOAD Data Modeler, SQL Architect
and other open source modeling tools.
•
SQL
& PL/SQL: Hints, partitions, parallel execution, LOBs, collections, sets,
analytic functions, materialized views, bitmap, function & join indexes,
cursor variables, conditional compilation, user-defined types, built-in
packages, pragmas, SQL injection-proofing, statistics, SQL tuning, PL/SQL
analysis, profiling & optimization. SQL/function result cache.
•
Oracle
Administration: Oracle installation/patches, listener configuration, database
creation & cloning, media recovery, backup/restore, Data Pump, SQL*Loader,
Oracle Jobs/Scheduler, initialization parameters, security, logical &
physical configuration, metadata development, RLS/VPD, heterogeneous tables,
internationalization.
•
Tools:
SQL*Plus, SQL Developer, OEM, SQL*Loader, Data Pump, DBVerify, Backup/Restore,
TOAD, Allround PL/SQL Developer, DB Artisan, SQL Navigator, DBAdmin III,
Virtual Box.
•
Multiple-DBMS:
Oracle, MS SQL Server, Sybase, PostgreSQL, Informix.
•
Languages:
PL/SQL, Transact-SQL, PL/pgSQL, Delphi Object Pascal.
•
Instructed/Mentored
in Data Modeling, SQL, and Database Programming.Taught classes for three
technical schools.Mentored developers in data modeling, application SQL and
PL/SQL development.
Professional Experience
Zion’s Bancorporation Data
Warehouse Modeler – April 2010 to December 2010
•
Created and revised relational and dimensional data warehouse
models in E/R Studio. Served as backup DBA and Database Developer in Oracle and
PostgreSQL environments.
Autoliv Corp (RHI) Performance Troubleshooting
2/2010-3/2010
•
Successfully optimized database with severe performance issue on
short-term contract.Created data model for database with no current data model,
no foreign keys and no documentation.
Software Technology Group Oracle DBA/Data Modeler/Developer
– 4/2008 to 8/2009
•
Wrote
Oracle 10g predictive analytics procedureto detect most likely DOD Security
Risks.
•
Mentored
and Optimized SQL for Java developers.
•
Created
and managed Oracle SQL scripts containing 250,000 lines of DDL, DCL and PL/SQL code.
•
Performed
ETL usingPL/SQL and SQL*Loader.
•
Created
and maintained data models in Erwin. Mentored DBAs in advanced Erwin 7.2.
Veteran’s
Health Administration (EDS) Oracle Data Warehouse Lead Developer: 9/2004
to 9/2007
•
Led
three person Data Warehouse team implementing Clinical Data Warehouse.Received
bonus for specification-complete, on-time rollout.Integrated with DTS for
direct-feed to SQL-Server 2005 warehouse.Created data profiling program that
detected different levels of errors and anomalous data.Replaced damaged
electronic medical record system during Hurricane Katrina.
•
Initiated
VHA Metadata Repository Group in creating integrated metadata repository and
mapping all source data: HL7, MUMPS hierarchical, XML, CSV, delimited, Oracle
and UML.
Ingenix Corporation Sr Oracle DBA 8/2003 - 8/2004
•
Administered
remote Oracle VLDB databases on HP-UX and Windows NT. Conducted system level
optimization. Installed, upgraded Oracle 8i/9i.Provided SQL, PL/SQL
consultation to staff developers.
Deltagen Proteomics Inc.Sr Oracle DBA 3/2002 – 11/2002
•
Administered
production, testing and development instances in Oracle 8i/9i.Developed PL/SQL
applications for biomedical research.Created complex data models to support
research protocols.
iCentris Corp Sr Oracle DBA 3/2000 -1/2002
•
Decreased
web page display time by 40% across lds.org family of web sites for The
Church of Jesus Christ of Latter-day Saints.Taught Application SQL tuning
workshop to staff Developers.
•
Reduced enterprise report run time from 8 hours to 25 minutes at USANA Corp by
re-writing ETL.Mentored developers in SQL.Created stored packages.Wrote
hierarchical tracking engine in PL/SQL.
•
Created
accounting data warehouse including dimensional model, star-schema database and
ETL engine in MS SQL-Server 2000/DTS for Mannatech Corp. Recognized by Vice
President of Accounting for meeting specifications on time and within
budget.Mentored junior level programmer.
•
Created
Delphi client-server applications in-house.Optimized Oracle
and PostgreSQL databases.
Career Achievements
§ At The Church of Jesus Christ of Latter-day
Saints I made SQL and PL/SQL optimizations that increased the page display
speed on lds.org and Mormon.org an average of 40%.Recognized by the Director of
the Church Internet Development Group and at his request, I held an SQL Tuning
workshop for all staff developers and interns in Utah.
§ At the Veteran’s Health Administration, as
Team Lead and Acting Project Manager of a three-member team, we delivered the
VHA Clinical Data Warehouse on time and under budget. Received bonus.
§ At Mity-Lite Corp, I turned around a failed
sales automation project, being hired as Team Lead directly after management
pulled the plug onthe previous effort.I walked into a situation where anger and
frustration were rampant among managers and employees who had just spent months
defining requirements for the failed project.After successfully defusingthe situation and
persuadingboth the managers and the employees to support this new effort, I led
our teaminseparate, aggressively-timed development projectsfor versions 1and2
of a sales automation application, completely integrated at the database-levelwith
the company’s existing ERP. We delivered both version 1 and version 2on time
and under budget.
§ Though I had never worked on a data
warehouse project before, in 2001 iCentris informed me they had marketed me as
a “data warehouse expert” to a client, Mannatech Corp, that expressed aninterest
in building an accounting data warehouse. I was told“You’re now a data
warehouse expert”. Having only a weekend to learn about data warehousing, I
chose to use the dimensional model/star schema approach, then modeled and
created the data warehouse. Upon completion,I was recognized by Mannatech’s
Vice President of Accounting for completing the project on time and within
budget when he didn’t think it was possible.I’ve been involved in data
warehousing ever since, out of choice.
§ Consulting at USANA Corp, I teamed with astaff
developer to optimize the enterprise ETL/reporting engine, which was taking more
than eight hours nightly to run andusing up the entire down time of the system.
Over a period of six weeks we deconstructed, rebuilt and optimized the ETL engineone
component at a time, reducing the eight hour run time to 25 minutes.
§ In response to an urgent request to replace
an AS-400 budget application and implement it throughout Utah and Arizona in less
than two months, I successfully did so, received an award and a special,
unscheduled bonus.
Download Resume Format
.JPG)
0 comments:
Post a Comment