ETL Test Lead

SHRUTHI HARISH

Country lake Estates, Spring, Texas-77388

Cell Ph: +1-346-***-**** Email ID: *********@*****.***

Objective: Seeking a challenging career in one of the best organizations and to work efficiently and contribute wholly to the progress of the organization while enhancing my technical and development skills.

Profile Summary: Bachelor of Engineering Degree in Electronics and Communications with 15 years of Industry Experience which includes 8 years of oil and Gas Industry vertical

8+ years of experience in Software Quality Assurance - in Data Warehouse, Database (ETL & BI), Web, Client - Server Systems and Applications for various Industries.

Extensive experience in writing SQL to validate the database systems and BI Intelligence reports testing.

Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).

Technical Expertise in Windows, Web, ADMS, Exchange and SQL Database Administration/ Maintenance, SQL Server Integration Services (SSIS) and PowerShell scripting.

Worked with Infosys as Technology Lead and Business Analyst for over 10+ years in IT Infrastructure Library (ITIL) and IT Service Management (ITSM), including design and implementing Service Request Catalog Solution using CA's Service Catalog.

Professional Skill Sets:

ETL Tools : Informatica, SSIS

Reporting Tools : Microstrategy, Tableau

Web Services : SOAP UI

Programming : PL/SQL, C and C++

Bug Tracking Tools : Team Foundation Server

Directory Services : Active Directory (2008/2003). Design & Administration.

Database Servers : Microsoft SQL Server, ORACLE

Operating Systems : Microsoft Windows Server 2012

Methodologies : Agile and Waterfall methods

Certifications:

IT Infrastructure Library Foundation Certification.

Microsoft certified SQL Server administration

Microsoft Certified Professional: Planning, Maintaining a MS Server Network Infrastructure

Present Job Roles and Responsibilities:

NABORS, West Greens Road, Houston, Texas

Duration: Since Jan ’2017

Role: ETL Test Lead

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Worked closely with Business user in Understanding designing and documenting the Functional testing plan.

Writing test cases to test Data Completeness, Data Transformations, Data quality, and Data aggregations

Matching aggregated data against staging tables and ensuring granularity of data matches the specifications.

Conducted sessions with the Development team to verify any additional testing scenarios required based on the ETL specifications.

Extensively tested several Business Objects Reports and Dashboards in Micro strategy to validate the reports data and cosmetics of the report.

Conducted Defect Triage calls to review and track down defects for each release.

Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.

Facilitated UAT readiness meetings and Production readiness meeting to mitigate issues and outline defect deferral process to facilitate progress.

Attended daily status meetings for Data quality issues and also technical review meetings.

Created Test Plan, Test Strategy documents and testing sign off documents for various deployments on the project on an as needed basis.

Professional Details /

Previous Roles:

INFOSYS TECHNOLOGIES Ltd, Bangalore (Feb ’2006-September 2016)

Client Location: Baker Hughes Inc, Houston, Texas, USA for Oil and Gas Industry Vertical

Duration: May ’2011 to September 23, 2016

Role: Technical Consultant- Business Analysis

Interface with the Business Users to understand the Business Requirements and Functional Specifications.

Experienced in client Requirement Analysis, Physical, Logical design, development, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using CA Service Catalog.

Manage request and approval processes using CA Service Catalog Process Model / Workflows.

Ability to design, configure implement Service Request Catalog Solution.

Configure user interfaces providing users an easy-to-use web-based interface for submitting IT service requests, completing tasks and tracking process activity.

Design and develop forms, process Definitions, workflows using CA Workflow and Process Automation Manager (PAM).

Developed PowerShell scripts to automate various tasks.

Provide Business Solutions, recommendations and ensure delivery to the business.

Knowledge on SDLC, system development methodology, project management and SQL Database management.

Expertise in writing SQL queries involving self joins, correlated sub-queries, Store Procedure, triggers and functions to display the data in front end application and for Business analysis and Reporting.

Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys.

