Sign in

Data Engineer

Edison, New Jersey, United States
November 05, 2019

Contact this candidate



Phone: 931-***-****

Over 5+ years of IT experience in Software Testing of web based and Client-Server applications. Strong Knowledge of Software Testing Life Cycle (STLC), which includes Designing, Developing and Execution of the entire QA Process which includes documentation of Test plans, Test Cases, Test Procedures and Test Scripts.

Strong testing Quality Assurance experience within Agile environment. Experience performing Black box testing, Gray box testing, End to End testing, System testing, Integration testing, UAT, Exploratory, Database Testing, regression etc. Efficient in Interacting with Business Users, Mangers for extracting their views in developing, modifying and analyzing ETL Strategies.

Working knowledge in Installing and Configuring Informatica Power Center 10.x Extensive experience in validating the Workflows, Mappings, Mapplets, Reusable transformations, scheduling the Workflows and sessions using Informatica Power Center. Expertise in Extraction Transformation Loading (ETL) process using Informatica consisting of administration, data transformation, data sourcing, mapping, conversion and loading. Experience in testing the Web application functionality and Web reporting Data validation. Good knowledge of Industry experience in the area of software testing with a solid understanding of test planning, Test Design, test Extraction,defect Reporting & Tracking . Expertise in understanding and analyzing test requirements, Tracking Changes and Maintenance of Test Requirements.

Expertise in documenting defects with high level of detail, accuracy and informative recreation steps using Quality Center.

Experience with testing on UNIX and Windows environments. Experience in database query manipulation using SQL. Strong expertise in lifecycle methodologies like Waterfall, Agile Models. Extensive experience in preparing documentation on Change Control, QA Status Reports, QA Summary Reports, QA Test Logs, Issues Report, Testing Metrics, Defect Control. Expertise in implementing complex business rules using different transformations, Mapping and Mapplets.

Proficient in XML, HTML, Java Script, VB Script, ASP, .NET based application testing. Experienced in Banking and Financial domains.

Experience in implementing complex functional tests that require an understanding of the application logic and excellent problem analysis and bug reporting. Ability to adapt to new environment quickly, strong team player, good communication, good analytical and computation skills, enthusiastic learner, confident, sincere and committed. Proactive in learning new technologies and updating my skills. Excellent experience in troubleshooting software applications for business functions in major areas of the business and enterprise-wide.

Strong diagnostic skills & work ethics, ability to work collaboratively with Testers, Developers & other Team members in testing complex Projects & enhancement of Software Product Quality. TECHNICAL SKILLS

ETL Tool Informatica Power Center 10.x/9.x

Languages SQL, Java, C

Tools Toad, Jira, Putty, WinSCP

Databases Oracle 11g/10g

Operating systems Windows 7/XP and UNIX.

Defect Trackers HP Quality Center 10.0, HP ALM

Methodologies Agile, Waterfall


• Bachelors in Information Technology, JNTUK, India. CERTIFICATION

• ISTQB Certified Tester, Foundation Level


UBS Financial Services, NJ Dec’17-Till Date

Test Analyst


Zeus is a application for credit risk which receives data legal agreements, trades, counterparty info, limits, sensitivity etc from various upstream systems then process the data as per the requires logic and stores it once all the information has been processed the data is sent to downstream systems(like IRIS and ZEUS MIS applications) for front end display and reporting purpose. Here as a Test Analyst validated the data from different upstream systems loaded in the stage environments after applying the business transformations the data is loaded in the target tables where the data will be sent to the downstream applications, the data can be validated through web based testing. Environment: Jira, Microsoft Excel, SQL Developer, Unix, Flat files, M.S.Excel, Oracle 11g, SQL, Agile, Windows 7, Informatica Power Center 10.x, Putty, WinSCP, Internet Explorer, Mozilla Firefox, Google Chrome, Safari.


• Analyzed and Reviewed the Business requirement document and Technical specification document to understand the scope of testing.

• Regularly interacted with management and product owners on project status, priority setting and sprint timeframe.

• Involved in daily Agile stand-ups, analyzing, estimating user stories and delivered them on time.

• Participated in Daily Scrum calls, Demo, Retrospectives, Stories Discussion etc for Agile.

• Extensively worked on web based testing for the ZEUS application.

• Browser compatibility testing for the web application is performed on browsers like Internet Explorer, Mozilla Firefox, Google Chrome, Safari etc.

• Participated in walkthroughs and meetings with Business team.

• Created test plan, test cases and test scripts development and executed based on business and technical requirements.

• Reviewed Functional Requirement Specifications for creating Test strategies.

• Validated several ETL Informatica Mappings for the business functionality.

• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.

• Experience in testing the Web application functionality and Web reporting Data validation.

• Created Test cases based on Test scenarios drawn from functional requirements in ALM/Quality Center.

• Involved in Back-end and Front-end Testing of the applications.

• Co-ordinated with developers for Black Box Testing.

• Performed Database Testing by creating complex SQL queries.

• Validated the source system data with the staging data using SQL

• Used JIRA for managing the stories and requests.

• Performed Smoke Testing, System Testing, System Integration Testing, User Acceptance Testing, Database Testing and Regression Testing.

• Extensively working with Infrastructure Team for executing prerequisite jobs.

• Executed batch jobs and validated data against Oracle database using SQL queries.

• Worked with Infrastructure Team to provide workaround for any job failures.

