Raj Sharma

<p>Complete change of Salesforce, AWS, Broad sign, Microsoft Dynamics 365, CPQ, web API and legacy systems and rebuild of reporting dashboards and Azure data factory, Data Lake and Data bricks.<br>
AI Tools, Claude code.<br>
Rebuild of all poer BI dashboards from new data sources in a Fabric environment.<br>
Data modelling of new data columns and measures into minimal tabular models/semantic models using a star schema.<br>
Rebuilt of SSAS cubes using Microsoft analysis services & Tabular editor, Sql Server Management Studio.<br>
Data from Microsoft Dynamics 365.<br>
Budgeting, revenue, marketing, operational dashboards.<br>
Testing of user functionality, designing user access management and row level security.<br>
Worked on extraction of data from all sources in data bricks and modified schemas and made changes to orchestration processes.<br>
Data governance and pii data encryption<br>
Worked on transformation of data from raw to presentation level involving complex calculations for Time series, taxation and availability for global markets.<br>
Used Git Hub for control management during the project.<br>
Worked as part of a migration team.</p>

<p>Built and maintained a production-grade data platform and reporting suite supporting finance, marketing, and operational stakeholders across European markets.<br>
Built and maintained Power BI and Looker dashboards for finance and marketing stakeholders — including row-level security, complex DAX measures, and data governance controls<br>
AI Tools – chat gpt, Claud code, Perplexity.<br>
Data models for marketing initiatives and customer journeys & return on investment.<br>
Designed and documented KPI frameworks for business performance reporting, working directly with stakeholders to define metrics and ensure accuracy<br>
Wrote and optimised complex SQL queries (Big Query SQL) for data extraction, transformation, validation, and quality assurance across large datasets using DBT core.<br>
Sql Server Management Studio.<br>
Mapped and restructured spreadsheet-based reporting processes into robust, scalable data models and automated pipelines in Python. YAML.<br>
Managed DBT transformation project — staging models cleaning raw data, mart models applying business logic, incremental partitioned tables<br>
Maintained production ETL pipelines ingesting data from Adobe Analytics, GA4, SFTP, and internal systems into Big Query<br>
Implemented GDPR data governance processes including consent management and managing PII data encryption using taxonomy.<br>
Good understanding of CI/CD pipelines and data engineering using GIT HUB.<br>
IAM user access management and group management for consultants and new engineers<br>
Led workshops and training sessions for new platform users; managed stakeholder relationships at all seniority levels</p>

<p>Led a large-scale reporting migration project — migrating Hewlett Packard North & South America reporting estate from on-premises to cloud.<br>
Sql Server Management Studio,SSRS,SSIS.<br>
Consolidated 80 Power BI dashboards into 14 through data model redesign and SQL rearchitecting — significantly improving data consistency and reporting quality.<br>
There were some Tableau dashboards also that we migrated.<br>
Defined and documented reporting KPIs and data quality standards across the migrated estate<br>
Built and optimised complex SQL views, stored procedures, and data quality checks across multiple source systems<br>
Managed CI/CD release planning using GitHub and Confluence, executing structured testing and deployment cycles</p>

<p>Single View of Customer Project<br>
Azure, Power BI, BI Projects.<br>
Azure Data Factory, ADF, Azure data lake storage.<br>
Sql Server Management Studio<br>
Rebuilt all dashboards and reporting from a manual process to fully automated ones.<br>
Management of ETL, Dashboards & all data related functions.<br>
Migration of data from all source systems.<br>
Managing all data flows into BI Environments.<br>
KPI Reporting - Across all markets – globally.<br>
Pipeline KPI Creation – via projects.<br>
Ad-hoc reporting, consultancy when required</p>

<p>Single View of Customer — Oracle data warehouse, Salesforce/Veeva CRM integration, Tableau and Power BI dashboards<br>
Multiple data migration for customer focussed data<br>
Exasol, Exaplus, Oracle SQL Developer, Salesforce, Veeva<br>
Sql Server Management Studio<br>
Oracle data warehouse, Tableau Desktop, Tableau Online<br>
R, Python, Azure, Data Science<br>
Modifications to existing data warehouses<br>
Exasol data migration<br>
Tableau dashboards<br>
Ad-hoc reporting, consultancy when required<br>
Covering all aspects of BI</p>

<p>Management of BI infrastructure and project work<br>
Managing existing Tableau online, Sql Server Management Studio, SSIS, AWS, Azure<br>
Data Science ETL management.<br>
Migration Oracle to AWS Data Lake Quick site, Tableau.<br>
Working on projects to enhance Business Intelligence.<br>
Metrics – cancelation rates, trade conversions, all aspects of trading.<br>
Campaign analysis and modelling.<br>
Risk/Compliance analysis, client KYC, Fraud detection.<br>
Trading analysis and metrics.<br>
Building solutions for data science.<br>
Monitoring – irregular trading and cash withdrawals.<br>
Monitoring of corporate/private client accounts and balance /credit reporting.<br>
Covering all aspects of BI</p>

<p>Integrating Google Cloud data into looker and creating visualisation and analysis dashboards for global markets and technology management.<br>
Google Big Query, Looker & Tableau, Azure, AWS, Adobe Analytics.<br>
Power BI – DAX Queries<br>
Integrating data from different sources with Looker, ETL, API.<br>
Modify & manage Tableau and looker environment<br>
Undertaking highly complex data manipulation and analysis<br>
Working with users and business leaders<br>
Managing various projects and delivering on time</p>

<p>Analysis, dashboards, modelling<br>
SQL Server 2017, Visual studio 2017, Tableau, AWS Redshift, MySQL Workbench<br>
Power BI – DAX Queries<br>
Sales Analysis – including, linear regression, seasonal indexing, forecasting<br>
Applying data science modelling, customer segmentation.<br>
Manging 2 SQL servers, AWS redshift server, backups and nightly jobs.<br>
Creating views for powering dashboards<br>
Meeting with steak holders for initial requirements.<br>
Managing projects from start to delivery.<br>
Working towards tight deadlines in a very high-pressured environment.<br>
ETL, stored procedures, Data Quality, Data Cleansing</p>

<p>Complete digital marketing BI solution — Big Query, Google Analytics, Python ETL, REST API integration, ROAS analysis<br>
Sql Server Management Studio, Visual studio 2017, Power BI, Google Analytics, Big Query.<br>
Omniture click stream, Appsumer, Agency Data, API data.<br>
Improvement of existing ETL, Data Quality and reporting environment.<br>
Design and build of a new ETL process using C#, Python & SSIS.<br>
Complete solution for digital marketing to improve growth and, market share.<br>
Analysis for customer journey, user journey, various apps and websites.<br>
API integration with other platforms, REST API, APP Sumer, Cloud Services.<br>
Impact Analysis, Growth, Yield and ROAS analysis.<br>
Creation of KPI’s and metrics to monitor e-commerce<br>
Multiple analysis of business areas to create dashboards.<br>
Data Visualisation in Power BI, DAX Queries, R data, SSRS & Microsoft BI Stack.<br>
Analysis of Media, marketing, digital marketing, sales data<br>
Developing complete solution across all departments including Finance.<br>
ETL, stored procedures, Data Quality, Data Cleansing</p>