Pranay Krishna Sriram

Environment: Postgresql, Sybase, DBeaver, RapidSql, Postman, Rest API, Kafka, Python, Pycharm, Beyond Compare, BitBucket.

• Produced test scripts for new automated software testing rounds.
• Build pytest automation frameworks for database testing based on python, tools and methodology to assist future users and to streamline automation.
• Build python framework to read platform events posted to multiple kafka listeners.
• Conducted functional testing on PostgreSQL databases to ensure optimal performance and data integrity.
• Developed and executed comprehensive test plans, test cases, and scripts for various database functionalities.
• Utilized Postman features such as environment variables, data-driven testing, and assertions to validate API responses.
• Conducted comprehensive UI and API testing using Postman.
• Automated functional and regression testing approaches to streamline software production.
• Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
• Documented, triaged and managed defects in Jira and worked with developers to facilitate timely resolutions.
• Contributed to the improvement of QA processes and methodologies to enhance efficiency and effectiveness.
• Documented and reported defects using established tracking tools, providing clear and actionable feedback to the development team.

Environment: Teradata SQL Assistant, Teradata CIM UI, Teradata Utilities, DB2, Gherkins, Oracle, Rally, Data Studio, MS-Excel, UNIX, Gherkins, Postman, Compare Beyond, Atacama DQC, Oracle, Atacama, MS-Excel, UNIX, Sybase power Designer, SQL Server, Beyond Compare 4, Clear Quest, Informatica, SAS

• Reviewed Business Requirement and the Functional Specification.
• Responsible for system testing, regression testing, and end to end testing, UAT testing and production run testing.
• Supported business in designing and maintaining of multi-channel customer communication campaigns using Teradata CIM, enhancing targeted messaging strategies and optimizing customer engagement.
• Provided guidance and leadership to multiple QA professionals across diverse teams, ensuring alignment with project objectives and adherence to industry best practices.
• Developed Test cases, Test plans, and Test procedures in rally and Jira as well as updating in confluence pages.
• Conducted source-system data analysis to understand current state, quality, and availability of existing data.
• Created test data in integration region and performed system-Integration testing, Smoke, Functional, Regression and User Acceptance Testing.
• Created and executed test scripts in Teradata BTEQ scripts and performed functional and non-functional tests.
• Created feature files using Gherkins for automation testing.
• Perform validations on Email & SMS notification Service testing using postman.
• Attend weekly Project Status Meeting with Team, QA Manager, and worked closely to define Test Strategy, Gap Analysis, Risk, and Test Dependency.
• Experience in Data integration of various data sources with Multiple Relational Databases like Oracle, DB2, SQL Server, MS Excel, and Flat Files.
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Conducted functional walkthrough, User Acceptance Testing (UAT) sessions, and assisted the development of User Manuals for customers
• Tracked Defects for closure and generated bug reports in Rally/ Jira.
• Tested data migration to ensure that integrity of data was not compromised.
• Interact with Business users on Testing needs and technical specifications document, High-level design document, Source to target mapping document.
• Perform Backend Testing like Functional Testing, Regression Testing.
• Analysis, ETL Testing and designing of the flow and the logic for the Data Warehouse project.
• Responsible for system testing, regression testing, and end to end testing, UAT testing and production run testing.
• Written several complex Teradata SQL queries for validating SAS Reports.
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Involved in designing of Test Plan, Identifying Test Scenarios and Executing the Test Cases.
• Conducting Retesting with multiple sets of test data using Data Driven Approach.
• Used Clear Quest Center to track and report system defects.
• Performed ETL testing to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
• Used Source to target (STM) mapping document to perform ETL testing for end-to-end flow of data.
• Used Atacama DQC for data profiling and checking the quality of the data.
• Wrote SQL views in schematic layer to test data Mart inbound to reports.