Associate Consultant Resume

SUMMARY:

Having 3+ years of experience in MSBI Technology and seeking assignment with an IT Organisation
Experience in MSBI (SSIS, SSAS, SSRS, Excel 2010).
Experience in Database using RDBMS SQL Server 2008 R2/2012 RC0.
Extensive knowledge in SQL and store procedure.
Experienced in VB macros used in MS Excel.
Experienced in ASP .NET Application including Charting, Reporting, Rendering Data into different Controls.
Experienced in the development of Solutions for Mobile BI.
Excellent communication & interpersonal skills with proven abilities in resolving complex software issues.
Relevant experience in Tableau and Datawatch Monarch.

TECHNICAL SKILLS:

Languages: .Net along with C#, VB, C, C++, T - SQL Scripts

Web Technologies: ASP .Net, XHTML, CSS, JavaScript.

IDE: MS Visual Studio 2010,SQL Server Management Studio

Database: SQL Server 2008 R2/2012 RC0 (including SSIS, SSAS, SSIS).

Operating System: Windows Family.

WORK EXPERIENCE:

Confidential

Associate Consultant

Technologies: SQL Server 2008 R2, MSBI (SSIS, SSAS, MS Excel 2010)

Responsibilities:

Writing queries to validate the data in the report according to the requirement.
Developed many STU Reports and supported as a part of development.
Unit Tested STU reports with ODS and corrected bugs for the same.
Tested report functionality and availability, stability.
Coordinating with test team for faster bug fixes.
Preparing Unit Test case documents.

Confidential

Developer

Technologies: SQL Server 2008 R2/2012 RC0, MSBI (SSIS, SSAS, SSRS), ASP .NET along with Charts and Grids

Responsibilities:

Writing T-SQL Statements with includes development of Stored Procedure and fetching data for the Reports according to the requirement.
Developed SSRS Reports based on the requirement.
Unit Tested SSR reports with ODS and corrected bugs for the same.
Tested report for proper functionality and availability, stability.
Coordinating with test team for faster bug fixes.
Preparing Unit Test case documents.

Responsibilities: Writing procedure, pulling correct data to SSRS and Charts and Grids in.NET, validating the same

Confidential

Developer

Technologies: SQL Server 2008 R2, MSBI (SSIS, SSAS, SSRS), ASP .NET,TFS

Responsibilities:

Writing T-SQL Statements with includes development of Stored Procedure for creating views in Datawarehouse.
Creating SSIS Packages including Script Task where C# coding is done.
Creation of Cube in SSAS Based on Staging DataBase.
Writing T-SQL Statements with includes development of Stored Procedure and fetching data for the Reports according to the requirement.
Developed SSRS Reports based on the requirement.
Unit Tested SSR reports with ODS and corrected bugs for the same.
Tested report for proper functionality and availability, stability.
Coordinating with test team for faster bug fixes.
Preparing Unit Test case documents.

Responsibilities: Writing procedure, Creating Cubes, pulling correct data to SSRS and Charts and Grids in.NET, validating the same

Confidential

Developer and Data Analyst

Responsibilities:

Data Extraction - Extraction the data from different ERP systems (e.g. SAP,HADOOP etc.).
Data Loading - Cleansing and loading the data to SQL server using SSISpackages, Datawatch Monarch etc.
Data Validation- Checking the consistency and completeness of data.
Data Analysis - Performing Risk Analysis Tests on the data using SQL Server.
Creating Reports - Creating Reports on results using various data visualizations toolssuch as SSRS, Tableau etc.

Confidential

Developer

Technologies: Visual Basic 6.0 and sql plus

Responsibilities:

It was a project that included all the details of Jet Airways.it contained the details of all the arrival and departure flights schedules, fares, availability of seats, booking of seats, duration of journey etc.
To enter new record into the database, to retrieve the details, to modify the content of any record can easily be done using the software
Coding on VB 6.0 and sql DB management.

Confidential

Developer

Technologies: JAVA

Responsibilities:

It is a project of hiding one format of data into another format so that any unintended viewer cannot even know the existence of data inside it. It can only be retrieve by using the software.
It also includes other features such as compression and encryption to add other level of security to the useful data
Coding on JAVA.