Syeda Samreen Anjum

Experience

• 

  Societe Generale Global Solution Centre

  Aug 2016 - Jul 2019

  Software Engineer

  >> oriented as a Software Engineer( PL/SQL ,PL/pgSQL) + Automation-centric (Python (2.X, 3.X) , my work primarily focuses on Applications Migration to Open Source software with infrastructure automation on a global scale>> my work not just focuses on the Databases aspects of Oracle(11g, 12c) and PostGres but also focuses on the automation domain .Project #1 : Commercial Databases Migration to Open Source • Migrating oracle databases along with application backend code, batch jobs in an Agile development methodology• Optimizing the query to match with Oracle performance and Extensively re-written the queries by using Joins and sub-queries. • Resolved and contributed to enhancement of open source ETL tool – Pgloader to perform data load operations on Postgres database.• Worked on Indexes, Views, complex Stored Procedures, user defined functions, table partitions , Triggers and huge amount of data operations to facilitate efficient data manipulation and data consistency . • Based upon business requirements, implemented workarounds to achieve the same Oracle functionalities which are not supported in Postgres ,like dblink .Project #2 : Automation of PostgreSQL Installation and Configuration • Automated the PG database creation task which saved significant man days per month which involved Installation, configuration, maintenance and troubleshooting of database and to automate mundane activities. • Planning disk space utilization on servers with UNIX system engineers and design scripts to do Capacity planning, Alert monitoring and handling incidents. For Example; tablespace alerts, database down/unreachable alerts, job failures, file system alerts etc. Show less

• 

  Mavenir

  Jul 2019 - Aug 2021

  Member of R&D Technical Team

  • Working in R&D team as Database Developer helping organization to embrace the new technological revolution, in an Agile Methodologies and SCRUM process.• Being a part of R&D Database team with opportunity to work on programming languages like Python, Golang & SCXML with SQL database Oracle & NoSQL database such as Couchbase.PYTHON :• Developed a tool to benchmark the Key-Value and N1ql performance on couchbase database for high volume up to 1 Billion documents using python vs golang.• Automation of the Couchbase database by building a tool to autonomously handle the critical administrative tasks along with active monitoring and alerting.• Worked on developing Python API’s with Multithreading and Multiprocessing. • Proficient understanding of code versioning tool such as Git.• Work collaboratively with product owners and the application developers.• Designing and developing of couchbase document structure to support the migration from Oracle to Couchbase. • Implement or leads the implementation of complex solutions that are easy to deploy, maintain, and are bug free.GOLANG:• Development of a tool to benchmark Key-Value and N1ql operations on Couchbase using Goroutines, Channel patterns and Interfaces for high volume up to 1 Billion documents.• Good understanding of various backend components and Microservices in a Service Oriented Architecture using gRPC and protobuf.• Good knowledge in developing APIs for Couchbase operations and based upon the application requirements using Golang.• Designing and development of API to support the Backward compatibility Online on Live Application.MINIO Cloud Storage with Golang Client POC:• Have worked on Minio POC with Golang client API using these GO packages : context, log, io, net/http, crypto/tls, github.com/minio/minio-go, github.com/minio/minio-go/pkg/credentials, github.com/minio/minio-go/pkg/encrypt, net/url• Developing Golang client API’s to check on the data storage and retrieval management. Show less

• 

  American Express

  Aug 2021 - now

  • Senior Data Engineer II

    Feb 2024 - now

  • Data Engineer I

    Aug 2021 - Feb 2024