Smita Sil

For the National survey of India , the government of India works as Technical business Analyst for ASI ( All India survey of Industry)

• Digital transformation initiative, integrating Agile methodologies into the project
• Analyzed business requirements to understand business needs.
• Combined business and systems knowledge to create functional designs.
• Performed critical analysis on information consolidated from multiple sources, identified and resolved conflicts and broke down high-level information into detailed workable requirements.
• Bridged the gap between technical teams and business units by translating complex concepts into easily understandable terms.
• Evaluated business requirements and translated them into detailed functional specifications for technical teams to implement.
• Reduced project risks by proactively identifying potential roadblocks and working collaboratively to address them.
• Continuously refined Agile methodologies within the organization, fostering a culture of innovation and adaptability.
• Enhanced team collaboration through daily stand-up meetings and effective communication channels.

Scrum master in UK media intelligence company (Informa)

• Scrum master for 3 squad team consist of 30+ members in stuff augmentation mode.
• Achieved a streamlined workflow with a 35% increase in overall efficiency and 20% faster project completion rates.
• Guide Product Owner in creating Project Roadmap for better execution of the deliverables on time.
• Generating various Dashboards & Reports with efficient use of Jira to help in Project Status and Impediments tracking.
• Managed product backlog effectively, prioritizing high-value items for faster completion.
• Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews, and sprint retrospectives.
• Streamlined and optimized workflow and communication by implementing Agile frameworks.
• Resolved conflicts and facilitated open communication among team members, promoting a healthy work environment.

AWS Migration project from Informatica as ETL Teradata as DWH to Apache Spark and Databricks and Microstrategy BI for Agile scrum based cloud project for NBCU , USA

• Scrum master for a team of 17+ working on AWS migration from Teradata to Databricks.
• Manage Testing deliverables with 4+ test team
• Understand Scope of Project from informatica and Teradata moving into AWS platform AWS S3, CloudWatch, Athena, Airflow and Lambda mainly working in this component.
• Facilitated Scrum framework – sprint planning, backlog grooming, daily scrums, sprint reviews, and sprint retrospectives.
• Define testing scope and tools and processes for each area including ETL and BI (functional and non-functional)
• Implemented key performance metrics to track team progress and identify areas of improvement consistently throughout projects'' lifecycles.
• Incorporated delivery requirements into planning of testing schedules.

Test Lead and Scrum Master in top priority control project for BICEP (Barclays Internal Controls Enhancement Plan)

• Be agile transformation team in Barclays, Implemented E2E agile conversion in for 150 people team under agile coach and become scrum master for team of 20 for 2 years
• Lead two Scrum team holding 10 members and successfully transform the team mind set from waterfall to Agile
• Increase Team velocity from 90 to 110 sp within 6 months
• Manage DWH deliverables with 7+ test team including internal members as well as vendor partners
• Interaction with 3 PO regularly related to sprint dependencies and relationships.
• Facilitating discussion, decision making and conflict resolution across all cross-function Biz teams
• Test strategy for informatica to Bteq migration takes place in DWH environment
• Manage and coach test teams – both internal and vendor partners
• Facilitate Team planning and Priorities, tracking activities while coaching in agile principle.
• Lead all Sprint activities, daily calls and sprint retrospective and facilitate other activities of Scrum.
• Understand the scope of BICEP in DWH area and testing scope
• Test Environment setup for Database, Unix, and Jira.
• Estimate efforts and timelines to meet the project goals
• Test Environment setup for Database, Unix and Jira.
• Provided reports on milestones, issues and test concerns to project managers for assistance.

Continuous Integration & Testing for Barclays' Structural Reform Program (SRP) for regulatory requirements

• Understand emphasis of SRP and help in creation of the right fit program test strategy
• Produce CIT plan and approach aligned to the program goals
• Estimate efforts and timelines to meet both program and organizational goals
• Manage the CIT phases with regular status reporting on the test progress, defects, and issues
• Work with SCRUM master to provide testing updates to the Product Owner
• Streamlined testing processes for increased efficiency and reduced overall test cycle time.
• Provide key QA documentations and other metrics for future improvements such as defect prevention
• Established regular communication channels between onsite and offshore team members, ensuring seamless coordination despite geographical barriers.

Continuous Integration & Testing for Barclays' Global Cash Management Strategy implementation through MassPay for ETL, DWH, and Cognos reports

• Produce CIT plan and approach including DWH testing, ETL testing, DB testing, ETL and Cognos reporting testing
• Estimate efforts and timelines to meet the project goals
• Manage deliverables with test team including internal members as well as vendor partners
• Selection of the right skills from the vendor partners and on-boarding
• Manage the CIT phases with regular status reporting on the test progress, defects, and issues
• Provide key QA documentations and other metrics for future improvements such as defect prevention
• Developed metrics-driven reporting mechanisms to track progress against established goals and timelines throughout the ETL testing lifecycle.

Senior Testing Analyst – Successful outsourcing of USD clearing to JPMC.

• Involved in a multi-vendor team with representation from Barclays and other vendors.
• Review and validate test approach for integration testing.
• Review and validate test scenarios and cases for ETL testing, MDM testing, DB testing.
• Perform hands-on integration testing to validate the testing outcomes.
• Elevated product quality with rigorous regression testing before each release cycle.

Senior DB tester on Informatica MDM for a large banking customer RBC based at Quebec, canada which involved Database and UI testing, Data load testing, Integration testing, MDM testing, Trillium testing

• Streamlined workflows with effective communication between team members and clients.
• Enhanced client satisfaction by promptly addressing their technical concerns and providing solutions.
• Delivered timely support during critical situations, minimizing disruptions to client operations.
• Streamlined testing processes for increased efficiency and reduced overall test cycle time.
• Reduced defect leakage rate by conducting thorough root cause analyses and proactively addressing areas of concern in future release cycles.
• Collaborated with developers to ensure timely resolution of identified issues, resulting in improved customer satisfaction.
• Communicated project status to stakeholders, authoring reports to provide up-to-date overviews of ongoing progress.

Senior DB tester on Informatica MDM for a large PBM firm AstraZeneca which involved Database and UI testing, Data load testing, Integration testing, MDM testing, Trillium testing.

• Manage the testing of a module independently with a small team.
• Identified critical bugs through thorough testing processes, enhancing overall product performance.
• Contribute in the overall test approach and planning.
• Collaborated with development teams to resolve defects and improve the overall stability of applications.
• Optimized test coverage, carefully selecting test scenarios to ensure all critical paths were evaluated.

DB tester on IBM MDM and ETL tools for a large PBM firm Medco in New Jersey, USA which involved ETL testing, DB testing, Data load testing, Integration testing, MDM testing.

• Understand the requirements and plan testing.
• Authored test cases and wrote acceptance tests for developed features.
• Established a strong record of defect detection in database systems, ultimately contributing to higher quality products for end users.
• Coach other team members in test case creation.
• Improved data integrity with the implementation of rigorous validation procedures.