Joseph A Mezz

Summary

·   SharePoint with workflows and Tableau Developer. Business Objects Report developer.

·   8+ years of experience in Business Analysis, Reporting Analysis,

·   8+ years of experience with Microsoft Access – Expert at connecting Office products with everything.

·   8+ years of experience with process improvement, workflow, benchmarking and/or evaluation of business processes.

·   8+ years of experience with many Relational databases and Database structures.

·   5+ years of SAS experience (SQL programming)

·   Microsoft Access and Excel Expert. VBA custom development and automation for all Office products.

Education:

·   Master of Business Administration, International Business & Finance, Pace University, New York City, New York.

·   BS, Business Management Information, Seton Hall University, South Orange, New Jersey.

·   Project Management Certification, Rutgers University, New Brunswick, New Jersey.

·   SharePoint Developer Certification.

·   CompTIA A+, PC Hardware Design Certification

Experience:

Wells Fargo – Business Intelligence Developer                                                            12/2014 - 6//2017          

·   Developed Tableau visuals that provided interactive decision support to manage 11,000 IT projects.

·   By definition data warehouses have an enterprise-wide depth. The information in data marts pertains to a single department. In some deployments, each department or business unit is considered the owner of its data mart including all the hardware, software and data. This enables each department to use, manipulate and develop their data any way they see fit; without altering information inside other data marts or the data warehouse.  Created a MS SQL Server at Wells Fargo that consolidates information that will be fed to Tableau.

·   Monitor, report, and analyze work and project portfolio activity, status, and metrics.

·   Built a timely InfoPath form enabling a release management tool to be migrated from SharePoint (SP) 2007 to SP2013 ahead of schedule with minimal enterprise cost.

·   Leveraged MS Access and Tableau to create advanced SQL queries that allows SP users to update SQL server tables.

·   Maintained SSIS scripts for loading information into SQL server BI warehouse.

·   Developed Tableau reports with extensive drill down features that track IT Projects performance and spend across the enterprise.

·   Developed a new collaboration tool that controls all software released to the public at Wells Fargo.

Johnson and Johnson- Sr. Metrics Analyst and SharePoint Lead                                 6/2013 –12/2013                  

·   Interfaced with Health Care Compliance Officers and other key compliance professionals to understand HCC and other related control risks. Utilized financial transactional data that mitigate these risks.

·   Built a Data warehouse containing at least 100 million records from various data marts. This information was used to enrich Tableau dashboards. Tableau dashboards were developed to show ongoing sales force activity, prescription data, demographic information, and census information. This allowed the optimization and deployment of the JNJ Pharmaceutical sales force.

·   Help business partners clarify, develop, and plan for their current and future technology needs using SAS.

·   SharePoint 2007, 2010, 2013 developer and Tableau developer creating visual KPI’s which monitor systems projects. Analyzed information requirements that cross multiple systems. Link to SAP Financial databases via MS Access. Integrated SharePoint with Tableau, SQL, MS Access, and SAS.

·   Query and mine large data sets to discover transaction patterns.Examined financial data and filter for targeted information using traditional SQL Server 2012 and Oracle 11.2. Created advanced visuals via Tableau with predictive analytic methodologie. Developed an Outlook VBA application that parses email message, extracts key information, and posts the results to SharePoint. Integrated Oracle with Tableau, MS Access, and Excel.

·   Created InfoPath forms for SharePoint that automatically fill key employee information. Migrated SharePoint 2007 to SharePoint 2013 platform. Performed SharePoint google site analytics to predict SharePoint 2013 usage.  Performed peer review of code in order to detect and minimize application defects

Bank of America - SharePoint 2010 Lead                                                                                  2/2013 – 5/2013

·   Helped manage the migration of a Sharepoint site from Development, to UAT, and finally into Production.

·   Managed Clarity Project Tracking at Bank of America. Integrated the Clarity backend database housed in (Oracle) to a front end system that auto alerts managers when staff time sheets are not completed on time.

