Cycling, Running, Watching Movies, Travelling
Akshay Karnik
TEM Senior Data Analyst-Billing & Inventory Management
Pune
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills. Detail-oriented team player with strong organizational skills. Ability to handle multiple projects simultaneously with a high degree of accuracy. Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
3
3
Certifications
1
1
Language
Work History
Senior Data Analyst- Inventory Implementation
Sakon
Pune
03.2019 - Current
- Worked on Microsoft Power BI
- Developed 85% custom Microsoft Power BI dashboards, visualizations, and interfaces with Microsoft SSRS to deliver meaningful and actionable insights.
Delivered 100% assigned tasks within the agreed budget. - Data analysis, validation, maintenance and implementation of wireline Telecom inventory on portal across all global Telecom providers.
- Procure & manage client/vendor related information in the database and reconcile to Telecom inventory.
- Invoice analysis to identify missing data, discrepancies, and opportunities for cost savings.
- Responsible for delivering savings to clients via dispute management, service upgrade, deactivating unused lines, monthly invoice audits, arising from vendor/ client, and exception handling.
- Functioning Data analysis of billing invoices in MS-Excel, Validation, Management of clients with their specific requirements, and Implementation of wireline Telecom services in portal of global Telecom providers, Building CSR (customer service record).
- Research on service amount/ New Account/ Other inventory maintenance activities.
- Monitor SLAs (Service Level Agreements) which include billing accuracy, renewal terms, disconnect and vendor accounts/circuits audit.
- Interaction with clients and vendors for tracking of missing information critical to project completion.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
- Leveraged text, charts and graphs to communicate findings in understandable format
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action
- Generated standard and custom reports to provide insights into business performance
- Generated ad-hoc reports to evaluate specific business requirements
- Analyzed data to identify root causes of problems and recommend corrective actions
- Collaborated with stakeholders to identify business needs and data sources
- Developed customized reports, summarizing and presenting data in visually appealing format
- Optimized data access and storage to improve performance of analytics systems
Store Manager of Operations
Mahindra Logistics
Nashik
09.2017 - 06.2018
- Rotated manufacturer products.
- Supplied daily support to buyer and assistant buyer.
- Unloaded arriving product stock and moved to store display areas.
- Conducted inventory analysis to determine optimal stock levels.
- Maintained customer satisfaction with quick and professional handling of product returns.
- Handled Vendor Management System at Bosch.
- Looked after 12000 ‘Gauges’ and dealt with more than 10 vendors regarding movement of same.
- Maintaining statistical and financial records.
- Dealing with customer queries and complaints.
- Maximized sales and minimized shrinkage through excellent customer service and adherence to standard practices
- Reduced operational risks while organizing data to forecast performance trends
- Reported issues to higher management with great detail
- Reduced budgetary expenditures by effectively negotiating contracts for more advantageous terms
- Handled problematic customers and clients to assist lower-level employees and maintain excellent customer service
System Analyst
Shri Datta Devasthan Trust
Ahmednagar
10.2014 - 08.2016
- Used strong analytical and problem-solving skills to develop effective solutions for challenging situations.
- Designed Inventory module and Donation management module(DMS)
- Tested software for Bugs for ERP team and worked on proposed changes.
- Improved systems with addition of new features and infrastructure
- Investigated system issues and implemented resolutions to reduce downtime
- Collaborated with upper management to drive strategy and implement new processes
- Optimized core processes to improve business performance and operational agility
- Enhanced interfaces to promote better functionality for users
- Organized system operating procedures to strengthen controls
- Worked on Data Gathering , Compiling and Data Analysis.
- Assessed data modeling and statistics to integrate high-level business processes with data rules
- Conducted system analysis and implementation to maintain and improve computer systems
- Defined and documented scope of projects for distribution to team
- Resolved or escalated over 50 problem tickets to resolve user issues
- Established specifications and coordinated production with software programmers
Education
Diploma in Information Technology - Data Management Technology
Symbiosis Center For Distance Learning
Pune, India 07.2015 - 10.2017
Bachelor of Science - Computer Science And Programming
HPT Arts & RYK Science College
Nashik, India 07.2011 - 10.2014
Skills
Qualitative data analysis
Data collection and management
Data Gathering
Inventory management aptitude
Team Handling
Issue Resolution
Data Visualization
Certification
PL-300: Microsoft Power BI Data Analyst
Interests
Timeline
Senior Data Analyst- Inventory Implementation
Sakon
03.2019 - Current
Store Manager of Operations
Mahindra Logistics
09.2017 - 06.2018
Diploma in Information Technology - Data Management Technology
Symbiosis Center For Distance Learning
07.2015 - 10.2017
System Analyst
Shri Datta Devasthan Trust
10.2014 - 08.2016
Bachelor of Science - Computer Science And Programming
HPT Arts & RYK Science College
07.2011 - 10.2014