SUMMARY

• Around NINE years of vibrant experience in developing as a Web/Application Developer, server - side programming and coding with analytical programming using Python, Django, React, Vue.
• Developing MVC web-based applications using Python web frameworks like Django, Pyramid, Flask and Web2Py, Singleton. Expertise on Databases such as MYSQL, Oracle, PL/SQL, PostgreSQL and NOSQL databases like MongoDB, Cassandra.
• Expertise in establishing database connections for Python by configuring packages like MySQL - Python and running various queries. Experience in python libraries like Pandas, Matplotlib, Numpy, to manipulate and visualize the data using interactive charts.
• Experiencing developing forms using HTML and performing client-side validations using JavaScript, JQuery and Bootstrap. Successfully migrated the Django database from SQLite to MySQL to PostgreSQL with complete data integrity.
• Proven expertise in employing techniques for Supervised and Unsupervised (Clustering, Classification, PCA, Decision trees, KNN, SVM) learning, Predictive Analytics, Optimization Methods, and Natural Language Processing (NLP), Time Series Analysis.
• Experienced in WAMP (Windows, Apache, MYSQL, Python /PHP) and LAMP (Linux, Apache, MySQL, Python /PHP) Architecture.
• Experience in using Statistical procedures and Machine Learning algorithms such as ANOVA, Clustering and Regression and Time Series Analysis to analyze data for further Model Building.
• Extensive working experience with Python including Scikit-learn, SciPy, Pandas, and NumPy developing machine learning models, manipulating, and handling data.
• Experienced with databases using ORMs/DOMs for integrating with MySQL, Postgres, Neo4J, MongoDB, and Cassandra SQLite. Also, experienced with writing custom queries through database connectors.
• Experienced in Python's modules like numpy, regular expressions, collections, dates & times and OS modules. Knowledge of Cloud Computing (Open stack(Helion), SDN (OpenFlow/Open daylight), NFV, Cloud Foundry, Docker, Ansible, Chef, Jenkins.
• Experience using ES2015 (ES6) and TypeScript 2.x and Experience maintaining and extending a style guide for scalability and cross-application usage.
• Worked on the full conversion of a Razor-based MVC server-based application into a SPA using asynchronous programming with the framework AngularJS and TypeScript 2.0.
• Experience in scaling the CI web application horizontally with a software load balancer (HAProxy) and scalable http& web servers (gunicorn &Nginx). Design, involved in code reviews and wrote unit tests in Python and Updated site with JavaScript, JQuery, Python, Django, and SQL.
• Developed a fully automated continuous integration system using Git, Jenkins, MySQL and custom tools developed in Python and Bash. Developed Restful API's integrating web exe with Django and Python implementations with data exchange through JSON and XML formats.
• Experience of software development with Python and various libraries of Python, python-twitter, Pandas, Dataframe, MySQLdb for database connectivity), Regular expression, File IO, etc.
• Experienced in Design, Development, and support of Data warehousing solutions for Extraction, Transformation and Loading (ETL) mechanisms. Experienced in installing, configuring, modifying, testing and deploying applications with Apache, Tomcat, and WebSphere.
• Designed Puppet Modules to manage configurations and automate the installation process and developed automation scripting in Python using Puppet to deploy and manage Java applications across Linux servers.
• Oracle PL/SQL Development with Informatica 9.6 and Control M 7.x using best optimization techniques. Understand and work on Component Integration Testing, Interface Testing, System Integration testing and End to End Integration Testing.
• Created Python scripts to automate AWS services which include web servers, ELB, Cloud Front distribution, databases, security groups,and application configuration.
• Experience in handling database issues and connections with SQL and NoSQL databases like MongoDB (2.6, 2.4) by installing and configuring various packages in python (Teradata, MySQL dB, MySQL connector, Pymongo,and SQL Alchemy).
• Maintenance and continues development of the applications in PL/SQL procedures, ETL modules and shell scripting using best practices. Containerized and Deployed the ETL and REST services on AWSECS through the CI/CD Jenkinspipe.
• Involved in the error checking and testing of the ETL procedures and programs of Informatica session log. Perform tasks related to performance tuning of ETL jobs. Experience in working with deployment tools like Microsoft Azure, Heroku and Jenkins.
• Designed/wrote the tech specs (Source-Target mappings) for the ETL mappings along with the Unit Test scripts. Resolve issues related to Control M, UNIX shell scripting, Oracle PL/SQL, and Informatica on Production environment.
• Developed DAO functions in python using cx Oracle package. Proficient in designing Model, View, Database Architecture for a given requirement or problem statement irrespective of the underlying technology.
• Excellent analytical and problem-solving skills with efficient time management and result oriented attitude.

