Home

Vasuki BALASUBRAMANIAN - Business Analyst / Data Analyst

[email protected]

Location: Beltsville, Maryland, USA

Relocation: Yes

Visa: H1B

Resume file: Vasuki BA Updated._1772027572345.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

VASUKI BALASUBRAMANIAN SENIOR BUSINESS ANALYST | SCRUM MASTER | STAKEHOLDER MANAGEMENT +1 (571) 538-6418 [email protected] LinkedIn: linkedin.com/in/vasuki-balasubramanian31/ GitHub: https://vasuki123.github.io/vasuki-s-portfolio/ SENIOR BUSINESS ANALYST SUMMARY Senior Technical Business Analyst with 8+ years of experience supporting loan origination, post-origination servicing, and financial operations across banking, telecom, and healthcare platforms. Proven expertise in managing daily operations and system support for Loan Origination and Servicing environments, including mortgage, vehicle loans, escrow, and ACH payment workflows. Strong background in requirements elicitation, process analysis, reconciliation, and data validation, with hands-on experience translating complex servicing and regulatory rules into functional documentation, SQL-driven validations, and UAT-ready solutions. Recognized for independently owning high-impact initiatives, improving data accuracy, reducing reconciliation breaks and operational risk, and partnering with business, engineering, and product teams to deliver stable, audit-ready systems in Agile environments. TECHNICAL SKILLS Business Analysis: Requirements Elicitation, BRD, FRD, Stakeholder Management, Business Insights Data & Analytics: SQL (Advanced), Python, Data Validation, Data Profiling, Machine Learning Assisted Analysis, Databricks Business Intelligence: MS Excel, Power BI (DAX, Power Query), Tableau, Qliksense ETL & Integration: ETL/ELT, Source to Target Mapping, Data Quality Controls Cloud Platforms: AWS, Google Cloud Platform (Big Query) Domains: Banking (Mortgage, Loans, ACH, post-origination servicing), Telecom (Subscribers, Billing), Healthcare (HIPAA) CERTIFICATIONS/ TRAINING IBM DataStage 2025 Data Integration & ETL Microsoft Certified: Power Platform Fundamentals (PL 900) Microsoft Power BI Data Analyst Associate (PL 300) In Progress PROFESSIONAL EXPERIENCE: NORTHERN TRUST BANK CONTRACT MAY 2024 PRESENT BUSINESS DATA ANALYST RESPONSIBILITIES: Led end-to-end business analysis for mortgage servicing and commercial loan initiatives, owning requirements elicitation, scope definition, and alignment between business, product, and technology teams. Performed advanced SQL analysis on mortgage and loan datasets to validate principal, interest, amortization, and payment calculations, identify reconciliation breaks and exception trends, and improve reporting accuracy by 30%. Executed escrow analysis for mortgage and vehicle loan portfolios by validating tax, insurance, and reserve balances within loan servicing systems, preventing billing errors and compliance issues. Provided daily operational and system support for enterprise Loan Origination and Servicing platforms, supporting post-origination workflows aligned with Dealertrack and RouteOne type LOS environments. Automated loan, escrow, and payment reconciliations using SQL and Excel VBA macros, significantly reducing manual effort and improving data accuracy across servicing and reporting processes. Supported AWS S3 and Databricks-based data pipelines by validating ingestion logic, transformation rules, and business mappings for mortgage, loan, and ACH datasets. Acted as a delivery-focused Business Systems Analyst within Agile teams by managing Jira artifacts, leading sprint ceremonies, resolving requirement gaps, and supporting UAT to ensure on-time, compliant releases. Delivered executive-facing dashboards in Power BI by translating business requirements into KPIs that improved visibility into loan performance, payment exceptions, and aging trends. AMDOCS, HYDERABAD, INDIA JAN 2019 SEP 2022 BUSINESS DATA ANALYST Responsibilities: Supported large scale telecom analytics and transformation programs, focusing on subscriber, usage, billing, and revenue datasets. Partnered with product, CRM, and operations teams to define business requirements, BRDs, FRDs, and functional specifications for analytics and reporting solutions. Performed deep SQL analysis on high volume subscriber and billing data to identify churn drivers, usage patterns, and revenue leakage. Developed and maintained dashboards using both Qlik Sense and Tableau, leveraging Qlik s associative analytics for exploratory analysis and Tableau for standardized, stakeholder-facing reporting across subscriber and billing datasets Proactively identified data quality issues, requirement gaps, and reporting inconsistencies, raising risks early and collaborating with cross-functional teams to drive resolution. Developed Python based data processing scripts to automate data cleansing, validation, and recurring analytical reports. Supported AWS based data environments (S3, Athena exposure) for analytics validation and reporting readiness. Collaborated with engineering teams on ETL pipelines, validating transformations and ensuring alignment with business logic. Facilitated Agile delivery by managing Jira artifacts, refining user stories, and supporting sprint planning and reviews. Translated analytical results into actionable insights that informed marketing, retention, and service improvement strategies. ANTHENA HEALTHCARE, CHENNAI, INDIA JUNIOR DATA ANALYST (June 2017 Dec 2018) Responsibilities Worked with clinical, operations, and revenue cycle stakeholders to support analytics initiatives using healthcare datasets (EHR, claims, utilization). Conducted SQL and Python based analysis to identify data quality issues, utilization trends, and reporting inconsistencies. Designed Tableau dashboards to visualize patient utilization, no show rates, readmissions, and operational KPIs for healthcare leaders. Leveraged Google Cloud Platform (BigQuery) to query and analyze large scale healthcare datasets efficiently. Validated HL7/FHIR feeds and ensured accurate data mapping to support longitudinal patient analytics. Supported HIPAA compliant data practices, including access controls, audit documentation, and secure handling of sensitive data. Partnered with data engineering teams on ETL and data modeling efforts, ensuring analytics outputs aligned with documented requirements. Independent projects in GitHub Telecom Customer Churn & Performance Jan 2026 Built and maintained analytics-ready datasets for customer segmentation, churn analysis, and campaign insights. Analyzed large-scale usage and billing data using SQL to identify behavioral patterns and high-risk segments. Designed Power BI dashboards to support marketing and performance insights through reliable, validated datasets. Translated analytical findings into actionable recommendations supporting retention and engagement strategies. Education MASTER OF SCIENCE COMPUTER SCIENCE (DATA SCIENCE CONCENTRATION) Hood College, Frederick, MD, USA BACHELOR OF ENGINEERING COMPUTER SCIENCE Anna University, Tamil Nadu, India Keywords: business intelligence sthree microsoft mississippi procedural language Maryland