SAS Data Engineer (Contract) - HSBC Bank - Canary Wharf
(2017-03)
The Finance Change delivery team is primarily responsible for maintaining and enhancing the Retail and Wholesale Expected Credit Loss Risk Model building engine, as well as producing supplementary reports and dashboards in SAS VA.
- Integrating and managing the data mappings from the client's data sources (Oracle, SAP) to the IFRS9 SAS Impairment calculation engine.
- Actively worked on cloud environments like GCP and AWS for data migration from the SAS IFRS9 engine.
- Perform analytical and programming activities including requirement gathering, impact assessment, design, development, unit testing, UAT support, implementation, and documentation of integrating the data management solutions.
- Responsible for Enterprise Data Warehouse and mapping data from multiple sources (including Oracle, Teradata, flat files, Excel, SAP, and XML files), building and implementing the data flows, and loading the SAS credit actual data into Hive and Qliksense dashboards.
- Developed explorations and reports using SAS VA by loading SAS SPDE data into the LASR server.
- Write Unix shell scripts to automate SAS reports/data extracts for GCP migration.
- Hands-on experience in migrating IFRS9 adjustment process SAS code to Python/Pyspark as part of GCP migration.
- Worked closely with the SAS Admin team to perform DR activities and troubleshoot environment issues.
- Develop SAS scripts to process billions of customer data to derive meaningful reports.
- Designed and implemented end-to-end SAS code base to perform adjustments to ECL values fed by Impairment engine based on different economic conditions.
- Extensively used various SAS applications to support the IFRS9 program and was responsible for fine-tuning load-balancing tasks.
Data Engineer (Contract) - RWE NPOWER
(2016-04 - 2016-10)
This team is primarily responsible for the maintenance and enhancement of Enterprise Data warehouse, Dolphin which is built with SAS DI studio 4.6. Dolphins follow a star Schema data model structure.
- Integrating and managing the data mappings from the client's data sources (Oracle, SAP) to the SAS Analytical data mart using SAS DI Studio 4.6
- Perform analytical and programming activities including requirement gathering, impact assessment, design, development, unit testing, UAT support, implementation and documentation of integrating the data management solutions.
- Responsible for building and implementing the data flows and loading the data into Dolphin Analytical/Reporting data mart from various data sources.
- Fine-tuned the performance by reducing Time/Memory/Input-Output operations and created and used indexes, used hash and arrays as lookup tables, compressed SAS data sets, sampled SAS data sets, created and used SAS data views, reduced the length of numeric variables safely.
- Developed numerous PL/SQL scripts and fine-tuned existing scripts as part of support and maintenance.
- Create, modify metadata definitions for raw external files, datasets, database tables using DI Studio
- Creating Stored Processes and webservices to provide business users of the Reporting Data Mart easy access to the data.
SAS Developer (Contract) - Nationwide Building Society
(2015-10 - 2016-03)
This team is primarily responsible for measuring the marketing effectiveness of different marketing campaigns associated with nationwide financial products like credit cards, mortgages, current accounts etc.
- Developed analytics data marts on sql server database for new business transactions of home insurance policies.
- Converted SAS DI Studio jobs into LSF flows that can be automatically triggered by time or file events to run on Platform Process Manager Server and refreshed data on daily basis.
- Perform data cleansing, validation, schedule SAS job flows on daily, weekly and monthly basis.
- Extracting data from Teradata central data base and CSV files, performed data marts data refresh on weekly/monthly and ad hoc basis.
- Meet with business stakeholders and gather reporting requirements as well as validation rules to honour new businesses came through cashback sites.
- Developed a SAS automated reporting job to identify all potential customers who are eligible for Amazon voucher as part of 'Amazon for all' campaign.
- Developed a reporting job for new business transactions via cashback sites like Quidco, TCB and Money supermarket using SAS tools (SAS 9.4) and generated a dashboard for those business numbers in SAS visual analytics.
- Add the internet banking campaign measures to the existing basket of measures and created a dashboard for them using SAS visual analytics.
SAS DI Studio Developer - Direct Line Insurance (through HCL)
(2015-04 - 2015-09)
This team is primarily responsible for the enhancement of datawarehouse and reporting layer of the direct line insurance by revising capital modelling and risk management standards as per the current Solvency II directive. Being a member of this team, responsible for the development of new DI studio jobs as well as maintaining existing ones underlying the risk management application, IRISS.
- Migrated BASE SAS programs to DI Studio as batch jobs and scheduled it as daily/weekly/monthly jobs.
- Building data marts for many areas of organization using DI Studio 4.6.
- Analyze the performance of DI Studio jobs associated with the IRISS application.
- Fine-tuned the performance by reducing Time/Memory/Input-Output operations and created and used indexes, used hash and arrays as lookup tables, compressed SAS data sets, sampled SAS data sets, created and used SAS data views, reduced the length of numeric variables safely.
- Write code to facilitate ad-hoc data extraction requests from the business.
- Develop new DI studio jobs for specific business areas.
- Gathering requirements, design, development, implementation, propose solutions and recommendations.
- Accept incident tickets raised by business users, analyze, investigate, fix or propose solutions.
SAS Analyst (Contract) - TESCO, UK
(2014-11 - 2015-03)
