Business Analyst

Astha Tripathi Sammamish – *****

Contact No: +1-425-***-**** Email: *******@*******.***

CAREER OBJECTIVE

A Lean Six Sigma Certified professional with 5.0 years of experience, seeking assignments in /Market research / Data Analytics/Business Intelligence/ Client Service / Business Analysis with an organization of repute.

PROFESSIONAL EXPERIENCE

I have overall 5.0 years of experience in Business Analysis, Charting & Reporting, Data Management & Analytics, and Market Research across various industries including CPG, Retail, Healthcare and Pharma Industry.

(April 2011 – October 2013)

Organization - Genpact, Bangalore (India)

Category - Market Research (Data Analysis & Business Insights)

Team - IRI Germany (Business Intelligence) & IMS Germany (Client Service)

Designation: - Senior Research Associate

IRI Business Intelligence Team :

Worked with IRI Germany Business Insights Team as a key member mainly into Charting, Reporting, Data Analysis and Business Insights. Creating Market Intelligence Research reports based on the business issue.

Creating framework for the business issue, extracting and refining data, quality controls it, analysis it, provides insights and gives actionable recommendations.

Providing actionable insights into performance of categories in Grocery, Health & Beauty Care, Household, Personal Care. Use strong analytical skills to deliver results using simple ad hoc reports and presentations

Creating a structured approach to answering German CPG clients business questions using POS data and open sources. Develop SWOT, PEST,BCG, Porter’s five force analysis report

Conduct Research, Profile companies and identify low hanging fruits

IMS Germany (Client Service) Team

Market Share Analysis and Reporting, Key Brand Performance Metrics, Consumer Behaviour regarding consumption of food items, popular premium brand Measures etc. Analyzed the reports to understand the sales metrics and depict the performance trends of the client products in different geographical regions of Germany.

Generated Sales and Performance reports (Weekly, Monthly,quarterly and annual) using various data extraction tools (Dataview, Sales analyzer, Power charts, Think Cell, Pads, Champ, Plus Suite, Xlerate) to analyze their business in various regions of Germany. Trained new team members with various tasks involved for deliveries

Proficiency with MS Office Tools (Word, Advance Excel, PowerPoint) and SQL

Key Project Undertaken:-

• Completed Lean Six Sigma Project for a client Murnauer.

• Feasibility study on Pharmaceutical, CPG and retail Companies in India

• Automation of reports( L’Oreal & Bayer) by using lean and Six sigma

(Aug. 2009 – April 2011)

Organization: - Star Health & Allied Insurance Co. Ltd, New Delhi

Designation: - Senior Officer

Department: - Client Service

ROLES & RESPONSIBILITIES

Interact with Client Delivery Team on customer requirements

Basic intelligence, analysis and aptitude for understanding requirements

Communicate with new and existing clients to understand their (and changes to) requirements and document them.

Analyze requirement and propose business solutions to clients.

Responsible for preparation of client specific weekly, monthly and quarterly reports.

Writing Business Insights, Product and Competitor Analysis and Report optimization of client requests.

Working independently on numerous data sources while integrating them for deriving valuable insights.

In depth analysis of reports and analyze the present market trend.

Deriving inferences from complex client specific standard presentations.

(April 2008 – Sep. 2008) Internship

Organization: - Adidas India Marketing Pvt Limited, Corporate office- Gurgaon

Category: - Research on Retail Market & Mall Development in India

Designation: - Management Trainee

Department: - Marketing

ROLES & RESPONSIBILITIES

Analysis on data pertaining to footfalls in malls, Anchor Stores & to find out the Peak Hours

Research on marketing strategy of Adidas in India

Assist with CRM data management at Adidas.

Study on Consumer's Buying Behavior.

Visual Merchandising at Adidas stores.

Training & Development Programme at Adidas.

EDUCATIONAL QUALIFICATIONS

MBA in Marketing from International School of Business & Media (ISB&M) in 2009

B.Sc. (Physics & Maths) from CSJM University Kanpur in 2006

Schooling from S.V.M Inter College (Kanpur)

ADDITIONAL QUALIFICATIONS

18th Months Master Diploma in Computer Information and System Management.

Six months certificate course (A1) in German Language from Max Mueller Bhavan, Bangalore.

Career Attainments:-

Appraisal Comments: "shown a lot of initiative and drive", "Quick Learner", "done tremendous work", "An excellent team player", "Exemplary contributions"

Member of Sponsor Team of Annual Festival (Fiesta-2008&2009).

2nd Prize in Debate competition organized by the Interact Club during school

Participation in NDTV Programme ("Building brand India" and "Indian of the year") in IIM KOLKATA.

PROJECT AND LIVE ASSIGNMENT

Marketing strategy of Nokia in India.

Lifestyle retailing and visual merchandising of Peter England & Shopperstop.

Business communication project on customer relationship management.

Project on comparison between two retail firms [ Pantaloons and West Side ]

KEY STRENGTH

Excellent Verbal & Non Verbal Communication Skills, Good research acumen

Proficiency with SQL, Advance Excel, and Power Point Presentation

Adaptable, Team player, Quick Learner, Good at analytical skills

Positive learning and working attitude, Ready to take new challenges

PERSONAL INFORMATION

Date of Birth : 09th November 1985

Languages : English, Hindi, German (Basic)

MOTTO IN LIFE

Imagination is more important than knowledge - So always put your thinking cap on.

Contact this candidate