ARAVIND GANGAVELLI

**** ********** **, *******, **-30041

Cell: 703-***-****, ac86er@r.postjobfree.com

Professional Summary

An enthusiastic IT consultant who completed coursework in Computer and information sciences with excellent research, time management, problem-solving, technical skills along with more than one year of experience in information technology field.

Skills

Microsoft Azure

Data Bricks

Manhattan WMOS

IBM iSeries WIMS

My SQL, SQL, DB2, Oracle, python

Azure PowerShell

Amazon Web Services

Committed to quality assurance

Critical Thinking

SSMS, SAS, SQL

SDLC like Agile & Scrum

MS-EXCEL, Star Schema

Work History

06/2018 to

04/2109

Data Engineer

CLIENT: Columbia Sports Wear, Portland, Oregon

Involved in all the phases of Software Development Lifecycle and implemented Agile & Scrum methodology.

Extract Data from multiple sources including AS/400(IBM I Series)

Design and developed complex Data Pipelines and maintained the data quality to support a rapidly growing business.

Ingested the Data in to Azure Data Lake.

Parsing, Analyze and Transform the Raw Data.

Designed a large data warehouse using Star schema.

Integrated SQL, Python into traditional ETL, accelerating the extraction, transformation, and loading of massive structured and unstructured data.

Ingested the aggregate data into a relational database for reporting, dash boarding and Azure Analysis Services (AAS).

Develop SQL queries with multi-table joins, group functions, subqueries for member policy data analysis.

Conducted thorough research and analysis of software systems to enhance performance and efficiency.

Responsible to make sure that the data coming into the system is clean and accurate and stays that way over the entire life-cycle of the data.

Involved in bug fixes and feature enhancements.

07/2017 to

06//2108

Production Support Analyst

CLIENT: Essilor Instruments, USA

Plan and execute integration testing with customer to ensure functional and non-functional business and system specifications are met

Coordinate all testing activities and resources for projects

Perform automated and manual testing

Mentor and provide instruction to Technical Quality Specialists

Work with project team to provide test data, interface with multiple teams and customers to provide status reports

Software review and reporting, documentation of test results

05/2017 to

07/2017

Software Developer Internship

IRA Tech INC– Renton, Washington

Analyze user needs to develop and customize computer applications software. Develop, modify and test the code, forms and script that allow computer applications to run.

Perform application studies and evaluations, design systems and procedures, conduct work

simplification and measurement studies.

Analyze and design database within an application area with the aim of optimizing operational efficiency. Write programs to store. Locate and retrieve specific data and information from database.

Prepare operations and procedure manuals to assist application development team. Analyze and deliver the change requests as per the schedule.

10/2016 to

07/2017

Graduate Assistant

Alcorn State University – Lorman, Mississippi

Oversaw groups of students and assisted with academic projects.

Helped under graduates in solving the technical errors in coding.

Assisted with data collection to be used for potential academic publications.

Analyzed acquired information and presented to professors.

08/2014 to

08/2015

Junior Software.QA

Candour Technologies– Hyderabad, India

Identified, documented and reported bugs, errors, interoperability flaws and

Other issues.

Demonstrated methodical, detail-oriented and thorough approach to all assignments

while adhering to compress time lines.

Consistently recognized for excellent problem solving and analytical skills by programmers

and project Managers.

Worked collaboratively with QA, development and business groups to complete

comprehensive testing on 2 major releases.

Education

2016 to 2017

Master's in Computer and Information Sciences

Alcorn State University – Lorman, MS

GPA- 3.81/4

2010 to 2014

Bachelor of Engineering

Kakatiya University - Hanumakonda, India

GPA-6.3/10

Accomplishments

Participated in poster presentation competition during visistsa at Vinutha Institute of Technology and science, India, 2014.

Volunteered as web casting representamen at Andhra Pradesh Elections,2014 organized by election commission of India.

Participated in a poster presentation at Kakatiya Institute of Technology and Science, 2014.

Contact this candidate