Job Id: ePC-8381-1 (93891003)
Business Analyst with Sql, Agile, Sharepoint, Visio, Data Cleanup, TFS And Child Support Enforcement Systems Experience
Location: Columbia, SC
Duration: 12 Months
REQUIRED SKILLS :
• 1+ YEARS OF EXPERIENCE AS A BUSINESS ANALYST ON SOFTWARE PROJECTS.
• STRONG ANALYTICAL SKILLS.
• EXPERIENCE WORKING IN THE AGILE SOFTWARE DEVELOPMENT METHODOLOGY.
• UNDERSTANDING OF TECHNICAL CONCEPTS RELATED TO SOFTWARE DEVELOPMENT.
• ABILITY TO READ AND UNDERSTAND DATA MODELS AND TO USE SQL TO QUERY DATA.
• ABILITY TO USE MS OFFICE, SHAREPOINT, VISIO EFFECTIVELY
• STRONG ABILITY TO COMMUNICATE (ORALLY AND WRITTEN) EFFECTIVELY WITH TECHNICAL, NON-TECHNICAL STAFF, CUSTOMERS/STAKEHOLDERS (STATE AND COUNTY) AND EXECUTIVES
• EXPERIENCE WORKING WITH MICROSOFT OFFICE 2010 TO INCLUDE EXCEL, WORD, VISIO, ACCESS, AND POWERPOINT
• 1+ YEARS OF EXPERIENCE IN CHILD SUPPORT ENFORCEMENT SYSTEM DATA CONVERSION
• EXPERIENCE WITH MICROSOFT TEAM FOUNDATION SERVER (TFS)
• BS DEGREE IN RELATED FIELD
SCOPE OF THE PROJECT: THE CFS PROJECT IS PART OF THE AND IS RESPONSIBLE FOR DEVELOPING, IMPLEMENTING, MAINTAINING, AND OBTAINING FEDERAL CERTIFICATION OF A FEDERALLY-MANDATED CHILD SUPPORT ENFORCEMENT SYSTEM (CSES) THAT WILL PROVIDE COMPREHENSIVE SUPPORT TO THE OPERATION OF CHILD SUPPORT ENFORCEMENT (CSE) PROGRAM AS WELL AS FOR COMPLETING THE DEVELOPMENT AND IMPLEMENTATION OF THE FAMILY COURT CASE MANAGEMENT SYSTEM (FCCMS) FOR THE 46 CLERKS OF COURT.
Category Name Required Importance Level Last Used Experience
Database Platforms Team Foundation Server (TFS) 2010 No 3 Entry Within 2 Years < 1 Year Miscellaneous Ability to deal effectively with the needs of technical peers, technical and user management, users, vendors, and staff members, and to communicate clearly and effectively in spoken and written form Yes 2 Entry Within 6 Months < 1 Year Packaged Applications MS Office (Word, Excel, PowerPoint, Visio) Yes 2 Entry Within 6 Months 1 - 2 Years Quality Assurance (QA) SQL Queries Yes 2 Entry Within 6 Months < 1 Year Specialties Business Analyst Yes 1 Entry Within 6 Months 1 - 2 Years Specialties Child Support Enforcement System (CSES) No 2 Entry Within 6 Months 1 - 2 Years DAILY DUTIES / RESPONSIBILITIES: This is an existing position on the CFS Project for a Data Conversion/Business Analyst experienced in Child Support Enforcement Systems and Clerk of Court child support data. The successful candidate will demonstrate a proven ability to collaborate and coordinate activities with diverse groups, including stakeholders, team leads, vendors, project managers, and technical staff. As the Data Conversion/Business Analyst, this individual will: • Assist with the creation of processes and procedures to establish and maintain employer database table that will be used by the new child support system during data conversion. • Analyze employer data from agency and county sources. Cleanup and standardize employer data to a central location • Map employer data to case records from the county sources • Work with Conversion developers on daily basis to ensure conversion mapping rules meets end user expectations • Write SQL queries to verify converted employer data in target system matches legacy and meets conversion mapping rules • Assist project data conversion team by preparing data cleanup reports • Develop and execute test cases for various testing phases for the child support and family court systems • Coordinate with state subject matter experts to confirm system functionality meets end user expectations • Review all relevant vendor documentation including but not limited to business requirements documentation, test plans, design documentation, and data conversion rules. • Review vendor deliverables applicable to the areas of responsibilities in accordance with project plans and processes • Develop a thorough knowledge of the existing child support and family court processes and data