Sam K. Email & Phone Number

Long Beach, California, Us

Experienced in leveraging and implementing "Data Driven solutions and its integrations usingAzure Data Factory Azure SynapseAzure DatalakeAzure StorageAzure SQL ServicesSnowflake, PowerBI, PowerApps and other services.,

Irving, Tx, Us

• Created look up tables and imported fact table from Oracle and designed the data model • Designed and documented the entire Architecture of Power bi Poc• Designed and Optimised SQL code in order to pull necessary columns and improve data loading• Created Cross- filter relationships, and maintained Row- Level Security for Embedding Power BI reports for Customers• Worked with Azure team to get necessary Permissions for Application to Access Reports• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS. • Designed and created data extracts, supporting SSRS, POWER BI, Tableau or other visualization tools reporting applications. • Created Navigation reports using Buttons, Bookmarks in Power BI Desktop.• Designed Pie charts, Bar charts, Trend charts in order to display three years of Historical data• Created complex DAX Queries in order to meet the business requirement of conditional hiding of data, created conditional columns and measures• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications.• Debugging SSIS packages, Performance tuning on Slowly running SSIS Packages.• Configure and maintain using Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager• Created Reports using Charts, Gauges, Tables, matrix.• Created SSIS Packages by using different data Transformations like Derived Column, Lookup, Data Conversion, Conditional Split, Pivot, Union all and Execute SQL Task to load data into Database.• Embedded Individual Tiles into Application and also worked on Embedding complete Report using Report ID• Enabled Query Caching in Power BI Service to meet SLA’s for Performance of the report

• Collaborated with Business team to gather requirements and analyse source data• Designed STAR Schema to maintain relationship between Fact and dimension tables• Utilized Power Query to make transformations like removing duplicates, data conversion, creating conditional column.• Implemented DAX to get KPI’s which depicts MOM changes.• Utilized Time Intelligence functions to calculate Year to Date sales, to get most recent month data • Migrated reports from Tableau to Power BI based on requirement• Analysed data in Source Database (Azure SQL Database) and wrote SQL Query to get necessary column and remove unnecessary data • Created VIEW’s in Azure SQL Database by writing complex T-SQL Queries to leverage data in the tables• Maintained live connection to Power BI Dataset and Online Services• Interact Actively with Business team to understand the expectations of End User and SLA’s• Responsible to Create SQL Query by Joining multiple Tables and Optimize SQL code in order to pull necessary columns and improve data loading • Utilized connectivity mode to Import Data into Power BI using Direct/ Import based on Table size, also created lookup tables to maintain Relationship• Create DAX functions for various fact calculations for efficient data visualization in Power BI• Utilized Data Analysis Expressions, created Measures and Calculated columns based on requirement• Designed Background Image of the report, maintained organizational font and colour code• Designed Line charts, Bar charts, Trend charts in order to display streaming sets of Time Intelligence data on daily basis• Utilized Power BI (Power View) to create various analytical reports that depicts critical KPIs such as Health assessment Percentages and Risk factors etc.• Responsible to Create Navigation Page using Buttons and Bookmarks feature in Power BI and design UI of the report as per SLA • Worked on Page level, report level And Visual level filters and used Slicers to best design UI for Users

• Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.• Actively involved in Normalization (3NF) and De-normalization of database.• Scheduled Jobs and Alerts using SQL Server Agent.• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.• Generated custom and parameterized reports using SSRS. • Utilized SSIS to get data from Source databases and to transform, data cleanse and loaded into Destination tables.• Created various visualizations like waterfall, funnel, matrix visualization, scatter plots, combo charts, gauges, cards and KPI. • Optimized SQL queries for improved performance and availability.• Ensured Data Recovery, Maintenance, Data Integrity and space requirements for physical Database.• Used query statements like sub queries, derived tables to insert the data depending on the requirement into the tables.

Master Of Computer Applications - Mca, Information Technology

Master Of Science - Ms, Microbiology, General

Bachelor Of Science - Bs, Microbiology, General