Prithviraj Bhoite

Experience

• 

  Nihilent Technologies

  Feb 2004 - Mar 2006

  SCORECARD ANALYTICS Domain : Performance Management (Balanced Scorecard)Client : South African Revenue Services (SARS) Developed and accountable for complex score logic written in T-SQL stored procedures and T-SQL queries. Data transformation and extraction logic from disparate data sources to feed data elements. Build Olap cube on dimension & fact data model. Hands-on with MDX queries in report development. Understood the concept of Key Performance Indicators (KPIs) and its importance on dashboard & reporting. Show less

  • SQL Developer | OLAP Developer

    Apr 2005 - Mar 2006

  • .NET Developer | SQL Developer

    Feb 2004 - Mar 2005
• 

  Cognizant

  Apr 2006 - Aug 2008

  MARKET RISK REPOSITORY (MRR)Domain : Mortgage Based SecuritiesClient : Washington Mutual Bank, U.S. The project involved developing a comprehensive Value-at-Risk platform to measure market risks and risk limit oversights for all positions reported in Corporate Risk Report. Was responsible to build data marts using Kimball methodologies. Developed SSIS packages to import XML & CSV data feeds from analytical systems (Summit, Polypath, MIAC & WCC/WMMSC) into centralized market risk data mart repository. Was awarded for designing & delivering complex multidimensional SSAS cubes on top of market risk repository. Scripting & querying in MDX.RE-ENGINEERING & MIGRATIONDomain : Mortgage Based SecuritiesClient : Washington Mutual Bank, U.S. Was pivotal in performing migrating activities of existing DTS master-child packages of VAR and PNL systems into SSIS packages using Package Migration utility and converting MSOLAP 2000 cubes to SQL Server 2005 cubes. Show less

  • Data Analyst

    Apr 2008 - Aug 2008

  • DW & BI Developer

    Apr 2006 - Mar 2008
• 

  Nationwide Building Society

  Oct 2008 - Dec 2013

  BACK BOOK MIGRATION (Internal Account Transfer)Domain : Retail Core BankingREGIONAL BRAND GENERAL LEDGER INTEGRATIONDomain : General LedgerAchievements● Prototyped ETL framework for feature comparison, performance benchmarks & maintainability between SAP Data Services & SSIS for 100+ million transactions.● Contributed & managed meta-data driven ETL framework for consistent audits, logs & error handling.● Additional generic packages for file validation, cleansing, archiving & data quality developed.● Was accountable for delivery of SAP data services jobs to achieve end-to-end migration involving complex functional dependencies between core banking products - accounts, cards, ledger, payments etc.● Monitor production runs for e2e batches with guard-rails on account reconciliation & batch rollback.● Gained good domain knowledge on retail banking products - savings accounts, cards, payments, statements and their dependencies. Show less CONTACT OPTIMIZATIONDomain : Banking Marketing CampaignsOLC MIGRATIONDomain : Flex Collections - Retail BankingAchievements● Developed SSIS packages with complex transforms using script component, pivot, & data flow tasks. ● Adopted modular design approach with use of master-child packages and use of dynamic variables, expressions & package configurations. Got acquainted with meta-data driven ETL frameworks.● Delivered performant regulatory / operational SSRS reports and Excel dashboards.● As part of deliverables - built optimized T-SQL scripts, stored procedures, views, partitions & indexes.● Performance tuning of T-SQL, SSIS & SSRS packages using execution plans & buffer architecture.● Drafted technical documentation - Data mapping documents, Traceability Matrix, High / Detail Level Design documents, Technical Specifications & Unit test plans. Show less

  • ETL Consultant | Migration

    Jan 2012 - Dec 2013

  • DW & BI Consultant | Migration

    Oct 2008 - Dec 2011
• 

  IBM

  Apr 2014 - Jan 2016

  Senior ETL / SQL Consultant

  INTERNATIONAL FINANCIAL REPORTING STANDARDS 9Domain : Regulatory Reporting - IFRS 9FIRM DATA SUBMISSIONDomain : Regulatory Reporting - ALM, Retail, Treasury, Commercial, Ops Risk, Structured Finance, Pensions, ProjectionsFINANCIAL REPORTINGDomain : Regulatory Reporting - FinRepAchievements :● Was pivotal in advocating, implementing & delivering strategic data load platform using SSIS packages to migrate data from Treasury, Commercial GL & Retail source systems into Data Vault (Hub-Satellite) modelled Regulatory Reporting Data Store (RRDS) for generation of Axiom PRA templates.● Prototyped ETL migration framework for consistent error handling, auditing, logging & re-runnability functionalities with performance enhancements e.g. push-back & in-memory.● Accountable for developing complex T-SQL stored procedures per data point mappings for data reconciliation of EBA / PRA templates. These procedures validated data against business rules from source to Axiom reports.● Automate generation of handcrafted source feeds using T-SQL scripts & SSIS packages after thorough understanding of business products like treasury deals, commercial loans & retail mortgages.● Replicate report generation from source data to compare it with actual reports (templates) for validation of numbers, aggregation & OLAP functionalities.● Co-ordination with offshore team & stake holder management with business and regulatory heads. Show less

• 

  TomTom

  Jan 2016 - Jun 2024

  ANALYTICS & DATA SERVICES (Service Platform)● Orchestrate ETL data components in Azure Data Factory, Azure Databricks & Azure Synapse analytics. ● Build meta driven ETL frameworks for consistent & standardized logging, error handling & auditing. ● Design & structure storage layers using data lake / lake house architecture on ADLS storage account.● Organize layers - bronze, silver & star schemas in gold as per medallion architecture.● Apply data quality rules using PySpark notebooks - API extract, data wrangling - deduplication, missing values & outliers. Write patterns - Type-2, Batch Overwrites & Upserts.● Create Power BI templates, themes for consistent layouts and story telling.ON-PREMISES INFORMATION WAREHOUSE (IWH) MIGRATION TO AZURE CLOUD● Technically Lead, Mentor, Design & Manage the project end-to-end providing technical support.● Prepare plan / migration strategy – Lift & Shift / hybrid / complete end-to-end modernization. ● POC’s on SQL Managed Instance / SQL Instance on VM / Olap & Tabular Instance on VM.● Cost Estimation / Price Calculators / Decision Points on vCores & RAM / Scalability options. ● Work on challenges like Azure AD Integration Vs Domain Logins / 3rd party drivers e.g. ZappySys. Show less SALESFORCE ANALYTICS | SLACK & MS TEAMS DASHBOARD | AUTOMATIVE MIGRATION (TO SYNAPSE)● Accountable for design, build and delivery of data pipelines and data flows with optimum design.● Build ADF / Databricks pipelines using medallion architecture - lake house (bronze, silver & gold)● Ingest data using - Slack APIs, Workday & Salesforce connectors, SQL Server, MySQL & file-based.● Build tabular model in Power BI with right relationships & cardinality. ● Trouble shoot & Optimize performance bottlenecks in python code, data pipelines & Power BI DAX.● Create Price Estimation, 1/3-year reservation & prepare Design, ETL & Data Mapping Documents ENTERPRISE DATA WAREHOUSE (EDW) (DATA MESH PARADIGMN) INITIATIVE● Explored & understood concepts around data mesh architectures - data products & domains ● Conceptual understanding of Data Management & Data Landing Zones (Azure Cloud Scale Analytics)● Azure Purview - Register & Scan data sources, Collections, Access Management on collections.● Vendor Management - with external partners like Microsoft, Macaw for demos / knowledge sharing.● Presented POCs to internal teams for adoption of data governance using MS Purview. Show less INFORMATION WAREHOUSE BAU (IWH)● Maintain, manage & enhance enterprise-wide data warehouse (Size ~ 25 TB)● Designing & Develop SSIS packages, tabular cubes & Power BI reports. ● Lead projects to migrate Responsys data pipelines to Salesforce Marketing Cloud. ● Built analytic solutions for Salesforce marketing tracking, lead optimization, Mopinion feedback system & propensity models for customer churn.MIGRATION : ON-PREMISE POWER BI TO AZURE CLOUD● Technically lead, design & manage end to end on-premise PBI to cloud SaaS migration.● License Management - Understood various PBI licenses - Pro, Premium User & Premium Capacity.● Tenant Management - Provision premium capacities (P1 – P2). Setup & configure tenant settings.● Workspace Management – configure roles like Admin, Member, Contributor & Viewer. ● Report Sharing – Direct links & via Apps with multiple audiences. Data set refreshes via gateways● Data Governance - use Capacity Utilization App & Report Usage Metrics. Show less

  • Senior Data Engineer | Design

    Dec 2022 - Jun 2024

  • Data Engineer | Design

    Jan 2020 - Nov 2022

  • DW & BI Expert | Tech Lead

    Jan 2016 - Dec 2019
• 

  VIVID

  Jul 2024 - now

  Senior Data Engineer