Developer Data

Sanjeev Kumar

Associate Consultant

Atos-Syntel Pvt Ltd

Mobile: +91-996*******

E-mail: addz5m@r.postjobfree.com

addz5m@r.postjobfree.com

Experience Summary:

Over 5.9 years of IT Experience in Database Design, Development and business intelligence of Sybase and Microsoft SQL Server 2008/2012/2017/2018 in Development, Test and Production Environments on various business domains like Financial, Insurance and manufacturing etc.

Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting Sybase as well as SQL Server 2008R2/2012/2017/2018 Database.

Expertise in SQL Query writing, T- SQL, Stored Procedure, User Defined Function, Cursors, Views, Triggers, Optimized Query, Index and performance Tuning in database.

Work as Admin like space management, server maintenance,configuration management, security, login management, Permission assignment, Database Security, Database creation, Device Management, Segments, Monitoring the database, Table Partitioning, Reorg tables,recompile procedure,Table and indexes update statistics,Backup and Restore, BCP, Patch Updating, Version Upgrade of the Sybase as well SQL Server.

Excellent Experience On Database Migration (Sybase To SQL Server ) using SSMA Tool .

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB and ODBC connection from heterogeneous sources like (Excel, CSV, Sql Server, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Experience in Data Conversion and Data Migration using SSIS packages across different databases like sql server, Sybase, MS access and flat files.

Experience in Performance Tuning and Query Optimization.

Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Award And Achievements:

Got Spot Recognition award in this company for creating the scripts to rectify the issue on Priority in 2019.

Got Spot Recognition award in this company for developing new company creation scripts with zero defects in 2019.

Got Certificate of Appreciation for Excellent Implementation of Kaizen last year (Feb 2018).

Got good work award for performing excellent quality of work last year (February 2017).

IT Skills:

Domain Knowledge : Sql Server,Sybase ASE,T-SQL,Data Modelling, Unix Shell Scripting, SSIS,SSRS,Database Migration VB.NET,Asp.net, Crystal Report

Tools : MS Management Studio, Eclipse,WinSQL,SSMA, Sybase Central, SAP Power Design,Visual Studio Source safe, TFS(Team Foundation System)

Database : MS SQL Server(2017/2012/2008/2005), Sybase ASE 16/15.7/12

Operating System : Unix, Linux, Windows OS(10/7)

Education Qualification:

Master of Computer Application from Pune University with 64.48% in 2013

Bachelor of Science in Information Technology (BscIT) from Sikkim Manipal University with 75 % in 2010

HSC from Bihar School Examination Board with 48 % in 2007

SSC from Bihar School Examination Board with 64.89 % in 2005

Professional Summary:

Current Employer : Atos-Syntel Pvt Ltd .

Joining Date : 19 Nov 2018 – Till Date

Designation : Associate Consultant

installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting.

Expertise in SQL Query writing, T- SQL, Stored Procedure, User Defined Function, Cursors, Views, Triggers, Optimized Query, Index and performance Tuning in database.

Works as Admin like space management, server maintenance,configuration management, security, login management, Permission assignment, Database Security, Database creation, Device Management, Segments, Monitoring the database, Table Partitioning, Reorg tables,recompile procedure,Table and indexes update statistics,Backup and Restore, BCP, Patch Updating, Version Upgrade of the Sybase as well SQL Server.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB and ODBC connection from heterogeneous sources like (Excel, CSV, Sql Server, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Working on performance tuning and optimization .

Previous Employer : EagleBurgmann India Pvt Ltd

Joining Date : 5 May 2014 – 22 Aug 2018

Designation : Sr. Software Engineer

Installation of Database Server whenever needed.

Maintain Backup and Recovery of Database.

Working as DBA like login management, Permission assignment, Database creation, Device Management, Segments, Monitoring the database, Table Partitioning, Backup and Restore, BCP, Patch Updating, Version Upgrade of the Sybase.

Expertise in SQL Query writing, T- SQL, Stored Procedure, User Defined Function, Cursors, Views, Triggers, Optimized Query, Index and performance Tuning in Sybase ASE database.

Project Details:

Syntel Private Limited Nov 2018 To Till Date

Project ID

Project Name

Customer

/Client Name

Team Size

Designation

Role

Technologies

/Skills Used

99591

Managed Services

Randall and Quilter Inv

10

Associate Consultant

ISIS Support

Sybase,Sql Server,Unix,SSIS,SSRS

Responsibilities

Database Support,Development, Migration and Report in Sybase and SQL Server database

Description

Randall and Quilter Inv is an insurance organization where end user can claim, ledger, deposit premium etc .

EagleBurgmann, India May 2014 to 22 Aug 2018

Project Name Automatic Machine Loading Prize winning Project in Japan ***)

Role : Database Developer

Technologies Used: Front End : VB.Net 4.0, Crystal Reports

Back End : Sql Server 2012

Description : This is used to increase the performance of work and utilise the machine. When cutting slip is released (requirement is generated), automatic cell No is assign according to criteria. It is also used to track the machine work. It is also used to control the machine load.

Analysed user requirements and designed functional specifications for applications.

Develop and implement Sybase stored procedures, Index and crystal reports for analysing.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers.

Also modified, maintained and optimized existing Sybase ASE 16 database.

Project Name : POSI - Purchase Order Sales Invoice

Role : Database Developer

Technologies Used : Front End : VB.Net 4.0, Crystal Reports

Back End : Sybase 16

Description : This is used to generate all sales and purchase product invoices

It manages all types of billing of incoming as well as outgoing Materials and products.

Analyzed user requirements and designed functional specifications for database applications.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers.

Also created, modified, maintained and optimized Sybase ASE 16 database.

Modified programs to ensure correct data transfer and communications between Sybase database and SAP system.

Project Name : Engineering – Data Bank and RND Planner & Auto Reports

Role : Database Developer

Technologies Used : Front End : VB.Net 4.0, Crystal Reports

Back End : Sybase 15.7

Description : This is used to design and manage the seal products.

Developed auto reports for users by mail scheduled on daily basis.

Analysed user requirements and designed functional specifications for database applications.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers.

Also modified, maintained and optimized existing Sybase ASE 15.7 database.

Maintained the documents and create reports for the business analysts and end-users.

Modified programs to ensure correct data transfer and communications between Sybase database

Project Name : Import Export

Role : Database Developer

Technologies Used : Front End : VB.Net 4.0, Crystal Reports

Back End : Sql Server 2012

Description : This is used to manage to export product from India to others country. It manages all information like pre-shipping, Post-shipping, banking transaction, Banking terms and condition, customer details.

Analyzed user requirements and designed functional specifications for database applications.

Responsible for the designing the advance SQL queries, procedure, cursor, triggers.

Also created, modified, maintained and optimized Sybase ASE 15.7 database.

Maintained the documents and create crystal reports for the business analysts and end-users.

Project Name : MRPII – Manufacturing Resource Planning 2

Role : Sybase Developer

Technologies Used : Front End : VB.Net 4.0, Crystal Reports

Back End : Sybase 15.7

Description : This project is an ERP for a manufacturing company EagleBurgmann. MRP2

Consists of various modules like Assembly, Production, Planning, Purchase, QA, Maintenance, and Engineering.

Store and Simulation as a core process for batch scheduling.

Requirement gathering from Users, analysing them and prepare database structure.

Major activities include performance tuning, database design, maintenance for Assembly module.

Set up and maintain database environments to support production, QA and development activities.

To work on production environment to handle user queries and to resolve them.

Designed and implemented tables, functions, stored procedures and triggers for Vapi module.

Identifying issues with current database and resolving them.

Project Name : TS3 – Tracker for Seal Support System

Role : Sybase Developer

Technologies Used: Front End : VB.Net 4.0, Crystal Reports

Back End : Sybase 15.7

Description : Engineering department uses this project for tracking the process of Seal

from the time it is ordered till it is manufactured & delivered to Customers.

Responsible for logical and physical design towards application and database tuning.

Developed Task Assignment to users for bill of material of Sales Order.

Provided and supported the development and on-going support of data warehouse, reporting systems and services.

Project Name : IBS (Integrated Business Solutions)

Role : Database Developer

Technologies Used : Front End : VB.Net 4.0, Crystal Reports

Back End : SQL SERVER 2008

Description : It is a web based project .This project helps to integrate the business.

It is used to take order from client, maintain client record and see

about products, customers.

Responsible for logical and physical design towards application and database tuning.

Developed Task Assignment to users for bill of material of Sales Order.

Provided and supported the development and on-going support of data warehouse, reporting systems and services

Personal Details:

Name : Sanjeev Kumar

Address : Shakul Apartment, Azad Nagar

Kothrud, Pune

Date of Birth : 05 Jan 1989

Sex : Male

Languages : English, Hindi

Nationality : Indian

Hobbies : Cooking/Listening Music

Declaration :

I hereby declare that the information given above is true to the best of my knowledge & belief.

Date: Signature

Place: Pune sanjeevkumar

Contact this candidate