We provide IT Staff Augmentation Services!

Sr. Bi Architect Resume

3.00/5 (Submit Your Rating)

Irvine, CA

Hire Now

SUMMARY

  • Top performing DW and BI professional with over 10 years of experience across diverse industries
  • Spearhead strategic analysis & plans, transform requirements into leading edge data solutions
  • Maximize quality, integrity and value of data, applications and systems
  • Improve access to key performance indicators, deliver useful, robust data warehouses
  • Provides 360 - degree hands-on experience as architect, analyst, developer, project manager and consultant

SUMMARY

Confidential Irvine, CA

Sr. BI Architect

Responsibilities:

  • Design and Implement Business Intelligence and SQL Solutions
  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012/2014/2016/Azure SQL
  • Develop OLAP Cube/Tabular models for reporting
  • Develop Data Strategies
  • SQL Development - Views, Stored Procedures, Functions
  • Report Development - SSRS, Tableau, Microsoft PowerBI, Microsoft PerformancePoint

Project Technologies: SQL Server 2012/2014/2016, SSIS, SSAS (Olap & Tabular), SSRS, Microsoft Power BI, Azure Data Services, Azure SQL, Azure Automation, Azure Data Factory, Dynamics 365 (Operations & Finance)

Confidential Angeles, CA

Sr. BI Architect/Lead

Responsibilities:

  • Design and Implement Business Intelligence and SQL Solutions
  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012/2014/2016
  • Develop OLAP Cube for reporting
  • Develop Data Strategies
  • SQL Development - Views, Stored Procedures, Functions
  • Report Development - SSRS, Tableau, Microsoft PowerBI, Microsoft PerformancePoint

Project Technologies: SQL Server 2008 R2/2012/2014/2016, SSIS, SSAS (Olap & Tabular), SSRS, Microsoft Power BI, MySQL, JSON, Master Data Services, Data Quality Services, Power View, Power Query, Tableau, Qlik, Data Science; Amazon Redshift

Confidential Simi Valley, CA

Architect

Responsibilities:

  • Design and Implement Reporting Solution for the Cyber Security infrastructure - $250K Saved
  • Work with Six Sigma principles for creating data collection plans.
  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012
  • Develop OLAP Cube for reporting
  • Install and Administer SharePoint 2012, with reporting delivery in PerformancePoint
  • Prototype Solutions using SQL Master Data Services

Project Technologies: SQL Server 2012, SSIS, SSAS, MDS, Sharepoint 2010, PerformancePoint

Confidential Los Angeles, CA

Prosum - Sr. BI Consultant

Responsibilities:

  • Design and Implement Business Intelligence and SQL Solutions
  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012
  • Develop OLAP Cube for reporting & forecasting
  • Create Views and other items necessary for reporting

Project Technologies: SQL Server 2012, SSIS, SSAS, SSRS

Confidential

Data Architect/Developer

Responsibilities:

  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012
  • Develop OLAP Cube for reporting
  • Create Views and other items necessary for reporting
  • Working with Big Data, doing analysis.

Project Technologies: SQL Server 2012, SSIS, SSAS, HDInsights (Hadoop)

Confidential .

Data Architect/Developer

Responsibilities:

  • Architect and design Data Mart for reporting
  • Develop ETL using T-SQL and SSIS, SQL Server 2012
  • Develop OLAP Cube for reporting
  • Create Views and other items necessary for reporting
  • Install and Administer SharePoint 2012, with reporting delivery in PerformancePoint
  • Assist .NET development team in presentation layer of data via customer portal

Project Technologies: SQL Server 2012, SSIS, SSAS, SSRS, SharePoint Server 2012

Confidential, WA

Technical Program Manager

Responsibilities:

  • Architected Data Marts and a Data Warehouse for reporting
  • Project Management, budgeting and forecasting
  • Created Technical User Stories
  • Mentored EBI PM’s on Business Intelligence and Data Warehouse methodologies

Project Technologies: T-SQL, SSIS, SSAS, Project, VSTF, Tableau, Excel Data Reporting

Technical Program Manager I

Confidential - IT Pasadena, CA

Responsibilities:

  • Architected Data Marts and a Data Warehouse for reporting on Remedy, a ticket tracking system
  • Developed and updated reports for various departments within KPIT
  • Supported various departments within KPIT to handle data and creating reports
  • ITIL V3 Certified

Project Technologies: T-SQL, MDX, SSIS, SSAS, SSRS, Microstrategy

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship