Software Development Scrum Master

Prasad Grama Phone: 703-***-****

*******@*****.***

Active Secret Clearance

https://badgecert.com/bc/html/img/badges/generated/badge-7227.png

Professional Summary:

Over Fifteen years of intense experience in Software Analysis, Testing and five years of experience in Software Development.

Resourceful result-focused professional with proficiency in technical disciplines and quality strategies to successfully integrate business needs and technology application.

High level of collaboration and influencing skills, managing staff & cross-functional / cross-cultural teams, multi-tasking & delivering critical projects on time, QA Analysis, Lead Test, Development, and implementation of various client/server applications.

Experience with different kinds of testing- Functional, ETL, Smoke, Black box, regression, white box, and automation testing.

Experience with software development life cycle (SDLC), Agile Process,

Complete testing life cycle process and procedures.

Performed the Extract Transform and Load ETL : source to target, utilizing Informatica Power center and Data Validation Option DVO .

Experience with Implementation and Administration of JIRA.

Implemented Data Validation Option DVO for understanding on how to run tests, and evaluated the test results.

Possess strong technical, analytical, and communication skills

Communicate proficiently with strong problem solving and time management skills

As a Scrum Master Organized and facilitated for Sprint Planning meetings, Daily Standup Meeting and Retrospective meetings.

Continuously learned Agile/Scrum techniques and shared findings with the team.

Knowledge of VIS (USCIS), Consular Affairs (LVSMS) application, CBP(ACE), CBP(PSPO), CBP(TASPO) Web application, Financial Application, Electronic Toll Collection and Fleet Logistics System.

PROFESSIONAL SKILLS Quality Systems & Agile Management – SDLC – Test Environment Design, Strategy & Test Tool selection. Requirement Analysis, Change Management – RTM Metrics analysis ·

Performance and Compatibility programs – Business Analysis & Technology Transfers – System integration, Verification, Validations & Certifications – Interoperability / End-to-End / Acceptance / Compliance / Upgrade Testing – Training, Coaching and Mentoring – Customer Interactions.

Architecture fame work in Test Planning, Test strategy and Documentation in an Agile methodology and Release Readiness Review (RRR),

SKILL SET Active Public Trust Clearance (DOE)

Web Technologies

ASP.NET,VB.NET,ADO.NET,ASP,HTML,DHTML,XML,ADO,Java,MQMON, Web Sphere

Data Base

Oracle 11g, SQL and PLSQL,, SQL Server 7/2000, Informatica, Amazon Web Services (AWS), DBMS/RDBMS

GUI

VisualBasic 6,PowerBuilder, Actuate, Informatica10.1,ETL,DVO 10.1,Developer 2000, SAS, Designer 2000, Mosaic, HP Quality Center, Quick Test Pro(QTP), JAWS, HP, SOAP UI, Application Life Cycle Management (ALM) SharePoint, JIRA X-RAY.

OS

Windows 10/NT/2000/XP, DOS, Unix/Linux

Computing Environments

Data Warehouse, Data web housing, Data mining

Development Tools

Visual Interdev 6, Visio, Win Runner, Test Director and Quick Test Pro.

Source Control

PVCS Version Manager, Razor, JIRA X-RAY, Confluence, Selenium IDE

EDUCATION

MS Computer Science, Shippensburg University of PA USA.

BE (Bachelor of Engineering) in Mechanical, Bangalore University India.

BS (Physics, Chemistry & Math), Bangalore University India

Certified Federal IT Accessibility Initiative 508 Universe

Certified Training in PVCS Version Manager, OAO Corporation, 1997

Certified Training in Designer 2000, Oracle Corporation, 1996

Certified Training in Building Applications Using Oracle 7.0, Oracle Corporation, 1995

Certified Training in CASE 5.0, Oracle Corporation, 1994

CSM - https://badgecert.com/bc/html/img/badges/generated/badge-7227.png

WORK EXPERIENCE

Protected Health Information Management Services (PHIMS) Nov.2021 to Current

Department of State

Senior Software Test Lead – Data Migration Tester.

Washington D.C

Working on Protected Health Information Management Services (PHIMS) Department of State – Task Order 5 - Electronic Health Record Implementation Project.

Working on Allscripts- E learning Center training for various modules. Like Introduction to Practice Dashboards, Practice Analytics Ad hoc Dashboards Prerequisite Program etc.

Developing Test Cases for Allscripts Adhoc Testing for Chart, Print Default, Calls Customize modules.

Analyzing and submitting Allscripts Touch Works/Quest Diagnostics Orders/and validating Results for Interface Testing activities.

