Resume

Sign in

Data Sql

Location:
Atlanta, Georgia, United States
Posted:
January 10, 2018

Contact this candidate

Resume:

Suniti Sai

ac3zcp@r.postjobfree.com

Status - US Citizen

https://www.linkedin.com/in/suniti-sai-3830b914a/

Phone: 917-***-****

Experience Summary

Software Professional with 7 Years of core experience in Business/Data analysis, Manual, ETL and Database Testing.

Understanding of Software Testing Lifecycle (STLC) aspects such as Writing Test Strategies, Test Plans, Test Cases, Defect Reports and Traceability Matrices.

Experience in Data Profiling, Data Migration, Data Integration, Data Modeling (Erwin) and Metadata Management Services.

Setup processes to collect data into database, backup, storage data, performed data validation, mapping and mining data, generated and analyzed student records and various reports by using

SQL, Oracle with queries, Dashboards, PL/SQL, Teradata, TOAD.

Identify root causes and risks, lead for integrating the business in Data Governance.

Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)

Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage

Provided technical support services for MDM mapping and gap analysis sessions.

Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.

Collaboration with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.

Defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks.

Excellent in Bug Reporting and Bug Tracking using various tools.

Create the Adhoc reports by using BI.

Experience and in depth knowledge of Agile Testing Methodologies.

Have Mobile testing experience (understanding of multiple platforms e.g. iPhone(ios), Android phones, Droid tab, iPad, windows phone and MAC devices).

Strong analytically and technically, have excellent experience in advising improvement in designs.

Experience to generate the Bill/Invoice by using the CA Workload (Dseries/ESP).

Conduct training for off shore and onsite team and coordinate the whole team.

Proven Flexibility, Quick learner, Proactive attitude and an amazing team player.

Highly efficient in delivering in complex, Agile, Dynamic, Onshore-Offshore project Environments.

Expert on Black Box Testing techniques include GUI testing, API testing, Functional testing, Compatibility testing, System testing & Regression testing.

Expertise in mentoring, handling multiple tasks and work independently as well as in a team.

Core Skills

Test Management Tools: HP ALM, JIRA, Microsoft Test Management Tool (MTM).

Tools: CA Workload, SOAP UI, FTP, Beyond Compare, BI (MicroStrategy), SSIS

Programming: R Programing, VB Script

Database: SQL, PL/SQL Server, TOAD, Teradata, Informatica Power Center 9.x/8.x,SSMS

Environment: Java, PL/SQL, UNIX

Certifications

IZ0-051-ORACLE Certification

R Programing from Johns Hopkins University

The Data Scientist's Toolbox from Johns Hopkins University

Getting and cleaning Data from Johns Hopkins University

Academics

Master in Life Science, JNU, New Delhi, India

Work Experience Summary

Client: Confidential (Health client), GA

Role: Lead Data Integrity Analyst

Duration: Aug17 – Till Date

Responsibilities:

Work with Business Analysts regarding requirements which involves PDM data and relaying any conflicting Information.

Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).

Involve in data Validation by using the vlookups and SQL queries.

Create the Pivot table and Dashboard after analysis and provide to higher management.

Data migration, Data Conversion, by using the SSIS.

Identify root causes and risks, lead for integrating the business in Data Governance.

Create the Adhoc reports with the help of MicroStrategy tool.

Client: Verizon Wireless, GA

Role: Data Quality Analyst/Business Data Analyst

Duration: Dec14 – April2017

Responsibilities:

Work in conjunction with Business Analysts regarding requirements which involves customer data and relaying any conflicting Information.

Data analysis to identify various business requirements.

Define and determine data errors/Modify procedures to reduce future errors.

Document and communicate complex business rules surrounding data to all parties.

Perform quality checks on daily basis.

Have Mobile testing experience (understanding of multiple platforms e.g. iPhone (iOS), Android phones, Droid tab, iPad, windows phone and MAC devices).

Worked on Requirement Analysis, Data Analysis and Gap Analysis of various source systems sitting and coming from multi systems. Responsible for BI Data Quality.

Conducted JAD sessions to allow different stakeholders such as editorials, designers, etc.,

Performed Business Process mapping for new requirements.

Performed Data Validation with Data profiling

Involved in Data Extraction from Teradata and Flat Files using SQL assistant.

Designed reports in Access, Excel using advanced functions not limited to vlookup, pivot tables, formulas

Use SQL, PL/SQL to validate the Data going in to the Data Ware House

Creating complex data analysis queries to troubleshoot issues reported by users.

Evaluates data mining request requirements and help develop the queries for the requests.

Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.

Executed the Test Scripts in TOAD and documented the results in RTM.

Define scope of testing within each release with the help of BA and Developers.

Deploy and manage the appropriate testing framework to meet the testing mandate.

Maintain research database, renewed and improved it from time to time and made sure safe storage of data.

Experience in, to generate the Bill/Invoice by running the batch jobs through the CA Workload (Dseries/ESP).

Provide Traceability from business requirements and technical specifications to test conditions and problem report.

Perform end to end testing on the reseller and lessee calls usage to generate different reports to feed into the Data warehouse Platform.

Troubleshoot PL/SQL procedures on UNIX as well as shell scripts to resolve issues and performance tuning.

Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.

Work closely with developers, Business Analysts, Program Managers and production Support to identify errors in data mapping.

Co-ordinate in Onsite\Offshore model and currently managing a team of 6 people.

Tools and Technologies: SQL Server 2012, Teradata utility 15.10, TOAD, JIRA, Confluence, Beyond Compare, FTP, Business Objects, Quality Center 11.0, ALM, Oracle 10g / 11g and UNIX, ETL, Excel, Powerview.

Client: AT&T, Atlanta, GA

Role: QA Analyst/Business Data Analyst

Duration: Mar 14 – Aug 14

Responsibilities:

Gather Business Requirements, Functional Requirements and Design Documents.

Perform Functional, Negative, Integration, Regression, End to End and User Acceptance Testing.

Writing and designing templates for the Test Plans and Test cases

Create Traceability matrix based on Functional requirement

Base-line Regression tests scheduled and performed in every release and build.

Support End-to-end testing for downstream systems.

Test deliverables, manage entry and exit criteria for testing and involve in complete testing life cycle.

Create Test Data for Member data’s according to scenarios.

Task Creation, Task Estimation, Task Distribution, Task Prioritization, billing and Communication among Onsite and Offshore Team Members.

Regular follow up with the development team to discuss the defects identified during Testing.

Test Coverage Metrics and Defect metrics such as Defect Density, Delivered Defect Density, Defects by Severity, Number of Defects, and Defects per build, Defect Fix Rate, Test Case Utility, Test Effort and various other measurements.

Interact with end users and investigate issues related to the QA.

Use Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Use SQL for Querying the DB2 database in UNIX environment

Write SQL queries and validate the data.

Database integrity testing by executing SQL statements.

Coordinate user acceptance testing with final users.

Participate in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center

Maintain bug lists for critical issues using ALM Quality Center.

Tools and Technologies: HP ALM, Rally, SharePoint, SQL Server 2005, UNIX, PL/QL, XML, MS Excel and MS Word

Client: Capital One, Richmond, VA

Role: Test Engineer/Data Analyst

Duration: Feb 10 – Dec 13

Responsibilities:

Test Execution, analyzing bugs, interaction with the development team members in fixing the errors.

Participate in requirement and design meetings to know the functionality and flow of the application and hosted Test case review meetings.

Interact with developers and discussed technical problems, reported bugs and supported development team

End-To-End testing, User Acceptance Testing, Functional Testing.

Test new functionalities on mainframe and integration testing between .NET front end and data written to mainframe VSAM files.

Identify high-risk points and priorities of the application & classifying them based on the severity using Quality Center.

Use Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Test Web, Web services, SOAPUI, and Client/Server applications.

Create and implement testing process for agile methodology.

Develop detailed Test cases, Test conditions, Test scripts, Test procedures, Testing Methodologies and Test Matrices.

Write SQL queries and validate the data.

Database integrity testing by executing SQL statements.

Compatibility Testing for Browser, Operating, Mobile & Printing options for Web Apps

Update and maintain Quality Center for reporting and logging the defects found during functional and regression testing and follow up the bug life cycle.

Data analysis using SQL, T-SQL and many other queries based applications.

Use T-SQL to verify and validate the data loaded to the SQL Server

Use SQL tools to run SQL queries and validate the data loaded into target tables

Data validation using SQL queries and back-end testing

Tools and Technologies: HP ALM, Visual Studio 2010, SQL, PL/SQL SQL Server, Rally, MS Visio, UNIX, MS Excel



Contact this candidate