DIPESH RAJPAL
Database Analyst and Pricing Analyst
Tornto,Ontario
Summary
Prospective Analyst who strives to pose and answer questions with quantitative-driven insights. Through development of personal projects and a valuable internship. I have learned the importance of having an iterative, hypothesis-oriented approach to analysis. I am eager to leverage that approach at your esteemed organisation as an Analyst
Overview
6
6
years of professional experience
Work History
SKU Data Analyst and Pricing Analyst
good natured Products Inc.
Toronto, ON
01.2022 - Current
- Audited internal data and processes to identify and manage initiatives, improving business performance.
- Synthesized business intelligence or trend data to support recommendations for action.
- Worked with internal teams to understand business needs and changing strategies.
- Investigated and resolved variances with inventory records.
- Designed surveys, opinion polls and assessment tools to collect data.
- Developed new functions and applications to conduct analyses.
- Analyzed overall profitability and reviewed company and market information to make informed pricing decisions.
- Collected data and information from vendors, sub-contractors and teammates to determine exact costs for all aspects of each project.
Database Analyst
Next Supply
Toronto, ON
02.2021 - 05.2022
- Tested and modified databases to determine and correct issues.
- Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization.
- Performed quality assurance processes to support data warehouse improvements.
- Wrote scripts and processes for data integration and bug fixes.
- Defined database design specifications based upon project requirements.
- Interpreted complex technical information and translated into various forms of easily understandable and non-technical communications.
- Conducted audits on internal controls and developed reports on findings.
- Formed multidisciplinary audit team at planning stage to deliver quality audits.
Inventory Coordinator
Janome Canada
Toronto, ON
06.2019 - 01.2021
- Planned and executed audits in accordance with accepted standard operating procedures.
- Kept department records and updated documentation with latest counts.
- Researched and corrected discrepancies quickly to maintain current information.
- Submitted new purchase requests to maintain optimal levels and meet projected needs.
- Performed scheduled inventory counts and supply audits.
- Completed full department audits in adherence with company audit schedule.
- Conducted financial analysis and research to advise senior management on forecasting decisions.
- Applied mathematical skills to calculate totals, check figures, and correct problems with physical and digital files.
- Maintained records tracking adjustments, pallet audits and inventory errors.
- Implemented purchasing program to keep up with changing customer demands.
Data and Pricing Analyst
Shalit Foods Inc
01.2019 - 06.2019
- Pricing analysis.
- Generating the reports using ETL process.
- Defining Work Breakdown Structure (WBS) for different projects.
- Analyzed pricing and sales for business products.
- Collected data and information from vendors, sub-contractors and teammates to determine exact costs for all aspects of each project.
- Creating WBS Dictionary, assigning tasks and defining time required to complete the task.
- Defining project deliverables.
- Analyzed financial data to identify trends, patterns and strategies.
- Analyzed complex financial information to offer recommendations to management, driving decision-making.
Project Co-ordinator
Cargotec India Pvt. Ltd
07.2017 - 03.2018
- Coordinating project schedules, resources, equipment, and information.
- Liaising with clients to identify and define project requirements, scope, and objectives.
- Ensuring the client’s needs are met as the project evolves.
- Assessed, monitored and reported on work progression.
- Handled portfolio of initiatives to support organization's goals.
- Coordinated with department leads to identify and outline solutions to client-specified challenges.
Education
Project Management, Ontario Graduate Certificate -
Centennial College
04.2019
Bachelor of Engineering - Information technology
Thadomal Shahani Engineering College
06.2017
High School Diploma -
S. H. M Institute of Technology
Mumbai06.2014
Skills
- Report generation
- Technologically savvy
- System implementation
- Data evaluation
- Problem-solving abilities
- Process optimization
- Tableau
- Data warehousing
- Critical thinking
- MS Office
- Report Creation
- Time management
- Hadoop
- Lean Six Sigma
- Python
- Data management
- MS Excel
- Maintain Data Integrity
- Forecasting and planning
- SAP
- Business development support
- Microsoft Power BI
- SQL
- VBA Macro
- OLAP
Accomplishments
- During the internship, I designed a database for SFI to take the retail orders online. This helped SFI to eliminate the need of paperwork and streamline operations. SQL concepts such as relational tables, queries; are used to effectively execute the project.
- Water Locator android app developed that searches the water resources like Water Tankers, Water Containers, Government Water Taps that are available in the nearby areas. Used MySQL for storing details of water resources and retrieving details as a marker on the map.
- Attendance Tracking website designed using Twitter Bootstrap framework that ease the process of maintaining attendance. Used MySQL to store and retrieve monthly weekly attendance report. Used sessions in PHP to maintain the record of teachers and their classes.
- Performance Reward: April 2018 Recognition towards resolving business critical issues, handling multiple development projects and delivering them smoothly while maintaining the quality of work.
- Hackathon Jan 2017 Ranked in Top 10 Teams in ‘Hack for Change’ Hackathon conducted by InterTrust Technologies.
References
References Available Upon Request
Timeline
SKU Data Analyst and Pricing Analyst
good natured Products Inc.
01.2022 - Current
Database Analyst
Next Supply
02.2021 - 05.2022
Inventory Coordinator
Janome Canada
06.2019 - 01.2021
Data and Pricing Analyst
Shalit Foods Inc
01.2019 - 06.2019
Project Co-ordinator
Cargotec India Pvt. Ltd
07.2017 - 03.2018
Project Management, Ontario Graduate Certificate -
Centennial College
Bachelor of Engineering - Information technology
Thadomal Shahani Engineering College
High School Diploma -
S. H. M Institute of Technology