Rohit K

• Used Power BI, Power Pivot, and Power View to construct data analysis prototypes and used Power Map and Power View to illustrate results.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel.
• Created complicated T-SQL queries, stored procedures, and SSIS packages and maintaining/modifying them to load data into a warehouse.
• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Developed ETL packages with the different sources as Flat Files, Excel, Text files, and XML files and migrating the data into destination using SQL Server Integration Services (SSIS).
• Collaborated with key internal and external stakeholdersto gather and analyze needs and requirements to design and implement robust analytic solutions to support the identified needs.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groupsand KPIs to analyze performance of Strategic Business Units as well as corporate centers.
• Worked on Logical modeling using the Dimensional Modellingtechniques such as Star Schema and Snow Flake Schema
• Created custom calculated measures using Power BI DAX language to meet the business needs. Published Power BI Desktop reports created in Report view to the Power BI service.
• Used for optimizing queries which take longer time in execution with SQL Server 2016/2012.
• Developed Reports, Sub Reports, Parameterized reports, drilldown reports and various features using SQL Server Reporting Services (SSRS).
• Installed and Configured Enterprise Gateway and Personal Gatewayin Power Bi Services.
• Developed Data Source, Data Source View to create a logical view of the data to beplaced in OLAP Cubesusing SQL Server Analysis Services (SSAS) projects.
• Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Used incredibly complex, sophisticated SQL queriesthat supplied Tableau visuals, large data sets were extracted from the Hive data warehouse.
• Used SQL, Python, and PySpark, worked Data bricks notebooks were generated, and automated notebooks were made using tasks.
• Worked on track record of modifying Jira projects with a wide range of schemes, complex processes, flows, authorization schemes, and notification schemes.
• Actively applied Agile Methodology practices for development of the Microsoft reporting environment.

Environment: Power BI, SQL Server 2016/2012, MS SQL, ETL, Excel, XML, SSIS, Azure, Tableau, Hive, Python, PySpark, Jira, Agile, KPI, T SQL, SSAS, T SQL, Star Schema, Snow Flake, SSRS, DAX, ADF.

• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Built SQL queries, stored procedures, and views to extract large datasets from heterogeneous sources including MS SQL Server, MySQL, and Oracle for varied audiences.
• Tableau reports were created, published, and scheduled in accordance with business requirements.
• Worked on metrics produced by DAX (Data Analysis Expressions) queries. Create SSAS Tabular Models, add DAX expressions, and deploy them.
• Made use of T-SQL objects to create tables, views, indexes, functions, and stored procedures.
• By pivoting and un-pivoting the data model with Power Query in Power BI, data cleaning and data massaging were carried out.
• Maintained the Tableau Gateway to ensure that all Tableau reports and Dashboards were accurate.
• Created and tested SQL queries based on the persistent table utilizing Inline Views, Dynamic SQL, and Merge statements.
• SSIS was used to generate high performance ETL scripts that moved and changed data from SQL Server and MS Excel.
• Created brand-new dynamic SSIS packages to enhance the ones already in place and load data into databases and between servers.
• Worked on demonstrated capacity for statistical analysis, especially fluency with Python for data exploration and analysis.
• Designed and made the queries, views, and stored procedures necessary to enable the SSRS report. SSRS was used to extract data from an internal data warehousing system.
• Participated with the installation, configuration, and performance optimization of the hardware and cluster capacity for the Hadoop cluster.
• At work was able to modify data using PySpark, Spark SQL, and data frames alongside data analysts while also comprehending the data and its intended uses.
• Worked on Linux and UNIX platform experience; work has been done to resolve the problems and build the code.
• Used JIRA tickets, as well as assisting in their closure by offering workable fixes.

Environment: Agile, Scrum, Tableau, KPI, EXCEL, Power Query, MS SQL, MY SQL, Oracle, Hadoop, Hive, Oracle, Excel, power Query, SPARK, Python, Jira, ETL, T SQL, P SQL, DAX, SSRS,SSIS.

• In-depth knowledge of Software Development Life cycle, having a thorough understanding of various phases.
• Using Power Query on the Power BI desktop, ETLMethods worked to integrate several data sources, such as spreadsheets, SQL servers, and external data obtained through web services, into a single, centralized data warehouse.
• After SSRS reports and the report builder were converted, Power BI builder reports were made and made available for usage in real production.
• To maintain dashboards and reports current with on-premise data sources, Power BI gateway was utilized. Created system and business requirements, designed the ETL process, documented it, and included data dictionaries, transformations, and source-to-target mappings.
• Scripted advanced SQL queries in PostgreSQL for Redshift and MySQL leveraging Common Table Expressions, sub-queries, correlated sub-queries, window functions and complex join logic to apply business rules.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Involved in Development, Implementation and Reporting in MS SQL Server 2016/ 2014/2012/2008R2/2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Imported data into SQL Server from a variety of OLTP data sources, including Oracle, MS Access, MS Excel, flat files, and CSV files.
• Involved in source code management with the help of GitHub using push and pull operations of GIT and created a local GIT repository so that the source code can be managed locally.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance
• Worked on Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact, and Dimensions Tables using MS Analysis Services.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.
• Worked on Agile methodology expert who participates in daily scrum sessions with backlogs.

Environment: Power BI, Desktop, ETL, Power Query, SSIS, SSRS, SSAS, OLTP, Oracle, MS Access, MS Excel, Git, Github, OLAP, Star, Snow, Flake, T SQL, Agile, Scrum, Redshift, MY SQL, Postgre SQL, DAX, SQL Server.