SUMMARY

• Having 13+ years of experience in development and implementation of Data warehousing and Business Intelligence Applications
• Worked on development in offshore - onsite and onsite - offshore model. Lead the team from both onsite and offshore. Provide guidelines and solution to the team members
• Worked on tool assessment, effort estimates, project plan, data model, design. Have worked on both agile and SDLC methodology
• Highly competent in Analysis, Design & Development phases
• Competitive knowledge in new BI cloud technologies
• Identifying the scope of activities, delegation of work to the team and providing appropriate directions to the team during the implementation
• Sending weekly and monthly status reports to Client and internal senior management on the project progression
• Highly competent in Warehouse design, OBIEE RPD, BI Publisher, Delivers, Answers and Dashboards in various versions on OBIEE RPD (10g, 11g and 12c). Have created reports using visual analyzer
• Convert Hyperion IR Reports to OBIEE 12c, both using OBIEE and Bi Publisher
• Extensive knowledge and hands-on experience in RPD design, development that includes Physical, BMM, Presentation layer, joins, hierarchy, variables etc.,
• Have implemented highly complex requirements in OBIEE
• Build RPD using Essbase as source
• Installation, upgrade of various versions of OBIEE tool (till 11.1.1.9.x) and latest patches in all environments (Dev to Prod) and Informatica (v 8.6x to 9.1)
• Configured LDAP, Single - sign-on (SSO) in OBIEE with Kerberos AD Authentication, and SSL
• Worked on customization on OBIA modules like Sales, Service, SCM and Procurement & Spend Modules
• Have worked on report development using BICS (BI Cloud services) and DVCS (Data Visualization Cloud services)
• Expertise in ETL using Informatica, ODI to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Implemented and worked on security models (LDAP configuration in web logic, object level security, data level security)
• Worked with multiple source systems the source system like Siebel CRM, JDE and Oracle database
• Worked on writing stored procedures, Triggers and queries in both Pl/SQL (Oracle) and T-SQL (Sql Server)
• Worked on design new relational data model, understand and modifying the existing data models
• Establishing the star and Snow-flake schemas to support the report requirements
• Identifying and creating the aggregate tables to improve the performance and avoid complexity in report development
• Experience in translating user requirements into functional, technical and system specifications, managing clients relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution (Vanilla Mappings and Custom Mappings). knowledge and understanding of other reporting tools - Spotfire, tableau, OTBI Reports, and Business objects
• Trained in development using Incorta tool (no ETL tool), from data extraction into incorta to building report, importing tables, data, modelling and creating incorta schema, internal, external session variables, building reports and dashboards
• Building reports using no star schema concepts in Incorta.

TECHNICAL SKILLS

• Incorta, OBIEE 12c, 11.1.1.x, OBIA 7.9.6.3
• ODI Studio 12.2.1, Informatica Power Center 8.6.1/9.1
• DAC 10.1.3.4.1
• Siebel, JDE, Oracle DB, Essbase
• Windows 95/98/2000/XP, UNIX
• Power Explorer, Sql server Data Modeler

PROFESSIONAL EXPERIENCE

Confidential, Chicago

BI Architect

Tools: Oracle 12c, Essbase, Visual Analyzer, Incorta

Responsibilities:

• Managing team of 9 members, Managing/delegating support incidents, meeting SLAs, handling escalations, create escalations for priority issues, enhancements and support
• Collating data and reporting the weekly and monthly status reports to Confidential management and customer
• Aligning the incidents appropriately for grouping to enhancements where ever applicable
• Planning and scheduling monthly releases
• Interacting and working closely with Administrators, end users, managers
• Planning for Knowledge transition, reverse transition, shadow support, Primary support whenever new implemented project that is implemented and transitioned to support team and document appropriately
• Experience in POC where there is new idea/solution/approach is needed for any new requirement
• Creating RCA (Root Cause Analysis) document for any critical or frequently occurring issues
• Defect fixing in reports and RPD, merging and migrating the code to higher environments
• Gather business requirements and create time/deadline schedules for the sprint and coordinate with Business Analysts and data warehousing team members.
• POC and customer Demo on Incorta no ETL reporting tool, and having no star schemas
• Converting Hyperion IR reports to OBIEE 12C reports by creating RPD models and reports
• Assessment to convert the Business owned reports to Hyperion IR Reports
• Attended meetings with Business users, enterprise architects, DBAs and data warehouse team to understand, design, configure and implement overall solutions for various source systems and Essbase as OBIEE source
• Conduct brain storming sessions with Business users to understand the requirement
• Develop POC to showcase business team the capabilities of OBIEE Dashboards, Analysis that can satisfy the business needs.
• Design and development of RPD using Essbase as source. Developed RPD from scratch, designed Physical, BMM, and Presentation layer.
• Prepare the Test cases, review and execute unit testing
• Framed guide-lines and design templates for design and Migration documentation
• Design and restructured the existing OBIEE Repository to allow enhancements that support
• Developed Mappings, packages, Load plans and scenarios. Loaded data using csv files and database source.

