Jay Carroll, Developer in Suwanee, GA, United States
Jay is available for hire
Hire Jay

Jay Carroll

Verified Expert  in Engineering

Data Warehouse Design Developer

Location
Suwanee, GA, United States
Toptal Member Since
September 1, 2020

Jay is, in a nutshell, a data and reporting guy. He's spent years extracting data out of large enterprise systems, rolling that up into something that makes sense for leaders, and then presenting those numbers in visual ways that allow for faster decision-making. He has served folks in sales, marketing, finance, and operations across several industries including healthcare, manufacturing, financial, and government. Jay's technical specialties include Oracle, SAP BusinessObjects, and Tableau.

Portfolio

ActiveHealth Management
Oracle, Crystal Reports, People Management, IT Project Management...
Genuine Parts Company
PL/SQL, Oracle Exadata, Data Warehouse Design, Data Warehousing...
Novartis
Crystal Reports, SQL, PL/SQL, Oracle

Experience

Availability

Part-time

Preferred Environment

MySQL, Oracle, Linux, Windows

The most amazing...

...thing I've recently done is improve the performance of client reporting by 98%, cutting runtime from 25 hours to less than an hour.

Work Experience

Senior Application Delivery Lead

2014 - PRESENT
ActiveHealth Management
  • Guided Scrum team development efforts and ensured the successful and timely delivery of projects for the provider care management function.
  • Provided design and development deliverables to support project delivery.
  • Developed data aggregation and reporting application components using PL/SQL.
  • Tuned and improved application performance for reporting on a 40+TB data warehouse.
  • Worked with key business personnel to gather requirements and define the direction of enterprise reporting for the organization.
  • Managed the output of a team comprised of 6 – 8 developers.
Technologies: Oracle, Crystal Reports, People Management, IT Project Management, Software Design, Business Intelligence (BI), Data Analytics, PL/SQL, SQL

Manager, Business Intelligence Operations

2013 - 2014
Genuine Parts Company
  • Developed a roadmap for the group that defined team structure, technical scope, roles, and responsibilities, along with core standard operating procedures.
  • Organized capabilities-based teams to provide support and maintenance for the reporting, data integration, and data warehousing layers of the EDW platform.
  • Defined key success metrics for the group to measure the stability, quality, and performance of information and services provided.
  • Built close relationships with leaders across the organization in order to understand their key informational needs and how these could improve business performance.
  • Directed the successful delivery of multiple small-scale business intelligence initiatives in support of larger operational improvements.
  • Managed team of 12 developers, analysts, and administrators.
Technologies: PL/SQL, Oracle Exadata, Data Warehousing, Data Warehouse Design, Business Intelligence (BI), Technical Hiring, IT Project Management, People Management

Manager, Business Intelligence and Data Warehouse Applications

2006 - 2012
Novartis
  • Worked closely with senior executives to set technical strategy in the areas of performance management and sales force automation.
  • Successfully managed a SAP BusinessObjects XiR3 business intelligence transformation project, resulting in the creation of a common platform with standardized reporting for sales, marketing, and finance.
  • Directed the implementation of SAP Business Warehouse 7.0 for the North American business unit, sourcing data from the SD modules in SAP R/3.
  • Coordinated activities of offshore development team personnel during large-scale projects.
  • Managed the ongoing support of an Oracle custom data warehouse, which sourced data from multiple internal and external systems and aggregated several subject-level data marts feeding canned and ad-hoc reporting. Sources included SAP R/3 and Siebel.
  • Managed a team of seven business analysts and application developers during new projects and ongoing support.
Technologies: Crystal Reports, SQL, PL/SQL, Oracle

Co-founder and Lead Developer

2001 - 2009
ScrapbookThis.com
  • Designed and developed a complete custom eCommerce platform for a craft supply retailer, with shopping cart functionality, credit card payment processing, inventory management, and catalog management functions.
  • Implemented dynamic front-end shopping cart functionality to present and categorize thousands of products to site visitors.
  • Advertised the business to customer list through regular email blasts.
Technologies: HTML, Apache, Linux, MySQL, PHP

Consultant

1997 - 2004
Accenture
  • Designed and developed custom, mission-critical apps for state and local government clients. The main solution was built on a three-tier architecture with Oracle Developer Suite, Oracle Internet Application Server, and an Oracle database all on UNIX.
  • Designed technical environments, including infrastructure and application architecture.
  • Planned tasks and managed workload for a team of database administrators and developers.
  • Performed complex data conversions from legacy platforms to the new solution.
  • Monitored and tuned the application databases during all project phases.
  • Worked with key client personnel to collect and document high-level requirements for data warehouse and decision support functional areas.
Technologies: COBOL, SQL, PL/SQL, Oracle Reports, Oracle Forms, Oracle

ScrapbookThis.com

https://web.archive.org/web/20071011013323/http://www.scrapbookthis.com/
I designed, developed, and enhanced a complete eCommerce website for a small craft supply retail business. The site was built from scratch using PHP, JavaScript, HTML, and MySQL on a Linux and Apache platform. The website presented thousands of products and included shopping cart functionality, inventory management, and payment processing.
2008 - 2009

Master's Degree in Business Administration (MBA)

Kennesaw State University - Kennesaw, GA

1992 - 1996

Bachelor of Science Degree in Finance

Indiana University - Bloomington, IN

JUNE 2011 - PRESENT

Project Management Professional (PMP)

Project Management Institute

Tools

Oracle Forms, Oracle Reports, Oracle Exadata, Crystal Reports, Apache

Storage

PL/SQL, MySQL

Languages

SQL, COBOL, PHP, HTML

Paradigms

Business Intelligence (BI)

Platforms

Oracle, Windows, Linux

Industry Expertise

Project Management

Other

Data Analytics, Software Design, People Management, Technical Hiring, Data Warehousing, Data Warehouse Design, IT Project Management

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring