Data Engineer Software

CHANDRA KISHOR MISHRA

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

PROFESSIONAL EXPERIENCE (7 YEARS)

Central New York Regional Information Center July 2024 - present Software Engineer Syracuse, NY,USA

- Developed APIs to enable seamless data retrieval from source tables, providing real-time access and efficient presentation to end users.

- Designed and implemented robust ETL pipelines to process and transform data from various sources, including AWS, Oracle, flat files, ensuring that users can access reports such as demographic data, performance evaluation metrics, attendance, and test scores.

- Designed and developed web service APIs for interactive data visualization, enhancing user experience. CitiBank Corps Jan 2022 - Dec 2022

Data Engineer Pune, India

- 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 Feb 2017 - Jan 2022

Senior Technical Analyst Pune, India

- 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, reducing dashboard latency with Apache Spark and Hadoop, enhancing data processing speed and scalability, resulting in significantly improved dashboard responsiveness and user experience.

- Led teams in critical interfaces for major releases (6.1/6.2/6.3), collaborating with product owners, stakeholders, developers, business analysts, and support teams to gather information, design flows, estimate effort, code, develop test cases, ensure seamless integration, and provide technical insights for decision-making.

- Mentored over 5 engineers (including interns, a data engineer and a data analyst) over the last 4 years by providing technical guidance, facilitating skill development, and integrating them into project workflows. Tech Mahindra Oct 2014 - Jan 2017

Data Engineer Pune, India

- Developed and mounted Shell Scripts to automate file downloads from Drop Box into the ETL Server, authorized, loaded into staging, queried raw data, and cleansed, transformed, and filtered data. Implemented North America Business Intelligence application, generating reports for the region, and created DDLs and DMLs in Teradata. Automated email alerts for completion and failure using Informatica and Airflow, increasing process capability (PDO) by 200% through designing reusable and configurable modules.

- Implemented the GDPR for the client which enables to access, delete, update port or put on hold the registration data of the users. ACADEMIC PROJECTS

Cricket Analysis System (Postgres, Python, MySQL) Sept 2023 – Dec 2023

- Designed and implemented a comprehensive cricket analysis system that effectively captures and analyzes cricket performance metrics for players playing in IPL, enabling informed decisions for team selection and competitive strategies. Customer Churn Prediction (Python, R) June 2023 - Aug 2023

- 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 Fake News Classification(Python, TF-IDF Vectorization, HashingVectorizer)

- Developed a fake news classification model using TF-IDF and Multinomial Naive Bayes, achieving an accuracy of 93%. Utilized HashingVectorizer to handle large vocabularies, improving memory efficiency and algorithm speed. EDUCATION

University at Buffalo, New York Jan 2023 - May 2024 Master’s of Science in Data Science Buffalo, New York, USA Coursework: Data Models and Query Language, Statistical Analysis and Data Mining, Probability Theory, Programming and Database Fundamentals, Machine Learning with Time Series Data, Deep Learning, Neural Network, Optimization of Algorithms West Bengal University of Technology, West Bengal Aug 2010 - Jun 2014 Bachelor of Technology West Bengal, India

Coursework: Data Structures & Algorithms, Database Management System, C, Advance Mathematics SKILLS

Python, R, Unix, Shell Scripting, Scala, JavaScript, Java, SQL, MATLAB, HTML/CSS, Teradata, MySQL, Postgres, Oracle, NoSQL, AWS, Informatica, Airflow, ETL, GitHub, GCP (GCS, Dataproc, Cloud Functions), ScheduleIN, TWF, Kafka Domain Knowledge: Banking and Finance, Data warehousing, Pharmaceutical, Retail, Supply Chain, Project Management

Contact this candidate