SUMMARY

• Experience of 6 + years of QA and ETL testing in finance and mortgage domain.
• Experience in loading data into Data marts using Informatica 8.6/8.1/7.1/6.2.
• Extensive knowledge in SQL & PL/SQL programming and Oracle 9i/8i/7.x and exposure to Teradata.
• Experience in working with Microsoft SQL Server, PowerPoint, Word, Excel and Outlook
• Experience in Quality Assurance analysis and testing on an Enterprise - level DW applications for various industries.
• Expertise in application analysis, test strategy development, test case creation, test script development, test execution, defect tracking and reporting.
• Expertise in Integration test by running ETL jobs, validating data loads, troubleshooting job execution errors and executing test scripts.
• Good Experience in all the stages of testing, such as Unit, Integration, Regression System and UAT testing, in both manual and automation environment.
• Domain expertise in business requirement gathering, business process, system analysis development, implementation and support of, applications in database, environments and testing.
• Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs.
• Extensive experience in ETL methodologies for supporting Data Migration, Data Exchange, Data Transformation using Informatica Power Center v 8.x/7.1/6.2.2 Suite.
• Sound Knowledge of Dimensional Modeling using Star schema and Snow Flake schema
• Worked on Logical and Physical Database Designing using ERWIN Tool.
• Experience in integration of data sources like Oracle, DB2, MQ, SQL Server, and Flat Files.
• Strong problem solving with ability to analyze complex system requirements and define discreet test scenarios to provide full functional coverage
• Experience in categorizing and prioritizing analysis and mapping workload for planning and forecasting
• Exposure to SQL Server Integration Services (SSIS).
• Exposure to Ab-Initio in high volume, parallel processing data environments.
• Knowledge of Service-Oriented Architecture (SOA).
• Extensively used various Performance Tuning techniques to investigate various bottlenecks in Informatica to improve the performance for data loads.

TECHNICAL SKILLS

OS (or) Environments: Windows (NT, 2000, 2003, XP, Vista, 7), UNIX (Sun Solaris, AIX, HP-UX),Mainframes

Databases: Oracle 10g/11g/9i/8.0, MS SQL 7.0, SQL Server 2000/2005/2008 , IBM DB2 8.1, OLTP, Terra data V2R6\V2R5, Sybase ASE

Programming: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, SQL Tuning/Optimization, XML and HTML.

Query Tools: TOAD, SQL*Plus, BTEQ, Erwin.

Reporting Tools: Cognos, Business Objects, Oracle Business Intelligence

Automation Tools: HP Quick Test Professional, HP LoadRunner, SOAPUI

Others: MS Office (Word, Excel), Test director, Autosys

PROFESSIONAL EXPERIENCE

Confidential

Quality Analyst

Responsibilities:

• Involved in the review of requirements with functional manager and technical specialists of the application
• Performed automated using descriptive programming and back end database testing.
• Designed and executed Test Plans and Test Cases and generated Test Scripts and Test scenarios.
• Interfaced with the business and the technical groups in order to convert the business requirements into functional requirements.
• Communicated with developers on a regular basis for better understanding of the application and let them know the issues.
• Also Involved In mentoring QTP to some of the new users
• Used the Smart Identification in QTP in order to identify the dynamic objects
• Reviewed extensive SQL Queries with complex multi-table joins and nested queries.
• Involved in reviewing complex SQL queries, views, functions and stored procedures and spotting issues before/during code migration.
• Rigorously tested SQL’s implementation of existing code.
• Automated the Back-End testing for reusability by writing Unix Shell Scripts.
• Created and maintained SQL Scripts and Unix Shell scripts to perform back-end testing on the oracle database.
• Performed Developed cases and scripts using QTP for Functionality, Security and Regression Testing.
• Created Text area Checkpoints to test the properties of the text in the application using QTP.

Environment: UNIX, Oracle, Quality Center 9.0, QTP, Windows XP, MS Outlook Express, Excel

Confidential, Charlotte, NC

QA / Back-end Tester

Responsibilities:

