Uploaded File
Srikanth
s.devunuri@gmail.com
732-429-3934
Pittsburgh, PA 15122
MSBI Developer
9 years experience W2
3
Recommendations
Average rating
285
Profile views
Summary

  • 7+ years of experience as Software developer
  • MCSE certified professional with 4+ years of experience as Microsoft Business Intelligence applications lead Developer in software analysis, requirement, design, application development, testing and support
  • Expertise in ETL Developer using SQL Server Integration Services 2008 and 2012
  • Hands on experience on T-SQL, PL SQL, SSIS, SSAS, SSRS, MDX, DAX, Power Pivot and Power View reports
  • Having knowledge on SharePoint, CSS, JavaScript, HTML5, .Net, C#, Java
  • Over 4+ years of extensive experience on MSBI tools with strong business understanding and knowledge of Extraction, Transformation and Loading of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, SQL Server.
  • Worked on Oracle 11g installed in Oracle Exadata
  • Created various OBIEE dashboards
  • Used Atomic UC4 tool for automation process and error logging
  • Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins
  • Proficient in creating T SQL (DML, DDL, DCL and TCL), Indexes, Views, Temporally Tables, Table Variables, Complex Stored Procedures, System and User Defined Functions.
  • Knowledge on big data technologies, Hadoop, Pig, Hive, Map Reduce, Spark, Sqoop
  • Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings. Hands on experience in optimizing SQL scripts and improving performance in loading warehouse
  • Experience in Optimizing the Performance of SQL scripts and database/application tuning.
  • Expert in creating Calculated Measures and Dimension Members using Multi-dimensional Expression (MDX), Mathematical Formulas, and User-defined functions.
  • Experience in scheduling ETL jobs using SQL Server Agent, Atomic and Windows task scheduler
  • Worked with Dimensional Data warehouses in Star and Snowflake Schema's, created slowly changing (SCD) Type1/2/3 dimension mappings.
  • Experience in writing Power Shell scripts for automatic deployment of databases and packages to SQL Server Catalogs
  • Good experience in performing and supporting Unit testing, System Integration testing (SIT), UAT and production support for issues raised by application users.
  • Diverse background with fast Learning and creative Analytical abilities with good Technical, Communication and Interpersonal skills
  • Familiar with Agile development and waterfall methodologies.
  • Conceptually strong with an innovative and analytical approach to the work with an eye for detail. Enriched with the ability to learn new concepts & technology within a short span of time.
  • An effective team player with exceptional planning and execution skills, outstanding communication skills, verbal as well as written coupled with exceptional presentation skills with the ability to perform above expectations.

Experience
MSBI Developer
Retail
Sep 2015 - Oct 2016

Description

Giant Eagle is a supermarket chain with stores in the U.S. states of Pennsylvania, Ohio, West Virginia, Indiana and Maryland. We manage complete retail sales information of all independent and corporate stores of Giant Eagle. We process the data, and generate/ develop various kind of reports as per business needs

Responsibilities

  • Involve in software development Life cycle (SDLC) and participated in scrum meetings with team
  • Involve in requirement gathering and calls with clients
  • Communicate to business users on sprint basis for development update and confirmations
  • Develop Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
  • Developed complex SSIS packages for data retrieval and cube processing automation
  • Deployed SSIS packages to Automic UC4 tool, for automation and scheduling
  • Create DAX and VB scripts for Excel reporting and calculated members
  • Use SSIS for data processing on daily basis and automation
  • Create tabular SSAS cubes for fast retrieval of data
  • Extensive usage of SQL Profiler and Analytics for query optimization and maintenance
  • Understand legacy OBIEE reports, and coming up with data points
  • Re write complete legacy OBIEE reports in new technology using PowerPivot and tabular models
  • Created multiple SSRS reports
  • Create test and verification documents
  • Create understanding and guidelines documents for business users
  • Complete deployment to production and verification
  • Use Microsoft Team Foundation Server for maintaining code
  • Use SharePoint for maintaining reports, documents and project details

Operating System Windows 7 Enterprise

Languages T SQL, SQL Server 2012, SSIS, SSAS, SSRS, Oracle 11g, Oracle Exadata, SharePoint, Tabular, Excel PowerPivot

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler, Atomic UC4, Oracle SQL Developer

T-SQL SQL Server SSIS SSAS SSRS Exadata Visual Studio MS SharePoint SQL SDLC OBIEE Scrum Microsoft Excel SSAS CUbe Requirements Gathering Data Analysis Oracle Analytics MS TFS SQL Developer Ember.JS Visual Basic Windows
Remove Skill
References
Average Rating

2 recommendations
MSBI Developer
Information Technology
Mar 2015 - Sep 2015

Description

DRAW is a centralized repository that provides key stakeholders with the tools for strategic data-driven decision making. Its primary goal is to drive operational analysis for all digital display campaigns.

Responsibilities

  • Involved in architecture changes, and introduced SQL 2012 and its usage
  • Migrated SQL 2008 databases, SSIS packages to SQL 2012
  • Created PowerShell script, to automate deployment of databases, SSIS packages to 2012 servers
  • Developed C# tool to update and populate destination tables schema coming from Excel files
  • Involved in requirement gathering and calls with clients
  • Communicate to client on sprint basis for development update and confirmations
  • Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
  • Created DAX and VB scripts for Excel reporting and calculated members
  • Used SSIS extensively for data loading with different source and destination connections
  • Used various transformations like UNION, MERGE, LOOKUP, CONVERSION, DERIVED COLUMN, AGGREGATIONS
  • Used SFTP components in fetching files from FTP servers
  • Wrote PowerShell script for downloading and archiving files from FTP server
  • Created tabular SSAS cubes for fast retrieval of data
  • Created perspectives in tabular SSAS cube
  • Created roles in tabular SSAS cube for security
  • Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load.
  • Designed Sources to Targets mappings from Excel files to SQL
  • Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
  • Wrote test plans and executed it at Unit testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
  • Identifying and documenting the technical issues and the approach to resolve the same.
  • Followed agile project methodology to discuss with team every day, and with client on sprint basis

Operating System Windows 7

Languages T SQL, SQL Server 2008 R2, SQL Server 2012, MSBI Tools, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL

T-SQL SQL Server SQL Visual Studio SSAS SSAS CUbe SSIS PowerShell C# Test Planning System Testing Unit Testing Agile Methodology FTP Analysis .NET Production Support SSMS Data Analysis Visual Basic MS TFS Data Profiling Windows
Remove Skill
References
Average Rating

1 recommendation
Sr. MSBI Developer
Information Technology
Sep 2014 - Jan 2015

Description

Cloud and Enterprise system is for reporting and analyzing views and clicks information of sites and its url's

Developed different kind charts to analyze views, visits and clicks w.r.t. various sections like end actions, locale, country and site

Responsibilities

  • Lead a team of 3 people, and interacted with client every day
  • Developed Excel PowerView and PowerPivot reports for data analysis
  • Involved in requirement gathering and calls with clients
  • Created Coded UI solutions for daily refreshing of Excel files from source
  • Scheduled Coded UI solutions from windows task scheduler
  • Involved in complete understanding of business requirement and involved in analyzing, Data profiling the sources to load.
  • Designed Sources to Targets mappings from Excel files to SQL using SSIS
  • Responsible for developing complex transformation mappings using different types of transformations like UNION transformation, Connected and Unconnected LOOKUP transformations, and Update strategy transformations for large volumes of Datasets.
  • Implemented slowly changing dimension Type 1 and Type 2
  • Responsible for Defining Mapping parameters and variables and Session parameters according to the requirements and performance related issues.
  • Wrote test plans and executed it at UNIT testing and also supported for system testing, volume testing and User testing. Also provided production support by monitoring the processes running daily
  • Developed tabular models for Excel PowerPivot reporting
  • Created stored procedures as per business logic to populate mart
  • Created dimensions and facts based on star schema
  • Extensive usage of SQL Profiler and Analytics for query optimization and maintenance
  • Created multidimensional cube with dimensions and facts for PowerView reports
  • Created Reporting database from mart which contains separate tables as per chart needs
  • Worked on handling performance issues, Troubleshooting of Mappings, evaluating current logic for tuning possibilities.
  • Identifying and documenting the technical issues and the approach to resolve the same.

Operating System Windows 8, Windows Server 2012 R2

Languages T SQL, SQL Server 2012, MSBI Tools, HTML5, CSS, JavaScript, .Net

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL

T-SQL SQL SQL Server CSS HTML JavaScript .NET Visual Studio UI SSIS Unit Testing System Testing Test Planning Windows Server Stored Procedure SSMS Dimensions Star Schema Data Marts Performance Tuning Microsoft Excel Business Requirements Data Analysis Data Profiling Windows
Remove Skill
Sr. MSBI Developer
Information Technology
Dec 2013 - Aug 2014

Responsibilities

  • Analyzed requirements, suggested new implementation processes
  • Followed Agile methodology in project delivery
  • Worked on all aspects of MSBI (SSIS, SSAS) , Power pivot, Power view
  • Developed tabular models with star schema
  • Involved in performance tuning of tabular models
  • Worked on UI technologies .Net, SharePoint, HTML, JavaScipt and CSS
  • Communicating with the client for collecting the requirement, document them, implementation the same.
  • Identifying and documenting the technical issues and the approach to resolve the same.
  • Migrated databases

Operating System Windows 7, Windows Server 2008

Languages T SQL, SQL Server 2008 R2, MSBI Tools, HTML, CSS, JavaScript, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio

T-SQL SQL Server SQL HTML CSS .NET JavaScript Visual Studio MS SharePoint SSAS SSIS Windows Server Agile Methodology Star Schema Windows Performance Tuning SSMS UI
Remove Skill
MSBI Developer
Information Technology
Jul 2012 - Nov 2013

Description

Objective of this stream is to develop dashboard/ reports requested by different subsidiaries of stake holders. This involves creation of data mart from different data sources and development of reports on top of it

Responsibilities

  • Worked on all aspects of MSBI (SSIS, SSAS) , Power pivot
  • Implemented Cube Security, ETL mails
  • Created tabular models with dynamic partitions
  • Responsible for supporting the project for various BR’s and CR’s
  • Communicating with the client for collecting the requirement, document them, implementation the same.
  • Identifying and documenting the technical issues and the approach to resolve the same.
  • Scheduled daily refresh jobs from SQL Server agent, and provided support in case off ETL failure
  • Synced up with source teams regularly and fixed ETL issues
  • Provided support to down streams regularly who are using reports
  • Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
  • Wrote Stored Procedures and functions.
  • Involved in Performance Tuning.
  • Unit tested the packages.

Operating System Windows 7, Windows Server 2008

Languages T-SQL, SQL Server 2008/2008R2, SSIS, SSAS, MDX, HTML5, CSS, JavaScript, .NET

Software Visual Studio, Team Foundation Server, SQL Server Management Studio, SQL Profiler

T-SQL SQL SQL Server SSIS SSAS HTML CSS .NET JavaScript Visual Studio ETL Stored Procedure Performance Tuning Windows Server MDX SSMS Data Marts Dimensions Windows
Remove Skill
MS SQL Server Developer
Information Technology
Jan 2012 - Jun 2012

Responsibilities

  • Worked on all aspects of MSBI (SSIS, SSAS), Power pivot
  • Supported tabular models, and fixed issues related to column mappings
  • Involved in end to end system development and design of the project
  • Provided solutions to automate ETL
  • Supporting the in project set up and meeting if needed
  • Identifying the issues and trying to resolve them

Operating System Windows 7

Languages T SQL, SQL Server 2008, SSIS, Excel PowerPivot

Software Visual Studio, Team Foundation Server, SQL Server Management Studio

ETL T-SQL SQL Server SQL SSAS SSIS SSMS Visual Studio SQL Server Developer Database Design Microsoft Excel Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Information Technology
International Institute of Information Techngology
Bachelor's in Information Technology
Kakatiya Institute of Technology and Science
Certifications
Microsoft SQL Server 2012
Querying Microsoft SQL Server
461
Microsoft SQL Server 2012
Administering Microsoft SQL Server
Databases (70-462)
Microsoft SQL Server 2012
Implementing a Data Warehouse with Microsoft SQL Server
463
Microsoft SQL Server 2012
Implementing a Data Models and Reports with Microsoft SQL Server
466
Microsoft SQL Server 2012
Designing Business Intelligence Solutions with Microsoft SQL Server
467
Programming in HTML5 with JavaScript and CSS3 (70-480)
Microsoft SQL Server 2008
Database Development (70-433)
Microsoft SQL Server 2008
Skills
SQL
2016
4
SQL Server
2016
4
SSAS
2016
4
SSIS
2016
4
T-SQL
2016
4
Visual Studio
2016
4
SSMS
2015
3
Windows
2016
3
.NET
2015
2
CSS
2015
2
HTML
2015
2
JavaScript
2015
2
Performance Tuning
2015
2
Windows Server
2015
2
Agile Methodology
2015
1
Analytics
2016
1
Data Analysis
2016
1
Data Marts
2015
1
Dimensions
2015
1
Ember.JS
2016
1
ETL
2013
1
Exadata
2016
1
MDX
2013
1
Microsoft Excel
2016
1
MS SharePoint
2016
1
MS TFS
2016
1
OBIEE
2016
1
Oracle
2016
1
Requirements Gathering
2016
1
Scrum
2016
1
SDLC
2016
1
SQL Developer
2016
1
SSAS CUbe
2016
1
SSRS
2016
1
Star Schema
2015
1
Stored Procedure
2015
1
UI
2015
1
Visual Basic
2016
1
Analysis
2015
1
Application Development
0
1
Approach
0
1
AWS S3
0
1
Axure
0
1
Big Data
0
1
Business Intelligence
0
1
Business Requirements
2015
1
C#
2015
1
Data Profiling
2015
1
Data Warehousing
0
1
Database Design
2012
1
ETL Developer
0
1
FTP
2015
1
Hadoop
0
1
Hive
0
1
Java
0
1
MapReduce
0
1
Oracle 11i
2016
1
Pig
0
1
PL/SQL
0
1
PowerShell
2015
1
Production Support
2015
1
Shell Scripts
0
1
Snowflake
0
1
SQL Server Developer
2012
1
System Testing
2015
1
Test Planning
2015
1
Unit Testing
2015
1
Waterfall
0
1
WebServices
0
1
XML
0
1