Mitali Madhumita Das

Project: SDM (Strategic Debt Manager)

I am currently working as an engineering lead and data designer for one of the cloud migration projects for the Collection & Recovery domain. This domain is mainly categorized into four products, and it is currently running on an old legacy system. My team and I are building a strategic solution for two of the products. With this strategic platform, all these legacy platforms will be merged in SDM. However, this is not mere application migration; while doing so, the business will look to revisit the requirements and try to optimize them, as well as bring a customer-level view for collections and recoveries processes.

The Technical Aspect :

Through the dual hydration process, we ingest the source data to the raw layer, and then to the base layer on the Cloud. Post tokenization, detokenization, and transformation, data gets loaded via Glue jobs to the S3 bucket, and through Athena, data is consumed in the FDP (Foundational Data Product). In BDP (Business Data Product), data consumed through Snowflake. Currently, data consumption through Iceberg is in progress. For scheduling, we use Astronomer. For reference table data load, we use the SDH tool (Strategic Data Hub). Data lineage is maintained in Alation. To bring the data producers and data consumers together to share data assets across the organization, we use the Marketplace.

Responsibilities: Engineering Lead & Data Designer

• Reviewing the requirements with consumer teams to finalize the scope, and following up with them until the final requirement sign-off.
• Working closely with the data modeler to define the data model and architectures using ER Studio, based on the requirements received, and to ensure the right alignment of the attributes.
• As a data designer, I analyze the source data using Hive and Teradata, define source-to-target mapping in an optimized way, and maintain them in GitLab.
• Reviewing the design with the system SME and stakeholders, ensuring solutions meet business needs.
• Collaborating with data engineers to build the solution using PySpark, and reviewing the target end results and test evidence, ensuring data consistency and data quality.
• Before loading the data to FDP (Foundational Data Product), I'm ensuring the CDEs (Critical Data Elements) are defined appropriately and maintained accurately in coordination with the data governance team to meet the compliance needs.
• Coordinating and discussing with various stakeholders, and the Product Owner, for timeline commitments. Responsible end-to-end data product implementation.

Project 2: Debit Card CAMS

CAMS is having multiple unsupported platforms and user-managed reports. The challenging task is to perform an IA and identify the work scope by understanding the existing E2E process of a 10+ year-old legacy system with huge manual dependencies. However, I've gathered the details and prepared a business proposal for PO to review.

Responsiblities: Data Architect

• Collaborated with CAMS SMEs and the ACE team to understand the platform dependencies and manual work efforts.
• Engaged with multiple stakeholders, gathered, and analyzed the business requirements to come up with an approach document.
• Performed lineage analysis and data discovery for VISA MI, along with seven other internal and external reports, to check if automation is feasible or not.
• Assessed the re-engineering possibility for access database and existing ACE processes to a strategic platform to set up a service-managed and automated pipeline.
• Pain areas explored are 1. CAMS raw data processing 2. ACE data transformation logic 3. Business data formatting and submission. These three areas have been identified as the most critical ones vulnerable to manual errors and hence, migration or automation was recommended.

Project 3: Cloud Migration for usecase - COO Dashboard

A dashboard with KPIs across various product lines, channels, and processes is currently published to BUK ExCo to assess the overall performance. The current implementation of the dashboard is manual, where the data is manually sourced from various sources across the BUK warehouse, including user-managed data. The goal is to build this dashboard on the strategic enterprise data platform (EDP).

Responsibilities: Data Architect & Senior BA

• Spreaheaded the data analysis part for COO Dashboard which was having 86 metrices including the external sourced ones and prepared an IA report for review
• Led the E2E analysis for 8 domains including the hydration prerequisites
• Performed lineage analysis and data discovery for associated metrics to assess the design approach (Tactical/Strategical).
• Collaborated with an external third party for one of the complaint metrics to integrate their data onto the cloud, addressing the risks associated.
• Identified the hydration requirement for FDP and created the required feature and capability on the JIRA board.
• Efficiently identified the cross-data product dependencies and initiated the engagement by establishing a BO/Capability through LCT.
• Prepared design approaches in order to procure cross-domain reference data onto the Cloud in coordination with the Lead Data Architect.

