SUMMARY:

• Have 10+ years of experience in Business Intelligence Applications using Oracle Business Intelligence (OBIEE) /Oracle Business Intelligence Apps (BI Apps) and Tableau with Oracle EBS source background in Implementation, Integration, Production Support, develop and implements disaster recovery and planning efforts.
• Worked on all phases of DW/BI implementation lifecycle from conceptualization, requirement gathering, analysis, design, implementation, testing, Server Administration, maintenance and support.
• Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timelines.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end - users /customers.
• Tremendous client interfacing experience and exposure to Pre-Sales activities including PoC, Project Costing, Proposal Making.
• Experience in architect, and developing of OBIEE 10.1.3.3.2, 10.1.3.4.1, 10.1.3.4.2, OBIEE 11.1.1.3.0, 11.1.1.5, 11.1.1.6, 11.1.1.7.1 OBIEE 12c, OBIA 7.9.6.4,OTBI 11.1.1.10.0, Tableau 8.2,9.2, Oracle 10g and 11g Development, SQL Developer, Toad.
• Expertise in OBIEE 10g to OBIEE 11g, OBIEE11g to OBIEE12c upgradation.
• Experience in Data Analysis, Performing Gap Analysis, Identification of dimensions, Facts & aggregate tables, Measures and Hierarchies.
• Experience in developing, modifying, and administering Analytics Intelligence Dashboards with drill down capabilities using prompts and filters Oracle Business Intelligence Enterprise Edition (OBIEE), using OBIEE Answers/Analysis, creating iBots/Agents using OBIEE Delivers.
• Experience in providing end-to-end business intelligence solutions by dimensional modeling design, building business models, configuring metadata, creating reports / Dashboards, cache monitor, building OBIEE Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer), time series objects, configuring OBIEE security (groups, access / query privileges) using OBIEE Repository, OBIEE Presentation Services, and OBI Publisher.
• Worked extensively with Oracle 10g, 11g, and Teradata databases.
• Experience in developing customized Oracle SQL queries and PL/SQL Programs
• Experience in developing customized SQL Server queires and TSQL Programs.
• Strong Knowledge in Oracle SQL query Performance tuning using Explain plan
• Experience in Performance Tuning of Data Warehouses by implementing the materialized views.
• Implemented Cache Management (Cache Seeding and Cache Purging).
• Good knowledge on OTBI 11.1.1.10.0
• Experience in Installation, Configuration, and Administration of Oracle OBIEE 10g and 11g standalone, OBIEE Presentation Services, and OBI Publisher, and configuring Delivers, Answers, and OBI Publisher to work together.
• Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data and Web Catalog Objects as per the data requirements using OBIEE Admin tool.
• Experience with end user documentation development, reporting requirements, reporting process flows, reporting solutions, flow charts, report mock-ups, process flow diagrams for reports.
• Worked extensively on Tableau 8.2 and Tableau 9.2 to create stories for Business Partner presentations.
• Skilled in Tableau Desktop versions 9.1, 9.2, 8.1 and 8.2. for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts.
• Experience in creating solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts.
• Expertise in Upgrade of OBIEE 10g to 11g and 11g to 12c.
• Expertise in migrating the Hyperion reports to OBIEE.
• Expertise in migrating the Cognos reports to OBIEE
• Expertise in migrating the OBIEE reports to Tableau
• Expertise of ETL tools like Informatica
• Excellent problem solving skills with strong technical background and good interpersonal skills. Quick learner and excellent team player, ability to meet deadlines and work under pressure. Excellent ability to understand and analyze the client requirements.

TECHNICAL SKILLS:

Operating Systems: Windows 7, Win XP/2000//2003, Windows NT/98 & UNIX (Linux)

Programming Languages: C, C++, SQL, PL/SQL, Shell Scripting

Relational Databases: Oracle 9i/10g/11g, SQL Server 2000/2005, IBM DB2 UDB 8.2, Teradata V15

Web Technologies: HTML, XML

Database Tools: TOAD, SQL*plus, ODBC, SQL*Loader, SQL Developer, Teradata SQL Assistant

BI Tools: Siebel Analytics 7.X, OBIEE 11.1.1.X, 10.1.3.X & BI Applications 7.9.6.X,OTBI 11.1.1.10.0, Tableau 8.2/9.2, Cognos Impromptu, OTBI.

