SUMMARY

• Having 5+ years of work experience in Manual/Automated software testing in various phases of IT projects Well aware with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards, change requirements and Quality procedures.
• Having good experience in Health care, Financial and educational systems.
• Well aware with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards and configuration management and change requests etc.
• Proficient in writing Test Cases, Test Scripts, Test Scenarios for testing.
• Extensive testing ETL experience using Informatica Power Center 9.1/8.6/7.1 (Designer, Workflow Manager, Workflow Monitor).
• Experienced in writing test cases, test scripts, test plans and execution of test cases for reporting and documenting the test results using Mercury Quality Center and Clear Quest.
• Strong understanding of Data Warehousing and ETL concepts using Informatica Power Center 8.1.1/8.0 (Workflow Manager, Workflow Monitor, Warehouse Designer, Source Analyzer, Transformation developer, Mapplet Designer, Mapping Designer, Repository manager, Workflow Manager, Workflow Monitor.
• Good experience with Web Based testing includes analyzing functional requirements.
• Good experience in writing Oracle SQL queries for data validation.
• Testing skills include Black Box Testing, Security, Regression, Functional testing, System Testing and User Acceptance Testing and performance testing.
• Strong understanding of OLTP, OLAP and data warehousing concepts.
• Good knowledge of HIPPA EDI 835 and 837 guide lines for claims.
• Very good at reporting the issues or bugs in detail and documenting them.

TECHNICAL SKILLS

Tool: Toad, my SQL, HP QC, Clear Quest, RFT

Databases: Oracle 10g/9i, SQL Server and MS Access

Languages: C, C++, SQL, UNIX Shell Scripting, Java

ETL Tools: Informatica power center 9.1/8.6/9.0 (Designer, Workflow Manager, Workflow Monitor)

Operating Systems: UNIX, Windows7/XP Professional/2000/NT/98/95

PROFESSIONAL EXPERIENCE

Confidential - Michigan

QA tester

Responsibilities:

• Analyzing Business Requirements, Functional Design Document (FDD), Technical Design Document (TDD) and use case for test case and test script preparation.
• Developing test scripts and designed test cases.
• Detecting defects, communicate to the developers using bug reporting tools and tracking the defects.
• Involved in various testing phases like Regression Testing, System Integration Testing, Data validation, User Acceptance Testing (UAT) and Performance Testing.
• Involved in querying and updating records and Validate Database Records as Expected.
• Validation of different files from mainframe to 835,834 and 837 format.
• Validation of XML provided and other text files.
• Testing of different user application and web-based application.

Environment: Windows 7, Mainframe, Eclipse, Clear Quest, Office outlook, MS Excel, XML.RFT

Confidential - Charlotte

ETL/DW Tester

Responsibilities:

• Involved in reviewing and discussing Test Plan with other team associates.
• Analyzed requirements, detailed design, and formulated test plan for the functional testing of the application.
• Extensively worked on handling the application response for Positive and Negative sets of data using Data Driven Testing.
• Developed Test Cases & Test Scripts for functional testing.
• Developed High Level Test Plans by incorporating User Profiles, Configurations, Environments, Risks, Test Scenarios, Schedules and Analysis and Presentation of Results
• Gather system matrix, defined use case scenarios for application under test by communicating with Steak holders (End user groups, Development teams, Functional/UAT test teams, Production support groups involved).
• Performed System Testing, Functional Testing, Black Box testing, UAT (User Acceptance Testing) and Regression Testing.
• Used Test Director for preparing the test plans and manual test scripts
• User defined functions were written according to the functionality of the application.
• Enhanced scripts using VBS by introducing checkpoints and verification points.
• Interacted with Business users and Technical team in providing clear solutions to requirements.
• Responsible for weekly status, attend the bridge meetings showing progress and future testing efforts.

Environment: Windows 7, MS Office, Outlook, UNIX, Oracle 9i, Toad, Mercury tools (QC), Informatica power center 9.1.Web application.

Confidential

ETL Developer

Responsibilities:

• Participated in business analysis, ETL requirements gathering, physical and logical data modeling and documentation.
• Designing the data transformation mappings and data quality verification programs using Informatica and PL/SQL.
• Extracted source definitions from various databases like Oracle, MS Access and Flat-files into Informatica repository.
• Designed Reusable Transformations and Mapplets. Used most of the Transformations like Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, Aggregator, Filter, and Sequence Generator for loading the data into Oracle database.
• Designed Workflows, reusable Tasks and Worklets using Informatica Workflow Manager SQL and worked on performance tuning.
• Investigate, debug and fix problems with Informatica Mappings and Workflows.
• Participated in Decision support team to analyze the user requirements and to translate them to technical team for new and change requests.
• Performed unit and integration testing in User Acceptance Test (UAT), Operational Acceptance Test (OAT), Production Support Environment (PSE) and Production environments.
• Technical Documentation.

Environment: -Informatica Power Center 8.6/7.1, Oracle 8, TOAD, UNIX, MS Access, MS Visio

Confidential

Oracle developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Performed requirement gathering, feasibility analysis and development and testing of the accounting, grading and on-line examination package.
• Worked on design of new systems and enhancements in existing systems: designed, altered, coded, debugged, tested and documented moderate to complex applications.
• Determined input and output data, processing requirements, time and cost requirements.
• Verified system design and performance with the specifications.
• Designed, implemented and documented software development and test procedure.
• Installed and maintained operating systems, database and networks at institute computer laboratories.
• Conducted seminars and training workshops for users or other programmers/analysts on the technical aspects or use of computer hardware, software packages and applications.
• Maintained technical documentation.

Environment: - Oracle 8, TOAD, MS Office.