Sumathy Subramanian Email & Phone Number

San Francisco Bay Area

San Francisco Bay Area

Santa Clara, California, United States

Santa Clara, California

Technology/Platform: SQL in Snowflake and Athena database, Excel Analytics, Domo, R programmingDomains: SaaS• New Business Forecasting Model in collaboration with Finance Team• Breakdown of New Business ACV to individual channels to have some attribution in place• Churn prediction Model. Completed descriptive analysis for churned customers in phase 1. Working on giving a score to existing premium customers on their likely to churn• Working on analyzing free/trial users on their behavior/interactions with the product and determining potential cohorts that have a good change of converting to premium offerings• A member of the Retention Tiger Team and work on analyzing the friction points in customer journey that will help reduce churn• Working with Product team in developing unified definitions of product related metrics and the right way to measure it (Installations, Active Machines, Uninstalls etc.)• Member of the Product Tiger Team that helps measure various aspects of the product • Member of the experimentation team. This team largely focuses on running different experiments on the Free/ Trial users. I work on analyzing the results of different experiments we run• Work in identifying potential opportunities for new experiments• Working on implementing Marketing automation platforms that will help the marketing team self-serve audiences for campaigns

San Francisco Bay Area

Technology/Platform: SQL in Redshift database, Excel Analytics, Looker, R programmingDomains: SaaS • Design and build KPI metrics in Looker Dashboards• Aggregate data from multiple 3rd party systems to assist in Marketing, Finance and Product centric decisions• Analyze results from multiple A/B tests to increase conversion and retention• Assist the Pre-Sales team in building prototype dashboards for prospective customers

3410 Hillview Ave, Palo Alto, Ca 94304

With SAP, I work extensively in Data Management, Business Intelligence and Analytics practices.Technology/Platform(SAP): Data Services, SDI & SDQ, Agile Data Preparation, HANA Studio and Web IDE, Lumira Discovery and Designer Technology/Platform(non-SAP): Excel Analytics, SQL server, Tableau, R programmingDomains: Retail, Insurance, Supply-chainI work closely with various business groups across the enterprise to deliver and understand the analytics/tracking requirements for customer's business operations. • Work on multiple enterprises level projects to represent analytics/Business Intelligence team• Design and develop logical and physical data models for new initiative projects• Design data migration strategy for new initiative projects• Design and deliver KPI's and dashboards using Lumira Discovery and Designer• Collaborated with Vendor, Claims and Accounts Receivables business lines in an effort to translate business requirements into transformation rules• Implement ETL process as a data preparation step for further analysis• Convert KPI's from its business definition into technical specifications for implementation • Collaborate with key business lines and architects for various projects• Define and develop real-time analytics dashboards, ad-hoc reporting and analysis in order to provide data-driven insights and optimized solutions

Cincinnati Area, Ky

Technology/Platform: Excel Analytics, SQL server, Tableau, R programmingDomains: EducationAnalysis of undergraduate student data to help make important managerial decisions for implementing experiential learning courses, by cleaning, organizing, mining, analyzing and visualizing data using CRISP DM methodology. • Perform extraction, cleaning and transformation tasks using SQL queries a part of Data Preparation for analysis• Perform exploratory data analysis using Tableau and R• Create regression models to test several hypotheses related to student performance (GPA)• Create regression models to test several hypotheses related to university's retention rate

Graduate Assistant for the course Data model and design healthcare.Technology/Platform: Excel, SQL serverDomain: Heathcare• Responsible to deliver practical sessions for a class of 20 students on how to build a database and perform data manipulation activities in MS SQL server• Assist the students in any form of additional help by conducting open sessions for 2 hours every week• Build a working database for the final project scenario which involved identifying functional dependencies, creating ER diagrams, drafting a conceptual design, drafting the final script for building the physical tables.

Mumbai Area, India

Technology/Platform(SAP): Data Services, HANA StudioTechnology/Platform(non-SAP): Excel Analytics, SQL serverDomains: Retail• Worked on the ETL process of data migration for Material, Vendor and Inventory objects involving complex transformations• Developed mappings in SAP Data Services to load the data from various sources into IDOC's or Load files using transformations like Source Expression, Merge, Lookup, Aggregate, Update Strategy and Joiner• Experience with Data Cleansing, Data Migration and Data analysis using SAP tools• Conducted various Knowledge Transfer sessions and gave training of up to 25 hours to the new team members• Worked on automating financial reconciliation by applying calculation rules and in Data Services Jobs

Mumbai Area, India

Worked under the Peptide and Nucleotide section. • Understood the work flow and production stages of peptides• Received training in the manual and automatic production of peptides• Gained insight in the use of Database systemms for Maintaining records• Acquainted with packaging and dispatch methods

Master’S Degree, Management Information Systems, General, 3.83

Engineer'S Degree, Biotechnology, First Class With Distinction