Jerry McClellan

About Jerry McClellan

I am an experienced, accomplished IT professional. Designed/implemented many databases, engineered countless data pipelines, been ‘lent out’ to other LOBs and Technical teams to serve as an expert and help them overcome challenges they could not. For those who know me, or have worked with me, or have heard from others who have, I have become an established go-to individual to help solve the unsolvable problems. I have successfully completed the three-part suite of CFA examinations ( equivalent to a Master’s Degree in Investment Management ). I have worked hand-in-hand with several Data Scientists, helping to improve and enhance their design as part of our ‘productionalization process’. As well as taken hundreds of hours of ‘corporate-level training’ over the years, focusing intently on the realm of Data Science these past few years. I am looking to leverage my broad range of skills and targeted areas of expertise.

Experience

1. Principal Data Engineer

   Fifth Third Bank

   Jul 2015 — Present

   Currently re-engineering our ESRI/Geospatial drive-time calculation process, to increase its throughput by over fold. Saving in hardware and in annual vendor costs, while allowing this critical dataset to be updated quarterly rather than every 2 years. Performed Exploratory Data Analysis and Data Modeling using Python & ESRI GeoSpatial toolsets on bank branches in Chicago region to drive decisioning for Branch Repositioning project. Re-engineered standard Geo-Spatial drive-time data pipeline methodologies, speeding data-access times by over 220x. Saving in server costs while allowing sophisticated/complex data analysis thought impossible/impractical, to be easily accomplished. Leveraging all aspects of Data Analytics, designed/implemented revolutionary customer-focused recommendation engine, now used throughout the bank in all customer interactions. See more here. Helped create a new paradigm for the bank for Data Modeling execution. NIFI/Rest API based with Job auditing, Data Quality metrics, alerts and historical reporting. Table-driven design, allowing nearly autonomous and continuous deployments (CI/CD principles). Converted several EDW & Vendor datasets to Hadoop datalake, including ARGOS (26 Schemas,118k tables, 26.6 TB). This required understanding & converting each system’s data/schema, developing a pipeline between the two (Sqoop/Pig) & resolving PII data obsfucation/tokenization requirements.Played pivotal role converting the Data Science data/schema from Hadoop/Hive to Snowflake MPP DB. Leveraging Snowflake’s JSON capabilities to implement CI/CD functionality into the process.Served on a team of Enterprise Data Architects, developing the Data Strategies and Architecture for the Hadoop-Data Lake schema, leveraging in part the Teradata data model.

Education

• CFA Institute - Chartered Financial Analyst Exams

  Passed all three levels of the Designation testing.

  2009 — 2013

Skills

• Etl
• Data Quality
• Enterprise Architecture
• Data Governance
• Strategic Planning
• Dimensional Modeling
• Database Administration
• Performance Tuning
• Change Management
• Sdlc
• Requirements Analysis
• Business Intelligence
• Machine Learning
• Project Management
• Enterprise Integration
• Business Process Improvement
• Disaster Recovery
• Database Design
• Extract, Transform, Load (Etl)
• Data Warehousing
• Process Improvement
• Data Integration
• System Monitoring
• Data Science
• Itil
• Unix
• Data Modeling
• Itil V3 Foundations Certified