Medha A.
- Role
- Senior Data Analyst at JPMorganChase
- Location
- Santa Clara, CA, US
- LinkedIn followers
- 500 followers
About Medha A.
Our team at JPMorgan Chase & Co. thrives on delivering precise data analysis and…
Experience
Senior Data Analyst
Dec 2020 — Present
Gather and refine business requirements and manage and coordinate data analysis and data modeling projects across business units partnering with business and IT support managers to identify and refine business requirements for data modeling support in light of general business development objectives. • Defined operational data modeling requirements, validation of content, and problem-solving parameters. • Design and develop reports and formal presentation slides to monitor business critical results, define and evaluate problems, and recommend solutions for business improvement. • Involved in requirement analysis, pig and hive script development, writing and implementing Ad-hoc queries in Hive and Pig for Data Analytics. • Developed, documented and preserved logical and physical database models in agreement with enterprise standards and preserved corporate metadata definitions for enterprise data stores. • Identified and Analysis of various facts from the source system (OLTP) and Business Requirements to be used for the Data Warehouse. • Responsible for Big Data solution development using PIG and Hive as per PDM design. • Project data from various online transaction processing (OLTP) applications and other sources is selectivity extracted, related, transformed and loaded into Teradata Warehouse using BTEQ, MULTILOAD, FASTLOAD and FAST EXPORT. • Designed Star Schema, Hierarchies and Snow Flake Schemas for reporting as per BRD. • Analyzed and Defined Primary keys, Surrogate keys, Dimensions and Fact According to Business Requirements and created document for Views and Mapping Sheets to Map Source columns from source to target. • Involved in Loading/Migration of Adhoc data into Hive from Teradata database and done Data Analysis using Hive on POC • Generated Data Definition Language (DDL) scripts using the Data Modeling Tool and manually for the creation of Physical objects like Tables, indexes, constraints, Views and Materialized Views.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.