Sql Server Data

EDUCATION

Novedea/Colaberry School of Data Analytics

Certificate of Completion: Developing BI/ED Applications with MS SQL Server, June 2015

Masters of Business Administration: Global Management

University of Phoenix, September 2011

Bachelors of Arts in Sociology

University of California at Davis, June 2002

TECHNICAL SKILLS

MS SQL SERVER/SSIS/SSRS

PROFESSIONAL EXPERIENCE

Business Operations Analyst Lewisville, TX

Nationstar Mortgage December 2015-May 2017

Performed data extraction, aggregation, and analysis from multiple data sources to create ad-hoc reports and data sets using T-SQL, SSIS and Excel

Conducted recurring and ad-hoc analysis on emerging business issues and trends, translating business questions into actionable data sets

Collaborated with IT partners to ensure operational and maintenance release commitments are fulfilled

Participated in requirement gathering sessions with business partners

Worked closely with the Business Units and IT team members to ensure business requirements are accurately documented

Used understanding of existing code logic to make the required changes as per the requirements

Maps out current processes, to identify disconnects and re-engineer processes to gain efficiencies

Worked with Senior Operations Management to understand data and analysis, allowing them to make suggested improvements based on recommendations

Re-engineered Daily Reporting process to increase efficiency and reduce time input by 60%

Created and maintained Production and Quality Dashboard for senior management to track operation efficiency of mid-level management, that identified on going reporting issues within the department

Business Control Analyst Plano, TX

Bank of America October 2010-November 2015

Responsible for understanding and following defined procedures, control plans, and process flows to help department with daily business routines. In addition to updating and creating new procedures and process flows

Gather data daily to track, report, and manage internal control gap issues and mitigation plans

Extract and manipulate data from databases using data analysis techniques

Develop operational procedures, control plans, and process flows for the department, and ensure their compliance

Saved Operations Department on average $192,000 dollars per year from 2012-2014

Increased loan output by 20% in 2014, to help bank reinstate or foreclose on delinquent home loans.

Developed and implemented quality control procedures to make breach process more efficient for the states of Illinois, North Carolina and Arkansas

Contact this candidate