Python Developer Sql Server

Shiva Reddy

Sr. Python Developer

E-Mail: *************@*****.*** Ph.: +1-732-***-****

PROFESSIONAL SUMMARY

10+ years of experience as a Senior Python Developer with architecting, developing, and managing scalable web applications. Proficient in leveraging Python and its frameworks, including Django and Flask, to deliver robust and efficient solutions.

Expertise in designing, optimizing, and managing databases with PostgreSQL, DynamoDB, MySQL, MongoDB, SQL Server, and Redis for efficient data storage and retrieval.

Skilled in creating and integrating RESTful APIs, GraphQL, and SOAP-based web services, ensuring seamless client-server communication and enhanced application performance.

Extensive experience implementing microservices architecture to build modular, scalable, and maintainable services, improving overall application flexibility and reliability.

Proven track record in deploying and managing applications on AWS (EC2, S3, RDS, Lambda, CloudFront, API Gateway, EMR) and Azure (App Service, Functions, Storage, Data Factory, Logic Apps), leveraging cloud services for robust and scalable solutions.

Experience with Apache Spark and Hadoop for big data processing and analysis, enhancing data handling capabilities and performance.

Expertise in developing responsive and dynamic user interfaces using HTML5, CSS3, JavaScript ES6+, React, Redux, Angular, Vue.js, Bootstrap, and jQuery, including creating Progressive Web Apps (PWAs).

Implemented server-side logic with Node.js, integrated WebSockets for real-time communication, and created interactive data visualizations with D3.js.

Proficient in automating CI/CD pipelines using Jenkins, Azure DevOps, and AWS CodePipeline and managing containerized applications with Docker and Kubernetes. Experienced in infrastructure as code (IaC) using Terraform and Ansible.

Worked on JavaScript library (Python), SRSS, PySpark to augment browser based applications with functional capability.Hands of experience in GCP, Big Query, GCS bucket, G - cloud function, cloud dataflow, Pub/suB cloud shell, GSUTIL, BQ command line utilities, Data Proc, Stack driver

Hands on experience in writing advance scripting like Python, PowerShell, Bash for automating process.

Strong background in unit and automated testing using PyTest, JUnit, Mockito, Selenium, and Postman, focusing on Test-Driven Development (TDD) and Behavior-Driven Development (BDD).

Skilled in monitoring and logging application performance using CloudWatch, ELK Stack, Splunk, and Prometheus, ensuring high system observability and efficient troubleshooting.

Experienced in managing code versioning and collaboration using Git, GitHub, and Bitbucket, and efficient project management with JIRA and Confluence.

Used virtualenv and pip to work in segregated environments for specific project requirements and to update old technologies, SRSS, PySpark, and NodeJS.

Implemented secure authentication and authorization using OAuth, JWT, and SSL/TLS encryption, enhancing application security.

Adept at applying Agile and Scrum methodologies for iterative development, project management, and continuous improvement.

Demonstrated ability to articulate technical concepts to non-technical stakeholders clearly, fostering better understanding and collaboration across diverse teams.

Proven track record of diagnosing and resolving complex technical issues with innovative solutions, ensuring project success and operational efficiency.

TECHNICAL SKILLS:

Programming Languages: Python, JavaScript ES6+, TypeScript, SQL, PL/SQL

Frameworks and Libraries: Django, Flask,Pyspark, React, Angular, Vue.js, Bootstrap, jQuery, AJAX, D3.js, Pandas, NumPy, Matplotlib, SciPy, SQLAlchemy, MVC, FastAPI, Express.js, Node.js

Databases: PostgreSQL, DynamoDB, MySQL, MongoDB, SQL Server, CosmosDB, Oracle, Redis

Web Services and APIs: RESTful APIs, GraphQL, SOAP, WSDL, Swagger

Cloud Platforms and Services: AWS (EC2, S3, RDS, Lambda, CloudFront, API Gateway, EMR, IAM, Autoscaling, SQS, SNS, CloudFormation), Azure (App Service, Functions, Storage, Data Factory, Logic Apps, Active Directory)

Big Data Technologies: Apache Spark, Hadoop

DevOps and CI/CD: Jenkins, Azure DevOps, AWS CodePipeline, CodeBuild, Terraform, Ansible, Maven, ANT, Git, GitHub, Bitbucket, Docker, Kubernetes

Testing and Quality Assurance: PyTest, JUnit, Mockito, Selenium, Cucumber (BDD), PyUnit, Test-Driven Development (TDD), Behavior-Driven Development (BDD), Postman (API Testing)

Monitoring and Logging: CloudWatch, ELK Stack, Splunk

Development Tools and IDEs: PyCharm, IntelliJ IDEA, Eclipse, VS Code, NetBeans, Jupyter Notebooks

Containerization and Orchestration: Docker, Kubernetes

Project Management and Collaboration: JIRA, Confluence, Rally, Slack

Security and Authentication: SSL/TLS Encryption, OAuth, Azure AD, JWT

Data Formats and Processing: JSON, XML, XSD, XSLT

Additional Tools and Technologies: ActiveMQ (Message Queuing), RabbitMQ (Message Queuing), WebSockets (Real-Time Communication), Gunicorn (WSGI HTTP Server), Swagger UI (API Documentation), Redis (Caching), Terraform (Infrastructure as Code)

WORK EXPERIENCE:

Horizon Blue, Pennington, NJ March 2022 – Present

Python Developer

Developed and deployed scalable web applications using Python and Django, improving application scalability by 30% and reducing load times by 25% through adherence to SDLC methodologies.

Designed and administered databases using PostgreSQL and DynamoDB, optimizing data storage and retrieval processes to achieve a 40% improvement in performance.

Designed and implemented centralized logging solutions using the ELK stack (Elasticsearch, Logstash, Kibana) to monitor and analyze application logs for performance tuning and troubleshooting.

Created and integrated REST APIs and GraphQL endpoints, increasing client-server communication efficiency by 35% and boosting application performance by 20%.

Implemented a microservices architecture, which improved application maintainability by 50% and reduced deployment times by 40%.

Develop and deploy the outcome using spark and Scala code in Hadoop cluster running on GCP.

Implemented public segmentation using unsupervised machine learning algorithms by implementing K-means algorithm by using PySpark using data munging.

Used Powershell WinRM and Python SSH along with Boto3 to connect to remote servers. Also worked with Subprocess(Python Powershell) and various Python Excel libraries(openpyxl, xlwings etc.) in Python Extensively.

Working closely with team members in developing the PowerShell scripts for automating the several steps in Microsoft HDinsight environment.

Analyzed the SQL scripts and designed it by using PySpark SQL for faster performance

Deployed and managed applications on AWS, utilizing services like EC2, S3, RDS, Lambda, CloudFront, API Gateway, EMR, and IAM to enhance cloud solutions, resulting in a 30% reduction in operational costs.

Leveraged Apache Spark and Hadoop for big data processing and analysis, increasing data handling capabilities by 60% and reducing processing time by 50%.

Developed custom Logstash pipelines to parse, filter, and transform logs from multiple sources before indexing into Elasticsearch.

Developed responsive and dynamic user interfaces using HTML5, CSS3, JavaScript ES6+, React, Redux, React Router, and Bootstrap, which improved user engagement by 45%.

Created Progressive Web Apps (PWAs), delivering a native app-like experience that increased user accessibility and engagement by 35%.

Optimized Elasticsearch clusters for high availability and scalability, including shard allocation and index lifecycle management.

Used PySpark-SQL to load JSON data and create schema RDD, Data Frames and loaded it into Hive Tables and handled Structured data using Spark-SQL.

Implemented PySpark using Python and utilizing data frames and temporary table SQL for faster processing of data.

