Software Engineer(Data Engineer)  •  Bidgely

February 2019 - Present

• Designing, building, and launching of new data models and data pipelines in production.
• Building data expertise and own data quality for allocated areas of ownership
• 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  on Xplenty.
• 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.
• Follow design develop and communicate model using Agile methodology for data ingestion and data Products for Platform.

Data Analyst  •  Cympl Studio

May 2018 - September 2018

•  Creating events for new products or new feature updates so that it’s easy to fetch data.
•. Creating different types of visualisation on tableau and publishing on servers. Repeatedly analysing and trying 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 the A/B Test.
•. Providing solutions to the stakeholders on how to increase revenue and make it implemented.
•. Providing solutions to stakeholders regarding games.
•. Making SQL queries for cleaning of data and creating predictive models 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 servers by coordinating with the server team
•. Making queries and integrating them into the tableau to make various types of dashboards.
•. Creating a new process or bringing new process if it is required.

Data Analyst  •  Reliance Games

January 2017 - May 2018

•. Creating analytics events for new games or new feature updates.
•. Creating different types of visualisation on tableau and publishing on servers. Repeatedly analysing and trying to improve current and future dashboards so as to find insights easily.
•. Making aware to the stakeholders if there is an 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 to the previous analytics events.
•. Providing solutions to stakeholders regarding games.
•. Making SQL queries for cleaning of data and creating predictive models on r as per the requirements of stakeholders.
•. Managing servers by coordinating with the server team.
•. Making queries and integrating them into the tableau to make various types of dashboards.
•. Doing analysis by making various reports on Tableau.
•. Creating a new process or bringing off a new process if it is required.

Data Analyst  •  SNAPDEAL

January 2015 - December 2016

•. 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 are causing an increase in the returns of the product.
•. Worked on different projects with AVP of Customer Experience to reduce return rates.
•. Creating a dashboard on tableau by finding the loopholes in our system and finding out how much fraud is happening currently and blocking it if required.
•. Writing SQL queries to find out the insights or defects in our system and creating a 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.