Developer Software
Resume:
CHERYL A. BANTZ
*** **** ******, ******** *******, Illinois 60139
Home 630-***-**** Mobile 630-***-**** E-mail: **************@*****.***
Objective Experienced systems programmer/analyst with expertise in Visual Basic,
SQL 2000/2005/2008/2012, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Office, Visual Source Safe, Crystal Reports, Visual Studio, XML, MSMQ, Business Intelligence, Data Warehousing and Sharepoint.
Seeking a SQL developer/SSRS developer position
Professional Experience
May 2015- Software Developer
June 2015 SEKO Logistics/Addison Group, Itasca, Illinois
Consulting work as IT Software Developer
SQL Database developer (T-SQL, tables, views, stored procedures and functions)
Create and maintain SSRS reports and Crystal Reports
May 2012- IT Specialist/Software Developer
February 2015 ComEd/Modis, Oakbrook Terrace, Illinois
Consulting work as IT Software Developer
SQL Database developer (T-SQL, tables, views, stored prodcdures and functions)
Create and maintain SSRS reports, including complex graphs and data grids, for Energy Efficiency Goals Tracking
Support for internal and external clients
SQL ad-hoc queries
Create and maintain 20-30 SSIS packages to import/export data in text, spreadsheet and XML formats
Sharepoint Administration (users and groups)
Create and maintain Sharepoint Sites, Libraries and aspx pages
September 2011- Programmer/Analyst
October 2011 North American Medical Management/Robert Half Technology
Hillside, Illinois
Consulting work converting databases from SQL 2005 to SQL 2008
Generated and ran SQL scripts to create Views, Tables and Stored Procedures on 12 databases
Database Auditing – created spread sheet that indicates SQL Objects (Views, Stored Procedures and Tables)
Trouble-shooting on new/updated Crystal Reports, upload reports to Report Management System
Cheryl A. Bantz Resume
Page 2
September 2010- Programmer/Analyst
July 2011 Chicago Tribune, Chicago, Illinois
SSRS Report Engineer
Liaison between product managers and developers
Worked with DBAs for data source retrievals
Imported data from data warehouses and SQL archive databases for approximately 20 SSIS packages to be used for SSRS reports
Worked in war room on AX/MDX reporting with senior level project managers
Member of Enterprise Reporting Team:
Project planning
Data requirements
Technical specification documentation
Time lines
February 2010- Programmer/Analyst
September 2010 Sagence Group, Chicago, Illinois
Consulting work writing reports in SSRS – approximately 130 were needed
Project leader with one assistant
Developed a work environment in SSRS to connect to necessary data sources and created templates for future reports
Mapped data from existing IBM, AS400 and JDE data sources to SQL and Great Plains data sources
May 2007- Programmer/Analyst
March 2009 Labelmaster/American Labelmark Co., Chicago, Illinois
Maintained VB6 on-line desktop applications
Worked with full project life cycles including analysis, design, programming specifications, coding, testing, installation and user training
Developed and maintained reports in SQL Server 2005 Reporting Services (SSRS) – including orders, purchasing, inventory, picking, packing, shipping and sales reports
Developed and maintained B2B Ariba accounts; SQL jobs and stored procedures; warehouse metering system
Created and maintained reports and user/group security in Great Plains Accounting System
Designed and conducted user training for all aspects of order entry, picking, packing, shipping and data maintenance
Supported internal clients by troubleshooting and repairing problems with desktop applications, reports and data and multiple hardware issues
Designed and maintained SQL databases and created and developed new applications in ASP.Net and VB.Net
Cheryl A. Bantz Resume
Page 3
1999-2007 Application Developer/Systems Analyst/Development Coordinator
Plantware, Inc., Batavia, Illinois
Designed, developed and tested software packages in Visual Basic 6/MS SQL Server including purchasing, receiving, inventory, production scheduling, customer orders, picking, shipping, customer maintenance, purchaser maintenance and item maintenance
Acted as lead programmer and mentor for two other developers
Created and maintained data warehousing applications and reporting systems in Crystal Reports
Administered and maintained client databases in SQL and installed client site upgrades
Coordinated and implemented database structure software upgrades and other projects
Supported external clients by troubleshooting help desk issues with desktop applications, reports and data
1993-1999 Senior Programmer/Systems Analyst
Syngenta Seeds, Inc. (formerly Novartis Seeds), Downers Grove, Illinois
Project leader in converging a sister company into existing company
Project leader in converting order numbers from 8 to 10 digits which involved approximately 25 files and over 200 programs
ABAP/4 team member in complete company conversion to SAP
Lead team member in creating front-end sales force automation system in Centurion/SQL Base and back-end sales force automation system on HP in COBOL and trained sales staff in its use
Lead team member in maintaining on-line inventory system in Turbo Image, View 3000, including purchasing, receiving, order allocation, packing, picking and shipping, and documentation on new and existing systems and job posting system in Lotus Notes Application Development
References Available Upon Request
Contact this candidate