PROFESSIONAL SUMMARY:

• 8+ years of IT experience in all phases of SDLC, along with experience in Application Development, Design, software development using Python, Django, Pandas, Selenium, Client - Server based applications, testing and maintenance.
• Good knowledge with Big Data Ecosystems, ETL.
• Experienced in design and development of presentation layer for web based applications using HTML/HTML5, CSS/CSS3, JavaScript, JQuery, XML and JSON.
• Experienced in performing Business Process Reengineering/Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Good experience with Django, a high level python web framework and C++, XML, CSS, HTML, JavaScript and JQuery.
• Good experience in Object oriented programming concepts in Python, Django and Linux.
• Experienced in WAMP (Windows, Apache, MySQL, and Python/PHP) and LAMP (Linux, Apache, MySQL, Python/PHP) Architecture.
• Experienced in installing, configuring, modifying, testing and deploying applications with Apache.
• Experience in writing sub queries, stored procedures, Triggers, Cursors and Functions on mySQL and PostgreSQL database.
• Worked on few and familiar with various applications using python integrated IDEs Eclipse, PyCharm, Sublime, Pystudio, PyScripter and NetBeans.
• Working Experience in amazon AWS cloud which comprises of services like: EC2, S3, VPC, ELB, RDS.
• Experience in setting-up databases in AWS using RDS, storage using S3 bucket and configuring instance backups to S3 bucket.
• Basic understanding of Golang programming and limited hands on experience in creating programs in Golang.
• Exceptional Documentation Skills for writing Use Cases, Functional Requirement Documents and Business Process Documentation.
• Experience on Tableau Desktop, Tableau Reader and Tableau Server.
• Experience in end to end design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Publishing dashboards and data sources to Tableau Server as well as managing access, user security, refreshing of Tableau extracts etc.
• Extensive knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Hands on Experience in Writing Python Scripts for Data Extract and Data Transfer from various data sources.
• Hands on Experience in automating and scheduling the jobs using UNIX shell scripting.
• Involved in manual testing, Automation testing and Integration testing by using Jenkins.
• Integrated Build Process through Jenkins to various SCM tools like GitHub, SVN.
• Experience in using Version Control tools like GIT, SVN.
• Experience in JIRA for bug tracking and issue tracking.
• Good communication, organization and interpersonal skills.
• Worked in agile and waterfall methodologies, SCRUM process with high quality deliverables delivered on-time.

TECHNICAL SKILLS:

Languages: Python 2.7 and 3.4, Selenium, C, C++, Java, Shell script

Web technologies: HTML, CSS, XML, Java Script

Other skills: GIT(version control) and Jenkins (CI/CD)

BI tools: Tableau Desktop, Tableau Server, Tableau Public

ETL tools: Informatica power center

Cloud: AWS

Databases: PostgreSQL, Sqlite3,Teradata, Oracle 11g/ 12g, SQL server, MySQL, MS Access, Confidential DB2

Web servers: Apache, Websphere

Frameworks: Django, Flask

Modeling Tools: ERWIN

Scheduling tools: AutoSys, Control M

Environment: Unix, Mainframes(zOS),Windows2003/2000/XP, LINUX, Mac

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, Virginia

Python and Django developer

Responsibilities:

• Requirement gathering, planning of architecture and building POCs.
• Creating API interface with Sales force application to get the data for Payments & Vendors.
• Working on AWS environments and making sure of authorizations & Security as data is owned by Confidential bank.
• Creating Ec2 instance and S3 bucket for creating databases for storage on cloud.
• Using the existing APIs and building new REST APIs using Python Django framework.
• Developing web pages on HTML, CSS and JavaScript.
• Involving with off shore teams to share the work and check on updates on sprint, help them with any business questions.
• Performing daily stand ups and gather all updates and update the Jira for the team.
• Helping Client to understand the technical scenarios and make sure timelines are defined appropriately.
• Used Postman tool to use, build, test APIs.
• Testing the python scripts using Unittest and API testing to make sure data, security is good.
• Deploying the application on Linux server on AWS and scheduling the jobs using Jenkins.

Environment: Python 2.7, Django, Postman tool, AWS Ec2 and S3, RESTful web services, HTML, CSS, JSON, JavaScript, Jenkins, Sales force db, MySQL.

