Piyush Gawai

813-***-**** adjejh@r.postjobfree.com

SUMMARY

• 3+ years of experience in Application support, Software testing, Tableau reporting, in Amdocs and Verizon

• 3+ years of SQL, Unix, Jira, HP ALM, 3GIS Application, Tableau reporting, Fiber Network Management system

• Technical knowledge of Agile methodologies, DDL, DML VSTS, Defect tracking Management system EDUCATION

MS in Electrical Engineering Dec 2018

University of South Florida, Tampa, FL (GPA: 3.3)

Bachelor of Science in Electronics and Telecommunications May 2014 Rashtrasant Tukadoji Maharaj Nagpur University, Nagpur, India (GPA: 3.7) TECHNICAL SKILLS

• Technologies and Environment: SQL, VSTS, Unix, JIRA, HP ALM, SDLC, Tableau, ARCGIS, ARCMAP

• Others: ADS, Amdocs Quality Center, Ginger, Visio, Project Handling, Agile Methodologies, Fiber Inventory tool WORK EXPERIENCE

Application Support Engineer, Verizon, United States, Tampa Jun 2019- Sep 2020

• Working on the server side on ETL for validation, verification and loading of data for 5g networks.

• Manipulating data into of GDB and insert new fields in the table if it is not present and update GDB with SDE data.

• Support and provide solutions on production related issues to multiple vendors.

• Working on Complete Software Development Life Cycle of the project.

• Working with geo navigation tool and API ARCMAP and ARCPY tool for geo location views and table views.

• Designing daily dashboards for the DML, DDL and AYS reports in Tableau.

• Proactively working with all the Verizon vendors to make sure all the Permits, Fiber cable are invoiced correctly.

• Analyzing and troubleshoot customer’s issues on fiber connection, Network planning and ensure functionality of the product and services.

• Worked on GDBs (Geo data base) to make sure all the data sent by user is without any exception and loaded correctly in Fiber Inventory management system

Software QA Analyst, Amdocs, Pune, India Mar 2014- June 2016

• Analyzed business requirements and functional documents, created the test strategy document that define the test environment, phases of testing, entrance and exit criteria into different phases of testing and resources required to conduct the effort.

• Conducted backend testing using SQL queries to validate data for database.

• Worked on Project Management tool- RTC, Jira, HP- ALM.

• Created test plans and test cases in concert with system engineers and web designers.

• Tested the application manually prior to automation for functional testing.

• Performed Manual performance testing to identify various critical points in the application.

• Wrote test cases and performed Manual Testing like Positive Testing and Negative Testing, Regression, Integration, Unit Testing.

• Performed requirements Analysis, Risk analysis, Dependency Analysis, and Issues/Problems Analysis.

• Created Test Cases Test Plans and Test labs using Quality Centre.

• Wrote SQL queries and statements to test database for retrieving information.

• Coordinated the walkthrough and kickoff meetings with developers and project managers. CLASS PROJECTS

Spectre and Meltdown.

• Identifying the causes and effects of Spectre and Meltdown and Approaches of different companies like Intel, Microsoft, Google, Apple to deal with it.

Detecting Password through Dictionary and Brute Force Attack

• Lead a team of Three students to develop a program that will identify the password of the user from the dictionary file.

• Developed a program to crack as many as 110 possible passwords from the password file in SHA-1 hashed version using python.

Designing Filter

• Designed and Implemented a microstrip coupled line band pass Filter for Given Frequency of 2.1 GHz using Advanced Design System.

Contact this candidate