Ilan Katz
Toronto,ON
Summary
Performance-driven Business Intelligence expert with progressive years and a strong background in system development, data analysis, and technical support. Experienced leading cross-functional teams in the development, documentation, and delivery of process innovation to drive the attainment of the company’s given objectives. Involved in all phases of software implementation including requirements gathering, system and workflow analysis, application and enhancement design, functional specifications, process and design diagrams, documentation, testing, training, and support. Effective in identifying potential problems and coordinating the formulation of solutions while integrating products and services required to meet enterprise needs.
Overview
11
11
years of professional experience
Work History
Junior Business Intelligence Developer
Pelephone Communications LTD
01.2020 - 04.2024
- Conducted comprehensive analysis of diverse technical data utilizing QlikView and SQL.
- Engineered and modified SQL queries and QlikView models to optimize data processing.
- Developed and updated ETL processes to meet dynamic business requirements.
- Identified and eliminated redundant tasks, saving hours weekly by removing a time-consuming process that was already handled elsewhere, improving operational efficiency.
Network Operations Center Operator and Analyst
Pelephone Communications LTD
01.2017 - 01.2020
- Performed thorough post-maintenance and upgrade performance reviews to ensure optimal system functionality
- Monitored and analyzed technical issues and usage fluctuations, implementing corrective actions as needed
- Spearheaded the development of a new wiki-style Knowledgebase for streamlined internal use
- Investigated and resolved issues at both the client and system levels to maintain high service standards
- Developed multiple Excel-based automation tools using VBA, most notably a pre-formatted email generator based on issue type, country, and operator selection, ensuring clear and professional communication.
Integrated the tool into QlikView, enabling auto-filled fields directly from reports, improving efficiency and accuracy. This solution addressed language barriers within the team and streamlined outreach to international roaming partners, saving valuable hours each month and allowing operators to focus on critical tasks. - Assisted in training new operators, sharing knowledge of best practices and promoting a culture of teamwork amongst peers.
Chat Bot Team Leader
Pelephone Communications LTD
01.2013 - 01.2017
- Devised and implemented solutions for common topics based on their frequency and urgency
- Identified and rectified consumer issues and software bugs to enhance user experience
- Conducted rigorous quality assurance for new features and major updates, evaluating their performance across mobile apps and mainstream browsers
- Continuously monitored system operations to proactively respond to and resolve emerging topics
- Edited and proofread content for both internal and external use, ensuring clarity and accuracy
Education
MCITP -
Sela Institute
Bnei Brak, IsraelETL -
Informatica, Aman
Bnei Brak, IsraelSkills
- Data & Business Analysis
- Project Management
- Technical Support
- Quality Assurance
- Database
- Troubleshooting
- Operations and Maintenance
- Team/Task Management
- Continuous Process Improvement
- Microsoft Excel
Accomplishments
- Developed several tools to automate daily workflow including: Email Generator: Crafted a tool that prepares email titles in a predetermined format with a simple message for non-English speakers. The tool adjusts the text based on added extras like examples. Integrated a button in the relevant Qlikview models for quick issue resolution.
- Knowledge Website: Managed a WordPress server to design, install suitable add-ons, manage users, and curate the knowledge uploaded by team members.
Qualifications
Thorough technical expertise and profound knowledge of troubleshooting guidelines to create effective, on-the-spot solutions to diverse technical disputes and user problems., Strong work ethic and exceptional organizational skills in effectively handling priorities and projects; while ensuring their completion within budget and time constraints., Strategic and persuasive communicator who guides business customers and project stakeholders to outcomes that benefit the bottom line while fostering organizational collaboration., Ability to work in a multicultural, multi-ethnic environment and maintain effective working relations with people of different national and cultural backgrounds., Business Intelligence, Data & Business Analysis, Project Management, Enterprise Systems, Technical Support, Stakeholder Management, SDLC & Quality Assurance, Database, Troubleshooting, Upgrades & Enhancements, Operations and Maintenance, Team/Task Management, Leadership & Supervision, Customer/User Relations, Continuous Process Improvement
Languages
Hebrew
Native or Bilingual
English
Full Professional
Timeline
Junior Business Intelligence Developer
Pelephone Communications LTD
01.2020 - 04.2024
Network Operations Center Operator and Analyst
Pelephone Communications LTD
01.2017 - 01.2020
Chat Bot Team Leader
Pelephone Communications LTD
01.2013 - 01.2017
MCITP -
Sela Institute
ETL -
Informatica, Aman
Similar Profiles
John LittonJohn Litton
Consumer Sales Associate at Verizon Communications/Frontier CommunicationsConsumer Sales Associate at Verizon Communications/Frontier Communications
Joel HenryJoel Henry
Independent Contractor at Cox Communications, DirecTV, Frontier CommunicationsIndependent Contractor at Cox Communications, DirecTV, Frontier Communications
Shannon JacksonShannon Jackson
Promotions Assistant/Front Desk Receptionist at Tidewater Communications LLC (Saga Communications)Promotions Assistant/Front Desk Receptionist at Tidewater Communications LLC (Saga Communications)
Angelica AbuqueAngelica Abuque
Home Childcare Provider at BRADLEY MAZDAHome Childcare Provider at BRADLEY MAZDA
Shana KhoshnawShana Khoshnaw
Tutor at Toronto District School BoardTutor at Toronto District School Board