We provide IT Staff Augmentation Services!

Sr Odi/obiee Consultant Resume

PROFESSIONAL SUMMARY:

  • 9+ plus years in leading and executing full life cycle of software development of a Data Warehousing and Business Intelligence solution including designing DW, ETL & Reporting experience.
  • Skill - set - Oracle Data Integrator, Oracle Warehouse Builder, OBIEE, Oracle Discoverer, Oracle Database, PL/SQL, UNIX.
  • Six Years’ experience in designing, creating & managing of Facts, Dimensions & Data Marts.
  • Highly skilled and experienced in Agile Development process for diverse requirements.
  • Experience in designing and developing Star/ Snowflake schemas.
  • Good knowledge of Data warehouse designs (Top-down, Bottom-up & Hybrid Design).
  • Experience working in globally distributed technology teams. Handled multiple roles - Team Lead, Data warehouse Developer, Business Analyst, Data Modeler and Back-End Developer.
  • Technology expertise includes in-depth skills in Designing and developing applications with Oracle Technologies.
  • Good knowledge of PL/ SQL programming (Creating Stored Procedures, Functions, Triggers, cursors and packages).
  • Extensive experienced in developing & supporting company-wide systems.
  • Proven ability to work with a wide range of departments and levels of management.
  • Proficiency in Software Development Life Cycle (SDLC) and AGILE methodologies of development process such as requirement analysis & definition, prototyping, proof of concept, designing, coding, testing and implementation.
  • Experienced in Configuration Management, setting up company Version policies, build schedule using Clear Case and Visual Source Safe (VSS).
  • Quick and accurate thinker with an optimistic attitude towards problem solving combined with efficient analytical skill set.
  • Significant experience in offshore leading, coordination thus implementing a successful onsite-offshore model of delivery.
  • Strong team player, motivator but has also executed projects independently.
  • Excellent Written, Analytical Skills and Verbal Communication skills with a customer service oriented attitude.
  • Proven track record of dependability and reliability with an accomplished sense of responsibility.

TECHNICAL SKILLS:

ETL: Oracle Data Integrator (Formerly Sunopsis) Ver 11g/12c, Informatica 9.1/ 8.6, Oracle Warehouse Builder, PL/ SQL scripts.

Databases: Oracle 8i/ 9i/ 10g/ 11g/12c, Sybase Version ASE 15, SQL Server 2008/2005/2000 , Teradata

Reporting: OBIEE, Oracle Discoverer, Cognos Reporting, Actuate Reporting.

Version Control: Visual Source Safe 6.0, Clear Case.

Other Tools: Toad, SQL Navigator, Microsoft Visio, Excel, Rapid SQL, SQL Advantage, HP Service Desk, SQL Developer.

Servers: Unix, Windows 2003 server.

PROFESSIONAL EXPERIENCE:

Confidential

SR ODI/OBIEE Consultant

Environment: Oracle DB 12c, ODI 12c, OWB, PL/SQL, TOAD, Serena Team Track, PVCS, Oracle Primavera p6, SAP BI, OBIEE, Linux

Responsibilities:

  • Conversion of existing OWB (Oracle Warehouse Builder) process flows to ODI packages
  • Develop ODI mappings, packages, procedures and Load Plans in Oracle Data Integrator (ODI)
  • Provide O&M Support to Data Warehouse
  • Daily ETL load monitoring and Performance tuning
  • Improve the design of the existing ETL jobs
  • Test the ODI packages developed by the team
  • Customize the Knowledge Modules in ODI
  • I have followed an extremely light and efficient Agile process, adapted to be most easily applied, and with that you may pursue and at any time change a project plan; and others, battle-proven, easy and fast, to prioritize among projects and manage a program in an Agile manner.
  • Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other Scrum-related meetings
  • Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility; ensured consistent application of scrum methodologies across the enterprise
  • Design, develop and maintenance of Complex PL/SQL Packages, Procedures, Functions, Materialized Views, Materialized Views logs, Materialized Views Refresh Groups, DB Triggers, Views and Sequences.
  • Consolidation of multiple schemas from multiple physical sites into one schema - activities involved data modeling, table creations, index creations, ETL/ELT, Data Analysis and data cleanup.
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, etc.
  • Used ODI Operator to monitor sessions.
  • Created model folder, sub folders reversed the technologies to get the table structures.
  • Created project folder and imported, exported the knowledge modules in different environments.
  • Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
  • Automated the ETL packages and File delivery packages using Oracle Data Integrator built-in agent.
  • Designed and developed the purge process for purging operator logs using oracle data integrator tools in the package.

