Kameswararao Malla

About Kameswararao Malla

Currently working as part of iTunes Data Analytics team in Apple, my current job responsibilities include building Reporting solutions on huge and complex Enterprise Data Warehouse and analytical information for business intelligence that highly impacted business decisions. Working in the field ofData analysis, ETL (Extract Transform Load), Data Integration and Data Warehousing using Teradata, Informatica and Data warehousing for 6+ years and have an array of experience in working companies like Deloitte & Capgemini. Worked on the diversified domains like Media, financial & Health care services. Decent experience in database, analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed timelines.• Expertise in data analysis using multiple sources (Hadoop, Teradata, Oracle) and creating data extracts using PySpark, Hive TD utilities like Fastload, Fastexport and Bteq• Hands on experience with Qlikview reporting, Tableau dashboards for visual data analysis, Physical, Logical and Conceptual Data modeling in Data Warehousing Schemas.• Skilled in writing complex SQL queries for extracting data from multiple sources/tables• As part of iTunes Data Analytics team in Apple, my current job responsibilities include building Reporting solutions onhuge and complex Enterprise Data Warehouse• Experience in coordinating and leading a team in onsite-offshore model• Reported analytical information for business intelligence that highly impacted business decisions• Analyzing large set of clickstream data in Spark and Hive to identify KPI’s• Created workflows for complex data processing pipelines using Airflow, PIE Data pipelines which provided business aneasier way to streamline the frequent reports

Experience

1. Lead Consultant

   Infosys Consulting

   Nov 2024 — Present · Hyderabad, IN

Education

• University of Central Missouri

  Master of Science - MS, Computer information systems

  2016 — 2017

• Chaitanya Engineering College, Chaitanya Valley, Kommadi, Madhurawada,Pin-530041(CC-L6)

  Bachelor of Technology (B.Tech.), Electrical, Electronics and Communications Engineering

  2009 — 2013

Skills

• Data Warehousing
• Unix
• Oracle Database
• Sql
• Asp.net
• Qlikview
• Html5
• Phpmyadmin
• Oracle
• Javascript
• Web Development
• C
• Software Development Life Cycle (Sdlc)
• Qlikview Development
• Extract, Transform, Load (Etl)
• Html
• Dbms
• Informatica
• Php
• Cascading Style Sheets (Css)
• Databases
• C#