Abhishek Singh

 OBJECTIVE: To employ my knowledge, skills and experience with the intention of securing a professional and challenging career, while gaining knowledge of new skills and expertise. Professional Summary: 6 years professional working experience in MSSQL, MS EXCEL. Functional Knowledge on Ramco ERP (SCMDB). Responsible for entire delivery of SCMDB support and Projects onsite. To Manage Implementation of Ramco solution for the customer, reporting to their Key Stakeholders. Provided solutions for functional & data related issues not directly handled by system. Manage the full cycle of on-site implementation like System study, Preparation of Project schedule, Master Data Collection Data Migration/Porting, Contract Management, Inventory Management etc. Defining the scope, interacting with the users for their requirements, analyzing the gaps in existing app, getting the additional requirements incorporated, testing on UAT, user training and implementation on production. Integration with production ERP (Ramco) for showcasing the case and financial data Integration. Preparation of Project schedule, Master Data Collection, Data Migration/Porting, Inventory Management, etc. Report creation based on SQL queries as per the user requirement. Executive-IT at Securitas India July 2015 – Till Now Job Summary: Major role includes implementing ERP (SCMDB) Projects, SQL based report development, process planning, solution designing, data management, application testing, training & Support. Create new stored procedures and writing query view, create new tables, Making join and creating triggers on tables. Experience: 1. RAMCO ERP Re-Engineering Defining the scope, interacting with the users for their requirements, analyzing the gaps in existing structure, incorporating the cluster concept, BMR finalization, testing on UAT, user training and implementation on production. 2. SQL Server SQL Scripting, using Microsoft SQL Server Management Studio 2008 R2, to research, update, add, or delete information for records within tables using SELECT, UPDATE, INSERT, or DELETE statements with JOIN, WHERE, GROUP BY, and ORDER BY clauses. Extensively using joints and sub-queries for complex queries which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements. TECHNOLOGY WORKED ON: Computer Systems Programming language skills Other skills Microsoft Windows (XP, 7, 8, 10), Android SQL Server, HTML, CSS MS EXCEL, MS WORD, MS POWERPOINT, PDF TO WORD, PHOTOSHOP, TYPING SPEED 60 WPM. ACADEMIC PROFILE: Degree / Year Board / Institute CGPA / Percentage Major Bachelor of Technology- Vivekanand Institute of Technology & Science, Ghaziabad 66% Computer Science & Engineering VBDM Gandhi Inter College, Bahraich 2010 VBDM Gandhi Inter College, Bahraich, Uttar Pradesh 63% Physics, Chemistry, Mathematics VBDM Gandhi Inter College, Bahraich 2011 VBDM Gandhi Inter College, Bahraich, Uttar Pradesh 61% N/A Personal Details: Date of Birth: 14th July 1991 Gender: Male Languages Known: English, Hindi