ETL testing

Nalini T

EMail:***************@*****.***

Mobile: +91-988*-**-****

Summary:

> Having 7+ years of experience in IT industry on server side application

development using Java/J2ee, Oracle B2B and Integration/Middleware

technologies in that over 3+ years of experience in ETL/DWH & Manual

Testing

> Good exposure to Data Warehousing concepts.

> Hands on experience in writing and executing SQL queries

> Has testing experience in Informatica power center

> Intensively involved in STLC, SDLC, Test Methodologies & Defect Life

Cycle.

> Having good experience of Build and deployment in both Jboss and

Weblogic environments.

> Having good experience in web services testing using SOAPUI.

> Extensive experience in Execution of Test cases.

> Reviewed Test cases and prepared Test Case Review Report.

> Experience in Functional Testing, Regression testing, User Interface

and system testing.

> Good experience in Defect Tracking and Reporting.

> Good knowledge in web services testing using SOAPUI tool.

> Very strong in Web technologies like Java, Servlets, JSP, Java Beans.

> Sound knowledge in using Struts Frame work and JMS

> Excellent problem solving, analytical, interpersonal and communication

skills. Ability to work in-groups as well as independently with minimal

supervision.

> Exceptional ability to quickly master new concepts, languages and

Tools.

> Proven ability to work efficiently in both independent and team work

environments.

> Basic Knowledge in TIBCO Business Works.

Professional Certification:

> Certified in BEA WebLogic 8.1(Integration Solutions) from BEA Systems

Inc.

Educational Qualification:

> MCA (Master of Computer Applications), From JNT University.

Professional Experience:

> Working as IT Engineer for Hewlett Packard Technologies, Bangalore from

Jan'11 to till date.

> Worked as Senior Software Engineer for Wipro Technologies, Bangalore

from June'10 to Jan '11.

> Worked as Technical Associate for TechMahindra Ltd, Bangalore from

Oct'06 to May '10.

Achievements:

> Received COOKIE award as a token of appreciation for significant

contribution for the R900 release.

Technical Skills:

Testing : ETL/DWH testing & Manual

testing

ETL Tools : Informatica Power Center

9.x,8.x/7.x

Operating Systems : Windows 7/8/98/NT/XP and UNIX

Languages : JAVA, J2EE,C,C++

Web Technologies : JSF, JSP, Servlets, XML, JavaScript

EAI Tools : BEA WLI 8.1, BEA ALSB3.0, Tibco BW, IBM portal server

DBMS : Oracle 9i, 10g

Frameworks : Spring,Hibernate, Struts

IDEs : Eclipse,RAD

Web /Application Servers : BEA WebLogic 8.1,Tomcat5.0,Jboss5.1

Other Tools : XML SPY, TOAD, SQL developer, JUnit, SVN,

StarTeam2005, SOAPUI

Project Experience:

Project#1

Title : HHO (HP Home & Home Office Store)

Client : HP, USA

Duration : March' 12 to Till date

Environment : Informatica 9.5, Oracle 10g

HHO is a direct (online) channel for HP's consumer products in US. HHO

supports direct online ordering via main website www.shopping.hp.com and

telephone ordering through (toll free number 1-888-***-****) TSR/Agents and

the site is called TOMI or call center site.

It uses 2 fulfillment models,

Consignment model for Stock to Order (STO) products

Procurement model for Customize to Order (CTO) products

Payment methods are categorized as primary and secondary. Primary payment

methods will be Credit Card, Efinance and PayPal. Secondary payment methods

will be Gift Cards.

Roles and Responsibilities:

> Understanding the requirements and scope of the system.

> Running the jobs/workflow for ETL process.

> Prepared and ran sql queries to verify dimension table and fact

tables.

> Verifying the data in target database after ETL process

> Performed column data mapping between source and target database.

> Involved in preparing test data and test cases.

> Verifying the data which is loaded into target database.

> Interaction with BA & dev teams to solve the issues.

> Developed, Reviewed & Executed Test Scripts and Designed test data

> Identified Test Scripts for Regression testing

> Defect Analyzing and Reporting in ALM.

Project # 2:

Title : Shopko Enterprise Data Warehouse

Client : Shopko Stored Inc.USA

Duration : Jan '11 to Feb '12

Environment : Informatica 8.6, Oracle 10g

Shopko is a well know retail and wholesale company in Green Bay. It is

a merchandiser of selling goods like cloths, jewelry, shoes, furniture,

electronics, etc. Providing services through a network of franchise

dealers, online, phone, direct sales and sales persons.

The main aim of this data warehouse is to help the senior and middle level

management of the organization to improve the sales and get the knowledge

of the new business opportunities.

Roles and Responsibilities:

> Involved in functional study of the application

> Running the jobs/workflow for ETL process.

> Prepared and ran sql queries to verify dimension table and fact

tables.

> Verifying the data in target database after ETL process

> Performed column data mapping between source and target database.

> Involved in preparing test data and test cases.

> Verifying the data which is loaded into target database.

> Interaction with BA & dev teams to solve the issues.

> Developed, Reviewed & Executed Test Scripts and Designed test data

> Identified Test Scripts for Regression testing

> Defect Analyzing and Reporting in ALM.

Project # 3:

Title : Cobb County

Client : Cobb County, US.

Duration : June '10 to Dec '10

Environment : IBM Portal Server, Java, J2EE, Oracle 10g, Lotus Content

