Jul 2019 – Aug 2023 · 4 yrs 1 mo · Gurugram, Haryana, India · On-site

• As a BI Engineer, I am responsible for designing, developing, documenting, and implementing a star schema-based warehouse architecture for consumer-side metrics. I collaborate with a team to accomplish this goal, bringing my expertise to the table to ensure the architecture meets our needs.
• Additionally, I work independently to design, develop, and document a star schema-based relational data model for temperature data sourced from third-party APIs. I also create and implement a source replication pipeline from various third-party data sources, including APIs, S3 data dumps, chatbot data, and competitive pricing data.
• To ensure our systems remain up-to-date and optimized, I successfully migrated over 100 jobs from Azkaban to Airflow as part of Azkaban's deprecation. I also conduct multiple training sessions on optimizing query writing for Amazon Redshift, Trino, Presto, and Spectrum tables.
• Finally, I am proactive in administering Redshift by setting up automated alerts and improving its performance through the application of distribution and sort keys on frequently accessed tables. My contributions help ensure our systems are efficient, effective, and able to meet the needs of the business.

Sep 2017 – Jul 2019 · 1 yr 10 mos · Gurugram, Haryana, India · On-site

• In this role, As the primary owner and stakeholder manager for the Operations, Finance, and B2B teams, I oversaw all analysis and reporting requirements. This involved maintaining and updating a star schema-based data warehouse and creating data marts.
• I provided analytical support to the Leadership/Product and Tech Team in fulfilling their ad-hoc requirements. Additionally, I assisted the Finance and Operations teams during external and internal audits by providing them with necessary data.
• From an analytical and data support perspective, I acted as a liaison between the Tech, Product, and Business teams to ensure effective collaboration among all parties.

Sep 2016 – Sep 2017 · 1 yr · Greater Delhi Area · On-site

• In this role, as a product owner and administrator for Zendesk (CRM) and 8x8 (dialer), I was responsible for completely revamping and documenting the existing structure of triggers and automations for Gwynieebie. Additionally, I onboarded two new tenants, namely New York & Company and Ann Taylor, in the professional edition of Zendesk.
• I also played a key role in restructuring and automating the complete reporting framework for the Customer Service and Accounts team in Tableau. Furthermore, I provided analytical support to the Product Team for their ad-hoc requirements, which helped me gain valuable insights into the product development process.
• During this experience, I had the opportunity to work in an onshore-offshore model, which allowed me to improve my communication skills and work effectively with colleagues across different time zones.

May 2016 – Sep 2016 · 4 mos · On-site

• In this role, I was responsible for overseeing the entire technology execution of the Net Promoter Score (NPS) process. I took ownership of improving and reporting NPS results regularly, and provided analytical support to the leadership team to identify key areas for improvement through Buyer and Seller NPS results. Additionally, I supported the team by analyzing internal surveys and fulfilling custom research requests.

Aug 2014 – Apr 2016 · 1 yr 8 mos · On-site

• In this role, I was responsible for a range of tasks related to reporting and analysis. I designed, maintained, optimized, and automated a complete reporting framework, and documented all of the processes involved. I also conducted in-depth analysis of key metrics like OTR, TAT, CSAT, and return processes, and set up anomaly detection reports to ensure that any issues were identified and addressed quickly.
• Another important part of my role was to analyze the impact of policy changes and new technology releases on performance metrics, so that we could continuously improve our processes and systems. I also measured the efficiency of automated tasks running on the backend, such as auto refund, auto CCA, and RTO updates, to ensure that they were running smoothly and contributing to our overall performance.
• In addition to these tasks, I assisted with third-party audit processes by providing relevant data and information. I worked closely with the audit team to ensure that they had access to all of the necessary data and that it was presented in a clear and organized manner. I also worked closely with the Product and Data Warehousing teams to devise business requirements that would help us achieve our goals.
• Finally, I was responsible for the CRM workflows, acting as an administrator to ensure that they were running efficiently and effectively. Overall, my experience in this role allowed me to develop a wide range of skills related to reporting, analysis, and process improvement.