ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
SRINIVASARAO.G
E-Mail:srinivasgmsbi11@gmail.com
Mobile-No: +91-9620606350
PROFESSIONAL SUMMARY:
3+years of experience in Data warehousing and Business Intelligence Domain.
Good experience with SQL Server 2008/2012, SSIS (SQL Server Integration Services), SSRS (SQL
Server Reporting Services).
Expertise on writing Queries, Sub Queries and Joins.
Good knowledge on Data warehousing Concepts
Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and
normalizations.
Expertise in writing Stored Procedures and Functions.
Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
Experience in creating Jobs, Alerts, SQL Agent, and Scheduled SSIS Packages
Experience on SSRS 2008 and SSIS 2008.
Expertise in designing reports like Cascading reports, sub reports and dashboards.
Supported team in resolving SQL Reporting services and ETL related issues.
TECHNICAL SKILLS:
BI Tools : SSIS, SSRS, T-Sql.
Operating Systems : Windows 7/8/10.
DBMS : SQL Server 2008/2012, ORACLE
PROFESSIONAL EXPERIENCE:
Working as a Data Warehouse Developer and Software Engineer in ITC Infotech India Ltd. Bangalore.
EDUCATION:
Master of Computer Applications [MCA] from JNTU University, Hyderabad.
PROJECT DETAILS:
PROJECT #2:
Project : Trade Marketing and Distribution
Client : ITC Limited
Role : Associate IT Consultant
Team size : 9
DESCRIPTION:
ITC TM&D (Trade Marketing & Distribution) vertical is interested in designing and implementing a
Performance Evaluation and Reward System for its Sales force. The system scope will include its front Area
Executives sales force. The performance evaluation of the AE’s will be done basis the channel they are
aligned to Implement an End to End solution which will automate the entire score computation process.
Computes payout basis the bands in which the scores lies and provides an output on the payout to the salary
department on a quarterly basis.
RESPONSIBILITIES:
Creating Jobs by using SQL Server Agent and Scheduled SSIS Packages
Writing Stored Procedures, Functions and Joins.
Insert data from database using bulk insert.
Creating packages at SQL Server Integration Service platform.
Created SSIS packages for data Importing, Cleansing etc. Extracted, cleaned and validated Loaded the data
from Excel and Flat files.
Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL
Task, Data Flow Task
Creating SSIS Configurations.
Create SCD in SSIS.
Export cleaned data from Excel sheets, Text file, MS Access and CSV files to data warehouse.
Created ad-hoc reports, drill down, and drill through reports. Creating reports by using SSRS 2008.
Created in designing reports like Cascading reports, sub reports and dashboards.
Involved in deploying reports.
Generated the Reports Weekly and Monthly wise as per the Client Requirements.
ENVIRONMENT:
Windows 2007 , SQL Server 2008 Integration Services, T-sql, SQL Server Reporting Services 2005 &
2008.
PROJECT #1:
Project : PROMAXTRADE PROMOTION
Client : ITC Limited
Role : Date Warehouse Developer
Team size : 5
DESCRIPTION:
Promax Trade Promotion is a Australian trading project having nearly 40 clients. Data is coming from
Promax Application of different customers where we are designing and developing Packages in order to load
whole data of the customers and supporting to the customer reporting and manipulating the reports according
to customer requirement. Generating the sales summary, sales forecast and Order summary on weekly,
monthly and quarterly reports. Supporting for customers issues.
RESPONSIBILITIES:
Creating packages at SQL Server Integration Service platform.
Importing Source/Target tables from the respective databases by using FTP task in Control Tasks in SQL
Server 2008 Integration services.
Writing Stored Procedures and Functions.
Creating SSIS Configurations.
Creating Jobs by using SQL Server Agent.
Created Event Handlers for the Packages Using Event Handler Tab.
Used Control Flow Tasks as Execute SQL Task, Data Flow Task, and Execute Package Task, Send mail
Task, Script Task and File System Task.
Extensive knowledge on Report Manager Properties.
Processing the cubes and building the package in SSIS to process the cubes.
As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2008
Reporting Services.
Involved in deploying reports.
Creating reports by using SSRS 2008.
Creating Drill down Reports, Sub reports, Drill through Reports.
ENVIRONMENT:
Windows 2007 , SQL Server 2008 Integration Services,T-sql, SQL Server Reporting Services 2005 &2008.
G.SRINIVASARAO.

