ritesh choudhury

Analytics professional with 5+ years of experience exhibiting strong analytical abilities, effective communication, storyboarding and project management skills. Currently, managing and collaborating with multiple cross functional teams in advertising domain for an e-commerce giant

Key highlights-
-Built teams from scratch to provide analytical support to Sales, Operations, Marketing, Analytics and Products team of advertising business of an E-commerce retailer and enabling them to take data driven decision.
-Driving engagements helping clients translating business problems to analytical problem by efficient requirement gathering, critical solution designing, end to end process QA and automation

Tech Skills - SQL, Hive, Shell Scripting, Python ,Pandas, R, Tableau, Domo, Advanced MS Excel, Omniture

Work Experience
Senior Data Analyst - Sigmoid Analytics, Bangalore, India (Dec 2021– August 2022)
 Developed Tableau Gross Margin Trending dashboard with detailed Sales and Margin analysis by Customer, Product, and 
Sales Representatives
 Developed Tableau Price Override dashboard with Price Override Margin analysis by Customer, Product, and Sales 
Representatives
 Built Snowflakes views with fact and dimension tables to support BI reporting and enable connection to the Gross Margin 
Trending Dashboard
 Optimized Tableau Dashboard and established a self-service BI reporting timeline pipeline for the Gross Margin Trending 
Dashboard
Achievements during the Tenure:
 Individual Reward and recognition for Flawless Performance of the month for June 2022.
 Client appreciations on multiple live projects for excellent Business insights and Data analysis.
Senior Engineer (Data Science)- Altimetrik, Bangalore, India (May 2021–Dec 2021)
 Optimized and modernized Direct Vendor Shipment reports by migrating from DOMO to Greenfield platform.
 Developed shipment expense avoidance report on DVS using DOMO to estimate expenditure on carrier and service group.
 Created a DOMO report for analyzing mail-in returns to evaluate the performance of returns in comparison to 
undeliverable packages.
Associate Analyst- JC Penney, Bangalore, India (Jan 2020–Dec 2020)
 Conducted weekly pricing optimization analysis across channels and product categories and generated performance 
reports to track progress on a weekly basis.
 Utilized a linear regression model to calculate price elasticity and increase prices to maximize revenue capture.
 Developed Tableau dashboard for analyzing discount percentage buckets for each brand and product in JC Penney.
 Created BI tables for data analysis and performed store-wise analysis for product clearance pricing using Hive QL.
 Built Tableau dashboard to measure and enhance campaign performance by providing end-to-end visibility and utilized 
Adobe Analytics report builder to prepare funnel reports showing conversion metrics.
Application Development Analyst- Accenture, Bangalore, India (Mar 2016–Jun 2019)
 Developed Python scripts to ingest and retrieve data from different RDBMS such as Oracle DB and optimizing query 
performance through bucketing and partitioning in Hive. Proficient in writing Hive QL to transform data for downstream 
processing
 Developed Tableau dashboard to display the final list of customers with transaction metrics
Part-Time Experience
Business Analyst – Zeus Packaging , Rathcoole (Feb 2023-)
 Developed and implemented a Power BI Global Sales Dashboard, enabling in-depth analysis of sales and budget trends 
for all entities worldwide.
 Designed and implemented a Margin Sales Dashboard to analyze gross margin trends across entities and customers.
 Proficient in creating BI tables and performing data analysis using SQL Server.
Retail Sales Associate - Brown Thomas, Dublin 1 (Oct 2022 – Dec 2022)
I am pursuing my master’s and simultaneously worked as a part-time Retail Sales Associate in Brown Thomas, near Henry Street. I 
chose this position to experience the diversified Irish culture and improve my reachability among local Irish people. A summarized list
of all the work at the shop is as follows.
 Use a computerized system to scan the order and ready for shipment. 
 Pack customer`s purchases, Process store loyalty cards, coupons, and vouchers.
 Checking the online order stock on hand and availability in the inventory. 
 Packaging and picking the orders from floor and warehouse.

Education
 SVKM’s NMIMS Mumbai, India (June 2021 – October 2022)
Master of Business Administration (Working Executives) with specialization in Leadership and Strategy & Operations and 
Supply Chain- NMIMS (GPA 3.19/4)
 Biju Pattnaik University of Technology, India (June 2011– May 2015)
Bachelor of Engineering in Computer Science and Engineering – College of Engineering Bhubaneswar (CGPA: 6.9/10)