• Involved and helped Senior Managers to establish direction and goals amongst Project team.
• Oversee multiple projects across all phases of development.
• Addressed and resolved project risks, roadblocks, and obstacles while securing resources to efficiently complete deliverables.
• Assigning roles & responsibilities to individual team members ensuring timely resolution of all issues by maintaining consistent communication with Client and making follow-up calls.
• Involved in defining & prioritizing Features/User Stories along with SLAs with Stakeholders and Clients. Also monitored complete workflow and made timeline adjustment as needed.
• Maintained and contributed to the development of project process improvements and best practices.
• Provided updates to the management and the business to keep them informed of any system issues.
• Conducted and participated in System Demos for every IP (Iteration Planning).
• Participated in quarterly SMR Meetings and contributed in identifying areas of concern.
• Conducted appraisal meetings and participated in weekend/weekday drives as L2 panelist.
• Review new requirement specifications of User Stories for different Features assigned on the Rally/JIRA board w.r.t. a particular Sprint/iteration for entire team during Iteration Planning.
• Perform impact analysis and analyze mapping (STTM/ RDM) document for Features having high priorities as well high complexities.
• Support other team members: providing mentoring, technical assistance, troubleshooting and alternative development solutions.
• Provided guidance to the team and prepared checklists to avoid end to end integration issues later on.
• Establishing and sharing design and development techniques of the ETL process in collaboration with different teams.
• Preformed design reviews (Internal/Cross Vendor) and quality control of deliverables.
• Application Maintenance Support (AMS) project exposure in terms of Production Load Monitoring along with handling customer generated incidents and work request following ITIL Process.
• Change Management, Release Management exposure in handling QA and Production changes/releases and post deployment activities.
• Design and development of Ab Initio graphs/plans/psets using GDE and execution through different scheduling tools like Autosys and Control Centre.
• Created and loaded new DB tables using Generic graphs for history, preload and incremental along with Inline reconciliation process.
• Analysis and bug fixing of Inline reconciliation failures in every environments.
• Perform end-to-end testing at different environments along with capturing test evidences and uploading them to the shared drive.
• Perform data refresh/mock-up activities from Production to lower environments using TDM (Test Data Management) tool for one-shot execution and data validation.
• Carry out performance load testing for new tables with high data volume in co-ordination with the ‘Performance Team’ at onshore.
• Perform testing using Python automation tool for certain selected enhancements at lower environments.
• Perform historical data correction for DB tables in Production environment.
• Migrated Ab Initio codes for different projects to higher environments using Github, Jenkins and UCD and checking in the code/DB checkout Script/One shot SQL to SVN (Tortoise).
• Initiated and maintained self-reviews and peer-reviews against standard checklists
• Creation of Lotus notes request/ BRS request for job migration to higher environments.
• Creation of new design/technical/story/deployment documents for future references.
• Roles Performed: Project Lead, Tech Lead, Offshore Coordinator, Senior Developer

• Gather and review the requirement specifications.
• Perform impact analysis.
• Modify/Design graphs, psets & maestro schedules using GDE and UNIX.
• Compilation and execution of graphs/schedules and fixing runtime issues.
• Perform UT along with evidences.
• Tag creation in coordination with the EME team.
• Creation, Updating of design documents.
• Creation of low level test cases for SIT and uploading them to MQC.
• Deployment planning along with creation of deployment documents.
• Design/modify jobs & sequences as per the new requirement.
• Migration of 600+ Datastage jobs to new server.
• Verification of DB Indices.
• Verification of data connection and parameter values within Datastage.
• Job compilation and execution through Sequence.
• Fixing runtime issues.
• Performing 3 types of data validation:
• Level 1 – Row count validation
• Level 2 – CIT
• Level 3 – Foreign Key Validation
• Providing support to the Konecranes applications and resolving Incident/Ticket.
• Onsite Coordination and direct client interaction.
• Production support (24 x7) of application including maintenance support during weekends.
• Roles Performed: Senior Developer, Tech Lead, ETL Tester

• Gather and review the requirement specifications.
• Perform impact analysis.
• Design/modify DataStage jobs as per the new requirement.
• Development and enhancement of reports/universe in Business Objects.
• Involved in writing and executing test cases using Quality Center (QC) to evaluate quality and performance.
• Involvement in system tuning and query tuning as per the project requirement.
• Execution of jobs using Control M scheduling tool.
• Creation of RFC for Higher environment code deployment with Client.
• Creating and updating of requirement documents.
• Roles Performed: ETL & Report Developer