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 & development and support of production jobs and coordinating with Data Visualization and Data Science teams to troubleshoot pipelines and or add features. Function as a SQL and data transformation SME to assist more junior team members or warehouse partners.• 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• data analysis & wrangling for Product team• performance optimization of SQL• work with Data Governance team to ensure adherence to standards and maintain META dataOracle 19, PL/SQL; AWS Console, S3, Redshift / PostgreSQL, Glue, Postman; Java, IntelliJ, Python, Git /

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. Responsibilities include analysis, solutioning, development, and testing. Tools include Oracle, Actuate, Tableau, JIRA, and Service Now.

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 dashboard delivery time by 6x, supporting cloud computing and mobile usage, and enabling self-service dashboarding and reportingo Transitioned BI delivery from waterfall to agile and BI team to managed service/staffing partnero Championed selection of Power BI to support cloud-based and mobile supported BITools: Qlikview; Microsoft SQL Server, SSIS, Management Studio, Visual Studio, Visio, Excel, VSTS, TFS, Sharepoint, Power BI, Data Gateway, On-premise Power BI Report Server, JIRA, ServiceNow, IISo Developed 2020 Vision for Agile Business Intelligence & Analyticso Developed plan and proposal for Qlikview to Power BI Migrationo Developed plan and proposal for migrating the data warehouse to the Azure cloudo Developed plan and proposal for building-out Power BI platform for BIo Planned and led development of new Power BI-based reporting capabilityo Planned and led development of a net asset value calculation engine and accounting system for Reinsurance contractso Solution architect for all Qlikview, Power BI, and data warehouse applicationso Managed transition of production support to InfosysTools: Microsoft SQL Server, SSIS, IIS, Qlikview, Power BI

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 capacity management DW and reports identifying KPI and utilization anomalies and trends that helped resolve problems and prevent performance degradation and outagesTools: Microsoft SQL Server, T-SQL, SSIS, Management Studio, Visio, Excel, TFS, Sharepoint, Actuate, SAP BOEXI, ServiceManager, ServiceNow, IBM BPM, IBM ODM, IIS, Apache Tomcato Migrated Capacity Management DW from Microsoft SQL Server 2005 to 2008o Built-out Operational Decision Management (ODM) platform and onboarded first applicationo Built-out Business Process Management 8.5.5 (BPM) platform and onboarded first applicationso Built-out the Business Objects XI 3.1 environments, managed the migration to BOXI 3 of 100s of applications across 60+ development teamso Built-out the Actuate 11 reporting environments and led 6 development teams through the upgrade from Actuate 10o Led the Morgan Stanley – Smith Barney lift and shift of customer reporting applicationsTools: Actuate, Microsoft SQL Server, SAP Business Objects, SAP BOEXI, IBM BPM, IBM ODM

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 BI/DW governance which reviewed and approved artifacts for all phases of the SDLC ensuring compliance with audit, release management, and SDLC policieso Created a SQL optimization and performance benchmarking process and reviewed SQL optimization/benchmark results to prevent performance degradation & outages o Transitioned BI team from local consultants to outsourcing partner with on and offshore resourceso Proposed a DW/DM architecture and flow that would result in ‘a single truth’Tools: Sybase ASE, T-SQL, Oracle, PL/SQL, ERWin, Embarcadero, TOAD, Informatica, Visio, Excel, Sharepoint, ServiceManager, ServiceNow, C, Java, Actuate Enterprise Reporting, Cognos, IIS

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 1000x faster and scalable to forecasted transactionsTools: Sybase ASE, T-SQL, ERWin, Embarcadero, Visio, Java, Actuate Enterprise Reporting

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 development more than 10x. Framework was installed at multiple clients and pirated by otherso Key Customers: Goldman Sachs, Chase Manhattan, JP Morgan, JP Morgan Chase, Deutsche Bank, Merck, Pfizer, Unisys/Sperry, Medco Health Solutions, RemedyTools: Sybase ASE, T-SQL, Oracle, PL/SQL, Informix, Teradata, DB2, MySQL, SQL Server, ERWin, Embarcadero, TOAD, Visio, SQL, PowerBuilder, Actuate Enterprise Reporting, Java, IIS

Bachelor’S Degree, Management Information Systems & Business Analytics

Masters Certificate, Is/It Project Management

Master'S Certificate In Applied Project Management