John Ashby Email & Phone Number

Charlotte, Nc, Us

Fulton, Maryland, Us

Richmond, Virginia, Us

Design and implementation of serverless architectures utilizing AWS for maximum performance and uptime.Development of ingestion pipelines utilizing PySpark/Glue in tandem with various orchestration platforms (Airflow, AWS Step Functions/Glue Workflows, etc)MLOps/DevOps pipeline design and implementation, including data quality and PII remediationDatabase management and versioning utilizing various technologies (Postgres, SQL Server, Dynamo, Liquibase, dbUp)RESTful API implementations making use of AWS API Gateway and LambdaInfrastructure management across multiple environments utilizing TerraformLeadership of diverse teams in service to our clients within various forms of Agile SDLCs (Scrum, Kanban, etc)

Architecture and implementation of data pipelines within an intense regulatory environment.Data modeling, mapping, and validation in service of ETL pipelines within a bespoke SSIS framework and its downstream reporting requirements (SSAS, Power BI).Integration of data from a myriad of sources, including Oracle, SQL Server, Azure, DB2, and MySQL.Data warehousing design and extension utilizing temporal table functionality for historical data.Design and implementation of master data management hub components in service of the organizational MDM strategy, helping to eliminate unnecessary integration workloads.

Dresher, Pa, Us

Design and development of data delivery systems across multiple architectures in a fast-paced, market-driven enterprise.Creation of ETL/ELT data pipelines at terabyte scale for purposes of analysis and presentation of timely market data.Development and implementation of schemas utilizing erwin Data Modeler.Maintenance and extension of reporting environments utilizing SSRS, SSAS, Crystal Reports, Business Objects, and Power BI. Extension of capabilities of monitoring systems (JAMS, Spotlight), and dashboard/alert development to enable immediate identification of performance or data quality concerns.Responsible for 24-7-365 availability of OLTP databases (Always-On, clustered, synchronized SQL Server 2016+ environments utilizing change data capture) and data warehouses for OLAP, including rigorous on-call requirements to meet required 99.9% yearly uptime requirements.Incident response and post-mortem analysis for cybersecurity incidents.Creation and maintenance of build scripts for a continuously-integrated DevOps environment using Team Foundation Server (TFS) and Powershell.Participation on multiple Agile teams with independent objectives and demanding project timelines.

Cincinnati, Oh, Us

Ownership and delivery of robust data solutions on multiple cloud-based platforms in a customer-facing role with intense delivery schedules.• Creation of beautiful, engaging reports and dashboards to visualize crucial data with leading technologies (Power BI, Tableau). Architecture and implementation of Looker data models - an emerging technology recently acquired by Google.• Solution architecture and implementation of data warehouses, data marts, and ETL pipelines across multiple platforms (Google Cloud, Azure, etc).• Architecture and implementation of data warehouses and OLTP databases using erwin Data Modeler in combination with SQL Server/Azure/MySQL/BigData.

Tokyo, Jp

Lead subject matter expert for credit-related research and resolution of anomalies within enterprise credit/retail analytics.• Development of Oracle BI reports to support deep-dives into massive datasets.• Discovery and remediation of critical security lapses related to Apache Struts implementations across the bank.• Usage of Oracle and Teradata SQL to directly remedy issues as they arose.• Owned and delivered custom reporting solutions across the Credit and Retail spaces.

Responsible for delivery of projects related to Ally’s monitoring and reporting applications for Deposit Ops and Dealer Financial Services.• Primary Tealeaf SME responsible for delivery of the monitoring strategy for Ally’s next-generation mobile application and authentication platform.• Design and implementation of multiple integrated ETL pipelines utilizing SSIS, merging data streams from varied sources including Oracle, SQL Server, Tealeaf, and Splunk.• Architecture and deployment of schemas for data warehouses utilizing erwin Data Modeler in a SQL Server 2016 environment.• Front-line response and investigative principal during cybersecurity incidents impacting bank operations, including configuration and utilization of Splunk forwarders, Tealeaf instances, and system logs from various sources to identify and address avenues of attack.• Utilization of Splunk, Akamai, and SiteCatalyst for enhanced customer analytics, issue triage, and intrusion detection/prevention; working with cybersecurity teams to enhance Ally’s responsiveness to threats.• Successfully managed Ally’s disaster recovery efforts for 2016 with zero downtime in an always-on, high-demand, and constantly scaling environment involving multiple third parties.

San Francisco, California, Us

Subject matter expert (SME) for several applications: Swap Data Repository, Regulatory Reporting, Portrec, and Enconnect, as well as configuration of host systems to be used within the Unix/BoKS environment.Data analysis requiring knowledge of various systems and methodologies within the multi-billion dollar securities space. Troubleshooting issues with derivatives/swaps of multiple types (equities, interest rate, credit, commodities, foreign exchange), requiring familiarity with the unique reporting requirements of agencies in each category.Installation and configuration of BoKS agents on a variety of Unix systems utilizing Solaris / HP-UX / Red Hat.Primary point of contact during cybersecurity incidents impacting securities systems, working to identify attackers and harden systems and software. Implementation of ITRS monitoring agents, and creation of high-quality dashboards to streamline the complex task of ensuring uptime across the bank’s vast infrastructure.

