SUMMARY:

• 9 years of IT experience in Developing and Implementin g Oracle BI Applications, OLAP, OLTP, Data warehousing and web applications. Good experience in different phases of software development life cycle including analysis, design, development, testing and maintenance.
• Experience in OLAP OBIEE Architecture for multiple projects.
• Strong understanding of relational database design concepts and in depth knowledge of Data Warehousing and OLAP solutions.
• Experience in working with business clients in gathering requirements, documenting the requirements and understanding business process.
• Experience in OBIEE dashboard, metadata repository configuration and Data Modeling with full cycle Analytics implementations.
• Experienced on OBIEE10g and 11g for multiple projects.
• Expertise on RPD modeling, OBIEE presentation service and admin activities.
• Designed business model Star Schema and metadata repository RPD based on Project requirements.
• Implemented OBIEE Data level and Object level security for multiple projects.
• Experience in developing OBIEE Answers, Dashboards, Delivers and iBots alerts .
• Sound Knowledge of Data warehousing and BI concepts.
• Experience in generating Technical Design Specifications.
• Good understanding of ETL tools ODI 11g OWB 11g.
• Experience in data modeling, design and used tools like Erwin/SQL Modeler for multiple projects.
• Experience in implementing Data Migration projects.
• Experience in conducting POC reviews with the clients and projecting technical solutions.
• Experience in web technologies HTML, Java script .
• Expert in adroit client communication and working with multiple cross-functional teams.
• Experience in working with overseas clients across the regions.
• Highly adaptable in quickly changing technical environments with very strong organizational and analytical skills.

DOMAIN EXPERTISE

• Worked on Manufacturing PLM , Retail and Textile Domains.
• Experienced in working with Oracle PLM Agile tools and Oracle Agile PLM BI analytics tools.

PROFESSIONAL EXPERIENCES

Confidenital OBIEE/ODI Developer

RESPONSIBILITIES:

• Configured/Customized OBIEE metadata repository .rpd based on requirements, which includes Configuration of Physical, BMM and Presentation layers.
• Identify gaps and perform analysis over customer requirements and suggest technical solution.
• Prepared technical design documents for RPD modeling based on the requirements.
• Implemented Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Prepared POC for new OBIEE report developments and presents to the client.
• Created materialized views and aggregates tables to improve report-rendering performance.
• Worked on both OBIEE 10g and OBIEE 11g web catalog and Presentation administration.
• Worked on Oracle PL/SQL scripts and create materialized views based on the requirements.
• Worked on report and dashboard development which involves various views like table, chart, column selector, view selector, pivot view etc. both 10g and 11g
• Developed interactive dashboards with the features such as Prompts, Guided Navigation, drill down etc.
• Worked on creation of iBots alerts as per the client requirements.
• Enhanced/Customized the dashboards/reports based on user specific requirements.
• Designed Star Schema business model for the set of ERS report requirements.
• Worked on SQL modeler for data modeling activities - ERS project revamps the existing classic data model to new data model.
• Worked on creation of Data Dictionary technical design document for the new EDWR data model.
• Analysis on OWB 11g Oracle Warehouse Builder ETL design for the new EDWR data model for ERS project and understand the various layers of ETL
• Actively participated in client discussions and project discussions within ERS project.
• Conducts code reviews and mentors team for deliverables and help the team for technical challenges.
• Involves in continuous development, enhancements and resolves technical challenges.
• Prepare effort schedule for deliverables, assign and track the work status from team members.

ENVIRONMENT: OBIEE 11.1.1.5 OBIEE 10.1.3.4.1, Oracle 11g DB, Unix, JavaScript, HTML, SQL Data Modeler, OWB11g.

Confidenital

OBIEE Developer

RESPONSIBILITIES:

• Participated in requirements gathering with the clients.
• Acted as SME for entire BI analytics implementation for PQM analytical report development.
• Conducted POC reviews with the clients.
• Involves in discussion with business clients for business requirements and analysis.
• Knowledge on ODI for PQM data Scenarios and Interfaces for CDC data capture in PLM BI Analytics suite.
• Customized OOTB RPD for DELL specific requirements and configured for Physical, BMM and Presentation layers.
• Designed the solutions for all OBIEE reporting requirements.
• Implemented OBIEE security through External tables and LDAP.
• Implemented data authorization for internal and external PQM users through dynamic filters capability.
• Implemented Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
• Created custom CSS classes, styles, java scripts and HTML scripts to enhance the dashboard functionality and deliver reports according to the business requirements.
• Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Classified multiple subject area in presentation layer depending on the business user requirements.
• Created Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Developed interactive dashboards with the features such as Prompts, Guided Navigation, drill down etc.
• Prepared technical design specification documents.
• Mapped required Page2, Page3 attributes through MDS CONFIGURATOR utility.
• Modeled RPD for ADM operational and MDS data schema.
• Developed various analytical and operational OBIEE reports/ dashboards through OBIEE presentation service.
• OBIEE Web catalog administration.
• Coordinated the OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed PL/SQL queries to validate report data across the dashboards.
• Mentored team for report development and technical challenges.
• Implemented PQM dashboard reviews with the clients.
• Planned work schedule estimations for individual team members
• Involved in end-to-end testing of all the reporting deliverables during development.
• Worked as functional and technical analyst for PQM analytics migration deliverables.
• Worked on Agile Data Import utility and created data mapping files.
• Prepared technical design specification documents for data migration deliverables.
• Developed PL/SQL procedures to validate the data from source to legacy systems.
• Implemented Data Dictionary document for source system to target system mappings for migration activity.

ENVIRONMENT: OBIEE 10.1.3.4.1, Oracle 11g DB, UNIX, Javascript, HTML

Confidenital

OBIEE Consultant

RESPONSIBILITIES:

• Involved in client discussion during design phase and gathered the business requirements.
• Implemented data model Star Schema design for ER6 Logistics modules.
• Used Erwin data modeler for data model design, created Logical design for logistics and supply chain modules.
• Prepared Technical design documents for RPD modeling.
• Configured/Customized RPD for Physical, BMM and Presentation layers.
• Imported tables to Physical layer, created Alias table, physical joins, complex joins and logical tables.
• Worked on hierarchies, level based measures, time series measures etc.
• Classified multiple subject area in presentation layer depending on the business user requirements.
• Involved in OBIEE Report/Dashboard design and development as per the BI report requirements for Logistics and Supply chain Modules.
• Created Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Developed interactive dashboards with the features such as Prompts, Guided Navigation, drill down etc.
• Developed PL/SQL queries to validate report data across the dashboards.
• Client interaction for project requirements.
• Projects plan creation for team members and track the tasks of team members.
• Mentors the team members during development and resolves the technical issues.
• Performed Technical code reviews during project development.

ENVIRONMENT: OBIEE 10.1.3.4.1, Oracle 11g DB, Unix, JavaScript, HTML, Erwin Data Modeler

Confidenital

OBIEE/Siebel Analytics Developer

RESPONSIBILITIES:

• Worked on application development for several TEDWEB modules
• Participated in requirements gathering with Wipro teams.
• Validated travel workflows through SAP ABAP function modules.
• Executed SAP ABAP BAPI procedures in ASP application development.
• Involved in continuous developments/enhancements of travel applications.
• Designed and developed travel admin operation web pages for Wipro operational team.
• Implemented XML as the format for request and response content in order to transfer data
• to ADOBE offline travel settlement forms.
• Implemented JavaScript methodologies for dynamic usability of the web pages to improve the rendering performances.
• Involved in continuous enhancements, maintenance and troubleshooting of the issues for TEDWEB My Travel and eBilling applications.

ENVIRONMENT: ASP, JavaScript, HTML, SAP ECC6.0 ABAP, SQL Server 2000

Confidenital

Siebel Analytics Consultant

RESPONSIBILITIES:

• Participated in requirements gathering with users.
• Worked on SQL procedures/packages for report requirements.
• Developed web pages as per the project requirements.
• Developed operational crystal reports for Yarn Fabric transactions
• Executed test cases and unit testing.

ENVIRONMENT: ASP, HTML JavaScript, SQL Server 2000, SegateCrystalReports6

Confidenital

Siebel Analytics/ETL Developer

RESPONSIBILITIES:

• Developed web pages as per the project requirements.
• Executed test cases and unit testing.