SAP Data Management Consultant

Genesis Consulting is a leading ERP and Enterprise Agility firm combining innovative Digital Transformation capabilities and enabling skills to provide industry-leading solutions to the federal government. Genesis Consulting is leading an advanced financial management transformation at one of the largest federal civilian agencies that implement programs designed to mitigate the significant risks of farming through crop insurance, conservation programs, farm safety net programs, lending, and disaster programs. The program encompasses integrating dozens of mission critical financial applications to a modern SAP application operating in a FedRamp Certified cloud, while reengineering business process, with the proper internal controls and educating the impacted users and organizations on the future digital platform.

Duties and Responsibilities:

Other duties include but may not be limited to:

• Provide processes and tools for the program to ensure the legacy data being converted to SAP is complete and accurate

• The source data to be converted will be determined by the customer's needs developed as the output of Business Process Re-engineering and industry best practices

• Define the source to target mappings and determine the level of detail needed for transactions to satisfy the audit and DATA Act requirements

• Identify the conversion relevant data in the source systems. In instances where all the required detail level data is not available in a single source system, derive the rules for sourcing and validating the required detail data from secondary related subsidiary or feeder systems

• Elicit and document the requirements for historical data for cleansing and conversion

• Provide the project team information and metrics pertaining to the quality of the source data for decision making (Size the volume and quality of data for each program or group of programs, as appropriate)

• Provide a data governance process

• Refine the data quality through a data governance review process

• Work together as an integrated team with to create a seamless experience for the customer and employee

• Design, build, and test all code and processes required for conversion

• Provide best practices, guidance, and support for data cleansing in preparation for a successful conversion

• Provide best practices and support for data quality assurance during conversion development

• Develop and implement data conversion plan in accordance with agency approved Data Governance Plan

• Develop data profiling, cleansing, reconciliation and ETL processes to cleanse and convert financial data

• Provide effective and efficient management of scope, schedule, and cost for Data Management support

• Demonstrate system capability to handle high volume data conversion with minimum downtime

Requirements

Minimum Qualifications/Experience:

• 3-5 Years of SAP Data Conversion Experience

• 3-5 years of SAP Federal Financial implementation experience

• Experience creating Functional and Technical Specification of Validation Rules- Describing the functional and technical specification of Business validation rules listed per data object.

• Experience creating data profiling report with validation rules- Validation rules will be run to perform specific tests on the data. These tests may validate business rules, target system rules, format of data, or ensure that the data exists in a reference table. The profiling report will provide details on the outcome of running the validation rules

• Experience with data cleansing and creating SAP data validation and ETL programs

• Experience leading and participating in multiple SAP Mock conversion tests

• Experience with converting data from SQL, Informix, DB2, IDMS COBOL and SAP CRM

• Experience with ETL tools- SAP Business Objects Data Services, IBM InfoSphere DataStage, SQL Server Integration Services (SSIS)

Minimum Education:

• Bachelor's Degree- Required

Required Certifications:

• No required certifications

• SAP, Agile, SAFe certifications desired

Other:

• Must be US Citizen