We provide IT Staff Augmentation Services!

Sr Data Analyst Resume

3.00/5 (Submit Your Rating)

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.

We'd love your feedback!