Post Job Free

Resume

Sign in

Sql Server Python Aws

Location:
United States
Salary:
65$
Posted:
April 05, 2024

Contact this candidate

Resume:

Name: Atharva

Email: ad4s3k@r.postjobfree.com

Contact: +1-470-***-****

Python/AWS Developer

PROFESSIONAL SUMMARY:

●7+ years of experience in Design, Development, Implementation of Python, Django, JavaScript and client - server technology based applications.

●Experienced in developing web based applications using HTML/HTML5, DHTML, CSS/CSS3, JavaScript, Angular JS, AJAX, XML and JSON.

●Designed and implemented large scale business critical systems using Object Oriented Design and Programming concepts using Python and Django.

●Experience on ETL and ELT Tools like SQL Server Integration Services (SSIS), also have knowledge in Data Migrator (IBI).

●Worked on standard python packages like boto and boto3 for AWS.

●Hands on Experience in AWS like Amazon EC2, Amazon S3, Amazon Redshift, Amazon EMR and Amazon SQS.

●Worked on several standard python packages like Numpy, MatPlotLib, Pickle, PySide, Scipy, wxPython, PyTables etc.

●Worked on various applications using python integrated IDEs Eclipse, PyCharm, NetBeans and Geany.

●Good experience in developing web applications and implementing Model View Control (MVC) architecture using server side applications like Django, Flask and Pyramid.

●Well versed with design and development of presentation layer for web applications using technologies like HTML, CSS, and JavaScript.

●Implemented responsive web pages using HTML5/CSS3, BootStrap and XML/JSON based SOAP and REST web services.

●Good experience in handling errors/exceptions and debugging the issues in large scale applications.

●Hands on experience working in WAMP (Windows, Apache, MYSQL, and Python/PHP) and LAMP (Linux, Apache, MySQL, and Python/PHP) Architecture.

●Experienced in using Caching applications for large scale applications like Memcached, Redis.

●Experienced in working Asynchronous Frameworks like NodeJS, Twisted and designing the automation framework using Python and Shell scripting

●Expertise in working with different databases like Oracle, MySQL, PostgreSQL and Good knowledge in using NoSQL databases MongoDB (2.6,2.4)

●Proficient in developing complex SQL queries, Stored Procedures, Functions, Packages along with performing DDL and DML operations on the database.

●Proficient in Automated Verification and Validation testing tools.

●Hands on Experience in Verification and Validation testing project schedules.

●Excellent working knowledge in UNIX and Linux shell environments using command line utilities.

●Expertise in Production support and knowledge of deployment using AWS, Heroku and Jenkins.

●Experience working in both Water fall and Agile software methodologies.

●Familiarity with development best practices such as code reviews, unit testing, system integration testing (SIT) and user acceptance testing(UAT).

●Hands on experience in working with various Version Control Systems, mostly GIT, CVS and subversion SVN.

●Involved in all the phases of Software Development Life Cycle (SDLC) using Project management tools JIRA, Redmine and Bugzilla.

●Expertise in Verification and Validation tools for coding used in Python.

●Highly motivated, quality minded developer, with proven ability to deliver applications against tight deadlines.

●Possess good interpersonal, analytical presentation Skills, ability to work in Self-managed and Team environments.

TECHNICAL SKILLS:

Languages: Python, C#, C++, C, SQL, Java, ASP.net

Web Development: HTML, CSS, Javascript, AJAX

Frameworks: Django, Flask, CherryPy, Pyramid, NodeJS, Angular JS, JSP, Numpy, Matplotlib, Servlets

Servers: Apache

Databases: PostgreSQL, MySQL, Cassandra, Redis, MongoDB, SQL Server

Tools: Git, SVN, Mercurial, Memcached, Jira, SSIS, Data Migrator

IDE: Notepad++, Eclipse, IDLE, Geany, Pycharm, Liclipse

Cloud Platforms: AWS, Heroku

PROFESSIONAL EXPERIENCE:

Sanofi – Cambridge, MA July 2022 to Present

Role: Software Engineer (Python/AWS)

Responsibilities:

