Oracle Data
Resume:
Summary of Skills
I have * years of extensive experience in Analysis, Design, Development, Testing and Implementation of Internet web-enabled and client/server, ERP, and CRM.
I have extensive experience in data modeling, Data Mapping, Data Conversion, and Data Cleansing.
I am extremely familiar with Full life cycle implementing of large scale reporting applications using Siebel Analytics/Oracle Business Intelligence (OBIEE) platform.
I am proficient in installing, configuring, troubleshooting and maintenance OBIEE
I extensively worked on following tools: Oracle BI Administration, Oracle BI Answers and other tools in the Oracle BI Suite. Quest Toad, Oracle SQL Plus, SQL Server.
Applications/Tools:
• Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.x, Oracle Business Intelligence Enterprise Edition (OBIEE) 11g
• Oracle Business Intelligence Applications(OBIA) 7.9.6.1
• BI Publisher 10.1.3.x
• Oracle BI Map Viewer
• Google Maps with BI
• Informatica Power Center 8.x
• Oracle Warehouse Builder 10.2.x
• Oracle
Programming/Languages:
• SQL
• SQL* PLUS
• PL/SQL
Operating Systems:
• Unix (HP Unix, Linux and Sun Solaris)
• Windows NT, 98, 2000, XP
Scripting Languages:
• UNIX Shell Scripting and JavaScript
Web/App Servers:
• Web logic
• IIS
• OAS
• Apache and Tomcat
Database:
• Oracle 10g
• SQL Server 2000/2005
• DB2
• MS Access
Educational Background:
Bachelor’s of Degree in Computer Science and Engineering, JNTU, Hyderabad, India.
Professional Experience
Gemological Institute of America San Diego, CA
Senior OBIEE Consultant February 2011 – Till Date
Established in 1931, the Gemological Institute of America is the world’s foremost authority on diamonds, colored stones, and pearls. GIA exists to protect all purchasers of gemstones, by providing the education, laboratory, research, and instruments needed to accurately and objectively determine gemstone quality. A nonprofit institute, GIA's mission is to ensure the public trust in gems and jewelry by upholding the highest standards of integrity, academics, science, and professionalism through education, research, laboratory services, and instrument development. GIA attained its leadership role through decades of integrity and ingenuity, and everything we do is still driven by this mission
Some of the activities /responsibilities include:
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Performed Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the BI Applications Analytics platform
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Analyzed and validated the business model in Oracle BI repository (RPD) by performing consistency check, validating logical source tables, logical columns, and also validating RPD level calculations done in the business model layer.
• Created multiple hierarchies in single dimension for RPD development, level based measures, new logical columns, calculated columns using the expression builder and created presentation Catalogs in presentation Layer for the ado query purpose.
• Developed and customized OTB reports and new Reports, UI changes to OTB Dashboards with different subject matter Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle Business Intelligence (OBI) Presentation Services for the various work streams.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Implemented security by creating users & groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Lead design and development activities for customization of delivered PeopleSoft EPM Financial module to meet client requirement.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.
Environment: Oracle BIEE 10.1.3.3.0, Oracle 10g
GE Finance Detroit, MI
Sr. OBIEE Consultant December 2010 – February 2010
GE is an advanced technology, services and finance company taking on the world’s toughest challenges. Dedicated to innovation in energy, health, transportation and infrastructure, GE operates in more than 100 countries and employs about 300,000 people worldwide.
Some of the activities /responsibilities include:
• Involved in discover/design phase of business requirements
• Prepared GAP Analysis Document between requirements and out-of-box OBIEE functionality.
• Analyzed the business requirement gatherings and translated the same into technical specifications document.
• Installed, Configured and troubleshooting of OBIEE on Solaris UNIX environments.
• Worked on Capacity planning for BI and Presentation Servers
• Migration of RPD, webcat to DEV/QA/PROD environments.
• Developed the technical architecture diagrams and config guides for Production support.
• Identified and customized OOTB stars to fit the business requirements
• Configured OBIEE Repository, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies
• Configured the integrated view of Analytics within Oracle EBS.
• Implemented Oracle EBS Single Sign on for OBIEE Application.
• Designed and developed of Security Strategy at both data and UI level
• Followed OBIEE Best practices for modifying OOB mappings and vanilla repository.
• Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
• Customized/Developed reports request using OBIEE Answers and configured all Dashboards.
• Installed patches on DEV/QA/PROD servers.
Environment: OBIEE 11.1.1.3.0, Sun Solaris
COX – BI Implementation Atlanta, GA
Senior OBIEE Consultant August 2010 – October 2010
Cox Communications is a multi-service broadband communications company. The third-largest cable provider in the nation, Cox Communications Inc. is noted for its high-capacity, reliable broadband delivery network and superior customer care. For Cox, it’s not about being the biggest; it’s about being the best. With more than 6 million total residential and commercial customer relationships, over 22,000 employees and a firm commitment to education, the Cox team is widely regarded industry leaders, having earned multiple distinctions in customer satisfaction, diversity practices and company strategy.
Some of the activities /responsibilities include:
• Involved in life cycle development in OBIEE 10.1.3.2
• Created a new subject area as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Performed complex OBIEE Analytics configuration involving report generation from OLTP and OLAP databases systems
• Upgrading Analytics RPD and made changes to the physical area to reflect merges in ETL and changes in the Upgrade Data Model
• Performed extensive debugging on existing ETL routines and repository(.rpd) layers
• Created detailed filters in repository (.rpd) to implement position based visibility
• Designed and modeled custom OLAP Subject Areas using dimensional modeling techniques
• Perform Administrative tasks in OBIEE such as granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail and configuration
• Created Design and Development Documents for creation of new subject areas/customization
• Responsible for Data Modeling, Functional and Technical Design for the client
• Established aggregate tables and set up the repository to perform aggregation navigation
• Granted users with appropriate access to the subject areas and reports
• Provided access and security features for the sites
• Developed detailed documentation for the business users
Environment: Oracle BIEE 10.1.3.3.0, Oracle 10g
Cricket Communications San Diego, CA
Sr. OBIEE Consultant Sep 2009 – August 2010
Cricket Wireless is a mobile phone carrier that serves more than four million customers across the U.S. Cricket delivers leading-edge mobile phones, nationwide, high-quality coverage, and all the latest features such as mobile web, downloadable games, popular ringtones, wallpapers and more.
Project is aimed to migrate the BODI (Business Objects Data Integrator) workflows and jobs into ODI (Oracle Data Integrator) interfaces and packages.
Some of the activities /responsibilities include:
• Involved in discover/design phase of business requirements
• Prepared GAP Analysis Document between requirements and out-of-box OBIEE functionality.
• Analyzed the business requirement gatherings and translated the same into technical specifications document.
• Installed, Configured and troubleshooting of OBIEE on Solaris UNIX environments.
• Installed and Configured OBIEE scheduler.
• Installed and Configured BI Publisher.
• Configured Siebel analytics clustered servers
• Worked on Capacity planning for BI and Presentation Servers
• Migration of RPD, webcat to DEV/QA/PROD environments.
• Developed the technical architecture diagrams and config guides for Production support.
• Identified and customized OOTB stars to fit the business requirements
• Configured Siebel Repository, Physical Layer, Business Model and Mapping Layer and Presentation Layer using OBIEE Administration Tool.
• Developed calculated measures and assigned Aggregation levels based on dimension hierarchies
• Configured the integrated view of Analytics within Oracle EBS.
• Implemented Oracle EBS Single Sign on for OBIEE Application.
• Designed and developed of Security Strategy at both data and UI level
• Followed OBIEE Best practices for modifying OOB mappings and vanilla repository.
• Analyzed the transaction environment to identify the required facts and dimensions for the OLAP.
• Customized/Developed reports request using OBIEE Answers and configured all Dashboards.
• Created Action Links for several reports.
Environment: OBIEE 10.1.3.4.1, BI Apps 7.9.6.1,Sun Solaris.
Dubai Customs - IPMS Dubai, UAE
Senior BI Consultant Mar 2009 – Sep 2009
Dubai Customs is a Government body that facilitates free trade and help secure the integrity of Dubai’s borders which aim to be a world leader in Customs administration through innovative and proactive services to our clients. Dubai Customs supports fair trade practices by identifying and addressing non-compliance with the common Customs law of the GCC (Gulf Central Council).
We developed OBIEE application for all the subject areas involved with the management of products in Oracle Business intelligence. This application has developed using Answers and Dashboards in OBIEE.
Some of the activities /responsibilities include:
• Involved in life cycle development in OBIEE 10.1.3.4.1,
• Designed System Architecture and designed work flow structure o process.
• Created a new subject area as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Performed complex OBIEE Analytics configuration involving report generation from OLTP and OLAP databases systems
• Upgrading Analytics RPD and made changes to the physical area to reflect merges in ETL and changes in the Upgrade Data Model
• Performed extensive debugging on existing ETL routines and repository(.rpd) layers
• Created detailed filters in repository (.rpd) to implement position based visibility
• Designed and modeled custom OLAP Subject Areas using dimensional modeling techniques
• Perform Administrative tasks in OBIEE such as granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail and configuration
• Created Design and Development Documents for creation of new subject areas/customization
• Responsible for Data Modeling, Functional and Technical Design for the client
• Established aggregate tables and set up the repository to perform aggregation navigation
• Implemented OAS Single Sign on (SSO) to sync the security with other corporate applications.
• Granted users with appropriate access to the subject areas and reports
• Provided access and security features for the sites
• Developed detailed documentation for the business users
• Trained End users.
Environment: Oracle BIEE 10.1.3.3.2, Oracle 10g
COX – BI Implementation Atlanta, GA
Senior OBIEE Developer Feb 2008 – Feb 2009
Cox Communications is a multi-service broadband communications company. The third-largest cable provider in the nation, Cox Communications Inc. is noted for its high-capacity, reliable broadband delivery network and superior customer care. For Cox, it’s not about being the biggest; it’s about being the best. With more than 6 million total residential and commercial customer relationships, over 22,000 employees and a firm commitment to education, the Cox team is widely regarded industry leaders, having earned multiple distinctions in customer satisfaction, diversity practices and company strategy.
Some of the activities /responsibilities include:
• Involved in life cycle development in OBIEE 10.1.3.2
• Created a new subject area as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Performed complex OBIEE Analytics configuration involving report generation from OLTP and OLAP databases systems
• Upgrading Analytics RPD and made changes to the physical area to reflect merges in ETL and changes in the Upgrade Data Model
• Performed extensive debugging on existing ETL routines and repository(.rpd) layers
• Created detailed filters in repository (.rpd) to implement position based visibility
• Designed and modeled custom OLAP Subject Areas using dimensional modeling techniques
• Perform Administrative tasks in OBIEE such as granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail and configuration
• Created Design and Development Documents for creation of new subject areas/customization
• Responsible for Data Modeling, Functional and Technical Design for the client
• Established aggregate tables and set up the repository to perform aggregation navigation
• Granted users with appropriate access to the subject areas and reports
• Provided access and security features for the sites
• Developed detailed documentation for the business users
Environment: Oracle BIEE 10.1.3.3.0, Oracle 10g
OBIEE – BI Map Viewer maps integration
OBIEE Developer Dec 2007 – Jan 2008
This application integrates the Oracle map viewer with OBI reports; it presents the data on geographical maps using address. The spatial data from the oracle schemas will be read by the application to show the decision making facts on maps.
Some of the activities /responsibilities include:
• Worked closely with the business team to assure all business requirements and application objectives are met
• Translated the business requirements into conceptual and detailed technical design
• Supported on-shore and off-shore Development teams and monitored their Analytics Development
• Developed OBIEE Metadata repository (.rpd) that consisted of Physical layer, business model and Mapping layer with Aggregates, Dimensions and time Series objects, and presentation Layer
• Involved in designing and development of building Physical Layer, Business model and presentation layer in Administration Tool
• Involved in Generation, maintenance of Design and Development Documentation
• Designed reports and dashboards in OBIEE Answers as per the user requirements
• Worked on different Views like Ticker, Narrative, Legend, Pivot Table view as per the requirements
• Used filters, column filters, prompts and dashboard prompts in the reports to make it simple
• Implemented Authentication and Authorization privileges for different user groups in Administration Tool
• Managed OLAP databases in development, test, staging and Production Environments
• Trained end users to build Ad Hoc Reports using OBI Analytics
Environment: OBIEE 10.1.3.2, JavaScript, Oracle BI Map viewer, OC4J web server
Success Factors- BI Implementation with flex OBIEE Developer
Oct 2007 – Nov 2007
Success Factors is the leading provider of on-demand employee performance and talent management solutions that enable organizations of every size, across every industry and geography, to realize their employees' potential and thus drive business results. Its hosted service is organically built from the ground up - providing a fully integrated, modular suite of performance and talent management applications that provide customers with immediate process benefits and tangible return on investment.
Some of the activities /responsibilities include:
• Actively involved in implementation and configuration OBIEE.
• Designed Metadata repository (.rpd) with connection pools to the source Data Mart tables in the Physical Layer
• Monitored the Query Environment, Scheduler and Query Caching
• Gathered and refined requirements from the business users
• Performed metadata configuration, report and dashboard configuration including aggregate navigation
• Designed reports and dashboards using Flex which provide rich interface with interaction rather than normal OBIEE Dashboard Reports as per the user requirements
• Used appropriate filters, column filters, prompts, dashboard prompts and calculations in reports
• Created reports in different views as Pivot Table view, Table View, Ticker view and selector views
• Identified gaps and fed back data requirements to other source systems. Identified data sources, extension columns, Siebel OLTP tables, Fields and mapped them to staging tables and ultimately to OLAP physical layer
• Optimizing/Tuning mappings for better performance and efficiency
• Trained end users to build Ad Hoc Reports using OBIEE.
Environment: OBIEE 10.1.3.3.0, Flex Builder 2.0
Data Smart II – BI Implementation Texas
OBIEE Developer Jun 2007 –Sep 2007
Toppan Photomasks, Inc. is a wholly owned subsidiary of Toppan Printing Co., Ltd., a diversified global company with revenue in excess of $13 billion in fiscal 2007. Together with the photomasks business of Toppan Printing, the company forms the world's premier photomask provider. Utilizing operations within the industry's most advanced and largest network of manufacturing facilities, Toppan Photomasks offers a comprehensive range of photomask technologies and research and development capabilities to meet the increasingly sophisticated and divergent product-and-service requirements of the global semiconductor industry. We developed OBIEE application for all the subject areas involved with the management of products in Oracle Business intelligence. This application has developed using Answers and Dashboards in OBIEE.
Some of the activities /responsibilities include:
• Involved in life cycle development in OBIEE 10.1.3.2
• Created a new subject area as per the business requirements
• Created new dashboard which is only visible to users of the corporation
• Created and scheduled iBots for delivering personalized reports to users
• Designed Intelligent Dashboards for different user groups to view updated KPIs
• Developed various reports as per the requirements for user interface design like Drill Down, Pivot, Break down Reports, Narrative and Nested reports in Answers
• Performed complex OBIEE Analytics configuration involving report generation from OLTP and OLAP databases systems
• Upgrading Analytics RPD and made changes to the physical area to reflect merges in ETL and changes in the Upgrade Data Model
• Performed extensive debugging on existing ETL routines and repository(.rpd) layers
• Created detailed filters in repository (.rpd) to implement position based visibility
• Designed and modeled custom OLAP Subject Areas using dimensional modeling techniques
• Perform Administrative tasks in OBIEE such as granting privileges, creation of custom, complex and summary folders, linking folders for Drill-to detail and configuration
• Created Design and Development Documents for creation of new subject areas/customization
• Responsible for Data Modeling, Functional and Technical Design for the client
• Established aggregate tables and set up the repository to perform aggregation navigation
• Granted users with appropriate access to the subject areas and reports
• Provided access and security features for the sites
• Developed detailed documentation for the business users
Environment: Oracle BIEE 10.1.3.2, Oracle 10g.
Contact this candidate