Resume

Sign in

Sr.QA Engineer

Location:
Corona, California, United States
Posted:
August 02, 2017

Contact this candidate

Resume:

Experience Summary

**+ years of IT experience in Software Quality Assurance and Testing in Financial, Business Services, Insurance and Healthcare.

Strong Test Management Skills and experience in running large, Cross-Enterprise testing initiatives leading both onshore and offshore teams.

Experience using SCRUM Framework with Agile Methodology, V-model and Waterfall development methodologies. Use Rally for tracking. Have multiple JAD / RAD sessions

Updated skills towards new corporate initiatives helping mentor QA Scrum teams on testing with new technologies using AWS, Hadoop, Platfora, C#, ASP.Net, Selenium, python scripting, Tableau etc.,

Perform QA Lead role in presenting ideas and information to team and department, mentoring peers, defect tracking, department meetings, maintaining automation software and coverage, test status and deliverables, maintain best practices and methodologies

Successfully coordinate and Lead Meetings with Technical Teams and Business Stakeholders.

Coordinate and Lead Roles in Creation and Execution of QA and Testing Processes, Test Strategies, Test Estimation, Test Plans, Bug Documentation and Regression Testing.

Experience in ETL Data Warehousing, Database Testing using Informatica for Workflow process and Reports developed using Cognos BI Applications such as Cognos 8.x BI Report Studio, Query Studio, Analysis Studio, Metric Studio, Event Studio, Cognos Series 7.x on Impromptu, Power Play Cubes, Impromptu Web Reports (IWR), Security testing with Access Manager, Architect, Transformer, Scheduler and ReportNet Powerplay cubes and dashboards.

Well versed with complete Life Cycle Development process which includes Requirements Analysis, Documentation, Development, Testing, Implementation and Maintenance of the HRMS module using Peoplesoft HRMS and Finance.

Demonstrated Expertise in Leadership, Project Management and Estimation.

Need to validate the OLAP cubes and do a thorough testing before and after rollup with different slice and dice and Data marts

Write BTEQ scripts in Teradata with SQL Assistant of Teradata

Profound insight to Determine Priorities, Schedule Work, and Meet Critical Deadlines and Proven ability to work collaboratively and focus the team to commit towards achieving dynamic goals and Ability to Meet Project Milestones and Deadlines on Deliverables

Experience in coordinating User Acceptance Test (UAT), Operation readiness Test (ORT).

Experience performing Functionality Testing, Graphical User Interface (GUI) Testing, Integration, Negative testing, User Acceptance (UAT) Stress Testing and Regression testing on several applications as needed to minimize defects.

Knowledge in Capability of Maturity Model Integration (CMMI) levels.

Experience in working client-server, web-based, stand-alone and database related project on Windows and UNIX platform.

Tested Reports on different PeopleSoft HRMS Functional areas in modules like Tuitions Reimbursement, HR Transactions, Offers, Dependents, Job Change, Terminations, Security, Exit Survey, Hires, Diversity, Contingent Worker, Leaves, Compliance, Headcount, Benefits, Background Check.

Extensive experience in designing and performing Verification and Validation, and test scripts and back-end testing with relational database (RDBMS), developing and maintaining Test Matrix and Requirements Traceability Matrix (RTM) and performing Gap Analysis

Have expertise in testing maps on Informatica 6.x and 7.x versions and also AbInitio Graphs.

Experience in manual as well as Automation Testing using QuickTest professional, Quality Center, PVCS (Polytron Version Control System), and Test-Director, Selenium, TestNG, Maven, Perforce, JIRA, FasTEST.

Experienced in writing UNIX shell scripting and testing of production jobs, automating them and creating Test Plan, converting and documenting requirements into Test Cases.

Excellent analytical and communication skills and ability to multitask and work well in teams.

Employment Details

Iconsoft Inc. Burlington, MA, USA Sep 2010 – Current

NPS Technologies Silver Springs, MD, USA Mar 2009 – Aug 2010

