SUMMARY:

• Over 9 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Expert in writing complex SQL queries.
• Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in DB2 and Oracle using SQL.
• Expertise in Data Mover scripts for Data Export and Import.
• Experience in Java Scripting with Hadoop, analyzing huge datasets & parsing CSV files.
• Experience in Integration and extraction of data from various sources like DB2, SQL Server, Oracle, Sybase, and Teradata, SAP 3.1H, Ms Access, Flat files into a staging area.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
• Experience in writing complex SQL and PL/SQL statements
• Created manual Test Cases in HP QC/HP ALM for various User Stories based on Release and Sprint Plan.
• Good knowledge on Automation Tool Selenium and Quick Test Professional.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Data stage, Informatica, Ab initio and Auto sys tools.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Experience on different types of Testing like Black Box, White Box, Integration, System, Functional and Regression Testing.
• Generated automated Scripts in QTP and designed Automated Test Suites for regression testing in Quick Test Pro.
• Knowledge of and ability to apply a wide range of software test engineering concepts: testing principles (Testing Methodology) and concepts, building a test environment, tracking defects n Quality Center
• Hands on expertise with test automation tools such as HP QTP (Quick Test Pro) 10/11 and Selenium IDE
• Experience in assisting the customer in User Acceptance Testing (UAT).
• Experience working with .Net, Java and C++ based applications. Good understanding of Object Oriented Concepts.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture
• Excellent skills in TeraData, DB2, SQL Server and Oracle 10g/9i/8i RDBMS and Sybase.
• Worked in industries including Banking, Finance and Retail domains
• Experience in creating environment’s for Development, Testing, Production and Version Control.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

LANGUAGES: C, PL/SQL, SQL*Plus, SAS

Data Modelling tools: Erwin 4.5/4.0/3.5.5/3.5.2, MS Visio

RDBMS: Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Oracle 7.X/8.X/9.X, MS SQL Server 6.5/7.0/2000, MS Access 7.0/ 97/2000, MySQL 3.X/4.X, Sybase, SQL Server 11.x/12.0

REPORTING TOOLS: Crystal Reports 6.5, Business Objects XIR3/XIR2/6.5.1(Supervisor, Designer, Reporter), Cognos 6.5/7.0, SSRS, IBM Cognos 8

DATAWAREHOUSING: Ab Initio, Informatica 8.6.1/8.1/7.1/6.1, OLTP, OLAP, Data Stage 8.x, Data Mining, DataMart, SQL*Loader, TOAD 7.5.2

TESTING TOOLS: MS Project Test Scheduling, Test Director, Quality Center, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Rhode Island

Data Quality Analyst

Responsibilities:

• Running of ETL jobs and test data setup using Autosys, Quality check for test data. - Transformation logic verification, RCA for defect found.
• Used SQL tools like TOAD for Oracle to run SQL queries and validate the data loaded into the target tables
• Did Data Completeness, Data Transformation, Data Quality, Data Loading, Data Profiling and Integration, UAT and Regression testing for multiple source data coming from different systems.
• Create ETL routines in SSIS
• Define and interpret business requirements into data specifications
• Determine usage and needs for data collection and reporting
• Identify and resolve conflicts with data interpretation
• Perform impact analysis on data and process changes
• Work with customers to identify data that supports their products and answers their questions.
• Perform analysis on data to detect and address issues and establish criteria for data quality standards
• Work with Database Engineering to maintain a centralized data dictionary
• Capture and plan for future data needs
• Work with BA to interpret business requirement into functional requirement
• Create mapping document using the functional requirement
• Help developer in understanding the mapping document
• Validate the stored procedures written by the report developers
• Raise RFC and prepare replication request forms
• Validate the replicated tables and views
• Written several complex SQL queries & PL/SQL stored procedures for validating Business Objects Reports
• Help the ETL team understand the mapping document
• Extensively followed AGILE SPRINT methodology to implement the Project.
• Participated in daily meetings with Business/DEV team mates to enhance the productivity.
• Worked in an intense AGILE environment, where the code is delivered every 3 days.
• Participated in weekly defect review meetings with the dev./business and test team peers
• Extensively involved in Onsite-Offshore model, where need to held meetings on daily basis, as were following AGILE methodology.
• Tracked the defects using QC ALM tool and generated defect summary reports.
• Validated the data movement (XML, Flat Files,VSAM,.dat,.xls) and transformations are done correctly
• Worked with Data Warehousing developers who extensively used Informatica9x, to design
• Mapping to move data from source to target database-using Stages to do the functionality.
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users.
• Participated in regular project status meetings related to testing
• Reviewing Functional Specification Document and preparing traceability matrix with the test case mapped.
• Worked on data analysis using SQL, T-SQL and many other queries based applications.
• Used Teradata advanced techniques like OLAP functions CSUM, MAVG, MSUM MDIFF etc.
• Developed Reports using the Teradata advanced techniques like Rank, Row number and etc.
• Responsible for WQA representation in the full end-to-end testing processes.
• Design and write formal test plans and test specifications to address system, integration, and data conversion testing.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Identify and document defects in a defect tracking system and manage issues/defects through resolution.
• Experience in using Java Scripting for Big data analysis with Hadoop to MapReduce Hadoop framework for analyzing huge datasets & parsing CSV files.
• Identifying duplicate records in the staging area before data gets processed
• Provide communication to project stakeholders.
• Manually execute detailed test procedures designed to validate application functional requirements.
• Ensure software requirements are verifiable and quantifiable with the ability to build test cases.
• Contribute to efficient and effective program and system solutions in solving medium-complex business problems.

