About
- Birthday: June 7, 1995
- Website: ynpreet.github.io
- Phone: +18577019272
- City: Boston, USA
- Age: 26
- Degree: Master in Data Analytics Engineering
- Email: ynpreetmehta1995@gmail.com
- Full-time Job: Actively Seeking
Happy Clients consequuntur quae
Projects Delivered End-to-End BI Solutions and Delivery
Years of experience Worked with 4 Organizations
Awards & Certifications LookML Developer Certified, Won 2 Hackathons, & Best Employee Award
Revenue Generated LookML Developer Certified, Won 2 Hackathons, & Best Employee Award
Services
Key deliverables
Hello
Conduct discovery workshops to understand Customer’s current reporting and data strategy, desired analytics landscape, and gather detailed requirements
Create technical design document outlining proposed BI architecture
Build interactive dashboards to achieve success criteria utilizing best practices
Conduct user acceptance testing and knowledge transfer along with providing final handoff with relevant documentation
Outcomes
Developed production-ready data models and visualizations in the BI tool making self-service feasible within 30 days of project kick off
Eliminated need to hire more analysts & BI Developer to support 1,000’s of product stakeholders by transitioning to self service
Transformation to data-driven culture across product, fully leveraging user behavior data to make improved product decisions with significant risk reduction
Configured Bigquery & Looker for optimal performance leading to migration of all data workloads on GCP
What most clients like about me?
Out of the box ideas and approach in making their teams data literate
Being a person who can be turned to for expert knowledge, BI solutions, or reliable performance, especially in a crucial situation
Monitoring data quality
Generating and delivering quality reports to customers and performing quality assurance checks on reports.
Evaluating BI software
Evaluating and improving existing BI systems and Conducting troubleshooting on BI models.
Writing relational and multidimensional database queries.
Allow users to ask analytical questions related to business or market trends.
Use Data warehouse for big data
Using warehouse data to generate reports to support business decision making and business performance monitoring.
Helping companies become data-driven organizations
Searce Inc.
was delivered solely by using Looker as a BI tool
Air Asia
Built Looker dashboard for Customer Analytics
and Fare Prediction
Arcus Finance
Built Looker dashboard to track transaction patterns across countries
Bajaj Finance Healthcare
Built Looker dashboard to study coorelation between symptoms and hospitals across cities
Bajaj Finance Healthcare
Built Looker dashboard to analyze Jwellery sales across North America
EPL Global
Designed dashboards in Power BI to analyze real time machine parameters data
Imagination Media
Designed dashboards in Tableau to analyze employees efforts hours and profits generated
Platform Science
Designed dashboards in Looker to monitor logistics across globe
Pulse Point
Provided solution support to track cost at user level in Big Query
Servify
Provided Business Intelligence solutions and provided workshop on Superset tool
TRM Labs
Built Looker dashboard to track various KPIs to measure Churn & Retention
Portfolio
I’ve gone through a number of phases in my career, and each of them has informed my current work ethos and philosophy. I have excelled in a number of data domain roles in diverse industries, and believe that my number one asset is my ability to adapt to any challenge that is thrown my way.
- All
- Machine Learning
- Data Management
- Data Visualization
- Certificates & Awards
Resume
Download CVSumary
Preet Mehta
A passionate Business Intelligence Developer (Looker certified LookML Developer) having 5+ years of professional and technical experience in using warehouse data to solve organizational problems through reports, analysis, and data visualization for decision-making resulting into $5M cost savings
- Currently pursuing Masters in Data Analytics Engineering from Northeastern University, Boston.
- I completed my Bachelor of Technology in Mechanical engineering from Nirma University in May, 2017.
- I have worked in areas like data analysis, data visualization, statistical analysis, machine learning pipeline, natural language processing, deployment. I am detail oriented team player with fluent communication skills.
- I am inquisitive towards the latest technologies in machine learning and data science, Seeking a job where he can enrich his knowledge and contribute to the ML community.
Education
Master of Science (MS) in Data Analytics
2021 - 2023
Northeastern University, Boston
Grade:4.0/4.0
Relevant Coursework: Datawarehouse & Business Intelligence, Data Mining, Data Management for Analytics, Computation & Visualization, Engineering Probability & Statistics
Bachelor of Mechanical Engineering
2010 - 2014
Institute of Technology, Nirma University, Ahmedabad
Grade: 3.1/4.0
Relevant Coursework: OOP, Data Structures, Algorithms, Computer Networks, Operating Systems, Database Management, Computer Architecture, Mathematics
Professional Experience
Analyst, Sales Operations
May 2022 - Present
Linkedin, Chicago, IL
- Scope and deliver strategic projects with agility, such as BI Dashboards and Foundational Datasets, for our leadership that provide key business insights for high-priority initiatives with different cross-functional stakeholders across Sales Operations, Sales, Acquisition Ops, Sales Development, and Marketing
- Support data intensive workstreams for x-functional transformation programs (systems and tool migrations), such co-owning and migrating the foundational datasets for existing dashboards
- Develop predictive analytics by leveraging statistical models
- Conduct in-depth analysis of our various businesses and develop deep understanding of key value drivers to identify improvement areas and opportunities
- Identify, diagnose and resolve data issues; perform data validation and update data mappings to summarize issues to the cross-functional partners and the leadership team to ensure data accuracy
- Build and manage operational dashboards to monitor business line performance and analyze business drivers
Graduate Teaching Assistant
Jan 2022-Present
Northeastern University, Boston
- Organizing hackathon for students and framed tasks for data cleansing, feature selection and building and deploying ML models.
- Designed assignments and exams for students focusing on ML and Data Science methods
Business Intelligence Developer
May 2021-Aug 2021
Searce Inc., Mumbai, India
- Handled consulting services to 20+ clients for business intelligence (BI) solutions such as proposing replicable and scalable data pipeline along with designing dashboards through BI tools using Tableau, and Looker, and achieved 10% increase in the revenue.
- Headed a team of 5 BI engineers and fostered 8 analytical dashboard projects to research, develop and deliver big data solutions, from concept to design and implementation.
- Conducted solution workshops for 19 overseas Fintech, Utilities, and Healthcare clients to demo Tableau, Power BI, and Looker for assessments of analytical tools and offerings and saved almost $1.7 million to the clients.
Supply Chain Analyst
Jun 2019-Mar 2021
DCM Shriram Ltd., India
- Administered the flow of products between the distribution center, inventory, and logistic departments by data gathering, data modeling, monitoring supply chain KPIs in Tableau, and communicating recommendations to the stakeholders.
- Awarded twice by the senior management for improving overall vehicle Turn Around Time by 18% and operational efficiency by 15%.
- Executed Descriptive Statistical techniques like Box and Whisker Plots, Histograms, and ANOVA on SAP 20M+ records of vehicle movement using MySQL and Minitab to investigate pain points within the process and develop solutions to resolve conflicts.
Data Analyst
Jun 2017-Jun 2019
DCM Shriram Ltd., India
- Facilitated analytical support to CXOs for monitoring scope, budget, and procurement KPIs of 5 cross-functional construction projects by sharing weekly MIS reports in Power BI.
- Collaborated with stakeholders and partners of 7 enterprise-wide divisions in defining and documenting single source of truth to ensure data consistency and discussed critical paths which support business goals.
Skills
Testimonials
Magnam dolores commodi suscipit. Necessitatibus eius consequatur ex aliquid fuga eum quidem. Sit sint consectetur velit. Quisquam quos quisquam cupiditate. Et nemo qui impedit suscipit alias ea. Quia fugiat sit in iste officiis commodi quidem hic quas.
Over the months after Preet became Looker certified Lookml Developer. As a business colleague, I had the privilege to take part in sharing how Preet worked with 30+ overseas clients to deliver end-to-end Business Intelligence solutions using Looker. He has always been such a valuable resource for all the clients we worked alongside. He is confident, dependable, and creative. If you want to design robust models, debug LookML code and build user-friendly Explores, I highly recommend Preet. It has always been great working with him, and I wish him audacious success in his future!
April Healy
Partner Manager, Google
I have known Preet since 2021 when he collaborated on one of our projects in Arcus Finance as a Looker Developer. The first time I met Preet, it was immediately apparent we would get along. I could tell he was going to be a productive team member and he proved it. In under a month, he was able to understand the goal of our fintech dashboard, documented it, made a prototype, choose the effective chart, gathered the feedback and reiterate it in Looker. He also provided a demo to our entire Arcus team which helped us in understanding Looker. He has an excellent ability to understand business and technology. He is a diligent learner, always actively participated, and has an enthusiasm for learning. I highly recommend Preet if you 'need a Looker guy to get your dashboard!' He is a team player who loves solving problems. He will be an asset to any organization that requires a passionate and talented member of its team. Wishing him all the best in his future endeavors.
Esaú Reyes
Sr. Data Engineer, Arcus Finance
I have known Preet since 2018. He is a productive team member. As his immediate supervisor, I am happy to recommend his deep understanding of data mining skills. He is one of the most dedicated professionals I’ve worked with and is willing to put that extra help whenever you need it. His expertise in data mining is considerable, and it helped our team come up with more efficient solutions on different projects He is a diligent learner, highly passionate, and self-motivated go-getter who gets things done. Preet will be a valuable asset for any organization. Wishing him all the best in his future endeavors.
Samrat Khanorkar
PMO Lead, DCM Shriram Ltd.
Preet has worked under me during his internship in Ford Motor Company at the Sanand Facility... To me Preet came across as an enthusiastic learner who grasped subjects with ease...He got along with the fellow team members well...At the end of his internship l, he picked up the Ford Processes concerning his project and contributed as per expectations
Vaibhav Talsania
Sr. Engineer, Ford Motor Company
Two key things you would notice about Preet are his clarity of vision and the ability to bring that vision into reality. I got acquainted with him in 2014. Five years ago, he first approached me to enquire about social clubs in Nirma University. He wished to start a social support activity club and gathered his friends and other like-minded students. What sets him apart from others in his batch are his positive attitude, creative thinking, and enthusiasm. This persuaded me to help and guide him in his venture. He initiated YOU-NEED in 2015. Just like initiating something is difficult, running it successfully too is a tough job. But, he was up for it. With his effective communication skills, he skillfully and clearly puts forth his ideas. His clarity of vision and ability to communicate that vision to his peers helped him gain the trust of his team-mates. A versatile individual is what we can definitely describe Preet as. Also, his ability and dedication to complete the assigned tasks are unparalleled. He multitasks effectively and can handle a high volume of workload. I was able to see this when he very calmly juggled his academic proficiency, his NGO work, and his work in the SAE Baja Team. I am extremely proud of his achievements and wish to see him scale new heights in his career.
Dr. Jignesh Patel
CEO, Informatic Solutions
Preet has worked in BAJA alumni committee (2017-18). He came across as a confident individual with sharp managerial skills. Wish him all the very best for his future endeavors and I hope he continues to benefit the society.
Dr. K C Vora
Former Sr Dy Director, ARAI
Preet has worked in BAJA alumni committee (2017-18). He came across as a confident individual with sharp managerial skills. Wish him all the very best for his future endeavors and I hope he continues to benefit the society.
Havish Madhvapaty
Havish M Consulting, Founder
Preet and I had collaborated on a course project to design an OLTP database for sales operations of an e-commerce site. The project was well received by the audience and it was commended for its intricacy and exhaustive approach. I would highly recommend Preet for skills like data modeling, SQL, Postgre SQL, and Python alongside being a good team player. He is an enterprising individual and always on the lookout for innovative approaches. His critical thinking ability is commendable.
Meghana Morey
BI Engineer, Dell
Preet Mehta is a dynamic personality. I have worked with Preet for almost four years on various projects and it was a journey of great learning and determination. Preet was senior to me when I was a new member at Team stallions that represents Nirma University at the National level. Preet used to manage so many functions in the team ranging from steering system design and testing to Sponsorship, treasury, and budgeting for the team. These are the efforts that have contributed to the team's success. The most important thing that Preet believes in giving back to the society, he has started an NGO in Ahmedabad to give back to the society, he started a club with like-minded alumni to help the graduating students groom and become ready for the placements and grab opportunities in front of them. He is still working for his first love, The Team stallions, and believes in the team vision and mission of ONE TEAM ONE DREAM. Preet inspires to share the privileges we have and work to the fullest capacity and never forget your roots. I wish him all the best in whatever he aspires to do next. All the best!
Jay Aliwala
Engineer, FCA Fiat Chrysler Automobiles
Contact
Data is only as useful as your ability to understand it correctly, and a team that understands data makes better data-driven decisions. I can help in selecting the right tool and build solutions for data interpretation. Let's get in touch!
Location:
50 Evergreen St, Boston, MA 02130
Email:
ynpreetmehta1995@gmail.com
Call:
+1 857 701 9272