Dhrishya Subramanian

Dhrishya Subramanian

Programmer Analyst Trainee

Followers of Dhrishya Subramanian420 followers
location of Dhrishya SubramanianSeattle, Washington, United States

Connect with Dhrishya Subramanian to Send Message

Connect

Connect with Dhrishya Subramanian to Send Message

Connect
  • Timeline

  • About me

    Business Analysis Manager at T-Mobile

  • Education

    • Sri Venkateswara College of Engineering- Anna University

      2004 - 2008
      Bachelor of Engineering (B.E.) Computer Science
    • University of Wisconsin-Madison

      2009 - 2010
      Master's degree Industrial Engineering- Operations Research
  • Experience

    • Cognizant Technology Solutions

      Aug 2008 - Jun 2009
      Programmer Analyst Trainee
    • Danfoss

      Jun 2010 - Aug 2010
      Summer Intern

      - Studied the financial impact of ergonomic conditions in the factory line- Danfoss employees had higher percentage of injuries as compared to the national average leading to high insurance premiums - Conducted a Baseline Risk Identification of Ergonomic Factors (BRIEF) Survey calculated the amount of risk an operator is exposed to- Identified indirect costs incurred by Danfoss, from loss of productivity, training and replacement, etc.

    • Hewlett Packard Enterprise

      Jan 2011 - Apr 2014

      One key deliverable of the Analytics team of HP India is to deliver segmentation and analysis of HP’s 91 million record B2B customer and shipment database, aimed at better targeting of marketing campaigns. My work involved understanding the nuances for all B2B marketing campaigns including email, direct mailer and telemarketing. For the marketing campaign, selected the appropriate target list using specific segmenting and targeting mechanisms like competitor attacks, cross-selling, region focussed targeting, predictive modelling, etc.- Worked with HP’s custom photo merchandise product called Snapfish- Analysed purchase behaviour based on seasonal purchase patterns to identify, retain and grow active buyers through customized marketing campaigns and promotions- Segmented buyers using non-hierarchical k-means clustering based on revenue and inter-purchase frequencies- Provided the Snapfish team a drill-down analysis of each segment’s characteristics of purchases, repeat purchases, and churn- Suggested methods on how each customer segment can be leveraged on their spending potential by identifying cross-selling and upselling opportunities Show less - Canada SMB team runs a monthly telemarketing campaign to improve sales of customers who have a low purchase history of PCs, laptops, and printers from HP- Provide monthly telemarketing target list of 6,500 contacts for Canada in the SMB space- Create the list on a monthly basis for the PC and laptop group based on the feedback given by the telemarketing vendor- Create a list on a quarterly basis for the printer division by running a regression model that predicted customers that were most likely to purchase a printer in the next quarter Show less

      • Analytics Consultant

        May 2013 - Apr 2014
      • Business Analyst

        Jan 2011 - Apr 2013
    • Facebook

      Apr 2014 - Dec 2015
      Specialist, Community Operations

      The Community Operations team supports users on Facebook and Instagram regarding their concerns around content and user behaviour. Issues are reported by users and have an SLA for response and resolution. To handle the billions of objects that could be reported, automation, profiling, trends, and proactive monitoring play a major role in meeting the SLA. Some of my responsibilities included-- Developing automation rules and plugged policy gaps that caught fake accounts with 97% accuracy. This resulted in improved safety for Indian women using Facebook and significant workload reduction - Developed routing rules to direct user-reported issues to the right SME improving overall review times by 21% - Outsourcing Instagram workflows for the Bullying vertical. Involved in making decisions for changes in the existing tool design, review procedures and policies- Designing and conducting the training for a team of 51 employees in one month for outsourcing readiness while maintaining a quality of 98%- Building dashboards for the team to track metrics- Identify and fix policy gaps based on new harassment trends Show less

    • Rockmetric Innovations Private Limited

      Feb 2016 - Jul 2016
      Independent Consultant

      Rockmetric is a customer data management start-up that creates digital profiles of customers and develops strategic insights about their customer base. I worked with two leading brands in India to improve their online and offline customer experience.I was involved in creating decision frameworks and product improvements in the e-commerce and retail domain.

    • Mu Sigma Inc.

      Aug 2016 - Dec 2017
      Associate

      Advised the Business Planning and Strategy team at a Seattle based client to identify drivers of engagement and churn in voice search. Developed a framework for forecasting voice assistant devices sold WW.Also worked on quarterly forecast of monetizable search volume for US and International markets based on active devices, market factors and planned growth initiatives. Based on the outputs of this study, we worked on forecasting the average revenue per device as a means of understanding life time value of a customer.On a previous engagement, I led a team of six decision scientists in the requirements gathering process with the Supply Chain Analytics team for a leading technology company with the goal of identifying drivers of product returns. I managed development of a logistic regression model to predict customers that are likely to return product – to proactively replace devices and increase customer satisfaction. I drove the delivery of the model, including end-to-end automation, to be re-applied on other product lines Show less

    • Revel Consulting

      Dec 2017 - May 2021
      Senior Associate

      Business Intelligence for the Services Org – Large Tech Vendor- Owned the development and maintenance of the performance dashboard for for a Services org, using SQL and Power BI, which drives services revenue of $750M, annually- Identified business insights on customer behavior by drilling into historical data of key metrics. This helped answer important questions like how switching services affects the overall spend, usage, and CSAT- Responsible for determining customer retention, acquisition, and attrition using historical customer trends, and revenue forecastsWeb to Retail Reporting Consultant – Large Telecom VendorDeveloped reporting capabilities for the e-Commerce Marketing and Experience team for their digital to retail programs.The client had initiated programs to drive foot traffic to stores to because physical stores had of higher conversion of leads to sales. As a part of this effort, I was brought in to help my client define the metrics and create dashboards that would be accessible to teams and stores across the US.- Defined KPIs and funnels that tracked different sources of customer interest online to foot traffic into the store- Developed a methodology to map the conversion of online customers into offline stores- throughout the customer journey all the way upto acquisition- Consolidated data coming from disparate data sources and designed the data cube dimensions and measures to meet reporting requirements. This involved Partnered with Business Intelligence team to consolidate disparate data sources or manual data pulls and land them in an internal SQL server. Drove the automation of data ingestion into SQL Server, saving 240 hours/year of manual data ingestion. - Built an automated dashboard for the Digital-to-Retail teams to readily access data and periodically assess program effectiveness, as well as draw insights on opportunities. Show less

    • T-Mobile

      May 2021 - now
      Business Analysis Manager
  • Licenses & Certifications