Greg Coe Email & Phone Number

Texas, United States

Dallas, Texas, US

• Member of Data Engineering team ingesting data from 3rd party sources and clients, constructing pipelines to populate dimension and fact tables for presentation in Tableau. Primary responsibility of pipeline design &.
• analyze / create / enhance / troubleshoot dbt PL/SQL packages and Snowflake SQL scripts
• create and run dbt Cloud jobs to extract, transform, and load data
• unit / QA / UAT testing to verify data
• data analysis & wranglingSnowflake, Redshift, BigQuery, dbt, AWS Console, S3, Visual Studio, Data Grid, GitHub, JIRA, Metaplane

Dallas, Texas, US

New York, NY, US

• Member of Global Reporting team and Data Engineering team providing daily reports and data feeds to JPMC credit card payment processing merchants
• analyze / create / enhance / troubleshoot Oracle PL/SQL packages and SQL scripts
• create / enhance / troubleshoot AWS Redshift / PostgreSQL tables and SQL scripts
• create and run AWS Glue jobs to extract, transform, and load data
• create / enhance JSON for delivery to merchants via API and reports
• unit / QA / UAT testing to verify data

New York, NY, US

Tech Lead at JP Morgan Chase Merchant Services for Global Reporting Application. Currently, working on a project to migrate and decommission a legacy reporting solution to a new solution based on Tableau. Responsibilities include enhancement and rotational production support for the Actuate based legacy system and migration of reports to the new system..

Direct, lead, and mentor BI/DW team; data/solution architect; data modeler/analyst; project manager o Assessed the Qlikview BI/DW solution and solved poor performance and scalability limitationso Proposed a BI/DW vision, strategy, roadmap, and solution that would reduce the BI operating cost by $1m annually while improving performance 10x, accelerating.

New York, NY, US

Direct and lead engineering teams; solution architect; project manager; product owner o Rescued lift & shift of BI systems from Smith Barney to Morgan Stanley that preserved the on-time go-live and prevented a cost overrun of millions.o Data modeled an archiving database and designed the archival application that eliminated system outageso Constructed.

Tokyo, JP

Direct, lead, and mentor BI/DW team; solution architect; data architect; project manager; service manager o Performance optimized dozens of T-SQL stored procedures to be more than 100x faster and stabilized Sybase ASE reducing resource utilization by more than 60% - preserving scheduled go-live data and preventing a cost overrun of millionso Established.

New York, New York, US

Lead portfolio reporting team; data modeler; data analyst; BI/SQL developer; business analysto Elicited requirements, data modeled backend, and developed customer portfolio dashboards and reportso Built framework to standardize presentation and functionality, improve quality, accelerate development 10xo POC’d pricing database in SAP/Sybase ASE that was.

BI/DW solution and data architect; data modeler; system Integrator; trainer; SQL/BI developero Introduced Goldman Sachs to Actuate Enterprise Reporting and POC’d portfolio reports leading to adoption of Actuate through Wall Streeto Built Actuate reporting framework that added key features, standardized presentation & functionality, and accelerated.

Bachelor’S Degree, Management Information Systems & Business Analytics

Masters Certificate, Is/It Project Management

Master'S Certificate In Applied Project Management