Data Management

Anastasia A. Gaspay, PMP, CDMP

**** ******* *****, *********, ** 95747 Mobile: 916-***-**** Email: ********@*****.***

Highly competent, analytical, creative, and team oriented data management professional with extensive

background in ETL, data warehousing and analytics. Passionate about using data and information to add

insights and improve decision making.

PROFESSIONAL EXPERIENCE

06/2010 – Present Sr. Advisory Associate KPMG LLP, Sacramento, CA

Assessed clients’ core processes in the areas of data analytics, BI, warehousing, master data management, conversion,

mapping, transformation, defect resolution, quality, cleanup, and validation

Collected and analyzed production data for trends and anomalies, developed metrics, and presented actionable

opportunities for improvement to internal stakeholders for a project totaling over 2 million accounts and a potential

savings of $4 8 million

Collaborated with users and led meetings to gather and adequately document As Is functionality and translated the

functionality into To Be use cases for a client implementing Health Insurance Exchange

Led integration analysis to determine scope and efforts required to integrate Siebel application with legacy mainframe

application

Performed data needs assessment for the integration project and captured “future state” data exchange between Siebel

application and legacy system

Analyzed product development process for a leading provider of analytic data platforms, applications, and services, and

identified opportunities for improvement

Led data collection activities as part of a datacenter assessment aimed at improving the datacenter's ability to respond to

failures, minded the collected data to identify potential points of failure risks, and developed analytics and reports

Conducted gap analysis of fields mapped from the data warehouse to BI presentation layer

Trained and mentored users on the use of new technologies and applications

11/2005 06/2010 Sr. Programmer Analyst CoreLogic, Sacramento, CA

Utilized various tools and applications to design, develop, test, and document complex ETL and data warehousing

solutions in a fast paced data production environment

Relied on various data modeling and warehousing methods and programming concepts to translate requirements into

custom solutions to satisfy customers’ analytical and BI needs

Developed ETL templates which streamlined processes and facilitated the highest ever monthly release of ETL jobs: 201

vs. 134 (prior highest)

Validated data for quality, including completeness, consistency, accuracy, integrity, and precision

Led 22 offshore analysts by assigning tasks, researching and documenting analysis and design issues, and facilitating

resolution of the issues reported by the offshore team

Developed training materials for ETL, data warehousing, and data analysis and conducted training sessions

Wrote specifications, created testing scenarios, and tested proprietary applications

Provided mentoring to the team on best practices in ETL, data warehousing, and analytics

09/2005 – 12/2009 Research Analyst The Dardan Group, Sacramento, CA

Applied general research practices, methodologies, rules of subject confidentiality, and research study protocols to

conduct research in various IT and business areas such as network security, electronic medical/patient records security,

IT outsourcing, and marketing

Assisted with survey design aimed at measuring physicians’ attitudes toward IT applications

02/2001 – 11/2005 Database/GIS Support Air Force Real Property Agency (AFRPA), McClellan, CA

Managed Deliverable Status Report Access database for the AFRPA

Acted as a liaison between AFRPA and various regulatory agencies

Created Oracle tables, views, queries, and triggers to improve efficiency of data access, storage, and retrieval

Assisted DBA with Oracle backups and data loads

Assisted Lead GIS Analyst with creation of maps and tabular presentations

Developed and delivered presentations on the reporting capabilities of the DSR database to users

`

Anastasia A. Gaspay, PMP, CDMP

1632 Jonquil Drive, Roseville, CA 95747 Mobile: 916-***-**** Email: ********@*****.***

EDUCATION

Master of Science in Business Administration

California State University, Sacramento (Management Information Systems concentration)

Bachelor of Science in Economics

Saint Petersburg University of Economics and Finance, Saint Petersburg, Russia (Finance concentration)

Certified Data Management Professional (CDMP)

Institute for the Certification of Computing Professionals (Data Warehousing Option)

Certified Project Management Professional (PMP)

Project Management Institute

TECHNICAL SKILLS

Extract, transform, and load (ETL) processes Requirements gathering and specification writing

Data warehousing UML modeling skills, e.g. use cases, sequence

Data analytics diagram, class diagram, activity diagram

Data mining (DataFlux) Relational Databases and DB tools: Oracle, Access,

Data profiling, cleansing, and validation SQL, PL/SQL, Toad

Data modeling, including star and snowflake Business Intelligence tools: OBIEE

schemas Programming: Java, IBM DataStage Basic, Natural,

System Development Life Cycle tools : Rational C, VB, HTML

ClearQuest, Rational ClearCase, HP Quality Center, Operating Systems: Windows, Unix

HP Application Lifecycle Management Microsoft Office Suite

SOFT SKILLS

Strong problem and issue resolution experience High level of creativity and resourcefulness

Excellent oral communication skills (presenter at the Experience leading diverse teams

International Academy of Business and Economics) Ability to prioritize multiple activities and objectives

Excellent written communication skills (published in a rapidly changing environment

papers in various peer reviewed journals and Strong sense of professionalism and ethics

conference proceedings, responded to technical

proposals)

MISCELLANEOUS PROJECTS AND ACCOMPLISHMENTS

11/2008 – 06/2010 Member of the Healthy Families Advisory Panel

Purpose: to advise the California Managed Risk Medical Insurance Board on policies, operations, and implementation of

the California Healthy Families program

01/2006 – 12/2006 Member of the Wireless Sacramento Regional Project WiSac

Purpose: to plan, fund, develop, select, build and test an interoperable and ubiquitous metropolitan and rural

broadband wireless network in Northern California

04/2006 – 05/2006 Graduate Research Work for the Interim CIO at Sutter Health

Purpose: to evaluate several operating room software vendors based on Sutter Health requirements and propose a

solution

02/2005 – 03/2005 Database Prototype Design for the California Broadcasters Association (CBA)

Purpose: to design a single system to maintain data related to CBA members, donors, programs, and events based on

CBA requirements

03/2005 – 05/2005 Feasibility Analysis for the Community Bank of San Joaquin

Purpose: to evaluate technical, legal, organizational, operational, financial, and time feasibility of implementing VPN

based wireless network

2007 & 2008 Presenter at the International Academy of Business and Economics

E business track Las Vegas, Nevada

`

Contact this candidate