Data Manager

Lynn Luo

Overland Park, KS ***** 913-***-****

***********@*****.*** https://www.linkedin.com/in/lynn-luo-1071645/

Business Intelligence Professional with extensive experience in root cause analysis of complex issues and turning data into actionable information. Provides reporting solutions and data metric analysis that may identify business trends and results. Utilizes data analysis to explain business issues and financial implications, recommend workflow improvements, or enable business unit to improve workflow processes. Working with various business units to accomplish objectives. Performs research and influences the strategy for the most complex reporting and analyses of information in reports. Serves as a project leader or project manager and has significant interaction outside of the work group.

SKILLS

•Tableau, Crystal Reports 8.0, MSI

•Database Management (Oracle SQL developer 4.1, Microsoft SQL Server 7.0, Teradata SQL assistant 14.10, Sybase)

•Proficient writing T-SQL, HTML, Visual Basic 6.0

•Data Analysis and Reporting

•Leading Cross-Functional Teams

•Process Analysis & Redesign

•Excel and Access Automation with VBA

•OS: Windows 95/NT, Unix

•Data Mining and Interpretation

EXPERIENCE

04/2015~8/2020 Sprint Corporation, Overland Park, KS

Business Intelligence Analyst III

•Assist with the management of WLNP (Wireless Local Number Porting) and RPV (Rate Plan Validation) data processes under Oracle. Responsibilities include monitoring of daily data processing and modification of ETL processes. In addition, will include involvement in requirement definitions recommendations, and data process design and development for new or modified processes.

•Strong data processing knowledge include Oracle Database Structure, SQL Optimization Techniques, ETL process and techniques, and reporting data architecture. Experience with Sprint's wireless systems and data structures including NDW, NMS, Clarify, and SMG.

•Managed reporting suite that provided daily, weekly, and monthly reporting and analytics.

- Provided standardized reporting and significant ad-hoc analysis to Sprint senior executives.

- Managed Visual Basic programs that extracted and delivered timely reporting to 500+ customers.

•Provided operational and analytical support for WLNP call centers.

- Identified and implemented efficiencies within the call center workflow to reduce call transfers, shorten agent handle time and improve service levels.

- Reduced inbound call center by driving process changes though upstream applications.

- Performed research and analysis of complex number porting issues, implemented a plan of action for resolution.

02/2008 ~ 04/2015 Sprint Corporation, Overland Park, KS

Business Analyst II

•Responsible for extracting and utilizing large amounts of data to provide financial, operational, and process improvement information while maintaining accuracy and relevance. Primary responsibilities include developing and troubleshooting reports while completing analysis on Sprint/Nextel key operational and financial metrics.

•Responsible for identifying trends and improvement opportunities while providing ad hoc analysis to help drive key business decisions in report development using complex reporting tools such as SQL, Oracle, Access, VBA, Tableau etc. Create new SQL database tables, maintain existing SQL database tables, and create/maintain stored procedures and packages. Create scheduled SQL jobs to extract / transform / load files in various formats. Coding and reviewing SQL stored procedures, performance, and database modifications. Monitor data flow, report design and the design and implementation databases.

•Performs analysis of business processes and data that pertain to business issues. Provide reporting solutions and data metric analysis that may identify business trends and results. Utilizes data analysis to explain business issues and financial implications, recommend workflow improvements, or to enable business unit to improve workflow processes. Works with various departments to accomplish objectives.

•Runs complex reports and performs complex analyses of information in reports. Provides guidance to less experienced staff in project/work assignments.

11/2007 – 02/2008 TEK Systems, Overland Park, KS

Technical Support Specialist, contract to Sprint/Nextel

•Root cause investigations and assisting in resolutions with SQL / Oracle for Sprint/Nextel systems and applications.

•Identify the data sources required to feed the tracking and reporting system. Develop output formats that permit Sprint Nextel personnel to review and assess the efficiency of provisioning systems.

•Develop and recommend, based on investigations and tracking, Irreversible Corrective Actions (ICA) to prevent future recurrences of system and process failures. Assist the Manager, User Security & Access Management, in developing an ongoing Operations Review format for both weekly and monthly reporting periods.

•Review and define discrepancies between termination activity in Identity Management (IDM) systems and current active user lists in Sarbanes-Oxley applications and investigate cause for the discrepancies. Implement, based on Sprint Nextel needs and requirements, a tracking and reporting system that permits Sprint Nextel to determine the efficiency of provisioning systems and processes.

•Investigation of Discrepancies between Identity Management Terminations and Active User Lists in Applications

07/2005 – 10/2007 NovaStar Financial Inc, Kansas City, MO

Financial System Analyst

•Manage NovaStar's MS SQL server 2000 based risk management database system which contains Novastar historical loan performance data, origination data and servicing data. Write stored procedures for reporting as necessary; maintain current visual basic based application. Provide accurate reports to support portfolio management, trading activities, securitization, mortgage origination and accounting.

•Monitor the portfolio characteristics and performance and build daily and monthly reports, such as production reports, prepayment reports, delinquency reports and credit committee reports investment committee reports and some 10-K and 10-Q reports for accounting.

•Use data to conduct business analysis related to mortgage origination and risk management. Provide any ad hoc reports for senior management decision making.

•Develop reports for analyzing mortgage portfolio interest rate risk, credit risk and prepayment risk. Maintain current visual basic based applications.

•Responsible for NovaStar’s pricing change for Wholesale, Correspondent and retail channel and loaded into NovaIS web application.

ADDITIONAL PREVIOUS EXPERIENCE

Saint Luke's Health System, Kansas City, MO, System Analyst

EDUCATION

Management Information Systems

Kansas State University, Manhattan, KS

Contact this candidate