SQL Developer

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 Oracle's 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 client's 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.

References and Past Performance:

• Provide references from previous clients for whom similar SAS to Oracle conversion projects have been successfully completed.

• Case studies or documented success stories showcasing the vendor’s expertise and successful project outcomes.

Training and Support Capabilities:

• Ability to provide comprehensive training and knowledge transfer sessions for the client’s 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.

Solution & Timeline:

• This effort needs to be completed in a 5-month timeframe, with one additional month for post-production support.