SUMMARY

• 7+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile
• Experience in Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining
• Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results
• Responsible for defect tracking, defect reporting and defect reproducing
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse
• Involved in the Performance Tuning of the Data Stage jobs using different methodologies like configurations of the environment variable file, designing and editing configurations
• Experience in analyzing the error caused to failure of theETLload with reference to the log file and report them to the corresponding team to get it rectified
• Familiar in working with Quality Center/ ALM to store Business Requirements, Test Cases, Test Runs, and Test Results for every iteration and store defects and link them back to the requirements
• Experience in End - to-End testing of an application/process. Performed backend testing using SQL Queries and UNIX scripting

TECHNICAL SKILLS

Data Warehousing: Informatica, Data Stage, Ab initio, SSIS

Reporting Tools: Cognos Suite, Business Object XI, Crystal Reports, OBIEE, SSRS, Microstrategy, Tableau

Data Modelling: Star-Schema Modelling, Snowflake-Schema Modelling, Fact and dimension tables, Pivot Tables, Erwin

Testing Tools: HP ALM/QC, Jira, Win Runner, Load Runner, Test Director, Quality center, Rational Tools

RDBMS: Oracle, MS SQL Server, UDB DB2, Sybase, Teradata V2R6, MS Access

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

Environment: UNIX, MVS, IBM AIX, Hyperion, Win, NT

Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

ETL QA SQL Tester

Responsibilities:

• Analysed and created new DQ rules using Informatica, introducing new features, coordinating software upgrades, and migrating existing procedures.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• I have used Hadoop commands to see the list of files, to take counts of the HDFS files
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle and Fast Export to extract, transform and load the Teradata
• Checking the status ofETLjobs in UNIX and tailing the log files while the loading is under processing.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Worked with business team to test the reports developed in Cognos
• Performed back-end testing, table manipulations of relational systems by writing complex SQL queries manually
• Worked with Unix for file manipulations, text processing, data parsing and Converted SQL queries results into Unix variable
• Monitored the Informatica workflows using Power Centre monitor. Checked session logs in case of aborted/failed sessions.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Reported bugs and tracked defects using Quality Center/ALM
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Environment: Informatica, Cognos, SQL, Agile, Quality center/HP ALM, Teradata, Oracle, XML, XSD, MS SQL, Hadoop/Big Data, UNIX.

Confidential, Cleveland, OH

ETL BI SQL Tester

Responsibilities:

• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Managed and executed the test process, using Agile Methodology.
• Wrote extensive SQL and PL/SQL Scripts for creating stored procedures in Oracle
• Analysed and created new DQ rules using Informatica, introducing new features, coordinating software upgrades, and migrating existing procedures.
• Completed several in-house training courses such as Elastic search, Hadoop, Hive, Spark and to learn about applications that sources data to the Warranty Cost Recovery system
• Written complex SQL queries
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• The reports that were created in Business Objects were testing by running the SQL statements
• Data is pushed to Hadoop Data Lake using Hadoop stack tools and will be exported to downstream business systems for analysis
• Used predefined UNIX scripts for file transfer and file manipulation as part of Test Data preparation.
• Performed InformaticaETLtesting to validate end-to-end data from source system MS SQL Server and Target system environment.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region for data validation.
• Validate Sqoop data from Oracle to generate reports by BI
• Involved in all phases of the STLC, with timely delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, etc.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Validating maps on Informatica to verify data from Source to Target data base & record test results
• Strong technical Knowledge of UNIX Utilities, shell Script to automate process.

Environment: Informatica, Cognos, SQL, Agile, Quality center/HP ALM, Teradata, Oracle, XML, XSD, MS SQL, Hadoop/Big Data, UNIX.

Confidential, Worcester, MA

ETL Tester

Responsibilities:

• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.Written complex SQL queries for each level of data validation.
• Used JIRA for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• JIRA used for project tracking and bug tracking
• Wrote complex SQL scripts in DB2 for testing data quality and validation
• Involved in Oracle, Unit Testing and Performance Tuning.
• Create Data Stage Parallel Jobs to extract, transformation and loading of the data using Data Stage Design toll in the parallel processing mode
• Working in Agile environment attend daily stand up, sprint planning, backlog grooming refinement and retrospective meeting.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Performed extensive Database Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application
• Extensively usedETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETLSolution usingETLtool like Data Stage
• Written SQL scripts to test the mappings and extensively used Cognos for report generation
• Strong in writing complex SQL queries to profile and analyse the data in Oracle

Environment: Data Stage, Cognos, SQL, Agile, DB2, Oracle, XML, XSD, MS SQL, Jira, XSD.

Confidential

DWH Tester

Responsibilities:

• Validating maps on Informatica to verify data from Source to Target data base & record test results
• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal
• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.
• Extraction of test data from tables and loading of data into SQL tables.
• Tested Informatica mappings. Performed data validations against Data Warehouse
• Distributed the reports to the users via Cognos Connection
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Involved in full life cycle Testing ofETLData warehouse and reporting environment

Environment: Informatica, Cognos, SQL, Quality center/HP ALM, Oracle, XML, XSD, MS SQL, XSD.