SUMMARY

• Over 11 years of experience in end to end development of software applications using Data Warehouse methodology in various phases of IT projects such as System Analysis, Design, Coding and Testing. Extensive experience in the implementation of Data Warehouse/ Data marts for business applications in Financial, Banking, Media and Pharma Domains.
• 10+ years of strong QA (Testing) and Data Warehousing experience in building and managing various Data Warehousing / Data marts using Informatica products such as InformaticaPowerCenter 7.1/7.0/6.1/6.2.1/5.1/4.7 , PowerMart 6.2/5.1/4.7, PowerConnect, PowerAnalyzer, and Power Exchange tools.
• 10+ years of experience in RDBMS technologies like Oracle8x/9x, DB 2 8.0/7.0/6.0 , Teradata V2R5/V2R4/V2R3, MS SQL Server 2000/7.0/6.5 , Dbase, Exceland MYSQL.SQL Developer, TOAD, Quest Central for DB2.
• 10+ Years of experience in Relational modeling and Dimensional modeling (Star schema and Snowflake schema with FACT & Dimensions tables using Kimball and Inmon methodologies) and experience in logical and physical data modeling with Erwin 4.5/4.0/3.5.5/3.5.2 , MS Visio.
• Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures, Triggers.
• Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

TECHNICAL SKILLS

ETL Tools: InformaticaPowerCenter 7.1/7.0 (Repository Manager, Designer, Workflow Manager)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager. Repository manager administration)/5.1/4.7(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), PowerMart 6.2/5.1/4.7/1.7

BI&Reporting: QlikView 11.20 SR10

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

Databases: Oracle 9i/8i/7.3, MS SQL Server 2000/7.0/6.5 , IBM DB2 UDB 8.0/7.0/6.0/5.0 , DB2/400, Sybase, Teradata V2R5/V2R4, Sunopsis, MS - Access and MYSQL.

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux (RedHat),MS-DOS

Languages/ Utilities: SQL, PL/SQL, SQL Developer, TOAD, Quest Central for DB2,UNIX shell scripts (Cron, C), Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, East Windsor, NJ

Sr.ETL Tester

Responsibilities:

• Identified data quality challenges which were addressed to solve business needs.
• Involved in reviewing FRD, Technical specification document and created Test plan.
• Created Traceability Matrix to ensure all requirements are met.
• Experience with coordinating offshore development team on the requirements documentation, functional design, assembly testing, and user acceptance testing of Data Warehouseenhancements/upgrades
• Tested ETL code dat TEMPhas been supplied to ensure the requirements are being met andworked as single point of contact for the project, coordinated with business units for UAT testing
• Involved in writing complex SQLscripts to validate the database tables and BO reports.

Environment: Oracle 12.9, Toad for data analysts3.0,HP PPM v9.31,Informatica 9.6.1,MS office 2013,SQL, BO v4.2

Confidential, New york, NY

Sr.ETL Test Analyst

Responsibilities:

• Involved in reviewing Functional requirement specification document and Technical specification document to create Test Cases and Test Scripts
• Involved in executing the Test cases /Scripts as part of formal SIT / QA testing and Defect Management to ensure Quality Assurance and to test all the business requirements.
• Extensive experience in developingSQLscripts to validate the databases tables and reports data for backend database testing.
• Involved in monitoring Oracle and Vertica batches which loads data in to dimension and fact tables.
• Involved in Testing Tableau Data layers such as Net Revenue summary,Sales MIS Revenue,CP-Prod 360 RPT Ran coverage,Equity full
• Involved in testing Compass Reports related to Net revenue, Hard dollar, Retention, Gross execution and Research commissions.
• Experience in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Involved in reviewing Business requirement document and Functional requirement specification document to develop Test Plan.
• Involved in executing the Test cases /Scripts as part of formal SIT / QA testing.
• Involved in Qlik view/Dashboard Testing by comparing against the Database for Daily and Monthly summary reports with respect to Business Line, Deal Type and Customer Group.
• Extensive experience in developingSQLscripts to validate the databases tables and reports data for backend database testing.

Environment: DB2/AIX64 v10.5.5, HP ALM v11.52, SQL Server database v 12.0.4422.0 , Toad Data Point 3.7, QlikView 11.20 SR10,MS Visio 2010, MS Excel 2010, MS Word 2010,InformaticaPowercenter v9.1.

Confidential, Bridgewater, NJ

ETL Test Lead - Data warehousing QualityAnalyst

Responsibilities:

• me was extensively involved in reviewing Functional requirement specification document to develop Test cases.
• Responsible for writing Test cases/scripts for development and formal Testing.
• Involved in implementation of Test scripts to support Agile software development of a Clinical Data Hub.
• Responsible for creating and executing the Test cases /Scripts as part of formal UAT / QA testing.
• Lead team of 3 Onsite .
• Interacted with Business and Technical partners to get a clear understanding of the requirements.
• Involved in developing complex SQL scripts by using SQL developer for validating ETL transformations and executed them against the appropriate databases.

Environment: Oracle 11g, Oracle SQL Developer v3.2.2, HP ALM v11.0, Windows 7Enterprise, MS Visio 2010, MS Excel 2010, MS Word 2010,InformaticaPowercenter v9.1.

Confidential, New Brunswick, NJ

ETL Test Lead - Data warehousing QualityAnalyst

Responsibilities:

• As a Data warehousing Quality Analyst was involved in
• As a Functional tester me was involved in performing System Testing, System Integration Testing and User Acceptance Testing.
• Tested all the new requirements manually in test environments and ensure dat the new and existing functionality is working as expected.
• Performed as Onsite Offshore co-coordinator and communicated with Offshore team regularly by Leading team of 5 members.
• Prepared Test Plan, High Level Test Cases and Detailed level Test cases.
• Extensively involved in reviewing User Requirements Specification, Functional Specification and Technical Design Specification.
• Involved in reviewing and writing Test Scripts, Test data Load sequence, Test case sequence, Test Data management and in capturing Test evidence.
• Involved in validating User Interface requirements by using the Informatica Data Director interface which allows the user to search, view and maintain data.
• Queries were ran against the databases to compare the source data to the Target data for validating the implementation of all the business rules for various subject areas such as Employee, Job, Location, Finance, Organization, Position, Event, Compensation and Talent.
• Involved in validating various Business scenarios such as New Hire, Rehire, Terminate, Job change, Location change etc.

Environment: InformaticaPowercenter v9.1, Oracle 11g, Oracle SQL Developer v3.2.2, WebLogic 10.3.6, Teradata v13.1, HP QC v10.0, Windows 7Enterprise, MS Visio 2010, MS Excel 2010, MS Word 2010.

Confidential, Pennington, NJ

Sr.ETL Tester - Data warehousing QualityAnalyst

Responsibilities:

• Interacted with Business and Technical partners to get a clear understanding of the requirements.
• Involved in developing SQL scripts for validating Data Survivorship, Branch Rollup, House holding, ETL Process, Outbound Feeds, Id Resolution process, Correlation Process, BAU Process, Delta Loads from PATH and KD.
• Involved in Data conditioning, Data Mining and Data cleansing for various projects.
• Involved in validating the Unique ID generated by GWIMHUB is unique only across GWIM systems and verified if GWIM Hub is sending all Basel required customer data elements to GDPP for provisioning to ECRIS for all customers maintained on the GWMHUB/Index.
• Extensively used SQL developer to develop the queries and executed them against the appropriate databases.
• Queries were ran against the databases to compare the source data to the Target data for validating the implementation of all the business rules.

Environment: Ascential Data stage 7.5.1A, Oracle 10g, Oracle SQL Developer v1.1.0.23, Rational Clear Quest v 2003.06.15.734.000 , HP QC v9.2, Windows XP Professional, MS Visio 2007, MS Excel 2007, MS Word 2007

Confidential, NY

Sr. QA Tester

Responsibilities:

• Extensively involved in writing Test Plan, Test Cases, based on Business Requirement Documents, Functional Requirement Specifications, and Design Specification document generated and executed Test Scripts.
• Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
• Created a weekly project status format and issue log for weekly meeting
• As a QA Analyst me was required to provide technical quality assurance for web based applications, meeting both company standards and end-user requirements.
• Written Test Plans and Test Cases on Mercury’s Quality Center Tool.
• Involved in functional testing of GABRIEL application.
• Worked with Oracle database to compare the results from front-end data values with backend data values.
• Extensively used SQL queries for Database testing and Validation.
• Involved in extensive backend testing.
• Developed Test Cases for testing the mapping designs before going to the production phase.
• Worked with Toad for data retrieval.
• Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
• Involved in all testing phases: Unit Testing, System Testing, Regression Testing, Integration Testing, and Quality Assurance Testing.
• Used Rational ClearQuest the defect tracking tool for retesting the CQ’s and creating the new issues using the CITRIX as webInterface.
• Modified the UNIX scripts for Testing purpose to check the Rollback mechanism, Restatement window logic, wrapper scripts etc.
• Involved in executing the UNIX shell scripts for loading the data from the Source to the Datamarts.
• Tested the data and data integrity among various sources and targets.

Environment: Oracle warehouse Builder 10g, Oracle 10g, Flat Files, PERL,SQL, PL/SQL, SQL * Loader, UNIX(Cygwin), TOAD 9.5, UNIX Shell Scripting, HP Quality Center 9.2, Rational Clear Quest, Windows XP Professional, Citrix 8.0, WinRunner 8x, .NET.

Confidential, NY

Sr. QA Tester

Responsibilities:

• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Well exposed to Software Development Life Cycle and Test methodologies.
• Extensively involved in writing Test Plan, Test Cases, based on Business Requirement Documents, Functional Requirement Specifications, and Design Specification document generated and executed Test Scripts.
• Worked with SQL to compare results from front-end data values to backend data.
• Developed complex queries using different data providers in the same report.
• Heavily interacted with ETL team for testing data Quality and data Validation.
• Written several backend SQL queries and was involved in enhancing the performance by tuning the SQL queries.
• Involved in creating Test Matrix for various work streams for traceability purposes.
• Involved in writing Test cases for all the links and various data files based on ETL Mapping document by Test Director.
• Worked with several sources for understanding the business needs for performing both positive and negative testing.
• Executed UNIX Shell Scripts for Batch Job Execution.
• Written several UNIX scripts for running test loads for regression testing purpose.
• Responsible for weekly status Reports, Performed functional, Integration, Regression testing.

Environment: Ascential Data stage 7.1, DB2 9, MS SQL Server 2000, SQL, Win SQL Professional, Windows XP Professional, Novell client 4.91, IBM AIX 5.1, MS Visio 2003,MS Excel 2003, LoadRunner 7x, Lotus notes 6, PeopleSoft 8, Oracle10g, Erwin 4.0, Toad.