Application Consultant is dedicated resource who works for one client at a time either on-site or off-site. Designed to meet client's overall
demand for technical skills and continuity of knowledge to operate day-to-day business operations.
Streamline process for acquiring experienced talented professionals
Suited for clients that require diversified technical skills
Experienced On-Site or Off-Site data professionals
No need to manage Application Consultants
No need to worry about geographically challenged technical skills
Drug, background and employment verified data professionals
10+ years of professional experience.
Do whatever it takes to meet the clients’ objectives and expectations.
Ensure the quality of all deliverables.
Create and communicate the vision of the solution and modify and re-communicate as needed.
Drive the phasing and other key strategies that underlie the project plan.
Identify and manage project risk factors to ensure timely, cost effective deliveries.
Manage client expectations.
Determine proper staff assignment and ensure that adequate training and education is provided to all members of the team, including those provided by the business community.
Manage daily activities for the project following the approved Project Management methods and procedures.
Handle all project planning, status tracking, team coordination and communication.
Assist in the development and execution of a project communication plan.
Track and resolve project issues.
Track and manage all requests for change in scope or requirements.
Make business aware of the impact of data warehousing on the business and its operational systems and processes.
5+ years of professional experience.
Establish the interviewing approach and coordinate the interviewing process.
Interview the business community to identify user requirements.
Review existing documents that may contain requirements or background information.
Document requirements and assist in clarifying discrepancies in requirements.
Prepare requirements documents and obtain appropriate approvals.
Review and approve data models and business metadata definitions.
Assist in the design and testing of the user interface.
Assist with business process design.
10+ years of professional experience.
Perform the detail data analysis.
Identify the key facts and dimensions necessary to support the business requirements.
Develop the logical dimensional model(s).
Develop entity and attribute descriptions and definitions for the models and ensure that conflicts in descriptions and definitions are resolved.
Conduct User Interviews and Data Analysis Review meetings.
Perform source data quality assessments.
Identify the appropriate data sources with the assistance the business analyst.
Perform the activities necessary to support the standardization of facts and dimensions.
Prepare prototype models to support the development efforts.
Assist the business analyst in mapping the data from source to target.
Assist the business analyst and Data Acquisition team with data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
Perform re-engineering of source models when necessary.
Assist the Data Acquisition Architect to ensure the Data Architecture is applied properly.
Assist the DBA in converting the logical model(s) to physical.
Maintain data in the metadata repository.
10+ years of professional experience.
Set or enforce ETL standards and architecture for the project.
Select appropriate ETL tools and techniques.
Ensure that the ETL requirements are adequately understood and documented.
Design the ETL application architecture based on the documented requirements.
Assist in the development of the ETL application and lead the Data Acquisition development team.
Perform QA functions for the ETL application, including ensuring that system and integration test plans are developed and executed.
Works with DBA, ETL and Business Intelligence teams to make sure the data warehouse is performing adequately.
6+ years of professional experience.
Manages day-to-day task assignment for the team.
Seeks collaboration by all members of the team to resolve issues.
Acts as a contributing member of the project team (i.e. as a developer, analyst, etc.)
Communicates all activities of the team to the Project Manager, including status, issues, and resource needs.
Ensures that the team’s activities and behaviors are in line with the objectives and expectations of the client, and that positive interaction and knowledge transfer occurs.
5+ years of professional experience.
Creates and maintains best practices for ETL processes.
Educates Data Acquisition Developers in building processes utilizing best practices.
“Expert” in chosen ETL software tools.
“Expert” in chosen cleansing tools.
Maintains and supports ETL and cleansing tools.
3+ years of professional experience.
Develop detail ETL specifications based on business requirements.
Develop and test the ETL application following all ETL standards and architecture.
Assist in the design of the ETL application.
Assist in the data analysis effort necessary to resolve issues uncovered relating to source data.
Assist in the development of system and integration test plans.
Execute test plans and document results and discrepancies.
Update and maintain metadata.
5+ years of professional experience.
Creates and maintains data delivery standards to ensure consistent information delivery methods across projects.
“Software Expert” for chosen data delivery tools.
Educates the user community in the use of chosen data delivery tools.
Develop BI applications that meet BI best practices/standards, working towards rapid development and consistency.
Translation of business questions and requirements into reports, views, and BI query objects.
Documentation of current and future metadata and reporting applications.
Testing the Business Intelligence applications and troubleshooting.
Design solutions for projects which are compliant with BI, EDW and Enterprise architectural standards.
Work with Enterprise Architect team to ensure proper integration with EDW platforms and standards.
3+ years of professional experience.
Develop BI applications that meet BI best practices/standards, working towards rapid development and consistency.
Translation of business questions and requirements into reports, views, and BI query objects.
Documentation of current and future metadata and reporting applications.
Testing the Business Intelligence applications and troubleshooting.
Design solutions for projects which are compliant with BI, EDW and Enterprise architectural standards.
Work with Enterprise Architect team to ensure proper integration with EDW platforms and standards.
5+ years of professional experience.
Monitor and manage data warehouse performance as needed
Monitor and manage operational data store performance as needed
Monitor data usage and access
Translate the logical dimensional model to a physical model.
Determine appropriate database sizing.
Generate physical database.
Design and implement the partitioning and indexing strategy for the physical database.
5+ years of professional experience.
Designs and implements the backup and recovery strategy in conjunction with the DBAs.
Performs database administration ensuring data integrity, system availability and performance.
Performs system or network administration activities as directed by Technical Architect.
Performs physical system configuration activities.
Monitors system performance and manages performance tuning activities.
Manages system access and file systems.
Logistics
Application Consultant only work for one client with direct reporting to client's reporting manager. Application Consultant mostly work at client's site.
