SUMMARY:

• Overall 8+ years of experience as a Sr. Python Developer, which comprise of Web/Application Developer and coding analytical Programming using Python, Django and Flask.
• Experience in creating different test plans, scenarios, and test cases as the part of unit and integration testing to satisfy all the functional and technical requirements
• Good experience in developing web applications and implementing Model Template View architecture using server - side applications Django, Flask and Pyramid.
• Expertise in entire life cycle of DWH -Analysis, requirements gathering, ETL Design, development, Unit testing and production support.
• Experience in developing web applications implementing Model View Control (MVC) architecture using Django, Flask and Pyramid Python web application frameworks.
• Worked with huge datasets in Python and SAS.
• Migrated SAS models, code to Python. Utilized Python libraries like SASpy, Pandas, etc to do so.
• Experience in using object-relational mapping (ORM) solution, technique of mapping data representation from MVC model to Oracle Relational data model with an SQL-based scheme.
• Experience in DevOps group running Jenkins in a Docker container with EC2 slaves in Amazon AWS cloud configuration. Also gained familiarity with supporting technologies like Kubernetes and Mesos.
• Experience in Web Development Boot Camp using Python, Django, Html, and CSS with some JS, JQuery and Bootstrap.
• Experience in performing ETL activities and data parsing, data validation, data cleaning, data manipulation and data preparation with methods including describe data contents, compute descriptive statistics of data, regex, split and combine, Remap, merge, subset, reindex, melt and reshape.
• Experienced in Data Management, Data Governance, Data Modeling, Warehousing, Data Integration, Metadata, Reference Data and MDM.
• Expert in setting up SSH, SCP, SFTP connectivity between UNIX hosts.
• Expertise in extracting the data from variety of files

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Python Developer

Responsibilities:

• Developed the ETL jobs as per the requirements to update the data into the staging database (Postgres) from various data sources and REST API's. Worked on ETL Tool, used it to transfer and load data into Amazon Redshift. Integrated data from multiple applications using ETL and ELT tools like SSIS.
• Designed DWH utilizing top down up approach utilizing snow flake schema modeling. Identified SCD and role playing dimension during the designing of DWH. Involved in the Complete Software development life cycle (SDLC) to develop the application and Worked closely with software developers and DevOps to debug software and system problems. Played key role in Migrating Teradata objects into SnowFlake environment. Worked closely with Business Analysts to define conceptual and logical models of DWH design by following the Star Schema methodology of building the data warehouse. Responsible for the solution design and development of Informatica Efforts to build ETL process for loading Trade Financial data from T360 system to DWH. Proficient in Postgres, Teradata, Hive, DB2, SQLite, MySQL, and other SQL databases with Python. Skilled in building complex SAS Data sets using various computational techniques Created SDTM and ADAM specifications and wrote independent SAS programs to create and validate SDTM and ADAM datasets for Phase I - III studies. Managed a team of DevOps engineer for infrastructure support on AWS cloud. Creating Cloud Formation scripts for hosting software on AWS cloud. Automating the installation of software through Power Shell scripts. Implemented a CI/CD pipeline using Azure DevOps (VSTS, TFS) in both cloud and on-premises with GIT, MS Build, Docker, Maven along with Jenkins plugins. Write UNIX Shell Scripts and develop Data Import/Export andConversions.
• Designed the architecture of the hardware environments and methodology of the code. Designed and managed API system deployment using Amazon AWS architecture Implemented a server less architecture using API Gateway, Lambda, and Dynamo DB and deployed AWS Lambda code from Amazon S3 buckets. Used Python and Django to interface with the JavaScript UI and manage the storage and deletion of content. Developer Open Stack, customized MDM system architecture. Prototyped web front-end to MDM. Design database using Erwin and Python/Django, C++ for DB scheme scripting Design MDM integration facilities (SOA-style) Develop SOAP client for testing MDM to SAP R/3 interoperation Managed, developed, and designed a dashboard control panel for customers and Administrators using Django, Oracle database. Worked on different databases like Hive, Teradata, Postgres, IBM Db2 etc. Skilled in maintaining and migrating existing SAS Codes to DI Jobs. Designed the SQL Server database and wrote the ASP.NET Core Web API and C# Interfaces to parse Teradata, Oracle, and Ab Initio Data into my new SQL Server Database for data that c

Confidential

Python Developer

Responsibilities:

