( Mobile: -630-***-**** * Email:- email@example.com
To be associated with a progressive organization with a respectable position which can give me an interesting, innovative and challenging working environment with targets & responsibilities that will utilize my technical, professional skills & experience and offer scope for learning and continuous professional development through teamwork and self-expression.
Bachelor of Technology in Mechanical Engineering.
2 yrs of experience in ETL Testing.
Experienced in working with Guidewire Tool.
Good knowledge of QA concepts and methodology, industry-standard testing, SDLC and bug tracking tool.
Self- directed and capable of working effectively in an innovative and challenging environment.
Experience in Agile practices and methodologies.
Extensive experience in designing test scenarios, test cases for new requirement as well as test execution, defect tracking,root cause analysis.
Experience in documenting daily reports, trackers.
Strong planning and multi-tasking ability.
Strong problem solving, analytical skills and ability to deal with undefined problems.
Excellent verbal and written communication skills.
Completed B.Tech( Mechanical Engineering) in 2017 from JNTUH College of engineering,Jagityal
•Operating System: Windows 7/8/10, Linux
•Database: Oracle SQL
•Language: Core Java
•Web Technologies: HTML,CSS
•Tools: Informatica 9.1,HP ALM,Guidewire Claim Center.
System Analyst at Tata Consultancy Services
Project Name : Farmers Insurance coming under Zurich North America Group
Domain : Insurance
Duration : 2017 – Till Date
Tools used : Guidewire Claim Center, HP Quality Center,Sql, Informatica
Role : ETL Test Analyst
The Farmers Insurance Company has partnered with TCS testing team to test integration of implementation with external systems interacting with Guide-wire based Policy Center system and claim center system to manage different policy-cycle LOBs & Claim cycle LOB’S.
The Guide-wire implementation comprises of 7 Releases based on different LOBs and this will be carried out in 5 Iterations in each and every Release phase. The new Policy Administration system will comprise of Guide-wire Policy Center application & GWCC which will interact with multiple other systems.
This is a transformation project as Farmers Insurance intends to roll-out the HEART policy administration system (mainframe based system) which Farmers is currently using across states business.
The Scope of engagement for TCS is to understand the business requirements of different LOBs with its policy &Claim life-cycle across states that Farmers currently conducts business. Creating test cases on the basis of business requirements and executing it on its integration implemented with other external systems.
Guidewire Operational Data Store (GW ODS) provides a common repository for policy center and claim center that is optimized for business usage. Guidewire CC/CM generates XML messages into MQ based on the business events and messages are loaded through Informatica ETL into claims ODS stage layer
Nature of Work:
Identified data streams and reviewed data models for testing strategies.
Preparing the test data for risk adjustment by extracting, and merging from different tables using SQL.
Once data is migrated to guidewire claim center DB we will ensure that data is loaded properly to Db and make some additional transactions through guidewire UI and check whether it is updated properly in ODS Base.
We will analyze the XML messages generated by GWCC and ensure that data is loading properly into stage DB.
From the acquisition and staging of data, storing records within the data warehouses historical archive and transforming the data for loading into target tables by running Work flows Jobs in informatica.
Good at analyzing work flow jobs in Informatica using designer, work flow manager and monitor.
Identified defects and errors in data prior to data processing.
Collaborated with guidewire claim center and Data Migration team to identify the issues.
Preparing test data required to test few defects according to the scenario.
Participated in daily status meetings, and conducting internal and external reviews with consent teams and documenting the proceedings.
Conducted Knowledge transfer sessions for new joiner.
Good Organizational skills.
Increasing levels of responsibility
Highly analytical with strong critical-thinking and problem-solving abilities
Reliable and committed professional
Has strong time-management and organizational skills
Delivery focused with the ability to prioritize activities
Awards and Honor:-
Received “Star Performer” award for my performance in Stabilization Phase within the project.
Received a “Learning achievement” award within the Project.
Received Central Merit Level Scholarship for the 4 years of my Graduation.
Father Name : Sadanandam
Date of Birth : 09-06-1996
Nationality : Indian
Languages Known : English, Hindi and Telugu
I hereby declare that the information given above is true to the best of my knowledge & belief.