
Pavan K M
Data Analyst

Connect with Pavan K M to Send Message
Connect
Connect with Pavan K M to Send Message
ConnectTimeline
About me
BI Developer|Business/Data Analyst| Business/Data Analytics| Tableau |Excel Specialist| Salesforce Admin| Masters @ Northwest Missouri State University| Ex-Infoblox|Ex-Akamai
Education

Sri Bhagawan Mahaveer Jain College
2012 - 2014Master of Business Administration (M.B.A.) Finance and Marketing B+Activities and Societies: Team Management, Time Management, Operational research projects Pursued my PGDM in Marketing & Finance.

Northwest Missouri State University
2021 - 2022Master's degree Information Systems 4.0Enthusiast Student who is excited about problem-solving situations.
Experience

Destimoney Securities Pvt. Ltd
Sept 2013 - Nov 2013Data AnalystI have done my internship in this company. My project title is "Evolution of CNX Nifty sectorial indices.Evolution of CNX Nifty Sector Indices, Auto, Pharma,Energy, IT.

Northern Operating Services Pvt Ltd
Apr 2014 - Apr 2016Data Analyst• Acquired knowledge in Investment operations, particularly mandatory corporate action-related activities.• Managed data for collation and provision of MIS.• Followed documented procedures to ensure team compliance with industry regulations & best practices.• Learned how to manage multiple activities to meet deadlines.

Indegene
Apr 2016 - Jan 2018Data Analyst-Salesforce• Scheduled email campaigns on IT platforms and extracted reports weekly, bi-weekly & monthly• Interpreted & created email metrics dashboards in Excel & Insights360 web platform• Evaluated & created tele call plans and uploaded into Salesforce• Experience in working with google analytics• Modified SQL Queries for date extraction from multiple Databases with respect to client for report creation• Built Salesforce, MS Excel & Tableau dashboards to track the Campaigns & Tele marketing• Obtained multiple “Client Satisfaction” awards• Performed SOQL & Data upload into salesforce using import wizard & workbench• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com subjects. Used it to read, extract and load data from comma separated values (CSV) files• Worked with various Salesforce.com standard objects like Users, Contacts, Reports, Dashboards• Performed the roles of Salesforce.com Analyst & Administrator in the organization. Show less

Akamai Technologies
Jan 2018 - Aug 2019Business Analyst - Operations• Created measures & tracking of KPIs relevant to the business and suggested action plans for performance improvement.• Integrated & produced Salesforce Tableau dashboards on Services metrics with a data lake.• Published weekly & monthly reports with internal teams like Tech support, Client servicing group & product delivery teams• Scheduled meetings with internal stakeholders for reviewing business requirements.• Produced the productivity/utilizations performances at geography Level with business.• Led Tableau dashboard development projects from conception to completion, ensuring timely delivery and alignment with business objectives.• Automated data refresh schedules to ensure that Tableau dashboards always displayed the most up-to-date information.• Used Data Loader to insert, update, and bulk import on Salesforce.com• Developed, and managed various Custom Reports & report folders for different user profiles in the organization Show less

Infoblox
Sept 2019 - Apr 2021Data Reporting Analyst• Automated ETL (Extract, Transform, Load) processes using Python scripts to integrate data from multiple sources, ensuring seamless data flow.• Analyzed large datasets to uncover trends, patterns, and insights, using Python libraries like Pandas, NumPy, and SciPy.• Created interactive and static visualizations using Matplotlib, Seaborn, Plotly, and Bokeh to effectively communicate data insights to stakeholders. • Developed interactive dashboards and reports in Tableau, enabling stakeholders to gain actionable insights from complex datasets.• Produced ad-hoc reports and dashboards that supported data-driven decision-making processes across various departments.• Worked closely with data engineers and IT staff to ensure seamless data integration and consistent data quality. • Created dynamic & user-friendly dashboards with interactive filters, drill-downs, and calculated fields. • Delivered insights on sales trends, customer behavior, and operational performance through Tableau visualizations, aiding strategic planning. • Applied advanced Tableau features such as LOD (Level of Detail) expressions, table calculations, and parameter controls to deliver sophisticated data analyses.• Performed quarterly, half-yearly & annual business reviews. • Created Salesforce dashboards for the Business Development team for lead generations.• Performed data upload activities using workbench into Salesforce CRM objects like Account, Lead & Contact.• Managed data load & assignment activities in Salesforce. Automation of regular Excel reports to Tableau dashboards. Show less

Northwest Missouri State University
May 2022 - Jul 2022Graduate Teaching AssistantAssisted Professor in teaching following courses: - Professionalism in Summer 2022Responsibilities: Research on the current trends in the topics and help the instructor in acquiring new material. Help instructor in gathering and preparing course material (for new courses). Post materials in CANVAS in a timely manner. Respond to students’ queries posed verbally and electronically in a professional manner. Manage teaching assistants of the course. Keep track of student's attendance in all the events (regular classes, help sessions, assignments, quizzes and exams) related to the course curriculum.Send announcements to students related to the course assignments & Course material. Supervise other teaching assistants and conduct help sessions during evening hours. Conduct one on one personal help sessions for the students who need extra help. Summarize and recheck all the grades from graders. Maintain and update gradebook in the Northwest Online with appropriate feedback to students. Show less

