Ms sql developer vs business intelligence developer

Differences between ms sql developer and business intelligence developer duties and responsibilities

Ms sql developer example responsibilities.

• Design dynamic DTS packages to transfer data between servers, load data into database and achieve data file from different DBMS.
• Create reports using SSRS from OLTP and OLAP data sources and deploy on report server.
• Create reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also work on integration of SharePoint with SSRS.
• Extract, clean, and validate data from XML file into database using XML source.
• Post HTML files to server and update database and return the response back to ASP.NET.
Show more

Business intelligence developer example responsibilities.

• Used TFS for managing versions of the code with in the development team.
• Develop VBA base application to automate testing of report output and test scenarios.
• Manage security privileges for each subject area and dashboards according to user requirements.
• Develop various T-SQL store procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Develop QlikView dashboards using drill down and cyclic grouping and also using input field, table box, list boxes etc.
• Introduce use of statistics, regression, supervise and unsupervise predictive analytics and visualization.
Show more