Jon Farber Email & Phone Number

Derby, Ks, Us

Derby, Ks, Us

Wichita, Kansas, Us

- Created Prospect Sales pipeline for client that involved prospective clients sending on average 13 files, which averaged 980,000 records combined. This data would be undefined and would be cleaned and processed through Azure Data Factory and a Spark Notebook to be loaded into data warehouse. Allowed client to improve turnaround time on process by 80%.- Built ground up data warehouse for non-profit customer, using Fivetran for data ingestion from 7 different source systems and moving data Snowflake and then using DBT to combine the data in star schemas for use by analysts which allowed for timely and consistent reporting on key metrics.- Maintained Legacy on premise MS SQL Data Warehouse including SSIS Packages.- Led cross functional teams in creating scalable, maintainable data architectures that support analytics, with a focus on delivering data models that adhere to Kimball best practices.

Wichita, Ks, Us

- Orchestrated end-to-end data pipelines using Azure Storage Containers, Azure Synapse Dedicated SQL Pool and Azure Data Factory, integrating various data sources and processing workflows for streamlined data operations.- Designed and implemented data models/warehouse in Snowflake using DBT (Data Build Tool).- Technologies used: Azure(Blob Storage, Functions, Synapse, Data Factory, SQL Server, Key Vaults, Automation Accounts), MS SQL Server, DuckDB, DBT, Python, Snowflake, and SQL

3801 S Oliver St, Wichita, Ks, Us

- Built and maintained data pipelines from multiple source systems(SAP, MES Systems, Safety) into the HANA Data Lake, creating data models to meet business requirements and supporting dashboard creation for stakeholders.- Developed a Python-based application to automate data migration within the Data Lake, increasing the efficiency of promoting data from Development to Production environments.

Wichita, Kansas

- Designed and developed full stack Python web application with a combination of Flask and FastAPI backend to serve reports and dashboards on business-critical data. - Responsible for maintaining and updating legacy codebase of over 100 applications developed in Java, Delphi, Go, HTML/CSS/Javascript, and Python

3801 S Oliver St, Wichita, Ks, Us

- Developed end to end solution that brought labor clocking data from source SAP system, transformed and modeled it and then visualized it using a Tableau dashboard that gave floor managers capability to in near real-time see what their employees were clocking labor to.- Developed foundational skills in data pipelines, data modeling, and reporting that later evolved into advanced data engineering capabilities in cloud environments.

Wichita, Kansas, Us

- Implemented HANA system for reporting for increased capability and efficiency- Served as IT Business Partner for Human Resources group. Met regularly with HR partners to discuss ongoing and upcoming projects, pain points, and provide solutions. -Led search for solution to Organization Charting needs for company to alleviate excessive manhours spent with Visio and Power Point. Installed, setup, and maintenance of Org Publisher software and production of Span of Control, Headcount, and Talent Charts to meet user needs.- Served as key knowledge holder of Business Warehouse info during integration of Beechcraft and Cessna. Met with business to gather reporting requirements and then developed a solution in either SAP Business Objects or Qlikview to meet their needs. - Monitored nightly data loads and remediated any issues.- Spearheaded Warranty Financial Reporting project to bring in all warranty and related financial data and build reports needed by business off that data.- Created multi-tiered training course for users of Web Intelligence reporting tool. Created training documentation and led over 30 classes.-Designed and implemented standardized format for reporting, coordinated 130 reports to meet requirements.- Designed and implemented multiple data streams and end user Qlikview Dashboards in various business areas. (i.e. Compliance, Aftermarket)- Met with customers to gather and document requirements, works with programmers when additional modifications are needed. Create and distribute reports based off requirements.- Daily use of Web Intelligence and BEX Queries to pull data and create ad-hoc reports.- Corroborated with Sales team to create a database that allowed tracking of key sales metrics relating to customers, regions, and materials sold.- Designed database used for tracking and improving backlog data. - Worked with sales team members to define reports needed and then extracted necessary data.

Setup, maintained, and troubleshooted any issues with technological devices for the school. Assisted staff and students with use of technology.

-Selected as lead programmer and liaison for unit’s forward operating location— served as central point for training and education of radar performance and evaluation software—mission performance up 25 percent-Researched and employed design methodologies correcting legacy software program deficiency— reduced equipment and time required for radar performance testing and analysis by 53 percent-Chosen as program manager for outdated software application—initiated action to rejuvenate application operations in compliance of military program standards—maintenance efforts decreased over 75 percent-Led development efforts to implement automated test software—reduced testing time by 65 percent-Developed Visual Basic application that allowed visual display of radar analysis software—allowed for user friendly modifications to radar data displayed.

Bachelor Of Science, Computer Operations Technology

Associate Of Arts (A.A.), History