Power Bi Microsoft
Resume:
Joeseph Mezzo
https://www.linkedin.com/in/joemezzojr/
Sr SharePoint Developer
ad5r89@r.postjobfree.com
SharePoint-PowerApps-Power Bi - Integrator
Detail and results oriented IT professional with extensive experience identifying business intelligence opportunities. Have a passion for synthesizing complex user requirements and translating them to value-added solutions. Industry Background= Financial Services, Pharmaceutical, Education, State and Federal Government.
Core Competencies
●Tableau SME
●Robocopy
●REST API
●SQL (MS SQL, Oracle)
●SharePoint O365
●PowerShell
●Power BI
●Power Apps, Power Automate
●JQuery, JavaScript, VBA
PROFESSIONAL EXPERIENCE
U.S. Department of Commerce- Remote 4/2023 – Current - Remote
SharePoint SME
Develop MS Power Automate Workflows and Forms to improve SharePoint applications. Integrated multiple data feeds to update each other. Created workflows using Microsoft Power Automate.
Milton Hershey Schools - https://www.mhskids.org/ – Human Resources
Tableau SME & Microsoft Power BI Integrator 1/2022 - 4/2023- Remote
As the Tableau SME at Milton Hershey Schools, Developed Dash Boards highlighting staff retention, Demographics, Scores by class. Fixed defects on existing Tableau dashboards and reports. Created complex SQL queries and stored procedures. Conducted Tableau server and reports tuning to optimize response time. Translated business requirements into data warehouse processes and reports.
DEUTSCHE Bank, NY Offices – (Telecommute - Consultant)
Tableau SME 10/2020 - 1/2021- Remote
Testing if Microsoft Power BI can simulate SharePoint.
Create Tableau Dashboards that show the consolidated Risk Models across 1600 risk areas of the bank. Model risk is a type of risk that occurs when a financial model is used to measure quantitative information such as a firm's market risks or value transactions, and the model fails or performs inadequately and leads to adverse outcomes for the firm. Created a what if Tableau reports with multiple filters and parameters. Compared the Visuals to Microsoft Power BI.
WELLS FARGO, Charlotte, NC (Telecommute - Consultant)
SharePoint SME 9/2019 –10/2020 - Remote
Developed custom windows applications to generate XML from the InfoPath forms.
Developed custom dynamic executive-level dashboards.
Implemented JQUERY scripts to enhance page and list formatting with tabs.
Designed web services using WCF to access business data. Enforced site level security.
Migrated all company data from local file shares into SharePoint & OneDrive using Sharegate.
USAA- San Antonio, Texas (Telecommute - Consultant)
SharePoint SME 5/2019 – 9/2019- Remote
Implemented time saving SharePoint workflows. Added US Government regulatory news feed web parts to a USAA SharePoint collection. Enhanced web pages using Bootstrap, Rest, jQuery, CS, JS, Fonts).
WELLS FARGO, Charlotte, NC (Telecommute - Consultant)
SharePoint Developer 6/2018 – 5/2019- Remote
Developed custom windows applications to generate XML from the InfoPath forms.
Implemented JQUERY scripts to enhance page and list formatting with tabs.
Designed web services using WCF to access business data. Enforced site level security.
Migrated all company data from local file shares into SharePoint & OneDrive using Sharegate.
Wells FARGO, Charlotte, NC (Telecommute - Consultant)
SharePoint & Tableau SME 3/2016 – 5/2018- Remote
Redesigning IT software approval process by work flowing approval forms. Improved security through the development of Tableau and SharePoint visuals with custom drill downs. Creating complex InfoPath Forms-Designer Workflow.
JOHNSON & JOHNSON -HeadQuarters, New Brunswick, NJ – Full Time Onsite Consultant
Tableau SME 2/2015 – 3/2016 - Remote
Queries unstructured data and discovered pharma vendor transaction patterns. Examined financial data and filter for targeted information using traditional SQL Server 2012 and Oracle 11.2. Created advanced visuals deployed via SharePoint Used Tableau for predictive analytics for Pharma sales. Developed an Outlook VBA application. It Parses Outlook email messages, extracts key Email Body information. The application then posts the results to a SharePoint table for Accounts Payable processing. Integrated Oracle with SharePoint, MS Access, and Excel via ODBC.
JOHNSON & JOHNSON HeadQuarters -Legal Dept, New Jersey Full Time Onsite Consultant
SharePoint Content Manager - 4/2014 - 2/2015- Remote
SharePoint subject matter expert that created a web site to track litigation across J&J LOB. Created KPIs to monitor systems projects. Trained users to optimize SharePoint. Delivered 3rd tier support for SharePoint solutions.
US ARMY, Fort Monmouth, NJ
SharePoint Collaboration Manager - Full Time Onsite Consultant 6/2012 – 3/2014- Remote
Spearheaded the worldwide deployment of SharePoint for the US Army to over 250 new locations. Responsible for development, workflow coding, and governance documents. Developed site content and implemented structured updates. Created and delivered training for end users and administered the team site. Created progress presentations.
●Ensured the successful first deployment of SharePoint software worldwide by creating an efficient operational infrastructure to launch 250 key web sites in the first six months.
●Improved security providing a collaboration document for developers and end users that outlines how to protect and restrict access to national security information.
MORGAN STANLEY SMITH BARNEY, New York, NY- Full Time Onsite Consultant
IT Reporting Tools Developer - 3/2011 – 6/2012- Remote
●Integrated data feeds from multiple sources, enhanced via VBA, and developed SharePoint workflows to automate the management approval process.
●Automated invoice processing for IT using SharePoint designer workflows, the creation of business management reports that route information from Business Objects (SQL Databases) to SharePoint.
BANK OF AMERICA, New York, NY
Global Operations & Systems Specialist - Full Time Onsite Employee Onsite Employee (6/ 2009 – 3/2011)
) SharePoint site manager- Define metrics and communicate KPI. Facilitated gathering business requirements. Prepared weekly and monthly IT status reports.
●Managed technology investments and budget for Wealth Management.
●Implement Clarity Project Tracking. Created automated extraction reports from SQL databases for distribution.
JPMORGAN CHASE - Full Time Onsite Employee Onsite Employee (1972r to 2009)
●Retired Vice President – Multiple revenue generating LOB and IT - Business Intelligence
EDUCATION, Certifications, & AWARDS
●M.B.A., Information Technology, Pace University, New York City, NY 6/1977
●B.S. Business School - Seton Hall University, South Orange, NJ 1/1972
●Rutgers University - Project Management Certification 9/2020
●CompTIA A+ Certification 233174224 4/2014
●Veteran – US Navy - Meritorious Service Medal 7/1978
Contact this candidate