Management system, RAD

Portlets and Windows XP.

Cobb County is a Government body for collection of property tax in GA, US.

It has got two websites for assessing the property tax and for collection

of property tax. These websites have been developed very long ago. The

current features on these websites look obsolete and lack the benefits

given by the modern technology. Cobb County would now like to move to a new

state of the art platform, as the current technology platform is very old,

screens are not user friendly, and to gain better control and support for

the web-sites.

Roles and Responsibilities:

> Involved in implementation of portlets using RAD.

> Involved in creating content and components using WCM.

> Involved in implementation of design documents like LLD.

> Involved in implementation of POC work using portlets.

Project # 4:

Title : Andes B2B AD

Client : British Telecommunications, UK.

Duration : Sep 09 to May 10

Environment : WLI8.1, Java, J2EE,Oracle B2B,XML,XSD's,Weblogic Workshop,DB

Visualizer,XML spy,

and Windows XP. Sun Solaris

ANDES is a BTGS program that focuses on the migration/reduction of the

existing 700+ systems to an 170+ count. As part of the ANDES Transition

program, Integration Infrastructure platform has planned to migrate the

existing legacy gateway systems in to the BT GS B2B Strategic gateway.

Roles and Responsibilities:

> Involved in implementation of JPD's using WLI.

> Brainstorm on the architecture of the current and proposed

systems

> Involved in doing configurations for Oracle B2B server and

weblogic servers as well as installing the software.

> Configuration of jms queues and connection factories /data sources

using BEA weblogic server console.

> Developing Action Plans for request and response using XQueries.

> Involved in creating stubs for request and response.

> Involved in implementation of Test cases.

> Involved in Unit Testing and ADE box Testing.

Project # 5:

Title : Service Fulfilment (SFF)

Client : AIS Telecom, Bangkok

Duration : Jan 09 to Aug 09

Environment : WLI10.2,ALSB3.0,Java,J2EE,Soap,Oracle,XML,XSD's,Weblogic

Workshop,XML spy,

MSVisio, Spring,Hibernate,JSF and Windows XP. Sun

Solaris

AIS Thailand is the largest mobile operator company providing a full range

of communications services over fixed, mobile and Internet platforms .AIS

has embarked on creating a Service fulfillment framework that would create

a channel for increasing Sales and revenue and likewise handle the

transactions generating out of the channel sales. This would enable AIS to

provide a view of their products and order products and full suite of

services via SFF and allow customers to purchase, upgrade their services

with automated provisioning.

Roles and Responsibilities:

> Involved in implementation of JPD's using WLI.

> Involved in the implementation of JSF screens.

> Involved in implementation of proxies and business services

using Aqua logic service bus.

> Involved writing xqueries, xslt transformations, wsdl exposure

and message flows in ALSB.

> Configuration of jms queues and connection factories /data sources

using BEA weblogic server console.

> Communicated with onsite team for status update.

Project # 6:

Title : E537 Gateway

Client : British Telecommunications, UK.

Duration : June' 08 to Nov' 08

Environment : Java, XML, Oracle B2B, TOAD,Weblogic 8.1, and WindowsXP

Migration of existing gateway to the strategic gateway.E537 Strategic B2B

Gateway will act as a trading partner to communicate with suppliers. E537

Strategic B2B Gateway server at present handles 6 messages per second.

Testing the functionality of handling high volumes and providing the main

functionality of the gateway from the trading partner side.

There will be a single instance of B2B Gateway shared

between OR and RoBT.B2B Gateway is a new component in Phase 2 Architecture.

It will replace existing B2B Southside Gateway. It will interface will all

the Red Side Suppliers on one end and TIBCO Business Works at the other

end.TIBCO Business Works will route all the e537 Messages related to the

Red Side Suppliers (depending on Contract Code) to Oracle B2B Gateway.

Roles and Responsibilities:

> Testing the functional and non-functional capabilities of the product.

> Modification of WLI code to make it work with Oracle integration B2B.

> Functional testing of BTW gateway with changed WLI code and Oracle

B2B.

> Performance testing of the gateway. Testing will be to prove

capability of Oracle on Linux and not be comparative with Cyclone.

Project # 7:

Title : B2B-Gateway Open Reach

Client : British Telecommunications, UK.

Duration : Jan' 07 to May '08

Environment : Java, XML, TOAD, Cyclone5.5, Weblogic 8.1, and WindowsXP

Open Reach Gateway is an EAI application. This is a business to business

application which was implemented for British Telecom. OpenReach has

established an equivalence management program to migrate support for

existing LLU & WLR3 products from the current systems to a new

industrialized stack that will utilize additional infrastructure

improvements and will ultimately bring the SMPF & MPF product lines

together with other Openreach product offerings onto a single platform.

OR B2B is the trading gateway through which all regulated products are

ordered and managed. CPs will send XML files to the B2B gateway over HTTPS.

B2B will ensure that the XML files are being received from a known CP and

then following basic validations on the XML files, will pass them on to the

EAI Hub. As the order progresses, KCIs are feed back via the same gateway.

Roles and Responsibilities:

> Involved in creating of Action plans and stubs by using XML.

> Involved in creation and Weblogic Configuration domain.

> Involved in Unit Testing.

> Involved in Build and Deployment of Applications.

> Involved in bug fixing and all the support activities necessary.

> Writing data base operations for updating and retrieving data.

Contact this candidate