Tableau Developer, BI analyst, BI Engineer
Resume:
Jyoti Sankar Sahu
**********@*****.*** Senior BI Analyst
+1-602-***-**** IGT Technologies Inc.
PROFESSIONAL SUMMARY
• Passionate about data analytics, problem solving, designing visualizations for business and always interested in learning new tools and technologies.
• Possesses good knowledge of Data Warehousing Business Intelligence Technologies
• Around 10 yrs. of experience in Analysis, Development, Production support and Enhancement of DWBI based projects.
• Developed Tableau dashboards with quick/context/global filters, parameters, LOD Functions and calculated fields that allowed to track and improve customer units KPI.
• Created Automated Schedule delivery of Tableau dashboard using tab command.
• Created monitoring dashboard and alert notification for Tableau workbook/extract failure for production support.
• Implemented dynamic row level security in Tableau dashboards.
• Implemented incremental tableau data extract refresh to improve the performance.
• Expertise on Microsoft SQL Server Reporting Services (SSRS), SQL server Analysis Services (SSIS).
• Automated uploading of user prepared excel data to Snowflake database using Python.
• Expertise on Business Objects XI R2/R3/BI 4.x, Infoburst as part of Reporting.
• Strong understanding of Data Warehouse concepts, OLAP, Star and Snow Flake Schemas, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Can work independently or as part of a team efficiently.
• Good communication skills and exude confidence in solving issues arising in the work environment.
• Interaction with Clients, handling their queries and understanding Business Requirements.
• Active participant in the organizational activities like conducting Knowledge sharing sessions and training.
• Have worked on Agile, Scrum and Managed Service Model providing end to end solution
(requirement gathering through deployment and post production support) to the Business without slipping on SLA timelines.
• Have been involved in BI 4.0 Migration process and worked on converting the Universes and Reports.
• Worked on complex reports with Multiple Data providers, Drill Through, Drill Down functionality along with a combination of Graphs and Cross Tabs
• Created BI Dashboards featuring multiple KPIs and bringing summarized information across multiple systems under the same hood enabling decision making for the top-tier management.
• Have worked on BI Administration, like adding/deleting users, assigning/revoking access rights at folder/user level and server management using CMC .
• Have extensively worked on Rationalization of the existing universes, reports as part of continuous improvement plan.
• Configuration management using BI Version Management, Infosol and Version Manager
• Proficient in SQL and worked on various Databases such as Teradata, Oracle 10g/11g, IBM DB2, MS SQL Server 2008 and Amazon Redshift.
• Excellent exposure to Informatica ETL tool. I can work on mapping and setting up the workflow ETL process.
• Have worked on scheduling reports, dashboards using BI scheduler, Infoburst and SQLRD.
• Have Worked on Data Warehouse Application Development and maintain Data Models in the Enterprise Data Warehouse using Informatica, Matillion tool and Python programming.
Project Details .
IGT Technologies Inc. 01-June-2016 - Present
Client: HAGroup/Princess Cruises, Valencia, CA
Tools: Business Objects XI 4.0 SP5, SSRS, Tableau, Amazon Redshift, SSIS, SSRS and Power BI, Matillion, Python, JIRA, Oracle 12g, Snowflake, SQL Server and SQLRD, Amazon AWS Cloud, JIRA Role: Senior Data Warehouse & Business Intelligence Analyst Client Overview : Princess Cruises is one of the best-known names in cruising, Princess Cruises first set sail in 1965 with a single ship cruising to Mexico. Today, the line has grown to become the third largest cruise line in the world, renowned for innovative ships. This Project is to create the reports/dashboards to provide the more insights about the business to marketing teams, sales team, onboard and Directors and Executives of various departments of the company. This project is executed in scrum model.
Under Business Intelligence and Reporting team below are the significant projects handled. Significant Projects Handled:
Project 1: Onboard Revenue data build, Dashboarding and Reporting Tools: Business Objects XI 4.0 SP5, SSRS, Tableau, Snowflake, SSIS, SSRS, POWER BI, Matillion, Python, Amazon AWS Cloud and JIRA
Responsibilities:
• Analyzes and defines business area and department specific objectives, strategies and processes; recommends system changes or enhancements and/or development opportunities.
• Develops functional specifications and test plans, coordinates testing, meetings, status updates, and presentations.
• Involved in assessments of data layer design for new projects, relational & dimensional data modeling, logical data modeling, data flow mapping and data modeling tools.
• Administers business requirements for various systems within the new build environment.
• Helps manage testing protocols and quality assurance for new builds through all phases of the delivery (staging, UAT, delivery), liaising closely with various IT and business teams.
• Applies information technology development methodology to identify business processes, system solutions and modifications.
• Compile and analyze relevant onboard revenue data (Bar, Spa, Dinning, Photo, Art, Retail and Shore excursion) to produce accurate and timely reports on a weekly/monthly/quarterly/ annual basis with minimal oversight using Tableau, Snowflake and Matillion tools.
• Translate enterprise or business requirements into long-term information/data architecture solutions including conceptual, logical and physical models.
• Formulates and communicates process and procedure changes.
• Ensure supervision and monitoring of all onboard revenue reports and dashboard activity.
• Helps identify areas of program risks and helps develop mitigation plans.
• Work within the Enterprise Data Warehouse Application Development team, developing and maintaining Data Models in the Enterprise Data Warehouse using Informatica, Matillion tools and Python programming.
• Work with team members, BI developers and the Business to further enhance data models and Architecture to support Business Intelligence and corporate reporting needs.
• Develop and maintain audit and validation processes to detect data integrity problems and work with developers internally and externally to solve data integrity issues.
• Participate in the agile process and meet goals as accepted.
• Participate in ETL Applications Tools/Servers system and data migration. Project 2: Asia Profit and loss Data Integration, Ingestion and Reporting Tools: SSRS, Tableau, Snowflake, SSIS, SSRS, Matillion and Power BI Responsibilities:
• Integrated month-end close and related month, quarter and annual corporate and management data in a single place for easy reporting.
• Managed account reconciliation process to ensure accuracy, efficiency and completeness of data.
• Coordinated with business to fulfill country regulatory requirements as needed.
• Provides financial data to assist operations groups in managing their business activities.
• Build reports for operations, financial planning, and executive management teams.
• Assists operating departments with financial understanding and analysis as opportunities arise.
• Identified and facilitates potential process improvements for data ingestion and transformation.
• Coordinates across groups to build dashboard and report when multiple parties are impacted.
• Lead regularly scheduled meetings to direct team in meeting individual, department and company goals.
• Supported the development of the long-term strategic and yearly operating plans and quarterly forecasts.
• Prepared, reviewed and justified the allocation percentages between multiples brands as well as shared service allocations between all brands.
• Helped business to accurately use reporting and analytical tools from information systems to assist finance and Operating departments in analysis of data and decision making.
• Worked with other finance departments to ensure accounting, planning and forecasting data are properly provided to the data warehouse systems.
• Works with operators to assure reporting meets analytical needs.
• Prepared, analyzed, and audits calculations and processes. Project 3: Nextgen Data build. Dashboarding and Reporting Tools: Business Objects XI 4.0 SP5, SSRS, Tableau, Snowflake, SSIS, SSRS and POWER BI Responsibilities:
• Interacted with the Business to understand Requirements and Driving the Project till completion to ensure On Time Delivery.
• Analyze and document business requirements to provide business intelligence solutions
• Design and build dashboard for business users.
• Developed Universes/Reports of all complexities & Scheduling Reports using Infoburst.
• Create Dashboards in Tableau to present the data to the sales/marketing team for analysis purpose.
• Automate manual intervene processes using SQL Server Integration Services (SSIS)
• Create reports using Tableau, Business Objects (BO), SQL Server Reporting Services (SSRS) tools.
• Was involved in Performance Tuning/Testing/Validating and Rationalization of the existing universes, reports as part of continuous improvement plan
• Have used aggregate aware, Index aware, Pre-defined filter Conditions and hierarchies, row level/object level & table Level Security.
• Helping the client in setting up the development environment and setting up the standards and process to do code promotion.
• Worked on Setting up the BO development environment for the development use.
• Worked on setting up the Version Management/promotion management for promoting the code.
• Worked on removing the -Dev, -QA universe from production environment and made the environment production environment clean and in sync with Development environment.
• Enabled the audit to track the usage of BO application and created audit reports.
• Introduced and set up Infoburst to meet complex scheduling requirements for BO reports in Princess.
• Worked with Team on upgrading the BO Platform.
• Worked on redesigned some of the most complex reports like Daily Net Revenue and Dashboard Inventory and PSA reports.
• Created lot of complex reports for Market Planning team and Yield, Air departments.
• Performed POC on Amazon Redshift.
Mindtree Private Limited 26-July-2010 - 01-June-2016 Client: American Red Cross
Tools: Teradata v14, Informatica 9.6.1
Role: Module Lead
American Nation Red Cross a humanitarian organization that provides emergency assistance, disaster relief and education inside the United States. It is the designated US affiliate of the International Federation of Red Cross and Red Crescent Societies. This Project was to migrate data and implement data warehouse on HR and Learning Management system using Informatica. Responsibilities:-
• Discuss with client and gather requirements.
• Design and develop the provided requirements with quality
• Unit testing the piece of code developed and maintain the same, effectively track and communicate work status and progress to appropriate audience.
• Understand the current ETL flow and integrate with the source system.
• Integrate the source system to data warehouse for seamless BI reporting
• Design and gather requirements for the downstream system to integrate the HR data to their systems
• Actively worked on Data Modelling for generating and data flow in various dimension and fact tables.
• Worked with BI team to build the reports and migrate the existing reports on top of DW Client: Silicon Valley Bank
Tools: Business Objects XI 4.0 SP5, BOXI R3, SQL Server, Oracle 11G, Infoburst, HPQC, Tableau, Xcelsius
Role: Module Lead
Client Overview: Silicon Valley Bank is a U.S.-based high-tech commercial bank with offices in a number of other countries. The bank has helped fund more than 30,000 start-ups. SVB Financial is the holding company for the bank. This Project was built around Managed Services Model. The team catered to all kinds of request coming in directly or indirectly from the business. The nature of the work included Development, Enhancement and Production Support. The Reports developed were scheduled using Infoburst. There was also a platform migration from BOXI 3.x to BI 4.0. Tools: Business Objects XI R3.1 SP5/BI4.0, Oracle 11G, Infoburst and HPQC Responsibilities:
• Leading/Mentoring the Reporting Team
• Interacting with the Business to understand Requirements and Driving the Project till completion to ensure On Time Delivery
• Developing Universes/Reports of all complexities
• Scheduling Reports using Infoburst tool
• Performance Tuning/Testing/Validating the reports
• Engaged in continuous R&D and implementing ideas for process improvement ensuring Value Adds
• Data Validation and Quality Assurance
• Was involved in Performance Tuning/Testing/Validating and Rationalization of the existing universes, reports as part of continuous improvement plan
• Provided Techno-Functional support to users and conducted BI Training sessions for the Business Users enabling Self Service BI
• Have used aggregate aware, Index aware, Pre-defined filter Conditions and hierarchies, row level/ object level & table Level Security
• Creating new Dashboards in Tableau and migrating the existing dashboards from Xcelsius to Tableau.
Significant Projects Handled:
• Private Banking Integration:
a. Report modification for inclusion of Private banking clients and products into existing reports containing commercial banking data
b. Universe modification through contexts and joins to align private banking individual client level data with commercial banking entity level data, for seamless integration of specific private banking loans and deposits data into existing reports c. Understanding of underlying data model wherein individual level data is aligned with aggregated entities (at commercial clients level)
• Rollout of UK Banking Operations:
a. New reports to cater to UK operations rollout and service offerings’ operational reporting. b. Existing reports modification for inclusion of new geographical data (e.g. - clients, products, organization structure, GL, etc.)
c. Existing report enhancement and validation to support rollout of UK term deposit products
• Certification of GL accounts:
a. To enable CAT users to identify the source system for the sub-ledger balance. In case there is any variance, knowing the source of the feed, will allow users to reach out to the responsible team for more details. For accounts that are certified at the BU- GL Account level, the report must get all departments & products within the BU & GL combination. b. Validation of existing reports for account balances in GL and EDW for accounts undergoing daily and monthly certification process
c. Regression testing of existing reports for certified account balances through flag level indicator
• Credit Admin Report Automation:
a. Discuss with client and gather requirements.
b. Design and develop the provided requirements with quality c. Unit testing the piece of code developed and maintain the same, effectively track and communicate work status and progress to appropriate audience. d. Data analysis and Automation of manually prepared SEC (Security exchange control) excel reports by using various technologies.
e. Scheduling of reports to deliver to intended users in time. f. Prepare reports that include the degree of risk involved in extending credit or lending money. g. Generate financial ratios, using technologies, to evaluate customers' financial status Client: PepsiCo
Tools: Business Objects XI R3 SP5, Oracle 11G
Client Overview: This Project was a Proof of Concept for PepsiCo. The Client had never implemented BI into their business before. The purpose of the project was to develop prototype reports on Web-I along with Universe Development in order to showcase their vital KPI’s. So that they can forecast and plan activities in order to meet their targets.
Tools: Business Objects XI R3.1 SP3, Oracle 11g
Responsibilities:
• Understanding the client requirements
• Analysis of Data Model, Prototype architecture
• Creation of Universe for each KPI
• Creation of Web-I Reports
• Data Validation and Demonstration to Clients
PERSONAL
• Contributed towards the Global BI Community
• Received high Performer award in Interglobe technologies in 2018.
• Received Star Performer award in Interglobe technologies in 2013, 2014 and 2015.
Contact this candidate