*We are in need of a Datawarehouse Consultant for one of our clients.* *Location - Portland Orlando. Duration is 6 months, *
* Experience with OpenText and Banner are just luxury skills. DESCRIPTION OF SERVICES: 1. Review vendor documentation of ERP solution to determine what changes are needed in the ETL, warehouse db, and/or data models; make all necessary changes; test solution in coordination with user community, and document said changes. PSU supports SungardHE's ERP solution, Banner. We are upgrading, in March, to version 8.x which requires conversion to UTF8 from ascii and will involve changes to data field definitions. The data extract from Banner to the Data Warehouse, reports and data models need to be reviewed to ensure continued functionality with minimal interruption to users. This may require modifications to the extracts, the warehouse database, the model and potentially reports. The warehousing interface application is OpenText's BI-Query. 2. PSU has a list of user requests concerning reports: existing reports no longer functioning as intended, reports needing enhancements, and request for new reports. We would like to address a subset of these more complex requests. Skills programming in SQL, PL*SQL would be required. 3. The creation of a development warehouse OpenText application product. REQUIRED SKILLS INCLUDE: - advanced verbal and written communication; - ability to communicate effectively with technical and non-technical users - group leadership and project management skills - ability to diagnose/resolve technical problems independently and to lead development and implementation of new and complex solutions. - programming with Oracle tools, SQL, PL*SQL, and with Unix shell scripting. - able to work with sensitive/confidential information and to handle such information as required by Federal, State, and OIT regulations/policies. REQUIRED RECENT EXPERIENCE: - minimum 5 years in data warehousing field that includes ETL, model design and reporting, warehousing methodologies and standards - extensive experience programming with Oracle tools, SQL, PL*SQL, and with Unix scripting - ETL and data modeling DESIRED EXPERIENCE: - SungardHE Banner application and related documentation - experience working within higher education environment - experience working with the OpenText BI Query product - experience building a warehouse from SGHE Banner data ADDITIONAL REQUIREMENTS AND PREFERENCES: Requires ability to work on-site; some flexibility to complete work off-site; approximately 50% of work to be completed on-site in support of analysis, design, testing, and communication with groups of clients/users. * * -- Thanks and Regards Ramesh Kumar Vayu Inc Phone No : 330-474-0573/330-931-4649 Fax No : 330-266-7336 Email : [EMAIL PROTECTED] Web : www.vayuvision.com Yahoo : Ramesh_vayuinc http://www.linkedin.com/pub/9/a90/592 * --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "zilliontechnologies" group. To post to this group, send email to zilliontechnologies@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/zilliontechnologies?hl=en -~----------~----~----~----~------~----~------~--~---