Attending Daily Scrum Meeting Analyzing, Developing and updating each story assigned to me.

Attending weekly meeting to discuss various issues, orders and Results for Allscripts Touch Works/Quest Diagnostics Orders/Results Interface.

Free Application for Federal Student AID(FAFSA) April 2020 to Nov

Senior Software Test Lead Washington D.C

Working as Senior Test Lead for Department of Education. The Free Application for Federal Student AID (FAFSA) for various applications like Web & Mobile applications for different cycles. Involved in Release Planning, Test Planning, Execution UAT testing, Review documents for various cycles including Web and Mobile applications.

Developed Test Plans, test scripts and executed the test scripts for FAFSA Project. Thorough out the project in various iterations/Sprints – conducted system testing, integration testing and functional testing.

Participated in Release Readiness Review (RRR), Retrospective meetings, and sprint planning and demonstrated stories to client.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Involved in writing test plan, test cases, actual testing, reporting issues documenting in JIRA Uploading and executing test cases. Producing report to management from JIRA X-Ray about the status of each application.

Developed test scenarios and scripts in partnership with the Functional Lead and SMEs

Managed the testing processes as per the test plan and validating the resolution of issues / defects.

Managed that defects identified during testing are accurately documented and appropriately assigned Compile and communicate test results in an accurate and timely fashion

Work with Program Manager to ensure effective communication of testing activities with the project team

Assist with the triage and prioritization of defects identified during testing

Manage overall test and defect tracking throughout the project, ensuring that all planned testing is completed in a timely manner and all resolved defects validated using JIRA.

National Aeronautics and Space Administration. (NASA)

Senior Software Test Engineer Washington D.C. May 2019 to April 2020

Working as Senior Test Engineer for NASA Head Quarters Information Technology Support Services (HITSS )III Project for various applications like SeviceNow Anti-Harassment, Action Tracker, CRM and various other applications. Involved in writing test plan, test cases, actual testing, reporting issues documenting in JIRA X-Ray uploading and executing test cases. Producing report to management from JIRA X-Ray about the status of each application.

Responsibilities:

Developed Test Plans, Test cases as per the requirement traceability Matrix.

Extensively interacted with developers, business & management teams to understand the HITSS III project business requirements and design document specifications.

Conducted actual testing from Jira x-ray by uploading test cases and executing tests.

Produced reports Pass/Fail for each story to the management.

Participated in regular project status meetings and QA status meetings. Extensively used and developed SQL scripts/queries in backend testing of Databases. Worked on issues with migration from development to testing.

Extensively tested several Business Reports –Dashboards to validate the reports data and cosmetics of the report for Anti-Harassment application.

Srisap Consultants Llc August 2018 to April 2019

Senior Software Test Engineer, VA

Managed as Senior Test Engineer for the United States Citizenship and Immigration Services (USCIS) office of Information Technology (OIT) Data and Business Intelligence Section (DBIS) for implementation of Enterprise Data Warehouse and Business Intelligence (DW/BI). Enterprise Citizenship & Immigration Services Centralized Operational Repository (eCISCOR) for Enterprise Data Warehouse and the Standard Management Analysis Reporting Tool (SMART) for Enterprise Business Intelligence. Managed VIS (Verification Information System) application to validate data which involves about 166 tables. Involved in 508 testing using WAT for BI reports.

Responsibilities:

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings for Data Warehousing Application.

Extensively interacted with developers, business& management teams to understand the USCIS VIS project business requirements and ETL design document specifications.

Participated in regular project status meetings and QA status meetings. Extensively used and developed SQL scripts/queries in backend testing of Databases. Worked on issues with migration from development to testing.

Implemented Data Validation Option DVO for understanding on how to run tests, and evaluated the test results.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Worked with ETL groups and business analyst for understating mappings for dimensions and facts.

Extensively tested several Business Objects Reports –Dashboards to validate the reports data and cosmetics of the report.

Implemented JIRA and administered for Creating new Stories, users and roles.

Participated in Release Readiness Review (RRR), Retrospective meetings, and sprint planning and demonstrated stories to client.

Developed Test Plans, test scripts and executed the test scripts for USCIS Project. Thorough out the project in various iterations/Sprints – conducted system testing, integration testing and functional testing.

Srisap Consultants Llc Sept 2014 to August 2018

Client: Immigration and Custom Services (USCIS)

Senior Software Test Lead, Fairfax VA

