www.lexmark.com International India Pvt Ltd Kolkata : ETL Architecture

[Admin]

Lexmark International (India) Private Limited
http://www.lexmark.com

Keywords: ETL Architect

Designation: ETL Architecture
Experience: 5 - 7 Years
Location: Kolkata
Compensation:
Rupees 5,00,000 - 7,00,000
Education:
UG - Any Graduate - Any Specialization
PG - Any PG Course - Any Specialization
Industry Type:
IT-Software/ Software Services
Functional Area:
Architecture, Interior Design
Posted Date: 01 Oct 2008

Job Description
Senior level ETL architect to drive and improve ETL standards, business/technical rule requirements, source-to-target mapping process, own ETL architecture, develop/communicate ETL strategy, manage consolidation/performance tuning efforts etc.

Desired Candidate Profile
5-7 years experience in DataStage 7.5 or higher ETL suite (DataStage, MetaStage, Parallel Extender, Quality Manager, etc.), monitoring/tuning/performance management.
3-5 years experience with design, management, monitoring etc.

Company Profile
Lexmark reported $5.0 billion in revenue in 2007. Revenue derived from international sales and exports from the U.S. make up about half of the company's consolidated revenue, with Europe accounting for approximately two-thirds of international sales.

Executive Name: Sutapa Das

Address:
Not Mentioned

Email Address: feedback@eskillport.com

Telephone: 03324292345

[Guest-IJT]

Name : Taranpreet Kaur Farmaha
Email : Taranpreet_Farmaha AT yahoo.in
Designation / Skillset : Test Engineer
Taranpreet- Test Engineer, Infosys

Resume :
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.
- Stream Training :-
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
Manual Testing project details :-
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.
Role : Test Engineer
Technology Involved : Mainframe Application
Team Size : 3 Offshore and 1 Onsite
Responsibility :
- 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.
Duration : 8 months

Following is the description of the projects and tickets undertaken :-
- Allstate Project(PMT 15065 DC,RECOVR)
Description : 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)
Description : 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)
Description : Communication to customer of interest rate when loan is taken.

- Allstate ticket(PM 6391 Billing Mode change)
Description : Billing mode change has occurred successfully for different policies in Atlas
System.

- Allstate ticket (PM 6659 Truncated Waiver of Premium)
Description : 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)
Description : 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) )

Description : 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.
Role : Test Engineer
Technology Involved : Java Application (Web based Application)
Team Size : 9 Offshore and 1 Onsite
Responsibility :
- Test Scenarios and Test Cases Preparation
- Execution of Test Cases for System Testing and Regression Testing- Manual process.
Duration : 1.5 months
Data Warehouse Testing project details :-
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