Haresh Patel Email and Phone Number
Haresh Patel work email
- Valid
- Valid
Haresh Patel personal email
- Valid
- Valid
Professional Summary 26+ years of IT experience Mining/Oil/Gas 4 years, Australia FMCG 5+ years, Australia Pharmaceutical 10+ years, Australia Government Organisations 2+ years, Australia Telecommunication 6+ months, Jakarta Banking (Retail) 4+ years, IndiaExpertise• Solution Architecture / Design and Development SAP Data Migration, Enterprise Data Warehouse, System Integrations (Batch/Real-time), Master Data Management, Metadata Management, ETL/ELT, Business Intelligence, Cloud based database and integrations, Prototypes, Business Case, Roadmaps, Governance, Standards, Guidelines• Hands-on full SDLC methodologies (Agile, Waterfall)• Data Modelling - Conceptual, Logical, Physical Data Modelling, 3NF, Ralph Kimball, Inmon, and Data Vault, Data Lake• Exceptional analytical and problem-solving skills• SAP S4, SAP HANA SP6/7/10 (On-premise and Cloud), Oracle 7 to 12g, PL/SQL, SQL, Microsoft SQL Server 2005/2008/2012, T-SQL, Stored Procedures, Web Services, SAP Data Service 4.2, IBM Data Stage 7.5, Microsoft SSIS, Informatica, Automic v10/UC4, SAP Business Objects BI4.2, Microsoft Visio 2010, ERWIN 7/8, XML, Unix shell script, C#, Java, Java script, Asp.Net, Pro*C, C++, C, SAS/SDD, Knowhow: Cloud, Tibco MDM, Web Methods, SAP ECC/SCM/BW/APO, SSRS, Siebel, CAS system, MFG Pro, Oracle Hyperion Planning, Oracle Hyperion Financial Management, Oracle DRM, Chris 21, Success Factor and EC PayrollKey Achievements / Awards• Green field implementation of HANA standalone finance data warehouse with 3 sec reporting responses• ~22 ml saving on clinical trials development @ Eli Lilly by providing innovative green field solutions • Transforming Lilly Award for outstanding performance and lasting contribution - from Information Officer GM&R IT- 2008 @ Eli Lilly• Regional winner of the Solution Achievement Award for demonstrating the leadership and skills required to make iPlan2 a reality and success from CIO of the company- 2006 @ Eli Lilly• Winner of the global solution achievement award from CIO – 2006 @ Eli Lilly• Regional winner for the solution achievement award from Executive sponsor and VP-IT/CIO – Jun-2004 @ Eli Lilly• Winner of the global solution achievement award from IT manager – Nov-2001@ Eli Lilly
Glencore
View- Website:
- glencore.com
- Employees:
- 5001
- Company phone:
- 61 2 9253 6700
- Company email:
- info@glencore.com
-
Senior Data Integration / Data Warehouse ConsultantGlencore Jun 2020 - PresentBaar, Zg, ChDesign and development of HR data warehouse
-
Data Migration ConsultantOil Search Limited Aug 2018 - Jun 2020Adelaide, South Australia, Au• Developed finance data migration strategy and design of ETL covering migration of GL Account, Profit Centres, Cost Centres, Joint Venture, Fixed Assets, Customer, Vendor, GL balances (Gross JV, Net sole), AP Open items, AR open items, GL open items from JD Edward into SAP S4 HANA• Delivered the migration of finance data objects from JD Edward into SAP S4 HANA• Design, develop, and deliver data migration solution to migrate HR and payroll data from Chris 21 into Success Factor -
Senior Data Integration / Data Warehouse ConsultantGlencore Oct 2016 - Aug 2018Baar, Zg, Ch• Realtime System Integration solution design and development of integrating employee data with various systems like ERP, Training System, Gate Security system, Safety System, external vendor managed Lab System.• Tech lead for technology migration from Oracle BI/DI to SAP Data Services for batch processing on Enterprise Data Warehouse• Design and develop real time SAP Data Services job and SAP Data Services web service for system integrations.• Development of BO Universe and WebI report• Validate/verify target system data received via multiple Realtime components with multiple transformation rules and identify potential improvement and future enhancement.
-
Senior Data Integration ConsultantLion Jun 2017 - Jun 2018Sydney, Nsw, AuProviding Ad-hoc consulting services to Lion for Design and implementation of BI solutions (data integration, BO Universe, WebI Reports)• May-Jun 2018 (part time)Design and implement BI solution to enable business tracking of sales and $ performance driven by customer is on/off the Macquarie Bank Loyalty program.SAP DS - Customer loyalty data integrated from Siebel to Data Warehouse with history maintenance BO Universe – Modified existing credit universe to add Bill-To customer loyalty dataWebI Report – Used data from credit universe and sales universes to create report with sales volume, NSR, outstanding debt for Bill-to and Sold-to customers• Mar-2018 (part time)Implemented additional Supply Chain KPI formulas in existing KPI calculation stored procedure in SAP HANA • Jun-2017-Sep-2017 (part time)Implemented Supply Chain KPI calculations and reporting solution for Lion Dairy and Drink business. SAP Data Services to bring KPI inputs from portal (SQL server database) into SAP HANA and calculated KPI outputs using stored procedure in SAP HANA, SAP BO universe for Ad-hoc KPI reporting. -
Data Warehouse Architect Design & Development LeadLion Mar 2015 - Sep 2016Sydney, Nsw, Au• Lion was going through the fiscal year change from Sep ending to Dec ending and project (in tune of $1 mil+ AUD) was formed to impact access all the applications (80+) and integrations and processes. I was one of the lead designer and was leading team of 4 developers. I organised/participated in many analysis and design review sessions with stake holders. • Design of the Lion Financial Year End change for Data Warehouses, Data Marts, HANA information models, Business object universes, Reports, CRM system (Siebel), Promotion system (CAS).• Re-design logical and physical data models in Lion Enterprise Data Warehouse for Year End change and update data standards and ETL guidelines documents.• Actively lead the development team on Lion Financial Year End changes on Data Warehouses and Data Marts data integrations.• Project was successfully completed and work was appreciated by management
-
Data Warehouse Architect Design & Development LeadLion Jun 2013 - Feb 2015Sydney, Nsw, Au• Lion was forming the green field systems and processing to streamline business units and group financial planning and reporting. Project Oscar was formed (in tune of 45 mil AUD).• This multi-million$ program was to align corporate finance/planning business process and reporting across the Lion group. The program manifested in multiple projects of planning solution using Hyperion Planning, financial consolidation using Hyperion Financial Management, and CPR/GFR reporting using brand new Lion Data Warehouse. • Business engaged Accenture to work on future state business processes and to formalise the business requirements. One of the sub project named Zeus was created to implement Lion Finance Data Warehouse with the aim of 3 second reporting. • As a part of project Zeus there was one project manager, one BA, 2 lead architects and designer, and 8 developers. I was one of the lead architect and designer and was leading team of 4 developers. • Lion Data Warehouse (LDW) built on standalone implementation of SAP HANA in-memory database sourcing the data from various source systems like MDM (CIM), Siebel, MFG Pro, SAP ECC, Oracle DRM, Hyperion Planning, and Hyperion Financial Management with history migration from source systems and existing EDW. Lion Data Warehouse provides P&L reporting, Cost Centre reporting, Gross Margin reporting, Customer Contribution reporting, and Brand Contribution reporting on plan and actual fact data with time and scenario comparatives.• Translated business requirements into detailed architectures and designs• Creation of best practices, standards, methodology while designing new Lion Data Warehouse and business analytics platform• Lead the Design and development team on SAP HANA data warehouse development and historical data migration from existing Oracle data warehouse.• Mentoring team members on best practices and help achieve delivery mile stones
-
Data Warehouse SpecialistLion Oct 2011 - May 2013Sydney, Nsw, Au• Lead the taskforce to address the business-critical integration and redesign/develop the robust integration which helps sales force team with accurate deal promotions while they are on the street with customers.• AC-Nielsen product sales data into SAP BI to support forecasting and planning process, Claim processing solution to bring customer claim data, validate, and feed to Siebel for claim review/approval and processing in SAP for LDD business unit • Pourage rights integration from EDW to Siebel, enabling business to track the customer agreements (agreed sale) with the actual sales• Integration of customer Deduction claim data (invoices) in XLS sheet to ISS system (third party system), and from ISS system and Promotions system to EDW, perform the complex tactic matching based on promotional deals to calculate the deal credit and integrating with ERP system (MFGPro) to generate the credit note to the customer, using SAP BO Data Integrator and PL/SQL. Scheduled the job flow using UC4 tool, • Integration of Sales Actual and Target KPI data in XLS sheet to EDW, using SAP BO Data Integrator. Scheduled the job flow using UC4 tool• Modify existing integration between Siebel and Enterprise Data Warehouse for Bacardi Lion (JV) Infield automation project, using IBM Data Stage 7.
-
Regional Solution Architect (Asia Pacific)Eli Lilly And Company Jan 2007 - Sep 2011Indianapolis, Indiana, Us• Preparing business cases and proposals, solution design, database design, web interface design, system integration design, business process mapping, industry regulations, lead development, pre-post implementation change control, system validation, system security plan and admin, disaster recovery and business continuity, periodic reviews, empowering the lead business SME on systems, business training manuals, system life cycle management (stable/upgrade/retire).• Translate business requirements into detailed architectures and designs • Work with functional analysts, developers, and vendor to ensure that all solutions are deployed within agreed timelines and supported after delivery • Review of business solution proposals, seek to align existing available solutions/systems globally within the company, security impact, business process impact, execute/build/evaluate the working prototype, evaluate ROI, estimate system life cycle, compliance with enterprise technology road map, compliance with local/regional/global regulations. • Influencing and working closely with business lead on IT and business process alignment• Application life cycle management to ensure application/system is current and operational as per business processes and provide update path of the application/system for future state architect. • Mentoring team members on best practices and help achieve their goals.• Working closely with external agencies, vendors, and outsourced support team.• Integration of systems, business & IT processes• The “InFuse” project was developed as a platform for data management of clinical trials. Project has enabled business to shorten the clinical trial system build time, resulted in saving of more than $12 million to-date on 60+ clinical trials running across the Asia Pacific, Japan, and Europe region. -
Senior Analysts Programmer / Design & Development LeadEli Lilly And Company Jun 2000 - Dec 2006Indianapolis, Indiana, Us• Business analysis, Solution designing and development, Integration of systems, business & IT processes, Lead developer, System development, testing, implementation, support, user training, Team lead, Test analyst, Vendor management (TCS India)• Co-designed/developed, implemented, and supported CT-FAST1 and CT-FAST2 projects which were initially used locally in Asia Pacific region and then adopted by Europe. There were 40+ clinical trials developed during the life cycle of the platform, resulting in savings of more than $10 million.
-
Sr Analysts ProgrammerSdi Technologies Pty Ltd Dec 1997 - May 2000• System development, testing, implementation, Y2K solution consulting with various clients like Department of Housing (Sydney Australia), RTA (Sydney Australia), Sofrecom (Jakarta, Indonesia)• Developed the Y2K Analysis tool to automate Y2K fix and analysis. The tool analyses the code and auto fix where possible and generates the report with the line of code that needs a manual fix with suggestions for potential fixes.
-
Analyst Programmer, Pre-Sales ConsultantMafatlal Consultancy Services Nov 1994 - Nov 1997• Business analysis, System development, testing, implementation, support, training, Preparing pre-sales demos – on retail banking solutions to various banks/branches in Gujarat and Maharashtra of India• X-chequer' was a retail banking system. It caters to all the co-operatives and scheduled bank's requirements. • I was involved in developing core functionality of the Overdraft & Cash credit accounts, Saving accounts, Telebanking, Loan accounts, Signature scanning & retrieval• I was instrumental in understanding, developing, and implementing local needs of the various banks I supported. I was also able to ensure that any technical or operational issues were resolved on time, ensuring the system was fully operational during core business hours.
Haresh Patel Skills
Haresh Patel Education Details
-
National Institute Of Technology SuratComputer Science -
St. Xavier School Surat
Frequently Asked Questions about Haresh Patel
What company does Haresh Patel work for?
Haresh Patel works for Glencore
What is Haresh Patel's role at the current company?
Haresh Patel's current role is Solution Architect | Data Migration | Data Warehouse | Data Integration | System Integration.
What is Haresh Patel's email address?
Haresh Patel's email address is ha****@****nco.com
What schools did Haresh Patel attend?
Haresh Patel attended National Institute Of Technology Surat, St. Xavier School Surat.
What skills is Haresh Patel known for?
Haresh Patel has skills like Business Analysis, Application Architecture, Metrics, Testing, Business Process, Vendor Management, Programming, Unix, Databases, Software Project Management, Sdlc, Software Documentation.
Who are Haresh Patel's colleagues?
Haresh Patel's colleagues are Alex Hicks, Karabo Tlhagwane, Martin Mashele, Олеся Пучеглазова, Dominique Poppi, Wayne Pienaar, Hong Varney.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial