PRADEEP SEKAR
Data Analyst
Pakenham,VIC
Summary
Dedicated Operations Analyst professional with history of meeting company goals utilizing consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
11
11
years of professional experience
Work History
Data Analyst
A&L Windows and Doors
Dandenong South, VIC
05.2021 - Current
- Identified and documented detailed business rules and use cases based on requirements analysis.
- Proactively design, measure, and continuously improve key operational, safety metrics and reporting capability
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
- Identify opportunities to improve efficiency and quality of existing processes
- Building dashboards with key focus on identifying bottlenecks through Trends and Pattern
- Reporting missed opportunities to business and engaging key stakeholders to initiate projects to eliminate waste
- Subject matter expert in various internal and SAP Processes
- Analysis and reporting of performance – develop automated reporting formats
- Managing various business critical projects to eliminate waste and improve efficiency
- Liaise with the Operations, Sales, and Customer Teams to understand & translate data requirements into valuable reports
- Assisting finance team in ensuring accrued revenue are within agreed targets
- Implement various measures for data integrity, security, and governance
- Managed to contribute saving of $230,000 through couple of projects
- Educating peers on Advanced Excel, Power BI and Tableau
After Sales Team Leader
A&L Windows and Doors
Dandenong South, VIC
02.2020 - 04.2021
- Leading and mentoring team size of 19 with primary focus on Customer Service and Experience
- Monitoring team’s performance everyday and ensuring their KPI’s are met
- Identify, analyse and interpret trends of patterns in complex data sets relating to warranty claims
- Part of Senior Leadership team headed by General Manager in sharing weekly performance dashboard, green/ref flags followed by action items
- Health and Safety Representative for any ongoing incident or hazards relating to Sales and After
- Sales teams
- Training and Coaching Customer Service Representatives on various processes and procedures
- Managing incidents relating to SAP and educating users on functionalities
- Effectively handling customer reviews on Google and Product Review page
- Working more on the business rather in the Business
- Closely working with Operational Departments to improve processes continuously
- Leading & Mentoring Reception team and understanding to remove bottlenecks in their processes
- Key role in Ecommerce projects involving Virtual Showroom, Online parts and Screens ordering and DIY videos for customers
- Handling customer escalations and complaints in a timely manner to ensure customer’s issues are being resolved
- Meeting Key Account customers and taking onboard constructive feedback for areas of improvement.
Service Lead
A&L Windows and Doors
Dandenong South, VIC
04.2017 - 01.2020
- Leading a team of 6 Customer Service Representatives involved in managing Ongoing Warranty issues
- Suggested and Implemented new materials which resolved huge scheduling issues
- Oversee and provide solutions to issues arising between process and systems
- Reporting on teams every week to ensure their efficiency is in line with KPI’s
- Reducing and sustaining overtime to 15% from 23%
- Coordinate with all stakeholders for any process improvement and train them accordingly
- Identifying and training Queensland team departments on Victorian SAP landscape
- Part of the team in resolving huge backlog of more than 3000 open orders in the system
- Running DIFOT project effectively and efficiently with all relevant stakeholders and ensured
- DIFOT is more than 95%
- Problem solving skills to manage issues within Order to Cash process
- A lot of small projects have been identified and solutions implemented successfully inline with Six Sigma Practices.
Customer Service Representative
Toll People, L Windows and Doors
Dandenong
08.2016 - 03.2017
- Dandenong South, VIC
- Investigating and actioning customers warranty requests within 48 hours
- Ensuring customer escalations are handled with rebuttals and provide solution as well
- Data entry of Customers requirements and updating status of the outstanding jobs
- Answering phone calls and responding to emails within 8 hours
- Updating internal and external teams on key account customers status.
Supply Chain Trainer
Techtronic’s Private Limited
Chennai
11.2015 - 03.2016
- Conduct SAP supply chain training on modules including MM, SD, PP, SRM and EHS for end users
- Prepare training materials for various supply chain related workshops
- Elaborative training on configuring document types relating to Purchasing, master data, material valuation, release strategies, inventory management and invoicing
- Highlighting each focus areas on Material Management with live project examples
- Evaluating user's knowledge consistently to identify and change the training content if required
- Coordinate with pre-sales team for SAP demonstrations in line with supply chain
- Providing functional support for Short term projects.
SAP Team Lead
TECH MAHINDRA GmbH
, NRW
12.2011 - 09.2015
- Leading the teams from BASF Ludwigshafen plant on issues relating to MM & EHS modules
- Expertise in P2P (Procure to Pay), Master Data, Inventory Management, Outline Agreements,
- Product Safety & Dangerous Goods
- Coordinate with BASF SMEs and Process Owners to collect and analyse project requirements pertaining to procurement and EHS
- Supported and provided solutions to eradicate frequently occurring incidents relating to supply chain
- Developed and implemented automation of master data including Material, Vendor Customer and BOM (Bill of Material)
SAP MM Implementation Consultant
Tech Mahindra SDB
Chennai
02.2011 - 12.2011
- SAP MM Implementation, Mapping of Organizational Structure of Company, Customizing
- Purchasing Organization, Plant, and Storage Location
- Configuring Material Master, Material type, Number Range Assignment, Vendor Master and
- Partner Determination
- Responsible for configuring Purchasing, Pricing Procedure, Release Procedure, Material
- Valuation and Output Determination
- Processing of transfer postings and special stocks in Inventory Management like sub- contracting, third-party and vendor consignment
- Maintained plant parameters for Materials Requirement Planning (MRP) such as MRP groups,
- MRP controller, MRP types, planning calendar, planning horizon, lot-sizing procedure, and availability check for components
- Worked with other SAP functional and technical consultants to bring out best solutions for unexpected issues during testing
- Since the end users were not exposed to SAP, the end user training was formulated in such a manner so that they could get introduced to SAP and work effectively
- Developed webinars to instruct and educate users to fulfil their day-to-day activities
- Educated the Power users in the integration of systems where the data dependency was active.
Education
SAP S/4 Hana - Simple Logistics Overview Open SAP -
SAP Germany SE & Co. KG (WDF21) - Walldorf, BW SAP Certified Application Associate -Supplier Relationship Management with SRM 7.0 SAP AG, Germany - undefined
SAP Germany SE & Co. KG (WDF21) - Walldorf, BW SAP Certified Application Associate - Procurement with SAP ERP 6.0 EHP4 SAP AG, Germany. - undefined
SAP Germany SE & Co. KG (WDF21) - undefined
Postgraduate Diploma - Management, International Business & Management
Singapore Institute of Commerce
Bachelor of Computer Applications - undefined
University of Madras
Skills
Data formatting
Business needs analysis
Data analysis
Project Management
Storyteller
Creative problem solving
Continuous Improvement
Report automation
Gap analysis
POWER BI
Excel
Tableau
SAP
Presentation
SQL
Accomplishments
- Awarded the Pat on Back by BASF client for excellence in removing bottlenecks for end users leading up to significant savings.
- Modified and improved existing databases to reduce processing time by consolidating data sets for ease of access
- Achieved multiple internal promotions by executing various projects yielding great efficiency and savings
- Collaborated with various teams in the development of Service DIFOT (57 % to 95%) using Six Sigma methodologies
- Supervised team of 22 staff members working over various functionalities of the business
- SAP Certified consultant in Material and Supplier Relationship management
Timeline
Data Analyst
A&L Windows and Doors
05.2021 - Current
After Sales Team Leader
A&L Windows and Doors
02.2020 - 04.2021
Service Lead
A&L Windows and Doors
04.2017 - 01.2020
Customer Service Representative
Toll People, L Windows and Doors
08.2016 - 03.2017
Supply Chain Trainer
Techtronic’s Private Limited
11.2015 - 03.2016
SAP Team Lead
TECH MAHINDRA GmbH
12.2011 - 09.2015
SAP MM Implementation Consultant
Tech Mahindra SDB
02.2011 - 12.2011
SAP S/4 Hana - Simple Logistics Overview Open SAP -
SAP Germany SE & Co. KG (WDF21) - Walldorf, BW SAP Certified Application Associate -Supplier Relationship Management with SRM 7.0 SAP AG, Germany - undefined
SAP Germany SE & Co. KG (WDF21) - Walldorf, BW SAP Certified Application Associate - Procurement with SAP ERP 6.0 EHP4 SAP AG, Germany. - undefined
SAP Germany SE & Co. KG (WDF21) - undefined
Postgraduate Diploma - Management, International Business & Management
Singapore Institute of Commerce
Bachelor of Computer Applications - undefined
University of Madras