Resume

Sign in

Sql Server Maintenance

Location:
Bengaluru, KA, 560001, India
Posted:
April 14, 2016

Contact this candidate

Resume:

ABHAS JAIN

Flat No - ***, Mobile : +91-998*******

GCN White Palm, E-Mail : acucz2@r.postjobfree.com

Ramagondanahalli Borewell Road, acucz2@r.postjobfree.com

Bangalore – 560066 DOB : 30 August 1981

OBJECTIVE:

To cultivate an enriched career in the IT industry by devoting me to a continuous learning process and to look for challenging jobs.

EMPLOYMENT PROFILE:

An IT professional with over 10 years of experience in Database Design, Development and Integration support. Extensive exposure in end-to-end development of software products from requirement analysis to System study, Project Management, System integration, documentation and implementation. Demonstrated abilities in leading and building teams with technical competence and growth initiatives.

Experience in multiple databases like Sybase, SQL Server versions 2000, 2005 2008 and 2012.

Hands on experience on different BI tools like Logi Analytics, Power BI and MSBI

Extensive exposure to scrum methodology.

Expertise in SQL Development – writing stored procedures, cursors, queries, views, triggers and other database objects.

Introduced tactical advancements and performance improvement in Query Optimization using SQL Server Profiler & Execution Plan.

Extensive experience in TSQL programming, Database Design, Development, Business Intelligence and Data Warehousing.

Worked on different SQL Server tools like SSIS, SSRS, SSAS, and DTS Packages.

Having good knowledge on SQL Server Azure.

Exposure to other Reporting tools like Seagate Crystal Reports and Proclarity.

Onsite experience in Data Migration.

Attended onsite training in Logi Analytics.

Exposure to Netezza Performance Server as well.

Microsoft Certified Technology Specialist. Cleared MCTS 70-445 (Microsoft SQL Server 2005 Business Intelligence – Development and Maintenance).

CURRENT & PREVIOUS EMPLOYERS:

Symphony Teleca, Bangalore as Database Architect (Since Jul’15)

J. P. Morgan, Bangalore as an Associate (Aug’13 to Jun’15)

Symphony Teleca, Bangalore as Technical Lead – Product Development (Feb’11 to July’13)

ITC Infotech India Ltd., Bangalore as Associate IT Consultant (May’08 to Feb’11)

BlueStar Infotech Ltd., Mumbai as Software Engineer (Aug’07 to Apr’08)

Deloitte Touche Tohmatsu India Pvt. Ltd., Mumbai as Executive – Central Support Team (Jan’07 to Aug’07)

JetAir Pvt. Ltd., Mumbai as Engineer – Software Applications (Feb’05 to Jan’07)

TECHNICAL SKILL SET:

Database: SQL Server 2000/ 2005/ 2008/2012, 1010, Netezza, Oracle, Azure

BI Tools: MSBI, Logi Analytics, Power BI

Reporting Tools: Seagate Crystal Reports, Proclarity.

EDUCATION:

2000-2004: B.Tech in Information Technology, UPTU, Lucknow, India (First Division: 73%)

1998-1999: HSC, CBSE (72%)

1996-1997: SSC, CBSE (76%)

PROJECT DETAILS:

Symphony Teleca, Bangalore

Backend: SQL Server, 1010, Netezza

Frontend: Logi analytics

Team Size: 5

Summary: Logi Analytics is an analytical tool used to create visualization and other reports. Basically it will give user more readability and understandability in different forms of representation. .

Responsibilities:

Develop stored procedures, SQL queries in optimized way

Connect all database objects to Logi and create reports and expected.

Exposure to Agile Scrum methodology – Daily Scrums, Sprint Planning etc.

Designed and implemented complex database architecture.

Closely working with Business Analysts to gather and analyze the requirements

J. P. Morgan, Bangalore

Backend: Sybase 12.5

Frontend: Java

Team Size: 5

