SUMMARY

• Over 7years of IT experience in various business domains.
• 4+ years of experience in Backend Software Development using Python, Database and UNIX technologies
• 2 years of experience with Production Support and Testing
• Eager to learn new technology and systems, expertise in working independently and collaboratively.
• Implemented technical solutions utilizing best practices and standards throughout the application development.
• Deep understanding and String knowledge with MVC architecture Web applications using Django Framework.
• Strong knowledge of Django ORM and SQLAlchemy in Python ORM libraries.
• Solid Knowledge of Python data acquisition libraries like as Pandas and file IO.
• Extensive experience in Python requests module, HTTP requests, HTTP Response Redirect, response, methods, headers.
• Expertise in Relational Database Systems such as PostgreSQL and MySQL.
• Expertise with Python DB Modules libraries like Psycopg2, MySQL and MySQL - connector-python.
• Strong understanding of developing Django-based database-backed applications with multiple databases.
• Expert in authenticating webservices using Djoser and Rest framework.
• Solid knowledge of Python data format libraries like JSON, CSV, and XML and PDF.
• Expertise in SQL queries, stored procedures, functions, packages, tables, views, and triggers.
• Data summaries were developed using Group By, having and Aggregation functions.
• Managed expected application failures, logging errors in the database and files.
• Expert in creating integration test cases for higher environments.
• Expert in Punit and Pytest Integration for unit testing and integration testing.
• Strong working knowledge in ingesting data across different sources using S3, AWS RDS and Python.

TECHNICAL SKILLS

Languages: Python 3.8, SQL, Unix

Python Libraries: Django, RegEx, Pandas, Psycopg2, PyMySQL

Python IDE: PyCharm, Eclipse

Web Technologies: Django, HTML5, REST API

Development Tools: Docker, JSON/XML/CSV

Cloud Technologies: AWS

Testing Tools: PyUnit, PyTest

Other Tools: JIRA, Git, Pylint, POSTMAN

CD/CI Tools: Jenkins

ORM Libraries: SQLAlchemy, Django ORM

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Python Developer

Responsibilities:

• This project is for handling backend datasets for order management and order fulfillment.
• Involved in Development and Support phases of Software Development Life Cycle (SDLC).
• Python development using Object Oriented Concepts, Test driven development practices.
• Implemented MVC architecture for developing the web application with the help of Django framework.
• Develop consumer-based features and applications using Python and Django in test driven development and pair-based programming.
• Developed Django APIs for price optimization to define the flexibility of prices.
• Accessed CRUD web services to retrieve and send data using Django and tested the APIs using POSTMAN
• Automate different workflows initiated manually using Python scripts and Unix shell scripts.
• Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
• Wrote programs to parse excel file and process many user data with data validations.
• Actively involved in developing the methods for Create, Read, Update and Delete (CRUD) in Python.
• Used Psycopg2 Python module to connect to PostgreSQL
• Worked on development of SQL and stored procedures in PostgreSQL.
• Added support for Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
• Develop and execute test plans, test cases, bug reports and scenarios for functional and regression testing.
• Data sets were developed and stored to test different business scenarios for the development of an application.

Confidential, Philadelphia, PA

Python Developer

Responsibilities:

• This is an integration project dealing with Files and web services for downstream systems.
• Designed and developed Use-Case, Class and Object Diagrams using UML for Object Oriented Analysis/Object Oriented Design techniques.
• Building Data Marts to store and organize customer information.
• Implemented MVC architecture in developing the web application with the help of Django framework.
• Used data format libraries like Pandas, CSV and XML for statistical analysis.
• Extensive worked on loading customer data into charts using python code using Python CSV, ftlib, and requests libraries.
• Created Python scripts for validating CSV row counts, verifying duplicate records, and checking data integrity.
• Incorporated external business code into view code so that it can be reused.
• Implemented Web API Authentication using REST framework.
• Handled inbound and outbound data from CRUD webservices using Django.
• Implemented and modified various SQL queries and Functions, Stored Procedures, Cursors and Triggers as per requirements.
• Worked with multiple databases using PymySQL to connect to MySQL and Psycopg2 to connect to PostgreSQL
• Developed, stored, and evaluated testing data sets for various application scenarios.
• Worked with POSTMAN for API testing.
• Prepared and stored testing data sets for various business scenarios.
• Maintained and developed data pipeline for ingesting data from various sources using S3, AWS RDS and Python boto3.
• Utilized continuous integration and automated deployments with Docker Containers and Docker Compose.

Confidential

Production Support & Testing Engineer

Responsibilities:

• XnappCentral Application contains all master level data based on country level which comes from JDE using web service.
• Involved in Integration testing of the XnappCentral Application with the Xnapp Mobility Application
• Support through mails and Telephonic and fixing issues in GUI and Consumer applications of any issues raised.
• Fixing issues in Mobility Application installed in the Customer Device using Team Viewer.
• Generate reports from MYSQL database by writing SQL Queries, Stored Procedures, Triggers and Cursors.
• Connect with the End User to identify the issue with the Mobility Application on a specific device.