Rajesh Mameda

.

• Worked independently to design, develop and test code.
• Automated repetitive tasks using Python scripts, increasing efficiency within team's workflow processes.
• Improved application performance by optimizing Python code and implementing best practices.
• Created RESTful APIs using Django REST framework, enabling seamless communication between front-end and back-end components.
• Generated workflow reports to test proposed change executions.
• Designed responsive user interfaces with HTML, CSS, and JavaScript for optimal viewing on various devices
• Ensured application reliability and scalability by implementing load-balancing and caching techniques in Python codebase.
• Enhanced database performance by optimizing SQL queries and indexing strategies.
• Designed and developed customized extract, transform, and load (ETL) applications per client specifications.
• Leveraged AWS Lambda functions for serverless computing, reducing operational costs while increasing scalability.
• Automated infrastructure provisioning using CloudFormation templates, enhancing scalability and maintainability of system.
• Integrated APIs with existing services to streamline data exchange between multiple applications within organization.
• Utilized industry-standard tools such as Git for version control, enhancing collaboration among team members.
• Developed and maintained unit tests using pytest, ensuring code quality and reliability.
• Implemented CI/CD pipelines using Jenkins/GitHub Actions, automating build, test, and deployment processes.
• Conducted code reviews to ensure adherence to best practices and mentored junior developers, fostering collaborative and high-performing team environment.
• Designed and implemented microservices architecture, enhancing modularity and scalability of application.
• Implemented security best practices, including input validation and secure authentication, to protect applications from common vulnerabilities.
• Participated in Agile/Scrum development processes, contributing to sprint planning, daily stand-ups, and retrospectives.
• Processed large datasets using Hadoop and Spark, enabling data-driven decision-making.
• Utilized Docker for containerization and Kubernetes for orchestration, improving deployment consistency and scalability.
• Developed machine learning models using libraries such as TensorFlow and scikit-learn to enhance application functionality.

• Extracted and mapped data from various databases to support pharmaceutical research and development activities.
• Developed proof of concepts for image and PDF data extraction to ensure high accuracy in data processing from customer files.
• Created and validated algorithms to check data accuracy and integrity, ensuring compliance with industry standards.
• Utilized TensorFlow for image extraction, enhancing data analysis capabilities for research projects.
• Designed and implemented deep learning architectures, including CNNs and RNNs, for processing pharmaceutical data, deployed on GCP’s AI Platform.
• Engaged in full-stack development using React for frontend and Python for backend, ensuring seamless user experience for internal applications.
• Implemented secure user authentication and authorization mechanisms in both React and Python components.
• Debugged and resolved issues related to frontend-backend interactions, maintaining a smooth and error-free user experience.
• Developed robust APIs to facilitate seamless interaction with knowledge graph data, using Apigee for secure API management.
• Designed and managed end-to-end CI/CD pipelines for continuous integration and delivery, streamlining deployment processes.
• Utilized Git for version control, ensuring efficient collaboration and tracking changes on Django projects.
• Participated in Agile development workflows, contributing to sprint planning, daily stand-ups, and retrospectives.
• Deployed applications using GCP’s App Engine and managed container orchestration with GCP’s Kubernetes Engine.
• Written test cases using UnitTest and PyTest to ensure code quality and reliability.
• Led the development of ETL processes in AWS Glue to migrate large datasets from various sources into AWS Redshift, optimizing data storage and retrieval.
• Optimized data solutions using Snowflake, supporting large-scale pharmaceutical data operations.
• Applied CSS styling to create visually appealing and consistent user interfaces across multiple browsers and devices.

