Summary
Overview
Work History
Education
Skills
Certification
Projects
Personal Information
Websites
Timeline
Generic

Parameshwar Sangangiri

NJ

Summary

Senior BI Engineer with extensive experience in data visualization and cloud services at J&J. Achieved a 25% reduction in operational activities through automation while leading cross-functional teams. Proficient in Python and SQL, delivering impactful business intelligence solutions.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Sr. BI Engineer

J&J
08.2019 - Current

• Lead the technology initiatives, demonstrate business values with POCs,

develop best standards, mentor teams, and collaborated with business and

App teams to build complex systems that support Business Intelligence,

Analytics and R&D needs.

• Tableau Server to Tableau Cloud Migration with setup of OpenID

Connect/SAML SSO, enabling SCIM for automated provisioning of users and

groups.

• Implementation of Governance for clean-up of users/unused or stale content, identifying long running extracts, etc.

• Service improvements by automations like self-service code migration, user access provisioning, 24*7 service availability, etc.

• Handled Onprem (Windows) to VPCx (Linux) Migration of 250 servers by overcoming the challenges experienced, limitations in terms of NAS storage,

fonts unavailability due to different landscape, etc.

• Leading a cross-functional team of 15 members in multiple locations dedicated to data management, BI administration, and improved employee retention by providing good learning opportunities.

• Mentored college graduates and implemented efficient training and cross skill strategies for smooth transition and upskilling of technologies.

• Built and operationalized Business Analytics platform and solution architected cross-platform authentication, integrating disparate data sources to generate daily data reports for 100000 server users

• Automation of Tableau Server Installation & upgrade process for around 250 servers (15 Platforms) that saved manual effort by 50% enabling huge cost savings

• Implementation of Best Practices regarding report development and data model preparation and following Hybrid approach of Live and Extract

connections.

• Implementation of a write-back solution in Tableau dashboards, enabling end users to enter comments and perform Live analysis.

• Work closely with business analysts, data engineers, and other stakeholders to gather requirements and translate them into Tableau solutions.

• Analyze large sets of data to identify trends, patterns, and insights that can be used to drive business decisions.

• Architected a self-service BI platform for ad-hoc analytics, empowering business users with advanced reporting capabilities.

• Develop data integration strategies and models for combining data from different sources into a unified structure.

• Experience in Design, Installation, Configuration, Maintenance, Migrations,

• Upgrades of Tableau, Spotfire, PowerBI, etc. along with set up of tools like CMT, RMT, LBLM, Logshark, TabPy & R

• Avoided hardware upgrade by means of workload management script that effectively distribute Tableau Services based on the load and during the

window of the day.

• 25% reduction in day-to-day activities by automation of Platform health checks, design of daily backup generation and archival policies(S3), Auto generation of change and Incidents, etc.

• Handling Compliance and annual Audits and develop recommendations to improve business processes, controls, efficiencies, and effectiveness to

ensure adherence to all internal operation and evaluate all procedures to maintain accuracy with all internal standards

• Handling of PII data, GXP and SOX Compliance platforms by ensuring

needed regulations are met

• Development of Rest API scripts to meet out of the box functionalities for

controlled Governance

Sr. Software Engineer

J&J
08.2016 - 07.2019
  • Design of solution to achieve Tableau Salesforce seamless integration which provided flexibility for business to access Tableau reports via salesforce app earlier with Sparkler and now with Tableau Lightening Web Component.
  • Troubleshooting and solving Performance Issues dealt on both onprem servers, Cloud setup and across different landscape.
  • Led a team of 10 members and trained for operationalization of daily and weekly activities along with handling upgrades
  • Migration of Analytics platform from On-Prem to AWS while enabling access to external users and facilitating Doctors, Medical squad access patient Reports on daily basis
  • Developed complex calculations, including LOD expressions and table calculations, to provide deeper insights and more granular analysis.
  • Implemented security measures such as row-level security, user filters, and governance policies to protect sensitive data and ensure compliance.
  • Work with stakeholders to define key performance indicators (KPIs) and create visualizations that highlight these metrics.
  • Setup of Data Driven Alerts or similar mechanism that would provide quick and efficient analysis of the KPIs.
  • Optimize Tableau dashboards and queries for performance to handle large datasets efficiently.
  • Experiment with new Tableau functionalities and recommend improvements to enhance data storytelling capabilities.
  • Develop logical and physical data models that represent data structures for databases, data warehouses, and other storage systems.
  • Integrate Tableau with various data sources such as SQL databases, Excel, Teradata, cloud services, TabPy/R, etc.

Software Engineer

J&J
08.2014 - 07.2016
  • Architected self-service BI platform to enable ad-hoc analytics and enhance reporting capabilities.
  • Migrated Tableau from Windows to Linux, realizing significant cost reductions.
  • Configured SSL/SAML, multiple IDPs, F5 Load Balancer, Tabmon, Tabjolt, Logshark, and Replayer for thorough load testing.
  • Automated server health checks and data extract refreshes, minimizing manual tasks and downtime.

Technical Associate

GTL
07.2011 - 08.2014
  • Managed SAP BW loads and developed BPC reports utilizing EVDRE Builder.
  • Provided support for SAP BW, BPC, and Tableau systems to ensure optimal performance.
  • Assisted global SAP BPC customers with planning processes and financial consolidations.
  • Created and maintained Tableau dashboards to improve data visualization and insights.

Education

BTech - Computer Science

JNTU
Hyderabad, India
04-2011

Skills

  • Python and SQL
  • Business intelligence tools
  • Data visualization and reporting (Tableau, PowerBI, Tibco Spotfire)
  • Cloud services (AWS)
  • SAP BPC expertise
  • API integration
  • Agile project management (Jira, Kanban)
  • Performance optimization strategies
  • Team leadership and collaboration
  • User access management
  • Data governance principles
  • Problem solving techniques

Certification

  • Tibco Certified Associate, 12/31/22
  • Tableau Desktop Specialist, 12/31/20
  • AWS Certified Cloud Practitioner, 12/31/19
  • Tableau Server Qualified Associate, 12/31/13

Projects

DIA (Data Integration & Analytics) - J&J, The project deals with Continuous Integration, Logistics, Dashboard development, Report Migration, Platform build, etc. This is an enterprise program which helps J&J to track the activities, perform analytics and manage the users globally between different BI platforms. Connect - Unilever, The project deals with Supply Chain Management, Channel Reporting, Customer Development, Marketing, etc. This is an enterprise program that gives Unilever the ability to Gain insight into Consumers and facilitate strategic decisions by streaming real-time information. AGS Support - Goldstone Technologies Ltd., The project deals with Business Planning and Consolidation support, report creation, writing scripts and support for SAP/Tableau Customers across globe. In addition, it involved pre-sales, sales, Development, and support of Licenses.

Personal Information

Title: Sr. BI Engineer/TeamLead

Timeline

Sr. BI Engineer

J&J
08.2019 - Current

Sr. Software Engineer

J&J
08.2016 - 07.2019

Software Engineer

J&J
08.2014 - 07.2016

Technical Associate

GTL
07.2011 - 08.2014

BTech - Computer Science

JNTU