●Gathered data files from Data Warehouse URL’s.

●Developed file cleaners using Python libraries and made it clean.

●Utilized Python Libraries like Boto3, numpy for AWS.

●Using raw files loaded data files from URL’s to Amazon S3 Bucket.

●Worked on reading queues in Amazon SQS, which have paths to files in Amazon S3 Bucket.

●Aggregate clean files in Amazon S3.

●Generated Python Django forms to record data of online users and used PyTest for writing test cases.

●Implemented and modified various SQL queries and Functions, Cursors and Triggers as per the client requirements.

●Clean data and processed third party spending data into maneuverable deliverables within specific format with Excel macros and python libraries such as NumPy, SQLAlchemy and MatPlotLib.

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

●Helped with the migration from the old server to Jira database (Matching Fields) with Python scripts for transferring and verifying the information.

●Analyze Format data using Machine Learning algorithm by Python Scikit-Learn.

●Experience in python, Jupyter, Scientific computing stack (numpy, SciPY, pandas and MatPlotLib).

●Perform troubleshooting, fixed and deployed many Python bug fixes of the two main applications that were a main source of data for both customers and internal customer service team.

●Write Python scripts to parse JSON documents and load the data in database.

●Generating various capacity planning reports (graphical) using Python packages like Numpy, MatPlotLib.

●Analyzing various logs that are been generating and predicting/forecasting next occurrence of event with various Python libraries.

●Developed single page application by using Angular JS backed by MongoDB and NodeJS.

●Design and maintain databases using Python and developed Python based API (RESTful Web Service) using Flask, SQL Alchemy and PostgreSQL.

●Built various graphs for business decision making using Python mat plotlib library.

●Involved in development of Web Services using SOAP for sending and getting data from the external interface in the XML format.

●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.

●Scraping website using Python Beautiful Soup, and then parsed it with XML.

●Outputting the parsed data as JSON/BSON and stored into MongoDB

●Used NLTK and StanfordNLP to process text data and created offline intelligence.

●Used Amazon EMR for map reduction jobs and test locally using Jenkins.

●Also worked on Amazon EC2 Clusters to deploy files into Buckets.

●Worked on Matillion ETL Tool, used it to transfer and load data into Amazon Redshift.

●Mentored and provided technical guidance to other test engineers as necessary during verification and validation activities

●Developed and maintained the Verification and Validation group’s project schedules and roadmap ensuring project on schedule.

●Experienced in Agile Methodologies and SCRUM Process.

●Exported/Imported data between various data sources.

●Created database using MySQL, wrote several queries to extract/store data.

Elphi - Boston, MA May 2019 to Aug 2021

Role: Software Engineer (Python)

Responsibilities:

●Analyzed and gathered business requirements specifications by interacting with client and understanding business requirement specification documents.

●Developed the presentation layer using HTML, CSS, JavaScript, JQuery and AJAX.

●Used JQuery libraries for all client side JavaScript manipulations.

●Utilized Python libraries wxPython, numpy, Twisted and MatPlotLib.

●Implemented SQLAlchemy which is a python library for complete access over SQL.

●Worked on Element Tree XML API in python to parse XML documents and load the data in database.

●Skilled in collections and used for manipulating and looping through different user defined objects.

●Developed views and templates with Python and Django’s view controller and templating language to created user-friendly website interface.

●Used Django configuration to manage URLs and application parameters.

●Created entire application using Python, Django, MySQL and Linux.

●Used Amazon Elastic Beanstalk with Amazon EC2 to deploy project into AWS.

●Accessed database objects using Django Database APIs.

●Generated Python Django Forms to record data of online users.

●Implemented Data tables to add, delete, update and display patient records and policy information using PyQt.

●Implemented a module to connect and view the status of an Apache Cassandra instance using python.

●Developed MVC prototype replacement of current product with Django.

●Improved the Data Security and generated report efficiently by caching and reusing data.

●Created UI using JavaScript and HTML5/CSS3.

●Managed datasets using Panda data frames and MYSQL. Queried the database queries using Python-MySQL connector and retrieved information using MySQL db.

