Summary
Overview
Work History
Education
Skills
Timeline
Generic

Emmanuel Castaneda

Greater Boston

Summary

As a data analyst with over five years of experience in data analysis and reporting, I have delivered actionable insights to organizations in various industries.

Overview

7
7
years of professional experience

Work History

Senior Sales Analyst

Lytx, Inc.
10.2021 - 09.2022
  • Spearheaded optimization of reporting processes, transitioning from manual Excel spreadsheets to automated solutions using Tableau and SQL, achieving a 90% reduction in processing times.
  • Processed weekly reports for senior management, providing detailed insights into sales performance.
  • Developed reports for investor presentations and sales meetings, documenting requirements and assisting the sales team in demonstrating return on investment.
  • Prioritized precision and clarity in reporting, enhancing accuracy and creating user-friendly sales data dashboards to facilitate real-time decision-making.

Market Data Operations Analyst II

ICE
01.2019 - 10.2021
  • Assisted with team development and operational enhancement, including training new team members and continuously improving analytics and system designs.
  • Designed comprehensive reports aligned with business requirements and improved metrics and KPI dashboards for widespread team use.
  • Contributed significantly to documenting business processes and systems, leading to improved business operations and processes.
  • Leveraged expertise in SalesForce, ServiceNow, Excel, Access, Tableau, SQL, and VBA to provide insights into the business state through analysis and data visualizations.

Market Data Operations Analyst I

ICE
11.2018 - 01.2019
  • Took charge of determining KPIs and metrics, reconciling invoices, and overseeing vendor and client inquiries.
  • Led reporting improvement projects for entire business units, specializing in designing analytics dashboards for widespread use in Salesforce and Access.
  • Created detailed reports tailored to business requirements across Salesforce, Access, and Excel.
  • Implemented innovative methods in Excel and Access, resulting in a significant 90% reduction in processing times and establishment of databases in both platforms.
  • Ensured reporting compliance between vendors and clients for various products on a monthly basis.
  • Proficiency in SalesForce, ServiceNow, Excel, Access, Tableau, and SQL enabled delivery of data-driven insights and effective streamlining of operations.

Board Member

Greater Lawrence Young Professionals Network
12.2015 - 01.2019
  • Led CRM software implementation discussions.
  • Organized local networking and community service events.
  • Developed marketing materials, member outreach, and retention strategies.

Client Support Specialist, Operations

ICE
11.2017 - 11.2018
  • Analyzed large datasets in Excel.
  • Served as the central point of contact for all departments.
  • Managed client hardware upgrades and data projects.
  • Handled client requests on internal systems and Salesforce.
  • Designed a SalesForce dashboard/report for team-wide daily use.
  • Provided valuable input on operations improvement.

Risk Management Analyst

Watts Water Technologies
01.2017 - 11.2017
  • Conducted financial analysis and identified KPIs.
  • Developed dashboards to streamline reporting processes.
  • Compiled comprehensive reports and trend analyses for senior management using multiple data sources.
  • Managed a database and enhanced reporting operations.
  • Provided valuable insights for operating system selection and budget management.
  • Supported Supply Chain and Finance departments with reporting functions, leveraging advanced Excel skills.

Analyst

Randstad
08.2016 - 12.2016
  • Conducted account reconciliation.
  • Managed vendor payment and disputes.
  • Addressed ad hoc employee requests.

Business Analyst - Intern

Sovos
01.2016 - 04.2016
  • Generated comprehensive reports for management, offering insights into market trends and opportunities.
  • Ensured data accuracy in Salesforce for seamless bulk uploads into the system.
  • Streamlined data management processes.
  • Leveraged expertise in Salesforce and Excel to develop efficient workflows.
  • Meticulously documented business processes in an operations manual to ensure operational consistency.

Sales Operations Analyst - Intern

Empower
06.2015 - 01.2016
  • Improved data integrity and efficiency in sales operations, leading to a full-time offer.
  • Created training manuals for Marketing Managers and Sales Department Interns to streamline onboarding.
  • Utilized Salesforce, Excel, and VBA for analysis, report generation, and CRM activity management.
  • Designed and implemented new business processes, resulting in a 99% reduction in processing times.
  • Supported sales management across various tasks, demonstrating versatility and dedication to organizational success.

Education

Political Science

University of Massachusetts - Lowell
Lowell, MA
12-2016

BBA - Finance, General

University of Massachusetts - Lowell
Lowell, MA
12-2016

Skills

  • Sales Analysis and Reporting
  • Business Intelligence
  • Operations Improvement
  • Requirement documentation
  • Salesforce, Tableau
  • Advanced Excel, SQL

Timeline

Senior Sales Analyst

Lytx, Inc.
10.2021 - 09.2022

Market Data Operations Analyst II

ICE
01.2019 - 10.2021

Market Data Operations Analyst I

ICE
11.2018 - 01.2019

Client Support Specialist, Operations

ICE
11.2017 - 11.2018

Risk Management Analyst

Watts Water Technologies
01.2017 - 11.2017

Analyst

Randstad
08.2016 - 12.2016

Business Analyst - Intern

Sovos
01.2016 - 04.2016

Board Member

Greater Lawrence Young Professionals Network
12.2015 - 01.2019

Sales Operations Analyst - Intern

Empower
06.2015 - 01.2016

Political Science

University of Massachusetts - Lowell

BBA - Finance, General

University of Massachusetts - Lowell
Emmanuel Castaneda