Michael Chaffee

Senior Business Analyst

Orland Hills, IL 60477

adtw2g@r.postjobfree.com

+1-708-***-****

I seek to utilize my work experience with multiplatform databases, MS SQL, iSeries, Salesforce, SDLC, and AGILE methodologies to apply my technical skillset and interpersonal capabilities to further an organization's success in the marketplace. Serve as a mentor to other team members utilizing my team builder and management skills. Work Experience:

Senior Business Analyst

National Van Lines Inc.

June 2015 to Present

Present

• Business Analysis and system design/architecture.

• Automation and integration of multiplatform systems.

• Designed and developed data integration between MS SQL, iSeries, and Salesforce.

• Design MS SQL databases.

• Created various MS SQL triggers, functions, and stored procedures to automate the process and system integrations using T-SQL.

• Design and develop various SSRS reports. Using VS 2019.

• Design and create various SSIS packages. Using VS 2019.

• Designed and developed a custom mail merge system utilizing MS SQL, iSeries, and

.net framework.

• Designed and created many APIs. using .net and PHP.

• Design programs and implement a Lead processor using PHP.

• Design a new dashboard portal and implement a new .net framework.

• Designed and developed web services and APIs using JSON to interact with other systems.

• Designed and created system automation across multiple platforms.

• Designed and created technical training for other team members.

• Mentoring and training team members on new technology and best practices.

• Created and implemented a disaster recovery plan. Director IT Solutions

Miller and Company

February 2015 to May 2015

Developed and implemented a project plan for Chemalloy merges into Miller and Company.

• Created and implemented a disaster recovery plan.

• Created a dashboard portal.

• Data profiling.

• Renegotiated contracts with vendors saving the company thousands of dollars.

• Automated a lengthy month-end process.

• Prepared and budgeted for projects.

• Led and participated in management/project meetings.

• Managed a corporate IT Department.

Team Leader/System Analyst

Financial Management Systems.

March 2011 to February 2015

• Automation and integration of multiplatform MS SQL and iSeries.

• Created APIs for the pay.gov credit card authorization system.

• Created many MS SSRS reports.

• Created many MS SSIS packages for systems integrations and automation.

• Developed iSeries and windows projects with DB400 stored procedures and SQLRPGLE to render data sets and update iSeries files.

• Built web applications using C#; Client Server applications using Visual Studio and JAVA.

• Maintained legacy software for iSeries and MS SQL 2005, 2008, and 2012.

• Performed internal auditing to ensure data integrity and security.

• Data profiling SQL2008.

• Mentored and trained team members on new technology and best practices. Systems Analyst - iSeries

Dental Network

March 2010 to March 2011

• Developed automated dental and oral surgery benefits and claims systems using RPGLE, SQLRPGLE, and CLLE.

• Performed audits to ensure incoming and outgoing data integrity, reliability and security, and data profiling

• Created integrations of systems and data across multiple platforms using AGILE methodology

eCommerce Project Manager/Team Leader/Technical Analyst Meijer Corp

January 2010 to March 2010

• Working with the business units to gather requirements, meet with Functional Managers and Functional Analysts to recommend system solutions; develop cost analyses, design considerations, and implementation timelines.

• Created system design, database design, data flow, and system flow.

• Prepared use cases, development, testing, and implementations.

• Provided technical assistance, development, support, and monitoring of existing applications. Systems included DB2, Teradata 12.0, Sybase, MS SQL2008, VS.2008 Senior Analyst/Project manager/Consultant

KTS - Chicago, IL

March 2007 to April 2009

• Worked on web-based systems and client-server systems via SDLC and AGILE Methodologies

• Perform IT audits to assess data integrity, reliability, security, and risks.

• MS SQL SSRS, SSIS, Triggers, T-SQL.

• Met with users to define requirements, document system flow, and use cases, estimated resources, and time requirements

• Technologies included iSeries RPG400, SQLRPGLE, Websphere, MS SQL2003, MS SQL2005, MS SQL2008, Data profiling, DB2, Teradata, Sybase, SQL Report Server, VB.NET, Visual Studio, ASP and ADO.NET, ORACLE Database 11g Enterprise Server, Navicat for Oracle Enterprise V9 1.2, Oracle Open Office 9.2, DBA Ease Control 4.5

.

Lead the Intranet committee

Draper and Kramer Inc

May 2005 to October 2008

visit various business locations to define business processes and create automation solutions.

• Prepare project documentation detailing the process; set up use cases, system diagrams, data flow diagrams, test cases, and benchmarks.

• Design, program and implement a corporate intranet site, which includes a secured area for an interactive Sales Commission system, Loan Inquiry, and online security requests services. Monitored intranet site using .NET framework.

• Implemented a web-based mortgage software system built over MS SQL and provided automated solutions to fit business needs using SDLC Methodology.

• Performed IT audit to ensure data integrity, reliability, and security, technology risks

• Utilize my iSeries/AS400 operation and programming expertise to access the historic data.

• Set up a TCP/IP connection to the AS400 to be used by ADO to retrieve data from the AS/400.

• Created an automated process to load loans from IDHA into the servicing MS SQL database.

• Performed MS SQL data profiling to insure data integrity.

• Created an automated solution for loans to be fed electronically to an outside law firm.

• Designed and developed various system automation and integrations using T-SQL.

• Mentored and trained team members on new technology and best practices.

• Maintained corporate website, wholesale website, and retail website.

