What certification is this? Maybe the certification is brand new.
Certifications: DW 2.0 – June 2007
[rmiug-jobs] Digest Number 3981
1a. Resume - Database Modeler/Business Analyst
Posted by: "pahender2005" pahender@earthlink.net pahender2005
Date: Sun Jun 24, 2007 10:48 am ((PDT))
Patricia A. Hendershot
11449 W. Burgundy Avenue, #106
Littleton, Colorado 80127
(303) 937-8639
pahender@earthlink.net
CAREER SUMMARY:
Twelve (12) years experience in Oracle, thirteen (13) years
experience in database design and modeling, fifteen (15) years
experience in business/requirements analysis, nine (9) years
experience as a consultant, and authored three (3) books on Oracle
SQL (v5.1a, v6.0,. & v7.0).
CAREER GOAL:
My ideal position as a Senior Database Modeler/Business Analyst will
allow me to use my design expertise in a team environment, but also
allow me to learn other areas (i.e., development, internet databases,
etc.) as well. I offer:
• Teach employees/users/customers SQL
• Ability to design information databases for many topics from
financial to satellite communications
• Familiarity with:
o Relational and Object-oriented database methodology and
structure
o Data Warehouse methodology
o Defining Naming Conventions/Standards
o Data Flows and Object Schemas
o Entity-Relation Diagrams
o Defining and writing Requirements Analysis, Database
Specifications, Data Dictionaries, User Manuals, Computer Operation
Manuals, Maintenance Manuals, SQL Training Manuals, and Testing
Procedures (conforming to IV&V standards)
EDUCATION:
B.S. Management, Purdue University, 1979
Majors: Marketing (Research) and Industrial Relations
Minors: Economics, Mathematics and Statistics, Industrial Psychology
COMPUTER EXPERIENCE:
Software:
Databases: Oracle v8.0, Oracle v9i, Oracle v10g, Teradata v7.1
Case Tools: Designer 2000 v2.1, S-Designer v6.0, ERWin v3.0
Microsoft: Windows XP, Windows 2000, Windows NT, MS Access 97 -
2003, Excel, Word, Power Point
Miscellaneous: Crystal Reports, Visio, Photostudio, Brio/Hyperion
8.3, Toad v8.0
Design Methodologies: Yourdan, Chen, Martin, Booch-Rumbaugh, Inman,
Kimball, UML, RUP
Classes: Compiere ERP software - March 2005
Teradata – June through August 2006
DW 2.0 (Inmon Data Warehouse Methodology) – June 2007
Certifications: DW 2.0 – June 2007
PROFESSIONAL EXPERIENCE:
EchoStar/Dish Network – Englewood, Colorado
May 2006 - Current
Responsibilities as Senior Analyst/Developer within the Data
Warehouse group is to work with all departments within EchoStar to
define requirements so that I may create a new data warehouse schema
for call data. I am the technical lead for this project. This
involves integrating mathematical algorithms and data aggregations so
that the Data Warehouse can store meaningful data to all
departments. I also am responsible for other projects for the Data
Warehouse ranging from research and analysis, reporting, and
interaction among other departments to meet the data warehouse design
modifications and reporting requirements defined.
From May 2006 through October 2006, I was a Business Analyst
consultant, vis PluralSoft, in the Data Warehouse group. My
responsibilities were to review all technical requirements
corresponding to reports and quality check that the SQL code is
correct. Reports are tested in Teradata, Hyperion, Toad, and
SQL*Plus. Other responsibilities included working with various
business units within EchoStar to gather their architecture,
reporting, and metric requirements concerning the Data Warehouse.
Product Development Corporation – Thornton, Colorado
October 2005 – May 2006
Responsibilities as a Data Analyst was to validate and cleanse
address data by zip code to the SQL Server database. PDC primary
focus is locating and maintaining residential and business addresses
for telephone directory distribution in the United States. Address
data arrives from two different sources, matched, merged, and then
verified via DPV software.
Reason for leaving: Consultant. Project completed.
Arltech, Inc. – Boulder, Colorado
March 2005 – May 2005
Responsibilities as a Database Designer was to design an MS Access
database, using UML methodology, to bridge between three other
databases for a client. The other databases were in Oracle, Seibel,
and Dun & Bradstreet. The purpose of this database would not only
map/correlate related data between the three databases, but assist in
defining corrupted data records for cleansing.
A second project for which I was assigned was to begin writing a
training and user manual for the use of Compiere software, for which
Arltech is a partner. Compiere is an accounting package using Oracle
10g as the database backend.
Reason for leaving: Projects terminated. Funding was cut.
WestMed, Inc. – Englewood, Colorado
December 2003 – March 2005
Responsibilities as a Consultant/Database Coordinator was to maintain
and update the MS Access Contracts database for which stores
information of Member hospitals and surgical centers of each
contract, company product information and tier pricing for each
contract, and monitoring monthly sales to ensure that purchases are
made within the contract agreements.
I was responsible for all data gathering, analysis, defining naming
conventions and business rules, and the design of a relational
database, using UML methodology, as well as data scrubbing and
validation of data supplied to us by those companies for whom
WestMed, Inc. has a contract. I wrote all pertinent technical
documentation including the Requirements Analysis, Database
Specification, Data Dictionary, and a User Manual. I also created a
series of statistical reports to monitor each contract, their
members, their location by geographic territory, and their related
product purchases by type and category for monthly and yearly
analysis and sales forecasting.
Reason for leaving: Completed project. Now maintained by admin
personnel.
February 1999 – December 2003: Responsibilities as a
Proprietor/Artist of my business, Hearthstone Gallery, was to design
and create jewelry for art galleries and gift shops. I created and
maintained a wholesale catalog, maintained two websites, designed and
maintained my MS Access database, and researched retailers for who
may have an interest in my products. I was also responsible for
photographing jewelry, monitoring inventory, ordering supplies,
customer service, advertising, marketing, and shipping and receiving.
June 1998 – February 2001: Moved to Colorado. I was a Consultant
serving as a Database Architect/Business Analyst and Team Leader for
five different clients. These clients included the Ballistic Missile
Defense Simulation Support Center (BMD SSC) at the Joint National
Test Facility (JNTF) at Shriever Air Force Base in Colorado Springs,
U.S. West, D2K (Data Warehouse/ETL software firm), Sprint-Paranet,
and IGS, Inc. in Boulder. My team's responsibilities included
requirements analysis, standardizing naming conventions,
standardizing business rules, logical and physical design of a
relational or objected-oriented database utilizing Oracle's case
tool, Designer, creating indices, table and tablespace sizing, and
writing all related documentation including data dictionaries and the
detailed database specifications. For each project, my team and I
worked closely with our client to gather information and held weekly
status meetings with them. Databases designed during this time
included missile simulation, telecommunications, and a retail back
end database for a sporting goods website.
January 1998 – May 1998: Responsibilities as a Manager within KPMG
(based out of Washington, D.C.), I was a Data Sourcing Manager at
PrimeStar in Denver. My team's responsibility was the upgrade of the
Informatica PowerMart tool from version 3.5 to 4.0, redesigning the
mappings and transformations, and automating all processes from
loading data from Oracle as well as outside load files, completing
the transformations, and loading the data into Red Brick via Unix
flat files.
Reason for leaving: Better opportunity which allowed relocation to
Colorado.
October 1991 – January 1998: Worked in the Washington, D.C. metro
area. I was a Consultant serving as a Database Architect/Business
Analyst for several defense and federal contracting firms as well as
a few telecommunications firms, such as MCI and WinStar. All
projects included my team and I performing requirements analysis,
standardizing naming conventions, standardizing business rules,
logical and physical design or redesign of a relational or object-
oriented Oracle database using case tools such as Designer, ERWin, or
MS Access, and writing all related documentation. Where a redesign
was required, we were also responsible for data mapping, reformatting
the existing data, and loading it into the new table structures via
SQL*Loader. For each project, my team and I worked closely with our
client to gather information and held weekly status meetings with
them. Databases designed during this time were for satellite
communications (defense and telecommunications), the Presidential
budget at the C3I level, financial information for the Department of
Education, military relocation, justice information (Health and Human
Services and the intelligence sector), and an information database
utilized by the Joint Chiefs of Staff.
Between June 1994 and August 1994, as a Consultant to the Federal
Aviation Administration (FAA), I wrote my third book, in class notes
style, on Oracle SQL for v7.0 to be used to train FAA Employees.
This included a curriculum and quizzes at the end of each chapter.
Between December 1992 and February 1993, while consulting to Unisys
Corporation on a joint military project for the Army at Fort Belvoir,
Virginia, I wrote my second book, in class notes style, on Oracle SQL
for v6.0 to be used by Unisys Education for their training classes.
December 1988 – October 1991: Worked at the Pentagon and for the
Navy (NAVSEA) as a Defense Contractor. As a Database
Architect/Business Analyst, my team's responsibilities included
requirements analysis, standardizing naming conventions,
standardizing business rules, logical and physical design of a
relational Oracle database, and writing all related documentation.
My team and I also wrote database testing standards, conforming to
IV&V standards, as well as writing testing procedures for two
databases we had designed.
Between August 1990 and December 1990, I also wrote my first book on
Oracle SQL for v5.1 as well as designed and created a corresponding
database to the book to offer hands on training to other employees.
Between May 1989 and July 1989, using a graphics software package, I
designed and created a computer based training package for the NAVSEA
project for which I was associated. This tool allowed the end user
to be trained to use the database our team had designed and developed
for them. They would be able to install this on their PC and refer
to it as a refresher from the classroom training they had received.
The tool emulated the database menus and forms as well as the Help
and Error messages. Quizzes were included at the end of each section.
June 1987 – December 1988: Worked on a NAVSEA project as a Defense
Contractor. As a Financial Analyst, my responsibilities included
providing financial, budget plans and forecasting, statistical,
technical, and administrative support as well as preparing and
writing job descriptions, user manuals, progress reports, program
financial reviews, cost and schedule monitoring, and preparing
Technical Instructions.
FINANCIAL/STATISTICAL/ANALYTICAL EXPERIENCE:
November 1986 - May 1987
Market Research Analyst for Perpetual Savings Bank, F.S.B. in
Washington, D.C.
September 1985 - November 1986
Loan Servicing Specialist for Perpetual Savings Bank, F.S.B. in
Washington, D.C.
January 1984 - August 1985
Statistical Analyst for a department store chain in Indianapolis,
Indiana
July 1979 - August 1980
Revenue Accountant for Mayflower World Wide Headquarters in Carmel,
Indiana
SECURITY CLEARANCE:
Secret
Issued by: DISCO
Last date of use: November 1998