TECHNICAL SKILLS

Python Libraries: Beautiful Soup, NumPy, SciPy, PySpark, Matplotlib, python-twitter, Pandas data frame, urllib2.

Database: Oracle11g, MySQL 5.x, and SQLServer, ORM NoSQL, Django ORM, Redis.

IDE Tools: Eclipse, Web Logic, Rational Rose, LDAP, Methodology, Clear Case/Clear Quest.

Web Services: SOAP, REST, WSDL, Django, Flask, Pyramid, Scrappy, Tornado.

Methodologies: OOPS/OOAD, UML, J2EE Design Patterns.

Version Control: SVN, Clear case, CVS.

Tools: RAD, Eclipse, Edit Plus, Apache Ant, log4j, JUnit, Visio, ANT, Maven.

Web/App. Servers: WebSphere Application Server 8.0, Apache Tomcat, Web Logic 11g/ 12c, JBoss 4.x/5.x.

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

Python Developer

Responsibilities:

• Automate different workflows, which are initiated manually with Python scripts and UNIX shell scripting. Create, activate, and program in Anaconda environment. Develop Test Plan and Strategy for Integration Testing.
• Use Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies. Used standard Python Modules e.g., CVS, RobotParser, itertools, pickle, jinja2, lxml for development.
• Involved in code reviews using GitHub pull requests, reducing bugs, improving code quality, and increasing knowledge sharing. Importing and exporting the table data from one schema to anther schema using Oracle Data Pump, Import/Export.
• Develop Sqoop scripts to handle change data capture for processing incremental records between newly arrived and existing data in RDBMS tables. Installed Hadoop, Map Reduce, HDFS, AWS and developed multiple MapReduce jobs in PIG and Hive for data cleaning and pre-processing.
• Manage 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 and used PyTest for writing test cases.
• 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 the Jira database (Matching Fields) with Python scripts for transferring and verifying the information.
• Perform troubleshooting, fixed, and deployed many Python bug fixes of the two main applications that were the main source of data for both customers and internal customer service team. Generating various capacity planning reports (graphical) using Python packages like NumPy, matplotlib.
• Build all database mapping classes using Django models and Cassandra. Analyzing various logs that are been generating and predicting/forecasting the next occurrence of an event with various Python libraries.
• Design and maintain databases using Python and developed Python-based API (RESTful Web Service) using Flask, SQL Alchemy, and PostgreSQL. Develop the workflow and dataflow of SSIS ETL processes to support many different file structures and business processes.
• Manage code versioning with GitHub, Bitbucket and deployment to staging and production servers and implement MVC architecture in developing the web application with the help of the Django framework.
• Use Celery as task queue and RabbitMQ, Redis as a messaging broker to execute asynchronous tasks. Design and manage API system deployment using fast Http server and AmazonAWS architecture.
• Develop remote integration with third party platforms by using RESTful web services and Successful implementation of Apache Spark and Spark Streaming applications for large scale data. Involved in the development of WebServices using SOAP for sending and getting data from the external interface in the XML format.
• Used Oracle Advanced Queuing - DBMS AQ for message exchange between Phoenix and external systems. Implemented Spring boot microservices to process the messages into the Kafka cluster setup. Scraping website using Python Beautiful Soup, and then parsed it with XML.
• Used NLTK and Stanford NLP to process text data and created offline intelligence. Developed a module to build DjangoORM queries that can pre-load data to greatly reduce the number of database queries needed to retrieve the same amount of data.
• Headed and implemented Parts Followup workflow using PySpark that tracks all the necessary information regarding the movements, usages, availability and forecasts of Parts in Plants and their various Lines and renders the desired tracking information in a QlikView dashboard.
• Solving the server crashing problem while running huge data with the Alteryx workflow most of the times. Debugged through SPARK UI and arrived at near optimum Spark configurations using Yarn such as partitioning, shuffle partitions, no of executers and driver nodes and memory for the project.
• Delivered a robust running workflow using PySpark that runs under 15 mins that processes and tracks all the car parts in different plants and lines of Confidential and displays them on dashboard.
• Headed and implemented Release Pull Ahead workflow using PySpark to optimize utilization of Supply Chain Containers and Distribution Centers for Inbound and Outbound logistics.
• Designed and developed a Restful Swagger API using React for Customers, Administrators and Business Users using for AUTOMAP which compares cars prices and features based on family and model of cars.
• Designed and developed Web APIs with Flask to integrate with different components written in React to combine ML algorithms written in Python, to compare and predict price lines and part consumptions.

