Summary
Overview
Work History
Education
Skills
PROFESSIONAL SUMMARY
PROJECTS SUMMARY
Certification
Timeline
Generic

Sreeja Jadav

Hyderabad

Summary

Experienced Power Bi Developer with 4+ years of experience in creating programs based on specific requirements. To succeed in an environment of growth and excellence and earn a job which provide me job satisfaction and self-development and help me achieve personal as well as organizational goals.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Power BI Developer

CES Limited
05.2022 - Current

Power BI developer

Cummins
06.2019 - 04.2022

Education

B.E -

University college of Engineering, Osmania University, Hyderabad
01.2017

Skills

    Operating Systems : Windows, Unix

    Database : SQL Server, Azure DataBricks,Impala , Oracle, SSAS Tabular/Cubes

    Reporting Tool : Microsoft Power BI, SSRS, Advanced Excel

    Other Tools/Software: SQL Server Management Studio, Azure Data Factory, Power Apps

    Languages : SQL, MDX, DAX, Python Basics,C, Hive Query Language

PROFESSIONAL SUMMARY

  • Having 4+ years of experience in Business Intelligence Tools Power BI, SSIS, SQL Server, Excel.
  • Experience to use Standard visualizations like Slicer card and Stacked Column Chart, Clustered column chart, Line and maps.
  • Comfortable in working with filters, calculated columns, measures and transformations of Edit query section.
  • Worked custom visualizations like hierarchy slicer, Word Cloud, Histogram, Dual KPI, Bullet Chart.
  • Worked on Formatting, Advanced Formatting in tooltip labels like descriptive tooltips, and conditional formatting.
  • Hands on experience on writing Data Analysis Expressions (DAX), using Time Intelligence functions, Informative functions, Filter functions etc.
  • Published/shared the reports by creating a Content packs in app.powerbi.com/sharing the pbix file.
  • Worked on DAX Functions to create Calculated Column and Calculated Measures.
  • Good experience in SSIS to create Control flow and Data flow tasks.
  • Used Control Flow Tasks like Execute SQL Task, For Loop Container, For Each Loop Container, Sequential Container and Send Mail Task in Designing packages.
  • Experience in managing SSIS packages execution and deploying packages to the servers.
  • Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
  • Well versed in Normalization/De normalization techniques for optimum performance in relational and dimensional database environments.
  • Experience in creating T-SQL Procedures, Functions and Indexes based on business requirements.
  • Having good experience on creation and scheduling of SQL server agent jobs.
  • Hands on experience with SQL Server in constructing Tables, Stored Procedures, UDF's, Views, Indexes.
  • Good Communication and Presentation skills, strong Analytical and Problem-Solving skills.
  • Strong believer in teamwork, with an ability to rapidly achieve organizational integration.
  • Energetic and self-motivated team player
  • Good knowledge in Data Warehousing Concepts.

PROJECTS SUMMARY

PROJECT 1 :

Title : EZCorp
Role : Power BI developer
Environment : Power BI, SSRS, SQL
Client : EZCorp, Inc
Duration : November 2022 - present
Description : EZCORP, Inc. is an American pawn shop operator based in Austin, Texas which provides services across the United States and Latin America.  It is a publicly traded company listed on the NASDAQ stock exchange and is the second largest pawn shop operator in the U.S. after Cash America International.The company also sells merchandise, primarily collateral forfeited from pawn lending operations and pre-owned merchandise purchased from customers. It offers pawn loans, which are non-recourse loans collateralize by tangible personal property, including jewelry, consumer electronics, tools, sporting goods, and musical instruments.


