joseph sunderman resume supplement public
TRANSCRIPT
Joseph SundermanResume Suppelment
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
How to Use This Document
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Highlighted (yellow frame) are hyperlinks to other parts of document but only functional in Slide Show mode
Note: Due to restrictions, some documents may require password. Contact [email protected]
Click on this image to go back to Road Map but only functional in Slide Show mode
Click on this image of documentation to get full document but only functional in standard edit mode. Does not function in Slide Show mode.
Road Map
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
References
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Analytical Capabilities
Securities/Economic Analysis
Credit
Analysis
Marketing/CRM
AnalysisSales/Web Analysis
Internal/Business
Analyst
Security/Economic Analysis• Securities (Fundamental, Technical, Derivative Securities)
• Named among the “Top Ten” Investment Analyst by Bridge
• Contributor to Award-Winning Web Site
Examples of Publications
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Several Articles SchaeffersResearch.com
Credit Analysis• Underwriting SME deals with bank policy• Cash Flow Analysis• Collateral Analysis• Structure of loan deals• Perform company and industry research• Client interaction to form opinion of borrower’s character, core
competencies and reasonableness of projections
Examples of Applications
• Managed a portfolio of 50 Greater Cincinnati small/middle enterprises with one of the largest amount of money lent, $133 million (23% of total Business Banking in Great Cincinnati footprint).
• Met all Bank in tracking measures of 206 legal entities in covenant tracking, timely renewals, financial statement tracking, PD and Regulatory Ratings
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Sales/Web Analysis
• Developed Market Response Videos Plan for Website
• Website analysis including webinar and newsletter traffic
• Based on Buyer Persona, suggested a revised/simpler sign up form for leads/prospects based off key criteria
• Developed weekly metrics to track activity of sales reps through both CRM and sale-sourced figures
• Creation of model to measure sales progress for insurance agent at various stages in sale process
• Goal development based on historical data, seasonal patterns, and pipeline analysis.
• Worked as liaison between Marketing and Content Providers on web traffic
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Marketing /CRM Analysis
• Lead analysis
• Overall Totals and Trends at various marketing stages
• Conversion Rates at all stages in marketing process
• CHAID/Decision Tree Analysis by lead and salesman
• Summary and recommendations to act upon
• Initialized data mining into CRM data to find opportunities for year-end push
• Created a Master Marketing Calendar that covered a multitude of activities. Weekly updates and bi-weekly conference calls to keep staff informed of deadlines approaching and new projects.
• Produced marketing channel mapping to define the course of action for a lead and/or prospect
• Event Marketing Mapping pre- and post-conferences
• Scoring System of Buyers - a model for most receptive buyers
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Business Analyst
• Diagramming Process Flows - Visio
• Quick Start Guide
• Development of User Personas
• Metadata analysis - compare/contrast metadata inventory versus sourced inventory
• In-depth research on the tools and learning options for Big Data tools for users
• Test execution, bug reporting, and defect retesting in development stage, user acceptance testing, and production environments.
• Translating Wireframe Reports to Template to test results
• Translation business flows into JSON for consumption by the D3.js
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Analytical Tools
• General Analytical & Financial Tools
• Business Analyst Tools
• Communication/Media Tools
Analytical ToolsGeneral Tools• Excel • Access, SQL Querying & Transact SQL (classroom work)• SAS, Business Objects (two years at 5/3 Bank)• Python, R Project, Tableau (personal development) • BI/EI training – Teradata (LexisNexis)
Financial Tools• ThompsonOne• Moody’s Risk Analyst• FirstResearch• AFS• Bloomberg• MarketQA
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Business Analysis Tools
• Visio
• MS Project
• Jira
• MS Publisher
• Lync
• Oracle Hyperion Data Relationship Management, Fusion Edition
• Oracle Hyperion Financial Data Quality Management, Fusion Edition
• HP Application Lifecycle Management
• Web Ex JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Communication/Media Tools
• Dale Carnegie trained
• Webinars
• Lync
• WebEx
• Adobe Visual Communicator
• Trade shows – small groups and large audiences
• Bloomberg television appearances
• Client interactions
• Extensive media coverage JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Project Coordinator• Directed International and Domestic Units (60) through varying stages of data integration from
• Trusted source
• Heat Maps
• Document Design
• Project Plan
• Sample File for initial data integration development
• UAT Testing
• Data Validation
• Coordinated the security and data integration of internal and 3rd Party data through KR
• Security documentation-Collaborating with business owner and technical developers-Determining integration pattern-Develop user stories and acceptance criteria for future analytical work
• Oversaw premium web site development – Command Center
• Directed research and technology teams to overhaul and streamline proprietary financial analytics database, which led to 42% reduction of processing time
• Worked collaboratively in business development venture with Dow Jones.
• Established a relationship with Cincinnati Business Courier’s Investor’s Edge section
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Managerial/HR CapabilitiesManagerial Capabilities• Employee development plans• Created training schedules with projected timelines and Gantt Chart for Client Service Associate • Setting budget for department• Employee reviews• Development and Implementation of variable compensation plans
• Setting direction for department• Development of benching process
• Master Calendar for all Projects and Initiatives throughout the company• Coordination of Several Cross-Functional Teams and Initiatives.• Developed Key Performance Indicators to help bridge operations to profit-loss statements
Human Resource Experience• Recruiting and Screening of Candidates (staff accountant, client service associate, interns).• Developed a 20-item checklist for new hire process (forms, office equipment, compliance, etc.) • Onboarding process including handling all associated federal/state paperwork, insurance, ACA
requirements, and other compliance related items• Setting up a remote office in New Jersey• Health Insurance Enrollment input & Review OJM Medical Insurance• Developed project plan, schedules while tracking progress for procurement for 3rd party resources for RIA,
office equipment, and phone services to improve efficiencies• Coordination of hiring intern through Xavier University and University of Cincinnati's Intern Program
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Work Experience
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Employer & Industry Summary
Leading global provider of content-enabled workflow solutions. Fortune 1000 Global
An innovative Solution Enablement Company- Worked within Fortune 25 company (Kroger)
Multi-disciplinary financial consulting firm
A U.S. regional banking corporation.Fortune 500 and #6 ABA Banking Journal
A leading provider of research, education, recommendations, strategies for stock and options traders.
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Industries Publishing/Web Investments Retail – Grocer Bank RIA/Insurance Firm Web-content (legal research)
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Inherited a project that a previous LexisNexis (LN) employee stepped out after 1-1/2 months knowing the difficulty, complexity and size (encompasses $2.15B units in revenue)
Socialization of Revenue Metrics for 35+ accounts and newly created Product and Segment Hierarchy
Acted as a liaison between 60+ business units and 120+ LexisNexis employees with the LN and PWC project team while translating business requirements to understandable steps Data Work Stream Project Lead with a mix of LN (5 employees) and 3 (PWC employees)
Organized, attended and/or led 255 meetings for International units and US Business Units over a five-month period
Creation, dissemination, and socialization of file format delivery for manual and automated data integration
Financial Data Project Coordinator (contractor)
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Placed into an existing project as a Business Analyst for grocery-giant Kroger where theteam’s objective was the construction of Big Data Service to improve analytics across functional departments through internal and third-party data sources. Working in an Agile environment, primary role was assisting in the onboarding of web application for “Friends and Family” rollout of the Big Data Service.
Highlights include:• Developed Quick Start Guide in MS Publisher• Diagramming Process Flows - Visio
• Metadata analysis - compare/contrast metadata inventory versus sourced inventory
• Developing contacts within company as resource for aforementioned tools• Coordinated the security and data integration of internal and 3rd Party data
through KR Security documentation-Collaborating with business owner and technical developers-Determining integration pattern-Develop user stories and acceptance criteria for future analytical work
Data/Business Analyst (contractor)
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Manager of several employees which included staff from Marketing, Compliance, Insurance, Registered Investment Advisory, and Sales.
Major Areas of Responsibilities• Recruiting and Onboarding process including handling all associated
federal/state paperwork. • Improved Operational Processes (Marketing and Project List). • Creation of Tracking of Sales/Marketing/Insurance Metrics. • Coordination of Several Cross-Functional Teams and Initiatives. • Procurement for 3rd party resources for RIA, office equipment, and phone services.• Developed Buyer Persona, Key Performance Indicators, and Event Marketing Mapping• Goal development based on historical data, seasonal patterns, and pipeline analysis.
General Manager
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Aligns with relationship managers in the small business space in underwriting/monitoring credit, existing/proposed credit requests, providing high level customer service support and assisting in cross sell effort.
• Managed a portfolio of 50 Greater Cincinnati small/middle enterprises with one of the largest amount of money lent, $133 million (23% of total Business Banking in Great Cincinnati footprint).
• Met all Bank in tracking measures of 206 legal entities in covenant tracking, timely renewals, financial statement tracking, PD and Regulatory Ratings
Credit Portfolio Manager
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
• Saved $100,000/annum streamlining a monthly report from a three week process to two days through use of SAS and VBA Excel programs.
• Developed and monitored bank non performing loans (Special Assets Group) portfolio – monthly report - $5.8B during the economic crisis that began in 2008
• Oversaw Commercial Real Estate and Leasing portfolio reporting, which equaled $13 billion or 41% of Bank’s commercial portfolio CRE National Portfolio Analysis
• Created and Developed “State of CRE” – 35-page quarterly report that integrated internal CRE data along with industry and anecdotal data from over 50 different sources. State of CRE
Senior Risk Reporting Analyst Role
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
• Oversees the Quantitative Analyst area of the Research department including the staff, databases, and quantitative analysis
• Established relationship with Cincinnati Business Courier to serve their financial market data needs in the “Investor’s Edge”
• Launched a collaborative with University of Dayton‘s Mathematics Department to study proprietary financial market data
• Conduct weekly analysis on team’s sector and market exposure including delta, beta, and simulations
• Monthly analysis and recommendations to Senior Management team as it relates to portfolio performance
• Oversee the application of core trading principles and developed trader benchmarks/assessment guidelines
• Created and instituted trader compensation system based on performance
• Led daily group trading sessions and weekly individual meetings with traders to improve performance
• Customer-service oriented for both the internal and external customer-Internally, acts as a liaison between research, sales, and marketing-Externally, help answer web-based questions from readers and advanced questions from service reps
Vice-President Research & Development / Director of Analysts
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
• Led a committee and subcommittee over four-month period to develop an extensive web site for customers
• Developed “Talking Points” for sales force to highlight the best features of our line of services and to generate higher incremental sales
• Weekly meetings with marketing and sales Vice Presidents to position services for future sales promotions
• Collaborated with marketing department to create institutional brochure and sales material
• Writer of daily commentary that reaches tens of thousands of subscribers while generating $500K+ annually
• Named among the “Top Ten” of traders, as tracked by Bridge Information Systems 1998, 1999, and 2000
• Presented advanced financial strategies to hundreds of investors at Money Show conventions
• Created sections for company web site that received the Forbes “Best of the Web” for options category
• Contributor to The Option Advisor: Wealthbuilding Techniques Using Equity and Index Options book
• Wrote chapters in “10 Days to Successful Options Trading” home study program
• Created a $100,000 sales day by coordinating a marketing strategy that drove call in traffic up 488%
Manager of Research & Development / Research Analyst
APPENDIX
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
PUBLICATION QUOTES
Associations
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Current:• National Association Business Economics – Cincinnati Chapter• Sacred Heart Church Committees
Committee member for three separate fundraising efforts – golf, festival (silent auction), benefit run and grand prize. The combination of all of these events raised approximately $50,000 through business sponsorship and sales of solicited items from local business and community members.
Past:• University of Cincinnati A&S Alumni Advisory Board• The Executive Committee (TEC) • Financial Executives International• Chartered Financial Analyst Society of Cincinnati – affiliate member• SCORE - Counselors to America's Small Business
Interact with entrepreneurs to help with business plans, financing, and marketing. • Sacred Heart Church Committees (2005-present)
Committee member for three separate fundraising efforts – golf, festival (silent auction), and benefit run. The combination of all of these events raised approximately $50,000 through business sponsorship and sales of solicited items from local business and community members.
• Executive Service Corps of Cincinnati (August 2005 to present)Volunteer consultant that assists local non-profit organizations in strategic planning, board development, funding strategies, marketing planning, and all other facets that impacts an organization
• Adjunct Professor Northern Kentucky University (Fall Semester 2001)Taught a Derivative Securities course for undergraduate students. This course covers the definition and explanation of various risk transfer devices such as options involved in trading these securities, hedging and speculating with options and
futures, supervision, regulation, and tax consequences of futures and options trading.• Volunteer Race Director of Cincinnati Recreation Commission Run (1996 – 2000)
Served as race director by handling all aspects of the run from gathering of sponsors, creating advertising campaign to local runners, handling public relations, t-shirts and awards, and coordinated all of the events the day of the run. Money raisedfrom the run has enabled the Sayler Park division of the Cincinnati Recreation Commission to build a playground, hold
symphony concerts in the park, and help upgrade the recreation center for the senior citizens and children of the community.
Other
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
MeetUp Groups• CinBITools • Cincinnati Business Intelligence & Analytics• CincyPy • Open Data Cincy • CinDay RUG • CincyPASS –Cincinnati SQL Server Users Group
Adjunct Instructor NKU – Derivative Securities
Blog
References
Victor Turner Sr. Dir Financial Sys LexisNexis 937-609-6088
Connie Bennett Director Illumination Works, LLC 937-938-1321
Andy Burns VP lllumination Works, LLC 513-276-4077
Randy Carter Credit Officer Fifth Third Bank 513-368-9997
Bob Rack Former COO Schaeffer's Investment Research 513-325-9789
Bob Becks Associate Bursar Xavier University 513-967-2668
Ron Taylor Attorney Blake Maislin 859-781-8898
Bernie Schaeffer Founder/Owner Schaeffer's Investment Research Letter Only
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Revenue Metrics
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Business Units
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Data Work Stream Role
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Commander Center
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80
Tableau
JOSE
PH
W. S
UN
DER
MA
N 5
45
3
LAK
E M
ICH
IGA
N D
R F
AIR
FIEL
D, O
H
45
01
4 C
ell#
51
3.6
08
.95
80