We provide IT Staff Augmentation Services!

Sr Data Warehouse/obiee Developer Resume

Albany, NY

SUMMARY

  • Complete Software Development Life Cycle implementation experience of Data Warehouse/Data mart and Business Intelligence using Oracle Business Intelligence (OBIEE), Oracle BI Apps, Enterprise wide Data Warehouse and Informatica Power Center.
  • Over 9 Years of strong experience in OBIEE Administration tool, Presentation Services and Scheduler.
  • Worked with client implementations including Confidential Inc, Laclede Gas and Confidential Inc. Have Knowledge of Cisco business and processes.
  • Expertise in converting and using Oracle pre - build Rpd’s (Financial, HR, Sales, Supply Chain, Order Management, Marketing Analytics, etc.) according to business requirements.
  • Experience in configuring in Data Warehouse Administration Console(DAC) and ETL (Informatica Power Center Jobs.
  • Proficient in building analytical repository, and customizing the Oracle BI Apps repository business models, generating reports, and creating dynamic Dashboards using OBIEE.
  • Experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Reports/Dashboards, cache monitor, and building Siebel Analytics/OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) using OBIEE.
  • Worked on OBIEE Administration Tool, OBIEE Answers (ad-hoc querying, reports), OBIEE Dashboards, OBIEE Delivers (alerts) and Oracle BI Applications that are complete pre-built BI solutions.
  • Expert in configuring the Dimensional modeling (Star Schemas, Snowflakes and Aggregates), Metadata Configuration, and design ETL data extraction processes apart from prebuilt.
  • Expertise in configuring and scheduling BI publisher reports based on ORACLE database.
  • Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters, OBIEE Security Setup (groups, access/query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Used various sources like Oracle, DB2, SQL Server and Flat files.
  • Strong understanding of CRM and ERP transactional data model and dimensional modeling/Data warehousing concepts and designing of Star/Snowflake schemas.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 98/2000/2003/ NT/XP/Vista/7, Linux, AIX

BI TOOLS: OBIEE (Oracle Business Intelligence Enterprise Edition) 10.1.3.x, 11.1.1.x, Oracle BI Apps 7.9.6/7.9.5 , Oracle BI Administration Tool, Oracle BI Answers, Oracle BI Interactive Dashboards, BI Publisher.

ETL TOOL: Informatica PowerCenter 9.x/8.x/7.x, ODI 12 C

SCHEDULING TOOL: DAC 10.1.3.

DATABASES: Oracle 8i/9i/10g,11g, MS SQL Server 2000, 2005, MS Access, DB2

PROGRAMMING LANGUAGES: C, C++, and SQL/PLSQL

OTHER TOOLS: TOAD, SQL Developer, Microsoft Office Suite (Visio, Project)

APPLICATIONS: Adobe Dream Weaver, Flash

WEB TECHNOLOGIES: HTML, CSS, XML

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr Data Warehouse/OBIEE Developer

Responsibilities:

  • Played a role on delivering the presentation layer of data assets to business units and to assist those users in obtaining optimal value from the data. Developing and building dashboards, reports, and dimensional models as well as working as a part of the data warehouse team are the primary functional activities.
  • Was part of NYSOH Team, used to participate in Agile meetings, support and involved in End to End RPD Design and deployment and involved in Code Review, testing of developed Reports.
  • Worked on Source Systems - Siebel, ACD ( Avaya) and Pipkins.
  • Built Reports based on Siebel source systems like Agent Performance by supervisor, Agent Attendance, Agent Log Report and skillset and created Agents Reports for Supervisor to check Agents monthly performance scoreboard.
  • Created complex reports by using direct database request.
  • Used to present Design Review for Complex Reports with team to get sign off for Development.
  • Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drilldowns.
  • Working along with the ETL developers on the data loading process to ensure that the final data in the warehouse meets the reporting requirements. (granularity, dimensions and facts etc)
  • Worked extensively on components like Oracle Enterprise Manager (EM), Oracle Weblogic server administration console and application (presentation services).
  • Customization of OBIEE report interfaces using custom skins and styles and also the logging home page of presentation services.
  • Support and test for the code which already passed the development and testing phases on a daily basis.
  • Created custom metrics based on the existing facts and dimensions as requested by the customers with appropriate aggregation rules.
  • Worked along with the migration team, provided migration documentation to ensure there are no hiccups during the code migration between development, testing and production environments.

Environment: OBIEE 11.1.1.7.1 , Informatica, Siebel, Redhat, Toad, Putty, Filezilla, Jira, Windows Server 2008 R2.

Confidential, St louis, MO

Sr OBIEE Consultant

Responsibilities:

  • As a Sr OBIEE consultant worked in coordination with business analysts to estimate, understand and finalize the reporting requirements which are intended to be developed within the OBIEE scope.
  • Extensively worked on OBIEE Administrationtool to develop and enhance metadata.
  • Configured Schema/Diagramsusing Fact, Dimensions, Physical, Logical, Alias and Extension tables.Designed and developed Performance Measurement Reports that are Dynamic & Interactive with intuitive drilldowns, drill-across & flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-charts), Capabilities split reports for summary & details information, local & global filters and cache monitor using OBIEE.
  • Implemented the business rules such has Dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Cache Management in Business Model and Mapping Layer.
  • Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems.
  • Also involved in developing ETL mappings using Informatica 8.6, used Transformations like Aggregator, Update, Filter, Lookup, Sorter. Worked in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
  • Maintained the Full and Incremental loads throughDACon different environments like Development, QA and Production environment.

Environment: OBIEE 11.1.1.7.1 , SQL Server Management Studio, Informatica 9.5, Redhat, Toad, Putty, Filezilla, Windows Server 2008 R2.

Confidential, Bartlesville, OK

Sr OBIEE/Informatica Admin

Responsibilities:

  • Applied patches on OBIEE 11g ( 11.1.1.6.6 ) on Dev, Test and Prod.
  • Configured MUD in Dev and prepared the documentation.
  • Migrated RPD and Catalog from DEV to Test and Prod.
  • Designed, implemented and developed ETL process against data sources.
  • ManagedSecurity settingsin OBIEE Administration Tool.
  • Configured LDAP security in all the environments.
  • Managed PowerCenter 9.5 instances. Performed Backup / Recovery of Informatica Workflows, Mappings.
  • Coordinated with UNIX and Database Administrators.
  • Provided technical support for the Informatica environment.
  • Managing documentation of application administrator duties.
  • Involved in Migrating Mappings, Workflows from one environment to other.

Environment: OBIEE 11.1.1.6.6 , Informatica 9.5, Oracle SQL, Perforce, Toad, AIX, Windows Server 2008 R2.

Confidential, Milpitas, CA

Sr OBIEE Developer

Responsibilities:

  • Was part of Cisco Commerce Workspace(CCW) Team.
  • Upgraded OBIEE from 10g to 11g and configured the Security in web logic. Implemented object level security and data level security.
  • ExecutedOBIEE administrative taskssuch asOBIEE server installation,migrationanduser maintenance.
  • End to End repository creation, reports creation, prompts, dashboards and data modeling in OBIEE 11g.
  • Provide support in the implementation of OBIEE components. Configured different types of Reports. Drilldown techniques, Aggregationrules to meet client requirements.
  • Created Reports, Graphs, Pivot Table and View Selector, dynamic dashboard prompts and guided navigation link in Deal Management Reporting (DMR).
  • Worked on BI Publisher to create corporate standard report layouts.
  • Worked on Reports including Top Deals, Service Reports, Sales Usage Reports, Deal Lookup.
  • Worked on Multi-user development environment (MUDE) and created different projects.
  • Involved in merging and migrating applications from development to production for Deployment.
  • Implemented OBIEE Security (Object level and Data level Security in the OBIEE repository and answers) using repository variables, session variables and initialization blocks.
  • Created security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
  • Developed different kinds of Reports (Pivots, Graphs) using Global and local filters.
  • Performed performance tuning of dashboards/reports and made recommendations for changes to database.
  • Involved in the Development of Informatica mappings and mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.

