SUMMARY

• Organized & efficient individual wif consistent record of achievements, Ability to deliver through people, leading improvement initiatives to business growth using decisive communication skills, global mind - set & exceeding client expectations.
• Solutions focused, meticulous and result-oriented Technocrat Professional wif experience in testing Data Warehouse, Database (ETL & BI), Web, Client-Server Systems & Applications for various Industries
• Proven expertise in writing test cases, test scripts, test plans and execution of test cases reporting and documenting teh test results using Mercury Quality Center
• Broad experience in defining Testing Methodologies; creating Test Plans & Test Cases, verifying and validating Application Software & Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Instrumental in Software Analysis, Planning, Design, Development, Testing, Maintenance & Augmentation for various applications in data warehousing, metadata repositories, data migration, data mining & Enterprise Business Intelligence
• Performed Business process Modeling and Entity Relationship diagrams as precursors to Workflow Development, re-engineering, functionality enhancements, migration to new technology and value-addition towards existing business solutions.
• Export through teh use of multiple ETL tools such as Ab Initio and Informatica PowerCenter
• Extensively used SQL and PL/SQL Procedures and Worked in both UNIX and Windows environment
• Written several complex SQL queries to validate teh data conditions as per teh mapping document

TECHNICAL SKILLS

Operating Systems: UNIX (AIX), Linux, MS-DOS, Windows vista / XP / 2000 / NT / 98 / 95

ETL Tools: Informatica, PowerCenter 8.6.1/8.1 / 7.1 / 6.2 / 5.1 , EME

Data Bases: Oracle 10g / 9i / 8i / 7.x, MainFrame via web3270, DB2 UDB, MS SQL Server 2008/2005/2000 / 7.0 , MS-Access, teradata v2r6

Development: SQL*Plus, T-SQL, PL/SQL 2.2 / 8.x, Unix Shell Scripting, Benthic Software Golden 5.7/ Goldview32/ ImpExp32, TOAD 7 / 7.6, SQL Loader, VBA

Workflow Tools: PuTTY, WinSCP3, MS-Project, MS-Excel, MS-PowerPoint, MS-Word

Management Tools: Peregrine ServiceCenter 5.1, HP Project and Portfolio Management Center (ITG) 7.1

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

BI Test Analyst

Environment: VBA, SQL, PL/SQL, Excel Pivot, Informatica, Oracle 10g/9i, MainFrame via Web3270, VSAM Files, Copy Books, Business Objects 4.1/5.1.5 /6. , DB2 UDB, WinSQL, UNIX (AIX), Linux, PuTTY, WinSCP3, Mercury Quality Center 9.0/8.0, Autosys, Teradata, TOAD, XML

Responsibilities:

• Reviewed Business Requirement Documents and Functional Specifications and formulated Test Plan from teh same
• Performed ETL testing based on ETL mapping document for data movement from source to target
• Performed backend testing for data validation using SQL Queries, validated data using SQL joins
• Performed Backend testing using SQL and UNIX commands; executed SQL statements to check if teh data integrity TEMPhas been maintained
• Analyzed business requirements, transformed data, and mapped source data using Teradata Financial Services Logical Data Model tool, from teh source system to teh Teradata Physical Data Model
• Worked wif ETL group for understanding Ab Initio graphs for dimensions and facts
• Formulated test plans and performed unit testing for teh graphs
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity; developed SQL Stored Procedures and Queries for Back end testing; automated detailed test cases by using Quick Test Pro
• Utilized Quick Test Pro to write teh automated test scripts by using various actions and reusable actions
• Planned testing strategy for end to end flow through teh system to link teh front end functionality to teh back end
• Formulated SQL scripts for test data preparation for Back End functionality testing
• Written extensive UNIX Shell scripting for data parsing and text parsing needs including archiving teh old data, running backend jobs & setting up of job dependencies
• Scrutinize business requirements, ETL Analysis, ETL test and design of teh flow and logic for teh Data warehouse using Informatica and Shell Scripting
• Tested Informatica Mappings to validate business conditions; Conditional testing of constraints based on business rules
• Formulated test cases on teh application as per company standards and tracked teh defects using HP Quality Center 9.2
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Written Test Cases for ETL to compare Source and Target database systems
• Monitored teh data movement process through Data Extract to flat files through Informatica execution flows and Loading data to Data mart through NZLOAD utility
• Testing teh ETL data movement from Oracle Data mart to Teradata on an Incremental and full load basis
• Developed teh ETL process to automate teh testing process and also to load teh test data into teh testing tables

Confidential, Pheonix, AZ

Data/SQL/ETL Tester

Environment: VBA, Excel, SSIS, Informatica, ERwin 4.1, Oracle 9i, DB2 UDB, SQL Server 2000, SQL, PL/SQL, PuTTY, WinSCP3, TOAD, SQL Developer, UNIX (AIX), Shell Scripts, Mercury Quality Center 8.0, Microsoft Office 2003, Windows XP/2000, TERADATA V2R6, MLOAD, FLOAD, TERADATA SQL ASSISTANT, BTEQ

Responsibilities:

• Data sources analysis such as flat files, ASCII Data, EBCDIC Data, from various heterogeneous data sources
• Developed inline view queries, complex SQL queries and enhanced teh query performance for teh same
• Performed ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds
• Identify issues, information, and behaviors during teh adoption of a proprietary information management system
• Develop code necessary to introduce additional reports, reverse engineer data models to teh business meaning, and instruct users on teh account management and implementation process advantages derived from teh system
• Identify and document deficiencies in teh proprietary information management system during initial implementation

Confidential, Manhattan, New York

ETL/SQL Analyst

Environment: Informatica, Operating System v2.11, GDE v1.12, Erwin 4.1, TOAD 7.6, Oracle 9i, DB2 UDB, Cognos 7.0 series, SQL, PL/SQL, UNIX (AIX), Shell Scripts, Windows 2000 / NT.

Responsibilities:

• Designed teh data flow diagrams using VISIO; worked wif Data Profiling for various needs of business
• Developed automated scripts for functional testing and data driven testing of teh application using QTP
• Extensively worked on QT Pro to design and develop various manual and Goal oriented Scenarios for Application
• Functioned on calling shell scripts from post-session and pre-session events; extensively involved in implementing performance tuning techniques for teh queries
• Vital role in Maintenance and Production Support
• Utilized various types of transformations viz., Expression, Joiner, Update strategy, Look up, filter for developing mappings
• Created sessions and workflows to run wif teh logic embedded in teh mappings using Power center Designer
• Utilized workflow manager for session management, database connection management and scheduling of jobs
• Executed campaign based on customer request and reviewed execution log to keep track of teh number of records going into and coming out of every job step
• Formulated Test Plan and test Strategies for Data Warehousing Application
• Optimized queries using rule based & cost based approach; executed campaign based on customer requirements
• Formulation of technical specifications and Source to Target mappings

Confidential, Manhattan, New York

ETL Analyst/Tester

Environment: Oracle 7.3, SQL, PL/SQL, SQL*Plus, Informatica, Operating System v2.11, Mainframe, Small world, Windows 2000/NT/98/95, Microsoft office 97, Informatica 6.1, UNIX, PERL, Shell Scripting, XML

Responsibilities:

• Vital role in building teh management process, ensuring controls are being followed, assisting in requirements design, and coordinating teh efforts of performers in teh Enterprise Information Management Department
• Performed unit and integration testing for Informatica & database level
• Formulated technical specifications, mapping documents and managed test cases
• Involved in teh development of an estimation tracking tool for level of effort projections
• Developed database applications for managing IT staffing requirements and monitoring teh status of outstanding requisitions
• Provided data analysis, identified trends and generated reports for Card Solutions Delivery reorganization effort
• Extracted data from different sources like Oracle, Flat files, Xml & loaded into Operational Data Source
• Worked on loading of data from several flat files to XML Targets
• Created UNIX shell scripts for Informatica ETL tool to automate sessions
• Developed graphic representation of various metrics used in forecasting, budgeting and procurement processes for teh Merchandising Department
• Utilized Access database to collect data from multiple database sources using ODBC methods

Confidential

Test Lead

Responsibilities:

• Interacting wif onsite counterparts and tested teh Tickets dat required for deployment.
• Involved in preparing Test script and Execution of teh Tickets
• Involved in teh preparation and monitoring of Defects.
• Performed System Testing and Regression Testing
• Interacting wif onsite counterparts and tested teh Tickets which were required for deployment.
• Involved in preparing Test script and Execution of teh Tickets
• Involved in teh preparation and monitoring of Defects.
• Performed System Testing and Regression Testing
• Interacting wif onsite counterparts and tested teh Tickets which where required for deployment.
• Involved in preparing Test script and Execution of teh Tickets
• Involved in teh preparation and monitoring of Defects.
• Performed System Testing and Regression Testing