Cindy C. Simpson
Professional Summary:
More than 15 years management experience.
Technical Management over database and data warehousing area.
Offers 7 years MySQL, 8 years SQL Server, more than 15 years DB2, 3 years
PostgreSQL and 5 years Oracle experience. Other database systems worked with
include IMS, Teradata, Progress, and Sybase.
Served as President/CEO for a data services corporation specializing in Data
Warehouse solutions for over 10 years. Started as Lead DBA and promoted to
Manager, Vice-President and then unanimously voted by the board to take the CEO
position. Founded a company using new open source technologies to develop
products for large data (DW) terabytes to petabytes seeking patterns and trends
in the data for predictive marketing, trend analysis, and forecasting and risk
assessment.
Specialized in Business Intelligence and Data Warehouse design using 3NF,
Dimensional Star and Snowflake data models.
Experienced in both agile and waterfall methods.
Strong data mapping experience between db platforms and XML and JSON. ODS
(Operational Data Store) design/staging for DW experience.
Other interests include real estate investing and oil and gas land investing
for exploration and production leases.
Skill Set Summary:
DB Platforms:
MySQL, SQL Server, PostgreSQL, DB2, Oracle, IMS, Sybase, Progress
Reporting/BI Tools/Dashboards Supported:
Tableau, Jaspersoft, Business Objects, WebFocus, Cognos, Microstrategy,
Informatica, SSRS
ETL/Analysis Tools: SQL, SSIS, SSAS
OS:
Linux (Redhat, Ubuntu, and SUSE), HP-UX, AIX, Solaris, Z/OS, Windows
Data Formats: XML, JSON
Industries:
Banking, Pharmaceutical, Transportation, Telecommunications, Oil & Gas, Consumer
Goods, Health Care, Insurance, Retail, Food Services, Saas, Startups,
BioTech, Startups, Restaurant, Point of Sales
Education:
UNIVERSITY OF COLORADO, Colorado Springs, CO, Physics
UNIVERSITY OF MISSISSIPPI, Oxford, MS, Computer Science and Electrical
Engineering
Professional Experience:
Blue Rose Technologies, Denver, CO 3/2010 present
President
Role: Provide BI/Data Warehouse design solutions
Work with clients to provide a Data Warehouse solution in a SQL Server
environment utilizing a star schema model, SSIS, SSAS, and SSRS
The Magellan Network, Denver, CO 8/2009 March 2010
Data Architect
Role: Provide data architecture for large data/ BI product integrating
restaurant related products.
Data Model of product data architecture.
Design of databases and creation of migrations for Ror active record
integration.
Use of Tableau to identify metrics in data for graphical display.
Evaluation of document oriented databases and tests to determine best suited.
Set direction with MongoDB. Installed and setup collections, queries for
interface to dev team.
Data Model and design for large volume data (petabytes) social networking,
analytics, metrics for predictive marketing.
Created scripts to export data from Mongodb and load to MySQL utilizing the
load parameters capability to massage and format data on the input stream.
Developed multiple stored procedures, triggers, constraints.
SQL Server conversion to MySQL/Mongo.
Colorado Open Source Technologies, Boulder, CO 6/2009 - Present
Independent Contractor
Development of Business Plan and strategy for new startup based on services
and support for open source technology
Provide data support for client SQL Server 2008/Ruby on Rails environment.
Partitioning, stored procedures, heavy performance tuning, etc.
Evaluations and recommendations along with installs and support for various
documented oriented technologies such as MongoDB, CouchDB, Tokyo Cabinet, Hadoop,
Cassandra, and more.
Provide replication architecture strategy and implementation for SQL Server
2008 clustered server in an active/active/passive setup.
Install SQL Serve 2008 in cluster group
Performance and tuning for SQL Server 2005/2008 services across more than 6
servers
Review and provide guidance on SQL; develop stored procedures
Provide Data Warehouse Strategy and design direction.
Absolute Performance, Boulder, CO 12/2007 6/2009
Technical Manager
Role: Database Administration & Support for multi clients including MySQL on
Linux, Oracle on Solaris/Linux, Informix on Aix, SQL Server on Windows,
PostgreSQL on Linux and DB2 on Linux/Aix).
Provided technical leadership, assignments, strategy, procedures
documentation, and standards for data team.
Responsible for managing, hiring, task assignments for a team of DBAs.
Data Model data architecture for health industry client for new product
offering.
Provide production database support, performance and tuning, backup and
recovery support for a host of clients supporting DB2 on AIX, DB2 on Linux,
Informix on AIX, Informix on Linux, Oracle on Solaris, SQL Server on Windows,
Oracle on Linux, MySQL on Linux, PostgresSQL on Linux
SQL Server 2000 to 2008 heavy data base administration support for multiple
clients.
Provided SQL scripts for reporting needs, DTS/SSIS ETL jobs, Cubes as required
for clients.
Export/import of data across multiple database platforms as required.
INTERNATIONAL DATA MANAGEMENT CORP., Colorado Springs, CO 19922008
This is a company that provided data management focusing on data warehousing,
data mining and BI solutions. I was one of the group of Data professionals that
started this corporation and voted quickly to move into the leadership role based
on my sales/marketing ability to bring in new customers; my exemplary background
in the data management field; and my ability to take advantage of opportunities
to provide favorable publicity for the corporation. I moved this company to the
TOP 100 Woman Owned list in Colorado for 5 years in a row. The corporation grew
to a multi-million dollar business with over 50 employees providing services. I
also continued to provide services in different capacity as needed to both keep
my skills, to understand the market changes, and as a mentor to other employees.
Those positions follow after my primary position description. We sold lucrative
sections of the business and closed the rest.
Executive Manager (Director to President/CEO)
Role: Executive management providing strategic direction and corporate
objectives. Tools included MS Project, Access, Word, Excel, Goldmine, ACT,
Powerpoint, Visio.
Managed many projects to list all but a few include development of a corporate
model of IDMC business and services; design and installation of a secured
internet based network system on Novell, Windows, and Linux platforms; Design and
development of a Survey system for a Gaming client utilizing MS ACCESS and
Windows platform; Conversion of systems for Y2K for Mainframe applications.
Responsibility included management of project budget, task assignment, facilitate
requirements gathering, develop schedules, develop detailed project plans, and
manage the project's budget. Responsible for ensuring successful implementation
of these projects on time and within budget.
Strong Architecture experience in Application/Data arena. Used a variety of
tools for Dataflow diagramming and Entity Relationship Diagramming. Implemented
normalization practices and central Corporate Data practices. Involved in
platform architecture, Application design, data design, data mining and data
warehousing decisions.
Manage budget for multi-million dollar corporation and set strategic direction
for Information Technology that aligned with Corporate Objectives.
Stepped in as Acting President of the corporation after decease of Presidents
wife. The companys growth was in the double digits and was name a Top 100 Woman
owned Business for the 5 subsequent years. I was named to the position of
President/CEO by the Board of Directors the following year. I was also honored
with Business Woman of the Year in that timeframe due to the corporate
recognition.
Marketed toward data warehousing clients and solutions to bring projects to
the team.
Project Manager/Leadership
Role: Data Modeling/Analyst/Project Management
Project Manager for several high visibility projects which several large
migration projects, data warehousing projects, and new product projects.
Modeling lead for project to map PeopleSoft data for DB2 interface system.
Lead Data Modeler for Software Team developing Client/Server PC based software
development environment and software integration systems.
Project Manager for Team that developed Software for Office Management,
Applicant Management, Financial Management, and Customer Contracts Management.
Also key member of the design and development teams due to resource issues.
DBA Manager
Role: IMS/DB2/MySQL/SQL Server DBA & Management
Environment: IMS, DB2, Data Propagator, Platinum Tools, File-Aid, Forrest &
Trees Data Warehousing product, SilverRun Data modeling tools, MySQL, Linux, SQL
Server, Windows.
Responsible for the assignment and management of tasks to a group of
programmers, DBAs, Production support and scheduling personnel.
Responsible for project reporting including man-hours, budget, dependencies.
Created a mirror system resolution for Batch processing and Read only Trouble
Reporting system.
Responsible for developing and assigning IMS/DB2 tasks in relation to Year
2000 Project.
Responsible for tracking of man hours in relation to budgeted hours.
Led team that was responsible for tagging active/retired modules for post Y2K
cleanup.
Member on a Data Warehousing project to map, explain, move and test data using
tools such as Data Replicator, Data Propagator, File-Aid, SQL statements.
Responsible for infrastructure architecture and concept based on open source
technology to cut costs.
Served as DBA on multiple projects with platforms DB2, SQL Server, MySQL,
Sybase, Informix providing data modeling for both operational and data
warehousing design; producing SQL for reporting needs; providing database builds,
backup/recovery, performance tuning, production support, and SQL tuning.
Supported reporting tools, providing extraction scripts at times helping
analysts with reporting needs and connections and SQL tuning. Many tools
supported across clients including Business Objects, WebFocus, Cognos, ETL via
DTS/SSIS for Sql Server, Microstrategy, etc.
FEDERAL EXPRESS CORPORATION, Colorado Springs, CO 19811991
DBA/Data Modeler
Performed information modeling, dataflow diagrams, and object oriented designs
for COD (Cash on Delivery product), Airbill Tracking Project, CERPS (Problem
Tracking System), Freight Tracking System, International Business Model, and a
Corporate Software Development Model. Most of these were phased implementations
which included converting VSAM files to databases as the phases were developed so
multiple systems could access the data.
Provided IMS problem analysis and resolution.
Designed, developed, and installed IMS full function and fast path Databases.
Performed DASD space estimation and placement.
Provided support to programming staff through call pattern walkthroughs, code
reviews and PSB generations.
Provided conversion interface code to development staff.
Developed CLists and Execs for DBA staff.
Provided training and presentations to all levels of management.
Provided JCL and training for Development staff.
Utilized tools such as Cadre's Teamwork Structured Analysis and Information
Modeling, Knowledgeware's Information Engineering Workbench, DSIMS IMS Data
Dictionary, IBM's IMS Utilities, BMC's Utilities, SIX Utilities.
Researched and resolved system level problems.
Provided tools and aid for system backup and recovery.
Set up automated statistic runs and reports.
|
