SUMARY

A Highly motivated, skilled, Senior Developer/Business Analyst with 35 years’ experience. The last 10 of which have been spent in working with MAPPER and SQL. Prior to that it was almost exclusively MAPPER. Have held senior level and lead developer positions. A Successful record of analysis / design / implementation. Strong written and verbal communication skills as well as ability to interface with all levels management and public.

HARDWARE

Unisys 1100 Series, 2200 Series, Clearpath, UNIX & NT, IBM 3090 AS/400, PCs, Honeywell Level 66 and DPS8, Xerox Mainframes, Dell & HP Servers

TECHNICAL

Programming Languages: T-SQL, PL/SQL, MAPPER/BIS/COOLIce, Javascript, C++, VB, HTML, CSS, COBOL, RM-COBOL, Micro-Focus COBOL

Databases: SQL Server 2005, 2008, 2012, 2016, MAPPER, Business Information Server, MS Access, DBase, Paradox, FoxPro, My SQL, Oracle, Data Warehousing (Star/Snowflake), NoSQL

Software: Business Objects, Crystal Reports, SAP, JIRA, SSIS/SSDT, SSRS, TFS, SSMS, Visual Studio, MAPPER/BIS, COOLIce, Microsoft Professional Office Suite, FrontPage, Expressions, Visio, Project, Corel Office Suite, Personify, Protek CMS, IQMS

PROFESSIONAL EXPERIENCE

Know How Limited (Unisys MAPPER Consultant) /SQL 08-1989 - Present

City of New York – Human Resource Administration - MAPPER Consultant 05-2019 – Current

Analyze existing WeCare and ABAWD system

oThese are systems the track people that they state is helping financially and getting them back on their own feet.

Create runs needed to move Legacy Data to Oracle

Crown Equipment Corporation Remote Evening Work 08-2018 – 01-2019

Analysis of Existing undocumented System

Creating new Archive system

Chicago Transit Authority Remote Evening Work 08-2017 – 04-2018

Analysis of existing undocumented MAPPER Records Management System

Determine All tables used in system

Create detailed layouts for all fields/tables used to determine the mapping between the legacy system and new MS-SQL based system

Create routines to automatically download all data from MAPPER to CSV & Text files

EMC Insurance – MAPPER Consultant – Full time work 02-2016 – 04-2017

Rewriting various parts of Insurance Application

Lead team of 8 remote self-employed consultants

Responsible for HR and Invoicing

Unisys MAPPER Consultants / SSRS Developer / Report Writer

Managing 7 member team In the rewriting of various applications in an insurance system

Gathering Business Requirements as well as Data Analysis

General Programming

SQL Developer - SSRS Developer / Report Writer

State of Washington – Department of Social & Health Svc Remote Evening Work 08-2014 – Present

Troubleshoot Upgrade of MAPPER from version 10.1 to 11.1E5/General Support

Setup ‘best practices’ for the administration of three MAPPER Systems

Analyze detailed logic in programs for various users

Setup / Install/Configure BIS & COOLIce

GKI Industries Remote Evening Work 12-2011 – 01-2013

Update financial programs

Create system that would allow users to scan in documents for machine work and then keep each generation of documentation so the user could view any documentation at any time.

Chicago Transit Authority Remote Evening Work 08-2015 – 02-2016

Determine data used by Law & Workers Compensation system

Create detailed layouts for all fields/tables used to determine the mapping between the legacy system and new MS-SQL based system

Create routines to download all data from MAPPER to CSV & Text files

Create routine to produce HTML files for all tables/fields in systems

Modifications to Warehouse Inventory Control System

Enhanced Chicago transit Authority (CTA) Monthly Pass System (Inventory Control - Made programs table driven) - Passes distributed throughout Chicago

MAPPER Technical Support

AAA Motor Club Remote Evening Work 07-2009 – 03-2011

MAPPER Technical Support

General Programming Support

Create new look up routines for Vehicle Identification Numbers (AAA Motor Club) (complete)

Create routines for encrypting passwords

Chicago Public Schools Consultant/Programmer/Business Analyst 05/1983 – 06/2013

Database Administrator – This include backup/restore, maintenance and installation of software

Using TFS as repository for sql scripts

Building SSIS packages for routine tasks

Converting Business Object (XI) into SSRS Reports – Approximately 20 reports

Create SQL stored procedures using SSMS for SSRS

Converting Legacy data from Flat files into relational tables using T-SQL & SSIS

Create Stored Procedures so Data load for transcripts is repeatable

Analyze, design, program, test, and implementation of BIS/CoolICE & T_SQL programs to allow schools to schedule phone calls to students. Programs needed to interface from Business Information Server to Oracle and MS-SQL databases

Automation of student absentee and general message phone calling using T-SQL for individual schools (approx. 10,000,000 calls per year)

Team Lead/Mentor/Training of Programming Language and Web Design

Building Web Application (HTML, CSS, AJAX, BIS, MySQL) that will allow users to retrieve various information about their environment from the cloud

Creation of MS-ACCESS tables for Early Childhood department to keep track of student assessment progress.

Taught Early Childhood department users how to retrieve information in MS-ACCESS

Create Menu system with MS-Access for Early Childhood

Standardized Cool-ICE development

oRegistration of Runs, Menu System, Saving of Variables/Arrays and Results, Function keys, Reloading of Variables/Arrays and Results

Analyze, design, program, test, and implementation of BIS/Cool-ICE with JavaScript for the verification of: Student Enrollment Projection, Free/Reduced and TANF, and Verification and Special ED Teacher Projections.

Analyze, design, program, test, and implementation of BIS/Cool-ICE to allow over 500 users enter Child Assessments Information on each of 30,000 children.

Provided ability for teachers to lookup where they are in the Teacher re-certification process using Business Information Server and the web.

Create generic programs to allow the creation of diary pages using the WEB. This was done using HTML and Business Information Server.

Create Monitoring dashboard with CoolICE to make sure that all programs are working properly

Used COBOL to reformat data as needed

COBOL Support as required

Use Pivot table to produce various charts for management

Converting MAPPER/BIS (Legacy) code into SQL Stored Procedures

Create tracking and placement system using BIS for over 65,000 Special Education children each year. Tracking includes all dates of required tests, placement for enrollment into any (650+) Chicago Public Schools and maintenance of required history data.

Create online programs for the entry of approximately 600,000 transportation requests per year for the students attending specific school. Edits included calculation of mileage, check for proper race, grade in school and options program, Proper transportation coding used, etc.

Provided Space Utilization tracking for how schools utilize the space, by room, within all 650+ schools.

Create and maintain tracking programs for athletic participation of 120,000 students.

Maintain programs that allow schools to enter and validate Monthly Summary information of Students.

Maintain programs that allow school to enter racial / ethnicity statistics by school.

Automate the sending of files that are used to collect TANF money

Created and provided support for Legacy Financial system, giving 650+ schools the ability to create requisitions to over 48,000 vendors. GUI front-end for all legacy financial programs in MAPPER to interfaced with Oracle. Systems provide receipt of merchandise, student stipends, and payouts.

Create programs that allowed schools to enter/update $5.3 Billion budget.

Create Interface between Kronos and MAPPER. Automated the download/uploaded information from/to Payroll

Added functionality and provided technical support for Comprehensive Student Information Systems for an overall Student Population of 434,000 Active student and 1.5 million inactive students.

Mainframe Peak Load (3 months per year) 2,000 concurrent MAPPER users with an average response time < 5 seconds.

Mainframe Normal load (9 months per year) 1,400 concurrent MAPPER users with an average response time < 2 seconds

Floral Network Inc., Downers Grove, IL 01/1986 – 05/1989

Database Administrator (DBA)

Installed, coordinated and provided technical support of MAPPER for the Mercury 2000 Inventory Control Project (Approx. inventory of over 400,000 individual pieces of computer equipment)

Changed storage method of calls statistics and created alternate indexing (MAPPER), was able to get same response of lookup in about 10 – 20 seconds – Previous response 25 – 45 minutes.

Automation of various departments, including Member Service, Customer Service and many customer service surveys and telemarketing campaigns to approx. 48,000 florists n US

Database Administrator (DBA) / Performance Tuning of software

Prior to Internet

oAutomated of Flowers After Hours (Online Order Entry / Data Collection)

oAutomated of 1-800-800-ROSE (Online Order Entry / Data Collection / Processing of Credit Cards / Picking filling Florists / Sending orders out automatically)