Implemented server-side logic with Node.js and developed interactive data visualizations with D3.js, enhancing data insights and user interaction by 40%.

Employed data analysis libraries such as Pandas, NumPy, and Matplotlib, streamlining data manipulation and visualization tasks and improving data analysis efficiency by 50%.

Processed and transformed XML data using XSD and XSLT, ensuring accurate data interchange and improving data integrity by 30%.

Implemented security measures, including role-based access control (RBAC) and TLS encryption, to protect sensitive data in the ELK environment.

Utilized Postman for API testing, ensuring 100% functionality and performance of REST APIs and GraphQL endpoints through comprehensive testing.

Monitored and logged application performance using CloudWatch, which improved system observability and troubleshooting efficiency by 40%.

Integrated WebSockets for real-time communication, enhancing user experience in interactive applications and reducing latency by 25%.

Developed and deployed RAG-based models to enhance natural language understanding (NLU) and question-answering systems in Python.

Managed code versioning and collaboration using Git and GitHub, ensuring efficient workflow and version control, resulting in a 30% increase in team productivity.

Containerized applications using Docker and orchestrated deployments with Kubernetes, achieving 50% faster deployment times and improved application scalability.

Automated infrastructure provisioning using Ansible and CloudFormation, ensuring consistent and repeatable deployments with a 35% reduction in manual setup time.

Configured Gunicorn as a WSGI HTTP server, improving Python web application performance and scalability by 30%.

Conducted unit testing using PyUnit and practiced Test-Driven Development (TDD), increasing code reliability and reducing bugs by 40%.

Automated UI testing using Selenium, enhancing application testing coverage and reliability with a 45% reduction in post-deployment defects.

Implemented OAuth for secure authentication and authorization, enhancing application security and reducing unauthorized access attempts by 50%.

Automated CI/CD pipelines using Jenkins, streamlining deployment workflows and reducing deployment time by 40%.

Applied Agile and Scrum methodologies for project management, improving iterative development and delivery speed by 30%.

Managed project tasks and collaboration using JIRA, facilitating effective project tracking and team communication, leading to a 25% increase in project completion rates.

Developed and debugged applications using PyCharm IDE, enhancing development productivity and code quality, resulting in a 20% reduction in development time.

Environment: Python, Django, PostgreSQL, DynamoDB, AWS, EC2, S3, RDS, Lambda, CloudFront, API Gateway, EMR, IAM, Apache Spark, Hadoop, React, Pyspark,powershell,Bootstrap, Node.js, D3.js, Postman, Git, GitHub, Docker, Kubernetes, PyUnit, OAuth, Jenkins, Agile, Scrum, JIRA.

US Bank PLANO, TX June 2020 - Feb 2022

Python Developer

Developed robust web applications using Python and Flask, achieving a 40% increase in application performance and a 30% improvement in responsiveness.

Designed dynamic user interfaces with HTML5, CSS3, and TypeScript, which enhanced user experience and accessibility, resulting in a 35% increase in user engagement.

Implemented RESTful APIs to facilitate seamless communication between client and server, improving data exchange efficiency by 30% and reducing latency by 20%.

Implemented retrieval mechanisms using Elasticsearch and other vector search engines to efficiently fetch relevant documents or knowledge base entries for generating accurate responses.

Fine-tuned pre-trained language models with domain-specific data to improve the quality and relevance of generated answers in RAG systems.

Built APIs for seamless integration of RAG models into existing applications, enabling features like intelligent search and contextual chatbots.

Deployed and managed scalable applications on AWS, leveraging services such as EC2, S3, RDS, Lambda, SQS, SNS, and API Gateway, which reduced infrastructure costs by 25% and improved scalability by 40%.

Configured AWS Autoscaling to maintain optimal performance and cost efficiency, achieving a 30% reduction in resource costs and ensuring consistent application performance under varying load conditions.

Utilized Maven and ANT for automated build processes, ensuring consistent and reliable application deployment with a 35% reduction in deployment errors.

Developed single-page applications (SPAs) using Angular, enhancing client-side performance and user engagement, resulting in a 45% increase in user interactions.

Oversaw the management of relational databases (MySQL) and NoSQL databases (MongoDB), ensuring efficient data storage and retrieval with a 30% improvement in query performance.

Employed Terraform for infrastructure as code (IaC) to automate the provisioning of AWS resources, improving deployment consistency and reducing setup time by 40%.

Utilized Git for version control, ensuring efficient collaboration and code management across development teams, leading to a 25% increase in team productivity.

Automated Continuous Integration builds, nightly builds, deployments and unit tests across multiple different environments (DEV, QA, Training, Production) each constituting different types of servers (DB, App, Web) and different number of servers of each type (for load balancing and such) using VSTSBuild, PowerShell, and MS Build, MS Deploy

Implemented the ELK stack (Elasticsearch, Logstash, Kibana) for centralized logging and monitoring, improving system observability and troubleshooting efficiency by 40%.

Automated CI/CD pipelines using AWS CodePipeline, streamlining deployment workflows and reducing deployment time by 30%.

Used Swagger for API documentation, ensuring clear and comprehensive API descriptions, which improved developer and stakeholder understanding and reduced integration issues by 25%.

Utilized Docker for containerization, improving application portability and environment consistency, leading to a 35% increase in deployment speed and reliability.

Orchestrated containerized applications using Kubernetes, ensuring efficient deployment, scaling, and management of applications, achieving a 40% improvement in scalability and fault tolerance.

Developed and debugged applications using Eclipse IDE, enhancing development efficiency and code quality with a 30% reduction in debugging time.

Applied Behavior-Driven Development (BDD) practices using Cucumber, ensuring that software met user requirements effectively, leading to a 20% reduction in post-deployment defects.

Deployed and managed applications on the WebLogic server, ensuring reliable and scalable application hosting with a 25% improvement in uptime and reliability.

Managed project tasks and workflows using JIRA, facilitating effective project management and collaboration, resulting in a 30% increase in project completion rates.

Conducted unit and integration testing using PyTest, ensuring code reliability and functionality with a 40% reduction in critical bugs and issues.

Implemented JSON Web Tokens (JWT) for secure authentication and authorization, enhancing application security and reducing unauthorized access attempts by 50%.

Environment: Python, Flask, RESTful APIs, AWS, API Gateway, Maven, ANT, Angular, MySQL, MongoDB, Terraform, Git, ELK, AWS Code pipeline, Swagger, Docker, Kubernetes, WebLogic, JIRA, PyTest, JWT.

Texas Capital Bank Dallas, TX Dec 2018 - June 2020

Python Developer

Developed and maintained web applications using Python and Flask framework, ensuring adherence to best practices and performance standards.

Implemented database models and queries using SQLAlchemy, facilitating efficient data access and management.

Designed and built dynamic and responsive user interfaces with Vue.js, HTML5, CSS3, and JavaScript, enhancing the user experience.

Added interactivity to web applications using jQuery and AJAX, improving client-side functionality and performance.

Integrated message queuing systems with ActiveMQ to ensure reliable and scalable communication between services.

Managed SQL Server databases, optimizing queries and stored procedures for improved performance.

Utilized Redis for caching and session management, enhancing application performance and scalability.

Created and consumed SOAP-based web services with WSDL for secure and efficient data exchange.

Developed data pipelines using Azure Data Factory (ADF), enabling robust data integration and transformation.

Deployed and managed applications on various Azure services, including Azure App Service and Azure Functions, ensuring high availability and scalability.

Leveraged GIT for version control, managing code repositories, and collaborating with team members through branching and merging.

Utilized Azure DevOps for continuous integration and deployment (CI/CD), automating build, test, and deployment processes.

Automated build processes using ANT, ensuring efficient and consistent build management.

