Sri Harsha

Mobile: 940-***-****

Summary:

. Having 7+ years of experience in Business Intelligence, Data

warehousing, Data architecture, Data modeling.

. Experience including analysis, modeling, design, and development of

Tableau, Microstrategy, reports and dashboards for analytics and

reporting applications.

. 5 years of experience working with visualization tools like Tableau

and Microstrategy.

. Have good understanding of Tableau architecture, design, development

and end user experience.

. Extensive experience in Tableau Desktop, Tableau Server and Tableau

Reader in various versions of Tableau 6.x/7.x/8.x.

. Extensive knowledge in various reporting objects like Facts,

Attributes, Hierarchies, Transformations, filters, prompts, Calculated

fields, Sets, Groups, Parameters etc., in Tableau.

. Worked on the development of Dashboard reports for the Key Performance

Indicators for the top management.

. Experience in creating different visualizations using Bars, Lines and

Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat

maps and Highlight tables.

. Expertise in Pareto charting, advanced calculations, work with

demographic and geographic fields.

. Excellent analytical and problem solving using QlikView, tableau and

SQL debugging skills.

. Very proficient in working with large Databases in DB2, Oracle,

Teradata and SQL Server.

. Experience in data modeling with high proficiency in using Erwin for

Dimensional Modeling (Star and Snowflake schemas).

. Strong understanding of Data warehouse concepts, ETL, Star Schema,

Snowflake, data modeling experience using Normalization, Business

Process Analysis, Reengineering, Dimensional Data modeling, FACT and

dimensions tables, physical and logical data modeling.

. Experienced in developing rich Interactive reports and dashboards

integrating various reporting components from multiple sources.

. Team player and self-starter with good communication skills and

ability to work independently and as a part of the team. Experience in

working with big projects.

. Excellent multitasking capability, efficiently plan and prioritize

projects with strong technical and business management skills.

Technical Skills:

Databases MSSQL Server 2008/2005/2000, Oracle (10g/9i/8i),

MSAccess, IBM DB2 (8.2/8.0). Netezza

BI Tools Tableau8.0/7.0/6.0, Microstrategy, Business Objects

Programming C, C++, SQL, PERL, Core Java, HTML.

Languages

Tools Adobe Photoshop Report Builder

ETL SQL Server Integration Services (SSIS), SQL Server

DTS

Design Tools ERwin, MS Visio.

Scheduling Tools Autosys, Maestro/Tivoli, crontab

Office Tools Office Suite 2010.

Professional Experience:

Client: Charter Communications, St. Louis, MO Mar'2014 - Present

Role: Tableau Analyst/ Developer

Description:

. Statistical Analysis of the data provided by the company to compare

and analyze various measures including merchant categories, location

and fraud detection.

. Identifying potential areas for promotional and marketing activities.

. Designing dashboards with multiple actions and drill down functions to

make it available for business users, with ability to filter and dig

in detail into KPIs and thereby analyze data for marketing and

promotions.

. Integrating interactive location maps with the data analytics based on

various filters and actions.

. Making custom calculated fields for ease of access and effective

visualization.

Responsibilities:

. Work closely with the Business Analyst to develop the visual analytics

for the given data and make it available online and on mobile

products.

. Create Tableau worksheets, design, develop dashboards and publish.

. Working with large volumes of datasets and loading delimited files

into tableau Server Sources.

. Develop Scripts to load data into tableau and work with multiple data

connections including Hadoop/Hive and by data blending.

. Using table Calculations and User Filter in tableau.

. Using Actions in order to provide additional drill down functionality

and Linking to other tableau reports.

. Maintaining permissions of Tableau Views and Dashboards.

. Extensively worked on parameters, pareto charting, mapping,

calculations, demographics and geographic fields.

. Worked with string functions, date calculations and swapping

dimensions with parameters.

. Constantly monitor the accuracy of the data and modify the measures as

per the business requirements.

. Forecasting demand and consumption patterns. Fixing bugs and updating

the software periodically.

Environnent: Tableau 8.1.4, Hive/Hadoop, Vertica, sql, DB2 V9.x, Oracle,

Java Script, PHP, HTML 5.

Client: Ryder, Miami, FL Oct'2012- Feb'2014

Role: Tableau Developer

Description:

. Identify new metrics and enhance the existing KPI's.

. Define best practices for Tableau report development.

. Dashboard Visualization through Tableau BI application.

. Analyzing the data using Statistical features in Tableau to develop

trend analysis.

Responsibilities:

. Gathering the clients, Suppliers and internal resource data from all

the Vendor Management Systems.

. New KPI generation for Scorecards.

. Data collection and leveraging on data manipulation teams for required

data.

. Developed complex SQL scripts for Teradata database for creating BI

layer on DW for tableau reporting.

. Building, publishing customized interactive reports and dashboards,

report scheduling using Tableau server.

. Created action filters, parameters and calculated sets for preparing

dashboards and worksheets using Tableau.

. Effectively used data blending, filters, actions, Hierarchies feature

in tableau.

. Administered user, user groups, and scheduled instances for reports in

Tableau.

. Executed and tested required queries and reports before publishing.

. Converted metric insight reports to tableau reports.

