Resume

Sign in

Data Manager

Location:
Coppell, Texas, United States
Posted:
April 30, 2019

Contact this candidate

Resume:

Mounika Nalluri

ac89c5@r.postjobfree.com

281-***-****

SUMMARY:

A highly adaptable QA Analyst with 6 Plus years of experience in Quality Assurance, Testing (Manual, System Integration, ETL, web services) and production support. Worked in the domain of Airlines, Banking Services and Retail. Proficient in Test case design, Test Scripts, ETL Testing tools and ability to continuous learning.

Experience in Developing Various Test assets like Test cases, from Functional Specification Documents

Involved in the Planning & Execution phases of the Testing Process.

Involved in various phases of Testing like Formal Testing and Sanity Testing

Involved in Test Plan Preparation, Test Case Designing and Test Case Execution on Various applications.

Involved in reviewing various Test Documents.

Wrote SQL queries to check the validity of data entered.

Involved in Client Interactions, through Mails as well as Tele Cons.

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).

Proficient in all stages of the SDLC, STLC and Bug Life Cycle.

Reviewed and comprehend business requirements and functional specifications.

Developed Test cases and Test data.

Involved in Functional, Integration, System, Regression, Data migration Testing.

Ability to work independently as well as in a team environment and success with meeting deadlines under pressure.

Ability to achieve successful outcomes through collaborative and cooperative means.

Shared Knowledge with other members of the team.

Experience in Airlines, Retail and Banking Application.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, SQL Server, Oracle, ETL and BI Reporting.

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

Solid Back End Testing experience by writing and executing SQL Queries

Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end

Experience in using Oracle Databases, DB2, SQL Server

Good in concepts of ETL, Warehouse and BI applications integration.

Good experience in working with onsite-offshore team model and agile process projects.

Having knowledge on MS Office, Excel, XML, MS Access.

Good Communication Skills to understand the business requirements with customers.

Ability to learn quickly to involve in any team in the project critical times.

Experience in UNIX Shell Scripts to support data warehousing tasks

Excellent SQL skills and provided multiple reports with the data from EDW to various Business customers.

Extensive experience in Onsite and Offshore model. Received good customer feedback for timely delivery and fulfilled the expectations.

Experience working in complex applications and adapt quickly to new platforms

Handled critical job failures in the production environment and Involved in fixing the data issues in the EDW.

EDUCATION DETAILS:

Bachelors of Technology in Computer Science, Acharya Nagarjuna University, APR- 2012, INDIA

TECHNICAL SKILLS:

Testing Manual Testing, ETL Testing

Data Warehouse/ETL Ab Initio 3.2.5, Teradata

Databases Oracle 11G,Teradata,MS SQL Server 2008, DB2

Languages/Scripting SQL, PL-SQL, XML, UNIX Shell Script

Tools Teradata Sql Assistant, HP Service Manager, SQL developer, HP/ALM Quality Center,

JIRA, control M,

Operating Systems Microsoft XP/NT, UNIX, Linux 4, Sun Solaris 8/7

PROFESSIONAL EXPERIENCE:

Client: Southwest Airlines, Dallas, TX Feb 2016 – Current

Project: Lone Star Project

Business Domain: Airlines

Position: ETL TEST ANALYST

Lone Star project deals with loading of data into EDW 2.0 (Teradata) from CDS-R (Teradata). The CDS (Commercial Data Store, a.k.a. Customer Data Store) is being created during the Lone Star project to hold ALTEA booking and passenger activity data in an operational data store scalable to serve the needs of our full domestic and international operations. CDS-R will be loaded using the feeds coming from the upstream process CDM (Customer Data Management).

Responsibilities:

Responsible for all the phases of SDLC which includes requirement gathering, testing, deployment and documenting the test catalogs as required.

Worked collaboratively with Business Analysts, SMEs, Technical Leads, Developers and Data warehouse engineers to understand the application and thereby validate the ETL scripts.

Responsible for writing, executing and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing.

Responsible for validating Source to Target data in Data Warehouse and Data Marts by writing SQL Queries to ensure that the target tables are populated according to the data mapping provided that satisfies the business rules.

Developed complex SQL queries for data validation for verifying the ETL Mapping Rules.

Ensure content and structure of all testing documents/artifacts are documented and maintained.

