Chandra Shekar

2+ years of professional experience in IT as a Business Intelligence (BI) developer in building, customizing, and publishing using Microsoft Technologies like Microsoft Power BI, Power Apps, Power Automate, D365, SQL Server, SQL, SSRS, SSAS, SSIS, SSMS, Dataverse and Office 365 concepts and applications. Participated in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance. Utilized Python for data analysis tasks, including data cleansing, pre-processing, and modeling. Power Business Intelligence (BI) components such as Power BI Desktop, Power BI Service, Power BI Mobile apps, Power BI Gateways and Power BI Report builder were used for business needs. Expertise in scripting languages: SQL, PL/SQL, Python, VB Script, UML, and XML. Applied Python scripts in ETL processes for data extraction, transformation, and loading. Worked on Composite Model/ Mixed model for data modeling on different data sources. Expertise in using Power BI building blocks such as Visualizations, Datasets, Reports, dashboards, and Tiles. Strong Experience in integrating Power Apps, Power Automate/ Flow into Power BI. Created a Power App and embedded it into a Power BI report as a visual for users/ Consumers to interact with that visual within the Power BI report. Experience in using Data Analysis Expressions (DAX) for creating measures, calculated tables, and columns. Components like Power Query, Power Pivot and Power Views are used for the requirements and functionalities. Experienced in creating Ad Hoc reports, SSRS reports and Power BI reports for business needs. Worked with Azure Databricks to run Spark-Python Notebooks through ADF pipelines. Proficient in SQL Server Data Tools (SSDT) like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)and SQL Server Reporting Services (SSRS). Experienced in Extraction, Transformation and Loading (ETL) process for data extraction, loading and transformation from different data sources into Data Warehouse. Performed data engineering tasks using Python in Azure Synapse Apache Spark Pools. Worked on importing and exporting data from MS-Access Database and XML to SQL Server Database. Experience in T-SQL/ SQL Command types like DDL, DQL, DML, DCL, TCL, SQL joins, Tables, developing stored procedure, triggers, views, user defined functions, creating complex queries, indexes, and packages. Experienced in Relational Database Management Systems (RDBMS) including Normalization, Clustering, T-SQL, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors. Worked with business users, users for the issues and troubleshoot and help. Row-level Security (RLS) was used for restricting data access for users and good understanding of permissions, recovery, security, and monitoring. Experienced in Azure Cloud Services like Azure Active Director, Azure SQL Database, Azure Data Studio, Azure Data Factory (ADF), Azure DevOps Service. Strong knowledge and used Microsoft Product suite and Office 365 applications and concepts. Agile Methodology and principles are followed for project development and SDLC. Experience in using Version Control software like Team Foundation Server (TFS), JIRA, and GIT. There are no canned reports and business can pretty much slice and dice the data on adhoc basis. Expertise in using TFS, JIRA to open bugs, create tasks and user stories, initiate change requests. Worked as Tier 3 level Production Support Analyst and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 support team. Good Independent / team working skills and experience, excellent communication skills with very good customer handling capabilities. Proficient in Power BI Dashboards.