PROFESSIONAL SUMMARY:

• Overall 4+ years of experience in System Integration Testing of web and ETL applications.
• Proficient in developing Test cases & Test plan for web based and data warehouse projects.
• Expert in writing complex SQLs, proficient in Data Comparison and validation of Data Integration and Data Migration.
• Extensive experience in Testing and Reviewing of Dimensional Modeling (Star and Snow flake) of data warehouse.
• Proficient in maintaining Testing deliverables: Test cases, Test results and Defects in HP ALM 12.0 and Squash.
• Actively involved and supported business users in User Acceptance Testing (UAT) phase.
• Good knowledge on SCD Type1 and Type2 mappings and workflows that in corporate complex business logic and interdependencies.
• Excellent Knowledge of Database Systems - Oracle 10g, SQL server, DB2, Teradata, Hadoop and UNIX Shell Scripting.
• Good knowledge in BI lifecycle, Dimensional Modeling, ETL concepts, OLAP and Reporting Services.
• Worked on Waterfall and Agile methodologies.
• Good knowledge on Sub Queries, Joins, set operations and Stored procedures.
• Tested ETL applications using both relational databases and flat files as Sources and Targets. Also tested UNIX shell scripts written for ETL Processes.
• Efficient in preparing Weekly status reports, Monthly Status reports and Testing project closure documents.
• Worked closely with the Development team during Planning and Testing phases.
• Very good team player with excellent Communication skills, quick learner and adapts quickly to new environment.
• Work authorization: Green card - Permanent resident.

TECHNICAL SKILLS:

Environment: s: Windows XP/7/8ETL and BI Tools: Informatica Power Center 9.5, Ab initio, Data Stage 8.1, Talend & SSIS, SAP BO 4.0

Databases: Oracle 11g/10g SQL Server 2008 & TeradataV2R5/V2R6

Qa Tool/Software: ALM 11.5/10/12.0 (Application Lifecycle Management), JIRA

Test Management Tools: HP ALM, JIRA and Squash

Testing Types: Black box, Functional, Integration, System, and Regression & User Interface.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Sr. ETL/ Data Warehouse Tester

Responsibilities:

• Processed the data through Talend and ran the Talend job through Active Batch V11.
• Validated all the Stage tables as the data got extracted from different sources.
• Validated the initial load as per the process (Dimentions, Facts, Aggregates, Product universe and position universe).
• Prepared Test plan document, Test cases and Test closure report. Also prepared WSR and DSR.
• Executed Integration Testing, Regression Testing, Application Testing, and ETL testing involving following applications:
• ETL Testing (Source:IMA3,Geneva,Investran,OT,Secmaster and Market Data - DWH 2.0)
• Validated source - staging and Staging to DWH for all the sources.
• Tested Conflict Report, AUM Report and validated the Measures and the associated Dimensions for DWH 2.0.
• Designed all the SQL queries as per the transformation logic from the staging table till Aggregate tables.
• Designed Test cases from the mapping document related to DWH 2.0, uploaded the test cases in Squash. Validated the ETL from Source to stage and stage to DWH.
• Validated the Fund Performance Report that has Endmarketvalue, Benchmark Monthly Performance, overlaps and Year to Date Performance .
• Validated Position data, Product data and product composite data and ETE Testing (Initial load and Incremental load).
• Consumed the ticker from sec master calculated the Benchmark performance as per the association and validated the Benchmark balances.
• Consumed the Actual Mark to Market value from Geneva and calculated the Returns for instruments.
• Validated the Recon report DWH 1.0 and DWH 2.0.
• Validated the Product universe and Position Universe by writing the DB queries with the measures and compared it with the Adhoc Report.
• Validated all the views that Investment team consumes.
• Did Impact Analysis for each and every change and covered all the tables which are getting affected while doing Regression.
• Validated the SMA data from Security Master that got transformed and loaded in to Hadoop.
• Designed the queries for SMA Transformation and compared that with target table.
• Participated in defect triage meetings with project team.
• Coordinated with Development team, got the KT, designed the queries as per the mapping document and reviewed the same with the team.
• Uploaded all the test cases approved by Customer in the Squash.
• Wrote numerous Pre and Post session SQL and Unix Scripts.

Environment: Sql Server Management Studio 2012, Hadoop, BO 4.2 SP03, Agile, Windows 2010, TOOLS: Snipping tool, JIRA, Squash, Active Batch V11

Confidential, Teaneck, NJ

Sr. ETL/ Data Warehouse Tester

Responsibilities:

