SUMMARY

• 12+ years of IT experience in Developing and Implementing 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.
• Strong understanding of relational database design concepts and in depth knowledge of Data Warehousing and OLAP, OLTP solutions.
• 10+yrs of Experience in building enterprise DWH solutions through OBIEE/OBIA BI implementations.
• Experience in working wif business clients in gathering requirements, documenting teh requirements and understanding business process.
• Experience in OBIEE metadata repository RPD development, Web Catalog Administration and Data Modeling.
• Strong Experience in design and development of ETL Informatica, Datamodeling for Enterprise Data ware house and DAC scheduling.
• Strong experience in OBIEE 10.1.3.4.x/11.1.7.X, OBIA 7.9.6.4 and DAC implementations.
• Experience in OBIEE/Informatica/DAC/BI APPS installations.
• Designed business model (Star Schema) and metadata repository RPD based on Project requirements.
• Good understanding of STAR and SNOWFLAKE data models.
• Implemented OBIEEData level and Object level security for multiple projects.
• Experience in developing OBIEE Analysis/Answers, Dashboards, Delivers, iBots(alerts) and BI publisher.
• Experience in developing BI publisher reports and data templates
• Proficient knowledge in Oracle PL/SQL scripts, procedures etc.
• Experience in developing Technical Design Specifications.
• Sound knowledgeof ETL tools such as Informatica 9x and good understanding of ELT tool ODI(Oracle Data Integrator) 11g
• Experience in developing/customizing teh various OBIEE/OBIA dynamic and interactive complex reports/dashboards
• Experience in data modeling and used Data modelling tools like Erwin/SQL Modeler for multiple projects.
• Strong Experience in relational database systems like Oracle 10/11g and SQL Server.
• Experience in handling all phases of and Software Development Life Cycle(SDLC) of teh BI Projects
• Experience in implementing Data Migration projects.
• Experience in conducting POC reviews wif teh clients and projecting technical solutions.
• Experience in web technologies (HTML, Java script).
• Expert in adroit client communication and working wif multiple cross - functional teams.
• Experience in leading teh project teams and worked in Onsite/Offshore Model.
• Highly adaptable in quickly changing technical environments wif very strong organizational and analytical skills.

TECHNICAL SKILLS

OLAP BI Tools: OBIEE 11.1.7.X& OBIEE 10.1.3.4.X

ETL Tools: Informatica 8x/9x

Data Modeling Tools: Erwin, SQL Modeler

Databases: Oracle10/11g, MS SQL Server 2000

Web Technologies: ASP, JavaScript, VBScript, XML,HTML

Other Tools: TOAD, SQL Developer, MS Office.

Reporting Tools: Seagate Crystal Reports

Testing Tools: Bugzilla, HP Quality Center and Star Team

Operating System: Windows Server 2003 & 2008, Windows XP&9X, Linux, Unix and DOS

PROFESSIONAL EXPERIENCE

Confidential, Columbia, MO

Sr. OBIEE Consultant

Responsibilities:

• Act as SME for OBIEE BI implementations for BI requirements.
• Involve in OBIEE11g report Analysis, System Design, Development, Unit Testing, Production Support and Enhancements.
• Interact wif Business Analyst, business users and identify teh BI project requirements.
• Identify gaps and perform analysis on client requirements and suggest technical solution.
• Conduct Proof of concept reviews for new OBIEE report developments and presents to teh client.
• Prepared technical design documents for RPD, dashboard/report development based on teh requirements.
• Design and develop STAR data model as per teh project requirements.
• Prepare technical design documents for OBIEE RPD, dashboard/report development based on teh project requirements.
• Develop Javascript to impose mandatory filters on OBIEE adhoc reports.
• Configure/Customize OBIEE metadata repository (RPD) based on requirements, which includes Configuration of Physical, BMM and Presentation layers.
• Worked on MUD development for various projects in OBIEE 11g.
• Develop/Customize OBIEE RPD Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
• Customize/Configure OBIEE RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Develop iBots (alerts) and schedule OBIEE reports according to teh business requirements.
• Develop analytical and operational OBIEE reports/ dashboards and work on report layout views table/pivot table/chart/narrative/view selector etc.
• Prepare OBIEE deployment instructions document to deploy OBIEE RPD and Web Catalog objects for development, testing and production environments.
• Implement OBIEE performance improvement techniques.
• Develop/Enhance OBIEE interactive dashboards wif teh features such as Prompts, Drill downs, Guided Navigation etc.
• Develop Oracle PL/SQL queries to validate OBIEE report data across teh dashboards.
• Customize/Develop ETL Informatica mappings through Informatica Designer as per teh user requirements.
• Wok on Informatica Workflow manager to create tasks for teh mappings.
• IdentifyFinance Subject Area related ETL tables, Informatica workflows/mappings and DAC tasks and customize Informatica mappings.
• Develop new subject areas and execution plans in DAC as per teh requirements
• Monitor teh daily Incremental Load in Production environment and fix any issues during teh Load.

Environment: OBIEE 11.1.1.7, BI Apps 7.9.6x, DAC 11g, Informatica PC 9x, Oracle EBS R12, Unix, Oracle 11g, SQL Developer, HTML, JavaScript.

Confidential, GA

Sr.OBIEEConsultant

Responsibilities:

• Installed Out of box OBIA APPS and configured teh out of box RPD and Catalog.
• Configure/Customize OBIAmetadata repository (RPD) based on requirements, which includes Configuration of Physical, BMM and Presentation layers.
• Interact wif Business Analyst, clients and identify teh BI project requirements.
• Identify gaps and perform analysis over customer requirements and suggest technical solution.
• Act as SME for entire OBIEE BI implementations for Confidential ERS BI requirements.
• Conduct Proof of concept reviews for new OBIEE report developments and presents to teh client.
• Prepare technical design documents for RPD, dashboard/report development based on teh requirements.
• Develop/Customize OBIEE RPD Dimensional hierarchies, Aggregate Navigation and Time series calculations for various reporting requirements.
• Customize/Configure OBIEE RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Worked on Financial Analytics Subject Areas Account Receivables, Accounts Payables and GL Subject Areas and corresponding dashboards as per user requirements
• Customized Account Receivables, Accounts Payables and Oracle GL Subject Areas and corresponding dashboards as per client requirements.
• Implement OBIEE object level security for dashboards through client specific Application Roles/WEBGROUPS.
• Create Oracle SQLmaterialized views and aggregates tables to improve report-rendering performance.
• Works on both OBIEE webcatalog and Presentation administration.
• Works on Oracle PL/SQL scripts, Procedures and created materialized views based on teh requirements.
• Works on OBIEE report development which involves various OBIEE report views like table, chart, column selector, view selector, pivot view/Narrative view etc.
• Created custom CSS classes, styles, java scripts and HTML scripts to enhance teh dashboard interface, functionality and deliver reports according to teh business requirements.
• Develop/Enhance interactive dashboards wif teh features such as Prompts, Drill downs, Guided Navigation etc.
• ConfigureiBots (alerts) and schedule teh reports as per teh client requirements.
• Develop BI publisher reports and data templates.
• Enhance/Customize teh OBIA Financedashboards/reports based on user specific requirements.
• Developed KPI and KPI watch list as per teh business requirements.
• Customize/Develop ETL informatica mappings through Informatica Designer as per teh user requirements.
• Develop Informatica ETL mappings by using teh transformations such as Source qualifier, Lookup, Expressions, Update Strategy, Router, Filter, Sequence Generator, Aggregator, Joiner etc.
• Wok on Informatica Workflow manager to create tasks for teh mappings.
• Installed DAC and configured DAC container wif teh respective out of box OBIA ETL Informatica mappings.
• Configured teh Out of box ETL Repository in Informatica and created Integration service.
• IdentifyFinance Subject Area related ETL tables, Informatica workflows/mappings and DAC tasks and customize Informatica mappings
• Create/CustomizeInformatica Workflows wif Worklets & Tasks and schedulethroughDAC.
• Develop new subject areas and execution plans in DAC as per teh requirements
• Deploy Informatica workflows to teh DAC, create dependency and dependent hierarchical tasks and streamline teh Execution Plans wif their respective tasks in DAC.
• Monitor teh daily Incremental Load in Production environment and fix any issues during teh Load.
• Schedule data load using DAC by configuring teh developed mappings wif their sources, staging tables and targets along wif their workflows.
• Actively participate in client discussions and project discussions wifin ERS project.
• Conducts code reviews and mentors team for deliverables and helps teh team for technical challenges.
• Involves in continuous development, enhancements and resolves technical challenges.
• Prepare effort schedule for deliverables, assign and track teh work status from team members.

