We provide IT Staff Augmentation Services!

Bi/dw Developer/admin/architect Resume

Houston, TX

SUMMARY:

  • Strong expertise in the IT Industry and having 10 years of experience in Oracle Business Inteligence(OBIEE/OBIA),Informatica ETL and Microsoft Technologies.
  • Involved in Analysis, Design, Development, Implementation and Testing using BI Technologies, Experiences in areas, Build & Release Management Project Management.
  • Software development process and developing Best practices. Implementation and Database Administration. Expertise in Oracle - BI, Reporting, Informatica, ETL and Microsoft BI Technologies(SSIS,SSAS).
  • Development and Database Administration activities encompassing database planning, design, installation, configuration
  • Experience in working with N-Tier Architecture.
  • Experience in complete SDLC Life Cycle which consists of Design, Documentation, Development, Testing and Maintenance.
  • Experience in Insurance, Retail, Financial, E-Commerce,Mobile Communication Sectors.
  • Well versed with OBIEE Recommended Implementation Methodologies & Best Practices.
  • Expertise in building OBIEE Repository, following best practices and based on user requirements.
  • Experience in working with OBIEE 11 G Exadata environment.
  • Very Good Exposure in Creating Hierarchies and user group and security settings in OBIEE administration.
  • Building, Deploying, Running and supporting complex OBI Reports, report templates, and analytics applications using BI Answers, Dashboards.
  • Extensive experience on Implementing end to end Oracle BI Applications (OBIA) Modules.
  • Expertise in Migration of Oracle Reports to BI Publisher 11g.
  • Experience in working with Oracle and MicrosoftSQL Server databases.
  • Knowladge on OBIEE 12 C data visualization.
  • Good Exposure in creating various Integration Services Projects using the Informatica, ODI ETL Tools.
  • Knowladge on Data modaling and Created and implemented ER models and dimensional models (star schemas).
  • Expertise in Data warehousing concepts and good Exposure to Data Warehouse design methodologies and Techniques.
  • Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
  • Hands on experience with Microsoft BI Technologies(Sql Server Integration serves and SQL server Analysis services).
  • Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to OBIEE Repository.
  • Worked as OBIEE Administrator, to setup the server, OBIEE installetion, configuration of SSO and 2 Factor authentication.
  • Worked on setup the cluster environment and load balancing on OBIEE Linux servers.
  • Experience in Agile, Waterfall Methodologies.
  • Excellent Analytical, Communication and Inter-personal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Mart, Informatica Power Center 9.x/8.x/7.x/6.x,ODI 11g

BI Tools: OBIEE 10g/11g/12C, OBIA11g,BI Publisher,OBIA 7.9.6.4, DAC 7.X

Operating Systems: Windows 95/98/2000/XP/NT/Vista, Linux, Unix, MS-DOS.

RDBMS: Oracle 9i, Oracle 10g, oracle 11g, SQL Server 2000, 2005 & 2008, netezza

Testing Methodologies: Manual Testing

Launguages: SQL,PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Houston, Tx

BI/DW Developer/Admin/Architect

Responsibilities:

  • Installed, Configured and implemented the OBIEE 12.2.1.1
  • Worked as OBIEE Administrator, to setup the server, OBIEE installetion, configuration of SSO and 2 Factor authentication.
  • Worked on setup the cluster environment and load balancing on OBIEE Linux servers.
  • Involved in the gathering the high level requirements and creating the functional and technical documentation.
  • Implemented the SSO for the OBIEE clustered environment.
  • Identifying the requirement and development of Informatica ETL mappings, Informatica data quality profiles and mappings
  • Worked closely with support development team for closing down their functional issues.
  • Added users and configured security in web logic console of OBIEE 12C.
  • Trained End Users and Pilot Users about OBIEE Tools.
  • Data Quality analysis on business logic and requirements
  • Using Netezza tabase for extracting data from source and loading into the datamart tables.

Environment: OBIEE 12.2.1.3(Oracle Business Intelligence Aplications), Informatica 9.6.x,Oracle 11g Database, Netezza

Confidential

BI Lead Consultant/Admin/Developer

Responsibilities:

  • Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
  • Being part of discussions and requirement gathering with Clients in Onsite.
  • Worked as OBIEE Administrator, to setup the server, OBIEE installetion, configuration of SSO and 2 Factor authentication.
  • Worked on setup the cluster environment and load balancing on OBIEE Linux servers.
  • Identifying the requirement and development of ODI ETL mappings
  • Doing changes in the SDL and SIL Loads based on the business requirements.
  • Chnaging the OOTB (Orcal delivered mappings) based on the ERP requirements.
  • Scheduling the customized mappings using the scheduler.
  • Worked closely with support development team for closing down their functional issues.
  • Added users and configured security in web logic console of OBIEE 11g.
  • Trained End Users and Pilot Users about OBIEE Tools.
  • Data Quality analysis on business logic and requirements

Environment: OBIA 11G(Oracle Business Intelligence Aplications),OBIEE 11G, ODI 11G,Oracle 11g Database

