Data Analyst

Keerthana Vella

Full-Stack Data & Software Engineer

New York ***************@*****.*** www.linkedin.com/in/keerthana-vella/

PROFESSIONAL SUMMARY

Innovative and impact-driven Data Engineering Analyst & Full-Stack Developer with 4+ years of experience delivering end-to-end data solutions, analytics platforms, and scalable software in fast-paced, regulated environments. Experienced in private wealth management and securities, applying advanced analytics, regulatory reporting, and compliance testing across financial services and fintech domains. Adept at transforming fragmented CRM and enterprise data into actionable insights using Python, SQL, Power BI, Tableau, and modern data warehouses like Snowflake and BigQuery. Experienced in building secure ETL pipelines, automating KPI dashboards, deploying RESTful APIs, and supporting production systems across AWS, Azure, and GCP ecosystems. Proven ability to work across Big Data platforms such as Hadoop, Hive, and Spark to manage distributed processing workloads and batch data pipelines, and recognized for strong cross-functional leadership, having led Agile pods, mentored junior analysts, and driven high-visibility initiatives across operations, compliance, and product teams. Experienced in fast-moving startup and high-growth environments, delivering rapid iterations of data and software products from concept to production. Skilled in modern frontend frameworks (React, Next.js, React Native) with TypeScript, TailwindCSS, and scalable backend systems on AWS and Postgres (Supabase). Experienced in end-to-end ML workflows using Python, scikit-learn, and basic applications of PyTorch and TensorFlow. Adept at applying cutting-edge AI/ML research, including Large Language Models, into production-ready workflows to serve enterprise clients and large user bases. Experienced in litigation analytics and legal operations reporting, leveraging Looker, SQL, and JIRA to transform legal and compliance data into executive-ready dashboards that drive risk mitigation and operational change. Certified in Microsoft Power BI, AWS Machine Learning, and Business Analysis (CBAP), with a consistent track record of delivering business-aligned data products that improve decision-making, ensure audit readiness, and support global scalability, a clear communicator skilled at translating technical findings for non-technical audiences, enabling smarter strategy through data. Open to feedback and proactive in enhancing the team’s capabilities through peer reviews, mentoring, and collaborative problem-solving.

EDUCATION

New Jersey Institute of Technology Sep 2023 – Dec 2024

Master’s in Management Science

R.M.K. Engineering College Aug 2017 – June 2021

Bachelor’s in Electronics and Communications

SKILLS

Programming Languages & Frameworks: Python (Pandas, NumPy, scikit-learn, PyTorch, TensorFlow), Java, C#, C, C++, R, .NET Framework, JavaScript, TypeScript, Angular, Swift (basic), React, Next.js, React Native, HTML/CSS, Objective-C (basic), Shell Scripting, MATLAB

Databases & Code Repositories: SQL Server, MySQL, PostgreSQL, Oracle, SQLite, NoSQL, Postgres (Supabase) Git, GitHub, Bitbucket

Data Engineering & ETL: ETL Pipelines, Data Warehousing, Data Marts, Dimensional Modeling, Data Integration, Data Lineage, Data Catalogs, HDFS, Hive, Sqoop, Flume, Spark, Kafka, Unstructured Data Processing (Pleadings, Legal Filings, Demand Letters), Hadoop, SAS Enterprise Guide (basic).

Data Analysis & Modeling: Data Analysis, Forecasting, A/B Testing, KPI Development, Root Cause Analysis, Campaign & Performance Reporting, Customer Journey Analysis, Litigation Analytics, Complaint Data Analysis, Legal Operations Reporting, Regulatory Reporting (UDAAP, Reg E, OCC 12 CFR 9), Content & Engagement Metrics, Statistical Modeling (Monte Carlo Simulation), Root Cause Analysis, Statistical Modeling, Risk Exposure Analysis, RFM & Cohort Analysis, Data-Driven Optimization, Compliance Testing, Wealth Management Risk Analytics, Trust & Fiduciary Compliance (OCC 12 CFR 9), Regulatory Testing, UDAAP/CFPB Alignment, Litigation & Complaint Data Monitoring.

Business Intelligence & Visualization: Power BI (DAX, Power Query, RLS), Tableau, Looker, Excel (PivotTables, Solver, VBA, Macros, Power Query), Dashboard Design, Reporting Automation, Real-Time Analytics, Interactive Visualizations, Trend Analysis, Test Panel Evaluation, Looker Dashboard Development for Legal & Compliance, Risk & Compliance Dashboards, Interactive Visualizations.

