Srikanth
s.devunuri@gmail.com
732-429-3934
Pittsburgh, PA 15122
MSBI Developer
12 years experience W2
3
Recommendations
Average rating
382
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
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