Summary
Overview
Work History
Education
Skills
Certification
Timeline
Projects
Projects
Generic

VENNILA RAMBHARATHY

Bentonville,Arkansas

Summary

  • Over 7+ years experienced IT consultant with expertise in data and Analytics Technologies Worked on the design and development of enterprise data warehouse systems and BI applications and ETL tools using Informatica, SQL, PL/SQL, AWS, Spark and Hadoop tools. Handled various tasks ranging from Development, Deployment, Testing, maintenance, and Release management in fields of Banking, Retail.
  • Over 2 years of Strong Knowledge of the architecture and components of hadoop, and efficient in working with hive sql.
  • Experience in utilizing Apache Spark and PySpark for distributed data processing.
  • By Using Python, we have performed data quality checks and validation during the ETL process.
  • By Using Hadoop HDFS we have stored the data extracted by implementing ETL pipelines to handle Big data.
  • Proficient in Relational Database Management Systems (RDBMS) with comprehensive knowledge of Oracle Database structure, schema objects, and expertise in utilizing cursors, triggers, procedures, and packages for efficient data handling.
  • Demonstrated capability in setting up and configuring AWS EC2 instances on both Linux and Windows servers, implementing various configurations to meet specific requirements.
  • Ability to create database instances using AWS RDS for Oracle, MySQL Aurora, SQL Server, etc. and connecting databases from local machines or EC2 instances to SQL Developer for streamlined data management.
  • Proficiency in creating and managing AWS S3 buckets, proficient in uploading objects through the AWS console or command line interface.
    Experience in configuring static web hosting using AWS S3, incorporating CSS and HTML files for web deployment.
  • Expertise in building clusters using Amazon Redshift, specializing in the development of column-based databases for optimized data storage and retrieval.
  • Gained foundational programming skills in machine learning during a Business Intelligence and Analytics course, including a basic understanding of several algorithms commonly utilized for predictive analysis.

Overview

8
8
years of professional experience
1
1
Certificate

Work History

Data Engineer

HCL Technologies
03.2019 - 07.2022

Client: CITI BANK

Application: Datalake project

The primary objective is to handle load the data from various sources like Oracle, Teradata, DB2 into datalake and AWS

  • Developed and maintained ETL pipelines using Sqoop and Hive to extract data from various sources(oracle database,flat files) and load it into a Data Warehouse..
  • Implemented Sqoop for seamless data extraction from diverse sources.
  • Designed real-time data streaming with Kafka and PySpark post historical data loading.
  • Developed Hive programs for data transformation and Data Lake integration.
  • Orchestrated workflows and jobs in an Automated Scheduler for YAML executions.
  • Prioritized tasks according to Jira tickets for efficient project management.
  • Leveraged GitHub for comprehensive version control.
  • Monitored and analyzed Hadoop cluster performance, identified bottlenecks, and implemented tuning strategies.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.

SQL Developer

Tata Consultancy Services
09.2014 - 12.2018

Client : NIELSEN

Application: PubEasy and Pubnet

  • Actively resolved tickets logged via ServiceNow or email, prioritizing based on severity issues which can be like login problems, missing menu items on their web page, order status visibility issues, and stuck orders and so on
  • Conducted in depth analysis by replicating issues and analyzing the code, PLSQL for backend, HTML scripts for UI, and Oracle databases to identify and rectify bugs in the code
  • Executed production fixes following Change Management protocols within designated downtime periods, ensuring minimal disruption to business
  • Engaged in various small application development in accordance with specified requirements
  • Wrote PL/SQL stored procedures for implementing business rules and logic
  • Wrote UNIX scripts and automated various application-related functions
  • Engaged with clients, participated in requirements gathering, and conducted weekly status reviews to align with project objectives and client needs
  • Utilized Unix scripting for efficient file uploads from publishers and implemented cron jobs for shell scripts to automate report delivery from the database to specific distribution groups.

Education

Master’s degree Holder in Big Data Analytics -

University of Central Missouri
05.2024

Skills

  • Big Data Ecosystem (Hadoop, HDFS, Spark,Hive)
  • Cloud Services (AWS)
  • Databases (Oracle SQL, Microsoft SQL Server, MySQL)
  • Programming Languages (SQL, PLSQL, Python, Oracle, Java )
  • Operating system (Linux, Unix, Windows)
  • Data Visualization (Tableau)
  • Scheduling Tools (Cronjob, Automatic Scheduler)

Certification

AWS Solution Architect - Associate

  • AWS Certified Solutions Architect - Associate with demonstrated expertise in designing scalable and cost-efficient cloud solutions. Proficient in AWS services, architecture best practices, and implementing secure and resilient applications on the AWS platform.

Timeline

Data Engineer

HCL Technologies
03.2019 - 07.2022

SQL Developer

Tata Consultancy Services
09.2014 - 12.2018

Master’s degree Holder in Big Data Analytics -

University of Central Missouri

Projects

  • Designed and implemented a blog website using Java, JSP, and Servlets within an MVC architecture, demonstrating software development methodologies acquired during master’s program.
  • Constructed a movie recommendation system leveraging Python in Jupyter Notebook, employing collaborative filtering techniques and data analysis to provide tailored and effective movie suggestions based on popularity, genre and rating variables from the data collected.

Projects

  • Designed and implemented a blog website using Java, JSP, and Servlets within an MVC architecture, demonstrating software development methodologies acquired during master’s program.
  • Constructed a movie recommendation system leveraging Python in Jupyter Notebook, employing collaborative filtering techniques and data analysis to provide tailored and effective movie suggestions based on popularity, genre and rating variables from the data collected.
VENNILA RAMBHARATHY