Md Swallah Asraf Sarfuddin

· Executed sourcing data analysis from various sources, ensuring compliance with business requirements.

· Authored data models and design documents to streamline ETL component development.

· Developed ETL components, focusing on mapping, workflow creation, and parameter file management.

· Reviewed test cases collaboratively with the business, documenting results in Zephyr for transparency.

· Automated jobs in higher environments, significantly reducing manual intervention and error rates.

· Engaged in sprint planning sessions to monitor progress and assist team members as needed.

· Presented changes to stakeholders while addressing business questions regarding testing outcomes. Supported operational teams during critical monthly and quarterly production validations.

• Analyzed mapping documents for multiple portfolios, including wealth management and wealth view.
• Maintained coding standards and best practices throughout development process.
• Executed unit testing by mocking data to validate functionality post-development.
• Created comprehensive unit tests and submitted documentation for review.
• Initiated migration requests for workflows and table migrations as required.
• Coordinated with data modeler on table creation and source team on data availability.
• Developed SIT handover documents and scheduled meetings with SIT team to explain business rules.
• Facilitated knowledge transfer regarding implemented logic during handover sessions.

• Executed migration project from Informatica Cloud to Apache Spark to reduce operational costs.
• Analyzed existing Informatica Cloud jobs, assessing dependencies, scheduling, and load types.
• Ingested data from Salesforce objects into HIVE using Apache NiFi for job transformation.
• Replicated production jobs in development environment and tested with mocked data.
• Enhanced existing code to align with Spark coding standards and resolve implementation challenges.
• Compared result files generated from both systems, identifying discrepancies for correction.

Transformed all existing Informatica Cloud jobs while preserving original logic in Spark framework.

• Sourced treasury data from diverse systems, including bank and customer details.
• Applied technical data quality checks to ensure accuracy and reliability of information.
• Delivered financial data to OFSAA team using SCD TYPE-II calculations.
• Designed reusable frameworks for processing data from heterogeneous sources like BAM and QUANTUM.
• Developed data model and design documents alongside defect-free ETL components.
• Automated job execution in higher environments to enhance efficiency and reduce errors.
• Conducted unit and functional testing for various mappings to ensure performance integrity.