Data Engineer Information Technology

GOPIKRISHNA KOKKIRALA

602-***-**** • ********@***.*** • www.linkedin.com/in/gopi-krishna-kokkirala

EDUCATION

Arizona State University, Engineering, Ira A Fulton, Tempe, AZ AUG2021-APR2023

M.S. Information technology 3.33/GPA

Relevant Coursework: Analyzing Big data, Network Forensics, Middleware Programming and Database Security, Adv DB Management Systems, Data Visualization & Reporting for IT, Natural Language Processing, Data in the Cloud for Information Technology.

Gitam university, Visakhapatnam, Andhra Pradesh, India. AUG 2016 -May 2020

B.Tech. Computer Science Engineering. 7.8/10 GPA

Relevant Coursework: C programing, java programing, SQL, Computer networks, Probability and Statistics, Computer Science, Business Economics and Financial Analysis

PROFESSIONAL SUMMARY

Around 5 years of experience in Detail-oriented Data base designs, develops and maintains highly scalable, secure, and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design, and implementation stages.

PROFESSIONAL EXPERIENCE

DATA ENGINEER

INTRA EDGE, Arizona city, AZ

Collaborated with Development team on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

Developing applications that can process huge chunks of data by writing complex Map Reduce, Spark codes using and Scala as a programming language.

Working with YML files and writing transformations for SQL tables in Visual Studio.

Designed and implemented data loading and aggregation frameworks and jobs that will be to handle hundreds of GBs of Json files, using SPARK, Snowflake.

When building intricate programs and queries, Hive tables are frequently utilized as input data, and the processed data is then stored back in Hive tables.

Working with UNIX Shell Scripting for automating deployments and other routine tasks.

Improved the deployment and testing infrastructure within AZURE using tools like Jenkins, visual studio and Docker.

Involved in moving all log files generated from various sources to HDFS and Spark for further processing.

Performed in agile methodology, interacted directly with entire team provided/took feedback on design, Suggested/implemented optimal solutions, and tailored application to meet business requirement and followed Standards.

Collaborated with five departments including systems and operations, Data and analytics, API team and senior management to integrate data services across the organization.

DATA ENGINEER/ANALYST

NetSABIOS, Hyderabad, Telangana, India

Member of the business intelligence team, responsible for designing and optimizing systems.

Coordinated statistical data analysis, design, and information flow.

Involved in Creation of tables, partitioning tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for aa business application development.

Increased efficiency by more than 80% by developing tools to assist in capturing serial data link requirements and performing automated verification testing.

Utilized SparkSQl to extract and process data by parsing using data sets in Hive context, with transformations and actions (map, flat map, filter, reduce, reduce by key).

Extended the capabilities of Data Frames using User defined Functions in Scala.

Performed pre-processing on a data set prior to training, including standardization, normalization.

Created Pipelines to create a processing pipeline including transformations, estimations, evaluation of analytical models.

Worked with client to understand Business needs and translate those business needs into actionable reports in Tableau and Powerbi.

Created interactive dashboards based on data to establish critical metrics and KPIs to gain actionable insights for relevant decision-makers.

Gathered business requirements and converted them into new T-SQL stored procedures in visual studio for database project.

Performed unit tests on all code and packages.

Analyzed requirement and impact by participating in joint application development sessions with business client online.

Updated existing and created new reports using Microsoft SQL sever reporting and SSIS packages used in the search engine optimization process.

Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.

Built data pipelines that ingest a Varity of manufacturing process metrics and context for in product data.

Monitored and turned database resources and activities for SQL server databases.

Collaborated with cross-functional Data Architects, Analysts, and IT team members on project goals and performance.

TECHNICAL SKILLS

Hadoop Ecosystem: HDFS, Map reduce, Hive, Spark, Spark SQL, Kafka, Hive, HBase.

Languages: Python, Java, SQL, MYSQL, Snowflake, Python.

Visualization: Tableau, Powebi.

Cloud services: Microsoft Azure, AWS S3 buckets.

Tools: Git, Jenkins, Docker, Visual Studio, Data bricks.

Soft Skills: Communication, Problem-solving, Decision-making, Leadership, Collaboration, Interpersonal skills

Contact this candidate