Candidates About

       

             Praneeth Murarishetty                                           

PROFESSIONAL SUMMARY:

·         Around 8 years of professional experience in Business Intelligence, Software Design, Modeling, Development and Implementation in Information technology with skills in all phases of Data Warehouse lifecycle development.

·         5+ years of extensive Tableau Experience in Enterprise Environment, in Tableau 10.1/ 9.x/8.x/7.x as a Developer and Admin.

·         Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 10 desktop/Server.

·         Extensive working experience in creating visualizations and Dashboards using Tableau Desktop.

·         Proficient in designing and creating various Data Visualization Dashboards, worksheets and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization utilizing Tableau Visualizations according to the end user requirement.

·         Good knowledge of System Development Life Cycle (SDLC), Agile and Waterfall development environments.

·         Posses' strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.

·         Strong experience in SQL and PL/SQL stored procedures and functions.

·         Created various actions in database like filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet.

·         Defined best practices for Tableau report development. 

·         Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.

·         Involved in installation of SAP HANA 1.0.17 in two environments.

·         Excellent knowledge on Tableau Architecture and new features.

·         Strong skills in Data Analysis, Data Requirement Analysis, and Data Mapping for ETL process.

·         Prepared different highly formatted financial reports such as consolidated income statements and balance sheets using Crystal Report and Ad-hoc reports using Web Intelligence.

·         Experience in administration activities like creating and managing repositories, monitoring/granting permissions and rights to users, user groups through Central Management Server.

·         Hands on experience in SAS programming for extracting data from Flat files, Excel spreadsheets and external RDBMS ORACLE, Teradata tables using LIBNAME and SQL PASSTHRU facility.

·         Publishing and presenting dashboards on web and desktop platforms.

·         Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.

·         Experienced with ETL tools like Informatica, SSIS, SSRS, SAS.

·         Excellent interpersonal and customer relational skills. Proven communication, presentation skills and leadership qualities.

·         I used SQL, Cloudera Hadoop and Hive, Apache SOLR, MapReduce, Amazon Redshift.

·         Ability to handle multiple tasks and work independently as well as in a team.

·         Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps. Effectively used Data blending feature in Tableau.

·         Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.

·         Experience in documenting the testing process using MS-Office tools including MS-Word, MS-Excel, and MS-Project.

 

TECHNICAL SKILLS:

Data visualizations/Reporting tools	Tableau Desktop/ Server 10.310.1//9.3/9.1/9.0/8.0 Tableau reader/Public Alteryx 11.0.
Programming/Scripting Languages	SQL, TSQL, PL/SQL
Databases	Microsoft SQL Server 2012/2008/2005,IBM, Postgre SQL, DB2, Teradata, Postgres Sql, SAS MS Access 2003, Oracle11g/10g/9i/8i.
Methodologies	Waterfall, SCRUM and Agile, Complete Software Development Life Cycle, Iterative, Scrum.
Operating Systems	Windows/Mac
Web Tools	PowerShell, Batch, Python.
Productivity Tools	MS Word, MS Excel, MS PowerPoint, MS Visio, MS Project, Erwin

 

Client: Micron Technologies, Boise, ID                                                                 March2017-Present

Role: Tableau Developer/Admin  

Description: Worked on the Administering Tableau Server as well as created dashboards related to Tableau Admin views and also helped other departments in developing Tableau Dashboards and published them to the Tableau Server for interactive usage.

 

Responsibilities:

·         Upgraded Tableau Server from 9.3.8 to 10.1.6

·         Migrated the server from a VM to Physical server to improve the performance.

·         Responsible for interaction with business stakeholders, gathering requirements and managing the delivery.

·         Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary reports and dashboard using KPI’s.

• Enabled SSO to SAP HANA data source from Tableau environments.
• Used Alteryx to modify the data.
• Experienced in writing scripts to remove inactive users on the server.
• Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.

·         Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.

·         Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.

·         Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.

• Connected to Tableau Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style.
• Created scripts to send automated alerts when ever restore or backup fails.

·         Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.

·         Coordinated database middleware issues with DBA's, query performance with System Architects

·         Created organized, customized analysis and visualized projects and dashboards to present to Senior Level. Defined best practices for Tableau report development.

·         Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

·         Provided 24/7 production support for Tableau users.

 

Environments: TableauDesktop10.1/9.3, Tableau server/Administrator, SQL developer, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office.

 

Client: Sirius xm radio, Farmington hills, MI                                                        Feb2016-Feb2017

Role: Tableau Developer/Admin

Description: Worked on the Administering Tableau Server as well as created dashboards related to Tableau Admin views and also helped other departments in developing Tableau Dashboards and published them to the Tableau Server for interactive custom.\

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau.
• Created and updated server architecture for scheduling tasks
• Used calculated fields extensively for different logics for Trend, Extended price calculations for the different cost types.
• Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
• Building, publishing customized interactive report sand dashboards, report scheduling using Tableau server.
• Creating users, groups, projects, Data connections, settings as tableau administrator.
• Developed Dashboards using OLAP cubes.
• Extracted data from the database using SAS/Access, SAS/SQL procedures to create datasets.
• Ad-hoc ETL, Reports requirement runs.
• Extensive usage of Amazon web services(AWS) for connecting to the data sources on cloud using Amazon redshift services
• Use of Java script for creating the client side validations in the webpages with dashboards.
• Use of Java script for embedding the dashboards on the webpages.
• Involve dincreatingdashboard sand reports in Tableau9.3andMaintainingserveractivities, user activity, and customized views on Server Analysis.
• Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.
• Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for logistics calculation and department spend analysis.

 

