Harshkumar Satapara

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