SUMMARY

• Chinmay is a seasoned QA professional who performs and manages validation as a Test Consultant.
• He leads and transforms teams and manages software testing to further transform business.
• He halps organizations, provide professional excellence in quality assurance management program across entire software testing life cycle.
• 9+ years of diversified IT industry experience in software testing / Quality assurance & efficiently managing testing teams in test activities which include: design, develop and execute test strategies/plans; debug and troubleshoot; perform impact and gap analysis; monitor and instruct test resources on proper procedures to ensure team compliance, status reporting, coordinate issue resolution, defect tracking and defect triage activities
• Currently working as Software test consultant /QA Lead in agile environment with major focus on Web Services API testing (REST) using postman & database testing along with enhancement by implementation of automation.
• Strong proficiency in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Bug Life Cycle (BLC)
• Proficient in tracking effort variance, schedule variance and ensuring strict adherence to predefined SLA’s..
• Very efficient in project estimation (timeline, cost and resource), test execution and coordinating tasks like Smoke Testing, Functionality/Non - functional Testing and Regression Testing from team.
• Define and build robust, modular and reusable Automation frameworks and retain accountability for ensuring all Test Automation Analysts understand and adhere to the framework
• Extensive experience of testing large scale, complex integration Programs/Projects
• Experience in Selenium web driver along with Python in implementing UI automation.
• Hands-on experience in formulating test automation strategy, identifying test automation opportunities and guiding test team via a center of excellence model to promote adoption within the QA teams.
• Hands on experience in testing mobile apps through simulator(mobile testing- Android & IOS),application testing, white box and black box test methodologies
• Expertise in requirements gathering & analyzing them to come up with sizing to complete test design part like automation scripts with various functional testing phases.
• Well Versed in System Testing (Web Services and Presentation Layer), Integration Testing (End to End application Integration testing), Supported UAT and Production Volume Testing.
• Experience in ETL testing with batch monitoring and execution along with ETL methodology for testing & supporting data extraction, transformation and loading processing.
• Extensive experience in testing of data warehouse / data marts for business applications with Banking, Financial domains.
• Expertise in Presentation Layer testing (Preparing test plan, Preparing and Reviewing test scripts, execution of scripts, Defect Management,Regression cycles.
• Experienced in working with teams in different geographic location and time zones to perform System Integration Testing, UAT, Co-ordinated testing.
• Experience in domains like trading, banking and regulatory reporting
• Significant experience is managing teams in Agile - efficient in scrum master responsibilities.
• Efficient in facilitating daily scrum, sprint planning, sprint demo and retrospective meetings
• Demonstrated other important skills on multiple projects such as project initiation, defining scopes, estimations, quality management and risk management.
• Ability to lead onshore and offshore QA teams and TEMPeffective communication and management
• Team player with strong written and verbal communication,analytical and interpersonal skills.

TECHNICAL SKILLS

OS: Microsoft Windows (98-10)

Test Management: Test Strategies and approach, Test Cases, Test Plans, Test Scripting, Test, Summary Report, Project Estimates, Project Management, defect triage.,Zephyr.

Methodologies: Agile, Waterfall and Iterative

CI/CD Tools: Bamboo, Bitbucket,GitHub

Databases: DB2, Aerospike

Languages: PLSQL, Python scripting, HTML

Software Products: QC ALM 12, Atlassian - JIRA, Confluence,SQL Server management, studio,Parasoft SOA

Tools: SQLDB,Toad, Beyond Compare, WinSCP, Control-M,Selenium Web driver, SOA test Postman, Bamboo, RDC, Pycharm

Domains: Banking / Regulatory reporting / Trading / securities

PROFESSIONAL EXPERIENCE

Confidential, Austin, Texas

Sr.Test Consultant

Responsibilities:

• Analyzing requirement by incorporating feasibility study matrix
• Implementing automation for Order entry through GUI using python - selenium webdriver.
• Applying real time noledge on usability of python to enhance testing automation process..
• Analyzed application data using the SQL, to validate the ETL transformation rules are working as expected.
• Automation script Validations tests through pre-defined set of rules
• Extensive use of SQL to perform daily validation for trades posted via different channels
• Broadcasting impact analysis on existing system
• Using batch processing to load the data from different files (source system) to staging area and validation of appropriate logic as per business rules
• Validating orderhub messages in rabbit MQ and IBM MQ.
• Regulatory reporting accuracy
• Executing mainframe jobs to ensure reports are generated
• Automating order entry using Parasoft SOA
• Bulk order entry along with performance tuning
• Extensively use of postman tool for REST API testing
• Validation system and database calls
• Focus on batch processing
• Detailed noledge on trade booking and after hours trading life cycle
• Managing onshore - offshore team
• Coordinating in timely delivery by proactive testing approach and strategy

Confidential, Austin, Texas

Sr.Test Analyst

Responsibilities:

• Managing QA activities under trading portfolio
• Responsible for end to end flow of trade booking system
• Closely working with customers for better product delivery
• Prepare and walkthrough complex ETL Test scenarios with business users.
• Formulating ETL Test Strategy and approach for various projects
• Validation of data for all 3 phases of ETL (Extraction, Transformation and Loading)Decent experience on data validation and testing of SQL and DB2 database
• Managing deliverables by following onshore-offshore team model
• Corss verifying downstream data flow till reports generation
• Reporting test matrix along with performance co-ordination
• Experience in ETL with Validation of processed data against transformation logic applied
• Database and performance tuning
• Bulk order entry management
• Working on different trade types - market order, GTC, day order,etc
• REST API testing - Postman
• Maintaining requirement query log and get it clarified from Business team
• Preparing and documenting the test scenarios
• Tracking of traceability of requirements
• End-to-end trade booking flow testing
• Data validation from source along with transformation logic till the final output.
• Coordinating with the Development and Business team for Defect analysis
• Planning for Change Requests and Ad-hoc in sprint requests.
• Sharing timely Status reports and Defect tracking reports
• Managing onshore-offshore coordination
• Coordinating daily stand-up calls

Confidential

QA Lead

Responsibilities:

• Trade booking in Wall Street system.
• Monitoring trade life-cycle.
• Maintaining requirement query log and get it clarified from Business team
• Data validation from source along with transformation logic till the final output.
• Validation of flows like Charles river and Aladdin
• Developing recursive testing framework
• Accommodating and adopting to ad-hoc changes
• Managing offshore team
• Coordinating with customers for better testing experience
• Engaging in projections, team metrics, testing matrics
• Guiding team in proper testing approach

Confidential

Test Lead / ETL test analyst

Responsibilities:

• Working in Agile model
• Developing aggressive test strategies
• Creating mappings using informatica powercenter.designer.
• Validating various ETL transformation rules based on log files, data movement with halp of SQL.
• Coordinating with development and Business team for Defect analysis
• Created and executed detailed test cases with systematic procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Quality center 9.2.
• Extensively used Data Stage for extraction, transformation and loading process.
• ETL mapping to load data from XML source to pre- staging, tan from pre- staging to staging for further processing.
• Verify that all data were synchronized after the data is troubleshoot and used SQL to verify correctness of tests.
• Creating and executing SQL queries to perform data testing on an Oracle Database to validate and test data using TOAD.
• Writing complex SQL queries for data validation for verifying the Packages and business Rules.
• Planning for Change Requests
• Sharing timely Status reports and Defect tracking reports
• Documenting SIT scenarios, test cases
• Managing onshore-offshore coordination
• Coordinating daily stand-up calls
• Analysis of functional requirement document
• Maintaining requirement query log and get it clarified from Business team
• Preparing and documenting the test scenarios and writing test cases
• Tracking of traceability of requirements

Confidential

Sr.Test Analyst

Responsibilities:

• Preparation of test data as per the project requirement
• Data cleansing and masking.
• Loading data to staging
• Applying transformation logic and rules using informatica powercenter
• Understanding mappings within modules
• Managing onshore-offshore coordination
• Coordinating daily stand-up calls
• Loading of feed files data into DB
• Executing batch files for transformation of data
• Batch monitoring
• Maintaining requirement query log and get it clarified from Business team
• Preparing and documenting the test scenarios and writing test cases
• Executing test cases and logging defects
• Coordinating with the Development and Business team for Defect analysis
• Sharing timely Status reports and Defect tracking reports

Confidential

Sr.Test Engineer

Responsibilities:

• Documenting SIT scenarios, test cases
• Prepared test data to validate ETL rules wherever necessary
• Working in Agile model
• Writing test cases for the data extracts to make sure the vendors are sending the correct data files.
• Performed ETL testing and extensively used SQL functionalities.
• Maintained Source definitions, Transformation rules and Target definitions.
• Preparation of test data as per the customer requirement
• Maintaining requirement query log and get it clarified from Business team
• Preparing and documenting the test scenarios and writing test cases
• Tracking of traceability of requirements
• Executing test cases and logging defects
• Coordinating with the Development and Business team for Defect analysis
• Planning for Change Requests
• Sharing timely Status reports and Defect tracking reports

Confidential

Sr.Test Engineer

Responsibilities:

• Understanding the application architecture and gathering Testing Requirements with co-ordination with
• Development team, IT BA’s and SME.
• Test Estimation and Resource Planning.
• Preparing Test Plan and Test Strategy and Test Scripts for projects.
• Tracking team’s work allocation and progress on daily basis.
• Highlighting and mitigating risk to the project stake holder to keep project on track.
• Daily Reporting to the project stakeholders and business stakeholders.
• Introducing industry best practices to overall project life cycle to improve quality and productivity.
• Coordinating between functional and technical team for issues during the test life cycle.
• Maintaining Test set in Quality Centre ALM and Managing of the Regression Testing Suite.

Confidential

Test Engineer

Responsibilities:

• Preparing and documenting test scenarios
• Writing test cases for various testing scenarios
• Tracking of traceability of requirements
• Responsible for the execution of test cases and log defects
• Responsible for querying the data from database and validation it against front end
• Coordinate with the Team Lead and Development team for defect analysis
• Daily, weekly and release level status reporting
• Involved in noledge transfer activities within the project and provide training to new joiners
• Preparing training and induction documents