MITTAL PANCHAL

Visa Status: H* EAD Ph. 201-***-**** Email: adwhjq@r.postjobfree.com Address: Jersey city, NJ,USA Linkdin: www.linkedin.com/in/mittal1108

PROFESSIONAL SUMMARY:

An IT professional with total 8+ years of experience and 5+ years of Business Intelligence experience creating enterprise reporting dashboard using Business Intelligence Tools like Tableau, Power BI, Qlik sense, QlikView, IBM Cognos. A strong background in analyzing and creating business intelligence reports to drive operational improvements.

Good experience on in dashboards with large data volumes from various data sources (SQL SERVER, MySQL ORACLE, etc.).

Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports. Ability to handle multiple tasks concurrently and meet deadlines.

TECHNICAL SKILLS:

Business Intelligence Tools : Microsoft Power BI, Qliksense, Qlikview, Tableau, IBM Cognos Analytic and Jasper Reporting Tool, Microsoft Dynamic Dax Query, Pivot Table in Excel. Azure Canvas, Power Platform, power bi Azure integration.

Business Analysis Practices : Data Analytics Engineering, Data Analytics and Visualization, ETL, Data Collect and Analysis, Data Modeling for Reporting, SQL for Data Analytics, Outlining Problems.

Database : Microsoft SQL Server, SQL, MYSQL, ORACLE

Programming Languages : Java, R, Python(beginner), HTML, JavaScript

IDEs Worked on : Eclipse, Visual Studio Code.

Others : Jira, Confluence Page, Agile Methodology Employer – MSBC Group, India July 2020 – Present

Client – TP ICAP, NY

Senior Business Intelligence Analyst

Responsibilities:

Worked on Business Intelligence Tools like Power BI, Power BI Azure Integration and IBM Cognos Reporting Tool development, Dash boarding and Reporting in Finance Domain.

Planning and execution for installation and upgrade of BI Tools.

Integration Power BI Report in Azure.

Manage Tableau Server, including user management, permissions, and content publishing

Create and maintain Tableau data sources, ensuring data quality and consistency

Designed data models and optimized database queries for efficient data retrieval

Conduct ad-hoc data analysis to support business needs.

Extracted data from multiple data sources and converted them into the combined source for reporting purpose using data transformation and cleaning (ETL).

Provide business intelligence across 10+ Region filter and Time Period Comparison YTD, MTD and QTD by creating reports with Tableau and similar tools.

Created Calculated columns and Measures in Power Bi and Excel depending on the requirement using complex Dax queries in multiple power bi reports and Excellent skills in scripting data loads, mapping and data modeling in qlik sense. and publish reports to service and provided user roles to end users and row level security.

Expertise in creating visualization reports using BI Tools to show different visualizations like a bar chart, pie chart, heat Map, Donut, Gauge, table matrix etc. (Vizlib Library in Qlik sense).

Created KPI and implemented complex features in charts like developed more than 5+ measure calculation in one KPI in Tableau.

Preparing classification points and setup meeting with client in closing question on time.

Unit testing, Support System Testing and UAT

Code optimization / tuning under guidance from Architects

Used Jira as the Bug Tracking tool.

Environment: Tableau Server, Tableau Desktop, Qlik sense, Qlik view, Power BI, SQL SERVER, ORACLE, MySQL, IBM COGNOS Reporting, Jira, Agile Methodology, MS Excel Power Query, MS Excel Power Pivot. Government Project(Freelancing), Ahmedabad - India Sept 2019 – July 2020 BI Developer/Data Analyst

Project – Government Smart City Mission (AMC)

Responsibilities:

Develop and maintain BI solutions to support business operations and decision-making.

Developed and maintained Tableau dashboards to track key performance indicators and support business decisions

Create data models and ETL processes to extract and transform data from various sources.

Design and implement dashboards and reports using Tableau, Qlik sense and Power BI.

Collaborate with cross-functional teams to identify business requirements and develop solutions.

Perform data analysis to identify trends and insights to improve business performance. Environment: Tableau Desktop, Tableau Server, SQL Server 2012, MS Office, Power BI, Qlik sense. TM SYSTEM PVT LTD., AHMEDABAD, INDIA Nov 2014 – Sept 2019 Senior BI Developer

Project – Bank Delinquency (Tableau Developer)

Responsibilities:

Working on bank delinquency data which starts with analysis of the data and cleaning the data and making Tableau dashboards according to requirements.

Process starts with analysis of the data using SQL views and then cleaning them using R, SQL, Excel or Tableau according to requirement

Work on generating various dashboards in Tableau server using various data source.

Admin user, user groups and scheduled instances for reports in Tableau.

Creating and modifying worksheets and data visualization dashboards.

Prepare Dashboards using calculation, parameters in Tableau.

Product wise sales: Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.

KPIs: Cost of sales, Growth%, Collection Health, Primary Secondary Sales, Customer Activeness, Primary Secondary Target Sales Month on Month.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Environment: Tableau Desktop 10.2, Tableau Server, SQL Server 2012, MS Office, R Script. Project – Pulsed Group Inc (JAVA DEVELOPER)

Responsibilities:

Pulses Group Inc is a privately owned Canadian company based in Ontario. It was formed in March 1984, primarily to publish peer-reviewed medical journals.

Pulses publish ten journals, which have all been adopted as the official publications of the related Canadian medical societies.

Worked on important modules of the project like Journals, Services, Search, and Subscribe. Challenging work dynamic body part data filter and dynamic generate journal Meta tag. Environment: Jsp-Servlet follows mvc, sql server 2008. Jsp-Servlet follows mvc, sql server 2008. PRIYA SOFTWEB SOLUTION, Ahmedabad - India Jan 2014 – Nov 2014 Java Developer

Responsibilities:

Worked on important modules of the project like HR Management, Dashboard, Project Management, PIR, and Project Dashboard.

Role wise management like Role-admin, Role-HR, Role, business management, Role team leader, Role-user.

Create module project Dashboard.

Work on high chart.

Environment: grails, hibernate, spring, MySQL.

Education:

Bachelor of Engineering in Computer Science from GTU–Gujarat Technological University with 7.02 CGPA (First Class with Distinction) in 2012.

Contact this candidate