Experience

• 

  Sony Pictures Entertainment

  • United States
  • Entertainment Providers
  • 700 & Above Employee

  • IT Business Relationship Manager

    • Oct 2014 - Present

     Supervising and mentoring three Business Analysts as well as owning the entire studio lot system portfolio - 40 departmental products, systems and services, including SaaS Products, B2B/B2C/B2B2C Web Products, Business Intelligence Dashboards, Reports and Data Analysis Services, Desktop Client-Server Products, Citrix Applications and EDI/ETL/FTP/API Interfaces. Developing studio products, systems and services with modern software lifecycle development and project management methodologies. Collaborating with SPE senior executives, customers, vendors and team leadership to understand business needs and relationships while building strategic initiatives to increase customer satisfaction and requirements.  Establishing quality processes for project requirements, schedules, resources, quality assurance and releases to ensure deliverables meet customer needs Implementing methodologies to track progress and performance of operations, tasks and deliverables throughout the lifecycle Coordinating with SPE Cross-Functional/Enterprise teams both onshore and off-shore to ensure projects are delivered successfully on time and within budget. Ensuring continuous system improvement through KPIs, reports, analytics, dashboards, and customer feedback. Forecasting project budget, resources, scheduling and work breakdown using latest project management tools  Serving as a Member of Change Advisory Board to represent Studio Systems Portfolio. Supervising, coaching and mentoring three direct reports, including business analyst, sr. business analyst and BI developer while preparing a detailed roadmap for skills and career advancement for each position.

  • Senior Business Analyst

    • Aug 2012 - Oct 2014

     Directed team members in successfully managing more than 40 Studio Lot departmental products and systems.  Developed project lifecycle documentation, including project plans and schedules, requirements and design specifications, resource estimations, use case, process flow and data flow diagrams, test strategy, schedules, cases and plans, data dictionaries and data mapping documents and kick-off, deployment strategy, and final project presentations. Worked cross-functionally with Application Development Teams, Enterprise Infrastructure Teams, and Vendor Teams to implement project lifecycle. Restored system environments after major system compromise by implementing short term solutions for businesses to limit downtime, as well as collaborated with users on manual process workarounds and defined security policies to adapt business users to “the new normal”.

  • Business Analyst

    • Jul 2010 - Aug 2012

     Effectively liaised with Application Development Teams, Enterprise Infrastructure Teams, and Vendor Teams to develop, test, maintain and upgrade programs and systems. Implemented custom interfaces with third party software to work with client systems. Prepared operational documentation for each departmental program, including Application Environment Sheet, Quick Reference Guides, Interface data sheets, and data flow documents. Integrated systems with SAP/Tigres financial systems for billing/accounts receivable, as well as monitor Bill-over/Recon reports for discrepancies and developed reports for data integrity.

• 

  Weber Distribution

  • Business Intelligence Analyst

    • Jan 2010 - Jun 2010

     Provided business intelligence inputs to a 3PL leader in the supply chain industry. Maintained complex, production Crystal Reports used by the company and clients to prepare report enhancements as requested by team members, as well as fixed report defects via Help Desk Defect Tracking System. Prepared new Crystal Reports, labels and integration tools from requirement documentation for new clients.  Effectively maintained department-specific MS Access and Excel applications by analyzing the latest application design and functionality, as well as developing processes to ensure client satisfaction. Collaborated with department heads to analyze business processes and provide options for improving efficiency and information quality via comprehensive reporting, data access, and storage. Developed project dashboards to manage scope, schedule, budget, requirements, tasks, progress, issues, risks, and customer feedback.

• 

  Surrex Project Solutions

  • Managing Consultant

    • Sep 2007 - Aug 2009

     Supervised and mentored project teams of various sizes by planning project schedule, allocating resources, tracking project milestones and deliverables, providing client real-time status using Microsoft SharePoint technology, ensuring on-time delivery of projects, and managing change requests and additional scope for client satisfaction. Participated in requirement-gathering meetings with clients to review and evaluate business needs, as well as creating technical and business requirements documents and finalizing scope of requirements. Maintained successful scope, schedule and budget of small to medium sized projects Identified issues and mitigated risks before they could impact project schedule or budget.  Designed and architected systems to satisfy client’s business requirements and generated associated design and technical specifications for developers. Developed and administered integration and user acceptance testing plans and scripts  Planned and executed deployment strategies for successful project “Go Live” by creating strategy, managing daily Go-Live meetings with clients, and working with developers to migrate code to production site accurately.

• 

  Toyota Financial Services

  • Business Systems Analyst

    • Apr 2007 - Jul 2007

    •Administer and support TFS time tracking system for associate employees. o Handle Severity 1, 2 and 3 issues using Support Desk system and interaction with Front Line Help Desk agents. o Proactively implement changes and enhancements to system to improve efficiency and decrease incidents o Produce performance metrics for time tracking system for management to see trends and statistics•Work with Toyota Rent-a-Car, Lexus Customer Convenience System, Revolving Credit Line System and Tax and Legal On-Hold Notification System to provide analysis for management o Lead troubleshooting for accounting discrepancy in RCLS system and General Ledger to provide an acceptable change request to reconcile the problem o Use system query tool along with formatted reporting tool to provide metrics for all 3 systems using statistical and graphical presentation

• 

  Indymac Bank

  • Business Systems Analyst

    • Jul 2006 - Apr 2007

    • Evaluate Asset Management, Help Desk, Human Resources and Time Management systems and requirements, recommend enhancements and implement solutions o Work with current business system users and managers to develop change request requirements o Meet with Business Managers, Users and staff for review and confirmation of requirements documentation o Provide development team complete documentation of requirements for implementation o Manage and coordinate User Acceptance Testing and Production Verification Testing with testers, managers and developers o Provide post-release support and communication to all business areas involved• Provide staff with comprehensive data packages necessary for meeting goals and deadlines o Work with software compliance manager to develop a report comparing installed vs. purchased software, using SMS, Asset management system and purchasing channels

• 

  IntelliTrack, Inc

  • Software Services Engineer / Business Systems Analyst

    • Apr 2004 - Apr 2006

    Develop custom solutions for IntelliTrack, Inc. customers based on customer requirementsMeet with customer and design a functional requirements document based on customer business needsUse requirements analysis of customer to design and implement a custom modification to our softwareUse .Net technology to develop advanced functionality for applicationsPlug-ins for external applicationsWeb services and interfaces Embedded solutions for portable devicesUpdate legacy softwareModify user interface with Visual Basic For Microsoft Access (forms, data validation, object oriented data transfer, multilingual system settings)Transform SQL Server 7 & 8 and Microsoft Access databases (tables, queries, views, stored procedures) using Microsoft import/export techniques and custom data modification functions.Manipulate Client/Server communication using RF technology via Visual Basic TCP/IP and UDP, 802.11 wireless access point routers, and multi-tier validation infrastructure.Integrate system into customer site accounting for existing information systemMigrate data into customer information system using data import techniquesAdapt current wireless system to IntelliTrack systemImplement Client/Server setup throughout customer siteTrain customers on new system and demonstrate system functionalityProvide support for customersUse remote desktop software to make modifications to customer systemProvide FTP and Microsoft Visual Source Safe technology for customer support