SUMMARY

• Data /Quality/Business Analyst with over all 10+ years of IT experience in software testing process which includes around 4 years of ETL/TDM in financial/banking domain in preparing Test Plans, Test Scripts, Test Cases and Test Scenarios Executing Tests based on business requirements and functional requirements and Defect Tracking for Manual Testing.
• Experience in Project Management methodologies like Waterfall/Agile and Iterative.
• Extensive experience in development of test plans, test strategies for testing and establishing test environments.
• Actively involved in design the BRDs, FSDs, Use Case diagrams and Activity diagrams using MS Word, MS Excel and MS Visio.
• Excellent at coordinating extensive communication networks and facilitation of JAD sessions, brainstorming sessions and interviews. Creating agendas and writing minutes of the meeting.
• Experience in Transformation and Loading (ETL) data from various sources into DataWarehouse and Data Marts using Informatica power center (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
• Experience in Test Data Management, ETL, Data Masking
• Experience in data visualization using tableau
• Involved in preparing training documents for KT purpose so new joiners can take advantage of.
• Skilled in data prepping of different channels like AU/CO/Lost/Fraud/Reissue/Renewal.
• Experience in manual preparing testing of diverse range of applications like desktop, Web based, Client - Server, GUI, and Database.
• Proven track record in conducting root cause analysis, risk analysis, ‘AS-IS’ and ‘TO-BE’ system analysis.
• Actively participated in various phases of SDLC & STLC by implementing project management methodologies such as waterfall, rational unified process (RUP), Agile (scrum).
• Experience in Working Agile-Scrum software development methodology.
• Documented all the QA test results and reported defects to the Business management and Technical teams and maintained documents for BA\QA and UAT validations.
• Participated in defect triage and assist in root cause analysis of defects.
• Good functional exposure in Insurance, Investment (equity and shares group, futures and options, Brokerage, Commodities), loans and Banking domain.
• Experience in Anti Money Laundry (AML) Monitoring System to enhance/strengthen its over securities and cash transactions
• Extensive experience in OBIEE reports.
• Extensive experience in Urgent Payment, SWIFT payment messages, Trading and Commercial Loans
• Experience testing LoanIQ in SIT and UAT env.
• Validated E2E events (Contract creation, Contract funded, SWIFT messages MT103, MT202, MT210, ITFT notifications) for LoanIQ and WSS (Wall Street Suites) contracts
• Experience in Writing and executing test scripts in Oracle Flex Cube & SWIFT, have an ability to query and analyze data in databases- Oracle/SQL, MySQL, SQL Server
• Experience in bug tracking, bug reporting like HP ALM, Clear Quest, JIRA and Quality center.
• Played a hybrid role of a DA /QA Testing.
• Experience in conducting Smoke Test, Functional, System Integration, Regression, User- Acceptance Testing (UAT) and Performance Testing.
• Experience in testing Web applications with comprehensive knowledge of browsers and user interface testing techniques.
• Demonstrated outstanding leadership, creative problem solving and analytical skills across multiple platforms.
• Extensive experience with Markets, FX Trades, Online Banking and SharePoint

TECHNICAL SKILLS

Project Methodologies: SDLC, RUP, UML, Agile, Waterfall

Business Modeling Tools: MS Word, MS Visio, MS Excel, Outlook, PowerPoint

Testing tools: Mercury Quality Center, HP ALM

Change Management Tools: Rational Clear Quest

Office Tools: MS Project, MS Office, MS Visio

Version Control Systems: Rational Clear Case

Database: MS SQL Server, MS Access, and Oracle

ETL/ Business Intelligence tools: Informatica Power Center, Informatica TDM, DVO

Banking Tools: IDV, Splunk, DataX, BOSS, SoapUI, CAIL, Flexcube/Flexpay

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

UAT/Functional Tester

Responsibilities:

• Working experience on 3 vendors Diebold, Hyosung and NCR ATMs.
• Conduct Testing, create Defects in HP/ALM Test utility tool.
• Took ownership of P3D for downstream validation, to make sure if XMLs are correctly generated and downstream are getting transaction records.
• Use SQL queries for backend validation if transactions are getting correctly recorded in targeted tables
• Excellent experience using CAIL application for end to end validation for all ATM transaction
• Took lead in process like create Jira request for pushing new builds into ATMs
• Created training documents for the beginners.
• Create Test Cases and Scenarios for the Testing efforts and execution.
• Attend defect triage calls and assist development team in root cause analysis of defects and analyse logs.
• Interacted with developers to report software bugs and re-tested the fixed issues.
• Dialogue with the ATM Lab Techs ref Vendor (Diebold, Hyosung and NCR) software fixes and updates to the OS.
• Involved in creation production like data in test environment.
• Verify if data is getting masked of customer account numbers for transactions come from ATM channels using Splunk application.
• Working closely with the Base24 / ISO 8583 Messaging Team reference to Technical Issues.
• Extensive experience in using SoapUI for web services (XMLs and JASON)
• Used SOAP UI to test different test scenario to automate communication between client - server
• Converse with Project Managers reference to Technical Issues and Test timelines.
• Create and update Test Status and Defect documents for Management.
• Mentor Junior less experienced Resources on Technical Items such as EMV Card Verification, DCC simulator and DPS simulator processing.
• Involved in Automation testing using RTM (Regression Test Management) tool.
• Used ATM simulator in order to perform automation ATM transactions (Get Cash, Deposits and Payments).
• Retract testing data from Datax (Track2, Accounts)
• Create Jira request to push latest build/code to the ATMs
• Recommend Procedures and Timelines in conjunction with Project Testing progress.

Environment: ALM, SQL Server, XML, Windows 7, HTML, Base24, CAIL, Smart Client, Splunk, DataX, BOSS, JIRA, FAST and SoapUI

Confidential, Charlotte, NC

Flexcube SME QA UAT Tester/Data Analyst

Responsibilities:

• Create Test Plans, Test Scripts by reviewing the BRS/SRS provided by Business team and Developers.
• Document current and proposed business processes and rules.
• Prepare Flow Diagrams, Sequential Diagrams in MS Visio
• Extensively use ALM for executing test scripts, Storing Test Results and Test Cases. Importing and Exporting Test cases.
• Involved in creating requirement documents for OBIEE reports.
• Developed UML (Use Case Diagrams, collaboration diagrams, activity diagrams), PROCESS MAPS (Flow charting and SIPOC) by using MS Visio.
• Created ad-hoc report templates for testers.
• Review ETL specification documents and data model.
• Validated and verified of duplicate fields, data continuity, row counts and joins.
• Involved in data masking, data creation, masking of sensitive fields and loading of masked data to non-production environment.
• Interacting with users for verifying user requirements, managing change control process, updating existing documentation.
• Involved with end user meetings to get requirements for new builds of the existing system.
• Test multiple OBIEE reports (DIRT Customer Report, Accounting Entry Report, Fund Transfer Productivity Report, Inbound/Outbound Wire Transfer Report etc.)
• Published TCR (Test Completion Report) after end QA Test Phase/Cycles, also Test Status Reports.
• Performed UAT E2E testing with better understanding the client’s need.
• As a manual tester, I involved in analyzing, reviewing the requirement documents and perform UAT testing.
• Experience in using agile methodology and attended the daily SCRUM meetings during each SPRINT session.
• Providing technical specification and estimates for Test Plan in Oracle FlexCube/Flexpay & SWIFT messages.
• Created LoanIQ contracts in XML format and used web services (IDV) tool to inject LoanIQ transactions and validate E2E process of transaction.
• Performed UAT testing with LoanIQ (London Branch), where I receive contracts from end user initiated from LoanIQ application and validate at the backend using Flexcube.
• Validated end to end RTGS transactions, Loan IQ transactions and FX Trades
• Validated SWIFT message (Tags validation) MT103, MT202, MT210 for LoanIQ and WSS transactions
• Validated GSMOS Sanction scanning process and SWIFT messages creations
• Technical liaison between businesses, agents and vendors to scope, model, integrate, procure and deploy Cloud based solutions.
• Plan, review and executed Software testing in Agile approach & aggressive project schedules providing input on project schedule risks, testing risks and dependencies.
• Developed Test Cases/Test Scripts, execute tests and log defects.
• Tested the custom point of sales program and interface to handle the windows stations including, file serving, database, security, user account management, sales, logon authorization and web services.
• Excellent knowledge of Agile & Scrum development environment, multiple web browsers, and automated testing suites
• Defect logging, assignment and tracking through ALM.
• Participated in Walkthrough’s and Technical Reviews all through the testing phase Applications.
• Performed Regression Testing, System Testing, Smoke Testing, Positive and Negative Testing
• Manually tested the web internet portal application to ensure the flow of the application functionality.
• Involved in manual testing for the functionality of the application on the mobile devices
• Participated in regression testing on Desktop Web App and Mobile Web by reviewing the source code after each build for every release.
• Reviewed complex functional requirements, Prepared the test Strategy Documents.
• Wrote SQL scripts, maintaining Database on QA systems and on Production systems
• Handled multiple Releases/Test cycles and test phases in DEV and QA environments.

Environment: Windows 7 & 10, MS Word, MS Excel, MS Visio, IDV, Informatica TDM, Oracle Fluxcube/Flexpay, ALM, SQL, Microsoft Test Manager, SharePoint.

Confidential, NJ

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Validated various MicroStrategy reports such as ad hoc, grids, graphs.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.
• Tested both conditional formatting and threshold level testing for several reports developed in MicroStrategy.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Involved in testing the UI applications
• Extensively used MicroStrategy for report generation.
• Involved in Security testing for different LDAP roles.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informatica, DB2, SQL, Teradata, Teradata SQL Assistant, UNIX, Informatica DVO, WINSQL, Oracle, DB2, SQL Server, XML, Windows XP, Quality Center

Confidential, Los Angeles, CA

QA Analyst /Business Analyst

Responsibilities:

• Worked closely with Business Analysts and Developers to gather Application Requirements and Business Processes to formulate the test plan.
• Elicited business requirements and translated into various business requirement documents (BRDs) and functional requirement documents (FSDs).
• Executed functional, regression, compliance, and load tests on different Web API.
• Used SoapUI for writing code to send request and validate the response.
• Excellent in determining the response in JASON/XML format
• Actively involved in design Use Case diagrams and Activity diagrams using MS Visio.
• Created test strategy documentation and detailed test documents.
• Have written test scripts to test the Custom exit and the second pass programs written by the RIT team to display the LDT in the correct format.
• Participated in playing back GUI and Smoke Scripts to smoke test every build.
• Helped the management team in validating the test LDT before the CI team could send the file to the customer.
• Have been keeping track of the work done by the entire team using an internally created application called as the Migration Tracking Repository Application (MTRA).
• Performed Back End Testing by writing SQL queries.
• Planned and Executed backend testing using numerous SQL Queries to verify the dataflow from the database using DB Visualizer.
• Used Tableau to develop integrated dashboard to track data quality progress, submit weekly report for the management and internal use.
• Executed SQL statements to test the integration between application and database
• Wrote Modification Request for the bugs in the AUT and helped developers to track the problem and resolve technical issues.
• Planning and executing Functional, system Integration testing and performance testing of the Capital Markets, MasterCard and Online Banking web-applications
• Extensive knowledge on Credit Card application process and involved in validation of the database for the testing on Credit Card information as well as executing test cases related to Credit Card system.
• Participated in Walkthroughs and Defect Review meetings to ensure overall quality of the software.
• Created and maintained the Requirements Traceability Matrix (RTM).
• Experience on international trades and transaction using SWIFT codes for equity and capital market.
• Interacted with the developers to report and track bugs using Quality Center.

Environment: Quality Center, SQL, UNIX, HTML, ALM, Tableau, SoapUI, MS Visio, TFS (Team Foundation Server)