Accela Programmer Analyst

25 Nov 2024

Vacancy expired!

IDEALFORCE has a

CONTRACT position available immediately for a

Accela Programmer Analyst to join our customer in

Lansing, MI. This is an

ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity.

Job Summary:-BPL/MI LARA (MiPLUS) instance.-BCC/BFS/LARA Instance.-MRA/MIMM Instance.-CSCL/MiCLEAR instance-MIOSHA/MIHS instance-Support interfaces for above instances, including CEPAS and SIGMA.

Duties are given below:-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.o Capture business requirements and document process for data migration covering details for extraction, cleansing, transformation logics.o Design technical report specifications and create report standards.o 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 of each agency. o Write SQL queries to develop Crystal reports, SSRS, and Power BI dashboards for Licensed Professionals, Bureaus by leveraging the understanding of L2K and Accela's data model.o Write, modify, and debug applications using java script. Develop event-based scripts, batch jobs, reports automation in Accela using JavaScript.o 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.o Work with Power BI/Accela Insights dashboard, creating complicated dashboard presentations for executive management.o Configure Crystal reports in Accela’s Report Manager with required parameters.o Work with report users and complete User Acceptance Testing (UAT) and coordinate with support team to deploy the reports into PROD.o 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.o Create shell records in Accela for data conversion processes and Crystal report testing.o Create SQL scripts to backup records created by users after every data conversion and reimport them in Oracle during subsequent data conversions.o Debug issues in PL/SQL, T-SQL programs and fix data migration performance issues, data problems and/or suggest data corrections in L2K.o 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.o Technical Support to Business users to analyze, add, modify Crystal, SSRS, Adhoc, and Power BI reports in Accela.o 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.o Implement reporting best practices, guidelines and repeatable processes for consistency and tracking changes.

Technologies and Tools:-Accela Automation, Accela Citizen Access.-Oracle, SQL Scripting, PL/SQL Programming.-SAP Crystal reports, Power BI, Accela Adhoc report Writer, SAP Business Objects Suite, BI Launchpad, Accela Report Manager, SSRS Reports, Accela Insights dashboard.-SQL Server, T-SQL.-SQL Developer, SQL Server Management Studio (SSMS), Java Script, JIRA, Microsoft Team Foundation Server, MS Office, Subversion, Assembla, Windows 10.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.

THIRD PARTY CANDIDATES:Email your candidate/s resume to jb dot resumes at idealforce.com along with the following details: Rate, Current location and Availability

Disclaimer : The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.

  • ID: #23465001
  • State: Michigan Lansing 86301 Lansing USA
  • City: Lansing
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2021-11-25
  • Deadline: 2022-01-22
  • Category: Et cetera