Sunitha Devi Mallampalli Email & Phone Number

Dublin, County Dublin, Ireland

Dublin, County Dublin, Ireland

Played the role of Release Manager for the Digital Banking programme at PTSB, Dublin.• Led the release process by collaborating with project stakeholders to define the release scope, identifying the dependencies and developed comprehensive runbooks with a detailed release schedule.• Proactively facilitated daily communication with Dev, Test, Business Analysts, Product Owners, and Operations teams to identify and swiftly resolve any roadblocks.• Coordinated the deployment of… Show more Played the role of Release Manager for the Digital Banking programme at PTSB, Dublin.• Led the release process by collaborating with project stakeholders to define the release scope, identifying the dependencies and developed comprehensive runbooks with a detailed release schedule.• Proactively facilitated daily communication with Dev, Test, Business Analysts, Product Owners, and Operations teams to identify and swiftly resolve any roadblocks.• Coordinated the deployment of builds across non-prod environments by collaborating with Dev and Test teams and ensured seamless code integration through meticulous tracking of code merges across parallel projects.• Facilitated collaboration with third-party vendors for penetration and performance testing activities. This involved clearly communicating the release scope, providing them with the necessary details such as API Specs, test data. Analyzed and reported the test results to the program team.• Led daily defect triage calls with all key stakeholders to prioritize and address critical issues, ensuring timely release.• Maintained comprehensive release status visibility for stakeholders by leveraging JIRA dashboards, defect metrics, and Confluence pages to effectively communicate progress across non-production environments.• Effectively communicated release readiness to the CAB committee by presenting necessary artifacts to secure approval for production / DR deployments.• Provided support during hyper care period to triage production issues with business and technical teams, and ensured the defects are addressed and fixes are deployed.• Documented the details in Confluence and maintained the release artefacts. Show less

Hyderabad, Telangana, India

Played the role of Datawarehouse test lead for WMA Data & Reporting team of UBS. Successfully collaborated with program stakeholders and global delivery team to ensure project objectives were met.My Responsibilities Include :• Understanding the business requirements and analysis of impacted datasets in Datawarehouse due to changes in upstream source files.• Created test plans and executed test cases to ensure data is clean and loaded into Data Mart for business… Show more Played the role of Datawarehouse test lead for WMA Data & Reporting team of UBS. Successfully collaborated with program stakeholders and global delivery team to ensure project objectives were met.My Responsibilities Include :• Understanding the business requirements and analysis of impacted datasets in Datawarehouse due to changes in upstream source files.• Created test plans and executed test cases to ensure data is clean and loaded into Data Mart for business reporting.• Developed and executed Automation scripts for validating data load and transformations in all layers of the Datawarehouse using Python and Shell scripts.• Identified and diagnosed data load job failures in Mainframes, SQL Loader, Informatica and assigned them to Data Engineering team for fixing the defects.• Created JCLs to extra the required data from source files as part of data validations.• Tracked all the bugs to resolution and followed up with upstream for source file issues.• Validated data quality rules for consistency, accuracy, and completeness by leveraging Hive and Impala against Tableau reports.• Performed Initial / incremental Data Load testing between Legacy Oracle SQL and Azure Synapse as part of Azure cloud DW migration testing using PERL automation scripts.• Prepared and reviewed the Test Closure Report with business stakeholders to document the QA results and to obtain QA sign-off.• Mentored the team in understanding the requirements, identifying the test scenarios, preparation of test cases and reviewed the test results. Show less

Hyderabad Area, India

Led the team in testing the OEM Activation 3.0 Business Intelligence program of Microsoft.My Responsibilities include:• Understanding & review of the BRD, Functional and Technical Specifications to ensure data requirements are clearly and concisely defined.• Created master test plans and executed test cases to ensure data is clean, transformed according to business requirements and loaded into Data Mart for business reporting.• Validated measures in OLAP cubes against… Show more Led the team in testing the OEM Activation 3.0 Business Intelligence program of Microsoft.My Responsibilities include:• Understanding & review of the BRD, Functional and Technical Specifications to ensure data requirements are clearly and concisely defined.• Created master test plans and executed test cases to ensure data is clean, transformed according to business requirements and loaded into Data Mart for business reporting.• Validated measures in OLAP cubes against Data Marts.• Designed Test scenarios and Test cases.• Performed rigorous Static Code reviews in SQL & Informatica.• Validated data load and transformations from source to Integration, Integration to Mart, Mart to Target Cubes using complex SQL queries.• Automated ETL validations for metadata, data load and data transformations using C# scripts.• Analysed Job failures by debugging Informatica Workflows. • Logged defects with right priority using TFS (Team Foundation Server) and assigned to Dev team.• Performed Regression and Smoke Test activities.• Supported and analysed UAT/PROD issues.Tools Used: SQL Server 2008R2, Informatica, SSAS, TFS Show less

