Fahmida

mailto:acr5f6@r.postjobfree.com

mailto:acr5f6@r.postjobfree.com

●Over 8+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications and worked as lead in recent project.

●In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.

●Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.

●Extensively strong on databases including Oracle 10g/9i/8i, MS SQL Server 2000/7.0 and DB2

●Strong in developing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.

●Extensive knowledge in regression testing and design documentation.

●Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.

●Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.

●Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.

●Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.

●Manipulated MS-SQL Server 2008, Teradata, Sybase, DB2 and Oracle 9i/10g databases using SQL queries.

●Extensively tools like Crystal Reports and Business Objects report

●Strong working knowledge of QA life cycle and methodologies.

●Flexible in accepting various duties and assignments and helpful in managing the changing priorities and needs of developmental projects

●Good communication skills, people/team skills, work ethics, organization and time management skills.

Technical Skills:

ETL Tools: Informatica 5.x/6.x/7.x/8.x (PowerMart & PowerCenter)

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, QTP 9.5/9.2/9.0, Bugzilla

Databases: SQL Server 2005, Oracle 10g/9i, Teradata V2R6, DB2

Programming Languages: SAS, COBOL (Mainframe), SQL, PL/SQL, UNIX Shell Scripting and PERL

Operating System: MS–Windows 9x/NT/2000/XP, Red Hat Linux, UNIX (Sun Solaris 5.8)

Other Tools: Siebel, Cognos, T-SQL, TOAD 10.6x and SQL Plus (Database tool).

Certifications

Oracle Database SQL Certified Expert

HIPAA Privacy Essentials Certification from CTG

PROFESSIONAL EXPERIENCE:

Independent Health, Buffalo, NY June 2012 -Present

Enterprise Data Quality Assurance Analyst/ETL Data Analyst

Responsibilties:

I am currently working on MDM-EDW Build out project which involves ETL testing techniques like : 1) Verify that data is transformed correctly according to various business requirements and rules.

2) Make sure that all projected data is loaded into the data warehouse without any data loss and truncation.

3) Make sure that ETL application appropriately rejects, replaces with default values and reports invalid data.

4) Make sure that data is loaded in data warehouse within prescribed and expected time frames to confirm improved performance and scalability -->Created test case scenarios based on Informatica IDQ specific process check related to Data quality mapping and cleansing routine testing.

Adhere to established Enterprise Quality Assurance Procedures and provide feedback and suggestions on plan improvements.

Participate in internal team audits and inspections as scheduled by the Enterprise QA Manager.

Good knowledge in evaluating and understanding HealthCare Domain on end to end Claims processing and practice management applications.

Testing Claim applications mainly in Provider, Group, Subscriber/Family, Membership and billing.

Participate in requirements gathering, functional design, support development and testing as per HIPPA compliance awareness standards.

Involved in the whole testing life cycle covering the entire project from initiation to completion.

Tested complex mappings and SCD type-I, type-II and type III mappings in Informatica to load data from various sources using different transformations like source qualifier, lookup (connected and unconnected), expression, aggregate, update strategy, sequence generator, joiner, filter, rank, router, and SQL.

Review application upgrade documentation in areas of expertise and provide feedback.

Complete Project Test Plan to specify the Test Approach, Test Criteria, Tasks, Schedule, etc. for Strategic Projects based on approved Requirements and ensure test plans and schedules reflect the necessary activities and durations to achieve the defined requirement and objectives following available standards and guidelines.

Define Traceability ensuring that all Business & Functional Requirements are properly represented.

Review and approve the selection of test data based on approved Requirements.

Create and maintain Data Test Cases/Scenarios ensuring testing coverage.

Monitor and control test activities performed by the Enterprise QA Analyst and the Business Testers.

Schedule and track testing progress. Review Test Outcomes and recommend additional action required.

Develop, maintain, and document manual and automated test scripts utilizing testing tools.

Create and distribute Daily & Weekly Data QA Status Reports for assigned projects.

Participate in effective post release/implementation metrics and analysis to enhance implementations.

Environment: Informatica 9.1.0, Oracle 11g, TOAD 10.6, HP ALM 11.0, IBM DB2, KALIDO DIW 8, KALIDOMDM 8.

