* 20+ years experience in data management, administration, and analysis
* 15+ years relational data modeling and database design
* Enterprise, ODS, dimensional, and Corporate modeling
* Application and Development DBA (proprietary Oracle), Oracle development and consulting support functions.
* Extensive data migration and conversion, scrubbing, and data transformation (ETL)
* Experience with very large databases, complex data
* Outstanding human relation skills -- extensive business analysis, process analysis, interviewing end-users, gathering and refining requirements, developing and defining business rules
* Extensive experience designing and implementing reporting and special interest databases
* Significant testing experience, including designing test cases, UAT testing, and designing test data
Hardware: HP9000, IBM RS 6000, SUN, DEC 6000 series, IBM PC, Macintosh
Operating Systems: UNIX (Several Versions: HP, IBM, DEC, SUN, SEQUENT), VMS, Windows; NT
DBMS: Oracle; SQL Server, Sybase
Development Tools: SQL+, ERwin, BPWin, Designer 2000, SQL*Navigator, TOAD, MS Query Analyser, Informatica, ActaWorks, MS DTS, Peregrine, Visio, E-Change Man, Rational RequisitePro
ERP/CRM: Clarify, Team Approach, SAP
Languages: SQL, PL/SQL, T-SQL, Unix scripting
UNITED STATES HOLOCUAST MEMORIAL MUSEUM
Development Data Analyst Jan 07 - present
WORLD WILDLIFE FUND WASHINGTON, DC Nov 04-Jan 07
Database Systems Analyst
Hardware and Software support for membership management and fundraising CRM system (Team Approach). Provide DBA and Systems Administration (Unix) services for Membership Development Services (IT).
WORLD BANK/INTERNATIONAL FINANCE CORPORATION (UC SATYAM) Sep 04-Nov 04
Sr. Associate Consultant- Data Modeling and Administration
As Technical Project Lead directed project to evaluate, choose and implement data quality tool and best practices. Provided technical expertise to Data Modeling and Management Group with regard to issues of data quality and management. Using WB/IFC established formal RFP review process evaluated solicitation responses, coordinated product demonstrations, and managed evaluation team. Authored report to upper management detailing evaluation results, purchase recommendation, implementation plans and initial project plan for implementation.
BANK OF AMERICA (u/c YOH IT) JACKSONVILLE, FL Sep 03 - Feb 04
As Technical Lead for Sales & Marketing Application group, provided detailed systems analysis and design services and led development efforts. Working closely with Service Delivery Managers (BAs), following modified RUP methodology, developed and designed technical solutions for new and existing web enabled, java and oracle based systems. Captured and refined business system requirements and rules, provided impact and gap analysis, designed new functionality; identified and defined changes and enhancements to existing applications; provided database design and modifications. Participated fully in all phases of development life cycle. Responsible for, authored, and managed all technical documents: functional specifications, high and low-level design, testing. Systems supported included proprietary CRM and Reporting systems.
SPRINT (u/c MOUNTAIN LTD), KANSAS CITY, KS Sep 02- Jan 03
Data Warehouse Data Analyst
Lead Data Analyst for Order Reporting subject area of large, highly visible system migration (legacy Oracle to OO (Objectel/ OMS) project. Gathered requirements, business rules and integration rules, developed definitions, created data mappings, designed logical and physical data dimensional models for warehouse, operational data mart (NRT), and data marts in support of new integrated reporting (legacy and replacement circuit administration systems) systems.
JABIL CIRCUIT, INC. (u/c MGA TECHNOLOGIES), ST PETERSBURG, FL Sep 01- Jul 02
Data Warehouse Specialist
Reviewed, recommended and implemented improvements for the SAP/ODS ETL jobs and population of associated data marts using ActaWorks ETL tool and dimensional models. Designed, created, tested and implemented new SAP/ODS ETL processes. Reviewed ODS database and datamarts (SQL Server 7/2000) for tuning opportunities and design improvements. Installed, tested, and configured Actaworks ETL tool on test box preparatory to production upgrade. Re-engineered ODS extract process (C+/VB/DTS/Stored Procs) to be event-driven, faster, and more reliable. Provided on-call support for ETL jobs, SQL Server DBA services, data issue resolution, mapping, and discovery.
AVAYA INC. FORMERLY LUCENT TECHNOLOGIES (MGA TECHNOLOGIES), ST PETERSBURG FL
Senior Enterprise Solutions Analyst/Senior Data Modeler Dec 99- Jun 01
Interviewed and assessed data analyst candidates. Co-authored data modeling assessment document. Provided Logical and physical data modeling support for special projects. Mentored junior data modelers and ETL developers. Provided Oracle expertise, SQL tuning and assistance to Informatica developers and other team members, provided development DBA services for Data Administration & Management Team and Development Team. Designed and wrote PL/SQL procedures to populate special databases and reports. Designed and implemented new ODS structures and models. Define & implement data modeling procedures and standards. Audit, design and implement improvements/tuning for central data store. Led Enterprise Logical Modeling effort. Designed SAP/Clarify data interfaces. Lead role for data cleanup activities and Clarify production data problem resolution.
STANDARD INSURANCE, PORTLAND, OR
Data Analyst III Jan 98 - Oct 99
Data analysis, Logical and Physical data modeling, and database design support for retirement plans development team. Application DBA (ORACLE) support designing physical implementations including table sizing and security design, promoting database changes through the development and test environments, Development efforts are carried out in a multi-platform, multi-tier, multi-database environment. Gather Business Requirements and business rules. Design, develop and implement physical data model modifications for maintenance of existing and development of new applications systems, including intra and Internet enabled applications. Monitors database and application performance, and other performance indicators. Recommends and implements enhancements. Provides Database & SQL tuning. Designs and writes database triggers using
PL/SQL. Oracle support and debugging consulting to development team. Designs and maintains test environments. As member of Data Analyst Group is involved in enterprise modeling activities, corporate modeling and design standards definition, data analyst process development and documentation and DAMA activities. Core member Platinum Repository Team.
SOURCE CONSULTING, PORTLAND, OR
Senior Consultant Oct 97-Jan 98
Analyzed the Blue Cross Blue Shield PPO/HMO contracting support system. Conducted a complete needs assessment with the current and projected user base; validated and documented actual system requirements. Recommended a course of action; provided the first draft of a proposed system which automated manual processes, improved an existing Lotus Notes application, and specified new required functionality to be built under Oracle Designer / Developer 2000. Turned over process review, design notes, and data model to DBA and the future design team.
WACKER SILTRONIC, PORTLAND, OR
Business / Database Analyst Mar 97 -Sep 97
Provided Oracle DBA, Data Analysis, Data Steward and Business Analysis services for large international proprietary Order Planning and Product Configuration database (OPS). OPS is the central repository for order and product information and provides data to downstream systems and other clients. Worked with users to define requirements and identify business rules. Analyzed data model and designed database changes for maintenance and enhancement projects using CASE tools (Oracle Designer 2000). Implemented changes to database including triggers, PL/SQL procedures and packages . Responsible for enforcing business rules and assuring data quality. Project Lead for large re-implementation of database as part of plant-wide re-implementation and upgrade project. Member of Project Technical Review Team. DBA for Case tool, SAP back-up DBA. As Business/IT Liaison ensured and developed close relationship between Business and IT; improving system & application performance, enhancing user satisfaction, supporting development and user testing.
Database Analyst Mar 96 -Mar 97
Performed Data Administration functions. Participated in Data Modeling sessions, business rule definition and validation. Provided Help Desk functions answering calls from users requiring knowledge of the data and database and its operation. Worked with developers using SQL to develop ad hoc reports, isolate
Bugs and go into the form tool triggers to identify those that were misfiring. Resolved data inconsistencies. Responsible for data cleansing and scrubbing for data migration, upgrades and database consolidation. Acted as Business/IT liaison ensuring and developed close relationship between Business and IT; enhancing user satisfaction, supporting development and user testing. Constructed ERDs from business definition meetings. Hired as permanent staff March 1997
BRITISH PETROLEUM EXPLORATION ALASKA, ANCHORAGE, AK
Information Analyst 1993 to 1995
Petrotechnical Data Specialist, Petrotechnical Data Center (under several contracts)
Information Management Team member responsible for coordinating all Well data. Managed key subject area of very large relational database (Sybase/UNIX) in client server environment. Supervised data entry, wrote data entry procedures and performed basic table maintenance. Defined and authored detailed technical procedure manual for this table. Analyzed information flows, initiated, and designed process improvements. Provided testing services for proprietary front-end software as well as consulting support to application programming staff. Also performed data upload, rationalization, and quality control checks. Provided database and technical support. Coordinated mission critical data for a large Sybase/Unix client/serve database. Worked with developers to track and resolve difficult to find bugs embedded in stored procedures and SQL triggers within the form tool. -- Reduced Directional Survey loading process time from 45 minutes per survey to 10 minutes via process evaluation and improvements. --Initiated and implemented key information flow improvements. -- Significantly improved database integrity.
Technical Assistant, RAZOR Project 1992 to 1993
Detailed geotechnical and computer assistance to professional geotechnical staff as member of the high profile, inter-corporate (BP/ARCO/EXXON) Reservoir Description Team. Developed and implemented visual data displays. Intensive data maintenance and management services as member of Petrophysics and Data Management sub-team. As member of this team responsible for uploading, rationalization, and quality control for conversion of 20 + million record database from Oracle/VMS (Petros) platform to Sybase/UNIX system in client/server environment. Technical support for numerous database systems including Sybase-SQL support. Trained new-hire Technical Assistants. Provided assistance, back-up and relief services for Information Technology sub-team staff. Corporate software testing.
Technical Assistant, Reservoir Description / PETROPHYSICS Jan 90 - Mar 92
Detailed geotechnical and computer assistance to professional geotechnical staff. As member of database building team located, uploaded and verified wire line well log data. Determined geologic formation markers. Position required good basic knowledge of geology and petrophysics, including wire line log interpretation and heavy use of varied computer hardware and software.
THE WASHINGTON CONSULTING GROUP, INC, WASHINGTON, DC
Junior Analyst Aug 88 -Aug 89
Technical and computer assistance to senior staff of Quantitative Studies and Technical Publications Division. Provided sample frame development and selection for survey studies; database development, design and maintenance and research assistant duties. Produced charts, presentations, and other graphics. Boilerplate proposal writing. PC technical and user support, including software installation and training.
Asistant Facilities Manager Jan 87 -Aug 88
General office management duties. Cost comparison and analysis for corporate purchase of office equipment and machinery, excluding computer hardware and software. Responsible for maintenance of all office equipment and machinery. Designed and implemented purchase order system and database. Supervised staff of five, including annual performance review, hiring and dismissals; planned and Coordinated corporate meeting and events. Promoted to technical staff within one year.
STATE OF ALASKA DEPARTMENT OF NATURAL RESOURCES DGGS - WATER RESOURCES DIVISION/
US DEPARTMENT OF INTERIOR UNITED STATES GEOLOGIC SURVEY, WATER RESOURCES
Student Intern/Hydrologic Aide 83-86
Participated in Groundwater Site Inventory (GWSI) Project, a national project under joint Federal and State sponsorship. Interpreted and prepared water well log, hydrologic, and core data for entry into national water resources database using information provided by drillers and engineers.
1982 to 1986 Anchorage Community College / University of Alaska
Excellent References available upon request
Additional Contact information is available on the Information Page.
Software Contractors' Guild (www.scguild.com)
Copyright(c) 1995 - 2001 Cathryn Mitchell and Software Contractors' Guild,
Post Office Box 257,Nottingham, NH USA 03290-0257