Tarun Gupta

Senior Software Engineer with hands on experience in building delivering end to end Business Intelligence solutions using Microsoft Technologies.
Possessed strong knowledge in Microsoft Business Intelligence tools SSIS, SSAS, SSRS, PPS, Tabular Model, PowerPivot
Particularly interested in building Datamarts using ETL solutions and using SQL Server data tool suite.
Always interested in building Cubes using Tabular Model and SSAS, SSRS reports and dashboards using PPS.
Strong expertise in SQL Server 2008 R2 and SQL Server 2012 and has written complex SQL queries logic and stored procedures.
Good experience in configuring and deploying databases to production and staging environment.
Good exposure to Tableau software
Highly focused and has a post graduate in Master of Computer Applications from National Institute of Technology, Kurukshetra.

Job responsibilities:
• Requirements gathering and providing estimates for different BI modules
• Delivery of scalable and robust end to end BI solutions that includes designing, development and maintenance of Back-end (databases ETLs cubes), SSRS PPS, Powerpivot and Powerview reports
• Providing architecture of BI solution based on requirements
• Designing wire-frames in SSRS
• Introducing and conducting sessions on Performance Point Services
• Helping the team members in understanding of Microsoft BI stack (SSIS, SSAS, SSRS)
• Single point of contact for onsite team on ETL solutions
• Conducting code reviews
• Writing complex stored procedures
• Writing efficient SQL Queries
• Performance Optimization of SQL queries and tabular model solution


Few Initiatives:
Blog Link: http://ssisblog.wordpress.com/