Senior Application Support & Analyst & Database Administrator
Ets.F.A.Kettaneh S.A.
Total years of experience :33 years, 1 Months
• Creating and implementing the source code of new applications..
(AS400, Oracle6i, Oracle 11g, SQL and PL/SQL , Visual Foxpro etc….)
• Provide support and training for all users and insure adequate response time to users’ requests.
• Recommend the necessary modifications to the applications.
• Ensure the reliability and efficiency of the databases in use.
• Support and monitor the databases in use.
• Strong experience utilizing Database platforms such as MS Access, SQL Server, Oracle, AS400, DBF.
• Design and develop new applications, modifications and reports for existing applications
• Data warehousing, data modeling, data designing, and data migration.
• Design processes and tools to allow data to be more accurate and more accessible.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Generate all required reports to excel to all departments and special reports to external audits.
• Data migration from / to Oracle Database (Excel, text files, Access and DBF etc…)
• Knowledge in BIGDATA
• Experience working with Relational Databases like MS SQL Server and Oracle, AS400 etc.
• Meet with users, collect requirements, write specifications, design wireframes
• Communicate with business stakeholders and leaders.
• Developing technical Documents to represent the design and code of new applications and tables.
• Write test cases, implement quality assurance and design sprints.
• Implement and maintain the new module in tablets in order to generate the invoicing, collection and survey online (Workforce and Mforce)
• Collect Data from Tablet (Survey etc…)
• Strong experience in SQL and PL /SQL with Oracle, SQL Server
• Experience of working with Data Access Technology e.g.ODBC
• Knowledge of Database administration.
• Knowledge of working with Data Analytics development
• Experience in designing and building Datawarehouse
• Design, maintain and execute automated and manual test scenarios
• Oracle Developer (Forms and Reports) in all modules
o Sales
o Leasing
o Auto After Sales & Workshop
o CRM
o Bills & collections Management
o Inventory
o Purchasing
o Payables
o Accounting
o Complaint Management
o Assets
o Budget and Target etc….
• Qlik Sense / BI Developer: Creating Dashboard based on Oracle Database or Excel or any source data with or without data warehousing
• Developing, maintaining, enhancing, and supporting Qlik Sense BI dashboards and reports.
• Strong background in data management, data modeling and query
• Programming Wireless Barcode reader, download data, implement, Design & printing Bar code label
• Create module and interface in Excel Macros to facilitate the pivot table, charts and reports for users (Attendees calculation, invoices, presentation and reports)
• Data extraction, analysis and transformation
• Coordinate with the accounting department and auditors to make sure data provided is accurate
• Interface to export all data from tablet to our Application.
• Excellent Knowledge in IMAD Application
• Support to all users in all applications and transactions
• Network Administrator for the group
• Database Administrator
• Key Player to implement all Softwares and install printers
• Team Leader in Analyzing & developing the ERP Application (Accounting, Budget, Finance, Fix Assets, Attendees, Payroll and Stock Management for all departments)
• Maintain users profile
• Training all users on the software
• Training Expert users on the Microsoft office ( Excel, Word, Power point, Access etc...)
• Release all troubleshooting System & Software
• Reports all kind statistics in Excel and Word
• Manage The Payroll to all employees with CNSS rules
Certificate in Forms and Report Oracle10g ,Coaching session with Lebanese coach (representing WYDNER coaches International- Mr.Samir Zehil),PL/SQL Certificate ,workshop I & workshop II for oracle DBA, SQL server, Qlik Sense , Migration data , Expert on Microsoft(Excel and Macros, Word , Power point etc... ), MS Access