Data Analyst Engineer

NIKITHA NAGOTI

980-***-**** adi3zd@r.postjobfree.com www.linkedin.com/in/nikitha-nagoti

EDUCATION

University of North Carolina at Charlotte Charlotte, NC Master of Science in Information Technology (4.0/4.0). December 2020 Coursework: MySQL, Visual Analytics, Mongo DB, Big Data, Machine Learning, Python and Algorithms and Data Structures Jawaharlal Nehru Technological University Hyderabad, India Bachelor of Science in Mechanical Engineering (3.5/4.0) May 2016 Coursework: Operation Research, Linear Programming, Probability and Statistics. TECHNICAL SKILLS

Languages: NET, Node JS, Java, Java Script,Python, Spark Web Servers: Apache HTTP Server, Apache Tomcat

Tools: Jenkins, SonarQube, Microsoft Excel, Microsoft Access, Microsoft Project, Jupyter, Git, Visual Studio, SQL Developer, pl/sql developer.

BigData Ecosystem & Cloud: Spark, AWS, Hadoop

Database Systems: MySQL, MongoDB,PL/SQL

Other Skills: Machine Learning models, Business Intelligence and Analytics, ETL, BigData Management, Data Analysis, Data Visualization,Data Modelling, HTML,CSS, SQL Injection attacks, PySpark, SparkSQL WORK EXPERIENCE

General Dynamics Information Technology May 2020- August 2020 Data Analyst/ Data Engineer Intern

• Integrated several suites of data validation into data pipelines using Great Expectations with Spark.

• Built Custom made expectations for the data according to the business requirement.

• Performed exploratory data analysis for Arkansas Medicaid contracts to generate reports with Python.

• Accelerated ETL using PL/SQL

• Monitor data quality in production data pipelines and data products.

• Worked with software engineers, data analysts, data scientists, and business analysts in developing various pipeline tests. These tests will alert the teams when assumptions about the data is either incorrect or has changed. TataConsultancyServices Sept 2016-July 2019

Data Engineer

• It involved management of Customer Warehouse and Operational Customer Database having customer, product, services,

• sales and billing related information.

• Data analysis using Visual Studio, SQL, Splunk and Essbase Excel Add-Ins. Developed/ optimized in-use SQL queries,

• stored procedures, views, and corresponding integrations.

• Involved in generating reports for the customer data to check the number of issues using MS Excel pivot tables.

• Optimized complex SQL queries on large scale data in RDBMS and increased the efficiency of report generation by 90%.

• Experience in handling Agile models with 95% accuracy.

• Worked on DevOps tools such as Jenkins for continuous integration and SonarQube that checks the code quality.

• Involved in complex project requirements gathering, solution designing and build phases, and communication with clients. TECHNICAL PROJECTS

Text Analysis using emotion of positive surprise words (Python, Machine Learning) Sentiment analysis with Python. Trained the model with the feature set extracted from the articles and constructed predictive models like Linear Regression, Logistic Regression and Random forest to predict the surprise ratings of the users who read the articles. EMR System (MySQL, Java)

Designed an API for an outpatient clinic that can function in real time based on the roles and holds the previous data in audit trail. Sports Fest (NodeJS, JavaScript, MongoDB)

Designed a web application which would authenticate based on user credentials and would login to give them capabilities like to buy tickets, choose events etc.

Man In the Machine Attacks (MitMa)

Published an article about MitMa attack in which I discussed how the attacks can be dealt in a better way ACTIVITIES

• Active participant of Street Cause which is an NGO whose aim is to help out the unprivileged in the best way possible.

• Chief organizer for an event BT GLITZ which helped me foster my leadership qualities.

Contact this candidate