We provide IT Staff Augmentation Services!

Bi Architect Resume

0/5 (Submit Your Rating)

CO

SUMMARY

  • A proactive principal/Data warehouse Lead consultant with cross domain knowledge in Financial, Human resource, Telecom, Retail, sales & marketing with in - depth technical and Functional knowledge in Data Warehousing / Business Intelligence applications
  • Around 10 years of total experience of global IT consulting and implementation experience in full life cycle of Data warehousing and Business intelligence applications in USA, UK and APAC.
  • Strong expertise in Business Intelligence, Performance Management, Requirement analysis, Data warehousing(OLAP), Data Modeling, Data Modeling, Data Analysis, OLTP system design, Testing and implementation Including OBIEE (Siebel Analytics), Informatica, DAC, OBIA (7.9.X.X).
  • Implemented procurement & Spend Analytics, Financial, Supply Chain & Order management, Marine, Human Resources Analytics and customer care sales analytics using OBIA 7.9.6.x and OBIEE 11.1.1.7.1 &10G.
  • Upgrade and Customization of OBIEE (Siebel Analytics), Oracle BI 10g/11g, Hyperion, ODI, Informatica.
  • Familiarity with Implementing OBIEE Custom data warehouse solutions & Pre-Built BI Analytics.
  • Establish the technical Architecture for risk data systems and initiatives.
  • 1+ years of experience in Pre-Sales (RFP, Estimation, Staffing), POC, BI Product evaluation, Enterprise Level Architectural Simplification, ODC Setup &SOW (Statement of Work) Finalization.
  • Extensive experience in Mobile BI Product Evaluation (i.e. OBI HD, SurfBI, RoamBI).
  • Strong expertise in customizing BI Apps Modules based on business requirements.
  • Extensive Experience in Oracle Exalytics (Summary Advisor, TimesTen),Mobile Bi Product Evaluation & Maps(spatial)
  • Migrated the RPD and catalog From OBIEE 10g to OBIEE 11g & PS1.
  • Migrated Entire OBIEE systems to Exalytics machine.
  • Imported Cubes from Hyperion Essbase to OBIEE Rpd.
  • Experience in Installation and Configuration of DAC and resolving issues in ETL Loads.
  • Very Good experience with designing star schema, snowflake schema, FACT and dimension tables, physical and logical data modeling methodology
  • Extensive Experience in EBS R12 (Data & Object) security Integration with OBIEE.
  • Extensive Experience in OBIEE/OBIA Server Installations, Configuration & Upgrades.
  • Data Visualisation and infographic design - Tableau Software,D3, Processing, Js
  • Good Knowledge on noSQL and real time analytics.
  • Extensive Experience in design the Job Scheduling with Different Dependency to meet SAL Requirements
  • Extensive in depth, conceptual as well as practical knowledge of data warehousing and BI related techniques.
  • Good Knowledge in Performance Tuning In OBIEE. & Sql queries and Mdx Queries.
  • Experience in analysis, design, development and delivery of BI solutions
  • Well-developed organizational and communication skills, with strength in inter-personal relationships Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously.
  • Mentoring the Team Members for understanding the business criticality and working towards the Zero-defect delivery.
  • Proven strong analytical and logical skills with ability to follow project standards and procedures as per client specifications.
  • Involved in every aspect of project life cycle, including collaborative requirements gathering, creating work plans, functional requirements and unit testing plans
  • Proven team player who keeps multiple tasks in motion while maintaining the overarching project vision
  • Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented

TECHNICAL SKILLS

  • Report Metadata Designing
  • BI Development
  • Business Analyst
  • Data Modeling and Design
  • Cross Functional Reporting
  • BI Architecture
  • Exalytics
  • Times ten 11x
  • OBI Application 7.9.6.X
  • OBIEE 10g 11g
  • Informatica 8.6.1/9x
  • DAC 10g/11g
  • Oracle 10g 11g
  • Big Data /HadoopAnalytics
  • Tableau
  • OLAP and Data Warehousing
  • Peoplesoft (HCM & ELM)
  • Business Objects XIR2
  • MS SQL Server 2000/2005
  • Confidential 5.0
  • OLAP Mondrian Server.
  • FERMAT v6 v12

PROFESSIONAL EXPERIENCE

Confidential, CO

BI Architect

