Berkeley, California, United States
I build enterprise analytics systems that scale. From designing structured data warehouses to automating ETL pipelines and streamlining global forecasting workflows, my focus is on transforming complex, multi-system environments into decision-ready infrastructure. Supporting $3B+ in global operations, I specialize in SQL, Python, Snowflake, and Hyperion EPM to improve reporting efficiency, strengthen data reliability, and enhance executive forecasting visibility across regions. By developing SQL and Python based ETL workflows within Snowflake environments, I reduced reporting cycle times by over three weeks per report while increasing data accuracy and cross regional consistency. My work enables finance, operations, and leadership teams through scalable reporting solutions built in Tableau, Cognos, and Hyperion EPM. I focus on strengthening enterprise data architecture, optimizing reporting workflows, and driving measurable operational impact through analytics at scale.
- Architected and deployed a centralized MySQL database server integrating global sales data from multiple enterprise systems, including relational schema design and data modeling, reducing reporting cycle time from 4 weeks to 3 days - Contribute to enterprise Long-Range Strategic Planning (LRSP) by consolidating multi-year financial forecasts across AMER, APAC, EMEA, and LATAM, supporting strategic revenue planning for $3B+ annual operations - Coordinated monthly global forecasts across regions, ensuring 100% on-time EPM system updates and supporting accuracy for $3B+ in annual revenue - Built and maintained Python-based ETL pipelines consolidating data from 5+ systems (Oracle, Snowflake, ERP), standardizing datasets for enterprise reporting - Automated LRSP system input processes using Python, reducing turnaround time from 3 days to 1 day and improving planning efficiency - Delivered 10+ Tableau dashboards and automated Excel reporting models supporting C-suite and global stakeholders across AMER, APAC, EMEA, and LATAM - Improved marketing visibility and campaign performance tracking by maintaining structured KPI reporting infrastructure through SharePoint and cross-functional dashboards
- Led a team of 3, prioritizing workflows and delegating responsibilities to consistently meet performance and fulfillment targets - Designed and implemented a Python-based inventory management system integrating with internal ordering and shipping portals, reducing shipping turnaround time by 75% - Conducted demand and sales forecasting to optimize inventory levels and operational planning, increasing process efficiency by 33% - Presented monthly KPI analyses and performance insights to key stakeholders, supporting data-driven decision-making across the business
- Developed and deployed an automated inventory optimization system leveraging order analysis to generate dynamic reorder points and optimal order quantities - Designed and institutionalized Standard Operating Procedures (SOPs) to standardize inventory and logistics workflows, reducing process variability and improving cross-team alignment - Spearheaded process improvements across refurbish, returns, and shipping operations, increasing efficiency and strengthening customer experience
- Streamlined and expedited order fulfillment process by efficiently and accurately processing orders received through the dashboard, resulting in improved customer satisfaction - Developed comprehensive documentation of shipping and quality assurance processes, ensuring accurate and up-to-date records were maintained, which facilitated smoother operations and compliance - Implemented an effective inventory tracking system, maintaining accurate inventory levels and ensuring adequate stock availability until new inventory arrived, minimizing stock outs and optimizing supply chain management
- Developed an LSTM based anomaly detection model achieving 74% accuracy to identify network tower outages and performance abnormalities - Built a geospatial Tableau dashboard mapping 8,500+ network towers nationwide, enabling field teams to optimize equipment preparation and reducing service downtime by 50%+ - Engineered a Python-based ETL pipeline to convert third-party XML data into structured database tables, automating an 8-hour manual process and significantly improving data processing efficiency
- Developed Python-based integrations leveraging APIs and JSON to automate data exchange and support business process integration - Collaborated cross-functionally to structure and operationalize data workflows for internal teams - Designed and delivered a Python curriculum for middle and high school students, creating hands-on programming projects to build foundational technical skills
- Conducted market research to identify target segments, contributing to improved campaign conversion rates - Led targeted outreach initiatives that increased enrollment for the subsequent academic term - Applied data analysis to optimize marketing materials, increasing traffic and engagement by 50%