Data Analyst
Location : Bangalore, India
Experience : 5 Year
Rate: $8 / Hourly
Availability : Immediate
Work From : Any
Category : Information Technology & Services
Having 5+ years of hands-on experience in analyzing, integrating, developing and designing robust Business Intelligence (BI) solutions in Sales and Healthcare domain with a strong understanding of data and analytics, Also having hands-on experience in Oracle and SQL
• Skilled in Business Intelligence tools like Power Bi
• Created Dashboards with different style using Power Bi components like Pie charts,Bar charts, Line, KPI Visuals etc.
• Develop detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to end user business requirements
• Extensive experience with star and snowflake schemas
• Having experience in creating Dashboards based on client requirements
• Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query
• Having knowledge on setting static and dynamic row level security
• Worked on deployment pipeline and sharing report on mail using Power BI subscription utility
• Experience in doing transformations like append, merge, creating custom columns and data cleansing in power query editor
• Good knowledge on SQL queries relevant to Power BI
• Hands on experience in Oracle like SQL queries, constraints, joins, operators,Analytical Functions, Views, indexes
• Having knowledge on OLTP, OLAP, Data Mart and Data Warehousing Concepts
• Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs
• Having experience in deployment through the CICD pipeline
• Connect to the data sources and import the data in Azure Analysis Service
• Deployed the data and connect power bi report to the AAS server
• Used Python to interact with databases (e.g.SQL Server, PostgreSQL)
• Implement data storage and retrieval mechanisms
• Used Python libraries like NumPy, Pandas, and Matplotlib for data manipulation, analysis, and visualization.
• Optimizing the performance of SSIS packages for efficient data processing.