Tibco Administrator

Prasant Sadangi

BI Administrator BI Platform Architect Project Manager

SAP BO Tableau TIBCO JasperSoft DOMO AWS

Ph : +1-412-***-**** **************@*****.*** LinkedIn

Professional Summary

** ***** of well-rounded IT experience, with proficiency in BI technologies - SAP Business Objects, Tableau, TIBCO JasperSoft, DOMO with strong understanding & implementation, management of BI Platforms & Architecture.

AWS Certified Solutions Architect Associate (SAA-C02)

Business Objects Certified Professional - Business Objects Enterprise

Tableau Certified Professional - Tableau Certified Server Architect and Tableau Certified Server Admin

DOMO Certified BI Professional - Completed DOMO platform accreditation, a new age Cloud BI platform which provides end to end Business Intelligence capabilities.

Proficient in analyzing and translating business requirements to technical requirements, designing architectures and platforms from scratch to a very highly scalable infrastructure.

Diverse experience in BI Platform Administration - building distributed/clustered deployment, sizing, upgrades, migrations, development, developing fully automated deployments using DevOps technologies, implementation & support of multiple BI Tools/Applications.

Hands on experience on wide range of BI Products & versions SAP BOXIR2 / BOXI31 /BI41/BI42, Tableau 8/9/10/2020, TIBCO 6.1/6.3/7.5, DOMO.

Worked in Virtual Private Cloud Environments by applying DevOps skills with hands on experience in automating the BI Server deployments using Eclipse, Python, SVN/GIT, Jenkins, Nexus Repository

Worked with variety of other technologies/applications, Databases, Application servers, Auth providers etc. & their integration with the BI Platforms. Tableau Dashboard developments for MIS reporting.

Excellent communication skills, leadership qualities, systematic approach, and ability to work effectively in fast-paced environments.

Played various roles BI Platform Server Architect, Subject Matter Expert, Technical Lead, Application Manager/Architect, Onsite coordinator, Developer etc.

End-to-end technology/project management, requirement gathering, Sizing/Estimations, business development, Resource management.

Certifications

AWS Certified Solutions Architect – Associate

Tableau Certified Server Admin

Tableau Certified Server Architect

Business Objects Certified Professional BOE Level 1 (SA210)

Business Objects Certified Professional BOE Level 2 (SA310)

DOMO Certified Professional

SAP Analytics Cloud through openSAP

Skills

· BI Skills: SAP BO, Tableau, TIBCO JasperSoft, DOMO, SAP Analytics Cloud

· BI Versions: BOXI R1/R2, BO 3.X, SAP BI 4.X, Tableau 2020.x/10.x/9.x/8.x/, TIBCO JasperSoft Enterprise 6.1.1/6.3.2, DOMO BI, Crystal Enterprise 10,

· Cloud: AWS, SAP Analytics Cloud, DOMO Cloud BI

· DevOps: Jenkins, Eclipse, Nexus Repository, Python

· Auth Providers: LDAP, AD, OIDC, Kerberos, Vintela, SiteMinder

·Web/Application Servers: IIS, Apache Tomcat, Oracle WebLogic, WebSphere

· O/S: Windows, Red Hat Linux

· RDBMS: Oracle, MySQL, SQL Server, DB2,

Sybase

· Other Tools: VMware 5.5 & 6.5, Remedy, JIRA, Putty, WinSCP, SVN, Visio, Service Now, App Dynamics, Moog Soft, HPOV, Dynatrace, Cloud Prober

· Tools & Languages: WRC, Tableau Desktop, JasperSoft Studio, Import wizard, LCM, CMC, BILaunchpad, SAP Lumira

Education

Master of Computer Applications: 2005

Pune University - Pune, India

BSC Computers: 2002

Andhra University - Visakhapatnam, India

Work History

Cloud BI Solutions Architect – AWS/Tableau Cognizant

