Pramod Kumar Chintalapati
Seattle, Washington 425-***-**** *****************@*****.***
PROFILE SUMMARY
With a comprehensive professional background spanning ~15 years, I currently serve as an Azure Data Engineer at LTIMINDTREE consulting for Microsoft, where I have been diligently contributing to Hi-tech domain. Previously worked in Azure Data Engineering and Data Analytics, at Tata Consultancy Services (TCS), for 10 years using various Microsoft Azure resources like Azure Data Factory, Azure SQL, Azure Databricks, Power BI, Pandas, Pyspark, Azure Logic Apps, Tabular Models etc. including utilization of Open AI for handling On Call responsibilities.
TECHNICAL SKILLS
•Databases: Microsoft SQL Server, SSIS, SSAS Tabular Models, Azure SQL, Kusto DB
•Programming: SQL, Python (Openpyxl, Pandas), Pyspark, PowerShell, Scope Scripting
•Azure: Data Warehouse, Data Factory, Logic Apps, Runbooks, Synapse, Function Apps, App Insights, Key vaults, Power Automate
•Big Data: Azure Databricks, Cosmos
•Reporting Tools: Power BI, ADX Dashboarding, SSRS
•Development Tools: Microsoft Visual Studio, ADO, Visual Studio Code
•Open AI: On Call responsibilities
PROFESSIONAL SUMMARY:
Microsoft Corporation (LTIMINDTREE) Jan 2025 – Till Date
Azure Data Engineer
•Currently developing pipelines using Scope Script to derive data for Signed in Users visiting various internal segments for Windows and Surface commercial website for US Market to trigger campaigns. ~133K users in US Market are being targeted with these campaigns.
•Developed automated data pipelines for handling Microsoft Windows Commercial Website Telemetry using Azure Databricks, Scope Scripting, Pyspark, Azure Data Factory, Azure SQL to help customer analyze the telemetry data to take key business driving decisions by triggering campaigns that would attract website users to buy Microsoft products. This entire activity showed a growth in sales of Microsoft products in Consumer Marketing Organization by 1%.
•Designed Automated pipelines using Pyspark in Azure Databricks to ingest data for Post Campaigns from EDLP (Enterprise Data Lake Platform based on ADLS Gen 2) to Azure SQL for Reporting purposes.
Microsoft Corporation (Tata Consulting) Nov 2014 – Dec 2024
Azure Data Engineer, Data Analyst
•Developed secure, automated data pipelines and efficient data models for Azure Security using Azure Data Factory, Kusto, Azure SQL, enabling visualization and analysis of security compliance using Power BI across Microsoft services in the organization helping to achieve 100% security compliance.
•Leveraged Azure resources for ETL and report design using Azure Data Factory, Azure SQL and Power BI to analyze user activity on the M365 Admin Center's Service Health dashboard, improving some Microsoft services availability by ~20%. Streamlined data pipelines into a single subscription with GIT configuration for better collaborative management.
•Led a team of 5 to design and deliver the SKU Map Digitization and Data Integration project using Azure Logic Apps, Azure Data Factory, Azure Databricks and Pandas, enabling seamless integration of new Microsoft Surface SKU programs with OnePDM, increasing the timely market release of Surface Devices by ~20%.
•Developed automated data pipelines and visualized data representation using Cosmos big data platform, Scope scripting, Azure SQL and Power BI for Microsoft's CDNA organization to analyze global usage of Win 10, 11, Pen & Touch devices, enabling user feedback surveys enhancing products efficiency by ~10%.
Tata Consulting (Aug 2009 - Oct 2014)
(Citi Bank, AmerisourceBergen, British Petroleum, Moody's Investor Services)
Database Developer
•Worked in designing ETL’s, developing Data Models and database objects for Addendum Application for Moody’s, to analyze metrics like Complexity of changes made within each Addendum, Addendums requiring legal review etc.
•Designed end to end Automated data pipelines to provide performance data online through environmental, social and governance (ESG) datasheet, aiming to deliver information that is representative of British Petroleum’s sustainability performance.
•Designed ETL’s, Data Models and Database design for AmerisourceBergen, now known as Cencora applications that offers a range of analytics to help manufacturers and providers improve patient care and product access.
•Worked in maintenance and support projects ensuring 100% SLA compliance for Citi Bank applications related to Loans, analyzing Data Warehouse systems and ETL’s to minimize the risk of losing money while lending to customers. Major tasks include Data exploration and Data cleaning.
EDUCATION
Graduated from Jawaharlal Nehru Technological University, Hyderabad, India with Information Technology Specialization.