Business Intelligence Architect Resume
5.00/5 (Submit Your Rating)
Los Angeles, CA
SUMMARY
- Senior Business Management Consultant, Business Intelligence Solution Architect, and IT Infrastructure Manager who consistently delivers high value IT solutions and business assets by leveraging strategic leadership and management skills, industry best practices knowledge, enthusiastic engagement, relevant industry experience, and technical expertise.
- A highly effective team member and leader who motivates and engages members of the organization at all levels in order to drive results and produce alignment with critical strategic initiatives.
TECHNICAL SKILLS
- Agile Project Management Financial Modeling Requirements Gathering (Data Warehouse)
- Business Analysis IT Infrastructure SSAS Tabular (DAX) and Power BI
- Business Consulting Management Solution Architecture (BI)
- Business Development Microsoft BI Stack (MSBI) Spanish (Fluent)
- CSM Cert. / Scrum Master Process Architecture SQL Development (Front - End)
- Data Modeling Project Management Tableau Development and Admin.
- Data Governance Product Ownership (JIRA) Vendor Management
- Economic Analysis Python (Beginner) White Papers
PROFESSIONAL EXPERIENCE
Business Intelligence Architect, Data Engineer, Agile PM
Confidential, Los Angeles, CA
Responsibilities:
- In my role as a Business Intelligence Architect, Data Engineer, and Agile PM at Western Asset Management, I serve as the driving force behind the following projects and initiatives:Principles and policy development
- Data Governance Office communication campaign
- Internal client and departmental engagement and project management
- Governance platform vendor and tool selection process
- MDM implementation project with IHS Markit technology vendor
- IT Infrastructure Platform Implementation Management
- Work in various capacities as Product Owner to scope, define, and prioritize BI Modernization Epic, Stories and Tasks and facilitate Agile methodology as a project delivery framework and maintain project backlog, groom the backlog, and manage project Kanban on Smartsheet
- Work in various capacities as Scrum Master to facilitate Agile rituals, facilitate communication, run daily scrums, communicate risk, issues and concerns, and generally remove roadblocks
- Work in various capacities as part of the Development Team to deliver
- Business Intelligence Platform Modernization Project
- Gather requirements for new BI reporting process, technology, and data
- Work with managers and team to scope all data domains, groups, fields, primary keys, relationships/joins, and granularity to provide requirements and articulation for new data warehouse and data virtualization layer
- Develop data model (conceptual, logical, and physical development) for new semantic / data visualization reporting layer to drive new reporting process and platform - using MSFT SSAS Tabular (in Visual Studio), Power Pivot / Power BI, and Tableau
- Recreate existing reports and process using new reporting paradigm: process, technology, data
- Help solve data related challenges: broken processes, missing data, data type, conformity, and normalization issues
- Consult on Enterprise BI and Information Management concepts: end-to-end process, storage concepts, ETL, best practices, MDM and governance, technology and vendor selection
- Consult on future state possibilities, BI strategy, project roadmaps, milestones, delivery process, risks and issues
- Host “BI Boot Camp”: educational sessions for team to learn about new BI tools, processes, best practices, methods, tips and tricks - educate about relational databases and dimensional modeling for semantic layer technology used in Power BI and Tableau.
- Liaison with IT Data Architecture team to help develop requirements and expectations for new Data Warehouse and Data Virtualization Layers to support new reporting paradigm
- Liaison with BICC (BI Competency Center) around implementation and enablement of Tableau
- Perform ad hoc analysis of data using SQL and various tools: SQLDbx, SAS, Tableau, Power BI
Business Intelligence Consultant
Confidential, Los Angeles, CA
Responsibilities:
- Functional Operations Manager: Tableau Product: Server and Platform
- Managed daily server and environment operations, optimization, offshore team, vendor relationship and service
- Fire drill resolution as lead point of contact for the business
- Coordinate operational activity and manage both offshore team and vendor relationship management
- Final accountability for Tableau product, stability, growth, and performance within NBCU
- Engagement Manager: Center of Excellence (CoE) and Customer Engagement
- Led development of internal Tableau CoE for customer engagement, empowerment, enablement, "getting started", training, Tableau User Group
- Point person for best practices, community engagement, critical information, and overall empowerment for any of our internal customer
- Set vision, strategy and goals for community engagement a user adoption
- Project Manager:
- Delivered the Tableau Server Environment Migration to new hardware
- Point person for: scope, schedule, plan, customer communication, SOP, status reporting, risks/issues, and all other project details.
- Drove the migration project and coordinating the activity around delivery.
- Tableau Server Architect:
- Assisted in engineering, designing, installing, configuring, and testing Tableau Server on new hardware and VMs
- Worked in conjunction with other server architects and admins to recommend licensing approach, cluster size and capacity, and Tableau Server services distribution over nodes in the cluster.
- Ownership of Overall Tableau Server environment development and deployment
- BI Solution Architect and Consultant to the internal business:
- Architected and deployed new BI solutions with the internal business units, providing data modeling and architectural support, Tableau SME and workbook development expertise
- Overall BI liaison and consultant to the business for new and on-going projections and solution architecting
- Front-end Tableau Report Development
- Created operational dashboard for performance monitoring of Tableau Server performance and Tableau Server Admin Team performance
BI Solution Architect and Product Owner
Confidential
Responsibilities:
- Business Intelligence Solution Architect
- Managed (re)development of enterprise BI solution, coordinating both front-end and back-end work for a major data migration from Oracle platform to Teradata, utilizing Tableau Desktop for development and Tableau Server for collaboration
- Led solution architecture design, development, and deployment management on a team of about eight people; including providing expertise on best practices and proper data management theory and implementation
- Provided theory, best practices, and technical implementation of new dimensional data model
- Developed project plan and communication, including creating visual diagrams and plans for architectural concepts to enhance team comprehension and buy-in
- Product Owner
- Articulated product vision, requirements, current state and gap analysis
- Defined work to be done, developed acceptance criteria, determined scope, determined priority, assisted with sprint planning, sprint review, sprint retro, backlog grooming, daily stand ups
- Provided high level team coordination, communication and collaboration management
- Managed team backlog, Kanban, roadmaps, epics, features, stories and tasks as and when needed
- Lead Agile and Scrum rituals including: Sprint planning and commitment, Daily Scrums, Sprint Reviews, Sprint Retrospectives, and Product Demos
- Provided executive level communication on status, progress, and risks and issues
- Technical Lead
- Led team meetings to define product vision, plan for design and development
- Researched new product solutions and features
- Facilitated and lead cross functional meetings with Mangers, SMEs, leads, and developers from teams across the organization to coordinate and consolidate efforts, leverage existing solutions, and define new plans and sprint cycles
- Helped to define best practices for development, and helped to coordinate development, validation, testing, and deployment
- Tableau Developer
- Troubleshot Report and Dashboard issues
- Created custom calculations, measures, and columns
- Architected new dimensional data model
- Introduced row level security using AD joined tables and account users
- Managed new user additions to Tableau server - collaborated to integrate new entitlements management system
- Wrote custom SQL Queries to manage data model and data sources
- Functional Manager (unofficial, but practical/de-facto)
- Managed one other team member during the development process: provided visions, goals, tasks, direction, help and oversight
- Coordinated their work effort to align with overall team goal, provided domain expertise to solve their problems and keep them productive throughout the day, provided feedback and support to help them learn and grow
Business Intelligence Solution Architect and Scrum Master
Confidential
Responsibilities:
- Worked in Agile framework to stand up IT Project Management Office (PMO)
- Scrummed and Sprinted to develop Agile BI Technology Solutions
- Architected Business Intelligence platform and solutions to support the PMO
- Served as BI Solution Architect, PM, BA, and Developer on most aspects of PMO projects
- Worked internationally (Mexico, fluent/conversational Spanish), designing business processes, systems, and data architectures to deliver modern BI: data management, reporting, and analytics capability
- Developed SSAS Tabular data model / semantic layer to support data management and reporting: developing and trouble-shooting data queries and connections, defining relationships, creating custom code for new measures and dimensions, developing custom visualization and reporting, managing integration between data sources, model, reports, and consumption layer
- Conducted Agile style development, with a focus on "quick time to value", iterative and flexible solutions
- Created dashboards and reports for managers using Tableau and Power BI
- Led stakeholder meetings to gather requirements, perform gap analysis, define project objectives, set stakeholder expectations, and drive development of new reporting capability
- Provided thought leadership in the area of Tabular data modeling, cloud integration and modern analytics paradigms and platforms
- Integrated data sources from Project Management, HR, Operational, Geo-Spatial, Financial, and other systems into a modern, tabular, in-memory, data modeling solution
- Researched, developed, defined, and governed new data sources - helping to define purpose, process, structure, format, access, integration of new data sources. Defining KPIs for PMO
- Developed reporting documentation, metadata, system architecture, security model, and user guide artifacts to support the overall technology system solution
- Lead educational seminars as needed to train team members as needed on new self-service BI tools - presenting to large groups on SSAS Tabular BI technology solutions
- Managed fire drills and high-risk, high-visibility critical client projects and communication
- Worked as a Project Coordinator and BSA to support IT projects for MDF cutovers: coordinating meetings and resources, creating cut over plans, gathering requirements, attending Product Design Review Meetings (PDRMs)
- Worked to develop small Azure SQL POC as a sample for the client