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