Resume

Sign in

Data Analyst Assistant

Location:
San Jose, CA
Posted:
December 27, 2020

Contact this candidate

Resume:

MANASI TELANG

408-***-**** adiy7a@r.postjobfree.com www.linkedin.com/in/manasi-telang

PROFESSIONAL SUMMARY

•Business Analyst professional with over 2+ years of experience in IT Industry

•Exposure and experience in various Software Development Life Cycle methodologies such as Waterfall and Agile-Scrum environment.

•Significant experience in conducting different sessions with various stake holders to gather requirements, analyze the requirements and document the requirements for fostering the other phases in project life cycle

•Skilled in creating interactive dashboards and reports using Tableau

•Hands on experience in writing SQL queries for data analysis

TECHNICAL SKILLS

Operational tools Tableau, Salesforce, Microsoft Office, Google Docs, Azure XP, MS Visio, Jira, Excel

Development Methodology Agile Software Development, Scrum, Waterfall, SDLC

Programming Languages R

Database Oracle MySQL, Postgres, MySQL

WORK EXPERIENCE

Graduate Teaching Assistant- San Jose State University Sep 2020- Present

•Teaching assistant for the course Business Analytics at San Jose State University

•Reviewed examinations, assignments and projects

Data Analyst Intern- Infinite Options, San Jose June 2020- August 2020

Developed visualization dashboards, created stories and interacted with stakeholders to understand the requirements and provide business insights with data crunching

Built an interactive Tableau dashboard for profitability analysis which highlighted the value additions that helped the stakeholders to make effective business decisions

Normalized data by joining together disparate data sources and brought consensus on a common data format to be followed by all stakeholders

Business Analyst - Tata Consultancy Services, Bangalore Sep 2016 - May 2018

Performed Document Analysis and conducted Stakeholder meetings to elicit, analyze, and validate high level functional requirements

Defined, analyzed and prioritized product requirements, product roadmap, and user stories

Managed SCRUM meetings and tracked progress on tasks with offshore teams to meet product deadlines

Performed data analysis on people data using advanced SQL queries like group by, order by and joins. Also used Excel functions like Pivot table, Index, VLOOKUP and Match

Identified, analyzed and translated the functional and non-functional business requirements into concise user stories, system use cases that contributed to efficient software development

Developed and implemented Databases, data analytics and other strategies to optimize statistical efficiency and quality

Worked with full-SDLC lifecycle - release planning, product demos and sprint retrospectives

Generated functional specifications document, requirement traceability matrix and use case documents and diagrams for higher management

Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Component Diagrams, Data Flow Diagrams, and Flow Charts using MS Visio/Azure XP

Awarded the global team excellence award for managing complex projects at TCS

EDUCATION

MS in Engineering Management San Jose State University (GPA- 3.83) Jan 2019 – Dec 2020

B.E in Computer Science Visvesvaraya Technological University, India (GPA- 3.56) Aug 2012- 2016

ACADEMIC PROJECTS

Individual Medical Expense Prediction Engine Jan 2020- May 2020

Analyzed historical patient’s data and found the major factors that contribute to higher expenses in personal medical care such as smoking, aging, and BMI

Found correlation between personal medical expenses and factors affecting it and utilized these factors to build a personal prediction engine using R that makes predictions using algorithms like Linear Regression

Data Mining and Analysis of Chinook Musical Store Database (SQL-PostgreSQL, Tableau) May 2020- June 2020

Analyzed the Chinook team’s customer, employee, and invoice information to identify the criteria for extending the monthly membership of their customers and derive insights based on sales data

Cleaned and queried the data using SQL joins and aggregations to find the distribution of purchases per customer

YouTube Data and Tableau Visualization July 2020- August 2020

Built an interactive Tableau dashboard that displays the number of viewers in the different states and cities of the US, top 10 videos, viewers per category, and the number of likes vs dislikes in each Category

CERTIFICATIONS

Udacity Nanodegree in Business Analytics, Lean Six Sigma Green Belt Certified, Scrum and Agile Certification (Udemy), Certified Business Analyst from Top Grads, SQL for Data Analysis (Udemy), Creating Interactive Dashboards in Tableau (Udemy) and Team workflows in JIRA



Contact this candidate