Nitin Dagar

Analytical and detail-oriented Data Analyst with proven expertise in designing and implementing data-driven solutions. Skilled in SQL Server, Power BI, and backend automation, with hands-on experience in building analytical business layers, developing workflows, and optimizing data pipelines. Adept at transforming complex datasets into actionable insights that support business decision-making.

Strong communicator with experience collaborating across teams, resolving critical issues under tight deadlines, and delivering innovative solutions that improve efficiency and accuracy. Seeking a challenging Data Analyst role to leverage technical skills and contribute to organizational growth.

Software Engineer (Data Analytics & Automation) - Infosys Ltd

(2021-12)

• Designed and executed complex SQL queries, stored procedures, joins, views, and data models in Microsoft SQL Server to handle large-scale datasets. This enabled efficient analysis of customer transactions and operational data for actionable insights.
• Collaborated with cross-functional teams to migrate certain reporting workflows from Excel/Power BI to Tableau, improving accessibility and reducing manual effort.
• Performed extensive data cleaning, transformation, and validation using SQL and Python scripts. This improved reporting accuracy by eliminating duplicate records, handling missing values, and standardizing inconsistent formats.
• Worked closely with business stakeholders to gather requirements, translate them into technical specifications, and deliver tailored analytical solutions that aligned with organizational goals.
• Built KPI dashboards to monitor operational metrics, incident trends, workflow performance, and SLA adherence. These dashboards provided real-time visibility into service delivery and helped identify bottlenecks quickly.
• Leveraged advanced Excel features such as Pivot Tables, VLOOKUP/XLOOKUP, Power Query, conditional formatting, and custom visualizations to support ad-hoc reporting needs and detailed analysis for non-technical stakeholders.

Associate Software Engineer (Cloud & Data Operations) - DXC Technology

(2021-08 - 2021-12)

• Designed and managed SQL-based validation processes to ensure data integrity across multiple business systems. Built automated checks that flagged inconsistencies in transactional and reporting data, significantly reducing manual validation effort.
• Assisted in analysing large volumes of business data to identify anomalies, recurring patterns, and actionable insights. Delivered reports that highlighted customer behaviour trends and operational inefficiencies, directly supporting strategic decision-making by management.
• Actively collaborated with cross-functional teams including business analysts, developers, and QA engineers in an Agile/Scrum environment. Participated in sprint planning, daily stand-ups, and retrospectives using Jira, ensuring timely delivery of analytics features and reporting enhancements.

B.Tech - ADGITM, Guru Gobind Singh Indraprastha University (2017-08 - 2021-06)