Professional Summary
- Over 6 years of Experience in SQL server databases and Data Loading and Reporting tools with SSIS, SSAS, SSRS, Power BI, SQL Server Integration Services (SSIS). - Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications. - Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes (Clustered and Non Clustered), Stored Procedures, Views, User Defined Functions, Cursors and Triggers. - Proficient in designing and deployment SSIS packages using various transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Conditional Split, Aggregate, Derived Column, Sort, Multi-Cast, Union, and Data Conversion Transformations. Experience in dealing with different source and target (like Oracle 11g, SQL Server 2008/2012, Hive, Tera Data, Cassandra, Sales Force,, CSV, flat file, Text Format Data) using different type of connection like (OLE DB, ODBC, ADO.Net). - Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management. Maintaining the Log and Audit information in SQL tables, - Experienced in providing Logging, Error Handling by using Event Handler for SSIS Packages Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions. - Hands on generating SSIS packages using Business Intelligence Markup Language (BIML) terminology. Experienced in developing Window Batch Script to execute SSIS package. - Configured Jobs using BMC product Control M 8.1. Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports Developing reports on SSRS on SQL Server. - Understanding of SSAS, OLAP cube and Architecture. Knowledge of Storage Modes (MOLAP, ROLAP and HOLAP) and processing Cubes using SSIS and SSMS. Experience in writing expressions in SSRS and Expert in fine tuning the reports. - Created many Drill through and Drill Down reports using SSRS. Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart. - Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. - Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX. Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects. - Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests. - Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. Knowledge of SFDC standard Data structures and familiarity with designing Custom Objects and Force.com platform and Force.com Sites. - Experienced in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs with SQL Server Agent, SQL Server Storage Structures, Index (Clustered and non-Clustered) and SQL Profiler. - As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.