About
Results-driven Data Analyst with hands-on experience in Python, SQL, Power BI, Tableau, and Google Cloud Platform (GCP). Specialized in processing and reconciling Mutual Fund RTA data from CAMS and KFintech (Karvy), including NAV data, transaction records, and AUM reporting for a mutual fund distributor. Skilled in data cleaning, ETL pipelines, KPI dashboard development, and business intelligence. Experienced in building client portfolio analytics, generating actionable insights, and automating reporting workflows. Strong understanding of mutual fund operations, data analytics workflows, and cloud-based analytics solutions.
Skills & Expertise (21)
Work Experience
Data Analyst
RKS Wealth India Pvt. Ltd. (RksWealth)
Jan 2025 - Present
Processed and reconciled Mutual Fund RTA data from CAMS and KFintech (Karvy), ensuring data accuracy for NAV, transaction records, AUM, and SIP/Lumpsum tracking across client portfolios. Designed and automated ETL pipelines in Python and SQL to ingest, clean, and transform RTA flat files (CAMS/Karvy) into structured databases for downstream reporting. Built KPI dashboards in Power BI and Tableau to monitor AUM growth, portfolio performance, transaction volumes, and client-level investment insights for distributor operations. Developed complex SQL queries across MySQL, PostgreSQL, and MongoDB to extract, join, and analyze business and investment data from multiple RTA sources. Utilized Google Cloud Platform (GCP) for secure cloud-based storage and analytics of sensitive mutual fund transaction data. Generated CAS (Consolidated Account Statement) analysis reports and reconciliation summaries to support client servicing and business decision-making. Improved database performance and ensured data integrity for backend analytics operations, reducing manual reconciliation effort by standardizing data ingestion workflows.
Internship Trainee
Ai Variant
Aug 2024 - Jan 2025
Worked on real-world business datasets to generate insights and improve reporting accuracy. Designed interactive dashboards and visualizations using Power BI and Tableau for stakeholder reporting. Performed ETL operations including data extraction, cleaning, and transformation using MySQL and Excel. Created KPI metrics and data-driven storytelling reports to support business decision-making.
Senior Sales Officer
Yes Bank
Jul 2023 - Jul 2024
Analyzed customer and operational data to improve business performance and customer experience. Developed reporting dashboards to monitor sales performance and operational KPIs. Leveraged data insights to optimize corporate account processes and workflows.
Operations & Marketing Executive
Yums Advertising
Oct 2019 - Jun 2023
Analyzed marketing and operational data to identify trends and business opportunities. Generated actionable insights and reports for non-technical stakeholders. Supported data-driven decision-making processes across operations and marketing teams.
Education
Bachelor of Science (B.Sc.) (Mathematics) - Jiwaji University
2016 - 2019 ยท Afghanistan
Senior Secondary Education (PCM) - Govt. Girls Higher Secondary School
2015 - 2016 ยท Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (21)
Click a skill to find developers with the same skill