LAVA KUMAR PN : adl5vo@r.postjobfree.com

: +91-812*******

SUMMARY

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

Having good experience on SQL server (2008/2008R2) Sub queries, Joins, Indexes, Views & Constraints, T-SQL (Stored Procedure)

Having experience on creation of work flows with Containers, Data flow Task, Execute SQL Task .

Hands on experience in development of various Transformations like Lookup, Conditional split, Merge, Join’s, Audit, Aggregator, Sort, and using in SSIS

Experience in Development of mappings using needed Transformations to implement the business logic

Having good experience on Execute SQL Task and Execute Package Task.

Having proficiency in designing different Types of reports like Drill Down, Drill Through and Sub reports.

Worked with performance tuning at various SQL Server, SSIS levels like Source, Target, Destination and Transformations.

Created and modified many packages and reports according to the business demand with the given transformation or business logics.

Having good experience on debugging packages, implementing Checkpoints, Event Handling, Deployment, logging, Error handling etc.

WORK EXPERIENCE

Worked as Software Engineer in Neon Software Services Pvt LTD, Hyderabad from May-2014 to June-2018

Worked as BI Developer in GENPACT, Hyderabad from June-2013 to March-2014

EDUCATION

Bachelor of Technology in the stream of Electronics and Communication Engineering from JNTU University in 2010

TECHNICAL SKILLS

Technologies : Microsoft Business Intelligence Tools

(MSBI).

Operating Systems : Windows family.

Databases : SQL Server(2008/2008R2/2012).

ETL Tools : SQL Server Integration Services.

Reporting Tools : SQL Server Reporting Services.

PROFESSIONAL EXPERIENCE

Project # 1

Title : MYUS

Client : MYUS, US

Role : Software Engineer in(BI Team)

Environment : SQL Server 2012/2014,SSIS,SSRS

Project Description :

MYUS is the first, largest and number 1 ranked provider of consolidation services in the world. In business since 1997, we ship over 50,000 products per week for customers in over 220 countries around the world and have proudly maintained accreditation with the Better Business Bureau since 2008.the order items Will Shipped Quickly and Safe.

As the most experienced and established company in our industry, we pride ourselves on providing customer service that is second-to-none. It is our goal to create a seamless shopping experience for each of our customers so that everyone is able to shop without borders. No other company can provide you with as much comfort, experience and benefits as that offered at myus.com

Roles and Responsibility:

•Involved in understanding the requirements and KT sessions.

•Created stored procedures and functions for data storage and manipulation.

•Worked on developing Tables, Joins, Views, Creating stored procedures and Indexes.

•Design and development of packages by using various transformations.

•Expertise in using different transformations like Lookup, Derived Column, Merge Join, Aggregate, For Loop, For Each Loop, Conditional Split, Union all etc.

•Created and optimized stored procedures to perform database maintenance and resolve fragmentation issues.

•Worked on Execute SQL Task and Execute Package Task.

•Experience in providing Logging & check points

Maintained log information in Table to tracking Errors and recording package execution status.

Project # 2

Title : British Gas Business

Client : Centrica, UK

Role : BI Developer

Environment : SQL Server 2008/2008R2,T-SQL,SSIS

Project Description

British Gas is an energy and home services provider in the United Kingdom. It is the trading name of British Gas Services Limited and British Gas New Heating Limited, both subsidiaries of Centrica Serving around 12 million homes in the UK. British Gas is the biggest UK energy supplier and is considered one of the Big Six dominating the gas and electricity market in the United Kingdom. The brand British Gas remains from the demerger of the British Gas Cooperation in 1997, which formed Centrica, BG Group and National Grid. British Gas is led by Chris Weston, its Managing Director, who oversees a business that provides energy for 12 million homes and employees over 30,000 staff based across the UK.

Roles and Responsibility:

•Involved in developing ETL for loading data into Database.

•Created ETL packages using Heterogeneous data sources (SQL Server, Flat Files, SQL source files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

•Creating Packages on SSIS by using different data Transformations like Derived Column, Conditional Split, Multicast, Sort and Execute SQL Task to load data into data warehouse.

•Creating Jobs for Scheduling SSIS packages and performance tuning of packages.

•Worked on Execute SQL Task and Execute Package Task.

•Created event handlers per the package using event handler tab.

•Generated the Drilldown Reports, Drill through reports & Sub Report.

•As per the requirements developed the reports in the form of Matrix, Table and Chart Using SQL Server 2008 Reporting Services.

Contact this candidate