DEEPANSHU MANDWAL
Noida
Summary
Detail-oriented Legal professional (BA LLB Hons) specializing in Indian AML frameworks and Corporate Compliance. I possess a proven track record of transforming raw data into strategic insights, gained through a Data Analyst internship at AVA Technologies utilizing SQL, Excel, and Power BI. My professional background includes a tenure at Aptara, where I developed exceptional communication skills and a disciplined approach to following organizational precedents. I am adept at bridging the gap between legal theory and operational reality, focusing on identifying risks, validating controls, and maintaining the highest ethical standards in global business environments.
Overview
1
1
year of professional experience
Work History
Data Analyst Intern
AVA Technologies
12.2025 - 02.2026
- Executed quality testing and data validation using SQL, ensuring internal datasets met compliance and regulatory standards.
- Created interactive Power BI dashboards to monitor risk indicators, allowing the team to visualize control gaps and track the effectiveness of implemented policies.
- Created Excel workbooks to audit operational workflows, identifying anomalies and generating weekly reports for senior supervisors on closure guidance.
- Partnered on InfoSec and Records Management projects, ensuring data handling adhered to legal and statutory requirements.
Customer Experience Associate
Aptara
05.2025 - Current
- Maintained a narrow, focused scope of work with high precision, ensuring that all customer interactions met organizational Quality Assurance (QA) standards.
- Functioned as an individual contributor in a high-volume environment, solving routine issues by strictly referring to SOPs and legal precedents.
- Identified recurring service delivery risks and reported them to the supervisor, aiding in the development of more robust internal controls.
- Demonstrated high adaptability by consistently meeting targets within a rotational shift schedule.
Education
BA LLB (Hons) - Prevention of Money Laundering Act (PMLA), IT Law, and Administrative Law
Guru Gobind Singh Indraprastha University
Greater Noida01.2025
Skills
- Risk & Compliance
- PMLA regulations
- Anticorruption regulations
- Legal compliance
- Operational Auditing
- Corporate governance
- Statutory regulations
- Information security policies
- Analytical Tools
- SQL
- Data Extraction
- MySQL
- Joins
- Advanced Excel
- Power Query
- Lookups
- Pivots
- Power BI
- Dashboarding
- Analytics
- Ethical decision-making
- Information security policies
- Anticorruption Controls
Technical Skills And Certifications
- Database: SQL (MySQL), Data Extraction, CTEs, Joins.
- Analytics: Excel (Advanced), Power BI, Power Query.
- Compliance: Knowledge of BCM, InfoSec Policies, and Anticorruption Controls.
Key Compliance Project
Flipkart Service Quality & Operational Risk Audit:
- To audit customer interaction data to identify drivers of dissatisfaction and potential compliance risks in service delivery.
- Extracted and filtered large datasets to isolate 'high-risk' customer complaints and categorize feedback., Performed a deep-dive statistical analysis to calculate CSAT (Customer Satisfaction) benchmarks and identify outliers in agent performance.
- Developed an automated dashboard to visualize sentiment trends, helping stakeholders identify which support channels required immediate risk mitigation strategies.
- Proposed a revised internal control framework to reduce service-level risks and enhance overall brand loyalty.
Timeline
Data Analyst Intern
AVA Technologies
12.2025 - 02.2026
Customer Experience Associate
Aptara
05.2025 - Current
BA LLB (Hons) - Prevention of Money Laundering Act (PMLA), IT Law, and Administrative Law
Guru Gobind Singh Indraprastha University