Ramendra Kumar

About Ramendra Kumar

I am a Lead Analytics Consultant with 13+ years of experience, specializing in Risk Analytics and People Analytics, delivering enterprise-scale analytics and data engineering solutions across regulated banking environments in Europe and India.My expertise spans the full analytics lifecycle, with a strong focus on ETL design, automation, and governance using Microsoft Fabric, PySpark, Python, SQL, SAS, NDM, and KSH scripting. I specialize in building scalable, auditable data pipelines that support regulatory compliance, operational resilience, and business decision-making.Currently at Wells Fargo, I design and implement Microsoft Fabric–based ETL pipelines leveraging Lakehouse, Notebooks, and Delta tables. My work supports Technology Controls, Risk Analytics, and People Analytics, with emphasis on data quality, lineage, automation, and control-aligned reporting across large operational and HR datasets.I bring deep experience in Risk Analytics, including operational risk monitoring, control effectiveness analysis, RCA automation, and regulatory-ready reporting. I have led automation initiatives that significantly reduced manual effort and improved audit outcomes.Over the last 2 years, I have expanded into People Analytics, working with workforce data covering recruitment, attrition, headcount movement, and hiring trends. My focus has been on implementing data quality frameworks, standardized KPIs, and automated reporting to support leadership insights and workforce planning.Previously, at Royal Bank of Scotland, I led delivery teams on enterprise risk initiatives, including the ORBIT program, where I developed an RCA Autoloader Automation Tool that reduced data preparation effort by 70%. At Cognizant, I supported mission-critical batch operations and built monitoring and automation solutions to improve stability and efficiency.I hold a PGDM in Data Analytics and Machine Learning from BITS Pilani and a SAS Programmer certification. I am known for strong problem-solving, technical leadership, and cross-functional collaboration.I am passionate about Microsoft Fabric, analytics-driven risk management, and workforce insights, and I enjoy building scalable solutions that create measurable business impact.Let’s connect.

Experience

1. Lead Analytics Consultant

   Wells Fargo

   Apr 2024 — Present · Bengaluru, IN

   Implemented scalable People Analytics solutions delivering workforce insights across recruitment, attrition, headcount, and performance using Python, PySpark, and SQL to support data-driven decision-making in an enterprise environment.Built end-to-end HR data pipelines integrating multiple sources (requisitions, candidates, hires, terminations) with standardized, audit-ready outputs.Engineered metadata-driven ETL frameworks to process large HR datasets with varying schemas, improving efficiency and reusability.Designed and implemented data quality and governance controls including null checks, duplicates, min/max validation, and 6-sigma/IQR-based outlier detection to improve data reliability.Developed standardized workforce KPIs such as attrition trends, hiring velocity, time-to-fill, and headcount movement to support strategic workforce planning.Automated People Analytics reporting workflows, reducing manual effort and accelerating insight delivery for dashboards and leadership reporting.Collaborated cross-functionally with HR, Talent Acquisition, and Technology teams to translate business requirements into scalable analytics solutions aligned with enterprise governance standards.Skills: Python · PySpark · SQL ·Power BI.Microsoft Fabric.Data Modelling.People Analytics · Workforce Analytics · HR Data Engineering · Data Quality · Automation · Analytics · Cross-team Collaboration

Education

• Zero To Mastery Academy

  Complete-Python-Developer-Zero-to-Mastery

• SCSVMV

  B.TECH, INFORMATION TECHNOLOGY

  2008 — 2012

• Birla Institute of Technology and Science, Pilani

  Postgraduate Degree, Artificial Intelligence and machine learning