Managed as Senior Test Lead/Tester for the United States Citizenship and Immigration Services (USCIS) office of Information Technology (OIT) Data and Business Intelligence Section (DBIS) for implementation of Enterprise Data Warehouse and Business Intelligence (DW/BI) solutions which consists of two main system components: The Enterprise Citizenship & Immigration Services Centralized Operational Repository (eCISCOR) for Enterprise Data Warehouse and the Standard Management Analysis Reporting Tool (SMART) for Enterprise Business Intelligence. Managed VIS (Verification Information System) application to validate data which involves about 166 tables. Validated data for 166 tables using DVO from source to target. Involved in 508 testing using WAT for BI reports.

Responsibilities:

Developed Test Plans, test scripts and executed the test scripts for USCIS Project. Thorough out the project in various iterations/Sprints – conducted system testing, integration testing and functional testing.

Developed complex SQL queries for querying data against different data bases for data verification process.

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings for Data Warehousing Application and Automation test strategies. Extensively interacted with developers, business& management teams to understand the USCIS VIS project business requirements and ETL design document specifications.

Participated in regular project status meetings and QA status meetings. Extensively used and developed SQL scripts/queries in backend testing of Databases.

Worked on issues with migration from development to testing

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.

Creating test cases for ETL mappings and design documents for production support.

Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Worked with ETL groups and business analyst for understating mappings for dimensions and facts.

Extensively tested several Business Objects Reports –Dashboards to validate the reports data and cosmetics of the report.

Implemented JIRA and administered for Creating new Stories, users and roles.

Participated in Release Readiness Review (RRR), Retrospective meetings, and sprint planning and demoed stories to client.

Software Environment: OBIEE, Informatica 10.1, ETL, DVO 10.1, JIRA, Oracle 11.5, SQL Developer, WAT for 508 Testing.

Srisap Consultants Llc. May 2013 to Aug 2014

Client: US Department of State Consular Affairs

Senior Software Test Engineer, Falls Church VA

Responsibilities:

Working as a Senior Test Engineer for Consular affairs Consular Systems and Technology CEAC (Consular Electronic Application Center) applications - IV – Summary, IV-APP, IV-Agent, Genniv, Ceac-DV, AGNATO, Ceac Web, Ceac Central and Ceac Web post applications. Involved in writing test plans, Reviewing Build Audit Check lists, gathering requirements, Writing TIRs, conducting meetings, end to end testing, regression testing. Installing new releases and web configuration. Managed all aspects of a Test cycle including testing, documentation, installation and commissioning of systems, scheduling work and activities, training, performance testing. Also, involved in CEAC report testing for AGNATO, IVAPP & Genniv reports.

Software Environment: Oracle 11g, SQL, SAP, ERP, Hyperion, Portal, UNIX, Informatica, ETL, Main Frame, Rfhutil, Clear Case, PVCS Dimensions and Quality Center.

Bart Associates Jan 2013 to April 2013

Client: Customs and Border Protection (PSPO)

Senior Test Engineer, Spring Field VA

Responsibilities:

Working as a Senior Test Engineer for Passenger Systems Program Office Tech Modernization project. Managing all aspects of a Test cycle including test documentation, installation and commissioning of systems, scheduling work and activities, training, performance testing. Managed vehicle processing using VPC (vehicle primary client), Processed I-94 and validated various Tecs Hits (ATS, Port Runner etc). Worked on requirements gathering, planning in setting up data and the environment for the test lab, Scheduled and assigned Test Cases (TCs) to testers within the group.

Software Environment: SQL, SAP, ERP, Hyperion, Portal, UNIX, Informatica, ETL, Main Frame, Rfhutil, PVCS Dimensions and Quality Center.

Srisap Consultants Llc Nov 2012 to Jan 2013

Client: Immigration and Custom Services (USCIS)

Senior Quality Analyst, Mclean VA

Responsibilities:

Ran scrum meetings, including daily stand-up, iteration planning (comprised of team capacity and velocity planning), release planning and estimation planning.

5 years of Quality Assurance performing on agile programs and projects utilizing several standards such as IEEE-1028, PMBOK, CMMI, ISO-9000, ITIL and DOF IT framework.

Audited program artifacts in accordance with program standards and international standards including ISO-9000 and IEEE-1028.

Generated Metric Reports. Created Full SDLC Requirement Management Process via SOP(tm) s in support of Agile Test Process using ISO-9000 standards.

As a lead identified approaches for Scrum planning meetings to address performance, schedule and reduce defects during processing.

Proven ability to understand the business rules and effectively implementing them into the Business Process Flow.

Software Environment: Oracle 11g, SQL, SAP, ERP, Hyperion, Portal, UNIX, Informatica, ETL, Main Frame, Rfhutil, Clear Case, PVCS Dimensions and Quality Center.

