SUMMARY:

• Around 7+ years of total IT experience and very good knowledge QA of Software Applications and Testing.
• Extensive experience in testing of data warehouse / data marts for business applications with Banking, Financial, Brokerage, Insurance, Pharmaceuticals, Manufacturing.
• Experience in Data Warehousing technology in building and managing various data warehouse / data marts using Informatica products such as Informatica Power Center/Power Mart, Power Connect, Power Analyzer and Power Exchange Tools.
• Expertise in ETL backend and Business Objects Reports testing
• Experienced testing Web Services using SOA, SOAP UI, and REST & Custom Based Approach.
• Experience in using SOAP Sonar for providing simple, intuitive and comprehensive testing for SOAP - , XML- and REST-based services
• Experience in SDLC and Agile methodologies.
• Experience working in using Databases like Oracle, Teradata, SQL Server, DB2, MS Access and DB2. Expertise in Database Programming (Stored Procedures, Triggers, Packages, PL/SQL, Joins) using Oracle.
• Extensive testing ETL experience using Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Extensive experience in Business Intelligence reporting tools using Cognos Series, Power Play, Transformer, Impromptu Web Reports (IWR).
• Extensively used SQL, PLSQL to create complex queries, SQL Override, Stored Procedures, and Triggers.
• Experienced in Data Modeling, Erwin, Star/Snow Flake Schema Designs, Logical Data Modeling, Normalization, Physical Design, Data Analysis, Data Modeling, Reports and Report Design.
• Expertise in writing Unix Shell Scripts.
• Excellent Analytical and Logical Programming skills with a good understanding at the Conceptual Level and possess excellent Presentation, Interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

OS: Sun Solaris 2.7/2.6, IBM AIX 4.3/4.2, MS DOS 6.22, Win NT/2000/98/95.

