Vivek Kumar Tiwari
Montreal,QC
Summary
- Experienced Senior Data Engineering Specialist with 11 years of expertise in database modeling, data warehouse design, data analysis, and data architecture. Proficient in utilizing technologies such as SQL Server, MySQL, MongoDB, Teradata, Hive, Snowflake, and Azure SQL. Proven track record of successfully implementing and optimizing data solutions to drive business insights and enhance overall data infrastructure.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Specialist
LTIMindtree Pvt
Noida, India
01.2022 - 09.2023
- Steered a 4-member team, fostering collaboration with clients and on-site teams to proficiently grasp project requirements, with a dedicated focus on incorporating data analytics methodologies for comprehensive comprehension and successful project outcomes.
- Optimized existing logic, resulting in a significant 40% improvement in query execution efficiency.
- Strategically evaluated intricate challenges, demonstrating expertise in problem-solving across various domains such as data reporting, data aggregation, data migration, data integration, data virtualization, and quality assurance, leading to the identification and implementation of effective solutions.
Senior Database Developer
Aalgro Foods Pvt. Ltd
Bangalore, India
04.2021 - 01.2022
- Advised upgrades enhancing platform architecture following internal audits on system performance. Achieved an 80% reduction in recovery time after outages.
- Conducted comprehensive data monitoring of databases and data warehouses by leveraging built-in tools such as Profiler and Performance Monitor, ensuring optimal performance and proactively addressing any performance-related issues.
- Optimized T-SQL queries for enhanced performance in AzureSQL (RDBMS) and MongoDB (NoSQL) environments by meticulously analyzing execution plans. Implemented strategic modifications to query structures and incorporated relevant indexes to achieve optimal database performance.
- Oversaw detailed documentation management, spearheading meticulous metadata oversight, and database modeling for tables, views, stored procedures, and triggers. Ensured thorough documentation and organization, optimizing data governance and accessibility..
Senior SQL Developer
Netsmartz Infotech
Chandigarh, India
05.2017 - 04.2021
- Spearheaded customer service-centric IT solutions in the realms of cloud and infrastructure. Successfully managed and delivered 7+ projects, ensuring scalability and consistently meeting client requirements with a 100% success rate.
- Collaborated closely with Business Analysts to comprehend functional requirements, facilitating the seamless translation of these requirements into effective technical designs.
- Led efforts in performance optimization, systematically analyzing and enhancing system efficiency to achieve optimal database performance.
- Implemented innovative strategies to establish and promote best practices, contributing to enhanced profitability.
Software Developer
Safaltek Software Pvt Ltd
Chandigarh, India
09.2014 - 04.2017
- Modified existing software systems to enhance performance and add new features.
- Adept in the end-to-end spectrum of database management, ensuring data quality, integrity, and security throughout the lifecycle for optimal organizational performance.
Technical Associate
LTIMindtreeMaccus Management Consultancy Pvt. Ltd
Bhopal, India
04.2013 - 04.2014
- Assessed data backup procedures to ensure proper data protection measures are in place.
- Participated in meetings or workshops related to technology initiatives within the organization.
Technical Associate
Prima Impact Informatics Solutions
Mysore, India
09.2011 - 11.2012
- Analyzed system logs and identified potential issues with computer systems or networks.
- Resolved technical problems through troubleshooting techniques.
Education
Bachelor of Engineering - Computer Science & Engineering
RGPV University
Bhopal, India06.2011
Skills
- MySQL, PLSQL, SQL Server, TSQL
- MongoDB(NoSQL)
- Teradata
- Hive (Hadoop/Big Data)
- JSON, XML
- Azure SQL
- Azure,AWS (Cloud Computing)
- Snowflake
- Microsoft Excel
- Python programming
- Machine Learning
- ETL/ELT pipelines
- Root Cause Analysis
- Analytical Thinking
- Process Analysis
- Analytical Skills
- Adaptability
- Time management abilities
- Professionalism
- Active Listening
- Self Motivation
- Teamwork and Collaboration
- Decision-Making
- Disaster Recovery Planning
- Multitasking
- Innovation and Creativity
- Great Communication and Interpersonal Skills
Languages
Certification
- Master's Program - Data Scientist
- M320: MongoDB Data Modeling
- Python Data Analysis
- Tableau Desktop
- Business Analytics with Excel
- Machine Learning Advance Certification
Timeline
Senior Specialist
LTIMindtree Pvt
01.2022 - 09.2023
Senior Database Developer
Aalgro Foods Pvt. Ltd
04.2021 - 01.2022
Senior SQL Developer
Netsmartz Infotech
05.2017 - 04.2021
Software Developer
Safaltek Software Pvt Ltd
09.2014 - 04.2017
Technical Associate
LTIMindtreeMaccus Management Consultancy Pvt. Ltd
04.2013 - 04.2014
Technical Associate
Prima Impact Informatics Solutions
09.2011 - 11.2012
Bachelor of Engineering - Computer Science & Engineering
RGPV University
Similar Profiles
ANUPAM VATSANUPAM VATS
Senior Manager at LTIMindtree Pvt LtdSenior Manager at LTIMindtree Pvt Ltd
Gaurav AgrawalGaurav Agrawal
Senior Data Engineer at LTIMindtree Pvt LtdSenior Data Engineer at LTIMindtree Pvt Ltd
Amith SaravananAmith Saravanan
Specialist - Cloud and Infra services at LTIMindtree Pvt LtdSpecialist - Cloud and Infra services at LTIMindtree Pvt Ltd