• Systems used: Harland Financial Services software, Mortgage Ware, Interlink Mortgage Servicing. Microsoft SQL, Visual Studio (VB and C#). R&D Manager/Team Leader

LeasePlan USA

September 1997 to March 2005

• Business analysis; Conducted meetings to gather requirements

• Designed systems to meet requirements, set up test cases, and research and implemented technology

• Managed a team of system analysts, responsible for researching the latest technology and finding the best technical solution for business needs.

• Using SDLC Methodology, Designed, developed, and implemented e-business solutions.

• Performed internal audit to ensure data integrity, reliability, and security.

• Assessed technology risks.

• Worked as part of a team to create data modeling, data mining, and data warehousing using DataStage to extract, transform and load data between AS400 and MS SQL databases.

• Created data warehousing tables to allow faster access for e-Commerce applications.

• E-Commerce included: NetFleet.com, ePlan.com, Client Approval of Repair, MVR, Shop Entry of Repair, Incident Management, and Document Merge.

• Created fleet management system including car rental bidding, insurance claims, and claims rental assignments.

• Technology: JAVA, WebSphere, J2EE, JavaBean, XML, ASP, ADO, VBScript, JavaScript, MTS, IIS4.0, TCP/IP, FTP, Photshop5.5, Paint shop pro6.0, Fireworks4.0, Microsoft Image composer, AS400 and Microsoft SQL7.0, RPGLE, SQLRPGLE, CLLE, DataStage.

• Client Server Included: Automated files download, Insurance Claim System, Automated Billing system, and Insurance coverage verification. Using Visual Basic 5.0 and 6.0, ADO, ODBC, TCP/IP, FTP, AS400, Microsoft SQL7.0, and Microsoft Access.

• Configured host server and TCP/IP configurations on an iSeries/AS400.

• Designed and developed an automated system using RJS to convert a document into a PDF file and email it as an attachment.

• Designed and developed server programs using RPGLE, CLLE, AS400 and SQL stored procedures.

Senior System Engineer/Team Leader

Uniform to You, Inc

August 1996 to September 1997

• Designed, Programmed, and implemented client-server order entry system and AS400 interface.

• Designed and programmed an inventory allocation system across various warehouses throughout the nation to fill customers’ orders, and ensure inventory accuracy.

• Developed the client-server using Microsoft SQL 6.5 and Delphi programming language.

• Designed and developed various system automation and integrations. Team Leader/Senior PA

WMS Industries - Williams Electronics Games, Inc

June 1992 to August 1996

Business analysis, requirements gathering, system design, testing, and implementation.

• Programmed and implemented client-server barcode shipping, warehouse transfer, and pack slip system using Microsoft Windows/NT, Microsoft SQL, and Visual Basic.

• Designed, created, and implemented a finished goods barcode system utilizing TL Ashford,

• Created Barcode KANBAN system, Barcode Manufacturing Board Testing System, Automated production reporting system, Inventory control system,

• AS400 system administration and performance tuning.

• Designed and developed various system automation and integrations.

• Mentored and trained team members on new technology and best practices. Team leader/Senior PA

Royal Crown Bottling Company

May 1989 to June 1992

• Analyzed various corporation divisions’ software needs, architecting a solution used by several divisions.

• Designed, created, implemented, and supported Dispatch System, Sales Analysis System, Order Entry and billing system, Bill of Material System, Purchase Order System, and Corporate Consolidated GL system.

• System21/ERP

• Configured an AS/400 B70.

• Converted Applications from S38 to AS/400.

• Set up journaling on iSeries/AS400 then use the journals to determine areas of failure in the software system.

• Managed 16 IT, team members.

Project Leader/Senior PA

Chicago Metallic Corporation

November 1987 to May 1989

Designed, Created, Implemented, and supported Auto Billing System based on manufacturing stages. Worked with CA-PRMS AP system. Senior PA

Royal Crown Bottling Company

June 1984 to November 1987

• Analyzed various corporation divisions’ software needs, architecting a solution used by several divisions.

• Designed, created, implemented, and supported Dispatch System, Sales Analysis System, Order Entry and billing system, Bill of Material System, Purchase Order System, and Corporate Consolidated GL system.

Education

Associate degree in Computer Science.

Microsoft SQL Developer

Microsoft Database Administrator

Salesforce.

Working on getting the Salesforce admin certification. Additional Information

Expertise: Automation and integration of multiplatform: MSSQL, iSeries, Salesforce. SQL Servers (SSRS, SSIS, Triggers, T-SQL)., SDLC Methodology, AGILE Methodology, Project Management, Business Analyst, IT Auditing, Database Management, and Design, Manufacturing, Distribution, Accounting, System and Data Integration, Data profiling, Automation, Development, testing, and implementation. iSeries (AS/400), Salesforce, PHP, and .NET platforms: RPGLE, RPG-FREE, SQLRPGLE, CLLE, DB400 SQL, QMQRY, DBU, MS SQL2019 and earlier versions, Data profiling, Visual Studio 2019 and earlier versions, Salesforce Developer, Salesforce Administrator, Webservice, API, JSON, PHP, JAVA, WebSphere, J2EE, JavaBean, ASP.NET, VB.NET, C#.NET, ADO.NET, ORACLE Database 11g Enterprise Server, Navi cat for Oracle Enterprise V9 1.2, Oracle Open Office 9.2, DBA Ease Control 4.5, ODBC, VBSCRIPT, JavaScript, RSP, HTML, XML, IIS4.0, MTS, NCR Teradata, Sybase, DB2, DB400, System21 ERP, MICROSOFT FRONT PAGE 2000, PHOTOSHOP 5.5, FIREWORKS 3.0, PAINT SHOP PRO 6.0, Microsoft SQL Server, EDI, Rational Rose Clear Case, MS Project, VISIO, Showcase Vista, Seagate Crystal Report, Data Stage, Remedy Change Management, Jira, Programmer Plus Case tool, TL Ashford, Aldon LMI, Aldon LME, Aldon CM, Hawkeye, and Robot.

Contact this candidate