Ram . Email & Phone Number

New York, Ny, Us

• Designed and implemented efficient data ingestion pipelines using Python, enabling seamless integration of diverse data sources into eCommerce platform.• Involved in development of Python based Web Services using REST for sending and getting data from the external interface in JSON format to track sales and perform sales analysis using PostgreSQL.• Automated data extraction, transformation, and loading (ETL) tasks using Python scripts, significantly reducing manual processing time and increasing data accuracy.• I developed a Python script to generate a report on the most popular products on an e-commerce website. The report is used by the company to make informed decisions about product development and marketing.• Integrated TypeScript-based front-end components with Python backend services, ensuring seamless communication and data exchange between the server and client-side applications.• I developed a Python script to train a machine-learning model to predict customer churn. The model is used by a company to identify customers who are at risk of churning and to take steps to retain them.• Improved data ingestion performance through Python-based optimization techniques, reducing data processing times by 30% and supporting high-volume transaction handling.• Developed Bootstrap responsive web application pages using react services, controllers and directives for front end UI/UX.• Deployed MongoDB for storing the data in JSON-like documents with dynamic schema where we can store our records without worrying about the data structure such as the number of fields or types of fields to store values.• Involved in data loading using PL/SQL and SQL*Loader, calling UNIX scripts to download and manipulate files; used Git for version control and Jenkins for CI/CD.• Designed and developed a horizontally APIs using python Flask and implemented monitoring and established best practices around using elastic search.

• Designed and implemented Python-based automation solutions for repetitive tasks, resulting in a 50% reduction in manual processing time and increased operational efficiency.• I developed a Python script to automate the process of extracting data from a variety of sources, cleaning and transforming the data, and loading it into a data warehouse.• Involved in enhancement of the legacy application which was used to have around 50 – 60 issues reported in a working day through support calls and with the new application, the errors were reduced to Zero. The page load time was improved a staggering 220 times as seen by SQL and web page traces.• I have used StoneBranch scheduler to create a workflow for processing a company's daily sales data. The workflow involves multiple jobs that extract, transform, and load the data into a data warehouse. The scheduler also includes steps for validating the data and for generating reports.• Created and optimized TypeScript-based financial dashboards, providing real-time insights and analytics for users while maintaining high performance and data accuracy.• Worked in message queues for communicating between multiple servers, review activity of requirement deliverables, project implementation for migration to SAP from existing inventory management.• Designed the functionality to read the data from DynamoDB, clean the data, and arrange the data into timeframes using Pandas.• Performed efficient delivery of code based on principles of Test-Driven Development (TDD) and continuous integration to keep in line with Agile Software Methodology principles.• We used Pandas and other libraries to read the logs to find out the successful trades through the logs, values of bids and offers and putting them into data frames for cleaning the data.• Worked on developing Restful endpoints to Cache application specific data in in-memory data clusters like Redis and exposed them with Restful endpoints by using Redis Cache.

• Worked with the Stakeholders, gathered requirements, developed High-level design and Detail design documents.• Designed and developed components using Python with Django framework. Implemented code in python to retrieve and manipulate data.• Made JavaScript functions for customer side approvals, made CSS for look and feel of use, and furthermore associated with back end approval.• Developed Restful Microservices using Django, deployed on AWS servers using EBS and EC2, used React for building web-apps, and is highly efficient in integrating with Restful services, Rest APIs.• Responsible for Gathering Semi structured data from S3 and relational structured data from RDS and keeping data sets into centralized metadata Catalogue using AWS GLUE and extract the datasets and load them into Kinesis streams. • Engaged in using MySQL as backend database and MySQL dB of python as database connector to interact with MySQL server.• Responsible for designing Front-side of the web app like embedded graphics, and interactive documents using JavaScript, XML, HTML, CSS and REST API calls.• Used Python and Django creating graphics, XML processing of documents, data exchange and business logic implementation between servers.• Developed Microservices by creating REST APIs and used them to access data from different customers and to gather network traffic data from servers.• Virtualized the servers using the Docker for the test environments and dev-environments needs, and configuration automation using Docker Containers.• Developed spark applications in python (PySpark) on distributed environment to load huge number of CSV files with different schema in to Hive ORC tables.• Designed and maintained databases using Python and developed Python-based API (RESTful Web Service) using Django, SQL Alchemy, and PostgreSQL.• Maintaining the Elasticsearch cluster and Logstash nodes to process around 5TB of Data Daily from various sources like Kafka, kubernetes, etc.