SUMMARY

• 7 years of Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Extensive testing ETL experience using & Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• 6 years of strong data base experience in Oracle, SQL Server 2000/2005, IBM DB2 and Sybase.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Expertise in ETL BACKEND TESTING
• Expert in UNIX Shell Scripting.
• Experience in Calc Scripts, Load Rules and Report scripts.
• Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
• Expertise in handling Onsite-Offshore model, client handling and continues business process
• Did extensive Front-End Web Testing using QTP and Quality Center.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Provided Application testing and white box testing for the Accounts Reconcilement legacy mainframe (HOGAN) application
• Extensive knowledge and work experience in COBOL 74, VS COBOL-II, CICS, DB2, JCL, VSAM
• Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
• Performed Unit, Integration and System Testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Designed data models using Erwin.
• Experience in developing various OLAP Models & Meta-Outlines using Essbase Integration Services (EIS) and generated scripts to automate building outlines in Essbase.
• Experience in Calc Scripts, Load Rules and Report scripts.
• Strong Knowledge of relational database design.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Solid time management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved
• Excellent written and oral communication skills and a team-player with a results-oriented attitude

Education: Bachelor's Of Technology in Electronics & communication(JNTU, Hyderabad, INDIA)-2003.

Technical Skills:

Hardware Pentium 4, IBM AS/400 Mid Range machine
Operating Systems Windows XP, Window 2000, MS-Dos, OS/400, UNIX
Languages & Software Java2.0, C, COBOL 400, RPG 400, CL 400, SQL, J2EE, EJB
1x, 2.0, Applets, Servlets, HTML
Domains Banking, Financial, Brokerage, Telecom, Service Oriented
ETL Tools Informatica 8.1/7.1, Data Stage 8.0/7.0
Mainframe Tools TSO/ISPF, RACF, TCP/IP, REXX, CLIST, QMF, FILE-AID
Middleware Web Logic, IBM's Web Sphere, Java Web Server
Others MS Project, Visio, MS Office, MS Excel
BI Tools Business Objects 6i/XIR2 , Cognos 7.3,
Tools Erwin 3.5.2, PVCS, Rational Clear Case, TOAD, XML Spy, WinSQL
Databases Oracle 9i/10g, DB2 8.0, MS SQL Server 2000/2005, IBM DB2 and Sybase.

ETL/SQL/Backend Tester-EDWH

Wells Fargo Home Mortgage (WFHM) takes care of supporting Wells Fargo representatives in all branches in distributing home mortgages to customers across United States. The CORE ODS (Operational Data Store) is used to acquire, prepare and deliver data which was generated within the CORE on-line applications. The COD database (Consolidated Originations Database) of OLTP system is the primary data source for the ODS. ODS is divided into various schema's like Raw, staging and static to ensure the proper cleansing and transformation of data to various downstream systems.

The CORE ODS delivers data primarily to the LIS (Loan Information System) from which the data is delivered to the various downstream systems including operational, reporting and analytical. We analyzed and performed ETL (Extraction, Transformation and load) operations on the ODS data of various subject areas like the RESPA Fee, Escrowing, Closing, Property, Landlord, Income, Asset, Employment, and Underwriter etc of the borrower into the LIS system.

Responsibilities:

• Interacted with clients to determine User requirements and goals.
• Participated in analysis of Business and functional requirements
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases , Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for this application.
• Extensively used SQL queries to check storage and accuracy of data in database table
• Performed basic testing of security features using manual testing
• Responsible for creating Test Strategy for the Data Warehouse
• Involved in creating the design and technical specifications for the ETL process of the project.
• Worked on trimming the SQL and optimizing the SQL by using various VLDB settings in the MSTR to avoid the cross join and removing multiple passes.
• Worked on InformaticaPower Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Used Erwin to reverse engineer the existing database design in SQL Server 2000
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for application.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2000/2005
• Extensive user of Clear Quest for defect tracking, process automation, reporting and lifecycle traceability for better visibility and control of the SDLC
• Strong Windows operating-system background, with understanding of the key drivers and influences on performance
• Developed SQL Stored Procedures and Queries for Back end testing.
• Involved in automation of test cases using QTP.
• Reported bugs and tracked defects using Rational Clear Quest.
• Tested web forms from test to production using Export and Import.
• Tested various business rule and data load rule files.
• Involved in the production support team for planning cycle after production implementation.Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the Oracle database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Extensively used Informatica power center for extraction, transformation and loading process
• Created and maintained test scripts in Rational Clear Quest and co-ordinate with the ETL group and other developers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Involved in offshore and onsite Coordination activities
• Synchronized the dimensions of development planning with production planning
• Troubleshooting the planning web forms with user testing
• Involved in integration/system testing and backup/restore testing for all components
• Involved in the production support team for planning cycle after production implementation.

Environment: Informatica Power Center 8.5, (Power Center/ Power Mart,) Rational Clear Quest, VB Script, Erwin 4.0, SQL Server2000/2005, SQL Plus, Business Objects 6i/XIR2,SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, Shell Scripting,

DWH/ETL Test Engineer

Credit Suisse (CS) entered into an agreement to purchase from Fortis Bank Nederland (FBN) its Prime Fund Solutions (PFS) business, a global leader in hedge fund administration services. The high level business and IT strategy is to fully integrate PFS into CS applications, processes and shared services infrastructure at the back-end. Project Avenir is a bank wide project, and seeks to achieve full separation of the PFS business from FBN and result in at end-state which is aligned to CS target systems, processes and operating model. Therefore, this project from a CS Finance perspective is a full, automated integration of the PFS business which is maintained in a system called T24 into existing CS Finance architecture and helps CS to outline how Finance processing and reporting of trade data will be delivered in relation to Financial Reporting.

Responsibilities:

• Implement the strategic plan for support of future company information requirements.
• Involved in predefining data mapping from ETL & BI to the relational source, and running ad-hoc queries for providing optimized reports.
• Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Worked with Agile Methodology
• Involved in the Meetings scheduled in order to discuss the documented Defects logged by the testing team using Clear Quest.
• Migrated objects from SQL Server 2000 to SQL Server 2005
• Fully documented and replicated defects for Developers, enabling them to fix Defects faster and meet Production Deadlines.
• Particpated in load testing exercises and tested dashboards and assisted development team with testing activities.
• Tested cognos reports for verifying and validating the data.
• Tested several complex reports generated by Cognos including Dashboard, Summary
• Did front-end testing and functional testing using Quick Test Pro.
• Used Quality Center for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• SQLs are written using QMF to query the DB2 database on mainframe
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Validated the data after running the batch process from different Mainframe systems
• Provided technical guidance and support to end-users by developing the documentation required.
• Worked on Excel Add-in Tools to generate various reports to analyze the business
• Created users, user groups in the Planning application for accessing the various application elements.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in Front to Back testing for all European and Asia pacific and North Atlantic exchanges
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.

Environment: Informatica 7.1 SQL Server2000/2005, Cognos 7.3,Mainframe OS/390, TSO/ISPF, JCL/PROC's, COBOL MVS Quality Center 8.2, Oracle 9i/8i, XML, XSLT, Rational Clear Quest, Clear Case, Agile, Quick Test Pro 9.0, UNIX Shell Scripting, UNIX, IBM AIX 5.3, Windows 2003, SQL, PL/SQL, TOAD,

ETL/Web Tester

Confidential, is the world\'s leading provider of financial services to institutional investors. It provides core investment custody, fund or investment/securities accounting, fund administration, securities finance and transfer agent services to insitutional clients. Its broad and integrated range of services spans the entire investment spectrum, including research, investment management, trading services and investment servicing. State Street also provides "middle office" services such as trading operations and a California affiliate provides reconciliation services to investment banks with the help of Syntel. State Street Syntel Sourcing Private Limited (SSSPL) is a joint venture entity that executes reconciliation for investment banks worldwide.

Responsibilities:

• Member of the warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Extensively used Informatica power center for ETL process.
• Preparation of ETL mapping specifications.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Designed mappings for dimensions and facts.
• Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
• Development of mappings as per the technical specifications approved by the client.
• Created reusable transformations and mapplets to use in multiple mappings.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Did lot of Web Testing using Quick Test Pro..
• Involved in Unit testing and integration testing of Informatica mappings.
• Implemented Error handling logic to capture the invalid data.
• Created sessions and workflows to run with the logic embedded in the mappings using Power center Designer.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Creating the catalogs and analyzing the joins.
• Maintained various versions of the documents generated during the project using Rational Clear Case
• Logged bugs that would enhance the usability of the application using Rational Clear Quest
• Designed and implemented basic SQL queries for QA testing and report/ data validation
• Assisted the QA team in designing the test plan and test cases. Performed User Acceptance Testing

Environment: Informatica Power Center 6.2 (Power Center Designer, workflow manager, workflow monitor, QTP, VB Script, SAS/SQL, SAS/ETL, UNIX, Korn, SQL, PL/SQL, Shell Scripting, Oracle8, SQL Server 2000, Windows 2000. UNIX Shell Scripting UML, RUP

ETL Engineer

This application is developed for Citigroup is the leader in global banking services and is the global franchise of Citibank Global Consumer group. Citigroup is the first financial services company in the United States to bring together banking, insurance and investments under one umbrella. Citibank focuses on technological innovation, seamlessly delivering value to customers across multiple-platforms.

Responsibilities:

• Worked with the Center Business Management Team to support the Service and Sales departments with daily, cyclical and monthly reports.
• Responsible for validating the ETL process of loading data from the source systems correctly into the target system.
• Involved in validating the ETL mappings from various systems(CRM,OLTP) to transaction history/reporting database
• Involved in system testing, data integrity testing and ETL testing.
• Written and implemented System level Test plan, test cases and test scripts.
• Responsible for data validations for initials/re-load and delta/incremental loads.
• Involved in validating the Informatica mappings from OLTP servers/databases into the staging tables using reporting platform to new management personnel.
• Involved in Data modeling, normalization, de-normalization, physical database design and relational models, database procedures, functions, packages and triggers for enforcing the business rules using PL/SQL.
• Expertise in Understanding the complete information flow, database objects creation, normalization.

Environment: Informatica 6.2/5.1, Toad, SQL, Test Director, Shell Scripting, Sun Solaris 5.8, PL/SQL, Windows NT 4.0, Erwin, Test Cases, Test Plan, Test Scripts, Stored Procedures, IBM AIX 5.0, Oracle 8i.