Freelance Data Manager, Manipulator and Analyst
Freelance
Total des années d'expérience :31 years, 7 Mois
My latest finished project, as a freelancer, was to build data management and business reporting framework for GpsGate Server; a vehicles tracking system. The system receives an average of 800K signals daily for a fleet of 200 vehicles in the first phase, then to be extended to more than 500 vehicles. The scope of work was to convert received signals into important information where management can evaluate drivers conformance to regulations and EHS laws like commitment to specific speeds, harsh turning, harsh acceleration, harsh breaking, using lights properly, and monitoring engine emissions, … etc. Tools used are mySQL, Jaspersoft Reports Server, and Studio.
I can build data management frameworks using any database either connected using native connectors, ODBC, or even ETL.
I'm currently learning C# so I can work within Microsoft environments beside Oracle.
I'm capable of developing solutions using Oracle 8iDB and Oracle Forms/Reports 6i. I already built Payroll, Personnel and time attendance applications using these tools.
Thanks
http://www.jordancarbonate.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
From February 2013 to date (2 years):
Section Head : Information Systems (internal applications development).
Developing applications where MIS systems doesn't cover. Tools used are Oracle Forms/Reports 6i as a front end connected to Oracle 8i Database as a backend.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
From September 2008 to February 2013 (4 years):
Head of HR and ADMIN Supervisors.
Managing and Controlling the following Operations and transactions:
1. Payroll: with different benefits and compensations (including the 13th, 14th and 15th salaries).
2. Personnel: for around 350 active workers in different organizational levels.
3. Time Attendance: with different work hours and shifts, multiple work groups, multiple attendance Groups, multiple work locations, and multiple entrance gates.
4. In-house Medical Coverage: for around 1450 beneficiary (workers and their family members).
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
from March 2007 to September 2008 (1 year 7 months):
Programmer.
1. Establishing internal ERP development activities.
2. Taking care of Oracle 8i Backups, Restore, Performance Tuning, compiled Forms/Reports Clients Updates, and coordinating with developers for requirements.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
from August 2005 - to March 2007 (1 year 7 months):
IT Administrator.
Managing all IT related issues in a WAN of 3 locations. Setting Standards and Procedures. Setting SLA's.
http://www.amc.com.jo
AMC is a Jordan National Bank Subsidiary Company Funded by USAID.
1. Automating the management systems & work procedures.
2. Managing & controlling the Information Systems & Technologies.
3. Managing the Head Office BackOffice daily operations.
--------------------------- Details:
1. Restructuring Operations. Now we treat branches as a self-dependence working units in a decentralized environment.
2. The Operations Department has been divided into Servicing Units related to the Working Units. A Support Unit has been created to support the working units.
3. Shifting from (the user is the owner of the PC) to (any employee can use any PC) methodology.
4. The lending electronic-records stored into Excel Sheets has been gathered, filtered, its data cleaned, and converted into MS SQL database with MS Access interface. Critical manual business process (cheques handling) has been totally automated. These solutions were developed using Access2000, MS SQL 7.0, Oracle 8i, and MS Exchange5.0.
5. A new “Fully Integrated” Accounting, Payroll, Personnel, Fixed Assets, Cheques Processing, and Loan Tracking systems has been implemented.
http://www.tamweelcom.org
JMCC is a USAID funded project.
1. Developing the management systems & work procedures.
2. Managing & controlling the “Account Receivables” accounting transactions, and the Information Systems & Technologies.
3. The systems I developed were sold to two competitors, and I’ve been awarded “The Employee Of The Year”.
--------------------------- Details:
1. Participated in the establishment of the company, witnessed the rapid and fast expansion of its activities, and played a major role in its success.
2. Since September 1999, I've participated in the evaluation of MIS systems to implement a unified MIS system for 4 microfinance institutions in Jordan. The evaluation process was under supervision of AMIR (http://www.amir-jordan.org) and two consultation firms \[Chemonics (http://www.chemonics.com)and Talal Abu Ghazalih (http://www.tagi.com)\]:
2.1 A member in a team consisted of 3 MIS managers and 1 operation manager to re-evaluate 1 MIS System from Uganda.
2.2 A member in a team consisted of 1 component Leader, 1 consultant, and 3 MIS managers to evaluate 3 MIS Systems, 2 in Cairo/Egypt, and 1 in Alexandria/Egypt.
2.3 A member in a team consisted of 1 component leader, 2 consultants, and myself to evaluate 1 MIS System in Aqaba/Jordan.
2.4 A member in a team consisted of 1 (team of consultants) leader, 3 consultants, 1 MIS manager + myself, 2 executive director, 3 accounting managers, 3 operation managers to evaluate 2 MIS systems in Amman.
3. The Computerized Loan Tracking System that I have developed has been chosen by 2 microfinance institutions to be used to process and track their transactions. One of these institutions is a U.S.A. microfinance institution. This system was developed using Access2000 and MS Exchange5.0.
4. I’ve been awarded “The Employee of the Year” for my participation of the Microfiance Industry Success in Jordan.
http://www.jordan-kuwait-bank.com
1. Participated in the development of the Branch Automation System.
2. Supported different departments technical activities.
3. Administered SWIFT interface & connection.
4. Being the heterogeneous data exchange solution provider.
5. Have been chosen to give 4 courses 2 of them were given to senior managers.
--------------------------- Details:
1. The most memorable and highly self-proud-off project was when I managed to download client account statements from the mainframes and manipulated the records to be imported into Access97 database through e-Mail account to keep Nablus Branch updated. This Solution downsized the telephone bill from around JD6000/- to JD2000/-. A sophisticated security in-house-developed algorithm on the single-transmission-level was implemented to secure client's information.
2. Assigned to refine the backup procedures. Where a totally new backup system and standards were created supported by a complete set of follow-up forms to secure the bank's achievements. The simple logic behind the system enabled the Operations Team to deal with different types of storage media and different backup-ages easily.
3. Member of Jordan Kuwait Bank Branch Automation Project (Navigator) team. My responsibilities were focused on developing S.W.I.F.T. messaging structure, Traveler Checks, and Deposits. Direct responsible of localization.
4. I've been the S.W.I.F.T. Interface (NovaSWIFT) administrator, technical support, and trainer. S.W.I.F.T. is the first choice for inter-bank financial telecommunication, and the financial standards builder.
5. Acted as Heterogeneous data exchange environment solution provider, creator, and implementer.
6. Checkbook Printing & MicerReaders Clearing Systems follow up & development.
7. I've been responsible of PC Technical Support & Help Desk team.
8. I also gave 4 courses.
Worked on developing a number of projects. My main tasks were to localize CAD systems related to sign making. A complete localization project was developed to "Vinyl Cad" application under DOS environment.
Worked on different departments, starting from the office management ending in the internal control team . My duties were concentrating on office automation and internal auditing.
Associate Technical Certificate (2 years diploma)