Cloud Platforms & DevOps: AWS Infrastructure (EC2, Lambda, Redshift, Athena, S3, API Gateway, CloudFront, Machine Learning), Azure (Blob, Data Factory, Synapse, AD), GCP (Big Query, Data Studio), Docker, Kubernetes, CI/CD Pipelines, Jenkins, GitHub Actions, Bitbucket Pipelines, Automated Deployment

Testing & Quality Assurance: Unit Testing, Regression Testing, UAT, Manual Testing, Shell Scripting, JBASE Scripting, QA Automation, Test Case Design, Functional Testing, Compliance Testing, Monitoring Frameworks, Risk Evaluation.

APIs, Tools & Technical Systems: RESTful APIs, JIRA, Confluence, T24 Transact, Salesforce, SAP, Excel Automation, RBAC, Data Governance, Agile, JIRA Legal Workflow Integration, Scrum, SDLC, Linux, Audit Logging, SWIFT Messaging, Market Analysis, Figma (Marketing & Compliance Reviews), Financial Compliance.

PROFESSIONAL EXPERIENCE

Data Engineering Analyst: Project C.U.R.E. April 2025 –Present

•Designed and deployed interactive Power BI dashboards using DAX, Power Query, and REST API integration to track inventory turnover, medical kit demand, and distribution analytics across 7 warehouses, improving planning efficiency by 25%. Delivered in a fast-paced, startup-like environment with rapid product iterations and stakeholder feedback loops.

•Built and optimized Python-based ETL pipelines to extract and unify data from Warehouse Management Systems (WMS), Salesforce CRM, and donor databases, improving data accuracy and reducing pipeline latency using Pandas, SQL, and Azure Data Factory.

•Automated data validation workflows in Python and SQL, ensuring high data quality for volunteer impact analysis, donor engagement metrics, and compliance reports; implemented RBAC security with Azure Active Directory.

•Created predictive models using scikit-learn to forecast shortages in high-rotation medical kits, feeding alerts into Power BI, and enabling proactive logistics decisions.

•Led cross-platform data stewardship initiatives by defining data ownership rules, implementing governance policies, and standardizing metadata documentation across Salesforce CRM, WMS, and donor databases.

•Designed role-based data access models and stewardship dashboards in Power BI to monitor data quality KPIs, compliance exceptions, and governance adherence in real time.

•Applied root cause analysis to shipping and handling delays by analyzing drill-through dashboards and delivery audit logs, reducing kit turnaround time by 15%.

•Conducted compliance checks on donor fund allocation data, ensuring transparency and alignment with organizational controls and reporting obligations.

•Reviewed marketing and fundraising materials in Figma for accuracy and adherence to donor communication guidelines and consumer protection practices.

•Managed compliance workflows in Jira, documenting review progress, flagged issues, and remediation actions for cross-functional visibility.

•Standardized data schemas and documentation practices, aligning with HIPAA and international donor reporting standards; enforced data governance across all analytics pipelines.

•Collaborated in Agile sprints using JIRA and Confluence, delivering sprint-based updates to operations, logistics, and donor engagement teams.

•Partnered with compliance and legal teams to centralize litigation case data, consumer complaints, and regulatory inquiries from Salesforce CRM, external law firms, and regulatory bodies into SQL, Looker, BigQuery, and Azure SQL datasets; implemented ETL pipelines in Python (Pandas, NumPy) using Azure Data Factory for automated ingestion and transformation.

•Designed and delivered interactive Looker dashboards powered by optimized SQL models and BigQuery views, integrating KPI development, trend analysis, and regulatory metrics (CFPB, Reg E, UDAAP) to track filings, causes of action, cycle times, and legal spend for attorneys, compliance officers, and senior leadership.

•Built text-tagging and data classification workflows for unstructured legal documents (pleadings, demand letters) in Python with scikit-learn, PyTorch, and NLP libraries, enabling predictive risk analytics and downstream integration into Power BI and Tableau dashboards.

•Collaborated with marketing, design, and compliance teams in Figma to review and refine dashboard layouts, visual assets, and branded content for compliance reporting, ensuring visual consistency and adherence to organizational guidelines.

•Provided structured feedback in Figma using annotations and version comments, enabling rapid iteration and alignment between design and technical implementation for Power BI and Looker dashboards.

