Abhijeet Ashok Ohal
Logistics Analyst & Business Intelligence (15 Yr. Experience)
Pune,MH
Summary
Logistics Analyst supporting reporting and Global Air & Ocean Data Management , RFQ Analysis & Bidding Support. Precessional with Technical Skills as Power BI , SQL, and Python , Excel VBA & Macros in logistics and business intelligence workflows. Builds standardized dashboards, recurring reports ,brings documentation, project coordination, and stakeholder reporting support to help teams deliver analytics at scale.
Overview
15
15
years of professional experience
Work History
Assistant Analyst– Business Intelligence, Logistics Analytics
Eaton Technologies Pvt. Ltd.
05.2016 - Current
- Eaton Technologies Pvt. Ltd
- Client: Vehicle Group Supplier Development and IPO
- Provide solutions for Internal & External automation VBA projects , Python , MS Access , SQL , Power BI , Power BI Workspace Admin Support
- Project RFQ for IPO Team Air and Ocean , LTL North America Cost Out & Economics Database Management, Automation & Analysis Support
- Data Governance
- Understanding and Appreciating Project Management Training Completion
- Project Documentation & Management Support
- Key player in report standardization & automation team for Continuous Improvement productivity realization in Hrs
- Design & maintain database Management for APQP, Focus Supplier
- Create GUI Forms for SDE to share their Part Information updates
- Assistant Analyst– Business Intelligence, Logistics Analytics
- Date May’16 – till
VBA Consultant
CBT Infotech Pvt Ltd
- Project: Benefit Team Report Automation
- Role:
- Responsible for requirement gathering and understanding of critical business logic from benefit team project manager (Client)
- Building project related reports from success factor reporting domain
- Automation of report
- Scope: The automation tool is capable of data formatting, cleansing and integration of refine data on basis of date range with different data set components.
- The tool is designed for the benefit team working in a department which are responsible for calculating and managing financial aspects of employees
- The tool is fast and executes smoothly on an average handled time of 15 minutes for One Lakh records
- Other Projects: Master BHRRH, Quality Check Macro, India Payroll Macros, Calendar invite Macros, GMC Macros.
- Role:
- Worked and modified some existing developed Macros and maintains code logic, troubleshoot and support with the same
- Builds and create customized reports in Prism
- Programming Language: VBA Excel
- Data Extraction Tool: Success factor (Prism)
- Duration: 4 Months
- Company Name (2) : CBT Infotech Pvt Ltd
- Location : Pune
- Position/Designation : VBA Consultant
- Work experience : 7 Months
- Work Profile:
Analyst
eClerx Services Pvt Ltd
- Work Profile:
- Automation Background:
- Lead Activity Workflow System (LAWS): LAWS an eClerx tool developed in VBA where the primary focus to develop the tool was to keep entire data in a centralized form. The tool was responsible for lead uploading into the tool from excel workbook, assignment and distribution of Leads in a team, Auto match leads and mapping reports
- Role in project: Worked on the report module where one can generate report providing the request ID
- Analyst Agent: An add-in like tool developed initiating for the LAWS tool at individual level where the tool capability is to perform an arrangement of Contact ID’s and Account ID’s with comma separated values into sets further to be inputs to generate SFDC reports and to match records of LAWS report based on the ID’s
- Lead Attribution weekly report: The tool consolidates excel files from a directory Specified and all the required data is there into one excel file. The data is filtered on criteria and required lookups and naming is performed.
- Brazil MB Scorecard weekly report: The tool fills data of SFDC report according to template headers, lookups are carried on certain data, logical calculations, filtering and formatting is processed
- Automaton Award: A Business process Improvement certificate from the Automation and Quality team for the tool developed as Analyst Agent which benefited for the process in terms of effort savings, time saving and quality
- Project: SMB (Small and Medium Business) Lead Generation
- Project summary: The process was basically for a Small segment business area to generate Leads for our client following a process Lead Mapping .Lead Mapping is a process where client data is analyzed on a CRM sales cloud database Salesforce.com. The data is in the form of excel sheet which is analyzed applying a standard level of criteria where the ultimate aim of Lead Management is to Search, identify the accurate Accounts and contact IDs of companies from a huge result set generated from Salesforce.com.
- Duration: 3 months
- Project: EMEA PLE Lead Gen (Large Enterprise)
- Project summary:
- Lead Generation: Lead generation with respect to Large Enterprise concerned for EMEA region.
- Campaign Creation: Creating campaigns in Salesforce.com.
- Lead submission: Creating client specified Leads into excel sheet and submitting those Leads to client.
- Contact Creation: Creating contacts in Salesforce.com with the data provided from client.
- Adhoc activities: Searching for Duns numbers and SIC codes of companies in Hoovers.com a DB of companies globally.
- Process Reporting: EOD Status reports, Status updates, Weekly decks, client communications.
- VBA: Macros to fetch data for Status report, Weekly decks
- Duration: 1 year 5 months
- Project: US LE Lead Generation (Large Enterprise)
- Lead Generation: Lead Generation with respect to Large Enterprise concerned for US region.
- 1) Lead mapping in an eClerx developed tool Lead Activity Workflow System (LAWS)
- 2) SFDC Lead Object Mapping with creation of contacts, Relationship Leads, finding Accounts ,Lead Owner alignment
- Tabulation: Tabulation is a process of segregating the entire Leads into different tabs with analysis of data based on criteria which further is utilized for Data Load Requests (DLR) creations.
- Reports: EMEA LEAD tracking report, Online Leads fetching from Salesforce.com.
- Duration: 1 year 4 months
- Project: T2D, EMEA SMB Incremental, SMB Brazil Lead Gen
- Lead Generation: Lead uploading into clients SharePoint a daily activity.
- Reports:
- Brazil MB Scorecard weekly report
- SMB Dashboard weekly report
- HnC Dashboard weekly report
- Lead Attribution weekly report
- EMEA online dashboard
- Duration: 12 months
- Company Name (1) : eClerx Services Pvt Ltd
- Location : Pune
- Position/Designation : Analyst
- Program Name : ABACUS
- Work experience : 4 Years 3 Months
- Work Profile:
- Automation Background:
Education
Bachelor of Science - Computer Science
Pune University
05.2003 - 06.2006
H S C -
Dr.D.Y.Patil ,Pimpri
Pimpri 06.2001 - 06.2003
S S C - undefined
Judson High School
Pimpri01-2000
Skills
Python
Power BI
Macros & VBA programming
SQL,SNOWFLAKE,CLOUDERA
Advanced Excel
Dashboard design
Report automation
Data validation
KPI reporting
Reporting standardization
Data Management
Requirements gathering
Stakeholder communication
Cross-functional coordination
Process documentation
Certification
Software Testing : Completed Software Testing course with live project from ATS Infotech Pvt ltd in the year (2007).
Achievements
Won 1st prize in Drawing competition of Camlin, Won 5th Consolation prize in Drawing Competition of UNICEF