Confidential, TX

Python developer and Automation

Responsibilities:

• Requirement gathering, Data analysis of different types of data.
• Creating excel files using different Python libraries Openpyxl, XLWT, Pandas.
• Using Pandas data frames for working with data and manipulating data.
• Automation of creation of excel sheets using Pandas based on different requirements and pulling of data from other excel files as input.
• Reading, writing of excel sheets using Pandas, Numpy, Openpyxl, XLRD, XLWT.
• Extraction of data from different APIs using RESTful API services.
• Working with XML data, JavaScript on different modules.
• Used Python AWS SDK for dynamic creation of EC2 instance and installed the application on AWS EC2 instances.
• Developing Test suites to test the modules using Unittest framework.
• Using REST APIs to pull data from a third party system and working on data to make it useful for the successor application internally.
• Debug existing automation code and test to confirm functionality within AWS/EC2.
• Evaluated business requirements and prepared detailed specifications that follow project guidelines
• Required to develop written programs.
• Implemented python code for retrieving the Social Media data.
• Analyzed large amounts of data sets to determine optimal way to aggregate and report on it.
• Designed the data model for storing the data.
• Creating MySQL tables, loading with data and writing SQL queries which will be used by python programs.
• Designed and developed the scripts to load the data into Hive.
• Worked on SQL joins to aggregate social media data according to the requirement.
• Created tables in MySQL which are used as staging table for the data loaded from the inbound feeds.
• Worked on different file formats like Text files and ORC files.
• Developed python script for faster processing of data using Multi-threading concept in Python.
• Implemented Docker build tool for scheduling, deploying Python jobs.

Environment: Python 2.7, Pandas, Numpy, RegEx, Selenium, AWS, RESTful services, HTML, JSON, XML, MySQL, all Excel related python libraries (XLRD,XLWT,Openpyxl), OS module.

Confidential, Irving, TX

Python developer

Responsibilities:

• Analysis of requirements and implement different functions, models according to design.
• Developed user interface using HTML, CSS and JavaScript.
• Worked on creating custom ETL scripts using Python for business related data.
• Performed Data Cleansing using python and loaded into the target tables.
• Developed Python modules to extract/load asset data from the MySQL source database.
• Worked on with spark dataframe operations that are required to develop a data format file.
• Analyzed the SQL scripts and designed it by using PySpark SQL for faster performance.
• Used python sub-process module to call UNIX shell commands to check directories or files exists.
• Worked on storing the dataframe into hive as table using PySpark.
• Used PyUnit, the Python unit test framework, for all Python applications.
• Developed the REST Web services to expose the business methods to external services in the project .
• Involved in front end frame works like CSS, Bootstrap for development of Web application.
• Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
• Automation and deployment on AWS instance.
• Developed data format file that is required by the Model to perform analytics using Spark SQL and Hive query language.
• Used spark parameters like number of executors, executor memory to execute the pipeline to increase the performance.
• Developed another scripts that will be moving the data from HDFS to Amazon S3.
• The Data format file is provided as input to Model which performs the analytics and the utput will be placed in HDFS location.
• Created External Table in the HDFS location where the analytics data will be updating regularly.
• Monitor the Spark jobs in Spark URL and Involved in Unit test and debugging after development.
• Used Pandas API to put the data as time series and tabular format for easy timestamp data manipulation and retrieval.
• Used Tableau to develop the data visualization and developed dashboards according to the requirement.
• Involved in creating metrics, attributes, filters, reports, and dashboards with Tableau.

Environment: Python 2.7, Django, REST APIs, Pandas, RegEx, Hadoop, AWS, Hive, Pig, Flume, Tableau, ETLHTML, CSS, JavaScript.

Confidential, TX

Python developer and Data Analyst

Responsibilities:

• Analysis of requirements and implement different functions, models according to design.
• Developed the back-end web services using Python, Django and REST APIs.
• Analyzes and improves application efficiency by optimizing queries and contents for Django.
• Associated with development of Web Services using RESTful API's.
• Designed, added and maintained new database tables for new functions.
• Wrote Python modules to extract/load asset data from the MySQL source database.
• Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.
• Experience with some of the existing modules of Golang build for concurrent processing of applications and some of its important functions.
• Conducted data analysis using Python libraries such as Pandas, Numpy and Matplotlib.
• Built multifunction readmission reports using python pandas and Django frame work.
• Involved in creating metrics, attributes, filters, reports, and dashboards with Tableau.
• Involved in building SQL queries that would be utilized in Tableau dashboards to satisfy the business's needs.
• Golang programs have been analyzed and made small tweaks or minor improvements in business logics.
• Managed large datasets using Panda data frames and MySQL.
• Used Pandas API to put the data as time series and tabular format for easy timestamp data manipulation and retrieval.
• Built various graphs for business decision-making using Python Matplotlib library.
• Used Git and Jira for code submissions and review process.
• Used Shell scripting, XML to automate some of the menial tasks.
• Used Django configuration to manage URLs and application parameters.
• Used Python and Django to interface with the JQuery UI and manage the storage and deletion of content.
• Installing, configuring and administering Jenkins CI tool on Linux machines and built Continuous Integration and Continuous delivery environment.
• Experience in implementing with server side technologies with restful API and MVC design patterns with node JS and Django framework.
• Created RESTful http services to interact with UI.
• Wrote Python scripts to parse XML documents and load the data in database.
• Build development environment with JIRA.
• Responsible for debugging and troubleshooting the web application.

Environment: Python 2.7 and 3.0, Django 1.4,Jenkins, XML, MySQL, HTML, CSS, JavaScript.

Confidential

Python and Tableau developer

Responsibilities:

• Analysis of requirements and implement different functions according to design.
• Developed the back-end web services for the worker using Python and REST APIs.
• Wrote scripts in Python for Extracting Data from JSON and XML files.
• Implemented PostgreSQL to improve applicability and performance of the data.
• Used Django APIs for database access.
• Utilized standard Python modules such as CSV, robot parser, Iter functions and pickle for development.
• Involved in development of Web Services using SOAP and REST for sending and getting data from the external interface in XML and JSON format.
• Used Ajax and JQuery for transmitting JSON data objects between frontend and controllers.
• Wrote scripts in Python for Extracting Data from JSON and XML files.
• Implemented user interface guidelines and standards throughout the development and maintenance of the website using the HTML, CSS, JavaScript and JQuery.
• Worked on front end frameworks like CSS Bootstrap for responsive web pages.
• Developed and tested many features for dashboard, created using Bootstrap, CSS, and JavaScript.
• Developed wrapper in Python for instantiating multi-threaded application.
• Familiar with Amazon web services and added support for Amazon AWS S3 and RDS to host static/media files and the database into Amazon Cloud.
• Managed datasets using Panda data frames and MySQL, queried MYSQL database queries from python using Python-MySQL connector and MYSQL db package to retrieve information.
• Participated in dashboard design reviews along with product manager.
• Created Tableau Scorecards, Dashboards using stack bars, bar graphs, scattered plots, geographical maps, and line/pie graphs.
• Built and published customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop.

Environment: Python 2.7/3.0, CSS, Django, HTML, JavaScript, Tableau, MYSQL, Linux and Python libraries.

Confidential

Python developer

Responsibilities:

• Requirement gathering and analysis phase of the project in documenting the business requirements by conducting workshops/meetings with various business users.
• Used Django/Python web-framework to develop application.
• Used MVC framework to build modular & maintainable applications.
• Designed and developed transactions and persistence layers to save/retrieve/modify data for application functionalities using Django and PostgreSQL.
• Automated data movements using python scripts. Involved in splitting, validating and processing of files.
• Involved in building database Model and Views utilizing Python, in order to build an interactive web based solution.
• Designed and developed data management system using MySQL and built application logic in Python2.7.
• Generated Python Django Forms to record data of online users.
• Used python to extract information from XML files.
• Worked on development of SQL and Stored procedures on MySQL, PostgreSQL database.
• Developed shopping cart for Library and integrated web services to access the payment (E-commerce).
• Provided technical assistance for maintenance, integration and testing of software solutions during development and release processes.
• Effectively communicated with the external vendors to resolve queries.

Environment: Python 2.6/2.7, Django Framework 1.3, CSS, SQL, MySQL, LAMP, JavaScript, JQuery, Apache web server.