SUMMARY

• 8 Years of IT Experience in Testing and Development of Data Warehouses & Datamart applications and ETL/OLAP processes
• Experience in DWH Tools Informatica PowerCenter 9.x/8.x and Business Objects.
• Experience with RDBMS and MPP databases like Oracle 10g/9i, SQL Server 2005/2008 and Teradata.
• Experience in writing complex SQL Scripts/queries for data validation and query tuning as well as performance tuning.
• Experienced in User Acceptance(UAT) and System integrations testing.
• Knowledge of Dimensional Modeling using Star schema and Snow Flake schema for faster, effective query processing and Business Analysis Requirements.
• Proven experience in complete life cycle of Design, Maintenance and Documentation of Data Marts.
• Strong business understanding of Financial, Health care, Education, Pharmaceutical and Service oriented industries.
• Experienced with process flow and system diagram development using tools such as MS Visio And Mind Jet Manager for use in requirements or technical documents.
• Experience in scheduling and executing workflows and sessions using Informatica workflow manager and workflow monitor tools.
• Experienced with protocols and technologies: TCP/IP, SIP, FTP, POP3, MAPI, HTML, XML.
• Strong experience in writing Test Plans and Test cases using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities. mentoring the development of testing approaches, test plans, and test case scenarios
• Represent QA in all phases of product development including requirement, design, construction, testing, implementation, code reviews and support. Sound business knowledge to improve current business practices.
• Experience in using HP Quick Test Pro and Quality Center tools.
• Good working knowledge of automation tool and expertise in QTP 10/9.5/9.2.
• Experience in Keyword Driven, Data driven frame works, function libraries, enhancements in the scripting.
• Well Versed in GUI application testing, Database Testing & Security Testing on Client - server and web- based applications with multiple server domains.
• Active role in requirements review, functional document review, testing review and key resource for System Testing phase and production roll-out.
• Defect tracking, creating test summary reports and documentation of the results
• Experience in writing the SQL queries. Performed backend testing and data validation by writing SQL queries.
• Experience to log the defects in Quality center and close the defects if they are fixed.
• Has experience in testing applications that work with Oracle, Web Technologies, and Java based platforms
• Good working knowledge in Agile methodology, attended the Scrum meetings daily to check the status.
• Multitasking and prioritizing projects, as well as the ability to appropriately set & manage expectations.
• Create, review and maintain test data and test results documentation. Document and report software defects using specific tools.
• Used a number of defect control systems and QA tools: Remedy, Jira, Rational Clear Quest, Bugzilla, HP Quality Center, PVCS Tracker, Track Record, TestTrack Pro, Radar, Lotus Notes, Test Track Web, FileMaker Pro, McAfee Bug Log, Fiddler, Firebug, Wireshark
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 7.x/8.x,9.x PL/SQL procedures

BI Tools: Business Objects 6.5/5.x (Designer, Supervisor), Cognos 7.x (Impromptu, Power Play, Transformer)

Operating Systems: Windows 2000/NT 4.0 Server, AIX, HP-UX 11i v2, Redhat Linux

Database: Oracle 11g R2,DB2, SQL Server 7.0, Teradata, MS Access 7.0,Query Utility(BTEQ)

GUI: Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

Web/App servers: Internet Information Server, Apache Web server, Web Logic

Tools: HTML,XML, SQL*Loader, Toad, Mainframes JCL, SQL-Programmer Win Runner7.0/6.0,Mind Jet Manager LoadRunner8.0/7.8,RQM,RTC,Quick Test Professional 8.0/8.2/9.0/9.2/9.5, Quality Center.

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Quality Analyst

Environment: Informatica9.x, Cognos Report Studio, Report Builder, Oracle 11gR2, PL/SQL,XML,Ultra Edit, Windows7.

Responsibilities:

• Performed Functional, System, and Regression testing of a web based application working in an agile environment.
• Involved in developing detailed Test Strategy, test plan, test cases using Quality Center for Functional and Regression Testing, Involved in writing Test plans and Test Design.
• Developed Tractability Matrix which is a proof of document to ensure that all the specifications are been tested and has no defect.
• Interacted with end users to obtain specific system requirements.Prepared test cases for Boundary Value Analysis using BlackBox testing techniques.
• Executed test cases manually and automated to check GUI and Functional features of the AUT, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using QC.
• Converted manual test scripts to automated test scripts in QTP .Perform backend database validation using SQL test scripts.
• Used HP QTP to develop and maintain reusable Test scripts and worked with Expert view Environment using Parameterization, Checkpoint, Regular Expression, Object Model, Virtual Objects, and Recovery Scenarios etc.
• Implemented BPT framework using QTP tool, Used BPT to enable Subject Matter Experts to create business process tests using reusable business components.
• Exported and Imported test data between Quality Center and MS Excel/Word.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• Performed an end-to-end test in a production environment to validate new or updated business processes, customization and configuration, reports, and data migration.
• Testing the operational tasks involved in loan products covering account creation, approvals, and disbursals, making payments and closing of accounts using end- end testing.
• Performed end-end testing to carry out operational tasks in saving products, client management and fee payback.
• Prepared weekly productivity reports and submitted test metrics to the management.
• Logging and managing the defects in Quality Center. Highly knowledgeable in software development, requirements analysis, and database design.
• Advanced Excel spread functions such as: Pivot Tables, V Lookup, & Goal Seek