Summary: Wealth Management (WM) Workstation provides a common web portal for accessing various functions with the goal of providing a holistic trading application interface for all front-office users, such as investors and investor specialists. The trading functionality within Workstation is also commonly referred to as Global Strategic Trading Platform (GSTP),supported for Investment Management (IM) and SDI trading include mutual funds, exchange traded funds, equities, fixed income, hedge funds, structured and foreign exchange products.

Cross Border Marketing and Funds Regulatory is part of Product Distribution Regulatory which in turn is a part of GSTP WorkStation where the regulatory demands imposed by various regulators in EMEA are implemented. This application does the marketing, risk assessment and documentation of the products delivered to the client through trading.

Responsibilities:

Exposure to Agile Scrum methodology – Daily Scrums, Sprint Planning etc.

Designed and implemented complex database architecture.

Closely working with Business Analysts to gather and analyze the requirements

Symphony Teleca, Bangalore

(A) EYC

Backend: SQL Server 2008, Netezza

Frontend: .Net

Team Size: 20

Responsibilities:

Involved in Database Design & Development for large databases.

Designed and implemented complex database architecture.

Exposure to Agile Scrum methodology – Daily Scrums, Sprint Planning etc.

Responsible in migration of the older application in retailer specific mode to multi-retailer.

Worked on SSIS packages for importing and exporting of data.

Involved in development of backend processes and job scheduling.

Applied and achieved success in many poor performing queries by applying Performance Tuning and Query Optimization techniques.

Managed and lead the database team.

Also worked on Netezza side, as main data warehouse is in Netezza.

ITC Infotech India Ltd., Bangalore

Worked in Retail and Accounting domain. In my entire tenure I was working on SQL server 2005 database development. I have worked on SSIS and SSRS also during my stay in ITC Infotech. Got good onsite exposure in the form of database migration project. Brief about the projects and my role in it is described below.

(A) Budget Planner

Backend: SQL Server 2005

Frontend: .Net, Silverlight

Team Size: 5

Summary: This application is developed for internal ITC purpose. Main aim is to determine what the income from different clusters, what the savings after allocating the entire spending. Also to determine whether the current expenses and future expenditure will be incurred in order to meet financial goals.

Responsibilities:

Involved in writing Stored Procedures, Cursors, Triggers, Views etc

Leader in major activities which include advanced performance tuning, database design

Single handedly handled backend part

Involved in DBA activities also like Job scheduling, Backup, Restoration etc.

(B) CARE

Backend: SQL Server 2005

Frontend: .Net,

Team Size: 14

Summary: Project is for US client, a NGO Firm called Columbia Association. They provide different facilities to CA residents. Main aim is to develop centralize application and automate all their operations.

Responsibilities:

Involved in complete Database Design and writing Stored Procedures, Cursors, Queries, Views, Triggers and other Db objects.

Introduced Error Handling and Auditing techniques wherever possible.

Responsible for Database Migration. This is onsite assignment, involved in gathering required data from the customers, validating the data and uploading it into SQL server database.

Worked on SSIS packages for importing and exporting of data.

Involved in development of backend processes and job scheduling.

Responsible for Database Admin and maintenance activities.

Monitored and identified several performance bottlenecks, modified the stored procedures so that performance needs were met.

Managed and lead the database team.

Involved in integrating different modules, as this is the centralized application and database objects are common across the modules.

Responsible for the development of the most critical module of the application, that is Accounting module.

Involved in giving demo and KT to the customer.

BlueStar Infotech Ltd., Mumbai

Worked in Retail domain. During my entire tenure, I have worked on Microsoft Business Intelligence using SQL server 2000 Analysis services and DTS packages. I was involved in 2 Business Intelligence projects.

(A) BlueStar BI Implementation

Backend: SQL Server 2000, DTS packages

Frontend: Proclarity

Team Size: 3

