PROFESSIONAL SUMMARY:

• Eight Years of prevalent IT experience Exceptionally in Data Modeling working as an Data Modeler / Data Analyst in Analysis, Design, Data Modeling ( Conceptual, Logical and Physical) for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP)Experienced with data analysis using several tools including Data Flux, Trillium and IDE.
• Vast knowledge of Software Development Life Cycle & its methodologies, expert in Quality Assurance testing of Web Based, Client/Server, ETL and BI applications.
• Have a good knowledge on Informatica MDM - Data Mappings (Landing, staging and Base objects), Data Validation, Match and Merge rules, Customizing/ Configuring Informatica  Data Director (IDD) applications. 
• Expert in using the Agile/Scrum and Waterfall testing lifecycle Methodologies
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Experienced with ETL tools like Informatica, SSIS, and Ab Initio and Data stage.
• Strong experience in testing BI reports like Cognos Reports, Microstrategy, Business objects reports and Hyperion.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Expertise in test strategy design based on the various types of testing including integration, function, system, End to End, load, stress and performance testing, Backend (Database) Testing.
• Performed   Data Centric testing  to validate the data   that is loaded in to the   data  warehouse is correct as per the defined business rules.
• Experience in both manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front-end and raw feed by developing and executed complex SQL queries for data base.
• Proficient in SQL query and testing RDBMS such as SQL Server, Oracle, MySQL for data validation. Expertise in Microsoft office (Word, Excel, Power Point, Outlook & Visio)
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Interact with clients for Quality discussions and responsible for the QA deliverables.
• Sound Knowledge and experience in Star schema/Snowflake schema.
• Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Strong working experience in Windows NT/2000/XP and UNIX environments
• Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Clear QUEST, Bugzilla, and Email (outlook)
• Excellent Communication and interpersonal skills with clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS:

ETL Tools: SSIS 9.0,Informatica 9.1/9.0.1/8.6.1/8.1/7.1/6.2/5.1 (Power Mart/Power Center) (Designer, Workflow Manager, Workflow Monitor, Server Manager, Power Connect), Informatica DVO, Data stage 8.1, Ab Initio (GDE 1.15, CO>Op 2.15)

Data Modeling: Erwin 4.0/3.5, Star Schema Modelling, Snow Flake Modelling

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

OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XIR3/XIR2/6.x/5.x, Microstrategy.

Languages: SQL, PL/SQL, Visual Basic, XML, C, C++

Tools: Toad, SQL* Loader, SQL Assistant,

Operating Systems: Windows 2003/2000/NT, AIX, Sun Solaris, Linux

Testing Tools: QTP 10/9.2, Quality Center 10, Test Director

Rational Tools: RUP, Rational Clear Case, Clear Quest, Test Manager, PVCS, Rational Requisite Pro, IBM Rational Manual Tester

Workflow Tools: MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

Job Schedulers: Control M, AutoSys, Maestro

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Quality Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Used Erwin Data Modeler tool for relational database and dimensional data warehouse designs.
• Used SQL for Querying the DB2 database in UNIX environment.
• Hands on Experience with Enterprise MDM Solution, Data Governance and Data Quality.
• Responsible for planning and directing Quality Assurance and Software change control policies.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns and data types.
• Performance tuning heavy queries and optimizing Informatica MDM jobs.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Experienced in working with Data Privacy & indentifying the regulations including State, Federal & International Regulations.
• Wrote queries, SSRS reports using data warehouse to analyze how our products are helping our clients to increase ROI for their business with different variables.
• Tested the   ETL  mappings and other   ETL Processes ( Data Warehouse Testing).
• Coordinated in setting up Test Environments and Test Plan needs with team members.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records. 
• Worked with the ETL processes using Informatica tool to extract the data from sources like Oracle, Flat files, Teradata thereby loading the data into the target Data warehouse.
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT.
• Executed Test Cases using positive and negative data in Quality Center’s Test Lab and reported results and defects using Quality Center’s Defects tool.
• Created well detail Manual Test scripts in HP ALM to test application Functionality, End to End, GUI, Look & Feel, and Content.
• Worked in AGILE-SCRUM Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Involved in validating the Data mart tables as per the business logic applied to the staging tables.
• Executed the test scripts against TeraData source and validated the rules according to mapping documentation.
• Testing and validation of the developed Informatica mappings.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Prepared Traceability Matrix with requirements versus test cases.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Involved in identifying the defects and developed Defect Tracking report using Mercury Quality Centre which involved Bug life cycle.
• Provided daily and weekly status reports .

