BI Developer / Data Engineer

• Nov 2021 - Present

• Develop end-to-end BI and data solutions for diverse customers in various industries. • Lead the entire project lifecycle, from requirements specification and project kickoff to final delivery. • Design and implement ETL and ELT processes, build pipelines, orchestrations, triggers, and alerts to ensure efficient and reliable data integration and transformation. • Create interactive and insightful BI dashboards using Power BI and Tableau to provide meaningful insights for business users. • Utilize a wide range of backend platforms, including Azure (Azure SQL Server, Azure Synapse, Azure Data Factory, Azure Logic Apps, Azure Function Apps, and Data Lake), AWS (Redshift, S3), Snowflake, and BigQuery databases and more. • Develop data models and design data warehouse solutions (DWH) to facilitate effective data storage, retrieval, and analysis. • Serve as the SQL expert within the company, leading SQL training programs for employees and ensuring best practices in SQL development. • Conduct interviews and participate in recruitment processes for new employees. • Provide presales technical support, working closely with the sales team to showcase technical capabilities and solutions to potential customers. Show less

BI Developer

• Mar 2020 - Nov 2021

• Wrote complex queries and stored procedures using SQL, T-SQL, and Teradata to extract and manipulate data from various databases. • Conducted data analysis and bug fixing in SQL Server databases to ensure data accuracy and reliability. • Designed and maintained ETL processes using SSIS. • Developed front-end reports using Cognos Analytics, enabling users to access and analyze critical data. • Wrote complex queries and stored procedures using SQL, T-SQL, and Teradata to extract and manipulate data from various databases. • Conducted data analysis and bug fixing in SQL Server databases to ensure data accuracy and reliability. • Designed and maintained ETL processes using SSIS. • Developed front-end reports using Cognos Analytics, enabling users to access and analyze critical data.

BI Developer / Data Analyst

• Nov 2017 - Mar 2020

• Characterize & develop DWH and ETL Processes• Characterize reports and present findings using Excel, OBIEE, SQL, Power BI• Build dashboards to present meaningful information for management team, using BI tools• Translating numbers into meaningful facts for business to help them make better business decisions• Dealing with Sales Figures, Inventory, Deliveries, Logistics, Purchasing, Costing, Customers Service, RMA and more

Process Improvement & Control Manager

• Jul 2014 - Nov 2017

• Manage a team of industrial engineers which lead the processes improvements of the supply chain domain.• Manage and lead cross company improvements project and IT projects.• Characterize and build KPI’s to measure the supply chain and EMS constructor’s performance. • Define methods & working processes for managers & teams.• Research, apply and implement IT solutions.• Data analyst - Examine reports and present findings using Excel, OBIEE, SQL & Access.• Report to Head of Supply Chain. Show less

Project Manager

• May 2006 - Jul 2014

• Management of the company’s ordering system, handling orders from customers in the USA, Latin America, Asia and Europe, in accordance with trends and customers’ forecasts.• Management of all stages of the project, overall responsibility for the entire supply chain, from the forecast phase to delivery to the customer.• Ongoing interaction with subcontractors and suppliers in order to advance the production of the components ordered.• Design and formulation of plans, processes, practices and objectives for meeting delivery deadlines.• Supervision and regulation over compliance deadlines, establishing priorities and provision of solutions to problems.• Collaboration and working alongside internal organizational interfaces, including salespersons, production planning and control, procurement, subcontractors, development, engineering, senior management, international forwarding and more.• Ongoing interaction with the company’s worldwide centers. • Flaw detection and investigation, control and monitoring of processes and performance while meeting stringent quality standards. • Assessment of results and implementation in order to improve procedures and apply cost savings. • Generate reports and analysis based on statistical measures of quality, efficiency and speed. • Partaking in decision-making and participation in management meetings for the presentation of results and compliance with objectives. • ‘Outstanding Employee’ for the year 2012. Show less

Director of IT

• Jul 2003 - May 2006

• Management of the company’s IT and infrastructure systems, including management of the company’s inventory and procurement of IT and communications equipment.• Management of projects from the demand and specification stages right through to the application and implementation stages.• Provision of support for a local network and distributed users, workstations, servers, peripheral equipment and backup systems.• Provision of consultation, installation, maintenance and training for company users on matters concerning hardware, software and information security.• Conducting negotiations with suppliers for procurement of IT equipment, identification of alternative suppliers for reducing costs.• Network fault monitoring and load testing. Show less

Help Desk Supprt

• 1999 - 2003