Prithviraj Bhoite Email & Phone Number

Basingstoke, England, United Kingdom

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.

Pune, Maharashtra, India

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.

Pune, Maharashtra, India

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.

London, England, United Kingdom

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.

Swindon, England, United Kingdom

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.

London, England, United Kingdom

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.

Lisbon, Portugal

WESTERN EUROPE DATAWAREHOUSEDomain : Retail BankingClient : Barclays Bank, Portugal.Worked as a data analyst to capture entities, attributes and relationships from source systems for Barclays bank, Portugal. Generated data dictionaries for each product and application followed by data mapping documents to map source attributes to centralized data warehouse. Gained knowledge on building data models - conceptual & logical.

Pune, Maharashtra, India

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.

City Of Johannesburg, Gauteng, South Africa

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.

Pune, Maharashtra, India

LAMAT DASHBOARD Domain : Performance Management (Balanced Scorecard)Client : In-HouseResponsible for data consumed by dashboards at various levels in org. hierarchy - leaf level employees to senior managers. Worked extensively on data side i.e. writing T-SQL stored procedures and optimized T-SQL queries. Exploration on OLAP cubes and understanding of aggregation engines. Use of MDX in Olap.

Master Of Business Administration (Mba), Quantitative Methods And Business Analytics

Post Graduate Diploma In Advanced Computing (Acts), Computer Science, First Class

Bachelor Of Engineering - Be, Mechnical & Computers, Distinction