Akshay Gupta

About Akshay Gupta

Credit Risk Analyst,Financial statements, SQL, Power BI,

Experience

1. Business Analyst

   Cognizant

   Oct 2020 — Present · Bengaluru, IN

   Creating and maintaining multiple Power BI reports.• Analyze current ETL process, define and design new systems• Analyzing data and present data through reports that aid decision-making• Knowledge of parameters, appends, merge, filtering, referencing, duplicating tables and other functionalities in the query editor.• Extensive knowledge in Data analysis, Designing Interactive Dashboards/Reports and Data Modelling of Star Schema and Snow Flake Schema patterns • Writing complex DAX measures to create different metrics.• Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.• Created multiple reports like Territory wise Vendors, KPI Dashboard containing Trend Analysis, Product Demands, Brand Availability, Profitability across territories etc.• Working with gateways and scheduling the refresh and Creating reports and dashboards.• Created dashboards and interactive visuals reports using Power BI• Published reports and dashboards using Power BI• Implementing dynamic RLS.• Published the paginated reports as per requirements, on an hourly, daily, weekly, monthly, or yearly basis.• Resolution of bugs and defects identified, Root cause analysis and providing optimized solution.

Education

• Prestige Institute of Management & Research

  Master of Business Administration - MBA

  2015 — 2017

• FINOPTIONS INSTITUTE OF FINANCIAL STUDIES PRIVATE LIMITED

  Fundamental Analyst

  2017 — 2017