Anil Kumar Email & Phone Number

New Delhi, Dl, In

Noida, Uttar Pradesh, India

• Proficient in Microsoft Fabric, Power BI, and data integration tools.• Designed and implemented Data Lakehouse solutions using MS-Fabric, leading large-scale data migration projects with minimal downtime.• Conducted ETL/ELT processes, machine learning, and real-time data processing with MS-Fabric.• Improved data security through encryption and access control measures.• Ensured smooth interoperability with third-party tools for efficient data flow.• Certified in DP-600: Implementing Analytics Solutions Using Microsoft Fabric.• Conducted comprehensive training sessions for team members on using Microsoft Fabric tools and best practices.• Completed various workshops and training programs on data analytics and Microsoft Fabric.• Expertly utilized Microsoft Fabric to integrate and analyze large datasets, significantly improving data accessibility and insights.• Actively shared knowledge and best practices on LinkedIn, contributing to the data engineering community.• Coordinated with clients to understand project requirements.• Prepared the BOQ and Demonstrate the POC’s for clients.• Worked on client projects, focusing on fulfilling their specific requirements.• Expertise in conducting successful audits which run by Microsoft for pre and post sales call for Analytics on Azure, VM, and other tools.• Expert in deploying Azure Cognitive Services, Azure Machine Learning, and Azure OpenAI technologies, including GPT-4, GPT-3.5, DALL-E, and Whisper, for innovative AI solution development.• Capable of demonstrating AI technology solutions to clients, showcasing potential applications and facilitating informed decision-making.• Collaborated on designing, developing, and maintaining data pipelines using Python, Spark, and Databricks.• Oversaw the optimization of data pipelines for performance, scalability, and reliability.• Managed Azure data processes, including deployment automation and continuous integration.

El Segundo, California, United States

• Strong experience in Azure platform Services, with a deep understanding of their capabilities and limitations.• Experience working on Azure IaaS Technologies such as VMs, Virtual networks, Express Routes, Standard/Premium storage, etc.• Strong expertise in building cloud-native enterprise data lakes and migrating applications from on-premises to cloud environments.• Experience in setting up enterprise-level account structure and security models in cloud environments.• Hands-on experience with infrastructure automation for continuous integration and continuous deployment of technical solutions leveraging Azure Services and Features.• Implemented solutions using Azure Synapse/Fabric, ADLS gen2 and Onelake.• Demonstrated knowledge of cloud architecture and implementation features (OS, multi-tenancy, virtualization, orchestration, elastic scalability).• Experience in carrying out the IT strategy assessment/consulting for a large enterprise.• Finding the insights of Job Boards and JobDiva as administrative prospectives.• Implemented data modeling techniques, such as creating relationships, calculated columns, and measures in Power BI.• Conducted performance tuning and optimization of Power BI reports for efficient data retrieval and visualization.• Designed and maintained MySQL databases, including schema design, indexing, and query optimization.• Created and optimized SQL queries for data retrieval, manipulation, and reporting in MySQL.• Implemented database security measures, including user management, access control, and data encryption in MySQL.• Conducted database performance monitoring and tuning to optimize query performance and enhance system efficiency.• Migrated data from various sources to MySQL databases using ETL tools or custom data integration scripts.• ETL (Extract, Transform, Load):• Developed and designed interactive and visually appealing reports using SSRS.• Hand on Experience ATS tool as admin prospective (JobDiva).

Noida, Uttar Pradesh, India

• Experience in handling large database• Experience in data visualization.• Experience in data modelling.• Experience in ETL.• SQL- joins, DML queries, DQL Queries• Experience in dashboard creating designing and update.• Hands on experience in performance optimization techniques by analyzing Query Execution Plans.• Collaborated with stakeholders to gather requirements and translate them into effective Power BI solutions.• Utilized DAX (Data Analysis Expressions) to create advanced calculations and measures in Power BI.• Published and shared Power BI reports and dashboards with appropriate permissions for users and stakeholders.• Experience in commercial payer like Cigna, Humana, BCBS, • Developed and designed interactive and visually appealing reports using SSRS.• Created and managed report models, data sources, and shared datasets.• Assisted end-users in report navigation, troubleshooting, and training.• Designed and developed ETL (Extract, Transform, Load) packages using SSIS to integrate data from multiple sources into a unified data warehouse.• Utilized SSIS Control Flow to orchestrate and schedule ETL processes, ensuring data synchronization and accuracy.Aetna etc.. and government payer like Medicare and Medicaid.• Experience in Database Design, Test, and Production Environments with Confidential business domains like healthcare, financial.• Good Advance Excel Skills used Vlookup, Hlookup, Pivot table, Pivot chart, Text functions, logical functions, Conditional formatting, data validation, dashboarding, slicers, filter and sorting.• Hands on experience in performance optimization techniques by analyzing Query Execution Plans• Work on projects and reports allocated as per agreed timelines• Write data validation scripts for data integrity and quality check• Hands on experience in Azure Development, worked on Azure web application, App services, Azure storage, Azure SQL• Maintaining the records of reports of every employee Report QC work

Noida, Uttar Pradesh, India

• Willingness to work in shifts (attitude)• Experience in Data visualization and modelling.• Generate timely and accurate reports for analysis. Handling the backend operations works.• Working as Cloud Administrator on Microsoft Azure, involved in configuring virtual machines, storage accounts, resource groups.• Data query language: SQL, DAX• MIS reporting by using MS Excel at Operational level.• Hands on experience in performance optimization techniques by analyzing Query Execution Plans.• Generating & maintaining day to day MIS Data and updating the management.• Developed 70% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights.• Dedicated to finishing projects by or even before the set deadline.• Perform tasks of defined processes or procedures• Proactively seek to identify and improve current core procedures• Preparation of Client Servicing Reports for complex and sensitive clients• Communicating with Onshore partner to maintain Dashboard and daily Deposit and share report with daily, Weekly and monthly basis.• Handling 7 Facility Hospital (Rutherford, Sent Thomas, Dekalb and Highland hospital) Dashboard, balancing and Reporting part too• Train the new recruiters.

Noida, Uttar Pradesh, India

Deliver presentation report of research findings to client partnersAdvising them on how to best use research findings. Balancing and filling out daily worksheets dashboard for whole team.Generating & maintaining day to day MIS Data and updating the management.