We provide IT Staff Augmentation Services!

Bi Architect Resume

Madison, WisconsiN

SUMMARY

  • 13 years of experience in the IT industry having experience in OBIEE, Tableau, Power BI,ODI, OBIA, DAC SSIS, and Informatica.
  • Good Experience which includes analysis, design, development, implementation, deployment and maintenance of business intelligence and data warehousing applications using OBIEE,OBIA and Informatica, ODI and DAC (Data warehouse Console).
  • Excellent knowledge of Data Warehousing Concepts.
  • Proficient wif OBIEE Admin Tool, Analytic Web and Scheduler.,
  • Expertise in creating and configuring Oracle BI repository.
  • Expertise in developing Physical layer, BMM Layer and Presentation layer in RPD.
  • Proficient in creating and managing Dashboards, Reports and Answers.
  • Extensive experience in configuring Interactive Dashboards wif drill - down capabilities using global and local filters and Metadata objects and Web Catalog Objects Dashboard, Pages, Folders, Reports .
  • Implemented Security Setup in web logic server Creating Users & Groups Defining Roles and policies .
  • Hands-on experience in Managing Privileges, Managing Interactive Dashboards, Managing sessions, Manage Presentation Catalog Groups and Users.
  • Experienced in configuring Usage Tracking and Multiuser Development Environment (MUDE).
  • Created and scheduled iBots using delivers to send alerts, run reports, and deliver reports to the users.
  • Expertise in configuration and integration of BI publisher wif BI Answers and BI Server. BI Publisher reports development; render the same via BI Dashboards.
  • Hands-on experience in performing the OBIEE administrator tasks such as migration and deployment of RPD, providing security and catalog migration from one environment to one another.
  • Integrated the BI Publisher wif Oracle EBS, BI Answers, Reports, and Dashboards, to generate standardized reports.
  • Expertise in implementing multi-dimensional modeling by using Hyperion Essbase and Cognos cubes.
  • Expertise in Design and Developing reports by using Hyperion Essbase cubes.
  • Expert in ODI 12c/11g setup, Master Repository, Work Repository,
  • Expertise in creating Projects, Models, Packages, Interfaces, Scenarios, Filters, Metadata and extensively worked on ODI knowledge modules (LKM, IKM, CKM, RKM, JKM and SKM).
  • Extensive Knowledge on Informatica PowerCenter 9.x/8.x/7.x for Extract, Transform and Loading of data from multiple data sources to Target Tables.
  • Knowledge on creating various mappings, sessions and Workflows. Knowledge on implementing end to end OBIA pre-built; all analytics 7.9.6.3.
  • Expert in configuring, designing, development, implementation and using Oracle pre-build RPD’s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements.
  • Wif Good Knowledge Of configuring DAC for data extraction from multiple sources and data processing/loading using any tools.
  • Delivering and implementing the project as per scheduled deadlines; extending post-implementation and maintenance support to the technical support team and client.
  • Fully conversant wif Life Cycle Methodologies from conceptualization to implementation and maintenance.
  • Very good experience in SQL and PLSQL.
  • Experience in various Business Domains like Manufacturing, Finance, Insurance, Healthcare and Telecom.
  • Experience on performance Tuning by implementing aggregate tables, materialized views, table partitions, indexes and managing cache.
  • Self-starter and team player wif good communication, interpersonal and analytical skills for interaction wif clients.

TECHNICAL SKILLS

BI: OBIEE, OTBI, OBIA, BI Publisher, TABLEAU, Power BI, Smart View, SSRS, Hyperion (FRS),Cognos

ETL: ODI, Informatica, Data stage, SSIS

RDBMS: Oracle, SQL Server, DB2, Teradata and NoSQL, Hyperion Essbase

Operating Systems: Windows 2000, XP, NT, UNIX, MS DOS

Languages: VB, C#, Java Core and R

Cloud: Microsoft Azure, SQL Azure, AWS, EC2, Red shift, S3, RDS, EMR

Web Technologies: HTML, CSS, ASP.Net.

Scripting: Java script, VB Script, Python, Shell Scripting

Tools: & Utilities: Microsoft visual Studio, VSS, TFS, SVN, ACCUREV, Eclipse, Toad

Modeling: Kimball, Inmon, Data Vault (Hub & Spoke), Hybrid

PROFESSIONAL EXPERIENCE

Confidential, Madison, Wisconsin

BI Architect

