RAHUL SINGH RATHOD

• Company Overview: Client: Citi Bank
• The application is designed to determine the count of manual touch of every trading data based on their respective regions
• It achieves this by utilizing the MTP application, using ETL logic in Oracle View and Talend Job
• Data is sourced from two different Business Units, ABC and Volumes, with region-specific source files
• Subsequently, this data is deposited into a Staging table
• ETL logic is then applied to the Staging table to calculate the MTP count
• The resulting data, along with the MTP count, is deposited in trackback tables
• The application generates reports from the Trackback table with the assistance of the MSTR tool

Roles and Responsibility

• Manage the Offshore Data drop validation team
• Performing Data quality check weekly and monthly for different LOB's
• Load data into staging Oracle tables using Talend
• Develop ETL logic in Views for various source systems
• Develop Talend ETL jobs for various data sources
• Solving production issue like taking care of Autosys job failure and Feed failure in dif

Production Support Specialist

• Resolved Critical File Corruption Issue: Identified and resolved a production issue caused by a corrupted file, ensuring timely delivery of reports and minimizing business impact
• Improved File Validation Process: Enhanced file validation process to prevent similar issues, reducing errors and improving overall data by a corrupted
• Resolved Critical Job Failures: Identified and resolved recurring job failures in production environment, ensuring 99.9% job success rate and minimizing business impact
• Analyzed and Optimized Job Schedules: Analyzed job schedules and optimized them to prevent conflicts and reduce failure rates
• Collaborated with Cross-Functional Teams: Worked closely with development, DQ, and production support teams to troubleshoot and resolve job failures, ensuring effective communication and collaboration

• Company Overview: Bayer is a pharma and Healthcare Company
• AIM of this Project is to get the cost of different Marketing Channels for various Drugs in different countries
• Bayer is a pharma and Healthcare Company
• AIM of this Project is to get the cost of different Marketing Channels for various Drugs in different countries
• It has data from across the World
• Like Japan, US, Brazil, China, Germany
• Reads Various Sources using Talend and loaded in Amazon S3 for Reporting and Analysis Purpose
• Bayer is a pharma and Healthcare Company
• AIM of this Project is to get the cost of different Marketing Channels for various Drugs in different countries
• Bringing in data from Sources like MSSQL, Oracle using Talend Enterprise version 7.3.1, (Level 0)
• Read the data from Level 0 and applying Data Quality checks and loading in Level 1 Amazon S3 Bucket
• Reading the Data Quality check passed data and applying business rules and logics provided by BA and loading the processed data in Amazon S3 Bucket (Level 2)
• Reading processed data and directly loading it to respective dimensions and facts in Redshift (Level 3)
• Loaded the dim and fact data in summary tables

• Company Overview: Client: BYTE DANCE
• Ensured the integrity and quality of online content by reviewing and moderating user-generated content, adhering to community guidelines and standards
• Ensured the integrity and quality of online content by reviewing and moderating user-generated content, adhering to community guidelines and standards
• Client: BYTE DANCE
• Ensured the integrity and quality of online content by reviewing and moderating user-generated content, adhering to community guidelines and standards
• Applied community guidelines and standards to ensure content compliance
• Made informed decisions on content removal, escalation, or approval
• Collaborated with cross-functional teams to resolve complex content issues
• Provided feedback and insights to improve content policies and guidelines
• Reviewed and moderated large volumes of online content, including text, images, and videos