PROFESSIONAL SUMMARY:

• Over 8.8 years of professional experience, I have 3 years of experience in production support projects and arround 6 years of experience in ETL/Data warehouse backend testing and BI Intelligence reports testing.
• Extensive experience in Analysis, Design & Execution of Manual and Automated tests.
• Experience with the Software Engineering / System Development Life Cycle from requirement analysis to User acceptance.
• Extensive Experience working in Agile Teams, Agile methodology, Scrum Teams.
• Hands on Experience with Rational Team Concert Agile tool and conducting Daily stands up, analyzing stories, estimating the story points and efforts, defining the acceptance criteria, delivering the committed stories in the sprint’s time.
• Extensive experience of working in Offshore - Onsite model, providing leadership and guidance to offshore teams.
• Extensively involved in Developing & Executing Test Plans, Test Cases, Test Scripts
• Expertise with Functionality, Integration, Regression, Black Box, White Box, Load, Performance, System and Back-End testing.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Knowledge in UNIX operating systems.
• Good knowledge in DBMS, RDBMS and data warehousing concepts for large SQL databases.
• Strong knowledge in test environment setup, requirements review and Management, Comprehensive test plan preparation, defect logging, test summary Preparation and test results documentation
• Proficient in Defect Management - defect identification, defect logging, and defect tracking using the defect tracking tools HP Quality Center 12.21 HP QC ALM, Jira
• Experience in working closely with the development team, QA, Users and Project Managers during all the phases of the product life cycle.
• Experience working in a fast paced, high pressure environment and meeting aggressive deadlines.
• Worked as an operations Engineer in 24*7 production support environment and used tools UC4, Tidal, Informatica, Teradata SQL assistance, cognos report studio

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead, Boston

Responsibilities:

• Worked as a QA Lead and ensured all development tasks meet quality criteria defined, through test planning, test execution, quality assurance and defect tracking.
• Worked with Business Analyst to understand the business requirements and define the testing scope of the project.
• Conducting daily Stand ups , and understanding the epic, breaking down the epic into stories.
• Assigning story points and updating tasks on daily basis from SQA Team.
• Working closely with BA in updating the Product Backlog with stories.
• Working with the scrum team in defining the acceptance criteria for stories.
• Analyzing the BFSD, FSD and TADS and preparing Test Scenarios.
• Extensive Interaction with developers, BA’S, and upstream systems , in resolving various issues from onboarding of the project to its completion.
• Preparing Test Scenarios, Test Strategy for the complete project and leading the offshore team and educating them in parallel.
• Working closely with BA in preparation of test data .
• Responsible for updating the team with issues through weekly defect triage and publishing the status of testing to the team.
• Responsible for all the HP QC ALM end to end activities and performed audit checks for other projects as well.
• Interacting with the Project Managers on estimation of efforts and timelines for the projects.
• Performed extensive functional and regression testing in UAT, Pre-Prod environments, for the highly paced incremental builds and Providing QA Sign-Offs in UAT and Pre-prod environments.
• Validation of various risk measures required for risk metrics processing.
• Responsible for Reports Validation and balance reconciliation.
• Responsible for giving demos to Business and Product Owner and getting their approvals for moving the code to production
• Responsible for providing support during production Release and providing SQA Production Checkout.
• Make the QA Team aware of the quality matrix and resolve all the queries.
• Create a list of milestones and checkpoints and set measurable criteria’s to check the quality on timely basis.
• Creating and defining test strategies.
• Review test cases and test results.

Confidential

Test Analyst

Responsibilities:

• Involved in designing and development of QA documentation such as Test cases, Test scenarios, requirement traceability matrix from business and functional requirements.
• Carried out complex SQL validations to verify the data extracts and record counts in the database table.
• Supported the extraction, transformation and load process (ETL) through Informatica.
• Involved in discussing business and functional requirements after which test approach, test planning will be finalized.
• Have worked on test plan and test timelines based on requirements.
• Conducted User Acceptance Testing (UAT) to ensure that developed solution satisfies the needs of business as specified in the functional requirements.
• Carried out functional testing to ensure the data is mapped correctly in the database that provides a random check in the overall data to check data is deposited in the table correctly.
• Extensively involved in designing the policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Have worked in testing reconcile (initial) and delta (daily) ETL loads .
• Used batch scheduler such as Control M Self Service , Oracle Data Integrator to run ETL jobs.
• Extensively used Cognos Reports studio to create reports for analyzing data and also used them to compare the data generated with Analysis studio.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Performed regression testing to analyze and understand the issues faced during the Cognos Studio version upgrade process.
• Liaised with development team to discuss about the defects raised and also coordinated in system integration testing.
• Performed exporting Manual test cases from MS - Excel template to HP Quality Center and also executed all the test cases in it.
• Reporting testing status by sending daily reports.

Confidential

Systems Engineer

Responsibilities:

• Monitoring UC4 Jobs (Teradata & Informatica Jobs) which are pre scheduled as per client requirement and making sure all the batches meet SLA.
• Connecting to UNIX servers, Informatica during Job failures and debugging from the UNIX logs and Informatica session logs.
• Executing deployment tickets as part of releases.
• Perform role as a shift lead and fixed all the batch issues with priority to SLA jobs (Bteq and Informatica jobs).
• Send regular check points to Management and Business users about the status of the Batch, Reports execution.
• Identifying the issues and escalating them at right time to concerned teams (SME, RE, DBA) and working with them to resolve the issues.
• Follow up with respective teams in case of file, DB and environmental issues and escalating the batch failures on time.
• Sending Monthly status reports to Management and Clients.
• Raising BUG's for any code issues to SME's using JIRA.
• Creating knowledge base articles for regular issues

Confidential

Analyst Programmer

Responsibilities:

• Involved for daily nightly batch monitoring, Run file configuration, environment validation, Run book deployment, HPSD- Work orders for Code review, Job scheduling Adhoc Onyx ticket handling, trouble shooting on job failures in different criteria, Table migration - data upload, all non-prod DB refreshes, Co-ordinate with other teams like DBA, Websphere, EDI, System Admin etc to complete the tasks on time.
• Add/Delete/Hold/Release/override a job/group.
• Creating hba wrappers for new jobs, which call the various hba functions that facilitate the data extractions, updates, file movement etc.
• Responsible for BRI, PHP, QCA, OHD, BCN (Facets clients) batches
• Analyze the defects and CRs and fix the defects (Facets Batch defects).
• Resolving Application Support Tickets using Onyx Portal.
• Issue Management (including problem analysis and generation of solutions); Test Management; Status Tracking & Reporting. Documenting all incidents and produce/contribute to the production for regular management reporting.
• Support to Facets Application.
• Knowledge on developing custom calendar, Adapter, Agent, Event and Action, development in Tidal.
• Troubleshooting database requests.
• Creating Change Controls & Work Orders.
• Troubleshooting, resolving various issues of application and database raised by customers.
• Responsible for the Batch Execution Monitoring, Debugging and Resolution of Batch Issues.
• Involved in setting up new jobs/batch and ensuring a smooth delivery and execution.