Projects: 1. Sales analysis for Buyers and Publishers Report. Environment: Power BI. Description: ● My client in Israel desired useful insights for their sales data, specifically for Buyers and Publishers. ● The buyer's report displays revenue, impressions, and CPM for various Buyers over various time periods. ● It also displays some useful insights such as top buyers and their publishers, revenue, impression, and CPM comparisons across time periods, publisher revenue, and so on. ● Publisher report provides detailed information for publishers such as new publishers, publishers with significant increases in impressions, different networks on which publishers work, % change in inventory, impressions, and fill rate over various time periods, specifically daily and weekly. Responsibilities: ● Requirement gathering and analyzing from client. ● Develop accurate and proper solution. ● Testing of the solution. ● Delivering the perfect product. ● Regularly update the client about work progress. 2. Shipments Report. Environment: Power BI, Power Apps, Power Automate, MS SQL Server, and SharePoint Online List. Description: ● My US-based client is a recognized Home Décor expert and a world leader in their field. ● In the United States, they offer their services to customers through their own branded websites as well as toll-free call centres. Problem: ● The client receives the excel sheet from the back-office team on daily basis via email containing the active orders they got via call or any walk-in customers. Another data was stored in MS SQL Server regarding the Orders they received via the web site. ● Now sometime, clients need to modify the data they received via email just to remove human errors or update the status of the order. Also, he needs to visualize the combined data from Excel and MS SQL Server in an automated way. The Solution: Here, the organization handed us the charge of painting the picture as the picture paints a thousand words if it is done by a skilled artist. Hence, here we tried to decipher the data and tried to come up with the ideas that will be helpful to the organization: ● Created a Power Automate flow that will read the email and process the excel sheet received as an attachment and store the records of the excel file in the SharePoint Online List on regular basis. ● Once we, got the data in SharePoint List, we created a Power Apps (Canvas App) on the SharePoint List by which they can modify the data as needed. ● At last, we have created a Power BI report based on this SharePoint list and the SQL Server Data and provided some useful insights as below: - Total Active Purchase Orders. - Late Departures. - Late Arrivals. - This Week Departures. - This Week Arrivals. - Total Customers. - Total Vendors. - Anomalies in the data (as we are combining data from different sources). - Purchase Orders by Arrival Status. - Purchase Orders by Departure Status. - ETA and ETD of different orders. - Shipment status. 3. CR ACS Dashboard. Environment: Power Apps, Power BI, Power Automate, SharePoint Online List. Description: ● My US-based client is a recognized wireless connectivity expert and world leader in providing 5G services beyond end users’ expectations. ● n the US, they provide their 5G wireless services to the customers so that they can seamlessly be connected to what they love. ● They cover the most interstate highway miles with 5G. ● Their commitment reaches beyond wireless. Problem: ● The client was in need of some way by which their engineers can enter data on some common portal and then they can use this data to generate a useful insight by which it can help them in taking informed and right decisions time being. ● Once the details is captured then they wanted to send an email to some reviewers and ask them to review the details filled by engineers. The Solution: ● Created a Power Apps (Canvas App) on SharePoint Online List so that engineers can enter the data as needed. Power App was having so many cool features like an editable grid as they needed it based on the data, they enter through the canvas app. ● We have prepared a Power Automate flow to send an email to the Reviewers with the attachments they have selected while filling the data through the canvas app. ● Once the data is filled engineer can send an email from Canvas App itself to the Reviewers to review the details they have filled. ● Now, we have created a Power BI report based on the SharePoint List to visualize the data so that they can take informed decisions for their business. ● Some of the insights are as below: - On Air by Market. - On Air by Location. - Total Active Projects. - On Air by Region. - Comparisons between different Milestones. - Projects in the pipeline. - Average time to achieve each milestone. - Weekly Updates of each milestone. - Potential Action Items. - Weekly Required Run Rate to get the Project On-Air. - Progress on how many projects got On-Air across the different time periods.

● My responsibilities were managing different teams (as both technically and non-technically) of different sizes and nature and get projects executed, conducting interviews for new candidates, mentoring new joiners. ● Handled and worked on many projects of Power BI, SSIS, SSRS, Azure Data Factory, Power Apps and Power Automate during this period. Project:Hearing Aid Centers (04/2021 - 04/2022). ● This project was mainly tabular representation project but, it was involving so many complex calculations and requirements. ● The main challenge in this project was their dirty data storage techniques. ● So, I have transformed data as per the best practices either in MySQL Views or in Power BI and created insightful dashboards for them which are helpful in taking informed decisions to them.

