HOME

 

 

Francis Catrine

      (937) 748-3610                                         561 Valley View Pt., Springboro, OH 45066                                frank@catrine.us

 

Experienced and results-driven Senior Technical Consultant, demonstrating solid analytical and team management skills. Proven track-record of project success through effective application of skills, training, and experience while simultaneously leading teams in direct support of targeted objectives.  Currently seeking a challenging position in Data Warehouse Technologies, Consulting, or Management that will effectively utilize all acquired skills and abilities, bringing 17+ years of professional experience as follows:

 

KEY TECHNICAL SKILLS and STRENGTHS

 


          
§         Data Warehousing                         §         Project Management                      §        Troubleshooting

           §         Data Analysis / Cleansing             §         SQL                                                 §        Needs Assessment

           §         Informatica / ETL                        §         Team Building/Leadership             §         Presentations

           §         Database Design                           §         Teradata / SQL Server                    §         Customer Training

              §         Data Security                                 §          Win / Unix / Linux                        §         Account Management

  

PROFESSIONAL PROFILE

 

EMC / DCD DIVISION, Springboro, Ohio                                                                 Nov. 2010 - Present

Senior Solution Architect – Federal

Member of the Federal Government / DoD team proof of concept (POC) and customer pre-sale work.

-   Coordinate POC effort with client

-   Coordinate POC effort with EMC/Greenplum to include hardware delivery, installation, setup, resources

-   Perform POC to include SQL modification, database build, scripts, etc.

-   RFI/RFP responses

-   Present POC results to customer

-   Perform general pre-sales tasks as needed to include customer meetings, evaluation, need determination

-   Work conferences and trade shows as needed

-   Assist/Develop internal training courses as needed

Federal TS security clearance

 

THE ANALYSIS GROUP (TAG), Dayton, Ohio                                                               May. 2010 – Nov. 2010

Senior Consultant

Data related services in support of the Data Management Office (DMO), part of the ECSS / Oracle ERP initiative for the U.S. Air Force.

-   Data investigation to include source to target identification and mapping

-   Data completion and quality analysis

-   SQL execution in support of investigation and analysis utilizing Oracle tools / PL SQL

-   Represent team in meetings relating to Data quality and analysis

Data Preparation Execution Checklist (DPEC) lead – develop the DPEC to provide actionable steps to be taken by field personnel to ensure data quality and accuracy before migration.

 

MORGAN BORSZCZ CONSULTING, Beavercreek, OH                                    Sep. 2009 – May 2010  

Consultant

Data related services in support of the Repair Data Migration (RDM) project, part of the ECSS / Oracle ERP initiative for the U.S. Air Force.

-    Data investigation to include source to target identification and mapping

-    Data completion and quality analysis

-    SQL execution in support of investigation and analysis

 

TERADATA, Springboro, OH                                                                                Nov. 2007 – June 2009  

Senior Pre-Sales Consultant

Assumes full responsibility for supporting the sale of Teradata solutions by providing product and service knowledge in the pre-sale phase of an engagement.

-    Provides post-sale follow-up and identifies upgrade, application, and consulting opportunities.  Assisted in performance analysis at Sears to establish need for multi-million dollar sale.

-    Assists the sales staff with account qualification and the development of sales strategies.  Worked in support of a $1 + million dollar CRM software and hardware engagement at convenience store / fuel sales client.

-    Prepares documentation supporting consultant engagements including pricing, risk, and Statement of Work.

-    Visits client sites and interacts with clients on a regular basis to establish relationships.

-    Coordinates the escalation of client issues to customer service and engineering.

-    Produces hardware and software capacity analysis and presentations.

-    Developed capacity management tools and practices for the East region teams.

-    Works with Data Security Team presenting concepts and solutions

-    Combined business and capacity analysis to sell $1 million upgrade at major retail clothing client.

 

KFORCE, Dayton, OH                                                                                       Oct. 2006 – Dec. 2006

ETL Consultant

Designed, tested, and implemented ETL using SQL, shell scripts, tables, and database work.

-    ETL development utilizing Informatica – Flat File and Oracle source, Teradata target.

-    Source data analysis, target staging modeling.

 

BUSINESS OBJECTS, Springboro, OH                                                            Dec. 2005 – Aug. 2006

Senior Pre-Sales Consultant

Collaborated with sales staff to qualify and prove opportunities for Business Objects EIM Solutions (Data Quality, Profiling, Integrator).

-    Prepared and presented solutions for specific client needs.

-    Demonstrated Business Objects EIM Solutions to prospective customers.

-    Trained in and Proof Of Concept work with Data Integrator.

 

HAVERSTICK GOVERNMENT SOLUTIONS, Beavercreek, OH                    Jul. 2005 – Dec. 2005  

Senior Consultant

Provided ETL and Data Warehousing support for the U.S. Air Force, including requirements gathering, database research and analysis, database design, SQL work.. 

-    Informatica XML file loads.

-    Teradata BTEQ scripts.

-    Haverstick project Team Lead.

-    Secret Security Clearance

 

