Sr. Statistical / QA / ETL Consultant, 15+ years exp. (Broomfield,CO)
Information Technology Manager / Problem Solver
Experienced in quickly finding patterns in complex business and
technical problems, then providing a simple, stable solution. Able to
explain technical concepts in useful ways. Can see opportunities for new
technologies and provide practical, creative cost-saving strategies for
their use.
Leadership, management and business expertise includes:
- Supervision of software teams and data center staff
- Clarify and simplify processes
- Mentor others while developing and testing software
- Create reporting systems to track operational metrics
Technology expertise includes:
- Quality Assurance – develop and execute test strategy and cases.
Compuware tools QA Run, TrackRecord.
- Food and Drug Administration (FDA) regulation 21 CFR 11 validation,
including GMP and GCP.
- Microsoft Office: Word, Excel, Access, PowerPoint.
- DB2 / SQL (IBM certified), SAS, COBOL, IMS, TSO/ISPF/JCL, utilities.
- Data warehouse training. Extract, Transform & Load (ETL) tools,
multidimensional modeling using Cognos PowerPlay, Knosys ProClarity &
MS OLAP Services.
- Strategy and Joint Application Design (JAD) design meeting
facilitation skills.
- Object-oriented analysis and design, information engineering, data
and function modeling.
Professional Experience:
Easy Solution, Morton Grove, Illinois – Consultant – April, 2007 to
June, 2007
Wrote custom ETL tool in Windows SAS and SQL to access Teradata
tables and load data into Microsoft Access for transport to AT&T.
Application included New Jersey and Georgia lives into existing marketing
reporting of Illinois lives. Took existing SQL code from Illinois system
and made it run inside the SAS code for processing of the New Jersey and
Georgia data. Validated source data fields from the New Jersey and
Georgia files into their proper target fields in the Illinois output
tables. Validated reports against existing Business Intelligence system,
to the penny. Enabled Blue Cross/Blue Shield of Illinois to get
substantial new business with AT&T. Thought to be impossible,
especially in the time available.
COMSYS, Oakbrook Terrace, Illinois – Consultant – May, 2005 to March,
2007
Supported credit card marketing analysis and reporting for major oil
companies and various retail private label accounts at Citigroup Credit
Card Services in Deerfield and Elk Grove Village, Illinois. Produced
series of weekly and monthly reports that detailed card usage, attrition,
and activation statuses. Designed, developed and produced new ad hoc
reports for such things as targeted marketing studies by zip code. Worked
with programs to transition inactive account holders to active usage
status. Prepared files of non-monetary transactions to repair account
details at First Data Resources for groups of account holders. Accessed
very large databases to prepare market sizing efforts with consideration
for risk and privacy. In market sizings, helped balance tradeoff between
risk of delinquency and charge-off and promotion of cardholder base
and usage. Addressed ad hoc problems as needed. Documented and improved
production. Supported Drug Distribution Data sales tracking system in
COBOL and SAS at Abbott Labs on OS/390, UNIX, and PC.
Unitech Solutions, Skokie, Illinois - Quality Assurance Consultant –
July, 2003 to January, 2004
- Performed business analysis to develop SDLC functional system
requirements, determining objectives and methods for conversion of
Laboratory Information Management System (LIMS) from Nomad / VM/CMS
platform to Oracle Clinical / UNIX system at Pharmaceutical Research and
Development division of Abbott Laboratories. Worked with project
management, technical staff and subject matter experts to ensure
continued compliance with Food and Drug Administration (FDA) regulation
21CFR11.
- Wrote test cases, supervised test execution, reviewed results,
tracked project progress and produced test summarization for validation
package.
- Used SAS analysis and programming expertise to ensure LIMS data would
continue to be represented and processed in desired ways in Oracle
Clinical storage format as it had been in Nomad.
- Validated reporting for the R&D LIMS Oracle database using
Business Objects version 6.5.
Compuware, Milwaukee, Wisconsin – Consultant – October, 1997 to April,
2003
- For General Electric Medical performed software quality assurance on
Excel / VBA sales proposal generation and reporting system. Allowed
developer to provide 20% better client value, while reducing pattern of
proposal errors on complex diagnostic medical equipment that resulted in
lost revenue.
- Software Quality Assurance for Voting Technologies International.
Verified entire election cycle of touch-screen voting system resulting in
stable operation prior to Federal Election Commission Certification.
- Maintained automated testing procedure for validation of complex
medical device at Baxter Labs for compliance to Food and Drug
Administration regulation 21CFR820.
- Provided business analysis and programming maintenance and
development support in simplifying, stabilizing, documenting and
enhancing Statistical Analysis System (SAS) warranty claims system
operations at Harley-Davidson, saving 10% when application was migrated
to intranet. Used SAS PROC modules MEANS, FREQ, FORMAT, PRINCOMP, FACTOR,
FUNCAT, CORR, UNIVARIATE and TABULATE. Tightened data quality standards
and processes.
- At Northwestern Mutual, repaired usability problem in online CICS /
COBOL mainframe application. Postponed software replacement and provided
practical, creative $100,000 cost savings and renewed productivity for
business user. Supported migration of SAS operations chargeback
application to PeopleSoft financial application by providing explanation
of SAS processing details to conversion team.
- Team member on cube design, data extract and loading for pilot data
warehouse OLAP application at Briggs & Stratton to track warranty
claims reimbursement of dealer-servicing costs of gasoline engines.
- At Case-New Holland, provided software maintenance coding support for
IMS / COBOL systems for warranty claims and to track in-house equipment
transfers between dealers. Provided SAS analysis, design and programming
support for a phone usage monitoring system to report improper
international calls.
- As a Team Leader during Miller Brewing’s Y2K migration designed and
programmed SAS system to analyze System Management Facility (SMF) data to
derive proper test sequence to verify mainframe batch cycle testing.
Provided supervision for eight-person team.
Cap-Gemini Sogeti, Westchester, Illinois – Consultant – August, 1996
to September, 1997
Provided operations support, software maintenance, training
co-ordination and change control management for a mainframe re-insurance
application at Allstate.
Omni Resources, Brookfield, Wisconsin – Consultant – November, 1993 to
July, 1996
- Consolidated Ameritech application from six data centers to one,
achieving 80% operating cost reduction.
- Developed and regression tested solutions to demand deposit
application errors at Metavante, a global bank service bureau. Modified
production software enabling growth while saving 10% by consolidating
hardware.
- Modified, tested & installed mainframe day care administration
system for Milwaukee County for compliance to Health & Human Services
regulations.
Interactive Business Systems, Brookfield, Wisconsin – Consultant –
September, 1993 to November, 1993
Programmed flexible SAS reporting system for Ameritech customer
demographics marketing research.
Ameritech Services, Inc., Chicago, Illinois - Supervisor, Project Manager
– May, 1988 to November, 1992
- Tracked and investigated mainframe service disruptions as Computer
Operations Problem Project Manager. Devised problem solutions and process
improvements with system technicians and clients. Designed and programmed
SAS applications to investigate and measure mainframe SMF data to
document outage causes and analyze system performance.
- Achieved over 98% system availability on 8 mainframes in Data Center
Operations. Supervisor for 18 operations personnel. Systems Programmer
onsite for technical changes to system hardware and software.
Nims Associates, Dallas, Texas – Consultant – January, 1987 to
November, 1987
As Programmer/Analyst converted an MS Windows, BASIC application for
a health care provider. Coded and tested an MVS, TSO, COBOL project
management system for a telephone company. Installed and tested a quality
control application in Dbase III for a roofing manufacturer.
Browning Associates, Fort Worth, Texas – Consultant – July, 1986 to
January, 1987
As Programmer/Analyst with MS Windows and Dbase III, developed a
progress-of-payments application for an electrical contractor.
Columbia Consulting, Fort Worth, Texas – Consultant – October, 1984 to
July, 1986
As Programmer/Analyst on Wang VS/100, designed, coded and tested
agent license verification applications for NN Insurance, a group health
insurance company.
Kenneth Copeland Ministries, Fort Worth, Texas - Systems Analyst –
October, 1983 to October, 1984
As Programmer/Analyst on Wang VS/100, designed, coded and tested
system to track manufacture and inventory of recorded cassette
tapes.
Bureau of the Budget, Governor’s Office, Springfield, Illinois,
Systems Analyst – September, 1977 to October, 1983
As Programmer/Analyst in MVS, TSO, IMS, VSAM, COBOL, SAS environment,
designed, coded, tested, implemented and maintained batch system for
monthly analysis of State Comptroller’s Balance files using COBOL and
TSO. Integrated that system with an IMS DB/DC system for managing and
publishing the Governor’s Budget Book for distribution at the annual
State of the State address to the legislature. Provided analytical
solutions to ad hoc reporting crises using SAS.
Contact: Contact information available to DataShaping clients. URL: www.datashaping.com/resumes16204r.shtml
Please mention datashaping.com when contacting me. Thank you.
|
