John Kouch Email & Phone Number

• Architected and implemented Airflow DAG management framework enabling complex workflow logic and actionable alerting.• Designed data pipeline that automatically handles file structure changes; eliminating the need for manual updates and configurations. • Lead developer in developing ETL pipeline using Python, Airflow, Glue and AWS Lambdas; enabling quick onboarding of 1,000+ customers.• Subject-matter-expert with several critical services, training teammates as appropriate to reduce knowledge silos.• Optimized SQL queries, indices and data structures for performance and scalability.• Maintained infrastructure as code (IaC) with Terraform, Docker and Jenkins.

Oakland, Ca

• Designed and developed technical infrastructure to Extract, Load, and Transform data from ODBC, flat files, API and other sources into SQL Server databases; leveraging SQL Agent, SSIS, Python and T-SQL procedures.• Designed data warehouses, based on Kimball’s dimensional modeling techniques, flexible enough to adapt to complex and varied customers’ needs.• Fully separated the development and production database environments. Established code conventions, review and QA processes for new code before deployment to production systems.• Set up monitoring and alerting processes against key services to protect against failures and downtime.• Led the initiative to version controlling the company’s ETL code in Git, culminating in automated deployment of code to development and production databases.• Led a team of 8 SQL developers and database administrators; responsible for onboarding, training, evaluations/reviews and professional development.• Worked closely with the sales, customers, and support teams to ensure that our products continually adapted to meet and exceed customers’ expectations.

Oakland, Ca

• Developed ETL processes for several core data systems (PowerSchool, Infinite Campus, Illuminate, etc.) used by schools nation-wide.• Reduced the time and effort to set up a new customer (accounts, database, backup schedules, etc.) by over 75% by developing scripts to automate much of the work.• Overhauled the security and permission infrastructure for both internal and external SQL accounts; increasing security, auditability, and transparency.• Designed interactive data dictionaries for the data warehouses to aid in customer training, support, and documentation.• Trained both internal and external audiences on SQL, Tableau and Python

Newark, Ca

• Enabled data-driven decisions by developing actionable QlikView dashboards used by the team worldwide.• Documented the team’s core ETL processes, discovering and resolving data quality issues and bugs during the process.• Maintained and improved Excel and Access based reports, focusing on enhancing technical infrastructure and code base to increase sustainability of report generation.• Redesigned, automated and improved legacy processes using VBA, SSIS and QlikView scripts.

Oakland, Ca

• Full stack ETL developer; responsible for all stages from data ingestion to report delivery.• Served as technical lead on projects such as improved data quality efforts and new system evaluations / implementations.• Conducted business and technical needs assessments with business owners in order to support a variety of initiatives.• Developed an expertise with Tableau, designing actionable dashboards and providing technical support to other report builders.

Oakland, Ca

• Designed and implemented sustainable solutions for large recurring data requests, resulting in annual savings of 100+ hours. • Collaborated with the DBA to develop the organization’s first data warehouse, based on Kimball’s methodology of dimensional modeling. Data warehouse provided to users both as OLAP cubes and SQL views built from the underlying star and snowflake schemas.• Worked on all stages of the data warehouse development lifecycle: gathering requirements, data structure design, development of ETL (Extract Transform Load) processes, and ongoing support.• Developed automated processes utilizing SSIS and T-SQL stored procedures to integrate data across key systems, simultaneously increasing data quality and eliminating the need for manual entry. • Designed actionable Tableau and SSRS data quality reports that are used daily by office managers.• Provided multiple levels of support (troubleshooting, analysis, ad-hoc data extract/reporting) to the entire organization.

San Francisco, Ca

• Served as the project lead in document collection and production efforts. Responsibilities included ensuring that deadlines were met while a high quality of work was maintained at all times.• Trained and mentored new staff members. Created documents describing and illustrating project processes to be used in training sessions and transitions.• Designed detailed progress tracking reports to monitor project schedules and identify potential problems well in advance.• Oversaw the day-to-day operations of projects in addition to maintaining budget sheets and managing relationships with clients/vendors.

San Francisco, Ca

• Developed tools, scripts and procedures to increase overall productivity of projects. • Planned and led both internal and external training sessions. Created several guides and instruction manuals for internal and third-party software.• Developed custom Access applications to streamline tasks such as data collection and document review.• Executed project tasks such as data analysis, vendor research, and preparation of reports and documents.• Provided technical advice and expertise to colleagues across the organization.