Data Analyst

Sivagami Murugesan **********@*****.*** Carlsbad, CA 92011 Data Analyst www.linkedin.com/in/s4788

https://sivagami-murugesan.github.io/sivagami.github.io/

PROFESSIONAL SUMMARY

Data Research Analyst with 1 year of professional experience in SQL, SSIS, and Collibra. Volunteer experience in Data analysis using Python, Tableau, SQL, etc. Google Certified Data analyst with experience in data cleaning, processing, analyzing, and visualizing data using SQL, Python, R, and Tableau. I have 4+ years, of professional experience in banking and volunteer experience in financial analysis. I leverage strong analytical skills and keen attention to detail to facilitate management decision-making and increase company revenue.

SKILLS

SQL (Big Query, MSSQL, MySQL) SSIS/Visual Studio Collibra Salesforce

Tableau/PowerBI Python/R Financial Modeling Data Entry (46 WPM)

Excel/Google Sheets (Pivot table, VLOOKUP, sum if, etc.) QuickBooks/Accounting

PROJECTS/VOLUNTEER EXPERIENCE

Village Libraries Volunteer Project

Analyzed the factors affecting student attendance in the mentorship program using Tableau/Python

Used data analytics tools to build new dashboards and reports

Portfolio project: sivagami-murugesan.github.io/Village Library case study at main · sivagami-murugesan/sivagami-murugesan.github.io

British Airways Data Science Job Simulation

Web scraping using Python to gain company insights Predicting customer buying behavior.

Project: sivagami-murugesan.github.io/BA_Task1.ipynb at BA_Python · sivagami-murugesan/sivagami-murugesan.github.io.

Developed business insights and made a PowerPoint presentation.

Google Data Analytics Certificate

Created a Portfolio project by following the six steps of Data analysis: Ask, Prepare, Process, Analyze, Share, and Act.

Utilized SQL (Big Query), R, Python, and Tableau to process, analyze, and visualize data.

Portfolio project: https://sivagami-murugesan.github.io/sivagami.github.io/

StartSmallThinkBig Volunteer Project (Remote)

Oakland, CA, United States

Financial Projection and Analysis project for a kid’s indoor play area business.

Analyzed and forecasted financial statements, complete revenue and cost analysis, and other basic finance reporting including P&L, gross margin, and profitability in Excel.

Communicated findings and insights to stakeholders and provided possible solution options for finance decisions.

Delivered complex analysis/findings in a manner that conveys understanding, garners support for recommendation, and lays the foundation for data-driven Finance decisions for operational management.

Taproot plus Volunteer Project (Remote)

Mansfield, Texas, United States

Financial Analysis and Reporting Project for a Non-Profit Organization.

Built a new financial model with financial statement projection and analysis, Budget, cash flow projections, Ratio analysis, graphs, and dashboard to aid in management decision-making.

Developed an automation process using Excel for the KPI reporting, increasing accuracy and attracting more grants.

Produced actionable reports that show financial trends, risk analysis, performance to budget, and other relevant analyses requested by the management.

Financial Modeling and Equity Valuation Project/Course (Remote)

Hyderabad, India

Developed and presented the Company profile of a publicly traded company.

Performed comprehensive range of valuation analysis- three statement model, comparable company analysis, precedent transaction analysis, DCF analysis, Ratio Analysis, sensitivity analysis in Excel using VLOOKUP, Macros, etc. for the company.

Collected, aggregated, and analyzed data from multiple internal and external sources to drive insights into Finance performance.

Project:https://github.com/sivagami-murugesan/sivagami-murugesan.github.io/blob/main/MSFT.xlsm

EXPERIENCE

Mar 2023 – Apr 2024 Data Research Analyst

Axos Bank, San Diego, CA, USA

Troubleshooted technical issues and provided accurate RCA (‘Root cause analyses’) for SQL production job failure/bug.

Implemented Collibra, a data governance platform – Data Catalog, Data dictionary, Technical and Report Lineage.

User account management in Salesforce – account modification/update, assigning permissions, etc.

Documented and trained new employees in doing RCA, monitoring jobs, and Collibra

Agile/Scrum methodology

Aug 2016 - Apr 2018 Bank Teller

Canara Bank Ltd, Bengaluru, India

Achieved 100% accuracy throughout almost one year of cash drawer audit.

Administered all transaction services including high-profile customer’s forex transactions, loan openings, bank deposits, monetary withdrawals, financial transfers, and other bank transactions with 100% accuracy.

Jul 2012 - Apr 2015 Bank Officer

City Union Bank Pvt Ltd, India

I headed a team for the branch’s rights issue of bank shares.

Executed 400+ daily transactions involving cash deposits and withdrawals, cheque clearing, and bank deposits with 100% accuracy.

Recommended bank products that met customers’ needs to increase sales by 8%.

EDUCATION

MBA (Finance)

Thiagarajar School of Management, India

Bachelor of Engineering

National Engineering College, India

Contact this candidate