Quality Assurance Project Manager

Sreejaya N

Mobile: 973-***-****,

****,***** ****** *****,*****, TX

E-mail : ************@*****.***

work authorization: Green card

IT Quality Assurance senior

Progressive Auto Insurance company

Cleveland,Ohio

Nov 2017-Present

Project 1# IntelliRisk: The main objective of this project is to provide Managers and supervisors Alerts related to the risks that are fired to intimate them about

Critical priorities that their reporting reps need to perform Leaders have more opportunity to provide actionable, real-time feedback to reps.

Leaders have the ability to remediate issues and get the claim back on track earlier, avoiding further risk.

Using the IntelliRisk tool eliminates the need for many manually-set diaries.

Ultimately, leaders are able to use their time more efficiently and accuracy should improve since they are intervening in at-risk work earlier.

Claim Station Tool Having a very good Exposure to claim station toll which is designed in lotes notes. To track the Claim details of insurer, Vehicle info, Rental. Total loss, Insepction and comparing the results with multiple web interfaces.

Tracking data and validating through OLTP, Prod reporting server and reports.

Roles and Responsibilities:

I was responsible to convert business requirements to functional requirements.

`Worked with business professionals, IT project Manager, Developers and Automation testers on latest enhancements in User interface, reports etc

Involved with end to end data validations from user interface to OLTP servers.

Conducted source to target validations of data flows from oltp to reporting server.

Involved with ETL developers to check fact, dimension tables from multiple sources to target transformations.

Involved in SQL based testing of SSRS and Tableau reports.

Involved in white box testing of code logics and ETLs.

Tracked all the bugs in TFS and performed detailed test documentation using MS Excel, MS word.

Prepared end to end weekly status reports to IT managers and business leads which helps them to track development and testing updates.

Provided efficient testing solutions to business team.

Designed excellent test strategies and scenarios to scrutinize entire applications.

Involved in huge volumes of data testing (billion records) using complex and advance sql queries.

Involved in data migration projects from DB2 to SQL server2012.

Project 2 # Claims business intelligence -Intellilead project

Intelli lead is a advanced version with ad-hoc and cutting edge features in claims management Business intelligence. The main objective of this project is to provide user with decision making Analytical reports for the extensive growth of business and identifying risk based areas in the business perspective.

Roles & responsibilities

Enhanced requirements and made more intuitive suggestions to features and projects.

Designed excellent Data analysis strategies to test UI and Data stuff to save 450 hours of ticket work hours . and 1 million dollars cost to company

Involved in identifying business critical features and prioritizing .

Did an excellent data analysis using Sql Server, MS excel and Analysed data compatibility with reports which has 3 billion records.

Involved in designing leadership dash board project in tableau, made data visualizations with 3 billion records. Made is scalable, accurate interpretations.

Involved in data preparations and test executions of the UI and web based testing.

Did data manipulations using python

Conducted black box grey box, exploratory and Ad-hoc testing.

Extensively used HP ALM and TFS for test management and defect reporting purposes.

Involved in testing and querying OLTP databases .Conducted data centric testing.

Involved in ETL testing of source,staging and target databases for data discrepancies

Involved in writing SQL commands for Verification of Null records, duplicate records, missed records

Worked with MS SQL server, SSIS, SSRS,Tableau and SSAS reports.

Environment: MS SQL server, DB2,Lotus notes, TFS,HP ALM,Agile methodology, MS Excel, SSIS,SSRS and SSAS, Html,Css3,Asp.net

Project 3 #Key metrics project This is a huge data migration project which includes complitaion of millions of records across multiple sources like IBM lotus notes,DB2 to SQL server. Involved in level1 and level2 QA for designing source to target validations with advanced and complex queries. Worked with hex codes commit sequence queries to check. Column to column validations from DB2 to SQL.

Prepared detailed test documentations with screenshots od tables and reconciled records from multiple sources, data sources, databases, reporting servers.

Project 4# DSM I was QA responsible for testing Angular project DSM .It handles individual contracts from vendors and maintaining their data transfers from oracle. It was automation using UI from maintaining excel sheets.

:

ETL QA Tester

Horizon Blue Cross Blue shield

December 2010 to September 2016

VUE Wrap-Up project #1

VUE Wrap-Up is an advance, web-based solution for streamlining and automating the management of Owner Controlled Insurance Programs (OCIP) and Contractor Controlled Insurance Programs (CCIP). VUE Wrap-Up allows CIP administrators to leverage automation; reliability and mobility without the overhead of maintain an in-house system or the cost of outsourced services.

The main objective of the proposed VUE Wrap-Up is to reduce the turnaround time for the major activities of Client to reduce the duplicate of work in performing the customer related activities.

Responsibilities:

• Prepared ETL Test cases according to the given mapping document.

• Involved in meetings with Business Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.

• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.working knowledge of Migration from Datastage tool towards informatica.

• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.

• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.

• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.

• Planned ahead of time to test the mapping parameters and variables by discussing with BA's.

• Validated the source data coming from various databases using complex SQL queries.

• Mocked test data to test all the scenarios and test cases planned.

• Written several complex SQL queries for data verification and data quality checks.

• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.

• Responsible for documenting the process, issues and lessons learned for future references.

• Reviewed the test activities through daily Agile Software development stand-up meetings.

Environment: Informatica 9.5, Oracle 10g, TOAD, SQL Server, SQL, Web services, Agile,, HP QC,JIRA, Datastage 9.x

-worked with Member forms,Paper form and EDI files to feed in the claims System. Validated data from claim system to Financial system .

-Involved in security testing and High volume data testing .

Manual QA Tester project #2

Horizon Blue Cross Blue shield.

Nov 2009-Dec 2010

Newark, NJ

Broad connectivity solutions

The objective is to provide brand support solution by customizing access services and connecting patients to therapy based on requirements from various healthcare and pharmaceutical clients and revolve around Brand Support Services. Worked with healthcare providers with payroll and claims processing.Horizon BCBS is a TPA.

We collected data from the insurer and Member

-

Responsibilities:

• Identify, recommend and implement any enhancements that are required.

• Detailed analysis of the user's requirements, Comprehensive data analysis to fulfill the user requirement. Interact with BSAs and Data modeler to understand the data mapping between source-systems and data-model.

• Used QTP to perform Regression Testing.

• Identified and submitted defects in defect tracking tool JIRA.

• Written several complex SQL queries for validating Cognos Reports.

• Preparing and supporting the QA and UAT test environments.

• Maintained the track of defect and defect report in HP ALM and conducted defect review meeting. .

• Provide UAT and post-production support.

Environment: Manual testing, Oracle, Agile, MS excel, Windows, SQL Server, HP ALM

SKILLS SUMMARY

-8 + years of extensive experience in Software Testing and QA implementation for Client Server and Web based Applications.

-Agile environment: Well versed with usage of agile methodologies. Expertise with usage of Agile Test plan template, Sprint backlog with burndown chart template, User story template, Product backlog templates in MS EXCEL.

-Experience writing SQL queries in TOAD for testing ETL DATA MAPPINGS.

-Experience in writing DDL, DML stored procedures, TSL commands, Inner and outer join commands. Data validation from source to target databases.

- Experience with flat file source files and tables.

-Experience and test cases based on system requirement specification-

-Excellent hands on experience in handling the defects throughout the bug life cycle with QA methodologies, Requirement analysis, writing test plans from detection until resolved using JIRA and HP QC.

-Expertise in Black box testing, Functional testing, Integration testing, Database testing and Regression testing.

- Interacted and organized meetings between end-users, expert team, vendors, development and QA team and suggesting key enhancements and changes to the business architecture

-Thorough working knowledge of Test Plans, Test scenarios and Test cases to ensure comprehensive testing of all functionalities and constancy to Requirements Traceability Matrix (RTM)

- Extensive working experience with web services related projects

- Extensive experience in Software Quality Standards, Documentation and implementation in a business environment .

Technical Skills:

.R studio, Python, Zepplin Notebooks, Data science, Tableau, Hadoop,Scala,Spark pursuing certification course trough IBM

ETL TESTING, Manual testing, C,C++, java, C#, visual studio, .NET, Coded UI.

RDBMS: MS SQL,T-SQL,Db2

BPM Tool: Pega PRPC v5.5

Automated Tools: QTP v9.5, QC, winrunner, JIRA

Browsers: IE 8, Netscape 6, Firefox 3.5,SAFARI,UNIX

Operating Systems: Windows NT / 2000 / XP / Vista

ETL- Informatica power center 9.5,SSIS,SSRS,MS SQL,COGNOS

MS office, MS Excel

Strong Knowledge of SDLC, Waterfall and agile methodologies,TFS,claim station,lotus notes

FRONT END-HTML 5 CSS 3

Python 3,0 jupyter notebooks,R-studio programmimg,tableau

Educational Qualifications:

Bachelor of Technology (Electronics and instrumentation)from Jawaharlal Nehru technology University, Kukatpally, with 68.8%

High School Intermediate from D.A.V junior college with 81%

Tenth C.B.S.E board Examination with 85%

Certifications and awards:

Data science certification from IBM course era

NATIONAL CAREER READINESS CERTIFIVATION

P.G DIPLOMA IN COMPUTER APPLICATIONS

Contact this candidate