Arpit Sawant
Data Analytics & Engineering
Mumby
Summary
At Firstsource Solutions, have leveraged a data analytics to enhance decision-making and boost overall business performance. Having technical skillset using tools such Excel, SQL (SSMS & SSIS), Power Automate, Power BI, and project management have led to significant process enhancements. Having a knack for motivating teams, instilling confidence in their abilities, and combining technical know-how with effective leadership. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
10
10
years of professional experience
9
9
years of post-secondary education
4
4
Certifications
Work History
Assistant Manager - Ops BI
Firstsource Solutions Pvt.Ltd
Mumbai
06.2018 - Current
- Utilized data analytics to make strategic decisions and enhance business performance.
- Contributed to formulation of long-term strategies for business intelligence and data warehousing, ensuring alignment with organization's goals.
- Created data-driven insights for business intelligence to guide executive decision-making and achieve strategic objectives.
- Improved decision-making processes by designing tailored business intelligence reports and dashboards.
- Promoted client engagement with business intelligence tools by seamlessly integrating Power BI into existing workflows.
- Assessed new tools, technologies, and methodologies in business intelligence sector to remain updated with industry advancements and boost team productivity.
- Ensured availability of precise, current data for business intelligence by developing ETL processes with SSIS and SQL scripts, while also employing Microsoft Power Automate for comprehensive data management and job success notifications, thereby minimizing manual tasks.
- Minimized manual effort and time spent on report generation by automating essential business intelligence functions within Excel Dashboards and Power BI.
- Leveraged SQL Server Integration Services, SQL Server Reporting Services, and other business intelligence tools to enhance data management.
- Crafted database schemas and optimized queries, resulting in faster data retrieval and supporting business intelligence initiatives.
- Refined reporting processes to facilitate improved data-driven decision-making, thereby strengthening organization's business intelligence capabilities.
- Advanced business intelligence functions by adopting sophisticated data analytics tools and methodologies.
- Guided junior team members in best practices for business intelligence development, nurturing culture of ongoing learning and enhancement.
- Aided business intelligence projects by creating customized reports that meet specific needs of stakeholders.
Data Analyst
TeamLease Services Ltd ( Jet Privilege Pvt. Ltd )
Mumbai
09.2017 - 06.2018
- Created monthly reports leveraging advanced Excel functions and Power Query to manage extensive data storage for optimal performance.
- Enhanced decision-making capabilities through precise data analysis and visualization methods.
- Employed data visualization platforms like Power BI to effectively convey business insights.
- Detected, examined, and interpreted trends or patterns within intricate data sets.
- Worked alongside cross-functional teams to maintain data integrity and accuracy, leading to more informed decision-making.
- Oversaw large databases to guarantee timely access to essential information for key stakeholders.
- Conducted data analysis to uncover root causes of issues and proposed corrective measures.
- Crafted tailored reports that summarized and presented data in engaging visual format.
- Produced both standard and customized reports to deliver insights into business performance.
- Created ad-hoc reports to assess specific business needs.
Automation Analyst
TeamLease Services Ltd ( Star India Pvt. Ltd )
Mumbai
11.2015 - 09.2017
- Resolved issues with existing automated systems, ensuring quick solutions to reduce downtime and uphold high operational efficiency.
- Performed in-depth analysis of current workflows to pinpoint opportunities for enhancement through automation strategies.
- Guided junior team members on best practices for automation tools, promoting collaborative environment and collective knowledge sharing.
- Created tailored scripts and macros to improve capabilities of automation tools, customizing solutions to align with specific business requirements.
- Achieved cost reductions by automating manual processes, lowering labor expenses and boosting overall operational effectiveness.
- Optimized business workflows for greater efficiency by developing personalized automation solutions.
WFM RTA Analyst
Capita India Pvt. Ltd
Mumbai
07.2014 - 10.2015
- Created tailored Excel reports that equipped management with critical insights into workforce performance metrics.
- Enhanced customer satisfaction by ensuring appropriate staffing levels during peak business periods.
- Maintained compliance with labor laws and regulations through careful tracking of work hours, overtime calculations, and paid time off accruals.
- Decreased employee absenteeism by actively monitoring and managing attendance records.
- Oversaw intraday staffing modifications, swiftly adapting to fluctuations in call volume or service level demands.
- Handled overtime, shift exchanges, breaks, and paid time off requests efficiently.
- Established and modified schedules to ensure optimal coverage and service quality.
- Produced and evaluated reports to track employee engagement and attrition patterns.
Education
Master Of Computer Applications - Information Technology Project Management
PKTC College
Chakan, Pune, Maharashtra 08.2012 - 01.2017
Bachelor Of Computer Applications - Information Technology
Vidya Vikas Career College
Vikhroli (E), Mumbai 08.2009 - 07.2012
Higher Secondary Education - High School Administration
N.E.S Junior College
Bhandup (W), Mumbai 07.2008 - 03.2009
Secondary School Certificate - Middle School Education
N.E.S High School
Bhandup (W), Mumbai 06.2006 - 03.2007
Skills
Accomplishments
- Worked alongside a team of three to create the Telegraph Reporting Dashboard.
- Earned the Best Performer and Extra Miler Awards for successfully delivering multiple reporting projects with precision and efficiency.
- Received recognition from both internal and external stakeholders for the effective development of interactive reporting dashboards.
Languages
English
Advanced (C1)
Marathi
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Certification
Achieved B Grade in Industrial Software Development [In Graduation]
Interests
Learning New Technology
Driving & Long Drives
Decorations on Home Festivals
Timeline
Assistant Manager - Ops BI
Firstsource Solutions Pvt.Ltd
06.2018 - Current
Data Analyst
TeamLease Services Ltd ( Jet Privilege Pvt. Ltd )
09.2017 - 06.2018
Automation Analyst
TeamLease Services Ltd ( Star India Pvt. Ltd )
11.2015 - 09.2017
WFM RTA Analyst
Capita India Pvt. Ltd
07.2014 - 10.2015
Master Of Computer Applications - Information Technology Project Management
PKTC College
08.2012 - 01.2017
Certification course in .NET technologies (Vb.net, Asp.net, C#) [ Result A+] -
03-2012
Certification course in P.P.T (Proficiency in PC Troubleshooting) [ Result A+]
01-2012
Achieved B Grade in Industrial Software Development [In Graduation]
06-2011
Bachelor Of Computer Applications - Information Technology
Vidya Vikas Career College
08.2009 - 07.2012
Certification course in MS-CIT [Maharashtra State Certification Course in Information Technology]
06-2009
Higher Secondary Education - High School Administration
N.E.S Junior College
07.2008 - 03.2009
Secondary School Certificate - Middle School Education
N.E.S High School
06.2006 - 03.2007
Similar Profiles
Naveen Kumar DamaraNaveen Kumar Damara
Quality Control Analyst at Firstsource Solutions Pvt.LtdQuality Control Analyst at Firstsource Solutions Pvt.Ltd
Syed AdeebSyed Adeeb
Sr. Customer Support Associate at Firstsource Solutions Pvt.LtdSr. Customer Support Associate at Firstsource Solutions Pvt.Ltd
SURESH KOUKUNTLA SURESH KOUKUNTLA null
Senior CSA at Firstsource Solutions Pvt.LtdSenior CSA at Firstsource Solutions Pvt.Ltd