• Gender: Male
• Age: 35
• Designation: Database Developer
• Highest Education Level: Masters - Degree
• Notice Period: 30  Days
• Preferred Location: Dhule
• Work Experience: 9.8 Year(s)

Education

M.Sc.(Computer) from D.N.C.V.P. College, Jalgaon with B Grade in 2014
B.Sc.(Computer) from S.V.S’s College, Dondaicha with 74% in 2011
H.S.C. from Nutan Jr. Science College, Dondaicha with 68.50% in 2008

Skill Sets

Technical Skills:
Tools: SQL Server 2016,SQL Server 2012, MS SQL Data Tools Domains: BFSI
Languages: MSSQL,SSIS
Database: SQL Server 2016 ,SQL Server 2012
Operating Systems: Windows 2008, Win8 etc.
MS-Suite: MS-Office.

Personal Qualities
Strong logical and managerial skills.
Ability to produce the best result in pressure situations.

Work Experience

Database Developer
From 12 Dec 2018 to Till date
Company profile- Microsoft and has developed expertise in providing solutions using Azure, BizTalk and SharePoint

Project # 1
Title: PFMS Phase I (Account Validation)
Client: IDFC,RBL, Jammu and Kashmir,PBGB,Kotak Mahindra Bank's.
Technologies: SQL, SSIS, ASP.NET
Used Tools: SQL server 2012, oracle client, VS 2010, SQL server Data Tools 2010
Role: Database Developer
Description:
The Account validation process is specially design for validating the Bank Account Details which information coming from government Agency i.e. from PFMS.Daily Reporting with corresponding Accounts with Response file Generation and same send to PFMS. This is a middleware application between bank and PFMS.
Responsibilities:
Understanding business requirements.
Create a Database using SQL server.
Creation of tables, procedures, functions, triggers, views.
Daily backup of Database.
Jobs creation and scheduling.
Development and Deployment of SSIS packages.
Project # 2
Title: PFMS (Phase II-III Payment Processing) Client: HDFC, Jammu and Kashmir, RBL, PBGB,IDFC,Kotak Mahindra
Technologies : SQL, SSIS, ASP.NET
Used Tools : SQL server 2012,oracle client, VS 2010, SQL server Data Tools 2010
Role : Database Developer

Description:
Its a payment Gateway Specially Developed for Banks To manage, monitor the government Schemes. The Product Provide the Automated System to distribute the money using NEFT, Transfer and APBS government funds for beneficiaries. Provide efficient functionality to tracking those Transactions. The software having the capability to making Payment Activities, Daily Reporting to Government.
Features: maker and checker functionality provided for maintaining the security of transactions. Report generation facility provided to bank for monitor the Transactions on daily basis, system capable to make transaction using digital signature which is more secured and Reducing the time and resource for maker & checker process.
Roles & Responsibilities:
Understanding business requirements.
Create a Database using SQL server.
Creation of tables, procedures, functions, triggers, views.
Daily backup of Database.
Jobs creation and scheduling.
Development and Deployment of SSIS packages.

Project # 3
Title: FCRA Reporting
Client: HDFC, YES Bank's
Technologies: SQL, SSIS, C#
Used Tools: SQL server 2016, oracle client, VS 2010, SQL server Data Tools 2010
Role: Database Developer
Description:
FCRA module specially developed for transaction reporting of various governments Authorized Institution to Central Government, the main motto of is to track all financial movements of institutions to Avoid the Fraud.
Responsibilities:
Understanding business requirements.
Create a Database using SQL server.
Creation of tables, procedures, functions, triggers, views.
Daily backup of Database.
Jobs creation and scheduling.
Development and Deployment of SSIS packages.

SQL DB Developer
From 3 Jan 2018 to 11 Dec 2018

Project
Project Title : Pocket HCM.
Role : SQL DB Developer
Tools : VS2013,Sql2014
Environment : ASP.NET,C#, SQL 2014
Team Size : 10

Description: - Pocket HCM is an End-to-End HR management solution with detailed modules to
Assist from key HR processes ranging from ‘Hire to Retire’.

Feature of pocket HCM:
Leave Management System
Time tracking software
Employee management System
Attendance management System
Employee Self Service
Recruitment Management
Appraisal


Previous Organization:
Company : Arc and Fusion E-Technology Pvt. Ltd.
Employment Period : 3 July 2017 to 30 December 2017
Project
Project Title : School Management System.
Role : Software Developer
Tools : VS2012,Sql2012, rdlc Report, Entity Framework
Team Size : 6
Description: - School Management system this project we are developed in multiple module Administrator, Finance Management, Staff Management, Inventory and Vender, School Event’s and Time table, Transport Management.

Previous Organization:
Company : Invoking Minds Pvt. Ltd
Employment Period : June 2016 to 30 June 2017

Project #1
Project Title : TMS (Transport Management System).
Role : Software Developer
Tools : VS2010,Sql2012, Crystal Report,Ado.net
Client: - Multiple clients (Bhavani Shipping Belapur, Jai Bharat Roadways, Caliber Shipping, VA Enterprises etc.)
Description: -
A Transportation Management System (TMS) is a software application designed to manage and optimize inbound and/or outbound transportation operations.
A TMS is an integral component of a mission-critical supply chain execution (SCE) suite of applications. It contain different module like LR/Hire Entry, LR billing, full Accounts (Receipt, Payment etc.). We can get outstanding report, Ledger report and Bank book from this software.
In-House Project #2
Role: .Net Developer
Tools: VS2010, Sql2008R2, asp.net, C#, Crystal Report, HTML, CSS, JavaScript
Team Size: - 3
Client: - Invoking Minds Pvt Ltd.
Description:- An In-House project, where all the Employees who have joined, left, retired or have refused job options of this company are stored. Company Client details for bill generation. Sales visit details, client visit details, client support details. Employee salary generation etc.

Roles & Responsibilities: -
Collected User Requirements by participating in meetings and studying existing systems.
Designed the front end and back end using ASP.Net and DataBase connectivity
Created database object like tables, views, store procedure, function, and triggers.
wrote complex SQL queries using joins, sub queries to retrieve data from database
Create Crystal Report and Excel report
Ability to guiding trainees and juniors in work related matters
Industrial Training & Project
Organization : CMC Ltd TCS Enterprises, Pune
Project : Life Insurance Site
Designation : Software Developer
Technology used : C#, Asp.Net (3.5) and SQL server 2008
Duration : 6 months

Competency Overview
Total 5+ Year Experience in MS SQL Server 2016 and 2012 for database development.
Around 2.5+ Year Experience in SSIS
Experience in Writing Stored Procedures, functions, Triggers, views.
Experience in Backup & Restore SQL Server Database, Job Creation.
Good knowledge in Software Development Life Cycle (SDLC) and Database designing.
Skilled in understanding Software Requirement Specification and identifying the all possible Scenarios.
Good knowledge on BFSI domain
Team player with Good communication and inter personal skills