Sana Shah

Data Engineer

Belgium12 yrs 2 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Expert in Data Engineering and Analytics.
  • Proven track record in automating data processes.
  • Multicultural experience across several countries.
Stackforce AI infers this person is a Data Engineering expert with a strong background in analytics and process automation.

Contact

Skills

Core Skills

Data EngineeringData Analysis

Other Skills

Azure Data FactoryPipelinesPySparkMicrosoft AzureAzure DatabricksAzure Cosmos DBAzure Data LakeXMLData IntegrationSQLMicrosoft OfficeTeamworkAnalysisMarketing StrategyBusiness Strategy

About

I am Indian by blood, and traveled across the globe. Living in Thailand, Israel, Belgium, United Kingdom and finally based in Mumbai has given me the exposure to a multitude of cultures and lifestyles. I am a Data Engineer by profession. I have previously worked at 2 multinational banks managing IT projects and then shifted to analytics consulting

Experience

12 yrs 2 mos
Total Experience
1 yr 11 mos
Average Tenure
5 yrs 8 mos
Current Experience

Loyalytics consulting

Senior Data Engineer

Sep 2020Present · 5 yrs 8 mos · Remote

  • Current Role (March 2023): Data Engineer
  • Providing accurate reflection of sales & inventory for a listed company in Saudi using Pyspark and ADF pipelines by reading XML source data and converting this into a more readable format in datalake. Using this to automate PBI reports for senior members of the company to have visibility on day-1 sales
  • Automated a process to generate their financial ledger sourcing data from multiple sources into the datalake for one-stop view on a weekly basis
  • Previous Role (April 2022-Feb 2023): Account Manager & Data Engineer
  • Managing 2 clients based in the UAE.
  • Supporting one client with transferring data from source system into the Datalake by sourcing the data from SAP using Azure Data Factory pipelines and writing PySpark in Azure Databricks to transform & clean the data, finally writing the data into the datalake. Setting standardized norms to ensure pipelines and python code are running with most cost-effective and time-efficient approach. Additionally ensuring data security in this process.
  • Managing multiple other projects across this client organization to provide a similar approach creating datalake as the master source of data
  • Working with another client to upgrade CRM software to in-house built Swan.ai. Developing their loyalty program by understanding their customer behavior and segmenting their customers
  • Previous Role: Data Analyst
  • A CRM Analyst managing 2 international clients and supporting them with:
  • 1) Customer Analytics - through RFV segmentation
  • 2) Dashboards - Creating & Maintaining reports on PBI
  • 3) Campaign Analytics - strategizing campaigns based on existing KPI's, selecting customer audiences according to requirements, and analysing performance of campaigns
  • 4) Reporting - writing Python & SQL code in Microsoft Databricks & Cosmos DB, using R for the same depending on reporting requirements by the client. Writing monthly reports to highlight progress and success of KPIs.
Azure Data FactoryPipelinesPySparkMicrosoft AzureAzure DatabricksAzure Cosmos DB+4

Caymus technology ventures

Data Analyst

Mar 2020May 2021 · 1 yr 2 mos · Mumbai Metropolitan Region

  • Currently working on an ed-tech platform: www.lore.online as a data analyst, documenting and reporting website traffic, user backgrounds, and sources of traffic to further improve our marketing efforts. I am equipped with Google platforms such as Google Analytics and Google Tag Manager, Facebook Analytics, and HotJar.

Cookie finds

Founder

Jun 2018May 2021 · 2 yrs 11 mos · Belgium

  • CookieFounder - A fun blog currently active on Instagram @cookiefinds which identifies interesting research from around the world supported through numbers! Follow me for fascinating findings !

Ing

Technical Consultant

Apr 2018Aug 2019 · 1 yr 4 mos · Brussels Area, Belgium

  • Worked as part of the centralized transaction screening team, managing rules designed to ensure that customer transactions are correctly screened. Coordinating with Risk teams to understand requirements of these rules, and possible operational and compliance risks. Additionally carrying out audit-based testing to ensure that our IT procedures are robust.
  • Key Deliverables:
  • Designing, implementing and testing new rules for screening of payments upon request from Risk and Compliance teams
  • Designing new rules for decision reapplication (re-applying previously made decisions) and stripping detection features (ensuring that all types of characters are readable by the software) of FMF (Firco-Multi-Filter)
  • Documenting functional description of key concepts implemented in the transaction screening rules file
  • Designing XML mappers for readability in FMF for converting SEPA transactions into FUF messages, ensuring that the messages are compatible with the screening software
  • Investigating the impact of different algorithm configurations for transaction screening using Fircosoft Multi Filter (FMF)
  • Ensuring the correct alerts are generated against Swift Sanctions, and where these alerts are missing, investigating the underlying problem and delivering possible technical solutions
  • Working with SAP Business Objects to design reports required by the business

Exellys

Technical Consultant

Apr 2018Aug 2019 · 1 yr 4 mos · Antwerp Area, Belgium

  • Representing Exellys at ING (as our client), part of the Payments - Transaction Screening team.

The red pen

Process Consultant

