Summary
Overview
Work History
Education
Skills
Timeline
Generic

Eswar Sai

Frisco,Texas

Summary

Offering 8 years background managing various aspects of development, design and delivery of database solutions. Practical Database Engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. History of mining, warehousing, and analyzing data at the company-wide level. Knowledgeable about the principles and implementation of machine and deep learning. Results-oriented and proactive with top-notch skills in project management and communication. Tech-savvy and independent professional bringing outstanding communication and organizational abilities.

Overview

10
10
years of professional experience

Work History

Data Engineer

Epeople Technologies
Jersey City, NJ
10.2023 - Current
  • Created ETL scripts to move and transform data from various sources into a centralized repository.
  • Developed data pipelines to ingest and process large datasets.
  • Integrated multiple heterogeneous sources into one unified source via ETL processes.
  • Optimized existing queries in order to improve query performance and reduce the load on the server.
  • Performed advanced analytics on structured and unstructured data using SQL, Python, R.
  • Implemented new database technologies such as NoSQL databases for efficient storage of large volumes of data.
  • Collaborated with other teams to understand their requirements and deliver solutions accordingly.

Data Engineer

Divis Labs INC
08.2017 - 12.2021
  • Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports. Deploy Power BI reports to Web service and develop Dashboards.
  • Integrated on-premises and cloud data sources (MYSQL, Cassandra, Blob storage, Azure SQL DB) using Azure Data Factory, applying transformations, and loading data into Snowflake.
  • Results-driven Data Migration Specialist with expertise in migrating on-premises resources to Azure Data Lake Storage (ADLS) Gen2.
  • Proficient in utilizing SQL Server, Azure Blob Storage, ADLS Gen2, Azure Data Factory (ADF), Azure Databricks, Logic Apps, Azure Monitor, Azure Synapse and Delta Lake tables. Skilled in implementing the bronze, silver, and gold layer approach for efficient data transformation and analysis.
  • Superintended usage of Python NumPy, SciPy, Pandas, PandaSQL and Matplot, Stats packages to perform dataset manipulation, data mapping, data cleansing and feature engineering. Built and analyzed datasets using R and Python.
  • Developed ELT/ETL pipelines using Python and Snowflake Snow SQL to facilitate data movement to and from Snowflake data store.
  • Integrated multiple data sources into one unified view using views or joins in SQL queries.
  • Used T-SQL scripting language for creating stored procedures, functions, triggers.
  • Expert in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, triggers, clustering, T-SQL, relational database models, data dictionaries, and data integrity.
  • Implemented ETL transformations and validations using Spark-SQL/Spark Data Frames in Azure Databricks and Azure Data Factory.
  • Implemented a CI/CD framework for data pipelines using Jenkins, ensuring efficient deployment and version control.
  • Utilized JIRA for project reporting, creating sub-tasks for development, quality assurance, and partner validation.
  • Applied Agile methodologies extensively, participating in daily stand-ups and internationally coordinated PI planning to ensure successful project delivery.

Data Engineer

Sarva Solutions
Bengaluru, India
01.2015 - 07.2017
  • Develop data models and schema designs that optimize data storage, retrieval, and analysis. This includes dimensional modeling for data warehousing and designing NoSQL databases for unstructured data.
  • Develop Extract, Transform, Load (ETL) processes to integrate data from various sources into Azure data platforms. Utilize Azure Data Factory, Azure Databricks, or similar tools for data ingestion, transformation, and orchestration.
  • Build and maintain end-to-end data pipelines for batch and real-time data processing. Leverage Azure services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure HDInsight, and Azure Stream Analytics.
  • Ensure data quality, consistency, and integrity across Azure data solutions. Implement data governance frameworks, data lineage tracking, and data quality monitoring to comply with regulatory requirements and organizational standards.
  • Identify and optimize performance bottlenecks in data processing workflows and storage systems. Tune SQL queries, optimize data partitioning strategies, and configure resource allocation for optimal performance.
  • Implement security measures to protect sensitive data stored in Azure environments. Configure role-based access controls (RBAC), data encryption, and network security policies to comply with industry regulations and best practices.

SQL Developer

Value Labs
Hyderabad, India
06.2014 - 12.2014
  • Developed and implemented complex SQL queries to extract data from multiple databases.
  • Optimized existing queries by analyzing query plans and execution times.
  • Performed database tuning activities such as indexing, partitioning and performance monitoring.
  • Migrated databases from one server to another while ensuring minimal downtime.
  • Worked closely with Business Analysts to understand functional requirements and translate them into technical designs.
  • Collaborated with other developers to design ETL solutions that meet business requirements.
  • Created stored procedures, functions, views, triggers and indexes for efficient data manipulation.
  • Participated in code reviews sessions conducted by senior team members.
  • Prepared detailed documentation on all changes made to the databases during development process.
  • Identified gaps in existing processes and provided recommendations on improving overall efficiency.
  • Assisted in troubleshooting application issues related to database objects or performance bottlenecks.
  • Monitored system resources utilization and optimized the same for better performance of applications.

Education

Master of Science - Computer And Information Sciences

Western Illinois University
Macomb, IL
07-2023

Bachelor of Technology - Computer Science

Andhra University
Vishakapatnam
05-2014

Skills

  • Microsoft Azure
  • Azure Data Lake Storage
  • Azure Synapse Analytics
  • Azure Databricks
  • Azure Data Factory
  • Azure SQL Database
  • Azure Blob Storage
  • Python
  • R
  • Tableau
  • Power BI
  • Performance Tuning
  • Data Migration
  • API Development
  • NoSQL Databases
  • Data Modeling
  • Machine Learning
  • Data Security
  • Data Warehousing
  • Relational Databases
  • Database Design
  • Business Intelligence
  • SQL Transactional Replications
  • Data Analysis
  • SQL and Databases
  • Data Analytics
  • Object-Oriented Programming

Timeline

Data Engineer

Epeople Technologies
10.2023 - Current

Data Engineer

Divis Labs INC
08.2017 - 12.2021

Data Engineer

Sarva Solutions
01.2015 - 07.2017

SQL Developer

Value Labs
06.2014 - 12.2014

Master of Science - Computer And Information Sciences

Western Illinois University

Bachelor of Technology - Computer Science

Andhra University

Similar Profiles

  • Chong Soo Ken

    Chong Soo KenChong Soo Ken

    Cloud Finance Speciallist (Cloud BG CFO) at Sparkoo Technologies (Malaysia) Sdn. Bhd (Cloud Subsidiary for Huawei Technologies (Malaysia) Sdn Bhd)Cloud Finance Speciallist (Cloud BG CFO) at Sparkoo Technologies (Malaysia) Sdn. Bhd (Cloud Subsidiary for Huawei Technologies (Malaysia) Sdn Bhd)

  • SRIRAM R

    SRIRAM RSRIRAM R

    Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)Software Quality Analyst at GAVS Technologies (formerly Neurealm Technologies Pvt Ltd)

  • Venkata Nagaraju Inakollu

    Venkata Nagaraju InakolluVenkata Nagaraju Inakollu

    Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)Technical Lead(System Design) at Relysys Technologies Pvt Ltd (now Invendis Technologies pvt ltd)

  • DESTINI MARSH

    DESTINI MARSHDESTINI MARSH

    FRAUD INTELLIGENCE ANALYST at Goldman SachsFRAUD INTELLIGENCE ANALYST at Goldman Sachs

  • Brandie Outlaw

    Brandie OutlawBrandie Outlaw

    Program Manager (Remote) at CISCO - Global EventsProgram Manager (Remote) at CISCO - Global Events

CREATE PROFILE
Eswar Sai