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.

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.

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.