Free Newsletters:
DatabaseJournal  
DBANews
 		Database Journal
Search Database Journal:
 
HOME News MS SQL Oracle DB2 Access MySQL PostgreSQL PHP SQL Etc Scripts Links Discussion
internet.com

» HOME
» NEWS
» FEATURES
» SERIES
MS SQL
Oracle
MS Access
MySQL
DB2
» RESOURCES
Products
Scripts
Links
» DISCUSSION
» DBA JOBS





iPod: You Tempted to Touch?

Microsoft Gets 'Live' With Services

Cognos Picks Up Applix For $339M

internet.com
IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers


New Job Search / Search Results / Oracle Report Developer (IL)

Oracle Report Developer (IL) - Next Step Systems
LOCATION: US-IL-Elk Grove Village
COMPANY: Next Step Systems
INTERNAL JOB #: OrclRprtDev-IL-PP
POSTED: 11/19/2009
JOB SKILLS: Database Systems, Software Development
JOB TYPE: W2
START DATE: asap
PAY RATE: $50,000 - $65,000 / year
TRAVEL: none required


JOB DESCRIPTION:
$50-$65K

Key skills: Oracle Report Builder 10g, Oracle Discoverer, PL/SQL, Advanced SQL, MS Access, Database Security, Advanced Excel, Oracle Applications Express, Oracle Portal, XML

Description:
Oracle Developer with 2-4 years of experience in Oracle Reports and Discoverer in a non R11i environment. Extensive experience writing PL/SQL procedures, packages, triggers. Any experience with Oracle Application Express, Oracle Portal and XML Gateway would be a plus. Apply knowledge of Oracle development tools, principles of data modeling to design and create custom reports and analyze and convert financial and/or manufacturing data into business intelligence.

Essential Duties and Responsibilities:
* Interact with subject matter experts and identify data elements and business rules to be embedded in the reports and design Discoverer Business Areas.
* Strong in PL/SQL: Create complex packages, procedures, and functions, performance tuning of SQL code to support ETL activities. Knowledge of Oracle Warehouse Builder is a plus.
* Knowledge of advanced SQL techniques like using Analytical Functions, knowledge of Materialized views, designing data models and ability to transform these into physical database design.
* Proficient in understanding and maintaining existing reports and developing new reports using Oracle Reports Builder 10g.
* To support ad-hoc reporting and analytics, be able to design new data models capturing the business requirements for detailed dimensional analytics and have the ability to independently create Discoverer business areas and their underlying detail and summary folders.
* Knowledge of advanced SQL techniques like using Analytical Functions, knowledge of Materialized views, designing data models and ability to transform these into physical database design.
* Be proficient in understanding and maintaining existing Business Areas and developing new summaries, hierarchies and folders using Oracle Discoverer 10g.

Required Skills:
- Oracle Application Server 9i & 10g
- Oracle Portal 9i & 10g
- Oracle Reports 9i & 10g
- Oracle Discover 9i & 10g
- Oracle Forms 9i & 10g
- Oracle Business Intelligence Suite 9i & 10g

Oracle Reports:
Develop complex Oracle reports that utilize the following:
- Multiple queries
- Multiple groups and levels of repeating frames
- Calls to PL/SQL packages, procedures and functions
- Formula, placeholder and summary columns
- Materialized views
- Format triggers & layout customization
- Lexical parameter
-* Export to Excel
- Oracle Reports deployment in Oracle Application Server 10g

Discoverer:
- Experience with Discoverer Administrator, Discoverer Plus and Discoverer Viewer 10G.
- Work with non Oracle E-Business Applications EULs.
- Design and create business areas to meet business requirements.
- Work with end users to identify most appropriate data and labels.
- Design materialized views and tables for use in Discoverer.
- Use PL/SQL to integrate data sets, perform various calculations and summaries for use by workbooks.
- Maintain joins, hierarchies, item classes.
- Create custom folders and summary folders.
- Create and register custom PL/SQL functions in Discoverer.
- Sharing and scheduling workbooks.
- Know the appropriate usage of Discoverer and its limitations.

Security:
- Setup custom security within Discoverer and Oracle Reports.
- Setup database security within Discoverer.
- Integrate Discoverer with single sign on.
- Administer public and private connections.
- Register Discoverer workbooks within Oracle Portal.
- Administration of Discoverer user privileges.

Education and/or Experience:
- Bachelors degree (B.S.) in Computer Science or equivalent with two to four years related experience and/or training with proven track record; OCP a plus.
- Experience in Business Intelligence, report writing and financial data analytics; be proficient in MS Access, PowerPoint and Word and Advanced in Excel.

CONTACT INFORMATION:
Mike Stapinski
Email Mike Stapinski
 
Next Step Systems
1212 S. Naperville Blvd.
Suite 119
Naperville, IL 60540
630.428.0600 T
http://www.nextstepsystems.com

 
Start New Job Search
Post Your Resume
Jobseeker Login
 
 
 
Resources for Employers:

It's fast and easy. Posting your job takes just minutes.
Target hard to reach passive IT jobseekers.
Post one 30 day job ad for just $279.

With job packs you reduce your cost per posting by up to 50%
Better exposure. Priority postings list at top of job search results.
Job Packs are available in increments of 3, 5, and 10 postings


internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs

Solutions

Whitepapers and eBooks

Microsoft Articles: Visual Studio 2010
Adobe Article: Adobe Helps PHP Developers Create Rich Internet Applications
Microsoft Whitepaper: How Windows Server 2008 R2 Helps Optimize IT and Save You Money
Adobe Article: Java Developers Finding a Home at Adobe Flex
IBM Articles: A Smarter Business Needs Smarter Technology
Intel Xeon Processor Increases Server Efficiency and Capabilities
Intel Tech Brief: Automated Energy Efficiency for the Intelligent Enterprise
Oracle Whitepapers - Innovation for IT Leaders
Avaya Article: Communication-Enabled Mashups--Empowering Both Business Owners and IT
 Internet.com eBook: IT Manager's Guide to Social Networking
Internet.com eBook: Get Ready for Windows 7
Microsoft Article: Expression Web 3--New Features for PHP Developers
Whitepapers: Manage Your Business Infrastracture with IBM
Whitepaper: Maximize Your Storage Investment with HP
Internet.com eBook: Becoming a Better Project Manager
Microsoft Article: Stress Free and Efficient Designer/Developer Collaboration
MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts

Webcast: Connecting PHP to Microsoft Technologies
Video: Microsoft Partner Program Benefits
Video: Windows Azure Debugging Tips
SAP BusinessObjects Webcast: Unlock the Power of Reporting with Crystal Reports
 IBM Webcast: Speed Business Innovation with Reduced Cost and Risk
Video: Deploy Applications on Windows Azure
MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits

Download: Microsoft Visual Studio 2010 Beta 2
Downloads & Free Trials: Microsoft's New Efficiency Resource Center
Get the Windows 7 SDK
 Free Trial: Red Gate SQL Backup Pro 6
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos

Internet.com Hot List: Get the Inside Scoop on the Hottest IT and Developer Products
All About Botnets
 MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES