Sr. Python Developer, Data Analyst Resume
Schaumburg, IL
SUMMARY
- Overall 10+ years of experience as an Analysis, Design, Development, Management and Implementation of various stand - alone, client-server architecture-based enterprise applications using Python.
- Sound experience in working with different python editors like PyCharm, PyScripter, PyStudio, Sublime Text.
- Experience in software development in Python (libraries used: libraries- NumPy, SciPy, Pickle, matplotlib, Python, Python-twitter, Pandas data frame, MySQL DB for database connectivity).
- Work with front end engineers to identify needed API functionality for our web applications.
- Experience on Web development using HTML5, CSS/CSS3, JavaScript, jQuery, Angular JS, AJAX, XML and JSON by following W3C standards.
- Knowledge in Visualization tools that have Big Query connectors - Tableau.
- Extensive Tableau Experience in Enterprise Environment, in Tableau 10.1/9.x/8.x/7.x as a Developer and Admin, Data Visualization, Dashboards, worksheets.
- Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud and designed several business dashboards.
- Work with data science team to identify API functionality needed for data analytics.
- Work with Matplotlib in extensions with NumPy and pandas, for providing an Object-oriented API by embedding graphical plots into application.
- Work with PyPip/pip package in automation of excel sheets work books.
- Contribute to the evolution of our Django Rest Framework based API and Ember.js based user interface.
- Worked on SQL queries, working knowledge of RDBMS like SQL & ORACLE. Proficient in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers using relational databases like Oracle, DB2, MySQL and MSSQL Server.
- Skilled in debugging/troubleshooting issues in complex applications.
- Expertise in Object-Oriented design and coding. Good knowledge of various Design Patterns and UML.
- Followed Agile Methodologies (Scrum), involved in daily standup meetings.
- Good Experience on Selenium IDE and creating Scripts in selenium --RC by using Python. Experienced in unit testing and testing using Selenium.
- Experienced in developing applications using Amazon web services like EC2, Cloud Search, Elastic Load balancer ELB, S3, Cloud Front, Route 53.
- Writing JavaScript for AJAX requests, form handling, and UI element. Familiar with JSON based REST API’s Web services and Amazon Web Services (AWS).
- Built multifunction readmission reports using python pandas and Django frame work. writing SQL Queries and implementing stored procedures, functions, packages, tables, views, Cursors, triggers.
- Good Experience in Linux Bash scripting and following PEP Guidelines in Python.
- Good knowledge in front end technologies such as HTML5, CSS3, Bootstrap, JavaScript, Node.JS, Angular.JS, XML, Ajax and JQuery. Good experience in setting up REST API using Django.
- Firm knowledge of different phases of Software Testing and Software Development Life Cycle (SDLC) including Agile Methodology and Waterfall.
TECHNICAL SKILLS
Frameworks: Django, Flask, Zope, PyJamas, Jython, Struts and CSS Bootstrap
Web Technologies: HTML, CSS, Java Script, JQuery, AJAX, XML, AngularJS, NodeJS
Programming Languages: Python, Java, C/C++, PERL, SQL and PL/SQL.
Scripting languages: CSS, AJAX, Java Script, JQuery, PHP, PowerShell Scripting
Versioning Tools: SVN, CVS, Git, GitHub, Bambo, BitBucket
Analytic Tools: JMP PRO, SAS, Tableau, UCI NET, NodeXL, MVC3
Application servers: Apache Tomcat, WebLogic, WebSphere
Databases: Oracle (9i,10g, 11g), My SQL, Apache Cassandra, MongoDB
IDE’s/ Development Tools: NetBeans, Eclipse, PyCharm, PyScripter, PyStudio, and Sublime Text.
Operating Systems: Windows, Red hat Linux 4.x/5.x/6.x, MAC OSX.
Protocols: TCP/IP, HTTP/HTTPS, SOAP, SMTP
Deployment Tools: Heroku, Amazon EC2
Testing Tools: Selenium, Bugzilla, Crucible and JIRA.
Protocols: TCP/IP, HTTP/HTTPS, SOAP, SMTP
PROFESSIONAL EXPERIENCE
Confidential, Schaumburg, IL
Sr. Python Developer, Data Analyst
Responsibilities:
- Having Extensive Experience in Agile Methodology
- Associated with various phases of Software Development Life Cycle (SDLC) of the application like requirement gathering, Design, Analysis and Code development.
- Worked with team of developers on Python applications for RISK management.
- Generated Python Django Forms to record data of online users
- Used Python and Django creating graphics, XML processing, data exchange and business logic implementation.
- Experienced in ORM programming in converting data between incompatible type systems in OOP languages.
- Developed flask Restful API endpoints for accessing through UI and uploading ETL data.
- Contribute to major development initiatives with codebases utilizing Python, Django, R, MySQL, MongoDB, jQuery and React.
- Work with multiple team to develop services and coordinate releases.
- Used PHP as an HTML embedded scripting language, in front end web development.
- Prepare Test scripts for different applications using QTP & Selenium
- Run a Regression test on Selenium after every build.
- Automation of internal web application through Selenium 2 WebDriver.
- Performed Compatibility testing of applications for dynamic and static content of browsers using HTML Ids and XPath in Selenium.
- Developed ETL (Extract Transform Load) software for DB2 columnar database fact and dimension tables.
- Develop data models for applications, metadata tables, views or related database structures.
- Developed entire frontend and backend modules using Python on Django Web Framework with GIT.
- Designed and managed API system deployment using fast http server and Amazon AWS architecture.
- Interfacing with supervisors, artists, systems administrators and production to ensure production deadlines are met.
- Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQLdb package.
- Used NoSQL database Apache Cassandra to load the data in database.
- Wrote Python scripts to parse XML documents and load the data in database.
- Utilized Python libraries wxPython, numPY, Twisted and Mat PlotLib.
- Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
- Carried out various mathematical operations for calculation purpose using python libraries.
- Developed tools using Python, Shell scripting, XML to automate some of the menial tasks.
- Interfacing with supervisors, artists, systems administrators and production to ensure production deadlines are met.
- Used Pandas library for statistical Analysis
- Designed and developed the UI of the website using HTML, XHTML, AJAX, CSS and JavaScript.
- Performed research to explore and identify new technological platforms.
- Created actions to navigate from one dashboard to another dashboard and created URL actions to navigate dashboards of tableau server based on parameters.
- I have designed and built various reports & dashboards activities such as grouping, sorting, filtering, ranking and ordering the data and using Tableau.
- Created, maintained, modified, and optimized SQL Server databases, database security and auditing.
- Designed, programmed, deployed and tested the requested Reports.
- Created Sets, Groups and Data Bins as per user requirements. Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts etc.
- Creating Multiple Dashboards using SQL as source and reducing the Performance Issues in the Tableau dashboards with Live connections with the Data Source.
- Experience with Customer Relationship Management and Sales Force Automation systems such as Salesforce.com to see detail level of customer data.
- Created and implemented dashboards and reports (using Jira & Confluence data) that creatively meet the needs of stakeholders.
- Created story showing the performance of each sales representative since sales territory assignment.
- Developed different types of reports like tabular, matrix, drill down and drill through for different sales management hierarchies.
ENVIRONMENT: Python 2.7, Django, MongoDB, Selenium, Amazon Aws, Pandas, Java, JQuery, Bootstrap, MySQL, Linux, Ajax, Java Script, Apache, Cassandra, HTML5 and CSS, Tableau Desktop 2018.3 v, Tableau Server 2018.3v, SQL Server 2016, SSIS, SSRS, SSAS, PL-SQL, Microsoft Excel.
Confidential, Richmond VA
Python Developer
Responsibilities:
- Developed tools using Python, Shell scripting, XML to automate some of the menial tasks. Interfacing with supervisors, artists, systems administrators and production to ensure production deadlines are met.
- Build all database mapping classes using FLASK models.
- Involved in building database Model, APIs and Views utilizing Python to build an interactive web-based solution.
- Extensive experience in implementing Continuous Integration and Continuous Delivery (using Jenkins) in an AWS Environment.
- Created Test plans. Worked on SQL scripts to load data in the tables.
- Connected continuous integration system with Developed monitoring and notification tools using Python. version control repository and continually build as the check-in's come from the developer.
- Coding groovy, domain class to handle the business logic.
- Strong experience in setting up the enterprise infrastructure on Amazon Web Services (AWS) like Auto Scaling, CloudFormation, CloudTrail, CloudWatch, DynamoDB, EBS, EC2, ELB, IAM, Redshift, RDS, S3, VPC, Route 53, CloudFront, security group and AWS lambda
- Developed Templates for AWS infrastructure as a code using Terraform to build staging and production environments
- Developed entire frontend and backend modules using Python on FLASK Framework.
- Developed custom screens using HTML5, JavaScript, jQuery, Bootstrap, Jinja and Angular.js.
- Migrated VMWARE VMs to AWS and Managed Services like EC2, S3 Bucket, Route53, ELB, EBS.
- Developed monitoring and notification tools using Python.
- Reviewed product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.
- Experienced with event-driven and scheduled AWS Lambda functions to trigger various AWS resources
- Experience in Selenium Automation using Selenium Web Driver, Java and Unit Test Framework.
- Created Selenium web-driver automation scripts using Python to validate functionality on various browsers.
- Wrote AWS Lambda functions in python for AWS's Lambda which invokes Python scripts to perform various transformations and analytics on large data sets in EMR cluster
- Established framework to setup Continuous Integration environment using Jenkins, Nexus.
- Extensive experience in implementing Continuous Integration and Continuous Delivery (using Jenkins) in an AWS Environment.
- Creating the Brokers for the use of Kubernates, kafka, zookeeper
- Provided on-going support and administration for Jenkins, SonarQube, fortify scan, GIT and build automations.
- Integrated Jenkins with various DevOps tools such as Nexus, Sonar Qube, Puppet etc.
- Involved in migration of CI tool stack from SVN to GIT, Maven to Gradle, Build force to Jenkins.
- Create Jenkins pipeline jobs for Puppet release process for module deployment, using Kanban methodology for Puppet development.
- Used Splunk for centralized logging and debugging, experienced in Installing, Configuring and Monitoring using NAGIOS
- Used Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.
- Involved in developing selenium automation framework using TestNG.
- Worked on AWS Cloud and Created instances in EC2.
- Experienced in designing Test Plans and Test Cases, Verifying and Validating Web based application.
- Imported and managed multiple corporate applications into Subversion (SVN).
ENVIRONMENT: Python, PyCharm, Selenium IDE, Perl, Groovy, jQuery, Tableau, MySQL, HTML, CSS, JavaScript, Kubernates, Ajax, Web Services, Pandas, JSON, Angular.js, Bootstrap, Jinja, Flask, MongoDB, SQL Workbench.
Confidential, Tampa, Florida
Python Developer
Responsibilities:
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
- Involved in the analysis and development of Software Development Life Cycle (SDLC).
- Contributed in developing a web services middle-tier in Python to integrate with an existing MySQL backend. Wrote several internal API utilities and micro services to carry out specific tasks.
- Wrote and executed exhaustive SQL queries using Python with help from various query builders in Python to frame the queries.
- Migrated MySQL to NoSQL data store using ETL processes using Python. Tasks included CRUD, elaborate cleansing of data and packing it into the expected format - JSON.
- Developed Python scripts to perform auditing tasks and generating Excel reports to support engineering a logistics, sales and inventory management system.
- Worked as assistant to Web Programmer in creating Django/Flask Web apps. Generated sample JSON format queries for testing REST endpoints.
- Frequently performed adhoc File IO tasks in python. Dealt with CSV, JSON, Text, XML and XLSX files. Used shell scripting to automate repetitive tasks.
- Liaised with third-party engineers and technical support depts.
- Heavy usage of String interpolation, modular structuring of code and parameterized approach.
- Followed a test-driven approach closely. Used Python’s Unit Testing extensively, effectively using data blending feature in tableau.
- Hand on experience in administration tasks such as publishing workbooks, setting permissions, managing ownerships, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server. Responsible for the overall solution design from the data collection to visualization.
- Managed data into several analytical data models and designed star schema for dashboards.
- Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
- Moved files between the file groups and partitioned the tables to improve the performance of Dashboard.
- Executing and testing required queries and reports before publishing.
- Creating Multiple Dashboards using SQL as source and reducing the Performance Issues in the Tableau dashboards with Live connections with the Data Source.
ENVIRONMENT: Tableau Desktop 10.0v, Tableau Admin Roles, SQL Server 2014, SSAS, Microsoft Excel.
Confidential
Python Developer
Responsibilities:
- Used the Django Framework in PyCharm and develop the application.
- Implemented web applications with in-built bootstrapping tools in Django framework with MVC architecture.
- Used Python to place data into JSON files for testing Django Websites.
- Updated and manipulated content and files by using python scripts.
- Used Django configuration to manage URLs and application parameters.
- Worked on Python Open stack API's.
- Used Python scripts to update content in the database and manipulate files.
- Generated Python Django Forms to record data of online users.
- Used Python and Django creating graphics, XML processing, data exchange and business logic implementation.
- Used Django configuration to manage URLs and application parameters.
- Built various graphs for business decision making using Python matplotlib library.
- Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQLdb package.
- Used Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.
ENVIRONMENT: Python, Amazon AWS S3, MySQL, HTML, Python 2.7, Django 1.4, HTML5, CSS, XML, MySQL, MS SQL Server, JavaScript.