• Mechanicsburg PA
  • (717)728.9222
  • galengish@hotmail.com

Galen Gish

Data Analyst | Systems Analyst | Business Analyst


Seventeen years of experience in the IT industry providing a combination of business and technical skills to entities in the private and public sectors. Currently working for a "Big 4" consulting company in an advisory capacity on multiple projects concurrently. Draw upon prior experience in private and public sectors to provide guidance, project oversight, planning, risk analysis, discovery & mitigation, contingency planning, facilitation, data analysis, etc.

Work History

Work History

Business Analyst

Oct 2014 - Present
KPMG (Contract)

Provide management consulting to the Commonwealth of Pennsylvania, Department of Human Services

Interact at all levels under the Deputy Secretary to the Governor of Pennsylvania in the deployment of enterprise systems directly impacting millions of citizens daily. Breadth of exposure includes acting in an advisory capacity on potential impacts as a result of federal and state mandates, policy changes, labor relations, bureau coordination, and technology upgrades realized as regular system deployments. Provide internal and external expertise in software development, logistics, data analytics, development and deployment of advanced reporting systems, business intelligence and executive dashboards

Senior Technical Business Analyst

Dec 2010 - Nov 2013
Highmark Blue Shield (Contract)

Senior Technical Business Analyst on 100-person Enterprise Data Warehouse team. Led ETL projects, defined & captured requirements, built data model requests, data mapping, transformation algorithms, mentored others on SQL, business & technical aspects, built tools, provided triage & support of production systems

Business Analyst

Aug 2006 - Aug 2009

Provided project based, business and technical analysis, performed testing and reporting for a multi-state, multi-client healthcare claims processing product developed and supported with global teams. Developed re-architecture strategies using encapsulation of code to convert from a monolithic architecture to a componentized, Service Oriented Architecture that could be deployed across multiple configurations of disparate systems


Feb 2003 - Jul 2006

Multi-state custom software implementation of Women, Infants, and Children(WIC) application

Acted as a project consultant participating in the entire life cycle of a custom WIC system. Met with clients to capture & refine business needs into codeable solutions. Developed assessment tool that interpreted federal USDA guidelines & state guidelines to provide system-generated list of nutritional risks for each participant in the WIC program based on anthropomorphic data & data gathered during participant interviews. Wrote VB.Net base classes and XML to provide a single code base solution for implementation in multiple states. Tested all aspects of the system. Trained the client at multiple locations on the application. Conducted User Acceptance Testing(UAT). Provided 1st & 2nd-level support of the system during development & after installation. Provided nationwide sales support demonstrating the system to prospective clients & the National WIC Association Conference. Created system documentation & release notes. Helped secure new business. Used advanced ANSI SQL and the Microsoft SQL Server Analysis Services to provide real time analysis using n-dimensional cubes to present data gathered at the clinic and state level. Data gathered was structured & extracted from system designed by CIBER. Quality of data was high based on age of system, design of system & data elements analyzed(anthropomorphic data & participation data). The data extracted & analyzed was used by client in monthly reports provided to the client as well as used at sales presentations & trade shows across the United States. Created & maintained all user documentation related to system upgrades & communicated changes to client as part of the incremental release process. Used a combination of tools including Borland Caliber RM, Test Director, Visio & Word to maintain up-to-date information for release notes.

HR Systems Consultant

Feb 1998 - Dec 2002

Corporate HR Systems Consultant; Business Intelligence Consultant; Sr. Technical Recruiter



Bachelor of Arts degree in Music Performance

Aug 1984 - Jun 1992
Butler University, Indianapolis, IN

Non-Degree Studies (Guest Matriculant)

Aug 1987 - Jun 1989
Indiana University, Bloomington, IN

Technical Skills





Relational Databases


Ability to train others


Enjoy walking the line between business & technology. Extensive background with SQL, multiple platforms (desktop, midrange, mainframe, Unix/Linux, Windows, MVS), comfortable with data warehouses & operational data stores, reporting services, multi-dimensional data cubes, numerous databases including Teradata, Informatica, SQL Server, Access, Oracle & DB2.

Software development experience with VBA, Microsoft Access, Excel and VB including .Net. Provide data analysis & visualization with Excel, QlickView, Alteryx, R, and Access. Experience defining & automating ETL (Extraction, Transformation, Loading) from various data sources to targets, manual & automated testing, defining metadata and physical structures within target databases.