Rachit Chugh Email & Phone Number

Vancouver, Bc, Ca

British Columbia, Canada

Successfully delivered a significant company initiative to transition from Tableau on-premise to Tableau Cloud which • Involved Migration of 100+ Tableau workbooks & data models across environments and • Transitioning 600 users from Windows AD groups to the MS Azure system• lead to a projected cost optimization $50K per annum by license rationalization. Solution Optimization for reports like introducing best practices for robust Row Level security.User experience enhancement by implementing SSO, SAML.Automation & Improvisation by enabling latest techniques including SCIM & Grant License on Sign On .Impact assessments for strategic database to cloud data warehouses migration(Snowflake)

Gurugram, Haryana, India

• Defining, monitoring metrics KPIs via Dashboards as per business analysis and stakeholder definition to provide continuous feedback on the efficacy of the business.• Analyzing data, preparing and transforming data for producing aggregated and detailed reports, dashboards and presentations. Design, Develop, implement and support Tableau, Power BI dashboards.• Preparing architecture & solution Design for Visual Analytics , prototypes, roadmaps/plans for report automation, rationalization, automation & migration of reports , enablement of Mobile/Tablet Dashboards, augmenting statistical modelling results (e.g. regression, clustering, predictive), RCA & troubleshooting . • Creating & ensuring adoption of Design Patterns, guidelines, Standards & Best Practices, Governance model for establishing security and permission levels to maintain data confidentiality.• Exploration / R&D on new BI & web technologies and staying up-to-date on new analytics solution while administering Proof Of Concept (POC) and collaborating with Head of Departments (HOD) - General Managers.• Identifying the design feasibilities for Accessibility, like Color Vision Deficiency while evaluating the project scope to make the Design & Products more inclusive, accurate and user friendly with an optimized UX.• Key role involvement in design discussions for entire business intelligence, database initiatives and reviewing ETL mapping/workflows, analyze operational problems and recommend innovative solutions.• Mentoring members of the development team and delivering knowledge transfer session and creating documentation/ training materials.• Enabling user onboarding via sessions, training materials, in-person meetings to support self-service BI.• Collaborating with Stakeholders including cross functional business teams, CTO, Data Architects, administration, Data Integration team / Data Lake team and other vendors, demonstrating work prioritization, time management and problem solving skills.

Gurgaon, India

• Successfully curated & delivered MI and analytical insights by utilising historical data like Trend analysis, Cohort Analysis, and Retention for major business channels within Fidelity using Microsoft Power BI, Tableau SQL and Python.• Conducted Requirement gathering, translation of complex business requirements into reports/visuals and data analysis.• Delivered sophisticated analytical dashboard using advanced DAX and row-level security requiring Understanding 0 out various Data Analysis, Wireframe creation, Development and User Training activities.• Involved in Data Preparation using Python scripts, Tableau Prep flows & SQL. Data Modelling of intermediate to advance the complexity , and metadata management.• Enriched the Dashboards using non standard data , eg. results of Web scrapping using Python. • Translated SAS code & Altryx Flow, ETL (Extract, Transform and Load) to Python. • Created/designed interactive dashboard with dynamic elements with Selection/Actions filters and parameters• Involved in preparation of intermediate to advanced visualisation such as dual axis with Blended Axis & Reference line and Correlation Plot, data densification .• Deployed Tableau Server DEV, UAT and PROD environment to ensure governance and distribution.• Task breakdown using Jira and agile delivery.

Gurgaon, Haryana, India

• Evaluated latest & strategic products - Tableau Online, Tableau Extensions, Tableau CRM Analytics, Einstein Discovery. • Successfully enabled in Tableau server upgrade, Microsoft Office suite including Power Apps integration SSAS, Tableau Extensions using Extensions API like natural language processing NLP & NLG • Created Design Layouts & guidelines for tablet/mobile device layout (iPhone, iPad) • Managed tableau usage, observed Postgres Metadata DB and integrated tableau to Java Web Application using Tableau JavaScript API, HTML.• Enhanced dashboard performance using various tools like performance recording and SQL tuning via Explain Plan• Involved in automation process including downloading Tableau Automated Batch workbook via custom CLI TABCMD Power shell script and Tableau Automated Single PDF Creation via custom CLI TABCMD, power shell ,VBA

Gurgaon, India

• Financial & Regulatory Reporting.• Statistical & Analytical Dashboard development using Tibco Spotfire 6.5.• OBIEE 11g Design & Development.• OBIEE Automated Unit Test framework development using Python & QTP (VBA).• Data Analysis using Visual Analytics using SAS-VA

Gurgaon, India

Pune Area, India

• Implementation of SCM Analytics( Supply Chain Management ).• Inventory, Procurement & Spend Reports through OBIEE 11g, Informatica 9, BIP & Oracle SQL Queries.

Pune Area, India

• Migrating Reports from SAP BO, COGNOS 8.3 framework to OBIEE. • OBIEE 11g & BI Publisher Reports, Dashboard and Repository development.

Bachelor Of Engineering (Beng), Electrical, Electronics And Communications Engineering

Education record