Sr Data Analyst Resume
Mclean, VA
SUMMARY
- 6+ years of experience as a Python Developer, pro cient coder in multiple languages and experience in Design, Development, Implementation of Python, Django, Flask client - server technologies-based applications, RESTful services, AWS, GCP, JAVA, and SQL.
- Experience in building APIs, Go routines with GO Lang.
- Experienced in design and extraction of encounter data from multiple source systems into the data warehouse relational database (Oracle) while ensuring data integrity.
- Experienced in Design, development, and implementation of performant ETL pipelines using python API (pyspark) of Apache Spark on AWS EMR
- Experience with AWS infrastructure and concepts like EC2 instance, S3 storage (cross region replications), RDS, IPM, route 53, AWS lambda functions
- Experienced with event-driven and scheduledAWSLambda functions to trigger variousAWS resources.
- Experience in writing cloud applications using AWS Cloud9.
- Experience in Building AWS code pipelines using code commit and code build, and code deploy.
- Gained experience in deploying applications on to their respective environments using Elastic Beanstalk.
- Highly skilled in deployment, data security and troubleshooting of the applications using AWS services.
- Experience in setting up CI/CD pipelines using AWS DevOps tools
- Experience in all phases of Software Development Life Cycle (SDLC)-Waterfall, agile Process across various workflows (Requirement study, Analysis, Design, Coding, Testing, Deployment and Maintenance) in Web & Client/Server application development.
- Extensive experience in developing web applications using Python, Django, Flask frameworks, pyspark.
- Experience in working with several python libraries including Beautiful soup, NumPy, matplotlib, SciPy, PyQt, Scapy, SQLAlchemy.
- Good experience in developing web applications implementing MVT architecture using Django, Flask, Webapp2 web application frameworks, with good understanding of Django ORM and SQLAlchemy.
- Hands-on experience with industry-standard IDEs like PyCharm, Sublime, NetBeans.
- Extensive experience in developing applications by implementation of web based and client/server application using HTML, Angular JS, Node JS, CSS, JavaScript, and various Java/J2EE technologies.
- Good experience in Shell Scripting, Oracle RDBMS, SQL Server, UNIX, and Linux.
- Good knowledge of TCP/IP, UDP, HTTP, HTTPS, SSH and SSL protocols.
- Expert at version control systems like Git, SVN and CVS, Migrated repos from svn to GitHub.
- Proficient in writing SQL Queries, Stored procedures, functions, packages, tables, views, triggers using relational databases like Oracle, MSSQL Server.
- Experience with Arc Objects SDK and ArcGIS JS API
- Good experience in working with Amazon Web Services (AWS) like AWS EC2, S3, VPC, SES, ELB, EBS, RDS, Glacier, DynamoDB…etc.
- Experience in using XML, SOAP, REST web Service for inter operable software applications.
- Hands on experience with bug tracking tools JIRA and Bugzilla.
- Experience in Agile development processes ensuring rapid and high-quality software delivery
- Highly motivated, quality minded developer, with proven ability to deliver applications against tight deadlines.
TECHNICAL SKILLS
Software Development: Java8/7, Python 3.6/2.7, R, Pyspark, Hadoop
Web Technologies: HTML, CSS, JavaScript, Django 2.0.6, Flask, React, Bootstrap, Node.js, AWS EC Cloud, GCP
Project management: SCRUM
Python Libraries: NumPy, Pandas, Matplotlib, Seaborn, SciPy, NLTK
Database Management: SQL server, MS-Access, PostgreSQL, Oracle
Web servers: Django-REST framework, REST Amazon s3, AWS, GCP
Version Control: GIT(GitHub), SVN, CVS
PROFESSIONAL EXPERIENCE
Confidential, McLean, VA
Sr Data Analyst
Responsibilities:
- Developed AWS Lambda function to terminate the EC2 instances and scheduled with cloud event CRON job.
- Developed Databricks script to load the data from Redshift database to snowflake database and performed data quality checks.
- Developed automation scripts to simulate Guard Duty actions on AWS IAM roles.
- Developed automation scripts to pull the data from VPC endpoints for S3 ad DynamoDB services and compare the policies whether compliant and non-compliant using boto3 SDK.
- Developed Tableau Dashboards and stories for JIRA reporting using Tableau Desktop.
- Developed python scripts to connect to Oracle database to get the data.
- Developed scripts to automate the controls testing utilizing multiprocessing techniques.
- Experienced in using AWS Athena service to query s3 bucket objects and CloudTrail log data.
Environment: Python, snowflake, Databricks, Tableau, Python SDK, AWS, Flash, NumPy, Pandas, DOM, Bootstrap, XML, HTML5, JavaScript, Angular.js, JSON, Rest, Apache Web Server, Git Hub, MySQL, LINUX.
Confidential, Tampa, FL
Python Developer
Responsibilities:
- Responsible for writing complex queries using Oracle PL/SQL.s
- Performing Mapping and Analysis using ARCGIS.
- Developed the test cases using Pytest and performed test coverage using pytest-cov.
- Developed API’s using AWS lambda and integrated with API Gateway.
- Experienced in creating s3 buckets connecting with BOTO3 python SDK.
- Containerized the microservices using Docker.
- Used Keras, tensorflow to train DL models.
- Generated tokens using keras, tokenizer, used GloVe word embeddings and trained multi label text classification models using LSTM.
- Generated tokens using keras, tokenizer, used GloVe word embeddings and trained multi label text classification models using LSTM.
- Built text summarizer using bert-extractive-summarizer
- Configured CI/CD pipelines with Jenkins.
- Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
- Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
- Created RESTAPIs using Django Rest Framework
- Created AWS Lambda function to trigger SNS notifications.
- Performed data extraction, transform and load operation for spatial data in KML and CSVs.
- Experienced in Design, development, and implementation of performant ETL pipelines using python API (pySpark) of Apache Spark on AWS EMR
- Developed microservices using Flask framework.
- Developed Python batch processors to consume and produce various feeds.
- Created test harness to enable comprehensive testing utilizing Python.
- Wrote Python scripts to parse XML documents and load the data in database.
- Handled all the client-side validation using JavaScript.
- Used python scripts to update content in the database and manipulate files.
- Created Data tables utilizing PyQt to display customer and policy information and add, delete, update customer records.
- Developed the required XML Schema documents and implemented the framework for parsing XML documents.
- Used JQuery for selecting DOM elements when parsing HTML.
- Worked with JSON based REST Web services.
- Using GIT version control tool to coordinate team-development.
Environment: Python, Django, PYQt, Python SDK, AWS, Flash, Numpy, Pandas, PyQuery, DOM, Bootstrap, XML, HTML5, JavaScript, Angular.js, JSON, Rest, Apache Web Server, Git Hub, MySQL, LINUX.
Confidential, Chicago, IL
Research Associate
Responsibilities:
- Taken part in entire lifecycle of the power system bus mapping projects including Design, Development, and Deployment, Testing and Implementation and support.
- Designed GUI application using python and Tkinter library to display power system network.
- Designed the front end of the application using Python, Java, HTML, CSS, AJAX, JSON and jQuery.
- Developed and tested many features for software using Python, ROBOT framework, Bootstrap, CSS, and JavaScript.
- Used JavaScript and XML to update a portion of a webpage and Node.js for server-side interaction.
- Develop consumer-based features and applications using Python, Django, HTML, Behavior Driven Development (BDD) and pair-based programming.
- Performed Unit testing, Integration Testing, GUI, and web application testing using Spec.
- Involved in writing SQL Queries and implementing stored procedures, functions, packages, tables, views, Cursors, triggers.
- Deployed the project into WebLogic using GIT version control system.
- Worked in MySQL database on simple queries and writing Stored Procedures for normalization and renormalization.
- Build SQL queries for performing various CRUD operations like create, update, read and delete.
- Involved in the Design, development, test, deploy and maintenance of the website.
- Responsibilities include developing, design and testing of power system dynamic models using PSS/E, PYTHON and MATLAB/Simulink for dynamic stability assessment.
- Successfully implemented exciter, governor and HVDC line dynamic models.
- Implemented automation scripts with python for running simulation using PSS/E and MATLAB/Simulink platforms.
- UI was developed using HTML, AJAX, CSS and JavaScript.
- Developed entire frontend and backend modules using Python on Django Web Framework.
- Developed Python batch processors to consume and produce various feeds.
- Created database access layer using JDBC and PL/SQL stored procedure.
- Developed Merge jobs in Python to extract and load data into MySQL database.
- Use Git for version control.
- Wrote validation scripts in SQL to validate data loading.
- Skilled in using collections in Python for manipulating and looping through different user-defined objects.
- Work with team of developers on python applications for RISK management.
- Used Pandas library for statistics Analysis.
- Improved code reuse and performance by making effective use of various design patterns.
- Worked in development of applications especially in Linux environment and familiar with all its commands.
Environment: Python, Django, PYQt, Python SDK, AWS, Flash, PHP, Numpy, Pandas, PyQuery, DOM, Bootstrap, XML, HTML5, JavaScript, Angular.js, JSON, Rest, Apache Web Server, Git Hub, MySQL, LINUX.
Confidential
Junior Python Developer
Responsibilities:
- Involved in the Design, development, test, deploy and maintenance of the website.
- UI was developed using HTML, AJAX, CSS and JavaScript.
- Developed entire frontend and backend modules using Python on Django Web Framework.
- Generated property list for every application dynamically using Python.
- Developed internal auxiliary web apps using Python Flask framework with CSS / HTML framework.
- Implemented Test Driven Development (TDD) strategy for the project.
- Developed Python batch processors to consume and produce various feeds..
- Developed Merge jobs in Python to extract and load data into MySQL database.
- Use Git for version control.
- Wrote validation scripts in SQL to validate data loading.
- Trained users and did production support.
Environment: Python, Django, MySQL, HTML, XHTML, CSS, AJAX, JavaScript, Apache Web Server, Git, Linux.