Northrop Grumman Nov 2010 to Nov 2012

Client: Immigration and Customs Enforcement (ICE)

Senior Test Engineer, Fair lakes VA

The Immigration and Customs Enforcement (ICE) Integrated Decision (IIDS), also known as Immigration Dashboard, is a new Business Intelligence (BI) platform intended to support decision-making activities for ICE users. The system is envisioned to encompass a Data Warehouse optimized for slicing and dicing data and a BI tool set to facilitate making the data accessible to end users by providing querying, reporting, and analysis functionality.

Responsibilities include Planning, Scheduling and managing Program Trouble Reports (PTRs) & software Change Requests (CRs), tracking and status reporting to the management for ERP Applications.

Wrote several test plans for Business Object Reports, conducted peer reviews and inspection meetings on various activities of Quality Assurance life cycle

Involved in Hyperion Report functional and performance testing for the ICE application comprising of complicated business rules for Arrest warrants, Deportation orders, Release requests etc.

Tested finished products using ORACLE RDBMS, SQL, and PL/SQL tools

Software Environment: SQL, SAP, ERP, Hyperion, Portal, UNIX, Informatica, ETL, Rfhutil, PVCS Dimensions and Quality Center.

Srisap Consultants llc JAN 2006 – Oct 2010

Lead Test Engineer, Vienna VA

Project Name: Automated Commercial Environment for CBP

This project involves various applications like Portal, SAP, Transactions, BRD, EDI and EIS etc. Customers will be able to file e-Manifest. CBP officers are able to hit Port Runners at exit gates in primary and secondary. Validates license plate information whenever the truck enters the port. Also, involves various kinds of shipments, carrier information and Crew information.

Leading a team of testers in a production support environment. Involved in M1 Testing for OCEAN, RAIL and Trucks with ATS (Automated Target System), TECs and production support environment. Responsibilities include Planning, Scheduling and managing Program Trouble Reports (PTRs) & software Change Requests (CRs), tracking and status reporting to the management. Wrote several test plans, conducted peer reviews and inspection meetings on various activities of Quality Assurance life cycle.

Ran several automated test scripts using Selenium & Java for Electronic Data Interface (EDI) regression tests. Expert in User Provisioning in setting up the roles for various users for different functionalities Managed all aspects of a Test cycle including test documentation, installation and commissioning of systems, scheduling work and activities, training, performance testing.

Managed Disaster Recovery testing exercises, Worked on requirements gathering, planning in setting up data and the environment for the test lab, Scheduled and assigned Test Cases (TCs) to testers within the group.

Managed the Test team and prepared test strategy, plans/cases and weekly progress / status reports, involved in conducting Peer Reviews, Inspection of test plans, and execution of test cases, mentored testers to add and close PTRs & CRs in PVCS. Tracked those PTRs and CRs in Quality Center and to generate status reports.

Software Verification: Participated in reviewing various PTR issues with different groups like BRD and Security. Involved in verification of the issues and closing PTRs. Scheduled defect call meetings to review and analyze defects with various people involved in the project. Managed multiple Applications using checklists, issues, lists, walkthroughs and inspection meetings. Ensured that functionality, as defined in PTR, was the intended behavior of the product.

Software Environment: SQL, SAP, DB2, Portal, Unix, Win Runner, MQMON, Rfhutil PVCS Dimensions and Quality Center.

Citi Financials OCT 2004 – Dec 2006

Software QA Engineer, Baltimore Maryland

Project Name: Mexico Financial Maestro Application

This is a Financial Maestro Application for the purpose of taking and approving Personal Loan and Real Estate Loans from Customers. This Maestro Application is able to pull the automated credit bureau for the customers under legal time period. Validates the credit history and will be able to book the loan. Also validates the history of Payment, Ledger card and Trade line details.

Software Verification: Prasad participated in reviews and meetings to evaluate Test Strategies and Test Plan document. Used Test Director 8.0 to enter the defects while executing test scripts from Test Director. Scheduled defect call meetings to review and analyze defects with various people involved in the project. Involved in testing multiple Applications using checklists, issues, lists, walkthroughs and inspection meetings. Ensured that functionality, as defined in requirements, was the intended behavior of the product. Verified automatic credit bureau pull, auto transfer to recovery center after legal time period as per the requirements and purging of accounts to re-use the account no etc.

Software Validation: Prasad ensured that functionality, as defined in Spec. Document, was the intended behavior of the product. Performed actual testing after verification was completed. Recorded bug incidents with detail of steps and attached screen shots. Found software issues, documented them, and worked with software Manger, developers and analyst to have the issues corrected.

