Warehouse Architect Data

SANTHOSH KUMAR

BI Analytics Manager – Tableau Architect / SME Mobile: +1-801-***-****

E-Mail: ************@*****.***

TECHNICAL SKILLS

Languages T-SQL/SQL, PL/SQL, VB.Net, HTML, Java Script, Python Data Visualization /

BI Applications

Tableau 2022 APR, v11/v10/v9/v8/v7, MS PowerBI, PowerApps,Cognos 8.4/8.3/8.2, SAP Business Objects Enterprise – Web Intelligence, BO Design Studio SAP Lumira, Crystal Enterprise, MS SSRS / SSAS, OBIEE, SpotFire, Qlik Enterprise Databases MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access, SAP Hana 1.x / 2.x, Snowflake, Snowflake, Postgres SQL

Data Modeling Tools Microsoft Visio, UML, Erwin, ER Studio, Apigee, API Development Resume

visualization in

Tableau

https://public.tableau.com/app/profile/santosh6277/viz/Santhoshresume/Santhoshkum arResume

EIM / ETL 2021.x / 2018.x, SAP EIM, Alteryx, Microsoft SSIS / DTS SUBMISSION DETAILS

Education Master of Science in Information Technology from NIT Warangal India in collaboration with CMU Pittsburgh in 2004

Work Authorization Green Card

Tableau Public

Profile

https://public.tableau.com/profile/santosh6277 newProfile=&activeTab=0 LinkedIn https://www.linkedin.com/in/santhosh-k-66940b22a/ Certifications PMP, Tableau, MS PowerBI, Qlikview, QlikSense, SAPDS / SAPBODS Certifications URL https://www.youracclaim.com/users/sanotsh-kumar-nirmala/badges PROFESSIONAL SUMMARY

Over 12+ years of Experience in Designing, Architecture, Administration, Analysis, Management in the Business Intelligence Platforms, Data Warehousing, Client Server Technologies, Web-based Applications and Databases and Experience in industries such as Retail, Financial, Accounting, Distribution, Logistics, Inventory, Manufacturing, Marketing, Services, Networking and Engineering.

Experienced in Data Warehouse Life Cycle: requirement analysis, understand trade-offs between different schema designs and their implementation, worked with DBA to implement data models in RDBMS and support enhancements.

2

Define / Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications.

Coordinates with project managers and participates in project planning

Worked in Designing Staging of ODS, ERP Applications' extract for Enterprise Data Warehouse

/ Data Mart / Data Lake (on Premise & Cloud) and assisted Data Warehouse Architect in Design/Dimensional Data Modeling of the Data Warehouse Data Storage Strategy / Technique and implementing the best practices for efficiency and optimization.

Worked / Assisted in planning, developing, implementing and managing data warehouse project deliverables, high level mapping for ETL specifications, working for alternatives and best practice approaches and mentoring / coaching to team members and client staff.

Over 9+ years of experience in Data Visualization Applications - Tableau Enterprise / MS PowerBI / Qlikview Enterprise ( Qlikview / QlikSense / N-Printing) in latest Design and Presentation.

Worked ln the development, analysis, modeling, design, and development of BI reports and dashboards reports for the Key Performance Indicators for the top management for analytics.

Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management, Maintenance, upgrade, Fix pack/Service pack installations, and Root cause analysis, Resolution Methods Time/ Cost/Budget Management.

Tableau Admin Responsibilities that include both Server and Site Administration. Handling minor and major upgrades in windows. Weekly meetings with TSM to ensure platform stability and escalation etc., Lots of Automation, Proactive Monitoring.

Worked in overseeing the overall infrastructure of Enterprise Information Management / Data Quality Management for Enterprise Solutions / Applications.

Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues/tickets. Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data. EXPERIENCE

JAN 2021 TO PRESENT

DATA SOLUTIONS ARCHITECT-TABLEAU / ALTERYX

HCL TECHNOLOGIES

BI / Data Solution Architect:

Worked in delivering Data and Analytics Solutions for clients like Franklin Templeton, Caterpillar.

Worked in delivery of end-to-end Data Solutions - Data Analytics, Business Intelligence, Data Cleansing, Data Processing, Master Data Governance / Management for large scale Data Conversions / Migration implementations and Data Mining 3

Worked in delivering end-to-end BI and Data Solutions can plug as needed and that can work full projects (from requirements gathering to back-end development through front end tableau development

Worked as Architect to Model and Implement the new Enterprise Data Warehouse, Entity Relationship Diagrams (ERD) using Data Modelling Applications like ER-Studio / Erwin.

Experience in Developing Performance Dashboards, Score-Cards, Metrics, What if analysis, Prompts, Drills, Search (using Add-ons), Reports / Dashboards for cross-functional areas including Supply Chain Management(SNC), Supplier Network Collaboration (SNC), Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory Warehouse Management, Supply Chain and Transportation, Sales/Marketing, Variable Objects with formulas.

Design and implement effective database solutions and models to store and retrieve data

Examine and identify database structural necessities by evaluating client operations, applications, and programming

Assess database implementation procedures to ensure they comply with internal and external regulations

Worked with Relational Databases such as ( Oracle, MS SQL Server, Teradata, Sybase ASE, DB2 UDB, etc., ), in-Memory Databases( SAP Hana), Cloud DB / DW ( Snowflake DW) & Columnar databases

Alteryx Responsibilities:

Design/Develop mappings/workflows, Data Analysis and reverse engineering of data model, Data preparation with SQL Scripting in Alteryx

Support the System Integration testing by fixing the bugs

Support the end-to-end integration testing by comparing the data in the reports with the source system to find out the mismatches; and find its root cause

Support the User Acceptance Testing by addressing any technical queries or fixing the bugs.

Co-ordinate with the source systems for any data mismatches

Development, Testing and Data Validation of in Alteryx/Incident/Change Request implementation in Production Environment

Tableau Responsibilities:

Experience in delivery of Complex dashboards using Tableau for the daily and weekly reports for Business and Operations teams.

Handled Tableau Server Administration, Role Assign and Interaction to user groups based on business requirements and manage schedules, Project/Site creation, Application / Dashboard Publishing in Tableau Server.

Worked in generating dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL server and Microsoft Analysis Services.

Coordinates with project managers and participates in project planning

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, SQL Server, NOSQL DB – MongoDB and HDFS.

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

4

Lead the Tableau migration project from On-Prem to Google Cloud Platform (GCP) and also upgrading Tableau to version 2021.3

Created executive dashboards that clearly tells the story of how the different divisions of BAO financial group is performing and to assist the executives to make appropriate business decisions.

Responsible for building Data Pipelines with JAVA and SQL that consume and transform the end customer’s data received in CSV format and feed it downstream into various data sources including Google Big Query.

Activated Tableau server management add-on in the production Tableau server and used tools like Tableau Resource monitoring tool to identify issues that cause slow load times, extract failures and other critical issues.

Used Tableau content migration tool to copy or migrate content between Tableau Server projects, sites and deployments.

Created Tableau extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insight into large data sets.

Defined the purpose and audience, rough sketch the plan, build and test interactive dashboards and applied visual best practices.

MS PowerBI Responsibilities:

Experienced in Publishing the Dashboards/Reports to Power BI Service.

Testing the developed Dashboards/Reports was as per the requirements.

Involved in Creating Workspaces in Power BI service.

Providing the Privileges on Dashboards/Reports to appropriate users.

Publishing Apps Power BI services and providing access to appropriate users.

Sharing the Dashboards/Reports among the members within the organization.

Experienced in Creating and Publishing the Models and Publishing those models into Power BI Service.

Environment:

Tableau Server 2020.x/v10/v9/9.2, MS PowerBI, Power Query, Alteryx, Cognos 8.4, SAP Hana 1.x,

/2.x MS SQL Server 2016 / 2012 / 2008 R2, Amazon Redshift, MongoDB, Kafka, Cloudera, Python, Hadoop (Cloudera), Hive, Impala, Angular JS, Java Script. JAN 2018 TO DEC 2020

TABLEAU ARCHITECT

ASTELLAS PHARMACEUTICALS, NORTHBROOK, IL

Responsibilities:

Experience in understanding project specifications, overseeing deliverable preparation and extensive client engagement

Worked in delivering end-to-end BI and Data Solutions can plug as needed and that can work full projects (from requirements gathering to back-end development through front end tableau development.

Worked in Delivery / Support scalable client engagement strategies that drive profitable growth, engagement and retention

5

Liaison to the rest of the organization, championing for self-service data analytics and maintaining relationships with power user

Worked with Cross-Functional teams - Sales, Marketing, Customer Support, Financial (Billing and Accounting), Supply Chain Management, Supplier Network Collaboration and PV, etc.,

Worked with Relational Databases such as ( Oracle, MS SQL Server, Teradata, Sybase ASE, DB2 UDB, etc., ), in-Memory Databases( SAP Hana), Cloud DB / DW ( Snowflake DW) & Columnar databases

Experience in delivery of Complex dashboards using Tableau for the daily and weekly reports for Business and Operations teams.

Handled Tableau Server Administration, Role Assign and Interaction to user groups based on business requirements and manage schedules, Project/Site creation, Application / Dashboard Publishing in Tableau Server.

Worked in generating dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL server and Microsoft Analysis Services.

Worked in a Fast-Paced Agile environment and were able to bring structure

Worked in interpret data from multiple sources, understand & propose data integration logic for Agile ROI, Marketing Mix etc.,

Coordinates with project managers and participates in project planning

Experience implementing Tableau Server or other Business Intelligence platforms

Installation and configuration of high availability Tableau Server Cluster(Primary, Worker, Backup Primary) and its processes (VizQL Server, Application Server, Data Server, Data Engine, Background Tasks, Gateway and Repository).

Activated Tableau server management add-on in the production Tableau server and used tools like Tableau Resource monitoring tool to identify issues that cause slow load times, extract failures and other critical issues.

Created Tableau extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insight into large data sets. Environment:

Tableau Server 2020.x/v10/v9/9.2, Alteryx, Cognos 8.4, SAP Hana 1.x, MS SQL Server 2016 / 2012

/ 2008 R2, Amazon RedShift, MongoDB, Kafka, Cloudera, Python, Hadoop (Cloudera), Hive, Impala, Angular JS, Java Script.

FEB 2014 TO DEC 2017

IT MANAGER - DATA VISUALIZATION ARCHITECT

JOHNSON & JOHNSON, BRIDGEWATER, NJ

Responsibilities:

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

Experience in Tableau as an administrator, including providing installation, administration, configuration, maintenance, performance monitoring, tuning support, providing general systems administration support, including patching, monitoring and experience with tabcmd and tabadmin command utilities, Tableau server licensing mechanism. 6

Manage application users, groups, Workbooks and Projects, Database Views, Data Sources, Data Connections and integration with Active Directory

Follow SOPs and administration guidelines for server upgrades, backups, patching, performance tuning, and security and administration of the applications

Coordinates with project managers and participates in project planning

Created incremental refreshes for data sources on Tableau server, developing / tuning of ETL process to Extract, Transform and Load the data into stage area and data warehouse using SSIS, SAP BODS and home grown ETL Processes not limited to DTS, Analysis Manager, Alteryx.

Conduct data model reviews with project team members.

Capture technical metadata through data modeling tools.

Enforce standards and best practices around data modeling efforts.

Worked and Trained in handing Privacy Data Sources following compliance standards HIPAA, PCI and OWASP

Working knowledge of HL7, FHIR and related standards.

Exposure to Analytics and Big Data platforms

Experience implementing Tableau Server or other Business Intelligence platforms

Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.

Involved in creating data blending in case of merging different sources.

Involved in creating a dual-axis bar chart with multiple measures.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, SQL Server, NOSQL DB – MongoDB and HDFS.

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

Providing the Privileges on Dashboards/Reports to appropriate users.

Publishing Apps Power BI services and providing access to appropriate users.

Sharing the Dashboards/Reports among the members within the organization.in creating and Publishing the Models and Publishing those models into Power BI Service. Environment:

Tableau Server v9/9.2/v8/8.2/v7, MS PowerBI Windows Server Standard R2, Excel, SQL Server management studio, Alteryx, Cognos 8.4, SAP Hana 1.x, MS SQL Server 2008 R2, Postgres, MongoDB, Kafka, Node JS, Java Script, Cloudera, Python. FEB 2013 – JAN 2014

TABLEAU LEAD CONSULTANT

POLO RALPH LAUREN, LYNDHURST, NJ

Responsibilities:

Interacted with business users and performed Gap Analysis of Client requirements.

Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Worked closely with business power users to create reports/dashboards using tableau desktop.

7

Provide infrastructure and platform sizing for projects, including hardware and software requirements, plan, design, and execute performance tests of platforms

Analyze, troubleshoot, and/or fine-tune product performance or deployment issues when required

Develop and document technical architecture, system designs, performance test results, and other technical aspects of implementations

Strong technical background with complete understanding of data warehouse modeling, architectures, OLAP, OLTP data sets, etc.

Solid knowledge and experience with Windows Server and networking technologies

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program managers and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static data sets.

Enforce standards and best practices around data modeling efforts.

Ensure data warehouse and data mart designs efficiently support BI and end user

Actively participated in clarification meeting with the Clients.

Created Test Cases and documented the Test Results.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment:

Tableau Desktop 8, Tableau Server, Business Objects, Cognos Report Net 1.1, Cognos 8.3 BI Modeling, Cognos 8.3 BI Server, Oracle, Crystal Reports, Windows Server 2008. FEB 2011 – JAN 2013

BI CONSULTANT

CARRIER CORPORATION, FARMINGTON, CT

Responsibilities:

Gathering the clients, Suppliers and internal resource data from all the Vendor Management Systems.

New KPI generation for Scorecards.

Data collection and leveraging on data manipulation teams for required data. 8

Developed complex SQL scripts for Teradata database for creating BI Layer on DW for Tableau reporting.

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

Created action filters, parameters and calculated sets for preparing dashboards and worksheets using Tableau.

Effectively used data blending, filters, actions, Hierarchies feature in tableau.

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

Worked in Admin Tasks using RESTful APIs.

Executed and tested required queries and reports before publishing.

Converted metric insight reports to tableau reports.

Worked extensively with Tableau Business Intelligence tool to develop various dashboards.

Worked extensively using Excel to validate the data and use as the source data files.

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

Environment: Tableau Desktop 6.0.2, Excel, Oracle), Windows Server 8, Windows 7

Contact this candidate