SUMMARY:

• US CITIZEN with PUBLIC TRUST CLEARANCE and over 10 years’ experience in IT with an emphasis on OBIEE 10.1.3.4.1 , 11g 11.1.1.3.0 /11.1.1.5.0/ 11.1.1.6.0 / 11.1.1.7 providing end - to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports and using interactive dashboards and Answers/ Analysis.
• Confidential in RPD Functions which include Mathematical, String, Calendar, Conversion, Aggregate and Time Series Functions.
• Expertise in using Console, Enterprise Manager, and Analysis in OBIEE 11g.
• Over 4 years experience in BI Publisher 10g/ 11g, improved business functionality by creating actionable reports and customer facing documents that help in speedy business decision making.
• Experience with design and development in OBIA specifically Oracle Financials, (GL, AP, AR, Projects and P2P), Supply Chain Management Analytics and Financial Management Analytics.
• Experience with upgrading from 10g to 11g using Upgrade Assistant and configuration files.
• Excellent Team member with good business acumen, effective communicator, experience in working with Business Users.
• Experience with Oracle BI Server, Oracle BI Answers/ Analysis, Oracle BI Scheduler, Oracle BI Interactive Dashboards and BI Publisher.
• Extensive experience in creating and modifying OBIEE Repositories (Physical, Business Model and Mapping, and Presentation layers) using the OBIEE Administration tool from Relational, File, Essbase and Microsoft Analysis Services data sources.
• Extensive experience in using Dimensional Hierarchy modeling (from Granular to Global levels) and Time series modeling in the Business Model and Mapping layer to meet business requirements.
• Extensive experience in creating sophisticated reports and templates using BI Publisher.
• Successfully created reports in multiple formats and delivered them to multiple destinations (Email, Fax, and Printer) using BI Publisher.
• Expertise in building star and snowflake schemas in the repository as well as using the OBIEE 11g New Join link in the physical layer.
• Expertise in using Alias and Dim tables so that the hierarchy and time series modeling would meet business requirements.
• Experience in using and troubleshooting the main servers: Oracle BI Server, Oracle Presentation Server and Oracle BI Scheduler.
• Experience in a Multi User Development Environment (MUDE), checking out RPD and making changes to meet business requirements.
• Expertise in designing and developing custom reports using BI Answers and making them available in Dashboards.
• Expertise in managing the NQSCONFIG.INI files to manage the RPD, and other parameters.
• Expertise in managing the INSTANCE CONFIG files to manage Presentation services.
• Expertise in managing performance through use of cache management and aggregated tables.

TECHNICAL SKILLS:

BI Tools: 10g 10.1.3.4.1 /11.1.1.3.0/11g 11.1.1.5.0/ 11.1.1.6.0 / 11.1.1.7 (Oracle BI Administration, Oracle BI Presentation, Oracle BI Dashboards, Oracle BI Delivers, Oracle BI Publisher, Catalog Manager)

Databases: Oracle 10g/11g

Languages: SQLOperating System: Windows XP

SQL Tools: SQL Developer

WORK EXPERIENCE:

Confidential

SENIOR OBIEE CONSULTANT

Responsibilities:

• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Designed and customized RPD's, Oracle Answers (webcat), Dashboards and Cache.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

Confidential

SENIOR OBIEE CONSULTANT

Responsibilities:

• Attended Client meetings to understand and prioritize the customer’s business and technical needs.
• Migrated Federal EBS Financial Reports from Discoverer to OBIEE 11g using either direct database tables or through Opaque Views.
• Built new reports in OBIEE.
• Remediated R11 SQL to be R12 compatible.
• Worked closely with the business users to identify various Confidential 's and designed solutions to enhance business decision-making.
• Contributed to the design and implementation of the reporting components of the solution, including creation of Oracle product demos.
• Contributed to the production of client deliverables such as detailed design and configuration documentation.

Confidential, Collegeville, PA

OBIEE Application Specialist

Responsibilities:

• Attended to business requirements meetings and interpretation of client needs in the design of the integration of the data sources within the RPD.
• Lead work teams which provide business and technical support for global planning processes.
• Provided input to the development and maintenance of reporting, including the building of functions within reports such as Time Series and Aggregates.
• Worked with business users to understand and communicate business and technical requirements.
• Worked with Supply Planners to implement new reporting metrics and Confidential ’s .
• Provided day-to-day support for planning activities with Global planning representatives.
• Assured adherence to all established work practices and enterprise-wide policies and standards.
• Provided response mechanism for day-to-day inquiries and issues.
• Attended to the performance tuning of WebLogic server by implementing strategies which include: tuning Pool Sizes, using the Prepared Statement Cache using Optimistic or Read-only Concurrency

Confidential, Seattle, WA

OBIEE Lead Application Developer and Administrator

Responsibilities:

• Designed and developed post upgrade plan with client using Business Intelligence systems utilizing Oracle database and Oracle Business Intelligence Enterprise Edition (OBI EE) 11g reporting tool including OBI EE 11g administration.
• Worked on rebuild of upgraded Supply Chain and Order Management Analytics dashboards such as Trends, Bill of Materials and Balances, to ensure that they reflect the content users required from 10g.
• Worked on modeling the RPD.
• Attended to Code Version upgrades of the webcat and debugging the same.
• Optimized the RPD for migration.
• Attended to setting up new security features from 10g to 11g.
• Attended to moving of files from DEV to TEST and then PROD.

