Summary
Overview
Work History
Education
Skills
Timeline
Generic

Naveen Muppa

Certified Einstein Analytics Consultant, Ab Initio, Teradata, Power BI And SPOTFIRE CONSULTANT
Collierville,TN

Summary

With over 13 years of experience in the IT industry, I have developed expertise in BI using TIBCO Spotfire Professional and Tibco Spotfire Webplayer. Throughout career, I have administered, deployed, and maintained Models and Reports to ensure smooth operation of reporting solutions. My skills include gathering business requirements, analyzing business needs, and documenting business information for effective reporting solutions. I excel in training end users on accessing reports through web browsers. By utilizing best practices and proven methodologies, I have successfully modeled data, performed ETL processes, and developed BI solutions. Leveraging features such as multiple tables, visualizations, drill-down capabilities, and analytics reporting tools, I consistently deliver valuable business insights. I am experienced in designing Spotfire dashboards and reports with complex data sources and optimizing applications for a professional look. My proficiency extends to Power Center Client Tools like Designer, Workflow Manager, and Workflow Monitor. Furthermore, I am skilled in developing solutions using the Microsoft Power Platform, including Power BI, Power Apps, Power Automate, and Power Virtual Agents. With expertise in SQL Server Integration Services (SSIS), I am well-versed in package creation, dynamic configuration of packages, package deployment using manifest files, implementing transactions, and package encryption. In addition to technical skills, I possess strong analytical and problem-solving abilities that allow me to resolve complex queries independently. As a team player, I am dedicated to sharing knowledge and fostering the development of others to achieve team goals.

Overview

12
12
years of professional experience
5
5
years of post-secondary education

Work History

BI Analytics, Ab Initio and EDW Teradata Lead Consultant

