Rishabh Yadav Email and Phone Number

PROJECT 1APR 2022 - FEB 2023Project: SAS to Talend ETL MigrationSummary: Led a collaborative effort with a team of 3 members to successfully migrate existing SAS ETL jobs to Talend platform. Oversaw the seamless transition while managing ongoing enhancements, maintaining client communication, crafting mapping documentation, and delegating tasks efficiently.Responsibilities:• Led the migration project, ensuring a smooth transition from SAS ETL to Talend.• Managed… Show more PROJECT 1APR 2022 - FEB 2023Project: SAS to Talend ETL MigrationSummary: Led a collaborative effort with a team of 3 members to successfully migrate existing SAS ETL jobs to Talend platform. Oversaw the seamless transition while managing ongoing enhancements, maintaining client communication, crafting mapping documentation, and delegating tasks efficiently.Responsibilities:• Led the migration project, ensuring a smooth transition from SAS ETL to Talend.• Managed continuous enhancements and modifications in SAS ETL jobs during the migration process.• Conducted daily client meetings to provide progress updates and address concerns.• Created comprehensive mapping documentation for accurate and streamlined migration.• Devised task allocation strategies, ensuring optimal utilization of team members' skills.PROJECT 2MAR 2023 – TILL DATEProject: SAS Data Source RepointingSummary: Leading a team of 3 members in a pivotal project to repoint an existing SAS job's data source from Teradata to Snowflake. Driving the entire process, overseeing enhancements, engaging with clients, creating mapping documentation, verifying table availability, and effectively delegating tasks for streamlined execution.Responsibilities:• Guiding the SAS data source repointing effort, ensuring a seamless transition to Snowflake.• Continuously enhancing the SAS job's functionality during the data source migration.• Conducting daily client meetings to provide progress updates and address queries.• Creating detailed mapping documentation comparing Teradata and Snowflake data structures.• Verifying table availability in Snowflake, ensuring a robust data migration process.• Skillfully allocating tasks among team members, maximizing productivity and outcomes. Show less

Project: Automated Data Processing and Enhanced CommunicationSummary: Led the implementation of an automated data processing system, integrating business rules and generating Excel outputs from TPA flat files. Collaborated with the Business Team, developed metadata files, crafted automated SAS and Python code, and enhanced stakeholder communication through a personalized SAS Macro.Responsibilities:• Collaborated with Business Team, ensuring requirements alignment and data… Show more Project: Automated Data Processing and Enhanced CommunicationSummary: Led the implementation of an automated data processing system, integrating business rules and generating Excel outputs from TPA flat files. Collaborated with the Business Team, developed metadata files, crafted automated SAS and Python code, and enhanced stakeholder communication through a personalized SAS Macro.Responsibilities:• Collaborated with Business Team, ensuring requirements alignment and data validation.• Created metadata files, encapsulating business rules for TPA flat file processing.• Developed monthly Automated SAS code, ensuring seamless and efficient job execution.• Designed a Python automation script to streamline flat file organization.• Crafted a customized SAS Macro, automating email notifications to existing customers. Show less

Project: Enhanced ETL Efficiency and Automation with SASSummary: Collaborated as a pivotal member of the SAS team, focusing on improving ETL processes and job automation. Interacted closely with business teams for validation and streamlined stakeholder communication through custom SAS solutions.Responsibilities:• Supported and maintained existing ETL solutions, ensuring consistent operations.• Utilized Autosys and crontab to meticulously schedule and oversee job execution.•… Show more Project: Enhanced ETL Efficiency and Automation with SASSummary: Collaborated as a pivotal member of the SAS team, focusing on improving ETL processes and job automation. Interacted closely with business teams for validation and streamlined stakeholder communication through custom SAS solutions.Responsibilities:• Supported and maintained existing ETL solutions, ensuring consistent operations.• Utilized Autosys and crontab to meticulously schedule and oversee job execution.• Engaged with the Business Team, aligning requirements and validating data with peers.• Automated essential SAS jobs across multiple timeframes.• Crafted a personalized SAS Macro, facilitating automated daily job notifications to stakeholders. Show less