Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sourav Kumar Pati

Bangalore

Summary

Data-Driven Business Analyst with 3.5+ years of experience in the Life Sciences & Healthcare Insurance industry. Leverages data analysis skills to identify trends and drive strategic business decisions. Proficient in SQL and Excel for data manipulation and reporting. Utilizes Power BI and Tableau to create insightful reports and dashboards. Proven ability to manage projects, collaborate effectively, and work independently. Successfully automated multiple process that boosted efficiency by 30-40%.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Business Analyst

Infosys Consulting
09.2023 - Current
  • Engineered and maintained scalable ETL pipelines using SQL & Talend, resulting in a 30% increase in data processing efficiency.
  • Designed and developed interactive, client-focused dashboards, to help a pharmaceutical giant track their cutover management, reducing critical failures & downtime by 20% across 5 projects.
  • Successfully integrated Power BI with various data sources like Power Apps, SharePoint, SQL Database and exhibited proficiency in leveraging Power Query for advanced data transformations in datasets with 1 million records.
  • Integrated & Automated Service Now with Power BI using Power Automate to remove the manual process involved in data refresh scheduling which saved 4 hours on a daily basis.
  • Created 10-12 compelling and collaborative dashboards using advanced visualization techniques to effectively communicate complex information, demonstrating strong ability to translate data insights into actionable visual narratives which elevated storytelling by about 70%.
  • Optimized Power BI reports for performance to enhance report responsiveness and scalability using DAX & calculation groups.
  • Implemented RLS by restricting users to access all the available data.
  • As PMO specialist, led the implementation of a database system for a healthcare insurance, aim was to consolidate and create a central repository of all reference data for the enterprise.
  • Coordinated & collaborated with Onsite Clients, Senior Directors and Top Management of multiple projects bridging gap between their requirements and actual deliverables, resulting in a 15% increase in operational efficiency.
  • Acted as a Scrum Master & monitored project progress by tracking activity, resolving problems, recommending actions, conducted training & doubt sessions for client using JIRA & ALM.
  • Gathered and documented business requirements, translating them into technical specifications for development teams & clients saving 9 hours of onboarding time.

Test Engineering Analyst

Accenture
08.2019 - 06.2022
  • Worked with a Healthcare Insurance where I managed & optimized a mainframe DB2 database using SQL and Excel Macros which improved query performance by 40%.
  • Spearheaded end-to-end automation from scratch which eased data extraction, comparison & report validation increasing work efficiency by 2x & reducing data inconsistencies by 25%.
  • Lead project as a solo resource for 13+ months during covid recession and delivered 6 successful releases.
  • Developed and executed comprehensive test plans, test cases, test scripts, UAT & BAT for 10+ projects, improving software quality and reducing defect rates by 30%.
  • Mentored and led a team of 7 members responsible for development, design, implementation and operating DB2 database while being migrated to AWS Cloud.

Education

MBA - Marketing

Great Lakes Institute Of Management
Chennai
06.2023

Bachelor Of Technology - Computer Science And Engineering

Veer Surendra Sai University Of Technology
Odisha
05.2019

Skills

  • SQL Power BI DAX Tableau Power Query Power Automate Jira ALM Confluence Service Now Excel Macros
  • Problem Solving Critical Thinking Requirement Gathering Team Management Data Analysis User Acceptance Testing Stakeholder Management Gap analysis Data Mining Database Management Data Governance Project Management

Certification

Microsoft Certified: Power BI Data Analyst Associate

AWS Certified Cloud Practitioner

Google Data Analytics Certificate

Microsoft Office Specialist: Associate

Tableau for Data Science

Timeline

Business Analyst

Infosys Consulting
09.2023 - Current

Test Engineering Analyst

Accenture
08.2019 - 06.2022

MBA - Marketing

Great Lakes Institute Of Management

Bachelor Of Technology - Computer Science And Engineering

Veer Surendra Sai University Of Technology

Similar Profiles

CREATE PROFILE
Sourav Kumar Pati