Ambar Chandra

• Designed and implemented end-to-end data architecture, including creating a data model, developing an ETL pipeline on Matillion with Python and various orchestration components. • Extracted data from multiple sources using API, such as Salesforce, Workday and transformed it before loading into our cloud data warehouse, Snowflake. • Developed KPIs on Snowflake and produced Tableau dashboards to present data insights. • Automated multiple ETL processes, leading to increased efficiency and improved accuracy.

• Querying data in SQL, Amazon Redshift and build ETL pipeline. • Analyse data for better business insights on large data sets specifically on B2C data using Python, Excel and Tableau. • Worked on multiple A/B test projects which includes (Pre test analysis, identifying MDE, main KPI's, power calculation, dashboard creation, revenue and post test analysis) • Built and maintain attribution model which includes predictive machine learning algorithms. • Collaborate with cross-functional team on ad-hoc analysis

• Creating Data models and Database design specifically for SQL Server. • Creating Power BI dashboard, drawing business insights, and presenting it to stakeholders. • Performed forecasting, trend analysis, pattern matching, and anomaly detection using Python. • Data integration from multiple sources and maintaining the ETL pipeline. Skills: Talend · DWH · Microsoft Power BI · Microsoft Excel · SQL · SQL Server Integration Services (SSIS)

• 3 years of experience in Data Analysis and conceptualizing Data models. • Predictive and multivariate analysis on Sales data, Inventory management (reducing overstock). • Determine reimbursement percentage-policy for different category of sellers. Decreased reimbursement for the first quarter by 28%. • Define key KPIs for buy now sellers on Amazon (Category and region-wise) Keywords - AWS, S3, Athena, RDS, RedShift, QuickSight, Python Scripting, SSAS, SSIS, Ms Excel, and Amazon Internal tools

• Build/maintain reports, dashboards, and metrics to monitor the performance of products in Power BI. • Data Visualization and presentation for cross-functional teams. • Identify gaps by conducting comprehensive data analysis on Power BI and accelerating the analytics maturity in key product areas. • Partner with Product and Engineering teams to solve problems and identify trends & opportunities. Skills: Power Bi, Microsoft Excel, MySQL, SSAS, Internal Applications

Data Mining. Data Analysis. Data Visualization. Machines Learning. ETL Pipeline