Data Visualization and Reporting:
- Maintained interactive dashboards in Redash and Superset for effective tracking of business performance.
- Reduced manual reporting time by 60% through automation of recurring reports using SQL and visualization tools.
- Delivered clear, actionable insights from complex data using tailored reports for diverse audiences.
- Increased executive decision-making efficiency by 40% through enhanced reporting capabilities.
Advanced Data Analysis:
- Achieved 50% growth in product sales by creating targeted marketing strategies informed by customer behavior analysis.
- Provided critical insights from detailed analyses to support strategic decisions in marketing and product management.
- Executed customer segmentation and performance analysis to refine outreach efforts and improve ROI.
- Built and deployed customer scoring models for salaried loan products to assess creditworthiness, segment borrowers, and improve loan approval precision.
Real-time Data Processing and Analysis:
- Addressed scalability challenges in processing and analyzing large volumes of real-time data generated daily across multiple systems.
- Migrated data from production environments to Amazon S3 using date-wise partitioning to optimize storage and retrieval efficiency.
- Designed and implemented a layered data architecture (raw, processed, curated) to streamline access for the risk team, and improve analytical efficiency.
- Automated data ingestion and processing tasks using Apache Airflow, scheduling jobs to run every 30 minutes, and ensuring data freshness for downstream analysis.
Regulatory Reporting & Bureau Submission:
- Managed end-to-end bureau data submission processes, ensuring accurate and timely reporting to credit bureaus in alignment with regulatory and compliance standards.
- Handled customer disputes related to bureau reporting by investigating root causes, coordinating with internal teams, and ensuring timely resolution within defined TATs.
- Designed and implemented validation frameworks to minimize submission errors, and improve data quality across reporting cycles.
- Partnered with compliance and risk teams to address audit findings, improve reporting processes, and ensure full regulatory adherence.
- Maintained thorough documentation for submission logs, dispute resolutions, and historical corrections to support audit readiness and transparency.
Sales and Marketing Collaboration:
- Partnered closely with the marketing and telesales teams to develop and execute targeted campaigns that drove a 50% increase in loan product sales.
- Provided customer behavior insights, lead prioritization strategies, and performance analytics to support more effective outreach and higher conversion rates.
- Contributed to the design of messaging, campaign timing, and segmentation logic, ensuring alignment between data strategy and business goals.
- Supported telesales initiatives with real-time reporting and customer scoring to help agents focus on high-potential leads, improving efficiency and closure rates.
Team Training and Mentorship:
- Provided regular training sessions to the operations team to improve their understanding of data processes, tools, and reporting workflows, and served as the primary contact for resolving day-to-day queries.
- Trained and mentored a team of over six junior analysts, reviewing their work, providing feedback, and guiding them on best practices in data analysis, reporting, and model development.
- Established knowledge-sharing practices and created documentation to ensure consistency, and elevate overall team performance.
- Played a key role in building a collaborative, high-performing analytics team by fostering continuous learning and skill development.