Pratik Majithia

Project Requirement: Transfer sensitive banking data from the production server to lower environments, applying appropriate masking to PII columns to ensure data privacy while enabling various teams to use this test data for testing and development activities.

Role and Responsibilities:

• Sole Responsibility: Managed entire task from requirements gathering to data delivery and validation.
• Collaboration: Worked closely with Data Management Office (DMO) team to create and validate algorithms for PII field masking.
• TPT Script Creation: Developed Teradata Parallel Transporter (TPT) using automation scripts for efficient data transfer.
• Algorithm Validation: Ensured correctness and effectiveness of masking algorithms applied to PII fields.
• Mainframe Job Validation: Verified accuracy and functionality of data transfer jobs.
• Data Validation: Conducted thorough validation of data post-transfer to lower environments to ensure integrity and compliance.

Project Requirement: Perform QA on critical banking data in a sensitive environment before production deployment.

Role and Responsibilities:

• Critical Data Testing: Conducted testing on personal customer data in a special pre-production banking environment.
• Pre-Production Testing from Onshore : Single-handedly managed multiple projects, conducting extensive testing in controlled environment from an onshore location.
• Defect Identification: Identified nearly 50% of defects within a team of six.
• Project Management: Successfully handled multiple projects simultaneously, demonstrating strong multitasking and project management skills.

Project Requirement: Develop a comprehensive automation suite to validate the entire ETL process from source file validation to target file generation, including transformation validation.

Role and Responsibilities:

• Automation Suite Development: Created an end-to-end automation suite using Robot Framework to validate ETL process.
• Technical Implementation: Enabled Robot Framework to connect with Unix and database environments for performing multiple transformations and data validations.
• Onshore Experience: Gained two years of onshore experience in Germany, focusing on client handling and project delivery.
• Client Handling: Managed client interactions and ensured their requirements were met effectively.
• Automation Testing: Developed automated test cases and framework based on business requirements.
• Business/Requirement Analysis: Conducted business and requirement analysis to ensure accurate project implementation.
• Project Approach and Estimation: Contributed to project approach planning and estimation to ensure timely and efficient delivery.

Project Requirement: Validation of data at each stage of the ETL process, including source files, staging tables, transformations in the core layer, and the output layer for reporting.

Role and Responsibilities:

• Functional and User Acceptance Testing: Performed comprehensive functional and user acceptance testing (UAT) to ensure data accuracy and integrity.
• SQL Query Development: Wrote SQL queries for testing and troubleshooting issues within data warehouse environment.
• Test Documentation: Developed detailed test plans, test cases, estimations, and test strategy documents to guide testing process.
• Defect Management: Tracked, prioritized, and organized defects, ensuring timely resolution and continuous improvement in data quality and system performance.