Madhusmita Mishra

Group Retail Datamart, Data Migration and Adobe Campaign project

• Working on Retail Datamart project across Singapore, Thailand and Malaysia, Indonesia and Vietnam
• Worked on data mart security access matrix, providing documentation to stakeholders, doing data profiling and preparing data dictionary
• Collate and manage all the details regarding the application for the assigned business vertical
• Liaise with project stakeholders (Tech and Biz) in defining detailed functional specifications and clarifications
• Analyze and transform business requirements into solutions with the help of Development teams
• Prepare, maintain and communicate functional documentation
• Plan, prepare and execute the qualification strategy and test of the target solutions
• Identify Test data required to complete test activities
• Review Test plan and the Test scenarios
• Steering of UAT and reporting status to project stakeholders
• Report and escalate key risks and issues related to project execution
• Support the project planning, schedules and milestones in coordination with project teams
• Hands on experience in working on large data platforms
• Strong understanding of Agile methodologies
• Working level experience in management tool (Jira, confluence, Share Point)
• Project planning and strategy
• Conducted stakeholder workshops to define data migration objectives, scopes and timelines
• Developed a data migration strategy aligned with business goals and requirements
• Created detailed project plan outlining phases, milestones and resource allocation
• Data Assessment and Analysis
• Performed data profiling to assess the quality, completeness and accuracy of source data
• Identified and documents data discrepancies, redundancies and gap
• Collaborated with business users to define data mapping rules and transformation logic
• Data Cleansing and preparation
• Led data cleansing initiatives to ensure data accuracy, consistency and compliance with the bank standards
• Data mapping and Transformation
• Mentored data mapping specifications to translate data from source systems to target systems
• Ensured data transformation adhered to business rules and requirements
• Involved in creating batch calendars to make sure the upstream and the downstream systems are synced to provide data accordingly

• Extensive Knowledge on Consumer Banking domain, Mobile payments apps, onboarding apps, Subsystems involved, Credit/Debit cards payment structures, Rewards and cash back process, Test Data creations with sub teams
• Backend verifications (Mainframe)
• Owns the product roadmap
• Actively taking part in requirement gatherings, Sprint Planning, Sprint Retrospective meetings, Daily stand ups
• Preparation of Test Plans which includes the Entry and Exit criteria
• Coordinating with Team on the sprint progress
• Create reports from JIRA to communicate the project status
• Develop scope and define backlog items (epic/features/user stories) that guide the Agile dev team
• Solve product related problems, make decisions to stay on track towards deliverables
• Demonstrating presentations/Demo to stakeholders
• Possess a fundamental understanding of end-to-end customer experience integration and dependencies
• Collaboration with stakeholders
• Accountable for delivering product and communicating the product needs with partners
• Assess value, develop cases, and prioritize stories
• Develop proper detailed specifications of the features so that they are understood by the dev team
• Work closely with product management and senior management in order to create a product that fits company portfolio
• Proficient in Agile methodologies
• Creating product deck for partners and support teams

• Company Overview: Client OCBC
• Auto Rome application is designed to enable internal staff such as Product manager parameter for e.g
• Product features
• Sales staff able to guide customers through FNA module to purchase protection, investment products in AutoRome
• Domain knowledge on Retail Banking applications
• Project included Features added to the Auto Rome applications (opening a bank account) which included different account types
• Leading a team of 10 people from Test planning till Test Execution phase (till closure)
• Daily defect calls and preparation of daily status report
• Working directly with client to understand the scope and documenting the same
• To provide daily estimation
• Co-ordination with developers and BA on daily basis on defects and closure of the same
• Expertise in HPQC(From Requirements to Test Planning)
• Parameterization in QC
• Providing training to Team members
• Track of daily defects logged to the number of test cases executed
• Mapping of Business to Functional requirements
• Test scenario preparation for each module and reviewing the test suite
• Taking approvals from clients on the scope covered
• Banking Essentials knowledge
• Client OCBC

• Extensive knowledge on Brokerage Domain which includes New accounts opening, maintenance, documentation, Risk analysis, Investment Banking, Regulatory Requirements, Securities, Trading accounts, Compliance (AML,KYC), Equities and Derivative securities, Fixed Income Securities
• Experience working in trading system, Account Management system, Customer onboarding, Working knowledge End to End trading life cycle
• Preparation of FSD, RTM and the Test Planning documents(Through PMUWS)
• Extensive knowledge on Wealth Management and Retirement plans (401k, IRA plans)
• Working closely with Business Program Manager and Release manager to prioritize the future scope of work and analysing and grooming the epic
• Work closely with stakeholders and change management to identify impacts to business processes as a result of changes
• Facilitate collective understanding and document scope, requirements and design amongst stakeholders including sponsors, decision makers, content owners end users and technical team
• Collaborating with onshore partners in understanding the business requirements
• Perform Gap analysis to identify system component and data structure coverage based on business requirements
• Creating monthly metric report and capturing the monthly financial data
• Confirming quality services are delivered with regard to the agreed SLA

• Good Diagnostic ability (Business point of view)
• Involved in Business Process Testing
• Involved in designing the functional documents and keeping a track of it in SharePoint
• High Level scenarios preparation
• Involved in Requirement Analysis and Designing
• Preparation of Test Strategy, Ambiguity documents, Estimation sheet, Closure documents
• Preparation of monthly Metrics
• Creating Process Diagrams (Related to specific applications)
• Defect Tracking with Project Managers
• Involved in multiple IDEA projects (Continuous Improvement projects)
• Working with different teams Test Planners on understanding the project related requirements
• Production patches/mainframe testing and coordination
• Knowledge on different services (interfaces) affecting the applications
• Maintaining the entitlements related changes
• Preparation of Ambiguity docs
• Working with Automation Team to streamline and Automate the Regression Suite

• Worked on AIX Environment
• Executed Testcases based on Pearl Script
• Involved in preparing Test Plan
• Performed I/O operation by creating own Test Stand
• Performing test according to the test plan and logging defects in CMVC
• Identifying the logs and then uploading it to the server

• Company Overview: Client GE Treasury
• Extensive knowledge on Treasury products
• Involved in Creation and execution of Data Migration Scripts for HPSM
• Worked on automation scripts (Writing and executing scripts) for HPSM
• Involved in Database testing
• Test Case Execution
• Update the Defect Log
• Detailing of Requirements
• Creation of Test plan and Test Cases/Defect Reporting and Tracking
• Client GE Treasury