Software Documentation: Prasad revised, updated and maintained all software test documents including “Entry Criteria”, “Software Verification Test Procedures and Results” and also Exit criteria document.

Software Environment: QL, Win Runner, Test Director 8.0, Mosaic and Unix.

Software Test Engineer, Gaithersburg MD Sep 2000 – Sep 2004

Project Name: Electronic Toll Collection

This is an Electronic Toll Collection System, which consists of various modules of which Transaction Posting is main module, which validates Device, Account Status and Discount plans associated with the Account. Get the best plan and toll fare for the transaction and debit the account balance and manage trip counts are the main features of the product.

Responsibilities:

Software Verification: Prasad ensured product was designed to deliver all required functionality to the client. Participated in reviews and meetings to evaluate documents, plans, code, requirements and specifications. Used checklists, issues lists, and walkthroughs and inspection meetings. Performed code analysis of 3,000 lines of source code written in SQL and C. Wrote repeatable test procedures and scripts. Wrote and maintained a 922-page software verification test procedure document.

Software Environment: Oracle 9i, Informix, RDB, VMS, VB, ASP, Actuate, Power Builder.

Software Developer/Test Engineer / Analyst May 2000 – Sep 2000

Project Name: Transo Extranet, Rockville MD

This is a B2B extranet for the associate partners of the company of Transo who are corporations on their own. Clients have a corporation id by which they are authorized to enter the site. According to the privilege assigned, specific type of envelopes and a limited quantity are allowed for ordering.

Responsibilities:

Software Testing: Prasad wrote, documented, maintained, executed, and verified 547 “black-box” and “white-box” test cases, procedures and test scripts. Inspected 37,000 lines of code. Updated a “Software Requirements Document” of 1,600 pages. Rational testing tools.

Software Environment: SQL Server 2000, VB.NET, ASP.NET and ADO.NET

Project Name: IMPACII, Rockville MD Oct 1996 – April 2000

Software Developer /Test Engineer / Analyst

This is Information for Management, Planning, Analysis and Coordination system of National Institutes of Health.

Responsibilities:

Worked on (Y2K IV&V) Independent Validation and Verification of the process whereby a Software application or system is tested to determine its vulnerability to date compliance issues. The purpose of this is to further reduce Y2K risk and vulnerability.

Software Environment: Oracle Forms, Oracle, Designer 2000, ASP, and VB 6.

Project Name: Coast Guard Fleet Logistic Systems, Greenbelt MD

This is a Fleet Logistic System for US Coast Guard. This application is built to enable collection of click stream data to maintain Procurement and Main module.

Responsibilities:

Responsible for creating/generating E-R and Data flow Diagrams. Involved in creation of Module Data Diagrams and generating MDD’s to create forms using Repository Object Navigator (RON) on Designer 2000. Developed Forms using standard template and common libraries in Designer 2000.

Software Environment: Oracle forms, Reports, Designer 2000, VB 6, Microsoft Windows 98, NT, PVCS version control, Lotus Notes, MS Word and Data Web Housing.

Shippensburg Pennsylvania Oct 1994 – Oct 1996

Graduate /Research Associate

Responsibilities:

Supervised computer laboratories equipped with heterogeneous Network of PCs, workstations, Terminals and Peripherals, running on Novel NetWare.

Software Environment: Oracle forms, Reports, Designer 2000, VB 6, Microsoft Windows 98, NT

Department of Agricultural Engineering, Aug 93 – Jun 94

McGill University, Montreal, Canada.

This project was for maintaining University records of staff, students and courses. System recognizes when a course has not been registered by a single student and removes the course from the current course list.

Responsibilities:

Defining QA process, producing standard, procedures and documentation. Writing of Test Plans. Testing of student’s records with IE and Netscape Browsers written in Power Builder and Oracle with SQL 6.5 databases. Use of SQA Rational Robot source safe and PVCS tracker. Utilization of Load Runner and Win Runner for stress and regression testing.

Environment: Novel Netware, Windows, and UNIX

Department of Mechanical Engineering, Oct 88 – Jun 93,

Indian Institute of Science, Bangalore, India.

Responsibilities:

Developed and tested a software package for selecting a cutting fluid. Work involved designing the database to select a cutting fluid based on the user input. Developed an interface to customize the selection process based on the user requirements. Developed in Oracle 7.0 (SQL) *Plus.

Software Environment: Novel Netware, Windows, and UNIX

Contact this candidate