Paychex, Inc., Rochester, NY Sep’ 2011-May’ 2012

Data Warehouse Quality Analyst

Responsibilities:

●Responsible for business analysis and requirements gathering.

●Involved in writing the Test Plan, developed Test Cases and supported all environments for testing.

●Managed and executed the test process, using Agile Methodology.

●Involved in preparation of Test Plan, Test Cases, Test Scripts, and Test Scenarios.

●Written Test Cases and performed Manual Testing like Positive Testing and Negative Testing.

●Extensively executed SQL queries in order to view successful transactions of data and for validating data.

●Worked with database Oracle using TOAD and SQL Developer.

●Extensively used Informatica tool (ODI) to extract, transform and load the data.

●Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

●Written several UNIX scripts for invoking data reconciliation.

●Experienced in writing complex SQL queries for extracting data from multiple tables.

●TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.

●Involved in the whole testing life cycle covering the entire project from initiation to completion

●Clearly communicated and documented test results and defect resolution during all phases of testing.

●Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.

●Used SQL queries and custom programs to perform data validation.

●Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.

●Automated and scheduled multiple ETL jobs using UNIX Shell Scripting.

●Involved in the error checking and testing of the ETL procedures and programs Informatica session log.

●Coordinate very closely with the developers regarding functionalities and defects.

●Performed Functional, Regression, Data Integrity, System, Compatibility, and User Acceptance Testing including GUI testing

●Report bugs and track defects using HP Quality Center.

Environment: ETL tool Informatica, (ODI), Oracle database 10g, TOAD, UNIX, Shell Scripting, SQL Developer, Rational Clearcase, XML Files, XSD, XML Spy 2011, Business Objects XIR3, HP Quality Center 10.

Ascension Health, St. Louis, MO Aug ’2009 – Sep’2011

ETL Test Analyst

Responsibilities:

●Experience in documenting Functional, Technical Specifications and Test Cases.

●Responsible for developing test plans, testing strategy, test cases and execution of the complete test cycle for the backend for ETL and BI needs.

●Written complex SQL queries to validate the data against the target based on ETL mapping specifications.

●Tested complex mappings and SCD type-I, Type-II and Type III mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Rank and Router and SQL transformations. Created complex mapplets for reusable purposes.

●Performed backend testing in Oracle /SQL Server My SQL database and analyzed the log files for different error codes for ETL processing.

●Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data from DB2, COBOL Files and converted to Analytic SAS Datasets for testing ETL loads.

●Responsible for testing the different Data mapping activities from Source systems to Teradata

●Extensively executed T-SQL queries in order to view successful transactions of data and for validating data in Sql Server Database.

●Queried Teradata Database and validated the data using Sql Assistant.

●Wrote many SQL/PL-SQL scripts to verify data in the DB and verify consistency with Web Portal BI reports.

●Extensively coordinated with the Engineering team/Product team/QA team to discuss challenging issues/bugs/features faced while testing the product.

●Wrote many SQL/PLSQL scripts to verify data in the DB and verify consistency with ETL mapping

●Interacting with developers and trying to track/verify bugs in the corporate Bug database and ensure smooth progress and completion of the QA cycle

●Extensively used UNIX shell scripts and compared the files in SAS to make sure the extracted data is correct.

●Very good experience running the jobs using UNIX Putty Session and Control M Job scheduler.

●Involved in testing universes and reports for correct mapping of the objects and data correctness.

●Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports

●Testing of Business Objects and Reports which Includes, Testing of objects in the Universe to ensure the correct mapping of the objects, testing of the Universe s Structure to ensure that tables are properly uploaded; Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation.

●Test Business Objects reports for data validation and compare results with TOAD.

●Unit tested BO reports before moving to the staging area.

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange, Oracle 10g, MS SQL Server 2005, Teradata, SQL Assistant, T-SQL, windows, Mainframe, SAS 9.1, Control-M, QTP 9.5, HP Quality Center 10.0, Rational Clear Quest, XML Files, XSD, XML Spy 2011, Business Objects XIR3, UNIX, Shell Scripting

