Lisa Lowell Email and Phone Number

Contract position

• Improved the quality and reliability of business data by analyzing and identifying key data discrepancies, proposing and implementing solutions and unifying reports and dashboard results.• Performed data analytics to create visualizations of sales data. Analyzed disparate data sources to develop and prioritize key metrics for business reporting and targeting candidate customers.• Worked closely with the Innovari leadership team to initiate the creation of a data warehouse and reporting tools.

• Extracted data from Simple’s Redshift data warehouse, analyzed data using SQL, Chartio, R and other tools, and presented findings to the relevant internal stakeholders.• Developed and refined metrics, reports, and procedures to monitor customer contact, key operational indicators, customer service trends and all KPIs related to the Customer Relations department.• Provided analytical support to the CR leadership team related to scalability and quality improvement within its business operations.• Assisted key stakeholders prioritize and understand the impact of potential product improvements.• Facilitated data-based decision-making throughout the company.

Contract position• Conducted interviews and work sessions with technology, SMEs and business team members to clarify and document data flow definitions and requirements of upstream systems for current and future processes.• Performed detailed data analysis and data mapping between multiple Oracle and Mongo databases using SQL Developer, Web Service requests, JSON Objects, Excel spreadsheets and data discrepancy reports to understand the root causes of data discrepancies and make recommendations to ensure resolution of data inconsistencies and identify and report system business logic and process defects.• Facilitated cross functional team meetings. Developed and presented reports outlining data discrepancies between multiple systems and disseminate process flow information acquired through interviews and work sessions.• Developed weekly summary reports to concisely communicate analysis findings and visually reveal data trends. Designed, developed and automated 12 summary reports using Excel and VBA. Decreased analysis report processing time by 400%. • Partnered with SMEs and technical members of cross functional teams to define and refine requirements for data discrepancy reports to correctly identify data discrepancies across multiple integrated systems of record. Analyzed data in report output to verify validity. Made recommendations to correct logic, add attributes and improve the overall value of the report.

• Developed complex SQL stored procedures, queries and excel spreadsheets to perform complex data analysis and implement, enhanced and managed all new and existing loss mitigation programs. • Utilized SQL Server, Excel, flat files and multiple other data formats and development methodologies to meet tight timelines and perform innovative analysis, achieving first to market results for all standard and pilot programs.• Responsible for detailed client requirements analysis, SQL development to isolate target loan populations, performance projections definitions and pull-through reporting requirements and measurement of relevant success metrics. Communicated analysis findings to internal and external stakeholders as well as client representatives.• Automated loan program eligibility analysis process by developing SQL scripts to perform analysis of program failure reason priorities with an Excel spreadsheet interface for users to run program eligibility analysis on loans in question. Replaced manual analysis process with automated process and delegated team leads to run the new automated tool. Designing, implementing and delegating automated process resulted in freeing up two engineering hours per day.

Contract position• Performed detailed data analysis and data mapping between multiple databases in preparation for data migration and system and data divestiture and integration• Documented analysis in SharePoint and Wiki• Developed logical data models in ERwin• Wrote SQL to analyze data in Oracle DBs• Interviewed stakeholder groups to understand their data, systems and processes • Developed as-is and to-be process flow and data flow diagrams• Utilized Version One for writing User Stories and tracking tasks

18 month contract• Performed detailed data analysis, mapping, extraction and transformation. Identified, documented, proposed solutions for and resolved data issues.• Manipulated and Imported csv and excel files into sql server 2008 database. • Designed custom sql queries and stored procedures to create tables, views, performed data analysis and data manipulation.• Maintained servicing data reports and conducted customer conference calls to resolve data anomalies and data integrity issues.• Authored business correspondence, reports and process design documents • Fulfilled QA responsibilities including drafting test cases, executing data tests, documenting and resolving testing issues.

• Performed research, financial data analysis and statistical analysis• Developed complex Excel spreadsheets, importing data from multiple sources• Streamlined processes and create financial reports• Increased company profitability• Managed and oversaw coordination of multiple contractors• Determined scope of work and delegate responsibilities • Monitored progress and interfaced with contractors and customers

