Home

Bhavana - Python Developer

vinny@uniteditinc.com

Location: Texas City, Texas, USA

Relocation: Yes

Visa: H1-B

Bhavana Senior Python Developer vinny@uniteditinc.com 469-575-4104 SUMMARY: Having 9+ years of experience as a Python Developer / Data Engineer in backend development with Python, and Django. Dedicated professional driven to enhance team efficiency. Performing low to high-complexity source code development. Experienced in using AWS technologies like S3, translate, lambda with Python and Java. Experienced building many navigation systems in React Native including Tabs. Drawer Stack Experience in Python Development, Data Analysis, and Web Development. Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, Kinesis, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, Cloud Front, CloudWatch, SNS, SES, SQS, and other services of the AWS family. Good Experience with Django, a high-level Python Web framework. Experience object-oriented programming (OOP) Concepts using Python, Django, and Linux. Proficient in crafting and upkeeping the user-facing aspect of web applications through the utilization of React, HTML, CSS, React Native and JavaScript/TypeScript. Extensive Shell/Python scripting experience and setup production systems on UNIX/LINUX Environment. Experience in various cloud vendors like AWS, GCP, and Azure. Expertise in Python scripting with a focus on DevOps tools, CI/CD, and AWS Cloud Architecture. Experience with continuous integration and automation using Jenkins. Worked on the development of SQL and stored procedures on MYSQL. Setting Up AWS and Microsoft Azure with Databricks, Databricks Workspace for Business Analytics, and Manage Clusters in Databricks. TECHNICAL SKILLS: Operating Systems: Windows 98/2000/XP/7,8, Mac OS and Linux CentOS, Debian, Ubuntu ProgrammingLanguages: Python, R, Java Web Technologies: HTML/HTML5, CSS/CSS3, XML, jQuery, JSON, Bootstrap, React, React Native JavaScript/TypeScript PythonLibraries/Packages: NumPy, SciPy, Pickle, PySide, PyTables, Data Frames, Pandas, Matplotlib, Seaborn ,SQL Alchemy, HTTPLib2, Urllib2, Beautiful Soup, Boto3 ,Requests, cx_oracle IDE: PyCharm, Visual Code, Notepad++, Jupyter Notebook Machine Learning and Analytical Tools: Supervised Learning (Linear Regression, Logistic Regression, Decision Tree, Random Forest, SVM, Classification), Unsupervised Learning (Clustering, KNN, Factor Analysis, PCA Cloud Computing: AWS, Azure, GCP, Snowflake Databases: MySQL, SQLite3, PostgreSQL, MongoDB, Teradata Web Services/ Protocols: TCP/IP, UDP, FTP, HTTP/HTTPS, SOAP, Rest, Restful Miscellaneous: Git, GitHub, SVN, Bitbucket , Kafka , Flink Build and CI tools: Docker, Kubernetes, Maven, Jenkins, JFrog, Nexus EDUCATION: Master of Science in Computer Science, UTA, TX B. Tech in CSE, GITAM University PROFESSIONAL EXPERIENCE: Intuit, Plano, TX, USA April 2024 Till Date Senior Python Developer Project: GenOS Responsibilities: Developed and implemented python Script to automate validation of new bots. Designed a validation framework that executes predefined SQL queries, capture results. Implemented automated checks for critical event types to ensure accurate tracking of user interactions and bot responses. Developed a reporting mechanism that generates detailed validation reports and provided actionable insights and identified issues quickly. Led the development for a Bot Response offline automated evaluation system assessing the relevancy , specificity and helpfulness of chatbot responses. Integrated GenAI Express V2 API into ETL process automating the grading of chatbot conversations and storing results for analysis and further data engineering practices. Analyzed bot data to identify and address areas of improvement, supporting bot designers in optimizing chatbot performance and enhancing user experience. Wrote and Implemented unit tests for Python applications using unit test framework to ensure functionality of critical modules , improving overall project code coverage from 75.93 to over 90 by identifying and testing unhandled edge cases. Used unittest.mock to isolate dependencies and effectively mock objects. Implemented dynamic URL construction in Python for API requests handling query parameters and path variables for data retrieval. Enhanced API request handling to ensure compatibility with end points including custom logging and error handling for monitoring. Co-ordinated with front end teams to adjust React.js based UI components to communicate with python back end services. Migrated critical service end points resulting in improvement in data retrieval times. Modified and Optimized API endpoints during migration process and performed impact assessments post-migration to evaluate effect of accessing new urls . Updated technical documentation to reflect changes in code base and effectively communicate modifications to relevant stakeholders. Developed methods to generate detailed, human readable summaries of changes between chatbot versions for easy analysis and ensured high code quality and consistency. Containerized microservices applications using Docker and deployed CI/CD pipelines for containerized applications, leveraging Jenkins for serverless container execution. Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation. Developed Python scripts to automate the ETL process using Apache Airflow and CRON scripts in the Unix operating system as well. Performing Data mapping between source systems to local systems, logical data modeling, creating class diagrams and ER diagrams, and using SQL queries to filter data. Developing Oracle Database development experience using tables, triggers, views, packages, and stored procedures in PL/SQL Strong RDBMS fundamentals. Environment: SQL, Python, Jenkins , Athena, AWS Glue , S3 , FastAPI, HTML ,CSS ,JavaScript,React.js, Restful API , HTTP Services, SQL Alchemy, AWS, Git , ESLint, Docker, Java, Flink, Databricks, Tableau,Qlik, Git Bash, Bitbucket, React, React native, NumPy , Pandas, Docker, Github , Kafka. FannieMae, Plano, TX, USA Sep 2021 Mar 2024 Senior Python Developer Project: Family Analytics Responsibilities: Developed tools using Python, Shell scripting, XML to automate some of the tasks with supervisors, artists, systems administrators and production to ensure production deadlines. Did automation testing by leveraging the pytest framework and wrote unit test cases. Designed and developed data management system using MySQL. 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 the Python matplot library. Worked on PySpark-SQL to load JSON data and create schema RDD, Data Frames and loaded it into Hive Tables and handled structured data using Spark-SQL. Designed and implemented ETL workflows using Python, ensuring seamless data flow from source to destination systems. SQL worked on designing and deploying a multitude application utilizing almost all the main services of the AWS stack (like EC2, S3, RDS, VPC, IAM, ELB, EMR Cloud watch, Route 53, Lambda and Cloud Formation) focused on high availability, fault tolerance environment. Analyzed SQL scripts and designed the solutions to implement using PySpark. Used Spark SQL to load JSON data and create Schema RDD loaded it into Hive Tables and handled structured data using Spark SQL. Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation. Developed Python scripts to automate the ETL process using Apache Airflow and CRON scripts in the Unix operating system as well. Performing Data mapping between source systems to local systems, logical data modeling, creating class diagrams and ER diagrams, and using SQL queries to filter data. Developing Oracle Database development experience using tables, triggers, views, packages, and stored procedures in PL/SQL Strong RDBMS fundamentals. Environment: SQL, Python , HTML ,CSS ,JavaScript, PySpark, Autosys, Azure, Databricks, Snowflake, Alteryx, Power BI, SQL server plus, ETL, Tableau, Git Bash, Bitbucket, React, React native NumPy , Pandas, MongoDB DTCC, Tampa, FL, USA Jul 2019 Aug 2021 Sr. Python Developer Project: Transformation, Metrics Responsibilities: Created methods (get, post, put, delete) to make requests to the API server and tested Restful API using Postman. Also used Loaded CloudWatch Logs to S3 and then loaded them into Kinesis Streams for Data Processing. Generated Python Django Forms, Crispy forms to record data, login and signup of online users. Designed email marketing campaigns and created responsive web forms that saved data into a database using Python/ Django Framework. Developed Liquibase scripts to create schema, tables, views in Snowflake. Performed Snowflake sql operations on around 1 Million rows of data using Snowflake CLI to check before deploying Liquibase scripts. Loaded the data from Snowflake to POWER BI for visualization. Used SQL, PL/SQL , Snowflake SQL and Stored Procedures for Oracle, Snowflake back- end database. Worked in RDBMS implementation using, SQL, PL/SQL, DB2, MySQL on Oracle database. Built various graphs for business decision-making using python matplotlib library. Developed data analytic tools using python Pandas, and visualizations using Matplotlib and Bokeh. Worked on development of SQL and stored procedures for normalization and renormalization in MYSQL. Design and Develop ETL Processes in AWS Glue to migrate data from external sources like S3, Parquet/Text Files into AWS Redshift. Designed and developed new reports and maintained existing reports using Microsoft SQL Reporting Services (SSRS) and Microsoft Excel to support the firm's strategy and management. Environment: Python 3, Django 1.6, Numpy, Pandas, Seaborn, Tableau 8.2, Beautiful soup, HTML5, CSS/CSS3, Bootstrap, XML, JSON, Apache spark, Linux, Git, Amazon s3, Jenkins, MySQL, Mongo DB, T-SQL, React,ReactNative, Snowflake, Apache Airflow, AWS Glue. OIT, Arlington, TX, US Aug 2017 May 2019 Assistant Python Developer Project: Information Technology Responsibilities: Requirements Gathering and treated python Modules for internal purpose basing on the requirement and created the entire framework from scratch. Developed scripts using pandas to easily perform read/write operations to CSV files, manipulate and compare data by columns. Developed GUI using python and Django for dynamically displaying the test block documentation and other features of python code using a web browser. Responsible in writing RDBMS databases like SQL queries to query database and queries Censhare for data and returns it as a structure on success responses and throws exception on any errors. Creation and deployment of AWS EC2 environments for proof of concept of design assumptions. Developed an embedded software data driven test automation framework in Linux/Python. Designed test cases and authored test plans. Built the web application by using Python, Django, AWS, J2EE, Postgre SQL, MySQL, Oracle 10g and MongoDB. Experience in GCP Datapost, GCS, Cloud functions, and Big Query. Experience in moving data between GCP and Azure using Azure Data Factory. Involved in writing SQL queries implementing functions, triggers, cursors, object types, sequences, indexes, etc. and developed and tested many features. Environment: Python, SQL, Data Analysis, SQL Server Reporting Services, Azure, Microsoft Team Foundation Server, Airflow, GCP, Bash, Shell, React HAL, Bangalore, India Jun 2015 Jul 2017 Jr Python Developer Project: Aeronautics limited Responsibilities: Develop sensor logic, which are initiated manually with Python scripts and Unix shell scripting. Involved in Design, Development and Support phases of Software Development Life Cycle (SDLC). Requirement Analysis and Estimation of project timelines. Developed Python batch processors to consume and produce various feeds. Did Map-Reduce using Pyspark to process huge Blob data sets according to BRD (Business Requirement Doc). Wrote Python scripts for data cleaning and data munging over massive datasets. Expertise in building custom alerts and validations using Python Scripting. Used Python scripts to update the content in the database and manipulate files. Wrote SQL Queries, Store Procedures, Triggers, and functions in MySQL Databases. Did automation testing by leveraging the pytest framework and wrote unit test cases. Environment: Python 3.x, Django, HTML5, CSS3, Pandas, NumPy, Apache Spark, Sql Server Keywords: continuous integration continuous deployment user interface javascript business intelligence sthree database rlang information technology procedural language Colorado Florida Texas