Skip to content

Bharath Alapati

Data Analyst • drivetube.ai/•••••

Professional Summary

Data Analyst with 6 years of experience delivering custody, commission, and advisor-level analytics for wealth-management, broker-dealer, and RIA platforms. Adept at translating complex financial requirements into scalable Snowflake data models, SQL pipelines, and Power BI dashboards that improve payout accuracy, regulatory readiness, and executive visibility. Combines end-to-end data-flow expertise with strong stakeholder communication to drive reliable, high-quality reporting across finance, compliance, and operations teams.

Technical Skills

Programming Language: Python,SQL
Databases: Snowflake,Microsoft SQL Server
Data Warehousing: Data Warehousing,Dimensional Modeling,Star Schema,Dimension Tables
Data Analysis & Visualization: Data Analysis,Power BI
Data Integration & ETL: Data Mapping
Project Management & Collaboration: Gap Analysis,Jira,Confluence
HCM Modules & Functional Areas: Compensation

Work Experience

LPL Financial Services
Data Analyst
Dec 2023 – Present
Supported enterprise wealth-management analytics for the broker-dealer’s compensation and custody reporting platforms.
Tech Stack: Snowflake, SQL, Power BI, Jira, Confluence
  • Analyzed end-to-end data flows spanning custody, advisor accounts, transactions, and commissions to ensure consistent inputs to enterprise reporting.
  • Authored and optimized Snowflake SQL queries that powered daily broker-compensation and payout calculations used by finance and compliance teams.
  • Designed dimensional data models capturing broker-dealer hierarchies, payout schedules, and RIA reporting rules, improving schema clarity for downstream users.
  • Built interactive Power BI dashboards surfacing advisor productivity, commission trends, and reconciliation exceptions for executive stakeholders.
  • Performed gap analysis between Pershing source feeds and internal compensation systems, reducing data discrepancies observed during audits.
  • Facilitated cross-functional reviews, documenting source-to-target mappings and business rules that strengthened regulatory reporting accuracy.
Optimum Info Systems Pvt Ltd
Chennai, India
Data Analyst
Jun 2020 – Jul 2023
Provided analytics solutions for RIA operations, delivering fee-based revenue, performance, and advisor-growth reporting across multi-custodian data sources.
Tech Stack: Snowflake, SQL, Power BI
  • Engineered Snowflake data models supporting advisor revenue, fee-based billing, and commission calculations, enabling unified RIA performance views.
  • Developed Power BI dashboards that highlighted advisor growth, AUM changes, and compensation trends, increasing leadership visibility into key KPIs.
  • Mapped and validated custodian feeds against internal schemas, ensuring complete and accurate data ingestion for wealth-aggregation workflows.
  • Authored data-lineage documentation and transformation logic used during regulatory audits, accelerating evidence retrieval for compliance teams.
  • Optimized high-volume SQL queries, cutting report runtimes and lowering warehouse compute costs during month-end processing cycles.
  • Led stakeholder workshops to gather new reporting requirements and prioritize backlog items, improving delivery predictability across sprints.
Luxoft India Pvt. Ltd
Chennai, India
ETL / Data Integration Engineer
Oct 2018 – May 2020
Contributed to ETL and reporting initiatives that supported government-linked financial-inclusion programs and statutory compliance reporting.
Tech Stack: SQL, Excel, Reporting Tools
  • Built and maintained SQL-based extracts and load procedures transferring financial-program data into centralized reporting stores.
  • Executed data validation and reconciliation checks that safeguarded statutory filings against source-system discrepancies.
  • Generated operational dashboards and ad-hoc Excel reports to track program performance and funding utilization for senior stakeholders.
  • Documented ETL workflows, data dictionaries, and error-handling procedures, enhancing knowledge transfer within the analytics team.
  • Collaborated with QA teams to design test cases and perform system integration testing of new data pipelines before production release.
  • Provided on-call production support, rapidly resolving data-quality issues and maintaining SLA adherence for nightly data loads.

Education

Indiana Wesleyan University
Master of Science in Information Technology Management • Marion, IN • 2025

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

Everything on Drivetube

Six products, two of them free forever. Start wherever you are.

Read the docs →
  • Your free digital resume

    at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept.

    Documentation
  • Verified jobs, posted in the last 3 days

    verified openings crawled ATS-by-ATS from 140,000+ real company career pages across 50+ ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed.

    Documentation
  • Written by senior career writers

    human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile.

    Documentation
  • Drivetube OneFrom $39.99 / 3 mo

    Daily matched jobs, tailored resumes, or we apply for you

    Drivetube's paid service. Community sends daily Jobsheets of fresh jobs matched to your profile on WhatsApp and email, with the Drivetube Community ($39.99 for 3 months or $69.99 for 6 months; ₹999 or ₹1,899 in India). Jobhunt is one-time application credits with Community included: one credit tailors one resume and its cover letter (100 for $99 with 3 months of Community, 250 for $199 with 6 months). Let Us Apply is an add-on to Jobhunt: a human expert applies 250 times for you on your credits ($0.60 each, $150). Everything lives on one dashboard at drivetube.ai/drivetubeone.

    Documentation
  • For employers — no job postings, no applications

    hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do.

    Documentation
  • Documentation

    every product explained in full, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.

  • Playbooks

    tactical job-search guides. Each post is one named tactic with the situation it applies to, the exact steps, a copy-paste message and honest failure modes. Free, no account.

The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.

Pricing is identical on the web, iOS and Android — no app-store markup. Monthly Community membership is purchased in the iOS app only; the website sells annual plans. The Android app has no in-app purchase, so Android members subscribe on drivetube.ai and then sign in to the app with full access. Membership follows your account, not your device.