Post Job Free

Resume

Sign in

Python Developer Sql

Location:
Dublin, OH
Salary:
as mentioned in job description and based on posit
Posted:
April 04, 2023

Contact this candidate

Resume:

Anusha Marrapu

469-***-****

adwccg@r.postjobfree.com

Python Developer

Professional Summary:

Python developer having over 4 years of Dynamic experience in the areas of Data Distribution, Client/Server communication, Multi-threaded applications, Server-side programming, analytical programming using Python.

Developed various Python scripts to generate reports, send FIX messages (FIX Simulator), SOAP requests, TCP/IP programming and multiprocessing jobs.

Proficient using Python packages such as NumPy, Pandas, SciPy, matPlotLib, Pickle, PySide, PyGTK, PyTables and Scikit-learn.

Expertise on Data bases such as MYSQL, SQL, Oracle, PL/SQL.

Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL database.

Expert on OOPS, Multi-threading, Exception-Handling & Collections in python.

Written Python Scripts to run on oracle database.

Experience in C and C++ languages. Written C and C++ applications and also migrated many legacy applications to Python.

Good Experience in error and exceptional handling.

Implemented unit tests, integration test and functional testing in Python.

Good Knowledge on Algorithms, Data Structures, Flowcharts

Have exposure in different stages of Software Development Life Cycle (SDLC).

Have worked with AGILE and WATERFALL methodologies with high quality deliverables delivered on-time.

Experience with Unit testing/ Test driven Development (TDD), Load Testing.

Ensured quality using Git Hub, SVN, JIRA as version control systems.

Prepared python scripts on database for tasks such as fetching data, improving query performance.

Proficient in database recovery, user management, performance tuning, upgrade, patching, cloning, data pump, memory management - tablespace issues.

Experience in monitoring of database size and disk space in Production, Staging & Development environments.

Performed cloning of production instances as per functional and development team’s request.

Have the ability to understand complex systems and be in command of the details to provide solutions. Maintained detailed documentation and architectural solutions in IT infrastructure and sales systems.

TECHNICAL SKILLS:

Operating Systems

Linux, Windows

Programming Languages

Python 2.X, Python 3.X, C, C++, SQL, shell scripting

Web technologies

HTML, CSS, XHTML

Webserver

Web logic

Databases

MySQL, PLSQL, Oracle, Microsoft SQL

Development IDE

PyCharm, Pydev Eclipse, Vim, MS Visio, Sublime Text, Notepad++

Version Control

Git-Hub, Sub Version

Methodologies

Agile, Scrum, Waterfall

EDUCATION:

.

BTech Bachelors of Computer Science and Engineering in 2012.

PROFESSIONAL EXPERIENCE:

Hanker Systems, Ohio Dec 2020-Till date

Python Developer

Responsibilities:

Involved in software development life cycle (SDLC) of tracking the requirements, gathering, analysis, detailed design, development, system testing and user acceptance testing.

Actively involved in developing the methods for Create, Read, Update and Delete (CRUD) in Active Record.

Rewrite existing Python/Flask module to deliver certain format of data. Created script in python for calling REST APIs.

Involved in designing user interactive web pages as the front-end part of the web application using various web technologies HTML/HTML5, CSS/CSS3, XML, XHTML, JSON etc.

Developed Python code to gather the data from HBase and designs the solution to implement using PySpark.

Developed PySpark code to mimic the transformations performed in the on-premise environment.

Used Celery as task queue and RabbitMQ, Redis as messaging broker to execute asynchronous tasks.

Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MySQL db package to retrieve information.

Generated Python Django Forms to record data of online users.

Developed Wrapper in Python for instantiating multi-threaded application.

Implemented monitoring and established best practices around using elastic search.

Generated graphical reports using python package Numpy and MatplotLib.

Implemented task object to interface with data feed framework and invoke database message service setup and update functionality.

Deployed and administered many MySQL RDS instances, PostgreSQL RDS instance and MSSQL database on EC2 server.

Used PostgreSQL for storing and retrieving JSON format data that need to be displayed on Google maps API. Good knowledge in AngularJS and Responsive Design.

Designed and implemented a tool called netconf (Network configuration) which automatically configures network switches by parsing XML files.

Managed code versioning with GitHub, Bit Bucket and deployment to staging and production servers.

Worked on upgrading VMware tools and created Linux VM instances using VMware images.

Participated in database administration using shell scripting.