• Analyzed and created the bug tracking reporting and summary report in the Quality Center.

• Worked on Jira for requirements management, planning, scheduling, running tests, defect tracking, manage the defects and executing the test cases.

• Executed SQL Queries and made sure that values entered in front end is stored successfully in the appropriate data tables.

• Ensured Test Entrance and Exit Criteria is met and complete the Test Completion report for any Risks involved in promoting the code during migration of code in to production if any defects are not resolvable in the current Release.




Tata Consultancy Services (TCS) is a global leader in IT services, digital and business solutions that partners with its clients to simplify, strengthen and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deep-set commitment to our clients, comprehensive industry expertise and a global network of innovation and delivery centers. Client: Bank of Montreal

QA Engineer

Description: The Bank of Montreal (BMO) financial group is diversified financial services provider that provides range of retail banking, wealth management and investment banking products and services in Canada and USA. It conducts business through operating groups, including Personal and commercial banking. BMO provides web base product to allow external and internal users to make mortgage & personal loan payments.

Project 1: OLBB


In BMO, I worked as QA Engineer on OLBB Project where the customers can generate different kinds of templates using different modes of data retrieval for generating reports. As a part of testing data should be collected from Source system then mapped to staging where the business transformations are applied and the data is available in the web portal, where tested the web application manually with different kinds of reports generated and validated the data.

Environment: HP QC, Microsoft Excel, SQL Developer, Unix, Flat files, M.S.Excel, Oracle 11g, SQL, Agile, Windows 7, Informatica Power Center 9.x


• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.

• Created test plan, test cases and test scripts development and executed based on business and technical requirements.

• Involved in testing reports generated in OLBB Application.

• Executed batch processing and verified job status and data in database tables.

• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.

• Performed Verification, Validation and transformations on the Input data (Text files, XML files, and database) before loading into target database.

• Performed Database Testing by passing SQL Queries and retrieved information from database.

• Tested the web application reports generated by validating the functionality using Queries, Slice and Dice, Drill Down, Dashboards etc.

• Tested data migration to ensure that integrity of data was not compromised.

• Responsible for coordinating Integration testing, UAT,Regression testing with Business Consultants

• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Water fall Maintenance process.

• Logged defects in Quality Center and worked with the developers to resolve issues.

• Reported the daily status of test cases executed/failed, defects status calls.

• Worked with business analysts to assure new functionality changes were reasonable regarding existing physical design.

• Performed end-to- end testing of applications and coordinated with other teams.

• Analyzed and created the bug tracking reporting and summary report in the Quality Center.

• Executed SQL Queries and made sure that values entered in front end is stored successfully in the appropriate data tables.

Project 2: Enterprise Wire Payments Feb’13-


As part of this project, the main objective is to check the Payments data is migrated from BMO HARRIS TO BMO, Enterprise Wire Payments verifies different wire Payments and validating the data from different systems, the data is validated by web based testing which is the front end application for payments.

Environment: SQL, HP Quality Center, SQL developer, Oracle 10g, MS Excel, Windows XP Responsibilities:

• Reviewed design documents & business requirements to learn the functions and scope of the application.

• Designed, Communicated, and enhanced QA test plan for the application in Meetings

• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.

• Involved in writing Test Scenarios and implementation of the Test Cases.

• Checked the data flow through the front end to backend and used SQL Queries to extract the data from database.

• Extensively tested the web application by validating the data generated in the reports.

• Involved in conducting Functionality, Negative/Positive, and Security testing

• Performed Functional and Integration Testing manually.

• Identified requirement changes and accordingly prioritized and edited test cases.

• Conducted web based testing to ensure the user friendly interface is available for the end users.

• Detected and tracked the bugs with the help of Quality Center and reported them to the developers to fix it.

• Coordinated with developers on bug fixes and defect status updates on a regular basis.

• Participated in UAT along with the QA lead and Project Manager.

• Preparation of System Test Results after Test case execution.

• Performed Functional, Regression, Data Integrity and System Testing.

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP Quality Center.

• Communicated discrepancies determined in testing to impacted areas and monitored resolution. AdvBackOffice


QA Analyst


Advanced Back Office Solutions offers comprehensive solutions to manage convenience store back office operations with unique software product offerings covering areas like – price book management, invoice management, inventory management, financial management, barcode label printing. The main achievement of this project is to check if the business is on track, identify the things which are going wrong, take and monitor corrective action

Environment: SQL, SQL developer, Oracle 9.2, HP QC, UNIX, Windows Responsibilities:

• Involved in STLC process.

• Developed, implemented test plan, test strategies and Test Cases to ensure complete testing, stability and overall quality of all the applicants.

• Experience in Writing test plans, test cases, test procedures based on business requirements.

• Supported new and existing products by configuring and testing software products and software components of a website.

• Wrote SQL queries and statements to test database for retrieving information.

• Design, document, manage execute test cases and test suites.

• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.

• Involved in extensive DATA validation using SQL queries and back-end testing.

• Executed manual test case. Tracked defect using QC.

• Planned and developed Functional, Integration, Regression and System level testing scenarios and Tested application manually.

• Defined the test criteria and project schedules, and base lined the Test Plan with the help of project meetings and walkthroughs.

• Prepared Requirement traceability matrix (RTM) for the application.

• Parallel interaction with development team and members of Quality Assurance team for cross checking the correctness of the test results.

Contact this candidate