Developed and documented data analysis workflows in Jupyter Notebooks, facilitating reproducible and shareable research.

Configured and maintained Nginx as a reverse proxy server, ensuring efficient load balancing and security.

Implemented authentication and authorization using Azure Active Directory (Azure AD), enhancing application security.

Conducted unit testing with Mockito, ensuring code quality and reliability through comprehensive test coverage.

Participated in Agile and Scrum methodologies, including sprint planning, daily stand-ups, and retrospectives, contributing to continuous improvement and team collaboration.

Environment: Python, Flask, Vue.js, ActiveMQ, SQL Server, Redis, WSDL, Azure, ADF, GIT, Azure DevOps, ANT, Nginx, Azure AD, Mockito, Agile, Scrum.

Corteva, Indianapolis, IN Jan 2018 - Nov 2018

Python Software Engineer

Developed and maintained web applications using Python and Django framework, adhering to Model-View-Controller (MVC) architecture principles.

Designed and implemented RESTful APIs and SOAP-based web services with WSDL, ensuring robust and secure data interchange.

Created and managed XML schemas for data validation and transformation, facilitating seamless integration with external systems.

Utilized HTML, CSS, and JavaScript to build responsive and user-friendly front-end interfaces, enhancing the overall user experience.

Implemented dynamic web functionalities using jQuery, improving interactivity and efficiency of web pages.

Developed and optimized SQL queries and PL/SQL scripts for database interactions, ensuring efficient data retrieval and manipulation.

Leveraged GIT for version control, managing code repositories, and facilitating collaborative development through branching and merging.

Conducted unit and automated testing using PyTest, ensuring code quality and reliability through comprehensive test coverage.

Employed IntelliJ IDEA for development, leveraging its advanced features for code navigation, debugging, and refactoring.

Documented project requirements, design specifications, and technical procedures using Confluence, ensuring clear communication and knowledge sharing among team members.

Applied Kanban methodologies to manage project tasks, ensuring efficient workflow and timely delivery of features.

Participated in Agile development processes, including sprint planning, daily stand-ups, and retrospectives, contributing to continuous improvement and team collaboration.

Environment: Python, Django, WSDL, XML, HTML, CSS, JavaScript, jQuery, MVC architecture, GIT, PyTest, IntelliJ, Confluence, Kanban, Agile.

Qvantel, Hyderabad, India July 2013 - Aug 2016

Python Backend Developer

Developed backend systems and services using Python and Django to ensure performance, reliability, and scalability.

Contributed to developing and integrating RESTful APIs and other backend services to enable seamless interaction with front-end applications and external systems.

Worked with relational and NoSQL databases (e.g., PostgreSQL, MongoDB) to design and manage data schemas, perform CRUD operations, and ensure data integrity and security.

Wrote clean, maintainable code following best practices and coding standards. Participated in writing unit tests using frameworks like PyTest to ensure the quality and reliability of the codebase.

Collaborated with frontend developers to understand requirements and integrate backend functionality with user-facing applications.

Identified, analyzed, and resolved issues and bugs in the backend systems. Used debugging tools and logs to diagnose problems and implemented adequate solutions.

Employed version control systems like Git to track code modifications, facilitate collaboration with team members, and maintain a comprehensive code history.

Assisted in creating and maintaining documentation for backend services, APIs, and database schemas to ensure clarity and ease of use for other developers and stakeholders.

Participated in Agile development practices, including sprint planning, daily stand-ups, and code reviews, to contribute to a collaborative and iterative development process.

Monitored and enhanced backend system performance by pinpointing bottlenecks and implementing optimizations to improve efficiency and scalability.

Followed security best practices to protect backend systems and data from unauthorized access and vulnerabilities.

Continuously learned new technologies, tools, and methodologies related to backend development to enhance skills and contribute to the team's growth.

Environment: Python, Django, RESTful APIs, PostgreSQL, MongoDB, PyTest, Git, Agile, Scrum.

Contact this candidate