Data Engineer Power Bi

NAMAN SINGHVI

Boston, MA 774-***-**** *************@*****.*** LinkedIn GitHub Portfolio

PROFESSIONAL SUMMARY

Experienced Data Engineer & Analyst with 4 years of expertise in SQL, Azure, Power BI, and Python, specializing in data platform optimization, ETL/ELT pipeline development, and automation of large-scale data integration (3M+ records).

Adept at performing data analysis on healthcare data for Medicare, Medicaid, and Commercial lines of business writing complex SQL queries.

Working experience at designing and implementing scalable data architectures, including data lakes, warehouses, and high-availability systems, improving data accessibility and data retrieval performance for the organization.

Demonstrated ability in using ETL methods, developed stored procedures, functions, packages, database triggers, and schema design in Oracle, and SQL Server.

Strong SQL experience and adept at developing SQL-based database solutions for reducing query execution enhancing data processing efficiency.

Skilled in team collaboration with experience leading cross-functional teams to develop data-driven solutions

Adept at working on analytics and business intelligence initiatives through Power BI, Tableau, and SQL.

Experienced working on cloud security measures and DevOps tools and technologies, improving server response times and performance tuning.

Strong analytical skills in data visualization, agile methodologies, and software development lifecycle (SDLC).

Earned certifications in Microsoft Azure (AZ-104, AZ-900, DP-900, AI-900) and Data Science to enhance my knowledge and keep myself up to date with the latest developments in the analytics field. SKILLS & CERTIFICATION

Programming & Scripting SQL, Python

Data Engineering & ETL ETL/ELT, Data Lakes, Data Warehouse, Airflow, Databricks, Snowflake Cloud & DevOps Azure Cloud, DevOps, CI/CD

Data Visualization & Analytics Power BI, Tableau

Data Modeling & Processing Data Modeling, Machine Learning Version Control & Project Management Git, Agile, SDLC Productivity & Documentation Microsoft Office Suite (Word, PowerPoint, Excel) Certifications

Advanced Certificate in Data Science

Microsoft Certified: AZ-104, AZ-900, DP-900, AI-900

BCG Virtual Experience Program – Generative AI

Accenture Virtual Experience – Data Analytics

PROFESSIONAL EXPERIENCE

Data Engineer, United Health Care, Remote May’24-Dec’24

Collaborated with cross-functional teams to enhance data literacy, increasing department productivity by 35%.

Assisted client with data analysis, optimized ETL processes, root cause identification, and HEDIS reporting.

Developed automated data validation scripts that reduced data inconsistencies by 30%, ensuring compliance with HIPAA and other healthcare regulations.

Integrated and processed healthcare datasets using SQL and Python, reducing processing time by 20%.

Managed medical records, demonstrating the ability to handle sensitive data securely and accurately.

Collaborated in building scalable data warehouses and BI dashboards, improving reporting speed by 20% for healthcare operations and patient analytics.

Conducted statistical analyses to drive data-driven decision-making, improving efficiency by 30%.

Developed intuitive reports and dashboards, enhancing decision-making by senior management and executives.

Developed Tableau dashboards for management, visualizing operational trends and driving actionable insights.

Enhanced database management and trend analysis with advanced SQL techniques, reducing data analysis time by 15%. Data Engineer, Advaiya Solution Inc, India Apr’21-Aug’23 Project 1: Dealer Management Application – MP Birla Cement

Designed, developed, and optimized large-scale database systems supporting 1M+ users, including dealers, retailers, sales officers, and upper management.

Led the end-to-end migration of raw data from SAP to Azure SQL Server, managing datasets exceeding 3M million+ records.

Engineered a robust SQL database architecture from scratch, comprising 40+ tables and 20+ stored procedures, improving query performance by 40%.

Developed and maintained Azure Data Factory & Azure Logic Apps pipelines, automating data processing for 200,000+ daily entries with 30-minute refresh cycles.

Built and managed CI/CD pipelines for API and frontend development, streamlining deployment processes and increasing operational efficiency.

Engaged closely with stakeholders to gather business requirements, translate them into scalable data models, and develop solutions ensuring high data integrity and performance.

Conducted data validation, software testing, and debugging, ensuring quality data delivery and application stability. Project 2: Adani One – Unified Digital Platform for Travel, Lifestyle, and Finance

As a data analyst, designed and implemented a high-availability data infrastructure, improving data accessibility by 90%.

Collaborated in building scalable data platforms, enabling organization-wide analytics and data-driven decision-making.

Applied agile methodologies to enhance project efficiency, ensuring seamless collaboration between data engineers, analysts, and business teams.

Optimized SQL queries and implemented indexing strategies, boosting data retrieval efficiency by 30%.

Enforced Cloud Security & Data Loss Prevention measures, improving data integrity and compliance as per policy.

Optimized data structures and implemented real time event-driven caching, enhanced system performance and reduced database load by 26%.

Collaborated with cross-functional teams to identify and resolve performance bottlenecks, reducing server response time and enhancing system reliability.

Data Analyst, TCS, India Sep’20-Mar’21

Monitored and analyzed server operations, storage performance, and backup efficiency, leading to a 25% improvement in system reliability and a 30% reduction in downtime across critical business functions.

Evaluated and optimized network security protocols, reducing potential vulnerabilities by 40%, thereby enhancing data protection and system resilience.

Promoted to Center Head within a month and leveraged data-driven insights to streamline workflows, optimizing resource allocation by 35% and increasing team productivity by 20%, leading to a 15% improvement in service delivery efficiency EDUCATION

M.S, Data Analytics (STEM), Clark University Dec’24 Bachelor of Science in Computer Science, College of Technology and Engineering Sep’21 ACADEMIC PROJECTS

Health Mate: Revolutionizing Dietary Health (Clarkathon, Clark University) Sep’24

Engineered the backend data architecture using Python and Firebase to support scalable and real-time data processing.

Developed core data handling processes using Python, ensuring data integrity and enabling efficient clustering of users based on dietary preferences for personalized health advice. Customer Retention Analysis for Phone Now Telecoms May’24

Designed Power BI dashboard visualizing customer churn trends, and demographic segmentation.

Computed KPIs such as churn rate, customer lifetime value, and revenue impact using DAX for advanced calculations. ACHIEVEMENTS

3rd Prize Winner, EasyA x Stacks Hackathon – Harvard University (November 2024)

Published "Digitalization and Use of Technology in Education", in Resonance of Gandhian Thoughts in NEP 2020.

Contact this candidate