Environment: Toad for Oracle, Unix, WIN SCP,ETL Informatica 9.1, AutoSys, QTP, VB descriptive scripting, Hadoop, Java, HP ALM Quality Center 11.0, Teradata 12.0, PL/SQL, Microsoft Windows 7, Business Objects, C++, XML, Test Director, J2EE, SAP.

Data Quality Analyst

Responsibilities:

• Analyzed the data mapping and developed scenarios to verify the data migration from different data sources. Researched various production issues.
• Analyze the client data and business terms from a data quality and integrity perspective.
• Perform root cause analysis on smaller self-contained data analysis tasks that are related to assigned data processes.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
• Develop and run ad hoc data queries from multiple database types to identify system of records, data inconsistencies, and data quality issues.
• Involved in translating the business requirements into data requirements across different systems.
• Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Wrote SQL Stored Procedures and Views, and coordinate and perform in-depth testing of new and existing systems.
• Provided support to Data Architect and Data Modeler in Designing and Implementing Databases for MDM using ERWIN Data Modeler Tool and MS Access.
• Worked with Data Modeling team to create Logical/Physical models for Enterprise Data Warehouse.
• Reviewed normalized/Denormalization schemas for effective and optimum performance tuning queries and data validations in OLTP and OLAP environments.
• Identified the database tables for defining the queries for the reports using SSRS.
• Exploited power of Teradata to solve complex business problems by data analysis on a large set of data.
• Built Fast Load and Fast Export scripts to load data into Teradata and extract data from Teradata.
• Familiar with using Set, Multiset, Derived, Volatile and Global Temporary tables in Teradata for larger Adhoc SQL requests.
• Efficient in process modeling using Erwin in both forward and reverse engineering cases.
• Experienced in conducting JAD Sessions.
• Involved with pre-migration testing including verifying the scope of source systems, verifying the destination systems, test the fields that uniquely link source and target records and ensure that there is a definitive mapping and test source and target system connections from migration platform.
• Involved with end 2 end data migration project.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Participate in weekly meeting with the management team and walkthroughs.
• Attended meetings with the Business Team, and Build Teams to gather the information about the project and the design methodology and the testing requirements
• Lead the team in offshore to do spec reviews, test case writing, running tests, logging bugs, and communicating issues. Got hands on when / where needed.

Environment: XML, MS Office, VBA Excel 2013, Access, SSRS SQL Server 2008, Erwin 9, Infosphere Data Architect, MS SQL Server 2008, Agile, Oracle 11g (SQL, PL/SQL), Teradata 12.0, TOAD, MS Access, XML Spy 2010, QTP 9.2,Data Stage, Business Objects, C++, XML, Test Director, J2EE, SAP

Data Analyst

Responsibilities:

• Prepared the test plan, test strategy and test case documents with the help of CA, PD, DD, other supporting documents.
• Attended walkthrough meetings with the Business Leaders, Analysts, SMEs and DEV team to get a clear understanding of the business and the applications being used in house.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Validated the source data coming from various databases using complex SQL queries.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Validated the XML files sent by Acquirers and made sure the File gets loaded/rejected at the appropriate situations
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity
• Transferred files via OFD to IRS for TIN-Matching of the Merchants.
• Validated the internal Lookups created by Data stage are being created as expected on a daily basis
• Worked on Web Services graphs, where the real time requests comes in and made sure the response is being sent back utilizing Soap UI
• Performed white box testing on various Data Stage jobs using TIVOLI work scheduler and made sure the functionality is working as expected and communicated the findings if any Via DEV-QA work shops
• Validated the data being successfully transformed from XML/Flat files/Pipe - Delimited/.dat files are being loaded into the staging area as expected .
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Logged defects using IBM Rational Clear Quest, linked defects with requirements and generated Defect Reports in QC10.0.
• Participated in change review meetings and suggested on the testability of the CRs.
• Worked with other members of the QA and Development teams and managed efforts with offshore team in improving the processes, methods, effectiveness and efficiency.
• Attended daily status call with Offshore/Onshore leads to review assigned tasks and solve any impediments.
• Used TOAD for Oracle for Querying source Database.
• System was implemented using Ab-Initio and the Warehouse in Teradata
• Performed Report Testing using Micro strategy by writing SQL queries to validate the data on the report and compare with the DWH data.
• Participated in walkthrough and defect report meetings periodically with Onsite/Offshore Developers.
• Ran the Abinitio Jobs from the backend using UNIX
• Involved in testing of multiple applications with QA, SIT, END-END and UAT testing by documenting, reviewing, resolving defects, follow up with interface sign-off.
• Written Test Results and Test finding documents once the QA life cycle has been completed
• Documented and reported various bugs during the Testing process.
• Written SQL Queries to define identify and validate the code written for the data movement into the database tables, fine-tuned the queries for better performance
• Retesting the resolved defects/issues after the developers fix the defects.
• Involved in preparing test data/ Test script for UAT and participated in UAT signoff
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly.

Environment: Data Stage, Oracle 8i/9i/10G, Sybase, Teradata V2R5/V2R6 Teradata SQL Assistant, SQL Server 2000, Flat files, PL/SQL, TOAD 8.0, SQL, ALM/HP Quality Center, ERP, SAP Conversion, R/3, ABAP,UNIX, Maestro 8.0 (Tivoli Work Scheduler), Charm, Remedy, Test Director/Quality Center, SUN SOLARIS, Power Connect, PowerAnalyzer4.1, synapse

QA SQL Tester

Responsibilities:

• Worked with Data Source team to understand the source data.
• Created test plan and test cases for manual and automated testing from the business requirements to match the project's initiatives.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify my test cases.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Reviewed ETL Jobs and test cases before delivering to Client.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Executed the Test Scripts in TOAD and documented the results in RTM
• Worked on Mercury Quality Center and updated defects status with appropriate information.
• Worked on Version Control Tool for Migrating code from one environment to another environment.
• Actively involved in Review meetings and walkthroughs.
• Perform black box testing by designing and constructing test cases, test data and test execution. Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Guide, train and support teammates in testing processes, procedures, analysis and quality control of data, utilizing past experience and training in Oracle, SQL, Unix and relational databases.
• Maintained Excel workbooks, such as development of pivot tables, exporting data from external SQL databases, producing reports and updating spreadsheet information.
• Created cases for settlement claims analysts by printing documents from a website that maintains information, regarding settlement claim data, compiled documents and updated settlement claim data into database system
• Deleted users from cost centers, deleted users authority to grant certain monetary amounts to certain departments, deleted certain cost centers and profit centers from database
• Load new or modified data into back-end Oracle database.
• 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.

Environment: Ab Initio (GDE 1.15, Co > OP 2.15), UNIX, Shell Scripting, XML, XSD, XSLT, XML Spy, Sybase 12.3, IBM AIX 5.2, SQL *Loader, Cognos 7.0 Suite, Oracle8i/9i, PL/SQL, C++, Sybase, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD 7.

Data Quality Analyst

Responsibilities:

• Involved in Data Validation using SQL queries.
• Performed negative testing, to make sure validations are done properly.
• Provide update to management on testing status and some other issues.
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing
• Reviewed Data Stage Jobs and test cases before delivering to Client.
• Involved in Data Validation with Business Team.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Was involved in design part for Extracting data from different source systems into the target database using Data stage Server 6.1.
• Extensively involved in Extracting, Transformation and Loading of data to target oracle warehouse database.
• Was responsible for Creating Job, Job Sequencers and Shared Containers.
• Extensively developed and deployed Unix Shell scripts as wrappers that build runtime parameters to DataStage jobs.
• Validated several Business Objects reports. Reviewed and tested business requests for data and data usage.
• Validated Business Objects dashboard reports by writing several complex SQL queries based on reporting logic.
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Review the test cases written based on the Change Request document.

Environment: Data stage Server 6.x, Oracle 9i, Business Objects 5.0, C++, UNIX, IBM AIX 5.0, Test Director, and Shell Scripting