Migrating On-Premises Tableau Platform to AWS Cloud. As part of the cloud adaption strategy – shifting a portion of Tableau On Premise Platform to AWS Cloud. Standing up the Tableau Server 2020.2.4 in AWS cloud and migrating the contents to AWS Cloud.

Roles & Responsibilities

Performed all the tasks from scratch like server provisioning, working with VPC, route 53, firewall etc..

End to end ownership & technically responsible for the Pilot AWS Cloud migration project.

Created Security Group - Assign Inbound and Outbound Rules. Allow https/https/rdp

Launched a windows Instance in the VPC using the security group.

Provisioning EC2 instances and assigning to right security group and NACLs.

Working with Cloud Team for firewall port openings.

Installing Tableau Server in AWS EC2 instances.

Performing distributed installation with additional nodes through boot strap.

Worked with WSAS team for adding ALB to the EC2 Servers.

Enabled Monitoring using Cloud Watch for the EC2 Instances

DOMO Cloud BI Solutions Architect / Product Owner - Cognizant

Anchoring the Cognizant - DOMO Partner alliance. Handling end to end DOMO show in Cognizant.

Roles & Responsibilities

Point of contact / managing the DOMO COE & worked as the Product Manager for DOMO Cloud platform.

Administering the DOMO instance – onboarding users, enabling them on the Cloud BI platform. Collaborating with Practices, Service Line Leaders & competencies to anchor DOMO related proposals. Prepared Industry specific cards for verticals.

Designed & developed the DEMO content for Pre-sales activities which includes pages, Cards, Publications, Magic ETL Flows etc..

Identifying use cases and build the solutions in DOMO and presenting it to clients.

Providing Product DEMOs to Customers, BU Heads, Service Line Leaders and highlighting the DOMO capabilities. Performing Proof of concepts and presenting it to clients

Imparting DOMO training to associates on the ground.

Driving the partner certification drive for DOMO, successfully had 400+ Associates certified in DOMO.

Established the AU/EU Zone DOMO partnership, establishing & signing the partner agreement with DOMO.

BI Platform Sr.Architect / Administrator Cognizant – Jersey City, NJ Client: BNYMellon

Sr.BI Platform Architect for the Business Intelligence COE in BNYMellon which consists of different reporting platforms SAP Business Objects, Tableau & TIBCO Jasperserver.

These platforms are huge, shared services platforms in the bank with 250k+ users dependent on it for Reporting/BI, Visualization/Dashboard needs in the bank.

Environment Tableau, SAP BI4.2, Jasper 7.5

BI Platform Administration Project.

Roles & Responsibilities

Working as a Sr.BI Platform Architect / Administrator for SAP Business Objects, Tableau & Jasper shared Service platforms.

Handling day to day operations of the platforms, end to end to BI Administration Activities, new developments of the platforms.

Defining roadmaps of the BI Platforms, strategies, planning

Being part of the reporting COE group interacts with clients and LOB partners for their reporting/visulization needs.

Interacting with Business Users/ LOBs for understanding their reporting requirements and suggesting the right tool to go ahead through a formal onboarding process.

Developing Tableau dashboards for CIO Reporting.

Working on JIRAs, managing change requests / Incidents, handling priority issues.

Upgrading the BI Platforms, Content promotions

Playing multiple roles & technologies in the project & managing it successfully.

SAP BO Architect / Administrator Cognizant – Jersey City, NJ Client: BNYMellon

Building BI4.2 SP7 Platform in the new BNYMellon Green Field Infrastructure as part of the Greenfield initiative & continuous effort to leverage latest functionalities of SAP BO for the BO Stakeholders. Done in two phases Infrastructure build & LOB Content Migration / Decommission of existing env.

Environment: SAP BI4.1, SAP BI 4.2 SP7, Windows, Red hat Linux, Private Cloud, DMZaas

Roles & Responsibilities

Designing the Architecture, preparing the Arch Diagram using Visio

Forecasting the volume, sizing the platform, and preparing Build Sheet as per the new capacity requirement

