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.
• 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 wif technologies like WSDL,SOAP, SOAP UI, XML, XPath and Web Services.
• Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
• TEMPHas 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.
• 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 experience in Cognos & Business Objects Reports testing
• Good analytical and problem-solving skills.
• Team player wif excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Team oriented and ability to understand and adapt to new technologies and environments faster. Good Confidential 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, SSRS, COGNOS, TABLEAU, POWER BI.

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, JIRA

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

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

Web Technologies: JavaScript, HTML, and DHTML.

PROFESSIONAL EXPERIENCE

Confidential

ETL QA Tester

Responsibilities:

• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Experience in data visualization tools like Tableau.
• Deployment of Teradata packages in QA environment using CCID tool viz, Jenkins. prepared the automated email system to send mail to user, using an SQL Server SP Mail Sorted port.
• Experience in data warehousing / ETL testing wifin the environment of Oracle.
• Comparing the results of traditional system to Hadoop environment to identify any difference and fix them by finding the root cause.
• Managed and executed the test process, using agile methodology.
• Participated in scrum meetings to ensure dat the business rules have been addressed properly.
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Wrote and modified required UNIX scripts to validate the Outputs.
• Created and managed issues through JIRA tracking tool.
• Raised and tracked defects in JIRA and shared defect report to my manager and all the key stake holders.
• As a member of the Scrum team participated in daily standup meetings, project status meeting and iteration reviews.
• Participated in defining and executing test strategies using agile methodology.
• Responsible for validation of target data in Data Warehouse and data marts which are transformed and loaded using Hadoop Bigdata.
• Hands on experience in writing functions in Oracle.
• Wrote SQL queries in Toad and SQL server management studio 2008 to validate the source and target systems.
• Consumed JSON messages and processed to Teradata & OHL system.
• Connected Tableau server to publish dashboards to a central location.
• Tested the ETL Informatica mapping and other ETL Processes (DATA WAREHOUSE TESTING).

ENVIRONMENT: SKILLS: Informatica, Tableau, Teradata, SQL Server, Oracle, Hadoop, Agile, Jira, scrum, Unix.

Confidential, BALTIMORE, MD

ETL QA Tester

Responsibilities:

• Used TOAD software for Querying ORACLE and Used Win SQL for Querying DB2.Used visual studio team foundation server to monitor work, code, build and test phases of the team.
• Involved in ETL process testing using Informatica.
• Created and maintained confluence reference pages around analyst processes, the Jira SQL schema and Power BI report updating and use.
• Tested the reports generated by SQL Server reporting services and checked as they are as per the Organization standards.
• Responsible for managing and reviewing Hadoop log files.
• Writing UNIX scripts to perform certain tasks and assisting developers wif problems and sql optimization.
• Created complex queries views and materialized views in Netezza.
• Created store procedures in Netezza using NZ sql.
• Analyzed, troubleshot and resolved problems using shell scripting using UNIX shell script.
• Updated the tasks from to-do- to done in TFS as sprint progresses every day.
• Analyzed data using Hadoop components Hive and Pig.
• Tested the Oracle Applications and Portals like Executive Dashboard, drill down, summary reports, portal built on Oracle.
• Advanced extensible reporting skills using SQL Server 2008.
• Responsible for Database (SQL) testing, performing functional, system, testing for major Power BI Gateway releases.
• Supported the extraction, transformation, and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.

ENVIRONMENT: SKILLS: Informatica, Power Bi, SQL, Oracle, Hadoop, TFS, Unix, Netezza.

Confidential, Pittsburg, PA

DWH/QA BI Tester

Responsibilities:

• Involved in Requirement Gathering for the General Ledger (GL), Accounts Payable (AP), Account Receivables (AR) Reports.
• Worked wif developers, SME’s and Business Analysts to understands the system procurements, Business workflow and Delivery applications
• Involved in Meetings wif 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.
• 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 usingALM\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.
• Worked on programs for scheduling Data loading and transformations using DataStage from DB2 to Oracle 9i using SQL* Loader and PL/SQL.
• Extensively used DataStage for extracting, transforming and loading databases from sources including Oracle, DB2 and Flat files.
• 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.
• Worked wif DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• 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 wifin agreed upon time, cost and quality parameters
• Proactively managed and highlighted risks and provided mitigations
• Contributed QA tasks to the project plans dat meet overall project objectives and timelines.

Environment: DataStage, HP ALM, SQL Server, Control-M, UNIX, Share Point, OBIEE, ALM/HP Quality Center.

Confidential, Alpharetta, GA

ETL QA Tester

Responsibilities:

• 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. Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Testeddata warehouseETLprocess using SSIS Integration Service.
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif 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. Produced operational reports in SSRS me.e., drill-down, drill-through, dashboard and matrix reports. Responsible for ETL through SSIS and loading Data to DB from different input sources.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Worked wif non-transactional data entities for multiple feeds of reference data using Master Data Management
• Identifying the Test Cases to be automated and developed automation test scripts using Selenium Web
• Performed Web Service testing using HP-Service 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.
• Tested all formats ofSSRSreports includingExcel, PDF, CSV, XML, TIFFand many other.
• TestedOLAP cubesandSSRSreports for various business needs.
• Extensively used Teradata load utilities Fast load, Multiload and Fast-Export to extract, transform and load the Teradata data warehouse
• Worked wif Data Conversion projects for testing data quality after migration.
• Responsible for different Data mapping activities from Source systems to Teradata
• Queried Teradata Database and validated the data using SQL Assistant.
• Worked on issues wif migration from development to testing.
• Worked on issues wif 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 dat the job fails on any critical error.
• Written test cases and completed unit test documentation.

Environment: SSIS, XML, XSD, UNIX, Teradata,SOAP, SOAP UI, Teradata SQL Assistant, Selenium, SSRS, SQL, PL/SQL, Oracle, DB2, T-SQL, TOAD, Quality Center.