Created/Executed manual test cases and test scripts for System, User Acceptance Testing and

Integration testing, Regression Testing and log and track defects to closure in HP QC.

Responsible for providing the status report to the Project Manager in the Weekly Status meetings.

Responsible for working closely with users to ensure that the application meets the user’s expectations.

Logged and updated Issues and Risks using the configuration management tool JIRA.

Performed data analysis and data profiling using SQL queries on various sources systems including Oracle and Teradata.

Developed SQL Queries for Data Validation, Count Validation, Null Validation, Referential Integrity check validation and Duplicate Check Validation.

Designed/Developed/Executed UNIX shell scripts to automate the process of validating the ETL data.

Responsible for creating and executing Unix Scripts to perform Functional and Regression Testing.

Reviewed the Business requirement and Functional requirement and Technical specification Documents to get good understanding of web services.

Extensive experience with testing on Web Services using Wisdom SOAP Admin Console.

Client: Capital One, Plano, TX Jan 2014 –Jan 2016

Project: Financial Services

Business Domain: Banking

Positon: IT Analyst

Capital One Financial Corporation is a bank holding company specializing in credit cards, home loans, auto loans, banking and savings products headquartered in McLean, Virginia. This project dealt with providing day to day production support services to the End client.

Responsibilities:

Involved in monitoring the day to day production issues such as job failures, late time, late sub through HP Service Manager.

Solving the Job failures based on checking the log in the respective server and resolving it based on the log.

Debugging the Production Data issues using Teradata SQL assistant.

Used Multiple Joins to retrieve the data from EDW using Teradata SQL assistant to send reports to customers.

Used the Ab-Initio EME Website to view graphs, files and datasets and examine the dependencies among objects.

Involved in data conversions from different Source databases like Oracle, Flat files to Target Enterprise Data Warehouse in Teradata using Ab-initio built-in functions.

Contacting L3 Support team and the respective teams by opening a bridge line if the issue cannot be resolved by us.

Checking the Job in Control M Enterprise Manager if the job is delayed.

Worked on creating a work load policy in particular server during maintenances.

Written SQLs joins, sub queries and correlated sub queries.

Perform Change Orders for some jobs using remote desktop connection to connect to respective server.

Performing file restores through CommCell Console.

Monitor the BI launch reports and schedule them to run through Central Management Console.

Used Splunk Enterprise 6.4 to verify the status of some jobs.

Used to handle the alerts through Cisco Tidal Enterprise scheduler by acknowledging it, investigating the issue and rerun the job if it needs a rerun or approach the respective person to resolve the issue.

Tata Consultancy Services Aug 2012 – Oct 2013

Bengaluru, India

Client: Target Corporation – United States

Project: TLM DS Migration TCS

Business Domain: Retail

Positon: IT Analyst

Requirements gathering and analysis.

Estimation and Planning of Deliverables.

Analysis of the Production environment and preparation of an analysis document for specific application.

Preparation of Test Scenarios and Test cases as per requirements.

Execution of Test cases as per schedule and completion as on date.

Data set up for execution of test cases as and when needed.

Managing the identified defects using a centralized defect management tool like Quality Center and follow up of the defects for rectification.

Core team member of Integration testing team, which involves SQL scripting (Test scripts), validating & analyzing data in tables & identifying bottlenecks.

Executing the project in a capacity as a QA tester.

Developed and executed the Test Cases using the QC11.

Effective coordination between development and testing team.

Expertise in Data Migration projects and executing and verifying ETL jobs (Data Stage) involved in functional testing For the Application.

Involved in manual testing of test cases.

Investigated and documented software faults and interfaced with developers to resolve technical issues.

Identify The bottlenecks in the application in the Initial phase of testing i.e. in system testing

Potential Defects raised to the Developers to improve the functionality of the Application.

Single point of contact for the functional testing.

Core team member for System integration testing.

Involved in Transition to understand the business requirements with customers.

Identify The bottlenecks in the application in the Initial phase of testing i.e. in system testing

Potential Defects rose to the Developers to improve the functionality of the Application.

Core team member for System testing.

Re-testing the defected module and validation.

Maintaining daily and weekly status reports.

Preparation of a Test Report once the testing of an application is complete.



Contact this candidate