Presenting Design to the Architecture review board, work on findings and acquiring permit to build

Installation & configuration of Clustered SAP BI4.2 SP7 environment across 50+ Nodes

Installation & configuration of Lumira Server

Configuring the environments with SSL, SSO for both internal & external customers using Kerberos, Vintela, Active Directory, LDAP SiteMinder, Trusted Authentication

Worked on for building the SiteMinder Policy

Settings up the security, configuring Version Management, Monitoring Probes etc.

Setting up BI on BI using the new CMS Universe

Working with SAP on License conversion from Core based to Concurrent user-based model

Working in the cloud environment for setting up DMZaas for the externally accessible URLs

Doing reverse proxy settings in the Webserver

Migrating users, groups, reports, universes, publications from BI4.1 to BI4.2 Environment

Defining the LOB content Testing/Signoff & Performance testing strategy

Completing the production readiness for the platforms

Preparing the Playbook for go-live, reviews with team and various stakeholders

TIBCO Jaspersoft Administrator / Project Lead Cognizant – Jersey City, NJ Client: BNYMellon

Building TIBCO JasperSoft Server version 7.5 Platform in the newly built BNYMellon Green Field Infrastructure. Migrating LOBs contents from existing TIBCO 6.3.2 to the new TIBCO 7.5 environment

Environment: TIBCO 6.3.2, TIBCO 7.5, Red hat Linux, Private Cloud

Roles & Responsibilities

Designing the Architecture, Presenting Design to the Architecture review board, work on findings and acquiring permit to build

Forecasting the volume, sizing the platform, and preparing Build Sheet as per the new capacity requirement

Installing TIBCO Jasper Server 7.5 on Redhat Linux machines

Preparing the Database for Jasper Repository & creating the Tables

Configuring the jasperserver-pro and preparing the war file deployment for all servers

Creating the top-level organization and defining the security model to overcome previous version issues w.r.t SSO

Creating a Staging Environment before migrating and merging the content into the New Env

Migrating contents LOB wise incrementally from Jasper 6.3.2 to 7.5 env

Setting up security for each LOB level

Developed a script to pull users from Entitlement database and assign it into jasper

Configuring SSL for the Application Servers, defining the routing policy via forward/reverse proxy

Setting up Open ID connect authentication end to end

Troubleshooting/fixing issues w.r.t to migration for LOB Portal Integration with the new platform

Configuring APP Dynamics on the Jasper Servers, integrating it with Splunk for log readings

Pushing the code base to from SVN to GIT

Working closely with LOB POCs for signoff for each environment and coordinating the effort

Providing Performance testing strategy and details to Testing Team

Preparing Production Playbook for go live with platform stakeholders

Tableau Architect Cognizant – Pittsburgh, PA Client: BNYMellon

The project was to design a robust Tableau architecture for making it a shared service platform which enables to use Tableau at reduced cost, providing self-service BI platform to end users & improved infrastructure utilization.

Environment: Tableau Server, Apache, Windows Server 2008, IIS

Roles & Responsibilities

Designing the tableau architecture with gateway & multiple worker nodes in a cluster environment.

Working with Business Solutions for procuring the hardware & standing up the infrastructure.

Installing tableau primary & worker nodes.

Configuring & Sizing the environment by forecasting the future load.

Integrating with SiteMinder using trusted authentication for easy integration with LOB Portals.

Writing a custom piece to accommodate trusted authentication for SSO.

Integrating with the bank's native user provisioning system using tableau SDK & tabcmd and syncing the users to tableau with two different process - an incremental sync using MQ and a full sync for the weekend.

Defining & documenting governance & onboarding process.

Working with Tableau Vendor for setting up the environment as per the best practices.

Coordinating LOB trainings with Tableau.

Integrating the dashboards into a centralized Portal for seamless access through SSO.

Onsite-offshore coordination with JIRA based issue tracking Accomplishments.

TIBCO Jasper Lead - VMware Cloud Cognizant – Pittsburgh, PA Client: BNYMellon

