Prashanth M Email & Phone Number

Halifax, Canada Area

Mainframes (DB2), Oracle 12C, Oracle Business Intelligence Enterprise Edition 12C (OBIEE), Microsoft Rumba 8.1, Informatica 9.1.0,Parasoft SOA 9.9, SQL Developer, Selenium BDD framework, Selenium Grid, AQT, JIRA, HP ALM 12.2 Notepad ++, Putty, WinScp, MS Office Suite Global Participant Indicative Data is designed to accept Unicode data for Global Participants and transliterate to ASCII data to support existing Legacy Mainframe systems

Halifax, Canada Area

Fidelity Investments - Enhanced Reporting ProjectETL/OBI Test EngineerInformatica 9.1.0, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Selenium, SQL Developer, AQT, PL/SQL Developer, HP ALM 11, HP ALM 12.2 Notepad ++, JIRA, Filezilla, Putty, WinScp,VMware, MS Office SuiteEnhanced Fidelity Plan Sponsor Web station (PSW) reporting is an analysis tool that creates data reports and templates in real time data. With enhanced reporting the users can get a summarized view, run an existing reports template and create new report templates to meet the business need, Testing involved verification and validation of standard and custom reports using Oracle Business Intelligence Enterprise Edition (OBIEE) tools

Halifax, Canada Area

Fidelity Investments - Optimal Online Query (Distributed Balances) ProjectData Quality Analyst•Involved in the creation of test plan by outlining test assumptions, risks, timeliness, build management, entry/exit criteria and deliverables•Developed complex SQL queries for querying data against different data bases for data verification process•Developed SQL scripts for verification of data at extraction phase to ensure ,transformation phase and loading phase of the data to ensure correctness of the data and also verifying the ETL mapping rules•Ensured Error logs and audit tables are generated and populated properly•Worked closely with Business users in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications•Executed Test Cases with respect to Source and Target database tables.•Documented and reported on identified system testing issues in HP ALM•Actively conducted/participated in defect triage and test status meetings•Tested a number of complex ETL mappings and reusable transformations for daily data loads•Involved in creation and execution of UAT test cases•Responsible for running Informatica workflows and checking workflow logs and session logs using UNIX•Contributed in the development of knowledge transfer documentation•Tested submission API, which is responsible for submitting both parsed as well as meta events to backend•Build and executed complex SQL queries using JOINS, UNION, Nested queries and SELECT statements to validate source data to migrate from source to staging database

Halifax, Canada Area

Fidelity Investments - Executive Insights ProjectETL/OBI Test Engineer•Translated business and systems requirements into technical test requirements•Reviewed and analyzed client-specific system requirements and scope of services•Analyzed functional and technical system design for testability•Collaborated with project team resources to understand and prioritize system testing efforts•Provided input to system test strategies•Created test scenarios, system test plans, test cases and participated in execution of manual and automated test scripts•Created UAT test scenarios and test cases and participated in execution of UAT test scripts•Agile based standard practices are followed in overall project•Collaborated with the project team members, development team and periodically confirm system test schedule•Executed Systems Integration Test Plan, including the comparison of actual results to expected results•Responsible for running Informatica workflows and checking workflow logs and session logs using UNIX•Responsible for Comparing data between OBI reports and database using SQL queries •Developed SQL queries for data validation for verifying the ETL Mapping Rules•Verified the data completeness using SQL through different testing approaches•Documented and reported on identified system testing issues in HP ALM•Actively participated in defect triage and test status meetings•Identified defects in multiple environments and throughout all phases of the development life cycle. Ensured that development groups address all open defects in a timely manner.•Assisted in analysis of current processes and propose recommendations for process improvements•Actively participated in project team meetings as required and communicated work status and issues to QA lead.

North Vancouver

•Had an in-depth understanding of business knowledge and have interacted with BA’s to have a clear understanding of the project•Worked very closely with the Guidewire development team in understanding the configuration•Attended several meetings and involved in business acceptance criteria solutions to filter out unnecessary approaches which saved time and have a clear outlook on what need to be done in the project•Prepared Testing Strategies for Data Warehousing Application•Daily stand up meetings, tracking of every day progress and discussing blockers which interrupt the target completion with corresponding developers to resolve issue as early as possible for task completion on daily /weekly and monthly basis.•Created Test Scenarios to ensure the complete coverage of Testing•Designed and Executed test cases based on Mapping Documents•Created the regression test cases to make sure the completeness of testing•Extracted legacy data from Guidewire Claims Center and validated the end to end Claim Center functionality•Performing testing on Guidewire Claims Management system implementation and policy center implementation•Executed end-to-end test cases to validate the integration between Policy Center, Claims Center and Billing Center.•Understood the data models and data types in different databases and their ETL process•Developed SQL queries for data validation for verifying the ETL Mapping Rules•Verified the data completeness using SQL through different testing approaches•Reported defects through JIRA and attended Defect Triage meetings to resolve issues accordingly•Loading and execution of test cases using RQM and linked defects to JIRA•Worked closely with development team to understand the conversion process.•Tested data integration, data mapping, ETL process, ERP system, and compliance applications