Hope this email finds you well!!! This is Imtiaz from My3tech
I have an urgent job opportunity with my client Please find Job Description mentioned below and let me know if you are interested and available for below position please reply to *md.imt...@my3tech.com <md.imt...@my3tech.com>* *ob title: BI Developer* *Location: Lansing, MI* *Duration: 12 Months* *Programmer Analyst 3 Description* The person in this role will provide programming, data migration and reporting services to the Michigan Department of Technology, Management and Budget (DTMB) & Licensing and Regulatory Affairs (LARA) to track license related data and processes. This person will work with multiple LARA agencies. 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. - 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. - 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 of each agency. - 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. - 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 in L2K. - 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. *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. *Please Email me a copy of your updated resume along with the details mentioned below**.* *Applicant Details* Full Legal Name: Mobile and Home Phone No: Email ID Mandatory: LinkedIn ID Mandatory: Current Location: US work authorization/ Visa validity: Passport Number Mandatory: Willing to Relocate (Yes/No): Total Experience: Best Time for Evaluation: Best time to reach you: Availability for Project in weeks: Masters / University Name / Year Of passing Bachelors / University Name / Year of passing Rate/Salary: *If this project does not match your exact skills perhaps you know of someone with the necessary experience and availability; if so, please feel free to forward this e-mail at your discretion or pass on their references to me. * Thanks & regards, *Md Imtiaz* 1601 N Harrison Ave, STE # 2B, Pierre, SD 57501 Phone: 605-220-5981 ext 116*|* Direct: 214-758-7404*|* md.imt...@my3tech.com <sjo...@my3tech.com> F: (605) 609-2010 | W: www.my3tech.com *Certified Minority Business Enterprise (MBE)* *An E-Verify Company* *DISCLAIMER: *The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer or if you want to be REMOVED please reply with REMOVE in the Subject line of this email -- You received this message because you are subscribed to the Google Groups "NYC IT Contract Dream Team" group. To unsubscribe from this group and stop receiving emails from it, send an email to nyc-it-contract-dream-team+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nyc-it-contract-dream-team/CAOx7XbkhEGVsZB2QJUrJn0bTbNcRb3QXa1WmyiEhLYz9KFCuWA%40mail.gmail.com.