More Related Content

What's hot (20)

MSBI-SSRS PPT
MSBI-SSRS PPTMSBI-SSRS PPT
MSBI-SSRS PPT
VIT-AP UNIVERSITY
Ìý
Building SSRS 2008 large scale solutions
Building SSRS 2008 large scale solutionsBuilding SSRS 2008 large scale solutions
Building SSRS 2008 large scale solutions
Denny Lee
Ìý
SSRS integration with share point
SSRS integration with share pointSSRS integration with share point
SSRS integration with share point
Jacob Chang
Ìý
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
Dibakar27
Ìý
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
Edureka!
Ìý
Ssrs 2008 R2 webinar
Ssrs 2008 R2   webinarSsrs 2008 R2   webinar
Ssrs 2008 R2 webinar
Snigdha Chotani
Ìý
New features of sql server 2016 bi features
New features of sql server 2016 bi featuresNew features of sql server 2016 bi features
New features of sql server 2016 bi features
Chris Testa-O'Neill
Ìý
Cover Letter Only040511
Cover Letter Only040511Cover Letter Only040511
Cover Letter Only040511
shangbaby
Ìý
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
Edureka!
Ìý
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Bala Subra
Ìý
SQL Server Reporting Services: IT Best Practices
SQL Server Reporting Services: IT Best PracticesSQL Server Reporting Services: IT Best Practices
SQL Server Reporting Services: IT Best Practices
Denny Lee
Ìý
SQL Server Reporting Services (SSRS) 101
 SQL Server Reporting Services (SSRS) 101 SQL Server Reporting Services (SSRS) 101
SQL Server Reporting Services (SSRS) 101
Sparkhound Inc.
Ìý
SSRS for DBA's
SSRS for DBA'sSSRS for DBA's
SSRS for DBA's
Jonathan Bloom
Ìý
Bhargavi_MSBI
Bhargavi_MSBIBhargavi_MSBI
Bhargavi_MSBI
Bhargavi paruchuri
Ìý
Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)
Anurag Rana
Ìý
Qidb resume
Qidb resumeQidb resume
Qidb resume
Bin Qi
Ìý
updated_profile_ak
updated_profile_akupdated_profile_ak
updated_profile_ak
Ashish Srivastava
Ìý
Ssrs introduction session 1
Ssrs introduction session 1Ssrs introduction session 1
Ssrs introduction session 1
Muthuvel P
Ìý
Resume - Courtney Ammons
Resume - Courtney AmmonsResume - Courtney Ammons
Resume - Courtney Ammons
Courtney Ammons
Ìý
Sql server reporting services
Sql server reporting servicesSql server reporting services
Sql server reporting services
ssuser1eca7d
Ìý
Building SSRS 2008 large scale solutions
Building SSRS 2008 large scale solutionsBuilding SSRS 2008 large scale solutions
Building SSRS 2008 large scale solutions
Denny Lee
Ìý
SSRS integration with share point
SSRS integration with share pointSSRS integration with share point
SSRS integration with share point
Jacob Chang
Ìý
Sophia wang (2)
Sophia wang (2)Sophia wang (2)
Sophia wang (2)
Dibakar27
Ìý
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
SSRS Tutorial | SQL SERVER REPORTING SERVICES ( SSRS ) | MSBI Training Videos...
Edureka!
Ìý
Ssrs 2008 R2 webinar
Ssrs 2008 R2   webinarSsrs 2008 R2   webinar
Ssrs 2008 R2 webinar
Snigdha Chotani
Ìý
New features of sql server 2016 bi features
New features of sql server 2016 bi featuresNew features of sql server 2016 bi features
New features of sql server 2016 bi features
Chris Testa-O'Neill
Ìý
Cover Letter Only040511
Cover Letter Only040511Cover Letter Only040511
Cover Letter Only040511
shangbaby
Ìý
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
MSBI Tutorials for Beginners | Business Intelligence Tutorial | Learn MSBI | ...
Edureka!
Ìý
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Basics & Intro to SQL Server Reporting Services: Sql Server Ssrs 2008 R2
Bala Subra
Ìý
SQL Server Reporting Services: IT Best Practices
SQL Server Reporting Services: IT Best PracticesSQL Server Reporting Services: IT Best Practices
SQL Server Reporting Services: IT Best Practices
Denny Lee
Ìý
SQL Server Reporting Services (SSRS) 101
 SQL Server Reporting Services (SSRS) 101 SQL Server Reporting Services (SSRS) 101
