App LogoApp name
SP

Shishira P

Open to work1 years experience

Data Engineer and Data Analyst

Mysore, KarnatakaTarget Roles: Backend Engineer • Full-Stack Developer • Frontend Specialist

Aspiring Data Engineer and Data Analyst

GitHubLinkedIn
Resume
Email

Standing Rank

Rank Not Available

Developer Badges

Badges Pending

Skills & Technologies

32 skills
sqlpythonhtmlcsstableaupower bicjavamicrosoft sql servermysqletl pipelinesdata warehousingdata modelingdata integrationdata cleaningdata validationbatch processingdata analysisedakpi analysistime-series analysisstatistical analysisbusiness intelligencewindow functionsjoinsaggregationssegmentationranking analysisgitgithubjupyter notebookvs code

Work Experience

Work Experience Not Populated

Professional job history, career timeline, and previous industry roles will show here once linked or added.

Projects

Data Warehouse (SQL – Multi-Layer Architecture)

SQL
  • Built ETL pipelines using stored procedures and BULK INSERT for data integration from CRM and ERP sources
  • Designed staging tables for structured raw data ingestion and batch processing
  • Implemented truncate-and-load strategy for consistent pipeline execution
  • Added error handling and execution logging for reliability
  • Performed data cleaning, validation, and quality checks using SQL (TRIM, CASE, ISNULL)
  • Implemented deduplication using ROW NUMBER() and handled inconsistent data
  • Applied business logic transformations to standardize datasets
  • Validated and corrected date formats
  • Designed Star Schema (fact and dimension models) for analytics
  • Created dimension and fact views integrating customer, product, and sales data
  • Enabled data integration across CRM and ERP sources
  • Optimized datasets for reporting and business intelligence

Exploratory Data Analysis (SQL)

SQL
  • Performed data exploration and validation using INFORMATION SCHEMA
  • Analyzed data distribution across country, category, and products
  • Evaluated date ranges and customer demographics using MIN, MAX, DATEDIFF
  • Prepared structured datasets for further analysis

Data Analytics & Business Intelligence (SQL)

SQL
  • Calculated key KPIs including sales, orders, customers, and average price
  • Performed time-series and cumulative analysis using window functions
  • Conducted YoY analysis using LAG() to identify growth trends
  • Built customer and product segmentation models and identified top performers

Leaderboard Standings

Leaderboard Position Pending

Global test scores, peer standing percentiles, and algorithm leaderboard ranks are updated dynamically.

Assessment Highlights

Assessments Not Completed

Coding evaluations, system assessment results, and conceptual score badges will appear here after taking a test.

AI Collaboration Score

AI Collaboration Score Pending

Developer coding behavior, assistant cooperation, and AI pair-programming indicators are evaluated during live coding sessions.

Role Compatibility Profile

Role Compatibility Analysis Pending

Custom matching reports, candidate role compatibility percentiles, and core engineer strength profiles are processed once conceptual code screenings are complete.

Achievements

AWS Certified Cloud Practitioner

AWS Certified Cloud Practitioner

Anthropic Certified AI Fluency: Framework and Foundations

Anthropic Certified AI Fluency: Framework and Foundations

About Details

Professional Bio

Aspiring Data Engineer and Data Analyst with hands-on experience in ETL pipeline development, data warehousing, and advanced data analytics using SQL. Skilled in building data pipelines, performing exploratory data analysis (EDA), and generating business insights through KPI tracking.

B.Tech in Computer Science Engineering

JSS Science and Technology University (2022 - 2026)

Pre-University

Mahajana PU College, Mysore (2019 - 2021)

Languages: English, Hindi
Email: Locked