Ravi Kumar Pandey

Project: iconectiv

• Working on Telecom number portability.
• Providing extended customer support.
• Working on customer ticket.
• Have good hands-on experience in Unix scripting, SQL.

Project: iconectiv

• Working as Data Migration Engineer.
• Developed PL SQL procedures and functions, collections.
• Used python scripting to generate Migration report.
• Wrote Shell script to automate the loading process.
• Analyzed migration failure and worked with team to find error.

• Migration of historical hive data to Google cloud Platform.
• Conversion of existing hive SQL code to BigQuery codes.
• Involved in data loading from cloud bucket to BigQuery and data validation and code optimization
• Created the Airflow Dags using the python which includes connecting to GCP, connecting to remote servers, pushing the data and fetching the data with the external sources.
• Monitoring the workflows from Airflow web UI
• Created SQL pipeline execution through DAG in Airflow as per requirement
• Using github to store the built codes on github to deploy it to other environments
• Used GCP services like BigQuery, Airflow, Cloud Storage, Composer.

• Bug fixing at the time of Portfolio testing and UAT to ensure smooth progress of development lifecycle
• Code and design review of peer developers
• Developed utility on Oracle to automate report generation and transfer to customers
• Created Oracle functions, stored procedures, cursors, triggers, tables, views, constraints, sequences, index
• Used shell and python scripts to automate manual task
• Conduct Training and KT for juniors.