We provide IT Staff Augmentation Services!

Senior Obiee Developer Resume

Dearborn, MichigaN

SUMMARY:

  • Total 11years of experience in requirements gathering,analysis,design Development,customization,testing and implementation of software Applications which includes Informatica Power Center,Datawarehouse Administration Console(DAC) and Oracle Business Intelligence Enterprise Edition(OBIEE),Oracle Data Integrator(ODI),Hyperion - Essbase.
  • Has very good experience onBusiness Intelligence reporting (10G & 11G) and Data Warehouse administration console(DAC).
  • 5+ years of experience in handling BI Publisher reports.
  • Extensively worked on Informatica power center 7.4.1,8.6& 9.5.1 versions.
  • Have very good experience on creating the cubes in Hyperion.
  • Have extensively worked in developing program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Has experience in analyzing, building, testing, and implementing Repository, Reportsand Dashboards using Oracle Business Intelligence technology platform
  • Experience in developing dimensional hierarchies with drill down, aggregate tables, time series functions, and rank and shares functionality.
  • Efficient problem-solver and decision maker with diverse experience in developing applications.
  • Fast learner; possess keen analytical & troubleshooting skills for effective problem resolution.
  • Experienced with ETL processes using Informatica Power center.
  • Good experience on Structured Query Language(SQL)and Procedural Language/StructuredQueryLanguage(PL/SQL)Procedures,functions,packages,Triggers,Views Etc.
  • Outstanding interpersonal skills to build a rapport with management, vendors, staff, peers and clients.
  • Has sound experience in delivering the defect free product on time.
  • Excellent resource balancing & leadership skills with an ability to drive initiatives through efficient team work.
  • Is always driven by team spirit and we-will-work-together attitude.
  • Having good knowledge on Oracle financials.
  • Experienced in setting up and working in multi-user development (MUDE) Environment
  • Experienced in managing and coordinating Onsite/Offshore teams
  • Well organized, good team player and self starter with a positive attitude. ability to quickly adapt to new technologies and business domain.

TECHNICAL SKILLS:

ETL TOOL: Informatica Power center 10.1.1/9.5.1/9.0/8.6.1/8.1.1/7. x

ELT TOOL: ODI-ORACLE DATA INTEGRATOR

Oracle Tool: Hyperion - Essbase

OBIEE Infrastructure: Oracle Business Intelligence Enterprise Edition(OBIEE) 11g/10g

Databases: Oracle 11g/10x/9x, IBM DB2, SQL Server,VSAM,PLSQL,Teradata

Domain Skills: Retail Business Services,Insurance - Property & Casualty Insurance,PMSC5.3,Health Insurance

Tools: Data warehouse Administration Console (DAC) 10G & 11G, CA-7

OPERATING SYSTEMS: OS/390, Windows 95, 98, 2000,XP,Linux,UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, Michigan

Senior OBIEE Developer

Responsibilities:

  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Reviewed and analyzed functional requirements, mapping documents.
  • Designed Finance dashboards.
  • Designed and developedRPD consists of Physical, BMM and Presentation layers
  • Helped the client set-up Multi User Development (MUDE) Environment and provided a detail documentation of the approach to be followed by the developers.
  • Re-Implemented security i.e. Object-level by creating roles & web groups.
  • As per the support model, monitored daily loads through DAC scheduler. Debugged failed tasks and created/modified the execution plans in DAC.
  • Implemented Custom web service in order to allow users to Change Password in OBIEE 11g.
  • Responsible for migrating RPD and web catalog between different environments.
  • Created tables, views in Teradata, according to the requirements.
  • Used Teradata utilities like MultiLoad, Tpump, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
  • Perform Teradata development support, including debugging, code maintenance, unit testing, change management, and promote to production methodology.
  • Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
  • Debugged performance issues in existing Out-Of-Box RPD and implemented use of aggregate tables.
  • Built BI Publisher reports for some of the projects using RTF templates.
  • Built Custom dashboards for comparing data between Source and Target environments.
  • Involved in User Acceptance Testing.
  • Conducted POCs for the company and demonstrated some of the OBIEE 11g new features.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.2 /11.1.1.7, BI Publisher 10g/11g, Informatica 10.1.1, Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata12

Confidential, OHIO, Mason

Informatica Developer

