Mitul Choksi Email & Phone Number

Dublin, County Dublin, Ireland

Mumbai Area, India

The project included reporting solutions to the client on its business operating cost, revenue, profit, on the rental of vehicles and transport services.• Defined and centrally owned operational processes and procedures to manage and maintain data used for reporting and analytics for the clients and worked with offshore team• Acquired data from multiple databases and flat files, set up processes to collect data, structure, format, and transform it using business rules and integrating data to the data warehouses.• Extracted, manipulated, and summarized customer and transaction records to provide business insights and developing strategies for business development using Python, SQL, and Power BI• Expanded management reports as well as effective visualization boards of key data trends & key performance indicators (KPIs) on customer insights and solution strategies using Python, SQL, and Power BI• Collaborated with external stakeholders, data architect, and senior data analyst to understand the business data and deliver required business targets adhering to the best practices in SDLC.• Created and modified complex SQL Queries using joins and subqueries, stored procedures, Views, indexes, triggers and Tables using DDL and DML commands in MS SQL Server.• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.• Wrote calculated columns, Measures queries using DAX in Power BI to show good data analysis techniques.• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.• Created multiple reports and dashboards using different visualizations, Published reports and dashboards using Power BI and scheduled automatic refresh.Achievements: • Designed solutions to Increase customer turnaround percentage from 12.56% to 21.2% in a financial quarter• Reduced Client's decision-making process and time by 15% through lucid and automated dashboard solution.

Mumbai Area, India

The project helped provide Banks with details on transactions and analytics on platforms such as POS, E-commerce, ATM withdrawals.• Performed ETL operations using SSIS, SQL on complex data from multiple sources and transferred the data to data warehouse and processes SSAS cubes to to store data to OLAP cubes.• Created SSIS packages to process the data, used various control flow and data flow items from the toolbox.• Prepared complex SQL queries and advanced excel to extract data from multiple sources for provisional business reports, which are automated into ETL batch processes.• Created and modified complex SQL Queries using joins and subqueries, stored procedures, Views, indexes, triggers and Tables using DDL and DML commands in MS SQL Server.• Encapsulated frequently executed SQL statements into stored procedures to reduce the query execution times.• Performed SQL query performance tuning by creating/modifying indexes to boost database performance.• Prepared visual presentations for the management team, highlighting key findings using data visualizations to obtain greater insights for high-value customers and improving marketing and growth strategy • Designed and implemented data models and reports in Power BI to help team, management, clients analyze data to identify market trends and customer behavior.• Created Page Level, Report Level, and Visual Level Filters in Power BI according to the requirements.• Wrote calculated columns, Measures queries using DAX in Power BI to show good data analysis techniques.• Created multiple reports and dashboards using different visualizations, Published reports and dashboards using Power BI and scheduled automatic refresh.Achievements : • Achieved 99.99% application business continuity and 0.01% downtime and failures.• Slashed the time spent in support tasks every sprint by 15% through automation of data duplication check, redesign of data load processes, status reports to management, etc.

Msc Data Analytics, Computer Science

Modules: Data Warehousing, Data Storage and Management Technologies, Statistics for Data Science, Advanced Data Mining, Analytical CRM.

Bachelor Of Engineering - Be, Electronics And Telecommunications

Modules: Applied Mathematics, Electronics Devices and Circuits, Principle of Communications, Micro-Controllers and Micro-Processor, Mobile.