• Utilized Pandas in Python to load, clean, and manipulate data for further processing, ensuring data quality and readiness for analysis.
• Built database models, APIs, and Views using Python to develop interactive web-based solutions, enhancing operational efficiency.
• Configured and administered MySQL, MongoDB, and Cassandra databases to support data-driven applications.
• Collected data from various sources, including sensors, IoT devices, and networked systems, to enhance data analytics capabilities.
• Resolved compatibility issues by optimizing data architecture, including data ingestion and pipeline design.
• Applied machine learning techniques to analyze customer trends, including developing clustering models for customer segmentation using Python.
• Developed a linear regression model using Spark and Scala API to predict continuous measurements for wind turbine data analysis.
• Utilized Django to manage URLs and application parameters, ensuring smooth functionality of web applications.
• Parsed raw data and produced concise conclusions in a clean, well-structured, and maintainable format.
• Implemented Spring Boot microservices to process messages within a Kafka cluster setup, improving real-time data processing.
• Designed and implemented complex graph data models using Cypher and Neo4j to represent relationships within interconnected datasets.
• Utilized Advanced JavaScript, including prototype-based inheritance, AJAX, and JSON, and worked with frameworks like JQuery and JQuery-UI to enhance front-end functionality.
• Developed web applications using Python and Flask, supported by MS SQL/PostgreSQL databases with SQL Alchemy for ORM.
• Designed and managed API system deployment using a fast HTTP server and AWS architecture, ensuring secure and efficient API management.
• Designed and developed ETL processes in AWS Glue to migrate campaign data from sources like S3, ORC/Parquet/Text Files into AWS Redshift.
• Guided the migration of PostgreSQL and MySQL databases to AWS Aurora, enhancing database performance.
• Analyzed and optimized SQL scripts using PySpark SQL for faster performance.
• Leveraged AWS services, including EC2, S3, RDS, Redshift, Glue, Athena, IAM, and QuickSight, to support various data and application needs.
• Created Docker containers and managed the application lifecycle using Docker consoles.
• Utilized Snowflake for database management, including schema and table configuration, to support large-scale data operations.
• Worked with large datasets and implemented deep learning algorithms using Apache Spark and TensorFlow to enhance data processing and analysis.

• Developed and optimized data processing pipelines using PySpark, leveraging distributed computing for efficient big data analysis.
• Implemented AWS services such as EC2, S3, Glue, and Athena to architect scalable and cost-effective data solutions.
• Designed and maintained SQL databases, writing complex queries and optimizing database performance for large-scale data operations.
• Utilized Git for version control, ensuring seamless collaboration and tracking changes across projects.
• Built responsive and interactive user interfaces using frontend libraries like React.js and Vue.js, enhancing user experience and engagement.
• Implemented ETL processes using AWS Glue to extract, transform, and load data from various sources into Redshift and S3.
• Developed RESTful APIs using Flask or Django, enabling seamless communication between frontend and backend systems.
• Leveraged SQLAlchemy for object-relational mapping (ORM), simplifying database interaction and management.
• Conducted unit testing and integration testing using PyTest and unittest, ensuring code reliability and functionality.
• Integrated authentication and authorization mechanisms using AWS IAM and OAuth for secure access control.
• Collaborated with cross-functional teams in Agile development environments, participating in sprint planning, stand-ups, and retrospectives.
• Optimized frontend performance by implementing best practices and leveraging browser caching and compression techniques.
• Implemented CI/CD pipelines using Jenkins or AWS CodePipeline, automating build, test, and deployment processes.
• Developed data visualization dashboards using libraries like Matplotlib, Plotly, or D3.js, enabling insights into complex datasets.
• Conducted code reviews and provided constructive feedback to team members, ensuring code quality and adherence to coding standards.