ETL Tools: ODI12C, Informatica Power Center 8.6/8.1.1/7.1/6.1, SSIS 2005/2008R2/2012

Networking Protocols: TCP/IP, UDP, IP, SMTP

MS Suite: MS outlook, Microsoft office 2003/2007, MS Access, Excel

PROFESSIONAL EXPERIENCE:

Confidential, Boston

BI Lead Developer

Responsibilities:

• Involved in gathering the business requirements and prepare the Functional Documents.
• Created GAP Analysis Document, shared the same to the business group to highlight and resolve the open GAPs.
• Involved in creating the Technical design documents.
• Good experience in designing logical and physical data models using Star Schema
• Developed the repository of OBIEE to cater the business requirements by creating new tables, aliases, joins in the physical layer, dimensions, facts, logical table sources, hierarchies, aggregated measures in BMM layer, subject areas in presentation layer.
• Designed and developed various Oracle BI Web Components such as reports (with different views), charts, prompts, filters, dashboard pages, user groups.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Developed custom reports/Ad-hoc queries using Answers.
• Implemented data level security by applying security on the presentation tables added in the repository.
• Implemented object level security on the dashboards by granting privileges to user groups as per the requirement.
• Involved in install and configure OBIEE.
• Implemented Cache Management.
• Involved in manually migrating the code (rpd changes and web catalog objects) from one environment to other.
• Supported the business team and users during UAT and conducted demos to explain the functionality of the dashboards.
• Involved in performance tuning of the reports.

Environment: OBIEE 11.1.1.7, OBIEE12C,Informatica 9.5.1, ESP, Oracle 11g Windows XP, Linux, Toad.

Confidential

BI Architect

Responsibilities:

• Gathering business requirements, creating business requirement documents (BRD /FRD).
• FIT and GAP analysis of the existing system and propose new solutions.
• Working with business partners to get the business requirements sign off.
• Translate the Functional requirements into Technical design documents.
• Designing logical and physical data models using Star Schema.
• Developed the repository of OBIEE to cater the business requirements by creating new tables, aliases, joins in the physical layer, dimensions, facts, logical table sources, hierarchies, aggregated measures in BMM layer, subject areas in presentation layer.
• Designed and developed various Oracle BI Web Components such as reports (with different views), charts, prompts, filters, dashboard pages, user groups.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Updated dashboards and report designs showing trends, patterns and other required data analysis using OBIEE Analysis.
• Created Agents to deliver reports to End Users
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates which will be used by business in daily basis.
• Design complex RTF, PDF, and Excel templates for Oracle BI Publisher
• Implemented comprehensive security functionality by creating users & web groups, external table security using session variables, test and validate the model using OBIEE Server Admin tool and associating catalog objects and Web modules with the created users and groups.
• Implemented data level and object level security based on the user requirement
• Implemented Cache Management (Cache Seeding and Cache Purging).
• Installation, Configuration, and Administration of Oracle OBIEE 11g standalone, OBIEE Presentation Services, and OBI Publisher, and configuring OBI scheduler, Delivers, Answers, and OBI Publisher to work together.
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Testing, debugging and Performance Tuning applications prior to user acceptance testing (UAT).
• Conducted OBIEE 11g trainings to Confidential Users.

Environment: Microsoft Windows 7 (Client Tools), OBIEE12C,OBIEE 11.1.1.7, SSIS, Sybase, SQL Server 2012, SQL Developer

Confidential

BI Lead Developer

Responsibilities:

