Programmer analyst-consultant vs bi consultant

Differences between programmer analyst-consultant and bi consultant duties and responsibilities

Programmer analyst-consultant example responsibilities.

• Manage the SDLC of internal and B2B projects and EDI integrations.
• Manage company's databases, ERP systems and overall security on a daily basis.
• Utilize UNIX to FTP payroll files from corporate to mainframe for processing and log files to be process.
• Experience with development environment tools TSO and ISPF.
• Develop a small API to generate fix width format text files using an XML specification file.
• Provide coding modifications of IBM mainframe COBOL programs, JCL, CICS transactions, DB2 tables and create QMF reports.
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