John Eckhoff Email & Phone Number

Project was to document, and facilitate functional and technical requirements for cloud migration. I created BRD from project purpose to testing sign off. Created project in JIRA and lead grooming sessions for sprint planning across many lines of business.• Elicit functional/non-functional and technical requirements for BRD creation for project.• Created user stories and acceptance criteria.• Document/build backlog in Jira/ Create sprints. Jira upgrades implementation and testing.• Document Application Assessment process and track KPI’s.• Report progress, use testing and production dashboards and KPI’s in Jira for updates.

Oaks, Pa, Us

Worked to bring on new client; in to Hedge Fund Portfolio. Elicited requirements document and shared KPI’s in JIRA; created Excel workbooks to perform tiered fee calculations, performance, hurdle and high-water calculations and “as of” dashboards to analyze impact to funds; built workbooks using advanced formulas and macros. • Elicited requirements from clients and reporting SME’s. • Extracted client data from SEI system and did necessary calculations. Pulled data from SEI system to validate the data calculations performed coincided with the client’s calculations to achieve 99% reconciliations. • Created process to manipulate data in Excel from different data sources (mutual fund, alternative fund, and hedge fund databases) to produce elaborate Excel reports for various variable monetary performance awards for management based on High-Water Mark (HWM) performance. • Gap analysis for client data. • Key point of contact and subject matter expert on multiple Excel Workbook data reports including High Water Mark, Managerial Fees, and as of variance gap analysis.• Exported data into Excel and verify data using Pivot Tables, v-lookups, “Sum If” and “Match” formulas” • Provided reports for client review.

Provided ad-hoc reports for retirement services operations and process enhancement for regulatory requirements. Elicited business requirements, functional requirements, created use cases, selected appropriate methodology, and validated stakeholder requirements to business requirements to facilitate testing and implementation. • Production Support project process enhancement. Automated processes that would take three people over a week to complete to processing in a few hours.• Automation of performance and other monthly reports and monthly reconciliation reports for retirement accounts in Excel with data manipulation.• Elicited business requirements and functional requirements, testing and push to production.• Created ad hoc reports as requested in project que for retirement operations.

Complete analysis of Sales in SalesForce.com. Creating Dashboards; spreadsheets, AdHoc reports. Lead in CRM and Interface enhancements. Administer applications to Sales, Marketing and Reporting departments as position dictates.• Create reports and dashboards for high level managers. Some SQL and VB involved in retrieving reports• Support Sales staff and other departments with application administration. Administer, Salesforce, CPQ, SharePoint, CSR, UCM, Data.com and DocuSign• Process improvements and user request meetings to continually improve the systems and processes.

San Francisco, California, Us

Business Analyst II International Operations Contract, 08/2013-PresentComplete analysis and ad hoc reports for project manager and Sr. management. Project reports, cost, tasks, status, and assisting task owners with timely accurate reporting; taking leads in projects when asked; completed a database cleansing and updating for over 72k rows of data. Improve daily process with macros and lookups in Excel; moved International Business Operations project website from old system to SharePoint 2010.• Prepare ad hoc reports and spreadsheets, using Excel, Access and Visual Basic as needed for analysis.• Process improvements. Create macros for departments to save time on everyday procedures.• Create SharePoint sites for easy access to project documents, scheduling, status, etc.• Coordinate meetings with managers to discuss project goals and process. Update managers with process results and improvements that will be implemented.• International Correspondent Operations web site maintenance.• Over 3 months and $300k saved in project budget with my data cleansing in all databases in system flow path.• Increased international business production by lessening error rate over 3% which processes billions of dollars on a monthly basis.

Valley Forge, Pa, Us

Vanguard, Malvern, PABusiness Analyst (Project 1) Contract, PresentAnalyze pilot testing ensuring a smooth high quality transition to the client’s upgraded brokerage account. This includes “Model Office” brainstorming, anticipation of breakdowns and solutions for obstacle paths that may occur. Create process improvements for new and existing procedures.• Prepare ad hoc reports and spreadsheets as needed for analysis.• Test and analyze procedures to ensure accuracy.• Create model flows of client interaction with crewmembers to show workflow process and analyze for any breakdowns and improvements.• Coordinate meetings with project managers to discuss testing, process results, and improvements.

Boston, Massachusetts, Us

•Converted clients to State Street operating system•Asset research and maintenance•Analyze current processes and recommend process improvements•Accounting validation and reconciliation

•Optimize client satisfaction•Oversaw over 15 mutual funds on a daily basis •Ensured accuracy of Fund Accountant's work•Checked monthly financial schedules•Verified data and submitted to client for analysis•Conducted monthly meetings •Reviewed issues and discuss improvements•Identified client problems and provided solutions•Resolved any discrepancies in trades•Maintained a 99.7% NAV accuracy rating •Ensured client needs were met•Managed a staff of eight Fund Accountants

•Optimized client satisfaction•Financial reporting for fiscal quarters•Completed work on muliple Mutual Funds daily•Checked accuracy of work that was completed•Verified monthly statements •Submitted deliverables to client for review•Built strong client relations•Maintained high accounting accuracy rating

•Responsible for over 20 health service provider payments •Daily management of billing to client •Responsible for all aging reports and collections•Conducted record keeping for clients•Provided information to client when requested•Achieved over 90% collection rate of all past due accounts

•Assisted customers in applying for mortgages•Ensured client paperwork was received in a timely and accurate fashion•Scheduled settlements and ensured loans were closed•Led 3 years in highest closing dollars

Ba, Finance

Ccba/Cbap, Business Analysis