Senior Python Developer/etl Resume
Alpharetta, GA
SUMMARY
- 8+ years of experience as a Python Developer, pro cient coder in multiple languages and environments including Python, C, JavaScript and SQL.
- Worked on several standard python packages like Numpy, Pickle, PySide, Scipy, wxPython, PyTables etc.
- Driven to architect Big Data solutions on multiple platforms using data analytics.
- Developed various Python scripts to generate reports, send FIX messages (FIX Simulator), SOAP requests, TCP/IP programming and multiprocessing jobs.
- Good Experience in Working on Restful Api’s.
- Good experience in developing web applications and implementing Model View Control (MVC) architecture using server - side applications like Django, Flask and Pyramid.
- Experience in working on BDPaaS (Big Data Platform as a Service).
- Expertise in working with different databases like Microsoft SQL Server, Oracle, MySQL, PostgreSQL and Good knowledge in using NoSQL databases MongoDB
- Expertise in working on data migration tools like Alembic.
- Proficient in developing complex SQL queries, Stored Procedures, Functions, Packages along with performing DDL and DML operations on the database.
- Hands on Experience in Data mining and Data warehousing using ETL Tools.
- Excellent working knowledge in UNIX and Linux shell environments using command line utilities.
- Application Stress tester, created and stress tested stand-alone, web-applications and generated graph reports.
- Motivated, proactive, innovative problem solver with excellent analytical, organizational, interpersonal, communication and written skills. Excellent team player, quick learner, keens to learn and implement new IT technologies.
- Strong knowledge of Data Structures and Algorithms, Object Oriented Analysis, machine learning and software design patterns.
- Good Experience in Working on Geospatial Data.
- Good Experience in working with Microsoft Team city and Octopus for continuous integration and deployment.
- Expertise in Production support. Provided first, second and third level support to different organizations. Used pdb, gdb and other debugging tools and deployed production hot fixes.
- Expert at version control systems like Git, GitHub, svn and cvs. Migrated repos from svn to GitHub.
- Experience in documenting the build and entire deployment process
- Good Experience in working on Amazon Web Services.
- Good Experience in Collaborating and working with Offshore resources.
- Experience with Agile, Scrum and Waterfall methodologies. Used ticketing systems like Jira, Bugzilla and other proprietary tools.
- Experience troubleshooting software and automation issues with assistance of testing engineers
- Familiarity with development best practices such as code reviews, unit testing, system integration testing (SIT) and user acceptance testing(UAT).
- 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.
- Performed code reviews and implemented best Pythonic programming practices
- Experience in writing test scripts, test cases, test specifications and test coverage.
- Good experience in handling errors/exceptions and debugging the issues in large scale applications.
TECHNICAL SKILLS
Programming Languages: Python, C, C++, JavaScript.
Operating Systems: Ubuntu, Windows 10/XP/2000/Vista/7, RedHatlinux, Windows server 2008,2012.
Python Libraries: Python, Django, Flask, Beautiful Soup, SQLAlchemy, GeoAlchemy, HTML/CSS, Bootstrap, jQuery, Pandas, Numpy, PySide, Scipy, wxPython, PyTables
Development tools: Sublime Text, Eclipse, PyCharm, emacs, gvim, Notepad++, OpenGrok, Jenkins, Coverity, pylint, pdb, gdb, cpp check
Databases: Microsoft SQL Server, PostgreSQL, Oracle, MySQL, MS Access, Mongo Db and NoSQL database
Cloud Technologies: AmazonWebServices(S3,CloudWatch,APIGateway,Step Functions,RDS,CloudFormation,Lambda,EC2,SES,SNS,Batch)
Big Data: Hive,PIG,PySpark,Spark
Version Controls: Git, GitHub, cvs, svn
Methodologies: Agile, SCRUM and Waterfall.
PROFESSIONAL EXPERIENCE
Confidential, Alpharetta, GA
Senior Python Developer/ETL
Responsibilities:
- Developed the ETL jobs as per the requirements to update the data into the staging database (Postgres) from various data sources and REST API’s.
- Developed analytical queries in Teradata, SQL-Server, and Oracle.
- Automated robot framework test plans to continuously validate the telematics application in staging and prod.
- Automated Jmeter test cases to perform the rest api load and performance testing.
- Wrote Python and batch scripts to automate the ETL scripts runs every hour.
- Developed ETL scripts in Python to get data from one database table and insert, update the resultant data to another database table.
- Wrote Python scripts to parse XML documents and load the data in database.
Confidential, Bellevue
Python Developer/Tester
Responsibilities:
- Developed rest API for device testing.
- Created application repository using Django framework for all new Confidential employees.
- Automated test cases using Robot Framework for phone testing.
- Developed python codebase to automatically update or download images from cisco websites.
- Successfully coordinated and developed the deployment process
- Documented the entire build and deployment process including detailed step-by-step instructions
- Supported multiple parallel projects by creating processes & procedures for reusing existing code
- Extracted and loaded data using Python scripts and PL/SQL packages
- Developed python scripts to parse 4g test failure and measure voice quality using Netscout application.
- Develop and coding of Informatics mappings, session, workflows for different stages of ETL
- Prepared scripts to ensure proper data access, manipulation and reporting functions with R programming languages.
- Formulated procedures for integration of R programming plans with data sources and delivery systems.
- Creating unit test/regression test framework for working/new code
- Debugging and testing of the applications & fine-tuning performance. Provided maintenance support in production environment.
- Worked onMongoDBdatabase concepts such aslocking, transactions, indexes, Sharding, replication, schema design.
- Experience in managing MongoDB environment fromavailability, performance and scalabilityperspectives.
Confidential, Iowa
Python Developer/Tester
Responsibilities:
- Developed Restful APIs using Python.
- Analyzed complex user requirements, procedures, and problems to improve existing System design.
- Helping automate data analysis by automating pre-processing and incorporating helper functions into API codebase.
- Used SQL toolkits like SQLAlchemy and Geo Alchemy.
- Extensively worked on Geospatial data.
- Developed end to end application components involving business layer, persistence layer, database and web services layer.
- Documented Detailed design within a given project structure.
- Developed code for http Api calls like (GET, PUT, POST, DELETE)
- Worked on Ingestion Process of geospatial data using ETL techniques.
- Experience in working and coordinating with Offshore resources.
- Used Analytical Python Libraries like Pandas and Numpy to work on Data Manipulations.
- Successfully coordinated and developed the deployment process.
- Worked on .csv, xml, .xlsx, and json files.
- Documented the entire build and deployment process including detailed step-by-step instructions.
- Worked on developing tables using alembic a data migration tool used for SQLAlchemy.
- Extensively worked on Microsoft Team city and Octopus for Continuous Integration and Deployment.
- Wrote python scripts to parse XML and CSV documents to load the data in database.
- Extensively worked on AWS Cloud platform and its features including EC2, VPC, RDS, Api Gateway, Cloud Watch, Cloud Formation, Step Functions, IAM, S3, SES, SNS, Batch, Lambda.
- Created SNS notifications and assigned ARN to S3 for object loss notifications
- Getting thoroughly involved in the programming of web based applications using pymongo.
- Working knowledge in AWS Lambda for Server-less computing using Python
- Working knowledge in Api Gateway for creating Api keys and endpoints.
- Developed cloud formation scripts to create and update stacks.
- Generated property list for every application dynamically using python.
- Worked on Defect Debugging.
- Creating unit test/regression test framework for working/new code.
- Debugging and testing of the applications & fine-tuning performance. Provided maintenance support in production environment.
- Followed Agile and Scrum Methodologies. Used Jira ticketing system.
Environment: Python, HTML/CSS, PostgreSQL 9.6, ETL, Team city, Octopus, Alembic, IBM, AWS, Oracle, PL/SQL, Unix Shell Scripting, Red Hat Linux, WebLogic Application Server.
Confidential, New York
Python Developer/Tester
Responsibilities:
- Developed application logic using Python.
- Used JMS for updating Mailing plans and tracking them.
- Used Java Server Pages for content layout and presentation.
- Created Data layer in MYSQL.
- Successfully coordinated and developed the deployment process
- Documented the entire build and deployment process including detailed step-by-step instructions
- Supported multiple parallel projects by creating processes & procedures for reusing existing code
- Extracted and loaded data using Python scripts and PL/SQL packages
- Supported Java application for Media portal management.
- Added Buy side and Sell side interfaces to route and receive orders over FIX as TCP/IP packets on a given port. Used FIX Simulator behind the scenes.
- Migrated C and C++ tasks to Python. Generated SWIG interfaces for tasks that are good to be left in C++. Interacted with Python using SWIG interfaces.
- Wrote python scripts to parse XML documents and load the data in database.
- Generated property list for every application dynamically using python.
- Creating unit test/regression test framework for working/new code
- Debugging and testing of the applications & fine-tuning performance. Provided maintenance support in production environment.
- Developed exhaustive SQL Queries to find differences in datasets to find out whether rolled out software has fixed issues.
- Developed scripts to migrate data from proprietary database to MySQL.
- Followed Agile and Scrum Methodologies. Used Jira and other proprietary ticketing systems.
Environment: Java, Python, JavaScript, HTML/CSS, MySQL, PL/SQL, JDBC, Unix Shell Scripting, Red Hat Linux, WebLogic Application Server.
Confidential, CA
Senior Python Developer/Tester
Responsibilities:
- Prototyped web front-end to MDM
- Design database using Erwin and Python/Django for DB scheme scripting
- Design MDM integration facilities (SOA-style)
- Develop SOAP client for testing MDM to SAP R/3 interoperation
- Develop scheme- and data-level database testing tool
- Develop data cleansing, retrieval, migration tools (ETL)
- Analyzed client’s needs and developed software tools to assist dynamic site content creation (Python, wxPython)
- Written MapReduce code in Java and Python
- Writing Pig Latin scripts and Hive query language to process the data and also written UDF in Java andPython
- Studying and analyzing requirement specifications and product documentation to plan and create automate test cases
- Handling responsibilities of identifying and troubleshooting software and automation issues with assistance of testing engineers
- Performing tasks of maintaining and documenting test and automation results
- Responsible for analyzing test results to ensure proper functionality of automation systems
- Coordinating with development engineering staff in resolution of problems
- Mainframe access profiles, using a series of algorithms created access profiles securing company mainframe system and allowing for auditing purposes and easier acclimation of new hires.
- SQL Workflow System, using Python created an adapter allowing communication between SharePoint lists and SSIS packages. This system provides users the ability to create complex automation workflows
- Excel Batch uploader, software that quickly uploads large batches of Excel Workbooks into our SQL Databases, while providing sanitizing and validation services
- SQL Naming Conventions Enforcement, Using Python; Stored Procedures created a server job that enforces naming conventions for all SQL objects. Creating a more constant SQL environment
- Client Search Engine, Using Python and XLWings package created an excel interface to search for client info through our databases
- Integrated Opengrok into development environment for making source code visible across the organization.
- Used Agile Methodology and SCRUM Process.
Environment: Erwin, Python, JavaScript, C++, SQL, ETL, SOAP, SQL, ETL, SOAP, FIX, TCP/IP programming, MySQL, Rabbit MQ, cppCheck, Jenkins, Coverity, Agile.
Confidential
Software Developer in Python
Responsibilities:
- Worked with the Stakeholders, gathered requirements developed High level design Detail design documents.
- Developed UI using HTML, AJAX, JavaScript and jQuery and jQueryUI.
- Re-engineered various modules for implementing changes and creating efficient system.
- Developed rich UI web application using JavaScript libraries like jQueryUI, data grid, jscolor, high charts.
- Designed and developed components using Python. Implemented code in python to retrieve and manipulate data.
- Implemented database access using Django ORM.
- Used MySQL as backend database and MySQL dB of python as database connector to interact with MySQL server.
- Used Restful APIs to access data from different suppliers.
- Support the scripts configuration, testing, execution, deployment and run monitoring and metering.
- Used Python and Django creating graphics, XML processing of documents, data exchange and business logic implementation between servers.
- Used Restful API's to gather network traffic data from Servers.
- Supported Apache Tomcat web server on Linux Platform.
- Developed and executed User Acceptance Testing portion of test plan.
- Debugging Software for Bugs
Environment: Python, C++, JavaScript, MySQL, Shell Scripting, PL/SQL, Unix, Linux, Agile, pylint, Jenkins.