Ashish Kumar Email & Phone Number

County Dublin, Ireland

County Dublin, Ireland

Dublin, County Dublin, Ireland

Bengaluru, Karnataka, India

• Created visually impactful dashboards and reports over the modelled data in Excel and Tableau for data reporting by using Pivot tables and VLOOKUP. Extracted, interpreted, and analyzed data to identify key metrics and transform raw data into meaningful, actionable information, which added value to the company in decision making and understanding the client performance.• Worked on all phases of Data warehouse development lifecycle from gathering requirements to testing, implementation, data migration and support.• Successfully identified multiple data issues and helped with their resolution as a part of team and cleaned the data by using Pandas library in Python programming language.

Dublin 6, County Dublin, Ireland

County Dublin, Ireland

Responsibilities:• Updated the daily stock summary in the database and visualize it into different categories by using MS-Excel and Tableau to identify the customer purchase trends and optimize pricing.• Utilized statistics to prepare visual dashboards to determine which products are selling and underperforming by using Tableau dashboards daily and ensuring inventory availability.• Prepared the payables and purchase reports and supported the internal audit teams in bimonthly inventory audits and warehouse management to ensure the inventory was up to date and accurate.

Dublin 6, County Dublin, Ireland

Responsibilities: • Collaborated with restaurant assistants to improve the customer service during the pandemic and performed administration activities such as cash handling, receipts, stacking products, etc.• Provided exceptional customer service to customers as the first point of contact, meeting the requirements while seeking opportunities to extend and develop the relationship for further business.• Delivered a superior quality of customer and product service continuously for outbound and inbound queries to ensure and meet the Service Level Agreements concerning service delivery.• Ensured all the operations were conducted in a correct, cost-effective, and timely manner in alignment with customer requirements and quality requirements while booking orders with customers.• Provided an efficient and effective Customs Service ensuring administration procedures are carried out in line with restaurant standards while also maintaining banking integrity and 100% SLA expectations.

Bengaluru, Karnataka, India

• Collaborated with external stakeholders and senior data analyst to understand the business requirements for financial team for improving budgeting, forecasting, and modelling key metrics. Analyzed and presented the data, which were adopted by management 24 hours after presentation that resulted in annual cost savings of $1.2M.• Analyzed data from 35000 monthly active users and used output to guide marketing and product strategies; increased average value by 1.5 times and redefined existing KPIs (Key Performance Indicators) surrounding marketing initiatives and supplied recommendations to monitor sales and decreased costs by 17%.• Developed 18 dashboard daily for client reporting and to find out the variance in data by using Microsoft Excel, Tableau and SQL queries in MYSQL/SQL Server and presented to non-technical audience• Worked with a team of data engineer, database architect, data scientist and senior business analyst for client's sales and financial team and exposed to various project methodologies and involved in sprint planning, daily scrum, sprint reviews & retrospectives, as well as requirement gathering, analysis sessions, and testing cycles.• Created complex SQL queries, stored procedures, and views as per business requirements, and examined the large datasets using SQL Server to test data quality and correlate and summarize the ETL purposes. • Performed data cleansing and pre-processing while extracting data from various data sources by using Pandas, NumPy, Seaborn & Matplotlib libraries of Python, SSIS, MySQL, MS Excel and developing and visualizing departmental reports for performance and response purposes by using Tableau and Power BI.• Monitored Ongoing DWH modelling and integrated client sales & financial data in a normalized star schema structure, along with building and maintaining the BI reports for clients by using Tableau and Power BI.

Bengaluru, Karnataka, India

• Created & maintained prospective client database on excel and relational database (MySQL/SQL Server) and used excel to make PIVOT Table and PIVOT reporting and use VLOOKUP functions.• Design and developed Ad-Hoc reports as per business analyst, operation analyst, and project manager data requests by using Microsoft Excel.• Collaborated with focus groups in a research analysis on 3 different products and increased sales by 11% due to the findings.• As part of manual weekly reporting to third party consumers, numerous SQL scripts were designed and built for process improvement. Build tableau dashboard to visualize core KPIs (e.g., Monthly recurring revenue), saving 10 hours per week of manual reporting work.• Used joins like inner join, outer join while creating tables from multiple tables to resolve the business problem from the raw data by writing SQL queries. • Leveraged analytical skills to import large data sets, clean the data, run analysis, generate tables, investigate the data security issues and present results as data visualization dashboards via Tableau.

Master'S Degree, Data Analytics

Bachelor Of Technology - Btech, Computer Science