Charlotte, Nc, Us

As the Senior Data Engineer for multiple applications within the Global Funding space, coordinated and executed complex plans for software releases, disaster recovery, and regulatory compliance.Gathering data and ensuring regulatory compliance for applications under strict federal scrutiny.Coordinating resources and timeframes in order to maximize system uptime and functionality.Documentation of all processes and tracking of issues as they arise until resolution.Creation of high-quality documentation and conducting training for users.

San Francisco, California, Us

As an Application Support Engineer with Wells Fargo, I was primarily responsible for the development and maintenance of the Combined Profitability Data Store (CDS), with additional work focused on the transition to the future system-of-record known as ProfitView.• Served as the primary point of contact for any and all questions involving CDS data, which is the current SOR for all of Wells Fargo profitability reporting.• Developed automation of ETL operations utilizing SSIS in a hybrid environment that utilizes SQL Server and Oracle.• Created BRDs/FSDs related to the long-term ProfitView project.• Analyzed system defects to ensure complete accuracy of financial data.

Charlotte, Nc, Us

This position involved the development and support of the Basel regulatory and economic capital calculators, a complex series of applications that are used by Bank of America to maintain regulatory compliance and analyze individual lines of business (LOBs) according to adjustable criteria.• Created, optimized, and queried databases in both the Oracle and Teradata environments (DDL, DML, ETL).• Authored, and deployed MLOAD scripts, shell scripts, and other code according to the dictates of a rigorous SDLC.• Managed Subversion (SVN) repositories and source code to ensure auditory compliance.• Maintained HP Quality Center ticket queues and defect reporting.• Triage of production issues in a high-pressure, results-oriented environment involving billions of dollars of assets and liabilities.

Neunkirchen, North Rhine-Westphalia, De

Bootstrapped and managed a talented team of technical support engineers based across the United States for a large multinational starting up its North American line of business.• Lead a team of 8 responsible for remotely supporting warehouse management systems (WMS) in a dozen locations, with customer site revenues exceeding $500M.• Delivered solutions across a variety of platforms/languages including Oracle, SQL Server, MySQL, Unix, Windows Server, and Teradata.

Scottsdale, Arizona, Us

In this position I was responsible for the technical support of the DLx Dispatcher application for over 30 large corporate customers at nearly 100 sites. I was a contributing member of a flexible support team that frequently assisted the software development team in the performance of their duties.• Opened, resolved, and cloed support calls in a 24/7 on-call support environment.• Researched issues via testing and/or verified the functionality of application code.• Generated custom reports using data from production systems and customized data warehouses, and analyzed this data using OLAP technologies (Business Objects).• Data export, transformation, and import (ETL) on Oracle Enterprise databases, as well as the creation of complex SQL and PL/SQL scripts to assist in data migration. • Analyzed database statistics in order to suggest architectural or configuration improvements (indexes, temporary tables, tablespace analysis, I/O).• Coded and tested PDR/SCRs for bug fixes and customer upgrades.• Controlled those changes via CVS and documented all work.• Monitored all customer systems to ensure 100% uptime.In addition to these responsibilities, I managed several projects related to the implementation of the WMS at various locations. I assisted in the implementation of our software at several customer sites and participated in the requirements gathering, creation, and completion of statements of work (SOWs). I have participated in the full software development cycle, from the origination of the SOW to the implementation of the requested features on-site.

In this position I was responsible for the support, maintenance, and development of an online pricing system. This application is the centerpiece of an Internet-based marketing strategy which delivers market analysis to hospitals across the country. I was the primary support for over 150 end-users as well as the primary administrator of the database which houses the information.I utilized Microsoft SQL Server 2005, Access, and Visual Basic to analyze, import, and extract information both to and from this data store. Heavy usage of Monarch was required to prepare data files for import. A functional knowledge of ASP.NET was also necessary in order to help troubleshoot issues with the application.

Charlotte, Nc, Us

My primary responsibility in this position was the development and support of applications in a fast-paced financial services environment. In addition to developing applications, I was responsible for supporting over 300 end-users on a wide suite of applications ranging from Microsoft Office products to industry-specific enterprise software. I regularly served as a backup to the System Administrator and Senior Business Analyst.I utilized Visual Basic .NET/6.0, Microsoft Access, and Microsoft Excel to design and implement desktop tools. The applications have solved problems ranging from scheduling and workflow to reporting needs. These applications are highly automated, accept a wide range of data from multiple systems and users, and provide management with customized interfaces for reporting. System requirements and program code were documented and have been utilized for upgrades as the business needs have changed.

Bachelor'S, Information Systems

As, Computer Technology