Ms. YOGITA D. PATIL
Mobile: +1-469-***-**** / E-Mail: ***********.**@*****.***
Work authorization: - H4 EAD (Valid Till Aug 2022) ISTQB Certified Tester
LinkedIn Profile: https://www.linkedin.com/in/yogita-patil-897b9b13/
Seeking an assignment in Software Testing with a growth-oriented organisation.
PROFESSIONAL SYNOPSIS
A dynamic professional with 9.5+ years of rich experience in Software Testing.
Currently Working with TechM as Senior Software Engineer in Plano,TX
Worked with AMDOCS as Data warehousing Senior Testing Engineer in Richardson TX and with Amdocs India pvt ltd.
Worked with Reliance Communications Limited, DAKC as Testing Engineer Associated with Datamatics Ltd as well.
Possess excellent interpersonal, communication and analytical skills with demonstrated abilities in customer relationship management.
Possess the ability to adapt to new challenges and maintain excellent relationship.
Expertise in managing software testing projects entailing creation and execution of test scripts using testing tools.
Well versed with testing concepts and methodologies and test life cycle methodologies.
Experience in preparing test estimation, test cases and test summary report.
Comprehensive understanding of software testing including creation of test cases and writing test cases for unit level integration testing, smoke testing, sanity testing and regression testing.
IT SKILLS
Database : MySQL, Oracle, HBase, Teradata, DB2
Testing Approach : Manual Testing, Functional Testing, Frontend-Backend
Testing, APIs(SOAP/REST)
Testing Application : ClariFy, TIBCO, PhoneGen, SOUPUI
Issue Management Tool : Rational Clear Quest, HP Quality Centre, TDP, Jira, Rally
Version Control Tool : Rational Clear Case, SVN, GIT
General Software : Microsoft Office, Beyond Compare, UltraEdit, GIMP
ORGANISATIONAL EXPERIENCE
Projects Handled
Title : Analytics 2.0 Fire
Client : Blue Cross and Blue Shield Association
Location : Plano, TX USA
Duration : May/2020–Till dATE
Environment : Unix, DB2, JIRA,HP ALM, Abnitio, Cognos
Role :
Collaboratively elaborates analyse and estimates user requirements with the team.
Defines and manages test plans, strategies, results reporting and metrics
Collaborates with the team to design test scenarios, build automated scripts and data and execute the scripts
Validates test results and works with developers to research and resolve defects
Identifies appropriate test strategy mix of manual and automation testing methods (leveraging automation where possible)
Coordinates and plans test runs
Maps requirements to tests and test results
Creates and modifies detailed automated test scripts/modules
Works with test automation architect to expand and/or improve automation framework and trouble shoot technical issues
Maintains solid knowledge and expertise in automated testing tools and techniques
Identifying Test scripts for a Regression Suite
Title : Data Lake - Data Warehousing
Client : AT&T (U.S.)-Mobilty (Amdocs)
Location : Richardson, TX USA
Duration : Sep/2016–Mar 2018
Environment : Unix, Teradata, Hive, CDAP, Shell, Oracle 11g, PLSQL, REST API
Role :
As Lead member handled lead role, involved in client communication in Data Lake project
worked with teams in different time zones and onsite/offsite model.
Provided estimate for new projects. Onshore offshore communication.
Worked on real time data flow testing for Data Lake project.
Understanding the ‘Functional Architecture’, ‘Integration Architecture’ and ‘Interface Exchange Documents’, ‘Interface Control Documents’, and ‘Business Processes’.
Working with business analysis function to ensure requirements are appropriately identified and included in the requirements.
Designed and Validate test cases as per test procedures for Project which included validation for CDAP Workflows, map-reducers, database validation, APIs (REST/Voltage), E-E Dataflow from Source till Downstream.
Title : CCPM/Business Intelligence Development- Data Warehousing
Client : AT&T (U.S.)-Mobilty(Amdocs)
Location : Richardson, TX USA
Duration : July/2012–Aug/2015
Environment : Unix, Teradata, Shell, Informatica, Oracle 11g, PLSQL, REST API
Role :
In data mart project, Handled lead role, client communication
Provided estimate for new projects. Onshore offshore communication.
Worked in Golden Gate data testing and real time data flow testing for project.
Managed Team of 9 people including onshore, offshore and near shore.
Understanding the ‘Functional Architecture’, ‘Integration Architecture’ and ‘Interface Exchange Documents’, ‘Interface Control Documents’, and ‘Business Processes’
Working with business analysis function to ensure requirements are appropriately identified and included in the requirements.
Creating the Unix environment for ETL testing, ETL development using shell scripting
Executing the shell script to load data in Database (Teradata)
Using the Informatica to extract the data from source, generating Extracts, loading into Target.
Using Informatica to import the data from different database, file and to export the data in different files and in database.
Title : Business Intelligence Development- Data Warehousing
Client : AT&T (U.S.)-Mobilty(Amdocs)
Location : Pune India
Duration : Sept/2010–Oct/2011
Environment : Unix, Teradata, Shell, Informatica, Oracle 11g, PLSQL
Role :
I was a part of ABS (ATT Business Solution, CDL(Corporate Data Layer),Sustainment project Team.
Creating the Unix environment for ETL testing,ETL development using shell scripting
Executing the shell script to load data in Database(Teradata)
Using the Informatica to extract the data from source,generating Extracts,loading
into Target using BTEQ scripts and mLOAD
Understanding the ‘Functional Architecture’, ‘Integration Architecture’ and ‘Interface Exchange Documents’, ‘Interface Control Documents’, and ‘Business Processes’
Working with business analysis function to ensure requirements are appropriately identified and included in the requirements.
Preparing Informatica, system testing and end to end testing environment
Using Informatica to import the data from different database, file and to export the data in different files and in database.
Title : ROGERS & Bell Telecom, Canada
Client : IBM-Amdocs
Location : Pune India
Duration : Mar/2010–Sep/2010
Environment : Clarify, Oracle 11g, PLSQL
Role :
Worked as Software Test Analyst for ROGERS & Bell Telecom, Canada.
Worked as team member from offshore team,(India).
Involved in writing test cases based on business requirement specification, System requirement specification & other supporting document.
Involved in preparing test environment for SIT,UAT & performed Smoke Testing to check stability.
Worked on Clear Case, Clear Quest & Rational Quality Manager application for reporting project progress.
Title : Amdocs CLARIFY (CRM Application)/TIBCO OMS
Location : Mumbai, India (Reliance Communication)
Duration : Sept/07–Mar/10
Environment : AmdocsClarify,TIBCO,BW5.X, ORACLE
Role :
Worked as Software Test Engineer in System Acceptance Testing department
Understanding the ‘Functional Architecture’, ‘Integration Architecture’ and ‘Interface Exchange Documents’, ‘Interface Control Documents’, and ‘Business Processes’.
Working with business analysis function to ensure QA testing requirements are appropriately identified and included in the requirements.
Involved in delivering various change requests on GSM projects post launch.
Achieved appreciation on launching GSM technology for Reliance communication in less than given timeline from all top management.
Involved in testing various basic telecommunication scenarios like Customer Creation, Order provisioning, Order Fulfilment, Creation of Call Duration Records(CDR), Uploading the same on mediation servers to generate the logs, generating monthly bills & verifying the same against CDRs
Worked in various core telecommunication processes that involves SIM & IMSI creation for various locations, SIM pre-provisioning for pre-paid & post-postpaid, maintaining SIM statuses on HLR for both Prepaid & postpaid, SIM activation for both pre-paid & post-paid connections.
QUALIFICATIONS
2007- Bachelor’s Degree in Engineering (B.E.) – I.T. with 69.33% from Government College of Engineering, Amravati (Amravati University).
2004- Diploma in Information Technology with 69.92% from Government Polytechnic, Jalgaon (Maharashtra Board).