Resume

Sign in

Sql Server Developer

Location:
Bangalore, Karnataka, India
Posted:
March 19, 2019

Contact this candidate

Resume:

MARAM.ASHOK KUMAR *: ac8tub@r.postjobfree.com

(: +91-984*******

PROFESSIONAL SUMMARY:

Having 2.9 years of Professional experience in IT industry, Involved in MSBI projects with extensive usage of SQL Server 2008 R2 Database/2012, ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS).

Experience in writing, optimizing T-SQL Objects like Stored Procedures, Joins, Functions, Triggers, Indexes and views.

Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task, File System Task and Data Flow Task.

Extensively used Derived Column, Row Count, Data Conversion, Conditional Split, Aggregate, Lookup, SCD, Merge, Merge Join and Sort to load data into Data Warehouse.

Experience in providing Error Logging and Error handling for SSIS Packages.

Experience in developing Table, Parameterized, Sub Reports, Linked reports, Drilldown Reports, Drill through Reports using SQL Server Reporting Services (SSRS).

Working with Integration Services package development and deployment.

Experience on Report Design, Development and Deployment using SSRS.

Team player and self-starter with good communication skills and ability to work independently and as part of a team.

Flexible and versatile to adapt to any new environment and work on any project.

Excellent interpersonal skills with strong analytical and Problem-solving skills.

PROFESSIONAL EXPERIENCE:

Working as MSBI Developer with NTT Data Global Delivery Services Pvt Ltd in Bangalore from NOV 2017 -Till Date.

Worked as Associate Software Engineer for Yash Technologies in Bangalore From

JUN 2016 – OCT 2017

TECHNICAL SKILLSET:

Programming Languages

SQL, T-SQL

Operating System

Windows Family

Databases

SQL SERVER 2008 R2/2012/2016

BI Tool

SSIS, SSRS

Qualifications:

Completed Bachelor of Technology in Electronics & Communication Engineering from JNTU-KAKINADA, (A.P.)

PROJECT EXPERIENCE:

Project#2:

Healthcare Domain Project

Role : MSBI Developer

Client : Washington Dental Services, US

Duration : Nov-2017 to Till date

Environment : SQL Server Integration Services,

SQL Server 2008 R2

Description:

Washington Dental Service (WDS), a member of the Delta Dental Plans Association, is the leading dental benefits company in the state of Washington, delivering over fifty years of high-quality, affordable dental care to more than two million people through employer-sponsored programs. Part of a 6-member team that offered solution to WDS to Build EDW using a Spiral approach (Agile Methodology). SSIS tool was used to extract the data from the various source systems and load into Corporate Information Factory (CIF) and then into the Data Marts. Business Objects was used as the reporting tool.

Responsibilities:

Responsible for creating the Functional Requirement Document.

Responsible for understanding the business requirements and designing applications to meet customer needs.

Created different SSIS packages and designing data warehouse.

Created SSIS Packages to import and export data from Excel, Xml and Text files.

Involved in designing and creating packages using SSIS.

Used transformations like Derive Column, Conditional Split, Row Count, Lookup, Merge, Sort and Execute SQL Task to load data into Data Warehouse

Scheduled the ETL Package using SQL Server 2008 R2 Management Studio.

Project#1:

Holiday Trips

Role : SQL Developer

Client : Kylie, Australia

Environment : SQL Server2008R2,T–SQL

Duration : June-2016 to October-2017

Description:

World Wide access is a Web based application which involves in providing various online facilities to the customers related to Business/Holiday trips. This application provides information of flights, Hotels, Cars, Vacations, Packages and Maps throughout the world. A customer can have different facilities provided and availability.

Responsibilities:

Worked in an agile methodology.

Generated the T-SQL Stored procedures, Triggers, Functions, Tables and Views.

Generated the Reports on Weekly and Monthly basis as per the Client Requirement.

Written procedures and manipulated the Date using DDL and DML functions.

Generated the reports by using the Report Wizard and Report Server.

Developed various reports like Drill-down, Sub reports, Tables and Matrix.

Developed parameterized reports including multi-parameters.

DATE: (ASHOK KUMAR.MARAM)

PLACE:



Contact this candidate