Data Manager

LEELA HOSUR

(C) 510-***-**** **********@*****.***

Professional Summary

•Seasoned QA Lead with 11 + years of IT experience

•Consistent Outstanding Appraisal Ratings & feedbacks for outstanding contributions to Project Deliverables

•Gather client business requirements, understand functional specification document for application development, maintenance or enhancements and prepare test document for testing

•Test strategy, Planning and Estimation

•Proactive planning, budgeting and growth of the testing function

•Driving the enterprise Testing strategy and roadmap for maturity of the testing function

•Driving tooling, standardization and best practices across people, processes, and technology in the testing space

•Improved efficiency and reduced test cycle by increasing automated test script execution by 70%.

•Provided leadership and supervisory oversight to quality assurance

•Experienced on working with Big Data and Hadoop File System (HDFS)

•Built testing road map for projects under the Data Analytics & Big Data portfolio.

•Manage and co-ordinate Unit, Integration, System, Regression testing, UAT and Deployment support for implementations

•Identify, manage, report and escalate program level testing risks and issues

•Subject Matter Expert (SME) for the CCC project (Customer Care Center) for Sales (Auto, Fire, and Life) System, Bank, Customer Care Service, Internet Service, Personal lines, Business Lines, Payment and plan. Facilitate Joint Application Development (JAD) sessions with client and business users, management, development team, users and other stakeholders to refine functional requirements.

•Coordinate & collaborate with other developers and testers to develop, test and implement application features or requirements

•Manage onsite QA team members and coordinate with offshore team for project deliverables

•Interaction with business users for requirement clarification and resolution of problems reported

•Conducting defect triage calls and tracking of all defects till closure

•Lead and automated performance and regression test suites

•Very good understanding of Hadoop Architecture and underlying Hadoop framework.

•Working experience in Agile, Waterfall Life cycle models. Used Version One project management.

•Highly motivated, flexible, versatile and team oriented professional, with excellent communication and interpersonal skills.

Technical Skills

Operating Systems

Windows, UNIX, Linux.

Databases

IBM DB2 LUW 11.1, SQL Server, nCluster, PostgreSQL 10.1, Oracle 8i/9i/10g/11g, Teradata v2r5/v2r6

Languages

Linux/Unix Shell Scripting, SQL, Scala, JAVA, C++

ETL Tools

Informatica 7.x, 8.x, ODI(Oracle Data Integrater),IBM Data Stage

OLAP Tools

Business Objects XI, Cognos, QlikView, Tableau

Big Data Hadoop Eco System

Spark, Flume, Kafka, Hue, Impala, Hbase

Test Management andDefect Reporting Tools

Trac, Test Link,Test Director, Rational Clear Quest,Rational Quality Manager(RQM), HP Quality Center(ALM).

Functional Testing Tools and IDE’s

Selenium, Mercury WinRunner, QTP, Ecplise, Spring Source Tool, IntelliJ

FTP /Database/Design Tools

IBM Data Studio, TOAD 8.x/9.x, SQL Developer, Putty, Ultra Edit, FileZilla

Microsoft tools

Microsoft Access, Excel, OneNote, Outlook, PowerPoint and Microsoft Visio

Performance Tools

HP Load Runner(VUGen) 12.53, HP Performance Center, Analysis tool

Domains worked

Insurance, Retail, Health

Work History

Big Data/ETL Test Analyst June 25th – Current Client - Anthem

•Working on driving testing on a Scrum team (Agile)

•Responsible for creaing test cases and test deliverables for the User Stories or Functional requirements

•Responsible for end to end SIT test excution,debugging applications, logging defects and working through resolutions

• Responsible for identifying test cases for automation

•Responsible for coordinating testing across multiple testing phases, including SIT, UAT, and Regression.

•Lead peer reviewon test deliverables to ensure completenes.

Test Lead Aug 2012 – Jan 19th Client - State Farm Insurance

•Working as Test lead for various data warehousing testing projects which involved understanding the project charter, requirements, design and communicating expectations to the team to help prepare the Test deliverables

•Identify the Risks, Issues and Dependencies and documenting in project notes

•Prepare the Test Strategy, test schedule and plan the test activities and communicate to the project and planner

•Oversee the test script preparation activities, uploading to test link and enforce test entrance and exit criteria

•Monitor Testing Defects for any escalation needs or defect triage procedures

•Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading

•Worked on databases created for end user reports using facts and dimensions (Dimensional Modeling)

•Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.

•Extensive testing ETL experience using Informatica (Power Center/ Power Mart)

(Designer, Workflow Manager, Workflow Monitor and Server Manager).

•Thorough knowledge on Data ware House concepts of Star Schema, Snow Flake, Dimension and Fact tables

•Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W

•Experienced on working with Big Data and Hadoop File System (HDFS)

•Validated and lead data movement from application to Kafka to HDFS and to Hive and Impala tables for further Business Intelligence use.

•Hands on experience in working with Ecosystems like Hive, Pig, Sqoop, Kafka, Impala Flume, Hue, Oozie.

•Strong knowledge of Hadoop and Hive and Hive’s analytical functions.