Responsibilities:

  • Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data using Business Requirement Document.
  • Integrating the new enhancements into the existing system.
  • Development of new reports as per the business requirements which involves changes in the design of ETL and new DB object along wif the reports
  • Developed the repository model for the different work streams wif the necessary logic dat involved creating the Physical, BMM and the Presentation layer.
  • Created new logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
  • Developed Time Series Objects using Ago and To Date functions for time series comparisons.
  • Created various session and repository variables and initialized them in the Initialization Blocks to change metadata dynamically as the environment changes.
  • Designed and developed various Interactive Dashboards and reports wif drilldowns, guided navigation, filters, and prompts.
  • Configured BI Scheduler and Oracle BI Delivers- iBots to deliver alerts and publish updated content to subscribed users as per the schedules and requirements.
  • Worked towards the Performance Tuning of Dashboards and Reports wif Business Analysts and DBAs.
  • Implemented security based on LDAP Autantication.
  • Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
  • Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
  • Integrated BI Publisher wif OBIEE to build reports in word, excel and doc format.
  • Created various templates, reports, and prompts in BI Publisher.
  • Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs.
  • Developed, supported and maintained ETL processes using ODI.
  • Customization to the Out of the Box objects provided by oracle.
  • Extensively used Integrated Knowledge Module and Loading knowledge module in ODI Interfaces for extracting the data from different sources.
  • Created ODI interfaces, functions, procedures, packages, variables, scenarios to migrate the data.
  • Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules.
  • Performance tuned the ODI interfaces and optimized the knowledge modules to improve the functionality of the process.
  • Developed reports by using QlikView.
  • Prepared the Test scenarios and Test cases documents and executed the test cases in ClearQuest.

Environment: OBIEE 12C, ODI -12C, Tableau, Window 2007 Server, Oracle

Confidential

OBIEE/ODI Architect

Responsibilities:

  • Gathered the business requirements, designed and implemented the custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle Business Intelligence (OBI) Analytics platform.
  • Designed and populated dimensional models both star and snowflake schemas for a data warehouse and Data marts.
  • Designed and Developed OBI Repository at 3 layers
  • In Physical Layer connecting to Data Warehouse & imported objects wif joins
  • Business Model / data mapping Create Logical tables, Drill-Down Hierarchies & complex joins.
  • Presentation Layer level create presentation catalogs and create presentation folders, test and validate the model.
  • Created different reports and dashboards.
  • Created different views of reports such as Pivot tables, Titles, Graphs and Filters etc and created different dashboards.
  • Creating reports and prompts in answers and creating dashboards and links for the reports.
  • Configured iBots for report delivery.
  • Designed and developed the Hyperion Essbase cubes.
  • Created different kinds of reports from multi-dimensional source systems (Hyperion Essbase Cubes)
  • Created aggregated reports from Hyperion Essbase cubes.
  • Implemented security at Object Level & Data Level for different level of hierarchies & Subject Areas.
  • Worked on Oracle Data Integrator components like Designer, Operator, Topology and Security Components.
  • Developed different procedures, Packages and Scenarios as per requirement.
  • Creating interfaces and mapping between source and target objects in interface.
  • Created jobs parallel and serial using Load plans.
  • Handled the ODI Agent wif Load balancing features.
  • Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse (EDW).
  • Performed Debugging and Tuning of mapping and sessions.

Environment: OBIEE 12C, ODI -12C,OBIA, Window 2007 Server, Oracle 12g

Confidential

BI Technical Lead

Responsibilities:

  • Collaborated wif the Functional Team and stakeholders to bring form and clarity to a multitude of data sources, enabling data to be displayed in a meaningful, analytic manner.
  • Estimated work and timelines, split workload into components for individual work which resulted in providing TEMPeffective and timely business and technical solutions to ensure Reports were delivered on time, adhering to high quality standards and meeting stakeholder expectations.
  • Coordinates and assists the activities of the team to resolve issues in all areas and provide on time deliverables.
  • Independently evaluate system impacts and produce technical requirement specifications from provided functional specifications.
  • Architected OBIEE solution to analyses client reporting needs.
  • Identifying key dimensions and measures for business performance, Developing Metadata Repository (.rpd) using Oracle BI Admin Tool.
  • Created Oracle BI Answers requests, Interactive Dashboard Pages and Prompts.
  • Involved in Reconciliation Process while testing loaded data wif user reports.
  • Involved in implementing different behaviours of security according to business requirements.

Environment: OBI EE 11G, OBI Apps 7.9.6.3, Informatica 7, DAC 7.9.6.3, Oracle 11G, Windows 2008 Server.

Confidential

Oracle BI& ODI Architect

