Overview
Work History
Education
Skills
Accomplishments
Certification
Languages
Affiliations
Timeline
Generic

JOHNATHAN CABALLERO

Fredericksburg

Overview

11
11
years of professional experience
1
1
Certification

Work History

Senior Manager, Analytics Architect

Salesforce
02.2021 - Current


  • Managed large-scale, multi-year analytics programs from strategy to execution.
  • Worked alongside clients' program sponsors to craft out an analytics vision and strategy, from creating business objectives to metrics to track progress.
  • Built proof of concepts to show how can analytics help the business achieve objectives.
  • Efforts produced more than $1M in professional services for analytics programs across multiple large enterprise clients.

Data Science & Analytics Architect

Acumen Solutions
01.2017 - 02.2021
  • Designed, built and implemented an Enterprise-wide Analytics solution for a large government sector client, that tracks 5M+ budgets and expenditures for variance analysis.
  • Developed a PoC for automating medical claims processing using Machine Learning algorithms in Python that will save manual review time on 10K+ of claims per year for a large healthcare client.
  • Designed and built an a Analytics solution that brought disparate data from multiple sources together in order to provide a 360-degree view of customers for a Dept of Justice client.
  • Migrated and integrated over 3.5MM ERP products and order data from multiple external systems for a custom CPQ SFDC Lightning application using Informatica Cloud and SQL Server reducing over 75% of manual overhead.

Master Integrator

Capco (The Capital Markets Company)
02.2017 - 10.2017
  • Identify gaps, dependencies, risks and issues for deploying application changes impacting the client's customer data warehouse (CDW) that stores financial and mortgage data used by investors. 
  • Developed a standardized approach to integrate 68+ applications for the largest U.S Government Sponsored Entity
  • Implemented a relational database system for data collection, storage and management of code versions, environments and deployments.

Data Analytics

Capco (The Capital Markets Company)
11.2016 - 01.2017
  • Developed proof of concept for a custom solution that allows users to accept and process bulk mortgage XML data using the MISMO standard as well as manage the relational database model using MariaDB and visualize the data in Angular.
  • Analyzed and developed transformation logic for handling large sets of structured, semi-structured and unstructured data using Datameer and Hive.

Systems Integration Team Lead

Accenture
01.2016 - 11.2016
  • Led an agile team to build, test and deploy application bug fixes and enhancements for a 200+ TB custom Oracle Business Intelligence database.
  • Coordinated with managers and support teams to execute Change Requests, Oracle PL/SQL and Data application deployments on a weekly schedule or on-demand.
  • Reviewed own and work of others to ensure code and test artifacts are delivered in a consistently high-quality manner to the client.

Salesforce Data Conversion Specialist

Accenture
01.2014 - 01.2015
  • Improved client adoption of Salesforce by 62% compared to the previous year by executing a strong data conversion strategy from legacy system to Salesforce combined with change management effort. 
  • Developed mapping and conversion strategy for legacy system data files, which resulted in over 13,000 customer contacts and more than 6,000 accounts structured in multiple formats.

Software Implementation Senior Analyst

Accenture
04.2013 - 12.2014
  • Provided technical/development support for a large-scale Business Intelligence custom application that processes 10+ billion records daily.
  • Re-engineered application processing to improve database performance and stability.

Education

BBA - Information Systems

University Of Puerto Rico
2012

Skills

  • Data Architecture
  • Master Data Management
  • Salesforcecom
  • Cloud Transformation
  • Release Management
  • Project Management
  • Business Development
  • SQL: Oracle, PL/SQL, SQL Server, MySQL, SOQL
  • ETL: Informatica Cloud, Mulesoft, SSIS, Pentaho
  • Analytics: Strategy, Tableau, IBM Cognos, Salesforce CRM Analytics
  • Big Data: ELK stack, Hadoop
  • Data Science: Python (pandas), R
  • AWS: RDS, EC2, Workspaces

Accomplishments

  • Formed a strategic relationship on a large enterprise client to develop a holistic analytics strategy that involves Salesforce as their main CRM and Marketing tool.
  • Transformed from legacy, on-premise, siloed systems to a single modernized Cloud Enterprise Platform for Analytics. The system leverages Salesforce and Einstein Analytics to realize future cost reductions, increases productivity, provides On-Demand Analytics, and improves efficiency for 1K+ users in a nation-wide federal client.
  • Developed an Analytics solution for a pilot program to track and measure Business Relationship Management efforts across 60+ entities in a government agency.
  • Built an end-to-end solution for a complex Cloud data migration and integration project for an international manufacturing company involving work streams spanning over 3 time zones (India, U.K, and the U.S).
  • Reduced latency of data available to clients from 36 hours to less than 8 hours by re-engineering a custom Oracle Business Intelligence application that processes 10+ billion transactions per day.
  • Increased business unit performance and visibility by over 80% by fully automating reporting using MS Office, VBA applications, and IBM Cognos.

Certification

  • Salesforce Certified Administrator
  • Salesforce Certified Sales Cloud Consultant

Languages

English & Spanish

Affiliations

Leukemia and Lymphoma Society (LLS) - Light the Night Walk in D.C

Timeline

Senior Manager, Analytics Architect

Salesforce
02.2021 - Current

Master Integrator

Capco (The Capital Markets Company)
02.2017 - 10.2017

Data Science & Analytics Architect

Acumen Solutions
01.2017 - 02.2021

Data Analytics

Capco (The Capital Markets Company)
11.2016 - 01.2017

Systems Integration Team Lead

Accenture
01.2016 - 11.2016

Salesforce Data Conversion Specialist

Accenture
01.2014 - 01.2015

Software Implementation Senior Analyst

Accenture
04.2013 - 12.2014

BBA - Information Systems

University Of Puerto Rico

Similar Profiles

CREATE PROFILE
JOHNATHAN CABALLERO