Praveen Kumar Golla
931-***-**** • adwplk@r.postjobfree.com • Manchester, NH 03104
Organized and motivated employee eager to apply time management and organizational skills in various environments. Seeking Job opportunities to expand skills while facilitating company growth. Practical Database Engineer possessing in-depth knowledge of data manipulation techniques and computer programming paired with expertise in integrating and implementing new software packages and new products into system. Offering 3-years background managing various aspects of development, design and delivery of database solutions. Tech-savvy and independent professional bringing outstanding communication and organizational abilities. Summary
Skills Programming and scripting: Python, SQL,
Java, Scala.
•
Databases and Data Warehouses: MySQL,
MS SQL Server,Teradata
•
Hadoop environment:
Hive,Spark,HDFS,HBASE.
•
Related Skills: Agile Development, GCP,
AWS, Hadoop, Map Reduce, Snowflake,
PySpark.
•
Visualization, Analytical and ETL tools:
Tableau, Spark Data.
•
• Build and Deployment Tools: Git,Jenkins.
05/2022 - Current
Data Engineer, AT&T, Dallas, TX
08/2017 - 11/2019
Data Engineer, Finetech Software, Hyderabad
Experience
Possess experience using and developing with databases, specifically MySQL, replication, and high availability.
•
Strong understanding and expertise in database modeling and database technologies, including RDBMS and NoSQL. (35%)
•
Skilled in SQL, with knowledge and experience working with relational databases, query authoring, and optimization. (35%)
•
Proficient in setting up CI/CD pipelines using tools like GitHub Actions, Jenkins, and Travis CI to automate build, test, and deployment processes.
•
Used shell commands to push environment and test files AWS using Jenkins automated pipelines.
•
Prototyped analysis and joining of customer data using Spark in Scala and processed it to HDFS.
•
Developed AWS strategy, planning, and configuration of S3, Security groups, IAM, EC2, EMR and Redshift.
•
Developed Spark/Scala, Python for regular expression (regex) project in the Hadoop/Hive environment with
•
Experienced in building data models, infrastructure, and ETL pipelines for reporting, analytics, and data science. (30%)
•
Knowledgeable in different big data programming or scripting languages, including Python and SQL.
•
Developed applications using Spark RDD and Spark SQL for various aggregation and transformation functions.
•
• Connected Spark Scala code with DB2 for SQL to Select, Insert, and Update data into DB. Developed data processing applications in Scala using SparkRDD as well as Data frames using SparkSQL APIs. (10%)
•
Created Spark Streaming jobs using Python to read messages from Kafka & download JSON files from AWS S3 buckets.
•
Used Spark Streaming to receive real-time data from Kafka and store stream data to HDFS using Python and NoSQL databases such as HBase and Cassandra.
•
• Linux/Windows for big data resources.
Implemented the credit line policy based on the conditions applied on Spark data frames using Scala components.
•
Extracted, transformed and loaded data sources to generate CSV data files with Python programming and SQL queries. (10%)
•
Prototyped analysis and joining of customer data using Spark in Scala and processed it to HDFS. (10%)
•
• Built automate pipelines using Jenkins and groovy scripts. (10%) 01/2020
Master Of Science, Information Technology
Southern New Hampshire University, Hooksett, NH
Electronic Patient Management System project, Capstone Project: 08/2019
MBA, Finance
Osmania University, Hyderabad
05/2017
Bachelor Of Arts, Bachelors of Computer
Osmania University, Hyderabad
Education And
Training
• [3.8] GPA
Developed an electronic patient management system for a capstone project to improve healthcare processes and patient outcomes.
•
• Utilized Spring, and MySQL to design and develop the system's functionality and data model. System features included appointment scheduling, electronic medical record management, and a dashboard for healthcare professionals to monitor patient status.
•
Goal was to reduce errors, increase efficiency, and improve patient outcomes in healthcare operations.
•
Successfully completed the project, demonstrating potential for significant improvements in healthcare processes and patient outcomes.
•
• Final Grade: [70]%
• Final Grade: [85]%