LiveCareer-Resume

sr bi architect resume example with 10+ years of experience

Jessica Claire
  • , , 609 Johnson Ave., 49204, Tulsa, OK 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
  • :
Summary

Seasoned Data Architect adept at understanding mandates, developing plans and implementing enterprise-wide solutions. Complex problem-solver with an innovative approach. Ready to bring 10 years of progressive experience and take on a challenging new role with growth potential.

Skills
  • Data mining
  • Warehouse models
  • Quality analysis
  • Data analytics
  • Reverse engineering skills
  • Enterprise information architecture
  • Team building
  • Multitasking
Experience
Sr BI Architect, 06/2022 to Current
Icon Identity SolutionsNashville, TN,
  • Led the BI tools evaluation process, proposed and implemented Power BI platform as the enterprise reporting solution.
  • Architected the On prem Power BI Report Server solution by sizing hardware and software resources from a licensing cost and usage perspective.
  • Advocated and implemented star schema data model, data mart and standardized the use of shared datasets and parameters in Power BI to reduce the report count, increase report throughput and usage.
  • Installed, configured and successfully deployed Power BI Portal in a development and production environment.
  • Architected role based access control (RBAC) security model for Power BI Portal access, dashboards and Paginated reports through Active Directory groups and creating custom groups in the portal.
  • Demonstrated to the executive sponsors the benefits of Power BI through presentations and proof of concepts by designing Power BI reports and dashboards.
  • Constantly engaged with the development team in pilot projects by demonstrating the benefit of Power BI shared dataset modeling for reporting.
  • Demonstrated the benefit of star schema data modeling using data warehousing best practices for efficient report building, performance and standardization leading to adoption of Power BI by report writers.
  • Mentored report writers on Power BI Report Builder (Paginated reports) for two dimensional pixel perfect reporting and Power BI Desktop tool for building effective visual dashboards using MSAS Cubes.
Lead BI Architect, 07/2015 to 05/2022
Cinch Home ServicesCity, STATE,
  • Partnered with Sales, Finance and Inventory team to create dashboards to track, monitor, alert and report on Key Performance Metrics.
  • Sales Management (Daily/Weekly/Monthly) dashboard played a critical role in the decision making process for Sears home during COVID by enabling them to pivot their business model to more strategic revenue lines
  • Sales Team Summary/Detail, Sales Order Analysis, Sales Management Phone were other dashboards created to drive visibility into day today operations and in turn led to better business decisions and outcomes during COVID times.
  • Advocated and implemented self service BI to enable users and management teams to create their own dashboards.
  • Created mobile dashboards and Mobile BI was adopted across the organization.
  • Trained users and mentored developers on dashboard and data modeling best practices.
  • Developed Power BI reports that are interactive and activate by using storytelling features such as bookmarks, selection panes, drill through filters also created custom visualizations
  • Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.
  • Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
  • Involved in internal Sprints, release schedules, and milestones through JIRA. Worked with client Business Analysts, Directors, and Data Engineers for project communications
  • Migrated reports and Dashboards from Tableau/MicroStrategy/OBIEE to Power BI. Lead the migration project to have one enterprise reporting platform. Coordinated with Microsoft team in setting up the capacities and workspaces required for organization and Power BI creator and Pro licenses.
  • Administer and manage development life cycles in Talend, Snowflake, Power BI, Tableau and OBIEE applications
  • Manage workbooks and help maintaining data glossary in multiple reporting platforms ● Used Kimball methodology in transforming independent SILOS to BI Warehouse
  • Created cross reporting platforms connections and helped marketing team to drive their analytics out of the warehouse
  • Technically lead team of 6 people
Sr BI Lead, 06/2014 to 07/2015
Citrix Systems IncCity, STATE,
  • Led the design, development and implementation of data warehouse architecture (Star & Snowflake), logical data marts & table structures (fact & dimension), dashboards and reports using Power BI tools to meet business and user needs.
  • Worked with sysadmins in installing, configuring, updating, and maintaining higher security of BI environment
  • Coordinated with data architecture and modeling teams in designing databases and Cognos reports. Provided support in all BI application development activities as per project requirements
  • Collaborated with senior data architect in creating model prototype designs in Framework Manager and helped with other development activities using Power BI application development as per project requirements
  • Recommended and developed effective strategies to improve performance and capacity of BI systems and related toolset functionalities. Adhered to established data management and data quality standards and best practices
  • Created reusable Geodatabase using US-State-Zip census file to create Shape Map layers, Polygon Map Layers on a map using GeoSpatial techniques like overlays,extract, join and proximity. Automated the entire process using Python scripts
  • Build PowerBI Dashboards to track anomalies in Sales data and track daily.
  • Work closely with the Sales Ops Coordinator and GEO Ops teams
  • Executes process to re-produce results for the data sets requested for individual GEOs
  • Work closely with Sales Systems team for awareness around Callidus environment issues/upgrades and outages. ● Interact with the Sales Compensation Operations to determine updates to Core Product Groups (CPG), Sales Compensation Plans
  • Perform edits if warranted under the guidance of the Sales Ops Coordinator (solely to drive credit recognition of the content)
  • Collaborate with internal stakeholders to understand changing business and technical requirements. ● Ability to learn, utilize and validate various applications (Analysis Cube, Advanced Excel, SQL etc.) for reporting, analysis, and data sourcing.
Team Lead, 05/2012 to 06/2014
Cross Country Home Services Inc.City, STATE,
  • Experience performing product gap analysis Interacted with functional and technical leads, SME’s, marketing, finance, and other business groups to identify, analyze, and document business requirements.
  • Designed and developed many Dashboards/Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts), and local & global filters and cache monitor.
  • Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformation and Workflows
  • Participated in analyzing ETL mappings using Informatica, used Transformations like Aggregator, Update, Filter, Lookup, Sorter.
  • Experience in working with PL/SQL while creating views in physical layer.
Education and Training
Master of Science: Information Technology, Expected in to Ohio University - Athens, OH
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Ohio University

Job Titles Held:

  • Sr BI Architect
  • Lead BI Architect
  • Sr BI Lead
  • Team Lead

Degrees

  • Master of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: