Devanshi

Assisted in Implementing a BI solution to map the customer journey across various banking products, aiming to identify bottlenecks and areas for process improvement.
Collaborated with customers and internal teams to design and maintain customized reporting solutions, enhancing data-driven decision-making capabilities.
Utilized strong proficiency in SQL-based languages to write and troubleshoot complex queries, ensuring accurate and efficient data analysis.
Worked with complex data sets to extract valuable business insights, contributing to informed decision-making processes.
Autonomously prioritized and executed Analytics projects in a fast-paced environment, meeting project timelines and delivering high-quality results.
Built dashboards and reporting tools to measure progress in key initiatives, providing stakeholders with clear and actionable visualizations.
Partnered with cross-functional teams, including product managers, engineers, and marketers, to offer data-driven recommendations and support ad-hoc analysis.
Contributed to the improvement of data culture by developing and enhancing data processes and best practices.
Demonstrated a keen interest and proficiency in presenting and visualizing numerical and statistical data.
Maintained a focus on security and privacy in data pipelines and stores, ensuring compliance with data protection standards.
Thrived in a fast-paced work environment, successfully managing and prioritizing multiple projects to meet organizational goals.

Assisted in implementing a BI solution to map the customer journey across various banking products, aiming to identify bottlenecks and areas for process improvement.
Conducted initial requirement-gathering meetings with business and technology stakeholders to align project objectives and expectations.
Developed comprehensive data models to efficiently structure customer activity and transactional information, ensuring optimal data organization.
Formulated and optimized SQL queries, enhancing data retrieval performance for insightful analysis and reporting.
Created, maintained, and fine-tuned PowerBI data models to meet ongoing analytical needs, contributing to a dynamic and adaptable reporting environment.
Led the design and implementation of PowerBI dashboards, focusing on analyzing customer interaction metrics for strategic decision-making.
Conducted A/B testing using SQL stored procedures, contributing to data-driven experimentation and continuous improvement.
Oversaw data governance processes, ensuring adherence to data quality standards and regulatory requirements.
Conducted quarterly data audits, verifying alignment with key performance indicators (KPIs) and maintaining data integrity.
Collaborated effectively with actuarial teams, defining precise data requirements and gaining insights into reserving logic for insurance-related analytics.
Applied advanced SQL techniques to mine large datasets, prioritizing data cleanliness and relevancy for robust analysis.
Utilized Jira to meticulously track data discrepancies and facilitated smooth inter-departmental data workflows through Confluence.
Organized and conducted cross-departmental workshops, aiming to enhance data literacy and cultivate a culture of data-driven decision-making within the organization.

Optimized data structure by consolidating 5 diverse data sources, reducing analysis time by 60% through stored procedures, triggers, and views.
Spearheaded communication with 10+ clients to understand their business needs and translate insights into actionable reports using Tableau; enabled clients to make data-driven decisions and increased client retention rate by 20%.
Efficiently delivered regulatory-compliant complaint reports to the Operations Team, reducing effort by 40% through complex SQL query automation.
Led a team of business analysts to collect client requirements and designed software functionalities, assisted preparing work units and solution approach documents.
Automated region-wise lead report for marketing Team using filters and parameters; eliminated daily manual efforts by 70%.
Proposed audit reports to diagnose data quality issues for 25K+ employees, leading to improving data quality by 50%.
Acted as a subject matter expert providing hand on platform diagnosis and assistance to various team members.
Recognized with “ACE 2022” to consistently delivering exceptional work in Tech Mahindra.
Received the “Pat on Back Award” for excellent performance in Tech Mahindra.

Analyzed agent performance metrics to influence talent development and staffing choices, improving the agency's overall profitability.
Collaborated with sales leaders to pinpoint key performance indicators crucial for decision-making.
Created and maintained Tableau data sources and sets for consistent and accurate analytics.
Authored and reviewed intricate SQL scripts for data extraction and manipulation, ensuring data integrity.
Engineered Tableau visualizations showcasing agent performance metrics, trends, and forecasts.
Implemented machine learning algorithms to forecast future performance, enhancing predictive analytics.
Developed robust procedures for data verification and cleansing using SQL for data accuracy.
Regularly updated dashboards and reports to incorporate new data fields and key performance indicators (KPIs).
Extracted and managed ticket data from various support platforms using SQL for comprehensive analysis.
Analyzed data for ticket trends, agent performance, and common customer issues, informing strategic decisions.
Managed ticket data extraction from diverse support platforms using advanced SQL queries.
Led data-driven discussions, influencing the customer support team's strategy through insightful analysis.
Instituted a feedback loop with the customer support team, refining analytics processes based on real-world insights.