ETL Tools: Informatica Power Center 9.0/8.x/7.x, (Source Analyzer, Warehouse DesignerTransformation Developer, Mapplet Designer, Mapping Designer, Data stage 7.x

BI Tools: Cognos 8.0 Series, Business Objects, SSAS, Crystal Reports and Siebel Analytics

Languages: SQL, PL/SQL, VB, C, C++, COBOL.

Databases: Oracle 11.6/10g/9i/8i, MS Access, SQL Server 2008, DB2 9.x, Teradata V2R6Other Tools: Erwin 4.5/4.0/3.5.5/3.5.2

Testing Tools: Load Runner 7.8, QTP 8.2, Quality Center 10, and HP ALM 11.0

PROFESSIONAL EXPERIENCE:

Confidential

ETL QA Engineer

Responsibilities:

• Coordinating with (on-site/offshore) in their daily tasks which include project tasks, operations support tasks, and management of application defects and testing.
• Created Test Strategy, developed Test Plan, Detailed Test Cases, wrote Test Scripts by decomposing Business Requirements, and developed Test Scenarios to support quality deliverables.
• Collaborated with key stakeholders including infrastructure engineers, business analysts, development teams, project managers and management, to report test progress and escalate issues requiring attention
• Maintained and updated the RTM to provide input to project managers and others on the testing process and progress
• Responsibilities included acceptance testing, functional testing, Integration testing, System testing, UAT.
• Conducted peer review of test cases and provided feedback on areas of improvement
• Wrote and executed test scenarios, and coordinated and communicated the status of the testing effort to ensure that the QA Best Practices.
• Used SQL queries to retrieve data from DB2 and validate them, tested on the Mainframe for data validation and also tested for ETL processes
• Coordinated and carried out Black Box, Functional, Integration, and Regression
• Performed backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
• Followed Agile/Scrum development process
• Performed software support as necessary in both production and testing environments.
• Used Quality Center to manage defects and track bug lifecycle
• Identified severity and priority of bugs, communicated to development team and helped minimize duplication of defects during testing cycle via QC
• Maintained and published all test results, planned and managed UAT process by interacting with stakeholders, analyzing UAT defects and also acted as support for User Education Issues post Go-Live
• Coordinated defect review meetings with the project team to identify the process to address the open issues
• Performed testing in composite tool from where the data has been pulled after the ETL processing is done and has been used for reporting purpose.
• Worked on Web Services Testing (XMLs)

Environment: Mainframe, Putty, HTML, HP ALM, Share Point, XML, JIRA, JAZZ, Informatica 9.1, Teradata, Micro strategy - DART9.4, Dynamics 365, VSTS

Confidential, MD

ETL CQ Test Engineer

Responsibilities:

• Interacted with clients to determine User requirements and goals, Participated in analysis of Business and functional requirements
• Collaborating with work stream CQs and PDs to understand their needs, and then implementing, getting reviews and releasing the components
• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases, Test plans, and Test procedures using MS Excel for Functional and Regression test.
• Create test cases and automate them using Control-M
• Automate tests which have file creation or file transfer on UNIX, verifying the jobs in Control-M, validate database and verifying the mapping
• Automate tests for verifying Settlements functionality for Debit and Credit transactions.
• Create test cases on control-M flows of various features like: Account Master, Customer master flow, DB2, Misc data, Authorization Log, Customer information.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Attend defect calls with A/R Vendor TSYS.
• Involve in QA Signoff of CM tickets for production issues after month-end releases.
• Handle migration testing of Informatica 8.x to 9.x from Control-M part.
• Work with Release Management team to get code push to various QA environments.
• Support End to End defects.
• Carry out Regression testing.
• Demos of the functionality tests to the Product Owner before acceptance of stories.
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Responsible for communicating Defect Status Reports to business in project meetings
• 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 on power exchange to compare the data from source to target.
• Worked on EBCDIC files.

Environment: Informatica 9.1, 8.6, TOAD 11.6, Power exchange 9.1, Control-M, Putty, UNIX, WINSCP

Assurant Health care Milwaukee, WI

ETL QA Engineer

Responsibilities:

• Developed Test Plan and overall Test Strategy for the Application.
• Developed Test cases, Test plans, and Test procedures using MS Excel for Functional and Regression test
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Involved in testing various EDI transactions like 837 and 835.
• Involved in adding Clients, Groups, members and processed claims
• Validated HIPAA edits are bypassed based upon trading partner settings .
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• 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.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server
• 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 Power Center 6.1, Quality Center, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Confidential

Jr. QA Tester

Responsibilities:

• Designed and developed Test Scenarios and Test Cases in HP Quality Center and executed them.
• Involved in writing the Test Plans based on Business Requirement and Functional Requirement documents.
• Involved in implementation of the Test plans, Test cases and Test Scripts.
• Created Test sets in Test Lab to move all the test cases from Test plan to execute the test cases.
• Tested the data and data integrity among various sources and targets.
• Developed and involved in both Manual Testing and Automation Test Scripts based on Use cases developed.
• Tested to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases.
• Tested Business Objects reports and Web Intelligence reports.
• Managed user accounts and security using Business Objects Supervisor.
• Tested the universes and reports in Business Objects XRI3.
• Extensively used Informatica power center for ETL process.
• Configured Quick Test Professional with Quality center.
• Executed of QTP Script for automation testing, analyzing the automation result
• Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Created the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Involved in preparation of System Test Results after Test case execution.
• Experienced in writing UNIX script.
• Effectively coordinated with the development team.
• Created critical scenarios for each change request and defect request.
• Worked on HP Quality Center and updated defects status with appropriate information. Test cases and Test plans are managed and controlled using HP Test Director. And also used HP Test Director to manage and track defects.
• Involved in various testing phases like Unit Testing, System Integration Testing, Validation Testing, User Acceptance Testing, Parallel Testing, Performance Testing and Regression Testing.
• Used various SQL queries to validate the test case results for back-end test cases.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Hands on experience with working on Autosys jobs and MQ’s. MQ’s are used for intermediate storage where the messages are stored for temporary purpose.
• Hands on experience working with SQL Server DTS Packages.

Environment: Informatica Power Center 8.1, Business Objects XRI3, SQL, PL/SQL, SQL Server 2000/2005, Unix Shell Scripting, XML, XML Spy 2008, XSLT, TOAD 9.2,Oracle 9.2, SOA, SOAP UI, REST Teradata, HP Quality Center 9.2, QTP 9.2, Rational Suite, DB Artisan 8.5.2, Autosys, MQ’s