M PHANI VARMA
Bengaluru
Summary
- Data Analytics and Business Intelligence professional with 10 years of experience in designing, developing, and delivering data-driven solutions using Alteryx, Power BI, and SQL. Proven expertise in data preparation, ETL automation, dashboard development, reporting, and analytics within the financial services domain at London Stock Exchange Group (LSEG). Skilled in transforming complex datasets into actionable insights, optimizing business processes, and supporting strategic decision-making through scalable analytics solutions.
Overview
10
10
years of professional experience
Work History
SENIOR ANALYST
London Stock Exchange Group
Bengaluru
09.2016 - Current
- Developed automated data processing and reporting solutions for trading account management, client onboarding, transaction monitoring, and regulatory reporting.
- The project focused on consolidating trading account data from multiple sources, ensuring data accuracy, compliance, and operational efficiency across trading operations.
- Automated data integration from multiple trading systems, built exception management processes, and delivered interactive Power BI dashboards for trade analytics, account monitoring, and risk reporting, reducing manual effort by 80% and improving reporting accuracy.
- Designed and developed Alteryx workflows to extract, transform, and load (ETL) trading account and transaction data from multiple systems.
- Automated daily and monthly reconciliation processes between trading platforms and back-office systems.
- Created data quality validation workflows to identify missing, duplicate, and inconsistent account records.
- Developed SQL queries, stored procedures, and views for trading account analytics and reporting.
- Hands on experience on Alteryx implementation including Macro for repetitive & Automated App development - Standard Macro & Batch Macro.
- Experienced on building Analytic App using Interface tools Check box, Text box, List box, Radio button, Drop Down, File browse and Action tool.
- Automated 90% of manual reconciliation activities using Alteryx.
- Reduced report generation time from several hours to under 30 minutes.
- Automated trading account validation and compliance reporting processes, reducing manual effort by 80%.
- Generated regulatory and audit reports ensuring adherence to financial market regulations.
- Utilized advanced SQL for large-scale financial data extraction, transformation, and analysis.
- Optimized Alteryx workflows, reducing processing time for large trading datasets.
- Built Power BI dashboards to monitor account activity, trade volumes, client onboarding status, and operational KPIs.
- Delivered real-time Power BI dashboards for trading operations and management teams.
- Collaborated with traders, operations teams, compliance teams, and business stakeholders to gather requirements and deliver reporting solutions.
- London Stock Exchange Group is a global financial markets infrastructure and data provider offering trading, market data, analytics, clearing, and risk management services across multiple asset classes. LSEG's trading solutions support pre-trade analytics, execution, post-trade processing, compliance, and reporting workflows.
ASSOCIATE CONTENT ANALYST
LSEG
09.2016 - 01.2022
- Deep knowledge and research on Mergers/Acquisitions and IPO, Company Name changes details of company.
- Understanding and developing knowledge on Refinitiv products like Workspace, EIKON, DSS and TRKD.
- Industrial research to update Organization classification (NAICS and NACE).
- Knowledge in mutual funds (Open-ended funds, closed ended funds, Investment funds, Pension funds and Insurance funds).
- Capturing Hierarchy (Parent and Subsidiary) Tracking of Name Changes, LEI and other entity level data.
- Data base Testing- Tool Enhancement ideas.
- Procuring documents filed by public companies, Banks and other financial institutions from Security Exchange Commission (SEC) Registration authorities and Regulatory authorities to check and update to minimize the risk of capturing data from unapproved sources.
- Documentation of activities performed and tasks migrated by the team.
- Understanding the process and deliver on the SLA set.
- Monitoring the Rota and paying attention to the details.
- Exceptional skills in writing the resolutions with demonstrated values and documenting the work.
Education
MBA - Finance
Sir M Visvesvaraya Institute of Technology
08.2015
Bachelor of Commerce - Finance
Veerashaiva College
08.2013
Skills
- Alteryx Designer
- PowerBI
- SQL Querying
- Data Analysis and Research
- Process improvement and Quality Control
- Alteryx Server / Gallery
- Tableau Desktop
- Databricks
- Microsoft Excel
- Training and Team Leadership
- Metrics and SLAs
- Alteryx Analytical App
- Tableau Prep
- SAP HANA
- Market Research
- Mentoring juniors
- Stakeholder management
Websites
Accomplishments
- Received Spot light award for driving the discussions related in sharing the best practices followed for handling client queries across different cross Content teams in LSEG.
- Achieved an award on presenting the demo how the dataflows to the products.
- Awarded the best performer award on receiving the best feedback from Clients on handling queries with high priority and avoiding the follow ups.
Languages
English
Kannada
Hobbies and Interests
- Playing cricket
- Reading books
- Bike riding
Timeline
ASSOCIATE CONTENT ANALYST
LSEG
09.2016 - 01.2022
SENIOR ANALYST
London Stock Exchange Group
09.2016 - Current
MBA - Finance
Sir M Visvesvaraya Institute of Technology
Bachelor of Commerce - Finance
Veerashaiva College