Shashi Bhushan

Experience

• 

  Keane india

  Jul 2009 - Jan 2012

  Sse
• 

  Infosys

  Feb 2012 - now

  Technical Lead

  Summary:•Microsoft Certified Technology Specialist with around 6 years of experience working with Business Intelligence Tools MSBI (SSIS, SSRS & SSAS) ,Power BI and SQL Server Management Studio.•Extensively worked on developing ETL’s using SSIS & developing reports using SSRS in Business Intelligence Development Studio.•Experience in implementation of Data Warehouse using MSBI technology.•Good experience of SSIS Software Development Life Cycle (MSF Agile) and Integration Services Engine.•Extensive experience in MS SQL Server 2012/2008R2/2005, SQL Server Integration Services, SQL Server Reporting Services.•Experience working on Visual Studio Team System implementing the concepts of Versioning and Source Code Control.•Experience of troubleshooting ETL Packages for performance and error handling in SSIS Event Handlers.•Expert in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL Server. •Expert in developing SSIS Packages to extract, transform and load (ETL)/DTS data into the data warehouse database from heterogeneous databases such as Oracle 8i, DB2.•Good exposure in Created Reports, Sub reports, Drill Through reports, Customized Reports, Charts, Graphs. Report Model and Report Builder.•Experience in cube creation using SSAS and creating ad hoc reports using ProClarity.•Used TFS (Team Foundation Server) as Application configuration management tool.Certifications:70 448 Microsoft SQL Server 2008, Business Intelligence Development and Maintenance.70 432 Microsoft SQL Server 2008, Implementation and Maintenance.70 461 Querying Microsoft SQL Server 2012.Microsoft certified Solution Associate.OthersETL Tool : SSIS 2005/2008,Informatica 8.5(6 Months Exp.)Reporting Tool : SSRS 2005/2008,Crystal Report, SAP Webintelligence Report,PowerBIAnalysis Tool : SSAS 2008(6 Months Exp.)Reporting Tool :ProClarityfor ad hoc reportingDatabases : SQL Server 2005/2008 Show less