Learn Data Skills
Beta
Abhilash P

Abhilash P

Data Analyst

Tech-Mahindra Business Services

Technologies

My Portfolio Highlights

My New Course

Introduction to SQL

My New Course

Intermediate Python

Data Science Enthusiast: Turning Data into Insights and Impact, orchestrating the symphony of insights with precision.

My Work

Take a look at my latest work.

course

Introduction to SQL Server

course

Streamlined Data Ingestion with pandas

course

Introduction to Power BI

course

Data Visualization in Power BI

course

Data Preparation in Power BI

course

Introduction to SQL

course

Intermediate SQL

course

SQL for Joining Data

course

Introduction to Python

DataLab

Joining Data in SQL

DataLab

Intermediate SQL

DataLab

Investigating Netflix Movies and Guest Stars in The Office

DataLab

Course Notes: Intermediate SQL Server

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

Gosure Infoservices Pvt. Ltd., PUNE | Nov 2020 - Present

Data analyst

Domain: Electronics Retail & Supply, USA 1 1 / 2 0 2 0 - 0 5 / 2 0 2 2 Technologies: MS Excel, Power BI Desktop, Power BI Services, MY SQL. Client Description: Sells and supports printers, copiers, and multi-function devices. Provide office IT solutions such as computers, printing, networking, copying, office equipment, and supply needs. Specialize in providing administrative, marketing, operational, and sales support to firms and solo entrepreneurs. Achievements and responsibilities: • I led a project focused on optimizing our operations and increasing revenue by 19% while expanding our customer base. • I've crafted client-focused dashboards and reports utilizing BI technologies such as Power BI incorporating interactive reports, and spearheaded data flow improvement. • Proficiently used SQL to extract and transform extensive data from diverse sources, such as sales, customer, and inventory databases, to maintain data accuracy and consistency • Performed data integration and ETL & data transformations using Power Query Editor. • Created interactive visuals, including bar charts, line graphs, and slicers, to explore sales performance. • Conducted data transformations and calculated key performance metrics (Year-to-Date, Year-over-Year, Month-to-Date, Month-over-Month) • Conducted table operations such as joins, merges, and appends with multiple tables • Built Power BI dashboard to visualize core business KPIs(e.g. Monthly Recurring Revenue, sales by region, average monthly Logistics(shipping) costs, and cost per acquisition (CPA). • Utilized historical data to build predictive models, enabling us to forecast demand and optimize inventory levels. • Set up Row-Level Security (RLS) for datasets that rely on DirectQuery, for instance, SQL Server. Domain: HealthCare, Insurance, USA 0 8 / 2 0 2 1 - 1 0 / 2 0 2 3 Technologies: MS Excel, Power BI Desktop, Power BI Services, MY SQL, Python. Client Description: A frontrunner in comprehensive research and analysis procedures focused on unveiling pre-existing medical conditions and unreported healthcare in- terventions. Dedicated to delivering the utmost security, consistency, and high-quality information to the claims industry. Achievements and responsibilities: • Executed data transformations effectively by harnessing the capabilities of Power Query Editor. • Identify key performance indicators aligned with appropriate objectives. • Performed intricate table operations, encompassing joins, merges, and appends across multiple tables, facilitating an in-depth examination of claim trends, including the nature of claims and disputes related to claims. • Collaborated with cross-functional teams to define project objectives and deliver actionable insights. The finance team, contact center team, production team, and review team gather valuable insights aimed at reducing expenses and augmenting revenue. • Set up Row-Level Security (RLS) for datasets that rely on DirectQuery, for instance, SQL Server. • Conducted in-depth data analysis to identify trends, anomalies, and opportunities for improvement. • Effectively communicated technical insights to non-technical stakeholders, supported by my skill in crafting reports that feature KPIs, year-to-date (YTD), quarter-to-date (QTD), and month-to-date (MTD) data
Show More

Tech-Mahindra Business Services Pvt. Ltd. | Nov 2015 - Feb 2017

Retentions Officer

Resolved customer inquiries and concerns regarding bills and contracts, providing comprehensive assistance to renew phone or SIM contracts. • Acted as a Subject Matter Expert (SME) while addressing customer inquiries and resolving billing concerns, streamlining contract renewal processes • Proficiently managed the SIM and phone contract processes, including cancellations and upgrades, ensuring a seamless experience for customers • Maintained diligent follow-up procedures to ensure timely resolution of customer queries, enhancing overall satisfaction. • Achieved an outstanding upgrade percentage of 24%, demonstrating excellence in retaining customers. • Successfully minimized contract cancellations to less than 8%, contributing to higher customer retention rates.

Convergys India Services Pvt. Ltd. | Jan 2014 - May 2015

Customer Service Associate

Proficiently addressed customer inquiries pertaining to billing and various telecom services. • Demonstrated a proactive approach by consistently following up on procedures to expedite query resolution, resulting in the highest levels of customer satisfaction. • Gave input that frequently influenced the team's performance and outcomes. • Supervised and trained small teams to enhance KPI performance, while also guiding work effort

My Education

Take a look at my formal education

BSc in Computer ScienceKalinga University | 2020

About Me

Abhilash P

I am fascinated by the power of data to drive informed decision-making, solve complex problems, and create positive impact across various industries. With each project, I relish the opportunity to explore new challenges, apply innovative techniques.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free