Consultant-systems integration vs bi consultant

Differences between consultant-systems integration and bi consultant duties and responsibilities

Consultant-systems integration example responsibilities.

• Manage multiple database platforms for potential performance issues, while conducting research and resolution with attention to detail and thorough documentation.
• Provide database support for EDI application.
• Ensure that HIPPA policies and procedures are put in place and EDI transaction requirements are compliant accordingly.
• Used the SDLC methodology to successfully complete the clients' implementation/project in a timely and accurate fashion.
• Work with team to troubleshoot and resolve complex issues (LAN/WAN connectivity, server access, applications).
• Utilize Unix commands and SQL commands to interrogate the databases, processes and directories utilize in the callplan execution.
Show more

Bi consultant example responsibilities.

• Implement QlikView desktop and publisher, manage user authentication, establish publisher tasks, streamline loading procedures and review log.
• Update existing mapping documents and ETL metadata repository.
• Create reports using IDT from more than one data source.
• Optimize existing OLAP databases by reducing number of dimensions, attribute hierarchies and calculations, develop SSAS actions and security layer.
• Develop different reporting and visualization solutions by utilizing SSRS and PowerView.
• Deploy and design cube in SSAS environment incorporating dimensional star schema design.
Show more