Tejal Ambilwade

• Created hybrid data integration solutions by configuring Azure Data Factory’s integration runtimes to securely link on-premises data sources like SQL Server, Redshift, and SAP systems.
  • Engineered intricate SQL triggers in Redshift and Athena to automate data processing tasks, resulting in a 30-hour weekly reduction in manual workload and enhancing data accuracy by 20%.
  • Key Performance Indicator (KPI) Development: Examined chargeback rate, payment success rate, fraudulent transaction rate, and payment processing costs to pinpoint inefficiencies and risks; decreased chargeback rate by 20%; and optimized payment success rate by 15%.
  • ETL (Extract, Transform, Load): Utilized Google Analytics & SSIS for real-time data ingestion and ETL pipelines, elevating end-user satisfaction by 25% and average revenue per user by 15%.
  • Applied complex data analysis calculations in Power BI DAX & Power Query, resulting in a 15% enhancement in forecasting accuracy and a 20% reduction in data discrepancies, thus enriching overall business insights and strategic decision-making.
  • Formulated the integration of diverse customer data sources for constructing visualizations using Tableau and Power BI for C-suite executives; enabled thorough analysis of customer behavior, fraud trends, and high-value demographics, leading to a 15% increase in customer retention and 20% revenue growth.
  • Led the creation and enhancement of new Tableau dashboards for tracking payment campaigns, boosting fraud prevention rates by 15% and successful payments by 12% compared to previous methods.
  • Devised a migration strategy and roadmap for data validation processes and user training plans, ensuring a seamless transition for over 80 dashboards from Tableau to Looker.
  • Oversaw the configuration and maintenance of a multi-instance Azure Data Factory (ETL) setup, synchronized with a centralized GitHub repository for version control, fostering cross-functional collaboration, and enabling swift deployment.
  • Provided guidance and mentorship to 2 junior analysts through Tech Stack training, resulting in increased project delivery speed and a 15% decrease in system errors.

• Provided marketing strategy insights to boost company sales by capitalizing on emerging industry trends, resulting in a client retention rate of up to 75%.
• Conducted workflow analysis to document business processes and proposed optimizations for operational streamlining.
• Employed MySQL for data reporting and demonstrated robust organizational skills in task management.
• Orchestrated a data-driven overhaul of procurement procedures, utilizing Tableau dashboards to refine operations.
• Managed inventory, coordinated logistics, and fostered supplier relationships, resulting in streamlined processes and heightened production efficiency.