Bengaluru, Karnataka, India

As a Quality Assurance Engineer involved in manual and automation testing of the Symmetrix storage developed by EMC. > Execution of Regression / Smoke / Continuous testing.> Testing the remote copy services such as PPRC, XRC and Flash Copy operations.> Escalation of the defects found during testing.> Logging/re-testing the test defects through OPT.> Maintenance of Symmetrix storage boxes.Solution Environment: EMC SymmetrixTools Used:… Show more As a Quality Assurance Engineer involved in manual and automation testing of the Symmetrix storage developed by EMC. > Execution of Regression / Smoke / Continuous testing.> Testing the remote copy services such as PPRC, XRC and Flash Copy operations.> Escalation of the defects found during testing.> Logging/re-testing the test defects through OPT.> Maintenance of Symmetrix storage boxes.Solution Environment: EMC SymmetrixTools Used: STCMON, Symm Win, OPT, Mix, Auto MFT, Box Tracker Show less

Mumbai Area, India

Led the team at offshore to launch a new group product MEGA for Genworth Financial assurance company. The scope of the project included requirement gathering, analysis, design, implementation and unit testing of the solution.> Understanding and analysis of the business requirements.> Prepared High Level/Low Level design documents and reviewed with the customer.> Implemented the proposed solution in Mainframes using JCL, COBOL, VSAM. > Prepared and reviewed Unit… Show more Led the team at offshore to launch a new group product MEGA for Genworth Financial assurance company. The scope of the project included requirement gathering, analysis, design, implementation and unit testing of the solution.> Understanding and analysis of the business requirements.> Prepared High Level/Low Level design documents and reviewed with the customer.> Implemented the proposed solution in Mainframes using JCL, COBOL, VSAM. > Prepared and reviewed Unit test plan and test cases.> Mentored and delegated work to the team. > Supported the UAT phase.Solution Environment: IBM Mainframes.Tools/Languages: File Aid, PANAPT, JCL, COBOL Show less

Richmond, Virginia, United States

Business/Data Analyst @ Sales and Marketing (LTC and RI&I), Genworth Financial.> Understanding the requirements of Business users. > Analyzed business requirements and provided them with feasible solutions.> Designed functional specification documents.> Worked with development team in implementing the solutions. > Performed User Acceptance Testing for the implemented changes.> Maintained Marketing Materials Database with minor changes requested by… Show more Business/Data Analyst @ Sales and Marketing (LTC and RI&I), Genworth Financial.> Understanding the requirements of Business users. > Analyzed business requirements and provided them with feasible solutions.> Designed functional specification documents.> Worked with development team in implementing the solutions. > Performed User Acceptance Testing for the implemented changes.> Maintained Marketing Materials Database with minor changes requested by business.> Developed Oracle forms to assist business team for clarified requirements which involved migration of 3000+ LTC marketing materials to the new system (Custom Point).> Documented business process. Show less

Mumbai Area, India

Involved in supporting, maintaining and enhancing of AES, Oracle Comp and Agent Database applications of Genworth Financial. Involved in resolving critical abends during the production support and in the design and development of enhancement requests.> Provided 24 X 7 application support / Technical Support for the Application Users.> Developed fixes for runtime issues due to data errors.> Designed and developed permanent fixes for critical repetitive application… Show more Involved in supporting, maintaining and enhancing of AES, Oracle Comp and Agent Database applications of Genworth Financial. Involved in resolving critical abends during the production support and in the design and development of enhancement requests.> Provided 24 X 7 application support / Technical Support for the Application Users.> Developed fixes for runtime issues due to data errors.> Designed and developed permanent fixes for critical repetitive application errors.> Unit Tested the Implemented Changes and provided support post implementation.> Maintained Application and Agent databases in Oracle.> Worked on merging of mainframe datasets into Oracle database.> Worked on various requests which involved in developing/updating the Oracle Forms for business users.> Worked on creating and modifying mappings in Agent Database using Informatica. > Documented the resolution details for every problem reported.Solution Environment : IBM – Mainframes,HP-UNIXTools/ Languages: Appworx, InformaticaPowercenter 6.0, Oracle Forms 6.0, File Aid, PANAPT, PVCS, JCL, COBOL. Show less