Akash Jaiswal
DWBI
5 yrs 2 mos
Financial Data Analyst
XPO Logistics, Inc
Great Lakes Institute of Management
Summary
A data enthusiast having around 5 years of experience in Data Warehousing and Business Intelligence, mainly responsible for analyzing requirements, developing data loading ETL's, and building interactive client dashboards. Also, have experience in implementing RPA and statistical machine learning solutions to various business problems.
... See More
Skills
5+ yrs
SQL
3 - 5 yrs
Tableau
1 - 3 yrs
Balsamiq
Hive
Informatica MDM
k-Means
Oracle
PowerBI
Python
Unix Shell (sh)
Career Journey (5 yrs 2 mos)
Financial Data Analyst
XPO Logistics, Inc
Apr 2019 - Present
2 yrs
Description: 
 Responsible for developing financial dashboards such as Labor-Wage Analysis, YoY analysis, Vertical analysis, and presenting it to the stakeholders.
 Developed ETL - BI pipeline to load finance Budget and Forecast models in Power BI Dashboard from excel models.
 Worked along with the Data Science team to optimize warehouse product management using associate rule learning which improved labor efficiency by 15%.
 Created customer volume segmentation model to cluster 30+ client warehouses in F&B vertical and 12 client warehouses in CPG vertical.
 Identified data anomalies by creating detective and preventive controls.
 Worked with the Data Science team to predict client volumes for the supply chain.
 Currently developing OCR for invoices processing automation using Python Tesseract.
 Created POC on employee hours anomaly detection using machine learning.
 Responsible for maintaining Oracle databases and providing data dumps to Vertical Stakeholders and Data Science team as per their requirements.
Skills
PowerBI
SQL
Python
k-Means
Unix Shell (sh)
Company Stage
Fortune 1000
Company Type
Service
Company Size
10,001+
Company Location
Mumbai, Mahārāshtra, India
Team Role
Individual Contributor
Team Size
6
B2B/B2C
Internal, Business (B2B)
Sector Learning
Financial Services, FinTech
Switch Reasons (1)
Financial growth not in-sync with my performance

... See More
Great Lakes Institute of Management
Post Graduation in Artificial Intelligence and Machine Learning
Jan 2019 - Jul 2020
1 yr 6 mos

Specialization
Degree: Post Graduation in Artificial Intelligence and Machine Learning
Category: Computer Science
Showcases
profile
Mentor Appreciation
... See More
Business Analyst
Blockchain
Jul 2018 - Jan 2019
7 mos
Description: 
 Primarily responsible for gathering and analyzing Blockchain-based requirements and providing business proposal documents.
 Translated stakeholder requirements into different tangible deliverables such as BRD, FRD, project vision document, user cases, user stories, workflow -process diagrams, data flow/data model diagrams.
 Suggested Govt Authorities such as Dubai Police, Dubai Taxi Commission, and Tristar about Blockchain-based solutions and improvements in their existing approach and methodology.
 Facilitated weekly meetings with clients to document Blockchain-based requirements, pain points and explore potential Blockchain solutions.
Skills
Balsamiq
SQL
Tableau
Company Stage
Growth
Company Type
Product
Company Size
51-200
Company Location
Dubai, Dubayy, United Arab Emirates
Team Role
Team Member
Team Size
3
B2B/B2C
Business (B2B)
Sector Learning
Logistics, Software
... See More
Software Engineer
CitiusTech
Nov 2017 - Jul 2018
8 mos
Description: 
 Responsible for suggesting improvements in the existing Data Warehouse implemented by the client.
 Responsible for creating ETL’s in SAP BODS which loads data from various sources into the final Data Warehouse.
 Created stored procedures and Unix scripts for data cleaning and Archiving.
 Provided L1 24/7 production support for 2 months to troubleshoot and solving production issues.
 Optimized the existing ETL jobs, stored procedures, and views to improve speed.
Company Stage
Late
Company Type
Product
Company Size
1001-5000
Company Location
Mumbai, Mahārāshtra, India
Team Role
Team Member
Team Size
8
B2B/B2C
Consumer (B2C)
Sector Learning
Healthcare Services, Software
... See More
Application Developer Analyst
Accenture
Oct 2015 - Oct 2017
2 yrs 1 mo
Description: 
 Responsible for Designing Informatica ETL mappings which fetches data from Salesforce, XML's, CSV files, SAP BW, and SAP APO modules.
 Coordinated with the Data Quality team to create DQ ETL's which cleans the data and archive it into Hadoop and Teradata.
 Tuned the performance of mappings by following Informatica best practices to get the best performance resulting in decreased run-time by 30%-40%.
 Responsible for analyzing carts data worth 2 million and performed quantitative analysis of product sales trends.
 Identified the bottlenecks in the sources, targets, mappings, sessions, and resolved problems by checking sessions and error logs.
 Performed Drill down analysis and performance tuning on the client's existing Dashboard which reduced the loading time for a report by 25%.
 Involved in designing and developing of the Stored procedures in Oracle for the Monthly/Quarterly granularity of the Aggregate tables
 Created POC on predicting production job failures using Artificial Intelligence.
Skills
Informatica MDM
SQL
Hive
Tableau
Oracle
Company Stage
Fortune 1000
Company Type
Service
Company Size
10,001+
Company Location
Mumbai, Mahārāshtra, India
Team Role
Team Member
Team Size
15
B2B/B2C
Business (B2B)
... See More
Thakur College Of Engineering and Technology
Engineer's Degree Electronics and Telecommunication
Jan 2012 - Dec 2015
3 yrs 11 mos

Specialization
Degree: Engineer's Degree Electronics and Telecommunication
Category: Electrical Engineering
... See More
Pravin Patil College of Engineering and Technology
Diploma Electronics and Telecommunication
Jan 2009 - Dec 2012
3 yrs 11 mos

Specialization
Degree: Diploma Electronics and Telecommunication
Category: Electrical Engineering
... See More
More
Accomplishments (2)
XPO Impact Award WinnerAIML Hackthon
Languages (1)
English
Personality
Nothing specified