Chinmay Shirsat
Dublin
Summary
Detail-oriented Data Analyst with over 3+ years of experience in the banking industry, specializing in SQL development, data visualization, performance tuning, ETL processes, and data modeling. Expertise in transforming complex datasets into actionable insights using SQL, Excel, Python, and data visualization tools such as Power BI. Proven ability to manage data mapping and headcount and position data management, ensuring database systems receive regular updates and ad-hoc reporting. Skilled in drafting business requirements, analyzing complex issues, and creating user stories with precise acceptance criteria to support informed decision-making.
Overview
4
4
years of professional experience
Work History
Software Engineer (SQL Developer)
Wipro Ltd
05.2021 - 08.2023
- Handled Banking financial data, improving data accuracy and anomaly detection by 35% through optimized SQL queries.
- Designed and implemented data to load and transform data from multiple sources into Power BI, ensuring high data quality and report consistency.
- Streamlined campaign operations by extracting data for both manual and automated campaigns across multiple banking products, improving targeting efficiency by 30%.
- Created and maintained data models using Power BI and Excels Power Pivot, ensuring scalable, modular reports for multiple departments.
- Improved reporting accuracy by 40% through a combination of SQL-based ETL pipelines and Excel data validation techniques.
- Configured and customized Jira workflows, dashboards, and issue types to support project tracking and reporting, enabling stakeholders to monitor KPIs and project progress effectively.
- Partnered with business teams to deliver insights aligned with compliance and risk requirements.
Application Support Engineer
CMS IT Services
12.2019 - 05.2021
- Gained over 1 year of experience as an Application Support Engineer, contributing to system stability and operational efficiency.
- Managed SQL databases by performing batch operations and job monitoring, improving process reliability by 25%.
- Automated routine database tasks and tracked issues, reducing manual workload and incident resolution time by 30%.
- Ensured 99.9% database uptime by continuously monitoring and optimizing performance and availability.
- Improved troubleshooting efficiency by documenting system changes and issue resolutions, enhancing knowledge transfer by 40%.
- Utilized SQL, IBM tools, Pentaho, and Linux environments to support application functionality and backend.
Education
Master's - Data Analytics
Dublin Business School
09.2024
Skills
- Languages: Python, SQL (MySQL, Server, PostgreSQL, Vertica)
- Tools: MS Excel, Tableau, Power BI, SQL Server Management Studio, Jira
- Python Libraries: NumPy, Pandas
- Data Analysis Skills: Data Analysis, Data Mining, Data Visualization, KPIs Development, Predictive Analytics, ETL
Timeline
Software Engineer (SQL Developer)
Wipro Ltd
05.2021 - 08.2023
Application Support Engineer
CMS IT Services
12.2019 - 05.2021
Master's - Data Analytics
Dublin Business School