Pawan Dhakal Email & Phone Number

Kansas, United States

As a lead database programmer, I am responsible for developing clinical databases using Medidata’s Rave or Oracle Clinical according to study protocol. My responsibilities to the project starts with the database build and continues until the study database has been locked.▪️ Create and maintain the eCRF system for the duration of the study. This includes making database updates due to protocol changes or other issues and database migration.▪️ Program data validations (edit checks), dynamics derivations and custom functions.▪️ Work collaboratively with lead data managers and multiple functional groups including external CROs/Vendors where applicable, to complete EDC build tasks per agreed timelines.▪️ Work with vendors to create Data Transfer Specs. Receive and process the data. Create SAS programs to reconcile lab data transfers.▪️ Create data snapshot and provide support during database lock and post data lock subject data archival processes.▪️ Provides ongoing clinical database support to data management and other members of the study team. ▪️ Contribute strategies as well as innovative and creative solutions to enhance processes and increase productivity of the group.▪️ Be a mentor to junior resources and help perform QC of other team member’s builds.▪️ Support development and maintenance of data management SOPs and WIs.▪️ Provide leadership and consultation in the area of database design and development with Data Managers and external CROs/Vendors where applicable.

Kansas City, Mo

Held full accountability for coding new solutions and enhancement. Responsibilities included designing, writing, testing, and reviewing code, with thorough understanding of requirements and a deep knowledge of software engineering domains and databases. Worked in a team environment to create and enhance owned solutions, and support teams/individuals who used them.▪️ Worked with the team in a deadline driven iterative SDLC. Developed an ability to juggle multiple projects and problem solve. Had proven track record of delivering results in tight schedule projects.▪️ Took full responsibility for the implementation and the completion of new components, services, tools and integration with the existing products.▪️ Held various design discussions for enhancements and fixes to existing solutions. Then wrote up technical specifications that needed to be implemented.▪️ Designed, developed, implemented, and maintained solutions primarily in CCL, and PL/SQL querying against Oracle database.▪️ Provided technical leadership to other engineers on the team through project work, knowledge sharing events and mentoring.▪️ Recently worked on a project to implement GDPR compliance for European clients. This gave me the opportunity to work with all other Cerner solution teams whose applications touched patient data.▪️ Supported team’s various solutions that are used to either migrate, replicate or refresh an Oracle database. This included logging into client domains to troubleshoot.▪️ Conducted numerous Oracle DB migrations using Goldengate, and DB replication using RMAN.▪️ With all that, acquired deep knowledge and experience with SQL based databases.▪️ Played a critical role in an agile team that works with engineers of varying experience levels.

Lenexa, Ks

Supported business requirements through the design, development, and implementation for publishing personalized documents for both transnational and direct marketing applications according to client specifications. Established file requirements and processing specifications for automated. Also monitored and maintained mini-system software and files to assure system integrity.

Olathe, Ks

Converted data from various MLS clients to a web-based product (Paragon). Analyzed and cleaned data, also helped maintain input data file format using FoxPro and MS Access. Wrote data download automation scripts for MLS clients. This replaced outdated manual procedures which in turn increased productivity by 30%.

Bachelor, Computer Information Systems

Education record