Senthil kumar A

<p>Managed recruitment operations and data through CEIPAL ATS, ensuring data accuracy and process standardization.</p><p> Managed GCC and Build-Operate-Transfer (BOT) recruitment models by collaborating with client organizations, driving end-to-end hiring operations, stakeholder management, workforce planning, and process alignment to ensure successful talent acquisition delivery.</p><p> Collaborated with TA Managers, Recruiters, and stakeholders to improve recruitment workflows and implement process enhancements.</p><p> Developed Power BI dashboards and MIS reports to monitor hiring KPIs, including Time-to-Offer, Time-to-Hire, and SLA performance.</p><p> Performed data cleansing, validation, and governance activities to maintain CEIPAL as the single source of truth.</p><p> Supported CEIPAL integrations with external recruitment tools and job portals while ensuring data security and audit compliance.</p><p> Executed ETL activities, UAT testing, production validation, and Root Cause Analysis (RCA) to identify, troubleshoot, and resolve system and data issues during new feature implementations and enhancements.</p><p> Managed vendor coordination, invoice validation, payout mapping, and Super Admin activities across recruitment platforms.</p><p> Automated reporting using Advanced Excel, Power Query, and Macros to improve operational efficiency.</p><p> Proactively monitored recruitment data quality, compliance, and reporting accuracy to support business decisions.</p>

<p>Developed structured datasets from unstructured operational data, enabling accurate analytics and reporting across business operations.</p><p> Built and managed dashboards using Power BI, Advanced Excel, and Google Sheets to track revenue, KPIs, productivity, TAT, and operational performance.</p><p> Owned daily, weekly, monthly, and quarterly MIS reporting, providing actionable insights for business planning and performance reviews.</p><p> Led revenue analytics, collections, and end-to-end reconciliations across business, partners, vendors, and payouts, ensuring financial accuracy and cash-flow optimization.</p><p> Managed operations across quick commerce platforms (Zepto, BigBasket, Zomato, Swiggy Instamart) and B2B/franchise networks, enhancing operational efficiency.</p><p> Monitored deployment manager-wise, rider-wise, and client-wise performance; tracked earnings, login hours, live productivity, order volumes, and P&L to drive operational improvements.</p><p> Automated reporting and data workflows using Advanced Excel (Power Query, Pivot Tables, Macros/VBA), Power BI (DAX, data modeling), Google Sheets, Google Apps Script, and SQL for extraction, transformation, and migration.</p>

<p>Working in the banking industry's contact center operations as part of the Continuous Improvement (CI) / Re-engineering team. Responsible for stakeholder management, task analysis, and reporting.</p><p> Gathered business requirements and developed data models, Excel reports, and interactive Power BI dashboards to support decision-making.</p><p> Receiving Business Requirement Documents (BRDs) from stakeholders and working on corresponding requests with clear timelines and reporting expectations.</p><p> Analyzed large datasets in compliance with company data protection and security policies. Designed automated ETL processes using SQL (including MySQL) and Power Query to ensure accurate and reliable reporting.</p><p> Performed data validation, data modeling, and data cleaning, and developed dashboards and reports in Power BI to highlight key business metrics.</p><p> Responsible for MIS analysis and timely publishing of all MIS reports using Excel. Maintained historical (vintage) data in SQL/MySQL databases for reporting and trend analysis.</p><p> Streamlined BAU (Business as Usual) processes by automating workflows using Power Query, Excel Macros, and MySQL. Utilized databases for efficient data storage, retrieval, and transformation.</p><p> Performed ad-hoc statistical analysis on large datasets using advanced Excel functions and MySQL techniques to uncover trends and insights.</p><p> Conducted service recovery analysis and customer survey reviews across channels such as calls, emails, chats, and video banking. Used third-party applications to retrieve and analyze feedback data, and published insights to stakeholders across multiple countries to drive service improvements.</p><p> Involved in resolving production issues for applications and ensuring all support activities comply with established SLAs (Service Level Agreements).</p>

<p>Developed and maintained HR dashboards in Excel to track key HR metrics such as headcount, attrition, recruitment funnel, and employee engagement.</p><p> Extracted and managed HR data from various systems (HRMS, ATS, Payroll) using SQL queries, including MySQL and SQL Server.</p><p> Used Power Query in Excel to automate data preparation tasks such as merging, cleaning, and transforming multiple HR data sources.</p><p> Managed recruitment operations and data through CEIPAL ATS, ensuring data accuracy and process standardization.</p><p> Published monthly and quarterly HR reports using Power BI, covering Recruitment, Payroll, Employee Relations, Productivity, and Performance metrics to support data-driven decision-making.</p><p> Created interactive Excel dashboards with slicers, pivot tables, charts, and conditional formatting for quick and visual insights. Monitored and analyzed attrition trends, onboarding pipeline, and training effectiveness, presenting results to HR leadership.</p><p> Automated manual HR reporting processes using Excel formulas, macros, and Power Query, reducing turnaround time significantly.</p><p> Worked with stakeholders across Recruitment, L&D, and Operations to gather requirements and deliver customized data solutions.</p><p> Performed regular audits and validations of HR master data to maintain clean and up-to-date employee records.</p>

<p>Analyzed recruiter and business development team performance using Advanced Excel (Pivot Tables, formulas) and Power BI; created dashboards and reports (weekly, monthly, quarterly) to track productivity and calculate performance-based incentives and bonuses.</p>