Uploaded File
Srikanth
MSBI Developer
W2 Pittsburgh, PA
Available immediately
Actively seeking
Srikanth
171
views
MSBI Developer
3 recommendations
3
Recommendations
Average rating
171
Profile views
SSAS SQL Server SSIS Visual Studio SQL T-SQL .NET HTML Windows Server CSS
Remove Note
View Note
Recent Experience
MSBI Developer 09/15 - 10/16
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
MSBI Developer 03/15 - 09/15
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
Sr. MSBI Developer 09/14 - 01/15
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
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.

Top 5 Skills
SkillsProficiencyLast Used
SSAS
2016
SQL Server
2016
SSIS
2016
Visual Studio
2016
SQL
2016
Education and Certifications
Master's in Information Technology
International Institute of Information Techngology
Bachelor's in Information Technology
Kakatiya Institute of Technology and Science
Microsoft SQL Server 2012,
Querying Microsoft SQL Server,
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:No travel (0%)
Employment Type:Permanent
Security Clearance:No clearance
Citizenship:H-1B Visa