•Configured and administered JIRA instances for litigation and complaint ticket tracking, integrating with Looker dashboards via RESTful APIs and CI/CD pipelines (GitHub Actions, Docker) to deliver real-time operational monitoring, compliance reporting, and governance-aligned audit logs.

Skills Applied: Python, SQL, Power BI (DAX, Power Query), Azure SQL, Azure Data Factory, REST APIs, Salesforce, scikit-learn, Excel (VBA, Macros), JIRA, GitHub, Docker, CI/CD, Data Governance, RBAC, Agile, Cloud Automation, Data Warehousing

Data Engineering Analyst Intern: VSLN International Inc. March 2025 – April 2025

•Analyzed multi-channel data from Salesforce CRM, financial ERP systems, and customer interaction logs using advanced SQL and Python (Pandas) to uncover inefficiencies in the sales pipeline and revenue attribution.

•Contributed to a high-growth startup setting, rapidly developing and deploying new analytics features within short sprint cycles to meet evolving business needs.

•Built and deployed executive-ready Tableau dashboards and Excel macros to deliver weekly ad-hoc performance updates; improved visibility into lead conversion rates and channel ROI.

•Automated data pipelines for reporting workflows using Python (openpyxl, schedule, smtplib), reducing manual reporting time by 50% and increasing delivery consistency.

•Developed forecasting dashboards in Power BI using DAX measures and M queries to visualize Q2 revenue projections and growth scenarios, enhancing financial planning accuracy by 15%.

•Enhanced SQL-based ingestion pipelines by restructuring staging logic and optimizing indexing, which shortened load time and improved refresh latency by 30%.

•Implemented data cleaning, transformation, and imputation strategies to unify siloed datasets across customer acquisition, retention, and conversion touchpoints.

•Designed interactive KPI dashboards tracking churn, funnel drop-off, and conversion trends across sales stages, aligning reports with C-suite metrics and business priorities.

•Designed forecasting models tied to key business performance metrics, applying statistical methods and predictive analytics to anticipate trends and operational outcomes.

•Built KPI dashboards with integrated regression and trend analysis to detect performance deviations and highlight actionable improvement opportunities for leadership teams.

•Participated in Agile ceremonies (standups, retrospectives) using JIRA and Confluence, ensuring sprint outcomes were aligned with evolving marketing and operations goals.

•Conducted in-depth data quality assessments across multiple systems, identifying discrepancies and implementing remediation strategies to improve data accuracy for logistics and vendor management.

•Developed reusable SQL scripts in BigQuery/Snowflake to validate data transformations and improve refresh performance in Power BI dashboards.

•Developed and enforced data governance workflows for Salesforce CRM datasets, including data lineage tracking, deduplication logic, and stewardship approval processes for critical business entities.

•Partnered with SAP ERP administrators to integrate governed master data fields into analytics dashboards, ensuring consistency in revenue, inventory, and customer data reporting across systems.

•Collaborated with cross-functional teams to document transformation logic, metadata, and profiling outputs for governance audits.

•Collaborated with product and analytics stakeholders to identify data integration gaps and document system-wide reporting logic and business rules.

•Contributed to version-controlled ETL components via GitHub, aligning updates with deployment timelines and cross-functional review cycles.

Skills Applied: SQL, Python (Pandas, openpyxl), Tableau, Power BI (DAX, M Query), Excel Macros, GitHub, Salesforce, ERP Integration, Agile, JIRA, Data Cleaning, ETL Optimization, Forecasting, Dashboard Design, CI-ready Scripting

Product Engineer – Data & Software Solutions: Temenos (Banking & Financial Technology) Aug 2021 – Aug 2023

•Led technical investigations into transactional anomalies across T24 Core Banking (Private Wealth, Retail Lending, Treasury) using advanced Oracle SQL, JBASE scripting, and structured TAFC/TAFJ logs, reducing repeat failures by 40% through log-based RCA and remediation scripting.

•Built robust SWIFT MT/MX validation dashboards in Tableau and Power BI, layered with SLA thresholds, failure classification, and Basel III breach indicators—used by compliance teams for real-time resolution and quarterly audit readiness.

•Designed and maintained automated regression testing frameworks using Java, Shell scripting, and JBASE, covering over 150 banking workflows across modules like Payments, Investment Servicing, and Funds Transfer: improved QA efficiency by 45%.