SQL Server Reporting Services (SSRS) 101
Sparkhound Inc.
Ìý
Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)Presentation 1 - SSRS (1)
Presentation 1 - SSRS (1)
Anurag Rana
Ìý
Qidb resume
Qidb resumeQidb resume
Qidb resume
Bin Qi
Ìý
Ssrs introduction session 1
Ssrs introduction session 1Ssrs introduction session 1
Ssrs introduction session 1
Muthuvel P
Ìý
Resume - Courtney Ammons
Resume - Courtney AmmonsResume - Courtney Ammons
Resume - Courtney Ammons
Courtney Ammons
Ìý
Sql server reporting services
Sql server reporting servicesSql server reporting services
Sql server reporting services
ssuser1eca7d
Ìý

Viewers also liked (17)

3 Elements to Setting Goals By: Dustin Hatfield
3 Elements to Setting Goals By: Dustin Hatfield3 Elements to Setting Goals By: Dustin Hatfield
3 Elements to Setting Goals By: Dustin Hatfield
Dustin Hatfield
Ìý
GERRY PANTIG MANICLANG
GERRY PANTIG MANICLANGGERRY PANTIG MANICLANG
GERRY PANTIG MANICLANG
Gerry Maniclang
Ìý
Equilibrium
EquilibriumEquilibrium
Equilibrium
Mr.Ramesh Chandra Panda
Ìý
TQM_Supplier Partnership
TQM_Supplier PartnershipTQM_Supplier Partnership
TQM_Supplier Partnership
Mr.Ramesh Chandra Panda
Ìý
LAWS FOR THE RESULTANT FORCE
LAWS FOR THE RESULTANT FORCELAWS FOR THE RESULTANT FORCE
LAWS FOR THE RESULTANT FORCE
Mr.Ramesh Chandra Panda
Ìý
cost of quality
cost of qualitycost of quality
cost of quality
Mr.Ramesh Chandra Panda
Ìý
Parallel Forces
Parallel ForcesParallel Forces
Parallel Forces
Mr.Ramesh Chandra Panda
Ìý
Moments
MomentsMoments
Moments
Mr.Ramesh Chandra Panda
Ìý
Composition and
Composition andComposition and
Composition and
Mr.Ramesh Chandra Panda
Ìý
FUNDAMENTALS OF TOTAL QUALITY ...
FUNDAMENTALS              OF                                   TOTAL QUALITY ...FUNDAMENTALS              OF                                   TOTAL QUALITY ...
FUNDAMENTALS OF TOTAL QUALITY ...
Mr.Ramesh Chandra Panda
Ìý
INTRODUCTION (2)
INTRODUCTION (2)INTRODUCTION (2)
INTRODUCTION (2)
Mr.Ramesh Chandra Panda
Ìý
LBM
LBMLBM
LBM
Mr.Ramesh Chandra Panda
Ìý
Ultrasonic Machining
Ultrasonic MachiningUltrasonic Machining
Ultrasonic Machining
Mr.Ramesh Chandra Panda
Ìý
basics
basicsbasics
basics
Mr.Ramesh Chandra Panda
Ìý
Introduction to Engineering Mechanics
Introduction to Engineering MechanicsIntroduction to Engineering Mechanics
Introduction to Engineering Mechanics
Mr.Ramesh Chandra Panda
Ìý
Csr presentation
Csr presentation Csr presentation
Csr presentation
Jwal Jani
Ìý

Similar to VASU (20)

