Overview
Work history
Education
Skills
Websites
Accomplishments
Certification
Timeline
Generic
ASHRUMALA DAS

ASHRUMALA DAS

Guwahati,India

Overview

12
12
years of professional experience
1
1
Certification

Work history

Business Data Analyst

Green View Nursery
Guwahati, Assam
08.2023 - Current
  • Enabled founders in securing $2.5M credit for infrastructure upgrades ,operation and admin expenses by conducting business assessment
  • Reduced sourcing and procurement costs by 10% through sustainable inventory optimization, suggesting expansion to retail sales, landscaping
  • Negotiated vendor adjustments based on usage patterns;Implemented procurement controls to minimize spoilage, excess inventory
  • Developed and monetized new product lines such as indoor plants, decor, gift items aligned to demand, conducted market viability assessment
  • Performed SKU-level contribution analysis to scale high-margin categories, analyzed a 2 year service-wise profitability segmentation
  • Led strategic business reporting, conducted multi-scenario financial analysis enabling 3-5 year planning and market feasibility concern


Data Analyst(Contract)

Capital One Bank
Plano,Texas, USA
09.2019 - 07.2023

Statutory Compliance - Eliminated data governance insufficiencies by 40% ,by raising timely escalations,clearing ad-hoc data issues

  • Classified data as NPI, API, PCI and standardized data lineage by complying with business data quality,CCPA and GDPR guidelines
  • Analyzed new producer data for better product performance, acted as risk management SME for final production data
  • Categorized data as inventoried, schema applied or curated from D0,D1,D2A to D2B by streamlining operations and follow-ups
  • Proposed change order, and ensured timely feedback from teams in Refinance,Dealer,Servicing,Business Risk Office and Home Loans

Cost Optimization - Facilitated cost-saving of $3.5M by optimizing process to mask unprotected data detected through scan tool

  • Mitigated risks which helped curb costs by 30% towards regulatory fines caused by insufficient masking of data in production data
  • Conceptualized data monitoring rules and identified critical data elements in legacy data while analyzing daily reporting sheet
  • Increased efficiency by 60% by identifying roadblocks, automating repetitive tasks using SQL,Python for scanning of sensitive data
  • Enabled savings of 25% on renewed vendor contracts while analyzing third party data, ensuring future service quality and reliability
  • Reduced 35% in operational cost for services such as EC2,S3 by ensuring precise implementation of AWS infrastructure in system

Business Intelligence - Translated complex business KPIs to summarize and interpret technical loopholes by integrating tableau

  • Capitalized open source/digital technologies to mine complex, voluminous, and different varieties of data sources and platforms
  • Navigated post-migration of legacy customer database to in-house built process, ensuring data accuracy, minimal downtime


Data Analyst-Intern(Full Time)

HSBC Bank
Chicago,Illinois, USA
06.2018 - 01.2019
  • Enhanced team productivity by 50% by reducing client coordination across EMEA and APAC to two touchpoints per day while reporting KPIs
  • Increased efficiency in monthly performance reviews by promoting use of SAS and Google-based dashboards during presentation
  • Improved end-to-end data quality by collaborating with techno-functional teams to streamline enhancement across full operational cycle
  • Ensured reliable data delivery by performing thorough cleaning,mapping during extraction from source systems to target environment

Assistant Manager - Financial Analyst(Full Time)

Assam Gramin Vikash Bank
Guwahati, India
07.2013 - 08.2017

Company Overview: Owned by Ministry of Finance, Govt. of India

  • Achieved 100% compliance in annual financial reporting by documenting P&L, Balance Sheet, depreciation schedules during year-end closure
  • Increased CSR engagement by designing outreach plans, organizing 5 monthly credit-disbursement, recovery camps in underserved regions
  • Improved staff task performance by 70% by training employees on new tools; updated operational content during digital-workflow transition
  • Reduced data-quality risks in managing $250M in deposits by identifying vulnerabilities using Excel,ERP in self-help group funding processes
  • Ensured error-free delivery of $100M in subsidies to 10,000 beneficiaries by validating transactions within 20-day window
  • Strengthened credit decisions by analyzing financials histories of 300+ applicants while assessing loan viability across varied income groups
  • Facilitated approval of $350M in viable loan proposals by performing inspection, due-diligence analysis for high-value credit requests
  • Secured placement of $800M in government deposits by submitting competitive bid-response proposals to multiple public-sector entities
  • Improved project delivery accuracy by negotiating vendor terms and monitoring budgets, across multi-stakeholder engagements
  • Completed recovery of $5M non-performing loan portfolio in 3 months by leading 7-member team through targeted scrutiny, workflows
  • Minimized potential write-offs by coordinating cross-functional schedules and collection activities across targeted borrower groups
  • Reduced loan defaults by 30% by analyzing demographic trends, reallocating $1M in credit-risk exposure within reclassified segments

Education

Master of Science - Business Analytics

The University of Texas at Dallas
Richardson, Texas
08/2017 - 05/2019

Bachelor of Engineering - Computer Engineering

Nagpur University
Nagpur, India

Skills

  • AWS
  • Tableau
  • Power BI
  • SQL
  • Python
  • JIRA
  • Machine Learning
  • Generative AI

Accomplishments

Business Analysis Projects

Predictive Analytics - ShopKo retail

  • Improved pricing decisions for 100+ retail products by segmenting customer groups, developing a predictive pricing model

Database Modeling - HomeCredit dataset

  • Enhanced data validation efficiency by 15% by architecting a scalable database and optimizing SQL queries

Machine Learning - IMDB data

  • Guided future budget planning for 10 blockbuster movie sequels by analyzing revenue drivers, genre, ratings in the US entertainment industry
  • Improved film marketing strategies by building ML models using regression to identify audience-influencing factors

Data Visualization - Conoco Philips refinery

  • Enabled a 15% damage estimation by creating visual simulation dashboards to assess hurricane impact
  • Delivered a structured 90-day recovery plan by narrating insights using multi-map Tableau dashboards for crisis-response planning

Web Analytics - Southwest Wildlife Foundation of Utah

  • Drove $2M in donations by designing a digital awareness campaign, analyzing visitor behavior to support endangered bird preservation plans
  • Increased outreach effectiveness by planning targeted marketing strategies using SEM

Community : Advanced financial inclusion efforts by initiating community-development plans for IOCL and Assam Gramin Vikash Bank

Certification

Udemy

  • Data Analysis with Pandas and Python, A/B testing with Python, AWS Cloud Solutions Architect


Timeline

Business Data Analyst

Green View Nursery
08.2023 - Current

Data Analyst(Contract)

Capital One Bank
09.2019 - 07.2023

Data Analyst-Intern(Full Time)

HSBC Bank
06.2018 - 01.2019

Assistant Manager - Financial Analyst(Full Time)

Assam Gramin Vikash Bank
07.2013 - 08.2017

Master of Science - Business Analytics

The University of Texas at Dallas
08/2017 - 05/2019

Bachelor of Engineering - Computer Engineering

Nagpur University
ASHRUMALA DAS