John YADI
Minneapolis,MN
Summary
Self-motivated Data professional with 8 plus years of experience in warehouse data management and Cloud Engineering. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems and business improvement processes. Bringing comprehensive understanding of warehouse operations and documentation needs.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Data Architect/Engineer
Hilton
09.2022 - 01.2024
- Oversaw the migration of the Legacy Hilton Hotel Management System called GRO to Redshift and designed the data migration strategy.
- Leveraged AWS EMR for migration of vast data volumes across various AWS data repositories like Amazon S3 and Amazon DynamoDB during QA migration phase.
- Utilized Pandas API for organizing data into time series and tables, facilitating data manipulation and retrieval.
- Oversaw the Managed quality reference data, ensuring integrity and relational database maintenance during the transition to redshift.
- Researched and recommended new cloud technologies and services, resulting in the adoption of AWS CloudWatch that improved Hilton infrastructure visibility.
- Worked with the data architects team to develop AWS S3 Security Framework with Lambda and DynamoDB for granular access for third party applications.
- Architected and modeled new data landscape in AWS services like EMR, Redshift, and S3.
- Analyzed tools for adoption such as Jenkins to improve the hilton DevOps and Continuous Integration/Continuous Deployment process.
- Collaborated with Business Stakeholders including Vice President and Senior Directors to define data requirements for migration.
Senior Consultant
Cognizant
09.2021 - 09.2022
- Led day to day stakeholder and client meeting collecting and gathering business requirements for the duration of discovery phase of the project
- Managed, mentored, and led junior consultants , as well as providing training to client and demos on the new application
- Created current and future state technical diagrams using Visio of the legacy application which was presented to all McDonald's stakeholders
- Led a Cognizant POC for the SaaS application PIM, to replace the legacy nutrition system MERLIN
- Performed data analysis and querying on large datasets to examine data quality and produce summary reports using SAS and SQL for use by senior management
- Utilized SQL, Excel, and a range of create Web Analytics tools reporting by working with Google Analytics, SurveyMonkey, and Mailchimp for comprehensive business and marketing analysis for the PIM website.
- Set up python APIs for extracting daily data from multiple vendors into PIM.
- Analyzed current technology planning and deployment processes for automation and tool chain analysis through DevOps initiative.
Associate Manager / Decision Scientist
Best Buy Corporation
08.2019 - 09.2021
- Lead the on-boarding and Implementation effort organization wide of Power Automate as an automation tool to consolidate all of the Supply Chain team’s intake between Sharepoint and Azure DevOps
- Manage a team of three analysts that work on the day to day reporting needs of the Order Management team in Best Buy
- Created custom API connector in GCP to create reporting for Order Management website activity in Google Analytics.
- Manage and develop ad-hoc business reports in Teradata and Oracle databases based on various business needs
- Performed analysis of data sources to verify continuity and incorporate findings into final weighting for decision-making processes.
- Managed and optimized Power BI dashboards and reports for various Order Health metrics like Day to Day Order Volume and other important KPIs
- Utilized Alteryx for various data migration and transformation needs based on the complexity of the request.
- Worked closely with Large Product team as they migrated their legacy data warehouse to GCP
- Develop Alteryx workflows on Alteryx gallery based on data transformation and migration needs.
- Lead team meetings and Sprint planning and backlog management
- Lead the team and was responsible for the key sprint deliverables from the user story list for a given month.
Data Engineer
Southwest Airlines
05.2017 - 04.2019
- Translated business requirements from variety of teams across Southwest into data warehouse solutions by way of modeling in ERwin and physical implementation in Oracle through SQL design
- Developed data dictionaries for a variety of teams which helped the visualization teams and business users, extract standard attribute definitions across database schemas
- Loaded data into aircraft management team table in snowflake table using Snow SQL
- Organized code repositories, created naming standards, and migrated all code from SVN to GitHub. Trained the team on Git commands and established best practices for version control and code management.
- Automated the deployment and configuration of AWS infrastructure which could be run as stages within a full environment pipeline.
- Built Cl/CD pipelines for building/scanning images, deploying them into EKS or ECS, and promoting through environments. Followed a GitOps approach to maintain deployable code configurations.
- Analyzed current technology planning and deployment processes for automation and tool chain analysis through DevOps initiative.
- Warehouse expert which entailed data warehouse design starting from the logical modeling in ERwin to the physical modeling and Implementation of design in Oracle
- Worked as the main Data Architect on the Data Science team to develop Tableau dashboards for the Aircraft Improvement projects
- Supported accounting team in the implementation and connection of data in Microstrategy
- Developed expertise in dashboard design with Power BI, Power BI Pro, Power BI Mobile when working with Flight Operations team stored.
Business Analyst
Southwest Airlines
05.2016 - 05.2017
- Designed and built the Aircraft Health database and schema used by over 50 internal clients to warehouse and report on over 10 million clients and 2TB of data using Oracle
- Worked as a Business Analyst on the Aircraft Recovery Application team which helped the dispatcher recover flights that have been cancelled due to bad weather and other irregular operations
- Gathering of business user requirements and documentation of user stories in JIRA story board
- Lead user story trend analysis through Microsoft Excel and Jira data extracts and ingesting that data into Tableau to create visualizations for end of Sprint review
- Documented and maintained Application defects in HP ALM
- Applied SDLC concepts in future sprints to improve team performance
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
- Developed and improved integrated reporting and analysis capabilities.
Change Management Business Analyst
The Coca-Cola Company
05.2015 - 12.2015
- Assisted in the transition of Coca-Cola’s Privileged Accounts Management user accounts to CyberArk
- Extracted privileged account users from SAP RM and designed SQL scripts for tables from the extracted users that were eventually migrated to CyberArk
- Designed Tableau dashboard as project conclusion Month, Year analysis of the overprivileaged users extracted to be implemented in Cyberark
Education
Bachelor of Science - Management of Information Technology
Georgia Southern University
Statesboro, GA12.2015
Skills
Scripting
- AWS Cloud Formation
- YAML
- Harness
- Terraform
- GitHub Actions
- Process Automation Cl/CD
Programming Language
- Python
- SQL
- PL/SQL
- DAX
- HTML/CSS
Compute
- Amazon ECS
- S3
- Lambda
Databases
- Redshift
- GCP
- Teradata
- Azure Data lake
- Oracle
- Snowflake
Messaging
- Apache Kafka
- Elasticsearch/Kibana
- Datadog
Analytics
- Power BI
- Business Intelligence
- Data Visualization/Analysis Data Engineering
- Google Analytics
- Alteryx
- SSRS, SSIS, SSAS
Modeling
- ERwin
Certification
CERTIFICATIONS
ITIL Foundation :January 2017 — Current
Certified Scrum Product Owner (CSPO): January 2024 — Current
Timeline
Data Architect/Engineer
Hilton
09.2022 - 01.2024
Senior Consultant
Cognizant
09.2021 - 09.2022
Associate Manager / Decision Scientist
Best Buy Corporation
08.2019 - 09.2021
Data Engineer
Southwest Airlines
05.2017 - 04.2019
Business Analyst
Southwest Airlines
05.2016 - 05.2017
Change Management Business Analyst
The Coca-Cola Company
05.2015 - 12.2015
Bachelor of Science - Management of Information Technology
Georgia Southern University