SUMMARY

• 13+ years of experience in the full systems lifecycle including analysis, design, programming, testing, deployment and maintenance.
• 10+ years of hands on experience with SQL development in SQL Server 2012/2014/2016 , Azure SQL Databases. Azure Portal.
• Expertise in database design Entity relationship, Logic apps In Azure. Business Intelligence tools, Data Warehousing, SQL Reporting Services and ETL processes, SSAS Tabular Cubes.
• Experience in Big Data, Hadoop, JSON feeds, Cosmos, Scope, USQL, Clicks, Impressions, Bing Ad Search. Azure Cloud Databases platform as Service.
• Strong knowledge of .NET Technologies (C#), Python and Power Shell scripting.
• Strong business knowledge in IS systems. Experienced in SDLC, Agile and Scrum Project cycles.

TECHNICAL SKILLS

• T - SQL, MYSQL, DB2, MDX, Tabular Cubes, DAX Expressions, C#.NET, MS Cosmos and Scope, Tableau Desktop, Data Warehouse Star Schema, MS Access, MS Excel. Data Migration, Erwin Data Modeling, Data mapping, Team Foundation Server, Visual Studio, SQL SSRS, SQL SSAS, SQL SSIS, Alteryx ETL, Excel Pivot tables, Power Pivot for Reporting, Power BI office 365. Azure Data lake and Azure Data Factory.

PROFESSIONAL EXPERIENCE

DATA Architect

Confidential

Responsibilities:

• Responsible for designing logical and Physical Models of JMSwank different Business Domain like Inventory, Sales, finance and Customers based on ERP and CRM data feeds.
• Manage JMSwank Databases in Azure Cloud, VM's, ServiceTiers and Azure DTU and database resources.
• Responsible for designing ETL Process using SSIS for JM Swank Data feeds for Data warehouse and Data Cubes and Power BI reports. Data sources like AX, CRM and freight shipping software.
• Build all the logic using t-sql script, storeProcs, Views for Data warehouse based on business rules for costing, pricing, shipping and freight.
• Responsible for designing the Data warehouse using star schema model after pulling Data using SSIS ETL process, build relation using dimension and fact Kimball methodology.
• Build Analysis Services Cube using data warehouse model, build dimension, fact tables and derived measures.
• Design PowerBI dash boards, Reports pulling data from Datawarehouse and cube, Build reporting for sales, category management and Finance.
• Write Dax expression to build calculated columns and calculated measure for power bi visuals
• Regularly improve database performance by fine tuning queries, data models and cube structures using index, query plan and data partition.

SQL Developer

Confidential

Responsibilities:

• Responsible for designing and creating Data mart, set ETL process from CRM DB to Datamart with daily uploads.
• Design Star schema Data mart, entity relation, define keys and indexes. Create view and procs to get data ready for Cube and Power BI dashboard consumption.
• Build SSAS tabular cube, Measure, Data modeling within Tabular cube, DAX expression for custom measure
• Build Power BI dashboards in Power BI Service, set up gateways, users, Data Modeling in Power BI, create custom measure with Power BI using DAX Expression, create Calculated column and Calculated tables for Report consumption. Pareto charts, Visual Charts with graphs and running totals.
• Create an Azure Data Lake and Data Factory Store account and perform basic operations such as create folders, upload, and download data files, Create Azure Data lake Analytics account and run USQL Scripts to extract data.

BI Developer

Confidential

Responsibilities:

• Design Star schema and relational Data models based on reporting and Data cadence requirements and using Dimensional Modeling (Kimball Methodology).
• Responsible for migrating on premises DB to SQL Server Azure Cloud Services, Create Databases on SQL Azure, setting up firewalls, Create and manage SQL Azure databases, migrate current data bases to SQL Azure, set SQL input output feed in logic app.
• Responsible for converting excel Power pivot models into SSAS tabular cube, design tabular models, create DAX measure and model per Power Bi reporting requirements.
• Create ETL process using Alteryx to Extract, transform and load data from different pipelines like MS Sales and other MS application. Import and Export data sets out of SQL Server using Alteryx data containers.
• Responsible for creating, managing and importing data into SQL Azure Databases using Logic Apps. Create logic App work flows to export data out of SQL Azure Databases.
• Responsible for creating Store procs, view, table partition, index with Azure SQL DB to get data ready for reporting with correct business rules.
• Responsible for designing, building and maintaining metrics in Tableau desktop using data from SQL Azure DB and manipulating data in Tableau to finalized reports.

SQL /BI Developer

Confidential

Responsibilities:

• Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi-dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Created calculated Measures for dashboard KPI's using DAX and Direct Query, build custom attributes for dashboard slicers and other filters using DAX.
• Build Marketing Dashboards in agile iterative, incremental method without hard requirements and based on daily customer feedback.
• Import Data into Power BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in Power BI to generate Marketing Campaigns metrics.
• Design Percentage, Month over Month and Year over Year measures after importing data into Power BI desktop using DAX and Power Query functions. Slice measure in Power BI tile using calculated Dimension fields in Power BI.

SQL/Report Developer

Confidential

Responsibilities:

• Responsible for Data migration from legacy CRM to Microsoft Dynamic AX, work with Analyst consultant and design script based on AX requirements to migrate legacy data. Design ETL process from to migrate data among MYSQL, Quick Books and SQL Server.
• Developed Reporting Dash board based on Microsoft dynamics AX Database tables. Developed mapping between Legacy CRM and MS Dynamics AX tables for financial and Inventory reporting.
• Developed reports out of MS Dynamics Back end tables, Design Schema using MS Dynamics AX tables for planning, Sales and Finance.
• Responsible for Designing Data warehouse and SSRS Reporting System for Confidential Financial and Inventory Data based on MS Dynamics back end Databases.
• Design Logical and Physical Model for OLTP and OLAP Databases. Design star schema ware house, create SQL Server Analysis Services Cubes and SSRS reports after SQL server 2005 migration.
• Responsible for all ETL operations including vendor feeds, warehouse loads, and data extraction.
• Design Database Schemas and normalize them with 3rd and 4th Normal form to build SSRS Report out of it.
• Develop T-SQL code to implement Confidential Business rules and logic through stored procedure, views and table value Functions.
• Created drill through, drill down, Sub, Parameterized and linked SSRS Reports from Analysis Service Cube and Stored procedures from the Data warehouse.

SQL Developer

Confidential

Responsibilities:

• Created Reports and Dashboards in SSRS, MS Focus, Power Pivot, Power BI and other BI tools for Sales and Services Division of Microsoft.
• Developed Stored Procedure, User defined function and Views for SSRS Reports• Developed several detail and summary reports including Multi value and Drill Down, trend analysis reports and sub- reports according to business requirements using SQL Server Reporting Services•
• Write Microsoft Cosmos, Scope Scripts to extract Click and impression information from MS AD Center Clusters.
• Embed SSRS 2008 Report in ASP.NET and C# using Report Viewer control.
• Developed ETL process to import Data from OLTP Databases into OLAP Databases. Transform data into Data ware house according to Business Rules and Hierarchies.
• Responsible for Yahoo Migration Project for Bing ads, manage, code and track Migration Projects KPI for Executive team.

SQL/Report Developer

Confidential

Responsibilities:

• Responsible for Designing Data warehouse and SSRS Reporting System for Confidential Financial and Inventory Data.
• Design Logical and Physical Model for OLTP and OLAP Databases. Design star schema ware house, create SQL Server Analysis Services Cubes and SSRS reports after SQL server 2005 migration.
• Install, Configure, Develop and deliver dynamic reporting solutions using SSRS.
• Created drill through, drill down, Sub, Parameterized and linked SSRS Reports from Analysis Service Cube and Stored procedures from the Data warehouse.
• Responsible for upgrading Database Management System from SQL Server 2000 to SQL Server 2005.
• Responsible for Capacity planning and monitoring database growth, performance issues on production servers. Search performance bottlenecks or perform other monitoring tasks using SQL Server Profiler.