Responsibilities:

  • Works closely with end users to identify business requirements, technical issues and training needs; for BI solutions. Deliver business analytics, logical data modeling (multi-dimensional), query optimization, data load strategies and designs including data transformation and cleansing
  • End to End Implementation OBIA HR With ODI 11.1.1.8.1
  • Implemented SSO and Security Integration with OBIEE.
  • Gap Analysis/ Requirement gathering and Fixes.
  • Dashboards & Reports Customization, Mapping Customization, Execution Plan Customization
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Created Proof of Concept and Prototypes in OBIEE( 11.1.1.7.1 )
  • Developed, tested and provided support for OBIEE ( 11.1.1.7.1 )
  • Customization of OBIEE Look & feel and Cleaning the RPD Warnings/Errors for Check Model Consistency
  • Implemented Complex Security Framework for HRMS System.

Environment: OBIEE 11g, ODI11, ETL, BIAPPS 11.1.1.8.1 , ODI, Linux, Windows, Oracle 11g, Toad 9.0

Confidential

Data warehouse Lead

Responsibilities:

  • Works closely with end users to identify business requirements, technical issues and training needs; for BI solutions. Deliver business analytics, logical data modeling (multi-dimensional), query optimization, data load strategies and designs including data transformation and cleansing
  • The objective of the project was to upgrade OBIEE 11.1.1.5 to 11.1.1.7.1 as a prerequisite Exalytics Environment and achieve sub seconds performance of the Executive Dashboard which would help to roll-out Mobile BI to Executives. Carried out the following activities:
  • Defining the Overall OBIEE Architecture with 2 Exalytics Box, Fail-Over Instance & DR Environment.
  • OBIEE ( 11.1.1.7.1 ) Installation on Exalytics Linux Servers (Server Installation, Configuration)
  • Created Proof of Concept and Prototypes in OBIEE( 11.1.1.7.1 )
  • Developed, tested and provided support for OBIEE ( 11.1.1.7.1 )
  • Customization of OBIEE Look & feel and Cleaning the RPD Warnings/Errors for Check Model Consistency
  • Summary Advisor for Suggesting Timesten Aggregates
  • Implementing the Summary Advisor Aggregates & Familiar with index advisor in times ten.
  • Setting up the Fail-Over Instance For Exalytics Environment
  • Defining Architecture for EPM Suite Implementation on Exalytics to have better performance, consolidating the H/W for BI Applications.
  • Upgraded the Entire BI System to Exalytics (Engineering System) environment.
  • Undertake to translate BRD into Functional Specifications for development by Technology.
  • Handling the end to end process of the code migration from dev to the Production environment.
  • Configuring delivers, metadata and the write back features making the application more interactive for user.
  • Implemented LDAP Security for data level and object level based on departments.
  • Created Flash Marine, Manning reports for CEO and CTO.

Environment: ETL, Informatica 8.6.1, Exalytics, Timesten 11x, OBIEE 11.1.1.7.1 , HFM, Oracle 11g, Toad 9.0, LINUX & WINDOWS

Confidential

BI Risk Analyst

Responsibilities:

  • Stakeholder engagement to understand the new regulatory requirements on liquidity risk and work together to finalize Business Requirement Definition (BRD).
  • Drive iterative fact-finding discussions with stakeholders and technology to recommend solutions to deliver stakeholders’ requirements.
  • Establish the Business Architecture for risk data systems and initiatives.
  • Establish the framework for consumer risk data systems.
  • Manage the alignment of risk data to critical reporting initiatives.
  • Data mapping and definition alignment to risk processes.
  • Provide clarifications on definitions and escalate gaps/issues for resolution.
  • Coordinate testing and reconciliation of outbound reports against risk and finance systems.
  • Investigate/Resolve data issues.
  • Document support process, rules, definition and mappings.
  • Upgraded OBIEE 11.1.1.6.2 to 11.1.1.7.1
  • Undertake to translate BRD into Functional Specifications for development by Technology.
  • Development and production support for Liquidity Risk application for 18 countries.
  • Handling the end to end process of the code migration from dev to the Production environment.
  • Configuring delivers, metadata and the write back features making the application more interactive for user.
  • Provide functional & thought leadership for product configurations and resolution of data/process gaps.
  • In the project implementation phase be involved in periodic UAT cycles to promote the business requirements to production.
  • Developing and modifying the dashboards in OBIEE 10g /11g for supporting new business requirements.
  • Analyzing and fixing the report issue in OBIEE and ESSBASE Hyperion.
  • Working on the performance improvement of the reports in OBIEE 11g.
  • Implementing the Disaster Recovery failover servers.
  • Resolving the data functional issues OBIEE reports and IBOT.
  • Exporting and importing the data from ESSBASE cubes.
  • Analyzing financial systems based on business requirements.
  • Ability to tune report performance by analyzing physical SQL's * Strong in writing and understanding SQL's