Covansys a CSC Company, California, Irvine, USA Feb 2002 – Jan 2010

Advantecs Groups Inc., Iselin NJ, USA Oct 2001 – Jan 2001

Birlasoft Technologies Inc., Edison NJ, USA Dec 1999 – Sep 2001

TranSys India Pvt Ltd., Chennai Mar 1997 – Dec 1999

Technical Summary

Operating Systems: DOS, Windows 95/98/NT/2000/XP, MVS/ESA, DOS/VSE and UNIX Solaris

Languages: SQL*Plus, HTML, DHTML, Visual Basic

Databases: DB2 7.0, ORACLE 7.x /8i, 9i, Teradata, MS SQL Server 2000 and MS Access

Tools QTP, JBuilder, Front Page 2000, TOAD, Cognos Series 7.0, DB2 Quest Central

Software Packages: MS-Office, Microsoft Word, Excel and Power Point

OLAP Tools: Cognos 8.x BI Report Studio, Query Studio, Analysis Studio, Cognos Framework Manger, Metric Studio, Event Studio, Score cards, Strategies, Cognos ReportNet, COGNOS Series 7.x (Cognos Impromptu Administrator, IWR (Impromptu Web Reports), Cognos Powerplay Transformer, Power Play Web Reports, Power Play Enterprise server, Upfront Server Administration, Access Manager, Data Stage, LDAP Server, Configuration Manager, Decision Stream), REPORT NET 1.x, Query studio, Report studio and Publishing the Cubes and Reports to the Upfront Portal implementing Row level security

Environments Citrix, Cognos Services like configuring Common Logon Server using i-Planet Directory Server, PPES (Powerplay Enterprise Server, Transformation Services, Upfront Portal Servicing, SMTP, HP/ALM, TCP/IP

Technologies Active Server Pages (VbScript), XML, Java Script, HTML, Microsoft Internet Information Server, Visual Interdev, Netscape LDAP Directory Server, UNIX, Selenium, TESTNG, Maven, Java, Shell scripts etc.,

E.T.L Tools: Informatica 6.0, PowerMart 6.0/4.7 PowerCenter 6.0/1.7.2

Domain Knowledge HRMS (HR Management System) using PeopleSoft and Finance

Automation Page object methodology Automation frame work for GUI using selenium, TestNG, JUnit, ANT, Eclipse, Maven, JIRA, Perforce etc.,

Education

Bachelors in Electronics and Telecommunications Engineering, from Madras University - May 1995

Engagement Overview

Iconsoft Inc Feb’14 – Till Date

Kelley Blue Book (COX Automotive Inc) as Sr. QA Engineer - Technology & Data Intelligence

Kelly Blue Book is part of Cox Automotive Inc. which is transforming the way the world buys, sells and owns cars with industry-leading digital marketing, software, financial, wholesale and e-commerce solutions for consumers, dealers, manufacturers and the overall automotive ecosystem worldwide. Since 1926, Kelley Blue Book has been one of the best-known names in the auto industry. Today, KBB.com extends the tradition, with trusted values and a reputation for innovation, including resources to help research, price and shop for the car been looking for. Committed to open choice and dedicated to strong partnerships, the Cox Automotive family includes Auto trader®, Dealer dot com®, Dealer track®, Kelley Blue Book®, Manheim®, Next Gear Capital®, vAuto®, Xtime® and a host of other brands. The global company has 33,000 team members in more than 200 locations and is partner to more than 40,000 auto dealers, as well as most major automobile manufacturers, while engaging U.S. consumer car buyers with the most recognized media brands in the industry. Cox Automotive is a subsidiary of Cox Enterprises Inc., an Atlanta-based company with approximately 60K employees.

Project: EDW Valuations data is a centralized, cleansed, standardized, cross data source covering Retail, Auction, Listings, ICO (Incentive Cash Offer) having easy access to dimentionalized reporting model which is Meta data driven with repeated process across dealers. Data sources from dealers will be feeding the centralized RCP (Reusable Component Process) where the Vehicle_Match_Service, Pricing components are made reusable for both internal and external systems to KBB. Internal system supporting Vehicle Configurations, Vehicle Values, KBB Vehicle, Field Analyst Inspections, Forecast Models, Order Management, Web Data and external system supporting feed to Auction, Retail, Ad Impressions, Website Traffic, Survey, Vehicle Registrations, Vehicle Maintenance, Market Conditions etc., The centralized RCP transaction is used by Predictive Analytics team for making Vehicle valuations models & forecasts, Web upfront forecasting, Owners strategy, engagement index, behavior analysis, Web Analytics, Traffic monitoring & analysis, Ad Analytics, Impression clicks, OEM delivery performance, Ad forecasting, Campaign tracking, Upsell analysis, Market Intelligence, Cross shopping analysis, New car traffic analysis, OEM reporting, KBB.com support, New Car Transparency etc.,

Responsibilities:

Analyze Business Requirements for Valuations and Web data and create detailed test cases.

Work closely with the business users and data architects to gather requirements and have multiple JAD sessions to scope out the deliverables

Participate in grooming for sizing, planning and schedule QA efforts.

Create test data for complex ETL requirements on both Valuations and Web requirements and write queries to validate business rules.

Use Informatica and validate data target warehouse systems from various data sources.

Expertise in ETL Mapping validation, Workflow and Session log analysis.

Worked on big data projects developed using Hadoop and Platfora.

Analyzed ERWIN diagrams for various Val and Web data sources creating QA knowledge base.

Took self-paced trainings towards new corporate initiatives helping mentor QA Scrum teams on testing with new technologies using AWS, Hadoop, JMeter, Platfora, C#, Selenium, python scripting etc.,

Assist business users validating the results in the UAT sessions with use cases.

Attend daily stand up meetings to discuss the progress on 2 weeks sprint.

Participate in retrospect meetings to provide feedback on what went well and which needs improvements.

Monitor defect tracking for the project, ensuring proper follow-through and resolution of issues and provide high level defect tracking status updates using Bugzilla and later moved to Rally following Agile Methodology with 2 weeks scrum. Use TFS to maintain code versions.

Use TFS (Team Foundation Server) to maintain the latest code versions.

Work with the Executive Staff and various teams throughout KBB.com to provide a clear vision and facilitate the execution of a Behavior-driven-development (BDD) Quality Management Process that is focused on customer satisfaction, continuous improvement, employee development and business growth.

Use ERWIN model to read logical and physical data models and understand the relationship between various tables and documenting the results

Plan, develop, and implement the research of new or improved testing methods, processes, tools, and systems.

Ability to quickly and thoroughly understand As-Is and To-Be business processes to adapt to changing requirements

Assist the project team in delivering a quality software product through collaboration with the product owners, business analyst, project software architects and developers

Analyze, review product backlog stories, write, and execute all testing related efforts, covering regression, functionality, script development, and end to end testing.

Good team player and ability to work well in team.

Project Environment: Informatica PowerCenter 9.5, Micro Strategy, Netezza, SQL Server, SQL Server Management Studio, Aginity, Hadoop, Platfora, TFS, Bugzilla, C#, AWS, SQL Server 2012, Microsoft Visual Studio Professional 2012.

Iconsoft Inc Aug’12 – Feb’14

Experian Consumer Direct – SQA Analyst Senior - Data Warehouse, Tech Ops/UK

Experian Consumer Direct is part of Experian InteractiveSM and the market leader for online credit reports, scores and monitoring products delivered directly to consumers over the Internet. Among its products, the business provides consumers with instant access to their credit report and credit score, plus credit monitoring products that monitor all three national credit reports daily and include identity theft insurance and fraud resolution. Experian Consumer Direct is getting global (including UK) and has established integrated, co-branded partnerships with leading online financial destinations that provide consumers with a broad range of comprehensive online financial products and information essential to managing one's financial life.

Responsibilities:

Testing complex Reporting in Cognos and Power Cubes to meet the business requirements on various ECD and Partner UK products like Halifax, Tesco, Auto check, PMID(Protect My ID), Pre-PIN, LMB (Lower My Bill), USEM (Unlimited Scores for Exisiting Members), RBS (Royal Bank of Scotland), Vehicle Check, UK Bedrock, Converting third party Garlik Alerting to Global Alert Hub, RSA Algorithm for critical data encryption etc.,

Testing the ETL logic which flows from FO (Front Office) to BO (Back Office) to ODS (Ware-House - Operational Data Store) for UK to understand data sources and test new requirements

Leverage and impart strong business and analytical skills on various Reporting across products

Knowledge of Data Modeling and Cognos Reporting to understand the business.

Able to work interactively across products and projects in a fast-paced environment.

Playing the role of SQA Analyst Senior - Data Warehouse, Tech Ops/UK, testing CTRL+M jobs and SSIS packages of Microsoft SQL Server 2008.

Testing the Replication of tables from UK-FO(Front Office), UK-BO(Back Office), UK-Phx_Ext_Reporting and final Reporting on ECDWarehouse target validating using Informatica DVO.

Validate Cube Development on Rolling-up, slice and dice, Cube Refresh, create Adhoc reports to business. Key cubes include Revenue Persistency, Bill sum Finance and Historical Cube, Orders Marketing and Historical Cube, Membership Churn, Orders Operations, Orders Real-time, Membership Revenue Persistency

Write Queries against SSIS to Verify the UK Business Rules against the Database on Reports and Cubes.

Prepare Test Cases using Team Track and tracking using Test Link.

Use Page Filler to populate the data for the new enrollments and cancellations across various UK products.

Modify customer scenarios using CST (Customer Support Tool) to generate Alerts, Transactions, Billings, Cancellations, Aging a customer etc.,

Perform End-to-End Testing executing the test scripts

Test the security on the system implemented across products and test the PMID with various monitoring services including Credit Monitoring and Web Monitoring.

Validate masking of the proprietary data and SSN hash logic to tighten the security across customer base.

Complete and sign Test Exit Criteria, indicate recommendation (yes/no) for Production Implementation and complete extended PLV (Project Launch Verification) with Business and end users of the Report or the Cube.

Use JIRA with Agile Methodology on 3 weeks scrum and track user stories

Have multiple RAD process during Agile to have quick deliverables on the scope covered.

Test Row Level Security for the reports and the cubes.

Project Environment:

Testing on Cognos Reports and Cubes, Test Link for creating the test cases, Table replication, CTRL+M jobs to call the SSIS packages, Informatica on testing ETL, Stored Proc using MS SQL Server 2010, Cognos BI tools using Report Studio, Framework Manager, Query Studio, Analysis Studio, Access Manager, LDAP etc.,

Iconsoft Inc Aug’11 – Jul’12

Intuit Inc (Merchant Tax Reporting) – Sr.QA Consultant

A Merchant has to Report the Tax to IRS based on the new 6050W compliance which states beginning calendar year 2011, the IRS (Section 6050W of the IRS Code) requires reporting of all payment card and third party network transactions. As Intuit is a reporting entity, Intuit will be required to file an annual information return with the IRS and provide Merchants with a Form 1099-K, which reports monthly and annual gross transaction sales. A 1099-K form will be mailed to Merchants. By March of each Fiscal year, Intuit Payment Solutions will file a copy of the 1099-K with the IRS. To comply with this new law, it is necessary that Merchants have their correct taxpayer ID number (TIN) and tax filing name. For additional information please visit the IRS website at :http://www.irs.gov/irb/2009-49_IRB/ar13.html. Project is Split into 2 phases. Phase 1 covers the Oasis UI Changes, Response file processing from Convey and Phase 2 talks about the Settlement and Money movement with Annual Gross Sale Reporting to the Merchants.

Responsibilities:

Validate two separate Merchant base systems called OASIS and ECHO where 6050W compliance needs to be achieved for the Existing and New Merchant base.

Validate New Oasis User Interface where the W9’s will be sent to Merchants using New Case creation.

Validate the 3rd party (Convey) Merchant Portal hosted through the MSC (Merchant Service Center) / MBC (Merchant Business Center) portal and provide the 1099s for the Compliant Merchants

Withholding amounts needs to be validated for the Known Bad TIN and for Non Compliant Merchants and Merchants with ‘B Notice’ from the IRS

Confirm the Settlement has happened after Withholding where the amount needs to be released to the Merchants.

Use Rally for tracking the user stories

Golden Gate is used to track the changes between Oasis and iHub and only conformed Dimensions and Measures are pushed to iHub.

Table Statistics on the Staging is tracked and Monitored and if there is a spike, alerts are generated to the core group.

Experience using Selenium with POM - page Object model Automation framework

Ensure that withholding and settlement is only for the Card Merchants and not for Gift or Tax Merchants

Validate Annual “information returns” for each merchant. Report the total aggregate gross amount of credit card and debit card payment for the calendar year to be validated.

Prepare the High level TestPlan, Test Strategy and various Risks involved in the End to End cycle

Build simulated scripts to receive the Response files similar to IRS with different scenarios and Test Cases.

Underwent corporate Selenium, TESTNG, Maven, and Java Training and started working on the TAME (Test Automation Made Easy) Framework and one of the core team member on the Automation.

Prepare Test data to process various possible Negative scenarios with IRS and simulating the Responses.

Thoroughly test the complete workflow on Oasis UI changes covering Emails send or by Postal with or without the W9 attached as New case creation requested by Merchant for the Merchant to be compliant against the 6050W IRS requirements.

Automate the End to End testing with Selenium and TestNG build with Maven and Perforce

Perform End-to-End Testing with Convey and IRS systems at run time and also make use of the Taxport which gives real time information at run time with IRS.

Have separate SCM scripts to be validated in sending the Request and processing the response back from Convey.

Ensure that the proprietary merchant information is PGP encrypted and hash logic applied to tighten the security before sending the request to Convey in the form of Trusted signatures shared by both parties as handshake

Complete the JIT(Joint Integration testing), Functional Testing, Regression Testing, Failover Testing, UAT and provide support till the project is live in Multiple phases and sign Test Exit Criteria, indicate recommendation (yes/no) for Production Implementation and complete Project Launch Verification and get the signoff from the Business and end users.

Good team player and ability to work well in team.

Project Environment:

OASIS and ECHO systems, Sonora, FDR, IDEA, Selenium, acrobat livecycle designer, Perforce, JIRA, SQL Server 2008 for IDEA databases, TOAD for Oracle under OASIS environment, JIRA, Eclipse, Selenium, TESTNG, Maven, and Java, WinSCP to FTP the files to the Oasis CIDEV4 env, LDAP access on Security, etc.,

Iconsoft Inc Aug’10 – Aug’11

Experian Consumer Direct –US as Sr.QA DWH / BI Consultant

Experian is a global leader in providing information, analytical tools and marketing services to organizations and consumers to help manage the risk and reward of commercial and financial decisions. Using the comprehensive understanding of individuals, markets and economies, Experian help organizations find, develop and manage customer relationships to make their businesses more profitable.

Responsibilities:

Testing complex reporting in Cognos and Cubes to meet the business requirements on various products like FCR (Free Credit Score), FCS (Free Credit Score), FACTA, Redemption, PMID (Protect My ID) for Identity Theft, Credit Score, Credit Expert, AMEX, Roosevelt, Triple Alert, Omniture, Family Secure, Triple Advantage, Green Umbrella, Mighty Net MNI on CreditScore and CreditReport etc.,

Work with the ETL and Reporting team to understand data sources and test new requirements

Leverage and impart strong business and analytical skills on various reporting across products

Knowledge of Data Modeling and Cognos Reporting to understand the business

Able to work interactively across products and projects in a fast-paced environment

Playing the role of Quality Lead Testing CTRL+M jobs, SSIS packages of Microsoft SQL Server 2008,

Use Informatica IDQ for validating and monitor testing activities.

Testing the replication of tables from FO(Front Office), BO(Back Office), Phx_Ext_Reporting and ECDWarehouse

Validate the Global enrollment of a customer across products on various memberships.

Validate Cube Development on Rolling-up, slice and dice, Cube Refresh, create Adhoc reports to business etc.,

Write Queries against SSIS to Verify the Business Rules against the Database on Reports and Cubes.

Prepare Test Cases using Team Track

Use star data to prepare test data and enroll the users under multiple products and runways across environments.

Modify customer scenarios using CST (Customer Support Tool) to generate Alerts, Transactions, Billings, Cancellations, Aging a customer etc.,

Perform End-to-End Testing executing the test scripts

Test the security on the system implemented across products and test the PMID.

Validate masking of the proprietary data and SSN hash logic to tighten the security.

Complete and sign Test Exit Criteria, indicate recommendation (yes/no) for Production Implementation and complete extended PLV (Project Launch Verification) with Business and end users of the Report or the Cube.

Test Row Level Security for the reports and the cubes.

Good team player and ability to work well in team.

Project Environment:

Testing on Cognos Reports and Cubes, Star Track for Test data across runways, Test Link for creating the test cases, Table replication, CTRL+M jobs to call the SSIS packages, Create stored Proc using MS SQL Server 2008, Cognos BI tools using Report Studio, Framework Manager, Query Studio, Analysis Studio, Access Manager, LDAP etc.,

Covansys a CSC Company Dec’06 – Aug ’10

Kaiser Permanente as Sr. QA Datawarehousing Consultant

Project Description:

Kaiser Permanente is the nation's largest nonprofit health plan, serving 8.2 million members, with headquarters in Oakland, California. At Kaiser Permanente, physicians are responsible for medical decisions. The Permanente Medical Groups, who provide care for Kaiser Permanente members, continuously develop and refine medical practices to help ensure that care is delivered in the most efficient and effective manner possible. With the oneLink project initiative across multiple business units spanning states various Medical claims, Audit claims, Claims Process, Claims Adjudication etc are handled in one central repository and reported against

Kaiser Foundation Hospitals and their subsidiaries

The Permanente Medical Groups

Prepaid insurance to spread the cost to make it more affordable

Focus on preventing illness as much as on caring for the sick

Responsibilities:

Playing the role of Quality Team Lead Testing Ad-hoc Reports and Cube Development.

Develop scripts to test the HR Dashboards for the Kaiser Management of the HR activities.

Write BTEQ scripts in Teradata and SQL Assistant of Teradata as part of ETL mapping task to load test the target systems.

Validate Data Models on the presentation layer and logical layer of Framework Manager.

Test Reports, Dashboards and Cubes created using Powerplay and Scorecarding using Metric studio and the events created using Event Studio and Reports created using Report Studio, Query Studio, Analysis Studio, Dashboards and Scorecarding using Metric studio

Testing Teradata Source and Oracle Target systems of the model

Validate the cubes and test the before and after rollups

Validate Data summarization of the data on the OLTP transactions to the Cube requirements and test the Report Performance.

Test the Report migration across Dev, Test and QA environments.

Test the Row Level Security for the reports and the cubes for the User Groups

Worked on testing PIMS (Pharmacy Information Management System) as part of Clinical trials.

Test the users Imported from the PS_Users of peoplesoft to the access manager and run the shell scripts to validate the users allocated to different User Goups and their security level.

Testing the Bursting of the reports for the users to see them prerun for the immediate access.

Test the Published Cognos Query packages to Cognos Upfront and testing the customization of Cognos Portal.

Setting up and Configuring Cognos Application Server.

Review of Delivery to ensure adherence to standards, quality and Performance.

Coordinate with end users to complete the Regression testing

Also responsible for maintaining the Quality Standards as per the CMM Level 5 procedures and also standards provided by the client.

Project Environment:

Quality Center 9.0, Portal of Cognos 8.4 BI Report Studio, Framework Manager, Report Studio, Query Studio, Analysis Studio, Powerplay Studio, Event Studio, Access Manager, LDAP, Upfront Portal, Powerplay transformer, AbInitio Recruitment system, Peoplesoft source system for HR Dashboards and Teradata and Oracle.

Covansys a CSC Company Feb’02 – Nov ‘06

Hewitt Associates as Software Engineering in Test

Technical Environment: QTP, Peoplesoft 8.3 & 8.8, Cognos Series 7.0, Cognos 8.3, ReportNet 1.1, Informatica Power center 6.2, and 7.1, Citrix, Windows NT, IBM DB2 UDB Version 8.2 and Sun Solaris, STAT, Continuus, Clearcase

Project Description:

Hewitt Associates is a global outsourcing and consulting firm delivering a complete range of human capital management services to companies, including HR and Benefits Outsourcing, HR Strategy and Technology, Health Care, Organizational Change, Retirement and Financial Management and Talent and Reward Strategies.

WFM Product is Centralized and integrated service for employees, HR managers and HR representatives of the company. This comprehensive and integrated set of delivery capabilities will help Organization to manage HR related costs, while improving the effectiveness of HR programs. Actively involved in successful completion of WFM Product Release I & II and implemented in various clients like SONY, MEDCO, BAYLOR HEALTH CARE, GOLDMAN SACS & STATE STREET

Hewitt-WFM clients implements analysis on HRMS reports like Headcount, FWA (Flexible Work Assignment), Hires, HR Transactions, Job Change, Leaves, MISC, Offers, PDC (Personal Data changes), STA (Short Time Assignments), Tuitions Reimbursement, Terminations, Contingent Worker etc., using Peoplesoft HRMS database as the source which populates the data to EPM database for the reporting requirements which contains ODS and Data mart using Informatica and Cognos Series 7.x and ReportNet

Responsibilities:

Playing the role of Quality Lead Testing the load of ETL Data manipulation, Ad-hoc Reports and Cube Development.

Testing Created catalogs, user classes, database UDF and Database connections.

MTP (Test plan) preparation and Review Test Case and actively involved in writing Test Plan, Test cases and testing categories by reviewing Project Specification and Business Requirement documents

Write Queries to Verify the Business Rules against the Database

Write Test Cases based on the Business Requirements and Detailed Design review meetings.

Preparation of Test Report and summary preparation and Daily Status Reporting

Performed End-to-End Testing by executing the test scripts

Test the provided security for the catalogs from the user classes.

Worked with appropriate Team Leads, Business and end users to ensure quality of test deliverables & timely completion of individual test plans

Testing the Bursting of the reports for the users to see them prerun for the immediate access.

Involved in all phases of testing like Unit Testing, System Testing, Integration Testing, Regression Testing during the entire life cycle

Complete and sign Test Exit Criteria checklist and indicate recommendation (yes/no) for Production Implementation

Create and update automated test scripts and shell scripting to support ongoing Regression tests

Validate Data Models on the presentation layer and logical layer of Framework Manager.

Validate the cubes and test the before and after rollups

Validate Data summarization of the data on the OLTP transactions to the Cube requirements and test the report performance.

Test the migration of Reports across Dev, Test and QA environments.

Test Row Level Security for the reports and the cubes for the User Groups

Test the users Imported from the PS_Users of peoplesoft to the access manager and run the shell scripts to validate the users allocated to different User Goups

Review of Delivery to ensure adherence to Standards, Quality and Performance.

Test the Migrated Reports across environments.

Running Unix-Shell scripts and testing the populated users of EPM



Contact this candidate