Associate
Gurugram, Haryana, India
• Generate timely and accurate reports for analysis and Creating MIS report and presenting it to the Management.• Creating Fund requirement data sheet on POWER Bi Dashboard for concern Department.• Extracted data from various sources like SQL Server 2008, CSV, Excel, and Text file from servers.• Various uses of transformations for package development like Data Conversion, Look up, Multicast, Sort, Merge Join, Derived Column.• Extract the data with system of patient and prepare monthly report with the help of SQL.• Prepared Dashboard on Power Bi and for Different requirement. Revenue Reporting, Monthly Comparison of Expenses, Hospitals Revenue comparison, Console level Reporting, ETC.• Audit - coordinating with statutory & internal auditors with respect to above-mentioned job profile.• Monthly bank reconciliations, Inter-company reconciliations, Debtors and Creditors reconciliations & Debtors and Creditors Ageing.• Generate timely and accurate reports for analysis.• Prepare Budget for new Project.• Monitoring of consume budget and prepare report monthly, quarter and yearly basis for management.• Preparation of Cash flow statement.• Responsible for posting of Accruals, Prepayment journals, closing of GL etc.• Handle received credit payment and prepared dashboard on daily basis and clear in books.• Handling various statutory compliances e.g., Taxation, TDS, TCS, Service Tax.• Reviewing, and correcting errors and inconsistencies in financial entries, documents, and reports.• Managing the Monthly, Weekly & Daily Report Creating in MS-Excel through in-depth analysis and producing the actionable information.