Environment: Python 3.6, Django 1.10,1.11, MySQL, Shell Scripting, Teradata, REST, HTML5, CSS3, Bootstrap, Java, JavaScript, jQuery, JSON, AJAX, Matplotlib, PyTest, Sublime, JIRA, SVN.

Confidential, Chicago

Python Developer

Responsibilities:

• Created Python and Bash tools to increase the efficiency of the retail management application system and operations; data conversion scripts, AMQP/RabbitMQ, REST, JSON, and CRUD scripts for API Integration.
• Extensively worked with Teradata utilities like TPT, Fast Load, Fast Export and BTEQ to export and load data from and to different systems with source systems. Developed Python-based API (RESTful Web Service) to track the events and perform analysis using Django.
• Developed entire frontend and backend modules using Python on Django Web Framework. Worked on several python libraries like Python, NumPy, and Matplotlib and used XML Web Services using SOAP to transfer information to the Credit Monitoring Systems.
• Involved in Using Python, Flask, and AngularJS for the design, development, and deployment of the application.
• Designed a network of web pages, where the user progresses through an application by selecting links, resulting in the next page being transferred to the user and rendered for their use using REST. Used Python-based GUI components for the front-end functionality such as selection criteria.
• Administration of dedicated collocated RHEL 4 machine and configured complex Apache configuration files.
• Implemented and enhanced CRUD operations for the applications using the MVT (Model View Template) architecture of the Django framework and Python conducting code reviews.
• Set up and maintain CI infrastructure to streamline build process, unit tests, functional tests, and integration tests and artifacts deployments. Developed build and deployment scripts using Ant and Maven as build tools in Jenkins to move from one environment to other environments.
• Analyzed the SQL scripts and designed it by using Spark SQL for faster performance. Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on SQL and PostgreSQL database.
• Extensive code reviewing using GitHub pull requests, improved code quality, and conducted meetings among peers. Develop mapping specifications, Source to target mappings and ETL development. Perform.
• Build backend security services for Cisco platforms such as web & email security appliances and cloud services, firewall, and next-generation backend intelligence systems. Designed and developed new features for an application using HTML, JSTL, JavaScript, and XSL.
• Developed Java utility classes for common application functionality like database access, error logging, and configuration file. Actively involved in developing the methods for Create, Read, Update and Delete (CRUD) in Active Record.
• Successfully migrated the Django database from SQLite to MySQL with complete data integrity. Responsible for transforming design mock-ups to W3C standards compliant HTML pages using HTML, XHTML, CSS.
• Written Spark-Scala scripts, by creating multiple UDF's, spark context, Cassandra SQL context, multiple API's, methods which support data frames, RDD's, data frame Joins, Cassandra table joins and finally write/save the data frames/RDD's to Cassandra database.
• Worked on Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.
• Created a Python/Django based web application using Python scripting for data processing, MySQL for the database, and HTML/CSS/jQuery and High Charts for data visualization of the served pages.
• Successfully migrated the Django database from SQLite to MySQL to PostgreSQL with complete data integrity.

Environment: Python 3.6, MySQL, Shell Scripting, REST, Teradata Database,HTML5, CSS3, JavaScript, jQuery, JSON, AJAX, Matplotlib, PyTest.

Confidential, Chicago, IL

Python Developer

Responsibilities:

• Designed and Developed UI for creating Dashboard application using AngularJS, D3, C3, HTML, CSS, Bootstrap, JavaScript, and jQuery.
• Developed and implemented Python scripts to automate retrieval, parsing and reporting of configuration parameters from Network Devices connected to customer networks. Involved in user interface design and development using JSP, Servlet, HTML5, CSS3, and JavaScript.
• Wrote and tested Python scripts to create new data files for Linux server configuration using a Python template tool. Designed and developed data management system using MySQL.
• Modified controlling databases using SQL generated via Python and Perl code, collected, and analyzed data with Python programs using SQL queries from the database of data collected from the systems under tests.
• Closely worked with Kafka Admin team to set up Kafka cluster setup on the QA and Production environments.
• Involved in write application-level code to interact with APIs, Web Services using AJAX, JSON and hence building a type-ahead feature for zip code, city, and county lookup using jQuery, Ajax, and jQuery UI.
• Collaborate with Product Management and User Experience experts regarding product definition, schedule, scope, and project-related decisions. Used Python libraries and SQL Queries/subqueries to create several datasets which produced statistics, tables, figures, charts, and graphs.
• Skilled in using collections in Python for manipulating and looping through different user-defined objects. Work with a small team of ETL developers on specific projects, including working directly with senior managers and clients.
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS. Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
• Involved in the Web/Application development using Python, HTML5, CSS3, AJAX, JSON, and jQuery.
• Cleaned data and processed third-party spending data into Manoeuvrable deliverables within a specific format with Excel macros and python libraries such as NumPy, SQL Alchemy, and Matplotlib.
• Prototype proposal for Issue Tracker website using Python/Django connecting MySQL as Database.

