Sreedhar Pasham

adjb9v@r.postjobfree.com

203-***-****

Summary:

Over 13 years of IT experience in development, Automation and manual testing of Data Warehouse, Client Server, Mainframes and Web Based Applications.

Sound Knowledge of System Development Life Cycle (SDLC) and Agile SCRUM.

Expertise in Writing, Executing and Maintaining Test Plans, Test Procedures, Test Cases and Test data.

Experienced in Data warehouse testing, in all the phases of Data warehouse life cycle.

Expertise in Testing complex Business rules by creating mapping document and various transformations.

Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.

Strong knowledge in Data Warehouse and Business Intelligence solutions and a strong understanding of Data Warehouse concepts, ETL, OLTP,OLAP, Star Schema, Snowflake Schema, FACT & Dimensions tables, Physical & Logical Data Modeling.

Strong experience using Oracle, MS SQL Server 2005/2008, Teradata, Sybase, AWS/Athena, Red shift.

Involved in testing ETL (Extraction Transformation and Loading) tools like SAP BODS, Informatica, Datastage, with reporting tools like OBIEE and Business Objects.

Strong experience in automation tools like Quality Center and Rational Test Manager and Strong Knowledge of Project Management.

Expertise in Problem solving and Tracking Bug Reports using Bug tracking Tools like Team Foundation Server (TFS), Jira and Bugzilla.

Solid Back End Testing experience by writing and executing SQL Queries using TOAD, Query Analyzer, Teradata SQL Assistant, PL/SQL developer, Squirrel tool and TSQL.

Experience working with UNIX, Shell scripting, managed version control software and defect tracking systems.

Education: Bachelor of Engineering in Computer Science, India.

Professional Experience:

NMDP (National Marrow Donor Program), Minneapolis, MN: Apr’ 2013 – Nov 2020

ETL / QA / Data Analyst

Currently clinical and outcomes data is collected by the FormsNet3 application. Operational data is derived from the STAR/SIP systems. Many departments across both the NMDP and CIBMTR rely on these systems to produce data extracts (‘save’ sets) for reporting and analysis.

Responsibilities:

Analyze the BRD and Requirement mapping document.

Involved in designed, developed and architected the IIDB project to combine the historic data supplied by CIBMTR with current data and NMDP data from the data warehouse.

Work closely with Product Owner and Scrum Master on backlog priorities and Sprint alignments.

Used SAP BODI ETL tool loading data in CDW from source systems.

Worked on Source to Target Mapping design.

Written Test Cases for ETL to compare Source and Target database systems.

Involving in writing complex SQL queries to verify data from Source to Target

Performed Integration, Systems, Regression, Smoke and UAT testing.

Tested customized and OBIEE reports with Metrics and Filters for Business analysis using Desktop intelligence with features of Drilling options.

Using OBIEE tool, tested Center Volume detail reports, FN Forms reports, HLA_SAV reports, UDM reports and Lab Vantage reports.

Tested Recipient and Donor forms reports.

Executed and managed test cases and reported bugs in Team Foundation Server (TFS).

Tested Oracle to Redshift migrations of target and/or source tables.

Analyze requirements by validating data in SQL Server, Oracle and AWS/Athena, Redshift.

Perform UI and Integration testing on Tableau dashboard builds.

Perform validation during Tableau Upgrade 2019.3 to 2020.2.5.

Working closely with developers during the Visualization on verifying the reporting metrics.

POC (Proof of concept) of Snowflakes for reporting from target tables.

Environment: OBIEE 11g/12, Team Foundation Server (TFS), Oracle, SQL Server 2008, SAP BODS 4.2, SQL developer, AWS, Redshift, Snowflake and Tableau 10.

Wells Fargo, Chandler, AZ Oct’12 - Mar’13

ETL Tester /Data Analyst

Operational Risk reporting is a major group in the bank which maintains various applications like CICAT, CRAS and RCSA to ensure the bank handles the risks in daily operations and complies with federal regulations.

Responsibilities:

Analyze the Functional system design (FSD) and Requirement mapping document.

Mercury Quality Center for executing manual test cases

Validated the data that is loaded from the source databases into the staging tables.

Tested Data Stage ETL data Validation.

Validated the record counts, the data integrity, and the data accuracy of the data that is moved into the Oracle staging environment.

Created and executed database queries for both SQL and Oracle environments that return record counts. Compare results from Source database vs Staging

Created and executed database queries against both Staging and the Data Warehouse (Oracle) that return attributes of each data element being loaded into ORMDW

Executed queries to validate any additional derivation logic that is being applied to populate the Data Warehouse.

