-
Over 7+ years of professional experience in working with projects driven on SQL Microsoft Business Intelligence tools, Data Warehousing and ETL processes.
-
Expert in T-SQL (DDL, DML): functions, views, triggers, cursors, stored procedures on SQL Server.
-
Experience in SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).
-
Experience with ETL processes, worked extensively on data extraction, data integration and loading from different data sources using SSIS.
-
Designed, developed and implemented various SSIS Packages and deployed using Deployment wizard.
-
Knowledge in Dimensional Data Modeling and analyze Data warehouse by building multidimensional cubes using SQL Server Analysis Services (SSAS).
-
Experience in writing MDX queries to access cubes data in SSAS.
-
Using Microsoft SQL Server to model datasets into datasets for business intelligence software.
-
Knowledge in optimization of cubes for better query performance.
-
Developing parameterized, linked, matrix, drill down and aggregation reports with various parameters and filters using SSRS.
-
Experience in creating Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries.
-
Extracted data from various sources like SQL Server 2008, Oracle, CSV, Excel and Text file from Client servers and through FTP.
-
Hands-on experience in BMC Control-M &TWS Scheduler tool for scheduling ETL/ELT Jobs and Unix Scripts.
-
Interactive data visualization products focused on business intelligence such as MICROSOFT POWER BI.
-
Extract and analyze data using PowerQuery, PivotTables, MS Excel, POWER BI and SSAS
-
Developed confidential proprietary analytical tools and reports with Microsoft Excel, and POWER Pivot, and POWER Point.
-
Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
-
knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
-
Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.
-
Publishing Power BI reports from Power BI Desktop to Power BI service.
-
Hands on experience in using version control software like VSS, Rational clear case and (TFS) Team Foundation Server, and Windows Performance Monitor for Monitoring and Tuning MS. SQL Server Performance.
