SUMMARY:

• 5+ years in Information Technology with Expertise in ETL testing for Data Warehouse/Data Mart development, Data Analysis for critical Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications and test data management experience.
• 2 Years of Experience on CA Test Data Manager.
• Involved in Assessment, Pilot and implementations phases of Test Data Management system for various clients.
• Manual / Automated Software Testing and Software Quality Assurance experience. Metrics definition and planning. Full understanding of the Software Development Life Cycle
• Have worked during various phases of project life cycle phases like Requirements and Analysis, Testing. My Technical abilities are complemented by good communication skills and user interaction abilities
• Complete understanding of the entire life cycle if testing. It includes both positive and negative testing.
• Experience in using the HPQC tool.
• Have knowledge in bug life cycle and SDLC concepts.
• Extensive experience in writing and executing test case and also executing them.
• Excellent logical and analytical skills with excellent communication skills.
• Worked as a QA test analyst and have knowledge on the prod, pre - prod and QA runs and testing methodologies.
• Certified CA Test Data Manager Implementation proven professional.

TECHNICAL SKILLS:

Databases: SQL Server, Oracle, DB2.

Reporting Tools: Microsoft Analysis Services, Business Objects, SSRS, Tableau reports.

ETL Tools: BODS

TDM Tools: Data Maker, Agile Requirement designer, Fast Data Maker, CA TDM Portal, GT Subset, Javelin.

Programming Languages: SQL

Productivity: Microsoft Office, Microsoft Excel

Methodologies: Waterfall, Agile

Software Testing: Manual Testing, Test Plan, Test Case, Regression test, Co-existence test, User Acceptance Testing, Release planning, Defect Meetings.QA Tools: Quality Center, CA Test Data Manager, HP Agile Manager.

PROFESSIONAL EXPERIENCE:

Confidential

Test Data Subject Matter Expert/ Test Data Management Engineer & Service Virtualization Engineer

Responsibilities:

• Was involved in selection of appropriate TDM tool for the Client.
• Installed CA TDM tool on server machine & work laptops.
• Initial setup of tool with different types of databases was done successfully.
• Initial 4 months was pilot phase which included conducting POC’s explaining different features of TDM like Data Masking, Data Subsetting, Synthetic Data Generation, Business Scenario Specific data.
• All the developed POC’s are utilized by Testers through Test Data Management Portal.
• Virtualized the services which are not available so that system can continue their testing without any lapse in time.
• Implemented multiple use cases on Synthetic Data generation, Data Masking of PII Data (SSN, Phone Number, Names and Address), Data Subsetting (Filter Data based on certain criteria).
• Worked on different types of sources formats like XML, Flat Files etc.
• Worked on File masking (XML, CSV, Flat files) and Table Masking.

Test Data Subject Matter Expert

Responsibilities:

• Conducted interviews with Stake holders on Test data related challenges.
• Participated in TDM tool evaluation process.
• Involved in creating High-level TDM Road Map document.
• Involved in creating Strategy document for TDM Implementation.
• Participated in Final presentation of TDM Assessment phase.
• Involved in creating the plan for Pilot Phase.

TEST DATA MANAGEMENT TEST LEAD

Responsibilities:

• Worked as Test data management test lead on CA TDM tool for Confidential project (Confidential)
• Worked on masking different types of files like x12, EDI, xml, dat files and HL7 messages.
• Worked on masking tables for different subsystems like Eligibility&Enrollment, Third party liability(TPL), Providers, Internet, dataware housing.
• Worked on different modules in CA TDM like Data cloning, Data sub setting and Test Matching.
• Masked the data in such a way that it properly generates 834’s and 271’s.
• Generated synthetic data for future tests.
• Updated the Scramble database with seed data.
• Worked as Team lead in an engagement with Confidential from scratch to go live in implementation of masked data in Confidential .
• Had to manage a team of 3 along with 2 consultants from Confidential .
• Involved in all phases of project actively.
• This project followed agile methodology. HP AGM was used to track project status.
• Created user stories in HP AGM and actively involved in sprint meetings.

Test Data Management

Responsibilities:

• Detailed JD Bottom-line responsibility for TDM deliverables
• Coordination with QA and other teams for TDM needs Transition plan and execution TDM strategy and implementation.
• Weekly status reporting analyzing physical data model and data relationships for TDM Offshore coordination and review of all deliverables
• Data validation post data refresh TDM tool evaluation, POC and implementation
• TDM script development and execution for gold copy creation and environment refresh
• Data validation post data refresh Physical data model and data relationship analysis TDM tool usage

QA Analyst

Responsibilities:

• Review functional and design specifications to ensure full understanding of individual deliverables.
• Backend database testing in Teradata including validating stored procs, jobs and triggers.
• Identify test requirements from specifications, map test case requirements and design test coverage plan.
• Develop, document and maintain functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts.
• Execute and evaluate manual or automated test cases and report test results.
• Hold and facilitate test plan/case reviews with cross-functional team members.
• Identify any potential quality issues per defined process and escalate potential quality issues immediately to management.
• Ensure that validated deliverables meet functional and design specifications and requirements.
• Isolate, replicate, and report defects and verify defect fixes.

Environment: Oracle 11g, Toad, Crystal reports 9, Teradata

QA data Analyst

Responsibilities:

• Worked as an ETL Development practitioner
• Worked on SAP BODS to create jobs, workflows, scripts, data stores to load in data quality tables.
• Involved in data quality analysis.
• Prepared data quality rules, business level data checks and generated reports based on the EDW data at different stages of the project.
• Worked on Teradata to prepare SQL, validating the data in EDW tables, semantic views.
• Extensive experience in writing and executing scripts for validation and testing of the sessions, data integrity between source and target database.