Vineeth Kumar Email & Phone Number

Boca Raton, Florida, Us

Used various sources to pull data into Power BI such as SQL Server, and Oracle.Involved in the installation of the Power BI Report ServerDeveloped reports to visually explore data and create an interactive report in Excel and Power BI.Using a query editor in Power BI performed certain operations like fetching data from different file.Created the KPI to show the difference between actual and forecast data.Working with import and direct query, creating a custom table in the Power BI.Merge queries and append queries, remove columns and split columns, choosing required columns in the data.By using a Power BI desktop connected to various data sources, working with different visualizations.Developed and published reports and dashboards using Power BI and wrote effective DAX formulas and expressions.Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing.Created Power BI Reports using the Tabular SSAS models as source data in Power BI Desktop and publish reports to service.

Louisville, Kentucky, Us

Experience in developing Reports, Charts, and Dashboards using Power BI Desktop and managing security based on requirementsTransform, define, and navigate the data from the data source and performed merge and append queries using Power Query.Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX.Performed transformations like Pivoting, Unpivoting, and Splitting of the columns using Power Query.Created different chart types and drill-down reports using Power Bi Desktop (SSRS).Involved in defining report layout in SSRS.Created measures, calculated columns, relationships and performed time series analysis using AX in Power BlPublished reports and visualizations to Power BI Service and thereby created dashboards.Created hierarchies in Power BI reports using visualizations like Bar charts, Line charts, etc.Worked with both live and import data into Power BI for creating reports.Managed relationship between tables in Power Bl using star schema.Used different type of slicers available in Power BI for creating reports.Experienced in creating many dashboards by pinning many visualizations in the workspace as per the insights provided.Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope.

Menomonee Falls, Wisconsin, Us

Develop and maintain data control/flow using ETL tool SSIS.Handling change requests and incorporating them into the existing ETL, cube, and reporting solutions.Improve the performance of the existing ETL packages by removing Blocking transformations in the package and replacing them with SQL Queries (Joins) at the source level.Perform unit tests (including test case development, review & execution)Deploying the changes and configuring them on multiple environments. Dimensional Data Modelling using Star and Snowflake Schemas.Developed store procedures for business requirements. Used PowerBI tool to perform previously Excel-done reporting to save time and energyWritten complex DAX functions in Power Bl and Power Pivot like COUNT(), SUM(), RELATED(), LOOKUPVALUE(), RANX(), CALCULATE(), etcWorked on various types of DAX functions like Date and time functions, Time-intelligence functions, Filter functions, Information functions, Logical functions Math anTrig functions, Parent and Child functions, Statistical functions, and text functionsCreated graphical dashboards and reports in Power BI.Performed Row-level Security to limit access to certain groups or individuals

Providing the business intelligence (BI) solution using SSIS, and, SSAS technologies.Involve in requirement gathering & write low-level and high-level specifications. Analysis, design, development, testing, implementation, and production support.Responsible for ensuring project estimates and schedules are created.Providing project status reports to RM and stakeholders.Designed and developed Multi-Dimensional Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.

Understanding the client's business problems and analyzing the data by using appropriate Statistical models to generate insights.Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.Participated in all phases of Data Mining, Data Collection, Data Cleaning, Developing Models, Validation, and Visualization.Extensively used joins and sub-queries for complex queries involving multiple tables from different databases Performance tuning of stored procedures and functions to optimize the query for better performance.Successfully implemented indexes on tables for optimum performanceHave used SQL Server 2008 Integration Services, transformations in the data flow of a package to aggregate, merge, distribute, and modify data. Performed DataCleansing and Profiling using Transformations in Packages. Involved in complete SDLC including Requirement Specifications, Analysis, Design, Building a Dimensional Data Model, Testing, Implementation, Debugging & Maintenance of applicationsCreated Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill reports as well as interactive reports according to business requirements in time restricted environment.