Pavan Kumar Manneru, Developer in London, United Kingdom
Pavan is available for hire
Hire Pavan

Pavan Kumar Manneru

Verified Expert  in Engineering

Business Intelligence Developer

London, United Kingdom
Toptal Member Since
October 7, 2020

Pavan is a senior BI developer with almost a decade of experience and expertise in database, data warehousing, business intelligence, data visualization, and C# WinForms. He designed multiple databases, data warehouses, ETL flows, and various dashboards for the clients, including Tesco, Wells Fargo, HSBC, and Lloyds Bank. Pavan specializes in Microsoft SQL Server, SSIS, Tableau, Power BI, and C#. He is passionate about contributing to the dev community and freelancing market.


United Kingdom National Health Service (NHS)
Indexing, Stored Procedure, Data Architecture, Azure, Azure Event Hubs...
West London NHS Trust
Indexing, Stored Procedure, Relational Databases, MySQL, Storage...
HSBC and Lloyds
Indexing, Stored Procedure, Azure SQL, Azure Data Factory, Azure...




Preferred Environment

Microsoft Power BI, Data Visualization, Data Warehouse Design, ETL, C#.NET WinForms, Tableau Server, Tableau, SQL Server Integration Services (SSIS), SQL Server DBA, Windows

The most amazing...

...thing I've built is an end to end system that daily handles over two million checks written by HSBC and Lloyds banks' customers.

Work Experience

Lead Business Intelligence Developer

2018 - PRESENT
United Kingdom National Health Service (NHS)
  • Designed and developed the organization-wide data warehouse, gathering information from various data sources, such as SQL Server, Excel files, and CSV files.
  • Migrated the existing Apache Kafka streaming analytics platform to Azure cloud using Event Hubs.
  • Created an end-to-end analytics platform in the cloud, using Azure Data Factory, Databricks, and Synapse for the data generated by different healthcare devices, sensors, web applications, and mobile applications.
  • Developed more than 100 Tableau and Power BI dashboards for the patients' critical care, improving clinical staff's work efficiency.
  • Administered multiple databases in the business intelligence environment and pioneered performance tuning by optimizing the BI environment indexes.
  • Built an end-to-end business intelligence platform to directly or indirectly manage the healthcare system of 800,000 people.
  • Developed an ETL solution to create various statutory extracts, such as Microsoft Access, Excel, CSV, and XML files for the UK healthcare watchdog.
  • Wrote many SQL queries to solve complex business problems, understand, and analyze the data.
Technologies: Indexing, Stored Procedure, Data Architecture, Azure, Azure Event Hubs, Azure Data Factory, Azure SQL, Microsoft Power BI, Tableau Server, Tableau, C#, SQL Server Integration Services (SSIS), Data Warehouse Design, SQL Server 2016, Azure Data Lake, Data Engineering, Cloud, Healthcare Software, SQL Stored Procedures, Dashboards, Amazon Web Services (AWS)

SQL Database Administrator

2018 - 2020
West London NHS Trust
  • Provided performance tuning of SQL Server and MySQL database queries or stored procedures.
  • Diagnosed the database errors and provided solutions on the go.
  • Set up the coding standards for the in-house database developers and made sure that those are adhered to, which stabilized the database environments.
  • Managed the organization-wide security by making use of the database-level roles and server-level roles.
  • Created applications to monitor the health of the SQL Server and MySQL serving as disk storage for database files, which trigger an email if there are any glitches.
Technologies: Indexing, Stored Procedure, Relational Databases, MySQL, Storage, Performance Tuning, Monitoring, Microsoft SQL Server, Databases, Database Administration (DBA), SQL Server DBA, SQL, Data Engineering, Cloud, Healthcare Software, SQL Stored Procedures, Dashboards

Senior Business Intelligence Developer

2014 - 2018
HSBC and Lloyds
  • Implemented the UK government's directive of reducing the check processing time from six to two days, allowing users to use the image processing technologies.
  • Introduced Microsoft SQL Server with in-memory OLTP and built an end-to-end system to process more than two million checks per day.
  • Led a team of seven that took care of delivering the DevOps functionalities to all the software development processes, which resulted in the expedition of code movement and seamless deployments across multiple environments.
  • Used the WiX technology to create the MSIs for different artifacts such as Windows, web, and database applications, which led to effective continuous integration and continuous deployment (CI/CD).
  • Designed and developed a test harness project generating bulk data for the quality assurance team to test the E2E check and image processing.
Technologies: Indexing, Stored Procedure, Azure SQL, Azure Data Factory, Azure, Data Architecture, Tableau, SQL Server Integration Services (SSIS), SQL Server 2016, Data Engineering, Cloud, SQL Stored Procedures, Dashboards

Business Intelligence Developer

2014 - 2014
Wells Fargo
  • Designed and developed the mortgage-related business intelligence platform for Well Fargo, the third-largest bank in the US at the time.
  • Led a team of five, which changed the lives of around fifty thousand customers and 1,500 employees across the US with our business intelligence capability.
  • Managed a team of eight to deliver one of the bank’s most tedious manual projects for extracting the mortgaging reports. This automation saved the bank about 589 million pounds and resulted in overall improved processes.
  • Pioneered the automation of the build and deployment of various database and ETL projects utilizing the CI/CD functionality of the Microsoft Team Foundation Server (TFS).
  • Provided support to multiple projects in the production environment by handling various incidents and problem tickets when the system was still functioning as a whole.
