KIRAN JADHAV

• Interact with business users to understand the business requirements
• Performed Power Bi Desktop data modelling, which cleans, transforms, and mashes up data from multiple excel
• Designed and created data visualization using multiple Stacked bar chart, clustered bar chart, scatter chart, line and clustered column chart, slicer, grid etc
• Implement DAX expressions, measures, and an appropriate relationship to filtration from user input as per requirement
• Edited queries like merge and append queries, split columns, conditional columns, add columns, transpose, extract, pivot, and un-pivot, Remove nulls, errors, etc
• Created page-level filters and a visual-level filter in Power Bi as per requirements
• Used group by and created index to create calculated column
• Created RLS to restrict data access for users.

• Worked as a Reconciliation Analyst for the IntelliSuite set of Applications, which is a SunGard product.
• It mainly deals with account reconciliation.
• Coordinating with businesses to resolve errors in reconciliations.
• Following up with concerned parties in case feeds do not arrive on time.
• Ad hoc report generation for users.
• Resolving business issues on other day-to-day activities on a need basis.
• Managing access of the users to the Reports and Application.
• Issue handling, issue escalation, follow-up with concerned teams, adhering to the SLA, and generation of reports to interact with client for their requirements.
• Investigation of issues raised by business users and proposed effective solutions, which include the introduction of new enrichment, customization in matching criteria, grouping, addition of logics, import format changes, and manual running of reconciliation.
• Conducted regular reconciliation data analysis to identify discrepancies, investigate root causes, and proactively implement corrective rules and functions.
• Customization and extraction of financial reports using the Crystal Reports application.
• Proficient use of SQL Server, Microsoft Excel, and Notepad++ for data analysis.
• Demonstrated strong problem-solving skills and technical expertise to deliver high-quality solutions.
• Handled incidents and service requests through ServiceNow, ensuring efficient problem resolution and continuous service improvement.

During my six-month internship at Tata Motors Electric Mobility, I worked on a project aimed at improving TCF Underbody Line efficiency by reducing downtime and enhancing AGV (Automated Guided Vehicle) design. My role involved analyzing downtime data, cleaning large datasets, and identifying bottlenecks. Using statistical methods and data visualization tools, I pinpointed recurring issues and proposed design improvements for AGVs that increased productivity.

This experience honed my data analysis and problem-solving skills, allowing me to provide actionable insights that optimized production efficiency and supported the company's operational goals.

During my six-month internship at Siemens, I contributed to the 'Zero Defect Station (ZDS)' project, aimed at reducing defects in high-voltage switchgear manufacturing. My role involved analyzing production data using tools like SQL and Excel to identify defect trends and root causes. I developed automated reporting systems to track quality metrics in real time, driving data-driven improvements that enhanced product quality and efficiency.

Additionally, I gained exposure to emerging technologies in gas-insulated switchgear (GIS) and systems integration. This experience sharpened my ability to analyze large datasets, design reporting tools, and apply IT-driven solutions to optimize processes in a technical environment.