Environment: Python, HTML5, CSS3, AJAX,RDBMS, JSON, jQuery, MySQL, NumPy, SQL Alchemy, Matplotlib, Hadoop, KAFKA, Pig Scripts, ETL.

Confidential, Melbourne, FL

Python Developer

Responsibilities:

• Involved in the software development lifecycle (SDLC) of tracking the requirements, gathering, analysis, detailed design, development, system testing and user acceptance testing. Developed entire frontend and backend modules using Python on Django Web Framework.
• Implemented Kafka producer and consumer applications on Kafka cluster setup with help of Zookeeper. Have knowledge on partition of Kafka messages and setting up the replication factors in Kafka Cluster.
• Involved in designing user interactive web pages as the front-end part of the web application using various web technologies like HTML, JavaScript, Angular JS, jQuery, AJAX and implemented CSS for better appearance and feel.
• Experience in real time data from various data sources through Kafka data pipelines and applied various transformations to normalize the data stored in HDFS Data Lake. Actively involved in developing the methods for Create, Read, Update and Delete (CRUD) in Active Record.
• Python variables are used to grab credentials (Teradata) from a specified folder in a location and generate text file as a log. Quality checks are done during the extraction from Teradata using Python.
• Implemented and modified various SQL queries and Functions, Cursors and Triggers as per the client requirements. Managed code versioning with GitHub, BitBucket,and deployment to staging and production servers.
• Implemented MVC architecture in developing the web application with the help of the Django framework. Used Celery as task queue and Rabbit MQ, Redis as a messaging broker to execute asynchronous tasks.
• Designed and managed API system deployment using a fastHTTP server and Amazon AWS architecture. Involved in code reviews using GitHub pull requests, reducing bugs, improving code quality, and increasing knowledge sharing.

Environment: Python 2.7, Django 1.4, HTML5, CSS, XML, MySQL, JavaScript, Backbone JS, jQuery, Mongo DB, MS SQL Server, JavaScript, Git, GitHub, AWS, Linux, Shell Scripting, AJAX, JAVA., KAFKA.

Confidential

IT Consultant

Responsibilities:

• Closely involved in performance evaluation and User Acceptance Test (UAT). Automated the movement, syncing and integration of inventory through creation of Cloud Product Master portal to create services, subscriptions, Stock Keeping Units, and dependencies as a part of Oracle offering Cloud Services.
• Worked on formulation and implementation of Oracle Cloud ERP and Oracle Fusion ERP for inventory and MDM modules using JAVA based OAF, Oracle ADF frameworks.
• Reduced the time required - from days to minutes - for approval of quality issues by devising, designing, and creating multiple workflows and alerts to optimize and automate approval system for various services offered by Oracle Fusion, Cloud Services, Oracle Cloud ERP and Oracle Fusion ERP.
• Improved the accuracy of inventory over 20% by designing and developing JAVA and PL/SQL based Item Validation Tool to maintain correctness and accuracy in inventory module. Simplified complex reporting systems and reduced running time manifolds.
• Example: Intrastate Trading Reporting System that records various types of movements and statistics of inventory across countries in European Union. Worked on HTML5, CSS3, JavaScript, Angular, Node.JS, Git, and REST API.

Environment: HTML5, CSS3, JavaScript, AngularJS, Node.JS, Git, REST API, Python-MySQL.

Confidential

Software Developer

Responsibilities:

• Developed queue-based system for recording and tracking various kinds of tickets for Standard Chartered Bank. Developed multiple models and controllers using core JAVA, Spring and Hibernate frameworks as a part of back-end development for SCB ISIS project.
• Developed rule based expert system using JAVA and XML for insurance approval for TRUVEN Health Analytics. Extensively used UML to develop various use cases, class diagram and sequence diagrams. Worked on writing SQL queries for Oracle.
• Involved in designing and generating web services using SOAP, WSDL, and UDDI. Developed interactive web application using ExtJS. Developed a web-based reporting system with JSP.
• Developed UI using HTML 5, Bootstrap, jQuery and JSP for interactive cross-browser functionality and complex user interface. Responsible to verify that the Software Configuration Management plan is followed in the project for the STG Billing application.

Environment: SQL, SOAP, WSDL, ExtJS, JSP, JMS, HTML 5, Bootstrap, jQuery.