Confidential, Houston, Texas Jan‘15- Sep’17

OBIEE Architect

Tools: Oracle 11g, BI Publisher 11g

Source System: SAP, MDM, DRP, EU, OpenWells, Adobe, AFE (Oil and gas sources)

Responsibilities:

• Implemented patch merging methodology for the client (New to the client)
• Developed many POC to explore the functionality of the OBIEE tools to the Key Stake holders
• Executed multiple point upgrade OBIEE 11g, and regression testing
• Framed guide-lines and design templates for design and Migration documentation
• Design and restructured the existing OBIEE Repository to allow enhancements that support quicker turnaround for implement the requirements
• Enabled the RPD model to support drill down and drill through functionality
• Created reports having drill down and drill through functionality
• Created BI Publisher reports sourcing from database, Answers and deployed them in Dashboard
• Worked on security models (AD configuration in web logic, object level security, data level security)
• Configured SSO, write back functionality where users can update database tables from the dashboards
• Have done performance improvement activity
• Development of OBIEE Analysis, Dashboards and Agents using multiple sources
• Repository development in MUD environment
• Handing UAT with Key business users for clarification and fixing priority defects with quicker turn around
• Managing the incidents using Service now application

Confidential, Houston, Texas

Onsite BI Lead

Tools: Oracle 11g, Informatica 9.1, BI Apps 7.9.6.1, DAC, Toad

Source System: JDE

OBIA Module: Supply Chain and Order Management Analytics, Procurement and Spend Analytics

Responsibilities:

• Gather, Analyze the requirements from business users and convert them to standard business documents
• Break down requirements to Technical blocks and projects
• Design the existing OBIEE Repository to include the new star schemas
• Development of OBIEE Analysis, Dashboards and Agents using multiple sources
• Repository development in MUD environment
• Manage the offshore team of 4 BI and ETL developers
• Developed Mappings using corresponding Source, Targets and Transformations like Source Qualifier, Sequence Generator, Filter, Router, Joiner, Lookup, Expression, Update Strategy, and Aggregator.
• Design and customization of existing custom repository
• Security configuration and changes
• Customization of Prebuilt ETL Mappings, Development of custom Mappings
• Written stored procedures, Triggers, Views, materialized Views and queries
• Additional DAC changes for the new custom changes
• Customization of Reports and Dashboards & Development of custom reports.
• Testing, Documentation and support
• Co-ordination with the client team like Admins, other Client BI and ETL developers

Confidential

Offshore BI Lead

Tools: Oracle 11g, Informatica 9.1, BI Apps 7.9.6.3, DAC

OBIA Modules: Sales Analytics, Service Analytics

Responsibilities:

• Providing solutions, suggestions and guiding the team on the development
• Involving in Project management activities like task allocation, follow ups, offshore project status, managing the onshore calls, high lighting project issues and risks in the forum etc.,
• Development of all layers of Oracle BI Administrator Tool, Physical, Business Model, and Presentation layer.
• Built the Star and snow Schemas based on the functionality
• Creating physical joins in physical layer and Complex joins in BMM layer.
• Creating dimensional hierarchies and level based measures as per business requirements.
• Customization of Oracle BI Answers, Reports and Dashboards.
• Configuring Security and creating User’s Groups and setting Privileges.
• Defining Dimension Hierarchies for the Logical Dimension Table.
• Creating Presentation Catalogs with measures from Multiple Fact Tables.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Creation and modification of mappings and workflows in Informatica
• Creation of task, Subject area, Execution plan etc,, in DAC and managing the Full load and incremental loads

Confidential

Offshore BI Lead

Tools: Oracle 11g, Informatica 9.1, BI Apps 7.9.6.1, DAC

Responsibilities:

• Installed and configuration of OBIEE with Informatica and Responsible for setting up the environment including installation of OBIEE, BI Apps and Informatica in all the environments.
• Have done a technical Upgrade of OBIEE 10g to 11g, Informatica 8.6 to 9.1
• Development of all layers of Oracle BI Administrator Tool, Physical, Business Model, and Presentation layer.
• Migrated Repository and Catalog between environments like Dev, Test, QA, maintenance and Performance.
• Built the Star and snow-flake Schemas based on the functionality
• Creating physical joins in physical layer and Complex joins in BMM layer.
• Developed Interactive Dashboards using Reports with different Views, implementing pagination (Drill-Down, guided navigation, Pivot Table, Chart, Column Selector, dashboard and page prompts), master data linking using Oracle Presentation Services.
• Assigned Data Level & object level security to users.
• Written stored procedures, Triggers, Views, materialized Views and queries
• Creation and scheduling of Agents/iBots.
• Creation and customization of Informatica mapping, workflow and configuration of DAC.
• Implemented the Change Data Capture mechanism in DAC to capture the incremental changes.
• Scheduling and running of execution plan required.
• Team Management, mentoring the off-shore team and interactions with On-site Lead / Client
• Customized Star Schema in BI Repository to improve performance.