SUMMARY

• I have over 7+ years of solid IT experience in teh 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.
• 3+ years of ETL and data integration experience in developing ETL mappings and scripts using Informatica Power Center 7.1/6.2/5.1 and Power Mart 6.2/5.1 using Designer (Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer), Repository Manager, Workflow Manager & Workflow Monitor
• Extensive testing ETL experience using AbInitio 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 wif RDBMS, VSAM Files, Flat files and XML.
• Experience in testing and writing SQL and PL/SQL statements.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos 7.3 Series and Business Objects XI R3
• Solid knowledge and experience in SQL database and writing SQL Queries for backend/database testing.
• Involved in writing and executing test cases, enhancing test scripts, reporting, finding defects and documentation.
• Having excellent understanding of Functional and non-Functional testing.
• Performed Functional, and Regression testing.
• Experienced in ETL Testing, BI Testing, and Data Quality Issues & Data Reconciliation process.
• Automated and scheduled teh Informatica jobs using UNIX Shell Scripting.
• Experience in all phases of Software Development life cycle.
• 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

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, New Jersey

ETL QA Tester

Responsibilities:

• Data quality checking and interacting wif teh business analysts.
• Good experience in communicating wif offshore team
• Communication wif teh client for weekly status report
• Created test data that includes all scenarios and created several scenarios to test teh referential integrity between tables.
• Prepared Test Plan and Testing Strategy for teh project.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Designed and developed UNIX shell scripts as part of teh ETL process to automate teh process of loading, pulling teh data for testing ETL Test loads.
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve teh system performance.
• Executed SQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Conducted review sessions on test case and regression test scripts in quality center.
• Promoted Unix/Data Stage application releases from development to QA and to UAT environments
• Written complex SQL statements for data reconciliation including comparing record counts between source data, data loaded to teh warehouse and rejected records.
• Reported bugs and tracked defects using Quality Center
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif data quality issues.
• Involved in data warehouse testing by checking ETL procedures/graphs.
• Performed teh tests in both teh SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Tested teh messages published by data stage and data loaded into various databases
• Strong ability in developing advanced and complex SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying teh tables and columns from which data is extracted
• Tested several data migration application for security, data protection and data corruption during transfer
• Tested various Mappings using Aggregator, Joiners, Lookups, Filters, Router and Update strategy
• Unit testing performed on Mappings.
• Tested teh ETL process for both before data validation and after data validation process.
• Tested wif Front-end functionality for teh entire application
• Involved in validating both functional and automated business processes using HP Quality center.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve teh system performance

Environment: Data stage, UNIX, Shell Scripting, Teradata 12.0, T-SQL, Teradata SQL Assistant 12.0, MLOAD, FLOAD, FEXPORT, TPUMP, BTEQ, SAS/Base 9.1, SQL, PL/SQL, Quality Center 10.0, Oracle 10g, Cognos Series 8.0, Report Net, Impromptu, Report Studio, SQL Server 2008, CA Erwin 7.x, UNIX, Windows 2000, TOAD, WinSQL, Ultra Editor, XML Spy 2010, XSD, XML

Confidential, Manhattan, New York

ETL QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Tested/Found teh defects in universes and reports. Used Mercury Quality Centre for tracking teh defects.
• Extensively used Data Stage for extraction, transformation and loading process.
• Validated parent-to-child relationships in teh data. Set up data scenarios that test how orphaned child records are handled.
• Validated and corrected teh dependency fields and check teh same values against lookup tables.
• Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
• Worked as ETL Tester responsible for teh requirements / ETL Analysis, ETL Testing and designing of teh flow and teh logic for teh Data warehouse project.
• Extracted Data from Teradata using Data Stage ETL and DTS Packages to teh target database including SQL Server and used teh data for Reporting purposes
• Responsible for testing teh reports according to client’s requirement using Business Objects 6.5.1.
• Created Short-cut joins, aliases and contexts to make teh universe loops free.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• 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.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking teh log files
• Used various Functions like Prompt (for user defined queries), Where (For creating conditional filters), and Select for testing Business Reports wif various boundary conditions.
• 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
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries.
• Used Quality center to manage teh requirements, test cases and also log defects and generate defect reports and graphs
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of teh reports and feeds.
• TEMPEffectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Used Quality Center to create manual and automated tests, build test cases, Test cycles, run tests, report and track defects.
• 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 wif migration from development to testing.
• Designed and developed UNIX shell scripts as part of teh ETL process, automate teh process of loading, pulling teh data.
• Defects tracking, review, analyze and compare results using Quality Center.
• Validated cube and query data from teh reporting system back to teh source system.
• Tested analytical reports using Analysis Studio

Environment: Data Stage, SQL *Loader, Quality Center, Business Objects XIR2, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, XML, XSLT, XML Spy 2008, Oracle 10g/9i, SQL Server 2005, Erwin 3.5/4.1, Windows 2000, TOAD 7

Confidential, Middle Town, New Jersey

ETL Test Engineer

Responsibilities:

• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs
• Worked wif Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented teh validation rules, error handling and test strategy of teh mapping.
• Tuned teh complex SQL queries for better performance by eliminating various performance bottlenecks.
• Lead team of 6 people in Quality Assurance Team.
• Compared teh actual result wif teh expected results. Validated teh data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding teh 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 teh front-end data wif backend.
• Conducted back to back meetings wif developers and discussed about all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked wif 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 wif 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 6.1, Quality Center, Windows NT, Micro Strategy, Oracle 8i, SQL Server, SQL, PL/SQL, SQL*Plus, Toad, VSAM Files, XML, XSD

Confidential, New Jersey

DW Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed teh functional specs provided by teh data architect and created technical specs documents for all teh mappings.
• Implemented Materialized Views using P/SQL for loading extended tables
• Tested logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted teh data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in teh Database, created Automated scripts, defined storage parameters for teh objects in teh Database.
• Defined various facts and Dimensions in teh data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Tested Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center/Mart to design multiple mappings wif embedded business logic.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in teh Informatica Designer.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to teh end users and created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings.
• Used shell scripts for automating teh execution of maps.
• Designed and developed Oracle PL/SQL scripts for Data Import/Export.
• Created and tested various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained teh batch processes using Unix Shell Scripts.
• Designed and Deployed UNIX Shell Scripts.
• Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica 7.1.1, DB2, Teradata, Toad, Erwin 3.0, SSRS, SSAS, XML Files, Oracle 8i and Toad