Job Details

Position: Accela Programmer (Ref: 9741)
Location: Lansing, MI 48933 USA
Duration: 1 Years 1 Months 7 Days - Contract
Openings: 1
Deadline: 11/30/2021
Pay Rate:Login

Description:

We are seeking an Accela Programmer who will provide programming, data migration and reporting services to track license related data and processes.

Roles:
• Relies on experience and judgement to plan and accomplish Project, Enhancement, and maintenance work.
• Must be able to work independently on complicated tasks, may lead and direct others, a wide degree of creativity and latitude is expected.
• This person will provide support for the following Accela platform instances; but is not limited to Accela work.
• Analyze systems outlines to develop programs for computer applications, writing solution programs, documenting the methods and procedures used in program development, code reviews, and testing and correcting programs.
• Capture business requirements and document process for data migration covering details for extraction, cleansing, transformation logics.
• Design technical report specifications and create report standards.
• Develop a technical strategy for Data consolidation after data migration, validation of data in reports.
• Maintenance support to keep the systems running smoothly and configured appropriately to meet the business requirements.
• Write SQL queries to develop Crystal reports, SSRS, and Power BI dashboards for Licensed Professionals, Bureaus by leveraging the understanding of Accela's data model.
• Write, modify, and debug applications using java script. Develop event-based scripts, batch jobs, reports automation in Accela using JavaScript.
• Develop complex Crystal reports, SSRS reports, and Power BI dashboards with multiple queries, cross tabs, charts, sub reports, master detail reports, parameters, reporting linking, conditional formatting, sub reports. Implement report level security in Report Manager.
• Work with Power BI/Accela Insights dashboard, creating complicated dashboard presentations for executive management.
• Configure Crystal reports in Accela’s Report Manager with required parameters.
• Work with report users and complete User Acceptance Testing (UAT) and coordinate with support team to deploy the reports into PROD.
• Maintain inventory of all reports, source code in cloud-based Version management tools like Assembla.
• Perform a variety of complicated tasks and ability to make decisions independently as necessary.
• Create shell records in Accela for data conversion processes and Crystal report testing.
• Create SQL scripts to backup records created by users after every data conversion and reimport them in Oracle during subsequent data conversions.
• Debug issues in PL/SQL, T-SQL programs and fix data migration performance issues, data problems and/or suggest data corrections.
• Implement security for reports in Accela's Report Manager to ensure only designated user, groups access the reports.
• Maintenance support to several reports, configuration management, testing and other areas as needed.
• Technical Support to Business users to analyze, add, modify Crystal, SSRS, Adhoc, and Power BI reports in Accela.
• Provide technical support on Accela's Adhoc reporting tool and fine tune Crystal, SSRS, Adhoc, and Power BI reports for SQL performance issues and suggest improvements where necessary.
• Implement reporting best practices, guidelines and repeatable processes for consistency and tracking changes.

Required / Desired Skills

  • Accela Automation, Accela Citizen Access. (Required 3 Years)
  • Oracle, SQL Scripting, PL/SQL Programming. (Required 3 Years)
  • SAP Crystal reports, Power BI, Accela Adhoc report Writer, SAP Business Objects Suite, BI Launchpad, Accela Report Manager, SSRS Reports, Accela Insights dashboard. (Required 3 Years)
  • SQL Server, T-SQL. (Required 3 Years)
  • SQL Developer, SQL Server Management Studio (SSMS), Java Script, JIRA, Microsoft Team Foundation Server, MS Office, Subversion, Assembla, Windows 10. (Required 3 Years)
  • Bachelor’s degree in Computer Science or Computer Engineering or Information Technology, or closely related field or its equivalent is required to perform these job duties. (Required 3 Years)

copyright @ www.ProfessionalTechIntegration.com.2011 All rights reserved
Professional Tech Integration, Inc., Computers  Sys Designers & Consult, Norcross, GA