Home

Raju K - Power BI Developer

[email protected]

Location: Farmington, Michigan, USA

Relocation: Yes

Visa: Green Card

Around 9+ years of experience as MSBI / Power BI developer, database developer, and data analyst with Microsoft SQL Server 2016/2014/2012/2008 R2/2008/2005, SSIS/SSRS/SSAS, OLTP, OLAP (Different environments such as Production, UAT, and development) and MSBI/Power BI in various domains. Extensive experience with SQL Server Integration Services (SSIS) 2008/2008 R2/2012/2014 and 2016 Data Extraction, Transforming, and Loading (ETL). Expertise in Scheduling Database tasks - Jobs, Alerts, Emails, and Notifications. Experience in BI Development and Deployment of DTS, and SSIS packages from MS Access, Excel, Oracle, and Teradata. Advance data modeling using DAX, power query/edit query in Power BI desktop, and working with custom visuals. Involved in writing Java API for Amazon Lambda to manage some of the AWS services. Has very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server. Has experience on Denodo for Data Visualization and ETL Worked with the technical team and business users to analyze business requirements and translate them into technical specifications for ETL and reporting. Experience in the design and development of applications using .NET Framework, C#.NET, ADO.NET, LINQ, Visual Studio 2003/2005/2008, AJAX, SQL Server 2008, and UML. Experience in developing N-tier distributed .NET applications using Web Forms and WinForms. Good knowledge of .NET Framework features including Reflection and Metadata. Coordinated and participated in weekly estimation meetings to provide high-level estimates for backlog items. Power BI Tools Power BI desktop, power pivot, power query, power view, power map, Power BI dashboard, calculated columns, and calculated measures using DAX, data modeling. Experience in Object Oriented Design and Programming concepts in Java and Python Having experience in Agile Methodologies, Scrum stories, and sprints experience in a Python-based environment, along with data analytics, data wrangling, and Excel data extracts. Experience in developing and deploying a Microservice application utilizing almost all the AWS Stack including S3, EC2, DynamoDB, Kinesis, SNS, and SQS. Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub-queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, and Common table expressions (CTEs). Expert in integrating various data sources into Power BI and Qlik, including SQL databases, cloud services, and Excel. Experienced in client requirement Analysis, Logical and Physical design & development of a database (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support, and Maintenance of business applications using SQL Server 2012/2008R2/2005, DTS, SSIS, SSAS, and SSRS. Wrote scripts in Python for extracting data from HTML file. Utilize PyUnit, the Python Unit test framework, for all Python applications. Experience in Logging, Error handling using Event Handler, and Custom Logging for SSIS Packages. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block, and partial blocking Transformations. Implemented Copy activity and custom Azure Data Factory Pipeline Activities for On-cloud ETL processing. Periodic reporting is done daily, weekly, monthly, and quarterly, which helps the client by using the Reporting Services (SSRS), POWER BI. Hands-on experience in Azure Development worked on Azure web application, App services, Azure storage, Azure SQL Database, Virtual machines, Fabric controller, Azure AD, Azure search, and notification hub. Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT, and Dimension Tables using SQL Server Analysis Services. Experience in Azure DevOps, creating pipelines, and usage of ADLS Implemented User-Defined server roles in SQL Server 2019, default schemas for groups. Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs. Keywords: csharp business intelligence sthree active directory microsoft Colorado