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.
• 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 tools.
• I worked with COBOL copy books and loaded VSAM files into the Teradata database using ETL tool like Informatica.
• 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.
• Experience as a Team Leader with strong focus on Documentation, Communication, Process and Constant Improvements.
• 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.

TECHNICAL SKILLS:

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

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

Programming: R Programing, VB Script

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

Environmen: t: Java, PL/SQL, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, GA

Lead Data Integrity Analyst

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 from EDW to SSMS by using the SSIS.
• Create the Adhoc reports with the help of MicroStrategy tool.

Confidential, GA

Data Quality Analyst/Business Data Analyst

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.

Confidential, Atlanta, GA

QA Analyst/Business Data Analyst

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

Confidential, Richmond, VA

Test Engineer/Data Analyst

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