Samarendra Sahoo

Project: ProCRM

Building a platform for Home Depot' Pro Associate Sales Representatives to get sales driven incentives which in turn drives sales growth across organization

Responsibilities:

• Worked with Stakeholders to identify business requirements and to provide end to end solution
• Architecting micro service design in Amazon Web Services(AWS) using Fargate, Lambda and AWS CloudWatch Events to implement automated weekly sales target and monthly and quarterly incentive payment calculation systems
• Implementing end to end security using IAM ,authentication protocol , encryption and virtual Private cloud networking
• Monitoring the service health and performance using Amazon CloudWatch
• Building data pipelines to connect to Enterprise Data warehouse(Redshift) and integrating with sales target and payment calculation services
• Integrating with HR work day systems for data exchange and data transformation using S3, Redshift, Glue and Step Functions.
• Leveraged PySpark and DataFrames for advanced big data computation and efficient data manipulation .
• Design and development using Java, Spring Boot, Python and Flask Framework
• Designed schema in Red Shift as per the business need
• Creation of Metric tables/Views in Red Shift for analytics
• Used Celery as task queue and SNS as messaging broker to execute asynchronous tasks
• Driving onshore and offshore Team for the deliverables
• Involved in code reviews using GitHub pull requests.
• Using Docker to achieve micro service architecture
• Monitoring, logging and debugging in AWS
• Worked with DevOps Teams to automate building jobs and deployment using GitHub Actions
• Improved code reuse and performance by making effective use of Factory design pattern

Project: ProCRM

Building a platform for Home Depot's sales executives to get realtime insight of quotes and orders , sales variation in history , sales target vs actual sales

The goal was to monitor the sales insights and drive the strategy for sales growth.

Responsibilities:

• Worked with Stakeholders to identify business requirements and to provide end to end solution
• Architecting micro service design in Amazon Web Services using Docker, Lambda, S3,Redshift and AWS CloudWatch Events to implement data pipelines
• Designing and developing the data pipelines using Pysprark to be used for analytics
• Designing and developing integration of Enterprise Data Warehouse(Rdshift) with salesforce
• Designing and developing integration of Enterprise Data Warehouse(Redshift) with Tableau
• Creation of Tableau dashboards and providing filters and row level security to the dashboards
• Involved in code reviews using GitHub pull requests.
• Monitoring, logging and debugging in AWS environment.
• Worked with DevOps Teams to automate building jobs and deployment using GitHub Actions

Project: Proreferral

Proreferral's business is to provide a platform to connect consumers with Service Providers for consumer's home improvement needs.

Responsibilities:

• Worked with Stakeholders to identify requirements and provide end to end solutions
• Architecting micro service design in Google Cloud Platform using Cloud Run, Cloud SQL and Cloud Scheduler to implement automated weekly sales target and monthly and quarterly incentive payment calculation systems
• Implementing end to end security using IAM ,OIDC authentication protocol , encryption and virtual Private cloud networking
• Monitoring the service health and performance using GCP's inbuilt Cloud Monitoring
• Design and development using Java and Spring Boot to deliver micro service architecture in Google Cloud Platform
• Designed schema in PostgreSQL as per the business need
• Migrating data from legacy MySQL to PostgreSQL
• Maintaining data pipelines from MySQL to PostgreSQL and PostgreSQL to BigQuery
• Building Database APIs to be accessed by Web services
• Creation of Metric tables in BigQuery for analytics
• Used pubsub as messaging broker to execute asynchronous tasks
• Involved in code reviews using GitHub pull requests
• Using Docker for local and production deployment
• Updated and maintained Github Actions for automatic building jobs and deployment
• Improved code reuse and performance by making effective use of various design patterns and refactoring code base
• Taken ownership of entire lifecycle of the project including Design, Development, and Deployment, Testing and Implementation and support

Project:Quote Builder

