Handling End to End Power BI Projects.

• Power BI Report: I have to make the changes in the power bi reports as per the client requirement as well as internal team requirement.• SQL: I have to migrate MySQL query to PostgreSQL and apply the changes in the existing power bi report. • Report Automation: Collect the report requirement from the client and get the same done in the provided timeline using VBA.

Power BI Project: -1. Payment Success Rate: This dashboard includes the below insights of the payments. • Overall Success Rate, Gateway Wise Success Rate, Payment Mode Wise Success rate, BU Wise Success Rate• Total Sales Value, Total No of Payments, Sales trends, 2. Cost Analysis: This report basically required by the finance team to do costs analysis.• Overall cost, quarterly cost, gateway wise cost, Payment mode wise cost.• BU wise cost, Sales value vs cost amount trends.3. Sales Analysis: This report was to Analyze sales insights. I have included below insights.• Total Sales, Gateway Wise Sales, Product Wise Sales, Payment mode wise sales,• Month wise sales trends, BU Wise Sales, Plan Wise Sales Report.VBA Report Automation: -1. ARN Report: Automated ARN report using VBA. We just need to click on single button and report automatically send to difference insurer with excel sheet attachment.2. Hold Payment Report: In this report we have download hold data from the company’s panel and run the report, this report sends all hold cases file to each BU on the company.3. Double Deduction Report: User just download previous day sales data and run the report. This report extracts the duplicate cases basis on the decided criteria and then share with the respective team to validate and inform to the customer.Excel Reports: -1. Handled Reconciliation: Validate all clients’ payment are executed and reconciled.  Perform analysis to ensure all accounts are reconciling on daily basis. Provide resolution to reconciliation of discrepancies and issues, escalating as necessary.2. Refund Report Reconciliation: Prepare refund report daily basis and share with the concern department. Processing of refunds to customer using various payment gateway (online refunds).3. Invoicing Reconciliation: We have to check at transaction level all MDR charges are correct, if we found charges mismatch, raise the same to PG to get credit note for the same,

• Analysis of sales data and identify area of improvement• Lead Report Analysis.• Agents Productivity Report.• Predication report for sale• Proficiency with MS office tools. Excellent command on pivot, Macro, V-look up, Data Handling up and excel formulas• Extensive usage of MS Excel (Aggregate function, V-Lookup, H-Lookup, Pivot table, Macros MIS reporting by using MS Excel)• Generate timely and accurate reports for analysis. Creating MIS/ Dashboard Implement and analysis data to create daily, weekly, monthly, and quarterly reports

• Preparing Sales Report (Industry Wise, Marketing Person Wise, Location Wise) on Daily, Weekly & Monthly.• Analysis of sales data and identify area of improvement.• Preparing Enquiry V/s Orders Report Weekly & Monthly.• Preparing Attendance Report Weekly & Monthly.• Preparing Productivity Report Daily, Weekly & Monthly.• Preparing reports of delayed orders in dispatching.• Extracting the orders which need to be dispatched on daily bases.• Maintaining the inventory & reporting to MD. • Preparing sales funnel report on Weekly bases.