PROFESSIONAL SUMMARY:

• 8 - Years of IT experience in Data Analysis/QA Testing/ Batch Testing/ETL/DWH/ TDM/ BI-Reports Testing & Testing of Software systems in Data Warehouse/ Business Intelligence/ Client-Server/Oracle and Web-based environments in Windows and UNIX platforms.
• Worked extensively on UNIX environment to execute the shell scripts.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables
• I have worked primarily in the domain of Telecom and I have Experience in Remedy applications and Manual Testing of Web based, CRM, OBRM application.
• Hands on experience in analyzing Business Requirement, Functional Requirement, Design specification and developing Test plan and Test scenarios.
• Hand on experience in Functional testing, Integration testing, System testing, Regression testing and End to End testing.
• Experience in financial application testing such as Insurance, Banking, Health and web applications integrated with various legacy systems.
• Extensive experience in testing methods including Waterfall, Agile and Scrum.
• Expertise in creating/developing Test cases, Test scenarios using standard and modular approach.
• Involved in setting up of Test bed for the End to End Test Execution by coordinating with Various Teams (Eg: Billing Systems, ESP team, Database and CRM system).
• Experience in working as a single point of contact for all testing activities and as liaison between the different teams members and the manager.
• Experience in testing of Data Warehouse/ETL Applications developed in Informatica, Data stage using SQL Server, Oracle, DB2, and UNIX. Ability to evaluate ETL/BI specifications and processes.
• Expertise in writing simple and complex SQL queries using TOAD, SQL Navigator.
• Experience in writing test cases/ test scripts for Inbound and Outbound ETL processes and interfaces with other systems and streams.
• Experience in testing/validating the Source, Stage and Target (End-to-End) data systems.
• Experience in analyzing the error caused to failure of the ETL load with to the log file and report them to the corresponding team to get it rectified.
• Familiar in working with Quality Center to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements.
• Expertise in Defect Tracking, Defect management and Bug Reporting using tools like Clear Quest, ALM, Quality Center.
• Experience in testing/validation of Actuate reports, Business standard and ad hock reports.
• Have knowledge on Web/.NET/JAVA technology - Knowledge on the phases of agile methodology and scrum Methodology.

TECHNICAL SKILLS:

Tools: Putty, Text Pad, CompareIT, Remedy, CRM, WinSCP

Databases: Oracle 8i/9i/10g/11g, DB2, Teradata V2R6/V2R5, SQL Server 2012/2008

ETL Tools: Informatica Power Center, MDM, Ab Initio, Data Stage, SSIS

Operating System: Windows, UNIX (Solaris)

Scripting: UNIX Shell Scripting, PL/SQL scripts

RDBMS Load Tools: SQL Developer, SQL * Plus (Oracle), T-SQL (SQL Server)

Reporting Tools: Business Objects, Cognos, Micro Strategy, SSRS, SSAS

Database Tools: TOAD, SQL Developer, Rapid SQL

Languages: Java, SQL, PL/SQL, T-SQL

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

QA Analyst | UAT | ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, and data mapping requirement specifications interacting with client, developers and QA team.
• Used HP ALM - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Performed validation tests to ensure that the developed functionality meets the specifications prior to UAT testing and Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Drafted complex SQL queries and perform allocation testing from front end/ user interface
• Extensively written SQL for ETL and Reporting Testing.
• Worked extensively on UNIX environment to execute the shell scripts.
• Executed the UNIX shell scripts that invoked SQL loader to load data into tables.
• Reviewed Error log files in UNIX box when order fails to load into SQL tables
• Validate the responses of web services by passing various requests using soap UI.
• Performed Web Services testing and Validated XML request/response data using SOAPUI
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Packages
• Performed the data validation once the Batch Job execution is completed
• TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Executed Informatica Workflows from UNIX using the shell scripts.
• Tested the created Informatica packages to transfer data from various sources like Oracle, Db2, MS Access, Excel, Flat files
• Conducted Load testing using SOAPUI tool.
• Generated reports using SOAPUI.
• Validated several UNIX scripts for invoking data reconciliation
• To verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Extensively used AUTOSYS to schedule the jobs and run the scheduled jobs at specific time.
• Involved in testing the UI applications.
• Extensively involved with backend testing by writing complex SQL queries.
• Testing of records with logical delete using flags.

Environment: Informatica, Oracle, Autosys, MDM, HP ALM, T-SQL, SQL, TOAD, Agile, Flat Files, UNIX Shell Scripting

Confidential, Minneapolis, MN

QA Analyst | ETL Tester

Responsibilities:

• Involved in various meeting like project kick-off, project planning, weekly & monthly client status meetings.
• Involved in writing and reviewing the test scripts.
• Experienced in Batch Processing & EDI interfaces in healthcare domain.
• Involved in gathering Functional Requirements, Business Requirements and Design Documents.
• Developed detailed Test Cases based on the Functional Requirements and Design Documents.
• Identified the test data to execute the test cases.
• Performed Functionality, Negative, Security, GUI, Integration, System and Database testing.
• Tested the entire ETL logic using Informatica to enable initial load and incremental processing from SQL Server and Oracle, error strategy and exception handling, restart ability and recovery, data cleanup, validation and monitoring.
• Compared and Tested Source data.
• Extensively used Informatica Workflow Manager to run the workflows.
• Monitored the session logs/log files in Informatica Workflow Monitor.
• Tested the ETL Informatica mappings and other ETL Processes (DW Testing).
• Validated OBIEE Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Validate for data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Worked as a data centric tester for Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis and also data mapping.
• Experience testing Transaction processing system for End Users during UAT and ensuring that payments made and received were calculated based on all the Business rules.
• Validated different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Validated Query Prompts as, Cascading Prompts, Calculations and Conditions & Filters.
• Analyzed and tested Informatica Mappings with OLTP source data, staging and target data.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Reported bugs and tracked defects using Quality Center and developed the Test Scripts and Test Cases in Quality Center.
• Setting up of Test bed for the End to End Test Execution by coordinating with Various Teams (Eg: Billing Systems, ESP team, Database and CRM system).
• End to End Testing involving verification of back end systems like Database testing(SQL server), CRM (clarify) and Biller systems (CSG, DDP, Saville), Other Integrated Systems (BFC,TPP,TTS)
• Error handling and performance tuning in Teradata queries and utilities. Data reconciliation in various source systems and in Teradata.
• Extensively used SQL to verify and validate the data loaded into Target
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Preparing and supporting the QA test environments.

