CV_Shubham Bansal
-
Upload
shubham-bansal -
Category
Documents
-
view
137 -
download
2
Transcript of CV_Shubham Bansal
Shubham Bansal Analyst ProgrammerContact: +91-9716170821, 8097867273Email:[email protected], Haryana
Presently associated with Fidelity Investments as an Analyst Programmer.
Career Objective
To work in a creative and challenging environment where I can constantly learn new technologies and enhance my skills according to the latest trends and be part of a dynamic team that contributes to the growth of the organisation.
Organisational Scan
S.No. Company Date Of Joining Date Of Leaving Position 1. Fidelity Investments 15-05-2015 Till Date Analyst
Programmer 2. NIIT Technologies Limited 11-10-2010 05-05-2015 Senior Software
Engineer
Experience Summary
Senior Software Engineer, Oct 2010-Present 6.1 years of professional experience in IT industry. Around 4 years of expertise as a T-SQL Developer/Analyst in areas of Software support,
development,testing and maintenance of client/server technologies. Incorporated business rules and constraints and created new tables for different modules. Worked on Procedures, Functions, Cursors, Indexes and modified existing codes, tables, views
etc. using T-SQL in Windows environment. Database Backup and Restore. Proficient level key skills in SQL 2005/2008. Learned ITIL process for Incident management and Problem Management for software support. Demonstrated ability to work well with attention to detail and follow-through; process oriented. Adopt in end-to-end development from requirement analysis,designing, testing, documentation
and implementation with cross-cultural teams. A skilled communicator with strong interpersonal & relationship management skills.
Technical Expertise:
Languages : T-SQL,MSSQL,DelphiTools : SSIS, SSMS, SSRS, SQL Profiler, SQL Monitor.Operating System : Windows XP, Windows 7Database : MS-SQL Server 2005/2008/2008 R2, Sybase, Oracle Version Tools : VSS (Visual Source Safe), MKSI, TFS, SVNPlatforms : Windows 2003 Server, 2008 Server
Projects Undertaken:
1. AutoRek - Client Money Project
Client : Fidelity Investment Limited Team Size : 06 Duration : May 2015 – Present Role : Analyst ProgrammerTechnologies : Microsoft SQL Server, T-SQL
Description : Autorek is a reconciliation tool that help firms know & understand their data, and report completely and accurately on their data. It is used for Automating the cash application process & complying with financial legislation including client money and FATCA etc.
Responsibilities: Review and verification of Stored Procedures. Worked on Incident tickets requested by the users. Involved in support & maintenance of the application. Day to day activities include HC & monitoring the schedule run. Optimizing of slow running queries.
2. Cox and Kings(Mumbai) – CnK is a tour & travel company which provides customer facility to book tours through their application.
Involved in DB support and maintenance of T-Sql scripts at Client Side.
3. Tenix IMES System
Client : Tenix SolutionsTeam Size : 06Duration : June 2013 – Sep 2014Role : Senior Software EngineerTechnologies : Microsoft SQL Server 2008R2,Visual Studio
Description: The system is based on ASP.NET, Workflow tool, Visual Studio 2010 and SQL server. Infringement Management and Enforcement Services (IMES) is a business unit of the Department of Justice primarily responsible for managing the end-to- end infringements system in Victoria, Australia. Its core functionality covers delivering and monitoring the road safety camera program, enforcement of unpaid infringement penalties through the Infringements Court and enforcement of warrants by Sheriff Officers,issued by Magistrates,Country & Supreme courts.
Responsibilities: Review and verification of Stored Procedures.
Worked on Database Change Request in DB Project of visual studio 2010.
Master Data Management by Post deployment SQL scripts.
Database deployment in different testing environments.
Performance Tuning of slow running queries.
4. SUBSCRIBE
Client : Hardy/Atrium/XL/Montpelier Underwriters Ltd. – UK Team Size : 06Duration : October 2010– May 2013Role : Software Engineer
Technologies : Delphi, Microsoft SQL Server 2005/2008,Sybase, TSQL,SSIS
Description: Commercial Insurance Policy Administration and Management software. Subscribe is a modular, multi-currency insurance and reinsurance policy administration platform designed to support the full lifecycle of policies and associated reinsurance. The solution includes comprehensive audit and compliance functionality & the loss manager and EDI modules to facilitate an end-to-end business process. This application has Underwriting, Claims, Reinsurance and compliance modules developed in Delphi/MSSQL/Sybase.
Responsibilities: Analyze the Operational Problem areas and implement transformation logic & business rules
effectively to resolve the queries raised by client. Identify data issues and provide recommendations for resolution to ensure optimal
performance. Implement/ Incorporate business rules and logic through SQL Scripts, Stored Procedures and
Packages etc. using T-SQL on SQL Server environment. Build and maintain SQL scripts, indexes and complex queries for data analysis and extraction. Create SQL scripts as data fixes for addressing change requests and bug fixes. Provide database coding to support business applications using T-SQL. Modify/Debug the SQL stored procedures and releasing these changes as a patch on
database. Involved in QA Defect fixes and enhancements.
Trainings Attended:
Uplift your Customer Service training from NIIT Technologies. Software Configuration and Management training. Microsoft Business Intelligence Training with NIIT Technologies. Software Review Testing training with NIIT. Effective Communication training with NIIT Technologies.
Academic Qualifications:
2010 B.Tech (Computer Science) from Guru Gobind Singh Indraprastha University, Delhi with 74% of marks.
2004 Intermediate from Central Board of Secondary Education with above 60% of marks.2002 HighSchool from Central Board of Secondary Education with above 60% of marks.
Personal Details:
Date of Birth : 23rd October 1985Languages Known : English, HindiCurrent Address : H.No.1594,Sec- 4,Gurgaon, India
I certify that the above information is correct and complete to the best of my knowledge.
Shubham Bansal
**Professional References are available on request.