Jan 2018Mar 2018 · 2 mos · Mumbai Area, India

  • Process Consultant (Jan 18 - March 18):
  • I am responsible for looking at the existing processes for different service lines, identifying where inefficiencies exist, and ensuring that the right teams are managing different stages of any process. Additionally, I supported the implementation (business side) of a CRM platform by managing testing and coordinating with their IT department for any fixes required.
  • Project & Stakeholder Management – managing various projects in a start-up environment, liaising with different teams to understand pain points and prioritise key issues that significantly affects the work environment.
  • Change Process Design – understanding and documenting existing processes through communication with many different service lines. Identifying the gaps and proposing feasible solutions which can bridge the gap and improve efficiencies in the start-up organisation.

Santander uk

2 roles

Change Management Consultant

Sep 2015Oct 2016 · 1 yr 1 mo

  • I was with Santander’s Corporate and Commercial Bank, where I worked on projects related to the data quality for SCCB and ensuring our data is accurate and meets all regulatory and reporting requirements for the bank. The main driver for these projects relate to the regulation for all banks in the UK: Banking Reform. I have developed many skills during my time here.
  • Skills Gained:
  • Project & Stakeholder Management – managing various projects for the bank, liaising with different teams such as project sponsors, risk, finance and IT to carry out the project through the project lifecycle. Ensuring all changes to the bank are compliant for risk, finance and various other areas of the business
  • Change Process Design – mapping out current processes within the bank, identifying gaps and developing proposals for changes to existing processes to make operational activities more cost-effective and efficient
  • Controls & Governance Reporting – Designing a governance and controls framework to monitor current data quality in the bank and progress for data quality improvements throughout the project lifecycle and upon completion of the project.
  • Requirements Gathering and Documentation – Putting together documents describing business requirements for various different projects in order for IT to translate this into technical requirements.
  • Main Projects:
  • Salesforce - implementing a new customer relationship management (CRM) platform (Salesforce) to improve customer service for SCCB customers with their respective Relationship Directors/Relationship Managers.
  • The Banking Reform - BDP as a Master Source of Data - creating the main Santander database as a master source of data by ensuring feeds from the numerous different systems at Santander accurately transfer information to this database.

Graduate Program - Business Analyst

Sep 2014Sep 2015 · 1 yr

  • On the graduate scheme, worked in 2 departments, Collections and Recoveries and Data Management.
  • I worked within IT Engagement for Collections and Recoveries. As part of this department, we were in the process of launching a new software and I was involved in supporting the testing phase of this project. I helped coordinate any issues raised between the testers and our programers.
  • I worked within Service Delivery for Data Management. My main role in this team was to manage data in Santander systems and ensure data completeness and quality of data. Here, I coordinated with our consultants, Accenture to ensure good quality of data and raised issues when problems were identified during certifications.
  • Skills Developed:
  • Time Management - ensured work completed within deadlines and specified timelines
  • Stakeholder Management - communicated between different stakeholders to ensure requirements are satisfied
  • Presentation - put together presentations for senior management around project updates on a monthly basis.
  • Risk Identification - flagging up risks to relevant teams and working together to identify a solution.

Shell oil company

In-House Recruitment Day ITMB Student

Nov 2013Nov 2013 · 0 mo · London, United Kingdom

  • A 1 day event over 5 hours speaking to senior leaders about their IT experiences and conducting a case study analysis in teams, developing potential solutions to a problem faced on a current project at Shell

Graduate promotions

Student Marketer

Sep 2013Apr 2014 · 7 mos · London, United Kingdom

  • Promoting job opportunities on university campus via different marketing techniques such as games and fun activities on campus. Speaking to students informing them about current opportunities and ways to network with top firms in the UK.

Santander uk corporate & commercial

HR Summer Intern

Jul 2013Sep 2013 · 2 mos · 2 Triton Square, Regents Place London

  • In Rewards & Employee Relations, I put a report together on employee performance results and developed recommendations to improve these scores; simultaneously developing a blueprint for a performance management system. Also, with other HR interns, we researched the costs of short-term sickness at Santander and developed recommendations on how to reduce this.

Intouniversity

Academic Support Mentor

Sep 2012Jun 2013 · 9 mos · Brent Centre London UK

  • I currently attend weekly sessions at a volunteering center named: IntoUniversity. This centre has students coming to them after a long day of school and provides them with a quiet and encouraging environment for students to study and complete their work in. As an academic support mentor, I meet these children weekly and make sure that they are comfortable with the work they complete. Our main goal is to encourage these students to believe that university is a potential future. This is commonly done through many encouraging words we as mentors use to develop self-esteem and confidence within these children.

Abn amro bank n.v.

Research Intern

Jun 2012Aug 2012 · 2 mos · Mumbai

  • At ABM Amro, I researched the macroeconomic position of India in 2012 and the effects of inflation and unemployment on the economy.

Kidz4mation ltd

Marketing Intern

Oct 2011Jun 2012 · 8 mos

  • Developed a marketing strategy to help the company promote their products In a team, we developed a thorough SWOT and PESTLE analysis in addition to growth and development strategies. We met the clients on a bi-monthly basis to discuss their position and their opinions on our recommendations. At the end, we presented these findings to our clients in the form of a formal presentation.

Education

UCL

Bachelor of Science (BSc) — Information Management for Business

Jan 2011Jan 2014

Antwerp International School

International Baccaloreate — International Baccalaureate

Jan 2003Jan 2011

Stackforce found 100+ more professionals with Data Engineering & Data Analysis

Explore similar profiles based on matching skills and experience