•Integrated real-time regulatory compliance alerts into T24 UI using data from Oracle Data Lakes and designed schema structures for logging fund exposure, counterparty risk, and FATCA-related transactions.

•Performed detailed data lineage and system flow analysis across T24 Core Banking, SWIFT validation, and Basel III compliance systems.

•Partnered with UI/UX and compliance teams to review financial product interfaces in Figma, ensuring regulatory compliance and alignment with brand guidelines across multiple banking modules.

•Utilized Figma to annotate design elements and provide technical feedback during the review of marketing and product-facing materials, expediting approval workflows for regulated content.

•Authored transformation rules, mapping specifications, and data validation scripts to ensure accurate migration of regulatory datasets into MDM and compliance reporting platforms.

•Partnered with compliance and risk teams to support trust and fiduciary oversight, incorporating regulatory standards such as OCC Trust Rules (12 CFR 9) into reporting and testing frameworks.

•Utilized SAS Enterprise Guide (basic exposure) alongside SQL and Python for compliance monitoring, data validation, and root cause analysis in private banking and securities workflows.

•Developed controls testing reports covering wealth management transactions, fiduciary data integrity, and compliance metrics, improving alignment with trust regulatory expectations.

•Partnered with data engineers to enhance ingestion pipelines, optimize query performance, and maintain audit-ready data dictionaries for governance.

•Partnered with compliance and risk teams to analyze securities, trust, and private banking transactions, ensuring adherence to UDAAP, OCC (12 CFR 9), and CFPB standards.

•Built and optimized SQL/Python queries on wealth management datasets to support compliance reviews, monitoring, and anomaly detection across customer portfolios.

•Collaborated with cross-functional stakeholders to test and validate regulatory reporting outputs for private wealth products, ensuring accurate and transparent disclosures.

•Supported enterprise-scale deployments serving hundreds of thousands of active users globally.

•Led cross-system data integration initiatives and authored mapping documentation for MDM and enterprise repositories, ensuring seamless alignment between source and target systems.

•Conducted root cause analysis on data discrepancies, defining and implementing remediation strategies to improve data accuracy and reliability across reporting workflows.

•Streamlined onboarding and upgrade deployment for 10+ global banking clients by developing Git-managed configuration scripts, mapping legacy data to Temenos structures, and configuring workflow triggers and notifications across modules.

•Improved front-end UI/UX by analyzing JIRA backlog heatmaps, conducting user interviews, and resolving more than 60+ usability tickets, which led to a 30% improvement in RM team satisfaction and fewer support escalations.

•Led litigation analytics and compliance reporting by integrating SWIFT compliance logs, regulatory breach alerts, and legal case metadata into audit-ready datasets using Oracle SQL, JBASE, and ETL pipelines, improving resolution time for high-risk cases across Basel III and FATCA-regulated workflows.

•Built SQL models and multi-layer dashboards in Tableau, Looker, and Power BI to monitor regulatory enforcement actions, complaint escalations, liquidity breaks, and case lifecycles, providing actionable insights to compliance officers and senior leadership.

•Automated compliance data packaging for quarterly audit cycles by transforming raw message logs into structured, audit-traceable formats (heatmaps, summary statistics) using Python, Oracle SQL, and data visualization best practices; ensured alignment with SOX, MiFID II, and internal governance policies.

•Collaborated with legal operations to standardize metadata and tagging for unstructured compliance documents, enabling faster retrieval and analysis during litigation reviews; integrated results with JIRA/Confluence documentation to support continuous audit coverage and traceability across global teams.

•Contributed to versioned documentation of compliance and audit logic in Confluence, reviewed by internal audit and legal teams, ensuring continuous alignment with regulatory shifts (Basel III, SOX, MiFID II).

•Supported cross-functional integration between compliance, core engineering, legal, and front-office teams to deliver scalable logging, monitoring, and reporting capabilities across a multi-tenant SaaS environment.

Skills Applied: Oracle SQL, JBASE, Java, Shell Scripting, Power BI, Tableau, Git, Bitbucket, Jenkins, JIRA, Confluence, SWIFT MT/MX, T24 Core Banking, Basel III, SOX, FATCA, Audit Compliance, Data Governance, REST APIs, CI/CD, TAFC/TAFJ, Log Analytics, KPI Modeling, Agile, Risk Scoring, Version Control, Data Lake Integration, Structured Logging