Upgrading & Migrating the Jasper 6.1.1 environment to 6.3.2 environment & integration with Enterprise Reporting System.

Environment: TIBCO JasperSoft 6.1.1 & 6.3.2, Apache Tomcat, Jenkins, Maven

Roles & Responsibilities

Setting up a parallel infrastructure for TIBCO JasperSoft 6.3.2 using BNYM's virtual cloud environment.

Introducing new assembly slots in the VMWARE Cloud Infrastrcuture for a custom component called micro service, which will interact with the Jasper Server for managed report scheduling.

Exporting the content from Jasper 6.1.1 environment using command line.

Importing the content to Jasper 6.3.2 environment.

Coordinating with LOBs for validations & signoff.

Reviewing daily tickets assigned to the Jasper Queue and assigning them to team members for closure.

Resolving issues raised by LOBs due to the migration, coordinating with vendor for product bugs and regressions because of the migration.

Deploying the micro service components to the Jasper Server by isolating it through a different tomcat so it doesn't impact the Jasper deployment in any way.

Reviewing daily tickets assigned to the Jasper Queue and assigning them to team members for closure.

Tableau Developer Cognizant – Pittsburgh, PA Client: BNYMellon

Designed Dashboards for CIO & Sr. management. Usage for incident reporting, platform usage & metrics.

Environment: Tableau Desktop 9.3, Tableau Server 9.3, IIS, Apache, Windows Server 2008

Roles & Responsibilities

Designed & Developed various tableau dashboards by connecting to remedy & other databases.

Developed dashboard using Tableau Desktop, allowing executive management to view platform usage & metrics, charge backs etc.

Created Dashboards and Stories by using Table calculations.

Worked on Tableau Dashboards in Tableau desktop.

Demonstrated knowledge in dealing with various functionalities like context filters, global filters, conditional formatting of reports to satisfy the end users.

Conducted training sessions for Tableau Users to use it as a self-service BI tool.

Responsible for Deploying and Maintenance of Tableau Dashboards on Server.

Responsible for supporting & managing the Tableau Shared Service Infrastructure.

SAP BO Lead Cognizant – Pittsburgh, PA Client: BNYMellon

With BNY & Mellon merger, there were different BO shared infrastructures with Heritage Mellon and Bank of New York. This BI4.1 standup Project is for consolidating two major Shared Infrastructures in the bank to one Shared Service Platform

Environment: Business Objects XI3.1, SAP BI 4.1, Oracle 11, Apache Tomcat, LDAP, Active Directory, SiteMinder, RedHat Linux

Roles & Responsibilities

Heritage Mellon shared infrastructure was serving internal clients, whereas BNY Shared infrastructure was serving the external clients.

It was a huge task for combining both the flavors.

Setting up Flexible security model for easy & fast onboarding process.

Setting up both Active directory and LDAP authentication, AD - for internal Users & LDAP - for External customers into the same platform.

Setup & mapping two different URLs one .NET & .COM for suiting both needs.

SSO Solutions: Internal using Vintela & External using SiteMinder.

Integration with existing Enterprise Reporting Service & other LOB Portals by designing a gateway which serves as a common framework.

Developed a facade REST service on BXP to integrate with BO SDK and BO web services.

Designed & implemented a cloud based BXP layer Web tier.

Setting up an active-active deployment architecture across Processing & web tiers with two different data centers for easy failover & fault tolerance.

Onboarding more than 30 applications/LOBs into this shared service.

Performed Sizing exercise for this huge infrastructure setup with more than 90000 users.

Managing offshore & onsite teams, interacting with the client & various stake holders for requirement, onboarding & solution implementation.

Jasper Server Architect - VMware Cloud Cognizant – Pittsburgh, PA Client: BNYMellon

Designing a clustered / distributed, easily scalable, robust TIBCO JasperSoft Enterprise Server platform & implementing the solution in BNYMellon virtual cloud platform.