• Gathering business requirements, creating business requirement documents (BRD /FRD).
• FIT and GAP analysis of the existing system and propose new solutions.
• Working with business partners to get the business requirements sign off.
• Translate the Functional requirements into Technical design documents.
• Created new Facts and Dimensions and used some of the existing confirmed dimensions to build multiple data models for Confidential and HR Analytics.
• Involved in Scoping and Estimating of new custom Profitability and Advanced Order Subject areas
• Customized the Financial and HR Subject Areas in OBIEE RPD based on project requirements.
• Implemented MUDE to enable multi developers to work on the RPD.
• Responsible for managing the DAC environment for adding and modifying Tasks, Indexes and Subject Areas to accommodate in the current execution plan in DAC.
• Developed the custom Informatica interfaces to load complex HR data from external sources.
• Coordinated and guided the off shore team in requirements translation, task completion and meeting the deadlines.
• Involved in preparing design specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Added customized flex fields, user defined fields and DFFs to the OBIA OOTB mappings for client specific requirements.
• Good knowledge on OTBI Financial reports.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Application level.
• Experience in performance tuning at the Database level by creating aggregate tables, Bitmap, B Tree Indexes, RPD level by creating Database hints in physical Layer, Tuning Reports.
• Involved in monitoring the loads through DAC.
• Utilized BI (XML) Publisher to create Data Templates, RTF, and XSL Templates.
• Created data models, parameters, templates and writing SQL Query for getting the data from Siebel source tables to design the BIP reports
• Analyzing the issues submitted in production support and provide Root Cause Analysis document for the issues.
• Created adhoc reports in OTBI.
• Responsible for leading the offshore teams and acted as single point of contact for all requirements analysis and translation.
• Responsible for all Production support activities, review code as a gate keeper to maintain the best practices, and migration of the code into production based upon maintenance cycles.
• Responsible for root cause analysis and get buy-in from business community for sustainable solutions.
• Responsible for all ad-hoc project deliverables and single point of contact for all the client interaction.
• Mentoring junior level resources and guide team members wherever required.

Environment: Informatica 9.1.0, OBIEE 11g, Oracle 11g R1,DAC, OBIA 7.9.6.3,OTBI 11.1.1.10.0, Windows XP, Linux, Toad

Confidential, Pittsburgh

OBIEE Lead Developer

Responsibilities:

• Analyses .IQD queries and created GAP Analysis Document shared the same to the business group to highlight and resolve the open GAPs.
• Created the technical Design Document the based on the Functional requirement document
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Used the OBIEE Administration tool to develop and enhance Data Model.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) based on the Cognos reports.
• Implemented the object level security based on the user requirement.
• Design and development of Tableau visualization solutions.
• Creating extracts and publishing data sources/workbooks to server.
• Involved in reviewing business requirements and analyzing data sources for design, development, testing of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop those were published to further data analysis and customization using filters and actions.
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau
• Created Cascading dashboards, data extracts Action filters for better performance of Tableau.
• Supported PNC team during the UAT Testing.

Environment: Microsoft Windows 7 (Client Tools), OBIEE 11.1.1.7, Tableau 8.2,Cognos Impromptu, Informatica 8.6,Oracle 11g.

Confidential

OBIEE Lead Develpoer

Responsibilities:

• Upgrade the reports from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5.
• Applied OBIEE patches to upgrade to higher versions
• Customizes the existing OBIEE reports based on the user requirement
• Working with business partners to get the business requirements sign off.
• Co-ordinate and remediate the business requirements into Dimension Models.
• Work with business DBA, Business Analyst, End Users to capture reports requirement and translating them to technical design
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Design Oracle BI Publisher Data Models, Data sets and Templates / sub templates
• Configured the Multiuser Development environment
• Configured the scheduler server.
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Supported the business team and users during UAT and conducted demos to explain the functionality of the dashboards
• Created Test Case documents to test the new objects added and Migration document to migrate the code units across environments.
• Written many SQL statements for validating the reports and used the same in Test documents.

Environment: Linux (Server), Microsoft Windows 7 (Client Tools), OBIEE 10.1.3.4.1, OBIEE 11.1.1.5, OBIEE 11.1.7.1,SSIS 2008 R2,SQL Server 2008

Confidential

OBIEE Lead Develpoer

Responsibilities:

• Upgrade the reports from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.5.
• Involved in completely on Oracle BI servers and applications, setting up the Oracle BI environments for different projects.
• Involved working with Development teams on the environmental systems.
• Applied OBIEE patches to upgrade to higher versions
• Customizes the existing OBIEE reports based on the user requirement
• Working with business partners to get the business requirements sign off.
• Co-ordinate and remediate the business requirements into Dimension Models.
• Work with business DBA, Business Analyst, End Users to capture reports requirement and translating them to technical design
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Created dimensional hierarchies and level based measures.
• Created the various calculated metrics using calculationwizard.
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Installation, Configuration, and Administration of Oracle OBIEE 11g standalone, OBIEE Presentation Services, and OBI Publisher, and configuring OBI scheduler, Delivers, Answers, and OBI Publisher to work together.
• Configured the metadata report to easily identify the database source columns.

