Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Alina
ETL/Backend Tester
|
Email:
alina@gmail.com
|
·
Over
7 years
of experience in end to end development of software applications using Data
Warehouse methodology in various phases of IT
projects such as System Analysis, Design, Coding and Testing. Extensive
experience in the implementation of Data Warehouse/ Data marts for business
applications with Financial, Insurance, Manufacturing, Energy, Telecom etc.
·
6+
years
of strong QA (Testing) and Data Warehousing experience in building and managing
various Data Warehousing / Data marts using Informatica products such as Informatica
PowerCenter 8.6,7.1/7.0/6.1/6.2.1/5.1/4.7, PowerMart 6.2/5.1/4.7, PowerConnect,
PowerAnalyzer, and Power Exchange tools.
·
4+
years
of experience in RDBMS technologies like Oracle 8x/9x, DB2
8.0/7.0/6.0, Teradata V2R5/V2R4/V2R3, MS SQL Server 2000/7.0/6.5, Dbase, Excel and
MYSQL. SQL Developer, TOAD, Quest Central for DB2.
·
Strong experience in XML, XSLT, XPath and XML Spy.
·
Extensive
experience in writing SQL and PL/SQL scripts to validate the database systems
and for backend database testing.
·
Experience
in using Automation Tools: Quick Test Professional, Win Runner
and Quality Center in Client/Server
·
Proficient
in working with Rule Files to build Dynamic Dimensions, add Attribute
Dimensions, modify existing Dimensions and Members, and Load Data dynamically.
·
Good
understanding of Design, modify and build BSO/ASO cubes and assign
member properties to them.
·
Experience
in Mercury Quality Center - Design Test Steps, Requirement Mapping to
Tests, Executing Tests Manually, Defect Logging, Defect Reportin
·
4+
Years
of experience in Relational modeling and Dimensional modeling (Star schema and
Snowflake schema with FACT & Dimensions tables using Kimball and Inmon
methodologies) and experience in logical and physical data modeling with Erwin
4.5/4.0/3.5.5/3.5.2, MS Visio.
·
Extensively
used SQL, PL/SQL to create complex queries, SQL override, Stored
Procedures, Triggers, CA Autosys, and BMC Control M and
Maestro.
·
Worked
on various Operating Systems which include Windows 95/98/2000/NT/XP and
Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i
v1.5/1.6/2.0).
Education:
Tools & Skill set.
|
ETL Tools
|
Informatica PowerCenter 7.1/7.0
(Repository Manager, Designer, Workflow Manager)/6.2(Source Analyzer,
warehouse designer, Mapping Designer, Workflow Manager. Repository manager
administration)/5.1/4.7(Source Analyzer, Data Warehousing Designer, Mapping
Designer, Mapplet Designer, Transformation developer), PowerMart
6.2/5.1/4.7/1.7
|
|
Testing Tools
|
QTP 8.2, WinRunner 8x, Test Director,
Quality Center, Load Runner 7x
|
|
Databases
|
Oracle 9i/8i/7.3, MS SQL Server
2000/7.0/6.5, IBM DB2 UDB 8.0/7.0/6.0/5.0, DB2/400, Sybase, Teradata
V2R5/V2R4, Sunopsis, MS-Access and MYSQL.
|
|
Job Scheduling
|
CA Autosys, BMC Control M, Maestro.
|
|
OLAP Tools
|
,Business Objects
XIR2/6.5.1/6.0/5.1.x/4.0Cognos 7.3 Series
|
|
Operating System
|
UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX
11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux (RedHat),MS-DOS
|
|
Languages/
Utilities
|
SQL, PL/SQL, SQL Developer, TOAD,
XMLSpy, Quest Central for DB2,UNIX shell scripts (Cron, C), Java, Servlets,
XML, HTML, DHTML, C/C++, Visual Basic
|
|
Web Technologies:
|
XML, XSL, X
L, HTML, CSS,
JavaScript, VBScript
|
Professional Experience
Citigroup,
NJ
Mar10
-
Present
DWH/ Quality Assurance Tester
One of the largest financial services
in the world, Citigroup is a pre-eminent financial services company in more
than hundred countries is organized into three major business groups – Global
Consumer, Corporate and Investment Banking, and Global Wealth. Project involved
developing a reporting service using Essbase server to analyze the expenses
incurred on Legal services based on different region/division. The data is
obtained from disparate sources like flat files, oracle, and general ledger and
Sql Sever tables.
Responsibilities:
·
Experienced
in writing test cases, test scripts, test plans and execution of test cases
reporting and documenting the test results using Mercury Quality Center
·
Involved
in automation of test cases using QTP.
·
Used
QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple
applications.
·
Performed
the Back-end Integration Testing to ensure data consistency on front-end by
writing and executing SQL statements
·
Load
new or modified data into back-end Oracle database
·
Worked
with QTP for Regression Testing
·
Developed
ETL Test Plan and Test Strategies for the entire Line of businesses.
·
Extensively
used SQL queries for Database testing and Validation.
·
Involved
in extensive backend testing.
·
Worked
on Informatica Power Center tool - Source Analyzer, Data
warehousing designer, Mapping & Mapplet Designer and Transformation.
·
Solid
Back End Testing experience by writing and executing SQL Queries Responsible
for testing Business Reports developed by Business Objects XIR2.
·
The
reports that were created in Business Objects were testing by running
the SQL statements
·
Tested
PL/SQL statements to verify the output and compared against ETL Output.
·
Designed
and developed Test Plans and Test Cases and executed them.
·
Developed
Test Cases for testing the mapping designs before going to the production
phase.
·
Written
several UNIX Shell Scripts for cleanup, logging, file manipulation and
transferring the files.
·
Involved
in functional testing the Web application using Quick Test Pro.
·
Used
Rational ClearQuest the defect tracking tool for retesting the CQ’s and
creating the new issues using the CITRIX as webInterface
·
Extensively
used Informatica power center for extraction, transformation and loading
process.
·
Worked
with Teradata SQL Assistant for data retrieval.
·
Vigorously
worked on Manual Testing by writing the Test Cases and executing the Test
Scripts for various scenarios.
·
Execution
of QTP Script for automation testing, analyzing the automation result.
·
Involved
in all testing phases: Unit Testing, System Testing, Regression Testing,
Integration Testing, and Quality Assurance Testing.
·
Transformation of XML documents using XSLT.
·
Developed XML Schema and DTD using XML.
·
Modified the UNIX scripts for Testing purpose to check the
Rollback mechanism, Restatement window logic, wrapper scripts etc.
·
Involved in executing the UNIX shell scripts for loading the
data from the Source to the Datamarts.
·
Tested the data and data integrity among various sources and
targets.
·
Involved in Front-end testing for the Application.
Environment: Informatica
PowerCenter 7.1, Business Objects XIR2/6.5 ,
XML, XML Spy 2008, XSD, XPath, Oracle 10g, Flat Files, SQL, PL/SQL, SQL
* Loader, UNIX(Cygwin), TOAD 9.5, Teradata SQL Assistant 6.0, Teradata V2R6
(MLOAD, FLOAD, FEXPORT, TMPUMP, BTEQ), UNIX Shell Scripting, HP Quality Center
9.2, QTP9.2, VB .NET, Rational Clear Quest, Windows 2000, MQ Series, Citrix
8.0.
PNC
Financial Services, Pittsburgh, PA
Mar08 –
Feb10
ETL /BI Tester
PNC
Financial Services is a U.S.-based
financial services corporation,
with assets (as of December 31, 2008) of
approx. $291 billion. PNC operations include a regional banking franchise operating primarily in eight states and the District of
Columbia, specialized financial businesses
serving companies and government
entities, and leading asset management and processing businesses. PNC is America's 5th largest
bank by deposits and is the third largest bank off-premise ATM provider in the
country
Responsibilities:
·
Interacted
with the Business users to identify the process metrics and various keys
dimensions and measures.
·
Worked
on a Business Intelligence reporting system that was
primarily functioning on Oracle Applications OLTP environment with Business
Objects for Business Intelligence reporting
·
Well
exposed to Software Development Life Cycle and Test methodologies.
·
Extensively
involved in writing Test Plan, Test Cases, based on Business Requirement
Documents, Functional Requirement Specifications, and Design Specification
document generated and executed Test Scripts.
·
Extensively used SQL programming in backend and front-end
functions, procedures, packages to implement business rules and security
·
Experience
in ETL Data Warehousing, database testing using DataStage for Workflow process.
·
Developed
complex queries using different data providers in the same report.
·
Developed
test scripts using QTP for Functionality and Regression Testing
·
Tested
the reports using Business Objects functionalities like Queries, Slice
and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
·
Heavily
interacted with ETL team for testing data Quality and data Validation.
·
Written
several backend SQL queries and was involved in enhancing the performance by
tuning the SQL queries.
·
Was
involved in design part for Extracting data from different source systems into
the target database using Datastage Server 7.1.
·
Involved
in creating Test Matrix for various work streams for traceability purposes.
·
Involved
in writing Test cases for all the links and various data files based on ETL
Mapping document.
·
Wrote
test procedures for back end validation via functional specifications
·
Prepared
SQL scripts for test data preparation for Back End functionality testing
·
Performed
back up project management duties
·
Conducted
the Functional, System, Regression, and Performance testing of the Web
application using Mercury tools Quick Test Pro and LoadRunner.
·
Extensively
used PL/SQL queries to perform operations like joins in the databases
·
Worked
with several sources for understanding the business needs for performing both
positive and negative testing.
·
Transformed the XML documents into various form using XSLT.
·
Extensively involved in testing the XML files and checked whether
data is parsed and loaded to staging tables.
·
Executed
UNIX Shell Scripts for Batch Job Execution.
·
Written
several UNIX scripts for running test loads for regression testing purpose.
·
Responsible
for weekly status Reports, Performed functional, Integration, Regression
testing.
Environment:
Ascential
Data stage 7.1, DB2 9, Business Objects XIR2/6.5.1/6.0/,MS SQL Server 2000, QTP
,SQL, Win SQL Professional, XML, XML Spy 2008,
XSD, XPath, l, Novell client 4.91, IBM AIX 5.1, MS Visio 2003,MS Excel
2003, Lotus notes 6, PeopleSoft 8, Oracle10g, Erwin 4.0, Toad.
Credit Suisse, New York,
NY
Jan07–Feb08
QA /SQL Analyst
Credit
Suisse is a diversified financial services company advising clients in all
aspect of private and investment banking solutions. Project required
maintenance of multi-dimensional databases for its budgeting, sales
forecasting, marketing analysis and reporting using their Cognos and BI Tools
suite. Reports were delivered via the Excel Add-in and Cognos.
Responsibilities:
·
Worked
on Informatica PowerCenter – Source Analyzer, Data warehousing designer,
Mapping Designer & Mapplet, and Transformations.
·
Test
Automation using Mercury Winrunner, provided hands on mentoring in
architecting and building a fully Automated Testing Framework for regression
tests and repeatable system test cases.
·
Used
most of the Transformations such as the Source qualifier, Aggregators, lookups,
Filters & Sequence, Joiner, and Expression as per the Business requirement.
·
Creating
and running Sessions & Batches using Server Manager to load the data into
the Target Database.
·
Used
various checkpoints in the Informatica designer to check the data being transformed
·
Performed
User Acceptance Testing and Regression testing.
·
Created
Jobs to Schedule multiple reports in Cognos Connection.
·
Detailed
repeatable end to end test cases for application, interviewed developers to
gain detailed information on complex calculations and backend exception
processing in order to validate the back end utilizing SQL Plus
·
Involved
in Manual Testing, Functional testing (Black Box Testing), Regression and
Automated testing of the application using Mercury Interactive Test
Suite.
·
Organized
sessions in a batch to run the sessions in a batch in sequential order or start
them concurrently by the server.
·
Designed
process performance loading strategies. And also wrote the optimizing
techniques to improve the process loading time within the streamline using
Server Manager to load the data into the Target Database.
·
Involved
in the error checking and testing of the ETL procedures and programs Informatica
session log.
·
Moving
Data into Target using Sessions and Batches.
·
Developed
and involved in both Manual Testing and Automation Test scripts based on Use
cases developed.
·
Wrote
automated test scripts using WinRunner.
·
Involved
in implementation of the Test plans, Test cases and Test scripts
·
Involved
in system Integration testing (SIT), System Verification Testing (SVT) and User
Acceptance Testing (UAT).
·
Application
was updated twice a week, so that all the Test Procedures created as Baseline
can be played back to perform Regression Testing Reported and tracked bugs
using Mercury Test Director
·
Involved
in various testing phases like Unit Testing, Integration Testing, Validation Testing
and Performance Testing
·
Developed
test reports, which compare the sources and the desired targets.
Environment: Quality Center,
Informatica Power Center7.2/6.1,Cognos 7.3, Toad 7.0, Oracle 9.2, Sunopsis, MS
SQL Server 2000, IBM Mainframes, Mercury Interactive WinRunner ,DB2
8.1.8, COBOL II, XML 1.1, PL/SQL, SQL, SQL Plus, IBM), HTML, VB Script, Windows
2000
Komastu American
International, Rolling Meadows,
IL
Nov05 –Dec06
ETL QA Analyst
Komatsu
is the second-largest, fully-integrated manufacturer and supplier of
construction equipment in the world, from the smallest compact construction
size to the largest mining size. It has a network of manufacturing plants and
parts distribution centers in North America with approximately 2000 employees.
Komatsu integrated enterprise solutions across Hyperion Essbase and used
Hyperion Reports to generate analytical reports
Responsibilities:
·
Designer
for mappings and coding it using reusable mapplets using from various sources
involving flat files and DB2 tables.
·
Scheduling
the session’s tasks comprising of different mappings in order to load data into
DB2 database Tables.
·
Extracted
Data from Teradata using Informatica Power Center ETL and DTS Packages to the
target database including SQL Server and used the data for Reporting purposes
·
Involved
in installation and migration of Hyperion modules for better
performance.
·
Involved
in Regression and Automated testing of the application using Mercury
QTP
·
Worked
extensively with complex mappings using expressions, aggregators, filters,
lookup and procedures to develop and feed in Data Warehouse.
·
Major
involvement in tuning the mappings, to perform maximum efficiency and
performance complete knowledge of session properties in server manager.
·
Involved
in the error checking and testing of the ETL procedures and programs
Informatica session log.
·
UNIX
scripts were written at various situations like job scheduling etc. Wrote
different stored procedures for Pre-Load and Post-Load Jobs.
·
Coordinated
with QA Testing Team to test various test scenarios involving Test Plans, Test
Cases, and Test Scripts.
·
Transformation of XML documents using XSLT.
·
Worked with XML feeds from multiple sources systems and loaded the
same into Enterprise data warehouse
·
Involved
in Manual Testing of the application.
·
Involved
in Unit, Functional, Regression and System testing.
·
Extremely
involved in using Test Director for identifying the bugs with the help of SQL
queries.
Environment: Informatica Power
Center 6.1/6.2, Informatica Power Connect, MS Visio 2002, Oracle 8i/9i, Systems
MS SQL Server7/2000, IBM DB2/400, IBM AS/400, Teradata V2R5, MS Excel 97, Flat
files, PL/SQL, SQL, Toad 7.0, Windows 2000, MQ Series ,Transact-SQL,
SQL*Loader Mercury QTP, Windows 2000, HP-UX 11.x Unix (ksh) Shell
Radian Group Inc,
Philadelphia,
PA
Dec04 –Oct05
ETL QA Analyst
Radian is a leading provider of credit
enhancement for the global financial and capital markets. Project had Oracle
and flat files as sources and Oracle as the warehouse database. The modern
trends of data warehousing and relational database management were methodically
adopted for developing an efficient database. Hyperion analyzer was effectively
used on this database for reporting system. Equally validated and updated data
was available to the users, though restricted by their authorized access
levels.
Responsibilities:
·
Worked
on Informatica Power Center 6.1 tool (Workflow Monitor, Workflow Manger,
Mapping & Mapplet Designer and Transformation Developer) to transform data
mainly from DB2 and Flat Files and load that data to Oracle.
·
PL/SQL
queries were written to perform operations like joins in the source database.
·
Involved
in Unit, Functional, Regression and System testing.
·
Documented
and reported various bugs during Manual Testing.
·
Designed
and created various Test Plans, Test Cases and Test Scripts based on the
application requirements.
·
Analyze
business requirements (e.g., business logic, Process specs, process flows).
Developed test plans and test cases based on the business requirements.
·
Used
various SQL queries to validate the test case results for back-end test cases.
Written SQL Queries to define, Identify and validate the code written for the
data movement into the database tables.
·
Used
various regressions testing on front-end and back-end test cases. Performed
various load testing using Load Runner.
·
Designed
and developed Test Plans and Test Cases and executed them.
·
Documented
Defects found during test on the Test Director system and communicated,
recorded problems to the responsible QA or development personnel.
·
Interact
with analyst, system staff, business user and developers. Provide input and
documentation to System Level Test Plan and facilitated project deliverables
·
Development
of Unit Test Plans, Integrated and System test plans
·
Stored
data in the Data Warehouse about Customers, Accounts. The loads were scheduled
(Daily and weekly) depending on the frequency of source data.
·
Participated
in walkthrough and defect report meetings periodically.
Environment: Informatica Power
Mart 5.1, Oracle 8, MS SQL Server, IBM Mainframes, DB2, COBOL, XML, PL/SQL, SQL
Plus, SQL, Transact-SQL, SQL*Loader, , UNIX, QTP, Windows NT.
Patni
Computer Systems,
India
Jan03- Nov04
Role:
Oracle developer
Patni Computer
Systems is a leading provider of information technology services and business
solutions. Project involved creating packages, function and procedures and
implements them to various stages of software development life cycle.
·
Coordinated
with users to define and design needs, developed technical solutions ensuring
technical integrity.
·
Extensively
developed PL/SQL procedures, functions and
Packages.
·
Developed
database Triggers to enforce security.
·
Load
data into tables and schemas with the help of SQL * Loader Utility.
·
Created
views to resolve complex query.
·
Involved
in tuning SQL using Explain Plan.
·
Coordinated
with other team members in testing new implementation and bug fixing.
·
Prepared
user manual and technical support manual.
Download Resume Format
.JPG)
0 comments:
Post a Comment