Description
Summary * 6 years of experience as Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments. * Extensive experience in database design, development and administration with MS SQL Server versions 2012/2008R2/2008/2005/2000 using SSIS, SSAS, SSRS (BI Tools) in various industries. * Communication & Management skills with Role playing capabilities. * Installation, Configuration and Updates of SQL Server. * Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert. * BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, and Oracle. * Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS. * User Privileges, Monitoring the Security and Audit issues as per Standards. * Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, Perlman and Spotlight. * Strong knowledge of Relational Database Management System (RDMS), creating and updating tables and checking database consistency by DBCC commands. * Hands on experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS) and creating OLAP cubes using SQL Server 2008 Analysis services (SSAS). * Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles. * Solving Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling. * SQL Server Storage Structures and Security Architecture for databases residing on SAN storage. * Programming Tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012 / 2014 with T-SQL. * SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process Models, E-R Diagrams. * Deploying and Consolidating Multiple Instances over Clustering Environment and Remote Installations. * Installation, Configuration and Deployment of SSRS using Scale-Out, Scale-Up and Local topologies. * Involved in migration of SSIS Packages 2012 SP1 CU5 and troubleshoot migration issues. * Providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages. * Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. * Generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View. * Proficiency in Developing SSASCubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects. * What-If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections. * Proactive Caching Degenerated Dimensions and Tabular Data Modeling for Moderate to Large Data Systems. * Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions. PROFESSIONAL SUMMARY
Accomplishments
Highlights:
Job Skills
Keywords
