Abhishek K S

#**, *** ****, *****: ac0hk3@r.postjobfree.com

East of Kathriguppe, Phone: 962*******

4th Phase, BSK 3rd stage,

Bangalore - 560085

Experience Summary:

Having 3.8 years of working experience in the field of Information Technology that widely covers

Database Design and Development and Maintenance.

Use of Enterprise Manager and Query Analyzer for performance tuning and optimization.

Design, Development, Implementation and Testing of software products covering vital business domains like Insurance and Tech Support.

Good Programming Experience in MS SQL, BI Tools (SSIS, SSRS).

Involved in Developing and Maintenance of Database Objects.

DBA activities.

An effective communicator with excellent interpersonal and relationship building skills.

Strong problem solving and troubleshooting abilities.

Ability to work with limited resources, capable of multi-tasking.

Possess a flexible, learning and detail oriented attitude.

Able to organize events and lead a team effectively.

Share knowledge and gain whatever possible from the team.

Has exposure towards quality procedures pertaining to project.

Technical Skills:

Operating Systems

Windows XP & 7, 10, Windows Server 2008, 2012 R2.

Platform

Database

Web Technologies

HTML

RDBMS

SQL Server 2008 R2, 2014, Base SAS 9.4

Language

MS SQL, T-SQL

Tools

SQL Server Business Intelligence SSIS, SQL Server Reporting Services SSRS,

SQL Developer and Base SAS.

Version Controls

SVN and Change Point.

Enterprise Tools

Tidal

Skills:

T-SQL Skills:

Database development activities like Create/Alter table structures.

Writing Stored Procedures and User defined Functions.

Working with Triggers, Views, Query optimization.

SSIS Skills:

Fact table load using incremental load.

Deploying the SSIS package in 2008 and SSDT.

Designed packages for parallel processing.

Scheduling the packages from SQL server.

SQL server table and file package configuration.

Implementing event log and error log to the table and file.

Migrated SSIS 2008 to SSIS 2014.

Batch/Bulk processing of data (archival).

SSRS Skills:

Designing Multi parameterized reports using SSRS 2008 R2.

Deploying reports to the server.

Designing reports with Cascading parameters

Sub reports, Drilldown and Drill through report.

Implemented Log reports to track performance issues.

Migrated SSRS 2008 to SSRS 2014.

Soft Skills:

Mentoring

Able to mentor junior resources at Organization level. Had given technical training at Org. level. Provided training to interns and played a role of mentor for 4 interns.

Communication

Good at both verbal and written communication skills as well as presentation skills.

Education:

B.E in Computer Science and Engineering from People’s Education Society (P.E.S.C.E), Mandya in 2013 with the Aggregate of First Class Distinction 81.4%.

Summary of Work Experience:

EVRY INDIA (SPAN InfoTech Pvt. Ltd) (August 2013 - Present)

Projects Details:

Project - 1:

Title : Claim Processing System

Role : Senior Software Engineer

Duration : March 2014 - Present

Team size : 21

Key Challenges:

Understanding the existing business logic, business requirements and work on new enhancements and performance tuning tasks.

Responsibility:

Conducting impact analysis of the specifications provided by the clients.

Providing best solutions for new enhancement tasks.

Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other TSQL statements for applications.

Creating SSIS Packages for integrating data using OLE DB connection from heterogeneous

sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided

by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Creating various type of reports such as Complex drill down & drill through reports, Matrix

reports, Sub reports and Charts using SQL Server Reporting Services (SSRS).

Involved in unit testing and preparing unit test cases for SQL Server Reports.

Ensure on time deliverables with zero defects.

Tuning the existing code for better performance.

Post production support.

Migration from SQL Server 2008 to SQL Server 2014.

Project - 2:

Title : Time and Attendance

Role : Junior Software Engineer

Duration : August 2013 – February 2014

Team size : 9

Roles and Responsibility:

Coordinating with project team, business and support manager with regards to release

acceptance and post production issues within warrant period.

Analyzing the impact on system for change requests.

Involved in DBA Activities like Monitoring Database and disk space management.

Resolving incidents reported by end users on priority bases based on the defined SLA.

Interacting with client on all updates of project related activities.

Leading the offshore team & coordinating with onsite team.

Estimating the effort and planning activities, preparing technical and impact analysis

documents.

Verification of new projects for adherence to defined release management process and

acceptance of the project to support.

Monitoring Daily jobs on all production servers of multiple markets and resolving the issues

if there are any failures and making the system available before business time.

Personal Profile:

Father’s Name : K Shiva Shankar Rao

Date of Birth: 18-11-1991

Marital Status: Married

Nationality: Indian

Hobbies: Reading books, Playing Cricket and Volley ball.

Linguistic: English, Kannada, Hindi and Tulu

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

Place: Bengaluru

Date: 19th May 2017

(Abhishek K S)

Contact this candidate