Jeffrey Colman Email & Phone Number

Bothell, Washington, United States

I work directly with clients to build Excel or web-based solutions to suit their specific needs.

Remote

Sync with stakeholders to assess project needs and scopeDevelop and modify Excel solutions for businessesDesign easy-to-use end user interfaces for templates

Redmond, Washington

As an Allovus Design vendor, I serve the role of Excel specialist for Microsoft HackingSTEM. This a small team that designs and develops STEM (Science, Technology, Engineering and Math) projects especially targeting middle school students through next generation hardware, software, and services. Our goal is to support teachers building inquiry and project-based activities that embed computational and design thinking into existing middle school curriculum. We want to democratize STEM for learners to demonstrate how all schools can provide affordable opportunities to bring "making" and 21st-century technical skills into the classroom. This team travels domestically and internationally presenting and engaging educators and students with hands-on tools and free downloadable curriculum activities that empower youth through hands-on learning.As the Excel specialist for the team, I develop the Excel workbooks that incorporate both live experimental data and imported Big Data in a variety of STEM experiments. All our content needs to be easy-to-use for middle school students, so I create the dynamic dashboard experiences where users interact with incoming data. This involves using my skills and imagination to conceive of new methods of Excel visualization, utilizing tables, charts, formatting, complex formulas, and VBA to create a dynamic visual for the students, to see charts and visualizations change in front of their eyes as they manipulate their tools. My expertise in this has also led me to run trainings and develop tutorials on live data visualization techniques for both internal and external users.

Bellevue, Wa

Vendor for Express Employment Professionals- Manage SQL database for quota management team--- Import essential data from external sources for storage--- Create stored procedures to simplify repeated processes--- Create and manage multiple quota distribution models- Utilize VBA to create and customize macros for recurring reports for business partners- Connect Excel reports to SQL database via PowerPivot, utilize advanced Excel formulas and methodologies to make reports dynamic- Implement monthly audits for partner portfolio alignments- Coordinate with team members via SharePoint to track business needs and ensure they are met in a timely fashion

Redmond, Wa

•Performed ad-hoc analysis on utilization, payouts, and presented analysis to various business partners•Performed weekly and monthly audits covering reconciliation of hours, participant setups, transition allowance, and other necessary data integrity issues for plan maintenance•Managed scheduled payouts as well as timely off-cycle payouts for participants•Provided support to the field regarding targets and incentive compensation data•Leveraged business partners to improve quality of service to the field and knowledge of the organization•Performed high level audits using Vlookups, Getpivots, and Macros.•Reconciled quota, revenue mapping, and revenue during payout cycles and during off-cycle periods.

Financial Lead from April 2013 to July 2014Manage personal bank account finances for all Seattle clients- balance income against monthly expenses - pay off bills, splitting bills as necessary among all relevant parties- prepare monthly bank statements for ongoing recordsManage company credit cards- coordinate use with Program Supervisors- track all expenditures, notify supervisors of missing receipts- balance all expenses within each credit limit- portion expenses as appropriate to be paid by company or relevant clientSupport Counselor August 2009-April 2013Coordinate day-to-day activities of two developmentally disabled clients in homeManage and redirect hostile and unhealthy behaviors of clients

Conduct laboratory experiments with studentsInstruct, demonstrate, and explain experimentEvaluate student performance

Master’S Degree, Data Analytics, 3.85 Gpa

Data management Evaluate business problems, analyze data sources, propose solutions for implementation Risk management Predictive data.

Bachelor Of The Arts; Bachelor Of The Arts, Philosophy; Psychology

Activities and Societies: Dean’s List Psi Chi Psychology Honors Society Phi Sigma Tau Philosophy Honors Society