Pavan Kumar Manneru
Verified Expert in Engineering
Business Intelligence Developer
Pavan是一名高级BI开发人员,在数据库方面拥有近十年的经验和专业知识, data warehousing, business intelligence, data visualization, and C# WinForms. He designed multiple databases, data warehouses, ETL flows, 为客户提供各种仪表板, including Tesco, Wells Fargo, HSBC, and Lloyds Bank. Pavan擅长于Microsoft SQL Server, SSIS, Tableau, Power BI和c#. 他热衷于为开发社区和自由职业市场做出贡献.
Portfolio
Experience
Availability
Preferred Environment
Microsoft Power BI,数据可视化,数据仓库设计,ETL, c#.NET WinForms, Tableau Server, Tableau, SQL Server集成服务(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
首席商业智能开发人员
联合王国国民保健服务(NHS)
- 设计和开发组织范围的数据仓库, 从各种数据源收集信息, such as SQL Server, Excel files, and CSV files.
- Migrated the existing Apache Kafka streaming analytics platform to Azure cloud using Event Hubs.
- 在云中创建端到端分析平台, using Azure Data Factory, Databricks, 和Synapse用于不同医疗保健设备生成的数据, sensors, web applications, and mobile applications.
- 为患者的重症监护开发了100多个Tableau和Power BI仪表板, 提高临床工作人员工作效率.
- 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.
- 开发ETL解决方案以创建各种法定摘录, such as Microsoft Access, Excel, CSV, 以及为英国医疗监管机构提供的XML文件.
- Wrote many SQL queries to solve complex business problems, understand, and analyze the data.
SQL Database Administrator
West London NHS Trust
- 提供SQL Server和MySQL数据库查询或存储过程的性能调优.
- 诊断数据库错误并随时提供解决方案.
- Set up the coding standards for the in-house database developers and made sure that those are adhered to, 稳定了数据库环境.
- 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, 如果有任何故障,哪一个会触发电子邮件.
高级商业智能开发人员
HSBC and Lloyds
- Implemented the UK government's directive of reducing the check processing time from six to two days, 允许用户使用图像处理技术.
- 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.
- 使用WiX技术为不同的工件(如Windows)创建msi, web, and database applications, 这导致了有效的持续集成和持续部署(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.
Business Intelligence Developer
Wells Fargo
- 为富国银行设计和开发抵押贷款相关的商业智能平台, 当时是美国第三大银行.
- Led a team of five, 它改变了大约5万名顾客和我的生活,我们在全美有500名员工.
- 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.
Data Engineer
Tesco
- 设计和开发销售和商店流程的自动化, which impacted approximately 500,000 employees across the globe.
- 通过数据迁移对公司的收入产生了重大影响. 总共节省了30亿英镑.
- Awarded the most valuable employee award by the company's CEO for my significant contributions to the program for the online shopping capability, 这导致了4.98亿英镑的利润.
- Led a team of two for the automated builds and deployments and got the best-performed team award on the company's annual gathering. 为38个不同的项目交付构建和部署自动化.
- Delivered various business intelligence data migration and build automation projects using Waterfall and Agile SDLC model.
Experience
Check Clearing Process Migration
I was a part of the team that designed a solution to process these images and data at the same speed. 介绍了Microsoft SQL Server内存OLTP的概念, I helped the organizations load and process the images and data of around two million checks with very high throughput.
作为组织范围的数据仓库架构师, I helped the senior management in the decision-making and creating the most useful Tableau dashboards.
医疗保健流分析迁移到云
The existing platform, Apache Kafka Cluster, 进行了很多实时记录操作,比如ICU监护, diabetes results recording, 还有血压测量记录.
使用Azure服务,如Azure事件中心, 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, 让他们能够随时捕捉和分析数据, just in time. The end goal is to save lives, shorten hospital stays, 通过预防保健建立更健康的社区.
零售总部和商店数据集成/工程
整个工作流包括OLTP和OLAP两个过程.
OLTP流程用于记录和转移销售, prices, 并且促销信息几乎实时地从商店传到总部.
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.
数据仓库向Google Cloud和BigQuery的迁移
将Apache Beam与Python结合使用, multiple data pipelines were created to load the data from numerous sources like the CSV files, Excel spreadsheets, Access databases, 和本地SQL Server数据库. 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, 让他们能够随时捕捉和分析数据, just in time. The end goal is to save lives, shorten hospital stays, 通过预防保健建立更健康的社区.
牲畜数据摄取到AWS红移(云DWH)
Education
计算机科学与信息技术学士学位
贾瓦哈拉尔·尼赫鲁理工大学(JNTU) -印度海得拉巴
Skills
Languages
SQL, T-SQL (Transact-SQL),存储过程,c#.NET, C#, Python
Tools
C#.. NET WinForms, Tableau, Microsoft Power BI, DataViz, BigQuery, Amazon Athena
Paradigms
ETL, Business Intelligence (BI)
Platforms
Azure, Google Cloud Platform (GCP), Amazon Web Services (AWS), Windows, Azure Event Hubs, Azure Synapse
Storage
SQL Server 2008 R2, SQL Server集成服务(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分析服务(SSAS), Redshift
Other
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)
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring