Business Intelligence Analyst
CONDUENT BUSINESS SERVICES INDIA LLP
Total years of experience :8 years, 9 Months
• Developed and implemented Power BI visualizations and reports that provided the key insight inform and engage business to increase the business impact and performance.
• Extracted, transformed, and loaded data from various sources into Power BI, ensuring data accuracy and consistency.
• Automated the manual process via PBI dashboards, Power query, DAX Analysis & VBA Macro to bring efficiency and simplifying the process and saved ~60% of utilization of resources.
• Perform detailed analysis on key trends for Budget, Committed Spend, Actuals, forecast & Target data, and present findings to management for effective decision making.
• Collaborated with business to identify key performance indicators (KPIs) and translate them into actionable Power BI visualizations.
• Developed strong skills in digitalization, automation tools, enabling me to streamline processes and enhance productivity across the organization.
• Extract data from micro-strategy tool and make it presentable through visualizations and publish 'Reconciliation Status Report' PBI dashboard to stakeholders on monthly basis.
• Managing reconciliation of Suspense accounts, Bank accounts, Offset accounts, Foreign Currency Conversion accounts, Inter-Company accounts.
• Responsible for month-end closing, statutory accounts, variance analysis in SL and GL.
• Alignment of SOX audit requirements, like data integrity, accuracy & completeness.
• Responsible for reconciliation of Bank & Suspense accounts for different markets.
• Assist controllers by providing commentaries and detailed analytical packs.
• Preparation of open items & account-ageing status report and publish it on weekly basis.
• Responsible for month-end activities like general ledger closing, MIS reporting.
• Preparation of P&L and Balance sheet accounts reconciliation and report analysis.
• Managing AP, Prepaid & Accrual accounts to depict the true & fair view of financial position.
• Managing BIP & CPC accounts against charges booked in payment cards.