Deepa Balakrishnan Email & Phone Number

Denver, CO, US

Stamford, CT, US

• Performs ETL by integrating varied data sources to create a Data Lake within Amazon S3 using EMR
• Optimize Query and data pipelines
• Use Step Functions and Lambda and execute the EMR cluster
• Working on Hive Query language and bash scripts
• Manage CI/CD using GitLab
• Managing the AWS resources using Terraform.

Mountain View, California, US

• Data Modeling using Postgres relational database and ETL pipelines to build Fact and Dimensional tables and insert data into these tables.
• Data Modeling using Apache Cassandra NoSQL database. Building ETL pipeline to preprocess raw dataset to create a new dataset which is utilized for answering analytical queries.
• Process the Amazon S3 dataset and load it to dimensional tables within the Amazon Redshift cluster.
• Data is loaded from S3, processed into analytics tables using Spark and this processed data is loaded back into S3 as parquet files.
• Data pipeline is implemented using Apache Airflow to process data residing in S3 into Amazon Redshift data warehouse. The data pipeline follows various tasks: staging, transforming, and loading data. A data quality.
• A spark warehouse with fact and dimension tables in a star schema is created. The raw datasets used for this project are in sas7bdat and CSV formats. Exploratory Data Analysis (EDA), data cleaning, and extract.

• Took a break to focus on full-time caregiving and owing to a delay in getting the US EAD/Work Permit issued; Excited and energized to return to work.Proactively pursued the below courses and certifications through.
• Certification-Querying Microsoft SQL Server 2012/2014(70-461)
• Data Engineering Nanodegree, Udacity (April 2022 – July 2022)
• AWS Machine learning Nanodegree, Udacity (August 2021 – January 2022)

Mountain View, California, US

Gained knowledge in Machine Learning concepts. Also got more acquainted with fundamentals of AWS Sagemaker to perform exploratory data analysis, train, deploy, and evaluate a model. Created machine learning workflows, starting with data cleaning and feature engineering, evaluating and hyperparameter tuning the models. Also developed machine learning.

Dubai, AE

• 2.5+ years of experience in SQL Server 2005/2008 and 2012 and Microsoft Business Intelligence Tools (SSIS, SSAS & SSRS)
• Hands-on experience in creating database objects such as Tables, Views, writing Stored Procedures, User Defined Functions, Cursors, usage of Triggers & Indexes to facilitate efficient Data Manipulation and Data.
• Thorough knowledge of Normalization and Optimization techniques
• Having experience in creating clustered and non-clustered indexes on the tables for performance tuning
• Having good experience in Extraction, Transformation, and Loading(ETL) for designing and developing SQL Server Integration Services-SSIS Packages with different Control Flow Tasks and Data Flow Transformations.
• Experience in Data Warehouse concepts

Dubai, AE

• Working on an end-to-end banking solution software that reports all the credit data of Credit Providers to a central entity, Credit Bureau, and accounting and auditing system. The roles and responsibilities include:
• Perform the ETL using Informatica 9.6.x to create different types of customers and corresponding loan information files in comma-separated formats.
• Used SQL to transform the data to Credit Bureau compatible formats.
• Leveraged, SQL Normalization and Optimization techniques, JOINS, Aggregations, Stored Procedures, Functions, and Views for this purpose.
• This transformed file will be then sent back to the banks, which in turn will be sent to the Credit Bureau to retrieve the customer credit information in near real-time
• Analyzing the requirements and developing assigned modules using SQL Server 2005/ 2008 and 2012 and ASP.NET

Data Engineering

Bachelor'S Degree, Electronics And Communications Engineering

Bachelor'S Degree, Electronics And Communication Engineering