Hari Krishna

Six years of IT experience as a Microsoft SQL Server developer, specializing in SSIS and SSRS using MSBI, SSDT, Power BI, and Power Apps. Proficiency in Microsoft BI Tools (SSIS/SSRS/SSAS) and T-SQL across various SQL Server versions. Advanced expertise in Oracle 11g for PL/SQL programming, focusing on Records, Collections, Bulk Bind, Ref. Cursors, Nested tables, and Dynamic SQL. Developed, designed, and supported interactive Tableau dashboards. Extensive experience in crafting Power BI Reports and Dashboards from diverse data sources using Data Blending techniques. Skilled in developing and debugging Stored Procedures and Triggers. Worked on various administration tasks, including data loading, batch jobs, IIS configuration, backup & recovery, Database mirroring, Log shipping, user/application table management, upgrades, and database partitioning. Proficient in using monitoring and tuning tools like MS SQL Profiler, Index Tuning Wizard, Pervasive, and Windows performance tools. Documented Dynamics 365 Migration and executed ETL on the cloud using Azure Data Factory. Generated Power BI Reports by identifying necessary Tables/Queries and extracting respective Columns to create Views in Dynamics 365 Business Central. Experience in using Row Transformations, Block, and Unblock Transformations for SSIS package performance tuning. Proficient in handling various types of Dirty Data from different sources. Hands-on experience with Logging and Error handling using Event Handlers pre and post for SSIS Packages. Expertise in Data Warehouse concepts, OLTP, OLAP, Star Schema, Snowflake Schema, Fact, and Dimension tables. Skilled in Data Cleansing techniques in ETL procedures. Capable of building and deploying multi-valued parameterized reports using Power BI and Tableau. Worked with Microsoft Power BI, Datazen, DAX expressions, Power View, and Power Query integrated with SharePoint. Created Paginated Reports using Power BI Report Builder. Excellent hands-on experience in creating groups, measures, and KPIs. Experienced in building Tabular Model Cubes from scratch in Databases with different Measures and Dimensions. Strong knowledge of Power Apps canvas apps & Power Automate Flows, customizing SharePoint list forms with Power Apps and Model Driven Apps. Experience in performance tuning, processing, and deploying cubes. Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.