Consultant

Job Title : Accela ProgrammerAnalyst

Location : LansingMI

Duration : 12Months

Programmer Analyst 3Description

Duties are given below :

• Analyze systems outlines to develop programs for computerapplications writing solution programs documenting the methods andprocedures used in program development code reviews and testing andcorrecting programs.
• Capture businessrequirements and document process for data migration coveringdetails for extraction cleansing transformation logics.
• Design technical report specifications and create reportstandards.
• Develop a technical strategy forData consolidation after data migration validation of data inreports.
• Maintenancesupport to keep the systems running smoothly and configuredappropriately to meet the business requirements of each agency.
• Write SQL queries to develop Crystal reportsSSRS and Power BI dashboards for Licensed Professionals Bureaus byleveraging the understanding of L2K and Accelas datamodel.
• Developcomplex Crystal reports SSRS reports and Power BI dashboards withmultiple queries cross tabs charts sub reports master detailreports parameters reporting linking conditional formatting subreports.

Implement report level security in ReportManager.

• Work with Power BI / Accela Insightsdashboard creating complicated dashboard presentations forexecutive management.
• Configure Crystalreports in Accelas Report Manager with requiredparameters.
• Work with report users andcomplete User Acceptance Testing (UAT) and coordinate with supportteam to deploy the reports into PROD.
• Maintaininventory of all reports source code in cloudbased Versionmanagement tools like Assembla.
• Perform a variety of complicated tasks and ability tomake decisions independently as necessary.
• Create shell records in Accela for data conversionprocesses and Crystal report testing.
• CreateSQL scripts to backup records created by users after every dataconversion and reimport them in Oracle during subsequent dataconversions.
• Debug issues in PL / SQL TSQLprograms and fix data migration performance issues data problemsand / or suggest data corrections in L2K.
• Implement security for reports in Accelas Report Managerto ensure only designated user groups access thereports.
• Maintenancesupport to several reports configuration management testing andother areas as needed.
• Technical Support toBusiness users to analyze add modify Crystal SSRS Adhoc and PowerBI reports in Accela.
• Provide technicalsupport on Accelas Adhoc reporting tool and fine tune Crystal SSRSAdhoc and Power BI reports for SQL performance issues and suggestimprovements where necessary.
• Implementreporting best practices guidelines and repeatable processes forconsistency 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 WriterSAP Business Objects Suite BI Launchpad Accela Report Manager SSRSReports Accela Insights dashboard.

SQL ServerTSQL.

SQL Developer SQL Server ManagementStudio (SSMS) Java Script JIRA Microsoft Team Foundation Server MSOffice Subversion Assembla Windows 10.

Bachelorsdegree in Computer Science or Computer Engineering or InformationTechnology or closely related field or its equivalent is requiredto perform these job duties.

Accela,Accela Automation,Accela CitizenAccess,SQL Scripting,PL / SQL,Oracle,Crystal Reports,Accela Adhocreport Writer,Business Intelligence,TSQL

Last updated : 2024-06-27