Wachovia Securities, Charlotte, NC Sept ‘2007 – Aug ‘2009

QA Analyst/ETL Test Analyst

Responsibilities:

●Involved in writing of complex SQL to test the business logic.

●Involved in checking of data integrity and constraints by using SQL Queries.

●Performed User Acceptance Testing.

●Involved in analysis of defects and found the root cause of the defect.

●Document software defects, using a bug tracking system, and report defects to software developers.

●Reviewed DataStage Jobs and test cases before delivering to Client

●Involved in defect tracking meetings.

●Designed test plans, scenarios, scripts and traceability matrix.

●Assists in developing detailed testing estimates and timelines.

●Prepared test cases and test data by using requirement documents.

●Involved in testing of Pearson website by using web services.

●Write and execute complex SQL queries to validate actual test results match expected results.

●Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on Ad-hoc requirements

●Tested the ETK Process Loading of data from SAS data mart into SQL database.

●Validated the conversion of ORACLE SQL codes into SAS Programs.

●Responsible for Data mapping testing by writing complex T-SQL Queries using Query Studio

●Involved in loading of data into database through UNIX.

●Validated the source and target data count.

●Used T-SQL for Querying the SQL Server database for data validation.

●Design and development Test cases for the ETL processes using DataStage ETL tool for dimension and fact file creation

●Performed functional testing using QTP for end to end application testing.

●Executed backend data-driven test efforts in QTP with a focus on data transformations between various systems and a data warehouse.

●Tested whether the Business Objects reports developed in OLAP are as per company standards.

●Involved in writing of SQL scripts.

●Validated the XML files by using Altova XML spy and against XSDs which are posted in the JMS topic.

●Validated all the applications and successfully executed and unit tested the jobs with Data Stage director

●Document software defects, using a bug tracking system, and report defects to software developers.

●Tested Business Objects reports for verifying and validating the data. Tested several complex reports generated by reporting tool including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards

●Involved in defect tracking meetings.

