ross leong

application system engineer

About

Constructive and reliable data analyst offering more than 13 years of experience in data analysis, designing, improving, and supporting key business processes. Subject matter expert in building data mart, ETL development, reporting, report/process automation, and variance data analysis. Competencies in: * Marketing analysis, time series analysis, forecasting, and trend analysis * Reporting for financial performance, post marketing campaign tracking, business portfolio, fatigue analysis, and modeling comparison performance (PSI) * Data warehouse/ data mart design, data mapping, and star schema design. * Data extract for data analysis, data mining purposes, data cleansing, data profiling. * Software design and development cycle including documentation. * QA testing, debugging, troubleshooting, software integration. * Requirement gathering, system design, system documentation.

Country

united states

City

san francisco

Industry

banking

Skill

ssis, etl, ssrs, data warehousing, sdlc, business intelligence, business objects, sql, oracle, microsoft sql server, visio, informatica, olap, t sql, database design, teradata, data mining, db2, software development, business analysis, databases, data warehouse architecture, crystal reports, sql tuning, ssas 2008, sas programming

Experience

analytic consultant

wells fargo

2003-12 - 2016-4 · 12 yrs 5 mos

application system engineer

wells fargo

2003-12 - Present · 22 yrs 10 mos

Wells Fargo Securities delivers a comprehensive set of capital markets products and services to customers, including originating and distributing public debt and equity, hedging interest rates, commodity and equity risks, advising on mergers and acquisitions, and originating structured lending facilities and municipal bonds. The institutional broker dealer is comprised of more than 4000 team members in 40+ offices across the United States, Europe and Asia.Wells Fargo Securities is the trade name for the capital markets and investment banking services of Wells Fargo & Company and its subsidiaries, including Wells Fargo Securities, LLC, a member of FINRA, NYSE, NFA and SIPC, Wells Fargo Institutional Securities, LLC, a member of FINRA and SIPC, and Wells Fargo Bank, N.A.