Ask Question / Post resume

Post a reply to the thread: www.lexmark.com International India Pvt Ltd Kolkata : ETL Architecture

Your Message

Your Username:

Notes:-
1) You can copy and paste your full resume in the box below.
2) Or you can ask your question. We try to answer, as far as possible.

Title:

[QUOTE=Guest-IJT;140472][B]Name [/B]: Taranpreet Kaur Farmaha
[B]Email [/B]: Taranpreet_Farmaha AT yahoo.in
[B]Designation / Skillset[/B] : Test Engineer
Taranpreet- Test Engineer, Infosys

[U][B]Resume[/B][/U] :
 OBJECTIVE
To associate with an organization which provide career growth by offering challenging project. To enhance my professional knowledge and skill so that it is beneficial for industry as well as my professional career.
SUMMARY
- Presently working as Testing Engineer in Infosys Technologies Ltd., Hyderabad, India.
- Working in Infosys for 1year 7 months and has led Manual testing process for Mainframe and Dot Net Application in Life Insurance domain and Data Warehouse testing for Microsoft.
- Proficient with complete Software Testing Life Cycle including Requirement Analysis, Test Planning, Test Execution, Defect Management, Test Reporting and documentation. Have hands on experience on Functional and Manual Testing methods.
- Good at soft skills like interpersonal communication, analytical skills, general thinking and teamwork.
PROFESSIONAL BACKGROUND
- Manual Testing of Mainframe Application and .Net application.
- Data Warehouse Testing – backend manual testing of Financial Application for Microsoft.
- Undergone training at Infosys in Mainframe Technologies. Major training in Mainframes.
[B]- Stream Training [/B]:-
Mainframes Technology - COBOL, CICS, JCL, DB2, IMF
TECHNICAL SKILLS
- 
- Manual Testing- Functional (Black Box Testing) and Regression testing
- Data Warehouse Testing- Manual
- Quality Center tool(QC)
- SQL Server Management Studio (SSMS)
- Good knowledge of SQL queries
- SQL SERVER , RDBMS Core , RDBMS Essentials
- Mainframes Technology- COBOL, CICS, JCL, DB2, IMF
- C, C#, .Net(ASP.Net, ADO.Net), Core Java
- MS-Word, MS-Excel
PROJECT DETAILS 
[B]Manual Testing project details [/B]:-
1. ATLAS - Atlas stands for Allstate Total Life Administration System. Atlas is currently used for policy admin, contract admin, billing and collection etc.
 4 projects and 3 tickets were handled individually in ATLAS team.
 [B]Role [/B]: Test Engineer
 [B]Technology Involved [/B]: Mainframe Application
 [B]Team Size [/B]: 3 Offshore and 1 Onsite
 [B]Responsibility [/B]:
- Study of the requirements and accordingly preparation of the deliverables.
- Test Effort Estimation, Milestone Preparation
- Test Strategy preparation for projects.
- Preparation of Test Scenarios and Test Cases.
- Preparation of the System Test Plan and Review of Test Plan to avoid any defects.
- Execution of the Test Cases for System Testing and Regression Testing.
- Updating the Results in QC and logging defects in QC i.e. Defect Management.
 [B]Duration [/B]: 8 months
 
 [B]Following is the description of the projects and tickets undertaken [/B]:-
- Allstate Project(PMT 15065 DC,RECOVR)
 [B]Description [/B]: Retrieval of archive records and UL audit request work together to create a UL Audit
 for full history of an archived policy in ATLAS system.
- Citrix Server Testing of Mainframe Applications
- Allstate ticket(PM 2407 7-Pay Test)
 [B]Description [/B]: When a material change occurs within the final 7 years of a policy, the 7-Pay 
 limit tax calculation does not fail in ATLAS system.
- Allstate project(PMT 15479 Life Loan Interest Notification)
 [B]Description [/B]: Communication to customer of interest rate when loan is taken.
 
- Allstate ticket(PM 6391 Billing Mode change)
 [B]Description [/B]: Billing mode change has occurred successfully for different policies in Atlas 
 System.
 
- Allstate ticket (PM 6659 Truncated Waiver of Premium)
 [B]Description [/B]: Report is generated successfully containing all those policies having truncated 
 waiver of premium in 04 Trailer in ATLAS system.
 
- Allstate project(PMT 16269- Annual Statements on Atlas)
 [B]Description [/B]: Scanner payment date is processed correctly on the same day when the 
 premium payment has been made actually in ATLAS system.
 
- Allstate project(PMT 15453- Life Reinstatements (Phase 1) )
 
[B]Description [/B]: 3rd billing notice is not generated 35 days after the premium due date and lapse letter is send to the owner/ assignee 31 days after the premium due date if payment is not received.
2. WELLPOINT - is the largest health plan company in the Blue Cross and Blue Shield 
 Association.
 [B]Role [/B]: Test Engineer
 [B]Technology Involved [/B]: Java Application (Web based Application)
 [B]Team Size [/B]: 9 Offshore and 1 Onsite
 [B]Responsibility [/B]:
- Test Scenarios and Test Cases Preparation
- Execution of Test Cases for System Testing and Regression Testing- Manual process.
 [B]Duration [/B]: 1.5 months
[B]Data Warehouse Testing project details [/B]:-
3. MERCURY- Mercury is a financial reporting application and data warehouse containing all 
 allocated General Ledger data for Microsoft’s internal and external reporting. With summary 
 Cost and Purchase Order data, drill down level detail, an enhanced user interface, and increased 
 reporting capabilities, Mercury provides its users with a single data source for their reporting
 needs. Mercury is now the official financial reporting system of record replacing the now 
 retired MARS system. All the products used for testing are Microsoft software and products.
 Role: Test Engineer
 Technology Involved: SQL queries
 Team Size: 3 Offshore and 1 Onsite
 Responsibility:
- Verification of data flow after ETL process at various stages of Mercury Server Topology.
- Study Functional Specification document (FS) and Business Requirement document (BRS).
- Preparation of Test Scenarios and Test Conditions.
- Preparation of the System Test Plan and Review of Test Plan to avoid any defects.
- Execution of the Test Cases for System Testing and Regression Testing.
- Using VSTF (Visual Studio Team Foundation) for holding TCS and project data.
- Using MTM (Microsoft Test Manager) for executing Test Cases.
- Database Back Up and Restore.
- Using MSRA (Microsoft Reporting Analytics) for generating financial reports.
- Applying build on servers.
- Troubleshooting activities
 Duration: 8 months
 Following are the projects undertaken:-
- Mercury Gregorian Calendar Changes- Aligning of all the Mercury calendars according to Gregorian format.
- Rainier Forecast Changes Set B- (inbound data from Forecast Factory into Mercury)
- PFAM (Product Family)
 
- 
- 
- 
 
EDUCATION
 
- B.E. in Electronics and Communication (E.C.E.) 2005-2009 
 Manav Rachna College of Engineering, Faridabad under Maharishi 
 Dayanand University (M.D.U.)
 Scored: 71.78%
- 12th from S.S Mota Singh Sr. Sec. Model School, Delhi Passed in 2004
 C.B.S.E. Board
 Scored: 68%
- 10th from S.S Mota Singh Sr. Sec. Model School, Delhi Passed in 2002
 C.B.S.E. Board
 Scored: 80% 
- MCP (Microsoft Certified Professional) in C# in 2009
- MCTS (Microsoft Certified Technologist Specialist) in SQL Server in 2009
CERTIFICATIONS
- Certification in French language course from Bharani Academy
- Certification in Mobile repairing (secured Grade A) from Achiever’s Call Net 
- Paper presentation on Biometrics achieving 3rd rank in College
- Stood first in Mega seminar held in Achiever’s Call Net
TRAINING
 
- Two months of training in Mahanagar Telephone Nigam Limited (MTNL) in Delhi
- 3 months of training in Sql Server, C#, .Net from NIIT
- Two months of training in Core Java language from Global Net Education Centre
 
PROJECT WORK AT COLLEGE
- Worked on ‘Teach India’ initiative project and made ‘Teach India’ software.
- ‘Automatic Temperature Controller’ Circuit –used in iron to control its temperature when over heated.
- ‘Bluetooth Operated Manless Electronic Vehicle’ project in final semester of college. 
EXTRA-CURRICULAR ACTIVITY
- Stood first in Inter College Cultural & Technical Fest in Fashion-Parade in 2008
- Participated in 40th Delhi State Summer Open Table Tennis Tournament
- Participated in 17th Inter School Inter Club Table Tennis Tournament
- Participated in stag 63rd Delhi State Table Tennis Championship
- Participated in T.T. Ltd 43rd Summer Open Table Tennis Tournament
INTEREST
- Table tennis, Swimming, Driving, Cooking, Dancing, Watching movies
 
 I do hereby declare that the particulars of information and facts stated here in above are true, 
 correct and complete to the best of my knowledge and belief.
 
 TARANPREET KAUR
 29-June-2011
-------------------------------------------------------
More Information about this submission and submitter:-
___________________________________________________
Submission ID : 4335876
Date & Time : 6th Jul 2011 5:54 AM (UTC)
IP Address : 207.46.55.29
Browser Info : Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)
Predicted Country : United States[/QUOTE]

All times are GMT +5.5. The time now is 10:45 PM.