Somya Mangla

Associate Consultant

Gurugram, Haryana, India4 yrs 1 mo experience

Most Likely To SwitchAI Enabled

Key Highlights

Expert in data analysis and automation workflows.
Proven track record in portfolio evaluation and reporting.
Strong technical skills in Python, SQL, and Power BI.

Stackforce AI infers this person is a Data Analyst with expertise in Fintech and data-driven decision-making.

Contact

Skills

Core Skills

Data AnalysisAutomationData Visualization

Other Skills

Analytical SkillsArtificial Intelligence (AI)Attention to DetailBudget MonitoringBusiness RequirementsC++CommunicationData ScienceData StructuresDatabase ManagementDeep LearningExcel MacrosHTMLJavaMachine Learning

About

A Data Analyst at Encore ARC, I work at the intersection of data, strategy, and automation. My experience spans secured and unsecured portfolio analytics, where I support acquisition and pricing decisions through deep data analysis, streamlined reporting, and process optimization. I enjoy solving business problems using tools like Python, SQL, Excel VBA, and Power BI. From building automation workflows that reduce manual effort to creating dashboards that bring clarity to complex data, I focus on delivering insights that drive smarter decisions. At Encore, I've contributed to the full lifecycle of portfolio evaluation—handling everything from data cleaning and trend analysis to maintaining audit-ready databases and improving operational efficiency through scalable mapping frameworks. My role demands a mix of technical know-how, business understanding, and collaboration across teams. I hold a B.Tech. in Computer Science (Gold Medalist) and have had the opportunity to broaden my perspective through global exchange programs in New York and London. I’m passionate about using data not just for analysis, but for meaningful impact.

Experience

Encore asset reconstruction company private limited

3 roles

Senior Analyst

Promoted

Oct 2025 – Present · 5 mos · Gurugram, Haryana, India · On-site

Data Analyst

Jan 2024 – Sep 2025 · 1 yr 8 mos · Gurugram, Haryana, India · On-site

Analyzed secured and unsecured acquisition portfolios to support pricing, due diligence, and investment decisions, ensuring data integrity and strategic alignment.
Automated key portfolio processing workflows using Python and Excel macros, significantly reducing manual effort and improving turnaround time.
Designed and implemented scalable mapping frameworks for unmapped payments and portfolio data, improving operational visibility and team collaboration.
Developed interactive dashboards and reports in Power BI to track KPIs, portfolio performance, and key business metrics for cross-functional stakeholders.
Maintained and optimized databases for multiple portfolios, ensuring high levels of accuracy and audit-readiness in compliance with internal and external requirements.

PythonExcel MacrosData AnalysisPower BIDatabase ManagementAutomation