Leading Metrics team to make sure of the data sanity of energy consumption data. Experience working with Snowflake Functions, hands on exp with Snowflake utilities, stage and file upload features, time travel, fail safe. Designing, development, and maintaining data pipelines and ETL processes using Snowflake and SQL. Optimization of data models and schema design in Snowflake for efficient query performance. Expertise on engineering platform components such as Data Pipelines, Data Orchestration, Data Quality, Data Governance & Analytics. Ensure data quality, consistency, and integrity by implementing data validation and cleansing processes. Monitor and troubleshoot data integration and processing issues, ensuring data pipelines are robust and scalable. Creating explores and dashboard on looker and do the analysis for data sanity. Optimisation of looker by modifying lookml or in redshift. Handling ETL if required using Xplenty if required. Writing lookml code for metrics requirements. Also writing sql code to extract and do quick analysis of data. Worked on various projects like hybrid watchdog, disagg dashboard, subscribe and unsubscribe of email/paper. Worked on development of Analytics Workbench application by integration looker as a backend. Created incremental PDTs in looker to avoid rebuilding of PDT's for huge set of data. Designing AWS redshift data streaming. Creating different models for different db connections, adding data security using access filters in looker, handling the admin of looker, optimisation of looker views to reduce the PDT's build time.

• Creating events for new products or new feature update so that it’s easy to fetch data. • Creating different types of visualisation on tableau and publishing on server. Repeatedly analysing and try to improve current and future dashboards so as to find insights easily. • Analysing the data providing the key factors to increase the revenue and make it implemented after doing A/B Test. • Providing solutions to the stakeholders how to increase revenue and make it implemented. • Providing solutions to stakeholders regarding games. • Making SQL queries for cleaning of data and creating predictive model on r as per the requirements of stakeholders. • Deciding and running the A/B test to improve various metrics like revenue and retention. • Analysis of data and proving actionable insights to product and marketing team. • Managing server by coordinating with the server team • Making query and integrating it into the tableau to make various types of dashboards. • Creating a new process or bringing new process if it is required.

• Creating analytics events for new games or new feature update. • Creating different types of visualisation on tableau and publishing on server. Repeatedly analysing and try to improve current and future dashboards so as to find insights easily. • Making aware to the stakeholders if there is increase or decrease in revenue by analysing statistically. • Automation of tableau visualisation on tableau online by scheduling the refresh of extracts. • Made a lot of improvements on the previous analytics events. • Providing solutions to stakeholders regarding games. • Making SQL queries for cleaning of data and creating predictive model on r as per the requirements of stakeholders. • Managing server by coordinating with the server team. • Making query and integrating it into the tableau to make various types of dashboards. • Doing analysis by making various reports over Tableau. • Creating a new process or bringing off new process if it is required.

•. Derive the key metrics for the Return of any specific product category with its return percentage by Value/Volume and variations in return rate to reduce returns to increase Customer Experience & Revenue. • Increasing the revenue target by analysing the return rate of the product and reducing it by finding different factors that is causing increase in return of the product. • Worked on Different projects with AVP of Customer Experience to reduce return rate. • Creating a dashboard’s on tableau by finding the loopholes of our system and finding out how much fraud is happening currently and blocking them if required. • Writing SQL queries to find out the insights or defects in our system and creating dashboard on Tableau. • End to end Ownership of the Return Experience Score(Rex) • Improve Return Experience Score by using data analysis, qualitative analysis, interacting with dissatisfied customers and setting up processes to overcome gaps in our current systems • Improve the current survey format to capture better insights from customers. • Help with other related analysis and recommendations. • Improving Return Experience Score metrics & corrective action plans.

• Worked on Cigna process. • Reports scheduling on a daily and monthly basis using SQL queries. • Audit call logs and evaluate adherence of agents. • Increased the productivity of the process. • Providing loop holes in the process to the stakeholders.