Solid knowledge of Relational Database Management System RDBMS, Data Warehouse Concepts, OLTP and OLAP and experience with Working on SSIS.

Created SSIS packages for Uploading of different formats of files Excel, Access, Flat files into the SQL Server data warehouse using SQL Server Integration Services SSIS

Structured Walkthrough sessions and Training sessions with Stake holders / clients for the new product upgrade versions and supporting Go live sessions.

Client Location: Intel Corporation, Portland

Duration: Sep ’2010 – Apr 2011

Role: System Integrator

Managing IIS 6.0 / IIS 7.0 Web servers and hosted web sites.

Created jobs for automatically running stored procedures for day-end operations using SQL Server agent such as index rebuild, data loads and summary reports

Application support for asp, .NET & java based hosted internal & external websites.

Troubleshooting .Net application issues hosted on the IIS

Creating, deploying, renewing and Import & export of the SSL certificate

Configuring Site Minder web agents’ clients for authentication

Provide level 3 support to application issues as per defined SLAs

Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

In-depth experience performing log analysis to identify issues and improved Web system performance via system monitoring, analysis, and performance tuning.

Client: Analog Devices Inc., Norwood MA

Duration: Nov ’2006 – Aug ‘2010

Role: System Administrator

Administration and Maintenance of Windows based network of over 240 Servers running Windows 2008/2003 operating systems.

Implementing and administration Active Directory services, replication, Trust Relationship and enforcing Domain Wide Group Policies.

End to end Automation using Powershell for User Account/ Mailboxes/ Distribution Group/ Security Group provisioning and management

Web Server Administration/Application support -- IIS 5.0 / IIS 6.0:

Share Point Portal Server 2007 - Managing web applications and site collections and managing user groups, Managing and administrating of MOSS 2007.

VMware Server Administration - Managing Virtual Servers -- Virtual Infra Client & VMware ESXi Server, Cloning and Troubleshooting the VM machines using Virtual center and VMware Infrastructure client.

Administering Exchange server 2007/2003.

Managing SQL servers 2000/2005 – Backup/Restore, monitor server performance, manage SQL Server logins and user accounts/passwords, manage database object permissions

Configuring Domain security policies, Local security policies

Creating groups, users and assigning share permissions

Analyze system outages, lead root cause investigations and define and implement process improvements and other long-term solutions.

Client: American Express bank

Duration: Feb ’2006 – Oct 2006

Role: Availability- Problem Manager

ITIL framework with expertise in Incident, Availability & Problem Management.

Ensuring IT Services are designed to deliver the required levels of Availability & provide a range of IT Availability reporting.

Ensuring that Service Level Agreements (SLAs) are achieved by minimizing the duration of problems and managing the problems within the agreed timeframes.

Reducing the number of problems by reviewing, analyzing, trend analysis & creating Root Cause Analysis (RCA) reports of problems

Effectively creating the daily, weekly and monthly reports for the team and provide the necessary feedback.

Error Control by maintaining Known Error Database and scheduling awareness trainings for the support staff

Academic Profile:

Course

Board/Univ.

Percentage

Degree in Bachelor of Engineering (Electronics & Communication)

(2001-2005)

Vishveshwariah Technological University

INDIA

79% (Aggregate)

US GPA equivalent: 4.0

Pre- University Degree

(1999-2001)

Karnataka Board

INDIA

86% (Aggregate)

US GPA equivalent: 4.0

Secondary School

(1998-1999)

Karnataka Board

INDIA

81% (Aggregate)

US GPA equivalent: 4.0

Personality Skills:

Customer and Business oriented with excellent Technical, Communication and People skills. Self-motivated Team player

Well-organized, fast, accurate and ability to work effectively under pressure in order to meet deadline constraints.

Quick understanding of concepts.

Excellent Team player.

Contact this candidate