SUMMARY:

• Over 8 years of IT experience in the Analysis, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience using query tools for Oracle, Teradata, Sybase, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Experience in testing and writing SQL and PL/SQL statements.
• Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Worked with technologies like WSDL, SOAP,SOAP UI, XML, XPath and Web Services
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Expertise in Testing complex Business rules by creating mapping and various transformations
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Cognos & Business Objects Reports testing
• 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.
• Good analytical and problem solving skills.
• Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

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

Reporting Tools: MicroStrategy, OBIEE

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, ALM/Quality Center

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

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++ Job Schedulers Auto sys, Maestro, Control - M

Web Technologies: JavaScript, HTML, and DHTML, Java, J2ee

PROFESSIONAL EXPERIENCE:

Confidential, Juno Beach,FL

ETL QA BI Tester

Responsibilities:

• Involved in Requirement Gathering for the General Ledger (GL), Accounts Payable (AP), Account Receivables (AR) Reports.
• Worked with developers, SME’s and Business Analysts to understands the system procurements, Business workflow and Delivery applications
• Involved in Meetings with Test Leads and project consultants to develop the Testing methodology, Detail Execution Plan, Testing Metrics and test integrations plans
• Created test plans and test scenarios for AIT and Smoke testing by analyzing the Business requirements documents.
• Tested the data load process using the Informatica Power Center ETL tool.
• Deeply participated in Integration Testing, Functional testing, Regression testing, End to end testing, Security-level testing and Performance testing in the INT environment.
• Managed test sets and status reports for each release using ALM\HP Quality Center
• Wrote PL/SQL Queries to test and validate the Data warehouse and OBIEE test results.
• Coordinated Business analysts and SME’s for UAT testing in STG environment.
• Tested the OBIEE subject areas AP, GL, ETP AP,ETP GL and AR to fix the defects.
• Involved in testing and validation of Row level Security of the OBIEE and PeopleSoft by using custom roles, Job profiles and permission lists.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested several UNIX Shell Scripts and for connecting to database and for file manipulation of data
• Reported bugs and tracked defects using Quality Center/ALM
• Tested Historical Loads, Daily Data Loads, Data Integration-Metadata and OBIEE Reporting
• Helped and facilitated in Business Process Testing.
• Involved in Ruining and testing the Control-M jobs for Loads in INT and STG environments.
• Contributed and improved QA process, procedures and methodologies
• Managed QA scope to ensure deliverables and achieved within agreed upon time, cost and quality parameters
• Involved in Unit testing and integration testing of Informatica mappings.
• Proactively managed and highlighted risks and provided mitigations
• Contributed QA tasks to the project plans that meet overall project objectives and timelines.

Environment: Peoplesoft Financial 9.2, HP ALM 11.52, Informatica 9.6.1, SQL Developer, SQL Server, Control-M, UNIX, Share Point, ODI, OBIEE, ALM/HP Quality Center

Confidential,Richmond,VA

DWH/QA BI Tester

• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Extract data from Mainframe data sets to compare against Target Values.
• Reported bugs and tracked defects using ALM/Quality Center
• Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
• Figuring out various error handling strategies to be adopted during cross system data migration
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested Informatica mappings for various ETL data conditions and mapping rules.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Strong ability in developing 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
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Created test scripts for the application which uses SOA, Web services, SOAP and WSDL.
• Tested the reports different types of Customized Reports (Drilldown, Aggregation) Created by OBIEE to meet client requirements.
• Ensured data integrity and verified all data modifications and calculations during database migration using ETL tools
• Development of automation Test scripts using Selenium WebDriver framework.
• Help define and track Data Quality and Data Governance metrics for MDM
• Worked with Unix for file manipulations, text processing, data parsing and Converted SQL queries results into Unix variable
• Design, build and test -reports, Dashboards and other functionality within the OBIEE suite.
• Involved in creating source target mappings based on the Technical Design requirements.
• Used different sources for Input.
• Tested XML files using Soap
• Tested data migration to ensure that integrity of data was not compromised.
• Built Automation Framework using Selenium WebDriver
• Performed back-end testing, database table manipulations of relational database systems by writing complex SQL queries manually.
• Performed front-end testing on OBIEE Executive Dashboard portal
• Effectively communicate testing activities and findings in oral and written formats.
• Experience working with Siperian Hub MDM (Master Data management) for customer integration model and tested the same.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.

Environment: ALM/Quality Center 11, SQL, PL/SQL,Informatica 9.1, OBIEE, XML Files, Flat Files, Teradata, Teradata SQL Assistant, UNIX, Oracle, DB2, Selenium, SOAP, SOAP UI,TOAD, Control-M job Scheduler, Shell Scripting

Confidential,Providence,RI

DWH BI Tester

• 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.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• 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
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• 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.
• Identify business rules for data migration and Perform data validations.
• Worked with non-transactional data entities for multiple feeds of reference data using Master Data Management
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Identifying the Test Cases to be automated and developed automation test scripts using Selenium Web
• Extensively tested several OBIEE Reports for data quality, fonts, headers, footers, and cosmetics
• Performed Web Service testing using HPService Test and SOAP UI.
• Performed Pre Migration Assessment, Migration and Post Migration.
• Did source identification, data collection, data manipulation and normalization and rule administration for data consolidation using MDM
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
• Worked with Data Conversion projects for testing data quality after migration.
• Interacted with Users to understand the bugs in Reports generated from OBIEE
• Responsible for different Data mapping activities from Source systems to Teradata
• Queried Teradata Database and validated the data using Sql Assistant.
• Worked on issues with migration from development to testing.
• Worked on issues with migration from development to testing and testing to UAT environments.
• Tested the functionality and performance of web services using SOAP UI.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
• Created different user defined functions for applying appropriate business rules
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Written test cases and completed unit test documentation.

Environment: Informatica 9, XML, XSD, UNIX, Teradata, SOAP ,SOAP UI, Teradata SQL Assistant, Selenium, OBIEE, SQL, PL/SQL, Oracle, DB2, T-SQL, TOAD, Quality Center

Confidential,Madison,WI

DWH/Backend Tester

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Validated various MicroStrategy reports such as ad hoc, grids, graphs.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• 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.
• Extraction of test data from tables and loading of data into SQL tables.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.
• Tested both conditional formatting and threshold level testing for several reports developed in Microstrategy.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• Extensively used MicroStrategy for report generation.
• Involved in Security testing for different LDAP roles.
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informatica, DB2, Java, SQL, Teradata, Teradata SQL Assistant, UNIX, Shell Scripting, WINSQL, Oracle, DB2, SQL Server, XML, Windows XP, Quality Center

Confidential

Database Tester/Analyst

• Created PL/SQL procedures, triggers, views, functions.
• Gathered information about the transaction process, planning and development of the various screens.
• Responsible for designing database tables and writing SQL & PL/SQL procedures, functions.
• Developed various forms (screens) and some complex reports.
• Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
• Written complex SQL queries for each level of data validation.
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.

Environment: Oracle, Visual Café, Rational Rose, Clear Case, Clear Quest, Windows