Sign in

ETL tetser

Irving, Texas, United States
May 29, 2018

Contact this candidate


Priyanka Sriram


**** ****** ****, ******, ** - 75039


IT Professional with 5+ years of experience in Financial & Health care clients. Experience with data analysis, reporting and problem-solving techniques. Able to analyze a set of data, provide high level data insights, illustrate complex analysis in a concise and simple fashion, and prepare presentations for senior management. Proven record of knowledge transfer to team members, continuously leveraging industry best practice and adhering to corporate data security requirements, while juggling multiple projects with competing priorities and demanding timelines. Offering excellent communications skills, customer service, and the ability to build partnerships with business units to ensure fulfillment of data needs. Strengths

Data Analytics Data Modelling Analytical Data

Data Mapping Data Marts Operational Data

Report Generation Ad Hoc Queries Batch & Real-time jobs Technical Skills

ETL Tools AB Initio, Informatica

Databases MS SQL Server 2008, Oracle 11g, Teradata 15.0

Reporting Skills SAP Crystal Reports 2008, Microstrategy

Operating Systems Microsoft Windows 7, UNIX

Testing Tools HP ALM 12.0, IBM Clear Quest, Selenium


Professional Experience

QA ETL Analyst

Capitol One Plano, TX April’16 – Present


Gathered the requirements from Business Analysts to understand the project and data flow from end-to-end systems.

Created the test data using various front-end client tools.

Worked on various releases for a major project in Waterfall/Agile & Scrum methodology provided day to day status on test execution.

Closely worked with development team & SME’s to resolve the issues and also provided the reliable solutions for some.

Provided the estimates for test cases and execution timelines for different releases

Logged the defects in HP ALM and prioritized those based on the business impact. Worked with Program & Development teams to make sure they deliver the fixes as scheduled.

Provided detailed analysis on the defects by documenting them and uploading them into a Share point to give insight to necessary teams.

Involved in Pre-PROD data validations by providing SQL scripts to support the data analysis.

Ran the existing ETL jobs through wrapper scripts for testing needs.

Involved in a daily defect triage to provide the update on testing impact (# of test cases being blocked due to a specific defect)

Created the end-to-end test cases and uploaded them into HP ALM 12.0 QA ETL Engineer

Wipro Hyderabad, IN July’13 – December’14


Experience in writing SQL queries for data validation and also to verify the ETL Mapping Rules.

Developed SQL queries/scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.

Extensive use of SQL for querying data in Staging, Data warehouse and Data Marts.

Extensively tested the reports for data accuracy and BO Universe related errors.

Involved in user training sessions and assisting in UAT (User Acceptance Testing).

Written test cases to test the application in Quality Center 9.0 and ALM 11.0.

Defects identified in testing environment are communicated to the developers using Quality Center Defects module.

Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

Participated in regular project status meetings and QA status meetings.

Performed Functional and Regression Testing.

Prepared the Test data (Input files) for interpreting the Positive/negative/regression results based on the design requirements.

User Management Support

Wipro Hyderabad, IN June’11 – July’13


Supported Oracle user management team to manage people and users in the system according to the requirements in Oracle E-Business Suite.

Maintained oracle users by create, update & disable accounts and resetting the LDAP passwords.

Grant user access to different roles & responsibilities of the system by assigning & revoking.

Defined user administration privilege roles.

Migrated shell scripts from DEV to QA & PROD environments.

Created customized workflows through Workflow Manager and loaded into Oracle EBS Suite. Education

Bachelor’s Degree in Computer Science Acharya Nagarjuna University

Contact this candidate