Shikha Ajay Rai

Actively and consistently supports all efforts to simplify and enhance the customer experience. Interpret data, formulate hypotheses and develop an analytical approach to meet business requirements. Create customer-readable reports and dashboard using advanced visualization tools such as parsing texts in order to extract machine-readable facts from them. Work to obtain and ingest new reference data sources required to deliver on business needs.

Performed monthly/quarterly analysis for stakeholders, highlighting actionable insights and enabling the implementation of corrective actions. Spearheaded the development and implementation of Power BI dashboards for critical HR analytics projects, including Employee Headcount, Ethnicity, Resignation/Termination, Mobility, Workforce Cost, and Compensation Range. Ensured quality data maintenance for regular/ad-hoc analytics. Led a cross-departmental BI strategy, reducing report generation time by 25% through optimized data models. Utilized SQL and Python for backend data generation and ETL processes, ensuring accurate and reliable data inputs for Power BI dashboards. Developed custom visualization templates in BI, improving report comprehension. Participated in project planning, execution, and post-implementation reviews to continuously improve dashboard performance. Trained and supported teams in interpreting and utilizing insights from Power BI dashboards, optimizing workforce management strategies. Created and maintained supporting documentation.

Engaged in requirement gathering sessions, collecting insights to formulate effective solutions. Collaborated with the finance team on the ROIC project, enhancing the company's capital efficiency. Worked on a Demand Forecasting project, improving inventory management and operational efficiency. Deployed Power BI solutions across departments, automating reporting tasks and reducing delivery time by 35%. Developed custom Power BI connectors, streamlining data ingestion and reducing integration time by 20%. Enabled dynamic reporting by integrating APIs, increasing report customization and usage by 25%. Optimized data models, decreasing dashboard refresh times by 50% and benefiting real-time decision-making processes.

Utilized Python to filter and cleanse data, identifying and rectifying code issues. Designed interactive Power BI dashboards, increasing operational efficiency by 12%. Initiated a data accuracy project, reducing data discrepancies by 22%. Facilitated Power BI training sessions, boosting team productivity by 40%. Conducted Key Performance Indicator analysis using Python, Matplotlib, and Power BI. Analyzed HR Analytics (Attrition Prediction), proposing retention strategies using Python and Power BI. Automated data preprocessing tasks, saving over 30 hours per month.

Reviewed and approved modifications to project plans and documentation. Collected and interpreted data using SQL and Excel. Reported analysis results to relevant business members.

Collaborated with cross-functional teams to align on problem statements. Utilized A/B testing methodologies, reducing platform bounce rate by 62%. Designed interactive dashboards (VAHAN Dashboard and Voice of Customer) to visualize key business metrics. Conducted Customer Lifecycle Value analysis to optimize marketing strategies using Python and Power BI. Developed a Lead Scoring Model using predictive modeling techniques with Python. Performed sentiment analysis on customer feedback, extracting insights using Python and Power BI. Automated financial reports using Power BI, saving 10 hours of manual work per week.

Business Research & Analysis, handling 'Trade & Forex'. Client Management & Credit Risk Analysis to Enhance client relationships, assess credit risk, and implement credit policies to minimize bad debt. Loan Default Identification Implemented a statistical model using Random Forest classification techniques to predict loan defaulters, contributing to risk mitigation strategies and improved loan portfolio management.