Zahiralli Malpekar
Senior Business Intelligence Consultant | Oracle Data Modelling And Database Design
Mumbai
Summary
Play a responsible role in an organization that stretch my skills and capabilities, challenges me to perform exceptionally in business analytics using Machine learning, R, Python Language, Tableau visualization, SAP ERP, SAP BI, SAP HANA, and development analysis of non-sap systems to extract meaning from big data. Certified in SAP BI and SAP HANA.
Overview
14
14
years of professional experience
9
9
years of post-secondary education
Work History
Senior Business Intelligence Consultant
AMD India Private Limited (Former Xilinx)
Hyderabad
11.2018 - Current
- Developed intelligence-sharing dashboards, providing company-wide access to collected data from IBM spectrum LSF (Load Sharing Facility), which is a workload management platform, job scheduler, for distributed high performance computing. Daily millions of jobs are executed through IBM LSF.
- Kibana visualization tool is used to design operational and executive dashboards from LSF data stored in Elasticsearch DB.
- Summarized data points are captured in .csv file which is used for developing reports in Tableau with more features to enhance the dashboard appearance for executive management.
- AMD is using standard platform to generate reports in POWERBI. Reports created in Kibana and Tableau are migrated into POWERBI.
- Drafted strategic business intelligence roadmap, complete with data governance policies and tactical information safeguards.
- Directed implementation of new business intelligence tools, selecting appropriate solutions and aiding in corresponding onboarding processes.
- Liaised with DevOps team to integrate business intelligence assets into future development lifecycles.
- Use Python for EDA to find patterns of LSF log data, showcasing to executive level for further decision and visualization ideas. Bringing more insights from the LSF configuration of actual job execution on various sites in USA, Singapore, India, Ireland and other countries.
- Extracting millions of data from Elasticsearch using python in .csv and converting that into pandas dataframe for further analysis on long text columns and correlations.
- Load data into BigQuery using files of cloud spending data, writing BigQuery SQL scripts and analyze the cost spend for different application.
- Mapped current business and operational processes and recommended areas for improvement.
Senior SAP BW Consultant
WIPRO
Mumbai
03.2018 - 08.2018
- SAP BW on HANA implementation. The objective of the project is to migrate data from oracle database to SAP HANA database.
- Install BI content in SAP BW on HANA.
- Responsible of technical and functional document creation and validation for sales and inventory reports.
- Create the dataflow from SAP ECC to new SAP BW on HANA system.
- BAdi implementation in ABAP on HANA for BW extractors.
- Create new objects in SAP BI 7.5 based on business requirement.
- Create technical document of reports from business requirement of reporting.
- Ensure the timeliness and proposed solution or hurdles to client in advance for appropriate decision.
- Weekly management discussion of project status.
Business Intelligence Consultant (SAP and Non-SAP)
Volkswagen Germany(Onsite) through Tech Mahindra Ltd.
Mumbai
04.2015 - 11.2016
- Major role was ensuring SAP BW ETL flow and business logic.
- Used standard BW content extractor (FI-AR, FI-AP, FI-GL) to fetch FI data from ERP into SAP BW system.
- Developing and customization of SAP BOBJ reports based on customer requirement.
- Regular meet up with business user in Germany to understand the ITIL support progress and bring improvement in case there is lack in service level agreement.
SAP On-Shelf Availability Project (Agile - RETAIL)
Philips Netherlands (On-site) through Tech Mahindra Ltd.
Eindhoven
09.2012 - 03.2015
- The objective of the project is to deliver an IT solution that enables the business to further embed OSA(on-shelf availability) in sales and supply processes. The solution must extend the current capabilities and functionalities of the DIR (Demand Information Repository) in the ONE BI landscape. Simplified product listing for the stores and smooth integration into the OSA reports.
- Understand the architecture of Consumer lifestyle SAP system of Philips.
- Use SAP BODS to extract data from flat files directly to check distributors information in SAP BW.
- Work on Demand Information Repository (DIR) to integrate external data into One BI to enable reporting of external data from various DataProviders together with Philips internal data, which are derived from transaction Systems like SAP ERP or SAP CRM.
Point of Sales POS - North America Convergence
Philips Netherlands (Onsite) through Tech Mahindra
Eindhoven
12.2011 - 09.2012
- Consumer Lifestyle North America Point of Sale data is currently collected in multiple systems with little cross usage or ability to get one overview of total Point of Sale US.
- Data collection methods from customer managed sources include electronic data exchange (EDI), manual download of data (via Excel spreadsheet), and capture of data from third party applications and sources. In order to maximize the internal sharing of retail customer point of sale (units , currency ) and inventory information, a convergence of all Consumer Lifestyle North America customer POS data is being undertaken.
- Understand the business requirement of north America point of sales.
- Create the infoobjects, infoprovider required for the POS data flow in the BI system.
- Create process chain to automate the process.
- Maintain the master data and transaction data of POS.
- Create test scripts for testing this Demand information repository functionality designed for point of sales in SAP BI.
- Create test cases in HP ALM.
- Used SAP solution manager in various project to keep track of the open and performed tasks.
- Extract test case results from HP ALM in more readable format with screen shots using excel macro.
- Upload the .csv file of customer point of sales data in the SAP BI system, which would be used by business users for reporting purpose.
- Do testing of BOBJ webi POS basic reports.
SPMCIL SAP Implementation Project
Tech Mahindra Ltd.
Nasik
06.2011 - 11.2011
- The Security Printing & Minting Corporation of India Limited (SPMCIL) was formed after corporatization of all nine Mints/ Presses/ Paper Mill which were earlier working under the Ministry of Finance, India.
- Understanding the business process of Currency Note Press (CNP) and involved in Blue print phase & Realization phase of Asap methodology.
- Installed and Activated Business Content Objects in the Area of Sales and Distribution.
- Involves in Extracting data from R/3 and flat file using different extractor-LO Cockpit, Generic Extractor (Table,View,Function module).
- Involved in Transporting Object from Development To Quality.
- Extensively worked on installing and activating the Standard Delivered Business Content in the form of Info Objects, InfoSources, InfoCubes, ODS objects.
- Involved in creating BEx Queries using BEx Designer, workbooks using BEx analyzer.
- Extensively work with variable in creating queries with processing mode as customer exit, Replacement path(Trending Report),user entry, Authorization.
- Collection of vendor, material master data to uploaded in LSMW format in SAP R/3 system.
- Create the structure of plant maintenance functional location, production equipments to be uploaded in
PL/SQL Developer (Payment Processing Module)
CITIBANK through Nucleus software solutions Pvt. Ltd. Singapore
04.2009 - 09.2009
- Integrate the PL/SQL stored procedures based on the business logic for payment processing module in citibank.
- Supporting the system integration & User Acceptance testing.
Functional Consultant (Lending Module)
ACOM Corporation Japan
Tokyo
12.2008 - 04.2009
- Understanding the business flow of Application Processing System (APS) and loans through different channels (Branch, CC, CS, ACM, Internet, Mail order, ATM).
- Gather requirement from customer for designing the application as required.
- Coordinate with team in india for developing the application using oracle forms and reports.
Software Engineer
Nucleus Software Solutions Pvt. Ltd.
03.2006 - 09.2009
- Understand the FINNONE loan management system used in banks.
- Responsible for enhancing and customizing the Lending module of FINNONE using PL/SQL, Oracle forms and reports.
Education
Pursuing Post Graduate Programme in AI And ML - IT
Purdue University
USA 04.2021 - 12.2022
Certificate Programme in Business Analytics - IT
Indian School of Business
Hyderabad 10.2015 - 10.2016
Bachelor of Applied science - Information Technology
RMIT University
Melbourne, Autralia 08.2004 - 08.2006
Advanced Diploma in Computer Studies (Cambridge) - IT
Informatics Computer School
Singapore 04.2003 - 03.2004
Polytechnic Diploma in Computer Technology - IT
Shreeram Polytechnic
Mumbai, India 09.1998 - 09.2001
Skills
Semiconductor
Retail (Point of Sales)
Banking
Automobile
Manufacturing
Tableau, POWERBI, Kibana
SAP ERP, SAP BW on HANA, SAP BOBJ
Python, R, Machine learning
Big Query
Datawarehouse, Cloud platform
Timeline
Pursuing Post Graduate Programme in AI And ML - IT
Purdue University
04.2021 - 12.2022
Senior Business Intelligence Consultant
AMD India Private Limited (Former Xilinx)
11.2018 - Current
Senior SAP BW Consultant
WIPRO
03.2018 - 08.2018
Certificate Programme in Business Analytics - IT
Indian School of Business
10.2015 - 10.2016
Business Intelligence Consultant (SAP and Non-SAP)
Volkswagen Germany(Onsite) through Tech Mahindra Ltd.
04.2015 - 11.2016
SAP On-Shelf Availability Project (Agile - RETAIL)
Philips Netherlands (On-site) through Tech Mahindra Ltd.
09.2012 - 03.2015
Point of Sales POS - North America Convergence
Philips Netherlands (Onsite) through Tech Mahindra
12.2011 - 09.2012
SPMCIL SAP Implementation Project
Tech Mahindra Ltd.
06.2011 - 11.2011
PL/SQL Developer (Payment Processing Module)
CITIBANK through Nucleus software solutions Pvt. Ltd. Singapore
04.2009 - 09.2009
Functional Consultant (Lending Module)
ACOM Corporation Japan
12.2008 - 04.2009
Software Engineer
Nucleus Software Solutions Pvt. Ltd.
03.2006 - 09.2009
Bachelor of Applied science - Information Technology
RMIT University
08.2004 - 08.2006
Advanced Diploma in Computer Studies (Cambridge) - IT
Informatics Computer School
04.2003 - 03.2004
Polytechnic Diploma in Computer Technology - IT
Shreeram Polytechnic
09.1998 - 09.2001