Data Analyst

GEORG CRUTCHLOW

Phone 973-***-**** Parsippany, NJ Email **********@*******.***

SUMMARY

Data Analyst with expertise in multiple data processing environments. Experienced reporting analyst using PC tools, Access, Excel, Word and SQL. Comprehensive analytical and trouble shooting experience. Proficient in all aspects of the project life cycle including systems analysis and design with medical, insurance, financial, payroll, and retailing applications.

TECHNICAL SKILLS

PC Packages: Office (Excel, Word, Access, Outlook) WordPerfect; Crystal Reports; Actuate; Microfocus Workbench; Visual Basic

Databases: Oracle; Datacom; DB2; VSAM; UFAM; SQL; Teradata

System Software: MVS/OS; WINDOWS; LINX; VM/ESA; VM/DOS; CMS; JCL; JES2, JES3; CICS

Languages: COBOL; Microfocus Cobol; DYL280; EASYTRIEVE; SAS; CA IDEAL; RPG II; REXX; IBM Assembler

Mainframe Packages: MVS TSO ISPF SDSF; Strobe; Librarian; FQAS Cobdebug; BHCS; PKZIP MVS / PC; Syncsort; CA7; IBM Utilities

EXPERIENCE

Prudentia/Consultant

2017 to 2018 Data Analyst – Data validation and reporting

Organized data for processing by performing data extraction, transformation, validation, and loading.

Identified issues and suggested actions to resolved anomalies. Took appropriate steps to rectify issues in a timely fashion.

Utilized Excel fuctions and custem macros to do ad hoc data analysis and QA.

Created and debugged Excel and Access VBA marocs to perform data consolidation.

Ethicon - Johnson and Johnson/Consultant

2014 to 2016 Data Analyst – Project and document control role.

Implemented improved process development project tracking dashboard with custom master files by creating a dynamic data collection form and producing key performance indicator reports.

Improved updates to global data collection system forms.

Added advanced Excel features and VBA Macro programming to implement new dynamic features.

Achieved automatic updates on SharePoint to numerous large datasets.

2012 to 2012 Express Scripts/Consultant

Reporting Analyst – Financial Operations and Reconciliation

Designed Access database systems for support of Medicare Part D insurance processing with analysis and reconciliation of premium billing and broker commissions operating within CMS regulations as part of a cross–functional team.

Extracted and manipulated large files via mainframe systems using Excel, Access, Teradata, SQL and SAS. Imported and exported data from Excel to Access. Performed trend analysis and drafted reports based on data results.

Created macros in Access and Excel based on report requirements.

Combined varied large data sets for client by member match. Generated reports on data quality for multiple business units.

2011 to 2012 Medco/Consultant

Reporting Analyst

Responsible for custom ePrescribing report automation with Access, Excel, VBA, Outlook and SharePoint. Set–up user friendly Access databases that import/export from multiple files.

Strong Excel skills pivots, lookups, macros, charts, linear regression and linked tables.

Structured Access to read daily Excel reports, edit, combine and store report data.

Automated formatted Excel report creation from stored Access tables with links to SharePoint.

Automated formatted Access generated Outlook emails with attached reports.

Linked Access SQL to dynamic Excel pivot tables (with drill–down) and charts.

Organized database and Excel comparisons to reconcile data from different sources.

2010 to 2010 Complete Analysis Laboratories

Analytical Chemist

Performed EPA and FDA revived analysis on Medicinal, Environmental and Industrial chemical samples. Performed laboratory QA and maintained equipment software. Developed reporting software.

2003 to 2009 Magellan Behavioral Health

Reporting Analyst

Responsible for developing, updating and generating regular and ad hoc reports integrating data from staff, Access queries, Crystal reports, Actuate and Oracle custom reports. High level of proficiency using Access and Excel in formula manipulation, queries, pivot tables and charts for professional presentation. Reliably met reporting deadlines for government and client reports including the NY state Department of Health and the Department of Social Services for the state of CT. Served as QI liaison to other departments and conducted QI monitoring activities, including generating HEDIS data.

Successfully transferred and integrated a large undocumented multi client multi state reporting system.

Created and mapped a linked system of over 50 monthly reports that significantly streamlined workflow by associating multiple sources of data.

Used SQL, Access, Oracle and Actuate programs to pull together mixed company and branch office data.

Set up, maintained, documented and upgraded mission critical complaint database.

2000 to 2002 Crum and Forster/Consultant

Programmer Analyst

Accomplished a seamless transfer of a major project that successfully transferred a very large mainframe client server insurance system. Project involved over 57,000 data sets, over 6,000 programs and over 1,700 jobs.

Maintained and updated dynamic JCL generating programs.

Maintained and updated a large live commercial insurance underwriting system in an MVS environment with interfaces to a wide range of client server systems.

Designed and wrote custom management data extracts for direct client server database up–loads to text, MVS or PC PKZIP files

1995 to 2000 Grand Union Company

Sr. Programmer Analyst

Maintained and upgraded point of sale data to over 200 store scanning systems. Supported and enhanced the point of sale communications between the stores and data center.

Supervised Y2K conversion and testing of Cobol and DYL280 programs for scanning systems.

Analyzed store full data file problems by data mining store databases. Found that some data items for products that where no longer being sold were not always being deleted. Designed a system to identify the items not being sold and make safe delete transactions so that the old items could be eliminated reliably without time consuming reloads.

Designed, implemented, and evaluated NCR host bad check system.

Coordinated and set up recurrent custom tax updates for state tax changes in 6 states.

Implemented update communications edits with electronic shelf label system in the Telapanel system.

Implemented system to keep scanner and shelf label data in synchronization.

Installed, tested, and maintained the point of sale BHCS system for VSAT satellite communications.

1990 to 1995 Automatic Data Processing

Programmer Analyst

Worked on a new edit system for large volume payroll products. Integrated batch and online programming together for faster processing and improved program maintenance. Performed analysis, design, performance tuning, coding, wrote JCL, handled testing and debugging of new and rewritten programs. Produced program specifications from user interviews and business documentation to implement system updates.

Researched inefficiencies in system and developed fixes that resulted in some programs running 10x faster.

Designed and implemented Datacom database rules interpreter. Programmed edits based on rules that can be updated online and then used without recompiling.

Converted from DOS to MVS COBOL programs and the run JCL.

Set up system to migrated object code from MVS to run on VM ESA.

EDUCATION Fairleigh Dickinson University, Teaneck, NJ Bachelor of Science in Chemistry

Contact this candidate