Nikhil_MSBI_updated
Nikhil_MSBI_updatedNikhil_MSBI_updated
Nikhil_MSBI_updated
Nikhil Korripati
Ìý
Balamurugan msbi cv
Balamurugan msbi cvBalamurugan msbi cv
Balamurugan msbi cv
bala murugan
Ìý
BI SQL Server2008R2 Portfolio
BI SQL Server2008R2 PortfolioBI SQL Server2008R2 Portfolio
BI SQL Server2008R2 Portfolio
dlinder25
Ìý
Vigna_MSBI_Resume
Vigna_MSBI_ResumeVigna_MSBI_Resume
Vigna_MSBI_Resume
vignanavathi solomon
Ìý
Rakesh
RakeshRakesh
Rakesh
Rakesh Kuchana
Ìý
Rakesh
RakeshRakesh
Rakesh
Rakesh Kuchana
Ìý
Resume_Navneet_Formatted
Resume_Navneet_FormattedResume_Navneet_Formatted
Resume_Navneet_Formatted
Navneet Tiwari
Ìý
Samuel Bayeta
Samuel BayetaSamuel Bayeta
Samuel Bayeta
Sam B
Ìý
resume mumbai
resume mumbairesume mumbai
resume mumbai
siva prasad
Ìý
Naveen CV
Naveen CVNaveen CV
Naveen CV
NaveenKumar GV
Ìý
MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)
manish sharma
Ìý
SQL Server (BI/T-SQL) Consultant
SQL Server (BI/T-SQL) Consultant SQL Server (BI/T-SQL) Consultant
SQL Server (BI/T-SQL) Consultant
Rajabpdev
Ìý
Venkatesh-MSBI
Venkatesh-MSBIVenkatesh-MSBI
Venkatesh-MSBI
Venkatesh Annam
Ìý
MSBI_MSSQL_Bhrath
MSBI_MSSQL_BhrathMSBI_MSSQL_Bhrath
MSBI_MSSQL_Bhrath
Bharath Bandaru
Ìý
NiveditaResumeDBA
NiveditaResumeDBA NiveditaResumeDBA
NiveditaResumeDBA
Nivedita Alure
Ìý
Tx 09 G3 Jayasri Santhappan
Tx 09 G3 Jayasri SanthappanTx 09 G3 Jayasri Santhappan
Tx 09 G3 Jayasri Santhappan
jayasrisan
Ìý
Professional Portfolio
Professional PortfolioProfessional Portfolio
Professional Portfolio
MoniqueO Opris
Ìý
Resume of Pritam Das
Resume of Pritam DasResume of Pritam Das
Resume of Pritam Das
Pritam Das
Ìý
Business Intelligence Dev. Portfolio
Business Intelligence Dev. PortfolioBusiness Intelligence Dev. Portfolio
Business Intelligence Dev. Portfolio
Vincent Gaines
Ìý
shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017
MICHAEL LIANG
Ìý
Balamurugan msbi cv
Balamurugan msbi cvBalamurugan msbi cv
Balamurugan msbi cv
bala murugan
Ìý
BI SQL Server2008R2 Portfolio
BI SQL Server2008R2 PortfolioBI SQL Server2008R2 Portfolio
BI SQL Server2008R2 Portfolio
dlinder25
Ìý
Resume_Navneet_Formatted
Resume_Navneet_FormattedResume_Navneet_Formatted
Resume_Navneet_Formatted
Navneet Tiwari
Ìý
Samuel Bayeta
Samuel BayetaSamuel Bayeta
Samuel Bayeta
Sam B
Ìý
resume mumbai
resume mumbairesume mumbai
resume mumbai
siva prasad
Ìý
MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)MANISH SHARMA(MSBI-QLIKVIEW)
MANISH SHARMA(MSBI-QLIKVIEW)
manish sharma
Ìý
SQL Server (BI/T-SQL) Consultant
SQL Server (BI/T-SQL) Consultant SQL Server (BI/T-SQL) Consultant
SQL Server (BI/T-SQL) Consultant
Rajabpdev
Ìý
NiveditaResumeDBA
NiveditaResumeDBA NiveditaResumeDBA
NiveditaResumeDBA
Nivedita Alure
Ìý
Tx 09 G3 Jayasri Santhappan
Tx 09 G3 Jayasri SanthappanTx 09 G3 Jayasri Santhappan
Tx 09 G3 Jayasri Santhappan
jayasrisan
Ìý
Professional Portfolio
Professional PortfolioProfessional Portfolio
Professional Portfolio
MoniqueO Opris
Ìý
Resume of Pritam Das
Resume of Pritam DasResume of Pritam Das
Resume of Pritam Das
Pritam Das
Ìý
Business Intelligence Dev. Portfolio
Business Intelligence Dev. PortfolioBusiness Intelligence Dev. Portfolio
Business Intelligence Dev. Portfolio
Vincent Gaines
Ìý
shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017shun(Michael)_Liang_Resume_2-1-2017
shun(Michael)_Liang_Resume_2-1-2017
MICHAEL LIANG
Ìý

