SUMMARY

• 7 plus years of valuable experience in Information Technology working for diverse domains such as Banking and Financial Services, Insurance, Telecommunication and Pharmaceuticals
• Expertise in Testing of Data Warehousing/Business Intelligence applications and experience in working with EDWs (Teradata, Oracle, DB2, Sybase, SQL Server).
• Extensive experience in testing Reports like dashboards, drill up and drill down, adhoc as well as scheduled.
• Good exposure with writing SQL scripts, complex SQL queries, Testing of Source to target mappings, Testing of BI Reports.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
• Performed Unit, Integration and System Testing.
• Proficient in leading testing projects from inception, requirement specification, planning, designing, configuration management & documentation and post production support.
• Rich onsite exposure of coordinating end to end testing processes, executing projects, interacting with Onsite Testing Lead for removing gap between client expectations & testing capabilities and assisting onsite leads in planning & risk mitigation in critical situations.
• Working Knowledge on all Phases of Software Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and testing methodologies such as V - Model, Agile and Waterfall Model
• Deft in testing methodologies viz. BI - ETL Testing, Report Testing, Manual Testing and Automation testing (QTP), and Database Testing; and completing highly complex test optimization.
• In-depth knowledge of various tools such as ETL Tools: Informatica and Datastage Director; Reporting Tools: Microstrategy, SAP BO, OBIEE; Automation Tools (QTP), Quality Centre (QC) and Basic UNIX commands.
• Team Player with excellent communication, planning, analytical and organizational skills
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica 9.x/ 8.6/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), SSIS, Data Stage

Data Modeling: Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000 , DB2, Teradata, Sybase 12.5, MySQL, Netezza

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI r3/r2/6.x/5.x, SSRS, SSAS, Crystal Reports, OBIEE

Languages: SQL, PL/SQL, XML

Tools: Toad, SQL* Loader, WinSQL, SQL Developer, Teradata SQL Assistant, SQL Plus*

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: HP Quality Center, Bugzilla, Rational Clear Quest

PROFESSIONAL EXPERIENCE

Confidential, Mclean, VA

Sr.ETL/SQL Tester

Responsibilities:

• Reviewed Error log files in UNIX box when order fails to load into SQL tables.
• Having Daily meeting with client for better understanding of requirements and Meet with the off-Shore team and guide them through the execution of all testing.
• Doing Testing that needs to happen in Onsite.
• Review all the test scripts written, approve all Validation Test Scripts and Create reports for Validation activities using HP Quality Center 11
• Worked on all Validation Artifact and documents.
• Written complex SQL queries.
• Tested several reports developed in OBIEE including Dashboards, Interactive Dashboards, Filters, Formulas, Conditional Formats, etc.
• Created several SOA test cases for validations which were based on the behavior of a specific service.
• Tested SOA application interface and communication paths.
• Tested several stored procedures.
• Validating Mapping Specification documents.
• Designed Development, Formal, Audit Trail and Access Delegation Test cases. Designing Column level Test cases.
• Designed Formal Test Cases and executing them as a part Release.
• Designed Reporting Test cases for Functional and Data validation.
• Validated flat files coming from downstream systems and mocked up feed files by using vi editor.
• Performed Backend/SQL Test for Insert, Update, and Functions.
• Automated test cases, for data driven tests and linked test scripts using QTP to perform Regression testing of different application versions.
• Created Test sets using Mercury Quality Center and HP Quality Center.

Environment: Oracle 11g,, OBIEE 10.1.3.2, Crystal Reports XI R2, SQL, Korn Shell Scripting, PL/SQL, T-SQL, Quality Center 11,Informatica 9.5, XML Files, Teradata SQL Assistant 13, SSIS, Ab Initio (GDE 1.15, Co>Op 2.15)

Confidential, Rochester, MN

DWH Analyst

Responsibilities:

• Analyzed and review System, Functional, Technical Requirement Documentations
• Tested the existing Reports with 100% accuracy
• Analyzed the data mapping and developed test scenarios to verify the data migration from different sources.
• Tested various reports extracted from Enterprise Data Warehouse with Business Object including Dashboards, Scorecards, KPI’s Master-Detailed, Summarized
• Validated data in Target database according to business rules
• Analyze data using SQL, Excel, UNIX and data testing tools.
• Verify the implemented ETL code against the corresponding mapping document. Confirm the data loads from source files into the target tables.
• Examine sample record sets for consistency, data corruption and over all data quality.
• Prepared SQL queries and executed to validate the ETL processed data in target database.
• Verifying the column mapping between source and target databases
• Worked closely with Development team for various data issues
• Confirmed that data is parsed, transformed and loaded per business logic in the Oracle data warehouse through the Informatica mappings
• Run the Informatica Workflows for ETL Process
• Prepared and ran SQL queries
• Developed SQL and Stored procedures to achieve the data transformations
• Performed back-end testing on the Oracle database by writing SQL queries
• Tested several UNIX Shell Scripts for job scheduling.
• Performed data profiling on the source databases to check for data inconsistencies
• Imported different source data with DB link into the testing environment for testing
• Executed very complex SQL queries to validate and verify data set per business rules
• Working with Data Analyst’s on the Ambiguities raised during Analysis/Testing Phase.
• Wrote and submitted weekly quality assurance status reports
• Attended and participated in periodic product status meetings

Environment: SQL, PL/SQL, HP QC, Rational Clear Quest, XML files, Flat Files, TOAD, XSD, XML Spy 2013, Informatica 9.x, Putty, WinSQL, DB2, SQL Server 2008, Oracle 10g, Autosys, IBM AIX 6.1

Confidential, Charlotte, NC

DWH/SQL Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for understanding the ETL data mapping document.
• Tested UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Prepared Test Plan for the project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Reported bugs and tracked defects using HP QC.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced and complex 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
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested the ETL process for both before data validation and after data validation process.
• Tested with Front-end functionality for the entire application
• Tested the data load process using the Informatica ETL tool.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Worked with Data Conversion projects for testing data quality after migration.
• Used Teradata SQL Assistant for data retrieval and querying.
• Used MLOAD, FLOAD, and TPUMP & FAST EXPORT for initial and incremental loadings.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Validated documented user requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Used SQL for Querying the DB2 database in UNIX environment
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.
• Tested several data validation graphs developed in Ab Initio environment.

Environment: Ab Initio (GDE 1.15, Co>Op 2.15, EME), Data Profiler, UNIX, Shell Scripting, Teradata 12.0, T-SQL, Teradata SQL Assistant, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, SAS/Base 9.1, SAS/Macros, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, SQL, PL/SQL, Quality Center, Oracle 10g, Cognos Series 8.0, Report Net, Impromptu, Report Studio, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

Confidential, Oakbrook, IL

Backend/SQL/DWH Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested/Found the defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• 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.
• Responsible for testing the reports according to client’s requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested and worked on creating open document reports for business.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select for testing Business Reports with various boundary conditions.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs 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.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), EME, SQL *Loader, Business Objects XIR2, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Windows 2000, TOAD 7.

Confidential, Jersey City, New Jersey

Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Lead team of 6 people in Quality Assurance Team.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica 7.x, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, XML Files