Anoop Kumar CV

Experience

• 

  Teradata

  Jun 2006 - Oct 2012

  Support Engineer

  Served as a Database Support Engineer for Teradata, addressing customer issues and offering design consultations to ensure optimal performance of data warehousing systems. Specialized in optimizing customer workloads and enhancing query performance.

• 

  JPMorgan Chase & Co.

  Oct 2012 - Aug 2015

  Senior Database Analyst

  Designed data warehouse in Teradata to deliver a comprehensive 360-degree view of the customer, managing approximately 1 Petabyte of data. Played a key role in re-designing the existing data warehouse solution to Teradata, ensuring optimal performance and an enhanced user experience.

• 

  UnitedHealth Group

  Aug 2015 - Apr 2022

  Worked as Senior Data Engineer in designing ETL process to load data into Snowflake using Azure Data Factory pipelines/ Databricks. This involved creating and configuring data pipelines and Spark code in Databricks to extract data from various sources, transform it according to business requirements, and load it into Snowflake. I utilized Data Factory’s built-in connectors and activities to streamline the data flow, ensuring efficient and reliable data transfer. Additionally, I implemented data validation and error handling mechanisms to maintain data integrity and quality throughout the process. This ETL solution not only improved data accessibility and analytics capabilities but also optimized performance and scalability for the organization’s data warehousing needs.Utilized Terraform for Infrastructure as Code (IaC) to automate the provisioning and management of cloud resources. This approach ensured consistent and repeatable infrastructure deployments, improved scalability, and reduced manual configuration errors. Show less Possess extensive experience in managing large-scale data warehouses, ranging from terabytes to petabytes. Key responsibilities include capacity planning, generating system performance reports, user management, database administration, access management, and backup management.Additionally, have significant experience in migrating in-house data environments to Azure Cloud, designing the entire supporting ecosystem in the cloud. Successfully migrated several environments, enhancing user experience and reducing overall costs. Show less

  • Senior Data Engineering Consultant

    Aug 2021 - Apr 2022

  • Data Engineering Consultant

    Aug 2015 - Aug 2021
• 

  Microsoft

  Feb 2022 - Jul 2023

  Azure Synapse Escalation Engineer

  As an Azure Synapse Escalation Engineer, I played a critical role in resolving complex technical issues and ensuring the smooth operation of Azure Synapse Analytics environments. My responsibilities included diagnosing and troubleshooting performance bottlenecks, query optimization, and addressing data integration challenges. Leveraged my industry expertise to elevate the team’s performance and capabilities.Involved in conducting regular health checks, performance tuning, and capacity planning to anticipate and mitigate potential issues. I also provided guidance and best practices to customers, helping them leverage the full capabilities of Azure Synapse for their data analytics and warehousing needs. My efforts contributed to improved customer satisfaction and the successful adoption of Azure Synapse solutions across various organizations. Show less

• 

  Tata Consultancy Services

  Aug 2023 - now

  Azure Architect

  As a Data Engineering Manager/Architect, I spearheaded the development of a sustainable Data as a Service (DaaS) solution for finance data on Microsoft Fabric. This involved designing and implementing a robust architecture that could handle large volumes of financial data with high efficiency and reliability. My team and I utilized Microsoft Fabric’s advanced capabilities to create scalable data pipelines, ensuring seamless data ingestion, transformation, and storage. We focused on optimizing data workflows to support real-time analytics and reporting, providing stakeholders with timely and accurate financial insights.In addition to the technical implementation, I led efforts to establish best practices for data governance, security, and compliance. We implemented stringent data quality checks and monitoring mechanisms to maintain the integrity and accuracy of the financial data. By leveraging Microsoft Fabric’s integrated tools, we ensured that our DaaS solution was not only scalable and performant but also aligned with industry standards and regulatory requirements. This comprehensive approach enabled us to deliver a reliable and sustainable data service that empowered the customer to make informed decisions and drive business growth. Show less