Dbeaver
Vigneshwaran Kothandaraman
Data Engineer/Analyst
Watford,HRT
Summary
- Detail-oriented Data Engineer/Analyst designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
- Google Certified – Associate cloud Engineer(Attained in Nov 2020).
- Google Certified – Professional Data Engineer(Attained in June 2023).
- Attained Coursers certification – On various Google Cloud Specializations .
- Completed Snowflake Core Certification in Udemy.
- Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills, excellent problem-solving abilities, and deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.
- Background includes warehousing, and analytics. Quality-driven and hardworking with excellent communication and project management skills.
- Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
- Interested in developing new skills and learning new things
Overview
9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certifications
Work History
Data Engineer/Analyst
HCL TECHNOLOGIES UK
05.2022 - Current
- Designed and implemented effective database solutions and models to store and retrieve data in AWS REDSHIFT and SNOWFLAKE .
- Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments.
- Collaborated with stakeholders to identify business needs and data sources.
- Worked on AWS GLUE, SNOWFLAKE, AWS REDSHIFT, DBT Models, AWS S3, Step Functions, Lambda Functions, IAM Policies.
- Created data models to support decision-making processes.
- Collaborated on ELT (Extract, Load, Transform) tasks, maintaining data integrity and verifying pipeline stability.
- Designed and developed data pipelines to acquire, clean and process data using AWS GLUE .
- Developed scripts( Python and PySpark ) to extract and analyze data from multiple sources and created AWS Glue jobs .
- Developed and maintained Mata Warehouses and Mata Marts as ADMIN user to control access and support business operations .
- Built databases and table structures for many applications.
- Communicated new or updated data requirements to global team.
- Prepared documentation and analytic reports, delivering summarized results, analysis and conclusions to stakeholders.
- Drafted technical documentation for internal business areas and processes, incorporating factors such as technical design, data manipulation, ETL and storage management.
- Performed UAT and PROD Deployment using GITLAB through JIRA Tasks and proper approvals.
- Optimized data sources and processing rules to enhance data quality through design and development phases.
- Acted as liaison between clients and technical associates, translating complex ideas into easy-to-understand explanations.
- Determined data storage and optimization policies, shaping organization efforts to enhance performance.
- Analyzed data to identify root causes of problems and recommend corrective actions.
Data Analyst
HCL TECHNOLOGIES INDIA
02.2018 - 04.2022
- Participated in requirements meetings to understand business needs.
- Collaborated with system architects, design analysts and others to understand business and industry requirements.
- Gathered, defined and refined requirements, led project design and oversaw implementation.
- Built ELT and ETL Data Pipelines and Data Transformation Techniques using AWS Glue and SSIS .
- Collaborated on ELT (Extract, Load, Transform) tasks and ETL tasks, maintaining data integrity and verifying pipeline stability.
- Built and Maintained AWS Redshift Instances, AWS Glue Jobs, S3 Buckets.
- Contributed to internal activities for overall process improvements, efficiencies and innovation.
- Built databases and table structures in MSSQL and Redshift for many applications.
- Led the Technical Support team and guided them to solve the issues and achieve solutions for the problems they face in complex data models.
- Resolved the data issues by identifying the root causes and strictly followed the SLA.
- Worked on SVN, Crystal Reports and Power BI Reports
Assistant Quality Engineer
DS Connectors And Cables India Pvt Ltd
Chennai, TAMILNADU
05.2015 - 01.2018
- Coordinated with quality control staff to complete inspections.
- Performed quality inspections and drafted reports to detail non-conforming material issues.
- Contributed to root cause analysis to determine core reason for failures and errors.
- Supported quality team members during corrective action updates.
- Developed traceability documentation to aid in investigating faults and defects.
Education
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Global Institute of Engineering And Technology
Melvisharam, Vellore 05.2011 - 04.2015
Skills
AWS Services (Redshift, Glue, S3, Lambda, Step Functions, Cloudwatch, KMS, Data sync, VPC, EC2, IAM, Parameter Store)
DBT
Python
SQL and Databases(Redshift, Snowflake, MSSQL)
Google Cloud Platform
Software
Power BI
GITBASH
Visual Studio Code
Service Now and JIRA
PyCharm
Certification
Google Cloud Professional Data Engineer
Timeline
Udemy - Snowflake Core Certification
08-2023
Google Cloud Professional Data Engineer
06-2023
Data Engineer/Analyst
HCL TECHNOLOGIES UK
05.2022 - Current
Google Cloud Associate Cloud Engineer
11-2020
Data Analyst
HCL TECHNOLOGIES INDIA
02.2018 - 04.2022
Assistant Quality Engineer
DS Connectors And Cables India Pvt Ltd
05.2015 - 01.2018
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
Global Institute of Engineering And Technology
05.2011 - 04.2015