Download PDF

Galen Gish

Data Analyst | Systems Analyst | Business Analyst

Summary

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 experience

Oct 2014Present

Business Analyst

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

Dec 2010Nov 2013

Senior Technical Business Analyst

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

Aug 2006Aug 2009

Business Analyst

EDS/HP

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 2003Jul 2006

Consultant

CIBER

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.

Feb 1998Dec 2002

HR Systems Consultant

EDS

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

Education

Aug 1984Jun 1992

Bachelor of Arts degree in Music Performance

Butler University, Indianapolis, IN
Aug 1987Jun 1989

Non-Degree Studies (Guest Matriculant)

Indiana University, Bloomington, IN

Technical Skills

Analysis
Excel
VBA
Relational Databases
ANSI SQL
Ability to train others

Summary

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.