surender mandula
Sr Software Quality Analyst at Trellance- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Pranav Mandloi,SPC5,SA,ICAgile ACC, PMP, ACP, CSM, AWS CP
Surender works closely with development team, business customers, QA Analysts & Data modelers to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality. As an ETL Test lead, Surender has exceptional SQL skills and Analytical abilities enables him in developing test strategy & design and lead execution to guarantee superior outcomes. Strong Analytical thinking and deep expertise about the domain to simulate real-time scenarios and frame test cases accordingly. He is always one step ahead in planning to provide testing status for ongoing projects and future initiatives in weekly status meetings. He delivers effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time and adhering to development and quality standards. He reviews software documentation to ensure technical accuracy, compliance or completeness and/or to mitigate risks. He is extremely hard working and diligent. Due to his work ethic and meticulous nature, Surender could be relied up on to carry out testing tasks in the best possible way.
LakshmiPriya(Priya) Srinivasan
Worked with Suren in USDA on a data intensive project in Finance .He has extensive working knowledge with Informix,DB2 databases and job scheduling. ETL testing was most critical for the project success and Suren was very instrumental in handling the tasks for high priority data sources. I appreciate his tireless work ethic and willingness to do whatever it takes to complete the tasks per the requirement of the project.He is a high power Analyst/tester who worked closely with business.He helped business users assure the quality and accuracy .He is expertise in writing SQL queries.I am glad I had opportunity to collaborate my knowledge with him.
Pranav Mandloi,SPC5,SA,ICAgile ACC, PMP, ACP, CSM, AWS CP
Surender works closely with development team, business customers, QA Analysts & Data modelers to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality. As an ETL Test lead, Surender has exceptional SQL skills and Analytical abilities enables him in developing test strategy & design and lead execution to guarantee superior outcomes. Strong Analytical thinking and deep expertise about the domain to simulate real-time scenarios and frame test cases accordingly. He is always one step ahead in planning to provide testing status for ongoing projects and future initiatives in weekly status meetings. He delivers effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time and adhering to development and quality standards. He reviews software documentation to ensure technical accuracy, compliance or completeness and/or to mitigate risks. He is extremely hard working and diligent. Due to his work ethic and meticulous nature, Surender could be relied up on to carry out testing tasks in the best possible way.
LakshmiPriya(Priya) Srinivasan
Worked with Suren in USDA on a data intensive project in Finance .He has extensive working knowledge with Informix,DB2 databases and job scheduling. ETL testing was most critical for the project success and Suren was very instrumental in handling the tasks for high priority data sources. I appreciate his tireless work ethic and willingness to do whatever it takes to complete the tasks per the requirement of the project.He is a high power Analyst/tester who worked closely with business.He helped business users assure the quality and accuracy .He is expertise in writing SQL queries.I am glad I had opportunity to collaborate my knowledge with him.
Pranav Mandloi,SPC5,SA,ICAgile ACC, PMP, ACP, CSM, AWS CP
Surender works closely with development team, business customers, QA Analysts & Data modelers to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality. As an ETL Test lead, Surender has exceptional SQL skills and Analytical abilities enables him in developing test strategy & design and lead execution to guarantee superior outcomes. Strong Analytical thinking and deep expertise about the domain to simulate real-time scenarios and frame test cases accordingly. He is always one step ahead in planning to provide testing status for ongoing projects and future initiatives in weekly status meetings. He delivers effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time and adhering to development and quality standards. He reviews software documentation to ensure technical accuracy, compliance or completeness and/or to mitigate risks. He is extremely hard working and diligent. Due to his work ethic and meticulous nature, Surender could be relied up on to carry out testing tasks in the best possible way.
LakshmiPriya(Priya) Srinivasan
Worked with Suren in USDA on a data intensive project in Finance .He has extensive working knowledge with Informix,DB2 databases and job scheduling. ETL testing was most critical for the project success and Suren was very instrumental in handling the tasks for high priority data sources. I appreciate his tireless work ethic and willingness to do whatever it takes to complete the tasks per the requirement of the project.He is a high power Analyst/tester who worked closely with business.He helped business users assure the quality and accuracy .He is expertise in writing SQL queries.I am glad I had opportunity to collaborate my knowledge with him.
Pranav Mandloi,SPC5,SA,ICAgile ACC, PMP, ACP, CSM, AWS CP
Surender works closely with development team, business customers, QA Analysts & Data modelers to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality. As an ETL Test lead, Surender has exceptional SQL skills and Analytical abilities enables him in developing test strategy & design and lead execution to guarantee superior outcomes. Strong Analytical thinking and deep expertise about the domain to simulate real-time scenarios and frame test cases accordingly. He is always one step ahead in planning to provide testing status for ongoing projects and future initiatives in weekly status meetings. He delivers effective and efficient testing solutions by meeting key project milestones and overall project deliverables on time and adhering to development and quality standards. He reviews software documentation to ensure technical accuracy, compliance or completeness and/or to mitigate risks. He is extremely hard working and diligent. Due to his work ethic and meticulous nature, Surender could be relied up on to carry out testing tasks in the best possible way.
LakshmiPriya(Priya) Srinivasan
Worked with Suren in USDA on a data intensive project in Finance .He has extensive working knowledge with Informix,DB2 databases and job scheduling. ETL testing was most critical for the project success and Suren was very instrumental in handling the tasks for high priority data sources. I appreciate his tireless work ethic and willingness to do whatever it takes to complete the tasks per the requirement of the project.He is a high power Analyst/tester who worked closely with business.He helped business users assure the quality and accuracy .He is expertise in writing SQL queries.I am glad I had opportunity to collaborate my knowledge with him.
Credentials
-
ASTQB - Certified Tester, Foundation Level (CTFL)
ASTQB - Official Page - American Software Testing Qualifications BoardJul, 2017- Nov, 2024
Experience
-
Trellance
-
United States
-
Financial Services
-
100 - 200 Employee
-
Sr Software Quality Analyst
-
Dec 2019 - Present
• Performed quality operations activities; incoming quality control, production process control, quality engineering ensuring process validation and verification compliance, review of deviations/investigation and escalation of quality issues to address the root cause and implement corrective and preventative actions. Collaborate with the operations team to identify process improvement opportunities. • Using Azure DevOps to Automate Tests for validating functionalities and data and produce outcomes in the Power BI dashboards. After each deployment to QA, an automation script has been executed to verify all the old functionalities are working correctly after changes are applied to the environment and a test report has been created to track for each test case with screenshots attached to the report. • Greatly improved communication, collaboration, and accountability across all levels of Testing Teams (Descriptive Analytics, Predictive Analytics, User Portal, Web Integrations, M360 Common Team & Testing Platforms and Data), Azure DevOps CI/CD pipeline, Snowflake • Tested Power BI visualizations and dashboards using Power BI Desktop for Column Chart, stacked chart, Pie chart, Slicers, Donut Charts, Row Cards, Multi Row Card, Line Chart and KPI’s testing with DAX measure on top of the datasets wherever required and designed customized queries in Power BI and handled the null/empty values in the Power BI to ensure the data to be accurate to use. • As being the first QA team member orchestrated the QA team, trained new resources to get them up to speed to make a quality contribution without comprising on the testing efforts by bridging the gap of providing extra support for testing on areas that involve complex workflows and functions. Show less
-
-
-
Red Cedar Consultancy, LLC
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Senior Data Test Engineer
-
Apr 2018 - Dec 2019
• Led the Enterprise Information Management Testing Support (EIMTS) group on the Financial projects and supported team members with scheduling, project tracking, estimates, document and reports current test status of projects on weekly basis and other lead responsibilities properly managed in JIRA. • Worked closely with Business team on requirement gathering and Test planning • Look beyond the current scope to define/identify potential risks and coms up with a suitable mitigation plan. • Integrate working with the test executive team, the project management deliverables for the test component of the project acitivity. • Prepare and monitor testing scope and requirement changes, assess the impact of requirement changes on test deliverables. • Tackles difficult problems and takes personal responsiblity for reaching solutions. • Seek ways to improve overall performance levels of the team in the pursuit of targets/goals. • Prepare and manage master test plan and continuously provide improvement of test management standards and procedures. • Prepare test estimates and sizing of the test object • Prepare test execution metrics and use the metrics to derive best practices and suggest/recommend improvements to test processes and methodologies. • Provide support for identification and management of Risks and Issues relating to testing activities and escalate any concerns to the approrpriate stake holders for resolution • Participate in production issues review meetings with business and development team • Responsible for conducting QA entrance and exit criteria meetings with project stake holders • Developed different Reports and Dashboard to communicate the testing progress and defect reports in ALM • Verified the deployment instructions in Certification Environment before sending it to production to ensure the project is successfully deployed and ready to use by end users Nationwide Show less
-
-
-
Booz Allen Hamilton
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
SD Test Engineer
-
Apr 2015 - Mar 2018
• Extensively interacted with developers, business and management teams to understand the various project business requirements and ETL design document specifications • Tested data for number of complex ETL mappings, reusable transformations using Full loads and Daily/Incremental data loads • Ability to manage and support multiple projects in Financial Management Reporting Systems data warehouse such as FWADM, CFIDM, COFDM, COTTONDM, FSADM, FMMI_ODS, EDW and PMRDS and adapt to changing priorities • Created detail Test cases in HP ALM for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions with an Expected and Actual results • Developed complex SQL queries using JOINS for data verification process and to validate the data in both source (DB2 and SQL), staging and target databases • Developed and executed Test Cases with respect to Source, Staging and Target (Warehouse) database tables by implementing real time business scenarios • Defects identified in testing environment are communicated to the developers using HP ALM (Application Life Management) – Defects module • Prepared daily/weekly status reports with details of executed, passed, and failed test cases and defect status • Participated in Release management process and keep tracking about the releases using JIRA Ticketing system and followed the standard procedures with CMSG (Configuration Management System Group) and DBA’s by creating FTRT’s and FDRT’s • Participated in creation and delivery of testing artifacts, including: Test Plan, project specific test strategy, detailed test cases/test data, defect reports, and final test summary report • Track and distribute testing results, status, and metrics to the project team on a regular basis to assist in making solid go/no-go decisions Show less
-
-
-
Metapro Solutions
-
United States
-
Computer Networking
-
1 - 100 Employee
-
Data warehouse/BI QA Analyst
-
Nov 2011 - Jan 2015
• Analyzed and reviewed Project Initiation Document (PID), System Requirements Document (SRD) and System Requirements Specification (SRS) to ensure testability and identify discrepancies or errors in the functions, interface, data structure and performance of the system• Created/uploaded and maintained requirements/user stories into ALM and created requirements and test matrix into ALM• Developed and maintained System, System Integration and UAT test Plan and test Approach• Defined and developed Test scenarios and test cases to test the new application/functionality and enhancements in existing application • Involved in creating the test data for generating sample test reports before releasing to production• Analyze Data Models, Data mapping, Design, Conversion and ETL design documents• Tested database integrity, referential integrity and constraints during the database migration testing process• Extensively involved with ETL test data creation for all the ETL mapping rules • Executed SQL statements to test the integration between application and database• Proficiently worked with OBIEE to test Physical Model, Business Model and presentation layer and established relationships• Tested different types of Customized Reports (Drilldown, Aggregation) created by OBIEE to meet client requirements• Validated the reports layouts in OBIEE based on Report Layout Document.• Creation and execution of test cases on Oracle Reports and OBIEE• Worked as an ALM/QC Admin and customized the tool based on requirements from users.• Created and maintained folder structures, release and cycles into ALM• Wrote complex SQL scripts using joins, sub queries and correlated sub queries• Validated the data in the reports by writing simple to complex SQL queries in the transactional system• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios Show less
-
-
Sr. Data warehouse QA Analayst
-
Feb 2009 - Oct 2011
• Participated in requirements definition reviews and functional specification reviews to ensure that critical information is included and testability requirements are met• Developed Test Approach and Test plan document for different Data Marts testing• Analyzed the Technical design specification documents, business rules, data validation specifications to identify deficiencies in test plans and procedures, and enhance test coverage accordingly• Responsible for writing and executing the test cases to validate the Transformation rules, Records counts, Logical and physical deletes, exceptions and errors for different stages of ETL• Developed test cases using standard test case template in Excel sheet and upload in Quality Center • Responsible for creating requirement traceability matrix (RTM) into Quality Center and generate the report to verify the test case vs. requirements coverage• Enhanced Regression Test Cases to implement complex testing scenarios, increased permeations of Functionality Testing and increased code coverage using QTP• Performed GUI interface testing at client side using QTP• Enhanced QTP automation scripts with synchronization points, data table, parameterization and functions• Performed data validation testing and validated XML data files and Transaction log files Show less
-
-
-
Instcomp Inc
-
United States
-
Software Development
-
Functional and Integration Tester
-
Sep 2007 - Jan 2009
• Performed Function testing, System Testing, Regression testing and UAT Testing • Developed standardize Matrix and Reports to keep track of team activities • Created and maintained the Test and Defect control matrix for each testing phase • Developed and presented Test approach, Test strategy and Test Plan • Created documents such as Automation Framework, Testing cycle flow, defect management guidelines, demo and presentations • Understanding various data sources and become familiar with database, email, preferences data including understanding key business rules that drive campaign and reporting outputs • Understanding system design, specifications and interface requirements and develop test cases, test data • Working closely with SIT team and Team Lead to ensure test plan accurately reflects the overall approach to SIT and UAT phases of testing • Recorded defects in the defect-tracking tool “Test Director”. • Testing website in various browsers like IE9, 10, Firefox, Safari, Chrome and various devices like tablets, mobile phones etc. • Made sure website and webpages are responsive and functional for Android, iPhone and Windows platforms • Wrote and executed SQL Queries to validate standard and customized BI reports • Testing all the other functionalities which a PC version of the respective messenger have like blocking/unblocking a contact, adding, deleting a contact, display of the groups etc. • Wrote and execute SQL Queries to get testing data to validate standard and customized BI reports • Experience in creating UNIX scripts for file transfer and file manipulation. Show less
-
-
Education
-
2004 - 2006
University of Ballarat, IIBIT, SYDNEY, AUSTRALIA
Master of Information Technology, Information Technology -
2000 - 2003
Osmania University, INDIA
Bachelors of Computer Applications(BCA), Computer Science
Community
