Data Analytics · Business Intelligence · Cloud Analytics

I turn data into clearer decisions

I analyse data with SQL, spreadsheets and BI tools, building on experience in search quality, AI data evaluation and risk operations. I am studying Data Science and Artificial Intelligence at IIT Guwahati.

Analytical scope Evidence to action
Portfolio riskMonitor
Where is exposure concentrated?
Market opportunityPrioritise
Where is demand both large and accessible?
Search and AI qualityEvaluate
Does the result match intent and context?
Common outputEvidence, limitations and a clear next step
An illustrative overview of Karla's analytical scope across portfolio risk, market opportunity and search or AI quality evaluation.

Selected Analysis

Analysis applied to practical questions

Three documented projects combine SQL, data quality and business interpretation across portfolio risk, market opportunity and contact-centre performance.

Loan portfolio monitoring

BigQuery + Looker Enterprise · Training dataset
Looker dashboard showing $3.08 billion in outstanding portfolio exposure, exposure by loan status and the ten states with the largest exposure
Exposure, loan status and geographic concentration. Open the image for a closer view.

Portfolio risk analytics

Loan Portfolio Risk and Concentration Monitor

I validated 270,299 loan records and built reusable risk tables in BigQuery. An interactive Looker dashboard brings exposure, loan status and geographic concentration together for portfolio monitoring.

  • SQL
  • Data modelling
  • Quality checks
  • Dashboard design
View the case study

Search demand by market

Estimated monthly searches · Same scale for all markets
TotalNon-brand
France: 69.7% of estimated demand is non-brand, supporting the France-first recommendation.

Market opportunity analytics

SEO Market Opportunity Analysis

I compared keyword data representing 2.15 million estimated monthly searches across Spain, France and the UK. Separating total demand from non-brand opportunity supported a France-first recommendation, with a 69.7% non-brand share.

  • Data cleaning
  • Segmentation
  • SQL
  • Commercial analysis
View the case study

Known inbound human routes

99,967 routes · All captured periods
Agent endpoint is a routing outcome; it does not establish that the customer's issue was resolved.

Operational performance analytics

Contact Centre Performance in Power BI

I modelled 197,278 telecom interactions in Power BI and separated abandonment before agent contact from losses later in the journey. The findings support distinct priorities for support access and Sales transfers, with metric definitions and limitations documented.

  • Power BI
  • Data modelling
  • Metric validation
  • Operational analysis
View the case study

Relevant Experience

Experience in evaluation and quality

My professional experience centres on search and AI evaluation, quality assurance and risk-sensitive investigation. Recent projects extend that foundation into SQL, cloud analytics and BI reporting.

Independent Contractor

Search Quality and AI Data Analyst

Delivered search quality, personalised search and AI data evaluation projects for TELUS Digital, Lionbridge, Appen, Leapforce and Outlier. Assessed relevance, intent, accuracy and language quality, documented edge cases and supported multilingual evaluation workflows.

Growth Leads

Quality assurance and validation

Reviewed more than 1,500 structured pages for accuracy and consistency, identified recurring errors and helped improve templates, validation routines and documentation.

TransUnion

Fraud Operations Analyst

Reviewed sensitive information and investigated cases requiring accuracy, consistency and careful judgement.

Methods and Tools

Tools for practical analysis

Tools serve a defined question: retrieve reliable data, explore patterns and communicate a result that someone can review and use.

Foundation

Query and modelling

Retrieve, combine and structure data for a defined analytical question.

  • SQL
  • BigQuery
  • Data modelling
Quality

Data preparation and quality

Clean, compare and validate records, with assumptions and checks documented.

  • Excel
  • Google Sheets
  • Data cleaning
  • Validation
  • Python foundations
Reporting

BI and reporting

Build views that make patterns, comparisons and limitations clear.

  • Power BI
  • Looker Enterprise
  • Looker Studio
Delivery

Digital analytics and delivery

Interpret digital performance and keep analytical work traceable and reviewable.

  • GA4
  • Google Search Console
  • GitHub
  • Documentation

From question to recommendation

Select a stage to explore the method

  1. Frame Define the question Clarify the question and the decision. View detailsHide details

    I define the question, the audience and the action the analysis must support before choosing metrics or methods.

    Business question · Scope · Success criteria
  2. Prepare Prepare reliable data Check and organise the evidence. View detailsHide details

    I inspect structure, standardise fields, identify duplicates, document assumptions and preserve enough context to explain every transformation.

    Cleaning · Validation · Joins · QA
  3. Analyse Explore patterns Compare patterns and test assumptions. View detailsHide details

    I compare segments, markets, intent and performance so the largest figure is not automatically mistaken for the strongest opportunity.

    SQL · Spreadsheets · Exploration
  4. Explain Explain the findings Connect findings with a useful next step. View detailsHide details

    I connect the result to commercial context, communicate limitations and build a recommendation that can guide the next step.

    Visualisation · Narrative · Recommendation

Education and Development

Education and professional development

Current degree study and completed programmes support my development in statistics, data preparation, modelling and business intelligence.

In progress

BSc (Hons) in Data Science and Artificial Intelligence

IIT Guwahati · Remote

Degree study in data science and artificial intelligence, building a foundation in programming, statistics and analytical methods.

Completed

Google and Google Cloud programmes

  • Google Data Analytics Professional Certificate
  • Google Business Intelligence Professional Certificate
  • Google Cloud Data Analytics Professional Certificate
  • Data Analytics and Visualization Specialization

Analysis, data modelling, dashboards, reporting and cloud workflows.

Completed

Microsoft professional certificates

  • Microsoft Excel Professional Certificate
  • Microsoft Power BI Data Analyst Professional Certificate

Spreadsheet analysis, data preparation, modelling and BI reporting.

Full-Stack Software Developer

Code Institute

Technical foundations in databases, APIs, version control and reproducible delivery.

Doctoral research in Cognitive Psychology

Selinus University

Research on AI, cognition and human reasoning, supporting question design, source evaluation and careful interpretation of evidence.

Contact

Need a clearer answer from your data?

Let's discuss your question, the available evidence and how analysis could help.