Fahmi Eshaq


A software engineer with considerable experience in database development and relational data modeling.


Resume

Proactive and versatile data analyst offering solid background in database development.

Work Experience

Sep 2017 - Mar 2018

Reporting Analyst

from Sep 2017 to Mar 2018

Acklands-Grainger Inc, Markham ON

AGI is a company of over 2,600 dedicated team members working together to make it easier for our customers by providing proactive safety and operational solutions. As Canada’s largest distributor of industrial supplies, they offer the largest selection of in-stock brand-name products from the world’s top manufacturers and the largest exclusive private-label offering in the industry.

  • Generated ad-hoc reports and analyses tailored to business needs, focusing on reducing overdue open orders.
  • Collaborated closely with managers and peers to streamline the process of closing outstanding orders, enhancing operational efficiency.
  • Produced daily and weekly standard reports for leaders and managers, facilitating data-driven decision-making in Field Support and Order Management.
  • Provided comprehensive support to the open order team, addressing inquiries and offering insights on specific reports at varying levels of detail.
  • Continuously evaluated and refined standard reporting processes to identify opportunities for enhancement.
  • Leveraged tools such as Teradata, Microsoft Access, SQL Server, and Excel Pivots to develop and deliver daily reports.
  • Contributed to cross-functional teams and projects, ensuring the effective resolution of Supplier Management issues and alignment with productivity and quality objectives.
  • Executed large-scale data insertion and extraction operations within existing database structures to support operational needs.
  • Conducted extensive data manipulations and generated ad-hoc reports to address evolving business requirements..

Jan 2017 - Apr 2017

Business Developer

from Jan 2017 to Apr 2017

Applied Machines for Telecom and IT Corp.

AMTIT is a Saudi telecom company that represents Mitel and AFL in Saudia Arabia. The company provides Mitel IP telephony and hospitality solutions for all business structures in addition to offering AFL fiber optic products to various government agencies. AMTIT is a subsidiary of GMATechs, a Canadian company.

  • Pitched new strategies during boardroom meetings.
  • Helped the company generate new qualified leads.
  • Delivered presentations to clients in addition to scheduling appointments.
  • Further contributed to business growth by engaging in follow-up sales activities.
  • Provided excellent customer service that led to the company maintaining healthy client-business relationships.
  • Served as a team player by working closely with the Gulf Cooperation Council (GCC) Mitel Committee.
  • Monitored monthly sales and technical performance for improvement opportunities.
  • Established and spearheaded a software development department that led to an additional stream of revenue.
Jan 2014 - Dec 2016

SQL Data Analyst

from Jan 2014 to Dec 2016

ERIS - Environmental Risk Information Services

Environmental Risk Information Service Ltd. (ERIS) is North America’s provider of property related environmental risk information. ERIS delivers accurate, affordable, on-demand research services for property related data and reference materials. The ERIS system electronically accesses federal, provincial, and private sector databases containing millions of current and historical environment records to identify potential environmental threats on Canadian properties. Key responsibilities include:

  • Conducted thorough analysis and optimization of database designs pertaining to environmental data sourced from government agencies.
  • Designed and implemented PL/SQL programs within Oracle Developer, enabling data reading, manipulation, analysis, and resolution of a diverse range of intermediate to complex database challenges, while keeping data consistency and integrity.
  • Developed SQL scripts to seamlessly import data from diverse formats into existing Oracle database structures, streamlining data management processes.
  • Effectively mapped unstructured data to match existing database structures, enhancing data organization and data integrity.
  • Oversaw the creation, management, and upkeep of user documentation, meticulously tracking and resolving bugs and issues as they arose.
  • Developed comprehensive web scraping programs using Ruby to extract publicly available environmental data from federal and provincial government websites.
  • Facilitated the smooth integration of new team members through active onboarding processes.

Feb 2013 - Nov 2013

Data Architect

from Feb 2013 to Nov 2013

Centennial College

Designed and implemented a complex relational database for a job portal system called College Cornerstone. College Cornerstone allowed employers to connect with non-co-op college students. During the internship, I was fully responsible for data modelling and database development as well as conducted interviews with stakeholders to gather business requirements and presented my technical solution to project sponsors for approval. ERD, wireframes, SQL (DML and DDL), and user stories were delivered successfully to stakeholders. We managed College Cornerstone project through Pivotal Tracker.

Jan 2008 - Dec 2011

Software Developer

from Jan 2008 to Dec 2011

G.M. Applied Technologies Canada Inc.