Confidential, Dallas, TX

Lead Technical Consultant

Responsibilities:

• Prioritized the customer’s business and technical needs.
• Contributed to the design and implementation of the metadata, ETL and/or reporting components of the solution. This included testing and, at times, deployment of the components.
• Produced client deliverables such as detailed design documentation, configuration documentation, unit test plans and training curriculum.
• Abide by Perficient’s best practices in the design and implementation of BI solutions.
• Regularly communicated one’s progress, problems and plans to leadership; adapted to changes in the project plan and customer requirements.

Confidential, Dallas, TX

OBIEE Architect

Responsibilities:

• Worked closely with the business users to identify various Confidential 's and designed solutions to enhance business decision-making.
• Assisted with upgrade from 10g to 11g using Upgrade Assistant for RPD, Presentation Catalog and BI Publisher and manual upgrades of configuration files including testing and security and privilege checks.
• Created reports with recommended views and made use of Breadcrumbs to assist with navigation.
• Anchored columns with freeze options.
• Customized Oracle Financial Management Analytics reports to display required information through the Edit option of OBIEE Analytics on each report.
• Created Essbase Repositories by importing metadata using Import Wizard, amending physical models, creating business models and subject areas.
• Combined Essbase with non-relational data into single business model using data federation techniques while at the same time enhancing performance through lookup functionalities.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Created Connection pools, imported physical tables and defined joins in the Physical Layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created table views, title views and pivot tables in dashboards.
• Configured Oracle Mapviewer with Navteq spatial data by importing into Oracle Database and setting up the Catalog and Repository to correspond.
• Created map views using map view editor, designed shapes on latitude and longitude values and plotting overlaying pie charts.
• 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.
• Designed dashboards and reports for role based users like Executive Management and Rep Levels.
• Developed Dashboards for each metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtained weekly reports and to send alerts to related managers and secured team members.
• Enhanced performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema.)
• Closely worked with ETL team to develop Mappings, Sessions, Workflows, and Database Connections and created test cases.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10g 10.1.3.4.1 /11.1.1.3.0/ 11.1.1.5.0, 11.1.1.6, 11.1.1.7 Oracle BI Publisher, Oracle Delivers, Windows XP & SQL. Informatica Power Center 7x

Confidential, Cincinnati, OH

OBIEE Lead Developer

Responsibilities:

• Attend follow up calls about the OBIEE Business Processes with End Users and Team Members.
• Created Repositories by building physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin tool to create Connection pools, import physical tables and define joins in physical layer.
• Set up and tested XMLA access to Microsoft Analysis Services cube.
• Used BI Admin Tool to import cubes, dimensions, members and measures from Analysis Services database using Metadata Import Wizard with SSAS credentials.
• Created Connection pools, cube tables, database objects, and trimming number of tables and hierarchies if not needed by users through either nesting or deleting.
• Customized the Business layer and Subject area by dragging and dropping cubes to BMM and Validating Repository using Consistency Checker.
• Developed and customized some of the existing Dimensions (Drill down Hierarchies) & Logical Objects in Business Model and Mapping Layer and Presentation Catalogs in the Presentation Layer.
• Created Aggregations and Logical Based Measures in Business Model and Mapping Layer. Created Analytical Views (Compound Layout, chart, pivot etc.,) and Global/Local Prompts to design the Dashboards.
• Created Security Settings in Oracle Administration Tool to setup Groups and Provide Access Privileges and Query Privileges and also managed security for Groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, 11.1.1.3 Oracle BI Publisher, Oracle Delivers, Windows XP, SQL.

Confidential

OBIEE Developer

Responsibilities:

• Communicated with management to obtain business requirements.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Configured and Created repository using OBIEE 10.1.3 Admin tool.
• Created numerous executive level reports. Designed dashboards to provide insight into the marketing/financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, and Alias tables.
• Analyzed and validated the Oracle BI repository by performing consistency check as per the oracle best practices.
• Created groups and users to manage the security privileges for each subject area in RPD and dashboards according to user requirements.
• Designed and customized RPD's, Oracle Answers (webcat), Dashboards and Cache.
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements.
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables.
• Generated various Analytics Reports like Formulary Report and Direct Sales Report using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate Security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/Ad-hoc queries using OBIEE Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Oracle Delivers, BI Publisher, Windows XP, SQL, Oracle 10g.

Confidential

Computer and Software Patent Agent

Responsibilities:

• Embedded systems
• Consumer electronics
• Digital signal processors
• Medical devices
• Imaging equipment
• Error correction algorithms
• Video compression/decompression algorithms
• Cellular/wireless systems
• Object oriented applications and architectures
• Data transmission formats/protocols/storage
• Advanced microprocessors/memory architectures
• Radio frequency/bar code ID algorithms
• Multi-user/multi-processor computer platforms
• Networking/clustering/fault tolerant systems
• Database organization/standard query language execution algorithms