Data Analyst - SQL, Python, Power BI

AIDA STENKOVA DATA ANALYST

+1-464-***-**** ************@*****.*** linkedin.com/in/aida-ste

Data Analyst with 5+ years of experience in data quality and process optimization for insurance and telecom sectors. Specialized in translating business requirements into data-driven insights.

● SQL Data Analysis: Advanced proficiency in complex query writing, data validation frameworks, ETL pipeline design for large- scale datasets

● Python Data Automation: Skilled in Pandas for data cleaning, building reusable quality check scripts, developing data pipelines

● Business Intelligence: Power BI dashboards tracking KPIs and performance metrics, real-time visibility into operational bottlenecks and data quality

● Database Management: Snowflake data warehousing, JDBC connections, Oracle and MySQL optimization, designing data models

KEY ACHIEVEMENTS

● Built data quality validation framework using SQL processing 50K+ insurance claims records weekly, flagging integrity issues preventing downstream errors for customer claims

● Developed automated data quality checks in Snowflake scanning customer transaction and claims data across multiple systems, enabling claims team to focus on high-impact issues

● Implemented Python-based data pipeline for daily quality reports catching critical data discrepancies in customer records and transaction flows before impacting claims processing operations

● Analyzed billing records using SQL identifying data patterns that revealed billing accuracy risks and revenue reconciliation gaps

● Created Power BI dashboards visualizing data quality metrics and operational bottlenecks across claims workflow, enabling real-time visibility for product and operations teams

● Designed data validation rules using SQL and Python ensuring accuracy and consistency of customer transaction data flowing through backend systems and API integrations

● Identified 20+ critical data issues across claims and billing systems preventing incorrect processing and customer record errors

● Developed ETL processes in Snowflake integrating customer and transaction data from multiple sources, standardizing data formats for consistent reporting across teams

Expertise in SQL-based data analysis, ETL pipeline architecture, Power BI dashboard design, data quality framework development, anomaly detection, process optimization, and cross-functional collaboration. Authorized to work for any U.S. employer without visa sponsorship. PROFESSIONAL EXPERIENCE

COGNIZANT January 2026 - June 2026

DATA OPERATIONAL ANALYST

ERP-integrated food distribution and logistics platform managing supply chain operations across regional markets

● Designed Power BI dashboards tracking inventory, fulfillment, and logistics KPIs across distribution operations.

● Extracted, transformed, and validated ERP data using SQL and Python, ensuring reporting accuracy across supply chain processes.

● Automated recurring operational reports, reducing manual reporting effort and improving visibility into delivery bottlenecks.

● Performed data quality analysis across inventory, vendor, and order datasets, identifying inconsistencies and improving reporting reliability.

● Gathered reporting requirements from operations stakeholders and translated them into dashboards, metrics, and validation rules.

● Supported migration of operational data to Snowflake by validating datasets, reconciling records, and testing ETL outputs.

● Analyzed supplier and fulfillment performance data, identifying trends affecting SLA compliance and operational efficiency. UTICA NATIONAL INSURANCE GROUP Chicago, Illinois January 2023 – October 2025 DATA ANALYST

Insurance claims processing platform handling high-volume claims data for national insurance operations Led data quality and validation initiatives for insurance claims processing system, working cross-functionally with claims, engineering, and operations teams in the Agile environment.

AIDA STENKOVA 464-***-**** ************@*****.***

● Built data quality validation framework using SQL analyzing claims workflow data, identifying root causes of processing delays through data anomaly analysis

● Implemented automated data quality checks in Snowflake validating 50K+ customer records, claims transactions, and billing data, catching data inconsistencies before processing

● Designed Power BI dashboards with real-time metrics tracking data accuracy, processing bottlenecks, and validation gaps across claims processing pipeline

● Developed Python scripts automating weekly quality reports pulling data from Snowflake and JDBC databases, enabling proactive issue identification

