GOVINDA RAJU KALLA

HOUSE NO. *-**, Chillangi (P*), Kirlampudi (MD), EastGodavari - 533431

Email: acqb7e@r.postjobfree.com Phone: (M) +91-900*******

To be the part of a team of hi-caliber professionals for challenging new assignments and responsibilities, thus sharpening my own professional skills, while at the same time, contributing my best to the overall development of the organization

Accomplished and results-driven professional with over 4.8 YEARS of IT experience in Microsoft Business Intelligence (SSIS, SSAS and SSRS), MDX, Data Analysis, Data Warehouse and Business Solution. Deep understanding of technology with focus on delivering business solutions. Proven ability to be a strong professional with the sound knowledge of the new technologies and advance applications. Recommends resolutions to complex matters of significance and coordinate the implementation of the approved course of action. Goal oriented, customer focused, and tenacious; committed to executing solutions on-time.

Currently working in WinWire Technologies, Hyderabad as BI Module Lead

Special proficiency in Microsoft SQL Server, Transact SQL, MDX, SQL Server Integration Services, SQL Server Analysis Services, Power BI and Microsoft Excel 2013. Thorough understanding of the complete Life Cycle of a BI Development

Expertise in preparing ETL, Cube design, Data Analysis and MDX

Have knowledge on SQL Server Reporting Services,PPS in SharePoint and Power BI

Technical Proficiency

Business Intelligence

Tools/ Technologies

Programming Languages

Database

Theoretical Knowledge

MSBI, SSIS, SSAS, SSRS, MDX, DAX,

BI Semantic Tabular Model,

Excel Pivoting,

PPS in SharePoint, Power BI

ASP .NET 4.0, SharePoint 2010, Visual Studio 2010/ 2012, MS Office 2013, SQL Server Management Studio 2012, TFS

C#, SQL, PL/SQL, HTML 5,CSS3, JavaScript, C, C++ and Java

SQL Server 2008 R2/ 2012, MS Access (MS Excel 2013)

Business Intelligence, Data Warehousing, Database Management System, Data Structure

Technical Certifications

Exam ID

Description

Date Completed

70-467

Designing BI Solutions with MS SQL Server 2012

Nov 30, 2013

70-463

Implementing a Data Warehouse with Microsoft SQL Server 2012

Feb 22, 2013

70-461

Querying Microsoft SQL Server 2012

Dec 22, 2012

ISTQB

Foundation Level Certificate in Software Testing

Jun 23, 2012

70-462

Administering Microsoft SQL Server 2012 Databases

Nov 2, 2013

70-466

Implementing Data Models and Reports with MS SQL Server 2012

Jun 22, 2013

Professional Experience

WinWire Technologies, Hyderabad (October’2014 – Till Now)

BI Module Lead

Key Responsibilities:

Worked on Agile model of development and got complete idea of “Software Development Life Cycle

Comprehensive knowledge of designing and analyzing databases/ data warehouses/ CUBEs

In-depth knowledge of data modeling and data warehousing methodologies

Expert at Agile model of development and got complete idea of “Software Development Life Cycle

Performed requirement analysis and estimation of new business requests from client

Analysis on new data sources for pulling and integrating data into our existing backend system

Handled and owned entire backend of the project

Handled and owned entire backend of the project

Integrated data from various sources like: Excel sheets, SQL Server databases, Flat files, Analysis Cube etc… using Microsoft SSIS

Focused on new tools to get “less work, high quality within time”

Good in performance tuning the objects at SQL server end

Expert at gathering and analyzing user requirements

Exceptional communication, presentation and interpersonal skills

Writing new logic, Query and Store Procedure

SSIS package monitoring and Custom logging

Experience on SSRS reports and PerformancePointServices in SharePoint

Skilled at developing reports, dashboards and other data visualizations

MAQ Software, Hyderabad (March’2012 – October’2014)

Software Engineer

Key Responsibilities:

Worked on Agile model of development and got complete idea of “Software Development Life Cycle

Performed requirement analysis and estimation of new business requests from client

Analyzed new data sources for pulling and integrating data into our existing backend system

Prepared monthly sprint plans for the project

Handled and owned entire backend of the project

Led the design of BI application

Integrated data from various sources like: Excel sheets, SQL Server databases, Flat files, Analysis Cube etc… using Microsoft SSIS

Filtered and cleaned data and build data warehouse

Worked on requirement gathering, effort estimation and managing a small team

Implemented data marts on top of data warehouse

Created SSAS cube using Microsoft using SSAS for faster retrieval of historical data

Implemented highly configurable asynchronous Zing chart web part in SharePoint with appealing UI

Configured various types of HTML5 charts in SharePoint application

Focused on new tools to get “less work, high quality within time”

Writing new logic, Query and Store Procedure

SSIS package monitoring and Custom logging

Projects Executed

Kapstone BI Duration: October’2014 – Till Date

Project

Kapstone BI

Company

WinWire Technologies, Hyderabad

Client

USA

Technology/ Tools

SharePoint 2010, Business Intelligence Tools (SSAS, SSIS,SSRS), PPS

Languages

SQL, MDX, C#, HTML5, JavaScript, JQuery

Database

SQL Server 2012

Role

BI Module Lead

Description

It is a SharePoint portal that displays various SSRS and tabular reports, which helped stake holders to take decisions on data

Responsibilities

Responsibilities include:

Created SSRS reports as per business requirements and integrated into SharePoint

