Senior Oracle Developer
SOROOF International
مجموع سنوات الخبرة :13 years, 7 أشهر
Significant Highlights:
• Exhibited avidity and aptitude for owning the responsibility of technical decisions and direction for various projects
• Demonstrated interest in improving the company’s technical awareness, depth and use of technology across the business
Key Deliverables:
• Acting as primary point of contact for communicating with client side. Responsible for interacting with clients to gather requirement, prepare functional design and write gap analysis, migrate data and provide end to end application support
• Participating in evaluating business process, defining functional requirements, preparing test scripts, designing system enhancement process and developing materials for end users
• Checking, verifying, implementing and configuring the system. Making necessary changes in the system to meet business requirements, documenting the project templates, mapping modules and handling system integration
• Preparing database structure such as Tables, Views, Functions, Procedures, Triggers and Jobs. Developing schema objects and executing rules for data integrity. Accountable for designing new applications and enhancements to the existing applications
• Supporting in-house development frameworks which enable other team members to produce new functionality with minimal coding effort and reduce complexity
• Enhancing existing business functionality. Troubleshooting any system failures and discrepancies, recovering solutions and implementing design and test systems
• Leading technical aspect of operations related to escalated client accounts and high severity issues as they confront a project team member
• Attending to both business and technical considerations when designing solutions. Participating in the evolution of company level best practices, standards, and policies as it related to software development
• Defining business need, application scope and objectives, analysis and solution recommendation and application software implementation
• Coordinating all phases of system development and implementation including design, coding, testing, documentation, training and implementation
• Motivating, guiding and managing the development teams and ensuring the release of premium-quality applications that provided intuitive and secure experiences for users
Module Exposure:
HR:
• Built New sub modules (Insurance System, Ticketing System, Employee account System, Manager Account System)
• Built Time-Attendance module (full Cycle)
• Upgraded Procurement, Leaves and e-serves requests Sub Modules
Payroll:
• Created function to make Salary calculation cancelation
• Developed all payslip Reports related to finance department
Inventory:
• Developed new reports, implemented and provided customer support
GL, AP, AR:
• Developed new reports, add customization, implemented and provided customer support
Procurment:
• Developed new reports, add customization, implemented and provided customer support
Budget:
• Built New functions (Budget Transfer, Budget Enhancement)
• Developed new reports related to budget deviation
Academics Modules:
• Built progress report, student support unit and student medical record module
• Upgraded behaviour and attendance and grading module
Projects Undertaken:
• Private Sector:
» Rashid Sad Al-Rashid
» Makasib
• Government Sector:
» Ministry of Petroleum and Mineral Resources
» Prince Sultan Military College
» Armad Forces Hospital - Dharan
• Learning Sector:
» Kingdom Schools
» king Faisal School
» Dhahran Ahliyya School
Responsibilities:
• Assisted Oracle analysts as necessary in troubleshooting software problems. Obtained on-going training to stay current with Oracle application development trends
• Wrote technical specifications for requested software changes, and estimated the work effort to code and unit test those changes
• Attended Oracle or other technical conferences/seminars, as deemed appropriate by manager. Developed and executed unit test plans, and documented the test result for all software modifications
• Followed company standards for design documentation, source control, code documentation, and code migration. Built new reports, forms modification and custamization and bugs fixing on Insurance Systems
• Designed and coded from specifications, analyzed, evaluated, testd, debugged, documented, and implemented complex software apps
• Used coding methods in specific programming languages to initiate or enhance program execution and functionality. Wrote clear codes and prepared coding documentations
• Interfaced with different departments within the organization regarding new deployments. Analyzed data processing functions, methods and procedures
• Performed design and development of Oracle applications according to project requirements. Designed, coded, and maintained the Oracle systems based on established standards
• Modified existing codes to optimize Oracle applications. Assisted in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines.
Responsibilities:
• Gained in depth understanding all customer needs and analysed information problems, requested changes, and required modifications to develop appropriate business process solutions
• Worked with a team to develop and customize Forms, Reports, Database Tables and Procedure etc. as per the customer’s requirement
• Designed a detailed description of user needs. Worked with technical resources to develop, test, and document software. Provided technical assistance to other developers as needed
• Coordinated and collaborated with functional users and IT staff to find solutions to problems identified in testing, resolved issues during systems upgrades, ensured that requirements documentation is easily translated into UAT
• Prepared workflow charts and diagrams to specify in detail business process supported by enterprise systems. Developed effective reporting tools needed to support the business unit information requirements
Module Exposure:
• Fixed Assets, HR/Payroll and Production Modules
• Finance, Sales and Purchase Modules