Technical Implementation Lead Consultant
Shell
مجموع سنوات الخبرة :24 years, 8 أشهر
- Working on a large CRM SAS BI, MA, Real Time Intelligence and Analytics Implementation project at Shell Global using SAS Enterprise Guide, DI Studio, Information Map Studio, CI Studio and Web Report Studio
- Involved in designing, planning and execution of migration from SAS V9.3 to V9.4 with SAS Grid.
- Involved in requirement gathering, analysis, design and development of business processes and data integration processes for setting up Adobe Campaign to work with existing SAS data warehouse.
- Involved in designing and developing decision campaigns using SAS RTDM and SAS Decision Manager for real time offer management and redemption.
- Worked on design and implementation of SAS RTDM, SAS Grid, SAS Decision Manager (BRM), and data integration project to migrate complex business rules from legacy system to Business Rule Flows and integrating it with SAS RTDM campaign diagrams.
- Added score cards and Risk Model Management score nodes to the newly developed campaign diagrams. The generated data was then used for score card performance reporting.
- Involved in documenting, presenting and finalising multiple options for recording audit trails with business users and stake holders.
- Designed and implemented audit trails using data processes to store complete life cycle of a credit application case on Oracle database.
Working on a large CRM SAS BI, MA, Real Time Intelligence and Analytics Implementation project at Shell Global using SAS EG 5.1, DI Studio 4.6, Information Map 4.31, CI Studio, Web Report Studio 4.31)
Responsible for designing and developing interface for SAS Real-time Decision Manager (RTDM) that is used to handle the next tasks in each loyalty card transaction like get rewards and finalise rewards.
Responsible for design and development of ETL for Reporting Data Warehouse to monitor TRB and Air Miles offers burned by loyalty customers and the rewards accrued, baskets spend, composition of loyalty customers and Fraud detections.
Creating Tech Design document for end to end reporting solution including Logical and Physical Data Model.
Defining a consistent naming of metrics and categories (dimensions) across the project.
SDC is a supplier of IT solutions to over 140 Nordic banks.
Working on a large ETL project that integrates Core Banking data with other systems to implement Analytics/Advance Risk Management/Marketing Data mart using SAS EG, DI Studio and Teradata as database
Responsible for design and development (using SAS DI Studio) to add new sources and extend existing sources in the currently operational ETL flow.
Working on a large CRM SAS BI, MA and Analytics Implementation project at Shell Global using SAS EG 5.1, DI Studio 4.6, Information Map 4.31, CI Studio, Web Report Studio 4.31)
Responsible for design and development (using SAS DI Studio 4.6) activities for a complete BI, Marketing Automation solution while ensuring a holistic data solution and testing the interfaces.
Designing, modelling and implementing control frame work (MSSQL Server 2013) to ensure data integrity, validation, accuracy, audit and reconciliation from source to data marts and output the responses back to source systems.
Responsible for managing multiple third party teams providing system source data, middle ware services and outbound communication channels for marketing campaign results.
Worked as a Real Time Intelligence Consultant, part of Knowledge and Insight team.
Designed and implemented operational databases used by the RTI decision systems and web applications.
Data modeled and designed new relational databases and orchestrating new ETL processes for the replacement Strategic Data Enhancement (SDE) BI application using SAS, Oracle Stored Procedure, Functions and Packages.
Designed and implemented ETL processes between central data sources and the RTI operational databases in accordance with business requirements using Oracle, SAS DI Studio, Base SAS, Macro and SAS Enterprise Guide.
Designed and implemented ETL processes to deliver application usage logged data in support of analytical data requirements that include commercial performance reporting and monitoring of the decisioning logic.
Tested data processes prior to go-live to ensure satisfactory, fail safe performance working with test management to resolve identified system defects.
Built a customer-centric view; ran several campaigns; recorded response rates and created ROI reports, as part of a SAS pilot project team with SAS being used to create campaigns to set appointments for field sales team. SAS products utilised were SAS Base, SAS Macro, DI Studio, Marketing Automation components like Information Maps, Campaign Studio, Enterprise Guide and Management Console with the environment being used was Unix server and Windows Client. The results showed significantly increased response rates
Master of Business Administration in Marketing Management