Venugopal Shramwad

Experience

• 

  Zensoft Technologies Pvt Ltd

  Dec 2014 - Sept 2015

  Oracle DBA

  Project Title: MANGALAM JEWELERS.Details: Developed ASP.net web application in managing all utilities and functionalities for each role defined as - Admin & Customer.For a Jewellery shop which facilitates customer visit and register to our site and purchase diamonds and jewelry online.Technology Used: ASP.net 3.0(C#.net), SQL Server 2008.Roles & responsibilities:• Database Design, developing Business logic.• Creation of schema objects like table, view, sequence, synonyms, index (Rebuilding) and constraints.• Write Query using join, subquery, functions, set operators DML, DDL.• Write PL/SQL code such as procedure, function, package and Trigger. Show less

• 

  IBM

  Oct 2015 - Jun 2016

  Oracle Database Administrator

  • Creation of schema objects like table, view, sequence, synonyms, index (Rebuilding) and constraints.• Write Query using join, subquery, functions, set operators DML, DDL.• Write PL/SQL code such as procedure, function, package and Trigger.• Managing Tablespaces, data files, redo logs, segments and Database Links.• Managing Users, Privileges Roles, Creating Database users and granting roles.• Tune SQL statement against the database and its objects.• Creating production scripts for various purpose data fetching updating tables etc.• Reconciliation of CDR reports for missing files or any as per RA validations.• Having Knowledge on Amdocs ABMG, INVOICING, RATER, EPC and Recovery of files, Re-Rating, EOD related modules.• Execution of bill cycles, post bill cycle activities as a part of invoicing with all pre-bill checks.• Handling rating, re-rating, rejects recycling process on daily basis.• Handling Charging/EPC related incidents assigned to a team.• Troubleshooting and maintenance of Oracle Database, Handling space issues.• Database: SQL, PLSQL, SQL Plus.• Operating Systems: Linux, Windows. Show less

• 

  Amdocs

  Jun 2016 - Oct 2018

  Software Developer ( Oracle / Telecom )

  Project Title: VODAFONE INDIA LTD (Telecom).Details: Vodafone India is a well-established telecom Operator in India. It is having its presence all over India, with state of art telecom services. The centralized operation for Vodafone IT services, rating, billing etc. are carried out by Amdocs Development India Pvt. Ltd. Pune. Before Amdocs, all this process carried out by IBM India Pvt. Ltd. Pune.Duration for IBM India Pvt. Ltd. Pune: 15-Oct-2015 to 27-Jun-2016.Duration for Amdocs Development India Pvt. Ltd. Pune: Presently working from 28-Jun-2016Technology Used: RHEL 5, Oracle11g, Oracle SQL developer, AMC tool (Amdocs monitor & control), BMC Remedy, Unix (AIX), Linux 6.1.0.0, Putty, MobaXterm_3.0Roles & responsibilities:• Reconciliation of CDR reports for missing files or any as per RA validations.• Creating production scripts for various purpose data fetching updating tables etc.• Having Knowledge on Amdocs ABMG, INVOICING, RATER, EPC and Recovery of files, Re-Rating, EOD related modules.• Execution of bill cycles, post bill cycle activities as a part of invoicing with all pre-bill checks.• Handling rating, re-rating, rejects recycling process and complete billing process on daily basis.• Handling Charging/EPC related incidents assigned to a team.• 24x7 on-call Production support for database activities.• Coordinating with team members. Show less

• 

  Zensar Technologies

  Nov 2018 - now

  Technical Specialist

  Oracle, Python Development.