Sourav Sikka

Tools Used: Data build tool (DBT), Amazon redshift, Presto, Airflow, Tableau, Python

• Implemented Data Warehouse from scratch, Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support.
• Created Single Source of truth for all major KPIs by creating fact, dimension, aggregate & logs table for different use cases
• Having strong hands on experience in extraction of the data from various source systems like RDBMS( MYSQL, PostgreSQL), Google Sheets & by using APIs
• Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance
• Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
• Manage a team of 2 analysts and ensure timely delivery of each assigned task
  

Tools Used: Amazon redshift, Qliksense, Python, Google Analytics

• Reviewed current analytics implementations and provided recommendations for realignment to customer KPIs or technical best practices.
• Provide analytics support to business verticals – CXO, Retail, Brands, Operations, CS, CRM, Finance, B2B MT GT
• Build, customize and publish interactive reports, visualizations and dashboards using Qliksense and Nprinting.

Business Projects :

1) Customer retention for retail Stores

• Applied RFM principles (recency, frequency and monetary) to cluster retail non-Buyers using K-Means Clustering Algorithm
• Call Customers in each cluster for identifying Churn reason & provide Discount Coupons to Customers as per sales history
• Identifying De-Growing and Low Performing Stores Customers and provide them coupons for improving sales
• Setup an automated process for Calling team. Call Churned customers who are not buying with in a gap of 4 months

Business Impact : 4% Conversion rate with 1.5 million monthly revenue

2) User Properties:

• Contains Purchasing Behavior (RFM), Repeat rate, Category and Channel wise Preferences of Customers which help marketing team in choosing right customer for daily campaigns.

3) DWH Load Optimization :

• Reduce load time from 2.6 Hours to 1.6 Hours by optimizing SQL Code of ETL Jobs
  
  

Tools Used: Microsoft SQL Server, Active Batch, Python, Excel

• Created new analytical systems to boost vital business metrics visibility.
• Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
• Instituted contingency plans, promoting business continuity through cross-training, documentation and data backups.
• Mentored teams and streamlined techniques through evolution of delivery cycles, establishing documentation framework to support agile methodology implementations.

Tools Used: HP Vertica, Tableau, Python, Adobe Omniture

• Managed and Developed all Key Metrics reports and tested before it get its live.
• Created periodic reports and CXO-level summaries, for tracking top-line (GMV, etc.), bottom-line (Net Margin) and UX(NPS)
• Supporting 25 Category teams with timely turnaround by researching trends and performance. Analyzing and sharing insights for various metrics like NPS, conversion, visits, NMV, CM, etc.
• Automation of redundant request by empowering the users with DIY Tools
• Created Live Sales dashboard of Brand Segment only, which helped saving Millions by raising alarms of abnormal sales
• Helped answer specific strategic questions and hypothesis for categories through data-driven analysis
  

Tools Used: MYSQL, Pentaho Reporting & Ctools, Excel, Google Analytics

• Researched and resolved issues regarding integrity of data flow into databases.
• Identified and documented detailed business rules and use cases based on requirements analysis.
• Participated in requirements meetings to understand business needs.
• Upheld security and confidentiality of documents and data within area of responsibility.