Responsibilities:

  • Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data using Business Requirement Document.
  • Integrating the new enhancements into the existing system.
  • Development of new reports as per the Cisco business requirements which involves changes in the design of ETL and new DB object along wif the reports
  • Developed the repository model for the different work streams wif the necessary logic dat involved creating the Physical, BMM and the Presentation layer.
  • Created and managed Dashboards, Reports and Answers.
  • Developed, supported and maintained ETL processes using ODI.
  • Customization to the Out of the Box objects provided by oracle.
  • Extensively used Integrated Knowledge Module and Loading knowledge module in ODI Interfaces for extracting the data from different source
  • Created ODI interfaces, functions, procedures, packages, variables, scenarios to migrate the data.
  • Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules.
  • Development of new reports as per the Cisco business requirements which involves changes in the design of ETL and new DB objects along wif the reports.
  • Performance tuned the ODI interfaces and optimized the knowledge modules to improve the functionality of the process
  • Prepared the Test scenarios and Test cases documents and executed the test cases in ClearQuest.

Environment: OBIEE 11G, ODI -11g, SSRS, Window 2007 Server, Agile

Confidential

BI Technical Team Lead

Responsibilities:

  • Extracting business logic, Identifying Entities and identifying measures/dimension out from the existing data using Business Requirement Document.
  • Created RPD and Implemented different types of Schemas in the physical layer as per requirement.
  • Created Logical Schemas, Logical measures and hierarchies in BMM layer in RPD.
  • Implemented different Levels of Aggregate tables and define different aggregation content in LTS.
  • Created Different types of Dimensional hierarchies. .
  • Created different types of reports such as Pivot tables, Titles, Graphs and Filters etc and prompts in answers and created the Different dashboards.
  • Provided the Report Navigation and dashboard Navigations by using portal page navigations.
  • Implemented usage tracking and created reports.
  • Security configuration in web logic server and both at Repository level and Webcat level.
  • Configuring and working Wif Oracle BI Scheduler, delivers, Publisher and configuring iBots.
  • Created topologies (Data Server, Physical Architecture, Logical Architecture, Contexts) in ODI for Oracle databases and Files.
  • Created ODI Models, Data stores, Projects, Package, Package, Variables, Scenarios, Functions, Mappings, Load Plans, Variables, Scenarios, Functions, Mappings, Load Plans.
  • Responsible for Unit, System and Integration testing and performed data validation for all the reports dat are generated.
  • Enhancing performance by understanding when and how to leverage aggregate tables, materialized views, table partitions, indexes and managing cache.

Environment: Oracle BI EE (11g), ODI 11g, SSRS, SSIS, Windows 2003, Oracle 11g

Confidential

Oracle BI Senior Consultant

Responsibilities:

  • Participated in gathering the business requirements, analysis of source systems, design suitable data model, and develop metadata for the Analytical Reporting.
  • Created a repository and built the physical and logical star schemes.
  • Used the Different Levels of aggregate Dimensional tables and Aggregate Fact tables.
  • Created Views and Alias tables in physical Layer.
  • Created Dimensional hierarchies for Store, Calendar and Accounts tables.
  • Created the new measurable columns in the BMM layer as per the Requirement.
  • Created Different types of reports including Union and Merged and prompts in answers and created the Different dashboards.
  • Implemented the Different types of Functions like rolling functions, aggregated functions and TopN functions in the Answers.
  • Provided the Report Navigation and dashboard Navigations.
  • Customized all the dashboards, reports to look and feel as per the business requirements using different analytical views.
  • Implemented Data Level and Object Level Securities.
  • Implemented the caching.
  • Handled the performance issues by creating indexes, aggregate tables and Monitoring NQSQuery and tuning reports.
  • Peer review of code, testing, Monitoring NQSQuery and tuning reports.

Environment: Oracle BI EE 10g, Windows 2003, DB2

Confidential

Oracle BI Consultant

Responsibilities:

  • Creating Repository and designing physical and logical star schema.
  • Created measures and implemented formulas in the BMM layer.
  • Implemented Security management for users, groups and web-groups.
  • Set up an Analytics Multi-User Development environment (MUDE).
  • Created different views of reports such as Pivot tables, Titles, Graphs and Filters etc and created different dashboards.
  • Creating reports and prompts in answers and creating dashboards and links for the reports.
  • Configured iBots for report delivery.
  • Creating ETL mappings and different kinds of transformations like Source qualifier, Aggregators, lookups, Filters, Sequence, Stored Procedure and Update strategy.
  • Created and used Reusable Transformations to improve maintainability of the Mappings.
  • Created various Reusable and Non-Reusable tasks like Session.
  • Responsible for monitoring sessions dat are running, scheduled, completed and failed.
  • Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
  • Responsible for Unit, System and Integration testing and performed data validation for all the reports dat are generated.

Environment: Oracle BI EE 10g, Informatica, Windows 2003, Oracle 10g

Hire Now