Responsibilities :· 

  • Gathered and documented business requirements for analytical reports, participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
  • Requirement analysis, planning the estimates, customer interaction for requirement clarifications.
  • Prepare technical report requirements, perform analysis and elicitation of DB inter-relations to generate required analytical reports, profiling reports, perform testing activities and drive the implementation to closure.
  • Prepare development estimates for the work at hand. Constantly track for work to be on schedule.
  • Developed analytical and interactive reports, KPIs based on business requirements.
  • Enhancing Performance of the SQL tables creating Indexes, removing Complex joins and writing queries.
  • Developed Complex MDX queries, SQL queries using functions, views, Joins to support Power BI reports.
  • Developed Custom calculated measures using DAX in Power BI to satisfy business needs.
  • Performance tuning to reduce redundancy and achieve maximum system performance.
  • Restructured the logics, optimized the data model for slow performing Power BI reports to bring down the report rendering time from >20 minutes to 15seconds.
  • Worked on all phases of software development life cycle from gathering requirements, implementation, testing, training, and support.
  • Giving application demos to customers and other team members at every sprint end.
  • Developed Custom reports and deployed them on server using Power BI.
  • Provided Continued maintenance and development of bug fixes for the existing and new Power BI reports.



PROJECT 2 :


Title : SSOE
Role : Power BI developer
Environment : Power BI, SQL
Client : SSOE Group
Duration : June 2022- October 2022
Description : SSOE is an internationally ranked architecture and engineering firm. SSOE provides engineering, design, and construction services to the semiconductor industry. Their leadership in the areas of Lean Construction, Virtual Design and Construction, and Integrated Project Delivery minimizes waste, maximizes value, reduces construction costs, and compresses schedules.
Responsibilities :

  • Gathered and documented business requirements for analytical reports, participated in requirements meetings and data mapping sessions to understand business needs. Identified and documented detailed business rules.
  • Involved in creating complex measures including ranking, KPIs, aggregation by DAX according to business requirements.
  • Knowledge of Data Modeling, familiar with snowflake schema and star-schema.
  • Published Power BI Reports in the required originations and Made Power BI Dashboards available on Web clients.
  • Developed analysis reports and visualization using DAX functions like table function, aggregation functions.
  • Hands on experience in gathering requirements, design, analysis, unit testing, UAT, performance optimization, implementation, and support.
  • Enabled the automation of reports sharing to users on monthly basis using Power Automate.
  • Created Workspace and content packs for business users to view the developed reports and scheduled automatic refresh and scheduling refresh in power bi service.
  • Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques.



PROJECT 3

Title : Dashboard Implementation for production metrics. 

Role : Power BI Developer 

Environment : SQL Server 2012, SSIS, Power BI 

Client : Cummins India Limited

Duration : August 2019 – March 2022 

Description: Cummins is a leading manufacturer of diesel and natural gas engines, generator sets, and related components and technologies. The company has a strong presence in the Indian market, Providing innovative solutions for various sectors including automotive, industrial, power generation, and marine. In this project we are getting the data from the Clients, using DTS Packages we are pulling the data from source system to sql server staging area and from staging area to data mart. 

Responsibilities

  • Understanding and analyzing the business requirements.
  • Connect to Different Data sources from Power BI.
  • Used Table, Matrix, Bar, Card and Slicer Visualizations.
  • Developed user interactive Reports as per client business needs.
  • Responsible to Schedule the dashboards according to frequently (Daily, Weekly).
  • Supporting the dashboards and also enhancing the reports based on the client's requirement.
  • Responsible import the data from SQL Server and build a Dashboards as per Client requirement.
  • Transforming the staging data by applying various transformations like Derived Column, Conditional Split, Multicast, Lookup, Union all and Execute SQL Task.
  • Troubleshooting of defects, perform root cause analysis and taking the defects for closure
  • Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
  • Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Involved in Power BI Maintaining, Monitoring Datasets, Performance tuning for reports/dashboards and control capacities in Power BI Service Experience on publishing Power BI reports on dashboards in Power BI server.
  • Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.

Certification

· Microsoft Certified Power BI Data Analyst Associate – PL-300

· Microsoft Certified Azure Fundamentals AZ-900

Timeline

Power BI Developer

CES Limited
05.2022 - Current

Power BI developer

Cummins
06.2019 - 04.2022

B.E -

University college of Engineering, Osmania University, Hyderabad
Sreeja Jadav