Manikanta Challa

Having around 5+ years of experience in the IT Industry and 4+ years on Business Intelligence tools like Power BI. Expertise in importing data from multiple data sources into Power BI, created relationships between various Tables in Power Pivot. Experience in Data preparation such as shaping data in Edit Query like add columns, split column, pivot column, unpivot column, changing data type and managing columns. Combined the tables and columns by append queries and merge queries in Power BI. Experience on understanding DAX Functions in Power BI and created calculated columns measures and New Tables using DAX. Knowledge on Data Warehousing Concepts like Start Schema, Snowflake schema, fact and dimensional tables and software development life cycle.

Project #4, Cardinal Health - US, Software Developer, Power BI, SQL Server, Excel, Tata Consultancy Services Hyderabad, This project provides different reports for making intelligent solutions based on data available in various branches across the worldwide connected over a period. It was established in 1891. It is American pharmaceutical company and one of the largest pharmaceutical companies in the world. We have different products like vaccines, Animal Health, Oncology, Fosamax, and Anti-bacterial and so on. The main objective of this project is to collect the data from different sources and dump into data warehouse once reaches the requirements then build the dashboards as per client business logics.

 Project #3, Dillard’s Strategic Network, Software Developer, Power BI, SQL Server, Excel, Tata Consultancy Services Hyderabad, Dillard’s is one of the leading Supermarket in north America in performing business intelligence operations in different locations across the global. In order to analysis there business moments like different product sales trends, sales profits, regional sales, top N products sales information they need a data warehouse systems. We build the data warehouse systems by capturing data from different transactions systems. Once data is loaded into data marts, we can generate data marts reports as per business request marts. 

Project #2, Electronic Medical Records (EMR) Portfolio, Software Developer, Power BI, SQL Server, Excel, Fidelity Information Services Bangalore, EMR is an Electronic Medical Records (EMR) based transactional application. EMR is the source system for Order entry and Order processing throughout the Medical Records which provides Information about to patient based on patient visits (orders), Investigation Results, Geographical Details and Billing Details like Insurance Provider, Policy types, corporate companies, Coverage Limits etc 

Project #1, Sales & Inventory Analysis, C&S serves about 3,900 stores from more than 50 locations in 11 states in the United States of America. It is a Supply Chain Management based transactional application. C&S has the source system for Order entry and Order processing throughout the supply chain which provides delivery date to customer based on supply (orders) and demand (inventory levels), Order releasing - releases product to ship to a customer from the warehouse based on current supply and demand.