SUMMARY

• Over 5+ years of Professional Experience in Software Development Life Cycle (SDLC) including Business, System and Data Analysis, Testing, Implementation and Documentation in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Created, maintained, and executed manual and automated test scripts for black box, functional, Integration, regression, confidence, system, security, performance, load and stress testing.
• Proven Strong Analytical and Logical skills with ability to follow project standards and procedures as per client specifications.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools.
• Good Testing experience in developing reports using SQL Server (SSRS)
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Demonstrated excellence in writing System Specification documents, creating and developing Test Plans, Test cases and Test scripts and interacted with development Engineers and Business Analyst.
• Ability to work in Multi-Platform Environments like Windows, UNIX and Linux.
• Experience includes the testing of Intranet, Internet and Client/Server and WEB based applications using automated testing tools like Quick Test Pro (QTP), Load Runner
• Involved in review meetings with Project Managers, Developers and Business Associates for Project Planning, Coordination.
• Skilled in analyzing business context and requirements for UAT testing purposes
• Well versed in detecting errors and conducting UAT by designing, developing, and executing test cases
• Extensively used CA Clarity PPM for Time Tracking
• Involved in testing the Micro strategy reports by writing complex SQL queries
• Experience in all phases of Software Development Life Cycle (SDLC), Testing life cycle and bug life cycle.
• Strong experience in Software Quality Assurance and Testing (Manual and Automation), Test Plan Formulation, Functionality, GUI, Performance and Regression Testing in Web Based and Client/Server Applications in different environments and different Browsers.
• Expertise in working with SQL queries and PL/SQL (Stored Procedures, Triggers, Packages/Functions).
• Excellent knowledge of the design and implementation of the Data Warehouse life cycle.
• Knowledge of Data Warehouse/Data Mart design concepts.
• Experience with business requirements gathering, business analysis and documentation.
• Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and UNIX.

TECHNICAL SKILLS

Data Warehousing: Ab Initio CO>Op 2.15, GDE 1.15, Informatica 8.6.1/8.1/7.1/6.1 , SSIS, Data Stage 8.x, SSIS

Reporting Tools: Business Objects XIR4, Cognos 8 Suite, OBIEE, Hyperion, Crystal Reports

Data ModelingStar: Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Test Director, HP Quality Center, Rational Clear Quest, Rational Clear Case

RDBMS: Oracle 11i/10g/9i/8i/7.x, MS SQL Server 2008, UDB DB2 9.x, Sybase 12.5, Teradata V2R6, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

QA Analyst

Responsibilities:

• Analyzed the requirement from the client and developed test cases/scripts and test plan based on functional requirements, general requirements and system specifications
• Prepared test cases for system testing and uploaded them into HP Quality Center; linked the test cases to the business requirements
• Responsible for executing test cases/scripts, and validate test results and document the test evidence
• Interfacing with the product owner and tech team to understand the Project and create QA project Plan
• Review test plans and test strategy document
• Responsible for identifying and analyzing project risks and scope
• Daily status reporting to higher management using Quality Center Dashboard
• Perform and co-ordinate UAT, functional, systems Integration, and regression testing
• Conduct defect triage meetings and review production validation plan
• Performed extensive manual on critical functionalities of the application
• Communicated defects promptly and clearly ensuring quick prioritization and resolution
• Involved in CRM application for customer user interface and customer agent application
• Tested whether the mapping adheres to development standards and naming conventions
• Manually ran test cases in HP Quality Center
• Developed test scripts using SQL queries to validate data
• Involved in Gap analysis of source systems and target systems
• Preform and guide team for production validation
• Responsible for defects management and driving to resolution and retesting the same
• Written SQL compare statements to validate actual results with the expected results
• Performed database (Oracle and DB2) validation after batch and PL/SQL procedure run
• Tested ETL mappings to extract and load data from different data bases such as Oracle, SQL Server, and Flat files and loading them into Oracle

Environment: Agile, SQL, PL/SQL, SSIS, Oracle SQL Developer, Jira, HP Application Life Cycle Management Teradata SQL Assistant, DB2, Micro strategy, QTP, SOAPUI, XML, XML, MS Excel, MS Word, Visio, MS PowerPoint, MS Visio, MS Project 2010, Windows 7, SharePoint

Confidential, Reston, VA

QA/UAT Analyst

Responsibilities:

