Alok Ranjan

Data Enginner

Cognizant•  February 2022 - Present•  Noida

Migrated 5000+ jobs from DataStage/Tivoli to PySpark/Airflow. Contributed to developing a robust control framework with dynamic functionalities, serving as the backbone of the migration. Accessed, extracted, and transformed data from various sources, utilizing ADLS storage. Led the migration of multiple subject areas, ensuring seamless transitions. Created data pipelines to manage data flow between multiple layers on Azure Databricks. Debugged syntactical errors in notebooks, enhancing code quality. Collaborated with multiple teams, including the Airflow team, to create DAGs and conduct DVS for system testing. Fixed defects related to data types, count mismatches, and data load issues.

Associate Technical Support

FIS•  January 2020 - February 2022•  Bengaluru

Gained exposure to the IT working environment, understanding business operations and team coordination. Monitored ETL processes for multiple banking domains, including manual intervention to move and load extracts onto database servers. Executed multiple "SELECT" and "UPDATE" queries, and scheduled/rescheduled packages on SSMS. Worked with SSIS (2016) and SSMS (2012, 2016, 2019) to manage data operations. Collaborated with business analysts to extract reports from SSMS using SQL, tailored to business needs. Conducted daily analysis and created dashboards in Excel (using PivotTables) to track the resolution and status of tickets across multiple assignment groups. Led a team focused on ticket governance and reporting for multiple client banks, utilizing skills in data extraction, data cleaning, and trend analysis. This effort resulted in the reduction of obsolete tickets and improved reporting to management.