Vaibhav Aita

SQL Server Developer

Verisk Analytics, Inc.

July 2014 to Actually working here

? 7+ years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, UAT and Production Environment).
? Strong technical knowledge in MS SQL Server development including SSIS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
? Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
? In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
? Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
? Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
? Experience in creating dashboards, scorecards and building reports using performance point server 2007.
? SQL Server 2005/2008R2/2012 RDBMS database(green plumb) development including T-SQL programming.
? SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
? ETL implementation using SQL Server Integration Services (SSIS).
? Developing reports on SSAS & SSRS on SQL Server (2008R2/2012). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
? Expert in creating the MDX cubes and dimensions. (SSAS)
? Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well verse in ERWIN
? Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
? Thorough understanding of Kimball?s? theory, KPIs, SQL 2005 Architecture.
? Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
? Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
? Knowledge in creating web applications using ASP.Net, AJAX, XML, HTML, DHTML, JavaScript and CSS (Cascading Style Sheets).
? Managing various applications like Financials Accounts, Inventory Control System and Payroll & Personnel Administration System.
? Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
? Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
? Involved in DBA activities such as backups, restores, replication etc.
? Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
? Worked with the data architect to migrate legacy data into the new analysis data mart and created reports for inventory report module.
? Excellent communication skills, analytical skills, understand business requirements in various domains.

Career Goals

Industries of interest

Areas of interest

Availability to travel and work outside the city

No

Interests and hobbies