• Analyze complex SQL queries of in scope reports and identify critical elements, complex calculation logics and capture them in requirements template
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Developed strategies with HPALM (Application Lifecycle Management) for stress testing and UAT (User Acceptance Testing)
• Experienced in creating the SSIS packages, DTS packages.
• Created and managed project templates, use case project templates, requirement types and traceability relationships
• Tested the reports generated by Micro strategy and verified and validated the reports using SQL.
• Tested different reports including detail, summary reports and on demand reports developed by SSRS Report Studio
• Profound experience in testing web applications using Quality Center and Quick Test Pro (QTP).
• Used SOAPUI for web services validation for SOA architecture.
• Worked with Source to Staging area to validate the Basel II multiple source system data with SQL queries
• Monitored performance, integrity to optimize SQL queries for better efficiency
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Using the Tableau for the data\business predictive findings, for trending, for finding the pattern of data over the period of time.
• Extensively tested several Micro strategy reports for data quality
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Responsible for creating the Requirements Traceability Matrix.
• Involved in Designing Star Schema, Creating Fact tables, Dimension tables and defining the relationship between them.
• Creating various automated test scripts using QTP
• Worked with Data Modelers to create a Physical Data Model from the Logical Data Model using Erwin tool.
• All DDM enhancements that are required to support the release, including: new columns, dimension and fact tables, look-up/shadow tables, and subject areas.
• The required data elements from each source system (where the data originates), the appropriate target columns in the DDM for these data elements (to where the data flows), and the transformation rules that are required from the Staging to the DDM (From which reporting is done).
• Designed & developed various Ad hoc reports for different teams in Business (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Report testing: Extensive experience with Reporting Tools like Micro strategy
• Conducted Load testing using SOAPUI tool.
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Write complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports

Environment: ETL Informatics, SQL, PL/SQL, SSIS, Oracle SQL Developer, Teradata, Teradata SQL Assistant, Micro strategy, QTP, SOAPUI, XML, XML, MS Excel, MS Word, Visio, MS PowerPoint, MS Visio, Ms Project 2010, Windows 7, SharePoint

Confidential, Richmond, VA

QA Analyst

Responsibilities:

• Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.
• Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.,
• Performed Business Process mapping for new requirements.
• Performed Data Validation with Data profiling
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
• Involved in testing the Micro strategy reports by writing complex SQL queries
• Used QTP for Regression testing.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Designed reports in Access, Excel using advanced functions not limited to vlookup, pivot tables, formulas
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House
• Creating complex data analysis queries to troubleshoot issues reported by users
• Evaluates data mining request requirements and help develop the queries for the requests.
• Conducted UAT (User Acceptance Testing) for multiple iterations by writing Test Cases and signed off the same after approval
• Used Informatica Data Validation Option(DVO) for a large set of pre-built operators to build this type of ETL testing with no programming skills required
• Experienced in creating the SSIS packages, DTS packages.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Executed the Test cases for Micro Strategy
• Involved in Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Efficient in process modeling using Erwin in both forward and reverse engineering cases.
• Worked in Agile technology with Scrum and waterfall models.
• Written XSLT scripts for various XML needs and used XPath, XQuery for data retrieval from XML documents.
• Responsible for creating the Requirements Traceability Matrix.
• Involved in Designing Star Schema, Creating Fact tables, Dimension tables and defining the relationship between them.
• Developed automated Test Scripts using QTP
• Generated reports using SOAPUI.
• Involved in different reports including detail, summary reports and on demand reports developed by SSRS Report Studio.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Verified Informatica sessions, worklets and workflows in QA repository.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested different detail, summary reports and on demand reports using Report Studio.
• Reported bugs and tracked defects using Quality Center 10.
• Experienced in working with DB2,Teradata
• Analyzed test cases for automation and created scripts for regression testing using QTP 9.2. Automated Test cases for the purpose of regression testing.
• QTP was used to generate automated Test scripts for functionality and GUI Testing.

Environment: Oracle 11g, Sql Server 2005, Oracle 10g, Informatica Power Center 9/8.5.1 Micro strategy, Netezza, XML, Test Cases, Assistant, Teradata V2R6, Teradata SQL Assistant, IBM DB2, SOAPUI, XML, QTP, SAS/Access, Unix, Test Matrix, TOAD, HP Quality Center 10Barclays; Wilmington DE

Confidential

Intern UAT Tester

Responsibilities:

• 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
• Written several complex SQL queries for validating Micro strategy Report
• Testing of Wholesale and Retail segment level files for CCAR including History files.
• Participate in FRB requirements sessions, conduct and schedule meetings with SMEs, organize CCAR team meetings, joint application development meetings for project planning and execution.
• Prepare Reconciliation Reports and send to users to make understand of the changes made
• Analyzed issues using information from source system mapping documents and by querying databases.
• Compared information from multiple spreadsheets to track and resolve issues for the edit checks.
• Provided status updates to the CCAR team regarding the issues and ensured that they are fixed.
• Communicated with SME’s to verify data transformation logic to identify if the issue was data quality related or logic related.
• Generated reports using SOAPUI.
• Involved in validating SSIS and SSRS packages according to functional requirements
• Experience in testing XML files and validating the data loaded to staging tables.
• Attend meetings to understand FRB requirements for CCAR
• Answered all the questions related to CCAR from Supervisory Modelling Team and also the point of contact for all issues raised by Reconciliation Team
• Analyze defects and propose solutions with appropriate transformation logic
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Worked with SOAPUI for testing Web Services
• Analyzed several SSRS reports and SSAS OLAP cubes for multiple projects and used RDL and XML for testing the same.
• Documenting the extent to which data fails to meet threshold reporting requirements
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and Entity-Relationship (ER) Diagrams in MS Project. Created and managed project templates, Use Case templates, requirement templates, and traceability relationships in Requisite Pro.
• Coordinated with SMEs to resolve Data Quality Issues and to get any missing source data.
• Worked with the team members closely in determining both medium and high severity defects that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Organized meeting to track the progress of project/defects.
• Performed data quality analysis using advanced SQL skills.
• Extensively used Data Stage for extraction, transformation and loading process
• Conducted GAP analysis & Impact Analysis while implementing Change management
• Designed and kept track of Requirement Traceability Matrix
• Worked with the enterprise test team to define System Test Plans and Test Cases according to
• Business requirements.
• Assisted in the development, design and implementation of new relational and multi-dimensional
• Databases for user needs.

Environment: Data stage 8.0,7.X/6.X, Micro strategy, SSIS, SSRS, Flat files, MS SQL Server 2008, Oracle 10g/11g, SQL, PL/SQL,HP QTP 9.0, HP Quality Center 10,ALM 11.0, Toad, Unix Shell Scripting, Windows XP, XML, Aqua Data Studio 12.0, Soap UI,DB2 - LUW 8.x/9.x/10.x.