Dell Technologies, Bangalore Jul 2021 – Sep 2023
1) Project: Development, Enhancements and refactoring for configure module of Dell ecommerce portal for premier(ConfigRO). Data analytics work with Splunk.
Technology/Tools Used: Dotnet Framework 4.8, Angularjs, C#, Web API, SQL Server 2019, Splunk search 8.2, sql server 2019, VS 2019.
Tasks:
1) Taking care of design, development and enhancement tasks in ConfigRO module; coded support for GoP functionality in the system, refactored pricing logic for Configure and Shop modules, support for CFI modules, caching of content keys and config responses, Windows autopilot support for product modules, BulkCaching of OrderCodes API for compatibility with new converged configurator, integration with EQuotes APIs etc.
2) Investigation and bug fixes for production issues reported by customers.
3) Analytics work in Splunk to monitor certain performance and error metrics. Created dashboards, drafted splunk queries, setting up email alerts in Splunk.
4) Unit testing & code reviews.
5) Splunk queries and dashboard for expired sessions while accessing configure or add to cart actions.
6) Weekly monitoring of 4xx & 5xx errors in powerBI analytics tool; based on the data, taking decisions for error handling and code refactoring.
7) Coordinating with SMEs for requirement gatherings.
2) Project: Premier side of new converged configurator
Technology/Tools Used: Dotnetcore 6.0, asp.net core, C#, web api, Datastax cassandra 6.8.1(apache cassandra 3.11.x compatible, datastax c# driver), splunk search8.2(splunk enterprise SDK), kafka 3.x(confluent c# driver), sql server 2019, VS 2022.
Tasks:
1) Majorly worked on production tickets/issues on priority.
2) Design and development of MediaGallery of configurator for premier.
3) Handling accessories in backward journey from cart to configure.
4) Taking part in designing cassandra database tables. Consuming kafka events.
5) Cache reloading of product details(for both dell.com and premier); cache invalidation and repopulation on demand.
6) Unit testing & code reviews.
3) Project: PFYD - new portal for "parts for your dell"(as legacy portal had lesser features, was slow in response for page loads, search and TTI)
Technology/Tools Used: Dotnetcore 6.0, asp.net core, C#, web api, Datastax cassandra 6.8.1(apache cassandra 3.11.x compatible, datastax c# driver), splunk search8.2(splunk enterprise SDK), kafka 3.x(confluent c# driver), sql server 2019, VS 2022.
Brief description: With legacy portal our customers were not able to easily and quickly find the exact parts that they were looking for. Getting to the right, compatible part seemed to be a long, non-intuitive journey with many roadblocks. Hence a new portal was envisioned by product team(SMEs) and requirements were passed to development team.
Major functionalities: Search by Device(product family and model), part number, service tag, recommended parts, compatible parts, parts by type and brand. New portal: https://www.dell.com/en-us/shop/partsforyourdell
Development tasks: implementing all the required functionalities in web API and in UI.
1) Inserting data into Cassandra tables.
ii) a CLI app named assembler was developed to consume kafka messages and inserted and updated into Cassandra tables.
iii) Took part in designing Cassandra database.
2) Designing the routing pattern for premier access in routing middleware.
3) Developed repository layer(mediator pattern) and webApi to get data from Cassandra based on a user's locale(country, language, segment and accountId). This is based on mediator pattern.
4) Consuming search API(search MFE) & Product API for searching by family & parts types, part number and service tag for premier accounts.
5) Took part in design and architectural decision making process.
6) Writing Unit tests(test coverage has to be greater than 95%, this is the norm at dell measuring with SonarQube).
9) Loading several data such as Energy efficient indexes, Federal taxes, pricing data, SKU data etc and calls to other internal APIs such as DeliveryPromise, SnPCatalogService etc in parallel to populate product data for premier path.