SURAJ BISWAS

Client: Telefónica Germany

• Designed and maintained end-to-end K2View Broadway flows for customer and order creation, automated data validation, and bulk migration, while ensuring seamless integration with Salesforce, incorporating performance reporting.
• Led dry runs, managed test and live data migration activities, ensuring smooth and accurate data transfer from cross-DB sources to target stacks, i.e. SFI/RAITT and relevant downstream applications.
• Automated data validation to identify eligible or ineligible customers, summarize failure reasons, and generate detailed reports based on business input.
• Served as a core MCCC team member, resolving Production and LRT bugs, and addressing Hyper Care topics raised by the client.
• Led multiple LRT and production run sessions, interacted with client forums, addressed queries, and implemented immediate fixes for minor issues.
• Created migration controller tables, which supported reconciliation reporting, and served as a master data source during post-migration activities.
• Handled history migration flows, and implemented automated delays for large-scale API job execution and failure tracking.
• Collaborated in business mapping, and finalized the data scope with clients.
• Maintained project delivery timelines while balancing team support.
• Developed API payloads and automated end-to-end flows using K2View Fabric Studio.
• Mentored junior developers, and collaborated effectively to achieve critical migration objectives.

Client: Grameenphone Ltd.

• Worked as part of the development team on the AEP Data Warehousing project using tools like DBVisualizer, DBeaver, Impala, and MySQL Workbench.
• Processed raw and structured telecom data using ETL tools to support business insights and analytics.
• Developed and tested Vertica and Hive SQL scripts for Tier 2 and Tier 3 data layers, based on SMX mapping sheets provided by the data modeling team.
• Handled development tasks across multiple SCD types (Slowly Changing Dimensions) within Agile sprints.
• Investigated and resolved defects reported during SIT (System Integration Testing) and UAT (User Acceptance Testing) phases via JIRA.
• Performed data reconciliation and gap correction for monthly data loads, ensuring data accuracy across tiers (T2/T3).
• Conducted report validation (T4 layer) and performed root cause analysis by drilling through ODS to T4 layers, applying code fixes as needed.
• Improved performance and efficiency of existing ETL jobs and SQL queries through code optimization.
• Assisted in validating delivered reports based on the client’s business logic and requirements.
• Monitored post-deployment data patterns to ensure system stability and report accuracy after delivery.

Client: DIGI Malaysia.

• Contributed to the AEP Data Warehousing project, processing raw and structured data using DBVisualizer and MySQL Workbench.
• Developed and implemented SCD Type 1 and Type 2 logic to manage historical data changes.
• Created and maintained Vertica and Hive SQL scripts for Tier 2 and Tier 3 layers, following SMX mapping specifications.
• Built dimension and fact tables in the aggregation (Tier-3) layer to support reporting and analytics.
• Developed various Base, Digi, and MVNO views to support different business segments.
• Investigated and resolved issues and JIRA defects identified during SIT and UAT testing by the client.
• Performed code optimization to improve performance and ensure the efficiency of ETL workflows.
• Conducted unit testing to validate that the developed logic met business requirements.
• Transformed and integrated data from multiple sources into the data warehouse, applying business rules to ensure accuracy.
• Provided production support and performed issue resolution as per project needs.