Professional Summary

• A versatile, resourceful Information Technology Systems Professional with over 15 years of experience including:
• Solid Financial, Process Improvement, Risk Analysis and Training skills.
• Strong working skills in Business Process and Operational Process Improvement to support the Company's Business Mission.
• Strong working skills in AGILE SCRUM Iterative processes.
• Ability to work within the organization at all levels utilizing a hands on approach to create value and buy-in as the lead change facilitator. Collaborated with IT infrastructure on implementing project required servers and re-designing data centers.
• Provided training to internal company business systems users and IT support staff.
• Demonstrated ability to analyze, coordinate, plan, and execute multiple projects simultaneously using MS Project.
• While working with Business SME's, have facilitated, gathered, documented and verified business user requirements for all application related activities and developed Functional Specifications for Development.
• Have extensive knowledge and experience with Access, Excel, Project, SQL, SharePoint, WORD and Visio and have used MS Access to: create Forms, Reports, Tables, Databases, exported and imported tables to using Excel
• Have created and worked with in Excel: Reports, formulas, Macros, Pivot tables
• Contributed to multiple projects valued from 10K to 400K , for Bank of America, Toyota, Countrywide, Kinecta, Northrop/Grumman and Quicken Loans.

Key Competencies:

• Solid knowledge and experience with AGILE/Iterative development process and product implementation.
• Use of Traceability Matrix and worked with XML and WEB Services
• Extensive knowledge of: JIT, KANBAN, TQM Total Quality Management , SDLC, Quality Assurance
• Value Stream Operations Analysis, SWOT Analysis, BPM Business Process Modeling
• Databases: Oracle 11g, Business Objects, SQL Server 2008, COGNOS/OLAP and Access
• Software: MS Word, Excel, PowerPoint, Project, Access Visio, HTML , Ataccama, Alteryx

Professional Experience and Accomplishments:

Confidential

Data Analyst

• Used MS Excel to produce Dashboard mockups for developers for Tableau. Prepared Power point slides to present development solutions to the developer team. Used Ataccama for Data Quality Management. Used Alteryx for Data Blending and Analytics.
• Successfully worked on major project to move 1.5 billion documents from MS Server to Cloud/Cassandra environment.
• Successfully completed the Proof of Concept in a Data Analyst role using Alteryx a Data analysis, BI software with SQL Server.

Confidential

Sr. Business Analyst

• Responsible for writing detailed Business Requirements, Test Plans and Test Cases to support report prototypes via wireframes for Property, Mortgage, and Real Estate Data Analytics products. Used SQL to Analyze the results from Functional and User testing. Used Visio for Business requirements documents, process and data flow design. Completed the Data Mapping as required. Used MS Team Foundation Server to track all project documents. Worked with WEB services to test application changes and verify data.

Confidential

Business Analyst

• Provided Business Analysis, developed Data Mapping, Systems Test Cases, System Training Plans and user Training documents for the major project for MGCB Michigan Gaming Control Board .Maintained project documents on MS Share/Point. Worked with developers to ensure Data Quality and verifiable unit testing of screens. Used SQL Developer to write SQL queries against an Oracle 11g database validating data migration from the old system to the new WEB enabled system. Developed Data Mapping between old system to the new Oracle WEB based system. Provided project status using MS Project.

Confidential

Business Intelligence Business Analyst

• Provided BI support to business users of the QL BI platform. worked with QL team members on using analytical, performance trending and the predictive analytical tools provided by the QL Business Intelligence platform. Developed Use Cases and User Stories for the AGILE/Iterative development process. Worked with SCRUM Master. Developed Ad-Hoc reporting in support of the Loan Servicing LPS/MSP system and Investor reporting teams. Accessed Data Cubes via Excel Pivot tables. Performed data mapping and data quality assurance. Developed a critical business compliance reporting solution that would save up to 77,000 annually.
• Bank of America Agoura Hills, California via Apex Systems 12/2011 - 01/2012

Confidential

Systems Analyst/Project Coordinator/Contractor

• Collaborated on projects using the banks ECMS Enterprise Change Management System system ECMS is designed around Lean Six Sigma DMAIC Methodology. Clarity and Nexus was used to track project activity. Collaborated with systems users and application developers to create work, data and process flow diagrams. Worked with project team to develop solutions for iSeries/AS400 back-end Mortgage, HUD, Assumptions, and HELOC applications. Insured high quality business solutions. Used the HP Quality Center. Used SQL to validate Functional testing results.

Confidential

Consultant

• Consult with various organizations to address Lean project requirements and provide business solutions. Activities included:
• Interpreted business requirements then developed requirements documents.
• Creating viable business process improvement solutions. Writing User Business requirements.
• Developing business performance reporting using MS Access such as:
• Inventory usage and control, Procurement performance, Vendor management performance.
• Trained staff to use the Business systems such as Access, Excel.

Confidential

Consultant - Data Analyst

• Developed and enhanced the User groups' National annual seminars MS Access database. Developed tables, forms, queries, reports and macros in support of the National annual seminar held in Irvine, California in July 2010.

Confidential

Lead Business Systems Analyst

• Provided vital technical and business leadership on high-profile projects that included: Implementation of updated Mortgage Loan processing and Servicing Systems, developing Business Requirements for improved Membership services. Charged with supplying project management and training. Directed Systems Testing and Quality Assurance with in-house staff and systems users during system implementation.

Key Accomplishments:

• Led implementation team in the installation of the data warehouse and business intelligence tool Business Objects Business Intelligence XI 3.0 , requiring data import from a number of non-linked source systems involving vendors like FiServ and Business Objects and in-house Excel spreadsheets and Access databases. BI/DW built on a SQL Server 2005 platform.
• Provided training for key systems users, IT support, IT Development and Database Administrators.
• Established processes which streamlined the operational systems and provided better input for Business decision-making.
• Managed a project budget of over 400K.
• Directed a project to pass the corporate NCUA audit on time including an audit of Mortgage Loans saving a potential 50,000 in fines.
• Worked on a project to provide QA assured mortgage loan data to the FHLB of San Francisco.
• Wrote SQL to validate Functional test results and to ensure data quality.
• Provided training to internal Business systems users and IT staff on the Data warehouse environment.