 Analyzing current and past financial data. Looking at current financial performance and identifying trends. Preparing reports and communicating the insights of these reports to the broader business. Providing users with month to date business performance with important KPI’s and data drill down features. Providing users with monthly trend and portfolio performance designed from risk perspective Dashboard. Providing users with on date portfolio reports and Users with as on date collections performance reports. Dashboard Development: Design, develop, and maintain interactive dashboards and reports using Power BI to provide insights for various business functions. Data Processing: Apply any necessary data transformations (e.g., filtering, renaming columns, merging tables) using Power Query. preprocess data from multiple sources for dashboard integration & analysis. Database Management: Write complex SQL queries to extract and manipulate data from relational databases (e.g., MySQL, ADS, SQL Server, Oracle, Access). Data Modelling: Develop and maintain data models that optimize performance and data quality in reports and dashboards. Collaboration: Work closely with stakeholders / business partners to understand requirements and translate them into effective reports / dashboards designs. Performance Optimization: Ensure dashboards are optimized for performance, scalability, and usability. Data Integration: Connect to various data sources such as databases, APIs and flat files for dashboard reporting. Troubleshooting: Identify, troubleshoot, and resolve data issues or performance bottlenecks in the dashboards or data pipeline. Documentation: Maintain clear and concise documentation of dashboard configurations, data flows, and codebase for future reference and compliance. Planning & Analysis: Annual budget planning and operational data analysis with each sectors every service types. 100% accuracy reports delivery within timeline.

 Maintaining Daily Data Reconciliation & Bank tracker  Daily follow ups with clients for variance from bank tracker Developing Power BI model, Complex Power query, DAX query and M language, DAX code. Power BI Publish Daily / Weekly / Monthly / Quarterly / Yearly Financial Dashboards and trade spend expense dynamic Dashboard reports and Marketwise dynamic Dashboards. Sales Marketwise Target’s creation and Power BI publication all Stores each profitable Dashboards. Used various sources to pull data into Power BI such as SQL Server. Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques Expertise in writing complex DAX functions in Power BI and Power Pivot. Development and Implementation Manage role and Row-level data security layer.  Developing and maintain the Data source (OLTP), prepare a large Dataset (OLAP Model) and Creating the Reports using Dataset, Creating Dashboards using the reports. Created dashboards in Power BI using various features of such as Custom-SQL, Multiple Tables, Blending, Extracts, Parameters, Filters, Calculations, Context Filters, Data source filters, Hierarchies, Filter Actions, Maps. Installed and configured Enterprise gateway and Personal gateway in Power bi service. Created Workspace and content packs for business users to view the developed reports. Scheduled Automatic refresh and scheduling refresh in power bi service. Creating Analytical Dashboard which shows Employee wise Goals & Pay-out reports  Reviewing & reporting of monthly Bank tracker for variance to client Working on urgent ad-hoc requests received from Client Supporting management team on a daily basis for various reports Delegate tasks and set project deadlines. Do regular performance evaluation Plan and organize team-building activities Responsible for handling the productive Dashboards & Analytics. Various Business Reports.

 Daily performing the duplication check for Customer, Vendor & Master data. Daily driving the Customer, Vendor & Master data from SAP system. Daily tracking target vs. achievement/KPIs/CPIs and maintaining performance scorecards. Preparation and Publication KPIs, Dynamic Dashboards, month/quarter Closing reports, In-depth analysis Management reports, Performance reports, various review reports and Ad-hoc reports, Sales reports for the business evaluations of fiscal year. Power BI tools Analyzing the Periodic act General Ledger related Trade Spend vs Actuals spend Cost analysis/variance analysis of help/hurt. Power BI Publish Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Worked on all types of transformations that are available in Power bi query editor. Power BI Implementation, Designing, Development, Administration and Data Integration. Managing and manipulating large datasets within Power BI Desktop and SQL Server.  Hands on in developing and designing reports and dashboards (using DAX functions).  Created dashboards in Power BI using various features of such as Custom-SQL, Multiple Tables, Blending, Extracts, Parameters, Filters, Calculations, Context Filters, Data source filters, Hierarchies, Filter Actions, Maps. Preparing daily Customer, Vendor & Material Master data MIS and Published Daily basis. Responsible for handling the product dashboards, MIS & Analytics. Various business reports. Managing backup systems to ensure no less of critical data. Organized technical support workers by delegating help requests to employee whose skill set matched issue.

 Maintaining Sales Reports & Published in Daily Basis.  Sales Target’s creation and Power BI publication all brands each profitable SKUs RLP and NIV for all Trade Channel partners, Distributor/Dealers and Wholesaler. Providing the meaningful reports/information, variance analysis and trends between Plan/Forecast vs Actuals with business/trade spend evaluation of help/hurt. Estimate trade spend Budget’s data reconciliation and LBE report preparation. Power BI Publish Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Sales Manager wise Target’s creation and Power BI publication Monthly State wise Dashboard. Power BI tools Analyzing the Sales Data & Creating Task wise Reports as per Requirement by Reporting Manager.  Created Dashboards in Power BI using various features of such as Custom-SQL, Multiple Tables, Blending, Extracts, Parameters, Filters, Calculations, Context Filters, Data source filters, Hierarchies, Filter Actions, Maps. Hands on in developing and designing reports and dashboards (using DAX Functions).

 Daily run query to extract the files issued previous day & also on real times basis. Download the Certificates, Checking of Certificate of Conformity (CoC’s) as per the Checklist and Checking CoC Fees, Border Fees & Business Unit. Forwarding all Certificates to the authorities. Ensure Continuous follow-up with the issuing office for correction of errors. Generating Monthly MIS for central Iraq, Kurdistan & The Central Bank of Iraq. Generating monthly Non-Conformity Report (NCR) Reports & Error Report. Weekly preparing Graphs & Analytical reports. Responsible for handling the product dashboards, MIS & analytics. Various business reports. Reporting of discrepancies and difficulties met in reaching the quality goals or time schedules. Perform any other operational duties as and when required by the management

 Preparing the Daily, Weekly, Monthly, Quarterly, Half-Yearly, Yearly MIS & Published to Concern Teams. Handling KYC activities for credit cards & PL cases. Handling Disbursal activities for Personal Loans & daily making a tools activity for All type of Loan cases. Analyzing and evaluating daily reports of PL products. Scrutinizing the bank statements. Salary Slip, Income Tax Papers, ITR & Any Repayment Tracks. Daily initiating Contact Point Verification/Field Investigations. Analyzing with Cibil reports details of PL cases. Pulling Out important reports for bank like Cibil report. Bank and Credit card Statements.