Gathered requirements from client

Communicate with client to get clarifications, attend design discussions

Sent daily status update to client

ETL Design, Data gathering, transforming and loading

Error handling, Maintain and monitor jobs

Coding and Unit Testing

Developed cube, Implemented Cube Security and ETL mails

Created implementation approach documents for each requirement

MS Online Store BI Duration: August’2012 – Oct 17, 2014

Project

MS Online Store BI

Company

MAQ Software

Client

Microsoft Corporation, USA

Technology/ Tools

SharePoint 2010, Business Intelligence Tools (SSAS, SSIS), Zing chart

Languages

SQL, MDX, C#, HTML5, JavaScript, JQuery

Database

SQL Server 2012

Role

Developer

Description

It is a SharePoint portal that displays various ZingChart and tabular reports, which helped stake holders to take decisions on data

Responsibilities

Responsibilities include:

Owning backend work of Project

Gathered requirements from client

Communicate with client to get clarifications, attend design discussions

Sent daily status update to client

ETL Design

Data gathering, transforming and loading

Error handling, Maintain and monitor jobs

Coding and Unit Testing

Developed cube, Implemented Cube Security and ETL mails

Created implementation approach documents for each requirement

Deployed ETL packages in production server using project deployment model

Cloud Infrastructure Duration: March’2012 – July’2012

Project

Cloud Infrastructure

Company

MAQ Software

Client

Microsoft Corporation, USA

Technology/ Tools

MSBI (SSIS, SSAS),MDX, MS SQL Server 2012

Role

Developer

Description

It is a SharePoint portal that displays various reports with Microsoft products information. These reports help the marketing team to analyze the current business.

Responsibilities

Responsibilities include:

Worked on all aspects of MSBI (SSIS, SSAS, SSRS)

Created data warehouse and mart for project on SQL Server 2012

Implemented Cube Security, ETL mails, quick changes to whole solution in case of requirements

Writing MDX queries and Stored procedures

Scheduling the ETL Package Using SQL Server 2012 Management Studio.

Deployed ETL packages in production server using project deployment model

Global Partner BI Duration: August’2011 – February’2012

Project

Global Partner BI

Company

ValueMomentum, Hyderabad

Client

Microsoft Corporation, USA

Technology/ Tools

MSBI (BIDS, SSIS, SSAS), MS SQL Server 2008 R2, SharePoint

Role

Developer

Description

A complete end to end BI solution for Microsoft partners. Collect relevant data from different sources of Partners, prepare data warehouse by SSIS (including many ETL packages), implementing all complicated Business logics before creating data mart (by using stored procedures, functions etc.), creating SSAS (MOLAP cube) which involve dimensions, measures and all types of relationships, applying cube level security using scripts and dlls. Finally same solution provides SSRS and ZingChart (SharePoint) reports using complex MDXs.

Responsibilities

Responsibilities include:

Designing and developing SSIS packages using different transformations to read the data from flat files and transform it into required format before inserting into Database.

Scripting complex MDX queries to fulfil Reports requirement

Coding and Unit Testing

Developed cube, Implemented Cube Security and ETL mails

Scheduling the ETL Package using SQL Server 2008 Management Studio

Implementing Package Configuration and Custom Logging

Deployed ETL packages in production server using package deployment model

Ufactory Duration: August’2010 – July’2011

Project

Ufactory

Company

ValueMomentum, Hyderabad

Client

USA

Technology/ Tools

SQL Server 2005/2008, SSIS, Oracle

Role

Developer

Description

UFactory is a comprehensive set of software solution that empowers mill product companies gain complete visibility into their customers, sales, manufacturing, operations, vendors and finance. With its flexible and easy to use software modules, UFactory integrates core process from shop floor to top floor to make decision proactively.

Responsibilities

Worked as Data warehouse designer

Involved in adding new improvements to uFactory

Involved in Coding and Maintenance of uFactory Modules

Educational Credentials

Qualification

Board/ University

Year of Passing

Percentage of

Marks Remarks

B.Tech, Information Technology

Bapatla Engineering College, ANU

2010

82.46

First class with distinction

Intermediate

Vignan Junior College, Guntur, IPE

2006

96.00

100% in Mathematics

SSC

AP RES High School, Bhupathipalem, SSC

2004

89.66

99% in Mathematics

Personal Details

ACHIEVEMENTS & AWARDS

Got Spot Award at MAQ Software for great performance given in the month of January, 2012

Got Spot Award at MAQ Software for excellent performance given in the month of December, 2013

Automated 80% of the data validation using PowerPivot, Excel using Excel and Cube Functions which reduced the manual effort exponentially and prepared automated excel sheet for one click data validation. Received Award for the same

Secured school first in my 10th standard

I have got consolation prize from Sanskrit bhasha Prachar Samithi

STRENGTHS

Solution Oriented, Responsible and Team Player

Positive thinking, Quick learning and Grasping ability.

Hard work with dedication, Self confidence and Commitment towards work

PERSONAL DESCRIPTION

Father’s Name

Veeraganeswara Rao

Mother’s Name

Sita

Gender

Male

Date of Birth

5th April 1988

Marital Status

Single

Nationality

Indian

Languages Known

Telugu & English

Hobbies

Listening to Music, Playing volleyball

I hereby declare that the information provided above is true to the best of my knowledge.

Place: Hyderabad [Govinda Raju Kalla]

Contact this candidate