VICKI L. BROCKERT
SUMMARY OF QUALIFICATIONS
- Information Technology professional with over twenty years of experience
working closely with clients to
provide innovative solutions to ever-changing enterprise information needs.
- Effective team player who plans, manages, and executes projects within time,
resource, and budget
constraints.
- Articulate facilitator who helps clients to define their business,
applications, and data requirements.
- Detail-oriented mentor, data analyst, software designer, and code developer
who utilizes “Best Practice”
methodologies.
PROFESSIONAL SKILLS:
- Data Analysis & Modeling
- Project Management
- Systems Analysis, Design, & Programming
- Production Planning & Scheduling
- Business Process Analysis & Design
- Product Engineering
INDUSTRY EXPERTISE:
- Telecommunications
- Contact Lens Manufacturing & Distribution
- Pharmaceutical Manufacturing & Distribution
- Garment Manufacturing & Distribution
- Insurance
- Uniform Rental & Distribution
SOFTWARE / TOOLS EXPERIENCE:
- CASE Tools
- Erwin
- PowerDesigner
- ER/Studio
- Oracle Designer 2000
- Knowledgeware ADW
- Software Packages
- Oracle Manufacturing
- Oracle Financials
- Diamond Health Care
- PeopleSoft
- RDBMS
- Oracle
- Teradata
- SQL Server
- DB2
- MS Access
- Programming Languages/Tools
- PL/SQL
- Oracle Developer 2000
- Oracle Reports
- SQL*Plus
- Cobol
- Design/1
- Warnier-Orr
- Queryman
- Aqua Data Studio
- Other Tools
- MS Project
- Project Workbench
- PVCS Version Control
- SCCS Version Control
- Service Center
- MS Office
- Lotus Suite
- Adobe Acrobat
- QMF
- Hardware
- IBM R/S 6000
- IBM 3090
- IBM AS/400
- Data General AVIION
- HP
- Sun
- Operating Systems
- Windows
- Unix
EDUCATION / TRAINING:
- B. S. Degree in Business Administration (GPA 3.9) - Oral Roberts University,
Tulsa, Oklahoma
- Computer Science Coursework (GPA 4.0) - Johnson County Community College,
Overland Park, KS
- Managing Projects in Organizations - Sprint/George Washington University
- MRP II Concept Education & Business Process Reengineering - EDS Corp.
- Oracle System Administration, Forms, Reports, Manufacturing & Financial
Applications - Oracle Corp.
PROFESSIONAL EXPERIENCE:
12/06 to 08/07 AMC Theatres – Data Warehouse Architecture – Kansas City, MO
Data Warehouse Architect Consultant - BalancePoint
- Created AMC ER/Studio model standards.
- Analyzed existing Oracle and SQL Server AMC data stores.
- Gathered requirements for Rentrak & Workbrain vendor subject areas for new
data warehouse.
- Created logical and physical dimension models.
- Documented source/target mappings & metadata.
- Created staging models and SQL Server databases.
- Designed AMC enterprise Date, Time, Theatre, Title, and Release dimensions.
- Designed Rentrak fact tables.
- Created logical and physical SQL Server relational models for AMC “Summer
Movie Camp” promotion.
- Managed the TOMS Workbrain project.
- Created project plans, facilitated meetings, documented business requirements,
designed technical plans, created logical and physical models, and coordinated
with developers and test manager.
06/05 to 12/05 MASTERCARD – Data Architecture – St. Louis, MO
Data Architect Consultant – Technology Partners
- Supported numerous internet applications which provide a broad range of
financial services.
- Facilitated JAD sessions with business and development communities to derive
data requirements and business rules.
- Developed multiple application data models in support of the enterprise data
model and data dictionary.
- Performed logical and physical Oracle data models using PowerDesigner
v.10.1.
- Used enterprise data modeling techniques for model consolidation, integration,
and reconciliation.
- Provided project management support for MasterCard’s eXtreme methodology.
05/04 to 01/05 SPRINT – Data Management - Overland Park, KS
Data Architect Consultant - Information Technology Group, LLC
- Supported multiple Sprint projects to enhance Oracle databases which monitor
wireless network
engineering alarms and capture operational performance metrics.
- Facilitated meetings to identify enterprise data requirements, document
metadata, and coordinate data
structure changes with database administrators and developers.
- Created and enhanced logical and physical ERwin v. 4.1 models and engineer
data definition language for
database structure changes.
- Provided project management support, forecasts, application architectural
blueprints, and application design
documents in support of Sprint’s DBDF methodology.
- Tracked time and expenses via PeopleSoft Services Procurement application.
03/03 to 04/04 TELECOMMUNICATION SYSTEMS (TCS) – Seattle, WA
Data Architect Consultant – BusinessEdge Solutions
- Created a GPS-based E911 enterprise data model for TCS and mapped over 1100
data elements from DB2, Oracle, and SQL Server existing databases to Oracle.
04/02 to 11/02 SPRINT - Long Distance Division - Overland Park, KS
Datawarehouse Architect Consultant - Information Technology Group, LLC
- Facilitated sessions with clients to define data requirements for a new Oracle
database for Special Customer Arrangements.
- Supported multiple Sprint long distance projects to enhance Teradata data
warehouses and Oracle data marts (e.g. Residential and Business (PAR/Pinnacle)
Data Warehouse, Sprint Business Profitability (SBP)
Data Mart, and National Consumer Organization (Encore NCO) Data Mart.)
- Created project plans and provided estimates for Data Management tasks.
- Created logical and physical ERwin models, forward and reverse-engineered
models, and performed complete compares.
- Coordinated with the DBAs to create, maintain, and enhance development, test
and production databases.
12/00 to 11/01 SPRINT - Long Distance Division - Overland Park, KS
Data Analyst Consultant - Information Technology Group, LLC
- Supported multiple projects by providing data analysis and creating logical
and physical Erwin models of the Integrated Information Store (IIS) which was
shared by 27 applications.
- Facilitated meetings with application representatives to identify shared data
elements, validate definitions, and determine relationships, keys, data types,
lengths, mapping, and data stores of record.
- Participated in Rational Rose modeling sessions.
- Created new procedures and departmental reports.
- Estimated level of effort as the IIS Requirements Data Management
representative on numerous project teams.
01/00 to 12/00 QUINTILES - Kansas City, MO
Oracle Forms/Database Architect Consultant - Information Technology Group, LLC
- Provided Oracle Developer/2000 and PL/SQL programming support for the
Quintiles Stability Information System (QSIS), a pharmaceutical application which
provides test result entry, tracking, and electronic
signature approval functionality for mission critical clinical research studies.
QSIS also includes specification analysis, inventory control, management
reporting, and security administration.
- Participated in construction, testing, implementation, and post-implementation
production support.
- Developed detailed test plans.
- Supported data conversions.
- Performed installation, operational, and production qualifications according
to rigorous FDA GMP (Good Manufacturing Practice) standards.
08/99 to 12/99 SPRINT - Long Distance Division - Kansas City, MO
Oracle PL/SQL/Database Architect Consultant - Princeton Information Systems
- Provided PL/SQL programming and design support for Adabas to Oracle database
conversion.
03/99 to 07/99 VISTAKON - JOHNSON & JOHNSON - Jacksonville, FL
Oracle Forms/Database Architect Consultant - Maxim Group
- Provided Oracle Developer/2000 support in a UNIX application/data server
environment which facilitated the manufacture and distribution of contact
lenses.
- Performed project planning, analysis, design, code, test, implementation, and
production support.
04/98 to 01/99 BLUE CROSS & BLUE SHIELD OF FLORIDA - Jacksonville, FL
Oracle Database/Applications Architect Consultant - Technisource
- Provided Oracle database & Diamond Health Care applications support for
Andersen Consulting project at BCBSFL to reengineer the benefits and claims
management process.
- Wrote PL/SQL procedures and loaded data in development and test environments.
- Implemented the Diamond software package in a client/server environment.
- Performed security administration.
- Coordinated performance tuning.
08/95 to 04/98 SPRINT - Local Telecom Division - Overland Park, KS
Oracle Developer/Database Architect Consultant - Computer Task Group
- Developed and maintained MS Project plans.
- Planned, analyzed, designed, constructed, tested, implemented, and supported
Sprint Circuit Administration System (CIRAS) projects, which facilitated
software-assisted network engineering functions at eight local telephone
companies across the United States.
- Trained and mentored developers in the use of Oracle Forms 3.0, 4.5 and
Developer 2000.
- Developed and documented procedures to support multi-programmer concurrent
development using Unix SCCS code version control.
05/93 to 08/95 UNITOG, INC. - Kansas City, MO
Oracle Developer/Data Analyst
- Implemented Oracle Manufacturing and Finance applications for nineteen remote
uniform rental branch offices throughout the U.S.
- Responsibilities included requirements definition, systems analysis, design,
test planning, and graphical user interface development using ORACLE Forms 4.0
application tools and ORACLE RDBMS.
Project Manager/Team Lead/Oracle System Administrator
- Represented the IS department on a Product Division re-engineering team to
evaluate various manufacturing/financial software packages and data |
