- Featured in:
-
More BI Architect Resumes
Use these BI Architect samples as a guideline or visit our extensive library of customizable best resume templates.
Select
Customize
Download
Find out what is the best resume for you in our Ultimate Resume Format Guide.
Additional Statistics Resume Samples
BI Architect Resume Samples
No results found
0-5 years of experience
As BI architect designed master data feeds from EDW to support a global enterprise contract management application.
- Reverse engineered application specific name-value pair database into a query friendly normalized data model to support reporting
- Worked on multiple aspects of implementing Contract Management System, with activities ranging from creating data model to support Selectica master data, building ETL processes across various business applications and configuring Selectica.
- Led, designed and implemented data extract processes using Oracle Stored Procedures to derive measurable metrics of Contract Lifecycle process.
- Supported critical business enhancements by implementing core business logic using Java, and JavaScript programming in Selectica.
- Mentored offshore team in designing and developing multiple system enhancements.
0-5 years of experience
Performed architecture and code review of the existing business model, established development and delivery processes, designed project execution plan.
- Developed Data Marts schemas for multiple business divisions (total of 4).
- Tuned ETL stored procedures, triggers and user defined functions. Designed and developed DTS packages, designed and enhanced OLAP cubes.
- Participated in numerous report development utilizing Active Report and Crystal Reports components.
- Supervised stress test and roll-out phases. Provided disaster recovery plan.
- Technologies: SQL Server 2000, Oracle, VB.NET, VBA, OLAP Server, DTS, T-SQL, Active Reports, Crystal Reports, UML, EDW Kimball Method
0-5 years of experience
Worked closely with a strategic consulting partner to understand the goals and organization strategy.
- Performed enterprise strategic BI DW Assessment and identified the gaps.
- Prepared Enterprise BI DW roadmap based on the findings from the assessment process.
- Recommended tools for BI and reporting
- Designed the high level architecture of the DW BI landscape.
0-5 years of experience
Re-architected and developed the Marketing Analysis data-marts using the Kimball methodology
- Managed the data migration of historical data into the newly designed data marts
- Analyzed and improved the load strategy of the existing ETL developed using PL/SQL
- Designed the Campaign Analysis Business Intelligence reports using Microstrategy
- Designed and developed Materialized views for aggregating and drilling across the fact tables
- Designed data marts for Churn Analysis and developed an algorithm for its loading
0-5 years of experience
Working in OptiFreight Data warehouse team as Data architect to convert current reporting system to new Teradata Data warehousing platform
- Conceptualize assist and design the solution approach for collapsing the existing data Warehouse application to the evolving OneSource EDW. Provide detailed roadmap for the implementation process.
- Identify and promote best practices and patterns for data modeling with respect, and provide oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes.
- Provide Technical recommendations for optimized data access and retention for the data warehouse and review of Solution architecture, High Level design documents. Build repository of reusable knowledge assets and implement best practices, concept documents for client education.
- Manage the Development team and the Production support teams involved in the engagement. Participate in staff recruitment activities for the engagement and mentoring team members.
- Designed and developed the Business Objects universe and template reports.
- Assisted and coached the business end-users in Business Objects XI reporting tool
- Identify opportunities for value addition to for effective use of BI applications, Lead aspects of proposal development process, scope out effort and cost of solution, develop statement of work
0-5 years of experience
Engaged to perform a BI Architectural assessment during Merger & Acquisition of J&J and Pfizer, Business Intelligence environment and data structures.
- Identified BI critical areas and introduced and recommended, procedural and technical improvements to drive standardization and integration, for ongoing and future success.
- Introduced Enterprise Architecture standards and framework to design and build technical solutions.
- Developed technology strategy and system roadmap based on understanding J&J BI strategy.
0-5 years of experience
Developed a BODS Landscape for DEV, QA. and PROD environment. Customer was facing throughput issues in extraction DSO and open hub tables. Developed and successfully implemented extracting write optimized DSO and tripled throughput. Obtained efficiency by pulling data instead SAP pushing data into Teradata via Informatica. BODS was used to pull data directly from SAP tables. Provided end-to-end solution and developed repeatable delta procedures.
- As an Information architect defined and communicated data integration vision and strategy including road map for business modernization program. The client is a leading defense contractor with strict security requirements. Helped in strategizing Information delivery and developed best practices in collaboration with data stewards. Responsible for enterprise data governance, enterprise architecture/integration.
- As a solution architect and BODS specialist got onboard on a special project before go live on 100% data validation integrating Wholesale and Retail systems and data quality measure and data governance. A complete solution with dashboard was delivered with data reconciliation data from AFS and ECC system. This involved tuning and efficient data loads involving millions of rows of data.
- Led a team with SAP Best Practices for Data Migration. In the capacity of ETL Architect help install BODS in Development, QA and Production environment. Developed best practices to migrate code across environments using central repository.
- Led a team to deliver data warehouse solution for Delta Dental a major insurance company. The solution included strict HIPAA rules for data governance.
- Created and implemented ETL installation and development best practices. It involved setting naming standards and fine tuning.
0-5 years of experience
Implemented Big Data Business Intelligence reporting solution for Metlife Compliance division to enable business users to produce standard reports in response to regulatory requests and analyze corporate data effectively.
- Developed Individual Life Policies with Claims Paid and Denied Compliance reports with Cognos Report Studio.
- Configured Cognos BI v.10.2 server connection to Metlife Big Data through the BigInsights Hive JDBC driver.
- Performed frame work modeling with physical, logical, and presentation layered approach.
0-5 years of experience
Lead the Data team through requirements, design and development for a complete overhaul of the Business Intelligence system at an Oil and gas company. Responsibilities throughout the full life cycle included data architecture design, logical and physical data model creation, requirements gathering and analysis for reporting and operational capabilities. Provided support to implementing Data Warehouse / Business Intelligence solutions and utilizing an extensive portfolio of experience and best practices. Responsibilities included conducting technical needs of reporting architecture, data warehousing, Data transfer, and serving as a subject matter expert in business intelligence concepts. Created and maintained company wide Business intelligence environment including SSIS, SSAS, SSRS, and SQL server 2005.
- Established cross-functional relationships and directed all requirements gathering, data analysis and documentation for enterprise projects to centralize data into one multi function data ware house system with advance reporting processes.
- Assisted in developing business intelligence strategies in coordination with data architect.
- Managed project management with scope of work, cost estimate, budget, work force, resource management, and deliverance.
- Managed full life cycle development of business intelligence systems for company.
- Provided support for Reporting services such as Analysis Cube Processing, Reporting services Pro-Clarity.
- Coordinated with users and developers for all data models techniques.
- Supported team with expert needs of creating and maintained company wide reporting structure in SSRS.
- Implemented system where internal and external users can access reports from SSRS environment.
- Applied Improved team production and efficiency with cross training along with best practice of project and team management process.
0-5 years of experience
Designed a Dimensional Model with views in Teradata from multiple Sources including Siebel
- Designed custom stars with newly identified Facts and Dimensions and also with existing conformed dimensions
- Developed a Custom Model and all the three layers (Physical, BMM and Presentation) in OBIEE RPD incorporating the new stars
- Migrated Informatica Mappings and Workflows from Development to Integration environment
0-5 years of experience
FMC Corp BioPolymer
- Gathered reporting requirements for profit center reporting.
- Utilized datasource 0EC_PCA_1 to extract summary records.
- Developed all InfoCubes, ODS, multi-providers, transformations and DTPs.
- Utilized multi-provider for current and prior year logical partitioning.
- Designed and configured reporting authorizations.
- Created all process chains and incorporated into the client’s nightly ETL schedule.
- Designed all PCA queries utilizing variables (text and characteristic), calculated key figures, and restricted key figures, formulas and standard workbooks.
0-5 years of experience
Drove the Database design choice for the Massachusetts DOE’s RTTT Grant proposal
- Provided their systems analysis from use cases through hardware and software usage and costs
- Provided a BI structure that will lead the current Enterprise Data Warehouse to a second phase
- Partnered with Massachusetts Department of Revenue on the complete rewrite of MassTax2 and moving the organization toward a more SAP based centralized service orientation.
0-5 years of experience
Chief architect of the BO XI RII reporting platform. This includes creation of technical architecture, administration of users and content, and performance management of BO XI RII system.
- Provided analysis for Rationalization and Consolidation of Reporting Platforms and the creation of a single Reporting Portal utilizing several Reporting Platforms.
- Designs and creates executive/operational reports and dashboards using BusinessObjects XI RII (Crystal XI, Desktop Intelligence, dashboard manager, performance manager, metrics, universes).
- Architects Data Warehouses/Data Marts, designs Star Schemas, Profiles Data, creates Master Data Management roadmaps/strategies.
- Proposed, architected, and implemented VB.NET/BusinessObjects SDK Enterprise solutions for streamlining administration of BusinessObjects XI RII users and objects. Example, creating a VB.NET solution for automation of restarting failed BusinessObjects reports for all or select users.
- Administered BO XI RII platform, applied and managed BO XI upgrades, service patches, hot fixes to the BO XI RII/III environment. Successfully orchestrated the migration from Business Objects 6.X and Crystal Enterprise 10 over to BO XI RII, SP 3.5 within 1 day.
0-5 years of experience
- Worked on the FI-CO, PP, MM, SCM and PLM data sources for extracting line item data into SAP BI.
- Executed the project system data in BW to retire existing legacy application for 1100 users worldwide.
- Created Reports RRI functionality incorporating Formula Variables, Calculated Key Figures, Restricted Key Figures in structures and Published the reports to security roles and portal by creation of iViews.
0-5 years of experience
- Reviewed SAP BW systems at [company name]and proposed recommendations to improve performance + integration with other systems in the landscape
- Recommended a combination of BEx, BO Interactive Analysis & BO Webi for Reporting strategy
- Proposed Architecture and Design standards
- Evaluated BW BPC system and suggested improvements, especially for Financial Calculation script logic & performance.
0-5 years of experience
Create on boarding orientation process document.
- Screen/Interview BI/DW developers, leads, and architects.
- Analyzed SendOuts Recruiting Application database.
- Reverse engineered database model of SendOuts application.
- Created complex SQL to validate SendOut application generated reports.
- Identified bugs in SendOuts extract process.
- Advised needed enhancements to SendOuts application in order to accurately track historical events of Consultants and Job Orders.
- Managed issues list for [company name] staff in regards to SendOuts reporting.
0-5 years of experience
Platform: Business Objects, SAS EBI, SAS Grid Manager, SAS OLAPServer, SAS EMiner, SAS Forecast Studio, SAS Model Manager, Oracle 10G, SQL Server, Teradata, Data Flux
- Responsible for providing infrastructural capacity performance to Senior IT leaderships
- Supervised the development of [company name] global SAS enterprise BI platform, emphasizing on multi business entity isolation and scalability between Burbank CA, Orlando FL and Paris FR
- Worked with IBM SAN Administrators on disk partitioning size (VPATHS) and I/O performance
- Designed and collaborated with IBM Web sphere engineers, on the creation of multiple application servers to provide high availability
- Supervised and performed Web Sphere and OS performance tuning
- Partnered with HP Open View engineer on the creation of SAS BI monitoring and alert mechanism for high availability
- Implemented password indexing of OS security identity
- Reviewed and translated business requirements into technical functions within the SAS BI Platform
- Configured and administered Platform LSF (Load Sharing Facility) to facilitate business requirements within the SAS BI environment
- Developed and implemented password notifying utility tool, to alert end-users of when their OS password shall expire
0-5 years of experience
Developed and Published Packages in Framework Manager – Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
- Developed metadata models with appropriate Joins, organized Folders according to the Business view and published the packages using Framework Manager onto Cognos Connection.
- Built complex Cognos reports using Query Studio and Report Studio for Ad-hoc and advanced report authoring.
- Worked closely with business users in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture
- Deployed the Reports, Packages & dashboards from testing environment to production environment.
0-5 years of experience
AMCAD automates the justice and records management ecosystem that includes courts, jails, prosecutors, probation, and county clerks and recorders offices. Public sector offices require comprehensive, integrated information management and AMCAD’s innovative suite of products and services including its integrated justice platform, a platform for government records solutions, document management services, and various data access technologies allow government offices to operate with enhanced efficiency and effectiveness.
- Collect, analyze and document business requirements and translate user requirements into technical solutions.
- Interacted with key users to identify requirements and develop technical specifications.
- Worked on Business Objects reporting on various data sources like MS SQL, Netezza, Henschen, and FoxPro databases.
- Involved in constant Requirements gathering and business needs with executives and traders for Dashboard design and development.
- Converted legacy BO reports to SAP BO XI R3.1 and SAP BO 4.1 Reports.
- Implemented both Accounts Payable Line Item and Accounts Receivable line item by enhancing business content.
0-5 years of experience
- Worked with Global Markets to implement global transparency program within aggressive schedule, ever-changing priorities and resource constraints in a highly complex technical environment.
- Performed planning, architecture and design of a strategic analytics and reporting solution to trace performance metrics, and ensure consistent and accurate metrics reporting to senior management.
- Conducted and managed the design and development of high volume, high performance QlikView in-memory solution architecture to support over 1 billion daily transaction volumes
- Performed technical leadership in dashboard design, data modeling, ETL, job automation, alert and notification and the integration with the Portal platform
- Designed and developed visualization components to support process automation, workflow and dashboard presentation framework on both desktop and mobile environment
- Participated in code reviews, QA/UAT testing, enhancement design and development, and deployment to support day-to-day business operations
0-5 years of experience
Added dynamic security to the cube to secure data for roles based on group membership in Active Directory.
- Added time calculations to the cube in order to support ability to slice measures by various time periods.
- Worked with principals, teachers, and business data analysts in testing dynamic security.
- Developed scalability and capacity planning strategy for upgrading to SQL Server 2008 R2.
- Test and analyze daily loads and cube processing and respond to system notifications to resolve load/processing failures as needed.
- Provide solutions for the Fulton County Schools superintendent and principals for 109 schools while supporting team DBAs and SSIS developer on data quality and integrity.
0-5 years of experience
Work with the system architecture and functionality for a new Business Intelligence environment.
- Validate the integrity of new data models and apply OBIEE features to fit detailed business requirements.
- Develop functional use case requirements to match with OBIA/Siebel Analytics capabilities.
- Worked with the subject area developers, and ETL group to refine the OBIEE/RPD to meet the reporting requirements of the business analysts.
- Worked to organize the presentation layer and created dashboards and reports to convert existing tools, i.e. excel, to BI Reports, and developed subject dashboards.
- Train staff in the use of OBIA tool set.
- Developed business logic abstractions for knowledgebase Supply Chain Ontology’s
0-5 years of experience
Solving Technical challenges by giving technical edge in Business intelligence solutions using MSBI technology. Contribution in designing a new system from end to end architecture & design
- Helped in architecting existing OLTP designed into more OLAP BI friendly reporting database
- Introduce SSIS, SSRS technologies to reform the manual process in customer service
- Solution to slow claim processing process into fast pace ETL Process
- Identify the stagnant design & process and give the solution to solve the business problems
0-5 years of experience
Work on COA (Chart of Account) DW re-design project as a lead BI Architect
- Create standards for ETL and BI Analytics.
- Responsible for re-designing and reviewing of ETL architecture, data modeling (STAR schema); performed gap and data analysis. Recommend best practices for ETL design.
- Worked with DBA team to improve existing DW infrastructure; worked with PeopleSoft technical team and BI users to gather technical and business requirements.
- Worked with other project teams to discuss and created future data integration plan and roadmap within the University.
0-5 years of experience
Worked as Data Migration Architect and Technical Lead to design and develop Data Mart and ETL for life policy data mart migration from DB2 to Oracle with couple of new source system.
- System Design, Designing ETL Framework, Data Modeling, Data Analysis, Gap Analysis and develop ETL Code
- Review Code for standards, performance
- Migration of BO reports from DB2 to Oracle
- Cutover planning, design for migration, data reconciliation report design for data validation
- Lead a team of 12 developers and 2 Tech Leads
- Worked on performance tuning of both ETL and Data retrieval for the reports.
0-5 years of experience
- Upgrade existing implementation on OBIEE 10g to 11g, including OBIEE repository/catalog as well as BI Publisher reports, on Windows 2008 64bit and on Oracle Enterprise Linux 64bit.
- Providing technical support for BI Publisher development as well as environment configuration for on-shore and off-shore team.
- Providing technical support for internal business user using OBIEE.
- Developing OBI Publisher reports, fixing bug and optimizing multi-sheet Excel generation through XSL translation as well as SQL query optimization and stored procedures in cross platform database environments.
- Skill used: OBIEE 10g/11g, OBI Publisher 10g/11g, Weblogic 10g/11g, SQL Developer, SQL Server Management Studio, Oracle 11g, Microsoft SQL Server.
Rate This Article
BI Architect
Last edited by: Gabriela Barcenas, CONTENT STRATEGIST -
Gabriela Barcenas
CONTENT STRATEGISTGabriela is a Certified Professional Resume Writer (CPRW) and career adviser. With 10 years of digital media experience and five years of resume writing expertise, her publication history includes fashion, education, travel, social justice, equitable design and career advice.
