Data Analysis Security
Resume:
Michael A. JanFrancisco
BOLLINGBROOK, IL 60490
********@***.***
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