Responsibilities:

  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Reviewed and analyzed functional requirements, mapping documents.
  • Designed and developedRPD consists of Physical, BMM and Presentation layers
  • Helped the client set-up Multi User Development(MUDE) Environment and provided a detail documentation of the approach to be followed by the developers.
  • Re-Implemented security i.e. Object-level by creating roles & web groups.
  • As per the support model, monitored daily loads through DAC scheduler. Debugged failed tasks and created/modified the execution plans in DAC.
  • Implemented Custom web service in order to allow users to Change Password in OBIEE 11g.
  • Responsible for migrating RPD and web catalog between different environments.
  • Debugged performance issues in existing Out-Of-Box RPD and implemented use of aggregate tables.
  • Built BI Publisher reports for some of the projects using RTF templates.
  • Built Custom dashboards for comparing data between Source and Target environments.
  • Involved in User Acceptance Testing.
  • Conducted POCs for the company and demonstrated some of the OBIEE 11g new features.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.2 /11.1.1.7, BI Publisher 10g/11g, Informatica 7.4.1/8.6.1/9.5.1, Data Warehouse Administration Console(DAC), Weblogic Server 11g, Oracle 11g, Windows Server,Hyperion-Essbase,Teradata

Confidential, Columbus, OHIO

OBIEE Developer

Responsibilities:

  • Analysis on Task assigned
  • Discussion with the onsite members obtaining the requirements for the preparation of the document to cover the technical issues and correcting Task.
  • Sending MOU (Module of understanding) to OSC.
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Developed ETL programs using Informatica to implement the business requirements.
  • Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks.
  • Performed data manipulations using various Informatica Transformations.
  • Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
  • Reviewed and analyzed functional requirements, mapping documents.
  • Designed and developed RPD consists of Physical, BMM and Presentation layers
  • Designed, developed and Customized reports and dashboards using different analytical views
  • Configured dimensional Hierarchies, Aggregate Navigation, Level Based Measures and Time Series.
  • Developed different kinds of reports (pivots, charts, tables) using global and local filters.
  • Implemented Data level and Object level security.
  • Worked in Multi user developmentenvironment(MUDE).
  • Code Review.
  • Involved in unit testing and production support as well as documentations.
  • Sending UTR to OSC.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, OBI Administration,Informatica Power center 9.0/8.6,Oracle BI publisher, Oracle Delivers, UNIX/LINUX,Oracle11g/10g,SQl, PL/SQL,Teradata.

Confidential, Fortmeyers, FL

OBIEE Developer

Responsibilities:

  • Designed and developed metadata consists of Physical, BMM and Presentation layers
  • Designed, developed reports and dashboards as per requirements
  • Implemented cache, security (Data and Object level)
  • Involved in the development, migration and merging of code with the off shore team.
  • Participated in various conference room pilots and User Acceptance Tests (UAT).
  • Managed and coordinated offshore and onsite development teams.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Informatica 8.6, Oracle 8i, UNIX, SQL server, Windows NT 2000.

Confidential, New Jersey

Informatica Developer

Responsibilities:

  • Coordinate with application team and develop all ETL processes.
  • Understand the ETL specifications and build the ETL applications like Mappings on daily basis.
  • Create the mappings, sessions and Workflows as per requirement of business to implement the logic.
  • Perform the Unit Testing on developed code.
  • Create a mapping document based on High level design document.
  • Responsible for preparing the Satyam Quality Documents.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11g, Informatica 8.6, Oracle 8i, UNIX, SQL server, Windows NT 2000.

Confidential, Sun Prairie, Wisconsin

Informatica Developer/ Oracle Developer

Responsibilities:

  • Assisted in Design of physical & logical models.
  • Interface with Sales and Production Management Team to capture and analyze business strategic requirements.
  • Developed many mappings / mapplets using various transformations for extract and loading the sales data.
  • Involved in the performance tuning of mappings.
  • Provided support to report developers in developing the reports.
  • Created Database procedures, Packages, functions to handle data manipulations and Computations on Server.
  • Designed and developed Oracle Monthly Reports.
  • Modified, Maintained and Developed the SQL,PL/SQL codes to develop new enhancements
  • Develop and maintain the documentation to support the team and business
  • Responsible for preparing the Satyam Quality Documents.

Environment: Oracle 9i/8i, SQL Server 2000, Informatica Power Center 7.1, UNIX Scripting (Ksh), Sun Solaris 7, Windows XP Professional.

Hire Now