Kartik Nag

A. Designing and Development of Power BI Reports/Dashboards as per Business requirements

B. Data cleansing/Data Modelling by using DAX function and Power Query & Migrated existing scheduled reports to Power BI

C. Developing Graphs, Reports and Presentation for Projects, Results and Support Ad-Hoc Data Analysis from Business Users Implemented Statistical Method like Regression Analysis, scatter plot, box plot, histograms, probability distributions and business intelligence using Advance Excel, Power BI.

D. Researched and resolved issues regarding integrity of data flow into databases.

E. Identified, analyzed and interpreted trends or patterns in complex data sets.

F. Used statistical methods to analyze data and generate useful business reports.

G. Tested data prediction algorithms based on historical data.

H. Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.

I. Analyzed transactions to build logical business intelligence model for real-time reporting needs.

J. Utilized data visualization tools to effectively communicate business insights.

K. Extracted and interpreted data patterns to translate findings into actionable outcomes.

• Reviewed accounts on monthly basis to assess aging and pursue collection of funds.
• Managed monthly reconciliation schedules for assigned accounts.
• Identified, researched and resolved billing variances to maintain system accuracy and currency.
• Performed targeted collections on past due accounts aged over [Number] days.
• Tracked contracts, proposals and waivers to keep billing accurate and current.

• Analyzed records of present and past operations, trends and costs and estimated and realized revenues to project future revenues and expenses.
• Prepared reports analyzing specific aspects of department structures, functions and operational procedures and recommended ways to improve productivity.
• Retrieved and organized data into required reporting formats to provide basis for comparison and evaluation.
• Analyzing the Actual Volume Report to find the dark and bright Spots.
• Variance Analysis of P&L Actuals against Plan and YAGO.
• MOM Variance Analysis of G&A Report.
• Preparing MFR decks for Management on monthly basis.
• Perform monthly P&L and changes in financial position/budget variance analysis.
• Preparing other Ad hoc Reports as according to team requirement.
• Upload Volume and P&L in Hyperion Financial Management (HFM) software.

• Validated and recorded invoices and resolved discrepancies with vendors.
• Prepared and mailed account statements to vendors and kept meticulous correspondence documentation.
• Reviewed general ledger for accuracy and specific coding issues.
• Processed employee and contractor expense reimbursements quickly.
• Maintained inventory of office supplies and placed orders.
• Input data into accounting system and maintained integrity of system information to alleviate potential breaches.
• Managing day-to-day accounting operations Maintenance of Voucher and Bills
• Reconciliation of Online Fee Received from Student & BRS
• Processes payments and documents such as invoices, journal vouchers, employee reimbursement
• Preparing reports and statements requiring interpretation and analysis of accounting records
• Liasoning with auditors for Training & Placement and CAT Related Activities
• Maintenance of Stock Register, Inventory verification for Books and Study Material