●Recorded the online users data using Python Django forms and implemented test case using Pytest.

●Developed the application using the Test-driven methodology and designed the unit tests using Python Unit test framework.

●Created database using MySQL, wrote several queries to extract/store data.

●Exported/Imported data between various data sources.

●Integrated data from multiple applications using ETL and ELT tools like SSIS.

●Experienced in Agile Methodologies and SCRUM Process.

●Identified several hidden bugs caused by complicated multithreading issues such as race conditions caused by asynchronous events and resolved them.

●Responsible for debugging and troubleshooting the web application.

●Took part in the entire project’s lifecycle which includes Design, Development and Deploying, Testing, Implementation and support.

●Used Design patterns efficiently to improve the code reusability.

●Coordinated with the offshore development team and assisted them when required.

Environment: Python 2.7, Django 1.6, CSS, HTML, JavaScript, JQuery, AJAX, MYSQL, Linux, AWS, GIT.

Delta Airlines, Atlanta, GA January 2018 – April 2019

Role: Python Developer

Responsibilities:

●Implemented user interface guidelines and standards throughout the development and maintenance of the website using the HTML, CSS, JavaScript and JQuery.

●Implemented AJAX for dynamic functionality of web pages for front end applications.

●Worked on front end frameworks like CSS Bootstrap for responsive web pages.

●Developed and tested many features for dashboard, created using Bootstrap, CSS, and JavaScript.

●Worked on server side applications with Django using Python programming.

●Used Pandas for a data alignment and data manipulation.

●Utilized standard Python modules such as csv, itertools and pickle for development.

●Worked on Python OpenStack APIs and used Numpy for Numerical analysis.

●Used Ajax and JQuery for transmitting JSON data objects between frontend and controllers.

●Developed Wrapper in Python for instantiating multi-threaded application.

●Developed views and templates with Python and Django's view controller and templating language to created user-friendly website interface.

●Deployed project into Amazon web services (AWS) using amazon elastic bean stalk.

●Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using ETL and ELT tools like SSIS.

●Created web application prototype using jQuery and Angular JS.

●Deployed the project into Heroku using GIT version control system,

●Maintained and Updated the application in accordance to the clientele’s requirement

●Used JIRA for bug tracking and issue tracking.

●Added several options to the application to choose particular algorithm for data and address generation.

●Developed the project in Linux environment.

●Used Agile Methodology and SCRUM Process.

●Maintained the versions using GIT and sending the release notes for each release.

●Supported the issues seen in the tool across all the teams for several projects.

Environment: Python 2.7, Django 1.4, CSS, HTML, BOOTSTRAP, JavaScript, JQuery, AJAX, MYSQL, Linux, AWS, GIT.

Beyondsoft – Hyderabad, Telangana June 2017 to December 2018

Python/Django Developer

Responsibilities:

●Used Agile Methodology and SCRUM Process.

●Responsible for gathering requirements, system analysis, design, development, testing and deployment.

●Participated in the complete SDLC process.

●Developed Business logic using Python 2.7

●Used Django framework for database layer development.

●Developed user interface GUI using CSS, HTML, JavaScript and JQuery.

●Responsible for setting up Python REST API framework using DJANGO.

●Created database using MySQL, wrote several queries to extract data from database using ETL and ELT tool (SSIS).

●Used Memcache as in memory key-value pair database to reduce traffic to database server.

●Wrote scripts in Python for automation of testing jobs.

●Deployment and Build of various environments including Linux and UNIX

●Installed and maintained web servers Tomcat and Apache HTTP (1.3, 2.2) Web servers in Red Hat Linux.

●Used web services for integration and testing.

●Jira is used as project management tool for issue tracking and bug tracking.

●Implemented monitoring and established best practices around using elastic search.

●Effectively communicated with the external vendors to resolve queries.

●Used GIT for the version control and deployed project into AWS.

Environment: Python 2.7, Django 1.4, C++, JSON, XML, SOAPUI, HTML, Restful API, Shell Scripting, SQL, MySQL, AWS, GIT, Linux.



Contact this candidate