Environments: TableauDesktop9.0/9.3.0, Tableauserver/Administrator, SQLdeveloper, SSIS, OLAP, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

Client: Penguin random house, Broadway, NYC                                                     July2015-Jan2016      

Role: Tableau Developer

Description: Gathered information from the business and developed dashboards based on the requirements given. Also, designed KPI dashboards as well. Helped the team to create dashboards using Tableau

Responsibilities:

·         Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

·         Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.

·         Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.

·         Hands-on development on assisting users in creating and modifying worksheets and data visualization dashboards.

·         Access dashboards from any browser or tablet.

·         Created incremental refreshes for data sources on Tableau server.

·         Analyzed user and business requirements attended periodic meetings for changes in the application requirements and documents.

·         Involved in license management SLA's with Tableau support.

·         Defined and created procedures to install Tableau desktop in silent mode.

·         Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.

·         Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

·         Creating users, groups, projects, Data connections, settings as a tableau administrator.

·         Ad-hoc ETL, Reports requirement runs.

·         Created visualization for logistics calculation and department spend analysis.

·         Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.

Environments: TableauDesktop9.0/8.3, Tableauserver/Administrator, SQLdeveloper, SSIS, Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007

 

Client: State Street, Quincy, MA                                                                          Mar2014-Jun2015   Role: Tableau Consultant

Description: State Street Corporation is one of the world's leading providers of financial services to institutional investors, including investment management, investment research and trading and investment servicing. The project dealt with Creating Dashboards for the HR department based on complete overview, new hire, terminations, changes, trends and employment compensation.

 

Responsibilities:

·         Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

·         Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

·         Implement info graphics and Dash boarding for data visualization.

·         Used different Mark types and Mark properties in views to provide better insights into large data sets. 

·         Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

·         Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

·         Integrated the tableau reports to other portals.

·         Provided reporting solutions for OLTP and OLAP systems.

·         Published Workbooks and Dashboards to the Tableau server. 

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

·         Extensively used Adadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.

·         Experience in converting OBIEE content into Tableau BI content.

·         Experience in providing Tableau server and tableau desktop training.

·         Experience with Teradata.

·         Experienced with trouble shoot of Teradata connection.

·         Tested reports and uploaded tableau dashboards onto server and provided production support for tableau users.

 

Environment: Tableau 7.0/6.0, Tableau server, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows2003/XP, UNIX.

 

Client: Dex media, Santa Monica, CA                                                                       Nov2012-Jan2014

Role: Tableau Developer/Admin

Description: The goal of the project is to create a central repository for all data related to Merchants, Merchant Products, Equipment’s, Charges Applied needed for reprocessing, recovery, reporting, and retention across mid-range applications and develop various analytical reports, dashboards on the same.

Responsibilities:

·         Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.

·         Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. 

·         Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives

·         Experience in standardizing Tableau for shared service deployment.

·         Developed Standard Operating Procedures (SOP) for Monitoring.

·         Extensively used data blending, embed functionalities in Tableau.

·         Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.

·         Generated server side PL/SQL scripts for data manipulation and validation and created various materialized views, global temporary table.

·         Generated scripts for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, Stored Procedures, roles and granting privileges.

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

·         Hands-on development, assisting users in creating and modifying worksheets and data visualization dashboards.

·         Involved in license management SLA’s with Tableau support.

·         Defined and created procedures to install Tableau desktop in silent mode.

·         Defined best practices for Tableau report development.

·         Provided 24/7 production support for Tableau users.

·         Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

·         Combined visualizations into Interactive Dashboards and publish them to the web. 

·         Migrated Workbooks and Dashboards from Tableau 7 to Tableau 8.

·         Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

 

Environments: Tableau server/Administrator, Tableau Desktop v7/v8, Windows Server Standard R2, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL.

 

Aurobindo Pharma, India                                                                                         Dec2010- Sep2012

Role: PL/SQL Developer

Description: Aurobindo Pharma is one of the leading Indian pharmaceutical research companies that manufactures and export drugs and formulations worldwide.

Responsibilities:

·         Developed PL/SQL Packages, Procedures and Functions for Various Extract Process run through UNIX Jobs.

·         Coded PL/SQL Packages and Procedures using Bulk Binding, for all Statements, DynamicSQL and Cursor Variables.

·         Tuned PL/SQL Packages and Procedure to manipulate large no of data using collections like nested tables and arrays.

·         Tuned Large Complex Queries and Improved Performance of PL/SQL procedures.

·         Created Schema Objects like Tables, Views, Materialized views, Sequences, Constraints, and Indexes.

·         Developed and Deployed Traders Oracle REPORTS in Oracle Application Server 9i.

·         Generated Oracle FORMS and REPORTS using Designer 6i.

·