Anilkumar A. Email & Phone Number

Glen Allen, Virginia, United States

• Develop efficient BI solutions by leveraging on-prem Microsoft BI stack, on-cloud Microsoft Azure services and the legacy on-prem reporting infrastructure hosted on Paginated Power Bi Reports.
• Create data models & datasets using Power BI Desktop, Power BI Report builder, SSRS and Cognos framework manager to leverage them for the development of reports, dashboards, scorecards, KPIs etc.
• Create reporting solutions on top of structured & unstructured data sourced from relational databases such as SQL Server etc.
• Architect and develop migration strategies and processes across different reporting platforms such as from Crystal Reports to Power BI.
• Schedule data loads from SQL tables to Azure SQL/SQL tables by using Azure Data factory.
• Leverage Power BI third party tools such as DAX Studio, debug and tune the queries and tabular data models.

Plainsboro, New Jersey, United States

Extensively Involved in creating Pipelines using Azure Data FactoryInvolved in Preparing Notebooks & Automation using Azure DatabricksUsed Kafka to Extract data from Custom Applications and loaded into Azure Data lakeExtensively used Azure data bricks and applied Machine learning Algorithms Used Polybase to load data into Azure SQL DWH from legacy.

Bengaluru, Karnataka, India

Involved in creating stored procedures, Functions and views for business needs.Worked on creating interactive reports and dashboards using custom visualizations and available Charts in Power BI.Involved in writing DAX in Microsoft Power BI Desktop.Involved in Creating Data Blending for merging different sources and Implemented Row Level Security in Power.

Chennai, Tamil Nadu, India

• Extracted data from various sources like SQL Server 2008 and Excel and loaded the data into Warehouse by performing different kinds of transformations using SSIS Packages.
• Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services & SQL Server 2008
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, Script Task and Lookup Transformation, Derived Column, conditional split and Merge and while loading the data into Destination.
• Experience on Custom Error Logging to Handle Errors and Debugging for the Packages
• Worked on Dimensional Data Modeling, Cube development and manipulations using SSAS
• Worked on Implementing Star Schema using Dimension and Fact Tables.

Chennai, Tamil Nadu, India

• Development using T-SQL in SQL Server 2000/2005, also involved in Requirement Analysis and Design Analysis of the Interface and Prepared Design Document.
• Unit Testing & Preparation of Test Case and Test Reports and Support to System Testing
• Wrote Scripts for Data loading and DDL Scripts.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Lifecycle.
• Extensively worked in writing SQL Queries (Sub queries and Join conditions, correlated subqueries).
• Wrote Stored Procedures, Functions, Views, and Triggers in SQL.