Environment: Informatica Power Center 9.5, Oracle 11g, HP ALM 11, SQL Server 2012, SQL Developer, Teradata, OBIEE, ALM, AS/400, Cognos 10, XML, PL/SQL, SQL, WinSCP, Putty, MDM, TFS, UNIX, Toad, SharePoint, CRM, Windows Office

Confidential, Chicago, IL

QA Analyst | Data Warehouse MDM Tester

Responsibilities:

• Written 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.
• Extensively involved in testing the ETL process of data sources, SAP Sybase, SQL Server, Oracle, flat files into the target Sybase, Oracle database as per the data models.
• Experience in testing Enterprise Data Warehouses using Informatica Power Center DVO.
• Experienced in configuring, backing up and recovering all EDI transactions.
• Tested SSIS packages according to business requirements and data mapping requirement documents.
• Obtained detailed understanding of data sources, Flat files & Complex Data Schemas in order to write the best test scripts.
• Performed Cross browser ADA Testing using NVDA Screen reader, JAWS, Voice Over, Talk Back in Windows/MAC/Mobile Devices(Android, IOS) to meet WCAG and Section 508 - Accessibility Compliance tool guidelines .
• Responsible to meet the W3C WCAG 2.0 standards as well as compliance with ADA, Section-508
• Worked as a data centric tester for Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis and also data mapping.
• Tested & developed the mapping for extracting, cleansing, transforming, integrating & loading data using Autosys.
• Experienced in data analysis using SQL, TSQL, PL/SQL and many other queries based applications.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Reported bugs and tracked defects using Clear Quest.
• Extensively used SQL to verify and validate the data loaded into Target.
• Validated the front end reporting components created using OBIEE Reports as well as performed back end testing, making sure that the correct data for a specific report are being pulled out from the Data Warehouse.
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Used SQL for Querying the database for data validation, data verification and data conditioning.
• Writing the test scripts, test cases & test plan for multiple ETL Feeds.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, Backend Testing, End to End testing and Regression Testing.
• Involved in Preparing and supporting the QA test environments.

Environment: : SQL Server 2008, Oracle 11g, OBIEE, Sybase 15.1, XML, XSLT, XSLD, Flat Files, MS Excel, SQL, TSQL, PL/SQL, SSIS, SSRS, SSAS, Toad, Clear Quest, .Net, MDM, C#, Windows, UNIX, Section 508 - Accessibility Compliance tool, Clear Case, Quality Center

Confidential, Plano, TX

ETL Tester | Data Analyst | Web Tester

Responsibilities:

• Involved in complete project software development life cycle (SDLC) and Quality Assurance Life Cycle (QALC).
• Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets.
• Experience in testing Web Based and Client Server (Facets, Healthcare Payer Application) applications on different platforms.
• Validating the data passed to downstream systems.
• Used data stage director to run the jobs and check the log files.
• Validated SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Validated the data from front end web applications coming to back end tables and the data from tables shown on the front end.
• Exclusively used Analysis Studio and Report Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed, Drill down.
• Validated Multi-Dimensional cubes using Power Play transformer.
• Validated Query Prompts, Cascading Prompts, Calculations, and Conditions & Filters.
• Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Analyzed Business Requirements and Developed the Test Scripts and Test Cases.
• Used Quality Center for Bug Reports and Defect Tracking.
• Performed Risk Analysis based on Defect Severity and Priority.
• Tested User Interface inconsistency and application functionality.
• Worked on issues with migration from development to testing.
• Tested application in various browsers.

Environment: Data Stage, DB2, Oracle 10g, XML, HIPAA, Cognos Power Play Transformer 8.3, EDIX12N 4010, Flat Files, MS Excel, Teradata, SQL, TSQL, PL/SQL, SQL Server 2008/2005, SSIS, SSRS, Toad, Clear Quest, .Net, C#, Quality Center, Windows, UNIX

Confidential, Dallas, TX

DWH / ETL Tester

Responsibilities:

• Validated SQL and stored procedures for the data warehousing application projects.
• Documented business requirements by facilitating sessions between business and technical team.
• Involved in systems design and implementation of standardized business processes.
• Generated and compiled reports based on findings with probable causes and possible solutions to systems issues.
• Extensively used Joins in order to get records from different tables.
• Validated Triggers that are implemented to enforce Integrity constraints, Cursors for data extraction and to carry out updates of new fields, and exceptions for run-time error handling.
• Validated Informatica workflows and mappings against the requirements.
• Involved in maintaining and first level troubleshooting of the database.
• Ensured accurate data transfer from sources into the newly designed system.
• Validated PL/SQL stored Procedures used for customers placing regular orders.
• Consulted with users and stakeholders to ensure that requirements are met.
• Familiarized with software development lifecycle and configuration management.

Environment: Informatica, Oracle 8i, SQL Server 2003, SQL, PL/SQL, Windows XP, MS Office Suite, Test Director