SDE (Data Analytics & Application Development) Trainee: Hubstream. Mar 2020 – Aug 2021

•Developed modular, reusable .NET (C#) components for a case management platform used by Australian law enforcement, enabling real-time case tracking, audit logging, and workload monitoring across investigative teams.

•Built and optimized SQL Server stored procedures and relational queries for tracking evidence files, SLA compliance, and multi-departmental data ownership—resulting in improved cross-agency transparency.

•Designed and implemented data validation rules for Aadhaar-linked records in C# and SQL, ensuring secure and auditable storage of PII in line with national privacy and legal admissibility standards.

•Developed and integrated RESTful APIs to support real-time communication between Angular-based front-end dashboards and backend systems, enhancing responsiveness for investigator-facing tools.

•Contributed to UI layer improvements by partnering with Angular developers, using live feedback and sprint-based retrospectives to optimize UX flows across evidence detail, case assignment, and closure pages.

•Conducted user acceptance testing (UAT) and manual QA validation for new analytics features, documenting edge cases, verifying data flows, and reducing front-end release defects by 20%.

•Engineered automated product usage analytics using SQL, stored procedures, and Excel macros, uncovering feature adoption gaps and enabling the UX team to prioritize improvements that increased task completion rates by 30%.

•Built Tableau dashboards to visualize backlog trends, SLA adherence, and team resolution speed, informing weekly leadership reviews and audit preparations.

•Actively participated in Agile ceremonies (sprint planning, retrospectives, backlog grooming) using JIRA, improving delivery consistency and aligning stakeholder feedback loops.

•Collaborated with compliance and legal teams to develop court-facing report templates for digital evidence admissibility and regulatory audits, improving litigation preparedness across partner agencies.

•Documented ETL data flows, front-end data mappings, and user roles in Confluence, supporting cross-team onboarding and system scalability.

Skills Applied: C#, .NET Framework, SQL Server, REST APIs, Angular, Tableau, Excel (VBA, Macros), Manual Testing, UAT, Agile, JIRA, SDLC, PII Compliance, Data Governance, Stored Procedures, Bug Triage, UX Collaboration, Legal Audit Documentation

PROJECTS

Strategic Financial & Data Analysis for Business Optimization September 2023 – December 2024

Master’s-Level Projects Accounting Finance Financial Modeling Financial Technology Data Integration Supply Chain & Product Management

Developed financial technology models using Excel (Solver, VBA, Pivot tables), SQL, and SAP to analyze financial statements, including balance sheets, income statements, and consolidated reports for USPS and Johnson & Johnson (J&J). Assessed cost structures and financial efficiency, identifying opportunities for a 15% reduction in expenses through optimized expense tracking, budget planning, and financial forecasting strategies.

Constructed predictive models in Python, applying Monte Carlo simulations and risk-return analysis to forecast Apple Inc.’s stock performance. Analyzed key financial growth drivers, market analysis, competitive advantages, and associated risks, estimating a 12-18% increase in stock valuation over the next fiscal year.

Designed interactive reporting and data analytics models to support real-time analytics, enhancing financial monitoring capabilities and improving decision-making efficiency by 10%.

Spearheaded product lifecycle management and supply chain optimization efforts for Kart2Go, leveraging SAP, SQL, and Power BI to streamline procurement workflows and enhance vendor coordination. Implemented data-driven demand forecasting and predictive analytics, incorporating the 3-Echelon Model to optimize inventory distribution across suppliers, warehouses, and retailers, forecasting a 20% reduction in procurement delays and improving supply chain responsiveness.

Established a responsibility matrix framework within JIRA, integrating product roadmap planning, agile methodology, workflow automation, and forecasting techniques to improve cross-functional collaboration. Enhanced project transparency and accountability by reducing project ambiguity by 25%, ensuring seamless task delegation, dependency tracking, and lifecycle management for efficient product development.

Used PyTorch and TensorFlow in academic projects to develop and test machine learning models for demand forecasting and retention scoring.

Led the Green Future Project, applying MS Project, Gantt Charts, and Six Sigma principles to track milestones, allocate resources, and conduct a feasibility study for Organic Plastic Solar Cells. Performed an in-depth SWOT analysis, assessing market expansion potential, sustainability benefits, and adoption feasibility, projecting a 30% increase in adoption rates compared to conventional solar technologies.

Contact this candidate