Data Scientist Manager
Marcura FZE
مجموع سنوات الخبرة :12 years, 8 أشهر
Partnered directly with executive teams as the first in-house data hire to formulate and report on KPIs across duTV and duApp digital platform that received 170M visitors annually using SQL.
• Conducted research on emerging technologies in order to stay ahead of the competition.
• Collaborated with data, analytics and marketing teams to create reports based on customer behavior
analysis for strategic decision-making purposes.
• Collaborated with data, analytics and marketing teams to create reports based on customer behavior
analysis for strategic decision-making purposes.
Built a logistic regression model to help the SEO team decide to which keyword to target, resulting in
15% lift in YoY site visitors.
• Collaborated with product managers to perform cohort analysis that identified an opportunity toreduce
pricing by 22% for a segment of users to boost yearly revenue by $170K.
• Developed root cause report to address problems with customer conversions, successfully revealing insights that boosted conversion by 32%.
• Created a Cloud data lake to centralize all company information, whichimproved efficiency and reduced errors by 95%.
• Managed the development of an enterprise resource planning system that streamlined business processes and increased productivity by 40%.
Project Name : Epsilon Email management For Dell Products
Project Domain : Digital marketing
Client : Epsilon.
Environment : Informatica, DataStage 8.1/9.1, Oracle, SAP, Windows XP, UNIX.
Duration : Jan’2014 to September 2016
Team size : 04
Role : Sr.ETL Developer
Description:
The Scope of the project is to develop data warehouse for different campaigns, with initial step of project being, capturing all the details of consumers and subscribers who has visited Dell website. Next step is to send mails to those customers based on the type of campaign. Foe Ex. Behavioral targeting campaign, Business as usual campaigns, saved-cart campaign, welcome series campaigns, did you forget campaign etc. To deploy emails, we should suppress and scrub email ids based on customer op-touts, unsubscribers, and apply necessary transformation rules to remove op-tout email ids. And also attach coupons to emails if the customers are eligible for special offers.
Responsibilities:
• Used Data Stage Designer to design and develop jobs for extracting, transforming, and loading data into different Data Marts.
• Used several stages like Sequential file, Lookup, Filter, Transformer, Funnel, Join, Surrogate Key, Dataset during the development process of the Data Stage jobs..
• Mapped the source and target databases by studying the specifications and analyzing the required transforms.
• Worked with several kinds of docs like source to target mapping docs and test case docs etc.
• Extensively used Processing stages likeLookup, join, and merge, Transformer, Filter stage. And debugging stages like Row generator, Peek stage while testing the Data Stage jobs.
As a ETL datastage Developer, Preparing Tech Specs Documents, Designing Datastage Jobs, Performing Unit Testing for Jobs.Writing Shell Scripts and executing them.Supporting for Onsite Developers and Testers. Delivering training on project and tool to newly joined peers.
Academic Details: •