Skip to content

Lovina Prince Macwan

Data Analyst / Business Analyst Intern • Chicago, Illinois • m***********@gmail.com • +13******772 • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst / Business Analyst Intern with 10+ years of experience in financial operations, compliance, and large-volume data processing at Tata Consultancy Services. Skilled at sanction screening, data validation, MIS reporting and process optimization; seeking internship roles to apply analytics, reporting and compliance knowledge to business problems.

Technical Skills

Databases: SQL,Relational data concepts,Report extraction
Data and Analytics: Data cleaning,Data validation,Data quality assurance,Data aggregation,Descriptive analysis,Microsoft Excel,PivotTables,Charts & dashboards,Tableau,MIS reporting
Tools and Methodologies: Orbiflow,Flexcube,NRSP systems,Client Order Tool,Microsoft Office Word, PowerPoint
Compliance & Risk: Regulatory compliance,Sanction screening,Risk monitoring,KYC,AML fundamentals
Process & Project: Process mapping,SOP development,Workflow optimization,Stakeholder coordination,Knowledge transfer & training

Work Experience

Tata Consultancy Services (TCS)
India
Process Analyst
May 2012 – Jul 2017
Worked at TCS supporting banking operations and client data quality for international banking customers; ensured compliance and timely delivery of processed data.
Tech Stack: Client Order Tool, Flexcube, NRSP systems, Microsoft Excel, Microsoft Office
  • Led final inspection and quality-control activities using Client Order Tool to ensure client data met regulatory and contractual requirements, reducing rework and exceptions.
  • Organized timely delivery of processed information to overseas customers while maintaining high accuracy and service levels through standardized checklists and schedules.
  • Developed product and market databases on Flexcube and NRSP systems based on client requirements to support reporting and client queries.
  • Observed operational processes and implemented workflow improvements that minimized processing delays and improved throughput.
  • Created data and workflow maps and wrote standard operating procedures (SOPs) to enable partial automation and consistent execution across shifts.
  • Collaborated with cross-functional teams to identify improvement areas, delivered training sessions, and transferred knowledge to sustain process changes.
Tata Consultancy Services (TCS)
India
Analyst – Banking, Financial Services & Insurance (BFSI)
Aug 2017 – Mar 2019
Supported high-volume transaction processing and MIS reporting for banking clients; contributed to treasury reporting and operational compliance.
Tech Stack: Microsoft Excel, MIS Reporting Systems, Microsoft Office
  • Processed high-volume banking transactions (RTGS, RTGC, NEFT) with strict adherence to accuracy and regulatory requirements to maintain transaction integrity.
  • Produced MIS and treasury reports used by management for decision-making, consolidating transactional data and highlighting exceptions for follow-up.
  • Analyzed transaction and reporting trends to identify recurring issues and proposed workflow changes to reduce exceptions and manual interventions.
  • Maintained transaction-level audit trails and documentation to support regulatory inquiries and internal audits.
  • Coordinated with stakeholders across operations and client teams to resolve discrepancies and ensure timely settlement and reporting.
  • Implemented Excel-based templates and checks to standardize reporting and accelerate report generation across the team.
Tata Consultancy Services (TCS)
India
Information Processing Specialist
Apr 2019 – May 2022
Worked on sanction screening, compliance checks and data validation for international financial systems to identify restricted entities and support regulatory compliance.
Tech Stack: Orbiflow, Internal banking systems, Microsoft Excel, Microsoft Office
  • Performed sanction screening and regulatory compliance checks to identify restricted entities within international banking systems, ensuring client adherence to sanctions lists.
  • Processed and validated large volumes of data using Orbiflow and internal banking systems to support compliance workflows and reporting requirements.
  • Maintained rigorous data governance and confidentiality standards to protect sensitive financial information and meet client security expectations.
  • Identified and resolved data discrepancies through root-cause analysis, improving data reliability and the accuracy of compliance reports.
  • Designed and maintained tracking logs and exception registers to ensure timely resolution and auditability of compliance cases.
  • Collaborated with compliance and operations teams to refine screening heuristics and reduce false positives while maintaining regulatory coverage.
Tata Consultancy Services (TCS)
India
Information Processing Enabler
Jun 2022 – Mar 2023
Supported team-based operational data processing and internal application processes within TCS, focusing on efficiency, reporting and timely processing.
Tech Stack: Microsoft Office, Microsoft Excel, Tableau, Orbiflow
  • Oversaw internal application processes and supported operational data processing to ensure consistent throughput and timely report delivery.
  • Liaised with team members and stakeholders using Microsoft Office to coordinate tasks and maintain timely processing and reporting cycles.
  • Streamlined data processing tasks by introducing standardized templates and automated checks in Excel to increase team productivity.
  • Created reporting templates and simple Tableau dashboards to improve visibility into processing status and key metrics for stakeholders.
  • Facilitated handovers and documentation for process changes to ensure continuity and reduce onboarding time for new team members.
  • Monitored process KPIs, identified bottlenecks, and proposed process modifications that improved operational efficiency and reduced delays.
Financial Services

Education

Concordia University Wisconsin
Master of Science – Business Analytics • United States • Expected 2026
SEMCOM College, Sardar Patel University
BBA (Honors), Finance & International Business • India
Maharaja Sayajirao University
LLB (Bachelor of Laws) • India

Achievements

  • On-the-Spot Award: Awarded by an international customer for accomplishing complex tasks without any mistakes.
  • Performance Linked Reward (PLR): Recognized for operational excellence.
  • Service & Commitment Awards: Awarded for 10 years of service at Tata Consultancy Services.

Powered by Drivetube · Create your own profile at drivetube.ai