Harshkumar Satapara

Harshkumar Satapara

FIELD APPLICATION ENGINEER (FAE)

Followers of Harshkumar Satapara2000 followers
location of Harshkumar SataparaPune, Maharashtra, India

Connect with Harshkumar Satapara to Send Message

Connect

Connect with Harshkumar Satapara to Send Message

Connect
  • Timeline

  • About me

    Oracle SQL - PLSQL | Certified Oracle Apex professional | Senior Software Developer at Oracle Corporation in India

  • Education

    • ITS

      2012 - 2012
      SQL-DEVELOPER SQL
    • ITS

      2012 - 2012
      SQL-DEVELOPER
    • S.P.B. Patel Engineering College

      2007 - 2011
      Engineer’s Degree Electronics & Telecommunication Destinction Class
    • M.B. Patel Gyan Jyot Higher Secondary School

      2005 - 2007
      High School HSC,SCIENCE First Class
  • Experience

    • Silicon Components Pvt. Ltd.

      Nov 2011 - Sept 2013
      FIELD APPLICATION ENGINEER (FAE)

      I AM A FAE, FIELD APPLICATION ENGINEER. GIVEN A TECHNICAL SUPPORT TO THE CUSTOMER ALL OVER GUJARAT.below is a key roll of mine in this company.- Handling and giving support to all over Gujrat- Given full technical support to Customer for developing his product- Given training on software for developing program on Microcontroller

    • Vodafone

      Sept 2013 - May 2015
      Software Engineer

      I was Started working in Vodafone in Sep 2013. Since i was new joined over there and i changed my field from EC to IT , i learnt all the thing very quickly. due to my hard work and knowledge they transfer me to centralized team which is setting in Pune. i shifted there on others payroll at Apr 2014. Below is my Key Responsibility over there.- Make the daily backup of system- Working with SQL query, stored procedure and backend database.- Developing SQL or PLSQL related query for Activity and Migration plan.- Develop dump related query for daily bases system hits and count on Database.- Handling Migration activity and doing necessary changes in Database with help of DML and DDL Queries.- Software & Database Support for throughout Indian technical staff. - Maintenance and daily backup of Server- Work with UNIX Scripts.- Managing Production Databases & Application Servers, Provide 24 X 7 proactive support. - Monitoring of error logs of UNIX servers, monitoring of database alert log, space allocations regularly.- Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.- Database Security, User management- Backup and recovery strategy.- Provide DBA Support to Business Analysts and Development Teams. Rectify system and software problems like software crashes, database run time errors etc.- Check and tune the performance of the SQL with appropriate Index Strategy and statistics.- Compilation of defect lists, intimating the same to vendors and monitoring the defect rectification.- Co-coordinating with HP/Wipro/IBM for Hardware solution & HP-UX(O/S related solution’sI also done Migration for SMSC to SMSR and give guidenss for doing work properly. need to handle SQL tuning in migration. Show less

    • Amdocs

      May 2015 - Apr 2016
      Software Support Engineer

      I was joined AMDOCS on payroll of COLLABERA in May-2015.This is based on Billing Systems for all telecom which is connected with AMDOCS. Below is my roles at AMDOCS.- Check all the Jobs running fine or is there any problem with it.- Working with SQL query, stored procedure and backend database.- Developing SQL or PLSQL related query for formatting bills and also for rejected bills.- Develop rejected related query for daily bases system hits and try to reduce the rejection of bills.- Doing necessary changes in Database with help of DML and DDL Queries if necessary for rejection or in main bill.- Software & Database Support for throughout technical staff. - Work with UNIX Scripts.- Managing Production Databases & Application Servers, Provide 15 X 7 proactive support. - Monitoring of error logs of UNIX servers, monitoring of database alert log, space allocations regularly.- Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.- Database Security, User management- Backup and recovery strategy.- Provide DBA Support to Business Analysts and Development Teams. Rectify system and software problems like software crashes, database run time errors etc.- Check and tune the performance of the SQL with appropriate Index Strategy and statistics.- Compilation of defect lists, intimating the same to vendors and monitoring the defect rectification. Show less

    • Indus Software Technologies Pvt. Ltd.

      May 2016 - Feb 2018
      Senior System Analyst

      - Worked on different project like Canara Bank, VP Bank, VW Finance Ltd, DHFL Avanse, Mahindra Rural Housing Finance Ltd.- Currently Working for DHFL Avanse , Mahindra Rural Housing Finance Ltd(MRHFL) on LMS module.- Loan Origination System to Loan Management System Data Migration Management.- As per Business Requirement comes through Business Analyst, Create the PLSQL a Database object like Procedure, Function, Package, Types. Etc as per requirement and fulfill project requirement on time..- Create business logic by creating objects, test it to development and integration environment and give release to Testing team to check more scenarios on those particular points.- Investigate issue and Fix the bug which is raised by testing team as per scenarios.- Give release on time decide by the team, deploy product to production environment and so setup as provided requirements. Do testing on production environments.- Working with SQL query, stored procedure, function, packages and backend database.- Doing necessary changes in Database and create/modify Oracle objects to fulfill business requirement. - Software & Database Support for throughout technical staff. - Provide DBA Support to Business Analysts and Development Teams. Rectify system and software problems like database run time errors etc.- Check and tune the performance of the SQL with appropriate Index Strategy and statistics.- Compilation of defect lists, intimating the same to vendors and monitoring the defect rectification. Show less

    • Accenture in India

      Feb 2018 - Apr 2021
      Application Development Team Lead

      - Worked for Vodafone UK and Deutsche Bank UK project.- Currently Working for Deutsche Bank UK on Maintain Banking Infra System.- Sourcing scattered data from different entity to one platform.- Analysis on requirement and create documents for development flow and impact analysis.- Task distribution, provide man hours on task, provide update to management, guide to team member and resolve raised query.- As per business requirement comes through Business Analyst, Create the PLSQL a Database object like Procedure, Function, Package, Types. Etc and meet the deadline discussed with client.- Do code review of developed code.- Do basic performance tuning of backend objects if daily batch job takes longer time.- Create business logic by creating objects, test it to development and integration environment and give release to Testing team to check more scenarios on those particular points.- Do maintain developed code in version control tool i.e. BitBucket and deliver it to testing team by taking build.- Help and guide team member by functional and technical logic to complete their task on time.- Investigate issue and Fix the bug which is raised by testing team as per scenarios.- Give release on time decide by the team, deploy product to production environment. Do unit testing on production environments.- Working with SQL query, stored procedure, function, packages and backend database.- Doing necessary changes in Database and create/modify Oracle objects to fulfill business requirement.- Software & Database Support for throughout technical staff. Show less

    • Oracle

      Apr 2021 - now
      Senior Software Developer
  • Licenses & Certifications

    • OCP

      ORACLE
      Feb 2013
    • OCA

      ORACLE
      Dec 2012
    • PLSQL

      ORACLE
      Oct 2012
    • SQL

      ORACLE
      Aug 2012
    • Oracle Database 10g Administrator Certified Associate - Version Retired

      Oracle
      Feb 2013
      View certificate certificate
    • Oracle Database SQL Certified Expert

      Oracle
      Jul 2012
      View certificate certificate