| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
A junior data analyst having 1years of experience in data analysis, reporting and Presentation.Industry: Banking and Telecom Marketing AnalystEmail: EMAIL AVAILABLE Mobile: PHONE NUMBER AVAILABLEProfile SummaryDetail-oriented Data Analyst with 1 year of hands-on experience in SQL and Power BI. Proven ability to collect, analyze, and interpret large datasets to drive business decisions. Skilled in data visualization, dashboard creation, and report generation. Strong problem-solving skills and a dedicated team player.Key skillExcel Power BISQL PythonData Analysis and Reporting Data ModelingProfessional SummaryProficient in writing complex SQL queries, including joins (INNER, LEFT, RIGHT), subqueries, and aggregate functions (SUM, AVG, COUNT).Experienced in database design and management, including creating tables, defining relationships (primary keys, foreign keys), and ensuring data integrity through constraints.Skilled in data manipulation tasks such as INSERT, UPDATE, DELETE operations, and proficient in transaction management (BEGIN TRANSACTION, COMMIT, ROLLBACK).Familiar with performance optimization techniques, including index creation, query tuning, and analyzing execution plans.Developed and maintained stored procedures and functions for business logic implementation, enhancing database efficiency and reusability.Hands-on experience with database administration tasks, including backup and recovery procedures to ensure data reliability and availability.Proficient in using SQL Server Management Studio / MySQL Workbench / PostgreSQL pg Admin for database development and management tasks.Strong understanding of database normalization principles and their application in improving database design and performance.Implemented security measures such as user roles and permissions to safeguard sensitive data and ensure compliance with organizational policies.Collaborated with cross-functional teams to gather requirements, analyze data needs, and provide SQL-based solutions to business challenges.Proficient in developing interactive dashboards and reports using Power BI Desktop.Experienced in connecting Power BI to various data sources, including SQL databases, Excel files, and web services.Skilled in transforming complex data sets into visually appealing and easily understandable visualizations.Developed DAX queries and calculations to derive key metrics and KPIs for business analysis.Familiarity with data modeling concepts such as star schema and snowflake schema.Collaborated with stakeholders to gather requirements and deliver solutions that meet business needs.Successfully deployed Power BI reports to Power BI Service for sharing and collaboration.Continuously learning and exploring new features and capabilities of Power BI to enhance data visualization and analysis skills.Corporate ExperienceLoan Performance & Risk AnalystDhruv Technology & System Solutions, Bengaluru, India as a Data Analyst from 2020-2021.As a telecom marketing analyst using Excel, SQL, Python, and Power BI more focused on collecting, analyzing, and interpreting data to inform decision-making and improve the overall performance of the marketing department and the company.Responsibility Includes:Data Management: Collecting, organizing, and cleaning large data sets from various sources like CDR dump, Recharge and Activation Dump using SQL for data manipulation and Excel for data organization and analysis.Data Analysis: Analyzing data to identify trends, patterns, and insights related to customer usage behaviour both voice and data, market trends, and other important metrics.Reporting: Creating reports using Power BI to visualize data in the form of charts, graphs, and other interactive visualizations, making it easier for stakeholders to understand and interpret the results.Segmentation and Targeting: Segmenting customers based on their behavior and demographics, developing targeted marketing campaigns, and measuring the effectiveness of those campaigns.Customer Lifetime Value: Estimating customer lifetime value (CLV) to help the company understand the profitability of different customer segments and identify opportunities to improve customer retention and loyalty.Market Analysis: Conducting market research to identify opportunities and threats, analyzing the competition, and monitoring market trends.Collaborating with other departments: Collaborating with other departments, such as sales and product development, to ensure that the company's overall goals are being met and providing data-driven recommendations to inform decision-making.EducationMaster of Business Administration, from ASMIT, Sikkim Manipal University India.Bachlor of Arts from North Odisha University India. |
