Post Job Free

Resume

Sign in

Business/Data Analyst

Location:
Lake Villa, IL
Posted:
February 03, 2015

Contact this candidate

Original resume on Jobvertise

Resume:

Cary Scharlau Email: acn5bj@r.postjobfree.com LinkedIn:

www.linkedin.com/in/caryscharlau/

***** ***** ****** *****

Lake Villa, IL 60046

847-***-****

PROFILE

BUSINESS TECHNOLOGY MANAGER - Results oriented technology manager

experienced in design, development and implementation of complex business

systems. Over 28 years experience with IBM mid-range systems and Microsoft

application/database servers. Worked in all types of organizations from

start-up to mature business. Industry focus on retail. Broad range of

technology and business skills with hands on approach to evaluation,

implementation and support. Last several years, focus on business skill

set acting as liaison between organization and IT. Interested in exploring

a role leaning more towards the business function as a business or IT

business analyst, possibly outside of IT.

PROFESSIONAL EXPERIENCE

Midas International, Itasca, Illinois 2000 - 2013

One of the world's largest providers of automotive service, 2350

franchised, licensed and company-owned Midas shops in 15 countries,

including nearly 1,600 in the United States and Canada. Midas also owns the

SpeeDee Oil Change business, with 172 auto service centers in the United

States and Mexico.

IT Director, 2004 - 2013

Asked by CFO to move over to IT, manage development team and assist in

other IT related management duties. IT needed to be restructured and

downsized, requiring a more open, creative and productive environment.

Oversaw the following:

Developed portal web sites as main communication mechanism between

corporate and US/Canada shops.

Personally worked with rest of organization to evaluate/enhance processes

and related systems.

Implemented and customized Microsoft Dynamics financial modules and Frx

financial reporting software.

Developed in-house queue-based Collections system integrated with Dynamics

AR.

Developed in-house Royalty and Warranty systems utilizing .Net and

Microsoft SQL.

Implemented Sarbanes/Oxley throughout department, establishing better

controls in all IT areas.

Business Analyst Finance, 2000 - 2004

Initially hired as a consultant and later employed by company CFO to manage

several finance-sponsored systems and operational projects. Worked in

finance department acting as liaison between IT, finance and other

departments to purchase/develop, manage/implement systems and process

automation.

Coordinated business-requirement enhancement requests and user testing for

new JDA ERP system for finance.

Managed team for the migration of in-house mainframe payroll/benefits

system to outsourced ADP.

Implemented Adaytum Cognos Planning financial reporting and consolidation

software .

Developed many automated solutions utilizing Microsoft Access/Excel with

ERP ODBC connections.

DELRAY FARMS, inc, Chicago, Illinois 1995 - 2000

Chain of over 25 ethnic-based grocery stores specializing in produce, dairy

and meats. Primary located in the Chicago area market with a few locations

in Georgia. Competed with small local independently-owned produce stores.

Consultant, 2000 - 2005

On annual retainer agreements, remotely supported all IT systems and

processes, with occasional project and on site work.

IT Director, 1995 - 2000

IT Department management including project planning, budgeting and vendor

relationships. Responsible for all aspects of AS400 design, development,

implementation and operations. Managed small staff.

Installed and configured AS400 Model 300 along with with JDA ERP System.

Designed point-of-sale interface on AS400 and other interfaces to Microsoft

Backoffice servers/databases.

Installed and supported ADP and Kronos payroll software.

Designed ordering, inventory and margin analysis programs utilizing

Access/SQL with links to AS400.

Completed software / hardware Y2K analysis and implementation on all

systems, servers and networks.

Courtesy home centers, Wheeling, Illinois 1991 - 1995

Small group of home improvement stores located in the Chicago area that

existed prior to the arrival of the large home improvement chains in the

area.

IT Director

Responsible for management of IT staff consisting of programmers, quality

assurance coordinator, point-of-sale manager and consultants. Hardware

included IBM AS400, Novell File Server, and Point-of-sale. Analysis,

design, maintenance, training and support of systems. Product evaluation

and selection for hardware and software. Departmental planning,

budgeting, communications and vendor negotiating.

Restructure of IT department staff, operations and processes.

Trained entry level programmer in AS400 operations and RPG

programming/analysis.

Designed test environment and implemented change-management development

environment.

Designed AS400 interface to point-of-sale system.

Conversion design and training on new version of JDA financial system.

Created custom merchandising and financial applications utilizing

Access/Excel with interfaces to AS400.

Circle Fine Art Corporation, Chicago, Illinois 1988 - 1991

Large chain of small art gallery stores located throughout the US in urban

and travel destination areas. Sold limited edition original paintings and

lithographs from a select group of artists, Disney animation cells and

custom designed jewelry.

Project Manager / Senior Programmer Analyst

Responsible for analysis, design and support of finance, inventory, sales,

and commission systems on IBM System 36 and AS400 utilizing RPG II, ASNA

RPG III and RPG400. Analysis, design and programming of new applications.

IT department communications and system support, consulting on new projects

and software. Assistant management of IT department and data entry

personnel. Trained and supported users on new systems.

Established data integrity audit on IBM System 36 to identify and correct

problem areas.

Managed migration from System 36 to IBM AS400.

Implemented custom-built inventory, sales and order entry systems working

with outside consulting firm.

Rebuilt/Enhanced commission system in RPG on AS400.

Designed point-of-sale and other 3rd party interfaces to AS400.

Handy Andy Home Improvement Centers, Gurnee and Schaumburg, Illinois

1985 - 1988

Large chain of home improvement stores located in Illinois, Indiana, Ohio

and Michigan that existed prior to the expansion of the current large home

improvement chains into those states.

Senior Programmer Analyst

Responsible for analysis, design, programming and support of financial,

payroll and sales systems on IBM Systems 36 and 38. Other

responsibilities included the management, support and training of all

corporate operations. Supported all IT functions in two corporate offices

and distribution center.

Designed IBM System 36 interface to point-of-sale system.

Managed migration from IBM System 36 to IBM System 38.

Managed conversion to new JDA Merchandise / Financial management ERP

system.

Developed enhancements to JDA system modules for specific company

requirements.

Configured, installed and supported Novell network at distribution

facility.

Designed payroll and accounts payable check reconciliation programs.

Configured, installed and supported PC hardware and software.

Education

College of Lake County

Associate of Applied Science - Data Processing - 1984



Contact this candidate