FedEx
Collierville, TN
06.2016 - Current
  • Gathered business requirements and designed functional and technical requirements documentation
  • Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
  • Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
  • Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
  • Expertise in writing the dynamic queries
  • Customized data by adding prompts, Filters, Calculations, Summaries and Functions
  • Creating TERR script for predictive analysis using R statistical programming language
  • Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire
  • Connected to spotfire using different connectors like SQL, Teradata, Active Spaces
  • Achieved complex requirements i.e complex dashboards using HTML, Python and Javascripts
  • Implemented on-demand information link functionality to load the data related only to given parameters to give the better performance
  • Created the Personalized information links to maintain the data security between the users
  • Created the parameterized query to restrict the data on the spotfire front end
  • Scheduled the reports in the scheduler to keep them in webplayer cache for the better performance and give the better user experience to the end users
  • Created a landing page in .NET code and embedded our spotfire server URL’s within that .NET code and deployed that code on node manager servers and configured it with IIS to bring all the users into one single base
  • Executed the queries in the Teradata and validated the data
  • Writing the queries in the TIBCO Data Virtualization Tool (Composite Studio)
  • Use In-memory capabilities of Tibco Spotfire, Spark as well as rich Machine Learning applications with easy to use Data visualization of Models using built in TERR (Tibco Runtime R engine) and Revolution R/R Studio
  • Customized Reports by writing complex custom SQL
  • Installed and configured the different spotfire versions on physical and cloud environments
  • Responsible in applying the hotfixes, latest patches and JDK across all the environments
  • Enabled anonymous authentications across all the environments to access the spotfire report from webplayer without any login (only to some set of users)
  • Embedded the logos on our tomcat servers and passing the tomcat server URL’s in the text area to embed the image in the html script
  • Applying the certificates on all the spotfire servers and renewing them, they are about to expire
  • Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
  • Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
  • Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports
  • Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices
  • Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment
  • Provided high level, complex support services and delegate low level support to off-shore support staff
  • Experience in applying the hotfixes on the servers
  • Completing the JDK upgrades on the servers
  • Upgrading the spotfire version from one version to other
  • Implemented system modifications as per established requirements
  • Created the dashboards on Power BI using the data and also created the flow using entities in Power BI data manager
  • Prepared project estimates and analyzed reporting issues
  • Formulated dashboard specifications and generated status reports
  • Creating dashboards in Einstein Analytics Studio
  • Creating the custom SAQL and using them in the Einstein Analytics studio to build the visualizations
  • Embedded the Einstein dashboard on our Sales Force lightning internal site
  • Create the new tab within the lightning home portal and added the filter string to get the data for logged in user
  • Integrating Einstein with the ETL abinitio and jitterbit to load the data into Einstein Data Manager
  • Creating the Teradata Macros to support the business needs
  • Loading the data to oracle and Teradata using 1A jobs and created a schedule to run the Ab Initio graph on weekly basis
  • Creating the recipes in the Einstein Data Manager
  • Creating the data sets from the recipes and using those data sets to create the dashboards
  • Doing some custom changes in the Json code generated by the Einstein Analytics studio to accommodate some requirements from the business user
  • Embedding the dashboard within our internal sales force portal to make it available to the 18k users across the globe
  • To maintain the security for the dashboards on the sales force portal adding some custom filter string to display the data only related to the logged in user
  • Converting the report from spotfire to Power BI and there are around 20k plus reports and we are supporting around 300k plus users with almost 300 plus server altogether
  • Developed parameterized reports to allow users to filter data dynamically
  • Implement subreports, cross-tabs, charts, and other advanced reporting features to visualize data effectively
  • Developed stored procedures, functions, indexes, and views to support data processing and cleansing activities
  • Created DAX and tabular models using SQL Analysis Services (SSAS) in Power BI, incorporating diverse visualizations (Stacked bar chart, Clustered bar chart, etc.) based on project requirements
  • Utilized Power BI for collaborative work with users and stakeholders on live data sources, enhancing real-time decision-making
  • Developed comprehensive user guides and documentation for PowerApps and Power Automate solutions, facilitating user adoption and self-service troubleshooting
  • Automated Power BI Refresh using Power BI REST APIs in combination with PowerShell
  • Transformed data from many online data sources when importing into the Common Data Service through Power Query
  • Assisted team members in understanding and leveraging Power BI features, through hands-on guidance and support, enhancing team productivity and report accuracy
  • Facilitated communication between IT and business stakeholders to translate business requirements into actionable BI strategies, ensuring alignment with organizational goals
  • Coordinated with IT and data analytics teams to streamline data workflows, improving efficiency and data quality for Power BI reporting
  • There are 6 different clusters in spotfire and out of which 5 are on-prem clusters and the other one is hosted on Azure cloud
  • Working with all the end users in capturing the requirements and guiding them with the power bi best practices and there are some critical use cases where in the refresh interval is for every 5 minutes
  • Generated Power BI reports and automated the publishing process to workspaces, apps, ensuring the availability of the latest data
  • Ensured that the data sources used by the existing reports are compatible with the target BI platform
  • Migrated the data sources to the new platform, ensuring data integrity, security, and accessibility
  • Updated the report connections and data queries to point to the migrated data sources
  • Planned the rollout of the migrated reports in phases or batches to minimize disruptions and ensure a smooth transition
  • Implemented various DAX functions for efficient data visualization in Power BI, optimizing fact calculations
  • Conducted training sessions for business users on Power BI reports and dashboards, facilitating widespread understanding and usage
  • Pulled the data into Power BI via direct queries and importing into Power BI
  • Embedding the power bi dashboards in teams and custom angular code using the power bi APIs and also created the self-serving dashboards
  • Environment: Oracle, EDW Teradata, ETL Abinitio TIBCO Spotfire 11.X, 12.X, 10.X 7.xTIBCO Data Virtualization Tool, Spotfire Automation Services 7.0, Spotfire Statistics Services 7.0, Spotfire Webplayer 7.0, Spotfire ADS 7.6, Sales Force Einstein Analytics Studio, Einstein Analytics Data Manager
  • SQL Server 2019/2016, Visual Studio, SSIS, MS Office 365, Power BI Desktop, DAX, Jira, Confluence, SharePoint, MS Excel, MS Word, Agile (Scrum)

Spotfire Developer/Administrator

