Hi Folks, Hope you're doing great there..!
I am wondering if you have consultant available for the below position, if so please respond me with their most updated resume and the best contact number to reach them to discuss about the below role ASAP. Please respond back to *a...@allianceit.com <a...@allianceit.com>* *Note:** Must be local to MA & Must go for F2F interview...!!!!!!!* *Job Title: Data Reporting Analyst/SQL Developer with SharePoint* *Location : Boston, MA* *Duration: 8 months contract* *Hours per Week: 40* *Job Description* *Experience:* We are looking for someone with experience in report writing within a SharePoint 2013 environment utilizing an SQL Server database. *General Qualifications:* *Knowledge of 3rd party Sharepoint applications *Experience in SQL developing and maintaining stored procedures and triggers. *Experience with ETL (SSIS) *Experience with SQL Server Reporting Services and reporting technologies *Experience in application level problem diagnosis and trouble shooting, resolution and testing. *Mandatory Requirements:* *Minimum of 4-6 year's experience in SQL Server Reporting Services and development with SQL technologies *Knowledge of SQL Server database architecture (components and processes of the database) for SQL Server 2014, 2016. *Knowledge of Microsoft SharePoint Lists and API Web Services. *Strong analytic skills *Superior organizational skills, with a disciplined approach to implementation, support and documentation. *Hands-on approach with ability to deliver to commitments. *Self motivated and highly professional with ability to take on responsibility and work independently. *Ability to work under pressure and tight deadlines. *Excellent client (internal & external) communication and liaison skills. *Other Desired Skills:* *Experience with reporting for project collaboration sites is a plus. *Sharepoint Search Content Manager Query Tool a plus. *Microsoft PowerApps a plus. *Development experience using SQL Server Analysis Services. *SharePoint Modal experience. *Work Environment:* We anticipate that this is an assignment lasting up to 1 year for one individual One person on-site in the MassDOT Construction Office (RM 7360) in a cubicle that will be provided. Basic office supplies will be provided. There is no Wifi in the building. MassDOT will supply a desktop and desk phone services. If a contractor brings in their personal laptop, daily security tests must be performed before they connect to the network. *Assignments:* The assignment includes writing code to develop the reports identified below. In addition to code writing ability, we are looking for someone who also has knowledge of 3rd party applications that may be configured to work with our current Sharepoint system. We envision that the work may be a combination of building/writing reporting code, in addition to using existing applications and tools to deliver this assignment. The analyst will need to work closely with MassDOT Engineers and internal and external developers to create the enhancements outlined in the four specific tasks below. 1.One of the most common roles of SharePoint users is that of the Reviewer. MassDOT and other Reviewers have the responsibility of reviewing, commenting, rejecting, accepting or approving technical and contractual documents. Timely reviews keep the project objectives moving and prevent unnecessary contract delays. Some reviewers are responsible for reviews from multiple sites. In the current implementation, a single MassDOT reviewer has to directly access each of the sites to track their assignments and work queue. This assignment includes the creation of a single dashboard the Reviewer can access that would provide a comprehensive view of the Reviewer's assignments including providing status and providing links to review document and associated comments. These reports that feed the dashboard should track assignments and provide others knowledge of individual's workloads and progress. 2.The users of SharePoint need the ability to review submittals within a specific timeframe. It is also critical that the project team can track the status of submittal reviews. MassDOT has limited ability at this point to track submittal status at an enterprise level (across projects). This assignment includes the development of a dashboard that would provide a comprehensive look at MassDOT performance in the submittal process across projects. This dashboard would present data such as statistics (max, min, average, etc.) review turnaround times, status of reviews, trending in the number of rejections or revise and resubmit documents that all affect the projects ability to deliver on time. 3.The third assignment will center around the development of a Reporting Center which would be used to access and manage reports. MassDOT will need the ability to control security to the reporting center and will need to link the reporting center to dashboards. This site would be used as the enterprise administrative center as the number of projects and users grows. 4.This Assignment is the development of project specific reports from data and metadata in InfoPath forms. In addition to canned reports MassDOT will need the ability to create simple to use queries that can mine project specific data to generate custom reports. Thanks & Regards Ajay Singh a...@allianceit.com www.allianceit.com -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at https://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
