SUMMARY:

• Worked 10+ years in Agile project methodology
• Scrum Master for 5 years
• SAFe (Scaled Agile Framework Scrum Master) for 3 years
• Product Owner/Manager for 3 years
• I’ve been an Owner for almost 10 years. - Products, Databases, Processes.
• I’ve been a Leader almost 20 years
• Managing Risk almost 20 years
• Problem solver almost 20 years
• I’m a Software Engineer, Business Analyst and Project leader with over 15 years of demonstrated success with the complete SDLC, relational database development and business support.
• I have broad experience as a software developer.
• I’ve been Strong team leader AND team member whenever needed, with excellent communication and problem-solving skills applied to a variety of projects.
• My solutions to problems aim with a few key goals in mind: simplicity, flexibility and maintainability.

SKILL:

Software: MS SQL Server, Jira, Toad for Analysts, Access, Excel, SSIS, ETL/ELT, Visio, SharePoint, PowerPoint, Cisco WebEx, Lotus Notes, IBM Maximo, Oracle, IBM iSeries, Rally, HP ALM (Quality Center), Team Foundation Server

Programming: T-SQL, PL-SQL, MySQL, C/C++, Python, VBA, HTML, JavaScript, DOM

Experiences: Scrum Agile Development, Six-Sigma DMAIC, Mortgage Banking, Fortune 500, ISO 9000, Federal Government, Software, Product Management, Public Education

High-Level Knowledge of: BAC Mortgage Underwriting Systems, Pega Dynamic Case Management, CoreLogic IntelliMods

Low-Level Knowledge of: SQL-Based Rule Engines, SQL Stored Procedure, Table-value functions, Scalar functions Data-Set Partitioning, Recursion with Common Table Expressions

Writing Skills: Business Requirements, Low-Level Technical requirements, ‘4-Blockers’ Presentations, Business Reviews

PROFESSIONAL EXPERIENCE:

Confidential, Greater Los Angeles, CA

Technical Project Solutions Consultant

Responsibilities:

• Work closely with Business units who own various impacted assets to determine the end-state for CFPB compliance.
• Determine technical roadmap and interdependencies for a variety of assets: Databases, Reports and Programming Scripts in an environment with more than 6,000 identified impacts.
• Capture all Impacts as Stories or features and aid identifying prioritization.
• Following up with Coding and testing schedules.
• Report out on Status for UAT testing to Initiative Owner.
• Support an Agile Software Development process, working in conjunction with end users / stakeholders and technical delivery team. Work closely with counterparts in Product Management to align on the vision, program backlog, and roadmap.
• Work directly with other product owners, system engineers, program managers, developers, testers, and customers to define features and technical user stories within an integrated SAFe Agile environment.
• Define the road map and prioritize the product backlog to meet the vision. Met twice daily with development teams to ensure the minimum viable product has been made.
• Own and drive backlog grooming and management, prioritize user stories, create acceptance criteria and drive testing and delivery.
• Prioritize and Lead defect management effort. Provide key performance metrics to Portfolio Manager on the deliveries and benefits realization of change implementations.
• Created UX design, BRD (Business Requirements Document) and UAT Scripts.
• Led UAT effort and participated hands-on.
• Data Warehouse Product Owner for an Adhoc systems and reporting group.
• Developed and QC Databases and worked with Technology team for Server migration and other Technology Initiatives. I was the control point for access entry and decline for a database that had hundreds of users. Worked to remove unnecessary elevated access as well as Read-Only Access reducing risk and exposure to data and assets such as NPI/NPPI data.
• Also worked at the application level to control access.
• Scrum Master for two value streams within an Enterprise implementation of a Scaled Agile Framework.
• These two value streams encompass two application retirement projects, Application Updates working with Third-Party Government Sponsored Enterprises and Modifications of Application logic per Compliance and Regulatory requirements.
• Perform all of the Roles and responsibilities according to Scrum Master traditional functions thru the use of Rally Application and HP Application Lifecycle Management.
• Work with an average of 30+ Project Stakeholders
• Average 18 User Stories completed per release per value stream
• Almost $200,000 per month in value delivered (Dollar value X Agile Story points)
• Reported directly to Program Manager
• Used Rally, MS Excel, MS Project to track project progress and develop Project roadmap.
• Scrum Master for PDFQC automation project.
• Run Daily Stand Up meetings, meet with PMO, measure and monitor Team velocity and support the team by facilitating the clarification of requirements and removal of obstacles.
• Operation Data Storage is migrating from SQL Server to an Oracle Exadata system.
• I assisted in the design, research and documentation of the self-service portal for clients to request new reports to be made from Oracle 11i/Cisco Composite system.
• ETL Developer on Escalated Decisioning Perm Upload workstream.
• Perform SQL Server coding to upload for Permanent modifications to trigger system generation of mail files so that 3rd party mail vendors can contact borrowers within a Timely fashion.
• Also, backfill data for thousands of Mortgage Modification loans that were mailed outside system.
• Rewrote T-SQL Script for Cancel Loan Action Team to QC incoming loans submitted for Re-Evaluation to ensure the integrity of a Loan’s Run-of-Record within the Company’s Loan Mortgaging System.
• I revised the ETL process to handle new loan programs beyond the original scope of U.S. Federal government MHA loans.
• Developed database to track non-controllable items for Loan Modification.
• The TAR Database is used to drive an Executive Waterfall data warehouse and to aid dozens of users to track the progress of populations of loans with varying issues prior to passing for a Modification.
• Designed and Developed a SQL Server and MS Access Front-End Application to assigned 30+ users their daily tasks for Loan Modification and reporting. This project was to retire TAR, retire Command Center Reporting, and act as an Associate Capacity Tracking to be used for Productivity reporting.

Confidential, Los Angeles, CA

Business Analyst/Developer

Responsibilities:

• Provided hardware and software consultation for an upcoming Confidential - Confidential Building Inspection contract.
• Recommended and built software interface and SQL Server database structure design for project inspection forms application.
• Completed three consulting agreements to build Database Applications and reports using SQL and VBA. Performed ETL using VBA, HTML, JavaScript, and DOM to create database warehouses for a Facilities Maintenance contract at Confidential -JPL. EMCOR is a Fortune 500 company.
• Created data warehouse and reports for a Sr. Business Analyst as a proof of concept for Teachers Retirement web portal for the Confidential .
• The deliverables were Microsoft Access Forms, Crystal Reports, Excel Tables coded with SQL and Visual Basic for Applications to customize Reports based on criteria selection to plan the transition from paper to paperless business functions through the web portal.
• Descriptive Statistical Analysis was performed on data collected from Business Logic and Requirements Analysis.
• End product was based on Functional, Design and Derived Requirements.

Confidential, Pasadena, CA

Database Administrator

Responsibilities:

• I’ve developed a number of Business Applications and Business Intelligence reports using these technologies: PL/SQL, VBA, ODBC, SQL*Loader, and Toad.
• Successfully completed Front-End Application and a data warehouse that queried five years of Fiscal and productivity data that wrote back to a Confidential ORACLE database millions of dollars.
• Created Productivity Report using payroll data and ORACLE Tables to illustrate employees' work completed and cost analysis per period in group reports and graphical charts
• Developed Training Database Application for Quality Assurance and certification compliance.
• Created reporting to reconcile physical inventory with periodic expenses.
• Last 3rd Party Developer to ever have Write Access to ORACLE Back End Reporting Server.

Confidential, Los Angeles, CA

Product Manager

Responsibilities:

• Performed Analysis on state of Product offerings and foundational technologies.
• Met daily with Development team to cover user stories, known defects and production issues.
• Managed cross-functional team projects, customer relations and product development to increase efficiency and eliminate defects for a Fortune 500 company.
• Managed 3 direct reports in a team of 6
• Provide support to Business customers by resolving 40 business customer inquiries daily, installing over 200 Client Databases, reached out to 5,000 e-Marketing clients per day via CRM Database
• Interviewed and hired technical staff
• Reported directly to C-Level Suite

Confidential, Los Angeles, CA

IT Project Manager

Responsibilities:

• Provide Business Intelligence solutions through building Access and Crystal Reports for a Sales invoice database.
• Technologies used: Python, SQL, Excel V-Lookups, VBA macros, Excel tables and MS ACCESS.
• Developed an Inspection Application with Microsoft Access to gather data to perform qualitative and statistical analysis on Overseas Manufacturers for Quality Control.
• Used inferential statistics to determine patterns in resource usage.
• Created and modified manager reports, spreadsheets, official documents, and presentations.
• Developed and rewrote existing database applications.

Confidential, Downey, CA

Letter Programmer

Responsibilities:

• Used Proprietary Scripting Engine to recreate PDF documents for Confidential for Business clients.
• Queried FoxPro and SQL Databases for Mail File data to match business requirements.
• Participated in the Agile Daily Stand-up meeting with various members of the development team.

Confidential, Pomona, CA

Project Manager/Software Developer

Responsibilities:

• We created a PHP/MySQL Website to serve an Automotive Sales and Advertising portal for a real Automotive Dealership.
• I maintained all project documentation, emails and meeting minutes.
• I researched and created MySQL database containing the data for Many Makes, Models, Years and Trims for Cars.
• I created the JavaScript for the client-side scripting for various calculator services.

Confidential, Highland Park, CA

IT Project Manager - Internship

Responsibilities:

• Assessed school resource needs and executed a plan to restore non-working inventory to operation.
• Upgraded Sixty Windows User systems.
• Repaired a dozen Inoperable Lab Computers.
• Create contingencies to be used upon my exit from internship
• Created Back-up hard drive images.
• Duplicated Data on to CD backups.
• Created Device driver library.
• Created User documentation.

Confidential, Pasadena, CA

Assistant Manager

Responsibilities:

• Created the ‘Closing procedures’ checklist for Managers and Floor Staff.
• Floor Staff Closing checklist had tasks broken down in to weighted values and Team members were encouraged to volunteer for preferred tasks similar to Agile Project Environment.
• Created Closing checklist for Managerial paperwork to ensure consistent delivery of District and corporate level reporting.
• Executed Opening and Closing procedures for Film Exhibition Company.
• Managed 5-20 Employees per shift.
• Managed Petty Cash Safe
• Created Employee Schedule
• Created Film Showing Schedule
• Reconciled Cash Receipts with Deposits