SUMMARY:

Working with different tools and applications SoapUI v5.2.1, EL4FMS, EIP and SAP Bo and Tableau dashboard V10.1, Informatica Power Center 9.5.

TECHNICAL SKILLS:

Testing Tools: QC (Quality Center) ALM (Application Lifecycle Management) QTP (Quick Test Pro) UFT (Unified Functional Test) OBIEE, BI Publisher, Extensively working on data validation testing Source to Target, Columns, Cardinality and joins.

Languages: Java, SQL, PL/SQL, HTML5, XHTML, C, C++ C#, ORACLE, MSSDB, MS - SQL Server2008.

Version Control: File Zilla- SFTP, JIRA V7.2, Clear Case, SharePoint, Visual Source Safe, ALM (Application Lifecycle Management), Quality Center (QC).

ETL Tools: PDI (Pentaho Data Integrator), Informatica Power Center 7.1.4 / 8.6.1, ODI, KETTLE

Oracle Business Intelligence: OBIEE 11.1.1.7.1/ 10.1.3.4.1 , BI Publisher, ODI, OBIA, Siebel Business Analytics 7.8.

Internet Technologies: J2EE, JSP, XML, HTML, DHTML, XHTML, Perl, UML, Junit

Version Control Tools: Jira, Clear Case, SharePoint, Visual Source Safe, Quality Control (QC)

Operating System: Windows10, XP, Professional, Firefox, Windows vista, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

DW ETL/QUALITY ANALYST

Confidential

Responsibilities:

• Extensively worked in backend activities for testing DW. Helping with reports developed by BI tools. Wrote several complex SQL queries/scripts for the data validations.
• Involved and creating test Plan documents, test cases, schedules reports and test strategies in accordance with project scope.
• Working extensively on EDW projects and Datawarehouse, writing ETL test cases and test plan documents, writing test cases for SOLAR API, EL4FMS, EIP, SOAPUI and SAP BO.
• Prepare and execute test cases, Regression Testing Scenarios.
• Working with heavy join, writing complex query, aliases, Create view
• Involved in 508 compliance testing. Color identification for tableau and Eip integration part legend of color for 508 compliance testing.
• Work with client to review test plans to verify adequate coverage of business processes and to ensure the business requirements are satisfied by the system
• Create and maintain requirements traceability matrices
• Review design documents. Test applications and document results.
• Write SQL queries to both gather and assess test data.
• Working very closely with business analyst and developers. Testing applications in Different environments DEV, SIT, FQT, PVT, PROD and User accepting testing for the Business Objects.
• Working on user’s story to create test plan document, and execute test cases. Excellent written and verbal skills to create test scenarios and/or scripts; document test results; and communicate issues to the development team while also identifying possible solutions and/or workarounds for problems.

DWETL /Tester

Confidential

Responsibilities:

• Working individually and team take responsibility, work hard, learn, and become a key contributor to a team. Teste assigned to support one or more ongoing Agile Scrum teams.
• Involved in writing test Plan documents, test cases, schedules reports and test strategies in accordance with project scope.
• Prepare and execute test cases, Regression Testing Scenarios.­­­­
• Working with heavy join, writing complex query, aliases, Create view
• Working with creating Requirements traceability Metrix, Test Plan, Test Case, Execute the test case, Defect creating, Reporting defect
• Working very closely with other team member’s developer, and reports run by weekly and daily, monthly as a primary backup and primary responsibility.
• Reviews software documentation to ensure technical accuracy, compliance, and completeness to mitigate any business risks
• Extensively working with different environments in DW/ETL Unite test, Black box, SIT, FQT, PVT, PROD.
• Involved in Analyzing Business Requirements, High-Level Designing and Detail Technical and Functional requirements Design of ETL application.

ETL /BI Quality Engineer

Confidential

Responsibilities:

