Sai Prudvi
Email: ******.********@*****.***
Phone no: 919-***-****
SUMMARY:
•Around 10+ years of experience as a Python Developer, proficient coder in multiple languages and environments including Python, REST Api, AWS, C, C++ and SQL.
•Wrote python scripts to parse XML documents and load the data in database and developed web - based applications using Python, CSS and HTML.
•Worked on applications and developed them with XML, JSON, XSL (PHP, Django, Python, Rails).
•Experienced in developing Web Services with Python programming language.
•Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
•Cleaned data and processed third party spending data into maneuverable deliverables within specific formats with Excel macros and python libraries.
•Experienced in developing web-based applications using Python, Django, PHP, C++, XML, CSS, HTML, DHTML, JavaScript and Jquery.
•Experienced in working with various Python IDE's using PyCharm, Pyscripter, Spyder, PyStudio and PyDev.
•Good experience of software development in Python and IDEs: PyCharm, sublime text, Jupyter Notebook.
•Experienced in web applications development using Django/Python using HTML/CSS for server-side rendered applications.
•Hands on experience working in WAMP (Windows, Apache, MYSQL, and Python/PHP) and LAMP (Linux, Apache, My SQL, and Python/PHP) Architecture.
•Worked on Anaconda Python Environment.
•Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
•Experience in implementing python alongside using various libraries such as mat plotlib for charts and graphs, MySQL db for database connectivity, python-twitter, PySide, Pickle, Panda’s data frame, network, urllib2.
•Experienced in using python libraries like Beautiful Soup, NumPy, SciPy, matplotlib, Python-twitter, NetworkX, urllib2, MySQL dB for database connectivity and IDEs - Sublime Text, Spyder, PyCharm.
•Experienced in Requirement gathering, Use Case development, Business Process flow, Business Process Modelling.
•Good knowledge of log4j for error logging, developed stored procedures and queries using pl/sql, expertise in RDBMS like oracle, postgres sql, MySQL, rds, snowflakes.
•Extensively used UML to develop various use cases, class diagram and sequence diagrams.
•Well versed with design and development of presentation layer for web applications using technologies like HTML5, CSS3, JavaScript, JQuery, AJAX, AngularJS, Bootstrap, JSON, XML.
•Exceptionally solid background in composing API's along with Web Services over Python.
•Experience in using Adobe Flash, SVN, Eclipse, JIRA, GitHub and CVS.
•Experience working knowledge in UNIX and Linux shell environments using command line utilities.
•Experience with Unit Testing / Test Driven Development (TDD), Load Testing and Integration Testing.
•Experience in Kafka for near real time batch jobs to load data from existing warehouse to cloud warehouse snowflake using s3
•Experienced in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers.
•Experience in working with Python ORM Libraries including Django ORM, SQLAlchemy.
•Experience in building frameworks and automating complex workflows using Python for Test Automation.
•Experience in implementing with server-side technologies with restful API and MVC design patterns with node JS and Django framework.
•Hands on experience in using NOSQL libraries like MongoDB, Cassandra, Redis and relational databases like Oracle, SQLite, PostgreSQL and MYSQL databases.
•Worked on UNIX shell scripts for business process and loading data from different interfaces to HDFS.
•Experience in deploying applications in heterogeneous Application Servers TOMCAT, Web Logic and Oracle Application. Server.
•Good Knowledge in Amazon AWS concepts like EMR and EC2 web services which provides fast and efficient processing of Big Data.
•Proficiency with the application servers like WebSphere, WebLogic, JBOSS and Tomcat.
•Proficient in Object oriented design experience, with extensive experience of Python-C/C++ binding using Boost Python and Python C types.
•Experiences with File Handling and SSH (Secure Shell).
•Working knowledge of errors and exceptions handling debugging using PDB, Eclipse and PyCharm.
•Excellent Debugging, Problem Solving, Optimization and Testing Skills using GitLab
•Experience in Python Development and Scientific Programing, and using Numpy and Pandas in Python for Data Manipulation.
•Experience in using Scikit-Learn and Statsmodels in Python for Machine Learning and Data Mining.
•Use of NLTK, OpenNLP & StanfordNLP for Natural Language Processing and sentiment analysis.
•Experience with SQL Server Management Studio, SQL Developer, Toad and MySQL GUI Tool.
Technical Skills
Operating Systems:
Windows, MAC OS, Unix/Linux
Language s:
Python, C++, Java, J2EE
Python Libraries:
Numpy, Matplotlib, NLTK, Statsmodels, Scikit-learn/sklearn, SOAP, Scipy
Python Frameworks:
Pandas, Flask, Django, Docker
Python IDE:
Sublime Text 3, Eclipse, Jupyter Notebook, VIM, Pycharm
NLP used for Python:
NLTK, OpenNLP, StanfordNLP (NER, POSTag, Tokenization)
Databases:
RDBMS (Oracle, SQL Server, MySQL), No SQL (Mongo DB),
Web Technologies:
CSS, JavaScript, XML, AJAX, JQuery, Bootstrap, AWS, RESTful Web Services
Other Tools:
Putty, SQL developer, Toad, JIRA, Mat lab, R.
PROFESSIONAL EXPERIENCE:
Client: SSM HEALTH, ST. Louis, MO. Aug 2023 - Present
Role: Sr. Python Developer
Responsibilities:
•Automate different workflows, which are initiated manually with Python scripts and Unix shell scripting.
•Create, activate and program in Anaconda environment.
•Use Python unit and functional testing modules such as unit test, unittest2, mock, and custom frameworks in-line with Agile Software Development methodologies.
•Develop Sqoop scripts to handle change data capture for processing incremental records between new arrived and existing data in RDBMS tables.
•Installed Hadoop, Map Reduce, HDFS, AWS and developed multiple Map Reduce 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.
•Involved in the Web/Application development using Python 3.5, HTML5, CSS3, AJAX, JSON and JQuery.
•Develop and tested many features for dashboard using Python, Java, Bootstrap, CSS, JavaScript and JQuery.
•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 Maneuvering 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.
•Experience in Designing and Building the Dimensions and cubes with star schema and Snowflake schema using SQL Server Analysis Services
•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 Node.JS.
•Design and maintain databases using Python and developed Python based API (RESTful Web Service) using Flask, SQL Alchemy and PostgreSQL.
•Manage code versioning with GitHub, Bit Bucket and deployment to staging and production servers and implement MVC architecture in developing the web application with the help of Django framework.
•Use Celery as task queue and RabbitMQ, Redis as messaging broker to execute asynchronous tasks.
•Design and manage API system deployment using fast http server and Amazon AWS 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.
•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
•Created custom Python scripts to analyze logs and metrics from the CI/CD pipeline to identify bottlenecks or areas for improvement.
•Contributed to the development of custom Python modules or packages that were used to extend the functionality of existing CI/CD tools or frameworks.
•Worked with infrastructure as code tools like Terraform or CloudFormation to automate the deployment and management of cloud infrastructure using Python scripts.
•Used NLTK and StanfordNLP to process text data and created offline intelligence.
•Querying data from MongoDB and use them as input for the machine learning models
•Using AWS for application deployment and configuration.
•Wrote UNIX shell scripting for automation.
•Developed views and templates with Django view controller and template Language to create a user-friendly website interface.
•Used JavaScript and JSON to update a portion of a webpage.
•Develop consumer-based features using Django, HTML and Test-Driven Development (TDD).
•Developed Python web services for processing JSON and interfacing with the Data layer.
•Increased the speed of pre-existing search indexes through Django ORM optimizations.
•Developed module to build Django ORM queries that can pre-load data to greatly reduce the number of databases queries needed to retrieve the same amount of data.
Environment: Python 2.7, Django, HTML5/CSS, PostgreSQL, AWS, MS SQL Server 2013, MySQL, JavaScript, Jupyter Notebook, VIM, PyCharm, Snowflake, Shell Scripting, Angular.JS, JIRA.
Client: Johsnon & Johnson Skillman, NJ. Aug 2022 – July 2023
Role: Python Developer
Responsibilities:
•Worked in comprehending and examining the client's business requirements.
•Used Django frameworks and Python to build dynamic webpages.
•Developed tools for monitoring and notification using Python.
•Enhanced the application by using HTML and Java script for design and development.
•Used data structures like directories, tuples, object-oriented class-based inheritance features for making complex algorithms of networks.
•Created PHP/MySQL back-end for data entry from Flash and worked in tandem with the Flash developer to obtain the correct data through query string
•Involved in designing database Model, API's, Views using python to build an interactive web-based solution.
•Generated Python Django Forms to record data of online users.
•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 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.
Environment: Python 3, Django 1.6, Tableau 8.2, Beautiful soup, HTML5, CSS/CSS3, Bootstrap, XML, JSON, JavaScript, JQuery, Angular JS, Backbone JS, Restful Web services, Apache spark, MVC, Linux, Git, Amazon s3, Jenkins, MySQL, Mongo DB, T-SQL, Eclipse.
Client: H&R BLOCK Kansas City, MO. Feb 2019 – July 2022
Role: Python AWS Developer
Responsibilities:
•Developed, tested, and deployed Business feature set in Node.js with Express and MongoDB backend, incorporating APIs.
•Developed application using Amazon Web Service (AWS) like EC2, cloud search, Elastic load balancer ELB, Cloud Deploy and monitor scalable infrastructure on Amazon web services (AWS) & configuration management using puppet.
•Rewrote one of the key pages, which allows users to manage their content. The task involved investigation of the AngularJS UI-Grid as well as refactoring of several backend methods.
•Built AngularJS modules, controllers, pop up modals, and le uploaders.
•Worked on server-side applications with Django using Python programming.
•Interacted with 3rd party APIs and built RESTful APIs using NodeJS
•Developed GUI using Python and Django for dynamically displaying the test block documentation and other features of Python code using a web browser.
•Configured Spark streaming to receive real time data from the Kafka and store the stream data to HDFS using Scale.
•Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.
•Involved in writing SQL queries implementing functions, triggers, cursors, object types, sequences, indexes etc.
•Created Data tables utilizing MySQL utilized Jinja to access data and display it in the front end.
•Worked on Automation of data pulls from SQL Server to Hadoop eco system via SQOOP.
•Contributed in the design and creation of RESTful APIs using Python/Django/Django Rest Framework.
•Imported millions of structured data from relational databases using Sqoop import to process using Spark and stored the data into HDFS in CSV format.
•Strong knowledge of all phases of SDLC and Strong working knowledge of Software testing (Functional Testing, Regression Testing, Load Testing).
•Installing and maintaining the Hadoop - Spark cluster from the scratch in a plain Linux environment and defining the code outputs as PMML.
•Complex loan origination and underwriting strategies can be flexibly defined and can include the implementation and deployment of credit risk scoring and risk rating models through model import (PMML).
•Successfully implemented Apache Spark and Spark Streaming applications for large scale data.
•Writing API documentation for onboarding developers on microservices platform of Autodesk.
Environment: Python, AWS, EC2, EBS, S3, VPC, PyCharm, jQuery, MySQL, HTML, CSS, JavaScript, Ajax, Web Services, JSON, Angular.js, MongoDB, SQL Workbench
Client: Huntington Bank Columbus, OHIO Aug 2017 – Jan 2019
Role: Data Engineer
Responsibilities:
•Develop a data platform from scratch and took part in requirement gathering and analysis phase of the project in documenting the business requirements.
•Worked in designing tables in Hive, MYSQL using SQOOP and processing data like importing and exporting of databases to the HDFS, involved in processing large datasets of different forms including structured, semi-structured and unstructured data.
•Developed rest API's using python with ask and Django framework and done the integration of various data sources including Java, JDBC, RDBMS, Shell Scripting, Spreadsheets, and Text les.
•Worked with Hadoop architecture and the daemons of Hadoop including Name-Node, Data Node, Job Tracker, Task Tracker, and Resource Manager.
•Used AWS data pipeline for Data Extraction, Transformation and Loading from homogeneous or heterogeneous data sources and built various graphs for business decision-making using Python matplotlib library
•Developed scripts to load data to hive from HDFS and involved in ingesting data into Data Warehouse using various data loading techniques.
•Scheduled Jobs using crontab, run deck and control-m.
•Build Cassandra queries for performing various CRUD operations like create, update, read and delete, also used Bootstrap as a mechanism to manage and organize the html page layout
•Developed entire frontend and backend modules using Python on Django Web Framework and created User Interface (UI) using JavaScript, bootstrap, Cassandra with MySQL and HTML5/CSS
•Importing and exporting data jobs, to perform operations like copying data from HDFS and to HDFS using Sqoop and developed Spark code and Spark-SQL/Streaming for faster testing and processing of data.
•Analyzed SQL scripts and designed the solutions to implement using PySpark.
•Used JSON and XML Serdes’s for serialization and de-serialization to load JSON and XML data into Hive tables.
•Used SparkSQL to load JSON data and create Schema RDD and loaded it into Hive Tables and handled structured data using SparkSQL.
•Developing data processing tasks using PySpark such as reading data from external sources, merge data, perform data enrichment and load in to target data destinations.
•Worked in development of applications especially in LINUX environment and familiar with all its commands and worked on Jenkins continuous integration tool for deployment of project and deployed the project into Jenkins using GIT version control system
•Managed the imported data from different data sources, performed transformation using Hive, Pig and Map- Reduce and loaded data in HDFS.
•Added support for Amazon AWS S3 and RDS to host static/media les and the database into amazon cloud.
•Executed Oozie work ow engine to run multiple Hive and Pig jobs, which run independently with time and data availability and developed Oozie work ow to run job onto data availability of transactions.
•To achieve Continuous Delivery goal on high scalable environment, used Docker coupled with load balancing tool Nginx.
•Used MongoDB to stored data in JSON format and developed and tested many features of dashboard using Python, Bootstrap, CSS, and JavaScript.
Environment: Hadoop, Hive, Sqoop, Pig, java, Django, Flask, XML, MySQL, MS SQL Server, Linux, Shell Scripting, Mongo dB, SQL, Python 3.3, Django, HTML5/CSS, Cassandra, JavaScript, PyCharm, GIT, Linux, Shell Scripting, RESTful, Docker, Jenkins, JIRA, jQuery, MySQL, Bootstrap, HTML5, CSS, AWS, EC2, S3
Client: Advanced Auto Parts, Raleigh, NC May 2014 – July 2017
Role: Jr. Python Developer
Responsibilities:
•Design, develop, test, deploy and maintain the website.
•Designed and developed the UI of the website using HTML, AJAX, CSS, and JavaScript
•Designed and developed data management system using MySQL.
•Rewrite existing Python/Django modules to deliver certain format of data.
•Used Django Database APIs to access database objects.
•Wrote python scripts to parse XML documents and load the data in database.
•Handled all the client-side validation using JavaScript.
•Expertise in writing Constraints, Indexes, Views, Stored Procedures, Cursors, Triggers, and User Defined function.
•I have also used Selenium Library to write fully functioning test automation process that allowed the simulation of submitting different we request from multiple browsers to web application.
•Used jQuery for all client-side Java script manipulation.
•Created unit test/regression test framework for working/new code.
•Using Subversion control tool to coordinate team-development.
•Developed entire frontend and backend modules using Python on Django Web Framework.
•Responsible for 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.
Environment: Python 2.5, Django 1.4, HTML5, CSS, XML, MySQL, AJAX, JavaScript, Angular JS, Backbone JS, jQuery, CSS Bootstrap, MS SQL Server, Selenium, Adobe CQ, T-SQL, Eclipse, Git, GitHub, Linux, Shell Scripting.