Praveen Kumar

Experience

1. Data Analyst

   Infosys

   Oct 2017 — Present · Hyderabad, IN

   Having around 4.5+ years of experience in IT Industry. 1.5+ years on Dot net and 3+ years on Business Intelligence tools like Power BI. Skilled in Advanced Excel, SQL and Power BI (Power BI Desktop and Power BI Service). Good at analyzing, gathering, managing and documenting the business requirements. Experience in connecting with multiple data sources like SQL Server, Oracle and Excel from Power BI to build complex Datasets. Extensively worked on performing the ETL Activities in Power Query. Good Experience in filtering the Unwanted Data in Power Query. Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, Un Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc. Extensive Experience in doing Data Modeling in Power Pivot Model. Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions. Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information. Extensively worked in Power View for Presenting the Data in Graphical Format using Different Visualizations in Power BI. Good Experience in Creating Hierarchies and Drilldown Reports. Good Experience in sorting the Data in Visualizations, Grouping and Binning the Data in Power BI. Extensive Experience in Creating APP Workspaces and adding the Members to APP Workspace

Education

• Osmania University

  Master of Business Administration - MBA