{"id":284,"date":"2017-12-31T18:17:25","date_gmt":"2017-12-31T17:17:25","guid":{"rendered":"http:\/\/bssolutionexpertise.com\/?p=284"},"modified":"2018-01-25T17:07:42","modified_gmt":"2018-01-25T16:07:42","slug":"optimisation-processus-declaratif-rh-annuel-aupres-assurances","status":"publish","type":"post","link":"https:\/\/bssolutionexpertise.com\/index.php\/2017\/12\/31\/optimisation-processus-declaratif-rh-annuel-aupres-assurances\/","title":{"rendered":"Optimisation du processus d\u00e9claratif RH annuel aupr\u00e8s des assurances"},"content":{"rendered":"

<\/p>\n

\n
\n
\n
\n
\n
\n
\n

Optimisation du processus d\u00e9claratif annuel aupr\u00e8s des assurances<\/h1>\n

Contexte<\/h2>\n

Chaque ann\u00e9e une d\u00e9claration compl\u00e9mentaire doit \u00eatre r\u00e9alis\u00e9e par le groupe aupr\u00e8s de certains organismes d’assurance.<\/p>\n

Cette d\u00e9claration doit reprendre des \u00e9l\u00e9ments d\u00e9j\u00e0 d\u00e9clar\u00e9s par le biais de la DADS-U, avec des informations suppl\u00e9mentaires pr\u00e9sentent dans le SIRH.<\/p>\n

Probl\u00e9matique<\/h2>\n

Cette t\u00e2che \u00e9tait r\u00e9alis\u00e9e par une ressource du SIRH sur plusieurs mois. Les donn\u00e9es issues de la DADS-U \u00e9taient charg\u00e9es en base ACCESS. Des donn\u00e9es compl\u00e9mentaires \u00e9taient extraites du SIRH et charg\u00e9es en base ACCESS. Puis pour chacune des caisses d\u00e9clar\u00e9es, des op\u00e9rations de filtrage et de red\u00e9coupage des donn\u00e9es par p\u00e9riode devaient \u00eatre r\u00e9alis\u00e9es (le plus souvent manuellement). Afin de cr\u00e9er le fichier Excel \u00e0 destination des assurances.<\/p>\n

Mission<\/h2>\n

Nous avons remis \u00e0 plat ce processus et r\u00e9alis\u00e9 des optimisations tout au long de ce processus\u00a0:<\/p>\n

    \n
  • Automatiser le contr\u00f4le des donn\u00e9es du r\u00e9f\u00e9rentiel du SIRH.<\/li>\n
  • Automatiser l\u2019extraction de donn\u00e9es r\u00e9f\u00e9rentielles du SIRH \u00e0 d\u00e9clarer.<\/li>\n
  • Automatiser la conversion des donn\u00e9es de la DADS-U en format CSV.<\/li>\n
  • D\u00e9couper en sous p\u00e9riode les donn\u00e9es de la DADS-U en fonction des donn\u00e9es du r\u00e9f\u00e9rentiel \u00e0 d\u00e9clarer.<\/li>\n
  • Automatiser l\u2019extraction des donn\u00e9es du SIRH en format CSV et compl\u00e9ter les donn\u00e9es par p\u00e9riode.<\/li>\n
  • Eclater les r\u00e9sultats par assurance, soci\u00e9t\u00e9 et r\u00e9f\u00e9rentiel.<\/li>\n<\/ul>\n

    Cette mission a \u00e9t\u00e9 r\u00e9alis\u00e9e en 10 jours et permis de faire \u00e9conomiser 50 jours par an.<\/p>\n

    Technologie\u00a0:<\/u> Java \/ JDBC \/ Norme DADS-U \/ POI Excel<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    <\/p>\n<\/div>

    <\/div><\/div><\/div><\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":372,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[7,4],"tags":[],"class_list":["post-284","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n4ds","category-hraccess"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bssolutionexpertise.com\/wp-content\/uploads\/2017\/12\/DADSU.png?fit=240%2C160&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9vk3y-4A","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/posts\/284","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/comments?post=284"}],"version-history":[{"count":4,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/posts\/284\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/posts\/284\/revisions\/373"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/media\/372"}],"wp:attachment":[{"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/media?parent=284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/categories?post=284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bssolutionexpertise.com\/index.php\/wp-json\/wp\/v2\/tags?post=284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}