Testing the SDTM mapping by performing the SAS data Quality Check.
Working for data comparison against mapped data and raw data.
Will create SAS data set According to SDTM Mapping Specifications.
Used various SAS functions, operators, statements and procedures.
Good knowledge on various SAS products like SAS/BASE, SAS/SQL, SAS/MACROS.
Knowledge on Reading data from various sources like Excel, CSV .
Good knowledge in creation of summary reports using PROC Report, PROC Means, PROC Freq and SQL procedures.
Familiar with Data transformations using PROC Sort, PROC Transpose, PROC Contents, PROC Import, PROC Export, Merge, update and modify statements.
Good knowledge on Character functions, Date functions and Numeric functions, Data Step.
Good knowledge on Creation of Macros and Macro Variables.
DMW Programmer
Accenture Solutions Pvt Ltd
Bengaluru
10.2018 - 08.2023
Creation of MDD and Derivation Specifications.
Study Setup like Creating Source data models, Target Data Models, Creation of BA’s and InForm Link.
Creation of .MDD files to load Target structure.
Mapping for all type of transformations like Direct, Join, Union, Unpivot and Custom.
Have good exposure on promotion of Clinical Data Models, Transformations, VCs and Custom Listings to Higher lifecycles.
According to requirements created Target Models and have done the mapping.
Worked on Oracle LSH module for issue investigation and Custom Program.
Have worked on Validation checks and Custom listings.
Have good exposure on features and functionalities of DMW and LSH.
Have experience on work assignment and project management timelines.
As a Senior DMW programmer trained new joiners on DMW tool.
Worked as a Root Cause Analysis (RCA) Spoc to mitigate issues from SAS QC and UAT Issues.
Worked on Oracle DMW tool to build standard library.
Working as DMW SME and DMW tool trainer, have trained more than 100 resources on DMW tool.
Excellent communication skills, Good at Team work, Decision making, meeting the timelines, adaptable to any circumstances.
Producing quality driven work with productivity.
Expertise in CDISC SDTM Mapping and in-depth knowledge of clinical data and CDISC SDTM implementation guide.
Data Mapping Programmer
Accenture Solutions Pvt Ltd
Bengaluru
08.2014 - 10.2018
Creation of SDTM Specifications and Define as per study requirement.
Drive/Lead discussion to translate client needs in terms of system functionality to ensure match between needs and system capabilities.
Promotion of Mappings to CDR DEV, UAT and Prod lifecycle.
Creation of SDTM311 dataset.
Manage the Project plan, Identify and communicate relevant changes proactively, identify risks and manage risk mitigation plans with all relevant stakeholders.
Understand the usage of CDISC SDTM guidance rules to annotate a CRF with SDTM domains and variables.
Responsible for Unit Testing, peer review and code reviews.
Execute Quality Control and Software quality Assurance test scripts.
Handling study activities End to End with respect to Mapping Process.
Serve as point of contact. Ensure that development functions are aligned to meet project management timelines.
Ensure there are no quality findings of SDTM Mapping.
Mentor new Data Mapping Programmers in their role, assist with questions and provide guidance on delivery.