Environment: OBIEE 11.1.1.6, Oracle 11g, TOAD, Oracle SQL, Windows XP, Windows Server 2008.

Confidential, Sunnyvale, CA

Sr OBIEE Developer/BI Analyst

Responsibilities:

  • Responsible for gathering business requirements meeting with business users and stakeholders and transform requirements in to functional/technical requirements.
  • Extensively worked on OBIEE Administrationtool to develop and enhance metadata.
  • Involved in modifications ofPhysical, Business and Presentation layersof metadata repository usingOBIEE Administration Tool.
  • Configured Schema/Diagramsusing Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Worked on Sales Analytics, Financial Analytics and Executive Analytics Dashboards. Financial Analytics Subject Areas: Financials - AP Balance, Financials - AP Invoice Aging, Financials - AP Transactions, Financials - GL Balance Sheet,, Financials - GL Cash Flow, Financials - GL Detail Transactions
  • Involved in customizing Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards as per user requirements.
  • Worked on Reports including Booking Trend Analysis, Sales Booking Analysis Trend, and Booking Forecast by Sales Territory.
  • Worked on OBIEE Answers to build Reports and Interactive Dashboards according to Functional Specific Documents.
  • Resolved production issues. Implemented the business rules such has Dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Cache Management in Business Model and Mapping Layer.
  • Worked on Multi-User Development Environment(MUDE) and created different projects.
  • Worked closely with users, developers and administrators to resolve ongoing production problems by reviewing design changes made to production systems.
  • Experience in using DAC to configure, monitor and schedule ETL routines.
  • Experienced in deploying Informatica workflows to the DAC and build dependency and dependent hierarchical tasks

Environment: OBIEE 11.1.1.5, Informatica 8.6.1, DAC 10.1.3.4, Oracle BI Apps 7.9.6.3, Oracle 11g, oracle SQL, Toad, Windows XP.

Confidential, Denver, CO

OBIEE Developer/Admin

Responsibilities:

  • Installed OBIEE 11g on Dev and Test server and configured Active Directory with user and group authentication in web logic.
  • Created BI support schemas and domains using RCU (Repository Creation Utility).
  • Developed reports for Proof of Concept and deployed RPD’s in Weblogic.
  • Use to monitor the performance of the reports.
  • Created new subject areas as per the requirement for the business users and exposed the subject areas at presentation layer.
  • Worked with Oracle BI Server, Presentation Server, Oracle BI Administration Tool.
  • Developed Reports/Dashboards with different Analytics Views using Oracle Business Intelligence
  • Presentation Services.
  • Created guided navigation links to help files within the dashboards to help the end users.
  • Created many pivot table requests allowing manager’s to analyze the business/data from different perspectives.

Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.3, Hyperion 9.3.1, SQL Server 2005, Toad, Windows server 2008R2

Confidential, Des Plaines, IL

Sr OBIEE Developer

Responsibilities:

  • Involved in full project life cycle.
  • Worked with Revenue Fact and Geography Dimensions using Oracle BIEE 10.1.3.4 for generating reports for managers, executives and individuals.
  • Worked with the physical layer to create Connection pools and imported physical tables and defined joins.
  • Worked on Oracle BIEE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
  • Worked and developed Repository (.rpd), configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
  • Developed and modified reports in BI publisher. Designed, developed, test, document, and deployed.

Environment: OBIEE 10.1.3.4/10.1.3.3 , XML/BI Publisher 5.6.3, SQL*PLUS, Oracle 10g, TOAD, Unix

Confidential

Oracle Developer

Responsibilities:

  • Communicated with clients regarding system requirements, ensuring the development and implementation of customized products to customer satisfaction.
  • Prepared functional specifications for user requirements.
  • Developed and modified applications, authored database procedures and triggers for data processing.
  • Developed PL/SQL Packages, Procedures, Database Triggers, and Functions to implement business logic.
  • Created Entry Forms/Reports for various modules. Created Databases, Loaded Initialization Data,
  • Generated Users, and assigned Roles and access.

Environment: Oracle8i, SQL, PL/SQL, SQL*Loader, Sun Solaris