Environment: Informatica Power Center 9.1, MDM, SSRS, Erwin, Quality Center ALM, Ms Excel, Teradata SQL Assistant 6.0, MS Access, Oracle 11g, DB2, SQL, PL/SQL, Teradata utilities, TOAD, Autosys Scheduler, UNIX, Windows 2000

Confidential, Londonderry, NH

ETL Tester/ Data Quality

Responsibilities:

• Analyzed the Functional requirements using Scenarios & DDD(Detailed Design Document)
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Generated the detailed reports of the Bugs, go no go reports and comparison charts.
• Experience in data analysis, data integration, conceptual data modeling or metadata creation.
• Involved in maintaining Data Privacy, improving Data Security and identifying the systems where the critical data resides.
• Involved in Manual and Automated testing using QTP.
• Involved in writing the test cases and Test plans based on Informatica Mappings Transformation Matrix or (Traceability Matrix) for supporting Black box and White Box testing.
• Tested data flow by introducing staging, transaction, and data warehouse and data mart area. This design provided more control on data flow and data validation. 
• Conducted Black Box - Functional, Regression and Data Driven.
• Design, develop, maintain and create Relational Database Management system using Erwin
• Analyzed the source data coming from Oracle, SQL server, MS Access, flat files. Worked with Data Warehouse team in developing Dimensional Model. Designed and developed Star Schema.
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Teradata data warehouse .
• Validate MDM for standardization, transformation, data clean, application integration, data flow, data quality, redundancy based on business requirements in agile methodology.
• Created Test Strategy, Test plans Test cases, and Test scripts and various other project documentation in HP Quality Center/ALM
• Tested whether the Business Objects reports developed in OLAP are as per company standards.
• Used Quality Center/ALM for test planning and execution and Rational Clear Quest was used for defect tracking.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Involved in Uploading Master and Transactional data from flat files and preparation of Test cases, Sub System Testing.
• Developed UNIX Shell scripts to automate repetitive database processes
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Extracted data from flat files and RDBMS tables and upload into targets Oracle tables. Used Informatica as the ETL tool to extract the data from sources and loading it into targets.
• Involved in testing timeline scheduling with the lead.
• Did testing of SOA end to end, Service by service and Interface by Interface
• Helped in identifying effort estimations related to testing efforts to Project Management Team
• Tested SOA application interface and communication paths.
• Tested data feeds from XML to Database.
• Development of test plan, test case and test scripts in Quality Center after for functional, system integration, Usability, security testing.
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested reports for various portfolios using universe as the main data provider.
• Tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity.
• Generated XML data files using XML Spy.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Informatica Power Center, MDM, Business Objects XIR3, QTP, User Acceptance Testing (UAT), Autosys, SQL Server 2005, Quality Center/ ALM, PERL, Oracle 10g, Java, TOAD, Unix AIX 5.2,VB Script, XML, XSLT, XML Spy, SQL, PL/SQL, MS Excel, Shell Scripting, SOAP, SOAPUI, Web Services, OLAP, Teradata V2R6

Confidential, Chicago, Illinois

Technical Data/ETL Analyst

Responsibilities:

• Developed business data feeds document for data mapping needs for ETL and BI purpose to migrate the data
• Written complex SQL queries for querying data against different data bases for data verification process.
• Written extensive PERL scripts for various needs including text processing, data parsing and database connectivity.
• Involved in testing data mapping and conversion in a server based data warehouse.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Extensively used SQL programming in backend and front-end functions, procedures, and packages.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Involved in the data synchronization testing from MDM to legacy system 
• Tested Microstrategy reports for business reporting needs.
• Tested dashboards using Microstrategy for business analysis. 
• Setting up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5.
• Extensively used Informatics power center for extraction, transformation and loading process.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Environment: Informatica Power Center (Power Center Designer, MDM, workflow manager, workflow monitor), Autosys, Microstrategy, Mercury Test Director 6.5, QTP 7.2, SQL *Loader, XML, PERL, UNIX Shell Scripting, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, Teradata V2R4

Confidential

Software Engineer

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project.
• Written PERL scripts and UNIX Shell Scripts for various data comparison and data parsing needs.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts.
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Used SQL*Plus for updating the database and for data retrieval.
• Did unit testing, manual testing of the processes to check the integrity.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Work with java developers to repair and enhance current base of PL/SQL packages to fix production issues.
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Environment: Oracle 7.0, SQL*Plus, SQL, Test Director, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, XML, XSLT, Java and UNIX, Korn Shell scripting, PERL