Systems Analyst

V2Soft ( www.v2soft.com ) is a global company, headquartered out of Bloomfield Hills, Michigan, with locations in Mexico, Italy, India, China, and Germany. At V2Soft, our mission is to provide high-performance technology solutions to solve real business problems. We become our customer's true partners, enabling both parties to enjoy success. We are committed to promoting diversity in the workplace and believe it has a positive effect on our company and the customers we serve.

Description of Services & Deliverables

• Client requires the services of one Systems Analyst to work under the direction of Client assigned supervisor to achieve the goals and objectives of the MEPIC Technology Upgrade

• Project as approved by a Legislative Budget Request (LBR). The Systems Analyst will be responsible for converting data from existing SQL database structures to a better designed SQL relational database structure.

The person in this position:

• Must analyze the structure, content and quality of the data to be converted.

• Map the data elements from the source tables to target tables ensuring that all necessary data I accounted for.

• Convert the data from the source tables into the target format tables.

• Validate the accuracy and integrity of the converted data.

• Document the data conversion process to include how issues were resolved with particular data elements

• Clearly communicate with stakeholders the data conversion plan

Systems Analyst responsibilities include, but are not limited to the following:

• Planning, Organizing, Integrating, and Implementing requirements with system interfaces, scheduled processes (jobs), functions and features

• Adhering to Client Project Control Processes, Procedures, and Change Control

• Technical issue identification and resolution

• Deployment and Implementation Planning

• Technical leadership in data conversion strategies for successful implementation

• Provide detail and summary reporting to the Project Manager on the progress of completing assignments by the developers

• Develop the programming architecture for converting the data to the new structure

• Coordinate effectively with Client Information Technology Services (ITS) staff required to support the project

• Effectively work with the Office of Statewide Investigative Systems (OSIS) Enforcement and Investigative Services (EIS) Leadership and MEPIC members throughout the software development life cycle to complete this project

Deliverables:

• Documented Detailed Data Conversion Plan

• Converted data ready for import in to the target SQL system

• Reports to support the accurate results of the converted data

• Identification of issues immediately with recommendations to mitigate

• Assistance to the Project Manager ensuring Action Items, Decisions, and optimal design is documented

• Contributor to the Operations & Maintenance Plan

• Knowledge transfer to the Client ITS MEPIC Maintenance Team

Mandatory Skills and Experience:

• Bachelor's degree in computer science, Business Administration, or other related Information Technology (IT) fields

• Minimum of 7 years of work experience designing successful, large-scale IT projects

• Proficient database management system skills to build SQL scripts to extract, transform, and load data from old structures to new structures

• Analysis and understanding of data structures and schemas

• Ability to troubleshoot and resolve issues that arise during the data conversion process

• Ability to clearly communicate with team members and stakeholders about the data conversion process and any issues that arise

• Ability to manage multiple tasks simultaneously and to work under tight deadlines

• Understanding the system from which the data is being moved from and to

• Ability to handle sensitive data responsibly

• Strong SQL programming skills

• Experience in completing the SQL scripts to convert the data within the schedule timeline

• Excellent oral and written communication skills

• Strong collaboration skills with stakeholders and project team

• Ability to communicate the technical data conversion design in non-technical terms for the end-users to understand

• Experience working in a multi-vendor project team members

• Technical understanding of data conversion projects

• Experience designing and programming in development projects

• J2EE/Java (JSP, EJB)

• JBoss 7.x application servers

• JDBC

• MS-SQL 2019 database

• PL/SQL stored procedures, triggers, views, etc.

• XML

Preferred Knowledge Skills and Abilities:

• Government, Law Enforcement, or Public Safety IT projects

• Master's degree in computer science, Business Administration, or other related IT fields or equivalent Project Management work experience

V2Soft is an Equal Opportunity Employer ( EOE).

https://www.v2soft.com/careers - to view all of our open opportunities and to learn more about our benefits.