Rig Data
Dallas, TX
01.2015 - 05.2016
  • Gathered business requirements and designed functional and technical requirements documentation
  • Created, developed and supported reporting and Business Intelligence initiatives using Spotfire application suite
  • Created various complex List Reports, Grouped Reports, Cross tab Reports, Chart Reports
  • Worked on Spotfire Professional to create worksheet, dashboards and published them to Spotfire server for end user use
  • Created Database connection and Spotfire Dashboard file (DXP) in Spotfire server
  • Customized data by adding prompts, Filters, Calculations, Summaries and Functions
  • Creating TERR script for predictive analysis using R statistical programming language
  • Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Spotfire
  • Use In-memory capabilities of Tibco Spotfire, Spark as well as rich Machine Learning applications with easy to use Data visualization of Models using built inTERR (Tibco Runtime R engine) and Revolution R/R Studio
  • Customized Reports by writing complex custom SQL
  • Worked on a plan to develop the process for remote systems administration and ongoing Spotfire application enhancement and maintenance
  • Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting
  • Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports
  • Worked on developing training program, user guide for Spotfire Professional and Spotfire web player in terms of best developing and design practices
  • Experience with Spotfire application performance monitoring, capacity planning, and tuning of the Spotfire environment
  • Provided high level, complex support services and delegate low level support to off-shore support staff
  • Administered Spotfire programs and supported library management
  • Evaluated log files and implemented performance tuning
  • Supported Spotfire logs for resolution of issues
  • Participated in connection of Spotfire with SQL data sources
  • Executed the queries in Teradata and verified the data
  • Also connected to spotfire using Teradata connector
  • Implemented system modifications as per established requirements
  • Prepared project estimates and analyzed reporting issues
  • Formulated dashboard specifications and generated status reports
  • Documented and maintained practices for system installations and configurations
  • Experienced with load balanced web architecture using Apache Tomcat
  • Experienced with continuously available Spotfire Server configuration
  • Experienced with RDBS including SQL Server and Oracle, SQL skills
  • Environment: EDW Teradata, ETL Informatica, TIBCO Spotfire 7.x, 6.x, Spotfire Automation Services 7.0, Spotfire Statistics Services 7.0, Spotfire Webplayer 7.0, Spotfire ADS 7.0

Spotfire Developer

T- Mobile
Atlanta, GA
01.2013 - 11.2014
  • Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and business logic underlying the requirement
  • Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team
  • Created dashboards and applications and Spotfire workbooks(DXP) from scratch based on clients needs
  • Worked with end users to explain TIBCO Spotfire workbooks, creating ad-hoc reports
  • Installed & configured the TIBCO Spotfire on Single Server Environment, Administering the Servers, Troubleshooting, Performance Tuning and implementing security
  • Coordinated an employee training program for various Spotfire applications and basic troubleshooting principles
  • Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts/Filters
  • Delivered advanced/ complex reporting solutions such as Dashboards and Standardized Reporting With Spotfire
  • Customized Reports using HTML and JAVA SCRIPTS
  • Created Materialized views for improve the performance of the reports
  • Assigning work to the offshore team on daily basis
  • Setup Weekly Status Calls with offshore team
  • Coordinated training sessions and demonstration of Spotfire tools to End-users
  • Developed technical specification document for the offshore team
  • Extracted data from multiple complex hierarchies from cross table flat files and websites
  • Extracted data from SQL, implemented Custom Queries in Spotfire and also pulled the data Using Information Links
  • Used Iron Python to create power actions in test areas
  • Good knowledge in developing and designing reports through SSRS and Excel
  • Involved in migrating the dashboards from Development to Production environments
  • Documented the entire effort
  • The documents generated during the process were User Requirements Specifications, Peer Review Log, Design Specifications, Validation Plan, Validation Summary Reports, Release statement, Production Approval Form and Project planning documents
  • Analyze and document process along with quick resolutions for typical issues in production and which were critical to the process
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
  • Used SQL to join the data in the database
  • Perform day to day administration of Spotfire, including group/library management, upgrades, monitoring log files, performance tuning, troubleshooting and reporting
  • Developed various operational Drill-through and Drill-down reports using SSRS
  • Environment: TIBCO Spotfire 7.x, 6.x, 5.x, TIBCO Spotfire WebPlayer

Education

Masters - Computer And Information Sciences

Computer Science
South Howard, CA
01.2012 - 12.2012

Bachelors - Information Technology

Information Technology
India
01.2007 - 04.2011

Skills

  • TIBCO Spotfire Professional

  • Einstein Analytics Studio

  • Einstein Analytics data manager

  • TIBCO Spotfire Webplayer

  • Ab Initio

  • Power BI

  • Windows 2012 Enterprise Server

  • Linux

  • Application Servers (WAS, Tomcat)

  • Web Servers (IIS, IHS)

  • HTML

  • Java Script

  • Iron Python

  • Json

  • SAQL

  • DAX

  • M-Query

  • PowerShell Scripting

  • Oracle 9i/10g

  • EDW Teradata

  • TIBCO Data Virtualization Tool

  • ETL Tools: Ab Initio

Timeline

BI Analytics, Ab Initio and EDW Teradata Lead Consultant

FedEx
06.2016 - Current

Spotfire Developer/Administrator

Rig Data
01.2015 - 05.2016

Spotfire Developer

T- Mobile
01.2013 - 11.2014

Masters - Computer And Information Sciences

Computer Science
01.2012 - 12.2012

Bachelors - Information Technology

Information Technology
01.2007 - 04.2011
Naveen MuppaCertified Einstein Analytics Consultant, Ab Initio, Teradata, Power BI And SPOTFIRE CONSULTANT