Complete Description:
Job Responsibilities/Tasks:
• Designs, develops and update reports using Business Analyzer (BEx) tools to replicate the existing reports developed in Cognos.
• Extracts and loads data from SAP systems and external Microsoft SQL Server databases.
• Defines, develops, tests and executes all data conversion needs.
• Modifies existing data models and queries for performance gains.
• Provides weekly updates on progress of all assigned work.
• Develops detailed technical specifications.
• Complies with all PTC coding standards.
• Assists in the technical preparation of business process procedures, test scenarios, end-user documentation and user manuals.
• Prepares, develops, executes and validates testing of enterprise data warehouse solutions.
• Works with general business users and functional team members to ensure adequate business requirement coverage for reports.
• Analyzes the requirements and designs the data models to support enterprise data warehouse solutions.
• Develops detailed functional specifications that describe custom changes that are needed to support Commission enterprise data warehouse solutions.
• Analyzes, researches and resolves data warehouse problems.
• Perform related duties as required.
Skills:
SAP BW 7.01 Data Modeling
Required 4 Years
InfoCubes
Required 4 Years
DSOs
Required 4 Years
MultiProviders
Required 4 Years
Transformations including ABAP routines
Required 4 Years
DB Connect, SAP ECC 6.0 and SRM 5.5 DataSources
Required 4 Years
Process Chains
Required 4 Years
SAP Business Explorer (BEx) 7 tools
Required 4 Years
Query Designer
Required 4 Years
Web Application Designer
Required 4 Years
Cognos 8.3 report creation
Highly desired
SAP Portal 7.01 development
Highly desired
HP Quality Center 11.0
Highly desired