SUMMARY:

• Over 7+ years of IT experience in complete SDLC, coding, integration, web testing and QA Validations and Data warehousing testing with extensive usage of SQL, PL/SQL, UNIX, Shell Scripting & HP QC
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, and Ab Initio and Autosys tools
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
• Expert on Load, Performance test using LoadRunner and Performance Center with different protocol i.e WebHTTP/HTML, Silverlight, WebServices
• Experience of working full Software development life cycle (SDLC) in Waterfall and Agile methodology
• Solid Expertise in using testing tools like Ruby with Cucumber, Selenium WebDriver
• Experienced working with SQL Server 2008, Netezza, Oracle 10g/11g, Teradata, Sybase & DB2.
• Experienced in testing different source feeds of data for ETL and prepared mock data for ETL.
• Experience in testing Business Report developed in Business Objects XIR2 & Cognos 8 series, OBIEE, Hyperion reports.
• Extensive experience in Oracle Packages , Stored Procedures, Functions and Database Triggers using PL/SQL. Efficiently used Oracle utilities like SQL Loader
• Hands on experience in creating of test automation frameworks from scratch
• I am capable to create a networking solution from scratch, designing a MOP, putting together the implementation and post - launch caring
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET, ASP.NET
• Experienced in Writing UNIX Korn Shell Scripting for job scheduling and sequencing.
• Experienced working on tableau
• Experience in clover ETL
• Experience handling DTF tool and hands on experience with DVO tool using informatica.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Extensive experience in UNIX Shell Scripting, AWK and file manipulation techniques.
• Experience with QA Methodology and QA Validations to ensure the Quality.
• Solid Back-end testing experience in writing and executing SQL Queries .
• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.
• Ability to interact with all levels of personnel from technical to high level executive management within the information technology and business communities.

TECHNICAL SKILLS:

ETL Tools: Informatica 5.x/6.x/7.x/8.x (PowerMart & PowerCenter), SSIS, SSAS

BI Tools: Business Objects XIR4, Cognos 8.0 Series, Crystal Reports, Hyperion, OBIEE

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Bugzilla

Data Modeling Tools: Erwin 3.x/4.x

Databases: SQL Server 2005/2008, T-SQL,Oracle 11i/10g/9i, Teradata V2R6, DB2, Sybase 12.5, Netezza

Teradata Utilities: BTEQ, FastLoad, MultiLoad, TPUMP, Teradata SQL Assistant

Programming Languages: COBOL (Mainframe), SQL, PL/SQL, UNIX Shell Scripting and PERL

Operating System: MS - Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

Other Tools: Siebel, TOAD 8.x and SQL Plus (Database tool), Autosys, Cron, XML Spy 2011

PROFESSIONAL EXPERIENCE:

Confidential, MC Lean, VA

Sr. ETL SQL DWH QA Test Analyst

Responsibilities:

• Analyzed Business Requirements and understood customer and developed QA/SIT Test Plan using Testing Methodology.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Researched QA Automation test tools, Application Testing tool(ATC m/c) from blue print
• Used Cucumber to run automated tests written in plain language
• Completed full life cycle of SDLC and QA Methodology throughout the project
• Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline documents.
• Participated in unit testing and verified entrance criteria of QA and set up configuration data with developer and updated release notes.
• Tested SCD Type 1, Type 2 and Type 3 for History Load and Incremental Load
• Ran ETL workflow to load the tables and tested the transformation as per mapping documents.
• Developed SQL Script to validate Data Transaction in Front End Testing. Developed complicated and execute via Toad and saved Test Result.
• Created frameworks for web based application from scratch.
• Used Oracle Developers to validate the Cognos Power Play cubes by running similar SQL queries against the source system(s)
• Worked with peers in development and other organizations to troubleshoot and resolve project issues both technical and non-technical in nature.
• Worked on clover etl
• Tested Cognos reports for verifying and validating the data. Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Involved in System Integration testing with external &internal interface team and performed E2E Testing.
• Assisted business & marketing team in execution of UAT by providing data.
• Involved in System Integration Testing with external/Internal interface and understood overall customer business functionalities.
• Shared technical information with team and involved in production testing with critical production problem.
• Interacted with upper management to provide daily QA status, discussed outstanding issue and upcoming project functionalities.

Environment: ALM / HP Quality Center 11, Oracle 11g, Informatica 9.5, QTP 11.0, SQL, SQL Server 2012R2, Cucumber, SQL server Management Studio, clover etl UNIX, Shell scripting, .NET, PL/SQL

Confidential, East Providence, RI

Sr. ETL SQL DWH QA Test Analyst

Responsibilities:

• Worked with Business Analysts, SME, QA Manager, QA LEAD and analyzed the requirement and review the BRD and TDD documents and design test plan
• Tested Dimension Tables and fact tables in Star Schema. Had experience with multiple datamarts.
• Conducted vigorous manual testing on functional behavior and Web Services (SOAP UI) testing to validating user access authentication process among the systems using standardized XML messaging system.
• Analyzed business requirements, data mapping specifications and developed Test Plans, Test Cases, Expected Results and Prioritized tests for the applications for various modules using HP QC 10
• Tested several packages developed using SSIS.
• Created from scratch EFS system for users via Visual Basic code, Access Database, and Crystal Reports.
• Functions created were data configuration, extraction of data to Excel and Access databases, and used for PowerPoint presentations
• Worked on multiple projects and experienced with on shore / off shore model extensively
• Worked on clover etl tool
• Wrote SQL queries in Toad and SQL server Management studio to validate the source and target system s
• Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity
• Tested complex objects to the universe to enhance the report functionality.
• Optimized the usage of user objects, conditions and universe level filters
• Involved in documenting the changes to the universe and reports functionality.
• Executed Informatica Workflows from UNIX using the shell scripts.
• Involved in fixing the defects and data validation of reports for Partially Converted and Fully Converted Reports.
• Tested and maintained the Business Objects universe and reports
• Written several shell scripts using UNIX Korn shell for file transfers, archiving the existing files, catalog creation, error log creations and log file cleanup process.
• Evaluation of critical problems/issues during testing and reporting them in Quality Center.

Environment: Oracle 10g, TOAD, SQL Server 2010R2, SSIS, SSAS, SSRS, Informatica 9.1, T-SQL, SQL Server Management studio 2008, Business Objects Enterprise XI R3.1, Business Objects Designer, HP Quality Center 10, HP QTP 10.0, UNIX, PL/SQL

Confidential, BALTIMORE, MD

ETL QA DWH Test Analyst

Responsibilities:

• Analyzed Business Requirements and understood customer and developed QA/SIT Test Plan using Testing Methodology.
• Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline documents.
• Participated in unit testing and verified entrance criteria of QA and set up configuration data with developer and updated release notes.
• Performed sanity testing using post installation check using release notes and identified installation or code initial problems.
• Developed SQL Script to validate Data Transaction in Front End Testing. Developed complicated and execute via Toad and saved Test Result.
• Performed functional testing by deployment request, sanity testing, prioritized QA Test Cases within project plan.
• Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Test Director.
• Performed impact analysis and executed test scenario with Regression Testing.
• Involved in Back End Testing using UNIX Utilities and automated Regression Testing using Korn scripting.
• Involved in System Integration testing with external &internal interface team and performed E2E Testing.
• Assisted business & marketing team in execution of UAT by providing data.
• Involved in System Integration Testing with external/Internal interface and understood overall customer business functionalities.
• Shared technical information with team and involved in production testing with critical production problem.
• Interacted with upper management to provide daily QA status, discussed outstanding issue and upcoming project functionalities.

Environment: Oracle 10g, OBIEE, Windows XP/2003/2000, clover etl, Crystal Reports XI R2, SQL, Korn Shell Scripting, PL/SQL, T-SQL, Quality Center 10/9,Informatica 8.6.1, XML Files, VSAM Files, Flat Files.

Confidential, DE MOINES, IA

ETL QA TEST ANALYST

Responsibilities:

• Interacted with Business Team, Business Requirement Gaps Analysis, Customer Experience and Impact Analysis of application.
• Contributed to and monitored test planning, test preparation and scripting, and test execution according to define best practices, standards and procedures.
• Interfaced regularly with peers and management regarding test related topics including the coordination of test related initiatives with QA Test Leads, Project Managers, Development Managers, and other QA Core team members (SDLC Team).
• Participated in all phases of the IT Project Delivery Framework, including review of complex business and functional requirements. (Kick Off meeting, Change Control, etc).
• Assessed risk to quality service based upon results of verification and validation. Monitored adherence to established test standards and procedures. Standardized QA Process using Testing Methodology, Process Improvement.
• Expertise in Back End Testing and use of UNIX Utilities like awk, grep, sed, vi, network, process, file level, directory level, etc.).
• Provided QA consultation services to support users of related test processes.
• Managed verification and validation activities for production modifications in production enhancement, interact with user, involved in automation of health check of application.
• Maintained document template libraries and internal project documentation like QA Test Plan, Local procedure, QA Test Results, etc.
• Organized and/or facilitates team member training sessions in each new application to implement process.
• Participated in both internal and external process improvement projects like QA, SIT, UAT Testing with business & Marketing and External Vendors team.
• Knowledge of relational databases like Oracle Database 11g to validate data testing in back end using complicated SQL script using Oracle functions.

Environment: Teradata V2R6 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant, SSIS, Business Objects Enterprise XI R2, Business Objects Designer, Quality Center 9.2