SUMMARY

• Over 7 plus years of experience working as ETL tester and knowledge of Data transforming, processing in corporate world ETL solution using Informatica tools.
• Expert knowledge in Business Process Flow, Case Tools, Business, Data Analysis, data Mapping and data transformations.
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Construction, Testing, Implementation, Support).
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (Sequence diagrams, Collaboration diagrams, State chart diagrams, Activity diagrams).
• Expert knowledge in EPI creating ETL Test Plans, ETL Test Cases, ETL Test Scenarios and Test Strategies to ensure Quality Assurance and to test all the business requirements.
• Actively involved in User Acceptance testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Validated the daily and monthly reports in against the data in Oracle databases.
• Worked with the components of Data Warehousing like components model, ETL tools.
• Excellent Knowledge of Database Systems - Oracle 11g/10g, SQL server, Erwin, Toad, Sybase and Data warehouse concepts with Eagle Star.
• Extensive ETL Testing experience on Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Experience in Business Intelligence (BI) and SAS technology in generating various reports using STATA, Business Objects and Crystal Reports.
• Excellent Knowledge in MS-Office (Word, Excel, PowerPoint), MS-Access.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.
• Created various automated test scenarios using QTP and HP Quality Centre tools.
• Extracted data from Server into flat file and imported to Oracle DB.
• Developed test strategy and test plans for the ETL process.
• Perform testing on SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Have experience working inAgile/ScrumMethodology.
• Created various AUF reports for validation strategies, SOPs and fit gap analysis report.
• A very good team player with excellent Communication (Verbal, Technical), Presentation and reporting skills.

TECHNICAL SKILLS

• Mainframe
• DB2
• Data Stage
• Oracle11g/10g/9i
• SSIS
• SQL Server 2008/2005/2000
• My SQL
• MS Access
• Star Schema
• Snowflake schema
• OLTP
• OLAP
• MS Windows XP
• 2000 & NT
• MS DOS
• Entity-Relationships
• Data Flow Diagrams
• C
• C++
• SQL
• PL/SQL
• VB
• ASP
• Informatica Power Center
• Erwin8.0/7.2
• TOAD
• Teradata
• MS-Visio2000
• SQL*Loader
• Microsoft Word
• Excel
• PowerPoint
• QTP10/11

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

ETL Tester/QA Analyst

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.
• Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
• Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.

Environment: SQL Server 2008, TOAD, SQL, PL/SQL, Informatica Power Center 9.1, Erwin 8, QC 10.0, QTP 11.0, Windows - 7, Vista, XP, UNIX, Oracle 11g, TOAD, SQL, PL/SQL, JavaScript, MS Word, Excel, PowerPoint, Outlook, MS Visio

Confidential, Greene, NY

ETL Tester/QA Analyst

Responsibilities:

• Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Conducted Operation readiness testing, deployment testing, negative testing, count testing and sampling testing on Mapplets
• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications
• Developed ETL test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Python is often used as a scripting language but is also used in a wide range of non-scripting contexts.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed SAS data quality analysis using advanced SQL skills.
• Performed Count Validation, Structural validation, Constraint validation, Complete data validation, Null validation, Negative testing, Duplicate testing
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing on SAP modules.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Possess experience in FDA regulated environment for subsequent releases with good understanding of processes and Risk Based validation.
• Python supports multiple programming paradigms, including object-oriented, imperative and functional programming styles.
• Tracked and reported the issues to project team and management during test cycles.
• Updated and maintained existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contributed in the development of knowledge transfer documentation.

Environment: Informatica Power Center 8.1, Oracle 11g, Sybase, SQL Server, Teradata, DB2, Erwin 7.0, Business Objects, Python, Rational Rose, MS Office, QC.

Confidential, Philadelphia, PA

ETL Tester/QA Tester

Responsibilities:

• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and TestData.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed ETL Test Cases and SQL Queries to perform various Validations.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation test on various SAS environment stages in data Stage.
• Performed Unit Testing, Integration Testing, User Acceptance Testing (UAT) and Requirement Testing.
• Executed Test Cases with respect to Source and Target database tables.
• Wrote SQL queries tovalidate reports against the database.
• Extensive SQL querying on Staging,Datawarehouse andDataMarts.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Extracted Patient data from Server into flat file and imported to Oracle DB.
• Validated reports based on Functional Requirements.
• Analyzed various reports generated by SSRS and perform field testing and report data validation test.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.

Environment: MS SQL Server 2005, Data stage 7.5,DCT, ERwin 7.2, Flat Files, DB2, SQL Profiler, TOAD 9.5, MS Office, XML, Windows Server 2003, Unix, QC 10.0.

Confidential, New York, NY

Sr. QA Analyst/ ETL Tester

Responsibilities:

• Attended application walk-through and reviewed Requirements to understand the scope of the project.
• Created the use cases, activity diagrams and sequence diagrams.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Tested Informatica Mapplets like Aggregator, Filter, Router, Ranks, Look Ups, Store procedures and Views.
• Performed ETL test task estimation, ETL test execution, Regression testing, ETL Functional testing, automated testing where possible.
• Designed test case, test data and test automation, Tractability Matrix and Test Coverage reports.
• Prepared the Data mapping specifications and documentation.
• Loaded data into Oracle using SQL loader and validated data
• Wrote SQL Queries and executed them using TOAD and SQL Editor
• Performed System test, Workflow Integration Test, Acceptance testing and Regression testing activities in Test environment and Production support environment
• Verified logs after running ETL jobs using Informatica.
• Studied the feasibility of the reports by conducting the data analysis.

Environment: Informatica Power Mart 8.1, Erwin, MS Excel, TSQL,DCT SQL, PL/SQL, TOAD, Test Director, Visual Basic 6.0, Oracle 9i,Python, Windows 2000, Rational Rose.

Confidential, Rockville, MD

QA Tester /Data Analyst

Responsibilities:

• Worked closely with application development teams to ensure adherence to design specifications, proposed procedures, practices and standards.
• Participated in Joint Application Design/Development (JAD) sessions.
• Extensively involved in requirement analysis
• Created the conceptual diagrams and data flow diagrams based on the analysis of requirements.
• Possess solid understanding of various FDA regulations for business process and Industry standards GAMP.
• Designed the relational data model i.e. ERD to acquire the transactional data and database snapshots.
• Also assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Identified the process which were to be associated with FACT tables.
• Extensively Worked with DBA's in implementation of databases and data schemas.
• Developed test strategy and test plans for the ETL process on the staging data base and then pushed to the Operational data store.
• Conducted Data modeling training sessions for different user groups and facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
• Assisted the UAT sessions with the users which were not just limited to flow of transactional data, through the system, performance test and updating the defect tracking list for with UAT feed backs.

Environment: Erwin 7.1, Oracle 10g, Informatica Power Center 7.1, Business Objects, Windows XP/2000 and UNIX, HP Load Runner 9

Confidential, Dallas, TX

ETL tester /Tester

Responsibilities:

• Involved in designing Logical and Physical Data model using Erwin Tool.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Performed Metadata Analysis by Data Profiling and acted as a data steward in maintaining the quality metrics on a continuous basis.
• Conducted Data Migration and Data Cleansing.
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager.
• Used Master Data Management (MDM) technology, tools to create and maintain consistent and accurate lists of Master.
• Responsible for Import and Export databases between Microsoft Access, Microsoft Excel, Text, or SQL.
• Extensively tested the reports for data accuracy and universe related errors.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Wrote data conversion and data migration scripts for ETL process
• Created ETL execution scripts for automating jobs.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.1, XML, WinSQL, Windows NT 4.0, Teradata, TOAD, Crystal Reports, Oracle 9i, PL/SQL, DB2, Microso