We provide IT Staff Augmentation Services!

Senior Obiee/etl Consultant Resume

MassachusettS

PROFESSIONAL SUMMARY

  • Over 8 years of work experience in the IT, acquiring both technical and functional skills

  • 4+ years experience in implementing OBIEE, Informatica for reporting, ETL, Data warehouse
  • Experience in development and implementation of OBIEE 11.1.1.6.7 , 11.1.1.3 and 10.1.3.4 Technical Developer with expertise in OBIEE Admin Tool, Analytics Web, Presentation Services, Security setup
  • Experience in configuring and customizing the reports of Procure and Spend, Revenue Financial Analytics in OBIA 7.9.6.4
  • Experience in OBIEE Design, Development and Production support Including Business modeling, Requirements gathering, Development, Configuration, Testing and Deployment for Oracle BI Enterprise
  • Experienced in using oracle BI administration tool to design and develop application metadata for three layers (presentation layer, business model and mapping (BMM) layer and physical layer)
  • Actively involved in performance tuning by setting cache management, clustering (vertical), lookup tables, connection pool management, session and other properties accordingly
  • Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication
  • Experience in Merging Repositories and experience in setup and configuration of Multiuser Development Environment (MUDE) and using merge utility to facilitate the development of application metadata in enterprise scale deployment
  • Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas
  • Expertise in Report Bursting using BI Publisher
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate wide ETL Solution
  • Extensively Developed Informatica Complex Mappings
  • Experience in developing, testing and implementing Triggers, stored procedures and functions using PL/SQL
  • Experienced in development, database maintenance, enhancement and production and batch support environments for applications involving Mainframe technologies as COBOL, JCL, DB2, VSAM
  • Working experience in developing applications with Object Oriented Programming concepts
  • Knowledge of extracting the data from Essbase cubes

TECHNICAL SKILLS

  • OBIA 7.9.6.4,DAC 11g

  • BI Reporting Tools: OBIEE 11.1.1.5,11.1.1.6, 11.1.1.6.7 , 10.1.3.3/10.1.3.4 , BI Publisher, Hyperion 11.x Interactive Reporting
  • Databases: Oracle 11g/10g/9i, Microsoft SQL Server, DB2,XML and Flat files
  • DB Analysis Tools: SQL* Plus, SQL Developer, TOAD
  • Languages: PL/SQL, C, C++, SQL,T SQL, COBOL,JCL,VSAM, CICS
  • Operating Systems: Windows All versions
  • ETL TOOLS: OWB 11g ,Informatica Power Center 9.1/8.6.0/8.5.1/8.1/7.1.1
  • Methodologies: SDLC (Software Development Life Cycle), Agile Methodologies

PROJECTS

Confidential,Massachusetts

Senior OBIEE/ETL Consultant

Responsibilities

  • Worked closely with Business to gather Analytics requirements to develop KPI Dashboards using OBIEE 11.1.1.6.7

  • Involved in the Migration of OBIA modules such as Procurement and spend, Fiancials,HR modules to Production
  • Actively involved in Post Production Support of all the OBIA modules
  • Customized oracle out of the box Financial analytics and Procure and spend dashboards from oracle out of the box
  • Modified the Procure and Spend SDE Mappings in order to customize the data flow as per the user requirements
  • Developed the scripts of Procure and Spend reports to test the data after full and incremental loads
  • Scheduled the Daily and Incremental load in DAC in production environment
  • Monitoring and supporting the daily incremental load in production
  • Customizing and cleaning up the RPD from the oracle out of the box according IDC standards
  • Customized the permission setup on Subject areas in RPD and in Catalog Manger
  • Resolved security issues related to Agents, Briefing Books and Dash boards
  • Set up the Usage Tracking in RPD and created various reports for Usage tracking as per the Oracle standards
  • Implemented MUDE functionality in the project to enhance parallel usage of the RPD
  • Designed and customized home grown Revenue data mart using OWB 11g
  • Involved in the fit gap analysis for moving the Revenue Analytics project to OBIA
  • Developed revenue pre stg table according to OBIA standards to move home grown revenue data mart to revenue OBI Analytics
  • Running and supporting the OWB revenue loads on a monthly basis

Confidential, Massachusetts

Senior OBIEE Consultant

Responsibilities

  • Participated in the design, development, deployment and production support of reporting solutions that meet requirements of business users. This includes documenting the processes to ensure standards and compliance.

  • Developed PL/SQL scripts for complex business logics like to calculate measures inward, outward premiums, claim payments and reserves.
  • Designed dashboards/reports to track Forecast, Goals, Claim Bookings, Discount %, No of Claims, No of Customers per Theater, No of Policies Renewed.
  • Experience in working on Sales Bookings, Forecast, Theater (Geographical View), and Product, Solutions, Customer, and Opportunity data.
  • Working on OBIEE 11G Sandbox versions to migrate reports from 10g to 11g.
  • Created Dimensional Hierarchies for Drill Down, Level Based Measures and Created Aggregated Tables to improve the Performance of the Reports.
  • Gathered requirements to implement OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables.
  • Created Global Prompts, Charts, Pivot Tables, Compound layouts to design the dashboards.
  • Created different Time series reports (using Month ago,To date) to develop more enhanced reports.
  • Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
  • Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
  • Conducted workshops to increase adoption of the dashboards that help users to use reports than Ad hoc data.
  • Conducted User training for several dashboard/ Reports to help them improve metrics that help them drive critical decisions.

