About Dipanshu Mittal
Dipanshu Mittal works as Sr. Associate – IT Ops Services at NIIT Technologies Ltd. and is based in Delhi, India. Dipanshu studied Master in Computer Application at Shyam Lal College (2009-2012). On Youth4work, Dipanshu has taken skill tests in SQL Server (rank 653 of 52,571, top 2%), Communication Skills (rank 6,774 of 375,956, top 2%) and MySql (rank 894 of 71,796, top 2%). Dipanshu also lists talents in Database Developer, Database Analysis, Database Administration and Visual Basic.
Talents
-
SQL Server... among ... users in Delhi653among 52571 users worldwide67.99percentile among worldwide users -
Visual Basic... among ... users in Delhi…among … users worldwide -
Database Administration... among ... users in Delhi…among … users worldwide -
Database Analysis... among ... users in Delhi…among … users worldwide
Professional Path
Sr. Associate – IT Ops Services
NIIT Technologies Ltd.
Full Time
May-2018 To
present
8 years 4 months
- -> Resolving Production issue by providing support. -> Smooth running of Product. -> Mange New Release of product & Build Deployment in Production. -> Application Hosting on IIS & manage its issue. -> Windows Patch management using Heat agent. -> Coordination with Development for issue resolution. -> Coordination with Business for getting Final sign-off on Build release in Production. -> Work on incident, change request, defects, and resolved it within a define SLA. -> Create incident Ticket of issue and take full ownership of the issue if require also coordinate with seniors, developers, and other departments. Respond to incidents raised by calls, email, Instant Message or through dedicated customer support portal
Lead - Tech. Operations
RateGain Travel Technologies Pvt. Ltd.
Full Time
May-2017 To
Apr-2018
11 months
- -> Resolving Production issue by providing 24X7 support (on call after business hours). -> Smooth running of Product. -> Mange New Release of product & Build Deployment in Production. -> Develop custom scripts for Nagios Monitoring Tool according to Business Requirement in T-Sql for managing production. -> Develop various management reports as per requirement in T-sql for pulling data from different tables. -> Debugging the T-Sql code for fixing issues in database. -> Involved in maintaining database tables, structure of database. -> Performance Tuning of Sql queries & T-sql. -> Develop new stored procedures, functions & triggers according to business need and resolving issue. -> Database Analysis & Regular Backup of Database. -> Currently handling a team of 5 people.
Lead - Tech. Operations
RateGain Travel Technologies Pvt. Ltd.
Full Time
Oct-2013 To
May-2017
3 years 7 months
- -> Resolving Production issue by providing 24X7 support (on call after business hours). -> Smooth running of Product. -> Mange New Release of product & Build Deployment in Production. -> Develop custom scripts for Nagios Monitoring Tool according to Business Requirement in T-Sql for managing production. -> Develop various management reports as per requirement in T-sql for pulling data from different tables. -> Debugging the T-Sql code for fixing issues in database. -> Involved in maintaining database tables, structure of database. -> Performance Tuning of Sql queries & T-sql. -> Develop new stored procedures, functions & triggers according to business need and resolving issue. -> Database Analysis & Regular Backup of Database. -> Currently handling a team of 5 people.
- Joined this Company as Sr. Operations Engineer and get promoted to Lead- Tech. Operations in Just 18 Months
Jr. System Analyst / Asstt. Programmer
Delhi State Cancer Institute
Part Time
May-2013 To
Oct-2013
5 months
- -> Smooth running of hospital -> Involved in maintaining database tables, structure of database -> Regular Backup of Database
Software Developer
TLC Relationship Management Pvt. Ltd.
Full Time
Jun-2011 To
Feb-2013
1 years 8 months
- -> Database Analysis -> Creating New Reports (writing Stored Procedure and Designing using Crystal Report 8.5) -> Designing of database -> Patch Work on their in House Loyalty Software (Frontend:- V6.0 & Backend:-Sql Server) -> Data Migration from Text, Excel, Ms-Access, Sql Server, Oracle & My Sql. -> Handled Technical Support on their Loyalty Software (CRM ERP) -> Handled 52 Programs currently (All Programs are standalone).
SQL Data Analyst & Asstt. Programmer
Jan-2010 To
May-2011
1 years 4 months
- -> Data Collection, evaluation -> Generation of Reports (MIS) -> Provide Data to UIDAI (for making of Card for Homeless Person in Delhi) -> Regular Backing up of database -> Designing of database -> Developed 3 Software for Data Entry for Data Collection (Frontend – Vb6.0 & Backend – Sql Server). -> Developed Software name Khoj for searching people (Frontend:- Vb6.0 & Backend:-Ms-Access). -> Data Migrated to Text, Excel, Ms-Access, Sql Server & My Sql as per requirement by the department.
Qualifications
Shyam Lal College
Master in Computer Application Computer Application
2009-2012
61%
Shyam Lal College
Bachelor of Computer Application Computer Application
2005-2008
My Story
To be a part of a growing organization which can provide me the responsibilities to design best deliverables relevant to my skills and experience, along with an overall growth in career.
Contact details are visible to employers.
Log in or sign up as an employer
Other people named Dipanshu
- Dipanshu Kandari, Delhi
- Dipanshu Kumar Gupta, Bhopal
- Dipanshu Gupta, Delhi
- Dipanshu Tayal, Ghaziabad
- Dipanshu Pandey, kurukshetra
- Dipanshu Singla, Bathinda
- Dipanshu Anand, Hyderabad
- Dipanshu Aggarwal, Noida
