We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume

Northlake, IL

SUMMARY:

  • I look forward to work in a challenging environment where I can enhance/deliver my technical and analytical skills to the best of my capabilities and to add value to the organization.
  • I served as technical lead with primary responsibilities of design and implementation of Data Warehouse and BI Applications based on the warehouse. I also have prior experiences in major enhancements and support Data Warehouse projects based on Oracle 10g and 11g.
  • Have experience in all the phases of building Data Warehouse and Business Intelligence applications projects
  • Led team technically providing analytical solution to the client requirements.
  • Specialize in working with technical staff to create, interpret, and implement business requirements into technical specifications.
  • Possess business domain experience in Projects, Manufacturing, Sales & Marketing, Financials, ASCP and Human Resources.
  • Possess excellent Knowledge of Data Warehousing concepts - Schemas, Facts and Dimensions etc.
  • Have excellent knowledge of OBI Apps out-of-the-box codes, best practices, design and dimensional modelling.
  • Have excellent exposure in design, implementation and support of Data Warehouse.
  • Have extensive experience in coordinating with clients, management and teams.
  • Have excellent hands-on on Business Intelligence apps development using tools as OBIEE 10g/11g.

TECHNICAL SKILLS:

Domain: HR, Sales and Marketing, Financial, Projects, Manufacturing, Supply Chain

ETL Tool: Informatica Power Center 8.6/9.0.1, DAC 7.9.5 / 11.1.1 , ODI 12c

BI Tool: OBIEE 10g, 11g, BI Publisher 11

Package: OBIA 7.9.6.3

Databases: Oracle 10g, Oracle 11g

SQL Tools: SQL PLUS, TOAD, SQL Developer

Operating Systems: Windows, Confidential AIX

Configurations: Single Server, Multi Server

Source systems: Siebel CRM, Oracle eBS

PROFESSIONAL EXPERIENCE:

Confidential, Northlake, IL

Data Warehouse Developer

Environment: OBIEE 11g, Oracle 11g, DAC 11.1, Informatica 9.0.1, OBIA 7.9.6.3, ODI 12c

Responsibilities:

  • Developing all the layers OBIEE11g RPD, including hierarchies, aggregations etc.
  • Developing OBIEE Dashboards and reports with views like pivot tables, Graphs, Prompts, View Selectors etc.
  • Creating technical Specifications document based on the functional specifications.
  • Creating/modifying data model as per the new requirements / enhancements.
  • Creating / modifying database objects as per the technical documents.
  • Developing new reports, modeling OBIEE RPD, creating Informatica mapping and designing DAC objects as per the specifications.
  • Working on Proof of Concepts for new user requirements
  • Developing Informatica objects from scratch following the design principles and best practices.
  • Performing unit and system testing and preparing required documents.
  • Conducting internal training to other teams on Data warehousing and OBI applications architecture.
  • Preparing POC for BI Publisher report and Oracle Primavera P6 integration.
  • Preparing POC for Microsoft Webservices and Oracle Data Integrator integration.
  • Providing production support for OBI Applications.

Confidential, Madison, NJ

Senior OBIEE Developer

Environment: OBIEE 11g, SQL Server, Windows, TOAD

Responsibilities:

  • Designing OBIEE RPD and reports based on Data Model and client requirements
  • Closely working with database developers for ensuring Data warehouse principles are followed while creating tables, keys etc.
  • Development of all the layers OBIEE11g RPD, including hierarchies, aggregations etc.
  • Development of OBIEE UI involving Dashboards, Reports using pivot tables, Graphs, Prompts, filters etc.
  • Delegating and tracking development of other team members’ deliverables.
  • Tracking daily progress by the team and reporting status updates to management over tele-conferencing.
  • Helping junior team members in development, testing and documentation.
  • Performing Unit and system testing.
  • Helping ETL team members with Informatica expertise.
  • Creating migration documents for admin team.
  • Designing BI Application solutions based on OBIEE 10g and 11g.

Confidential, New York, New York

Environment: OBIEE 10g, Oracle 10g, Informatica 8.6, OBIA 7.9, DAC, Oracle eBS Human Resources, OBIA 7.9.6.3

OBI Apps Lead

Responsibilities:

  • Leading a team of 4 OBIEE and Informatica developers.
  • Creating Technical design documents from Requirements.
  • Creating data models in adherence to the technical design.
  • Working with the database team for object creation as per the design.
  • End-to-end implementation of Informatica objects.
  • Designing OBIEE RPD and reports based on Data Model and client requirements.
  • Guiding team members in day-to-day implementation.
  • Preparing Unit and System test cases with the team members.
  • Closely working with the team members in their development and working to overcome any impediments they come across in regards to the database objects and the data.
  • Cross-training teams on the concepts of ETL and OBIEE development.
  • Guiding teams on Oracle out-of-the-box applications involving OBIEE, Informatica, DAC and database objects as tables, keys, indexes, joins etc.