Performed field by field data validation of each object within each BO Class/entity (i.e. build a report (similar to an “All Fields”) that contains each object for a given class/entity)

Validated report aggregations, historical data, standard templates and layout and monitored report response times.

Performed functional testing, system integration testing (SIT), regression testing and UAT testing.

Environment: IBM Data Stage 8.0.1 (Designer, Manager, Director), Quality Center, Business Objects, Oracle 10g, SQL Server 2008, Toad, Clear quest and MS Excel.

Nationwide, Columbus, OH Nov’07– Aug 11

Data / ETL Tester

This Data Warehousing Project is to facilitate the Client integration of information. The objective of the integration of information is to provide a unified picture of the business. This unified picture of the business is intended to facilitate integrated management reporting.

Responsibilities:

Analyzed Business Requirements and gathered mapping documents.

Used Informatica ETL tool for loading data from flat file sources into Teradata Database.

Developed and executed test plans and test procedures based on requirements

Created and executed test cases and test scripts

Developed SQL Queries for backend testing using Teradata SQL Assistant and TOAD

Successfully developed and implemented the Test Cases manually for Integration, System Testing, positive, negative and User Acceptance Testing.

Maintained the Requirements Traceability matrix and participates in the Test Case

Peer Review to ensure test cases translate and map to requirements.

Documented and reviewed test results, test process and test standards.

Used Clear quest for bug tracking tool

Validated the micro strategy reports and documented the results.

Environment: Informatica 7.1, Oracle, TOAD, Quality Center, UNIX and Business Objects.

NutriSystem, Horsham, PA Sep’06 - Oct’07

Data warehouse Tester/ QA Analyst

The aim of the project was to gather data related to its users. The data was from several databases in the form of flat files and the task was to integrate the data into a centralized database to provide a single vision and single platform that enables insurance providers to analyze and use the information to improve services they provide.

Responsibilities:

Involved in various phases of the Data warehousing life cycle - logical and physical design, ETL process, performance tuning, and maintenance.

Analyzed source system functionality and developing source-to- target data mapping rules.

Created complex SQL scripts and validated in TOAD.

Develop test strategy and test cases to ensure business and technical integrity

Extensively used Data Integrator to load data from various Database sources and flat files to Oracle database

Environment: Data Integrator, Oracle 9i, Quality Center, SQL Server 2000, Crystal Reports and Toad

Health Dialog, Manchester, NH Feb‘06 – Jul’06

BI Tester

The data flow to PHR (Personal Health Record) is an interactive application where by the end user has the capability to modify the PHI (Personal Health Information) data displayed through the application

Responsibilities:

Analyzed Business Requirements and Identified mapping documents.

Extensively used Informatica ETL tool to load data from various Database sources and flat files to data warehouse.

Performed System testing, Regression and end-end testing.

Tested Informatica Mappings and worked with staging area to validate the data with SQL Queries.

Developed Test Plans/Test Cases to Validate Key Business Requirements based on the report specification document.

Wrote complex SQL queries using TOAD for data validation against the data warehouse applications.

Developed/Tested/Integrated Conversion Programs, EC Gateway Scripts, maps and provided HIPAA. Business knowledge for Inbound Professional Claims X12N837-P, Institutional Claims X12N-837-I, Dental Claims 837D, Inbound/Outbound Eligibility Enquiry/Response X12N 270/271 and Claim Status Enquiry.

Extensively used Clear Quest for Test Planning, Bug Tracking and Reporting

Interface with developers to resolve technical issues and investigated the bugs in the application

Environment: Oracle, TOAD, Informatica, JAVA, XML, Visual Source safe, Cognos, Autosys, Windows XP, Unix, Rational Test Manager and Clear Quest.

Anheuser-Busch, St. Louis, MO Jul’05 – Dec’05

ETL Tester

During the Bud Net Remediation project, the (product) data was moved from the source system into the new model base tables. There are currently views that were created for PLMS and PATSI projects for which the requirements will be incorporated into this project.

Responsibilities:

Reviewed requirements and design specifications to identify gaps analysis

Analyzed Business Requirements and gathered mapping documents.

Used Data stage ETL tool for loading data from flat file sources into Teradata Database.

Developed and executed test plans and test procedures based on requirements

Created and executed test cases and test scripts

Developed SQL Queries for backend testing using Teradata SQL Assistant and TOAD

Successfully developed and implemented the Test Cases manually for Integration, System Testing, positive, negative and User Acceptance Testing.

Used Test Director for bug tracking tool

Environment: Teradata, Teradata SQL Assistant, Data stage, DB2, TOAD, Test Director, Oracle, and Business Objects.

Contact this candidate