Praveen Pandey
Data Engineer
Noida
Summary
7 years of experience in the Information Technology industry. Good Knowledge in database replication tools like Qlik Replicate and native replication tools. I assist clients with Replicate, a high-performance data replication and loading solution designed to accelerate enterprise. Replicate automates movement to, from and between databases, data warehouses, and the Cloud, reducing time. A Strong analytical skills, excellent ability to debug and resolve technical problems in complex systems. Able to learn new technologies and business terminology quickly. Maintaining an issues knowledge base with resolutions for future reference. Diagnosing and resolving data and system issues to ensure warehouse usability for the consumers of the warehouse data. Some light debugging duties using SQL will be required to develop queries/reports of varying complexity to. Acting as the point of contact for the data warehouse production eco system. Performing daily, weekly, monthly, quarterly, and yearly operations tasks required for the ongoing functionality of the software applications.
Overview
7
7
years of professional experience
1
1
Certification
1
1
Language
Work History
Lead - Application Consultant
Flextronics India
07.2023 - Current
- Handles Qlik Replicate issue, managing and resolving the error, task development, Administration.
- Developed and implemented ETL processes to improve data quality, resulting in a 20% increase in data accuracy.
- Involves seamlessly managing the flow of data from various sources into a unified system.
- We use Qlik Enterprise Manager for managing different task.
- Working on SnowSQL and Snowpipe.
- Involves data validation, error handling, and implementing quality checks to ensure that the data being used for analysis is trustworthy.
- Creating Snowpipe for the continuous data load.
- Prepares detailed functional specification solution development.
- Use COPY to bulk load the data.
- Creating data sharing between two snowflake accounts.
- Perform import and export ETL jobs across various ETL projects. and servers.
- Handle the CDC Latency Issues.
- Develop transformation logic using snowpipeline.
- Troubleshot issues of data failure and table failure in Qlik Replicate.
- Creating automated workflows with the help of triggers.
- Validating the data from Oracle to Snowflake to make sure it has apple to apple match.
- Using COPY, LIST , PUT and GET commands for validating the internal stage files.
Lead- Application Consultant
ITC Infotech
12.2021 - 07.2023
- Streamlined data integration, profiling, and validation for various datasets by 40%, improving customer outcomes.
- Assisted in the development and implementation of ETL processes.
- Building the pipelines to copy the data from source to destination in Azure Data Factory.
- Worked on creating dependencies of activities in Azure Data Factory.
- Provide detailed analysis of problems and recommend solutions.
- Prepares detailed functional specification solution development.
- Perform import and export ETL jobs across various ETL projects and servers.
- Handle the CDC Latency issue.
- Created automated workflows with the help of triggers.
- Scheduled jobs in flows and ADF pipelines.
- We use Qlik Enterprise Manager for managing different task.
- Qlik replicate installation, upgradation on both windows & Linux Platform.
- Creating multiple data sets in Azure.
- Troubleshot issues of data failure and table failure in Qlik Replicate.
- Debugging the scripts which were developed by the other team members.
- Created stored procedures using Common Table Expression.
- Monitoring produced and consumed Data sets of ADF.
- Requirements gathering from the client managers and implementing them as tasks as per requirement.
- Moved CSV files from Azure blob to on-prem server(Linux).
Qlik Data Integration Engineer(Support)
Qlik Tech India Pvt. Ltd
08.2020 - 12.2021
- Qlik replicate installation, upgradation on both windows & Linux.
- Installation of various databases as Qlik replicate endpoints.
- Qlik enterprise manager installation & configuration.
- Handles cases from Qlik support forum.
- Reproduction of customer scenario in our lab setup for next level.
- Analysis of Qlik logs & Diagnostic package for any errors or warning.
- For any latency cases we use enhanced level of logging.
- Qlik Enterprise Manager for managing different Qlik server’s console.
Qlik Data Integration Engineer(Support)
R Systems international Limited
10.2019 - 08.2020
- Installation of various databases as Qlik replicate endpoints.
- Qlik Enterprise Manager for managing different Qlik server’s console.
- For any latency cases we use enhanced level of logging.
- Analysis of Qlik logs & Diagnostic package for any errors or warning.
- Reproduction of customer scenario in our lab setup for next level.
- Handled cases from Qlik support forum.
- Qlik enterprise manager installation & configuration.
- Installation of various databases as Qlik replicate endpoints.
Data Warehouse Support Engineer
Aravina Infomedia Pvt Ltd
01.2017 - 10.2019
- Maintaining an issues knowledge base with resolutions for future reference.
- Created Database objects like Tables, Views, Indexes, Sequences, etc.
- Diagnosing and resolving data and system issues to ensure warehouse usability for the consumers of the warehouse data.
- Providing 24×7 operational support to all production practices on holidays and weekends.
- Creation of users, Granting Roles and Privileges to Users.
- Some light debugging duties using SQL will be required to develop queries/reports of varying complexity to troubleshoot and recommend fixes to development teams.
Education
MCA - Computer Application
UP Technical University
Greater Noida07.2016
BCA - Computer Application
CCS University Meerut
Greater Noida07.2013
12th - Science
UP Board
Ballia03.2010
10th - Science
UP Board
Ballia04.2007
Skills
Snowflake
undefinedCertification
ITIL V4
Personal Information
- Father's Name: Shyam Nath Pandey
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Dob
03/15/93
Disclaimer
I hereby declare that the information furnished above is true to best of my knowledge & belief
Timeline
Lead - Application Consultant
Flextronics India
07.2023 - Current
Lead- Application Consultant
ITC Infotech
12.2021 - 07.2023
Qlik Data Integration Engineer(Support)
Qlik Tech India Pvt. Ltd
08.2020 - 12.2021
Qlik Data Integration Engineer(Support)
R Systems international Limited
10.2019 - 08.2020
Data Warehouse Support Engineer
Aravina Infomedia Pvt Ltd
01.2017 - 10.2019
MCA - Computer Application
UP Technical University
BCA - Computer Application
CCS University Meerut
12th - Science
UP Board
10th - Science
UP Board
Similar Profiles
SMITHA PSMITHA P
Senior Specialist at Flextronics India Pvt. LtdSenior Specialist at Flextronics India Pvt. Ltd
MIJI MMIJI M
Specialist- Procurement at Flextronics India private Ltd.Specialist- Procurement at Flextronics India private Ltd.
Karthik VelanKarthik Velan
JUNIOR ENGINEER (TEAM LEAD) at Flextronics India pvt Ltd.JUNIOR ENGINEER (TEAM LEAD) at Flextronics India pvt Ltd.
Prashant KashyapPrashant Kashyap
Consultant at TATA CONSULTANCY SERVICESConsultant at TATA CONSULTANCY SERVICES
Amartya SharmaAmartya Sharma
Web Analyst at Munivar Online Pvt LtdWeb Analyst at Munivar Online Pvt Ltd