Data Analyst Power Bi

AARIFA JANNATH S B

Data Visualization and Analysis Professional

+91-876******* **.*******@*****.*** Bengaluru, India SUMMARY

Results-oriented professional with 8 years of total experience, including 4+ years as a Data Analyst specializing in data-driven decision support. Proficient in Python and SQL for data extraction, transformation, and analysis. Skilled in using Power BI to create dynamic dashboards and reports. Experienced with NumPy, pandas, and seaborn for data manipulation and visualization. Strong understanding of data modeling and applying machine learning techniques for predictive analytics. Proven ability to translate complex data into clear insights to drive strategic initiatives. TECHNICAL SKILLS

Advanced Excel

• Python

• Data Modelling

SQL, DAX • Cognitive Analysis • Data Visualization

Power BI • CAD • Data Cleaning

SQL Server

WORK EXPERIENCE

• Machine Learning • Data Storytelling

Data Analyst Corefront Technologies, Bengaluru 2/2020 – 04/2024

• Used SQL to extract and analyze data from relational databases generated weekly and monthly reports, summarizing data insights and presenting findings to management. Thus, improving the efficiency of reporting processes.

• Developed and optimized complex SQL queries for efficient data extraction, transformation and seamless integration with Power BI reports.

• Optimized ETL transformations by implementing data validation checks, reducing reporting errors by 30%.

• Developed and maintained Power BI reports and dashboards, leveraging DAX to meet business requirements.

• Collaborated with business stakeholders to understand requirements and deliver actionable insights.

• Collaborated with cross functional teams to define business requirements and data models.

• Created monthly and weekly reports by utilizing advanced Excel functions and applied statistical techniques to analyze data and produce valuable business insights.

• Utilized data visualization tools to effectively communicate business insights. Assistant Manager ICICI Bank, Bengaluru 10/2019 – 02/2020

• Directed teams in coordinating efforts to address billing issues, facilitate payment discussions, and achieved a 15 % improvement in client satisfaction.

• Facilitated customer services including fixed deposits and loan applications. Handled end-to-end customer management.

• Delivered inbound services, backend support, and account management Design Engineer Cranfinia Energy private Limited, Bengaluru 09/2017 – 06/2019

• Conducted study of sustainable energy products and prepared preliminary design layouts for mechanical systems.

• Drafted assembly details and installation plans, generating material schedules (BOM) per MIL standards.

• Executed detailed design and assembly modeling of mechanical components using CAD.

• Developed rework schemes for dimensionally deviated parts based on vendor requirements.

• Handled projects involving conceptual and preliminary design for solar products.

• Analyzed customer data to identify trends and patterns.

• Provided valuable insights to customers, improving customer experience and business performance. Testing Engineer Happiest Mind Technologies Limited, Bengaluru 08/2015 – 09/2016

• Conducted manual testing of Microsoft Dynamics CRM modules, including ATI, AAFA, and REARC.

• Identified bugs and raised tickets in Jira for prompt rectification.

• Executed test cases to verify application functionality and detect malfunctions.

• Managed end-to-end integration process from CRM to UA and GP, ensuring accurate data migration.

• Gained insights into new entities in CRM REARC, specifically enrolments and payments.

• Projects handled included PES-Ascend Learning, utilizing CRM tools. EDUCATION

Bachelor of Engineering-Aeronautical (8.2 GPA) achieved First Class honors Nehru Institute of Engineering Technology. Coimbatore. KEY ACHIEVEMENTS

• Successfully conducted Data analysis and provided the concrete results by using Python, SQL.

• Readied the analysis model within given time constraint and created an insightful dashboard.

• Implemented advanced analytics and scheduled data refreshes in Power BI Service, enabling real-time insights and enhancing executive reporting efficiency.

• Collaborated with cross-functional teams to design and optimize data models, improving business forecasting and supporting more accurate demand planning.

• Developed a customer segmentation model using machine learning techniques, enabling the marketing team to improve targeted engagement strategies.

PROJECTS

Capstone Projects

• A reliable machine learning model capable of predicting laptop prices with high accuracy.

• Insights into the factors influencing laptop prices, empowering market positioning and strategy. Sales Analysis Dashboard

• Created an insightful dashboard for 2019 sales by analyzing the growth trends of 4 product categories by using pivot table. Housing Dataset EDA Project

• Performed Exploratory Data Analysis (EDA) on the Housing dataset to understand the data, relationships and insights for better decision-making.

• Explored patterns, distributions, correlations and trends within the dataset. Library Data Analysis

• Incorporated Comprehensive Library Report and Advanced Library Data Analysis using MY SQL.

• Incorporated clustered column charts, bar charts, control combo box & data analysis add-in to accomplished top products. LANGUAGES

English -Proficient (IELTS with score 6.5) Tamil -Native Kannada -Good Hindi -Good

PERSONAL ABILITIES

• Possess good analytical skills • Follow-up on assigned Task

• Honesty & Integrity • Job Knowledge

• Systematic Consciousness • Team building

• Positive thinking, self-motivated and confident • Good communication and organized way of working DECLARATION

I hereby declare that the above details are true to the best of my Knowledge and belief.

Contact this candidate