The goal of the project is to provide a highly reliable automated home improvement solution system with quote on demand to end customers.

Responsibilities:

• Involved in software development life cycle (SDLC) of tracking the requirements, detailed design, development, system testing and user acceptance testing
• Involved in design, analysis and architectural meetings
• Created Architecture Diagrams, and Flow Charts, case diagrams, class diagrams, database tables, and mapping between relational database tables
• Followed Agile software development practice paired programming, test driven development and scrum meetings
• Developed entire backend using Java and Spring Boot
• Implemented MVC architecture in developing the web application with the help of Spring MVC
• Involved in code reviews using GitHub pull requests
• Using Docker for local and production deployment
• Deploying, Monitoring, logging and debugging in Google Cloud Environment.
• Updated and maintained Jenkins for automatic building jobs and deployment
• Improved code reuse and performance by making effective use of various design patterns and refactoring code base
• Implemented various SQL queries and Functions and Triggers as per the client requirements
• Building Database APIs to be accessed by Web services
• Collaborating with team members, management, and clients to ensure projects are completed as per the requirement

Project: Customer Analytics

Increasing utilization of myTNB app, Identification of drivers of complaints using pattern mining, Identification of future enquiries to be converted to complaints using machine learning model

Responsibilities:

• Worked with Stakeholders on requirements to identify business goals
• Data Cleaning, Data Exploration, Feature engineering, Vectorizing Text Data, building machine learning model on vectorized data, Cross Validation for better accuracy, Topic modeling and sentiment analysis on Facebook Data Dump provided by client using Python and its libraries
• Identifying rules for segments using tree-based approach
• Developed a decision tree model using scikit-learn with features extracted from Hadoop storage and assigned scores to customers through the tree model to present the probability of the customer using myTNB app
• Designing end to end solution through Natural Language Processing (NLP) and SVM and representing insights and recommendations to Client Service Team Text Preprocessing through Noise Removal, Lemmatization, Stemming and Standardization
• Text to Features/Vectors (Feature Engineering on text data) using statistical method TF–IDF
• Applying dimensionality Reduction on features using PCA
• Cross Validation for hyper parameter tuning for bias variance trade-off and better accuracy
• Environment: Python 2, Hive, DBvisualizer, JIRA, PL/SQL, Logging Module, Scikit-learn, Git

Project: Char Coding

Automating Operation Team's manual work of tagging characteristics to UPC through Natural Language Processing (NLP) & Machine Learning Model

Responsibilities:

• Translated the customer requirements into design specifications and ensured that the requirements translate into software solution
• Text Preprocessing through Noise Removal, Lemmatization, Stemming and Standardization
• Text to Features/Vectors (Feature Engineering on text data) using statistical method TF–IDF
• Applying dimensionality Reduction on features
• Building SVM classification model on densed features to extract characteristics
• Building SVM classification model on densed features to identify the correct commodity
• Cross Validation for hyper parameter tuning for bias variance trade-off and better accuracy
• Used Logging module for event logs
• Unit testing using pytest
• Environment: Python , Oracle, DBvisualizer, JIRA, PL/SQL, Scikit-learn, Git, Logging Module

Project: GNSO

Through NSO, Nielsen provides market analysis reports for products to end Clients at different hierarchical levels using Audited data as well as Sales Data

Responsibilities:

• Developed backend modules using Java and Spring MVC
• Develop, test, deploy and maintain the website
• Designed and developed data management system using MySQL
• Wrote python scripts to parse XML documents and load the data in database
• Involved in development of MySQL tables, stored procedures, and functions
• Creating unit test/regression test framework for working/new code
• Responsible for debugging and troubleshooting the web application
• Handling the day-to-day issues and fine tuning the applications for enhanced performance
• Tracking the Incidents, Service requests through Incident Tracking Tool (Service Now)
• Environment: Python, Java, Linux, HTML, CSS, PL/SQL, MySQL, Apache Web Server, UNIX.