INFORMATICA, Springboro, OH                                                                      Sep. 2004 – May 2005

Senior Pre-Sales Consultant

Worked directly with sales staff to qualify and prove opportunities for Informatica Data Integration (ETL) and Business Intelligence opportunities.

-          Prepared and presented solutions for Enterprise Data Integration (ETL) Platform.

-          Demonstrated Informatica Data Integration & BI unified solution to prospective customers.

-          Responded to Customer Requests for Information on Informatica products. 

 

HAVERSTICK GOVERNMENT SOLUTIONS, Beavercreek, OH                 Nov. 2002 – Sep. 2004  

Senior Consultant

Provided Data Warehousing support for the U.S. Air Force, including requirements gathering, database research and analysis, database design, SQL work, report analysis, documentation, and customer evaluation. 

-    Conducted user interviews, requirements gathering, along with conceptual and logical modeling.

-    Full data analysis from source to target systems.

-    Produced detailed data specifications for a software build contractor. 

-    System Architect Administrator for the EBS program office.

 

ARCH WIRELESS, Cincinnati, OH                                                                       Jan. 2002 – Jan. 2003

Senior DBA

Served as Senior DBA to corporate systems to include analysis, data modeling, backup and recovery, security, development advisory, and other DBA tasks. 

-    Worked with SQL Server 6.5 and 7.0 on Windows NT and 2000, DTS, BCP, stored procedures, etc.

-    Responsible for migration requests, problem resolution, and pro-active initiatives to prevent outages. 

-    Worked with MapInfo GIS tools to load, transform, and transfer/migrate GIS data.

-    Worked on the numbers management data warehouse initiative, including design, recommendations, and need assessment.

 

SELF EMPLOYED, Cincinnati, OH                                                                    May 2001 – Jan. 2002

Database & Computer Consulting

Provided general consulting in database development and technologies, computer systems, and web development. 

 

SAGENT TECHNOLOGIES, Cincinnati, OH                                                  Sept. 1999 – Apr. 2001  

Regional Technical Manager | Pre-Sales

Provided pre-sales technical assistance and consultative selling of the Sagent development suite, including presentations, consulting, needs assessment, and Sagent fit, proof of concept, and RFI / proposal response. 

-    Utilized consultative selling to establish relationships with “C” level personal, as well as to present ideas and methodologies to technical staff. 

-    Managed the client base including technical assistance, reference generation, and evaluation of future needs.

-    DBA functions including system setup, installation, SQL analysis and tuning, script, database building, etc. using SQL Server, Oracle, Informix, etc. 

-   Worked as part of the UNIX product implementation including installation, assessment, and training (both client and Sagent personnel).

 

SCH TECHNOLOGIES, Cincinnati, OH                                                          Mar. 1999 – Sept. 1999

Project Manager

Managed all MIS projects, including analysis, team building, vendor research, development, testing, and implementation.  Provided backup support for users, DBA support, and other MIS functions.

 

THE ROSS GROUP, Dayton, OH                                                                     Oct. 1997 – Mar. 1999

Director – Informix Services

Served as Senior Consultant for Informix clients, specializing in DBA, database design and analysis, and data warehousing. 

-    Generated new clients and hired, placed, and managed Consultants.

 

INFORMIX SOFTWARE, Cincinnati, OH                                                           Jan. 1997 – Oct. 1997

Senior Pre-Sales Systems Engineer

Provided pre-sales technical assistance including demonstrations, presentations, consulting, and needs assessment. 

-    Technical account management of the current client base to include technical troubleshooting assistance, database consulting, and evaluation of future needs.

-    Provided hardware/software evaluation and customer training. 

 

COLLEGEVIEW, Cincinnati, OH                                                                        May 1995 – Jan. 1997

Project Manager | Database Analyst

Managed a project involving connection of 2,700+ high school and college sites to CollegeView via modem and network including database design, analysis, and development.

-    Purchased and provided customer and in-house support of software/hardware.

 

CARS INFORMATION SYSTEMS, Cincinnati, OH                                           Jun. 1994 – May 1995

DBA | Research Analyst

Administrator for all Informix databases and company liaison to Informix for support and product issues. 

-    Researched/evaluated new technologies and recommended/managed database related projects and growth. 

-    Managed corporate PC hardware/software daily operations.

 

BASS INC., Dayton, OH                                                                                      May 1991 – Jun. 1994

Programmer | Analyst

Developed and maintained the retail scanning support system in a COBOL and UNIX environment and performed shell programming, documentation, and new system development.

 

  

EDUCATION & TRAINING

 

Capitol University | Bachelor’s in Management Information Systems

Sinclair Community College | Associate’s in Computer Information Systems

Villanova University | Masters Certificate Program – Program Management IT/IS

Teradata Certified Professional V2R5

Informix Classes | Management Classes/Seminars | MS Windows/NT Classes | Oracle OCA/OCP Training

U.S. Air Force Honorable discharge, service dates Mar 1980 – Mar 1985.  Held TS SBI/SCI clearance

Currently Hold Secret Security Clearance

 

 

References

HOME

Word version of Resume