Technologies: Indexing, Stored Procedure, Data Architecture, SQL Server Integration Services (SSIS), Data Engineering, SQL Stored Procedures, Dashboards

Data Engineer

2011 - 2014
  • Designed and developed the automation of sales and stores’ processes, which impacted approximately 500,000 employees across the globe.
  • Made a significant impact on the company's revenue with the data migrations. The total savings accounted for £3 billion.
  • Awarded the most valuable employee award by the company's CEO for my significant contributions to the program for the online shopping capability, which resulted in a profit of £498 million.
  • Led a team of two for the automated builds and deployments and got the best-performed team award on the company's annual gathering. Delivered build and deployment automation for 38 different projects.
  • Delivered various business intelligence data migration and build automation projects using Waterfall and Agile SDLC model.
Technologies: Indexing, Stored Procedure, Data Architecture, SQL Server Integration Services (SSIS), SQL Server 2008 R2, Data Engineering, SQL Stored Procedures, Dashboards

Check Clearing Process Migration

The process of check clearing in the UK had undergone an important and necessary change. The main difference was that instead of exchanging physical paper checks, UK banks had begun to exchange digital images of these checks.

I was a part of the team that designed a solution to process these images and data at the same speed. Introducing the concept of Microsoft SQL Server in-memory OLTP, I helped the organizations load and process the images and data of around two million checks with very high throughput.

Serving as the organization-wide data warehouse architect, I helped the senior management in the decision-making and creating the most useful Tableau dashboards.

Healthcare Streaming Analytics Migration to Cloud

Working as a lead BI and data engineer in the healthcare industry, I was challenged to migrate the existing Apache Kafka event capturing and streaming platform to the cloud, preferably Azure.

The existing platform, Apache Kafka Cluster, performed a lot of real-time recording operations like ICU monitoring, diabetes results recording, and blood pressure metric recording.

Using the Azure services like Azure Event Hubs, Data Factory, Data Lake Storage Gen2, and Synapse, I was the prime architect of the entire project from the data producer side to the data consumer side.

This migration project enabled our healthcare provider to apply predictive analytics to data in motion for continuous decisions, allowing them to capture and analyze data—all the time, just in time. The end goal is to save lives, shorten hospital stays, and build healthier communities through preventive care.

Retail Head Office and Stores Data Integration/Engineering

This project's aim was integrating 1,000 Tesco UK retail stores data to the head office. I served as a BI/ETL engineer working with business analysts to understand and integrate the data using various technologies.

The whole workflow included both OLTP and OLAP processes.
OLTP processes were used to record and transfer the sales, prices, and promotion information from stores to the head office on a near real-time basis.

OLAP processes to turn the sales and other data into a reportable and presentable data warehouse using various ETL/ELT processes and then presenting them in intuitive dashboards in the Microsoft Power BI.

Migration of Data Warehouse to Google Cloud and BigQuery

Working as a lead BI and data engineer in the healthcare industry, I was given the challenging task of migrating the existing on-premises data warehouse to the cloud, preferably BigQuery of Google Cloud Platform (GCP).

Using Apache Beam in conjunction with Python, multiple data pipelines were created to load the data from numerous sources like the CSV files, Excel spreadsheets, Access databases, and on-premises SQL Server databases. The transformations had been seamlessly done using Python before finally moving the data to the BigQuery.

The BigQuery had then been exposed to the Tableau for creating multiple intuitive dashboards.

This migration project enabled our healthcare provider to apply predictive analytics to data in motion for continuous decisions, allowing them to capture and analyze data—all the time, just in time. The end goal is to save lives, shorten hospital stays, and build healthier communities through preventive care.

Livestock Data Ingestion into AWS Redshift (Cloud DWH)

Working as Data Analyst/Engineer in the livestock industry, I was tasked with ingesting various livestock specie information into the AWS Data warehousing infrastructure, mainly into Redshift. Ingestion was facilitated using multiple Amazon Web Services like AWS Lambda functions and AWS Glue. The data was sent into an S3 bucket. This would either be picked up by the AWS Lambda function or AWS Glue ETL Pipeline. With corresponding transformations, it would be loaded into AWS Redshift. Redshift was then exposed to Tableau to create multiple intuitive dashboards using SQL as the querying language. This data analytics project enabled the company to effectively manage livestock disease tracing and maintain data in one place.
2007 - 2011

Bachelor's Degree in Computer Science and Information Technology

Jawaharlal Nehru Technological University (JNTU) - Hyderabad, India


C#.NET WinForms, Tableau, Microsoft Power BI, DataViz, BigQuery, Amazon Athena


SQL, T-SQL (Transact-SQL), Stored Procedure, C#.NET, C#, Python


ETL, Business Intelligence (BI)


Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS), Windows, Azure Event Hubs, Azure Synapse


SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server DBA, SQL Server 2016, Azure SQL, Database Administration (DBA), Databases, Microsoft SQL Server, Google Cloud Storage, Data Pipelines, MySQL, Relational Databases, SQL Stored Procedures, RDBMS, PostgreSQL, Amazon S3 (AWS S3), SQL Server Analysis Services (SSAS), Redshift


Data Warehouse Design, Data Engineering, Data Warehousing, Data Migration, ETL Development, ETL Tools, Data Analysis, Data Architecture, Azure Data Factory, Monitoring, Performance Tuning, Storage, Cloud Storage, Indexing, Cloud, Dashboards, Data Analytics, Data, Azure Data Lake, Healthcare Software, Tableau Server, Data Visualization, Architecture, Data Build Tool (dbt)

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.


Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring