Juan Chiwah

Lead continuous improvement of Demand Planning datamart and reports. Owned all technical aspects of reporting technology and back-end data sources used by demand planners; increased accuracy and speed of analytical business cycle. Leveraged Snowflake, Databricks, and Sigmacomputing technologies in agile development process. Developed data pipelines for BI and data science applications. Actively contributed to the weekly consumption forecasting status meetings.

Led development of new Business Risk datamart and dashboard development. Managed team 4 data analysts of various skill levels, providing coaching and technical leadership. Consolidated data from multiple systems and data formats. Performed data cleansing, transformations, and delivery via automated scripts, and via multiple tools including Tableau dashboards, Excel pivot tables, and email distributions. Presented scorecard data to Business Risk leadership. Actively participated in cross-functional data governance across various analytical teams in the organization. Ensured proper documentation and communication for all standard processes.

Designed, deployed, troubleshot Discover credit card Client Acquisition systems, effective communication for cross-team collaboration, escalated issues for quick resolution. Modernization of data warehouse by migrating to Snowflake cloud-based platform. Troubleshot and refined data pipelines using Snowflake, Kafka, and Lambda functions. Analyzed multiple data sources and created accurate source-to-target data mapping. Validated data models used in ML applications. Actively contributed in Agile process, Scrum ceremonies, and overall team process improvement. Created complete logs of projects and timely status updates via JIRA. Conducted Scrum ceremonies as alternate facilitator, ensuring proper project progress and escalating issues when required. Documented user stories and contributed in story-pointing process.

Delivered end-to-end data warehouse modules, including database design, ETL processes, self-serve views and reporting solutions, proofs-of-concepts, and production jobs and dashboards. Architected and developed ETL solutions using On-premise and Cloud-based databases, Secure FTP, and REST APIs technologies, among others. Provided technical leadership in the complete rewrite of Enterprise Data Warehouse. Transition use of IBM Cognos Data Manager to Microsoft SSIS toolset. Designed and implemented datamarts for Advancement reporting via Tableau, PowerBI, SSRS, and WebFOCUS.