Swapna R

Dedicated professional with experience in Business Process Outsourcing (U.S. Mortgage) and a strong interest in data-driven roles. Recently completed training in Power BI, MySQL, and Advanced Excel, with hands-on project experience in data visualization, database management, and reporting. Seeking to transition into a challenging role where I can apply my analytical mindset, process knowledge, and problem-solving skills to contribute to business insights and decision-making.

Tools covered: Power BI, MySQL, and advanced Excel key learning areas

• Power BI: data visualization, Power Query Editor, data modeling, DAX expressions, interactive dashboards
• MySQL: SQL commands (DDL, DML, DQL, DCL, TCL), data querying, joins, and subqueries
• Advanced Excel: Pivot Tables, VLOOKUP/XLOOKUP, data cleaning, conditional formatting, and charts

Projects undertaken

1. POWER BI :

a. Financial performance analysis

• Objective: Provide insights into an organization's financial health through visualizations of income statements, balance sheets, and cash flow analysis
• Data sources: Use sample financial datasets or create your own based on hypothetical data
• Key features: profit and loss charts, balance sheet summaries, and cash flow visualizations

b. Sales performance dashboard

• Objective: Analyze sales data to identify trends, top-performing products, regional performance, and potential areas for improvement
• Data sources: Use sample datasets, like the Microsoft sample dataset
• Key features: interactive charts, drill-down capabilities, and clear visualizations of key metrics like revenue, units sold, and profit margins

c. Marketing campaign analysis

• Objective: Evaluate the effectiveness of marketing campaigns by tracking key metrics like click-through rates, conversion rates, and return on investment (ROI)
• Data sources: Use data from marketing platforms like Google Analytics, or social media platforms
• Key features: interactive dashboards with visualizations of campaign performance, cost analysis, and ROI calculations

2. MySQL – customer data analysis designed and queried a database to extract insights from customer behavior data using advanced SQL joins and aggregate functions

• Built and normalized a relational database to store customer and order information
• Executed complex SQL queries to extract sales patterns, customer segmentation, and repeat purchase behavior
• Utilized INNER JOINs, LEFT JOINs, and nested subqueries to combine and analyze multi-table data
• Created summary tables and used GROUP BY with HAVING to identify top-performing customer segments

3. Excel – Expense Tracker and Summary Report developed an automated Excel tool for expense tracking using pivot tables, data validation, and conditional formatting

• Built dynamic dashboards with PivotTables, slicers, and timeline filters to summarize 50k+ rows of monthly data
• Cleaned raw CSVs using Power Query (merge, append, unpivot), and loaded them into the Excel Data Model
• Wrote nested formulas (e.g., XLOOKUP + FILTER + LET) to replace legacy INDEX/MATCH sheets cut lookup time 70 %.
• Automated repetitive tasks with recorded macros and introductory VBA, such as looping through workbooks and sending Outlook emails
• Applied advanced conditional formatting with formulas to flag anomalies and trending variances in real time
• Used dynamic array functions (SORT, UNIQUE, SEQUENCE) to create refresh-free reporting templates
• Leveraged Power Pivot to write DAX measures (YTD, rolling 3‑month, YOY %) for interactive reports.
• Protected workbooks and set data-validation rules to ensure clean user input for shared files
• Generated forecast charts with exponential smoothing and seasonality detection (Excel 365 'Forecast Sheet')

• Data Analysis & Visualization
• Business Intelligence
• Dashboard Reporting
• SQL & Database Management
• Data Cleaning & Transformation
• Excel Automation
• Decision Support Systems
• Process Optimization using Data
• Data-Driven Reporting
• Predictive Analytics (Beginner)

• Trained in Title Exam.
• Trained in Title commitment.
• Undergone training on current owner search
• Data analysis training for three months (Power BI, SQL, Advanced Excel)
• Power BI: data visualization, Power Query Editor, data modeling, DAX expressions, interactive dashboards
• MySQL: SQL commands (DDL, DML, DQL, DCL, TCL), data querying, joins, and subqueries
• Advanced Excel: Pivot Tables, VLOOKUP/XLOOKUP, data cleaning, conditional formatting, and charts

Date of birth: 08/12/1997

Passport number: Y6148373

Nationality: Indian

Mother tongue: Telugu

Languages known: English, Kannada, Telugu

Father's name: Raja Reddy K. A.

Marital status: Single