VASU

  • 1. SRINIVASARAO.G E-Mail:srinivasgmsbi11@gmail.com Mobile-No: +91-9620606350 PROFESSIONAL SUMMARY: 3+years of experience in Data warehousing and Business Intelligence Domain. Good experience with SQL Server 2008/2012, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services). Expertise on writing Queries, Sub Queries and Joins. Good knowledge on Data warehousing Concepts Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP and normalizations. Expertise in writing Stored Procedures and Functions. Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database. Experience in creating Jobs, Alerts, SQL Agent, and Scheduled SSIS Packages Experience on SSRS 2008 and SSIS 2008. Expertise in designing reports like Cascading reports, sub reports and dashboards. Supported team in resolving SQL Reporting services and ETL related issues. TECHNICAL SKILLS: BI Tools : SSIS, SSRS, T-Sql. Operating Systems : Windows 7/8/10. DBMS : SQL Server 2008/2012, ORACLE PROFESSIONAL EXPERIENCE: Working as a Data Warehouse Developer and Software Engineer in ITC Infotech India Ltd. Bangalore. EDUCATION: Master of Computer Applications [MCA] from JNTU University, Hyderabad. PROJECT DETAILS: PROJECT #2: Project : Trade Marketing and Distribution Client : ITC Limited Role : Associate IT Consultant Team size : 9
  • 2. DESCRIPTION: ITC TM&D (Trade Marketing & Distribution) vertical is interested in designing and implementing a Performance Evaluation and Reward System for its Sales force. The system scope will include its front Area Executives sales force. The performance evaluation of the AE’s will be done basis the channel they are aligned to Implement an End to End solution which will automate the entire score computation process. Computes payout basis the bands in which the scores lies and provides an output on the payout to the salary department on a quarterly basis. RESPONSIBILITIES: Creating Jobs by using SQL Server Agent and Scheduled SSIS Packages Writing Stored Procedures, Functions and Joins. Insert data from database using bulk insert. Creating packages at SQL Server Integration Service platform. Created SSIS packages for data Importing, Cleansing etc. Extracted, cleaned and validated Loaded the data from Excel and Flat files. Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task Creating SSIS Configurations. Create SCD in SSIS. Export cleaned data from Excel sheets, Text file, MS Access and CSV files to data warehouse. Created ad-hoc reports, drill down, and drill through reports. Creating reports by using SSRS 2008. Created in designing reports like Cascading reports, sub reports and dashboards. Involved in deploying reports. Generated the Reports Weekly and Monthly wise as per the Client Requirements. ENVIRONMENT: Windows 2007 , SQL Server 2008 Integration Services, T-sql, SQL Server Reporting Services 2005 & 2008. PROJECT #1: Project : PROMAXTRADE PROMOTION Client : ITC Limited Role : Date Warehouse Developer Team size : 5
  • 3. DESCRIPTION: Promax Trade Promotion is a Australian trading project having nearly 40 clients. Data is coming from Promax Application of different customers where we are designing and developing Packages in order to load whole data of the customers and supporting to the customer reporting and manipulating the reports according to customer requirement. Generating the sales summary, sales forecast and Order summary on weekly, monthly and quarterly reports. Supporting for customers issues. RESPONSIBILITIES: Creating packages at SQL Server Integration Service platform. Importing Source/Target tables from the respective databases by using FTP task in Control Tasks in SQL Server 2008 Integration services. Writing Stored Procedures and Functions. Creating SSIS Configurations. Creating Jobs by using SQL Server Agent. Created Event Handlers for the Packages Using Event Handler Tab. Used Control Flow Tasks as Execute SQL Task, Data Flow Task, and Execute Package Task, Send mail Task, Script Task and File System Task. Extensive knowledge on Report Manager Properties. Processing the cubes and building the package in SSIS to process the cubes. As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2008 Reporting Services. Involved in deploying reports. Creating reports by using SSRS 2008. Creating Drill down Reports, Sub reports, Drill through Reports. ENVIRONMENT: Windows 2007 , SQL Server 2008 Integration Services,T-sql, SQL Server Reporting Services 2005 &2008. G.SRINIVASARAO.