SUMMARY

• 10+ years of overall IT experience involving Analysis, Design, Development and Implementation using standard SDLC methodologies
• Over 9 years of experience in designing and developing end - to-end solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE), Micro Strategy, Tableau and Cognos, Including 3 full lifecycle implementations
• Experience and knowledge with major reporting tools Oracle Business Intelligence (OBIEE), MicroStrategy and Hyperion IR
• Core competencies include design and development of OBIEE repositories, and building OBIEE Dashboards/Reports, Data modeling, ETL Data mart
• Experience in OBIEE 12c, 11g as SME to analyze business requirements to develop interactive Dashboards and Ad Hoc Reports, upgrade, Technical challenges fine-tuning, system configurations, development, best practices, perform code reviews and implementation activities for Business Intelligence.
• Working experience with new administration features of OBIEE 11g (OBIEE 11g Administration Console, OBIEE 11g Enterprise Manager)
• Working experience on integrating OBIEE with Smartview
• Expertise in design and development of the three layers (Physical/Business Model and Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration Tool.
• Extensive experience implementing BI solutions at numerous companies including a major Retailer, Consumer goods, Financial Institutions, Higher Education Institutions
• Extensive experience in Data Warehouse with full understanding of Dimensional Data Modeling
• Knowledge in PeopleSoft Campus Solutions, Student Administration, Human Capital Management and Financial Management Systems.
• Strong knowledge of SQL/PL SQL and performance tuning in ORACLE
• ETL Development experience using Informatica.
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Proficient in ETL processes of creating Source/Target definitions, building Mappings/Mapplets using various Transformations, creating and monitoring Sessions/Workflows.
• Proficient in defining Key Metrics, Dimensions, Hierarchies, Attributes and building Star and Snowflake Schema.
• Extensive experience in Unit, Regression, Performance, Integration and User Acceptance testing methodologies.
• Able to handle and achieve completion on multiple projects and priorities simultaneously.

TECHNICAL SKILLS

Reporting Tools: OBIEE 12.2.1, OBIEE 11.1.1.x, OBIEE 10.1.3.x, ODI, OBI Publisher 10.1.3.4, Hyperion IR 9.3.1, MicroStrategy 9.x, 8.x (MicroStrategy Desktop, Web, Intelligence Server, Narrowcast Server, Administrator and MicroStrategy Architect), Cognos Report Net 1.1

ETL Tools: Informatica Power Center 8.x/, Data stage 8.x

Operating Systems: Windows95/98/NT/XP, UNIX, MS DOS, Mac

Languages: SQL, PL/SQL, C

OLTP / Middleware: CICS, MQ Series

Tools: & Utilities: SQL Developer, SQL*Plus, TOAD, MS Office, Excel, Hyperion.

Databases: Oracle 11g/10g, SQL Server 2000/2005, MS Access

Web Technologies: HTML, Javascript, XML

PROFESSIONAL EXPERIENCE

Confidential, CT

Sr.BI Analyst/Developer

Responsibilities:

• Involved in all the OBIEE projects from initial phase to the production release like requirement gathering, design, development, testing and release.
• Involved in meeting with business representatives for requirement analysis and to define business and functional specifications.
• Built OBIEE Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Worked with business analysts (Student Administration/Financials/Research Administration) to gather analytics requirements and created the business model using star schemas.
• Developed Reports for Student Administration, Financial Analytics and Research Administration
• Involved in administrative tasks such as Branding the Company logo in OBIEE environment.
• Configured Embedded Content from external sources to Dashboards.
• Configured Maps with Map viewer and OBIEE.
• Integrated OBIEE reports on to Microsoft Office tool Smartview
• Built BI Publisher reports which provided shared online components (subpages) supporting one-click report execution (used by each report)
• Managed security privileges for each subject area and dashboards according to user requirements.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.
• Worked on tuning the longest running mappings by turning them to SQL procedures for quicker run times.
• Worked with Oracle Enterprise Manager (FMW) to monitor, manage and configure Oracle BI system components.
• Worked with Oracle Fusion Middleware Control to create and manage the Application Roles and Application Policies that control access to Oracle Business Intelligence resources
• Working experience with Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server.
• Executed OBIEE administrative tasks such as OBIEE 12c server installation, Configuration, Security, migration, and user maintenance.
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Worked closely with Users, ETL Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to repository.

Environment: OBIEE 12.2.1.0, OBIEE 11.x, Smartview, Data stage 8.1, Oracle 11/12c, Sql Developer, Hyperion IR 9.3.1, PeopleSoft, UNIX, Windows.

Confidential, Atlanta, GA

Sr.BI Analyst/Developer

Responsibilities:

• Involved in meetings with business representatives for requirement analysis and to define business and functional specifications.
• Built OBIEE Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Worked with OBIEE Analysis, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Created number of Finance reports for business such as Sponsored Project Budget Position Report, Transaction Detail Report, Encumbrance Detail Report, Profit and loss.
• Worked with Oracle Fusion Middleware Control to create and manage the Application Roles and Application Policies that control access to Oracle Business Intelligence resources
• Assisted developers in understanding and using MUDE development
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, rebuilding of indexes, overwriting the sql execution path by making use of hints etc.,
• Bug fixing and debugging using TOAD and SQL in Oracle environment
• Analyzed business problems and designed proper solutions utilizing Oracle BI Enterprise Edition (OBIEE)
• Managed security privileges for each subject area and dashboards according to user requirements
• Working experience with Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server.
• Defined the OBI Design Technical Specification document for all the requirements
• Recommended Data Model Changes for obtaining optimal and scalable long-term performance

Environment: OBIEE 11.1.1.6.1 , OBIEE 11.1.1.5.0 , WebLogic 10.3.5.0, SQL Server 2005, Oracle 11g, TOAD, SQL Developer, Windows XP, Compass (PeopleSoft)

Confidential, Burbank, CA

Sr.BI Developer

Responsibilities:

• Involved in all the BI projects from initial phase to the production release like requirement gathering, design, development, testing and release
• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Developed number of KPM (Key Performance Metrics) complex reports for the Business where they can track and compare the Estimate, Plan and Variance.
• Involved in the Migration project (from MicroStrategy to OBIEE)
• Defining views into MicroStrategy and creating Schema Objects (facts, attributes, hierarchies, Transformations)
• Creating Application Objects (filters, metrics, prompts, consolidations and custom groups)
• Imported the tables/views into MicroStrategy warehouse catalog and created Schema Objects
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Worked with OBIEE Analysis, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Managed security privileges for each subject area and dashboards according to user requirements
• Executed OBIEE 11g administrative tasks such as OBIEE 11g server installation, Configuration, migration, and user maintenance.
• Used OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, rebuilding of indexes
• Worked with Oracle Enterprise Manager (FMW) to monitor, manage and configure Oracle BI system components.
• Working experience with Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server.
• Implemented SSO (Single Sign On) in OBIEE with Microsoft Active Directory.
• Worked on Security Setup at both Object and Data levels, which involved creation of users/groups, Application Roles
• Analyzed business problems and designed proper solutions utilizing Oracle BI Enterprise Edition (OBIEE)

Environment: OBIEE 11.1.1.5.0 , WebLogic 10.3.5.0, MicroStrategy 9.0.2, MicroStrategy Desktop, Web, Intelligence Server, Architect, Report Services, Administration, Dashboards, Distribution Services, SQL Server 2005, Oracle 10GR2, TOAD, SQL Developer, Windows XP.

Confidential, San Leandro, CA

OBIEE Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document.
• Created number of key reports for business such as Cross sales report, Summary Profitability, Product Profit, Profit and loss for business to analyze.
• Worked with OBIEE Analysis, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Worked with onshore and offshore team of 7 developers and led the team in the direction of development.
• Configured repository and session variables to get dynamic reports and dashboards.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Executed OBIEE 11g administrative tasks such as OBIEE 11g server installation, migration, and user maintenance.
• Worked on OBIEE Administration Tool for customizing and modifying the Physical, Business Model/Mapping and Presentation layers of metadata repository (.rpd).
• Worked with Oracle Enterprise Manager (FMW) to monitor, manage and configure Oracle BI system components.
• Working experience with Oracle Weblogic Server Administration Console to create and manage users and groups in the embedded LDAP server.
• Worked with Oracle Fusion Middleware Control to create and manage the Application Roles and Application Policies that control access to Oracle Business Intelligence resources.
• Implemented Proxy Users (“Act As”) functionality in OBIEE 11g.
• Handled code review of work product created by off shore resources.
• Analyzed business problems and designed proper solutions utilizing Oracle BI Enterprise Edition (OBIEE).

Environment: OBIEE 11.1.1.5.0 , WebLogic 10.3.5.0, Oracle 10GR2, TOAD, SQL Developer, Windows XP.

Confidential, Tucson, AZ

OBIEE Report Developer

Responsibilities:

• Built OBIEE Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Involved in meeting with business representatives for requirement analysis and to define business and functional specifications.
• Worked with business analyst and users (Student Administration/HR) to gather analytics requirements and created the business model using star schemas.
• Worked with HR analytics to make sense of business performance by adding context to real-time business measure.
• Developed Reports in Student Administration and HR (Compensation/Payroll) Analytics. Also developed complex reports where the different employees are compensated at different levels. Resolved complex modeling with different views.
• Involved in all the OBIEE projects from initial phase to the production release like requirement gathering, design, development, testing and release.
• Analyzing the Oracle ERP service module (table relationships) for customizing the mappings and also for developing new mappings.
• Configured Interactive Dashboards with delivers/iBots to alert the student’s team about business changes.
• Created a “one-click solution” enabling the option of running XML Publisher reports to a window (in either Excel or PDF) in single mouse click (bypassing process monitor)
• Built BI Publisher reports which provided shared online components (subpages) supporting one-click report execution (used by each report)
• Managed security privileges for each subject area and dashboards according to user requirements.
• Worked with OBIEE Answers, Intelligence Dashboards. Demonstrated knowledge in dealing with various functionalities like prompts, views, aggregates, global filters, scheduling, guided navigation, customization, conditional formatting of reports to satisfy the end users. Managed dashboard and request security/privileges in the analytics catalog manager.
• Created Reports, pivots, charts and dashboards in Hyperion Interactive Reporting
• Worked on tuning the longest running mappings by turning them to SQL procedures for quicker run times.
• Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security
• Performance Tuning of Dashboards/Reports and made recommendations for changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Worked closely with Users, ETL Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to repository.
• Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.

Environment: OBIEE 10.1.3.4, Data stage 8.1, Oracle 8.0.x/8.1.5, SQL Server 2000, Sql Developer, Hyperion IR 9.3.1, PeopleSoft, UNIX, Microsoft Visio, Windows xp.

Confidential

Report/ETL Developer

Responsibilities:

• Developed ad-hoc reports using query studio.
• Developed List, Crosstab, and Chart reports using Report Studio.
• Created customized reports using calculations, filters, and conditional formatting in Report Studio.
• Worked with complex reports like master-detail and drill through reports.
• Designed reports with various formatting features in eliminating the duplicates using Level span, Sectional, and grouping.
• Developed a report which involve in creation of single select and multi select cascading prompts.
• Handled full load and refresh load via staging tables in the ETL Layer.
• Designed and developed new Aggregates using Informatica ETL processes.
• Created mappings for initial load and daily updates using Informatica.

Environment: Cognos Report Net 1.1, Oracle 8i, Informatica 6.1, Oracle 8i, UNIX, SQL server, Windows NT 2000.