• Working directly with Business team to establish Business Requirements, defined and documented core business process information, business rules, business entities and other relevant information in Business requirement document (BRD) by conducting JAD session and interviews.
• Assisting project manager in maintaining project schedules, project plan, project scope, work breakdown structures (WBS), issue logs, meeting summaries and status reports by using tools like MS project, ALM & share-point to ensure effective, ongoing communications across all team members.
• Performing Data mining and data extraction by using SQL to create financial reports by pulling data from database for various products like credit, loans, mortgage, Investment and Insurance of the bank in Oracle 10g environment.
• Focal point for making sound decisions related to data collection, data analysis methodologies and designs by using SQL scripts. Conducting research to collect and assemble data from databases and also responsible for design/development of relational databases for collecting data.
• Constantly coordinated with Infosys, offshore development team, for optimum results of testing SIT, UAT, and Regression. Communication and understanding with the offshore was very important to fully develop and test all functionalities in scope.
• Developed test cases for the front end to test application and button functionalities on the UI.
• Performed front-end application testing with back-end validation.
• Participated in UAT testing with the users to guide them to test the full functionality of the application.
• Developing test cases, test plan, test strategies and requirement traceability matrix for tracking the requirements.
• Performing User Acceptance Testing by providing training, user guides and user manual to end users.
• Coordinated with all team members to identify in which cycle the testing can be automated.
• Performed automation testing using Quick Test Professional where possible.
• Reviewed VB scripts in QTP to pinpoint bugs in the code to resolve testing issues.
• Thorough knowledge of implementing Agile SDLC in all six phases of a project i.e. Initiation, Gathering requirements, designing, development, testing and implementation. Participating in the scrum meetings under agile methodology.
• Performed Regression testing with QTP to automate and analyzed the results to find defects.
• Coordinating with the testing team for SIT, Regression and Automation testing by using tools like QTP, HPQC, and HP Performance Center 11.
• Assisted in testing data migration from Oracle 10g to 11g first with test environments and later in the production environment
• Developing various business model diagrams, Data flow diagram, work flow diagram, sequence diagram using tools like MS Visio.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• Conducted a GAP and SWOT analysis to identify problems in the existing system and implemented the strategies and solutions to rectify those problems.

Environment: Oracle 10g/11g, Oracle Business Intelligence Enterprise Edition (OBIEE), Quest Toad for Analysts 3.2, Toad 10.1, Windows XP, Windows 7, MS Visio, PL/SQL, Quick Test Professional

Confidential, Fair Lawn, NJ

QA / ETL Tester

Responsibilities:

• Participated in the meetings with business and product management staff, business rules management, developers and project managers for business rules, application project planning, requirement and scope discussion.
• Using structured methodology, analyzed business requirements and solution specifications to create development integration test strategy and test plans.
• Responsible for the full life-cycle of the test phase of a project from its kick off until delivery and readiness to be deployed to Production.
• Responsible for setting and execution of service-oriented application systems by following standard testing methodologies.
• Automate front-end test cases in Selenium to maximize time efficiency.
• Recognized test automation opportunities and analyzed SOA requirements.
• Responsible for estimating required resource and components for SOA testing
• Responsible for testing and implementing service oriented architecture components
• Perform test task estimation, test execution, Regression testing, Functional testing, automated testing where possible.
• Designed test case, test data and test automation.
• Executed test cases, analyzed document results, identified and managed defects.
• Performed front-end web application testing using Selenium.
• Participated in functional and non-functional testing of web based application.
• Assisted with the development of tools and processes to support development integration testing.
• Performed UAT execution plan and assisted UAT activities.
• Created test cases and test scripts for front-end testing using Selenium
• Designed and documented validation rules, error handling routines and testing strategies for the mappings.
• Developed processes for automation of loading data using parameter driven sessions for batch schedule processes, verification and re-conciliation of data stored in several different source systems.
• Experienced in capturing test metrics, dashboard, and reports
• Understanding of SDLC and/or Agile methodologies
• Analyze business requirements to help drive and develop test cases.
• Develop and executed test cases and provided feedback to Project Management and Development.
• Worked with the teams closely to progress the testing toward realistic achievable milestones.
• ETL packages Migration from point A to point B for Backend testing

Environment: Informatica Power Center 8.1, Oracle 10g, UNIX, Selenium, Sybase 12.5, LoadRunner 9.10, Erwin 4.0, DB-Artisan 7, SoapUI Pro, BO XI, Power Builder, Sun Solaris 8.0

Confidential, NYC

QA / ETL Tester

Responsibilities:

• Reviewed requirements and specifications and provided inputs during requirements and specification walkthroughs.
• Created and executed manual and automated tests, document testing practices, and communicate results/recommendations to team.
• Responsible for testing of the ETL solutions developed using Informatica and SQL / T-SQL.
• Automated of functional testing framework for all modules using Selenium.
• Developed and maintain the manual and automated test scripts, functions / SQL code.
• Regression test cases were automated using Selenium, WebDriver, WebDriver Backed Selenium.
• Developed complex SQL queries using querying tools and SQL/T-SQL and relational database manipulation.
• Understanding of data rollups/aggregation, capacity planning, data standardization, slowly changing dimensions and data security Ability to design and execute test scripts and plans for unit, integration, regression and UAT testing processes
• Excellent Documentation skills from a technical and Analytical set of documentation scope related to the testing team and its efforts.
• Experience in defect management tools and processes
• Defined, developed and maintained test scripts. Executed test plans and test scripts independently based on planned project schedules and in accordance with QA methodology.
• Escalated proactively issues to the QA Lead Alerts the project team on potential impact to test schedule.
• Recorded and tracked defects uncovered during the execution of tests scripts.
• Drives defect towards resolution Proposes and designs test cases, test scripts and test data for defect retests.
• Provided timely and accurate status defect information and appropriate metrics to facilitate QA reporting.
• Participates on testing Production Support tickets though rotating on-call responsibilities.
• Provides consistent and uninterrupted testing service to the organization and minimizes risk of systems down time.
• Developed and executed complex SQL queries.

