Jay Carroll, Data Warehouse Design Developer in Suwanee, GA, United States
Jay Carroll

Data Warehouse Design Developer in Suwanee, GA, United States

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.
Jay is now available for hire

Portfolio

Experience

Location

Suwanee, GA, United States

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.

Employment

  • 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 Warehouse Design, Data Warehousing, 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

Experience

  • 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.

Skills

  • Languages

    SQL, COBOL, PHP, HTML
  • Storage

    PL/SQL, MySQL
  • Tools

    Oracle Forms, Oracle Reports, Oracle Exadata, Crystal Reports, Apache
  • 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

Education

  • Master's Degree in Business Administration (MBA)
    2008 - 2009
    Kennesaw State University - Kennesaw, GA
  • Bachelor of Science Degree in Finance
    1992 - 1996
    Indiana University - Bloomington, IN

Certifications

  • Project Management Professional (PMP)
    JUNE 2011 - PRESENT
    Project Management Institute

To view more profiles

Join Toptal
Share it with others