Hiral Doshi

Hiral Doshi Email and Phone Number

VP, Data Senior Analyst at City National Bank | Data Engineering | Data Analytics | Big Data | ETL Pipeline | Data Warehousing | Business Intelligence | Technology & Innovation @ City National Bank
Hiral Doshi's Location
Los Angeles, California, United States, United States
Hiral Doshi's Contact Details

Hiral Doshi personal email

n/a
About Hiral Doshi

SQL | Hive | Snowflake | Salesforce | ETL | IICS | SAP | Informatica PowerCenter | Tableau | Python | BI | R | .Net Framework | Statistical Analysis | Data Engineering | Data Science | Data Obfuscation | Data Profiling | Data MaskingEnthusiastic Data Analyst/ETL Developer with 5+ years of experience in end-to-end Analysis, Design, Development, Testing and Implementation of data warehousing and business intelligence, data integration/migration, and market research projects Commercial Banking and Finances, and IT domains. Possesses exceptional skills in extraction, transformation, load (ETL), statistical and analytical techniques, and visualization of large data sources. While contributing to the organization, constantly aims to increase individual productivity and knowledge. I am open for new challenges and have a very strong will to learn, adapt and excel.

Hiral Doshi's Current Company Details
City National Bank

City National Bank

View
VP, Data Senior Analyst at City National Bank | Data Engineering | Data Analytics | Big Data | ETL Pipeline | Data Warehousing | Business Intelligence | Technology & Innovation
Hiral Doshi Work Experience Details
  • City National Bank
    Vice President - Data Senior Analyst
    City National Bank Aug 2022 - Present
    Los Angeles, Ca, Us
  • Virtusa
    Consultant - Technology
    Virtusa Oct 2019 - Aug 2022
    Southborough, Ma, Us
    •Dealing with new data pipeline consumed by accounting systems, processed to the centralized cloud-based data warehouse (Salesforce ncino), and pushed to downstream application ODS layers in Oracle and Enterprise Data warehouse Presentation Layers in Teradata.• Analyzing data flow from ultimate source systems to the final presentation reporting views, business requirements, creating functional and technical specifications, maintaining data integrity and quality to reduce costs and time• Implementing change data capture and slowly changing dimensions (Type 1 & 2) for load strategy and automating the processes /reconciliation reporting by developing reusable codes, integrating the platform system• Building star and snowflake schema, dimensional data modeling, fact, and dimensional tables along with the expertise in writing complex SQL Queries to populate the required data• Creating Data Lineage Document and Data flow diagrams for data migration to datahub project for 11 different banking products like Lease, Loan, Credit Card, etc.• Designing, developing, and implementing ETL processes of EDW and Commercial Lending systems for initial loads, daily and monthly data load strategy, creating acceptance criteria-based Test cases using Gherkin code for data validations/testing• Developing UNIX Shell scripting for data feed files for making ready-to-be-processing as per system and scheduling jobs in CA7 and CA Automic and querying in and exporting data files from Salesforce ncino as part of ad-hoc processes/data cleanup activities for running data loaders in Salesforce.
  • La Mere, Llc
    Data Analyst Intern
    La Mere, Llc May 2018 - May 2019
    Indio, Ca, Us
    • Conducted analytical support, competitive and market metrics, Key Business Insights, cause-effect relations, transactions on Oracle Opera Property Management System from historical sales data. Created pricing and cost saving strategies.• Developed 2 data-driven models with accuracy of 80% in R to forecast revenue and MS Excel (VLOOKUP, Conditional Formatting, Pivot Tables, Macros) to predict customer behavior for each season and control/manage inventory/supplies. • Leveraged dashboards and analytical reports on Tableau and Excel identifying return on investment, forecasted future sales, guest ratings, invoices, performance trends, seasonal events for the CEO to provide data driven decision making.• Transformed findings into 2 actionable business opportunities to support decision making and recommend potential business solutions by market trends analysis and BI reporting; increased profitability by $50,000, efficiency by 20%.• Consolidated daily reporting of brand mentions and reputation and analyzed feedback to prevent negative comments from customer on Tableau and Excel; improved customer experience score and social media rating by 1.5%.• Prepared Human Resource plan to include training and managing using objective accomplishment.
  • Titan Communications, Csuf
    Graduate Student Assistant
    Titan Communications, Csuf Jul 2018 - Aug 2018
    Fullerton , California, Us
    • Maintained University equipment check-in and check-out, Titan Card Validation websites on Visual Studio and SQL Server• Programmed on .NET Framework, C# and MVC as front-end and SQL to fetch and store database
  • Infosys
    System Engineer
    Infosys Nov 2015 - Jul 2017
    Bangalore, Karnataka, In
    • Established ETL Routines for data extraction and transformation on SSIS, for reporting data validation.• Devised unit test cases for PWC audit manager web app in .Net Framework (bootstrap and PL/SQL), C#, MVC. • Implemented SDLC, requirement analysis, process mapping, Agile software development processes, for developing app. • Articulated business requirement, adhered to SLAs, performed troubleshooting, ad hoc reporting, root cause analysis, server/security audits, system backup and recovery procedures by company’s disaster recovery strategies on MS Access. • Resolved CRM services related problems, requests, priority-wise incidents/tasks for user groups, clients on ServiceNow.• Managed 6-member group of new hires, ensured smooth training process and explained business policies and guidelines.Generic Training:• Python• Relational Database System- MySQL• Data Structures• Object-Oriented ProgrammingStream Training:• NET Framework• C#• ASP.NET using Web forms• MVC 5• Entity Framework• SQL Server Connections

Hiral Doshi Skills

Html C++ Language Java Photoshop Visual Basic Xml Microsoft Sql Server Python C# Ado.net Entity Framework Asp.net Asp.net Mvc Adobe Photoshop Bootstrap Javascript Angularjs C++ Sql Microsoft Powerpoint Microsoft Office .net Framework Vmware Vsphere Microsoft Excel Microsoft Access Tableau Microsoft Visual Studio Public Speaking Customer Service Relationship Building Xlstat Xlminer Regression Analysis Anova Cross Functional Coordination Statistical Data Analysis Business Intelligence Data Mining Forecasting Project Management Data Analysis Business Analysis Ibm Spss Cascading Style Sheets Databases Leadership Logistic Regression Multiple Regression Linear Regression Linear Programming Descriptive Statistics Intermediate R Software Development Life Cycle

Hiral Doshi Education Details

  • California State University, Fullerton
    California State University, Fullerton
    Information Systems And Decision Science
  • Cal State Fullerton, College Of Business And Economics
    Cal State Fullerton, College Of Business And Economics
    Information Science/Studies
  • University Of Mumbai
    University Of Mumbai
    Information Technology

Frequently Asked Questions about Hiral Doshi

What company does Hiral Doshi work for?

Hiral Doshi works for City National Bank

What is Hiral Doshi's role at the current company?

Hiral Doshi's current role is VP, Data Senior Analyst at City National Bank | Data Engineering | Data Analytics | Big Data | ETL Pipeline | Data Warehousing | Business Intelligence | Technology & Innovation.

What is Hiral Doshi's email address?

Hiral Doshi's email address is hd****@****mtb.com

What schools did Hiral Doshi attend?

Hiral Doshi attended California State University, Fullerton, Cal State Fullerton, College Of Business And Economics, University Of Mumbai.

What skills is Hiral Doshi known for?

Hiral Doshi has skills like Html, C++ Language, Java, Photoshop, Visual Basic, Xml, Microsoft Sql Server, Python, C#, Ado.net, Entity Framework, Asp.net.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.