Francisco Julian Borrego

Sherman Oaks, CA *****

818-***-****

adeupz@r.postjobfree.com

https://sites.google.com/view/fjbm/home

https://www.linkedin.com/in/francisco-borrego-7119a57/ Summary

• BA/PM with Agile methodology experience – Gathering Requirements - Write Epics, User Stories, Acceptance Criteria.

• Experience working in Scrum team using Jira/Confluence

• Very familiar with all phases of SDLC-Working with Developers, QA and UAT teams

• Knowledge of MicroStrategy and other BI tools

• Develop training plans, demos and customer-facing documentation

• Bilingual (Spanish/English)

Work Experience

Senior Business Analyst – Information Technology

HP – HPE - DXC - Universal Music Group, Los Angeles, CA April 2008 – Present

• BA/PM for Metadata Reporting System using MicroStrategy. This reporting system is used by domestic and international users within UMG different departments for extracting large portions of metadata (Metadata, Scheduling, Licensing, Royalties, Finance, Accounting, etc.)

• BA for UMG main Metadata application

• Elicit business and technical requirements from both external and internal sources

• Define, document and review acceptance criteria with QA team

• Participate in all phases of SDLC (Analysis/Development/QA/User Acceptance)

• Refine the product backlog in collaboration with Product owner

• Creating epics and detailed user stories and providing mock-ups/wireframes as necessary

• Prepare Release Notes for applications community.

• Design On-Line System - using RoboHelp as the tool.

• Key point for escalation of issues and new implementations.

• Strong technical background.

Tools – MicroStrategy, Qlik, EA, Visio, Power Point, T-SQL, Word, Excel, SharePoint, JIRA, etc. Technical Environments – Oracle, MS SQL Server, Java, .Net, XML, Web Services, etc. Business Analyst - International Theatrical Distribution 20th Century Fox, Los Angeles, CA

July 2006 – April 2008

• Central point of contact for all business matters from Fox Territories, Regions and Home Office personnel.

• Working with Key Users to finalize the requirements in each of the territories.

• Participating / reviewing the application design.

• Perform pre-release system testing alongside QA Analyst. Francisco Borrego

Page 2

• Coordinating activities related to data clean up and conversion.

• Working with Territory management to set up security access in accordance with Corporate Audit and SOX 404 guidelines to enforce segregation of duties.

• Preparing training materials and delivering End-User Training.

• Providing post-implementation support after each territory deployment.

• Produce client reports using Microsoft Reporting Services and Crystal.

• Other duties as assigned.

Tools – Microsoft Project Manager, Visio, Power Point, Word, Excel, SharePoint, MicroStrategy Technical Environments - MS SQL Server Reporting Services (SSRS), SSIS, .Net, Web Systems Analyst/Programmer

Countrywide, Los Angeles, CA

March 2002 – July 2006

• Participates in all planning and management phases, as a Subject Matter expert.

• Participate in the documentation and process mapping of business functions for Wholesale Department.

• Extract requirements from business unit; interviews and document requirements according to project standards. (Business requirements, Functional Specs, Use Cases, etc.)

• Participate in final conversion execution.

• Support POS applications built on Microsoft Technology using Active Server Pages (ASP) front end, Visual Basic middle tier, and SQL Server 2000 back end. These applications interface with some central services.

• Perform pre-release system testing alongside QA Analyst.

• Produce client reports using Microsoft Reporting Services and Crystal. Tools – Microsoft Project Manager, Visio, Power Point, Word, Excel, SharePoint, VIPER Technical Environments - MS SQL Server (SSIS / SSRS), .Net, Web Systems Analyst/Programmer

Universal Studios, Los Angeles, CA

November 2000 – March 2002

• Provided application support for Theatrical Distribution Systems (TDS). This application has a Visual Basic front end and SQL Server back end and interface with outside sources as Technicolor, ACNielsen.

• Collaborated with outside and in-house developers maintaining present applications, or adding new components to existing packages using SQL and VB.

• Produced executive reports using Crystal Reports versions 7.0.0 / 8.0.1.0 and MicroStrategy Agent for International Distribution in a Citrix environment. Very familiar with Data Warehouse.

Tools – Microsoft Project Manager, Visio, Power Point, Word, Excel, SharePoint, SSRS, SSIS, MicroStrategy

Technical Environments - MS SQL Server, .Net, Web

Systems Analyst/Programmer

Paramount Pictures, Los Angeles, CA

May 1998 – November 2000

• Offered client support for the Motion Picture Department, maintaining, analyzing, installing and recommending applications for domestic and international marketing and publicity, Viacom

Francisco Borrego

Page 3

• Consumer Products, Domestic Theatrical Distribution, Invoicing and others; Coordinated with Network Support Group software or hardware implementations; Produced executive reports using Microsoft Project Manager, Visio, Power Point, Word, Excel, SharePoint, SSRS, SSIS, MicroStrategy Crystal Reports and Impromptu.

• Worked with QA group in year 2000 applications conversion. Tools – Microsoft Project Manager, Visio, Power Point, Word, Excel, Transact SQL Technical Environments - MS SQL Server, AS400, .Net Systems Analyst/Programmer

Motion Picture Association of America, Inc., Encino, CA January 1988 – May 1998

• Developed, maintained and supervised applications for domestic and International operations in a Network Environment with over 100 users, using: DBaseIII+, Clipper, FoxPro, Visual Basic and Delphi, Crystal Reports (R&R) and Impromtu.

• Functioned as Systems Consultant, Troubleshooting (hardware-software) for all locations, domestic and international.

• Gained expertise with DOS, WINDOWS, NOVELL and NT environments as well as with most widely used software packages (Microsoft Office, WordPerfect, Lotus Notes, PC Anywhere, etc.,)

Tools – Microsoft Project Manager, Visio, Power Point, Word, Excel, Transact SQL Technical Environments - MS SQL Server / AS400 / Novell / .Net Education

California State University Northridge, CA

Bachelor of Arts Degree, Political Science, 1994

UCLA Extension, Los Angeles, CA

Microsoft SQL Server / Transact-SQL Advanced Visual Basic Introduction and Advanced Delphi

Introduction to C Programming

California State University of Los Angeles, Los Angeles, CA Local Area Networking with Novell Netware - Certification of Completion Universidad Complutense, Madrid, Spain

School of Business Administration

IBM STUDY CENTER, Madrid, Spain

Operation, System Support and

Applications: IBM/34, 36 and 5280; RPG-II Programming Specialties

• Strong knowledge in all phases of software development life cycle (SLDC)

• Advanced knowledge of SQL and BI Tools

• Ability to multitask according to project priorities and with complex and aggressive time lines

• Strong ability to work effectively with multiple businesses and IT stakeholders

• Experience communicating clearly to both business and technical teams Francisco Borrego

Page 4

• Bilingual (Spanish/English)

Community Service

Volunteer Math Tutor/Bilingual Aide – School on Wheels AYSO (American Youth Soccer Association)

Contact this candidate