• Processed reconciled orders in WON, generated invoices.
• Ran the Batch job in WON validated the flow in Oracle through ESB and in to the Oracle, verified till accounting.
• Tested Credits and Reissues, ran the batch job and validated adjustment in Oracle.
• Worked as Onsite Testing Lead for Fusion Sales Integration project.
• Prepared Test plan document, Test cases and Test closure report. Also prepared WSR and DSR.
• Executed Integration Testing, Regression Testing, Application Testing, and ETL testing involving following applications:
• Tested Tableau CMC report and validated the Measures and the associated Dimensions for Fusion.
• WON - MDM Customer Hub; Customer Data - Batch
• Customer MDM - Redesigned Test cases from the mapping document related to Fusion, uploaded the test cases in QC. Validated the ETL from Source to stage and stage to DM.
• WON - Oracle EBS via MDM; Customers Data - Real time.
• Created new fusion customers in WON and passed it to MDM through ESB (Real time).
• Executed MDM testing - Merged the new customers with the existing customers in Wide OrBIt Application and validated the xref.
• Dealmaker Application- SMART (SFDC via Teradata); SMART Quarterly BOB.
• Validated the Recon report before and after the code change.
• WON - Oracle EBS; Validated Invoices.
• WON - Oracle EBS; Validated Credit/Re-issues.
• Generated invoices in Wide OrBIt, processed and passed it to Oracle application through ESB by running the WO batch job. Tested the Oracle application and validated the backend Oracle table data. Validated the Oracle mapping and tested till accounting as part of E2E Testing. Created multiple credit and reissue to cover all the scenarios.
• SFDC - Upfront - Teradata/BO; Upfront Forecasting UF094A DM vs Smart Recon; UF094H0 DM vs Smart Recon
• Validated the BO Recon report for fusion.
• Participated in defect triage meetings with project team.
• Coordinated with offshore team of 3 people and guided the team on Test cases execution and clarified project Requirements.
• Uploaded all the test cases approved by Customer in the HP/ALM 12.0
• Wrote numerous Pre and Post session SQL and Unix Scripts.

Environment: Teradata 14.0, Teradata 15.0, SAP BI - 4.1, Tableau 8.1, SQL Server Management studio 2008/R2, SQL Developer 2011, Agile, Windows 2010, TOOLS: Snipping tool, HP/ALM 12.2

Confidential

Onsite Testing Lead

Responsibilities:

• Analyzed mapping document for CMC, FRO, Smart Scatter applications and prepared SQL Queries to validate the integrity of Application data.
• Prepared Test plan document, Test cases and Test closure report. Also prepared WSR and DSR.
• Executed full set of Test cases in Sales force source db for smart upfront and Teradata db for both staging and data mart.
• Executed test cases for applications having sources (SQL server2008R2 Management Studio, SQL developer, sales force)
• For Smart upfront application, validated all the communication Reports (national executive summary, upfront timing report, dealmaker vs smart) - designed and executed test cases to check the data consistency, format, look and feel, Core computation) and compared the report with production version.
• Validated the Tableau reports for CMC (cmc007, cmc004, cmc001) - Interacted with clients, understood the requirement, designed and executed the test cases for initial and incremental data load.
• Tested UNIX batch jobs according to the specifications and the functionality. For FRO application, uploaded Test cases in to HP/ALM.12.0 in our format, executed all the test cases for BO reports. In case of incremental load for Smart upfront, on behalf of Salesforce team, made changes in the Salesforce application by adding Agency, Agency group, Advertiser and made change in the upfront dollar value.
• Ran the workflow, validated the data in ETL tables. Also validated if changes are reflecting in the BO report.
• Tested UNIX shell scripts written for ETL Processes. For FRO application, the client created a new invoice in the application. Meanwhile we ran the workflow and validated weather the new invoice is reflected in the report with the appropriate amount along with the ETL process.
• Participated in defect triage meetings with project team.
• Coordinated with offshore team of 5 people and guided the team on Test cases execution and clarified project Requirements.
• Uploaded all the test cases approved by Customer in the HP/ALM 12.0.
• Performed Production check out after Go-Live, for all BO and Tableau Reports.

Environment: Teradata 14.0, Teradata 15.0, Salesforce, Agile, UNIX, SQL server2008R2 Management Studio, SQL Developer, Windows 2010, TOOLS: Snipping tool, HP/ALM 12.0

Confidential

ETL/ QA Tester

Responsibilities:

• Responsible for getting, understanding the business specs, preparing technical Specs.
• Developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• SQLs are written using SPUFI to query the DB2 database on Mainframe environment.
• Validated Extract/Transform/Load (ETL) processes that load test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Corresponded with warehouse architect and report developers in preparation of test scenarios.
• Tested several SSIS packages which were migrated from SQL procedures.
• Performed tests with SSIS, ETL and DTS technology.
• Interacted with Data warehouse developers and modelers on status and risks involved.

Environment: SQL Server 2008, SSIS, T-SQL, Mainframe, JIRA