Confidential, Bay Area, California

Environment: OBIEE 10g, Oracle 10g, Windows, SQL developer

OBIEE Team Lead

Responsibilities:

  • Leading team of 3 OBIEE developers.
  • Creating OBIEE reports based on Technical Design.
  • Creating Dashboard objects including reports, Dashboard prompts, Filters etc.
  • Complex reporting using pivot table and graphs with multiple selectors and drill-in facilities.
  • Tracking the team progress on bi-weekly basis and reporting to the management.
  • Reporting issues and dependencies in the independent OBIEE RPD development team and following up with them.
  • Coordinating with various other teams to avoid impediments for a smoother implementation.
  • Preparing Unit and System test cases for the OBIEE UI part and running them with the team members.
  • Reviewing and giving feedbacks to the junior team members’ work.

Confidential

Environment: OBIEE 11g, Oracle 11g, Informatica 8.6, DAC, Windows, SQL developer, Oracle eBS HR and Finance, OBIA

OBIA Team Lead

Responsibilities:

  • Working as subject matter expert for BI Applications.
  • Supporting Oracle BI Applications production 24/7.
  • Solving tickets as per the SLA defined.
  • Identifying major and minor enhancements for the existing applications.
  • Designing and estimating the Change Requests and generating revenue for Confidential .
  • Designing / Re-designing of Data Warehouse tables: Facts, Dimensions, and Aggregate tables as part of the enhancements and/or support tickets.
  • Identifying concerns and risks in the team and working with management to create a mitigation plan.
  • Coordinating with various teams for successful implementation of enhancements and resolution of service tickets.
  • End-to-end development of OBIEE 10g RPD, Dashboards, Reports, security implementations.
  • End-to-end development of ETL using Informatica Mapping, workflows and scheduling with DAC using Subject Areas, Execution Plans.

Confidential, Cleveland, Ohio

Environment: OBIEE 10g, Oracle 10g, Informatica 8.6, DAC, Windows, TOAD, Oracle eBS HR, OBIA 7.9.6

OBIA Informatica Team Lead

Responsibilities:

  • Working with senior designer to gather client requirements and creating Functional design document.
  • Creating Informatica and database technical design involving the enhancements based on the Oracle’s out-of-the-box code.
  • Working as subject matter expert for Oracle out-of-the-box package for OBIEE, Informatica and DAC.
  • Training team members on Oracle’s pre-packaged solution’s architecture, codes, standards, conventions etc to bring them upto the speed.
  • End-to-end development of Informatica objects with flat source and Oracle data warehouse as target.
  • Maintaining quality assurance documents for audit purposes for all the deliverables and deliveries.
  • Tracking status updates o daily basis and reporting to management.
  • Preparing and running unit and system test-cases for Informatica development.
  • Reviewing and tracking team member’s development work and deliverables.

Confidential, Boulder, Colorado

Environment: OBIEE 10g, Oracle 10g, Informatica 8.6, DAC, Windows, Confidential AIX, TOAD, Siebel CRM, OBIA 7.9.6.1

OBIA Developer

Responsibilities:

  • Supporting Production OBIEE, Informatica applications 24*7 with Siebel as source.
  • Handling Service Requests and major client-requested enhancements.
  • Designing, creation and population of DW tables using SQL and ETL tools as Informatica.
  • Solutioning, designing, data modeling and developing minor and major application enhancements requests based on tools OBIEE, Informatica and DAC.
  • Preparing migration documents and working closely with the admin team for successful installation of enhanced objects into Production environment.
  • Quality Assurance - Defect Prevention, Configuration and On-Off boarding co-ordination.

Confidential

Environment: OBIEE 10g, Oracle 10g, Windows, TOAD

OBIEE Developer

Responsibilities:

  • Data Warehouse table creations as per the data models.
  • Creating joins, keys, indices on the DW tables as per the design.
  • Development in Business Intelligence Reports, Dashboards etc as per the technical design.
  • Creating Pivot tables graphs and other reporting objects in OBIEE.
  • Implementation of Security as per the client hierarchy in the Data Warehouse tables and subsequently to the BI reports.

Confidential

Environment: Siebel Analytics, OBIEE 10g, Oracle 10g, Windows, TOAD

OBIEE Developer

Responsibilities:

  • Development BI repository and dashboards for Business users using Siebel Analytics and OBIEE 10g.
  • Enhancement implementation based on OBIEE 10g.
  • Coordinating with end users and developing the application/analysis with team.
  • Configuration Management.
  • Application and data testing.
  • Application Administration.

Hire Now