Confidential, Cambridge, MA

Sr. ODI Consultant

Responsibilities:

  • Developed various ODI interfaces to load data from Flat file & Relational Sources to Oracle DataMart.
  • Topology Manager is used to create database connection, physical and logical schema in order to achieve the whole infrastructure.
  • Used ODI Designer for importing tables from database, reverse engineering, to develop projects, and release scenarios.
  • Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data, checking it, integrating it, etc.
  • Used ODI Operator to monitor sessions.
  • Created model folder, sub folders reversed the technologies to get the table structures.
  • Created project folder and imported, exported the knowledge modules in different environments.
  • Created interfaces, Procedures and Packages, generated scenarios using Oracle Data Integrator Designer.
  • Automated the ETL packages and File delivery packages using Oracle Data Integrator built-in agent.
  • Designed and developed the purge process for purging operator logs using oracle data integrator tools in the package.

Confidential, NYC, NY

Lead ODI/ OBIEE Developer

Environment: Oracle Business Intelligence EE 11.1.6, Oracle 11g, PL/SQL, OracleSQL Developer, Oracle Data Integrator 11.1.1.7, 12.1.2.0, SQL, PL/SQL, TOAD, Erwin

Responsibilities:

  • Leading a team of 6 ODI & OBIEE developers.
  • Responsible for delivery of releases related to ACSINFO.
  • Gathered and analyzed requirements. Discussed the requirements with Business Analyst for any clarifications.
  • Analyzed multiple sources (database and files) and designed normalized staging area to source data for Mart.
  • Prepared Source to Target Mapping Document.
  • Created physical and logical Data models for ACSINFO.
  • Designed hierarchies and dimensions as per business rules.
  • Designed the developed data Extraction, transformation and load process.
  • Completed code review of ODI code.
  • Created OBIEE repository for different subject areas and Adhoc reporting in BI Administration.
  • Developed various reports using BI Analysis.
  • Used BI Catalog Manager to maintain Catalog folders for code promotion to different environments.
  • Worked on BI Enterprise Manager to save RPD on server and restart servers post deployment
  • Defined OBIEE/ ODI row level & subject area level security.
  • Completed Parallel Processing in ODI to achieve performance benchmarks.
  • Completed ODI job scheduling for Daily, Weekly & monthly jobs in various environments using ODI Operator.
  • Co-ordinate with Business, DBA and other technical teams for analysis.
  • Extensively used Designer to develop the interface, packages and create scenarios.
  • Implemented complex business rules into ODI transformations/ mappings.
  • Promoted Scenarios to different environments for ODI code promotion.
  • Developed Packages and generated Scenarios to integrate all the interfaces sequentially.
  • Developed the procedures to update the process control parameter tables.
  • Used constraints to achieve the data quality.
  • Created Models for File structures and updated/ maintained Data Models for Oracle/ Sybase DB.

Confidential, MI

Sr. ODI Developer

Environment: Oracle data integrator 10.1.3.6/11.1.1.7.0 Enterprise Edition, JReports,oracle 11g,PlSql, Informix 11.70 fc 7,Weblogic 10.3.6.0.0 , Dimensional model, Sub Version, Windows 2003 server.

Responsibilities:

  • Upgraded the existing ODI 10.1.3.6 development, quality and production Master /Work repositories to latest ODI 11.1.1.7.
  • Installed of web logic server on development, test and production environment.
  • Creating the web logic domain to access ODI web console for monitoring the jobs.
  • Defining the technology definitions in topology for Informix and Oracle database.
  • Configuring the ODI Standalone agent’s on Linux environment for development, quality and production environment.
  • Configuring the ODI web console for development, quality and production

Hire Now