Nicholas B. Johnstone

Client Operations Manager

**** * **** ****** ************ Indiana 46219 352-***-**** ad4ovw@r.postjobfree.com

Overview

With over 6 years of Sales and Account Management experience, I am a versatile “swiss army knife” professional. with 10+ years in Business Intelligence, Account Management, Sales, Direct Response Marketing and Operations. Specializing in B2B relationships, I am adept in enhancing organizational effectiveness through data analysis and dashboard creation for reporting to stakeholders. Skilled in simplifying complex operations and communicating insights across teams, I'm driven by a passion for data-driven decision-making and improving efficiency at all organizational levels to drive profitable business outcomes.

SKILLS & TOOLS OF THE TRADE

Data Management & Analytics

●Data pipeline structuring, planning, and implementation to advance data maturity globally.

● Strong focus on data quality and integrity enforcement for reliability.

● Proficient in transformation and processing of data for real-time analytics to source actionable insights from multiple streams.

●Development of feedback loop mechanisms for continuous improvement, iteration and process cultivating.

Database Proficiency & Data Manipulation

●Leverages skills in Excel, Google Sheets, and SQL to represent shape and dig into interesting datasets, via V-Lookup Tables, Pivot Tables and Spreadsheet Formulas.

●Experience with Python scripting for data manipulation.

●Proficient in managing and querying relational databases for direct access to sources of truth.

Data Visualization

●Skilled in creating impactful dashboards for internal and external stakeholders, teams, customers and vendors.

●Experience with ETL and visualization tools like Domo, Tableau, and Power BI.

Leadership in Operations & Project Management

●Proven ability in leading operations and tracking projects for both remote and local teams.

●Proficient with tools like Zoho CRM, Zoho Projects, Salesforce, Asana, Notion, Wrike, and Jira.

Stakeholder Management

●Effective in managing diverse stakeholder expectations while delivering outcomes through effective project management.

●Skilled in automated reporting, rollups, client summaries, internal/external performance dashboards, and stage gate summaries.

Vendor & Supply Chain Management

●Demonstrated ability in managing relationships with upstream and downstream vendors.

●Proven capabilities in showcasing supply chain and vendor management to maintain integrity at all stages of the B2B lifecycle.

●Experienced in leading video conference calls, client services calls, status updates and public speaking.

●Effective in developing client relationships for upselling and cross-selling opportunities that drive positive business outcomes.

PROFESSIONAL EXPERIENCE

Client Operations Manager & Business Intelligence Analyst

X Social Media Jan 2019 - Jan 2024 ( 5 years)

●Developed views and workflows to support organizational operations at all levels.

●Utilized SQL for data gap identification and quality improvement strategies.

●Managed data extraction and integration (ETL) from various sources.

●Optimized data organization in spreadsheets for better accessibility and usability.

●Created visualizations for key business insights, aiding in data-driven decision-making.

●Managed and updated company CRM with a focus on workflow optimization and data integrity.

●Contributed to sales and client success, enhancing client retention and upselling.

●Engaged in and managed direct action digital marketing strategies to drive business KPIs.

Facebook Marketing Expert

Facebook TTEC - Phoenix, AZ March 2016 – February 2019 (3 years)

●Managed a $5-$10 Million Book of Business quarterly in Facebook’s SMB division for North America.

●Assisted 150+ advertisers in increasing ROAS and scaling conversions across various verticals.

●Leveraged algorithmic tools for reporting, analytics, and result-driven strategies.

●Focused on client engagement for positive business outcomes and revenue growth.

PolyCycle LLC

Feedstock Procurement Director, 01/14 - 10/16 & 11/17 - 02/19

●Managed relationships designed to help source end of life waste plastics from around the South Western United States to allow for the production of liquid hydrocarbon fuel to be turned into crude oil, diesel and aromatics.

●Evangelized chemical recycling technology to residents, businesses, waste management groups, government entities, landfills and polymer brokers.

Sedona Recycles - Sedona AZ

Assembly Line Manager, 03/13-05/14

●Ran a sorting line picking post consumer recyclables for processing and shipping.

INTERNSHIPS

Junior Developer

Cloud Software LLC January 2016

●Developed and customized Salesforce Org Views using MVC programming principles.

●Retrieved and integrated data using Saleforce’s Proprietary SOQL (similar to SQL) for enhanced data management.

●Delivered tailored Salesforce solutions for improved client business processes.

EDUCATION & CERTIFICATIONS

Coursera: Google Data Fundamentals Course

●Acquired foundational skills in data analysis using Google's tools.

●Applied data-driven strategies for business intelligence insights.

Google Business Intelligence Certificate

●Learning advanced spreadsheet techniques and data analysis with Microsoft Excel.

●Developing skills in data analysis and visualization for strategic decision-making.

IBM Data Analytics Certificate

●Gaining proficiency in Python for data analytics and visualization.

●Engaging in ETL best practices and creating effective data visualizations.

Front-End Web Development Bootcamp

●RockIT Bootcamp, Apollo Group

●Focused on HTML, CSS, JavaScript, and responsive design techniques.

●Handled JSON payloads and built web interfaces with a focus on user experience.

Chandler Gilbert Community College

●Liberal Arts, Chandler AZ

Indiana University Purdue University Indianapolis

●Liberal Arts, IUPUI

LANGUAGES

Spanish

●Near-fluent proficiency; valuable in team engagement and client or vendor communication.

Contact this candidate