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.