Data Analyst

COLLIN C CROWTHER

**** ****** **.

Alexandria, VA 22306

703-***-****

***************@*****.***

EXPERIENCE

GLOBAL IMAGING SYSTEMS, INC

Data Analyst; April 2008 – January 2010

Responsibilities include providing business process documentation and data analysis reporting for the day to day sales, service and inventory activities.

Specific data analysis responsibilities included:

• Facilitate requirements gathering sessions with users, system experts, and executives to identify and document current business processes;

• Design, test and implement new detailed requirement documentation forms, templates, standards and procedures;

• Create and maintain a standard repository for requirements documents, use cases, and business process workflows;

• Develop automated processes to capture sales, service and financial data from wide variety of sources to load SQL 2005, Access and Oracle tables;

• Design and implement training courses to aid end users in new system functionality and data reporting services;

• Analyze data to determine current sales trends and report findings along with forecast models and summary directly to executive level management;

• Generate new and existing monthly sales, service, and inventory reports utilizing Access, SSRS, and Excel spreadsheets;

• Process the necessary transactions within the OMD Business Management System database to extract data and load external tables for data mining and analysis;

CCS MEDICAL

Sales Data Analyst; November 2007 – April 2008

Responsibilities include creating new sales reports and documentation of new and existing business processes.

Specific data analysis responsibilities included:

• Create new sales reports to include new forecasting statistics and trend analysis utilizing Crystal Reports and InfoMaker;

• Develop requirements documentation to aid in the execution of new and existing sales reports and data mining activities;

• Analyze, modify, and maintain operational procedures to assist with the outside sales team;

• Asses the viability of each project and update the appropriate acquisition and financial databases as necessary;

• Coordinate requirements gathering sessions with sales force to elicit new business requirements;

HEALTH PLAN SERVICES

Computer Programmer; August 2006 – February 2007

Responsibilities include development of new applications to assist with archiving of old accounts based on requirements documentation from large health insurance companies.

Specific Computer Programmer responsibilities included:

• Create new CICS programs and DB2 tables to archive old health insurance accounts;

• Develop SQL queries to data mine and populate new and existing DB2 tables;

• Build test scripts to validate new programs and tables against existing system functionality ;

• Implement new tables and application into the production environment using Changeman and Roscoe tools;

• Document new functionality and new processes available to the end user community;

UPS AIRLINES

-Airline Enterprise Release Management Team Analyst; January 2002 – February 2006

-Senior Programmer Analyst; November 1998 – January 2002

Airline Enterprise Release Management Team Analyst; January 2002 – February 2006

Responsibilities include all aspects of application, system, and configuration management including development and analysis of critical airline systems, CMM activities, and all associated reporting activities.

Specific Airline Enterprise Release Management Team responsibilities included:

• Coordinate CMM project to achieve level three CMM certification for all core airline support teams;

• Facilitate a comprehensive Business Impact Analysis of all critical core airline systems and applications;

• Conduct interviews with department heads, subject matter experts, and end users to identify, gather, and document business requirements;

• Manage and maintain all requirements, surveys, business models and process flows utilizing SharePoint and PVCS;

• Act as the primary liaison between the user community and the software support team to gather requirements for new or existing system functionality and translate those requirements into technical specifications;

• Develop, test, and implement an alternate airline operations center and run the airline successfully from the alternate site;

• Design, test and maintain training courses to deliver new system functionality via classroom and web training curriculums;

• Document, analyze, and evaluate business processes to conform to FAA mandated regulations;

Senior Programmer Analyst, Flight Operations Support; November 1998 – January 2002

Primary responsibilities include system support and new development of critical airline systems and applications and to increase system reliability, availability and data integrity.

Specific Senior Programmer Analyst responsibilities included:

• Develop new airline crew tracking system using detailed requirements documentation to include FAA mandated requirements;

• Code application changes, facilitated peer reviews and implemented application changes to the flight tracking, crew, ACARS, and flight scheduling systems;

• Coordinate and attend change control meetings to facilitate application and system upgrades;

• Provide around the clock application and system support via pager and cell phone;

• Assist in the development of project plans, procurement of new systems, and budgeting for the Flight Operations Team;

EDUCATION

Principia College, Elsah, IL

B.A., Business Administration June 1998

TECHNICAL SKILLS

• Operating Systems: Windows, Unix, Z/OS

• Programming Languages: PL/SQL, SQL, HTML, COBOL, IMS, CICS, JCL

• Database Systems: Oracle 9i, SQL 2000/2005, DB2, Excel, Access, VSAM

• Tools: PVCS, SQL Plus, Toad, SQL Developer, Crystal Reports, SharePoint, Project, Visio

PROFESSIONAL CERTIFICATIONS

• Oracle PL/SQL Developer Certified Associate

• Certified Business Continuity Planner

• Tryon Classes: Project Management Fundamentals, Structured System Analysis, Requirements Management

Contact this candidate