Sid Dar Email & Phone Number

Pembroke, Hamilton, Bm

• Involved in developing and designing Dashboards using Power BI to show KPI in the project.• According to client requirements, generated reports like Tabular Reports, Sub Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS).• Developed and rendered monthly, weekly and Daily reports as per the requirement and gaveRoles, user access with respect to security in report manager.• Created OLAP cubes, facts and dimensions for the analysis of sales in different locations andProcess data from data mart using SSAS.• Involved in building the dimensions, cubes with star schema and snow flake schema using SSAS.• Developed Tabular Model infrastructure in SSAS for various Lines of Business and createdOver different interactive Dashboards using various visualizations in Power BI Desktop.• Created multiple dimensions, perspectives, hierarchies, and dynamic measures (DAX) to analyze performances of each KPI.• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSASDatabase.• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database. • Created designs and process flow on to how standardize Power BI Dashboards to meet theRequirements of the business.• Involved in the Unit testing, Quality Assurance testing and User Approval testing of Power BI reports and modifying the code accordingly to match user’s business requirements.• Used different types of visualization Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.

• Defined source data columns and its respective mapping with target based in consultation with data modeler and application developers.• Identified data quality and data cleansing tasks based on review of data and data model.• Created stored procedures, views and user defined functions using T-SQL to insert data in target databases.• Designed SSIS flow to pull source data into staging to perform data quality and cleansing before pushing into target database using SSIS 2012.• Created SSIS packages for loading and transferring data using Sequence Containers, Execute SQL Task with T-SQL Stored Procedures and Data flow task in Control flow.• Applied various transformations in data flow tasks like Conditional split, Lookup, Row count, Merge, Merge join, Union, Audit etc. and performed unit testing.• Implemented exception handling using event handlers in SSIS 2012 and identified critical exceptions to be notified and logged in database.• Created ETL jobs using SQL Server Agent.• Loaded transformed data into data warehouse which was having Star-Schema.• Designed and developed parameterized reports, Excel reports with drill-down and multi-drilldown, dashboard reports using SSRS 2012 with data source as SSAS 2012 for claims for Mobile Insurance based on geographical locations.• Designed MDX queries to extract data from the cubes for reporting.• Scheduled monthly, weekly, and daily reports to run automatically on dashboard.• Maintained traceability matrix and participated in providing demos to business for feedback.• Created functions, CTEs and Update queries using T-SQL to pull data from staging to Data warehouse.

Raleigh, North Carolina, Us

• Analyzed the specifications provided by the client and gathered the requirements for design and development Designed, developed and deployed Business Intelligence solutions using SSIS and SSRS• Wrote complex SQL queries using Joins and Sub queries and Functions to retrieve data from data sources.• Extracted data from internal data warehouse system to SSRS Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.• Created ETL packages using SSIS to move data from various heterogeneous data sources.• Created packages with different Control Flow options and Data Flow Transformations such as Conditional Split, Multicast, Pivot, Union All etc. • Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures. • Designed and developed stored procedures, queries and views necessary to support SSRS reports.• Created datasets for reports using T-SQL and stored procedures. • Designed and deployed reports with Drill Down, Drill Through and Drop-down menu option pdf reports. • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. • Created standard report Subscriptions and Data Driven Report Subscriptions • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

• Analyzed & designed the business rules for data cleansing that are required by the OLAP and OLTP databases. Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, flat file, Text Format Data.• Designed High-level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.• Deployed generated reports of each quarter onto the Report Server to access it through a browser.• Created various geographical and time dimension reports for the fiscal year, quarter month, week and daily reports for all domains and published through Report Server.• Created various reports by comparing the growth of sales based on each quarter by using bar charts.• Worked as a developer in creating Complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications.

In

• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective. • Worked with DDL, DML, and DQL in T-SQL using CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, FROM, WHERE, ORDER BY, and GROUP BY. • Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL code in MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) effective. • Responsible for the quick response of SQL statement and connectivity from front application to the database servers. • Created SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. • Created SSIS packages to populate data from various data sources. • Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.