Gaby J Email & Phone Number

Sydney, Nsw, Au

Sydney, New South Wales, Au

Providing service consultation, Retail software and BI tools deployment, data integration, ETL processes, and data integrity, requirement gathering, hands-on development, system architecture, backlog management, documentations to releases and support using Lean approach and agile methodologies. Core Responsibilities: Planning and implementing BI tools and retail software projects, including new clients and services/upgrades.  Designing, developing, testing, and implementing relational databases and procedural database code for the support team. Identify opportunities to develop new or improve existing features. Managing the phases of implementation of the BI tools and Retail software. Integration between the implemented software and existing or new software. Created and monitored the development of functions and procedures for item loading, reporting, product search, different vouchers create and update. Optimizing query performance and populating test data. Overseeing clients’ databases performance using Procedures, Functions, Cursors and Triggers. Performing quality assurance and testing of SQL server environment. Training clients in using implemented software projects.

Dubai, Ae

Overseeing the development of relational databases optimized to provide data to 36 high ranking Gulf websites. Analysed and interpreted data feed sources (FTP connections, direct server queries, raw data files) to migrate data from various data formats into SQL Server databases using daily automated import processes (DTS and SSIS packages, etc.). Responsible for troubleshooting database issues and engaged in problem solving tasks involving data feed transformations. Core Responsibilities: Management and analysis of the subscribers Database using Silverpop and local Microsoft SQL 2012/2014/2016 for more than 36 high ranking Gulf websites. Planned the work process for data transformation and data integrity of all databases used for the websites, including platform changes or new projects. Consistently met deadlines for data transformation and implementation of projects while working with software development and client service teams to further improve the products. Created programs, scoring models, alerts, automated mailing, and opt-in/opt-out forms. Testing and scheduling the dispatch of campaigns according to plans or suggested date and time preferences of the client base. Overseeing databases performance. Followed up with the latest technologies and best practices to ensure best deliverability and performance.

NEW ERA provides business oriented IT solutions to clients in the retail industry providing total solutions including our own retail management software “EraPOS”. Involved in the whole Software Development Life Cycle (SDLC) from requirements gathering, application architecture to support.Core Responsibilities: Plan, lead, organize & control development efforts and resources for designated application software. Designed database, tables and views structure for the application. Successfully transferred inbound data from various sources like flat files, MS Access, and Excel into database using SSIS Packages. Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application. Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files. Responsible for optimizing SQL queries, stored procedures to improve the performance time. Designed and documented detailed system architecture along with supervising team members’ code standards and coding best practices. Research & Implement versatile new technologies, modifying system architecture and using new solutions to tricky development problems.  Deploying customizations for the companies clients, and actively participate in projects. Embrace emerging standards while promoting best practices in order to push the limits. Translated the business requirements to the deployment personnel, supervised and motivated staff, ensuring timely delivery of equipment and supplies needed and process documentation.  Identified potential problems and presented desirable solutions to ensure timely and cost-effective delivery. 3rd Party Software Integration with the Product (for example MS GP, NAV).

PDS is one of the biggest drug warehouses in Jordan. Managed the IT department, focusing on the development of the inventory software and data analysis. Core Responsibilities:  Designed and developed application in sending Emails of Daily Reports using DB Mail configuration to send Mails via SMTP Mail server. Developed Stored Procedures, Triggers, and created indexes. Created Database Tables and database views. Created batch job processing, scheduling and production support. Implemented batch job processing, scheduling and production support Provided a more detailed and useful analytical reports for the company’s marketing, purchasing and sales department which increased profitability and eliminated waste in both time and inventory aspects.  Managed the company’s computer networks (including maintenance, exchange server and The ISP server). Managed the transition between SQL 2000 to SQL 2005.

Master'S Degree, Business Administration - International Business

Bachelor'S Degree, Computer Science Major - Banking And Financing Minor

Tawjihi, Science