Post Job Free

Resume

Sign in

Sql Developer Manager

Location:
Bhopal, Madhya Pradesh, India
Posted:
May 05, 2021

Contact this candidate

Resume:

Yash Golchha

Magarpatta city,Pune

Mobile: +91-797*******

E-mail ID: adl5xu@r.postjobfree.com

Professional Summary

• Technology Engineer having 4.5+ years of experience in SQL, Unix, Perl/Python Scritping and currently associated with Amdocs.

• Have strong analytical and troubleshooting skills.

• Have Automation skills. Produced Automation scripts using Unix Shell/Perl/Python script to reduce the manual effort. Have knowledge of ordering and billing system for AT&T.

• Effective communicator, quick thinker and rapid problem solver with commitment and has a strong work ethic. Good experience in Application Development\Testing and Support, Production Support & Telecom domain Skills

• Database : Oracle 10g/11g.

• Operating system : HP-UNIX, Aix5.3, Ubuntu/Linux, Windows XP/2000.

• Tools : Putty, SQL Developer,Kibana,Grafana,

WebTrax, Exception Manager,TDP,Kubernetes,HP Sitescope

• Languages : SQL,Unix,Perl,Python,ELK,Core Java (basics),docker

• Certification : Microsoft Azure Fundamentals (AZ-900) Experience

AT&T-OMS (Order Management System)/Billing System (July 2016- Oct 2017) Project Description OMS is an automated solution to manage the service order lifecycle and helps to fulfill complex and bundled orders quickly and accurately. Wherever the order originates, whether from self- service or a customer agent, service order management software takes each order and decomposes it into a sequence of interdependent tasks. Role Application Support (L2 Level)

Domain Telecom

Duration July 2016 to Oct 2017

Customer/Client AT&T USA

Technologies Oracle SQL, Unix

Responsibilities • Supporting an Amdocs Ordering management application for any incidents or service requests and Ensuring its availability.

• Provided Application support for OMS product.

• Handling the OMS related internal technical issues raised through the Webtrax/CSR

• Correction of erroneous data by manual intervention and workarounds.

• Provided Reconciliation Support between OMS and Enabler.

• Working on the EM (Exception manager) to clearing the backlogs of the order stuck at the Calls to the different systems.

SDS Tools Team and Webtrax

Project: Unified Dashboard,aPa application, Webtrax reporting Team Size: 4

Duration: November 17 2017 – Sept 2020

Database: Oracle

Technologies: SQL, Unix, Perl,ELK,Python

Project Description : Shared Delivery Services Tools team has developed and tested various system monitoring and alerting tools for all the applications in AT&T group with the aim to provide one stop place to identify issues, collect data and use this data to provide insights and trends to the Customers on a Dashboard or a website. Webtrax application has all the billing related reports and data as well as all the billing events Responsibilities:

• Development and maintenance of alerting scripts based on business requirement in Perl/Python

• Development and support of Unified Dashboard tool depicting overall health of applications To Support Release and upgrades, Iphone launch efficiently

• Automations of various scripts to reduce manual efforts and resolve system/server issues like overload/failure

• Development and testing of tools like ATT Mobility dashboard, Billing Automations using Perl scripting and Json for backend data

• Maintaning Kibana dashboard - elastic search, logstash processes AtomIQ Monitoring Team

Project: Open Source tools based monitoring,Mobile BI application Team Size: 8

Duration: September 15 ‘2020 – till date

Database: Influx

Technologies: SQL, Shell scripting,HP Sitescope,Grafana,Docker Project Description : AI and open source based system monitoring and alerting tools for all the applications in APAC and phillippines region with the aim to provide one stop place to identify issues, collect data and use this data to provide insights and trends to the Customers on a Grafana Dashboard or a website. Also present this data in graphical manner on a mobile application Responsibilities:

• Support / maintenance of the Mobile application which is using full stack technologies and ionic framework.

• Resolving issues related to the availability of the app and data being presented on the application

• Implementing monitoring using sitescope for various applications

• Automations of various scripts to reduce manual efforts and resolve system/server issues like overload/failure.

• Maintaning Grafana dashboard - influx,telegraf processes.

• Data collection on influx database and applying AI solutions to detect anaolamies and show the data trends. Educational Summary

Course College/University Year % Obtained

Lakshmi Narain College of Technology Bhopal M.P. 2016 77.7% B.E.(Hons) (Rajiv Gandhi Technical University, Bhopal) Intermediate St.Aloysius Sen.Sec.School Jabalpur,MP 2011 75% High School St.Aloysius Sen.Sec.School Jabalpur,MP 2009 88% Certificaties/Recognition

• Certificate of Recognition – Amdocs.

• Secured first position in Google Design Sprint organized by IIT Indore Fluxus’15

• Secured first position in technopuzzle organized by MANIT,Bhopal and participated in coding competitions at college levels..

• Secured 6th position in State Level Science Quiz in 2009.

• Got the Certificate of Merit in Quiz under Gambit 2014 organized by Srijan 2014.

• Won in interschool and interaschool group singing and skit competitions. Hobbies & Interest

• Dancing

• Member of National Service Scheme (NSS).

• Member ( Propel Wingman) of a non profit Youth organization named MAD. Reading

• Listening to music.

Personal Profile

Name : Yash Golchha

Marital Status : Engaged

DOB : 25-Mar-1992

Nationality : Indian

Permanent address :H.No.112 Cantt Sadar bazaar jabalpur, M.P, India Declaration

I hereby declare that all information provided by me in this resume is true to best of my knowledge.

(Yash Golchha)



Contact this candidate