·   Developed an interactive organization metaphor in Sharepoint with descriptive links for drilldown capability.

·   SharePoint 2007, 2010, 2013 developer and Tableau developer creating visual KPI’s which monitor systems projects. Developed multi-media elements for the Sharepoint site asset folder.

·   Designed the metrics by which all I.T. projects will be evaluated. For example, net present value, return on investment, strategic and/or technical fit.

Morgan Stanley Smith Barney - IT Reporting Tools Developer                                                  11/2010 – 10//2012     

·   Developed MIS to manage projects, headcount, and budgets for the Sales Technology IT area at Morgan Stanley.

·   Integrated SharePoint with Tableau, SQL, MS Access, and SAS.

·   Integrated data feeds from multiple sources into a Sharepoint site. Developed Sharepoint workflows to automate the management approval process. Design and implement Excel based metrics. Extensive use of VBA to enhance data feeds. Some SQL work and integrated Oracle with Tableau, MS Access, and Excel.

·   Created pivot tables, graphs, VLookups, and merge large data sets. Created an Information pump to refresh KPI’s and have them distributed via a SharePoint server. Automated Invoice processing for IT using Sharepoint Designer workflows.  Automated the creation of Business Management reports that route information from Business Objects (SQL Databases) to Sharepoint. Integrated MS Access, Excel, SQL, and Business Objects with various SharePoint websites.  Excellent communication skills with the ability to synthesize complex user requirements and deliver value added business solutions that result in impressive performance gains. Used QLIKVIEW to link to SQL, Access, Excel, and Business Objects databases.

Johnson and Johnson - SharePoint Content Manager                                                     6/2010 –11/2010

·   Rolled out a new SharePoint site for the Legal department that tracks litigation. SharePoint 2007, 2010, 2013 developer and Tableau developer creating visual KPI’s which monitor systems projects. Trained users to optimize SharePoint. Third level support for SharePoint solutions. Worked as a Share Point SME to identify opportunities for process improvement. Developed MS Access databases linked to SharePoint to Track pending JNJ litigation. Used SAS to normalize the accounts receivable database.

US Army-Fort Monmouth - Collaboration Software Manager                                                          7/2008 – 2/2010

·   Spearheaded the worldwide deployment of SharePoint for the US Army. Responsible for site content and structure updates, training users in SharePoint, and team site administration. Responsible for SharePoint development, workflow coding and governance. SharePoint 2007, 2010, 2013 developer and Tableau developer creating visual KPI’s which monitor systems projects. Responsible for leveraging out-of-the-box and custom developed functionality for SharePoint. Utilized SharePoint Designer for all intranet/extranet workflow functionality.

Bank of America - Global Operations and Systems specialist – VP                                               10/2006 – 7/2008

·   Developed a SharePoint site to communicate KPI.

·   Developed interfaces between Oracle and SQL Server based applications via MS Access or SharePoint, the intranet, and supporting databases. Trained end users and departmental administrators.

·   Integrated disparate business data from multiple sources. Working knowledge of Project development, Software Development Lifecycles. Expert at Excel and Access. Knowledge of relational database structures.

·   Front ended MS Access to a backend Oracle and Microsoft SQL databases. 

·   Responsible for the preparation and reporting of IT Weekly and Monthly Status Reports.

·   Clarity time tracking manager. Defined metrics and then partnered with teams to implement their adoption.

·   Project Manager for implementing Business Objects. Facilitated gathering business requirements for IT projects.

·   Managed technology investments and budget for the Wealth Management CFO organization.

JP Morgan Chase – Vice President                                                                                                      12/1981 – 10/2006

·         Channel Delivery Innovation - Project Manager

·         Collaboration Software Manager.

·         Manager Strategic Planning - Branch network.

·         Finance Manager - ATM rollout

·         Corporate Systems - Capital Expenditure Management

·         Industrial Engineer -Process improvement Analyst