Manasa Chappa

Working for Pharmacy Technology team to create a tableau report for analyzing the data and to take business decisions.
● Develop, support and maintain a data pipeline using Apache Kafka.
● Read the data from Kafka topic and using kSql, KStream and KConnect process and push the data to PostgreSQL for tableau reporting.
● Used Apache Nifi to read data from Oracle, transform and pushed it to PostgreSQL for tableau reporting.
● Analyzed large amounts of datasets to determine optimal way to aggregate and report it.

• worked on POC for Hopsworks framework, to collaborate for ML teams, providing a secure, governed platform for developing, managing, and sharing ML assets - features, models, training data, batch scoring data, logs
• Working for Pharmacy Technology team to create a tableau report for analyzing the data and to take business decisions.
• Analyze the tables and understand the raw data in Oracle Database before transfer the data into the PostgreSQL Database.
• Creating tables and trigger functions to read the data from oracle and store the data in PostgreSQL Database.
• Creating requests for Attunity and KSQL Kafka Topics from Kafka-UI to convert the raw data from JSON to
  Avro schema.
• Creating KSQL scripts to transfer the data from oracle to PosgreSQL Database.
• Develop an ETL pipeline by using logfile generated everyday by ambari agent. write a script to put the file on HDFS and Sprak application to process the logfile and extract the required information.

Worked as Business Analyst and System Testing for the Pennsylvania Voter Services and also supported developer with reinstates.

• As a BA for the support team, I was bridging connection between developer and client for PAvoterservices front
  end development.
• Worked in Manual testing to check the updated records of the voters for both Absentee and Mail-In Application.
• Developed sql queries for reinstating/updating records of the voter which linked with other voter records.
• Developed the front end PAvoterservices absentee application page using SSMS to update the Warning and deadlines for the users.