• Automated manual workflows using Python scripts and UNIX shell scripting, streamlining processes and improving efficiency.
• Created and managed Anaconda environments for Python programming, ensuring a standardized and efficient development environment.
• Implemented unit and functional testing with Python testing modules such as unit test, unittest2, and custom frameworks, following Agile Software Development methodologies.
• Installed and configured Hadoop, MapReduce, HDFS, and AWS, developing MapReduce jobs in PIG and Hive for data cleaning and preprocessing in the energy sector.
• Managed datasets using Pandas data frames and MySQL, querying MySQL databases from Python using Python-MySQL connector and MySQL dB package for efficient data retrieval.
• Developed web and application solutions using Python 3.5, HTML5, CSS3, AJAX, JSON, and Angular 4 to address industry-specific challenges in the energy sector.
• Utilized Python Django forms for recording online user data and PyTest for writing test cases, ensuring robust and reliable applications.
• Implemented and customized SQL queries, Functions, Cursors, and Triggers to meet client requirements and optimize database performance.
• Cleaned and processed third-party spending data using Excel macros and Python libraries such as NumPy, SQL Alchemy, and Matplotlib to generate actionable insights.
• Utilized Pandas as an API for manipulating and retrieving data in time series and tabular formats, facilitating analysis and decision-making processes.
• Troubleshooted and fixed Python bugs in critical applications, ensuring continuous data availability for both customers and internal teams in the energy industry.
• Managed code versioning with Git, Bitbucket, and deployment to staging and production servers, implementing MVC architecture in web application development using the Django framework.
• Created various data visualization graphs using Python's Matplotlib library to support business decision-making processes in the energy sector.
• Scraped websites using Python Beautiful Soup, extracting relevant data and parsing it into usable formats such as XML for further analysis.
• Enhanced consumer-based features using Django, HTML, and Test-Driven Development (TDD) principles, ensuring user satisfaction and engagement.
• Developed Python web services for processing JSON data and interfacing with the Data layer, enabling seamless integration and data exchange in energy applications.

• Collaborated in the design and implementation of robust software solutions using Python, ensuring code efficiency and maintainability
• Developed and maintained Python-based applications, focusing on backend logic and database interactions
• Utilized Python frameworks such as Django and Flask for web application development, ensuring adherence to best practices
• Participated in code reviews to ensure code quality, adherence to coding standards, and knowledge sharing among team members
• Worked closely with cross-functional teams to gather requirements, design software solutions, and deliver effective Python-based applications
• Created and maintained database structures, wrote SQL queries, and ensured seamless integration with Python applications
• Implemented RESTful APIs using Python to facilitate communication between various components of the software architecture
• Collaborated with frontend developers to integrate Python backend logic with responsive and user-friendly web interfaces
• Worked with various SSIS control flow tasks and data transformation tasks like data conversion, derived column, look-up, and fuzzy look-up, conditional split
• Developed various Python scripts to find vulnerabilities with SQL Queries by doing SQL injection, permission checks, Auto scaling, and performance analysis and developed scripts to migrate data from proprietary databases to PostgreSQL
• Automated repetitive tasks and optimized processes using Python scripts, improving overall system efficiency
• Conducted unit testing and debugging of Python code to ensure the reliability and stability of software applications
• Actively participated in Agile development methodologies, including sprint planning, daily stand-ups, and retrospective meetings
• Engaged in continuous learning and exploration of new Python libraries and tools to enhance development capabilities
• Assisted in the deployment and maintenance of Python applications on servers, ensuring smooth operation in production environments.

• Involved in developing the UI pages using HTML, DHTML, CSS, JavaScript, JSON, jQuery, Ajax
• Involved in various phases of Software Development Life Cycle (SDLC) such as requirements gathering, modeling, analysis, design and development
• Performed Design, involved in code reviews and wrote unit tests in Python
• Designed the database schema for the content management system Performed Design and Code reviews
• Wrote Python scripts to parse XML documents and load the data in the database
• Generated Use case diagrams, Activity flow diagrams, Class diagrams and Object diagrams in the design phase
• Responsible for entire data migration from Sybase ASE server to Oracle
• Migration of API code written for Sybase to Oracle
• Overlook the migration activity of PL/SQL programs
• Migration of the PL/SQL code from Sybase to Oracle
• Migration of the data contained in the earlier ASPL Database from Sybase to Oracle
• Migrate the Libraries written using Sybase API's to Oracle's OCCI API's
• Automation of testing using Python.