Summary: Blue Star is India's largest central air-conditioning company. It fulfills the air-conditioning needs of a large number of corporate and commercial customers and has also established leadership in the field of commercial refrigeration. Main aim of the project is to give the ease to the end users to generate the reports and do the analysis on the data as per their needs.

Responsibilities:

Involved in Database development.

Involved in ETL (Extract Transform Load) process.

Responsible for designing Cubes, Dimensions, Facts and Measures.

Involved in Data staging, validation and transformation.

Responsible to log errors at any point of time during the process.

Worked on Stored Procedures, Queries, views and other database objects

Involved in Job scheduling and other maintenance activities.

Involved in complete BI design, development and implementation cycle.

(B) Raymond BI Implementation

Backend: SQL Server 2000, DTS packages

Frontend: Proclarity

Team Size: 1

Summary: The Raymond Group was incorporated in 1925 and within a span of a few years, transformed from being an Indian textile major to a global conglomerate. Raymond is one of the largest integrated manufacturer of worsted fabric in the world. Main aim of the project is to provide end users data in ease format, so that it will be helpful in their day to day analysis.

Responsibilities:

Involved in maintenance and support activities

Responsible to understand day to day queries of end users and help them for any issue.

Involved in Bug fixing and new enhancements

Involved in training sessions, to make users familiar with the BI process and proclarity tool to generate the reports.

Involved in generating some complex reports through proclarity.

Responsible for monitoring scheduled jobs and rectify in case of any failure.

Involved in Database maintenance activities also.

Deloitte Touche Tohmatsu India Pvt. Ltd., Mumbai

Worked in finance domain. During my tenure I have worked on one in-house application and got exposure to Lawson ERP system. I have worked on SQL server 2005 Analysis services and Reporting services as a part of my tenure in Deloitte.

(A) PSR System

Backend: SQL Server 2005, SSIS Packages

Frontend: SSRS

Team Size: 3

Summary: PSR stands for Professional Services Reporting system. This is basically a reporting system which fulfills day to day need of reports for the end users

Responsibilities:

Worked on Stored Procedures, Queries, Views to perform various tasks

Responsible for Designing and Publishing the reports using SQL Server 2005 Reporting Services.

Responsible for designing Cubes, Dimensions, Facts and Measures

Involved in resolving various issues involving in PSA (Professional Service Automation) and SUN System.

Involved in various Database maintenance activities.

JetAir Pvt. Ltd., Mumbai

I have worked in SQL server 2000, DTS packages, Seagate Crystal Reports and Visual basic. Also got bit exposure to MySQL Database and JSP’s, Servlets. I have been involved in Data warehousing front also. Brief about the projects and my role in it is described below.

(A) TSSAS

Backend: SQL Server 2000, DTS Packages

Frontend: Visual Basic

Team Size: 10

Summary: TSSAS stands for Ticket Sales and Stock Accounting System. Basically JetAir is the parent company of Jet Airways. It serves as the agent to Jet Airways and also to the other international flights. This application takes care of the fortnightly sales and refunds of passenger and cargo tickets of domestic and international Airlines.

Responsibilities:

Worked on Stored Procedures, Cursors, Queries, and Views to perform various tasks.

Involved in designing of reports as per airline requirement using Seagate Crystal reports.

Involved in gathering the requirements from the users and implement them.

Responsible for enhancements and maintenance of the TSSAS application.

Involved in validating and importing the data which we use to get from airlines into the SQL Database using DTS packages.

Responsible for maintaining the version control using Microsoft Visual Source Safe

Involved in designing of cubes, handling Data warehousing.

Involved in Database maintenance activities.

(B) Attendance Statement

Backend: MySQL

Frontend: JSP’s, Servlets

Team Size: 3

Summary: This is the in house application developed to record the attendance of the JetAir Employees. Based on this, application will generate the daily and monthly attendance report which is sent to HR department.

Responsibilities:

Involved in development using JSP’s and Servlets

Involved in giving demo to the management, regarding different features of the application.

Responsible for maintaining the application and bug fixing if any issue.



Contact this candidate