Confidential, OH

Quality Analyst

Environment: Informatica9.x, Business Objects XIR3.1, WebI, Universe Designer, Oracle 11gR2, PL/SQL, Remedy5.0, Windows XP

Responsibilities:

• Analyzed, developed, documented and validated QA work product for the application, against the Use Case and Business Requirements Documents as part of the SDLC activity.
• Handled the entire testing process including vast amounts of test data creation, execution, data validation
• Documented test requirements using quality center and set the traceability between different requirements.
• Responsible for preparing and executed of Test Cases (System, Integration Regression test cases).
• Performed peer to peer reviews and communicated the inconsistencies between the requirements and application
• Participated in developing software test plans for various testing phases.
• Functional responsibilities included performing GUI Testing, System testing, Database testing, Usability testing, and Regression Testing
• Prepared test data and Compared the Expected Results with the Actual Results and the Results are Stored in the Quality Center
• Tracked the bugs using Quality Center and generated reports & Defect metrics
• Recorded, maintained and tracked defects in Quality Center. Documented the test results and test processes.
• Executed the test cases in different QA environments and for this enhanced the test cases using data scenarios and data driven approach.
• Developed test oriented SQL Queries to query the database to test the back end process of the application
• Wrote DDL, DML scripts for Schema, Table space, Cluster creation and Alteration.
• Imported De-limited files Into Excel file and Validated data quality Using MS Excel.
• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.

Confidential, German Town, MD

Quality Analyst

Environment: Informatica 8.6, Quality Center8.0, WINSQL, Wireshark, HTML, Java, JSP, SQL, Windows XP.

Responsibilities:

• Identified test objectives and scenarios from (BRD) Business Requirement Document and test strategy documents of the application under Test.
• Involved in Verification and Validation phase of the development life cycle.
• Involved in developing test cases based on high-level and detailed designs to include prerequisites, detailed directions and descriptions of the anticipated outcome
• Prepared test cases for Functionality and GUI testing
• Performed manual testing of the complete application and identified mismatches between actual and expected behavior of the application.
• Analyzed the results of the test cases executed and recorded defects and updated the information to QA Lead
• Set up definitions and process for test phases including integration test and system test.
• Involved in database testing of the application to check for insert and update operations using SQL queries
• Performed integration and cross browser testing to check if application under test was performing as expected.
• Reported Defects using bug-track and actively involved in analysis of the defects on severity and priority.
• Participated in defect meetings and build meetings to resolve outstanding issues and to prioritize defects and asses risks.
• Documented and communicated test execution results.
• Participated in status meetings to report any bugs, issues and risks.

Confidential, MI

ETL Tester

Environment: Informatica Power Center 8.1, SQL*Loader, Business Objects 6.5, Web Intelligence 2.0, Oracle 9i, Windows NT.

Responsibilities:

• Involved in designing the data model using ERWIN and generated the DDL for DBA to implement the tables in the development and production environment.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Setup and maintenance of database on Oracle. Database administration tools used includeOracle Enterprise Manager, Spotlight on Oracle AndTOAD.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Involved in deriving the Test Scenarios and designing, executing the Test cases.
• Involved in generating the test data and preparing the weekly status reports.
• Involved in manual test execution and was involved in various testing phases like Sanity Testing, Smoke Testing, Retesting, Regression Testing and System Testing.
• Executed the test cases manually on timely basis and detected the defects.
• Interacted with the developers to solve the defects and retested the scenarios once the defect is fixed and closed the defect if it no longer exists.
• Provides the status reports like how many test cases executed, defects found, defects pending, defects solved.
• Documented the test results and informed to QA lead about the status.
• Performed the database testing by executing the SQL queries.
• Good interaction with team to ensure good relationship among the team.

Confidential

Software Engineer

Responsibilities:

• Identify the sources, Analyze the source data.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
• Configured session properties and target options for better performance.
• Test all the applications and transport the data to target Warehouse Oracle tables on NT server.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Maintain and enhance the application to meet all the required business needs, mainly to optimize the supply vendors cost.

Environment: /Tools:Informatica Power Center 5.1, Oracle8.0, SQL, Windows