Environment: OBIEE 11.1.1.7, BI Apps 7.9.6x, DAC 11g, Informatica PC 9x, Oracle EBS R12, Unix, Oracle 11g, SQL Developer, HTML, JavaScript.

Confidential, Austin, TX

OBIEEConsultant

Responsibilities:

• Participated in requirements gathering wif teh clients and Business Analyst.
• Designed Star Schema Data model for Confidential specific Custom report requirements.
• Acted as SME for entire BI analytics implementation for OBIA Procurement analytical report development.
• Conducted POC reviews wif teh clients.
• Involves in discussion wif business clients for business requirements and analysis.
• Customized OBIA out of box RPD for Confidential specific requirements and configured Physical, BMM and Presentation layers.
• 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 teh dashboard interface, functionality and delivered reports according to teh business requirements.
• Performance management using optimization efforts such as aggregate navigation, indexes and Oracle materialized views.
• Worked on OBIA Procurement and Spend Analytics subject Areas Purchase Orders, Purchase Receipts, Purchase Requisitions, Purchase Requisition status.
• Customized teh OBIEE user interface on top of existing out of box Procurement dashboards,
• Classified multiple subject area in presentation layer depending on teh business user requirements.
• Customized OBIA RPD Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Developed interactive dashboards wif teh features such as Prompts, Guided Navigation, drill down etc.
• Prepared technical design specification documents.
• Developed various analytical and operational OBIEE reports/ dashboards through OBIEE presentation service and worked on report layout views table/pivot table/chart/narrative/view selector etc.
• OBIEE Webcatalog administration.
• Coordinated teh OBIEE RPD and Web Catalog objects migration from Dev environment to QA environment and to teh Production environment.
• Worked on iBots (alerts) and scheduled teh reports as per teh client requirements.
• Developed Oracle PL/SQL queries, procedures to validate report data across teh dashboards.
• Mentored team for report development and technical challenges.
• Conducted Pilot programswif teh clients during UAT phase.
• Planned work schedule estimations for individual team members
• Involved in end-to-end testing of all teh reporting deliverables during development.
• Worked on Data mapping files for data migration for legacy systems.
• Installed DAC and configured DAC container wif teh respective out of box OBIA ETL Informatica mappings
• Customized/Developed Informatica mapping through Informatica Designer.
• Configured teh Out of box ETL Repository in Informatica and created Integration service.
• Created different types of Transformations like Source Qualifier, Expression, and Filter, Rank, Sequence generator, Lookup, joiner, Aggregator, Sorter and Update Strategy transformations in Informatica designer.
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Deployed Informatica workflows to teh DAC, created dependency and dependent hierarchical tasks and streamlined teh Execution Plans wif their respective tasks in DAC.

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6.x, DAC 10.1.3.4.1 , Informatica PC 8.6, Oracle EBS Apps, Unix, Oracle 11g, TOAD,MSVISO

Confidential, Dallas, Tx

OBIEEConsultant

Responsibilities:

