Data Warehousing and Business Intelligence Analyst
Chennai, IN-TN, IN
April 2021 - July 2023
company
Flextronics
title
Data Warehousing and Business Intelligence Analyst
overview
- Engineered a fully automated product with six SSIS ETLs and seven SSRS paginated reports in BAAN ERP, yielding $217K cost savings and reducing headcount by 16
- Designed and implemented nine self-service analytical reports in Microstrategy, enhancing decision-making accuracy by 20% through actual
- Created five Tableau dashboards with global inventory management metrics, optimizing inventories by 30% within a quarter
- Archived 46+ million high-volume transactional accounts payable records, reducing response time and improving database performance by 25
- Spearheaded cost accounting data mart migration from Oracle/SQL data sources to Snowflake, achieving a 40% reduction in processing time and 20% decrease in infrastructure costs
- Led a team of four in modifying 84 cost accounting ETL data pipelines to accomodate ERP system changes, resulting in a 30% reduction in processing time and 20% increase in data accuracy