PROFESSIONAL SUMMARY:

• Around 8 years of extensive experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web and Client/Server based commercial applications.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies
• In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Performed GUI, Functional, Integration, Regression, User Acceptance, Business Process Testing Smoke, Sanity and System testing.
• Analyzed and diagnosed issues which may impact performance or availability in the eCommerce environment.
• Experience in Manual, Functional and Automated Software Testing tools QTP, Selenium, and SoapUI.
• Performed front end testing to verify functionality, GUI and usability.
• Strong accomplished experience as Sr. Microstrategy Expert Consultant
• Good noledge of Hadoop ecosystems, HDFS, Big Data, ETL, RDBMS.
• Experience in Setting up of Nodes, Data Sources, Virtual Hosts, including planning, installation and configuration of WebSphere Application Server ND5.x/6.0/6.1/7.0
• Expertise in writingSQL QueriesusingOracle,SQL ServerandTeradatain validating data into Data Warehouse/ETL applications.
• Excellent with QTP, SOAP UI, Borland Silk Test, Selenium RC, Selenium WebDriver, Microfocus TestPartner
• Strong noledge of Hadoop and Hive and Hive’s analytical functions.
• Ensured dat implementations met the required scalability and reliability required for Company eCommerce operation.
• Great expertise in testing web services via SOAP, using the open source testing tool SoapUI
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, Abinitio and Autosys tools.
• Settle on the methodologies and procedures for carrying out TEMPeffectual data analysis.
• Extensive experience in testing ETL data from multiple sources into Data warehouse using Informatica.
• Create SOAP UI framework for testing of API based on REST web services
• Provided best practices for MicroStrategy Implementation.
• Profound noledge of web services testing using Service Oriented Architecture tools SOAP UI.
• Implemented Proof of concepts on Hadoop stack and different bigdata analytic tools, migration from different databases( me.e. Teradata, Oracle, MySQL) to Hadoop.
• Executed test cases manually and automated to check GUI and Functional features of the AUT, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using QC.
• Implemented Proof of concepts on Hadoop stack and different bigdata analytic tools, migration from different databases( me.e. Teradata, Oracle, MySQL) to Hadoop.
• Expertise in Desktop creating and integrating Microstrategy reports, objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) and Generic cubes.
• Testing of web services using SOAP UI
• Good Knowledge in Configuring Remote/Local IHS Web Server and Apache Web Server in Websphere Application Server Network Deployment Manager.
• upporting presales activity for Data centric warehouse testing projects.
• Proficient inFunctionality Testing,Blackand WhiteBoxTesting,SystemIntegration Testing,RegressionTesting,User Acceptance Testing (UAT),andLoad &Performance Testing
• Experience in setting up and definingUAT process, schedule, and deliverables
• Served as core analyst on all future strategic projects assigned to eCommerce team.
• Implemented Proof of concepts on Hadoop stack and different bigdata analytic tools, migration from different databases( me.e. Teradata, Oracle, MySQL) to Hadoop.
• Tested the ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and BI Reports Testing
• Performed manual testing for the GUI and Functionality of the application.
• Extensive ETL testing experience using Informatica Power Center 9.1/8.1/7.1/6.2 components (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• A great deal of experience with eCommerce Content Management
• Worked onWeb ServicesTesting usingSOAP UI 4.0/3.0, Apache Axis Client 2.x, Eclipse 3.4 and IBM RAD 7.0.
• Installing and Configuring of MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments.
• Experienced in applyingpatchesfor Web Sphere Application Server.
• Gather data necessary to accomplish analysis from a number of sources, accumulate it together in prearranged format and enter the data in several data analysis software.
• Experience in using Oracle Databases, DB2 UDB, Sybase, SQL Server, Redbrick, Netezza, and Teradata.
• Strong no
• Experienced on working with Big Data and Hadoop File System (HDFS).
• ledge of Hadoop and Hive and Hive’s analytical functions.
• Good noledge onWeb sphere Portal server6.1.
• Hands on experience in Deployment of J2EEapplications on Web Sphere Application Servers 6.x/7.0.
• Performed Smoke, GUI, Functional, Performance, Integration and Usability testing.
• Experience with SQL Server Security and SQL Server Auditing.
• Expert in using Test Management Tools - HP, ALM,Quality center 11
• Developing data analytical databases from complex financial source data.
• Worked with different querying tools like SQL Assistant, TOAD, Oracle SQL Developer, iSQL * plus
• Used SOAP UI, Web Logic ANT task to test Web Services running on Web Logic Server.
• Experience in writing complex SQL and PL/SQL statements and validating XML feeds.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access, Flat Files and XML feeds.
• Expert in Test plan, Test strategy, Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Involved in the team to adoptQATesting Standards.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports.
• Generated GUI Maps for the application using Win runner's rapid test script.
• Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT)

TECHNICAL SKILLS:

Test Management Tools: Test Director9.0/8.0/7.5, Quality Center 11/10/9.0, QTP. Load Runner, Win Runner

ETL Tools: Informatica 9.1/8.1/7.x, Data Stage 7.5, Ab Initio (GDE 1.13, Co>Op 2.13

Bug Reporting: Quality Center 11/10/9.0, JIRA, Rational Clear Quest, Test Director, Bugzilla,soap.,GUI.

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML,Hadoop,Big data.

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX-UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005,2008, Sybase12.0/11.0, MS Access 2005, Teradata V2R6/V2R5, Netezza NPS 8050.

Reporting Tools: Business Objects, Cognos 8.0,SSIS,SSAS,Microstrategy.

PROFESSIONAL EXPERIENCE:

Confidential, MO

Sr. ETL Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Validating the Autosys jobs and executing them using CA Workload Control Center
• Prepared Test Plans and Test Cases for the mappings developed through the ETL Informatics tool.
• Experienced on working with Big Data and Hadoop File System (HDFS).
• Created multiple Profiles on WebSphere Application server 6.0&6.1and 7.0
• Tested different detail, summary reports and on demand reports.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Created different schema objects like Attributes, facts by using MicroStrategy Architect of the MicroStrategy BI Suite.
• Implementation of horizontal and vertical scaling of WebSphere Application Server for workload management in a cluster
• Strong noledge in Data warehouse Testing using AbInitio
• As a QA Engineer me used to run the test cases for the end to end process in dat data warehouse
• Experience testing tables like SCD Type 1, Type 2 & Type 3 verified history load and incremental load data.
• Configured AdminConsole security on websphere and creating users with various roles to access the websphere admin console - users and groups and added them in LDAP console groups using both admin consoles.
• Developed 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.
• Configuring WebSphere Application Server on multiple platforms for both horizontal and vertical scaling for Work Load Management.
• Executed the Test cases for BO and Congas
• Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
• Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists.
• Involved in preparing Test Plan from the Business Requirements and Functional Specification, Design, Development and Implementation of RDM (Report Data Mart).
• Used TOAD Software for Querying ORACLE.
• Responsible for different Data mapping activities from Source systems to different target systems.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems.
• Developed MicroStrategy Dynamic Dashboards in the Flash Mode using several controls and worked extensively on widgets.
• Perform Backend database testing to validate the data using complex SQL queries, PL/SQL, Oracle and AbInitio.
• Used automated scripts to perform routine management tasks on WebSphere environments like monitoring Disk Space, CPU & Memory Utilization.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Use AbInitio graphs to test positive & negative scenarios based on the test cases
• Extensively used Informatica power center for extraction, transformation and loading process
• Ensured data integrity and verified all data modifications and calculations during database migration.
• Responsible to get Test data from Production source to QA Source
• Exported Manual Test Cases from MS Excel template directly to QC and executed the Test Cases in Test Director with Pass/Fail/Blocked status.
• Executed the developed Test Cases and Test Plans and also responsible for creating Test Strategy for the Data Warehouse.
• Installed and configured the IBM HTTP Server 6.0/6.1 created web server definition and re-generated web server plug-in on Portal and Application Server to redirect request from Web Server to IBM web sphere application server
• Reported the Bugs/Defects using Quality Center 11 & JIRA defect management tool.
• Responsible for communicating Defect Status Reports to business in project meetings
• Worked with Production environment to resolve several data issues.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Performed Functional testing, System testing, Regression testing and Back end testing.
• Involved in Production Support related activities including resolving end user queries, investigation and resolving data related issues
• implementation of horizontal and vertical scaling of WebSphere Application Server for workload management in a cluster.
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & Adhoc reporting issues
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.

Environment: Informatica Power Center 9.1/8.5.1, Oracle 10g, TOAD, SQL, PL/SQL, Excel Files, XML, Load Runner, UNIX, HP,ALM,Quality center 10 & JIRA,Data Centric,Websphere. SQL Server 2000/2005/2008,Big Data,SOAPUI,Microstrategy.

Confidential CT

Sr. ETL/DW/Backend Tester

Responsibilities:

• Analyzed business requirements, data mapping requirement specifications along with the team
• Wrote SQL/Complex SQL queries for system testing
• Used data conversion to Protect the data and prevent data loss
• Wrote data conversion and data migration scripts for ETL process
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded.
• Developing test plans and validation templates and Coordination with Siebel systems for UI enhancement.
• Responsible for collecting business requirement, WMOS Modules, design and development of the system and developing test plans in collaboration with Testers and maintaining Traceability Matrix.
• Worked closely with Database administrators to resolve database and JDBC related is-sues in WebSphere Application Server Migrated to WAS 6.0 Network Deployment and Base on AIX/Windows platforms to WAS 6.1 ND
• Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
• Involved in developing Unix Korn Shell wrappers to run various Ab Initio Scripts.
• Tested the data load process using the Ab Initio ETL tool
• Tested several data validation graphs developed in Ab Initio environment.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• Involved in the re-engineering of various web based Apps and Enhancements over existing applications. Implementation and strong understanding ofManhattan WMOS Supply-chain modules like Order Management & Transportation Management for Home Depot Stores nationwide.
• Performed routine management of WebSphere environment like monitoring Disk Space and CPU Utilization.
• Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Used data conversion to Protect the data and prevent data loss
• Involved in extensive DATA validation using SQL queries and back-end testing
• Wrote complex SQL, PL/SQL Testing scripts for Testing of the data warehouse application
• Involved in monitoring Master and Transactional data upload from
• Written several Stored Procedures and modified existing stored procedures.
• Involved with extraction routines to verify all the required data loaded into target systems and tested for data reconciliation
• Extensively executed SQL queries, in order to view successful transactions of data and for validating data, along with Business Objects reports
• Modified/Tested BO Universes with pre-calculated aggregates from summary tables
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using HP,ALM, Quality Center
• Tested Migration of the Universes/Reports across the Servers (Development to Production Servers)
• Involved in Testing Re-creation of reports for NOT Converted Reports
• Tested and Developed data reconciliation method for the entire project
• Was involved in analyzing scope of testing the data warehouse
• The reports dat were created in Business Objects were tested by running the SQL statements against the Universe
• Involved in setting up Delta Tests for carrying out controlled delta testing.
• Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
• Worked closely with BA and development teams to investigate data issues
• Worked with Production environment to resolve several data issues
• Was point of contact between onsite and offshore team

ENVIRONMENT: Ab Initio, (GDE 1.14, Co>Op 2.14),, ORACLE 9I/10G, SQL, PL/SQL Developer, STORED PROCEDURES, SQL, QUALITY CENTER 8.0, Business Object XIR2, MS OFFICE SUITE,Load Runner,Webspher,Microstrategy.

Confidential, Ann Arbor, MI

Sr.ETL/SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Interacted with senior peers or subject matter experts to learn more about the data.
• Validating the Workflows and running them using Workflow Manager.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL Informatica tool.
• Experienced in writing complex SQL queries for extracting data from multiple tables and validating with target tables.
• Validated target tables DDL, counts, data (Business rules), negative testing and regression testing.
• Involved in preparing Test Plan from the Business Requirements and Functional Specification, Design, Development and Implementation of RDM (Report Data Mart).
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Involved extensively in doing back end testing of the data quality by writing complex SQL.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Ensured dat the mappings are correct and TEMPeffectively communicate testing activities and findings in oral and written formats.
• Created TEMPeffective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Extensively used Oracle Loader to load Test data from flat files to tables.
• Reported bugs and tracked defects using Quality Center.
• 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.
• Extensively tested several Cognos reports for data quality, fonts & headers.

Environment: Informatica power center 8.6, Oracle 9i, SQL, PL/SQL, Teradata, SQL Server 2005, UNIX, Unix Shell Scripting, IBM DB2, XML, SQL *Loader, Cognos 7.0, Erwin 3.5, Windows 2000, TOAD 7, Quality Center 9.2,Load Runner,Microstrategy.

Confidential, Bloomington, IL

ETL/QA Tester

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL process for both before data validation and after data validation process.
• Tested to verify dat all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Testing TEMPhas been done based on Change Requests and Defect Requests.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Involved in integration testing of Informatica mappings.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Experience testing tables like SCD Type 1(Staging Tables) and Type 2(Target Tables)
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant
• Used Quality Center to track and report system defects.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports dat included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Worked closely with engineering team to discuss the design and testing aspects of the applications to design the test plans and to isolate the root cause of defects.
• Involved in meetings and walkthroughs.
• Responsible for weekly status.

Environment: Informatica Power Center 7.2 (Power Center Designer, workflow manager, workflow monitor, UNIX, Oracle8, Teradata V2R4, SQL Server 2005, Windows 2000, Cognos8.4.1,Quality center 9.2,Load Runner.

Confidential, Groton, CT

QA Analyst

Responsibilities:

• Projects were in different methodologies like Waterfall and AGILE, well versed with both methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support issues.
• Designed detailed test plans, test case and executed test scripts and diagnose problems in Informatica mappings based on Business Requirements.
• Gatheird UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other database objects.
• Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next version.
• Communicated with Developers regarding technical issues.
• Used Remedy in trouble ticketing and moving projects from testing to pre-production environments. VSS to upload track and manage scripts and documents.

Environment: Test Director 8.0, SQL server 2005( SSIS, SSRS ), SSAS, Informatica 8.x, SQLServer, DTS Packages, Remedy, Teradata V2R5, Windows NT, UNIX, MS Excel, VSS(Visual SourceSafe), Quality Center 8.2, QTP 8.2