Environment: OBIEE 11.1.1.7.1 , Hyperion Essbase Cube, ETL, PLSQL, Datastage, Oracle 11g, Toad 9.0, LINUX & WINDOWS

Confidential

OBIEE Technical Consultant

Responsibilities:

  • Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers& End users.
  • Installed and configured OBIEE Admin tool and Siebel web components including Intelligence Dashboards, answers, and requests.
  • Analyzing Oracle apps R12 Source systems based on business requirements.
  • Used admin tool to creation of repo by using physical layer, business model and mapping layer and presentation layers.
  • Created Complex reports
  • Using the Presentation Variable in prompts Report filters.
  • Creating Different types of hierarchy (Ragged, Unbalanced hierarchy) for business models in RPD.
  • Having good knowledge on merging RPD’s and Catalogs

Environment: OBIEE11g, Oracle EBS R12, Informatica 9, Oracle 11g, Toad 9.0, Linux & Windows

Confidential

Senior OBIA Consultant

Responsibilities:

  • End to End Implementation.
  • Gap Analysis/ Requirement gathering and Fixes.
  • Dashboards & Reports Customization, Mapping Customization, Execution Plan Customization
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Supported & Implemented the Coding of Informatica mappings for the different stages of ETL (SDE,SIL,PLP)
  • End-to-end design of DAC execution plans (Creating tasks in DAC pertaining to ETL mappings, embedding them into relevant subject areas and then assembling them into execution plans)
  • Setting up schedule in DAC for the Weekly & Monthly ETL load and monitoring of daily ETL load and trouble shooting in case of failures.
  • Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations & calculations.
  • Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
  • Created proactive agents, iBots to send alerts to the users onto their delivery profiles Confidential specified intervals
  • Implemented Security by creating roles and web groups, checks with external tables.
  • Designed and developed interactive navigational drill down reports in Siebel Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
  • Creating Different types of hierarchy (Ragged, Unbalanced hierarchy) for business models in RPD.

Environment: OBIEE 10.1.3.4.1 , OBIA 7.9.6.1, Peoplesoft (HCM&ELM), Linux, Windows, Informatica 8.6.1, DAC 10.1.3.4.1 , Oracle 11g, Toad 9.0

Confidential

Technical Consultant

Responsibilities:

  • End to End Out of box Implementation
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Implemented the Coding of Informatica mappings for the different stages of ETL (SDE,SIL,PLP)
  • End-to-end design of DAC execution plans (Creating tasks in DAC pertaining to ETL mappings, embedding them into relevant subject areas and then assembling them into execution plans)
  • Setting up schedule in DAC for the Weekly & Monthly ETL load and monitoring of daily ETL load and trouble shooting in case of failures.
  • Deployed (migrated) the entire application (DAC, RPD, and WebCat) from DEV to the TEST environment
  • Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
  • Created proactive agents, iBots to send alerts to the users onto their delivery profiles Confidential specified intervals
  • Implemented Security by creating roles and web groups, checks with external tables.
  • Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.

Environment: OBIEE 10.1.3.4.1 , OBIA 7.9.6.1, Oracle EBS R12, Informatica 8.6.1, DAC 10.1.3.4.1 , Linux, Windows, Oracle 11g, Toad 9.0

Confidential

OBIEE Architect

Responsibilities:

  • Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers& End users.
  • Installed and configured OBIEE Admin tool and Siebel web components including Intelligence Dashboards, answers, and requests.
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations & calculations.
  • Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
  • Worked on creation of repository variables and session variables.
  • Worked with the Security settings in OBIEE Admin Tool to set up users, groups, access privileges.
  • Documentation & presentation of the project
  • Involved in deployment process with platform team.
  • Designed and developed interactive navigational drill down reports in Siebel Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
  • Created complex reports i.e. Customization of Links using Go URL to navigate to multiple targets from single report values.
  • Creating Different types of hierarchy (Ragged, Unbalanced hierarchy) for business models in RPD.
  • Having good knowledge on merging RPD’s and Catalogs
  • Resolve the performance of the reports and having good knowledge in performance tuning.
  • Tested and validated the unit test cases

Environment: Oracle business Intelligence 10.1.3.4 (OBIEE), Windows Server 2003, Informatica 8.1.1, Oracle 9i,Oracle 10g,Toad 8.0 & 9.0.

Confidential

OBIEE Developer / Programmer

