Ms sql developer vs developer/consultant

Differences between ms sql developer and developer/consultant 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

Developer/consultant example responsibilities.

• Manage SDLC development including analysis, writing technical documentation, design, coding, testing.
• Lead the project, development and architecture of an innovative SharePoint contract warehouse, including designing several process improvements.
• Interpret, develop, and enhance graphic, visual & interaction designs in HTML, CSS and JavaScript.
• Work with other web technologies such as AJAX, jQuery, and PHP throughout this redesign.
• Work with AJAX data consisting of JSON responses parsing the same and presenting on the UI layer.
• Coordinate new test environment builds with CICS & DB2 support teams, streamline existing test environments by identifying and eliminating redundancies.
Show more