JOE MEZZO Manchester, NJ ● 732-***-****
**********@*****.***
Work Samples here
Data Analyst
Experienced Data Analyst with a strong track record of uncovering business intelligence opportunities, refining strategic decision-making, and driving performance optimization across diverse functions. Skilled in SQL, Excel, SharePoint, Tableau, and Power BI, with deep expertise in data cleaning, statistical analysis, and reporting. Known for translating complex data into clear, actionable insights that support informed business decisions and measurable outcomes. Core Competencies
Data Visualization: Power BI, Tableau, Power Apps
Automation & Workflow: Power Automate, MS Office
(with VBA), Excel (Lookup, PivotTables)
Database & Integration: SharePoint (SP)
Development: REST, MS Access to SharePoint List
Productivity Tools: Microsoft Office Suite
Experience
Job Title: Data Analyst & Developer for SharePoint, Power Apps, Power BI, Power Automate Client: U.S. Veterans Administration 6/9/2025 - 7/2/2025 Vendor: PFS
Duties: A new Intake process was created to improved productivity for the VA staff. It processed internal and external inquires in record time. Cost saving were achieved by using existing license Microsoft software. Products used: SharePoint, Power Apps, Power BI and Power Automate for workflow processing.
Job Title: SharePoint SME
Client: U.S. Department of Commerce 9/3/2024 - 5/3/2025 Vendor: ICS-Federal
Duties: Automated the FHFA Human Resources awards process via a SharePoint Online application. Enhanced the site using MS Power Automate and Microsoft Forms.
Job Title: Tableau SME & Microsoft Power BI Integrator Client: Milton Hershey Schools - Human Resources 6/3/2023 - 9/3/2024 Vendor: Belmero
Duties: Provided live reports showing Human Resources the tool to use to supply the US government with proof meeting required personnel quotas. In addition, filtered Tableau reports deployed on their intranet. Used Power Automate, Power Forms, and SQL that delivered ongoing live reports for clear insight on their staffing needs. Job Title: Tableau SME
Client: DEUTSCHE Bank, NY Offices 6/3/2022 - 6/3/2023 Vendor: Ecstech
Duties: Create Tableau Dashboards derived from complex formulas to deploy bank wide Risk Models. Timely and accurate delivery to DEUTSCHE Bank mitigated impending risks and Government fines. Job Title: SharePoint Designer and Site migration Manager Client: Wells Fargo, Charlotte, NC (Telecommute - Consultant) 3/3/2021 - 6/3/2022 Vendor: Kellton
Duties: Develop custom SharePoint apps and forms using InfoPath. Tie SharePoint permissions to active directory (Azure). Developed a process to easily modify url links to multiple site collection Designed web services using WCF to access Data Marts & Data Verse environments. Migrated all company data from local file shares into SharePoint & OneDrive using Sharegate. Title: SharePoint SME
Client: USAA - San Antonio, Texas 12/3/2019 - 3/3/2021 Duties: Implemented time saving SharePoint workflows. Added US Government regulatory RSS news feeds. Enhanced web pages using Bootstrap, Rest, and jQuery
Joe Mezzo - Resume Continued
Title: SharePoint Developer
Client: WELLS FARGO, Charlotte, NC (Telecommute – Consultant) 9/3/2018 - 12/3/2019 Duties: Developed custom windows applications to generate XML from the InfoPath forms. Implemented JQUERY scripts to enhance page and list formatting with tabs
Title SharePoint & Tableau SME
Client: Wells FARGO, Charlotte, NC Remote – Consultant 6/3/2017 - 9/3/2018 Duties: Redesigned Bank wide IT software approval process by work flowing approval forms and creating times reminders. Improved security through the development of Tableau and SharePoint visuals with custom drill downs. Creating complex InfoPath Forms-Designer Workflow.
Title: Tableau SME
Client: JOHNSON & JOHNSON -Headquarters - Onsite Consultant 1/5/2016 - 4/5/2017 Duties: Aligned unstructured SAP data. Automated posting of SAP information on Tableau for predictive analytics on Pharma sales. Eliminated manual processing of faxes (100/day) that showed. Past due vendor invoices and eliminated financial penalties. Redirected past due vendor invoices to a SharePoint server where Accounts Payable staff were able to handle timely vendor payments.
Title: SharePoint Content Manager
Client: JOHNSON & JOHNSON(J&J) -Legal Dept - Onsite Consultant 10/5/2014 - 1/5/2016 Created SharePoint Subsites that communicate litigation across (Consumer products, Pharmaceuticals, and medical devices. Created KPIs to monitor systems projects. Trained users to optimize SharePoint. Delivered 3rd tier support for SharePoint solutions. Title: SharePoint Collaboration Manager - Full Time Onsite Consultant Client: US ARMY, Fort Monmouth, NJ 10/5/2013 - 10/5/2014 Duties: Spearheaded the worldwide deployment of SharePoint for the US Army. Link to - SharePoint Program Manager Duties - US Army Title: IT Reporting Tools Developer -
Client: MORGAN STANLEY SMITH BARNEY, New York, NY- Full Time Onsite Consultant 2/5/2013 - 10/5/2013 Duties: Integrated data feeds from multiple sources, enhanced via VBA, and developed SharePoint workflows to automate the management approval process. Automated invoice processing using SharePoint designer workflows. Created business management reports that route information from Business Objects (SQL Databases) to SharePoint. Title: Global Operations & Systems Specialist
Client: BANK OF AMERICA, New York, NY 6/5/2012 - 2/5/2013 Duties: SharePoint and Clarity manager. Defined metrics and KPI. Facilitated gathering business requirements. Integrated Pivot tables to SQL data. Automated the distribution of IT status reports. Managed technology investments and budget for Wealth Management. Implement Clarity Project Tracking. Created automated extraction reports from SQL databases for distribution. Title: Vice President
Employer: JPMORGAN CHASE - Full Time Onsite Employee 6/5/1981 - 6/5/2015 Duties: Financial Controller, ATM deployment Project Manager, IT – Tri-State Network & Server Deployment, Cash Management Business Intelligence, Strategic Planning, Deployed – second wave – ATM, More… EDUCATION, Certifications, & AWARDS
● M.B.A. Lubin Business School-Information Technology, Pace University, New York City, NY
● B.S. Stillman Business School - Seton Hall University, South Orange, NJ
● Rutgers University - Project Management Certification
● CompTIA A+ Certification 233174224
● Veteran – US Navy - Meritorious Service Medal -VS71 o DOD – Active Secret and Pubic Clearances
Work Samples
Tableau Sample Report1 - Human Resources
Tableau Sample Report2 - USA Colleges by State / Degree Tableau Sample Report3 - 2016 Presidential Result