Melinda Lee Email and Phone Number
Melinda Lee work email
- Valid
- Valid
- Valid
Melinda Lee personal email
Melinda Lee phone numbers
I am a senior data and systems analyst. My expertise is in project coordination, research, data analysis, data modeling, and problem solving. I have worked on large scale in house applications, as well as vendor software for various industries such as financial services, insurance, warehouse distribution, and government. Prior technical experience included coding in COBOL and Java, with the last ten years predominantly with Sql.I enjoy working on large complex systems, which affords me the opportunity to delve into details many find daunting. I have worked on systems from the beginning of the cycle to the end. I have collaborated with business partners to define scope and requirements, with the cycle continuing with my involvement in research and analysis, project estimation, and the definition of specs. Once jobs are coded by team members, my tasks end with testing and implementation tasks, as well as providing ongoing support to users.I have worked mostly in a team environment, which includes business partners, project managers, architects, data modelers, software engineers, a QA team, and end users. I communicate in various ways with the team, whether it is participating in or leading team meetings, or writing scope, business requirements, technical specifications, or test plans. Other forms of communication involve the sharing data models I have created, or passing ETL specifications to developers. I started in the business as a developer, and have a deep understanding of systems, and can communicate effectively with all participants of a department.
First Republic
View-
First RepublicCalifornia, United States
-
Data AnalystFirst Republic Jun 2021 - Mar 2023San Francisco, Ca, Us- Coordinated the analysis and development work with Finance business partners for Enterprise-wide projects.- Performed impact analysis on deposit, loan, and customer enhancements made on source feeds residing on Snowflake and SQL Server databases. - Created data models for deposits and loans data being fed into the QRM (Quantitative Risk Management) software system to document metadata and data lineage. - Prepared detailed Visio diagrams of loan, deposit, and investment inputs, outputs, and processes for the QRM system. -
Senior Data System AnalystLendingclub Nov 2019 - May 2020San Francisco, California, Us- Was a team member of a critical loan performance project to capture metrics for determining profitability.- Performed the role of analyst on a BSA/AML project to transmit transaction monitoring data to a third party vendor, for reducing fraud.- Supported ad hoc requests from the Risk and Legal departments, by creating reports and datasets against the Hadoop HDFS, using Presto and Hive.- Improved processes in the Data Services department by implementing data warehouse standards and publishing repeatable processes. -
Data ModelerFirst Republic Bank Aug 2017 - Jun 2019San Francisco, Ca, Us- Performed the role of analyst and data modeler to support the Project Management Office, which resulted in the automation of resource time tracking and project planning, and the ability to collect data consistently. - Conducted research for upgrading ER/Studio, in order to reduce costs of individual licenses, as well as consolidate data models across multiple departments onto a single server.
-
Senior Data And Technical AnalystCharles Schwab Jun 1999 - Oct 2016Westlake, Texas, Us- Data analyst and data modeler for the following projects: -- Year-long project to provide biographical information of financial consultants for the company website, to attract potential clients and to aid existing clients in locating advisors. Project involved Sql Server, Teradata and MONGO databases. -- Two-year long billing project to migrate applications from an in-house system to a vendor based application, which resulted in reduced maintenance. Data was extracted from an Oracle database and loaded to a Teradata data warehouse. -- Project to build cashiering tables in Teradata for out-going wires. to allow for business reporting. -- Project to merge many years of historical data from multiple sources with current activity tables to track business trends. -- Project to calculate net new assets for consistent corporate management reporting to the Street. -- Project to load credit card data into the data warehouse for the bank division's launch of its first credit card for brokerage clients. -- Order replacement project to track submitted, pending, and settled trades.- Developer: -- Maintained the departmental internal website using the third party Teamsite software. -- Designed, developed, and implemented a graphical user interface to validate mid-tier services on AIX servers, using Java, Jsp, Javascript, and HTML. The GUI was used for validating and measuring performance by development, QA, and performance engineering teams.- Enhanced and maintained a trading desktop application (Velocity) written in Java and Java Swing.
Melinda Lee Education Details
-
University Of California, BerkeleyHumanities
Frequently Asked Questions about Melinda Lee
What company does Melinda Lee work for?
Melinda Lee works for First Republic
What is Melinda Lee's role at the current company?
Melinda Lee's current role is Data Analytics | Business Intelligence | Team Leader | Data Modeling.
What is Melinda Lee's email address?
Melinda Lee's email address is ml****@****lub.com
What is Melinda Lee's direct phone number?
Melinda Lee's direct phone number is (800) 633*****
What schools did Melinda Lee attend?
Melinda Lee attended University Of California, Berkeley.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial