PeopleSoft OBIEE Reporting Specialist - BSSI (New York, NY)
Posted: Thursday, January 31, 2013 5:58 PM
BSSI are currently looking for the following resource: Strong SQL skills are essential . Under the auspices of the team leader, the incumbent: Will prepare and upload data for compliant PeopleSoft reporting trees Will run and prepare reports, including PeopleSoft queries and OBIEE extracts Will create ETLs to extract data from the clients PeopleSoft databases Will create ad hoc queries and extracts to defined business requirements using tools such as Toad and Benthic Expected output(s) Task Output Running and enhancing the quarterly reconciliation tool for Atlas GL to sub-module reconciliation Quarterly reconciliation of GL and sub-modules Making the Top 100 queries compliant Compliance of Top 100 queries Creation of tree loader tool for compliant trees Compliant trees uploaded Successful delivery of data integration, data reconciliation projects with ERP applications including Peoplesoft HRMS and Peoplesoft Financials Accurate data extracts to business requirements Analysis of business processes and requirements and transforming requirements into a conceptual model, designing databases, developing and implementing Extraction, Transformation, and Load (ETL) techniques OBIEE extract and reporting database updates Tuning of existing and new SQL queries and extracts Data extraction with performance to client standards Certifications It would be advantageous, but not essential to be certified in: Oracle: Oracle Database 11g: SQL Oracle: Oracle Database 11g: Administration Oracle: OBIEE reporting tool Technical experience requirements: Experience in the following (or near equivalent) is required ETL Tools: Ascential DataStage 8.1/7.5, Reporting Tools: Ideally OBIEE, but Cognos, Business Objects also acceptable, XML publisher Data Modeling Tools: Erwin, or other modelling tool Databases and extraction: Oracle 11g/10g/9i/8i MS SQL Server 2000/2003/2005, MS Access Shell Scripts, Benthic or Toad client interface tool Operating Systems: MS Windows, Solaris and Windows 2000 ERP Software: Peoplesoft Financials, (General Ledger) Educational and experience requirements University degree in a technical subject or business. Ideally in engineering or computer science. 5 years experience of data extraction, ETL tools and SQL Relevant experience in finance/accounting related functions. 5 years experience with PeopleSoft desirable, especially the GL and reporting modules. Excellent analytical skills or experience in reconciliation Excellent communication and writing skills in English Ability to work under pressure and deadlines BSSI is a trading name of BAW UK Ltd.
• Post ID: 36996290 newyork