| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateManchester, NJ PHONE NUMBER AVAILABLEEMAIL AVAILABLEJOE MEZZO LINKEDIN LINK AVAILABLETableau Human Resource ReportTableau USA CollegesTableau-SharePoint-PowerApps-Power Bi - IntegratorDetail and results oriented IT professional with extensive experience identifying business intelligence opportunities. Havea passion for synthesizing complex user requirements and translating them to value-added solutions. IndustryBackground= Financial Services, Pharmaceutical, Education, State and Federal Government.Core CompetenciesTableau SME JQuery, REST APISQL (MS SQL, Oracle) PowerShell Power Apps, Power AutomateSharePoint O365, Sharegate Power BI VBAPROFESSIONAL EXPERIENCERemote Consulting 8 yrs Onsite Employee 1975-2005U.S. Department of Commerce & Federal Housing FHA 10/3/2022-3/4/2024SharePoint SMESharePoint 365, PowerApps, Power-Bi, and Power Automate. Built an Intranet Inquiry system accessible with a smartphone. Added Power Automate create timely notifications. Integrated multiple data feeds with Cascading PowerAppsmenus for easy access.Milton Hershey Schools - Human Resources 10/3/2021-10/3/2022Tableau SME & Microsoft Power BI IntegratorAs 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 storedprocedures. Conducted Tableau server and reports tuning to optimize response time. Translated businessrequirements into data warehouse processes and reports. Used Power Automate, PowerApps and Power BI.DEUTSCHE Bank, NY Offices (Telecommute - Consultant) 10/3/2020-10/3/2021Tableau SME Plus Compared Power Apps vs SPFX RecommendationCreate Tableau Dashboards that consolidated Risk Models across 1600 risk areas of the bank. Created what if Tableaureports with multiple filters and parameters. Compared these Visuals to Microsoft Power BI.WELLS FARGO, Charlotte, NC (Telecommute - Consultant) 10/3/2018-10/3/2020SharePoint SME SharePoint Designer & InfopathDeveloped custom SharePoint apps. Used InfoPath for custom forms. Developed dynamic filtered all Org leveldashboards. Implemented JQUERY scripts to enhance page and list formatting with tabs. Designed web services usingWCF to access Data Marts & Data Verse environments. Implemented solid site collection security. Migrated allcompany data from local file shares into SharePoint & OneDrive using Sharegate. Move onsite to O365USAA- San Antonio, Texas (Telecommute - Consultant) 10/3/2017-10/3/2018SharePoint SMEImplemented time saving SharePoint workflows. Added US Government regulatory news feed web parts (RSS) to aUSAA SharePoint collection. Enhanced web pages using Bootstrap, Rest, jQuery, CS, JS, Fonts)WELLS FARGO, Charlotte, NC (Telecommute - Consultant) 10/3/2016-10/3/2017SharePoint DeveloperDeveloped custom windows applications to generate XML from the InfoPath forms. Implemented JQUERY scripts toenhance page and list formatting with tabs. Designed web services using WCF to access business data. Enforced sitelevel security. Migrated all company data from local file shares into SharePoint & OneDrive using Sharegate.Wells FARGO, Charlotte, NC Remote - Consultant 10/3/2015-10/3/2016SharePoint & Tableau SMERedesigning IT software approval process by work flowing approval forms. Improved security through thedevelopment of Tableau and SharePoint visuals with custom drill downs. Creating complex InfoPath Forms-DesignerWorkflow.JOHNSON & JOHNSON -HeadQuarters - Onsite Consultant 10/3/2013-10/3/2015Tableau SMEUsing SAP, queried unstructured data and discovered pharma vendor transaction patterns. Examined financial dataand filter for targeted information using traditional SQL Server 2012 and Oracle 11.2. Created advanced visualsdeployed via SharePoint Used Tableau for predictive analytics for Pharma sales. Developed an Outlook VBAapplication. It Parses Outlook email messages, extracts key Email Body information. The application then posts theresults to a SharePoint table for Accounts Payable processing. Integrated Oracle with SharePoint, MS Access, and Excelvia ODBC.JOHNSON & JOHNSON(J&J) -Legal Dept - Onsite Consultant 10/3/2011-10/3/2013SharePoint Content Manager -Used SAP to track litigation across J&J. Was the SharePoint subject matter expert. Created KPIs to monitor systemsprojects. Trained users to optimize SharePoint. Delivered 3rd tier support for SharePoint solutions.US ARMY, Fort Monmouth, NJ 10/3/2009-10/3/2011SharePoint Collaboration Manager - Full Time Onsite Consultant Spearheaded the worldwide deploymentof SharePoint for the US Army to over 250 new locations. Responsible for development, workflow coding, andgovernance documents. Developed site content and implemented structured updates. Created and delivered trainingfor end users and administered the team site. Created progress presentations. Ensured the successful first deploymentof SharePoint software worldwide by creating an efficient operational infrastructure to launch 250 key web sites inthe first six months. Improved security providing a collaboration document for developers and end users that outlineshow to protect and restrict access to national security information.MORGAN STANLEY SMITH BARNEY, New York, NY- Full Time Onsite Consultant 8/4/2007-8/4/2009IT Reporting Tools Developer -Integrated data feeds from multiple sources, enhanced via VBA, and developed SharePoint workflows to automatethe management approval process. Automated invoice processing using SharePoint designer workflows. Createdbusiness management reports that route information from Business Objects (SQL Databases) to SharePoint.BANK OF AMERICA, New York, NY 8/4/2005-8/4/2007Global Operations & Systems Specialist - Full Time Onsite Employee-OnsiteSharePoint site manager- Define metrics and KPI. Facilitated gathering business requirements. Prepared weekly andmonthly IT status reports. Managed technology investments and budget for Wealth Management. Implement ClarityProject Tracking. Created automated extraction reports from SQL databases for distribution.JPMORGAN CHASE - Full Time Onsite Employee Onsite Employee 6/5/1975-6/5/2005Retired Vice President Multiple revenue generating LOB and IT - Business IntelligenceEDUCATION, Certifications, & AWARDSM.B.A., Information Technology, Pace University, New York City, NYB.S. Business School - Seton Hall University, South Orange, NJRutgers University - Project Management CertificationCompTIA A+ Certification 233174224Veteran US Navy - Meritorious Service Medal -VS71IRS Clearance - Tier 5: National security |