Sql Server Engineer

Alok Kumar

Email : **************@*****.***

Mobile No: 830-***-****/ 775-***-****

OBJECTIVE

To work in a challenging environment which gives me an opportunity to employ my technical skills to the best of my ability and to learn new skills to enhance my profile.

EMPLOYMENT HISTORY

Name of the Company

Designation

From

To

Infosys Technologies Limited

Senior Systems Engineer

11 Sept 2011

17 Sept 2014

Accenture Services

Software Engineering Analyst

19 Sept 2014

12th Apr 2016

Cognizant Technology Solutions

Associate Projects

4th July 2016

Present

ACADEMIC QUALIFICATIONS

Bachelor of Technology from Visvesvaraya Technological University (2007-2011)

PROFILE:

7.2 years of sound development experience in the areas of Microsoft Business Intelligence (MSBI) using Microsoft SQL Server 2008/2012 and SSIS.

Involved in ETL design, development and deployment

Implemented performance tuning in SQL and SSIS.

SKILLS:

Functional Skills: ETL, Reporting, Analysis, Development, Unit Testing, Performance Enhancement.

Technical Skills: SQL Server 2008/2012, SSIS, SSRS

Working Knowledge: SQL Server 2008/ 2012, SSIS, SSRS, Power BI

EXPERIENCE AND STRENGTHS

Total experience of 7 years 7 months with 7.2 years of Business Intelligence and Data warehousing development experience with Infosys Limited in Manufacturing Domain and Accenture in Insurance domain and Cognizant Technology Solutions in Insurance domain.

Extensive experience in designing, developing, building and testing BI and DW applications.

Strong Analytical skills.

Strong communication, interpersonal skills, self-motivated, team player, quicklearner.

Having a good experience on ETL technologies like SSIS

Worked on SQL Server 2012 and SQL Server 2014,2016.

Having the good Knowledge on the CDC Technology.

Writing the complex Stored Procedures.

Performance Tuning of Databases and SSIS Packages.

EXPERIENCE SUMMARY

Cognizant Technology Solutions

Technologies Used: SSIS, SQL Server 2012

Responsibilities:

Involved in ETL development, design and deployment processes

Created/modified SQL stored procedures and functions for using in SSIS load.

Worked on performance tuning and database query optimization tasks.

Involved in deadlock resolving activities.

Accenture Services Private Limited

Technologies Used: SSIS, SQL Server 2012, SSRS

Responsibilities:

Created SSIS packages for migrating data from Legacy System to SQL database.

Experience in writing complex SQL queries

Created/Modified SSRS Reports as per requirement for projecting insurance renewal and insurance subscription related activities.

Involved in database deployment activities, performance tuning and database query optimization tasks.

Infosys Technologies Limited

Technologies Used: SSIS, SQL Server 2008

Responsibilities:

Designed advanced SSIS packages & procedures.

Performed impact analysis while bug fixing by considering the business impact.

Performed incremental load of data and fixed data quality issues.

CERTIFICATIONS

External:

Microsoft SQL Server2008 Database Development (70-433)

Microsoft Querying SQL Server 2012(70-461)

Implementing a Data Warehouse with Microsoft SQL Server 2012(70-463)

STRENGTHS

Sound experience in designing, developing and testing BIDW applications.

Strong analytical and communication skills.

Key player in a team

Excellent debugging skills

Contact this candidate