SUMMARY:

• More than 6+ years of experience in the field of Business Intelligence applications and Data Warehousing, as an ETL Developer with expertise in SQL Server Integration, Analysis and Reporting Services .
• Good at Data Warehouse techniques - Dimensional Data Modelling, Star Schema and Snowflake Schema.
• Experience in developing Stored Procedures, Views and Complex Queries on SQL Server.
• Experience in creating Cosmos jobs using SCOPE scripts in Data Studio to export data to Kusto.
• Experience in using Kusto queries.
• Expertise in using Cloud based managed services for data. warehousing/analytics in Microsoft Azure ( Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure Table Storage, U-SQL )
• Experience in creating multiple Power BI reports and Dashboards which are capable for generating deep analytical insights .

TECHNICAL SKILLS:

Languages: SQL, T-SQL, U-SQL, Kusto, Scope script and C# .NET, Java, PowerShell scripting and HQL

RBMS: SQL Server, Microsoft Azure Databases, MS Access, Oracle

Development Tools: SQL Server Management Studio, Kusto, SQL Query Analyzer, MS Visual Studio .NET, BIDS.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Transformation Services (DTS), Power BI (Power Pivot, Power Query, Power View), Power BI Service.

Azure: Cloud Services (PaaS & IaaS), Azure SQL Database (PaaS), Azure Storages (Blobs, Tables, Queues), Azure Data Factory, Azure Data Warehouse, PowerShell and Azure portal

Technical Environment: - ETES, DC Demand, MS POD

Configuration and Code Management: VSTS, TFS, ICM, Git/SourceTree and Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential

BI - Reporting Engineer

Responsibilities:

• Participate in meetings and discussions with Client to gather Business Requirements and System Specifications from Business Users.
• Constant process engagement with Execution Graph for successful and failed deployments during Cirrus runs.
• Developed Stored Procedures, Views and Complex Queries on Kusto and SQL Server.
• Created complex DAX calculations to support several teams in Azure Compute and in Azure-PIE with a variety of purposes that go from purely informational, for debugging, and for reporting.
• Designed Azure compete metrics with GCE and AWS.
• Created Power BI reports are utilized by development teams to identify VM development performance regression and to address the issue that caused the regressions.
• Created Power BI reports to identify the SLA Impact between week over week change and month over month changes to drive weekly and monthly status meeting across all stakeholders.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Prepared technical document through Wiki for all the reports.

Confidential

BI-Reporting Engineer

Responsibilities:

• C+AI readiness coverage using GDPR Power BI over 1800 cloud services and boxed products.
• Constant process engagement with 10+ engineering POCs working with across C+AI daily on GDPR compliance using Power BI.
• Created complex and diverse business-heavy DAX calculations to support GDPR power metrics with multiple aggregation levels using power BI and utilizing bi-directional filtering in tabular back-end.
• Data gateway design, administration and security setup, Publish power BI reports and schedule automated data fetch/refresh from the data sources for enterprise reporting architecture.
• Design, development and implementation of Automatic Notification delivery system based GDPR completeness using C#, Selenium framework.
• Involved in retrieving stale data and validate compliance with retention policy for 150 million + COSMOS streams.
• Drive GDPR Progress tracking meetings with teams and data stewards of the enterprise COSMOS Storage engine and deliver GDPR default retention policy implementation across Microsoft focusing 1.5 exabytes of COSMOS storage savings.
• Balanced approach towards continuous integration vs continuous deployment for enterprise Power BI architecture.
• Implementing ICM/TFS operations tickets into GDPR reporting platform using KUSTO/Excel plugins and auto-refresh setup.

Confidential, WA

BI-Reporting Engineer

Responsibilities:

• Providing reports to executives on post-launch metrics, Reporting, KPI's, scorecards, data integration, ad-hoc reports and performing analysis for master data issues, concession, end of life and sales.
• Maintain data integrity and validations for the revenue from each supplier and tracking the revenue spent by the Microsoft, also updated and manipulated report orientation and structures with the use of Pivot Tables and V-Lookups.
• Collaborate with BI-AZURE/SQL DB teams for Sales, SKU and Order data.
• Create multiple Power BI reports which are capable for generating analytical insights for sales and order data
• Provided technical operational reporting expertise to stakeholders to ensure all operational data are available to support business decisions.
• Created multiple kinds of Power BI Reports and Dashboards to represent data.
• Develop calculated measures using Data Analysis Expression language (DAX).
• Provide continued maintenance and development of bug fixes for the existing and new Power BI reports.
• Deploying and scheduling Periodic Reports to generate all daily, weekly, monthly and quarterly Reports including status.