● My responsibilities were generating the usefull and visually apealing Power BI reports, client communication, requirement gathering and provide estimation of the project duration, integrating data from various datasources in the data warehouse using SSIS and building SSRS reports. Projects: 1. Donation Analytics (01/2019 - 06/2019). ● Donation Analytics is a report which will get csv files from ftp server using SSIS. ● This file will be imported in SSAS and perform tabular modelling over there. ● This SSAS modelling will be used as a source in power bi report. 2. COVID-19 Outbreak Analysis. Environment: Power BI. Description: ● Built these reports to support the world to get genuine details about world Problem: ● The year 2020 started on a bitter note as COVID-19 (Novel Coronavirus) outbreak started from Wuhan, China slowly spread across the world. ● With no vaccination and cure available for the virus, the victims entirely relied on their immune system, causing more than 8000 deaths in the first three months of the outbreak. ● Thus, we decided to put all the numbers and stats available across various sources and create a report which not only summarizes all the fact data into a well-arranged dashboard, increasing the understandability and value of the data, but also provides all the latest news about the outbreak from major sources around the globe, and spreads awareness. The Solution: ● We put together and integrated multiple web resources and APIs available which provide tabular data regarding the issue. ● To make sure that the end-user easily understands the message we are trying to convey through this dashboard, we narrowed it down to a set of data sources and APIs we will be using for this report. ● An appealing yet neat dashboard was then produced providing various statistical analyses about the impact of COVID-19 on various countries. Responsibilities: ● Requirement gathering and analysis. ● Provide proper estimation of work. ● Assign tasks to the team. ● Develop accurate and proper solution. ● Testing of the solution. ● Regularly update the senior about work progress. ● Deploy the report on Power BI Service.

Projects: 1. Sales Analysis. Environment: Power BI. Description: ● A sales analysis report shows the trends that occur in a company's sales volume over time. ● In its most basic form, a sales analysis report shows whether sales are increasing or decreasing. ● At any time during the fiscal year, sales managers may analyze the trends in the report to determine the best course of action. ● Managers often use sales analysis reports to identify market opportunities and areas where they could increase volume. The Solution: ● Information about profits and sales by Product and Customers. ● Sales of Products and Countries by their Sales. ● Sales and Profit by Country. ● Sales and Profit by different entities such as Segment and Products. ● Sales by New Customers & Old Customers. ● Sales by Category & Subcategory of the products. Responsibilities: ● Produce clean, efficient code based on specifications. ● Verify and deploy the program. ● Troubleshoot, debug and upgrade existing software. ● Create technical documentation for reference and reporting. 2. Traveller’s Guide. Environment: SQL Server, SSIS. Description: ● My US-based client is a recognized hotel expert and world leader in providing lodging reservation services. In the US, they provide its services to travelers through its own branded Web site as well as toll-free call centers. Sub Projects: ● DB Service (DTS, Jobs, Store Procedures). ● Reporting Central Project RCP (SSRS). ● Conversion of DTS to SSIS. ● Enhancing existing database for Business prospects. Responsibilities: ● Development of SSIS packages and SQL scripts. ● Preparation of Technical, functional and Unit test case documents. ● Executing Unit test cases. ● UAT and build promotion support activities. 3. Recruitment Facts. Environment: Power BI. Description: ● For the recruitment conducting industry. The Problem: ● Recruitment is the process of finding and attracting potential resources for filling up vacant positions in an organization. ● It sources the candidates with the abilities and attitudes, which are required for achieving the objectives of an organization. ● An organization figured out the significance to be aware of the process and numbers related to it backward and forwards. ● Hence, the objective of the task is to get an understanding of the candidates applying for the interview of the organization. The Solution: Here, the organization handed us the charge of painting the picture as the picture paints a thousand words if it is done by a skilled artist. Hence, here we tried to decipher the data and tried to come up with the ideas that will be helpful to the organization: ● Information of the candidates that are applying/appearing/not appearing/selected/joined for the interview. ● Information about the sources that have helped the candidates to apply for an interview. ● Information about the last companies that the applied candidates were working at. ● Details of the candidates by their expertise when appearing in an interview. ● Which are the top 10 sources that candidates have found the organization? ● Which were the top 10 reasons for the candidates to leave their last company? ● Information about the hired candidates and their experience. ● Information about the scores by their quality and their experience. ● Information about the notice period by their experience. Responsibilities: ● Requirement gathering and analyzing from client. ● Driving the project by guiding the team. ● Develop accurate and proper solution. ● Testing of the solution. ● Regularly update the client about work progress.