Data Engineer Solutions Architect

CHANDRA KISHOR MISHRA

+1-716-***-**** ********.*******@*****.*** LinkedIn

Professional Summary

Detail-oriented and solution-driven Data Engineer with 9+ years of experience designing and developing robust data pipelines, data modelling, ETL workflows, report generation and database systems across healthcare, education, and finance domains. Proficient in Python, SQL and cloud technologies (AWS, Databricks), with a strong background in building scalable data platforms, ensuring data quality, developing RESTful APIs using Django REST Framework and supporting advanced analytics and reporting systems. Professional Experience

Central New York Regional Information Center (CNYRIC) Data Engineer Syracuse, NY Aug 2023 – Present

- Designed the data model and maintained data pipelines for large-scale education datasets using SSIS and Python, automated extraction and transformation logic from Denodo views into MSSQL staging tables.

- Collaborated with cross-functional teams to ensure data accuracy, validation, and secure delivery, developed logging and alert systems for nightly ETL workflows and SFTP file transfer reliability. CitiBank Corps Data Analyst Pune, India Jan 2022 – Dec 2022

- Developed a subledger system application from scratch, creating new requirements/APIs in Python to feed data into the database and integrating Apache Kafka for streamlined data ingestion and real-time processing. This resulted in a 30% reduction in accounting errors and a 25% increase in reporting efficiency, ensuring compliance with GAAP principles and generating comprehensive reports in line with FASB and regulatory rules using ETL (Star Schema).

- Migrated the entire conventional system from Sybase to MySQL and Oracle, performing rigorous testing and performance upgrades, and enhanced query performance by analyzing DBQLs and explain plans, resulting in a 40% reduction in CPU time. Teradata Senior Data Engineer Pune, India Feb 2017 – Jan 2022

- Implemented new requirements in Informatica PowerCenter and Unix Shell Scripts after data modelling, supplying data to downstream applications for the CI/CD pipeline, and designed separate pipelines for Redshift and Snowflake.

- Wrote Teradata queries to aggregate data using Bteq, TPT, reducing dashboard latency with Apache Spark and Hadoop, enhancing data processing speed and scalability, resulting in significantly improved dashboard responsiveness and user experience. Tech Mahindra Software Engineer Pune, India Oct 2014 – Jan 2017

- Automated Dropbox file ingestion into ETL server using Shell Scripts, processed data in Teradata, and generated regional BI reports. Enhanced reliability by designing reusable modules and alert systems using Informatica and Airflow, boosting PDO by 200%. Technical Skills

Languages/Databases: Python, SQL, Unix shell scripting, R, SQL Server, PostgreSQL, MySQL, Denodo, Teradata, Sybase Tools/Frameworks: Apache Airflow, Informatica, SSIS, Pandas, NumPy, SSIS, Teradata Utilities Cloud & others: Databricks, AWS (S3, Lambda, EC2, Glue, Sagemaker), GitHub, Power BI, Tableau, REST APIs, CI/CD Pipelines Education

University at Buffalo, The State University of New York Master’s in Computer Science – 2024 West Bengal Institute of Technology, West Bengal, India Bachelor’s in Information Technology – 2014 Academic Projects

Cricket Analysis System (Postgres, Python) - Designed and implemented a cricket analysis system that effectively captures and analyzes cricket performance metrics for players playing in IPL, enabling informed decisions for team selection and strategies. Customer Churn Prediction (Python, R)- Designed a model to predict the churning of customers from the given data. Applied Logistic Regression, support vector machines (SVM), decision trees, and random forests to predict churn likelihood in customers, evaluating performance

Projects & Contributions

Healthcare Claims Pipeline: Worked for GSK to build ingestion flow for batch and streaming health records with schema validation and logging.

Performance Optimization: Worked in Teradata performance team to optimize the performance of complex queries using Push Down Optimization and other Teradata Utilities.

Power BI Dashboards: Created interactive dashboards in quicksight for stakeholders using SQL views and Denodo datasets. Mentoring: Led and mentored a team of 5 junior developers, providing guidance on coding standards, best practices, and project execution.

Certifications

Microsoft Certified: Azure Fundamentals (AZ 900), Agile Scrum Foundation, AWS Cloud compute

Contact this candidate