Environment: Datastage 8.1, SQL, T-SQL, XML, XSD, XQuery, Business Objects XIR2/6.5.1,` MDM 8.5, IBM AIX 5.3, UNIX, Shell Scripting, SAS, IBM Rational Clear Quest,IBM Functional tester,Ultra edit, Mercury Quality Center 9.2, QTP 9.0, Oracle 10g, SQL server 2005, DB2, TOAD, SQL developer, MQ Series 6.0, XML Spy 2011

Pfizer, New London, CT Mar ‘2006 – Aug ‘2007

Data Quality Tester

Responsibilities:

●Responsible for delivery of high-quality information systems by leading the effort to plan, execute, and document results of tests of new or revised system capabilities. This included primary responsibility for determining whether new or revised system capabilities had been adequately tested for release to users in production.

●Determined the level of testing required validating new or revised system capabilities.

●Developed Test Plans and developed Test Cases/Test Strategy with input from assigned business analysts and data architect.

●Reported accurate testing status and created test summary reports.

●Developed, Enhanced, and Maintained automated testing scripts with QTP for Regression, system Testing.

●Enhanced scripts by putting database checkpoints using QTP.

●Continuously improved test models, test data, and test processes based on lessons learned.

●Responsible for data refresh/migration and served as point-of-contact for the BID Data Pipe Team for the QA environment on WSQEAP01.

●Written several complex T-SQL queries for validating/verifying the business rules for Data.

●Tested data coming through various lines of business applications & databases like IPOS, OPUS, PDCLITE, RWOT and IMEFlex systems.

●Automated the manual testing process in QTP to test ETL

●Validation of reports generated in excel sheet and data comparison using QTP Scripts

●Uploading Text file(Flat file),copied data from text file to excel sheet for data comparison using QTP scripts

●Coordinated component and system testing with the appropriate technical groups and Release Management and documented test procedures and findings.

●Involved in extensive DATA validation using T-SQL queries and back-end testing for SQL Server.

●Validated the data of reports by writing T-SQL queries in PL/SQL Developer against ODS.

●Used TOAD, SQL developer software for querying the Oracle databases.

●Used Teradata SQL Assistant 12.0 for accessing Teradata database on DEV, QA and Production areas.

●Created test mappings and MLOAD scripts for testing purposes.

●Tested Business Objects reports and Web Intelligence reports.

●Managed user accounts and security using Business Objects Supervisor

●Used Maestro scheduler for composing and executing jobs to simulate the production environment in QA.

Environment: ETL (Informatica 8.5.1, Power Center), Business Objects XIR2, Unix, QTP 8.0, Mercury Quality Center 8.2 (Test Director), Maestro Conman Scheduler, IBM Rational Clear Quest, Rational Functional tester, SQL Server 200, T-SQL, Oracle 10g, TOAD, Teradata V2R6, Teradata SQL Assistant, T-SQL, SQL Developer

Charles Schwab, SFO, CA Sept ‘2005 – Mar ‘2006

DWH Tester

Responsibilities:

●Responsible for business analysis and requirements gathering.

●Involved in writing the Test Plan, developed Test Cases and supported all environments for testing.

●Involved in preparation of Test Plan, Test Cases, Test Scripts, and Test Scenarios.

●Written Test Cases and performed Manual Testing like Positive Testing and Negative Testing.

●Performing Functional, Integration, System, Regression and User Acceptance Testing (UAT).

●Prepared test cases by understanding the business requirements, Data Mapping documents and technical specifications.

●Extensively executed SQL queries in order to view successful transactions of data and for validating data.

●Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.

●Was involved in analyzing scope of testing the application. Test Strategy was created to test the all modules of the Data Warehouse.

●Created the test data for interpreting positive/negative results during functional testing.

●Involved in the whole testing life cycle covering the entire project from initiation to completion

●Clearly communicated and documented test results and defect resolution during all phases of testing.

●Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity.

●Used SQL queries and custom programs to perform data validation.

●Used Teradata SQL Assistant for data retrieval and querying.

Environment: SQL, PL/SQL, XML, XSLT, XML Spy 4.3, .NET, IBM AIX 5.3, KORN SHELL SCRIPTING, Informatica Power Center 8.1/7.1, (Power Center Designer, Workflow Manager, Workflow Monitor), Rational (RUP, ClearCase, ClearQuest), Teradata V2R5 (SQL Assistant, Fast Load, Multi Load, TPUMP), Oracle 10g, Business Objects 6.5.1/XIR2, WebI XIR2, SQL Server 2005, Erwin 4.0, UNIX, Windows 2000, TOAD

WIPRO Technologies, Bangalore, INDIA. Feb ‘2004 – Sept ‘2005

ETL/Data Warehouse Tester

WellPoint is the nation's leading health benefits company serving the needs of approximately 34 million medical members nationwide. It is offering a broad range of medical and specialty products. WellPoint is a Blue Cross or Blue Cross Blue Shield licensee in 14 states: California, Colorado, Connecticut, Georgia, Indiana, Kentucky, Maine, Missouri, Nevada, New Hampshire, New York, Ohio, Virginia, and Wisconsin.

The goal of Enterprise Data Warehouse (EDW) program is to create a single, authoritative source for analytical reporting. The flow of this project is to getting the data on to the Enterprise Data Warehouse (EDW) using the Persistent Data Source (PDS) as the Input. Taking the PDS as input and applying all the business rules and transformations, the data would be loaded onto the Target Data Base, which is standing on Universal Data Base (UDB). Loading of data into the EDW is done using the ETL Tool Informatica. Loading of data into EDW process need to be scheduled using Informatica scheduler

Responsibilities:

●Extensively used Informatica power center for extraction, transformation and loading process.

●TOAD is used to perform manual test in regular basis. UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.

●Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

●Tested ETL informatica mappings for several data feeds.

●Executed UNIX jobs for testing needs.

●Preparing and supporting the QA and UAT test environments.

●Tested different detail, summary reports and on demand reports.

●Communicated discrepancies determined in testing to impacted areas and monitored resolution.

●Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Test Director

●Prepared Test status reports for each stage and logged any unresolved issues into Issues log.

Environment: Informatica (Power center 6.1), Oracle 9i, TOAD 7.8, UNIX, Shell Scripting, SQL Server, Erwin Data Modeler 4.1, Cognos.

Contact this candidate