Pooja N.

Architect

310 dollar
Freelancer
12 years
London, UNITED KINGDOM

My experience

More

ShellJanuary 2010 - Present

Business Domains and Recent Projects
* Retail electric-mobility: Shell Recharge
* Scoped for Europe markets, this is a mobile app for electric vehicle (EV) customers, offers location/navigation services, vehicle charging capability based on services from Shell's partner company NewMotion and integration with Shell customer offerings Loyalty & Offers.
* Tech stack includes Azure App Service, Application Gateway, Redis, API mgmt, Logic Apps, Storage, SQL and React Native, SaaS products.
* New Energies electric-mobility: Shell SmartCharge
* Scoped for US markets initially, this is a smart charge solution based on open protocols for demand-response events and data science algorithms to charge the electric vehicles when the electricity cost is most optimal, it consists of proprietary Raspberry Pi based chargers and offers a mobile app to electric vehicle (EV) customers to schedule the charging window, web portal to site hosts and operators to monitor/maintain charging sessions and scheduled electricity usage reports to energy suppliers.
* Tech stack includes Azure VMs, Containers, Service Bus, Functions, Monitor, API mgmt, Load Balancer, Application Gateway, Functions, Storage, Power BI, Java, Objective C, Python, R, SaaS products.
* Retail Data Platform: Single View of Customer
* This platform aims to provide a single and reliable view of B2C customers which include Loyalty, Mobile Payment, Shell Energy (acquisition of First Utility) customers to Retail and NewEnergies business stakeholders so as to help them identity cross-sell opportunities, execute appropriate marketing campaigns, make real-time offers, points and discounts to customers.
* Tech stack includes Azure VMs, Azure Data Factory, Azure Data Lake, Azure Hadoop, Spark, Data Warehouse, Power BI, Adobe Campaign, Adobe Audience Manager, inhouse Oracle databases, SaaS solutions
* Retail B2B: Shell Fleet App
* This is a mobile app for Shell Fleet small-medium B2B customers to offer convenient and fast self-services of ordering fuel card, choosing bundle, setting limits for drivers, viewing spend and reports.
* Tech stack includes Azure App Service, Redis, API mgmt, Logic Apps, Storage, SQL and React Native, SaaS products.
* Trading: SQL DB migration to Azure, Oracle DB migration to AWS
* Part of Cloud migration program, this project accomplished migration of SQL / Oracle DBs to Azure VMs and SQL to Azure SQL and big some Oracle DBs to AWS RDS
* Tech stack includes Azure, AWS, Oracle, SQL Server
Skills and Responsibilities
* Architect end-to-end IT solutions addressing business process, data, application, technology, information security aspects picking the right mix of build, buy and reuse to deliver the right outcome
* Architect and design Azure based backend for mobile apps - choosing appropriate compute option (IaaS, Paas), App services (Web App, API App), storage services (Blob, Table), data stores (SQL and Cosmos DB)
* Design for auto-scaling, performance, caching (Azure Redis Cache), security (KeyVault), load balancing (using load balancer, application gateway), high availability (virtual machine scale set) to meet the non-functional requirements
* Design security rules to ringfence databases and storage services and network security groups to subnets
* Design for monitoring and alerting based on standard metrics and custom errors, application insights
* Design gateway, management, policies of API through API management
* Design integration of backend with other SaaS services and vendor APIs
* Design data platform using Azure Data Factory, Logic Apps Azure Data Lake, Analysis Services, Power BI
* Produce high level design of end-to-end delivery to ensure that development teams have clear and defined vision to deliver against
* Be the design authority and drive decision-making process by articulating options, rationale and implications
* Execute product selection process taking into consideration the current & future requirements, time to deliver, cost, support, integrations
* Decide appropriate integration patterns and best practices in complex and heterogenous environment
* Decide appropriate architecture style like n-tier, microservice, event-driven based on the business scenarios and technology constraints
* Execute Data Architecture tasks related to data mastership, application/process CRUD matrix, data quality improvement
* Drive data analysis, requirements, flow, storage and life cycle from GDPR and compliance perspective
* Design conceptual and logical data models, advice data engineers, developers and database administrators on the physical data model
* Document and articulate complex solutions and designs to technical and non-technical audiences
* Liaise with specialist architects, business leads, and key suppliers and participate in associated program/product delivery governance
* Participate in steering boards and strategy forums, focusing on and contributing to the long-term business objectives and strategic targets across segments and lines of businesses.
* Strong influencing, negotiating and conflict resolution skills, ability to effectively interact with wide range of business stakeholders
* Actively participate in Functional Excellence activities of architecture community, assist in onboarding new architects

My stack

Languages

SQL, C#, Java, Python, UML

Others

N-tier, Cloud, PaaS, API, Analytics, Alteryx, Problem Solving

Business Intelligence

SQL Server Integration Services

Middleware

Jenkins

Technologies

AWS, Amazon Web Services (AWS), Software Architect, Web API, TOGAF

Other

Objective C, Microsoft C-SHARP, Data Architect, Data Analyst, API management, Software as a Service, ITIL Foundation Certificate, Architect, CRUD, Data Warehousing, Solution Architect, negotiation skills, Back End, GDPR, Platform as a Service, Data Modelling, Python Programming, Scrum Methodology, SAFe, Data Architecture, Mobile Applications, Adobe Audience Manager, Azure Architect, Microsoft Certified Azure Solutions Architect Expert, Oracle Certified Professional ( OCP ) - DBA, UML/OMT

Big Data

Spark, Big Data, Hadoop

Open Source solutions

Kubernetes

Mobile

React Native

Analysis methods and tools

Agile Methodology, Scrum, Kanban, DevOps, Agile

IT Infrastructure

Nagios, Puppet, Cisco, Azure Cloud, Cisco Switches/Routers, Azure, Docker, IaaS, Git

Databases

Database Administration, Microsoft SQL Server, Oracle, Redis