Environment: Linux (Server), Microsoft Windows 7 (Client Tools), OBIEE 10.1.3.4.1, OBIEE 11.1.1.5, OBIEE 11.1.7.1, SSIS 2008 R2, SQL Server 2008

Confidential

OBIA Lead Develpoer

Responsibilities:

• Providing end-to-end business intelligence solution by configuring metadata & building Repository, template design, building business models, and generating reports using OBIEE 10.1.3.4.1, OBIA 7.9.6.1
• Customizes the Mappings
• Created the Tasks in DAC
• Design and developed process for Initial loads and Ongoing loads (Incremental Aggregation with Extract Date concept).
• Extracted many Mapplets and workflows from Prebuilt like Oracle EBS, BI apps and modified them according to the requirement, also tuned them for Optimum performance,
• Dependencies and Batch Design.
• Customizes the existing OBIEE reports based on the user requirement
• Involved in Migration and Merging of Analytics Repository and Catalog from Dev to QA and coordinated into production.

Environment: OBI EE/ Publisher 10.1.3.4.1, UNIX - AIX 5.3 (64Bit), Informatica 8.6.1,Oracle 10g/ 11g R1, DAC 10.1.3.4, OBIA 7.9.6.X ( Confidential ), LDAP (ADS), Oracle EBS 11i R12, TOAD

Confidential, Palo Alto, CA

Senior OBIEE Developer

Responsibilities:

• Lead Migration and implementation of OBIEE 11.1.1.6.
• Assistance in validating and implementing recommendations based on review of the OBIEE 10g repository.
• Gathering business requirements, creating business requirement documents (BRD /FRD).
• FIT and GAP analysis of the existing system and propose new solutions.
• Working with business partners to get the business requirements sign off.
• Co-ordinate and remediate the business requirements into Dimension Models.
• Work with VMware’s technical and functional resources to validate VMDash metadata design and implement identified retrofits.
• Fix metadata warnings arising during consistency checks through appropriate application of design principles or workarounds.
• Collaborate with the VMware’s technical team and implement metadata design configurations to ensure logical and physical object relationships within VMDash OBIEE RPD confirm to standard practices.
• Assisting VMware technical team in their validation of the OBIEE 11g upgrade and production roll out of the upgraded OBIEE 11g application.
• Re-create Usage Tracking
• Establish OBIEE 11g Test environment and OBIEE 11g Production environment based on Configuration management standard practices.
• Integrate RPD and Catalog content between environments and establish uniform architecture across all VMware environments
• Support VMware technical team with report and data validations of the upgraded 11g content and assist in fixing or implementing appropriate workarounds for any upgrade related issues that arise during validations of reports
• Support VMware technical team during user testing of OBIEE 11g
• Provide oversight and guidance for the technical team in OBIEE 11g administration tasks
• Provide oversight and guidance for the technical team in OBIEE 11g custom LDAP security integration.
• Implemented Cache Management (Cache Seeding and Cache Purging).

Environment: Linux (Server), Microsoft Windows XP (Client Tools), OBIEE 10.1.3.4.1, OBIEE 11.1.1.6, OBIEE 11.1.1.5, Informatica 8.6, Oracle 11g Database, SQL Developer

OBIEE Developer

Confidential, Framingham

Responsibilities:

• Involved in design, analysis, development, testing and deployment of reports in OBIEE 10g.
• Configured and designed and created OBIEE Repository of physical, business and presentation layers of metadata repository using OBIEE Administration Tool.
• Used the OBIEE Administration tool to develop and enhance Data Model.
• Created different types of Customized Reports (Drilldown, Aggregation, Levels) to meet business requirements.
• Developed custom reports/Ad-hoc queries using Answers.
• Developed complex and rich reports using pivots tables, charts, and view selector. Used global and local Filters for data abstraction.
• Managed security privileges for each subject area in repository and web catalogue according to user requirements.
• Involved in tuning of reports for better performance.
• Used word and BI Publisher desktop to customize and perform calculations.
• Design, develop, test and prepare detailed specification of new requirements
• Supporting Administrative technical issues related to OBIEE in Integration and Production environments.
• Testing, debugging and Performance Tuning applications prior to user acceptance testing (UAT).

Environment: Linux (Server), Microsoft Windows XP (Client Tools), OBIEE 10g, Informatica 7.2, Oracle 10g Database, Toad, SQL Developer