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

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

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

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

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.

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.

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.

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

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)