Short term contract• Performed Data ETL responsibilities including data analysis, mapping, extraction and transformation for SQL Server 2008 Intel proprietary database• Wrote DML, T-SQL and stored procedures to extract and transform data • Created temp tables and views and develop complex SQL queries• Marked up Power Point slides utilizing Intel proprietary software to map data from stored procedures to fields in Power Point slides. Developed new and debug existing PowerPoint slides• Responsible for QA of stored procedures, data mapping and final slide presentation

Contract position• Performed data analysis and data mapping for SQL Server 2005 district wide and statewide school databases• Interfaced directly via phone, email and in person with district level customers and state level customers determining requirements and modifications • Documented requirements, business rules, schedules, milestones and overall processes• Performed Data ETL responsibilities including developing SQL and T-SQL queries and stored procedures to structure data fields, validate and convert data, create temp tables and extract data • Employed SSIS to assist in database extraction and creation of flat files for transfer process• Developed T-SQL views, stored procedures and functions to interface with a SQL Server 2005 database for utilization by front end C# UI developers• Created test matrices and test cases; execute test cases, log and track results and bugs using SharePoint

• Utilized technical skills (SQL, T-SQL, .NET, MS Windows, HTML, XML) and troubleshooting abilities to analyze and debug software and systems problems for financial institution industry• Provided technical information, customer assistance, and resolutions to technical problems involving Corillian products and solutions. • Provided the highest quality of customer service to Corillian clients and internal customers• Worked closely with other Corillian employees to facilitate resolution of software and systems problems in a variety of environments including production, staging and development. • Provided feedback and isolated product defects for Engineering and Product Management groups to help improve product quality and usability.• Accurately logged, documented and tracked all current problem statuses for customers and internal problem-solving teams.• Maintained a record of common problems and issues for feedback to marketing and engineering.

• Responsible for all phases of Product Availability Database and web based user interface software development lifecycle, including, but not limited to: requirements gathering, technical documentation, design, development, test, implementation, training and technical support.• Prioritized, scheduled, implemented and documented the development of new and modification of existing SQL queries, stored procedures, triggers and tables to provide additional data requested by Engineering and Marketing departments. • Retrieved, analyzed and compared data within databases by designing SQL code using cursors, temporary tables, triggers, variables and stored procedures.• Designed ER Diagrams for new database development and reviewed and enhanced existing ER Diagrams.• Managed web based user interface to Product Availability Database utilized by Marketing and Engineering departments. • Improved existing code and defined and implemented new Java servlets, HTML code and JavaScript to accommodate new FLEX technology and MemPro models. • Increased engineering productivity by implementing script interface capabilities within Java servlets.• Directed both proactive and reactive support for support center web site. Routinely reviewed web pages, identified areas needing enhancements and updates, prioritized, designed and efficiently implemented HTML, CGI Perl script and JavaScript modifications.• Conducted DBA responsibilities for Sybase Database containing data for over 2,000 models. Maintained, enhanced and documented code and data.

• Specialized in worldwide technical product support of simulation models, over the phone, by email and in person. Consistently rated excellent in Customer Satisfaction Surveys.• Expert in resolving technical licensing issues. Served as consultant, training new hires, Sales and Field engineers in the complexities of licensing. • Authored technical articles posted on Synopsys external web page and helped company meet the goal of “helping customers help themselves”. Articles received one of the highest “retrievals per article” rates in the group.• Analyzed data, investigated, validated, located and reproduced customer’s technical issues using Mentor Graphics and VIEWlogic simulators with Solaris and HPUX. • Evaluated issues and initiated processes to resolve problems by interfacing with Engineering, monitoring progress and advising customers of resolution. Utilized SCOPUS database to track and manage customer issues and improve resolution response time• Acted as customer advocate by providing a direct voice to Marketing, Sales and Engineering, representing customer concerns and requests.• Conducted QA on new versions of technical manuals, installation guides and online documentation, improving customer service and company profitability.

• Enhanced existing parameter extraction tool written in C.• Performed System Administration duties for Test Engineering group.• Project Leader. Planned software and hardware schedules. Delegated hardware builds, designed, developed and debugged test programs and vectors. Worked closely with Design Engineering. Met all schedules and had program functional for first silicon.• Designed and developed a multiflow generic software shell in Pascal, used in the creation of all test programs within the company.• Produced multiple complex vector post processors using C, awk, sed and shell scripts, used by design and test engineers.• Accurately enhanced data capabilities and testflow of existing Pascal program. Contributed to schedule development, planning, implementation and debug of characterization software for Floating Point chip set.