UTSAV MEHTA

Working at Sprint
Studying at UT DALLAS
Living in United States

About

I can guide your DATA to build your DECISIONS ?.

A skillful and passionate Data Analyst pursuing masters in INFORMATION TECHNOLOGY & MANAGEMENT.

TECHNICAL SKILLS
Analytical Tools: Tableau, SAS EM, Power BI, SAP Business Objects, Crystal Reports, SAP Lumira, SAP Analysis for Office, Advance Excel, SAP BEx Query Designer
Software’s: Toad, Nexus Query Chameleon, SAP NetWeaver, Netezza, SSIS, MS Project, JIRA, Kanban
Programming Languages: SQL, Apache Hive – HQL, HTML, CSS
Database: Big Data Environment – Hadoop System, SAP S/4 HANA, Microsoft SQL Server, RDBMS, IBM Netezza

BUSINESS EXPERIENCE

CHARLES SCHWAB & CO
-Digital Services Analyst Intern - Analytics Business Insights
Queried approx. 1M data loaded into the Big Data Environment from Adobe Analytics Database with the help of Apache Hive - HQL scripting in Nexus Query Chameleon replicating the Adobe Data Structure.
Converted HQL scripts to SQL and used Custom SQL Editor of Tableau to build 6 insightful Dashboards gaining 97% efficient results.
Automated these Web Analytics Dashboards with the help of UNIX and Report Tracker, which ran through manual intervention before, saving 87% of the time and saving approximately $2.5M.

TATA CONSULTANCY SERVICES.
-SQL Analyst – Bank of Montreal
Developed ETL Mappings using Netezza SQL to extract the data from flat files, CSV files and transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10,000 records.
Analyzed ETL Mappings & Designed 167 SQL QA queries based on Facts & Dimensions from Source to target tables for directs moves and indirect moves based on transformation rules & lookup tables comparing Business and production Data with the accuracy and efficiency of 99%.
-Data Analyst – DELL-EMC
Analyzed dataset in MS Excel and worked as a liaison with BI to communicate requirement gathering.
Built Tableau Dashboards from structured and unstructured data with 99% accurate insights.

Thanks for viewing.
ukm170000@utdallas.edu

Experience
Charles Schwab
• Conducted the Root Cause Analysis of bad data and queried approx. 1M records loaded into the Big Data Environment with the help of Hive QL in Nexus Query Chameleon replicating the Adobe Data Structure.
• Implemented innovative approach to convert HQL scripts to SQL using Custom SQL Editor of Tableau & performed analysis, producing quantitative visualizations in Tableau to help manage performance.
• Automated these Web Analytics Dashboards with the help of UNIX and Report Tracker, which ran through manual intervention before, saving 87% of the time and saving approximately $2.5M.
• Proactively communicated and collaborated with Schwab Intern Academy to manage revenue and other core enterprise metrics that drive forecasting and strategic planning for the Schwab Intern Program.
• Communicated and presented insights clearly and compellingly to senior leadership of the organization.
Projects
Worked on many projects relating to the Analytics domain.
1. • Conducted the Root Cause Analysis of bad data and queried approx. 1M records loaded into the Big Data Environment with the help of Hive QL in Nexus Query Chameleon replicating the Adobe Data Structure.
• Implemented innovative approach to convert HQL scripts to SQL using Custom SQL Editor of Tableau & performed analysis, producing quantitative visualizations in Tableau to help manage performance.
• Automated these Web Analytics Dashboards with the help of UNIX and Report Tracker, which ran through manual intervention before, saving 87% of the time and saving approximately $2.5M.
• Proactively communicated and collaborated with Schwab Intern Academy to manage revenue and other core enterprise metrics that drive forecasting and strategic planning for the Schwab Intern Program.
• Communicated and presented insights clearly and compellingly to senior leadership of the organization.
2.Client, Bank of Montreal.
• Conducted ETL using Netezza SQL to extract the data from CSV and Flat files; transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10,000 records.
• Designed 167 SQL QA queries based on transformation rules, lookup tables and validating the data files to make sure correct data has been captured to be loaded to target tables.
• Implemented SCD I, II to the extracts based on the business requirement and client expectations.
3.Client, DELL
• Created real-time dashboards in Excel & Tableau and reporting capabilities of KPI metrics across Revenue Cycle Management, leading to 34% growth in customer acquisition and boosting NW region sales of India by 15%.
• Checked coherence in the monthly revenue reports submitted by the different business units and consolidated summary totals of profits to be compared with projections.
• Implemented knowledge of software development life cycle to analyze data regarding internal work efficiency and noted areas of wasted time, increasing total productivity in production by 9%.
• Built deep behavioral profiles of active users, which led to product improvements that increased customer activation rates by 30%.
4. Social Media Analytics
5. Marketing Analytics
6. Organizational Behavior Analysis
7. Airbnb DataSet Analysis in SAS EM