Open to opportunities

Challenor Jack

@challenorjack

Message

Data analyst and engineer with expertise in business intelligence.

United States

Message

What I'm looking for

I am seeking a role that fosters innovation and collaboration, with opportunities for growth.

I am a dedicated Data Analyst and Engineer with a Master’s in Information Systems and extensive experience across financial, consumer product, and online marketing sectors. My expertise lies in business intelligence, database analysis, and application support, where I have a proven track record of delivering projects on time and within budget while maximizing ROI. I pride myself on being a strong leader and collaborative team member, capable of independent work.

In my previous role as a Data Engineer at Renown Health, I oversaw the entire data engineering lifecycle, translating user requirements into technical architecture and implementation plans. I have successfully designed the Enterprise Data Warehouse and developed innovative data pipelines that integrate and normalize extensive data from various sources. My previous experience as a Senior Business Intelligence Analyst at Wellen Capitol involved building an in-house data warehouse and implementing machine learning techniques to enhance business operations, demonstrating my ability to leverage data for strategic decision-making.

Experience

Work history, roles, and key accomplishments

Current

Data Engineer

Current

Renown Health

Jul 2022 - Present (3 years)

Oversaw the data engineering lifecycle, including research, architecture, design, development, testing, deployment, and maintenance. Designed the Enterprise Data Warehouse and Data Management Centers (DMCs) on Caboodle Epic Systems for Epic and non-Epic data.

Data Warehouse Power BI PaaS IaaS SaaS ETL Processes SQL Data Pipelines

Senior Business Intelligence Analyst

Wellen Capitol

Jan 2018 - Present (7 years 6 months)

Built an in-house Data warehouse and implemented machine learning/predictive analytics. Developed and managed ETL processes to incorporate the Wellen data warehouse and build other stand-alone datamarts.

Data Warehousing Machine Learning ETL Tableau Data Modeling Business Intelligence SQL

Data Architect Analyst

Loyola University

Apr 2013 - Present (12 years 3 months)

Oversaw the onboarding of the data warehouse within the University and designed the architecture for all data warehousing components. Led the development of reports and dashboards, and supported Tableau reports.

Data Warehousing ETL Tableau Business Intelligence Data Modeling SQL

Application Support Analyst

Newedge USA, LLC - Global Multi-Asset Brokerage Company

Jun 2008 - Present (17 years 1 month)

Provided technical services as a second-line support for the company’s global trade load systems, database processes, and software applications. Troubleshot complex SQL views, stored procedures, SQL jobs, and SSIS packages to identify and resolve trade failures.

Application Support SQL SSIS Unix Windows Troubleshooting Technical Documentation System Monitoring

Product Specialist III Third Line Support

Kaplan University

Oct 2007 - Present (17 years 9 months)

Provided technical support for university portal Systems, including problem analysis and resolution. Built reports for business evaluation using Crystal Report and/or Microsoft Reporting Services.

Technical Support Crystal Reports Ad Hoc Reporting

Reporting Analyst

Dotomi Inc. – Online Ad Media/Marketing

Nov 2006 - Present (18 years 8 months)

Managed all Microsoft SQL Reporting Systems (SSRS) and created DTS packages and jobs. Developed reports that provided the sales management team with pertinent data to grow the business.

Microsoft SSRS T SQL Stored Procedures Data Mining Sales Reporting

Data Analyst/Data Warehouse Analyst

Information Resources Inc. - Consumer Product Goods

Dec 2004 - Present (20 years 7 months)

Developed data quality reports using MS SQL 2000 Reporting Services (SSRS) and Cubes. Created DTS (SSIS) packages within Enterprise Manager to process audited data with a focus on data quality.

Data Quality Data Warehousing Ad Hoc Reporting

Education

Degrees, certifications, and relevant coursework

DePaul University

Master of Science, Information Systems

Grade: 3.67 GPA

Completed a Master of Science in Information Systems, focusing on business intelligence, database analysis, and application support. Gained expertise in data warehousing, data mining, and enterprise systems.

DePaul University

Bachelor of Science, Computer Science, Data/Database Analysis

Obtained a Bachelor of Science in Computer Science with a specialization in Data/Database Analysis. Studied core concepts including database programming, administration, and data warehousing.