Systems Analyst

John Gianatasio, II.

Cape Coral, FL • 239-***-**** • ****.**********.**@*****.*** https://www.linkedin.com/in/johngianatasioii

SUMMARY

IT professional of 12+ years with experience in systems management, project and support leadership.. Brings a background in both industry and consulting roles, effective at managing cross-functional relationships to deliver results against key client initiatives.

SKILLS

Analysis/BI: Power BI, Tableau, SAP Business Objects, Microsoft SQL Server Analysis Services

Databases: SQL Server, SAP BW

Data Interchange Standards: EDI (Electronic Data Interchange), EPCIS (Electronic Product Code Information Services), XML, JSON

Languages: R, Python, SQL, SAS, HTML

Application: Dynamics GP, Dynamics CRM, SAP ECC, SAP Sales Cloud, SAP TPM (Trade Promotion Management), Oracle Sales Cloud, NetSuite ERP

Advanced Analytics: Text Mining, Data Visualization with Python, Advanced Predictive Analytics, IBM Watson Explorer, RStudio

Productivity and Other: MS Office Suite, SharePoint, ITIL Certified, Blue Prism RPA

Security: KnowBe4 Training Implementation, O365 2FA Implementation, Duo Mobile 2FA Implementation, Bitlocker

EDI Translators: Cleo VL Trader, SPS Commerce, CommerceHub, Data Masons

EDUCATION

Northern Illinois University

M.S. Data Analytics, 2020

B.S. Operations and Information Management, 2011

EXPERIENCE

First Nation Group, Business Systems Analyst (Position Eliminated) 2022 - 2023

●Re-designed and improved reporting processes to streamline Analytics for our Pharmaceutical Team including a custom database that pulls data from multiple disparate government data sources to produce market pricing and sales insights to help predict future market share.

●Implemented use of ITIL for Service Management to improve service desk experience for customers and streamline internal operations.

●Managed EDI set-up and on-going monitoring of EDI documents (850, 855, 856, 810) with Trading Partners and Vendors.

●Completed first ever EPCIS roll-out for the organization to both send and receive documents for our Pharmaceutical including document design, testing, and go-live with ERP integration.

●Worked with functional areas of the business to gather requirements for new ERP system implementation.

Honey Can Do International, Systems Analyst (Position Eliminated – Cost Cutting)

2021- 2022

●Led company to 1st ever Cybersecurity Insurance Policy Acceptance in history due to security efforts implemented.

●Implemented Security Improvements:

Rollout of 2-Factor Authentication for both workstations and VPN using Duo Mobile.

Rollout of 2-Factor Authentication for O365.

Rollout of BitLocker across workstations.

●Led KnowBe4 training program implementation across the organization including vulnerability assessment and on-going remediation plan.

●Improved the Cybersecurity Awareness of the organization significantly through on-going remediation.

●Implemented ITIL Incident, Problem, and Change Management for managing the IT Service Desk.

●Performed and improved daily controls procedure to check availability and health of our systems, applications, and networks for all of IT.

●Reverse-engineered and then improved Profitability Dashboards for the Executive Leadership team.

●Project Lead for Robotic Process Automation (RPA) to automate processes for Finance and Customer Service.

●Managed set-up of EDI (850, 846, 855, 856, 810) documents within our environment to process through ERP and WMS.

●Developed SOPs for executing key IT Service Desk activities.

●Implemented and tested the roll-out of new handheld devices to our warehouse fulfillment team.

theITSupportCenter,LLC., Certified Tech Advisor (Contract)

2019

●Supported off-the-shelf applications, including MS Office, SharePoint, Skype, Windows, Adobe, and mobile devices such as the iPhone, Windows Phone, and Androids in order to increase the productivity of Fortune 5000 customers.

●Managed Active Directory Groups and Users to deliver against customer requests.

●Performed troubleshooting and installation of printers, scanners, and handheld devices.

●Developed procedures for executing key support activities.

Northern Illinois University, Associate Director IT (Position Eliminated – ReOrg)

2018

●Implemented the user of data controls at our integration points to eliminate errors and improve quality of our CRM data.

●Performed analysis across data management activities and implemented the use of data management procedural documents to ensure consistency in our data management procedures.

●Managed the CRM team, projects, and support landscape.

●Performed email campaign analyses and made actionable recommendations for improvement.

●Created HTML marketing emails based on requirements from clients.

●Led data management CRM project to successfully be able to manage prospect leads for both undergraduate and graduate pipelines for 1st time in NIU CRM history.

Accenture, Senior Analyst

2017-2018

●Created CRM pre-sales videos for SAP Cloud for Customer (SAP Cloud CRM) key processes.

●Responsible for the operation and evolution of the integrated program management processes and tools and the delivery methodology for global SAP-ECC and BW implementation.

●Created daily program update reports from Microsoft Project and SAP for Senior Program Management Team to check health and status across all projects as part of the Program Management Office.

●Lead for Program Management Office for global SAP S4/HANA implementation for large CPG company.

Nebraska Book Company, Manager, CRM Systems 2016

●Managed Project and Support Landscape for Customer Relationship Management (CRM) software, Oracle Sales Cloud, including digital integration.

●Led rollout of CRM Mobile Technology to the field sales reps, including field training and training material development.

●Launched Oracle Social Network to help streamline communication and improve collaboration across key sales and marketing operations. Created CRM Training Videos for SAP Cloud for Customer (SAP Cloud CRM) key processes.

Kraft Foods, Inc., Associate Analyst Analyst Associate Manager

2011-2015

●Designed, Developed, and Delivered Custom KPI Executive Dashboard to track key initiatives across sales and marketing.

●Managed and led 1st successful Disaster Recovery in company history across for SAP ECC, CRM, and TPM.

●Created and implemented system controls for SAP ERP, TPM, Middleware, CRM, and BW to ensure quality and integrity of system data.

●Managed and implemented the use of ITIL Incident, Problem and Change Management for key data management processes across SAP ERP, CRM, TPM, and BW integration points.

●Led SAP CRM/TPM Upgrade with zero critical defects to successful go-live.

●Project lead for transition from SAP CRM to Salesforce.

●Partnered with vendors as security project lead to implement security model for global financial application.

●Managed direct mail campaigns for the Foodservice Business.

Certifications

Academic Alliance, Data Science and Big Data Analytics v2 – Dell Technologies

License: HQTNHL4ZMEFE1CCF

ITIL Foundation Certificate in IT Service Management – PEOPLECERT

License: GR750065079JG

Contact this candidate