Sql Developer Resume
Columbus, Ohio
SUMMARY:
- Enthusiastic Web/Application Developer with 7 years of experience in developing and deploying projects using Python, Django.
- Full software development life - cycle experience, worked in agile and waterfall methodologies with high quality deliverables delivered on-time.
- Experience with architecting scalable platforms, object oriented programming, database design and agile methodologies.
- Built web applications by using Python, Django, AWS, Flask, Jinga, WSGI, nginx, Fabric, PostgreSQL, REDIS.
- In-depth knowledge of providing specifications using Waterfall, RUP or Agile Software methodology to modeling systems and business processes.
- Proficient with Photoshop, Illustrator, Adobe Flash, SVN Eclipse, MS Visio, SharePoint and Microsoft Front Page.
- Worked on cross browser compatibility testing and intellectual challenges in User Experience (UX).
- Worked with MVW frameworks like Django, Angular JS, Java Script, JQuery and Node.js.
- Object oriented programming (OOP) programming experience using Python, C++ and PHP.
- Strong working experience with WAMP (Windows, Apache, MYSQL, Python/PHP) and LAMP (Linux, Apache, MySQL, Python/PHP) Architecture.
- Proficient in developing front-end applications using Python, Django, PHP, XML, CSS, HTML, JavaScript and JQuery.
- Worked on installing, configuring, modifying, testing and deploying applications with Apache web server.
- In-depth knowledge of design and development of presentation layer for web applications using technologies like HTML, CSS, and JavaScript.
- Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
- Experience maintaining detailed documentation and architectural solutions in IT infrastructure and sales systems.
- Worked on continuous integration and automation using Jenkins.
- Worked on Unit testing/ Test driven Development (TDD), Load Testing.
- Developed the required XML Schema documents and implemented the framework for parsing XML documents.
TECHNICAL SKILLS:
Web technologies: JavaScript, XML, HTML, CSS
Languages: Python, Java, C, C++,SQL, Shell Scripting
Frame works: Django, Spring MVC, Hibernate
Database: SQL SERVER, MYSQL, Oracle
Operating Systems: UNIX, Linux, Windows and
Software Tools: Microsoft Visual Studio .Net 2008, MS Visio, Valgrind Version Control Tools CVS, Perforce, Code Collaborator.
Web servers: Apache, Flask
PROFESSIONAL EXPERIENCE:
Confidential, Columbus, Ohio
SQL Developer
Environment: Python3.5, Django, HTML5/CSS, MS SQL Server 2013, MySQL, JavaScript, Eclipse, Linux, Shell Scripting, JQuery, GitHub, Angular.JS, Jira
Responsibilities:
- Built the UI of the website using HTML, AJAX, CSS and JavaScript.
- Worked with Django Database API's to access database objects.
- Used JavaScript to handle all the client side validation.
- Built Python/Django modules to deliver certain format of data.
- Used Bootstrap, Javascript, and jQuery to optimize the user experience.
- Built python scripts to parse XML documents and load the data in database.
- Built data management system using MySQL.
- Developed automated test design, frontend and backend feature implementation, and any other improvements to the test automation framework.
- Used Python and Django to interface with the jQuery UI and manage the storage and deletion of content.
- Developed Web Services using SOAP for sending and getting data from the external interface in the XML format.
- Responsible for debugging the project monitored on JIRA (Agile).
- Worked with JQuery for all client side JavaScript manipulation.
- Developed unit test/regression test framework for working/new code.
- Used Subversion control tool to coordinate team-development.
- Built development environment with JIRA.
- Developed multiple high performance MongoDB replica sets on EC2 with robust reliability.
- Implemented whole frontend and backend modules using Python on Django Web Framework.
- Involved in debugging and troubleshooting of the web applications.
- Involved in entire lifecycle of the project including Design, Development, and Deployment, Testing and implementation and support.
SQL Developer
Environment: XML Schemas, XML, JSF, Java Script, CSS, HTML, Angular JS, Linux, Shell Scripting, Python 2.7, Java Script, JQuery, JSON, XML, MySQL.
Responsibilities:
- Developed Python/MySQL back-end for data entry from Flash. Assisted the Flash developer send the correct data via querystrings.
- Developed high-performance streaming REST server in Flask .
- Maintenances PHP/MySQL (primarily Joomla), Classic ASP/MSSQL. Communicating and interfacing with previous developers on a regular basis.
- Worked on migrating the Django database from SQLite to MySQL to PostgreSQL with complete data integrity.
- Developed and deployed advertisements with Advert Serve.
- Experience in AWStats and Google Analytics to analyze web traffic.
- Worked with the team that did automated test design and various automation framework improvements.
- Worked on Django models modifications while retaining all data, while site was in production mode using Django evolution and manual SQL modifications.
- Created XML with Django to be used by the Flash. Worked very closely with designer, integrating Flash into the CMS with the use of Flashvars stored in the Django models.
- Experienced in using Wire shark, live http headers, and Fiddler2 debugging proxy to debug the Flash object and help the developer create a functional component. The webpages for displaying the data uses AJAX to sort and display the data. The page also outputs data to csv for viewing in Microsoft Excel.
- Upgraded Python 2.3 to Python 2.5 on a RHEL 4 server, this required recompiling mod python to use Python 2.5. This upgrade was necessary because inlined models with UTF-8 characters were causing unexpected errors. Submitted a ticket to the Django project documenting this incompatibility with Python 2.3.
SQL Developer
Environment: Python, Django 1.3, MySQL, Linux, HTML, XHTML, SVN, CSS, AJAX, Bugzilla, JavaScript, Apache Web Server, Django.
Responsibilities:
- Designed and developed data management system using MySQL.
- Worked on high level design and detail design.
- Design, develop, test, deploy and maintain the website.
- Developed the interactive user interface using jQuery JavaScript library.
- Developed/Modified GUI using HTML, CSS and JavaScript (jQuery).
- Built application logic using Python 2.7, Django and MYSQL.
- Rewrite existing Python/Django modules to deliver certain format of data.
- Used Django Database API's to access database objects.
- Developed python scripts to parse XML documents and load the data in database.
- Worked on all the client side validation using JavaScript.
- Wrote Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers and User Defined function.
- Extensively used Selenium Library to write fully functioning test automation process that allowed the simulation of submitting different we request from multiple browser to web application.
- Worked with JQuery for all client side JavaScript manipulation.
- Developed unit test/regression test framework for working/new code.
- Used Subversion control tool to coordinate team-development.
- Worked with Forms, views, models using Django.
- Developed entire frontend and backend modules using Python on Django Web Framework.
- Debugging and troubleshooting the web application.
- Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
- Generated complex graphical data, creation of histograms etc using the Python's modules numpy, matportlib etc.
Environment: Django Framework, MYSQL, AJAX, CSS, Python 3.5
Responsibilities:
- Worked with PYTHON, MYSQL, CSS, JavaScript, AJAX and XHTML to build a fully Web 2.0 compliant social networking website around online HD streaming video.
- Developed scalable applications.
- Developed applications using the Zend framework.
- Performed documentation and user training.
- Built key modules including photo gallery, blogging system, forums, profiles, articles, newsletters, email, chat and IM.
- Integrated third party software such as Image Magic, TinyMce AJAX, IM.
- Developed multi-page applications from beginning to end.
- Performed Flow Control, response to Front-End Request using PYTHON/MYSQL/AJAX.
- Conceived and created tables using MySQL 5.
- Created tables, stored procedures, triggers and views for data access and manipulation.
- Fixed bugs using Xdebug.
- Maintained code using SVN.
Software Developer
Environment: Python 2.6/2.7, Linux, Shell Scripting, JavaScript, Django Framework, CSS, SQL, MySQL, LAMP, JQuery, Adobe Dreamweaver, Apache web server.
Responsibilities:
- Part of the team that set up networks through Design and Development.
- Created Database, Business Logic to display the records dynamically on template based on query, providing user permission to access particular features of the site.
- Developed complex algorithms for networks using data structures like directories, tuples, object oriented class based inheritance features for making complex algorithms of networks.
- Developed various custom modules for integration of various types of network circuits.
- Responsible for important Network APIs for Basic Video, developed user interface screens and solved customer reported software bugs or issues.
- Worked on memory managed design patterns for various GigE networks.
- Used smart pointers, profilers and C++ Standard template library to optimized the code.
- Built an effective Basic Video customization development environment for other developers to work in.
- Directly responsible for various enhancements of Equipment updates/transmission of signals on OC/STS cables.
- Profiled python code for optimization and memory management.
- Implemented locking mechanisms using multi-threading functionality.
- Used Purify, GDB and DBX for debugging/crash logs which helped in performance enhancement and optimization.
- Worked with various Design Patterns in provisioning the networks.
- Developed and deployed the orders for VNI, VHO, VSO, ONI etc., and their controllers as demanded for the applications design.
- Worked on Content Management through front end, live search and normal search features.
- Tracked small amounts of data without requiring the DB using Python's XML parser architectures (SAX) and DOM API.