Confidential, WA

BI Engineer (Azure Data Lake)

Responsibilities:

• Participate in meetings and discussions with Client to gather Business Requirements and System Specifications from Business Users.
• Create data integration and technical solutions for Azure Data Lake Analytics, Azure Data Lake Storage, Azure Data Factory, Azure SQL databases and Azure SQL Data Warehouse for providing analytics and reports for improving marketing strategies.
• Leverage Azure Blob storage accounts via PowerShell or azure storage explorer for storing the different types of data like Blob storage, Table storage, Queue storage and File storage.
• Create data bases (DWH-OLAP) based on the data required from OLTP to support analysis/report generation
• Created Input, Output data sets to Monitored the Pipeline and Data Slices for ADF life cycle.
• Worked on Azure scheduler to configure the Time Slices which will ensure the Schedule to run at specific time.
• Working on C# scripts for the data extraction in U-SQL.
• Worked on Coding, Code reviews Issue management and status reporting.
• Working with business and resolve ad-hoc queries.
• Created multiple kind of Power BI Reports and Dashboards to represent financial forecast data.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Technical Environment: T-SQL, U-SQL, C#, SSRS, SSIS, SSAS .

Configuration Tools: TFS/VSTS (for source code control)

Special Software: Azure SQL Database (PaaS), Azure Storages (Blobs, Tables, Queues), Azure Data Factory, Azure Data Warehouse, PowerShell, Azure portal.

RDBMS: SQL Server 2008 R2/ SQL Server 2012 and 2014 .

Confidential, WA

BI Developer

Responsibilities:

• Analyzed Mapping documents which included details of field to field mapping between sources and targets, Business (TRANSFORMATION) Rules, workflows, pre-dependencies, post dependencies, exception error processing methodology.
• Designed and developed Star Schema, Snow flake Schema and created Fact Tables and Dimension Tables for the Warehouse Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform and load jobs.
• Worked on Performance Tuning in SSIS packages by using Row Transformations, Block and Un-Block Transformations.
• Handled multiple feed file formats such as Delimited / Fixed Width flat files, Excel/CSV files, Variable data length (VDL) files.
• Performed SQL tuning and improve the speed of query running.
• Used MDX to query Analysis Service Databases, debugging and supported the purpose of data analysis .
• Working with business and resolve ad-hoc queries.
• Created reports from different data sources using SSRS.
• Developed meaningful reports to management using SQL Server Reporting Services (SSRS) and Excel Power Pivot.
• Analyzed and modified data using Power Pivot, created pivot tables and charts for presentation and decision-making purposes.
• Developed dashboards with SQL Server Reporting Services (SSRS) and Power BI and deployed dashboards onto SharePoint.

Technical Environment: T-SQL, SSIS, SSRS .

Special Software: SQL Server Management Studio, MS Visual Studio.NET, BIDS .

RDBMS: SQL Server 2008 R2/ 2012 .

Confidential, WA

Jr. MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Create scripts to do chucking and massaging of legacy data in staging area of SSIS packages.
• Used DTS migration wizard to convert DTS to SSIS packages and develop new SSIS packages.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Modified existing databases by adding/removing tables there by altering referential integrity, primary key constraints and relationships per requirements
• Created trace in SQL profiler and used database engine tuning advisor for performance tuning on stored procedures and Scripts.
• Worked on current information systems (Microsoft DAX, Microsoft SQL Server, Data Warehouse, VMI and others)
• Created CSV and excel files for data analyst for the records business need.
• Deployed reports to report manager and troubleshooting for any error occur in execution.
• Responsible for implementing robust disaster recovery plan.
• Worked on Data Modeling (Logical/Physical) with ER/Studio.
• Created several cubes in SSAS and build lot of MDX queries to query cubes and to access cube's data.
• Planning and scheduling backup strategy to ensure reliable backup.
• Involved created database maintenance plan for the performance of SQL server, which covers database integrity checks, update database statistics and re-indexing.
• Participated in testing during the UAT (QA testing). Mentored and monitored team development and status.

Technical Environment: T-SQL, SSIS, SSRS.

Special Software: SQL Server Management Studio, MS Visual Studio.NET, BIDS.

RDBMS: SQL Server 2008 R2.