John Mcgilligan Jr. Email and Phone Number

Analyzing & optimizing digital media conversions & segmenting audiences for better marketing ROI.Manipulating data, Cleaning up and Presentation synthesize information and provide insights about the data.Responsible for helping to evaluate and develop relevant consumer insights to improve Marketing Communications go-to-market strategy.

● Tableau Site Administrator - create and manage the site's users/groups, create projects to organize content on the site, and assign permissions to allow users/groups to access the content. ● Developing, maintaining, and managing advanced reporting, analytics, dashboards and other BI solutions● Performing and documenting data analysis, data validation, and data mapping/design● Reviewing and improving existing systems and collaborating with teams to integrate new systems● Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues● Creating tools to store data within the organization● Certify content and measure the use of analytics within the site and scheduled instances for refreshing visualization data in Tableau● Ensures data sourcing is consistent with business needs/requests and applies knowledge of the business to customize reports and deliver information for an optimal user experience● Demonstrates working of knowledge of SQL relational databases, query tools, data mining and data manipulation skills and the ability to apply them to work assignments● Organized, “take-charge” professional with exceptional follow-through abilities and attention to detail, able to plan and oversee a task from conception to successful conclusion● Primary responsibility is to design, prototype, and develop data sets, reports, dashboards and data visualizations in order to effectively provide information to business leaders in Tableau● Experience in dashboard designs that have large data from various data sources (SAS, Oracle, Excel, CSV)● Design, develop, and establish KPIs to monitor analysis and provide strategic insights to drive performance● Summarize analysis by organizing findings into actionable conclusions and recommendations, and communicates findings through verbal and written methods● Worked extensively with creating Calculations, Table Calculations, Parameters, Trend Lines and Statistics

• Provide the Perfect Client Experience (PCE) by telephone to internal and external clients accurately, professionally and courteously, while adhering to bank policies and procedures.• Proficient in LeasePlus, Aspire, Crystal Reports• Generates weekly data excel reports for company executives.• Knowledgeable in accounting practices and principles• Handle a variety of complex banking service inquiries, solving client problems, identifying client needs to open/refer products and services and providing first level technical support• Assist supervisors with front-line agent call handling support• Process more specialized call types and higher risk transactions and maintenance.• Deliver world standard client service by answering inbound client calls timely, accurately, professionally and courteously. • Maintain required performance standards in quality, occupancy, attendance, promptness and identifying client needs. • Assist in the resolution of client complaints.• Assist supervisors with front-line agent support to ensure one call resolution.• Ensure the security of client information and assist with minimizing bank losses by performing client verification on each call received.• Identify possible identity theft and fraud and escalate for client follow-up and risk mitigation.• Provide high quality service through efficient and effective client service with an emphasis on low client effort.• Assess client needs and suggest products and services. • Suggest changes to improve communications and business efficiencies.

• Plays significant role in the company’s annual budgeting process• Works closely with owner to build accurate forecast projections• Calculates key performance indicators such as profitability, solvency, and efficiency ratios• Ensures optimal work quality and customer service• Collect and analyze project financials to increase profits and improve efficiency• Generates profits from new projects through social media marketing• Process employee expense reports• Consistently assume additional responsibilities and worked extended hours to meet project deadlines

• Collected data from app to specifically place bikes in areas where consumers are frequently located• Oversaw assembly• Assisted in supply chain• Planned all logistical aspects of bike delivery at port to Avalon• Directed bike inventory purchases