Confidential

BI Lead Consultant/Admin/Developer

Responsibilities:

  • Installed ODI. Set up the ODI connection with Oracle, MS SQL Server and flat files.
  • Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries.
  • Set up the Topology including physical architecture, logical architecture and context.
  • Created new models for the data sources - flat files, MS SQL server, Oracle.
  • Involved in to tune the ODI and OBIEE reporting. Here I am working as a ODI and OBIEE lead and designer and mapper.
  • Understanding the working environment & Tune the ODI environment and OBIEE reporting to achieve the desire performance.
  • Worked as ODI and OBIEE SME: - Involved in gathering business requirements, Modifying and tuning the ODI Interface and OBIEE reportingProc for SLA Reporting and assisting the team to achieve their goal.
  • Worked as OBIEE Administrator, to setup the server, OBIEE installetion, configuration of SSO and 2 Factor authentication.
  • Worked on setup the cluster environment and load balancing on OBIEE Linux servers.

Environment: ODI,OBIEE 11.1.1.9,ORACLE 11G Database

Confidential

OBIEE Consultant

Responsibilities:

  • Reviewed Bisiness Requirement document and functional Design document and converted into Technical design document.
  • Created ETL mappings using Technical Design document
  • Worked closely with Support Development team for closing down their functional issues.
  • Created dinemtional model for new subject areas.
  • Estimation of the mapping to be built in informatica and OBIEE reports as per the requirement.
  • Created OBIEE rpd and webcatalog based on report design document.
  • Involved in the process of ETL flow of data from Stage to CLDM.
  • Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
  • Used Teradata as a source system

Environment: Informatica9.1.1,OBIEE 11g,Teradata, Netezza

Confidential

BI Consultant

Responsibilities:

  • Installed, Configured and developed BI Apps 11.1.1.6.0 Financials, Supply Chain, Procurement and Spend, HR modules.
  • Extracting data from ODS system and creating report using OBIEE reporting tool.
  • Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
  • Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
  • Added users and configured security in web logic console of OBIEE 11g.
  • Managed security privileges for each subject area and dashboards according to user requirements
  • Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.

Environment: Oracle Business Intelligence Applications (OBIA 11G),ODI 11g,Oracle 11G,OBIEE.

Confidential

BI Consultant

Responsibilities:

  • Installation of OBIEE 11.1.1.6.0 in Development, Testing, Acceptance and Production Environment.
  • Installation of Informatica 9.0.1 in Development, Testing, Acceptance and Production Environment.
  • Modified and Created new mappings.
  • Modified and created new OBIEE reports and dashboards as per requirements.
  • Migration of repositories (Metadata) and catalogs to different environments.
  • Identifying and solving complex development problems.

Environment: OBIEE11.1.1.6,BI Publisher, Informatica 9.0.x, DAC and Oracle 10g.

Confidential

BI Consultant

Responsibilities:

  • Analyzing the data and extracting and Loading into database using Wherescape RED ETL tool.
  • Interacting with clients and analyzing business requirements.
  • Explaining technical specification as per the business requirements.
  • Worked on various creating using the OBIEE 10.1.3.2 Reporting tool.
  • Familiar with processes involved in both development and support of BI environment.
  • Developing Coordinating with the QA team if issue arises.

Environment: Informatica 8.6.X, OBIEE, Business Objects(web reports), Oracle 11g.

Confidential, KS

BI Consultant

Responsibilities:

  • Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration.
  • Interacting with the business users and extracting the data from flat files and loading into the target table.
  • Interacting with clients and analyzing business requirements and explain project plans to the team.
  • Explaining technical specification as per the business requirements.
  • Worked on various Scorecard creations using the OBIEE 10.1.3.2 Reporting tool.
  • Creating OBIEE Repository and setting hierarchies in Repository.
  • Perform deliverables review before moving it to Quality / Acceptance testing to client.
  • Creating and customizing dashboards and reports to meet user requirements.
  • Building, Deploying, Running and supporting complex OBI Reports, report templates, and analytics applications using BI Answers, Dashboards.

Environment: OBIEE 10.1.3.2, SSAS(Sql server analysis services), SSIS(sql server integration services), MS SQL Server 2005 and MS SQL Server 2008

Confidential

BI Developer

Responsibilities:

  • Understand requirements as stated in the Business Requirement document
  • Build code samples and small prototype to help in technical design
  • Develop code in SSIS, SSAS and OBIEE
  • Troubleshoot applications code built using SSIS, SSAS and OBIEE.
  • Write PL/SQL queries to extract and validate data for various activities
  • Query optimizing of SQL’s by using SQL profiler
  • Build script components and packages using SQL Server Integration Services
  • Merge scripts and code artifacts into SVN Configuration management system
  • Provide support to the QA team in merging data across environments

Environment: OBIEE 10.1.3.3.X, BI Publisher, SSIS, SSAS, ( SQL Server 2005)

Hire Now