Rama Srujana Mamidi

Experience

• 

  Wipro

  Jan 2019 - Dec 2021

  • Create and deploy REST API endpoints using Python frameworks such as Flask or Django.• Automate different workflows, which are initiated manually with Python scripts and UNIX shell scripting.• Use Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies• Real-time sensor data was designed and deployed utilizing a scalable NoSQL database solution based on MongoDB and DynamoDB.• Involved in the Web/Application development using Python 3.5, HTML5, CSS3, AJAX, JSON and jQuery.• Develop and tested many features for dashboard using Python, Java, Bootstrap, CSS, JavaScript and jQuery.• Helped with the migration from the old server to Jira database (Matching Fields) with Python scripts for transferring and verifying the information.• Design and maintain databases using Python and developed Python based API (RESTful Web Service) using Flask, SQL Alchemy and PostgreSQL.• Developed Python web services for processing JSON and interfacing with the Data layer.• Developed module to build Django ORM queries that can pre-load data to greatly reduce the number of databases queries needed to retrieve the same amount of data.• Design and manage API system deployment using fast http server and Amazon AWS architecture.• Export Test case Scripts and modified the selenium scripts and executed in Selenium environment.• Developed entire frontend and backend modules using Python on Django Web Framework.• Configure and Schedule jobs for smoke, regression, User Acceptance (UAT), System integrated testing (SIT), functional testing and business validation testing of Test cases.• API Testing is done with Postman tool and UI testing is done with Selenium framework. • Conducted performance testing to evaluate ETL efficiency, identifying and resolving bottlenecks and Integrated ETL tests into the CI/CD pipeline, maintaining data quality across deployments. Show less • Creating network based VM.• Writing Test cases for different Windows OS platforms. • Level 1 Triaging bugs on all Windows OS platforms. • Worked on Spartan Deprecation Testing. • Worked on Site Compat Testing. • Performed Hardware testing on different operation systems and devices (Hard disk, Surface pro, Wi-Fi, Bluetooth, Printer, iPhone, Android).• Worked in an agile environment to deliver high quality software.• Extensive experience in Black Box testing, Regression testing on Microsoft Teams Mobile Application.• Test cases are maintained in x-ray JIRA tool and collaboration with other developers• is done through GIT repository.• 100% adherence to the Test Plan and assigned tasks. Contribution to cycle time reduction in activities involving preparation of scenarios, test cases, test data documentation. • On time and accurate logging of bugs with all relevant fields adhering 100% procedure. • Having awareness and required knowledge on all tools used in the project viz. WTT, Orange. Show less

  • Full Stack Python Developer

    May 2019 - Dec 2021

  • Test Engineer

    Jan 2019 - Apr 2019
• 

  Freelance

  Feb 2023 - Aug 2023

  Python Developer

  • Crafted a versatile web crawler as a developer, leveraging parent URLs to amass profile data from diverse websites.• Organized the collected data into a database and devised efficient Python scripts for monitoring crawler and database statuses. Additionally, implemented error reporting scripts to trigger emails in case of script or process failures.• Engineered an Automation Framework using Selenium in Python for streamlining the testing process.• Executed and updated test cases to assess the functionalities of backend code.• Developed a proof of concept and constructed a framework for data extraction without relying on static content.• Leveraged Selenium and Scrapy to crawl profiles across various websites.• Conducted analysis on the gathered data to identify duplicates and anomalies, incorporating a String-matching algorithm to enhance accuracy.• Utilized bulk inserts and file insertions for inserting crawled data into databases, ensuring timely updates.• Implemented API crawling through the Flask module. Show less

• 

  MassMutual

  Jan 2024 - now

  Full Stack Python Developer

  • Creating REST APIs with the Django framework to retrieve information from databases.• Optimize database queries and data retrieval processes to enhance performance and reduce latency. This may involve understanding Vertica's query execution plans and utilizing appropriate indexing strategies.• Utilize Python libraries such as pandas or matplotlib to perform data analysis and generate reports based on data retrieved from Vertica databases.• Implement Python code to extract data from Vertica databases efficiently, using SQL queries or specialized functions provided by Vertica libraries.• Design, develop, and maintain robust backend components of web applications using Django, including models, views, templates, and forms.• Integrate backend functionality seamlessly into the user interface using Django templating language and frontend framework React.js.• Implement caching strategies using Django's caching framework or third-party solutions like Redis to improve application performance and scalability.• Write unit tests, integration tests, and end-to-end tests to ensure the reliability and functionality of Django applications. Use debugging tools like Django Debug Toolbar or logging to identify and resolve issues efficiently.• Deploy Django applications to production environments using Jenkins.• Develop responsive and interactive user interfaces using React.js, JSX, and modern frontend development tools like Webpack• Manage state and data flow within React components using hooks or state management libraries like Redux• Integrate backend functionality into the frontend by consuming RESTful APIs using libraries like Axios or the native fetch API.• Implement client-side routing and navigation using React Router to create a seamless user experience.• Optimize API requests and responses to minimize latency and improve performance, considering factors like pagination, caching, and data fetching strategies. Show less