• Created & migrated SSH keys for application ID to enable SFTP/SCP capability. Handled the scheduling tasks (cron jobs and task scheduler) for the scripts for various purposes. Developed Web Application using AngularJS, HTML5, CSS3, JavaScript, Bootstrap and JSON web token. Working as an application developer have knowledge with controllers, views and models in Django. Created fact tables with multiple granularity levels and maintained fact table relations with alternate keys in existing DWH. Leveraging queueing architectures with AMQP/RabbitMQ for scalability, performance and building distributed systems. Used Python Django framework to design and develop a web application using MVT - Model view template architecture. Gained good working knowledge in DevOps Environment by working on various technologies/applications like Ansible, Chef, GIT, SVN, Jenkins, Docker. Worked in DevOps group running Jenkins in a Docker container with EC2 slaves in Amazon AWS cloud configuration. Hands on knowledge on architecting the ETL transformation layers and writing spark jobs to do the processing. Have working knowledge of Hadoop, Big Data, ETL, Spark and AWS. Communicate with ETL team to schedule the jobs and report the issues if any to the respective team. Used object-relational mapping (ORM) solution, technique of mapping data representation from MVC model to Oracle Relational data model with an SQL-based scheme. Installation, configuring, upgrading, migrating, and patching of DB2,
• Oracle, and SQL Server. Proficient in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers using relational databases like Oracle and MySQL. Used Python programs to automate the process of combining the large SAS datasets and Data files and then converting as Teradata tables for Data Analysis. Designed MDM integration facilities (SOA-style). Developed SOAP client for testing MDM to SAP R/3 interoperation. Loaded the data from Teradata to HDFS using Teradata Hadoop connectors. Involved in Migrating Objects from Teradata to Snowflake. Used SAS to develop various ad-hoc programs and reports. Involving in Building the modules in Linux environment with ant script. Developed Docker container based micro services using Spring Boot/Cloud and deployment on Kubernetes cluster. Created the entire application using Python, Django, MySQL and Linux. Skilled in working on
• Data quality tools Informatica IDQ, Informatica MDM. As an Architect implemented MDM hub to provide clean, consistent data for a SOA implementation. Develop metrics based on SAS scripts on legacy system, migrating metrics to snowflake (AWS). Created SAS Transport (.xpt) files for FDA submission.
• Restful web services using Python REST API Framework. Developed complex web, middleware, and back end systems in Python, SQL and PL/SQL for Linux and Windows. Data Modelling for DWH jobs Worked on Cross-Browser

Confidential

Python Developer

Responsibilities:

• Developed and tested many features for dashboard using Ruby on Rails, RSpec, Bootstrap and JavaScript. Worked on JavaScript for developing and maintaining graphs. Created web application prototype using jQuery and React JS. Worked on cross browser compilation and Responsive web Design using HTML5, CSS3 and Bootstrap. Created and maintained various DevOps related tools for the team such as provisioning scripts, deployment tools and staged virtual environments using Docker and Vagrant. Implemented the Backbone JS for DOM manipulation as this is the light web framework compared to
• Angular JS. Design, development and implementation of performant ETL pipelines using python API (pySpark) of Apache Spark on AWS EMR. Wrote scripts in Python for extracting data from HTML file. Building/Maintaining Docker container clusters managed by Kubernetes Linux, Bash, GIT, Docker.
• Developed views and templates with Python and Django's view controller and templating language to create a user - friendly website interface. Performed server-side application using Django framework. Developed web applications and RESTful web services and APIs using python, Django, Tornado and PHP.
• Developed dynamic web pages using HTML5, CSS3 and jQuery, AngularJS, JavaScript and Oracle. Worked with a marketing company to build several Django, Pyramid, Flask and CherryPy applications. Used Python Flask framework to build modular & maintainable applications. Developed remote integration to consume third party RESTful web services and wrote XML parser. Used SAX for XML parsing, JSON and AJAX to send request to secured web service. Worked on python modules to extract /load asset data from the Postgres database. Performed Unit testing, Integration Testing, GUI and web application testing using Rspec.

Environment: Python, HTML5, CSS, Bootstrap, JavaScript, Restful Web services, Linux, Git.

Confidential

Software Developer

Responsibilities:

• Used Pandas as API to put the data as time series and tabular format for manipulation and retrieval of data. Involved in developing web application UI using HTML, CSS, JavaScript. Used MYSQL database queries from python using Python - MySQL connector and MySQL dB package to retrieve information.
• Built and optimized databases for different Airline's In-flight entertainment systems using Mysql, Sqlite and Mongo Db. Extract Big Data from CSV files, transform them and load to MySQL database table, using PySpark Creating Stored procedures to load contents for each unique GUI page. Creating stored
• Queries and optimizing them based on GUI requirements. Maintained a large web application/tool for Metadata transformation using Shell scripts, PHP, HTML, JavaScript, CSS Developed user interfaces using HTML5 and JavaScript. Used GIT to for Versioning the source code. Maintained version control of
• Python by using GIT. (Merge Branch, Push, and Commit). Python Scripting and data processing for large Databases using MYSQL. Web Application Development for access to internal databases and for API interaction. PHP server creation to seamlessly interact with Front end API calls from web applications and Python scripts. Used several python libraries like NumPy, Pandas, Matplotlib and SciPy. Uploaded statistics to MySQL for analysis and logging. Used Amazon Web Services for data storing and Web journal with Flask and Django python web framework. Analyse GUI Designs and Requirements into functional Database Configuration; taken into consideration all the LRUs applicable. Developed internal auxiliary web apps using Python Flask framework with Bootstrap, CSS HTML framework. Involved in building database Model, APIs and Views utilizing Python, in order to build an interactive web based solution. Designed and styled UI screens using HTML, JavaScript and CSS

Environment: Linux, MySQL, Oracle, Python, PHP, JavaScript, jQuery, Windows, REST