Project Developer

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

Phone : 91-818*******

Ravi Lade

SUMMARY

Around 2 years of IT experience as MSBI Developer.

Worked extensively in MSBI (SSIS, SSRS), and well Crystal Reports.

Strong experience of DDL, DML, T-SQL, views, stored procedure, functions and

packages.

Expertise in Developing SSRS reports and Technical solutions related to SSIS

implementations.

Extensive hands on experience in Designing and developing reports using SSRS and

developing SSIS packages for integrating data from different sources in to a data

warehouse.

Excellent Communication, interpersonal skills with strong analytical and problem solving

skills.

TECHNICAL QUALIFICATION

Master of computer applications from OU University Hyderabad during the period 2008

2011 with an aggregate of 68%.

WORK EXPERIENCE

Working as a software engineer in Sonata Software LTD from August 2012 – Till date

TECHNICAL SKILLS

Analysis Technology: MS SQL Reporting Services, Analysis Service, Data

Mining Integration Services.

Reporting : SSRS SQL Reporting Services.

Databases: MS SQL Server 2008/2005.

Platforms/OS : Windows NT/9X/2000/XP, Windows 2000/2003

Server

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE

Project #1

Company : Sonata Software LTD

Project Profile : Internal Project

Client : Sonata

Duration : Aug 2012 – Nov 2013

Role : Msbi developer

Description :

As per the requirement for the analysis of the employees travelling for the company purpose arises this

project is handled. As part of the Creating Database (ETL Process) Worked on the SSIS for Conversion of

MS Excel Database to SQL Database and creating Reports through SSRS for the End user.

Contribution:

As developer, I was responsible for

Collected all the required specifications of input data.

Analyzing and understanding the Excel Data and Creating SSIS Packages accordingly to

dump the data in to SQL Database.

Analyzing the approach in which SSIS package should be developed.

Creating SSRS reports for the end user.

Achieving things through work around which are not directly supported in SSRS.

Bug Fixing.

Status Reporting.

Project #2

Company : Sonata Software LTD

Project : Migration from Crystal to SSRS.

Client : Epicor

Duration : DEC 2013 Jul 2014

Role : MSBI Developer

Description:

Epicor is the leading software company in USA.Their Internal reports were developed in Crystal

Reports. They need to Migrate the reports developed using Crystal Reports to SSRS reports.

Worked on SSIS for Conversion of XML Database to SQL Database .

Contribution:

As developer, I was responsible for

Collected all the required specifications of input data.

Analyzing and understanding the Crystal Report Functionality.

Analyzing the approach in which SSRS report should be developed.

Restructuring the XML as per the approach.

Implementing the same functionality in SSRS reports which is their in Crystal Reports.

Achieving things through work around which are not directly supported in SSRS.

Bug Fixing.

Status Reporting.

Contact this candidate