SUMMARY

• Highly Skilled Professional 7 years of IT experience in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Extensive experience in data warehousing and business intelligence using various ETL tools primarily Informatica, Data Stage, Business Objects, Cognos 8 suite of products.
• Experience testing Complex mappings using various transformations available in Mappings
• Experience with Teradata as the target for the data marts. Worked with BTEQ, FastLoad, MultiLoad, TPUMP and Teradata SQL Assistant.
• Heavy experience in working with COBOL VSAM files, XML, Relational data and Flat Files.
• Proficient working with Unix/Linux environments and writing UNIX shell scripts.
• Experience tested slowly changing dimension methodology and slowly growing targets methodologies.
• Experienced in system analysis, design, Quality Assurance, and automation of testing.
• Experienced in the different types of testing dat include System testing, Integration testing, Functional testing, User Acceptance testing (UAT), Black Box Testing, Stress/Load Testing, Manual and Regression testing with automated testing tools. Experience in Writing Test plans, Use Cases, Test cases, and System design & Requirement analysis.
• Strong in developing Test plans, Test cases, Test data, Defect Tracking & Reporting, Ability to perform under deadlines, good individual and team player
• Managed the process of data creation for testing purposes.
• Experience in testing SCD Type 1, Type2 and Type3
• Experience working with SDLC, RUP, Waterfall and Agile methodologies.
• Experience with OLAP, ROLAP and other BI tools.
• Solid experience with Database migration and data cleansing.
• Expert in Oracle development (PL/SQL, Forms, Reports).
• Very strong in testing with Cognos version 8 (Report Studio, Framework manager, Metric Studio, Analysis Studio), Cognos Series 7 Impromptu, Reportnet 1.1 (Report Studio/ Query Studio).
• Experience in testing complex reports using drill - through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos. Expert in creating PowerPlay Reports.
• Expert in writing complex SQL Queries.

TECHNICAL SKILLS

ETL Tools: Ascential Datastage8.0,7.X/, Informatica Power Center 8.x/7.x/6.xBI Tools Cognos 8 BI Suite, 7.0 Series

Databases: MS SQL Server 2005/2008, Oracle 8i/9i /10g, Teradata 12.0, IBM DB2, Sybase

Client Side Skills: SQL, T-SQL, PL/SQL, UNIX shell scripting, Java, HTML, XML, CSS, JavaScript, C, C++, VB 6.0

Web Servers: IIS v5.0/6.0, Apache Tomcat

OS: Windows 2000/NT, UNIX/Solaris, Red Hat Linux, IBM AIX

Version Control: Visual Source Safe 6.0, CVS, PVCS

Tools: Toad, Erwin 4.1, Rational Rose, MS Project, MS Visio, Autosys

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

ETL Test Analyst

Environment: Ascential Datastage8.0,7.X/, Oracle 10g, Erwin 4.0, pmcmd scripting, Shell Scripting, TOAD, PL/SQL, HP QTP 9.2,HP Quality Center 9.2, UNIX, Cognos 8.4 Report Studio, Query Studio, Event Studio, MS Excel, MS Access, HP Quality Center 10.0, Rational Clear Quest.

Responsibilities:

• Involved with requirement gathering and analysis for the data marts focusing on data analysis, data quality, data mapping between ODS, staging tables and data warehouses/data marts.
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Worked on Data Stage Version Control Tool for Migrating jobs from one environment to another environment.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process
• Experience with Quality Center including administration, requirements, test planning/design, test lab/execution (i.e. Creating and executing complex test sets), and defect tracking.
• Quality Center customization of the Requirements, Test Plan, Test Lab, and Defects modules.
• Used HP Quality Center for testing activities.
• Involved in writing Test Plan and Testing Strategy.
• Developed various test scenarios based on ETL mapping document.
• Used Rational Clear Quest for bug tracking needs.
• Tested data warehouse objects - Fact tables, dimension tables, and association tables.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro.
• Tested with new transformation like Java transformation, Transaction Control.
• Tested various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer.
• Tested Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Extensively worked on type 1 and type 2 SCD.
• Wrote SQL queries to validate the business rules and data sources. Extensively used SQL Developer as Ad Hoc Query tool for Oracle.
• Analyzed the session logs, bad files and error tables for troubleshooting mappings and sessions for data reconciliation needs.
• Wrote shell script utilities to detect error conditions in production loads and take corrective actions.
• Generated SQL for views from query subjects in Framework model.
• Worked with Complex reports in Report Studio using master-detail relationship, drill throughs, drill up and drill down, burst options, PROMPTS.
• Tested several Cognos reports.
• Tested UNIX shell scripts for data loads.

Confidential, Charlotte, NC

ETL/BI Test - CRDW

Environment: Ascential Data stage 7.X/,, Oracle 10g, Erwin 4.0, pmcmd scripting, Shell Scripting, TOAD, PL/SQL, UNIX, PERL, HP QTP 9.2,HP Quality Center 9.2, Business Objects XIR2, VSAM Files, COBOL Copy Books, XML Files, Flat Files, Web Services.

