Data Analysis, Advanced Excel, Pivot tables, data modeling, Tableau

SWATI RAMESH

669-***-**** ● *************@*****.***

*** *********** **, *** ****, CA 95122

EDUCATION

SAN JOSE STATE UNIVERSITY

Master of Science, Engineering Management (GPA 3.82/4.0)

Certification: Six Sigma Green Belt (Process Optimization)

San Jose, CA

Aug 15 – May 17

VISVESVARAYA TECHNOLOGICAL UNIVERSITY

Bachelor of Engineering, Computer Science and Engineering (GPA 8.8/10.0)

India

Aug 08 – May 12

SKILLS

Business Intelligence and Big Data: Interactive dashboards, Tableau, Power BI, Advanced Excel, Regression analysis, Data Modeling, Data Warehousing (ETL Informatica, EDW), OLAP cubes

Product Management: Product Strategy, User Research, Market Analysis and Segmentation, Hypothesis Testing, Design Thinking, Wireframes, A/B testing, competitor analysis, User stories, Backlog Grooming, SDLC

Programming and Database: R, Python, Java, HTML 5, MySQL, Salesforce, Teradata, Oracle 9i, DB2

Project Management: Lean, Six Sigma, Agile methodologies, Jira, Asana, Mathematical models for optimization

EXPERIENCE

NOSON INC (B2C Startup- Airport Parking Software) San Francisco, CA

Intern, Customer Experience Analyst Dec 17 – Present

Working towards enhancing NPS score from 40 to 90 by driving improvements on MVP and email deliverability

Automating payment process alongside managing new product development with a team of developers and designers

VOCERA COMMUNICATIONS INC (B2B SaaS- Healthcare IT) San Jose, CA

Intern, Product Analyst Jun '17 – Sep '17

As an analyst in Product Management team, took complete ownership of building a reporting framework for enterprise-wide ROI tracking, right from the stage of conceptualization to implementation and deployment

Built product management focused dashboards around pipeline, costs and revenue using Microsoft Power BI

Designed data model (Snowflake Schema), built tables, normalized data, transformed data using Data Analysis Expressions(DAX) for data streaming from Salesforce, SAP, Excel and Jira

Uncovered high operations cost for hardware shipping, projected ~25% cost reduction by suggesting an alternative logistics plan and presented my case to product strategy team

Collaborated with multiple product owners and financial analysts to track KPIs, costs and revenues for Vocera product lines

Created user stories using Jira and coordinated with Engineering teams in Agile environment

IBM GLOBAL BUSINESS SERVICES Bangalore, India

Business Intelligence Developer/Analyst Sep '12 – Jul '14

In a client facing role, translated business requirements into technical requirements to deliver value

Developed back end Business Intelligence applications using SQL, Informatica Power Center and Teradata Database

Extracted large sets of data from heterogeneous platforms, performed data cleansing and transformed data according to business rules using ETL procedures, coordinated with three cross-functional teams to ensure consistency in data flow and provided application support

VOLUNTEERING

PRODUCT MANAGER – Data/Business Intelligence

Mifos Initiative, Mountain View, CA

Product Manager for Business Intelligence initiatives at Mifos which provides an open source technology platform; The platform enables core functionality needed to deliver financial services to the 2 Billion poor and unbanked

Drafting out requirements, specifications and design documentation for BI, data and reporting-related features on the Apache Fineract platform, the Apache Fineract CN framework and the Mifos X web and mobile apps

RELEVANT PROJECTS

MARKETPLACE LIVE – BUSINESS MANAGEMENT SIMULATION

San Jose State University

Used Tableau to analyze market and competitor data to make quarterly product decisions

Improved customer conversion rate from 5% in initial quarters to 16% by the end of fourth quarter in a simulation game involving introduction of computers into a nascent market along-side strong competition

Played an active role as VP, Business Analytics in a five-member team with various responsibilities including analyzing customer needs, selecting target market, designing brands for specific segments and post-analysis of results

PRODUCT DEVELOPMENT - SMART TREKKING POLE

Master’s project, San Jose State University

Conceived idea from personal experience and analyzed this idea through user research (Quantitative and Qualitative) and competitive analysis

Built Product Requirements Document (PRD) after translation of user requirements into design specifications using Quality Function Deployment (QFD)

Evaluated alternative designs for usability and reliability resulting in the initial prototype design

CARSDIRECT.COM - NEW FEATURES PRIORITIZATION & UI DESIGN

San Jose State University

Brainstormed a set of features for carsdirect.com mobile application during idea generation phase and evaluated these features with respect to multiple parameters such as customer value-add, time and effort required

Used Kano Model and Prioritization Matrix to come up with a list of features to be implemented

Designed high fidelity wireframes for these features using Balsamiq Mockups

PROCESS OPTIMIZATION

Stanford Medical Center, Palo Alto, CA

Analyzed and optimized standard medication delivery workflow using Value Stream Mapping, Gemba, Hoshin Kanri and Root Cause Analysis

Slashed Twenty-four minutes of non-value add time per workflow and increased process efficiency by 40%

Contact this candidate