Data Analyst Power Bi
Resume:
RESUME
Swarup Kumar Mall
*******.***@*****.***
LinkedIn: www.linkedin.com/in/mallswarupkumar
CAREER OBJECTIVE:
To leverage my technical and analytical skills in a dynamic organization to drive data-driven decisions and optimize business processes.
PROFILE SUMMARY:
Experienced Data Analyst with 7.6 years in production support, data analysis, and process automation.
Expertise in UNIX commands and Shell Scripting, with hands-on experience in Python, Tableau, and Snowflake.
Proficient in monitoring long-running SQL queries and resolving critical production issues within SLAs.
Strong analytical and problem-solving skills, with a focus on delivering high-quality solutions to meet client expectations.
Skilled in designing and maintaining dashboards for actionable insights, enhancing data- driven decision-making.
TECHNICAL SKILLS:
Programming Languages: Python, Shell Scripting
Tools & Platforms: Tableau, Power BI, JIRA, Snowflake, MySQL
Operating Systems: UNIX
Other Skills: MS Excel, PowerShell
EMPLOYMENT DETAILS:
ICE MT INDIA PRIVATE LIMITED, Pune
Data Analyst
January 2017 – June 2024
ACADEMIC DETAILS:
Bachelor of Technology in Information Technology, Centurion University of Technology, Bhubaneswar, 2012
PROJECTS HANDLED:
Project Name: Elliemae AIQ (DocVelocity)
Team: Loan Migration Team
Duration: January 2017 to June 2024
Client: LoanCare, US Bank, Fay Servicing, LoanDepot, United Shore Technologies: UNIX, MS Excel, Power BI, Shell Scripting, Tableau, MySQL, Python, Snowflake Description: AIQ™ by ICE Mortgage Technology™ is an omnichannel solution leveraging AI to automate workflows, enhance productivity, and reduce risk. It standardizes data into a secure cloud repository and integrates with loan origination systems to streamline processes across mortgage sectors.
Key Responsibilities:
Streamlined the bulk import process, enhancing data ingestion efficiency using UNIX shell scripts and Python automation.
Designed dashboards in Power BI and Tableau, providing actionable insights on ticket analysis and system performance.
Implemented Python scripts to clean data, removing special characters, and standardizing formats for large datasets.
Created daily, weekly, and monthly reports, including billing data, client-wise trackers, and system performance metrics.
Used Snowflake for ADR accuracy reports and end-to-end data reporting.
Monitored system queues during the import process and collaborated with operations teams to optimize capacity utilization.
Coordinated with interface systems to resolve issues, maintaining SLA adherence.
Investigated logs for root cause analysis and implemented solutions to minimize recurring issues.
Managed and resolved escalated tickets while acting as a liaison between business and technical teams.
Provided training and documentation for new applications and processes.
Recommended process improvements to enhance system performance and user experience.
Participated in SWAT calls and outage management, ensuring timely resolution of critical issues.
KEY ACHIEVEMENTS:
Reduced ticket resolution time by 25% through automation and process optimization.
Designed and deployed Tableau dashboards that improved data visibility and decision- making for key stakeholders.
Automated file processing workflows using Python, saving over 10 hours per week.
Ensured 99.9% data accuracy in reports through Snowflake integration and validation scripts. PERSONAL DETAILS:
Date of Birth: 28 April 1991
Address: Phursungi, Pune
DECLARATION:
I hereby declare that all the information mentioned above is true to the best of my knowledge and belief.
Date:
Place: Pune
Swarup Kumar Mall
Contact this candidate