• Configured/Customized OBIA RPD for Physical, BMM and Presentation layers.
• Imported custom database tables to RPD Physical layer and created Alias table, physical joins and created logical tables in BMM layer.
• Configured/Customized OBIEE RPD hierarchies, level based measures, time series measures etc.
• Worked on Financial Analytics Subject Areas Account Receivables, Accounts Payables and GL Subject Areas and corresponding dashboards as per user requirements.
• Implemented OBIEE dashboard object level security through an External table.
• Configured/Customized out of box OBIA Repository, system and non-system session variable and initialization blocks for various reporting requirements.
• Customized OBIEE reports through Table/Pivot table/Chart/Narrative/Narrative Views etc.
• Customized interactive dashboards wif teh features such as Prompts, Guided Navigation, drill down etc.
• Developed Oracle PL/SQL queries, procedures to validate report data across teh dashboards.
• Developed CSS HTML custom style sheets as per teh client requirements and customized teh out of box OBIA dashboard web interface.
• Created custom columns and measures in RPD BMM layer for Finance Subject Areas Account Receivables, Accounts Payables and GL Subject Areas.
• Implemented Star Schema for new set of client custom requirements and used ERWIN modeler for logical and physical data model design.
• Customized/Developed Informatica mapping through Informatica Designer.
• Developed Informatica mappings though teh transformations such as Source Qualifier, Expression, Filter, Rank, Sequence generator, Lookup, joiner, Aggregator, Sorter and Update Strategy transformations in Informatica designer
• Worked on creating DAC tables, task definitions, Subject areas and indexes for tables and worked on change capture mechanism during incremental load for tables which were not part of OOB.
• Deployed Informatica workflows to teh DAC, created dependency and dependent hierarchical tasks and streamlined teh Execution Plans wif their respective tasks in DAC.
• Monitored teh daily Incremental Loads.

Environment: OBIEE 10.1.3.4.1 , BI Apps 7.9.6.x, DAC 10.1.3.4.1 , Informatica PC 8.6, Oracle EBS Apps, Unix, Oracle 11g, Erwin Data Modeler

Confidential, Pittsburgh, PA

OBIEE Developer

Responsibilities:

• Worked wif management professionals, analysts as well as other business teams on requirement gathering.
• Worked on repository development, configured metadata objects (Subject Area, Table, and Column) and web catalog objects (Dashboards, Folders, Reports).
• Identified Facts and Dimensions according to teh design specification.
• Developed analytical repository using Siebel Analytics Admin Tool (importing database object into physical layers, defining logical objects that includes Dimensions & facts in BMM layer and presentation catalog in Presentation Layer).
• Modified Dynamic Session Variables used for Data Visibility, Configured Security Confidential teh repository level, Catalog level & teh Siebel Application level.Created measures in Administration tool for teh requirements using expression builder and calculation wizard and also created hierarchies and level-based measures for drilldown detail wifin Analytics Reports.
• Used BI Publisher for report delivery in many popular pre-packaged application suites, like teh Oracle e-Business Suite.
• Created Rich Text Format (RTF) templates to generate BI Publisher Reports and embedded them on Oracle Intelligence Dashboard..

Environment: OBIEE 10.1.3.3,Informatica Power Center 7.1,Business Objects XIR2,Crystal Reports XI, DAC,Oracle BI Apps 7.9.4,BI Publisher, DAC

Confidential, Camp Hill, PA

Siebel Analytics Consultant

Responsibilities:

• Involved in gathering functional requirements from system users and converted them to business requirement documents.
• Used Metadata Design Principals to design Repository based on business requirements and followed Best Practices.
• Customized and developed teh SABMM layer by creating new logical columns, aggregate columns, hierarchies etc.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Developed many Reports / Dashboards wif different Analytics Views (Drill-Down, Pivot Table, Chart, Column Selector, Page and Dashboard Prompts).

Environment: Siebel Analytics 7.x, Informatica 6.x/5.x,Oracle 8i, UNIX, Windows 98