Utsav Raj
Austin,USA
Summary
Analytical data professional prepared to deliver innovative data architecture solutions. Recognized for developing efficient data frameworks and enhancing data systems to drive business growth. Known for collaborative teamwork and adaptability to evolving project needs. Proficient in data modeling, database design, and data integration.
Overview
14
14
years of professional experience
1
1
Certification
Work History
DATA ARCHITECT
Consultant for ServiceNow, USA
03.2024 - Current
- Managed and optimized user analytics data pipelines in Azure Databricks by creating Delta tables, ensuring efficient processing of large-scale JSON files and loading the data in Snowflake
- Created interactive Power BI dashboards to visualize key insights and trends, facilitating data-driven decision-making for stakeholders
- Built and deployed a generative AI model using Databricks to automate the summarization of employee survey feedback, providing HR teams with actionable insights and trends for strategic decision-making.
- Developed a Proof of Concept (POC) for a knowledge graph leveraging Databricks, demonstrating the integration of diverse data sources to uncover hidden relationships and insights
DATA ARCHITECT
Consultant for Verra Mobility, USA
08.2023 - 02.2024
- Led the migration to cloud-based database solutions on AWS, ensuring seamless integration with existing systems which resulted in a reduction in infrastructure costs
- Engineered and optimized complex SQL queries and stored procedures, resulting in a 20% increase in database responsiveness and query execution speed, facilitating the transformation of PostgreSQL database data for the generation of customer-facing Power BI reports
DATA ENGINEER
Consultant for PayPal, USA
11.2019 - 07.2022
- Partnered with the GCP cloud team to migrate financial data and was involved in the solution evaluation phase by completing POC and pre-production releases using agile methodology; migration helped reduce spending in disaster recovery by 37%
- Collaborated with the data science team to develop a regression model for performing customer segmentation on small and medium businesses, which helped the sales team to optimize operating costs and increase
- Implemented Hive transformations using Spark and deployed ETL pipelines to develop Tableau dashboards that helped accounting users identify the reconciliation breaks early on and lowered the revenue loss by 1.2%
DATA ENGINEER
Consultant for Apple Inc., USA
01.2011 - 10.2019
- Spearheaded strategic projects and initiatives focused on assortment development, collaborating with cross-functional teams to define use cases, streamline business processes, and implement tools
- Redesigned Tableau dashboards to provide prorated billing and refund information to businesses for each partner; helped reconcile invoice/credit amount, leading to a reduction in users’ effort to reconcile the data by more than 50%
- Enhanced scripts utilizing Python libraries to reconcile inbound and outbound file discrepancies and established protocols for triggering production alerts in the event of data mismatches, resulting in a notable 20% reduction in application rework time
Education
Master of Science - Business Analytics
08.2023
Relevant Coursework: Data Visualization, Applied Statistical Methods, Optimization, Data Mining, Regression, Classification, Probability, Statistical Computing, Simulation Methods, A/B Testing, Hypothesis Testing, Data Wrangling, Time Series and Forecasting, Predictive Modeling, Optimization, ML-Ops, NLP
Bachelor of Technology - Mechanical Engineering
04.2010
Skills
- Programming Languages and Analytics Tools: SQL, Python (Pandas, NumPy), R, Tableau, Excel, Google Analytics
- Databases/Warehouses/Cloud: Oracle, PostgreSQL, Teradata, Hive, Google Big Query, Azure, Spark, Databricks
- Management Tools: Agile, Scrum, Project/Product Management, ServiceNow, Jira, Confluence
- Statistical Modeling: Regression, Trees, Random Forest, Gradient Boosting, KNN, K-Means, SVM
- Data Lake Management
- Machine Learning
- Generative AI
- API development
Certification
Databricks Data professional, GCP Associate Engineer, AWS Certified Cloud Practitioner, Teradata certified professional, Tableau Analyst, SnowPro Core, Azure AI Engineer, Databricks Certified ML Associate
Timeline
DATA ARCHITECT - Consultant for ServiceNow, USA
03.2024 - Current
DATA ARCHITECT - Consultant for Verra Mobility, USA
08.2023 - 02.2024
DATA ENGINEER - Consultant for PayPal, USA
11.2019 - 07.2022
DATA ENGINEER - Consultant for Apple Inc., USA
01.2011 - 10.2019
Cochin University of Science and Technology, School of Engineering - Bachelor of Technology, Mechanical Engineering
University of Cincinnati, Carl H. Lindner College of Business - Master of Science, Business Analytics
Similar Profiles
Kati PayneKati Payne
Product Owner, Sr Project Manager at Sogeti USA / Manager Consultant at GE AerospaceProduct Owner, Sr Project Manager at Sogeti USA / Manager Consultant at GE Aerospace
Guillermo PerezGuillermo Perez
International Brand Development at Boaonda / Vegtus (USA market lead and consultant)International Brand Development at Boaonda / Vegtus (USA market lead and consultant)
EMILY ABDNOUREMILY ABDNOUR
Senior Manager, Program Management – STEP EDU at SERVICENOWSenior Manager, Program Management – STEP EDU at SERVICENOW