● Created data validation rules ensuring integrity of customer and claims data across API integrations between backend services and claims systems

● Performed SQL analysis on insurance claims data discovering data quality patterns enabling process improvement recommendations

● Participated in Agile ceremonies translating business requirements into data validation standards and quality metrics

● Documented data quality procedures and validation guidelines establishing single source of truth for claims processing standards

● Utilized Jira and X-Ray managing quality checks, data issues, and validation procedures, coordinating with engineering teams

KCELL Almaty, Kazakhstan October 2020 – December 2022 DATA QUALITY ANALYST

Major telecom provider serving 45K+ active customers with diverse mobile and data services Analyzed telecom billing and customer data systems ensuring accuracy of transaction records and customer information for mobile service operations.

● Analyzed billing database records using SQL discovering data discrepancies across 45K+ customer base preventing billing errors and revenue leakage

● Created data validation procedures for telecom transaction systems ensuring accuracy of charges and customer records across multiple billing cycles

● Performed data analysis identifying patterns in customer data that revealed billing issues affecting service accuracy for large customer segments

● Developed SQL queries validating transaction integrity across billing systems catching data inconsistencies before customer- facing p rocessing

● Collaborated with operations and billing teams translating business requirements into data quality validation standards and accuracy metrics

● Worked with Git managing SQL scripts and data validation procedures for team reproducibility 2SKY Almaty, Kazakhstan October 2018 – October 2020 QA Analyst

Interior Design Studio Luxury Home & Commercial Design Executed quality assurance and data validation for client web applications covering functional requirements verification and process design.

● Developed test cases and data validation procedures based on functional requirements, covering REST API, UI, and database testing across 8+ concurrent client projects.

● Executed REST API testing using Postman validating request/response integrity, JSON payload structure, and endpoint behavior across backend services and system integrations.

● Performed database testing using SQL and XPath to verify data accuracy, consistency, and system component interactions across application layers.

● Identified 20+ critical data and system issues across client applications; tracked and logged defects in Jira and Trello with detailed reproduction steps, improving data accuracy before production releases.

● Implemented BDD methodology with JSON reporting for quality metrics visibility to project stakeholders.

● Pioneered remote cross-browser UI tests using Selenium Grid, achieving 20% improvement in cross-browser compatibility.

● Integrated test execution into CI/CD pipelines ensuring automated quality gates across development and deployment cycles.

● Conducted performance testing with Apache JMeter, identifying and mitigating bottlenecks for a 10% improvement in system responsiveness.

AIDA STENKOVA 464-***-**** ************@*****.***

● Collaborated with developers and project managers in Agile environment participating in sprint planning and retrospectives. EDUCATION

Bachelor’s Degree in Civil Engineering, Kazakh Leading Academy of Architecture and Civil Engineering, KLAACE, September 2011 – June 2015

PROFESSIONAL DEVELOPMENT

Python and Data Analytics, Astana Hub — SQL fundamentals, database design, Python automation for data workflows COMMUNITY LEADERSHIP

Data Quality and Testing Mentor — Guided 3+ junior QA engineers and data analysts on test automation best practices, data validation frameworks, and ETL pipeline design, helping team members advance from junior to mid-level roles. Process Documentation and Knowledge Base — Established comprehensive documentation standards for data quality procedures and validation guidelines serving as reference material for cross-functional teams, reducing onboarding time for new team members. TECHNICAL SKILLS

Data Analysis: SQL (JOINs, CTEs, Window Functions, complex queries), Snowflake, JDBC connections, Oracle, MySQL, data modeling, schema design

Automation: Pandas, NumPy, data cleaning scripts, ETL automation, quality check scripts Business Intelligence: Power BI, dashboard design, KPI tracking, performance metrics Platforms: Snowflake, Power BI, Python,Java, SQL, Git/GitHub, Jira, X-Ray, Trello, AWS Methodologies: Agile/Scrum, ETL design, data quality frameworks, requirements analysis

Contact this candidate