Responsibilities:

• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems.and Involved in writing and executing test cases based on the requirements.
• Performed End-to-End testing of full functionality
• Experienced in using Mercury Quality Center as a defect tracking tool.
• Involved in Component Testing, Functional Testing, Integration Testing and Regression Testing.
• Involved in performing Regression testing manually for every new Releases.
• Worked on Waterfall and Agile both methodology.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Involved with the Solutions Architect and the Business Team for validation and verification of the ETL data loading.
• Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
• Worked in keyword view as well as expert view of Quick Test Pro
• Used SQL tools likeTOADto run SQL queries and validate the data in warehouse.
• Tested various mappings like Update Strategy, Look up, Sequence Generator, expression, Aggregator, XML, Stored Procedure and tested the mappings for data verification in Designer
• Did various data load simulations to stress test the mappings
• Tested the shell scripts to backup the log files and job scheduling in SIT, QA, UAT and Production.
• Co-ordinate with the off-shore teams and mentored junior QA’s.
• Tested the reports using Business Objects functionality's like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae's etc.
• Involved in trouble shooting of various reporting errors for testing needs.
• Tested Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports.

Confidential, Raleigh, NC

Sr. Test Analyst - EDWH

Environment: InformaticaPower Center 7.1.1, Oracle9i, IDQ, Perl Scripting, Cognos, PL/SQL, SQL Navigator, DB2, ERWIN, HP QTP 9.2,HP Quality Center 9.2,SQL Assistant, Teradata BTEQ, J2EE, HTML, XML Files, Flat Files.

Responsibilities:

• Generated test cases and procedures based on business rules and requirements for two web-based applications
• Managed individual test cycles, reported bugs and worked with analysts and developers to resolve problems.
• Involved in the development of test plan and test strategy; performed functional and structural analysis for the same.
• Tested various business rules of data transformations using various Informatica transformations like Normalizer, SourceQualifier, Update Strategy, Look up (connected/unconnected/static cached/dynamic cached), Sequence Generator, expression, Aggregator, XML(source and generator), Stored Procedures.
• Optimized QTP scripts for Regression testing of the application with various data sources and data types.
• Executed regression tests at each new build in QTP.
• Updated database tables to support the testing of ETL functionality.
• Used Teradata as a Source and a Target for few mappings. Worked with Teradata loaders within Workflow manager to configure FastLoad and MultiLoad sessions.
• Solely responsible for the daily loads and handling the reject data.
• Tested Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Used SQL tools like SQL Navigator to run SQL queries and validate the data in warehouse.
• Used workflow manager and work flow monitor to run and monitor jobs.
• Extensively worked with flat files and excel sheet data sources. Wrote batch scripts to automate flat file transportation local toInformaticaserver.
• Tested a number of complex ETL mappings, Mapplet and reusable transformations for daily data loads.
• Tested mapping parameters and variables to support SQL override.
• UsedInformaticaData Explorer andInformaticaData Quality for Data Quality Management and Data profiling purposes.
• UsedInformaticaData Quality to formulate data conversion and data cleansing rules.
• Generated PL/SQL and Shell scripts for scheduling periodic load processes.
• Generated Perl and UNIX Shell scripts for data validation, data collection and data importing.
• Associated with Production testing support team in various performances related issues.

Confidential, Pittsburgh, PA

DW Developer

Environment: InformaticaPower Center 6.2,InformaticaPowerconnect, OLAP, Oracle 8i, MS SQL Server 7.0/2000, PL/SQL, Erwin 3.5, Toad, Unix Shell Scripting.

Responsibilities:

• End-to-endETLdevelopment of the Data Mart. Data Quality Analysis to determine cleansing requirements. Designed and developed Informaticamappings for data loads
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management. Understand the business needs and implement the same into a functional database design
• Extensively usedETLandInformaticato load data from MS SQL Server, Excel spreadsheet, flat files into the target Oracle database.
• Worked onInformaticaPower Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis.
• Developed PL/SQL procedures/packages to kickoff the SQL Loader control files/procedures to load the data into Oracle. Tuning InformaticaMappings and Sessions for optimum performance.
• UsedInformaticafeatures to implement Type I & II changes in slowly changing dimension tables. Created and ran workflows and Worklets using Workflow Manager to load the data into the Target Database.
• Used PMCMD commands in non-windows environments.
• Performance tuning of SQL Queries, Sources, Targets and sessions.
• Responsible forETLprocess under development, test and production environments.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development Parsing high-level design spec to simpleETLcoding and mapping standards
• Maintain Development, Test and Production mapping migration Using Repository Manager. Also used Repository Manager to maintain the metadata, Security and Reporting
• Used windows Scripting and Scheduled pmcmd to interact withInformaticaServer from command mode. Modeling and populating the business rules using mappings into the Repository for Meta Data management.