. Working extensively with Tableau Business Intelligence tool to develop

various dashboards.

. Working extensively using Excel to validate the data and use as the

source data files.

. Hands-on development assisting users in creating and modifying

worksheets and data visualization dashboards.

Environment: Tableau Desktop 7.0.2, Excel 2013, Outlook 2013, VMS Systems,

Microsoft Office Suite (Word, Excel, Power Point, Visio).

Client: Super-value, Eden Prairie, MN

Jun'2010-Sep'2012

Role: Tableau Analyst

Description:

. Utilized Warehouse Catalog to pull new tables from Data warehouse as

well as manage any updates to the existing tables.

. Created adhoc reports to users in Tableau by connecting various data

sources.

. Designed and developed Documents and Dashboards using multiple

datasets.

. Designed dash boards for actionable, non-actionable complaints from

Multidimensional database

Responsibilities:

. Worked with Business Analyst and the Business users to understand the

user requirements, layout, and look and feel of the application to be

developed.

. Worked on Universe enhancements updating the tables, adding new

tables, Joins, detecting loops. Created additional contexts, new

dimension and measure objects in the Universe

. Generated Dashboards with Quick filters, Parameters and sets to handle

views more efficiently.

. Published Workbooks by creating user filters so that only appropriate

teams can view it.

. Used excel sheet, flat files, CSV files to generated Tableau adhoc

reports.

. Generated context filters and used performance actions while handling

huge volume of data.

. Generated tableau dashboards with forecast and reference lines.

. Used filters, quick filters, sets, parameters and calculated fields on

Tableau reports.

. Generated Tableau dashboards with combination charts for clear

understanding.

. Generated dashboards using dual axis for comparison.

. Generated Dashboards by joining multiple complex tables.

. Involved in creating and visualizing dashboards using Tableau Desktop.

. Generated Tableau combination charts using Tableau visualization

software.

Environment:-Tableau Desktop 6/7, Teradata, Oracle, Windows XP.

Client: IBEEE, India

Aug'2008 -Apr'2010

Role: Sr Microstrategy Consultant

Description:

. Preparing MicroStrategy development estimation for schema and

application objects.

. Designing dynamic Dashboards using MicroStrategy Report services

sourcing from Intelligent Cubes.

. Building huge intelligent cube and performance tuning using VLDB

settings

. Freeform SQL reports in Microstrategy.

.

. Responsibilities:

. Importing data from various formats as Csv, Excel to build cubes by

user and create reports.

. Working with Passthrough functions.

. Implemented Report bursting to file location for delivery to

widespread userbase.

. Participating in user and security group maintenance.

. Creating & maintaining schedule objects to create caches for

dashboards, reports, Intelligent Cubes.

. Extensively used filters, prompts, metrics, consolidations and custom

groups to generate reports.

. Working on customizing and optimizing the query performance of reports

using MicroStrategy features like VLDB settings.

. Involved in preparing technical design for MicroStrategy reports.

. Involved in migration of Qlikview reports to MicroStrategy reports.

. Managing schema objects and application objects across the projects by

using Object Manager

. Developed mobile reports and Dashboards for Tablet users.

. Provided training to the users, created documents for the users,

involved in customer support and stabilize the report in production

environment.

. Configuring and creating reports based of Hive.

. Using Object Manager package for doing migrations from Development

environment to Testing and Production.

. Scheduling various jobs using Opswise to use Event based triggers on

cubes.

. Incremental load of data into cubes to include the data which are at

different levels

. Managing Onsite - Offshore coordination for development.

. Using Time Series, Network Analysis and Information box widgets on

Ipad.

Environment: Microstrategy 8.1, Intelligence Server, Web, Hive, Greenplum,

Windows 7.

Client: Ztech Solutions, India May'2007 -

Aug' 2008

Role: Microstrtegy Developer

Description:

. Tuned Microstrategy implementation for greater performance based on

recommendations from internal testing.

. Periodic maintenance of Intelligence server and Narrowcast server

installation in all environments to determine the current state of

server parameters, performance, as well as identify potential issues

and limitations.

. Best Practices using standardized methodology for coding, development,

test and implementation processes.

. Create and manage MicroStrategy application objects, schema objects

and configuration objects.

. Define/Create system hierarchy/user-defined hierarchy and controlling

(lock, limit and filter out) the attribute elements in hierarchy.

. Responsibilities:

. Defined advanced prompt expressions to create Hierarchy prompt, prompt-

in-prompt and nested prompts

. Created KPIs and Metrics to analyze the existing system usage and

performance using Enterprise Manager Tool.

. Implemented Narrowcast tasks like service designs, subscription,

scheduling and administration.

. Provide optimum performance and scalability through Multi-pass SQL,

Aggregate tables and VLDB settings.

. Command manager Scripts for creating Users.

. Migration of objects using Object manager between environments.

. Automate all repetitive tasks, and allow them to be initiated on time-

based or event-based triggers.

Environment: MicroStrategy 7.5(Desktop, Administrator, Intelligence Server,

Web, Architect, Agent), Object Manager, SQL Server, Oracle 10G, Toad, UNIX,

Jira

Contact this candidate