Lakshmi Varaha Krishna Chittella

1. Data Engineer

   Softtechers LLC

   Dec 2025 – Present

   • Engineered Python and SQL pipelines integrating case, customer and activity records from PostgreSQL and REST APIs for operational analytics.
   • Built paginated API extractors with authentication, bounded retries, exception handling and structured execution logs.
   • Integrated case assignment, status-change and resolution events into consistent datasets for downstream reporting.
   • Modeled current case records alongside event histories to support point-in-time analysis and operational reporting.
   • Created staging transformations using SQL CTEs, joins, window functions and aggregations to prepare analytical datasets.
   • Standardized customer identifiers, case statuses, timestamps and source fields across disparate application systems.
   • Implemented null, duplicate-key and source-to-target reconciliation checks to prevent invalid records from reaching reports.
   • Replaced full reloads with timestamp-based incremental extraction and SQL upserts for new and modified records.
   • Maintained scheduled runs, dependency checks, execution logging and controlled reprocessing for failed data refreshes.
   • Published SQL reporting views for case volume, open backlog, resolution trends and service-level performance.

2. Data Engineer

   TechRoots Inc.

   Jan 2025 – Nov 2025

   • Supported 4 production ETL/ELT pipelines in Snowflake delivering customer, sales and billing datasets for reporting.
   • Developed SQL transformations for staging and reporting tables using joins, aggregations and business-rule validations.
   • Applied PySpark and Python to clean source fields, standardize data types and process structured datasets.
   • Supported incremental data-loading workflows and validated source updates before loading reporting tables.
   • Reconciled source and target records with SQL counts, aggregates, key comparisons and duplicate/null checks.
   • Diagnosed pipeline failures involving SQL errors, missing inputs and dependency issues; verified controlled reruns.
   • Documented recurring failure scenarios, validation queries and recovery steps to streamline troubleshooting.

3. Associate Systems Engineer

   Tata Consultancy Services, Kolkata, India

   Oct 2022 – May 2023

   • Validated Oracle batch ETL loads of customer and transaction data into operational reporting tables.
   • Wrote SQL joins and aggregations; checked record counts, null fields, duplicate identifiers and key consistency.
   • Investigated batch failures with senior engineers, verified completeness after reruns and supported historical reprocessing.
   • Maintained ETL mappings, test evidence and operational runbooks for troubleshooting and team knowledge transfer.

Technical skills