SUMMARY:

• I have over 7 years of solid IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using query tools for Oracle, Teradata, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensive testing ETL experience using Ab Initio 2.14, Informatica 8.6/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• 5+ years of database experience using Oracle 10g/9i/8i, SQL, PL/SQL, SQL*Loader, Stored Procedures, Functions, TOAD, Constraints, Triggers, Indexes - B-tree Index, Bitmap Index, Views,, Inline Views, IBM DB2 UDB 8.0/7.0 & MS Access.
• Extensively worked on Data Extraction, Transformation, and Loading with RDBMS, VSAM Files, Flat files and XML.
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in designing the database and data elements associated with the database
• Worked on managing large and complex data sets, extracts, clean and format data for Data Analysis using MS Excel, MS SQL etc.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
• Strong with Mercury Test Director & Quality Center for Planning, Maintaining, Executing Test Cases, Defect Management, Bug Tracking and QTP 9.2 for regression Testing.
• Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Extensively worked on MS Access, MS Excel, Power Design, MS Visio, MS PowerPoint, MS Project, and SQL.
• Excellent written and verbal communication skills including experience in proposal and presentation creation.

TECHNICAL SKILLS:

ETL Tools: Ab Initio, (GDE 1.15, Co>Op 2.15), EME, Data Profiler, Informatica 8.6.1/8.1/7.1/6.2/5.1, SSIS, Data Stage 7.5

Data Modeling: Erwin 7.3, Star Schema Modelling, Snow Flake Modelling

Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005, DB2 8.x, Teradata 12.0, Sybase 12.5, MySQL

BI/OLAP Tools: Cognos 8.0/7.0/6.0, Business Objects XI R3/R2/6.x/5.x

Languages: SQL, PL/SQL, Unix Shell Script, Visual Basic, XML, PERL

Tools: Toad, SQL* Loader, WinSQL, Teradata SQL Assistant

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

Testing Tools: QTP, WinRunner, LoadRunner, Quality Center 9.2, Test Director, Rational Clear Quest

Version Control: Rational Clear Case, CVS, VSS, PVCS

WORK EXPERIENCE:

Confidential, Boston, MA

Sr. ETL Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• As a ETL Tester responsible for the business requirements, ETL Analysis, MVS, ETL test and design of the flow and the logic for the Data warehouse project using Informatica, Shell Scripting & PERL
• Used Mercury Quality Center tool to store and maintain the Test cases
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Conditional testing of constraints based on the business rules
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
• Used Quality Center for writing and executing Test Scripts.
• Distributed the reports to the users via Cognos Connection.
• Compared query result sets from different database systems using UNIX diff command.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Preventing occurrences of multiple runs by flagging processed dates.
• Preparation of various test documents for QA process in Quality Center
• Written Test Cases for ETL to compare Source and Target database systems.
• Testing of records with logical delete using flags
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations

Environment: Informatica 8.6.1/8.1, XML, XSLT, PERL, WinSQL, SQL Server 2008, QTP, Quality Center 10.0, DTS, T-SQL, SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, MVS, IBM DB2, SAS, Cognos ReportNet8.0, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Charlotte NC

ETL/SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested/Found the defects in universes and reports. Used Mercury Quality Centre for tracking the defects.
• Validated parent-to-child relationships in the data. Set up data scenarios that test how orphaned child records are handled.
• Validated and corrected the dependency fields and check the same values against lookup tables.
• Tested graphs for extracting, cleansing, transforming, integrating, and loading data using Ab Initio ETL Tool.
• 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.
• Created Short-cut joins, aliases and contexts to make the universe loops free.
• Involved in installation of Business Objects XI R2 and assisted in creating users and assigning them appropriate access rights
• Report defects using Quality Center and interact with developers to resolve any defects/issues.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested and worked on creating open document reports for business.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Written complex joins to validate query performance on large database volumes and worked with business users for acceptable performance criteria for each query.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Planned, coordinate and execute Business Objects deployment for End-users and documented the entire project.
• Responsible for testing the reports according to client’s requirement using Business Objects.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Ab Initio (GDE 1.14, Co>Op 2.14), EME, SQL *Loader, Business Objects XIR2, Quality Center, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy 2008, Oracle 10g/9i, Quality Center, SQL Server 2008, Erwin 3.5/4.1, Windows 2000

Confidential, Jersey City, New Jersey

ETL/QA Tester

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively tested several ETL Mappings developed using Informatica.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Performed defect tracking and test case management by Mercury Quality Center 8.2.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Environment: Informatica Power Center 7.1, Quality Center 8.2, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Confidential, California

ETL/QA SQL Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Designed the data flow diagrams using MS VISIO.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Worked with SSIS system variable, passing variables between packages.
• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.
• Tested different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services.
• Creating test cases for ETL mappings and design documents for production support.
• Scheduling and automating jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Reported bugs and tracked defects using Test Director 6.5
• Worked with ETL group for understating mappings for dimensions and facts.
• Worked on issues with migration from development to testing.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

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

Confidential, Bethpage, NY

ETL Test Analyst

Responsibilities:

• Writing test plans and test scripts
• Written complex SQL queries.
• Coordinating with user to gather the new requirements and working with existing issues.
• Involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications
• Performed testing in mainframe environment
• Recorded Testable and Non Testable requirements in spreadsheet.
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in functional, system, integration and performance testing.
• Assigned defects to developers through Test Director.
• Updated the defects status in Test Director.
• Reported periodic project status and updates to the QA Lead and QA Manager
• Heavily involved in interacting with UNIX Shell scripts

Environment: Windows NT/2000, Oracle 8i, SQL, PL/SQL, XML, PERL, UNIX, Manual Testing, Test Director 8.0.