SANJAYKUMAR GAMIT
Mobile No : 099********
E-mail : adk56m@r.postjobfree.com
Working With : Grace and Faith Technologies LLC.
**** ***** **** *****, **********, TX 76065.
OBJECTIVE
Creating a niche for myself & establish a Long-term career in the field of IT Sector & Software Industry in order to grow professionally & Contribute to the growth of the Organization.
SUMMARY
Total 7+ years and 5+ Years experience on Oracle 11g, 12c as PL SQL developer with Linux platform.
Experience in Stored Procedure, Triggers, Views Joins and Sub Query, other database concept.
Comfortable working in Team and sharing the knowledge with teammates.
Oracle 10g Certification for PL SQL Developer.
Big Data Hadoop Developer Certification from Udemy.
Shell Scripting Certification from Udemy.
WORK EXPERIENCE
Currently working with Grace and Faith Technologies LLC, 1760 Creek Bend Drive, Midlothian, TX 76065.
Worked with NSEIT as a Associate System Analyst from 2nd January 2019 to 30th December 20.
Worked as a software Developer at Osource India Pvt. Ltd. from 5th January 2017 to 14th December 2018.
Worked as Software Engineer at NUCSOFT Ltd, Mumbai, India From 18thApril 2016 to 31st December 2016.
Worked with Institute For Advance Computer Technology as a Trainer, Tapi, India. 10th June 2013 to 31st December 2015.
Worked with Essa Al Serkal Gen. Cont. Est. as a Engineer, Abu Dhabi, UAE. From 5th May 2012 to 25th May 2013.
TECHNICAL SKILLS
Languages and Skills : Oracle PL/SQL, Core Java, Hadoop, Shell Script
Web Technologies: HTML5, CSS3. Jsp.
Database : Oracle 10g, 11g,12c,Microsoft SQL 2008.
Operating System : Windows 9X/NT/200/XP/7, Linux
Tool : Oracle SQL Developer Tool,Putty,MS Office.
PROJECT EXECUTED
Project Name
SDD –System-driven Disclosures in Securities Market.
Duration
1st January 2020 to 30th December 2020.
Designation
Associate System Analyst.
Job Description
Developing Procedure, function and designing modules in oracle and Schedule Jobs using Linux OS and shell script.
Project Details
Description: As specified in SEBI circular dated 01, 2015, the system is being implemented in phases and in first phase, the disclosures of promoter/promoter group under SEBI (Substantial Acquisition of Shares and Takeovers) regulations 2011 (hereinafter referred to as “SAST Regulations) and SEBI (Prohibitions of Insider Trading ) Regulations, 2015 (hereinafter referred to as “PIT Regulations”) are implemented in Second Phase.
SAST Regulations :
1.The various formats for sharing of data shall be standardized as agreed upon by the depositories and exchanges.
2.For the purpose of SAST Regulations, the depositories shall tag the scheduled commercial banks and public financial institutions in their systems for excluding them from disclosure requirements.
3.The depositories shall share data with each other, on a daily basis, pertaining to non promoter shareholders of a company who are holding more than 2% in the company.
4.The details of shareholding of those non-promoters whose combined shareholding is more than 5% in the company shall be provided by the depositories to the stock exchanges on a daily basis.
5.The stock exchanges shall then identify the data requiring disclosure under SAST Regulations and disseminate the same on its website in accordance with the respective regulations .
6.Any discrepancy observed by the entities must be communicated to the respective stock exchanges which may then resolve the issue in coordination with the depositories.
PIT Regulations :
1.The various formats for sharing of data shall be standardized as agreed upon by the depositories and exchanges.
2.The first step would be to build a database of the existing holdings at ISIN level of all the directors and employees of each listed company. The listed company will be required to provide to all the depositories the information about the directors and employees. The information provided by the listed company to the depositories must be authenticated and shall be provided . The information provided by the listed companies to the depositories shall be in the manner prescribed by depositories and must also include the PAN of the entity. In respect of PAN exempt entities, the account numbers shall be provided.
3.Based on the PAN/account numbers, the depositories will tag such Demat accounts in their depository system at ISIN level.
4.In case of any subsequent changes in the directors/employees of the listed company, the company shall provide the information of the changes to the depositories on an immediate basis.
5.The listed company shall select one of the depositories as a Designated Depository for the purpose of disclosure of data for that particular company. In respect of the identified directors/employees for a listed company, the Designated Depository shall aggregate its data along with the data received from the other depository for the particular company.
6.The data shall be processed by the Designated Depository and the identified data requiring disclosure in terms of PIT Regulations shall be sent to the respective stock exchanges on a daily basis for dissemination on their website.
7.Any discrepancy observed by the entities must be communicated to the respective Stock Exchanges which may then resolve the issue in coordination with the depositories.
Tools
Oracle SQL Developers Tool, Putty
Team
4 Members
Project Name
NSDL – National Securities Depository Limited.
Duration
2nd January 2019 to 30 Nov 2019.
Designation
Associate System Analyst.
Job Description
Developing Procedure, function and designing moduel in oracle and Schedule Jobs using Linux OS and shell script.
Project Details
Description: NSDL – National Securities Depository Limited.
SDD – System Driven Discloser . Migrating Oracle to Hadoop.
FILM – Foreign Investment Monitory Limit . Migrating Oracle to Hadoop.
Tools
Oracle SQL Developers Tool, Putty
Team
5 Members
Project Name
Onex ERP
Duration
5thJanuary 2017 to 14th December 2018
Designation
Software Developer.
Job Description
Development Dynamic Report Generating system, Loan Module, EMI Calculation and Daily Basis Interest .
Making Procedure, function, triggers, packages, debugging, reports and JV developing .
Project Details
Description: (Kerry Hotel Hong Kong)
Onex Payroll developed on cloud with Oracle 12 c database. With this web based cloud application all the requirement has been fulfilled for the salary process of employees and employer.
Tools
Oracle SQL Developers Tool
Team
3 Team Member Mentor forTask distribution and assigning task.
Client Communication, requirement gathering and planning.
Project Name
BRMF (Bankers Realm Micro Finance).
Duration
18th April 2016 to31st December 2016
Designation
Software Engineer.
Job Description
Creating PL-SQL procedures for several modules in the application.
Dealing with SQL queries to ensure consistent data.
Liaise with Client, Service manage on day-to-day basis (Ticketing system).
Check server related issues.
Project Details
Description: (Application-BRMF)
BRMF is a platform-independent, scalable Business Process Management engine that enables automation of organizational business processes. Built using open technologies, it has seamless integration abilities allowing it to be introduced into any IT infrastructure.
At Fullerton India, it is used for complete loan booking process.
Tools
Oracle SQL Developer Tool, MS Office.
Team
10 Members
Project Name
RRE II (Ruwais Refinery Expansion 2). Abu Dhabi, UAE
Duration
5thMay 2012 to25th May 2013
Designation
Engineer
Job Description
Dealing with SQL queries to ensure consistent data.
Generating Reports, assets management, Business service monitoring on SapphireIMS application.
Project Details
Description: (Application-SapphireIMS)
SapphireIMS Asset Management is a comprehensive Asset Lifecycle Management Solution that also includes CMDB, inventory management, compliance management and IT automation. SapphireIMS Asset Management enables you to manage IT and Non-IT Assets through their lifecycle from Procurement to Retirement
Tools
Oracle SQL Developer Tool, MS Office.
Team
5 Members
EDUCATION
Degree
School / University
Bachelor of Technology
Institute of Technoloy, Nirma University. Ahmedabad.
HSC
St. Xavier’s High School, Anand, Gujarat.
SSC
Jagruti Highschool, Mandal, Gujarat.