Summary
Overview
Work History
Education
Skills
Roles And Responsibilities
Certification
Projects
Accomplishments
Interests
Timeline
Generic
Prasoon Kumar

Prasoon Kumar

Business Analyst
Bangalore

Summary

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

9
9
years of professional experience
5
5
Certifications
2
2
Languages

Work History

BI Engineering Senior Analyst

Accenture
08.2021 - Current
  • Leading UI development activity including Wireframe designing, getting business requirement from clients, dashboard designing, development, testing and releasing to end users.
  • Collaborated with stakeholders to identify Problem statement & business needs and suggest Metrics which generates relative Insights.
  • Performed requirement gathering, analysis, documentation, testing, implementation, and user support for platform transitions.
  • Provided technical support for troubleshooting analytics and reporting issues and recommend corrective actions.

Consultant

Deloitte
08.2019 - 08.2021
  • Enhanced & optimized existing reports to improve user experience and performance.
  • Utilized Alteryx for conducting high-volume data reconciliations and executing validations.
  • Developed automated peer review process using VBA Macros.
  • Quick turnaround on client queries & feedback were analyzed and implemented.

Technology Analyst

Infosys
10.2015 - 08.2019
  • Interacting with business users and business analyst to know requirements and providing several mockups to create finalized reports.
  • Designing, developing dashboards, and presenting it to business users and cross-functional teams.
  • Proactively Identifying issue by creating Adhoc dashboard which triggers email in case data is missed or not reconciled.

Education

Bachelor of Engineering -

NMAM Institute of Technology
Udupi, India
04.2001 -

Intermediate (CBSE) -

Jesus & Mary Academy
Darbhanga, India
04.2001 -

Matriculation (CBSE) -

Jesus & Mary Academy
Darbhanga, India
04.2001 -

Skills

Power BI

undefined

Roles And Responsibilities

  • Worked with multiple data sources integration, data transformation and used business intelligence reporting tools to create KPI’s and visuals to improve organization profitability measures and comparative financial analysis..
  • Involved in collecting, cleaning, analyzing, and visualizing data to improve specific business functions.
  • Collaborating with the techno-functional lead to create a technical design document for the solution.
  • Creating mock-ups showing the intended functionality, visual aspects of the dashboards to be developed
  • Working closely with client business technical team and liaising with development and quality assurance team to maintain deliverable quality with timely deployment.
  • Implemented solution for Composite model using data flows (ADLS) to handle large dataset refreshes.
  • Helped internal audit team on various analytics test case execution using Alteryx tool.
  • Provided Power BI training across team & deployed them to live project.
  • Managing resource utilization & allocation.
  • Implemented role-based solution for RFA where access is to be controlled via 3 dimensions into single dashboard.

Certification

Accenture - Star of the Business Award Q2 & Q3 2023

Projects

Accenture (Aug-21 to Present)

Retail Client : Developed Demand Forecaster Performance dashboard -Manager/Analyst view in SiSense using the Redshift DB as source. Have utilized Elasticube and used BLOX to generate custom visuals/charts.

Healthcare Client :

  • Flux Commentary : Developed a solution for row level commentary in Power BI using PowerApps & PowerAutomate which gives end user flexibility to write back/store comments at row level and fetch it.
  • Balance Sheet Analyzer: Created a dynamic dashboard which displays rolling 10 months balances basis period selection, This dashboard features Simulations where user can enter various threshold and get the desired output.
  • Controllers Cockpit: Developed this app in Power BI which helps accountants, and financial professionals with a comprehensive view of financial data, performance metrics that help managing and controlling financial operations.

Consumer Goods Client: Created a Balance Sheet Analyzer Dashboard which provides insight on Financial health assessment, Trend analysis, Efficiency and asset utilization, Risk management & decision making.

MD&I Internal: As part of firm Market Development & Initiatives I have migrated existing Tableau dashboards like Spend Optimizer, PEC, BSA on to Power BI Desktop & Mobile devices which can be rolled on to various clients. Implemented RBAC for Recruitment Funnel Dashboard.


Deloitte (Aug'19-Aug'21)

Consumer Goods: Designed & developed the dashboard in Power BI for Chief Information Security Officer (CISO) to monitor/ remediate the vulnerability in cyber security domain.

Breweries Client: Worked on the existing Qlikview dashboard performance optimization. The queries were simplified for better refresh time & improving overall performance.

E-Commerce: Helped this client to identifying the duplicate license invoices and established a system to alert incase they receive duplicate Trading, FSSAI license.


Infosys Limited (Oct'15-Aug'19)

Insurance Client : Supported enhancement of Expense dashboard & Income statements, cash flow statements, Created HR Analytics dashboard in Power BI for this client.

Manufacturer Client : Involved in End to End Support operation of the Global Customer Platform which contains Customer & Transaction information's. I was involved in DB script run, housekeeping of older files, debugging incase any issue raised.

Accomplishments

  • Supervised & Managing allocations of the smaller team.
  • Managed client where budget & timelines were constrain and handed deliverables ahead of schedule.
  • Developed workflow status monitoring dashboard using Power BI, resulting in a 30% decrease in run support activity.
  • Have done R&D on the aspect where some requirement were not feasible within the tool and was implemented. i.e. Row level commentary.

Interests

Travel, Yoga

Timeline

Accenture - Star of the Business Award Q2 & Q3 2023

08-2023

BI Engineering Senior Analyst

Accenture
08.2021 - Current

Alteryx Designer Core Certified

05-2021

Deloitte – Dot of Fame Award for providing actionable insights to clients.

08-2020

Consultant

Deloitte
08.2019 - 08.2021

Steller contribution to Fossil Service Delivery Excellence 2017 (Client Award)

05-2018

Insta Award for Fossil GCP application Support during peak period 2016.

10-2016

Technology Analyst

Infosys
10.2015 - 08.2019

Bachelor of Engineering -

NMAM Institute of Technology
04.2001 -

Intermediate (CBSE) -

Jesus & Mary Academy
04.2001 -

Matriculation (CBSE) -

Jesus & Mary Academy
04.2001 -
Prasoon KumarBusiness Analyst