Data Analyst

Amar Raut

Data Analyst

**, *** ******** *****, ****** Hinganghat, India ************@*****.*** 935-***-**** linkedin.com/in/amar-raut2708 27/08/1994

Profile

Results-oriented Data Analyst with expertise in SQL, Power BI, and Excel, skilled in turning data into actionable insights. Strong in data- driven decision-making, business communication, and stakeholder collaboration. Known for critical thinking, attention to detail, and delivering accurate, automated reports and dashboards. Work Experience

Data Analyst

Etech Global Services

07/2020 – present Gandhinagar, India

•Perform advanced data analysis and reporting using SQL (joins, aggregations, subqueries, window functions) in SQL Server Management Studio (SSMS).

•Develop and maintain dynamic dashboards and data

visualizations in Power BI to support KPI tracking, executive summaries, and operational insights.

•Use Microsoft Excel (pivot tables, advanced formulas, charts, Power Query) for data transformation and reporting automation.

•Automated daily and weekly reports in Power BI, reducing manual reporting time by 40%.

•Apply statistical techniques (descriptive statistics, correlation analysis, trend analysis) to analyze large datasets and identify actionable patterns.

•Automate recurring reports and data validation checks using Power BI and Excel, improving efficiency and data accuracy.

•Prepare documentation and user guides for dashboards and self- service analytics solutions.

•Coordinate with data engineering teams for data access, schema understanding, and data structure validation.

•Create ETL jobs using Talend Tool to ingest, transform, aggregate, and resolve issues relating to supported applications.

•Identify, analyze, and interpret trends or patterns in complex data sets.

•Maintain, automate, and increase the efficiency of existing reports.

Skills

• SQL (Joins, Aggregations, Window

Functions)

• Data Visualization (Power BI)

• Basics of ETL Development (Talend)

• Basics of Python (Pandas, NumPy, Data

Cleaning)

• Data Modeling and Data Warehousing

• Advanced MS Excel, SSMS, Visual Studio

• Statistical Analysis, Reporting,

Dashboarding

Education

Bachelor of Engineering (B.E.) in

Information Technology

Datta Meghe Institute Of Engineering

Technology & Research - [DMIETR]

06/2012 – 06/2017 Wardha, India

Higher Secondary Certificate (HSC)

NMG Jr. College

06/2011 – 06/2012 Wadner, India

Secondary School Certificate (SSC)

NMG High School

06/2009 – 06/2010 Wadner, India

Sr. Executive

Vodafone Shared Services India (VSSI)

10/2018 – 01/2020 Ahmedabad, India

•Provided end-to-end back office support to front-line teams, enabling smooth and efficient customer service operations.

•Supported cross-functional teams by handling administrative, reporting, and operational tasks critical to day-to-day business processes.

•Played a key role in simplifying front office production workflows, ensuring timely escalation handling and resolution of process- related issues.

•Ensured data accuracy and process compliance by maintaining and updating operational records and reports.

•Collaborated with internal departments to streamline workflows and improve turnaround times for customer-facing functions.

•Assisted in documentation, performance tracking, and internal audits, contributing to operational transparency and governance.

•Participated in continuous process improvement initiatives, reducing inefficiencies and enhancing service quality. Customer Care Representative

Motif India Infotech

05/2017 – 05/2018 Ahmedabad, India

•Handled inbound and outbound customer calls, addressing queries, concerns, and service-related issues with a focus on customer satisfaction.

•Delivered prompt and effective resolutions to customer problems, ensuring first-call resolution and high service standards.

•Maintained accurate and detailed records of customer interactions, complaints, and feedback for process improvement.

•Communicated clearly and empathetically to resolve issues, contributing to positive customer experience and retention.

•Escalated unresolved issues to relevant departments, following up to ensure closure and customer satisfaction.

•Demonstrated strong problem-solving and communication skills in a fast-paced BPO environment.

Certificates

Excel for Business (LinkedIn Learning)

Data Integration & ETL with Talend OS (Udemy)

Languages

English

Marathi

Hindi

Projects

WT University & Support Projects

Role: Data Analyst Tools Used: SQL, Power BI,

Advanced Excel

Worked on U.S.-based WT University and

Support Projects, focused on managing

large volumes of client lead data. The

objective was to transform raw data into

structured, actionable datasets for business

operations and reporting.

•Performed data mapping and scrubbing

using SQL in SSMS to clean, validate, and

prepare leads for database upload.

•Loaded cleansed datasets into structured

relational databases, ensuring high data

quality and consistency.

•Created interactive Power BI dashboards

to visualize key metrics and support the

client support team with decision-making

tools.

•Collaborated with support teams to define

reporting requirements and build

operational and performance reports.

•Created financial dashboards that helped

leadership improve ROI tracking by 15%

Spectrum & Verizon Sales Projects

Role: Data Analyst Tools Used: SQL, SSMS,

Python, Power BI, Talend

Handled sales and lead data for telecom

clients Spectrum and Verizon, focusing on

data ingestion, transformation, reporting,

and pipeline automation.

•Retrieved data files via SFTP and executed

data mapping and scrubbing using SQL

queries in SSMS.

•Used Python (Pandas, NumPy) for data

transformation tasks like formatting,

cleaning, and deduplication before

inserting into the database.

•Designed interactive dashboards in Power

BI and Tableau for real-time tracking of

sales performance and financial metrics.

•Developed basic ETL jobs using Talend to

automate periodic data loading and

transformation.

•Ensured data integrity, accuracy, and

traceability throughout the ETL process.

•Cleaned and mapped lead data with 99%

accuracy, ensuring reliable insights for

sales teams.

Contact this candidate