Management Project

Arati Paramale Email: *************@*****.*** Bachelor in Engineering (E&TC) Mobile: +91-740*******/960-***-****

Objectives

To use my communication, experience and inter-personal skills and be a part of the booming industry so that I can create a niche for myself in the organization I work for.

Overall Work Experience – 4.0 years

Technology Expertise: Tibco Spotfire 4.5, 5.0, 6.5

Current organization

Organization : Quintiles Research Technologies (India)

Designation : Sr. Programmer, CDP

Client : Amgen

Duration : Jul-2014 – Till date

Project Title: Amgen Spotfire reporting

Duration: July 2014 to Till Date

Role Description

Experience on creating data visualization dashboards, multi tab reports using Tibco Spotfire.

Knowledge of tuning Spotfire dashboards for performance issues.

Design and create Information Links for reusability across reports.

Proficient with creating Information links, In-memory and On-demand report creation

Share and follow the best practices in the areas of reporting, modelling and dashboards.

Strong background in SQL

Experience of publishing dashboards using Spotfire Web Player.

Excellent written and oral communication.

Consultant Spotfire

Hands on experience in Design, Development, Testing, Deployment and support of BI reporting tool like TIBCO Spotfire

Experienced with TIBCO Spotfire suite including TIBCO Spotfire professional and TOBCO Spotfire web player.

Expertise in complete Project life cycle process for providing reporting solution that involves gathering Business requirements, Analyzing business needs, documenting design specifications, implement document, Test cases and Test results.

Experienced in Data Analysis, interaction with ETL team for dataset creation, information links, Dashboards, visualizations for KPI s using calculated columns, custom expressions, Drill down, Text Areas, cross table, Pie chart, Bar char etc. using Spotfire professional client.

Expertise in designing Spotfire dashboards/ reports with complex multiple data sources

Previous Organization - I

Organization : Infosys

Designation : Process Specialist/ Sr. Process Executive

Client : Procter & Gamble

Duration : December-2011 to July-2014

Project Title I: SRM_RP- Revenue Pulse Management

P&G ReSS (Reporting Shared Services) 2.7 years of experience in emerging markets & retail analytics domain with strong knowledge on Microsoft packages, Spot Fire Client professional. Proficient knowledge on strategic insights and actionable analysis of P&G and handling portfolio management.

Role Description

Handling a team of 4 members who are into a development of Spotfire visualization which is a part of retail analytics of P&G.

Provide estimation on FTE inclusion & exclusion & impact analysis in all new requests which comes in as a part of process.

Cost estimation

Change Management

Quality & Timeliness of projects as aligned with Business teams

Lead implementation of Keystroke Automations across reports

Program, Project & Team management

Stake-holder management and Escalation handling

Worked as a Process Analyst for Strategic Revenue Management of P&G’s.

Consultant Spotfire

Creating and Analysing the Strategic reports for SRM drivers (Price, Promotion and Mix) based on the Trade Panel data and Point of Sales data.

Creating Spot fire matrix, visualizations and providing Business insights to the end users and resolving the issues in Frontend (Spot fire) and Backend (Oracle).

Driving the Strategies by comparing Procter& Gamble Products with the Benchmark products using the Corridor limits based on the current market trends, historical data and Product performance of YOY/FYTD/IYA.

Providing crucial Business insights on SRM Portfolio: Product Mix & Hierarchy based on Product prices, Market Price (all the competitors), Inflation rate, Depth of Discounts offered, Volume Sold on deal, Value/Volume shares of products at different levels(Category/Company/Segment/Brand/Sub-brand/Form/Size/items) and tracking at GBU and MDO level.

Support to the entire BA's for Revenue Pulse Global templates on Spot fire

To study various segments (e.g. Beauty, Healthcare) of P&G’s GBU to know the classification of product so that comparison is made between P&G’s product with competitor’s product (which is generally market leader in that segment).

Edit and execute the set of SQL queries to manipulate the data & make it ready to use format.

Creating SPOTFIRE matrix & visualization providing Business insights to end users and resolving the issues in Front End (Spotfire) & Back End (Oracle)

Project II: iZOOM (Master Data Management)

Duration: AUG 2012 TO NOV 2012

Role Description

Data cleansing, data cleaning and data uploading to server

Getting the raw data from client.

Preparing it in required format i.e. data cleansing and providing it to end user. Also used to manage the database provided by client

Project Title III: Initiative Tracker

Duration: NOV 2012 TO July 2014

TOOL USED: - Nielson Answers, AOD, Nielson Advisor, Aztek, Intage, TIRA, Source One, MAP, Informatica, Counter Insights, Tibco Spotfire

ETL- TOAD (back end- Oracle), Informatica

Type of data handled: Shipment data, Consumption data, financial data, Household Panel data, Sales Fundamental data, Media data

Role Description

Product (brand of P&G) contains different sizes of SKU of FPCs. Tracking of these FPCs under different markets. Setting up the forecast for particular brand in initiative tracker.

Providing the Actual numbers for products i.e. how much the product has been sold in the market using different data sources.

To study the various segments (Skin care, Oral care) and providing insights of product VS competitor

Academic Profile

Degree

University

Year

%

B.E. Electronics and Telecommunication

University of Pune

2010

63.93

Certifications

Certification in ‘C’ PROGRAMMING with ’A’ grade from SEED InfoTech, Pune

Certified for ASP.NET3.5 from NIIT Institute, Pune

Awards and Recognition

Trained by British Council in Professional Communi Care

Achieved Star Performer Award (within 6 months) for SRM RP project- providing the detailed analysis to business in Infosys BPO Services.

Achieved Star Performer Award for Initiative Tracker.

Achieved Special Achievement Award (within 4 months) for APT (Amgen Programming Team-Spotfire) project in Quintiles Technologies.

Trainings:

1.Customer Orientation, Analytical thinking

2.Retail Analytics domain training

3.People management

4.Business Communication

5.Risk management

Contact this candidate