Confidential, Maryland

OBIEE Consultant

Responsibilities

  • Performed gap analysis and feasibility study for the given requirement.

  • Created mockup reports and dashboards for review by the business users.
  • Customized the OBIEE Repository (physical, BMM, and presentation layers).
  • Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
  • Created dimension hierarchies, aggregates, and keys in the BMM layer.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Worked on repository and session variables.
  • Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
  • Created materialized views and aggregates to improve performance.
  • Created different Time series reports (using Month ago, To date) to develop more enhanced reports.
  • Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
  • Performed Data Validation of data in the reports and dashboards.
  • Performed Unit testing, integration testing to verify the report functionality and debugged dashboard reports to verify data matches as expected.
  • Worked extensively with BI Publisher 11g.
  • Created Data Models and RTF Templates for various reports.
  • Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
  • Documented the design for intuitive understanding and future reference.
  • Performed production support for the project.

Confidential, Boston,Massachusets

OBIEE/ETL Developer

Responsibilities

  • Worked during the whole life cycle of the project from requirements gathering to deployment.

  • Analyzed the data and developed Logical Star Schema model with consultation from Data Modelers and Business Analysts.
  • Created new logical columns, dimensional hierarchy, calculated measures, and aggregate
  • Developed Time Series Objects using Ago and ToDate functions for time series comparisons.
  • Created security settings in OBIEE Administration Tool and set up groups, access privileges and query privileges and also managed security for groups in Answers.
  • Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
  • Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.

Confidential, USA

ETL Developer

Responsibilities

  • Understood the Business requirement documents for an ETL design and source to target specifications

  • Design and develop Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables
  • Used transformations like Connected and Unconnected Lookups, Aggregator, Expression, Joiner, Update, Router and Sequence generator
  • Created reusable transformations and mapplets and used them in complex mappings
  • Involved in unit testing by debugger tool and analyze the bottlenecks for better load performance the ETL processes
  • Developed and scheduled Workflows using task developer, worklet designer and workflow designer in Workflow manager and monitored the results in Workflow monitor
  • Applied CDC logic to load incremental data from source to Data warehouse (EDW)
  • Performed unit testing and Involved in tuning the Session and Workflows for better performance
  • Deployed ETL mappings from development to multiple environments.
  • Participated in Team Meetings, knowledge transfer and change Management process

Confidential, Hartford, USA

ETL Developer

Development/Maintenance Responsibilities

  • Involved along with the Business analysts in requirements gathering and building specifications documents, in accordance with Insurance business rules

  • Extensive research into Legacy systems to find data anomalies and report it to the source systems
  • Co ordinate with the source system personal to achieve the requirements of GCS
  • Extracted data from various Legacy systems like Genius, WINS and Phoenix systems, transform the data according to the business logic and load the transformed data into relational targets
  • Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica
  • With extensive knowledge of Insurance business, developed Source to Target Mappings using Informatica Power Center 8.6.1.
  • Extensively used Transformations like Router Transformation, Filter Transformation, Aggregator Transformation, Normalizer Transformation, Source Qualifier Transformation, Union Transformation, Joiner Transformation, Lookup Transformation, Expression Transformation, Stored Procedure Transformation and Sequence generator Transformations
  • Extensively used the Informatica Debugger for debugging the Mappings associated with data failures or failed Sessions
  • Created and managed daily, weekly and monthly data operations, workflows and scheduling processes
  • Actively participated in the client meetings and suggested solutions for critical tasks
  • Involved in enhancement, maintenance, and documentation support for ETL program using Informatica

Environment

Informatica Power Center 8.1.6, SQL Server 2008, SSIS, Autosys

Confidential, Chennai,India

Mainframe Systems Analyst

Responsibilities

  • Arranging the joint discussion sessions for requirements gathering and reviewing the inputs given by users & clarify any queries with the end user

  • Preparation of the requirements document and technical design document for the enhancements
  • Modify and enhance the existing programs for different line of business as per the requirements detailed in the technical design document within the given time lines
  • Involvement in production support activities such as monitoring the daily batch cycle, fixing the abends, resolving critical or high priority call tickets within stipulated SLA i.e. 24hrs
  • Participation in daily meetings with the client to discuss and update about the batch abends and to update the status on the Call tickets
  • Scheduling the batch jobs based the new user requirements
  • Update the clients about the progress on the changes in the programs during daily meetings

Confidential, Chennai,India

System Analyst/Mainframe Developer

Responsibilities

  • Analyzed the current system and understood the as is process and documenting the same

  • Understanding the requirement for developing of a new Batch process to Compute and Store the QualityGuard+Plus Dealer Dividend Trend Information) for QualityGuard+Plus contracts in the host database
  • Developed a new pop up screen from the VESR DDTR option to display the QG+Plus DDTR information for NISSAN and INFINITI dealers
  • Enhancement of VSC Host system to process any QG+Plus dealer dividend bonus program Chargeback's for Nissan and Infiniti dealers during the 1st and 2nd half dealer dividend program close
  • Review the inputs given by NNA & clarify any queries with the onsite team
  • Work on the changes as per the requirements after interaction with the clients to understand the requirement specifications
  • Preparation of understanding documents with the knowledge gained by analysis of the systems
  • Monitoring and adhering to the pre defined Quality norms and procedures

Hire Now