Environment: TIBCO JasperSoft Enterprise 6.1.1, Oracle 11, Apache Tomcat, Jenkins, Eclipse, Python, BXP, RedHat Linux

Roles & Responsibilities

Doing proof of concept for multi tenancy & other factors.

Designing the Jasper Server architecture with multiple Web & App servers.

Integrating with organization SiteMinder for SSO for external customers.

Integrating with OIDC (OpenID) authentication Provider for internal users.

Working with business solutions team to have the architecture approved & provisioning the servers.

Creating assemblies & slots in the VMware Cloud environments for each server type.

Defining the Assembly.XML file with High availability and fault tolerance configurations

Creating partition projects in eclipse & building the deployment package, deploying to NEXUS repository.

Used Python for developing & automating the deployment process.

With fully automated the deployment process from NEXUS, same package can be deployed to multiple servers in one go, reducing timelines for installations.

Working with ethical hack team to find out vulnerabilities & working with the vendor to fix it.

Working with LOBs for onboarding by a formal onboarding process.

Managing offshore team & guiding them for tasks.

SAP BO Lead Offshore/ BO Administrator Cognizant – Pune, India Client: BNYMellon

BNYMellon had multiple Business Objects Environments which were operating independently. Everything was decentralized costing very high maintenance. This project was to consolidate all silo BOXIR2 environments into one Shared Service Platform.

Environment: Business Objects XI R2, Oracle 9, WebLogic, LDAP

Roles & Responsibilities

Setting up the Business Objects XIR2 Environment.

Doing the top-level security setup along with LOB folder securities.

Setting up server groups for each Lines of business for isolating their contents so it doesn't affect other tenants in the platform.

Migrating contents from existing LOB environment to the Shared Service environment.

Working with SAP on the license consolidation & sizing/scaling the environment.

Configuring LDAP authentication.

Creating a business objects wrapper to seamlessly integrate with LOB portals.

Providing administration & support to multiple LOBs.

Coordinating with onsite & client for resource & work allocation.

Associate Subject Matter Expert KPIT Cummins GBS Ltd – Pune, India Client: SAP

SAP Business Objects has the biggest Technical Assurance Center for Americas in KPIT Cummins with around 200 resources working. Handled SAP fortune 500 clients and provide end to end consulting, support, Problem solving and suggesting different sizing guidelines related to Business Objects Architecture, Integrations, Security Implementations, and Migrations etc. Worked on the Architecture group which provides BI Administration support to SAP Customers.

Environment: Crystal Enterprise 10, Business Objects XI R2, Oracle 9, WebLogic, AD, WebSphere, LDAP, VMWare Workstation, VMWare Server

Roles & Responsibilities

As a Subject Matter Expert handled critical and production down / Severity 1/ escalated issues.

Handled Issues w.r.t Business Objects, installation, configuration, administration, server management, publication, authentication, web app configuration, auditing, migration, content management etc..

Worked as a technical lead for my team of 15 engineers.

Subject matter expert for the Architecture group & providing assistance to Engineers & Sr.Engineers

Handled the technical aspects of my team.

First point of contact for any technical queries and escalations for my team.

Review their incidents and provide technical guidelines and suggest next steps towards resolution.

Mentoring them, identifying the technical gaps & providing training/sessions

Develop, approve Knowledge base articles, and release them to the customer.

Worked with operations/management for desired targets & discussing the same with team & help/guide them for achieving the goal

SAP MAX Attention Assignments

Sr. Engineer Architecture KPIT Cummins GBS Ltd – Pune, India Client: Bank of Montreal

Bank of Montreal is one of the largest banks in Canada. They use Business Objects for their reporting needs. They were migrating from BOXIR2 to XI3.1. The Project was to deploy and configure business objects XI3.1 in VMware 6.5 environment and migrate the XIR2 Production Environment.

Environment: Business Objects XI R2, R3, Oracle 9, WebSphere, Active Directory, windows 2003.

Roles & Responsibilities

Designed and documented the multi-server architecture of Business Objects.

Designed multi server architecture for Business Objects XI R3 Enterprise for more than 1000 users.

The multi-server architecture consisted of BOXI3.1 on Two machines, WebSphere in another box.

Responsible for the creation and implementation of Business Objects Clustering, Load Balancing, Disaster Recovery.

Installed Business Objects and Deployed the Webapps of Business Objects to WebSphere.

Stress tested Business Objects enterprise servers to determine ideal configuration for best performance.

Performed Migration of content from the XIR2 system to XIR3 using the Import Wizard.

Implemented the Integration of AD for Authentication.

After the migration created the same identical Dev and Test Environments using manual Migration.

Trained developers on steps involved in migration of reports from Business Objects XIR2 and XIR3.

Managed Production, Test and Dev environments including installation of patches, security administration and access controls.

Engineer Architecture KPIT Cummins GBS Ltd – Pune, India Client: Florida Health

The Florida Department of Health is responsible for protecting the public health and safety of the residents and visitors of the state of Florida. This project involved setting up the BOXI Env for reporting needs.

Environment: Business Objects XI R2, SQL Server, Active Directory

Roles & Responsibilities

Proposed the solution to upgrade from Crystal Enterprise 10 to Business Objects XIR2.This included working closely with their Administrator and End Users.

Did manual migration from CE10 to BOXIR2.Involved in testing the migrated contents.

Implemented Kerberos Active directory authentication and worked on user mappings and securities.

Demonstrated different features available in XIR2 and different reporting features as per their need.

Presented the QAAWS tool reporting and developing Web services.

Using QAAWS tool and suggesting different ways of consuming the web services in Crystal Reports and Xcelsius Dashboards.

Managed group and user permissions for the reports on Enterprise.

Regularly monitored the server for any problems, configured different destinations for scheduling.

Developed a script for copying the user preferences and cascading it.

Engineer Architecture KPIT Cummins GBS Ltd – Pune, India Client: McKesson Corporation

McKesson Corporation is an OEM partner with SAP Business Objects. The project involved in setting up an SSL environment, Installing Business Objects XIR2 environment & implementing LDAP authentication. Designed the security model for McKesson Corporation.

Environment: Business Objects XI R2, SQL Server, LDAP, Tomcat, Windows 2003

Roles & Responsibilities

Installation of Business Objects XIR2 clustered in the Secured Application Server Environment.

Set up Tomcat SSL Environment.

Implemented LDAP Authentication with SSL.

Mapped more than 500 LDAP Users and designed a security model by applying inheritance from top to bottom.

Used predefined access levels and configured Authorizations for them with in CMC.

Configure Business Objects XIR2 to work in Firewalls, Enable the port(s) needed like 6400, 6401 etc.

Synchronized the QA, DEV environments with Production reports.

Responsible for interfacing with business users to gather reporting requirements.

Setting up Weekly calls with McKesson BO Administrator and monitoring the environment.

TRAININGS & SESSIONS

AWS Certified Solutions Architect - Associate by Udemy.

AWS Certified Cloud Practitioner by Udemy

Business Objects XI architecture and security rights from SAP Tech Ed.

Deploying BO in Distributed Architecture from SAP Tech Ed.

Imparted trainings in Cognizant Academy.

Imparted various trainings at KPIT Cummins.

Artificial Intelligence through Cognizant Academy.

Cloud Computing through Cognizant Academy.

Member of ASUG, SAP Business Objects Pittsburgh chapter & Tableau User Group.

Professional Accomplishments

Wow award for exceptional contribution at work resulting in benefit to the company and client.

You Dunnit award in KPIT Cummins for exceptional handling of escalations and contribution to customer satisfaction.

Tech-Wiz team award for skillfully managing simultaneous technical issues and contributing to consistent improvement in team performance.

Cognizant BFS Applause awards for continuous excellent delivery.

Cognizant Cheers Award for extraordinary client feedback & client focus

Contact this candidate