Ankit Rai

• Authored code fixes and enhancements for inclusion in future code releases and patches.
• Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
• Contributed to successful project completion with effective time management and prioritization skills, meeting tight deadlines consistently.
• Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
• Migration of SQL Procedures - Working on end-to-end Procedure migration . It includes DAG-IT conversions of TD sql file , creating realtime DAG from scratch, making necessary changes in .py file, provisioning, tracking the jobs triggered using keystone & Datapipeline , performing validation checks with Ins-Upd-Delete checks.
• Added Responsibility - Utility scripts and Assisting Team - Worked on few utility scripts in python to help reduce the manual work and save time and effort for this project. Alongside helped team to fix issues related to code or platform faced by them, do pre-requisite checks required for the inventories. Fix any issues raised through incidents post delivery.
• Performed end-to-end testing to check the working of converted procedures. Insert-update-Delete functionality along-with Validation checks were performed. Checked column sync-up between tables in TD &SF and ensured Data flow from processing-main-core table. All these steps were documented in UTC & shared.
• Incident Support - Assisting Application Team Users for issues,Understand and clarify requirements. Fixing any SQL procedures/logic identified later post delivery.

• The client was looking for a implementation partner for its Terminus Tableau migration program (for Sales BU) to support migrating and validating its Tableau workbooks from Teradata to Snowflake, for which our team has done the analysis of around 250 + Tableau Objects and migration of 350 + Tableau objects to Snowflake Datasources.

It required :

• End to end conversion of Tableau objects (Datasources, workbooks, Flows), 2
• Work closely with users to make changes to Tableau report that includes data sources, SQL queries, calculations, formulas etc
• Production cutover and warranty support.

• Working in Cognizant as Programmer Analyst, I have been in Data Warehouse Training which taught me skills like MySQL, PL/SQL, Snowflake, Teradata, Data Warehousing and the Basics of Python programming
• Being new to these skill, it made me more curious about the data, its flow, how it is processed and where it is stored, and many more
• To further this, I am looking for roles related to Data Science or Data Engineering which are in sync with the skills I have and ready to upskill myself with the required skills in order to help contribute to the project/organization as well as my own personal learning.