Summary
Overview
Work History
Education
Skills
PROFESSIONAL SUMMARY
Languages
Disclaimer
Timeline
Generic

Sriram

Chennai

Summary

Power BI and Microsoft Business Intelligence (MSBI) Developer with 3+ year of professional experience. Delivering high-impact visualization that drive business efficiency and informed decision making. I am looking an opportunity to establish a rewarding career, applying my expertise inventively to streamline process. Seeking a collaborative environment to further leverage my skills and expertise, driving innovation and growth.

Overview

3
3
years of professional experience

Work History

Data Analyst-Power BI Developer

Wipro Technologies
09.2023 - Current

Domain - Banking

Client - Citi Bank

Environment - POWER BI and SQL SERVER

  • Along with Financial Advisor understand proper requirement gathering & project KPIs
  • I created the Business Requirements Document (BRD) along with my BA
  • Created Monthly/Quarter/Yearly Report and Banking Dashboard
  • Involved in Data cleaning and Data preparation using POWER QUERY EDITOR
  • Build Pages with slicer for Quick filter and generate report-level filters while handling vast volumes of data
  • Creating different visualization using Bar, lines, Pies, Map, Highlight tables and metrics
  • Utilize Power BI to build interactive and visually appealing dashboards and reports
  • Identify the requirements and develop custom charts accordingly
  • Optimize SQL queries for improved performance and results
  • Write DAX queries to create measures for advanced calculations.

Process Associate-System Engineer

Wipro Technologies
07.2021 - 08.2023
  • Along with the BA, understand the proper requirement gathering process and the project KPIs
  • I created the Business Requirements Document (BRD) along with my BA
  • Generated monthly, quarterly, and yearly reports and a sales dashboard
  • Involved in data cleaning and Data preparation using Power Query Editor
  • Built pages with slicers for quick filtering and Created report-level filters while handling vast volumes of data
  • Creating different visualization using Bar, lines, Pies, Map, Highlight tables and metrics
  • Utilize Power BI to build interactive and visually appealing dashboards and reports
  • Identify the requirements and develop custom charts accordingly
  • Optimize SQL queries for improved performance and result
  • Write DAX queries to create measures for advanced calculations.

Education

B.A Economics -

DG Vaishnav College Arumbakkam, Madras University
01.2019

Skills

  • Power BI Desktop
  • Power Query Editor
  • Power BI Services
  • Data Visualization
  • DAX Calculation
  • Dashboard Design
  • Data Modeling
  • Report Development
  • MS SQL
  • Tableau Desktop
  • Advance Excel
  • MS Office Suite
  • SQL Queries

PROFESSIONAL SUMMARY

  • 3 years of experience Software development in the Power BI and Microsoft Business Intelligence (MSBI)
  • Experience in developing SSAS (Tabular Model) and Power BI Reports using different DAX queries, visuals, filters, and configuring Dashboards with drill down Capabilities.
  • Working knowledge on Power BI objects like Dashboards, Reports, Power Views, Creating Workspaces, Sharing dashboards
  • Hands on experience in MS SQL Server Database.
  • Proficient in SQL Queries related to Power BI, including joins, subqueries and functions
  • Design and maintained data models with efficient relationships using various joins
  • Experience in Extract, Transform & Load (ETL) development using SQL, Service Integration Services (SSIS), Power BI and SSRS
  • Experience in using SSIS tools like Import Export Wizard and SSIS Package Designer
  • Worked on Transformations like conditional split, derived column, Data Conversion, Lookup, Merge Join, Union All and Multicast
  • Experience in using Variables, Expressions and Functions for the Reports with experience in handling Sub-reports in Power BI
  • Having Knowledge in Extracting the Data from various Data Source into Power BI Desktop and Transforming Data and to generate Reports and Dashboards
  • Creating new categorical variable with value. Provide the percentage of complaints resolved and unresolved. Through Bar Chart, Pie Chart, Line Chart and Point Chart.
  • Knowledge of Tableau for creating different charts, graphs, maps, dashboards, and stories for visualizing and analyzing data, to help in making business decisions
  • Experience in all phases of SDLC such as Design, Development, Testing, Defect Management and Deployment.
  • Worked with testing team to create test cases for unit, link and system testing.
  • Expertise in working in challenging environments with restricted timelines.

Languages

  • Tamil
  • English

Disclaimer

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Signature: 

Sriram P

Chennai, India

Timeline

Data Analyst-Power BI Developer

Wipro Technologies
09.2023 - Current

Process Associate-System Engineer

Wipro Technologies
07.2021 - 08.2023

B.A Economics -

DG Vaishnav College Arumbakkam, Madras University
Sriram