Summary
Overview
Work History
Education
Skills
Personal Information
Languages
Disclaimer
Languages
Timeline
Generic

MANISH NIGAM

Summary

A result oriented professional with 6.2 years of experience in full life cycle of SQL Development and maintenance with large customers. Proficient at performing data analysis and providing customer / end user oriented solutions which are easily maintainable. Extensively experienced at MS SQL, PLSQL, MySQL,T-SQL, PostgeSQL, SSIS designing and development. Creating tables, synonyms, views, sequences, constraints, indexes, etc. Writing and tuning complex SQL queries, sub queries. Writing stored procedures, functions and Triggers. Load the data from MS Excel / CSV / TXT to Oracle table using SQL Loader. Extracting the data from MS SQL table to MS Excel / CSV / TXT files using UTL file Good experience in TradeEdge ETL Tool, SSIS. Well organized with a track record that demonstrates self-motivation, creativity & initiative to achieve personal & corporate goals. Design, develop, and optimize database solutions using SQL Server and other relevant technologies. Collaborate with software engineers to integrate database solutions architecture. Develop and maintain data models, schemas, and database objects to support application requirements. Implement data migration, transformation, and synchronization processes as needed. Monitor and optimize database performance, ensuring high availability and scalability. Troubleshoot database issues and perform root cause analysis. Implement and maintain database security measures to protect sensitive data. Mentor junior team members and provide technical guidance as needed. Analyse and track database requirements and tasks. Strong communication and collaboration abilities.

Overview

8
8
years of professional experience

Work History

Technology Lead

Infosys Limited/Edgeverve
09.2022 - 01.2024
  • Followed TradeEdge Process model
  • Prepared and updated module specifications as per customer requirement
  • Development of new functionality and enhancement of existing functionality as per design specifications
  • Prepared SSIS ETL scripting for input files using SQL
  • Prepared requirement gathering document by communicating with customer
  • Provided Level 1 to Level 3 support to customer
  • Transform Client Data using Stored Procedure and function
  • Involved in activities related to important extracts for customer
  • Develop, design, and administer database functionalities using T-SQL
  • Design, develop, and optimize database solutions using SQL Server and other relevant technologies
  • Actively monitor databases to troubleshoot production issues and identify optimization opportunities
  • Independently analyze, solve, and correct issues in real-time, providing end-to-end problem resolution
  • Troubleshoot database issues and perform root cause analysis
  • Refine and automate regular processes, track issues, and write documentation
  • Interact with customers and participate in business and system requirements sessions.

Enterprise integration Engineer

Acidaes Solution Pvt Ltd.
02.2020 - 09.2022
  • Development BFSI module with BANK and Insurance Company
  • Prepared and updated design specifications as per customer requirement
  • Development of new functionality and enhancement of existing functionality as per design specifications
  • Prepared requirement gathering document by communicating with customer
  • Patch deployment Activities
  • Follow SSIS tool to Transform and Integrate data
  • Involved in activities related to important extracts for customer
  • Handling group of three subordinates
  • Overshadowing their tasks and challenges
  • Involved and helping in functional configurations along with technical configurations
  • Involved and understanding integrations with third system with the help of product feature
  • Provide database support for critical business operations and resolve reported issues within SLAs
  • Actively monitor databases to troubleshoot production issues and identify optimization opportunities
  • Review pull requests and optimize SQL code submitted by developers.

Engineer

Surework Infotech Pvt Ltd.
03.2016 - 02.2018
  • Implementing and development MS SQL,MySQL, and ASP.net
  • Active directory and related services
  • Understanding the knowledge of Backup and Restore tools MS Platform Operating
  • Data Center Visit for maintenance
  • Ticket resolution process and provide quality Level 1 support.

Education

Master Of Computer Application - COMPUTER APPLICATION

Maulana Azad National Institute Of Technology
BHOPAL
01.2015

Bachelor of Computer Applications - COMPUTER APPLICATION

Chhatrapati Shahu Ji Maharaj University
Kanpur, UP
07-2012

Skills

  • MS SQL
  • T-SQL
  • PL/SQL
  • MySQL
  • PostgeSQL
  • SSIS
  • Oracle
  • SQL Loader
  • MS-Word
  • MS-Excel
  • Oracle PL/SQL Developer

Personal Information

  • Date of Birth: 07/08/1990
  • Nationality: Indian
  • Marital Status: Married

Languages

  • English
  • Hindi

Disclaimer

I hereby declare that the above mentioned information is correct and true, to the best of my knowledge and belief.

Languages

Hindi
First Language
English
Upper Intermediate (B2)
B2

Timeline

Technology Lead

Infosys Limited/Edgeverve
09.2022 - 01.2024

Enterprise integration Engineer

Acidaes Solution Pvt Ltd.
02.2020 - 09.2022

Engineer

Surework Infotech Pvt Ltd.
03.2016 - 02.2018

Master Of Computer Application - COMPUTER APPLICATION

Maulana Azad National Institute Of Technology

Bachelor of Computer Applications - COMPUTER APPLICATION

Chhatrapati Shahu Ji Maharaj University
MANISH NIGAM