• Working with archive tax reporting system state of Oregon using Pentaho 5.0.1.1. Enterprise edition as well as community edition
• Re-engineer some of the current ETL processes to streamline the data acquisition and integration process using PDI (Pentaho Data Integration) Kettle, Spoon
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design and leveling other Data Warehouse concepts
• Implemented end to end ETL development using PDI Data Loading tool and customized OBIA mappings
• Successfully customized and designed OBIA Case Management Analytics application by adding dimensions facts etc.
• Implemented Core Dimension modeling, hierarchy design, derived measures, level-based measures, Aggregates, Ad-hoc analysis design etc. in OBIEE RPD
• Extensively used PDI to extract, transform data from different source systems and load the data into the Target database
• Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner transformation, Stored Procedure, and Router transformation.
• Developed OBIEE analytical reports and designed dashboards
• Integrated IDM with OBIEE and implemented SSO with Siebel
• Implemented role based Security in OBIEE Application
• SCD Type 2 was successfully implemented in order to develop Trended analytical reports
• Involved in tuning of the mappings and SQL queries
• Responsible for Performance Tuning of sources, targets, mappings, and sessions
• Code promotion to Integration and UAT and Production environments
• Involved in conducting reviews for the codes after development
• Developed around 100 transactional reports including multilingual using BI Publisher

OBIEE /ETL

Confidential

Responsibilities:

• Upgrade the existing OBIEE application from 10g to 11.1.1.7.1. Used Informatica for the ETL Process
• Working with SCD Type 2 and SCD Type 1 was successfully implemented in order to develop Trended analytical reports
• Upgrade the Informatica from 8.6 to 9.1.0 and DAC from 10g to 11g
• Analysis of existing dashboards/analyses and fix any defects that might arise due to upgrade
• Analysis and resolution of defects in Informatica mappings and DAC ETL load scheduler
• Configure DAC Tasks as per Informatica mappings
• Modify OBIEE RPD to in corporate changes as per the new OBIEE version
• Involved in gathering and Analyzing Business Requirements, High-Level Designing and Detail Technical Design of ETL application
• Developed SQL Script and library functions to verify UI against the database
• Validated the code with design document
• Experience in development rpd using OBIEE
• Extensively worked with backend activities for testing several reports developed by BI tools. Wrote several complex SQL queries
• Experience in Informatica Lifecycle Management (ILM)
• Plan test schedules and test strategies in accordance with project scope
• Support team in resolving scope and testing issues
• Coordinate with teams (onsite and offshore) to make sure deliverables are completed on time with quality

QA and BA

Confidential

Responsibilities:

• Planning, gathering requirements, review meetings to address any issues or action requires validating requirements
• Working with very closely with all other teams in the project regarding the issues in 1095A and defect tracking issue solving
• Attend meeting with solving the new issues and for the new deliverables on the process and the ETA deadline for that
• Reviews software documentation to ensure technical accuracy, compliance, and completeness to mitigate any business risks
• Prepare and executed the Regression Testing Scenarios. Used File Zilla for the secure file transfer protocol
• Performed Functional and Integration testing of the application and prioritized test cases to meet project specific deadlines
• Involved in developing Test Plan for application
• Worked on Logging bugs in the ALM tracking tool
• Reported the bugs, Email notifications to the developers using the ALM and Monitored ALM
• Involved in preparing detailed and reviewed Test cases to cover all the requirements
• Strong knowledge of Entity-Relationship concept, Facts, and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema)
• Involved in functional testing and verify the application according to the user perspective
• Involved in onsite offshore coordination for DEV, PreProd, UAT testing phases
• Reviewed Business Requirement Documents and Functional Specification Documents.

QA and BA

Confidential

Responsibilities:

• Working with manual testing creating defects and send the defects to the developer resolved the issues and bugs
• Writing test case in QC and test case review and attend TCR meeting, test case pear review. Worked on UI functionality and using SOAP UI
• Working with SQL Oracle in DDL (Data Definition Language) Like as Create, Alter, Drop, Rename, Modify, Add, and Truncate
• Reported the bugs, Email notifications to the developers using the QC
• Working with heavy join, writing complex query, aliases, Create view
• Working with QC and Creating Requirements, Test Plan, Test Case, Execute the test case, Defect creating, Reporting defect
• Uploading Requirement, test case, defect from excel to QC
• Making RTM link the test case with the requirement, test resources, and library
• Working with automation tools QTP and VB script programming, Descriptive programming, Ordinal identifier, Regular Expression, DIM variables
• Automation Framework, Function, Loop, Actions, Environment Variables, Runtime error handling, Read Excel data into custom QTP data-table using custom script, Built a complete repository reusable keyword functions using descriptive programming
• Test cases and test steps are stored in excel, error report to be exported back to excel.