GMATechs is an import/export firm specializing in telecommunications and engineering consultancy services to facilitate the fulfillment of customer orders, provide advisory support, moving into a software developer role to develop IT business solutions.

  • In SOFTWARE DEVELOPER capacity, worked as business analyst with collaboration of company management to gather requirements for building the company’s database and two customized desktop applications using SQL Server 2008, C# on .NET Framework 3.5 and Visual Studio 2008.
  • Created database and desktop applications designed to secure data and converting the business to a paperless system, in order to assist in performance of daily office duties.
  • Designed desktop applications code in three-tier architecture: presentation layer, business layer and data access layer.
  • Built essential SQL reporting services to facilitate data analysis and decision making.
  • Analyzed database and application design to isolate and eliminate any design flaws and potential security threats, carrying out thorough manual testing and debugging consistently to ensure a proper, functional system.
  • Liaised between company management, copywriter and an external web designer to manage and plan the construction of the company’s website.
  • As CLIENT COORDINATOR, checked client Request for Quotation (RFQ) against stock inventory and in cases where stock is unavailable on-site, contacted vending partners to price products in order to establish a quote.
  • Fielded unspecified product and consulting services requests, forwarding pertinent information to the appropriate third party to solicit a product recommendation and pricing information.

Education

Jan 2014 - Dec 2016

Bachelor of Technology, Applied Engineering

from Jan 2014 to Dec 2016

Memorial University, St. John’s NL

Jan 2012 - Dec 2013

Advanced Diploma in Software Engineering

from Jan 2012 to Dec 2013

Centennial College, Toronto ON

The Software Engineering Technology program has met the national technology accreditation requirements established by the Canadian Council of Technicians and Technologists (CCTT) and, as such, has received national accreditation status by the Canadian Technology Accreditation Board (CTAB). The holder of the Software Engineering Technology advanced diploma is recognized as a Certified Engineering Technologist.

Jan 2007 - Dec 2007

Computer Science Fundamentals – Continuing Education

from Jan 2007 to Dec 2007

Mount Saint Vincent University, Halifax NS

The program covered core principles of programming and computer science.

2010

Oracle SQL Expert Certification

2010

Oracle Certified Developer Associate

2009

Oracle SQL Professional Training

2009 - 2010

Microsoft .NET Certificate of Achievement

from 2009 to 2010

Centennial College, Toronto ON

2009 - 2010

Unix System Administration Professional Training

from 2009 to 2010

Seneca College, Toronto ON

2011

Junior Level Linux Professional Certification

2010

CompTIA Network+ Certification

2010

CompTIA A+ Certification

1999 - 2002

High School (Science)

Miscellaneous

My Favorite Books & Articles

  • Database Systems: Design, Implementation, and Management (Coronel/Morris/ROB).
  • Database Design Pattern: Role-Based Security (Yukon College).
  • Data Modeler's Workbench (Steve Hoberman).
  • Scale: Seven Proven Principles to Grow Your Business and Get Your Life Back
  • Head First Design Patterns (Elisabeth Freeman, Eric Freeman, Bates, Sierra, and Robson).
  • Mastering Business Systems Analysis (Trond Frantzen).
  • Outwitting the Devil by Napoleon Hill

Grab my CV in a PDF Format

Download

Grab My Contact Info!

Skills

My analysis, technical, and management skills allow me to develop technological solutions that meet stakeholders needs. For every project, I keep my eyes on the Iron Triangle, i.e., scope, budget, time, and quality.

Data Analysis (SQL Query)

97%

Data Modeling (Relational Database Management System | RDBMS)

98%

ERD (Entity Relationship Diagram)

96%

Pivotal Tracker

91%

Web Scrapping

95%

MVC Web Development, PHP Codeigniter Framework

94%

Javascript and jQuery

80%

HTML, CSS, and Bootstrap

91%

Object Oriented Programming

93%

Additional tools: VP UML, Microsoft Visio, Microsoft SQL Server, Oracle SQL Developer, MySQL, Access, and Excel.

Note: I offer a comprehensive database training to individuals and groups. The training covers all necessary database topics that allow you to be productive in the workplace. The training is split into two phases: logical phase and implementation (physical) phase. In the logical phase, you'll learn about database design. In the physical phase, you'll learn how to write basic and advanced SQL queries. Start now http://www.SQLDatabaseCourse.com

Portfolio

I listed some of my work below which involved the following technologies: relational database design, Microsoft SQL Server, MySQL, object oriented programming, C#, MVC Codeigniter PHP framework, HTML and CSS, Bootstrap, javascript, jQuery, Microsoft Visio, and system analysis.

Contact

Do not hesitate to email me, or phone me!

  • +(416) 938-4648
Top