Analyze, design, program, test, and implementation of Web system using Cool-ICE that would allow internet users to Order Floral arrangements. Program completely table driven to update system daily or as required

KAUFMAN CONSULTING GROUP, Madison, WI 02/1983 – 12/1985

MAPPER/BIS Technical Support

MAPPER Coordination

MAPPER Technical Support

Writing of various runs for Material management System

Flexan Corporation - Consultant 10-2018 – 5-2019

Modify Business Object reports for Packing Slips, Invoicing, and Certificate of Compliance in IQMS.

Create new Business Object reports for the running of Day to Day operations

Solicit Business Rules for reports from various sources. Existing SQL, Interviewing of IQMS Users, Personnel Experience.

NABP – National Association of Board Pharmacists 03-2017 – 8-31-2018

Use JIRA as tool report status of projects – Projects also assign to me through JIRA

Creating reports using SSRS & create T-SQL using SSMS for the reports

Produce all Stored Procedures that are needed for SSRS

Create SSIS packages that will call SSRS to produce PDF and then email PDF and update database

oNext step is the integrating of placing the report on Amazon S3 and updating database accordingly

Use SSIS to Extract Data from Oracle, Transform the data into JPG files and then Load to S3.

Using DTS to import Data

Performance tuning of SQL scripts

Creating SQL utilities as needed

AFX Lighting - SSRS Developer / Report Writer 06-2016 – 10-2016

Produce approx. 50 Customer Service/Sales/Warehouse custom reports using SSRS and SSMS/T-SQL/Stored Procedures

Convert Crystal Reports into SSRS reports

Write all SQL to pull data for newly created reports.

Data Analysis to determine location of required data to fulfill reports

Create Dashboard to show sales / commissions

The Room Place -SSRS Developer Report Writer 03-2016 – 05-2016

Produce approx. 20 Customer Service/Merchandising/Financial reports that were requires prior to going live with a new Point of Sales system

Write all SQL to pull all data for newly created reports. Used SSMS to create SQL code and stored Procedures. Also responsible for indexing tables as needed.

Data Analysis to determine location of required data to fulfill reports

Performance tuning of SQL scripts

City Colleges of Chicago Senior SQL Database Developer / Analyst / Report Writer 09-2015 – 02-2016

Converting/Automating state compliance reports from SQRs to T-SQL

Create required stored procedures and functions

Analysis and Document of existing processes to create reports

Backup and Restore database as needed

INTREN – Union, IL - Report Analyst 07-2014 - 08-2014

Develop and Implement Stored Procedures, Crystal Reports and SQL Server reports using SSRS

American Society of Anesthesiologist - Senior SQL Developer/Business Analyst - 11-2013 – 08-2014

Data Conversion from Microsoft CRM to Personify 360 CRM

Create T-SQL scripts, functions, stored procedures and indexing of tables

Create SSIS Script to execute / log all sql scripts that were needed for data conversion process.

Rewrite existing scripts to use table processing instead of cursors. Process went from 3 hours to 45 seconds. Another process went from 25 minutes to 15 seconds

Backup and Restore Database as needed (DBA)

Wisconsin Employers Trust Fund - 09-2013 – 09-2014

Business Analyst/SQL Programmer / SSRS Developer / Report Writer

Document Business Rules through the usage of group and individual interviews.

Also some business rules had to be documented by analyzing the data. This was done because

in many cases the business rules that the user supplied were incorrect.

Create custom T-SQL scripts, functions, stored procedures and indexing of tables to support the

documented business rules

Importing of MS-ACCESS tables using SSIS

Create Relationships between various tables in MS-ACCESS

Create reports using SSRS

Work with SSIS in the importing of over 700 DB2 tables.

EDP Limited, Skokie, IL 03/1980 – 01/1983

COBOL Programmer/Analyst

EDUCATION

Oakton Community College Des Plaines, Illinois 9-1979 – 6-2006 (2.99/4.00)

Major in Computer Programming – Associates degree

DePaul University Chicago, Illinois 1-2007 (4.00/4.00)

Advanced SQL

Northwestern University Evanston, Illinois 3-2009 – 6-2009 (3.00/4.00)

Computer Science

You will notice that many dates overlap. This is because I work multiple contracts at one time

Contact this candidate