Good understanding on scheduling scripts on CRONTAB utility.

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.

Environment: Python 2.7, HTML5, CSS, XML, MySQL, PySpark, RESTful, MY SQL, Elastic Search, AWS, GitHub, Bit Bucket, Linux, and Windows.

Bank of America, Agora Hills, CA Aug 2019 – Nov 2020

Python Developer

Bank of America is a U.S. multinational banking and financial services holding company headquartered in Charlotte, NC. It is the largest bank in the United States, the world's ninth largest bank by total assets, with total assets of US$2.32 trillion, and the world's most valuable bank by market capitalization.

Responsibilities:

Gathered all requirement for developing and analysing requirement of projects.

Developed entire frontend and backend modules using Python on Django including Tastypie Web Framework using GIT.

Developed Merge jobs in Python to extract and load data into MySQL database.

Successfully migrated the Django database from SQLite to MySQL to PostgreSQL with complete data integrity.

Used Test driven approach for developing the application and Implemented the unit tests using Python Unit test framework.

Dynamic implementation of SQL server work on website using SQL developer tool.

Designed front end using UI, HTML, Bootstrap, Node JS, underscore JS, CSS, and JavaScript.

Involved in the Complete Software development life cycle (SDLC) to develop the application.

Used Restful APIs to access data from different suppliers and to gather network traffic data from servers.

Used NumPY for Numerical analysis.

Used Open stack for deploying and managing large numbers of virtual machines and other instances to handle computing tasks.

Followed AGILE development methodology to develop the application.

Used and customized apache server to for checking our developed project.

Good experience in using Open stack Cloud concepts.

Continuous monitoring and managing the Hadoop cluster using Cloud Manager

Used Test driven approach (TDD) for developing services required for the application.

Implemented Integration test cases.

Experienced in ETL (Export Transform Load) Processes.

Sorting or ordering the data based on a list of columns to improve search performance Using ETL.

Used GIT to resolve and coding the work on python and portlet.

Used Scala for support for functional programming and a strong static type system.

Used several python libraries like wxPython, numPY and matPlotLib.

Was involved in environment, code installation as well as the SVN implementation.

Build all database mapping classes using Django models and Apache Cassandra.

Used Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.

Environment: Python 3.3, PyQT, PyQuery, MVW, HTML5, CSS3, DOM, Angular.js, Shell Scripting, JSON, Rest, Apache Web Server, Django, SQL, UNIX, Windows, PostgreSQL, and python libraries such as NumPY.

Eduex Soft Solutions, Hyderabad, India Jan 2013 – Dec 2015

Jr Python Developer/Data Engineer

Responsibilities:

•Managed datasets using data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector MySQLdb package to retrieve information.

•Development of real-time multi-tasking systems using Python.

•Created data access modules in python.

•Developed a data migration feature using GZ File Compression and AES 256 encryption.

•Designed and developed components using Python with Django framework. Implemented code in python to retrieve and manipulate data.

•Used Python & Django creating graphics, XML processing of documents, data exchange & business logic implementation between servers.

•Worked on development of backend services using Python, SQL and Linux. Created many API's for Iscrum project which involves creating and maintaining projects in an organization. And developed UI using HTML, CSS.

•Developed backend services and created many API's using Python Programming Language and SQL.

•Involved in developing a video calling application using python web-sockets.

•Performed research regarding Python Programming and its uses and efficiency.

•Developed GUI screens for XTT & LD application using HTML and CSS.

•Development UI modules using HTML and CSS.

•Implemented web based front-end using HTML, CSS.

•Involved in developing the UI panels using XHTML, CSS.

•Set up the deployment environment on Web Logic Developed system preferences UI screens using HTML.

•Rich UI development experience and well versed in client side technologies like AngularJS, jQuery, BackBone.js, Google Widget Toolkit, Sencha UI

•Worked in XML, Oracle, DB2, Struts, spring, Hibernate, REST Web services, Model driven architecture and software configuration management tools.

•Created a Rich Single Page Application using HTML, CSS.

•Designed and implemented UI layer using HTML, DHTML, JSON, XML.

•Integrate the ExtJS/Sencha framework with Oracle BPM.

•Prepared statements are used for communication SQL database

•Involved in developing custom stored procedures.

Environment: Python, Django, HTML5, CSS3, MySQL, TOAD, SQL, DB2, Selenium, Water Fall Model, XML, Jira



Contact this candidate