APURVA NARAYANKAR

Phone No.: +1-470-***-****

E-Mail Id: ad3m1o@r.postjobfree.com

Bachelor of Engineering

Professional Profile

Total 7+ years of working experience in Business Intelligent Tools like Tableau, Power BI, Tibco Spotfire and Analytical experience.

3+ Years of experience as Business Analyst, worked directly with Client to for requirement gathering, creating documents and test cases, and increasing revenue.

Expertise in full life cycle of Business Intelligence implementation and have understanding of all aspects of implantation project using Tableau

4+ Years of experience in designing and deploying workbooks with drill down, drill through and drop-down menu options and parameterized, linked reports using Tableau Desktop and experience in data blending

Experience in creating the aggregate, hierarchies, charts, filters, quick filters, table calculations, trend lines and calculated fields using Tableau Desktop

Good Knowledge in Tableau Prep Desktop

Experience in designing and developing complex Tableau Dashboards, advanced reporting with different types of filters, parameters, calculations, actions and data blending best practices

Experience in connecting Tableau desktop to variety of data source and able to handle large amount of datasets

Experience in creating Tableau Data Extracts, publishing to Tableau Server and Scheduling / on -demand to refresh the Tableau Data Extract to get the updated data from original data source.

Performance Tuning of workbooks and data sources and providing best practices for development admin process

3+ Years of experience in implement JavaScript and HTML code in Spotfire

3 years of working experience in SQL

2+ years of working experience Software Testing processes

2+ years of work experience in providing IT support and delivering solutions to clients in the 24*7 Support project resolving tickets

Technical Skills

Visualization Tools: Tableau Tibco Spotfire Power BI

Software Methodologies: SDLC Agile Waterfall

Languages: JAVAScript Iron Python Script PLSQL HTML

Management tool: SharePoint JIRA Rally tools ServiceNow Balsamiq tool HP ALM Workday

Microsoft tools: MS Excel MS Power point Open Office Visio

Areas of Expertise

Having a strong communication skill for effective communication with technical and non-technical users

Ability to organize and plan work effectively, manage, and coordinate multiple complex activities.

Creating RFP, bidding, Business Case document, HLD, Test cases. Manage project through status meetings, weekly reports, identifying risks, and tracking issues

Increased revenue through analysis of data surrounding customer behaviours, vendor and stakeholder relationships, achieving goals, and creating workflows.

Excellent knowledge of Microsoft Office products including Visio and MS Project if required.

Provide end-user support for SharePoint.

Be experienced in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, Power BI, and DAX

Worked on writing SQL queries to get the required data from different datasets. Creating Sample data set for the business

Built out the data and reporting infrastructure from the ground up using Power BI and SQL to provide real time insights into the product.

Lead a team of 2 FTEs, facilitated meetings with stakeholders agreeing on finalizing the requirements.

Ability to analyze Functional Specification and Create Test Scenario and Scripts, prepare Test plan/Test strategy, involves in planning activities also experience in UFT automation tool

Worked on developing Iron Python scripts, HTML, JavaScript, R Scripting for enhancing Spotfire user’s enhancement.

Worked on developing JavaScript which is used to trigger IronPython Scripts

Have sound knowledge of Business Intelligence tools like Power BI and TIBCO SPOTFIRE

Able to coordinate several tasks simultaneously and integrate them into desired results, enjoy working with a team and handling team efficiently even under pressure by improving operations tactfully with substantial quality.

Great Team player with quick learner and interpersonal skills.

Good in creating test cases and test data.

Identifying, analyzing and tracking the bug through QC.

Career Highlights

CVS Health

Contract (FEB 2023: Till Now)

Analytical Tool - Tableau

Database - Teradata

●Working as Tableau Developer

●Designing, creating and implementing BI solutions for the end users

●Evaluating, repairing and improving current BI systems .

●Translating business goals into technical specifications

●Creating interactive visual reports using Tableau desktop

●Collaborating with teams and managers to help businesses develop

●Finding correlations in data to discover meaningful insights

●Identifying key performance indicators (KPI) to help companies adjust and fulfil objectives

●Wrote transact-SQL code to extract correct data to answer business questions.

●Creating thorough business requirements documentation and overseeing the approval process from the collection of requirements to approval.

●Facilitating meetings with the aim of key stakeholders agreeing on business requirements.

●Arranging for key stakeholders to examine and approve the business requirement documents before turning them over to the technical and implementation team.

●Working together with developers during the technical design and implementation phases to guarantee successful project implementation.

●Working with the UAT teams during the testing stage to ensure that the documented requirements have been delivered and are ready for deployment

Tata Consultancy Services (Sep 2013 – Apr 2017)

Analytical Tool - Tableau, Tibco Spotfire

Database - Oracle, Teradata, Greenplum

Scripting - JAVAScript, HTML, IronPython

Description:

Ensure consistency across reporting, transparency and alignment; ensure everyone has a common understanding on how to read and interpret the data

Support strategic and problem solving activities.

Support client meetings relating to project communications and produce communications as required to ensure awareness of project delivery

Collate, maintain, analyse and interpret a diverse range of complex data and information, as required. For example: identifying processes and procedures that need to be updated, improved or changed to improve performance delivery

Use appropriate methodology and tools to produce accurate and timely information in the most appropriate and useable format

Develop and maintain professional working relationships and communicate effectively with clients across the organisation and with other relevant teams and individuals to ensure effective service delivery

Used Tableau desktop to create, review, analyse, and present visual dashboard and metrics reports.

Wrote transact-SQL code to extract correct data to answer business questions.

Creating thorough business requirements documentation and overseeing the approval process from the collection of requirements to approval.

Facilitating meetings with the aim of key stakeholders agreeing on business requirements.

Arranging for key stakeholders to examine and approve the business requirement documents before turning them over to the technical and implementation team.

Working together with developers during the technical design and implementation phases to guarantee successful project implementation.

Working with the UAT teams during the testing stage to ensure that the documented requirements have been delivered and are ready for deployment

Worked as a Spotfire and Tableau Developer

Creating Iron Python script for providing extra functionality in Spotfire

Use Java Script, HTML, R script and Python scripting in Spotfire for providing additional functionalities to the user.

Propose different visualisation that makes data analysing simple

Provide business with detailed analysis and data accuracy

Worked on Oracle 11 G, Greenplum

Company Name: INFOSYS (Jul 2011 – Sep 2013)

Analytical Tool : SPOTFIRE-Business Intelligence Tool

ETL : Oracle Application Express (APEX)

Database : SQL Server

Data Mining Tools: MAP, Nielsen-Answers (AOD), Advisor and Aztec

Description:

Working as an Analyst for Strategic Revenue Management (SRM) of the client.

Extracting data from database using SQLDeveloper tool, analysing the data that has been finalized by the business team.

Creating and Analysing the Strategic reports for SRM drivers (Price, Promotion and Mix) based on the Trade Panel data, 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 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.

Roles & Responsibilities

Feasibility study, Set up Designing, Implementation, Analysis and Quality checks.

Preparing the UAC’s, providing assistance to the Effort estimation Team and creating the CPS for current Project.

Responsible for the executing the advance SQL queries, procedure, cursor, triggers, scripts.

Also created, modified, maintained and optimized SQL server database.

Maintained the documents and create reports for the business analysts and end-users.

Responsible for the management of the database performance, backup, replication, capacity and security.

Feasibility study, Set up Designing, Implementation, Analysis and Quality checks.

Preparing the UAC’s, providing assistance to the Effort estimation Team and creating the CPS for current Project.

Responsible for the executing the advance SQL queries, procedure, cursor, triggers, scripts.

Also created, modified, maintained and optimized SQL server database.

Maintained the documents and create reports for the business analysts and end-users.

Responsible for the management of the database performance, backup, replication, capacity and security.

Contact this candidate