Manager Analyst
Resume:
Francisco Julian Borrego
Sherman Oaks, CA *****
*********@***.***
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