Michael A. JanFrancisco

*** ***** **.

BOLLINGBROOK, IL 60490

ad3dz7@r.postjobfree.com

630-***-****

OBJECTIVES

To obtain a position within an organization that values growth, learning, and innovation.

EXPERIENCE

Database Developer 2022 – 2024

Power Distributing – Elmhurst, Illinois

Data Analysis: Utilized SQL for data analysis and extraction to support business decision-making. Proficient in data mining and integrity.

SQL: Proficient in writing complex SQL queries, stored procedures, and triggers.

SSRS: Design, Development, Deployment.

Database Management: Experience with managing and optimizing databases to enhance efficiency and optimal storage.

Data Security: Implemented data security measures and ensured compliance with data privacy regulations.

Custom Report Design: including T-SQL report design; dashboards; creation of reporting tools for management and stakeholders.

EDI: Management and Implementation

Project Management: Collaborated with cross-functional teams to gather and understand data requirements for various projects, ensuring timeliness of outcomes.

MMIS/WMS Administrator, IT Specialist 2014 – 2022

Network Global Logistics/ Impact Fulfillment Services – New Lennox, Illinois

T-SQL programming, data mining, analytics.

Maintain vendors, customers, item masters, and storage in WMS database.

Program BI dashboards and report via Periscope / SSRS

Maintain and service 40+ computers in an office & warehouse environment.

Maintain and service multiple servers on location (ADC, SQL & File Server).

Maintain and service security system and equipment for the warehouse.

Support multiple warehouse management systems in multiple warehouse locations.

Maintain RF units, barcode scanners & printers in multiple warehouse locations.

Plan and implement Electronic Data Interchange (EDI) projects/solutions for customers.

Provide database support, reports and data analysis for management and customers.

Provide weekly implementation project reports for management and customers.

Provide automated reports and data scheduled through Dell’s Atomsphere software.

System Administrator 2013 – 2014

Euclid Beverage – North Aurora, Illinois

Data mining, reporting, and data integrity using SQL server

Analyst data for Improvement and streamlining system to optimize processes

Active Directory – manage groups, users, and computers.

Manage Business Intelligence software and produce new reports.

Create Desktop, Laptop, Service Terminals and Servers.

Diagnose system hardware and software problems and repair them.

Provide remote and phone support for customers and business clients.

Administer and manage Logistics software.

Data Analyst/SQL Jr Temporary Assignment 2013 – 2013

East Aurora School District - Aurora, Illinois

Design and Build Custom Computers to customer/store specifications.

Create Desktop, Laptop, Service Terminals and Servers.

Provide On-Site repair service to customers and businesses.

Provide phone support for customers and businesses.

Diagnose system hardware and software problems and repair them.

Provide system hardware upgrades and maintenance to customer/business computers.

Maintain company data server, backup company files and configure internal network.

Dell Technician/Training 2006 – 2012

Etelecare - Phoenix, Arizona

Experience with enterprise integration tools

Training and/or teaching technicians

Strong oral and written communication

Ability to train others using a variety of adult learning methodologies

Ability to design professional training materials

Quick to embrace new technologies

Excellent analysis skills and the ability to develop processes and methodologies

Strong understanding of technologies such as SQL, XML

Senior Technician 2002 – 2006

Dream Games - Phoenix, Arizona

Install, configure, maintain server/POS based games.

Maintained company e-mail, networks, and Active Directory.

Replace existing hardware with upgrades and software installation.

Network renovated and new additions to existing buildings.

Install VOIP devices to existing services.

Install ATM/debit devices in retail stores and upgrade software.

Data Input Manager 1999 - 2002

Sunterra Resorts - Scottsdale, Arizona

Managed a small team to input sales data of resort customers.

Data entry

Reporting

Schedule Team hours and coverage

EDUCATION

Dobson High 1989 -- 1992

Mesa Community College 1993 – 1994

Tech Skills (Technical Certifications) 2008 -- 2010

(SQL, A+, MCSE)

Software

OSX 10+

MS Office Suite

MS Win10/Vista/XP+

MS Server 03/10

MS SQL Database

Crystal Reports

Boomi AtomSphere –

EDI

MMIS / WMS

SSRS Reporting

Hardware

System Maintenance

Hardware Diagnosis

Hardware Installation

Networking

Cat5E Cabling

File Sharing

Printer Sharing

Network Installation

Domain Configuration

Support

Troubleshooting

Customer Support

RDP Support

Contact this candidate