ARAVIND GANGAVELLI
**** ********** **, *******, **-30041
Cell: 703-***-****, **********************@*****.***
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.