SUMMARY

A Highly motivated, skilled, Senior Developer with 30 years' experience. The last 10 of which have been spent in the web and SQL arena. 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 8080,8086,80286,80386,80486, Pentium , Honeywell Level 66 and DPS8, Xerox Mainframes, Dell HP Servers

TECHNICAL

Programming Languages: T-SQL, PL/SQL, HTML, CSS, MAPPER/BIS/CoolICE, Javascript, C , VB

Databases: SQL Server 2005, 2008, 2012, My SQL, Oracle, MAPPER, Business Information Server, Access, DBase, Paradox, FoxPro

Software: SSIS/SSDT, SSRS, TFS, SSMS, Business Objects, Visual Studio, Microsoft Professional Office Suite, FrontPage, Expressions, Visio, Project, MAPPER/BIS, COOLICE, COBOL, RM-COBOL, Micro-Focus COBOL

Operating Systems: Windows XP, Windows-7, Windows-8, W2K3, W2K8, Unisys Mainframe

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst/SQL Programmer

Document Business Rules through the usage of group and individual interviews. Also some business rules have been documented by the use of analyzing the data. In many cases the business rules that the user supplied were not correct. This was verified by analyzing the data.

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

Create reports using SSRS

I would rather see users pull predefined reports than have the users download the data. If they download the data, they can then create their own reports that would allow them to stretch the truth of the data.

Work with SSIS in the importing of over 700 files.

Create SQL to support SSIS

Use O 1 DBC as data source

AAA Motor Club 10-2008 Present Telecommute/3/2014

MAPPER Consultant

MAPPER Technical Support

General Programming Support

Confidential

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

• Building Web Application HTML, CSS, AJAX, XML, BIS, MySQL that will allow users to retrieve various information about their environment from the cloud
• Converting Business Object XI into SSRS Reports Approximately 20 reports
• Create SQL stored procedures using SSMS for SSRS
• Define ODBC Connections to various databases
• Working in Visual Studio to create about 40 SSRS reports from scratch for Dashboard
• Building SSIS packages for routine tasks
• Building Web Application HTML, CSS, AJAX, XML, BIS, MySQL that will allow users to retrieve various information about their environment from the cloud
• Converting Legacy data from Flat files into relational tables using T-SQL SSIS Used ODBC as source connections
• 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
• Analyze, design, program, test, and implementation of BIS/Cool-ICE with JavaScript/HTML/CSS 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 via the WEB. HTML/CSS.
• Provided ability for teachers to lookup where they are in the Teacher re-certification process using Business Information Server and the web. HTML
• 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
• Create Monitoring dashboard with CoolICE to make sure that all programs are working properly
• 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.

Confidential

DataBase Administror 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
• Automated of Flowers After Hours Online Order Entry / Data Collection
• Automated 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

Confidential

MAPPER/BIS Technical Support

• MAPPER Coordination
• MAPPER Technical Support
• Writing of various runs for Material management System