Chris Charles Email & Phone Number

Schaumburg, Illinois, Us

Paylocity's all-in-one software platform gives HR pros a way to easily manage daily tasks in payroll, benefits, talent, and workforce management.I am a Staff Data Engineer at Paylocity, responsible for the design, development and maintenance of data pipelines using Python, Apache Airflow, Snowflake, dbt, AWS and PySpark. I am also responsible for defining and enforcing coding standards, creating unit tests and CI/CD pipelines, and mentoring engineers.

San Francisco, California, Us

Brightwheel is the fastest growing and top reviewed product in early education - a $100B US market.I was the Staff Data Engineer at brightwheel, responsible for the design, development and maintenance of the company's Redshift Data Warehouse. I maintained and used Apache Airflow within our Kubernetes cluster and locally via Docker. I created our cloud infrastructure using AWS Cloudformation. I designed and populated our Data Warehouse via Airflow dags and dbt models. I documented our data infrastructure, set coding standards, created unit tests and CI/CD pipelines, and mentored engineers and data analysts.

Mclean, Virginia, Us

For over a century, Mars has been one of the world’s leading manufacturers of confectionery and pet food.I was the Senior Data Engineer on the Advanced Machine Learning team at Mars. The main project I worked on was to enable the global traceability of a single Mars product from the point of sale all the way back to the farmers who provided the ingredients to make that product. I was also heavily involved in documenting best practices for Python / Spark development.

Traverse City, Mi, Us

Hagerty is an insurance company that is the global leader in collector car insurance.I was a Senior Data Engineer at Hagerty, specializing in Apache Airflow, Cloud Data Engineering and Master Data Management. My initial focus was to help establish the Apache Airflow pipeline infrastructure, including Python functions for commonly used pipeline functionality, custom Airflow Operators for common pipeline patterns, Amazon AWS cloud infrastructure, unit and integration tests, and documenting best practices and coding standards. After the basic pipeline infrastructure was established, I created data pipelines with Airflow, populating a Data Lake in Amazon AWS and a Data Warehouse in Snowflake. I also helped establish the company's Master Data Management system. My role at Hagerty included overseeing the design for new pipeline projects, reviewing code to ensure it meets our standards, and mentoring engineers.

New York, New York, Us

BabyCenter is the #1 pregnancy and parenting digital destination.• Worked as part of cross-functional teams to develop, refine, and scale data management and analytics systems.• Worked closely with internal teams to help define problems and design solutions to derive insights from our data.• Built and maintained processes to clean, move, load, and summarize data. • Designed and maintained automated processes for summarizing data for a wide variety of internal teams.• Built and automated data processes using tools like Apache Airflow and AWS. • Built and maintained internal data applications using Python.

New York, Ny, Us

An online flash-sale retailer specializing in home decor with over $200 million in annual revenue.• Responsible for the design, development and maintenance of the Data Warehouse and Big Data platforms.• Assisted in the development of new ETL Jobs integrating multiple data sources.• Wrote efficient Python and SQL from business requirements.• Wrote integration scripts for pushing data from HBase to Hive and then on to Vertica.• Wrote Oozie XML scripts for Hadoop workflow scheduling. • Wrote Pig scripts to transform HDFS data and store in Hive tables.• Maintained and tuned the Vertica database.• Worked closely with business analysts for data acceptance, change management, and ensure quality.• Provided advice and guidance to the various teams working with data and searching for insight.

San Francisco, Ca, Us

A multinational software corporation making software for architecture, engineering, construction, manufacturing, media and entertainment industries with $2.2 billion in annual revenue. • Directed data integration from SQL Server and Oracle databases (Siebel, SAP and Salesforce) into ODS, Data Warehouse and revenue-focused Data Mart by utilizing Informatica Power Center.• Introduced critical, high-visibility Industry-related metrics into Data Warehouse, Data Mart and downstream Business Object Universe to streamline how company reports revenue. • Platform Lead for Microsoft Master Data Services (MDS) technology, establishing standards for design and development, (including use of design patterns and web services), deployment, administration, governance and training materials for end-users. • Managed and executed projects for Customer/Account Master Data Management (MDM) system, Siebel Universal Customer Master (UCM) by performing integration of source systems with UCM and data cleansing software, Trillium. • Conducted performance optimization of UCM database through data cleansing initiatives.

San Francisco, Ca, Us

An online content network for information and entertainment with several websites covering news, sports, entertainment, technology and business generating $600 million in annual revenue. • Led entire ETL process through analysis, design, coding, testing, implementation and troubleshooting initiatives. • Developed and resolved data integration challenges in Data Warehouse with innovative ETL design in both batch and near real-time environments.

San Jose, Ca, Us

An Internet-based image publishing service known for its photo book line, the flagship product. • Designed and developed mission-critical Marketing and Finance-related analytic Data Warehouses and Data Marts utilizing the Agile Scrum methodology. • Collaborated with business end-users on analysis requirements and ensured requirements were met throughout entire projects. • Executed projects for Marketing Campaign Management Systems while verifying compliance with current Sarbanes-Oxley standards. Technologies used: Oracle, Informatica Power Center, SQL Server, Perl, Unix (Bash) shell scripts, and PL/SQL for ETL processes, and Cognos, SQL, and PL/SQL for Business Intelligence reporting. We used the Rally application in conjunction with JIRA and Perforce for coordinating the Agile methodology and implementing version control.

A biotechnology company focusing on genetic sequencing and related technologies. • Completed design/implementation of a Data Warehouse using PL/SQL and Java scripts embedded in an Oracle database. • Led engineering team as a senior designer/developer of a LIMS system for controlling fifty Polymerase Chain Reaction (PCR) machines running in parallel to integrate a Plate Tracking module into LIMS using customized ActivityBase software. • Accessed data within LIMS by designing and implementing Oracle schemas and writing Java applications to implement Bioinformatics algorithms. • Authored Visual Basic programs to control Plate Cranes and feed plates to dispensing and PCR machines.

A software company whose products aid the drug development process.• Lead designer / developer of a Data Warehouse utilizing the star schema model of Oracle 8i Enterprise Edition. • Designed and implemented the Oracle database for the company’s High-Throughput Assay Screening application – ActivityBase.• Trained new developers and consultants to show them how to create, customize and maintain product databases. • Wrote many programs, utilities and sub-modules using Microsoft Visual C++. • Modularized ActivityBase code using static and Dynamic Link Libraries (DLLs), reducing the size of the application and allowing shared access to standard functionality.

Data Warehousing & Business Intelligence

Nanodegree Program, Data Streaming

Java Programming, Project Management, Technical Communication

Bsc Honors, Computer Science