Responsibilities:

  • Gathering requirements, Analysis, functional and technical specifications, interacting with Business Managers and End users.
  • Used admin tool to creation of repositories by using physical layer, business model and mapping layer and presentation layers.
  • Worked on BMM layer to customize the tables, hierarchies, dimensions and aggregations and calculations.
  • Organized and customized the presentation layer in a format that is easy for end user to use as basis for reporting
  • Creating hierarchies for business models in RPD.
  • Worked on creation of repository variables and session variables.
  • Documentation & presentation of the project
  • Designed and developed interactive navigational drill down reports in Siebel Answers, requests and Intelligence Dashboards using various reporting features and functionalities such as formulas, filters, charts, pivot tables.
  • Using the Presentation Variable in prompts Report filters.
  • Tested and validated the unit test cases

Environment: Oracle business Intelligence 10.1.3.2 (OBIEE), Informatica 7.1, Oracle 9i & 10g, Toad 8.0

Confidential

Pentaho Report Developer

Responsibilities:

  • Integrated html and jsp with analysis reports for managers using Pentaho functionalities like MDX queries slice and dice, Drill down.
  • Experience in designing dashboards and reports in the Pentaho Bi Suite
  • Created parameterized analysis reports for drilldown will provide supervisors and managers the ability to look Confidential productivity metrics for the agents they manage.
  • Involved in configuration and Integration in Pentaho with Customer Care application.

Environment: Pentaho 1.6 Rc2, Olap Mondrian 3.0, Windows XP Prof, Kettle 3.0, Postgresql 8.3, Confidential 5.0, Oracle 9i

Confidential

Senior Business Solutions Engineer

Responsibilities:

  • Created reports using Pentaho functionalities like MDX queries, slice and dice, Drill down.
  • Analysis & Reporting Dashboards for Top Level Management Forecasting the
  • Transaction on verification process of postpaid CAF (customer application form)
  • Created Multidimensional reports& Graphs for App Verification pending by daywise, Monthwise for Agency.

Environment: Pentaho 1.6 Rc2, Olap Mondrian 3.0, Kettle 3.0, Sqlserver 2005 & 2000

Confidential

Senior Business Solutions Engineer

Responsibilities:

  • Reporting Solutions Based on OLTP Systems
  • Created Multidimensional Reports for agent’s information by using MDX queries.
  • Parameterised Reports are being generated for weekly, monthly For Total calls by Agents Based on Campaigns.
  • Created Table and Views which accessed data For Different Types of Reports
  • Created complex Crosstab reports for Agents Performance Detail.

Environment: Pentaho 1.6 Rc2, OlapMondrian 3.0, Kettle 3.0, Sqlserver 2000, Confidential 5

Confidential

Project Name: Operational Analytics

Responsibilities:

  • Transformations are created in Pentaho Data Integration which are in turn used in jobs and run to populate the data warehouse in Confidential target. Mondrain, which is the OLAP server, is configured to use the data from the data warehouse to generate multidimensional view of the data
  • Involved in configuration and deployment in Pentaho and Jboss as a Hibernate server.
  • Pentaho report designer and Pentaho report designer wizard will Generate Operational reports
  • Creation of Xml schema & X action File By Using Pentaho Cube Designer
  • Created complex reports such as Parameter Reports, Dependent Parameter Reports, Burst reports.
  • Created the reports using Pentaho design Studio like Pivot table With Diff types Of Chart,
  • Drill Slice and Dice. It has got drill down option using which we can drill down to the depth to get closer.

Environment: Pentaho 1.2 Enterprise Suite, Olap Mondrian 2.0, Jboss4.0, Kettle 2.0, Confidential 5.0

Confidential

Responsibilities:

  • Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
  • Used ETL to standardize data from various sources and load into Data Stage area
  • Used the Informatica power mart Designer to develop processes for extracting, clean, transforming, integrating, and loading data into data warehouse database.
  • Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy.
  • Processed session data using threads and various tasks and managed database connections and valid the workflow. Involved in the development of Informatica mappings and also tuned for better performance

Environment: Informatica 7.1 & 6.2, Ms Sqlserver 2000

Confidential

Responsibilities:

  • Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards
  • Used ETL to standardize data from various sources and load into Data Stage area
  • Used the Informatica power mart Designer to develop processes for extracting, clean, transforming, integrating, and loading data into data warehouse database
  • Created the mappings using transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Joiner and Update Strategy
  • Processed session data using threads and various tasks and managed database connections and valid the workflow
  • Involved in the development of Informatica mappings and also tuned for better performance

Environment: Informatica 7.1 & 6.2, Ms Sqlserver 2000

We'd love your feedback!