Software Developer
Software Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Scope of Work
The work will include but not limited to:
Vendor will convert (re-develop) existing SAS code-based Backend process into an optimized Oracle PL/SQL codebase.
This backend process integrates multiple data-sources massages data implements business logic & business rules and prepares data for final reporting.
Vendor will ensure the converted code maintains the functional equivalence or better and performance efficiency of the original SAS code.
Overall the script does not perform complex conversions using SAS statistical functions it is an ETL process written in SAS that can be transitioned to PL/SQL. ACS was able to convert 15% of the code and did not encounter any technical issue ACS needs vendor assistance due to resource constraints with internal staff.
Detailed Requirements: Analysis and Assessment:
Conduct a thorough analysis of the current SAS code including identifying all macros data steps procedures and any external dependencies.
Design and Planning:
Develop a detailed technical project plan outlining the steps for the conversion process including timelines and milestones.
Pre-Approval of any design changes required from ACS development team
Code Conversion:
Rewrite the SAS code into Oracle PL/SQL ensuring all functionalities are accurately translated and optimized for Oracles architecture.
Testing and Validation:
Conduct comprehensive testing to ensure the converted PL/SQL code produces the same results as the original SAS code. This includes unit testing integration testing and user acceptance testing (UAT).
Parallel testing needs to be done. Execution of SAS code and execution of Oracle PL/SQL code should produce identical results.
Performance Optimization:
Optimize the PL/SQL code to ensure it meets or exceeds the performance of the original SAS code.
Documentation:
Provide detailed documentation for the converted code including architecture diagrams data flow diagrams and code annotations.
Training and Knowledge Transfer:
Offer training sessions and materials for the clients development team to ensure they are proficient in maintaining the new Oracle PL/SQL codebase.
Support and Maintenance:
Provide one month of post-implementation support and maintenance to address any issues that may arise and ensure smooth operation.
Vendor Qualifications
Experience and Expertise:
Proven track record of successfully converting SAS code to Oracle PL/SQL in similar projects.
Deep understanding of both SAS and Oracle PL/SQL including their respective strengths limitations and best practices.
Experience with performance tuning and optimization in Oracle environments.
Familiarity with data warehousing ETL processes and database management.
Technical Skills:
Proficiency in SAS programming and Oracle PL/SQL development.
Expertise in SQL and understanding of relational database concepts.
Knowledge of data modeling database design and schema creation in Oracle.
Ability to use Oracle development tools and utilities effectively.
Project Management:
Demonstrated ability to manage projects including planning execution and delivery within
agreed timelines and budgets.
Strong problem-solving skills and ability to troubleshoot and resolve technical issues promptly.
Training and Support Capabilities:
Ability to provide comprehensive training and knowledge transfer sessions for the clients
team.
Availability of support services post-implementation to address any issues and provide necessary updates or improvements.
Compliance and Security:
Adherence to industry standards and best practices for data security and compliance.
Experience in handling sensitive data and ensuring compliance with relevant regulations.
Employment Type
Full-time