•Experience using the Database client tools to connect to the database for verify and validate data with SQL

•Identified regression test suite for CCC Dashboards application and involved in developing automated scripts using selenium WebDriver.

•Devolved and conducted performance load test scripts using HP Load Runner suite for CCC dashboard application.

•Identified Automation possibilities in Unix with scripts to verify log results and scripts help validate the data by data comparison

•Adept in writing shell scripts using powerful simple and Compound Unix utilities to automate the testing efforts

•Received appreciation from Test/Project Managers for hard work, effort and extremely effective in getting team quickly up to speed, thoroughness and excellent communications with the team and business partners resulted in quickly gaining respect from the developers, timely identification of the defects, finding root cause, appropriate escalation to defect triage team, coordinating between the developers and help verify the fix.

•Experience in working in Data Migration, QlikView Dash board, Cognos Reports, TM1 cube, Adhoc Reporting, BO Crystal reports in projects under BIRA and EPMA

•Experience in working in data movement validation to Hadoop big data environment.

•Coordinated between the offshore and onsite project team by communicating the project expectations and constantly monitoring the offshore deliverables via mails and conference calls

•Proactively provided feedback while reviewing project deliverables to gain insight into the project scope and objective

•Coordinated with the Implementation Coordinator and Release coordinator to align/adjust the test activities to meet the Implementation/Release schedule expectations.

Environment: Agile, Version One, Java, SharePoint, Windows, Informatica, Cognos, TM1, QlikView, XML, VMware, FTP, IBM DB2, Putty, IBM Data Studio, Selenium, Postgres, SQL Server, nCluster, Teradata, Hadoop, Hive, Hue, Hbase, Impala, Flume, Kafka, Spark, Scala, SQL, ETL,Ultra-Edit, Note Pad ++.

Sr. DW Analyst/ETL Tester Feb 2011 –Aug 2012 Client - Florida Blue,FL

•Responsible for developing software Test Plans, Test Case Design and Test Scripts.

•Participated in all aspects of the software development life cycle.

•Experience in testing Oracle databases using tools like Toad, SQL Management Studio etc.

•Conducted Quality Assurance tests for Data Warehousing and ETL projects

•Validated Informatica mappings with respect to business transformation rules.

•Identified and created test data for test execution.

•Performed back-end testing manually by generating SQL queries for System Test Databases.

•Reporting and tracking software defects in HP Quality Centre 9.2(ALM – Application Lifecycle Management) and re-creating them to assist developers for faster resolution.

•Apply technical expertise to organize and implement black-box test efforts and to analyze requirements for software design, development and validation

•Worked with development team to ensure testing issues are resolved on the basis of using defect reports.

•Conducted Functionality, URL Link Testing and Regression Testing during the various testing phases of the application using QTP.

•Analyze the business and technical specifications and participated in walk-throughs and sign-off meetings.

•Participated in User Acceptance Test (UAT), documented procedures and guiding the users in verifying various transactions on the system

Sr. DW Analyst/ETL Tester Jan 2010 –Jan 2011 Client – Cigna,TN

•Involved in writing Test cases and developing Test Plans.

•Developed Functional Test Cases based on the business specifications.

•Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.

•Verified Transformation rules in REFORMAT & JOIN components.

•Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing(UAT).

•Tested the application on different browsers and verified the links of the application.

•Used Test Director for defect tracking and participated in Bug reporting and reviews.

•Attended Daily Stand Up meetings, and provide Testing status of assigned work.

Sr. DW/ETL Tester Nov 2008 – D2009 Client - Target, MN

•Performed extensive DATA validation using SQL queries and back-end testing.

•Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.

•Designed and implemented reports for internal and external use, including adhoc and published reports.

•Worked closely with end users to establish correct report criteria

•Performed data analysis per management requests

•Experience in testing of business applications for Data Warehouse Systems using (ETL) Data stage.

•Analyzed the ETL design documents to understand the business logic.

•Performing Integration testing for all the Mappings in “Customer Order Tracking(COT) DM” and documenting the results.

•Performed troubleshooting the loading failure cases, including database problems.

•Prepared Functional, scope and ETL mapping documents for COT Data mart.

•Wrote complex SQL queries and Data Mart Staging Tables to validate the data results and documented.

•Prepared Test Plans, Test Scripts, Test cases and executed the Test cases.

•Involved in Regression, Release and System Integration testing.

•Used Quality Center for the defect tracking.

•Working with different data sources, like Oracle, Teradata, Flat files, xml files, and handling huge data.

DW Tester/QA Analyst Aug 2006 – Oct 2008 Client - Aetna Health Care, CT

•Involved in writing Test cases and developing Test Plans.

•Ran the UNIX shell scripts to validate data movement for ETL process.

•Validated Informatica source to target mappings to meet transformation rules.

•Involved in reviewing Business Requirements and Use Cases.

•Tested web applications on different browsers and verified the links of the application.

•Used SQL & PL/SQL to test backend functionality.

•Used Test Director for defect tracking and participated in Bug reporting and reviews.

Education: Bachelor of Engineering in Electronics and Communication.

Contact this candidate