Murata
Oct 2022 - nowBusiness Data Analyst• Created machine learning models on Dataiku utilizing recipes in flows • Extracted, transformed (Python) & developed data visualizations with PowerBI & Tableau tools.• Utilized Dataiku Data Science Studio (DSS) to design, develop, and deploy end-to-end data pipelines, enhancing data processing efficiency by 40%.• Deployed machine learning models from Dataiku to production environments, ensuring seamless integration with existing systems and applications.• Experience in writing SQL queries, DAX calculations & Power BI measures which are accurate and performant on large datasets.• Created PowerBI & Tableau reports on Salesforce objects (Accounts, Opportunities, Contacts & trips).• Implemented machine learning algorithms for customer segmentation, churn prediction, and sales forecasting.• Conducted time-series analysis to identify trends and seasonality patterns in sales and operational data.• Efficient in preprocessing data including Data cleaning, correlation analysis, Imputation, Visualization, Feature Scaling & Dimensionality Reduction techniques using Machine Learning platforms like Python Data Science Packages (Scikit-Learn, Pandas & NumPy)• Experience in data science process life cycle: Data Acquisition, Data Preparation, Modeling (Feature Engineering, Model Evaluation) & Deployment.• Designed and implemented Business Intelligence solutions, integrating data from multiple sources to provide a unified view of business performance. • Experience with configuration/management of Microsoft Power BI Services• Automated data collection and reporting processes, reducing manual effort and increasing efficiency by 40%.• Conducted root cause analysis for business problems, identifying key drivers and recommending actionable solutions.• Led data analysis projects from inception to completion, managing timelines, resources, and deliverables. Show less
Licenses & Certifications
- View certificate

Advanced Microsoft Power BI
LinkedInApr 2023 - View certificate

Getting Started with Power BI
LinkedInAug 2022 - View certificate

Power BI Essential Training (2020)
LinkedInMar 2023 - View certificate

Data Engineering Foundations
LinkedInJul 2022 - View certificate

Power BI Data Modeling with DAX
LinkedInMar 2023 - View certificate

Introduction to Data Science
LinkedInApr 2023 - View certificate

Learning SQL Programming
LinkedInJun 2019 
Microsoft Excel 2010 Expert
Microsoft Partner NetworkMay 2012
Tableau Desktop Qualified Associate Certification
EdurekaNov 2018- View certificate

Agile Foundations
LinkedInJul 2023
Languages
- enEnglish
- teTelugu
- hiHindi
- kaKannada
Recommendations

Akhona ndamase
Office Manager CEO's officeCity of Johannesburg, Gauteng, South Africa
Florian körner
Porsche Holding Group StrategySalzburg, Salzburg, Austria
Mageshwaran gurumoorthy
Automotive EnthusiastChennai, Tamil Nadu, India
Danai leousi
Senior People Care Partner at Nokia| Assoc CIPD| MSc HR Management & BusinessGreece
Guillaume bédat
Managing Partner @ Welcome Service | Relocation & Immigration throughout SwitzerlandGeneva, Geneva, Switzerland
Hans fendt
Former Corporate Utilities Technical Lead, passionate for technical staff training and data science ...Miranda State, Venezuela
Gustavo lópez martínez
Director en Digital Technology Consulting en EYGreater Barcelona Metropolitan Area
Zahira decena sanchez
Public Health InternRaleigh, North Carolina, United States
Akshvin uthesh
Data Science EnthusiastDubai, United Arab Emirates
Mahmoud shoeib
Construction Engineerمصر
Jesse lin, pt, dpt
Physical TherapistLexington, Massachusetts, United States
Ghadah mohammed
🚀 Adam Studio: Mastering Metaverse Realms with 3D Modeling & VR Expertise 💡 Pioneering Commercial ...القاهرة القاهرة مصر
Cindy bevis
Wow!Mount Vernon, Illinois, United States
Peiter hardy
WGH Senior Purchasing Officer/Fleet Manager and Proprietor of Garfield House CoffeeGarfield North, Victoria, Australia
Jon matthews
Oceania System Security ManagerWellington, Wellington, New Zealand
Matthew sinclair
Program Manager at Intercare Therapy, Inc.Crestline, California, United States
Katlyn canning, phr
HR Manager at Northaven Development GroupPerrysburg, Ohio, United States
Tahrin ahmed
Human Resources Executive | Technical Recruiter | Recruitment Specialist |Employee Engagement | Empl...Dhaka, Bangladesh
Rachel malabanan
Sales Admin / Coordinator at Easy World Automation LLCDubai, United Arab Emirates
Austin haase, cmcp
VP, Mortgage Credit Administration at Claremont Savings BankLebanon, New Hampshire, United States
...