Darshika Shah

Experience

• 

  Aon Hewitt

  Jun 2016 - Jul 2018

  Configuration Analyst 1

  Projects worked upon : • Annual Enrolment report of 2016 for clients -T – Systems, Johnson&Johnson, Wells Fargo• Annual Enrolment report of 2017 for clients - Williams Lea, Acxiom, Secure Trust Bank, Ferring Pharmaceuticals, DPD Group, DPD World, ABC Bank, JN Bently, Ingeus, Cognizant, CMC Markets, Oracle, SIS UK Online.• Used SAS for pre-processing of data, data extraction, validation, and manipulation.• Create reports using SAS Procs and SQL to review and verify the latest data.• Writing SQL Queries to fetch required data from Database as per the requirements.• Using SET, MERGE, JOIN, SORT, APPEND, CONCATENATE techniques and combine the datasets.• Using SCAN, TRIM, SUBSTR, INTCK,PUT etc functions to transform the data.• Taking calls to understand the requirement from the client.• Full accountability of the task delivered. Show less

• 

  Conduent

  Jul 2018 - Jan 2020

  Technical Business Analysis Engineer 1

  Projects worked on : Adobe , Sage and AMN Inc• Day to Day working on Base SAS 9.4 / EG 7.1 (Data –Step Prgramming ,SAS Functions,Base SAS,Proc SQL).• Exporting/Importing data from/to MS-Excel to/from SAS Dataset and performaing Data validation,Data Cleaning and Data manipulation by SAS/SQL Procedures.• Writing codes to generate the Healthcare benefit reports using Base SAS and SQL in different formats and doing analysis based on these reports.• Experience in data management, cleaning, reporting, manipulation, integration using Base SAS, SAS/SQL, SAS MACRO SAS Procs and Functions.• Having experience of working on several high priority issues, monitoring end to end reports and preparation of daily and monthly reports using SAS SQL.• Complete accountability of quality, timeliness and clarity for work assigned to me.• Updating Daily and weekly reports to support business.• Debugging of BAU codes for smooth business functioning.• Involved in Design and Requirement calls with clients. Show less

• 

  Landmark Group

  Jan 2020 - Apr 2020

  Analytics Consultant

  - Understanding the problem statement through discussion with the team.- Understanding of Marketing/Retail Analytics.- Understanding of various tables in the SAS EG and their refresh frequency.Also Understanding the Oracle database tables.- Involved in the various data extraction activities through SAS programming.- Various adhoc analysis on Lifestyle, Max and home center data. - Campaign Creation from scratch for Lifestyle.- Campaign Management (Weekly run and report analysis)- Redemption Summary Report creation for home center on weekly basis and it's analysis.- Fetching data from Oracle database through pass through query. Show less

• 

  Softtek

  May 2020 - Dec 2021

  Senior Software Engineer

  Account worked on : General Electric (FourQ Systems)

• 

  NatWest Group

  Dec 2021 - now

  • Risk Analytics Lead Analyst

    Jun 2024 - now

  • Risk Associate

    Dec 2021 - Jun 2024