Environment: Informatica Power Center 8.1, PL/SQL, Selenium, Oracle 10g, SQL Server 2005, Unix Shell scripting, UNIX, Windows NT

Confidential, Charlotte, NC

QA / ETL Tester

Responsibilities:

• Extensively used ETL to load data from Oracle database, SQL Server, Flat files, DB2 to the DB2 Data warehouse.
• Preparation of Test Data/Unit Testing /Integrated testing and generated various test cases.
• Documentation: Data migration document for various metadata tools/procedures/functions/shell scripts.
• Interacted with clients during Integration Testing. Participates in all different test phase as per the project needs.
• Contributed to the development of the test plans and project testing approach.
• Provided inputs to the development of project and Release Test Plan documents.
• Understands and contributed to the process of test estimates and project schedules.
• Participated in test planning, test case design and test script walkthroughs with QA Leads.
• Understands testing to be accomplished and suggests changes for efficiencies within or between projects.
• Assisted in the preparation of test estimates and project schedules.
• Adheres to established standards and methodologies.
• Utilized tools and methodologies to improve individual effectiveness and increases efficiency in the QA process.
• Developed and sustained appropriate relationship with peers and other project team members.
• Good experience in verification and validation techniques, defect management, quantitative methods, risk management and measurement programs.
• Strong SQL skills. Working knowledge of UNIX. Strong leadership capabilities, good judgment and the ability to work effectively with a diverse workforce.
• Hands-on experience on a defect management tool. Excellent verbal and written communication skills.

Environment: Informatica Power Center 7.1, Oracle 10g/9i, SQL, PL/SQL, IBM 8.1.7, Db2, UNIX Shell Scripting, and Windows NT 4.0, VISIO 5.0, IBM control centre 7.0, Control M, PVCS 7, Microsoft outlook, Cognos

Confidential, Jersey City, NJ

QA Consultant / ETL

Responsibilities:

• Actively conducted and coordinated the QA reviews like Peer Review and Functional Review.
• Prepared and Analyzed the Test Plan that defines the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required.
• Used the 'Requirements',' Test Plan' tab, 'Test Lab' and 'Defects' to prepare, execute the test sets and track the defects Excellent hands on experience in Testing
• Designed, developed, and executed test cases that exercise the ETL process.
• Analyzed business requirements to help drive and develop test cases.
• Developed test cases and Executed test cases and provided feedback to Project Management and Development.
• Captured test results and worked with QA automation engineers to drive and captured test cases in automated tests.
• Ensure that bugs reported are linked to test cases or QA tasks.
• Created, refined and delivered functional test materials corroborated with test cases; set up test plans, schedules and scenarios using Rational Test Manager
• Conducted Unit testing and Integration testing.
• Develop and maintain the manual and automated test scripts, functions / SQL code.
• Ability to design and execute test scripts and plans for unit, integration, regression and UAT testing processes
• Responsible for drafting documentation for end user usage and develop training material.

Environment: Informatica Power Exchange, Informatica 7.1 (Power Center), Micro Strategy, DB2 8.x, IBM-AIX, Erwin 3.5, Oracle 9i, Clear Case, MS Visio, Visual Source Safe, MS Office, Rational Suite MS SQL Server.

Confidential, NYC

QA / ETL Tester

Responsibilities:

• Designed the ETL processes using Informatica to load data from File source and Oracle into the target Oracle 9i database.
• Developed complex Informatica Mappings and monitored those mappings.
• Developed various ETL transformations and PL/SQL program units.
• Used Informatica Workflow Manager & Monitor to Create, Monitor workflows.
• Worked with type1, type2, and type3 slowly changing dimensions in data model process work.
• Performed Debugging and performance tuning for developed Mappings.
• Validate the data in data marts after loading process balancing with source data.
• Performed Unit Testing Cases.

Environment: Informatica Power Center 6.2/5.1, Oracle 8i, Windows 2000, SQL, UNIX