Neelkumar Patel

Involved in converting data into information, information into insight and insight into business decisions.
Performed Data extraction, Data cleansing, Data transformation and loading.
Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc).
Developed Power BI data visualization using Text table, KPI’s, Pie Charts and Bar Charts etc..
Prepared Dashboards using DAX /calculations, parameters in Power BI and created calculated fields, groups, sets and hierarchies etc.
Used Tableau’s various features like filters, context filters, Level of details (LOD) to create dashboard.
Transformed inbound data from various sources like flat files, MS Access, and Excel into database using ETL.
Developed SQL code such as stored procedures, functions, indexes, and views for business.
Provided support to Tableau users and Wrote Custom SQL to support business requirements.
Developed Tableau workbooks from multiple data sources using Data Blending.
Worked on data Ingestion/Extraction projects to inject/extract data into/out Data warehouse using multiple sources systems using ETL tool SSIS.
Executed and tested required queries and reports before publishing the reports.
Worked on Advanced Excel (Pivot tables, VLookup, conditional formatting, text to column etc.)
Compare EOM reports, spend plan, and requirements apps for consistency.
Ensure teams spend plan and requirement pp are balanced.
Identify/analyze any irregularities and provide updates to BA to receive guidance to resolution.
Review FM drill Timeline and prep dashboards for upcoming drills.

 Involved in converting data into information, information into insight and insight into business decisions.
 Performed Data extraction, Data cleansing, Data transformation and loading.
 Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL server, oracle, spreadsheets etc).
 Developed Power BI data visualization using Text table, KPI’s, Pie Charts and Bar Charts etc..
 Prepared Dashboards using DAX /calculations, parameters in Power BI and created calculated fields, groups, sets and hierarchies etc.
 Used Tableau’s various features like filters, context filters, Level of details (LOD) to create dashboard.
 Transformed inbound data from various sources like flat files, MS Access, and Excel into database using ETL.
 Developed SQL code such as stored procedures, functions, indexes, and views for business.
 Provided support to Tableau users and Wrote Custom SQL to support business requirements.
 Developed Tableau workbooks from multiple data sources using Data Blending.
 Worked on data Ingestion/Extraction projects to inject/extract data into/out Data warehouse using multiple sources systems using ETL tool SSIS.
 Executed and tested required queries and reports before publishing the reports.
 Worked on Advanced Excel (Pivot tables, VLookup, conditional formatting, text to column etc.)
 Compare EOM reports, spend plan, and requirements apps for consistency.
 Ensure teams spend plan and requirement pp are balanced.
 Identify/analyze any irregularities and provide updates to BA to receive guidance to resolution.
 Review FM drill Timeline and prep dashboards for upcoming drills.

Designing, developing, and maintaining business intelligence solutions.
Crafting and executing queries upon request for data.
Presenting information though reports and visualization.
Managed project insights through Azure DevOps to track the list of assignments and provide daily updates on progress.
Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis.
Developed highly formatted, pixel-perfect paginated reports by using power bi report builder.
Build Paginated reports by consuming data from Azure Analysis Services, Power BI Datasets, SQL server and Azure SQL Database.
Optimized SQL queries, stored procedures, views.
Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
Developed calculated columns and measures using DAX in Power BI.
Worked on-premises gateway to refresh the data sources & creating a live connection with tabular /Multi-dimensional Model SSAS.
Scheduled Reports Weekly and Monthly basis as per the Client Requirements.
Implemented the Row-level security (RLS) with Power BI Reports.
Worked with Azure Data Studio, Azure Data factory for Orchestration, SQL Azure, creating resource groups, subscriptions, build and release definitions.
Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
Published Power BI Reports in the required origination s and Made Power BI Dashboards available in Web clients.
Used Power BI Gateways to keep the dashboards and reports up to date.
In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.
Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Gathered requirements from the business users, created technical specification documents.
Documented all work, so user can easily understand the flow of process.
Designed diverse types of Power BI reports like Drilldown, Drill through and Sync Slicer.
Developed custom report Tooltips for different Reports and Dashboards in Power BI.
Created various customized and interactive Reports and Dashboards in power BI.
Publishing reports to Power BI Service and providing the access to required users.
Created Table, Matrix, trend lines, bar, card, gauge, slicer etc. and Custom visuals using Power Bi.
Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS.
Responsible for programming, testing, debugging, and documenting simple to moderately complex ETL applications (SSIS) under direct supervision.
Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
Improved ETL performance, optimization on SSIS packages.
Involved in the designing, development, modification and enhancing the database structures and database objects.
Maintains and modifies existing ETL applications and corresponding documentation Develops new ETL applications reports of simple to moderately complex scope, works with basic applications systems design specifications and utilizes company standards, procedures, and techniques creates and maintains effective ETL application documentation and Reports.
Assists in the development of test plans for assigned projects, uses simple to moderately complex debugging techniques to test ETL applications.
Documented all work, so user can easily understand the flow of process.