PROFESSIONAL SUMMARY:

• Over 13 years of IT experience as BI Developer with a proven track record in Multiple Business Intelligence (BI) Platforms, Data warehousing (DWH), Metadata Repositories, Data migration, Relational and Multidimensional Databases, Data Management and all phases of software application development.
• Extensive professional experience in Power BI, Tableau Desktop, Tableau Server and OBIEE.
• Extensive knowledge in writing complex DAX functions in Power BI and Power Pivot.
• Worked both on imported and Direct Query, Implemented the Dynamic Row Level Security and Configured the Security Groups for the APP access.
• Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.
• Experience in Repository Administration tasks like creating Repository, User groups, Users and managing users by setting up their privileges and profiles.
• Architected and designed a BI Solution using Oracle OBIEE, Teradata, and Hyperion.
• Design and development OBIEE Analytics reports, OBIEE repository, metadata as per Business requirement.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Also involved in administrative tasks such as publishing workbooks, setting permissions, managing ownership, providing access to the users and adding them to the specific group and scheduled instances for reports in Tableau Server.
• Designing, implementing and maintaining ETL process using Data parallelism layouts, Metadata management, Metadata Catalog management including creation of Metadata Catalog Creation, adding tables into catalogs, deletion of catalogs.
• Experience in designing and developing complex mappings applying varied transformation logic such as Source Qualifier, Expressions, Sorter, Router, Filter, Aggregator, Joiner, Connected and Unconnected lookups, Sequence Generator, Rank, Update Strategy, Stored Procedure, External Procedure, XML Source Qualifier, Normalizer.
• Worked on Informatica Designer (Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer), Workflow Manager, Workflow Monitor, and Repository Manager
• Strong expertise in developing Informatica Transformations, Reusable Transformations, Mappings, Mapplets, Sessions, Tasks, Workflows and Worklets.
• Participated in a team that converted and improved complex company maintenance planning systems from Oracle 10g database both running on UNIX Systems.
• Provide a monthly report to the board and members showing all income and disbursements using Oracle Business Intelligence Tool.
• Worked on improving performances by tuning of Informatica Mappings, Transformations, and Sessions. Optimized the query performances by various utility programs.

TECHNICAL SKILLS:

Microsoft Power BI: , Power BI Mobile, OBIEE (Oracle Business Intelligence), Tableau.

ETL Informatica: Power Center, Data Warehouse Application Console.

Teradata: , Oracle, SQL Server, MS Access.

T SQL: , DAX, MDX

Microsoft suite: - Excel, Outlook, Word and PowerPoint.

Ralph Kimball s Data modeling: , Star and Snowflake Schema Modeling.

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

BI Developer/ Analyst

Responsibilities:

• Designed RevPro (Revenue Recognition Reporting) Data model in Power BI. The key metrics include Revenue (MTD, QTD, and YTD), Deferred Revenue Waterfall, VSOE, Deferred Revenue Begin Balance and Ending Balance.
• Developed the complex calculated measures using Data Analysis Expression Language (DAX) in Power BI and Power Pivot.
• Auto-collect Revenue Allocation or Revenue Management data using the Oracle ODI integrator and perform the transformations to load into warehouse tables for the BI Reporting purpose on daily basis to eliminate the time-consuming and error-prone excel spreadsheets.
• Enabled the real-time revenue reporting visibility and Produce faster period-end close reporting and month-end close activities more efficient.
• Developed and integrated the custom visuals based on business requirements using Power BI Desktop.
• Experience in developing Dashboard Report, Parameterized Reports, and Linked reports, Sub reports by Region, Year, Quarter, Month and Week.
• Automated the Monthly, Quarterly Revenue Reports to the management for better decision making.
• Strong attention to detail with the ability to work efficiently under tight deadlines, review and prepare technical disclosures.
• Design and develop data modeling concepts using various data modeling tools like star schema and dimensional modeling.
• Identify production faults and critical issues followed and troubleshoot them.
• Provide remedial measures to the production issues or process failure.

Environment: Microsoft Power BI, Oracle ODI

Confidential, San Jose, CA

BI Systems Analyst

Responsibilities:

• Design Confidential (Customer Metrics Management Center) Data model. Metrics include the Headcount, Expense, Travel and Hotel. Mainly Headcount and Expense are used to measure the Confidential Market share against the Competitors. Data pulled from HRMCC to GWPROD DataMart.
• Developed around 100 reports, Most of the reports go back to last 8 quarters. Reports include Q/Q & Y/Y Company Headcount, Travel & Hotel Expense by Weekly, Monthly and Quarterly.
• Day to day activities include issue resolution, Gathering user requirements, Development and testing.
• Worked on 11g upgrade for GBOSS (Global Business Operations Shared Services), Building PMM, EIO (Efficiency in Operations) and Confidential Dashboards.
• Converted all Desktop Intelligence Reports to Web Intelligence Reports using Report Conversion Tool.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Responsible for communicating with the customers to understand their requirements and making changes according to their suggestions.
• Created a versioning scheme for the Sales Hierarchy to do what-if analysis and this gave the users an opportunity to analyze bookings through 3 versions of Sales Hierarchy.
• Implemented a unique solution enabling the users to pick weekly, monthly or quarterly reports by using a drop down on the dashboard.
• Created and implemented a unique data model for Forecast and Judgment data which doesn’t roll up additively along the hierarchy.
• Metrics involved Bookings, A/R, Orders released, HR related metrics and GTRC.
• Extensively worked on the .rpd, Webcat, BI Publisher.
• Developed scorecards for the GMI, Sales and Prod Bookings.
• Built Sales and Prod Hierarchy, Implemented the Data and Column level security.
• Worked on Index Col and Choose Functions.

Environment: OBIEE, Informatica, Teradata

Confidential, San Jose, CA

BI Systems Analyst

Responsibilities:

• Designed and Developed Business Objects Universes.
• Updated the existing Workforce Universe by adding new Tables, Classes, Objects and creating predefined conditions and prompts for the new reporting requirements.
• Created the reports using Web Intelligence, WEBI Rich Client and Live Office according to the user requirements
• Developed WEBI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL at Report level.
• Defined initial blocks and created repository variables to be used in the expressions mapped logical columns in BMM layer to physical columns in the physical layer.
• Worked extensively on the physical layer, business layer and presentation layer of the repository in the Siebel Analytics Administration Tool.
• Designed RPD based on business requirements followed design best practices for RPD design to achieve Company standards.
• Modeled physical layer/logical layer for SCDs and fact/dimension extension tables.
• Customized the presentation catalog and created a personalized view of the data for various employees.
• Implemented multiple levels of data security based on the product and Sales Hierarchy. The solution also had security based on levels in the hierarchy as well.

Environment: Business Objects, OBIEE, Informatica, Teradata

Confidential, San Jose, CA

BI Systems Analyst

Responsibilities:

• Used Business Objects Web Intelligence client as the primary reporting tool obtaining Business Data into its interactive query and analysis capabilities.
• Involved in testing (Users, Universes and Reports) and troubleshooting issues throughout the migration process.
• Worked with the customers for analyzing the business requirements & planned to create multiple universes based on the analysis & the business
• Converted all Desktop Intelligence Reports to Web Intelligence Reports using Report Conversion Tool.
• Created hierarchies in Universe design to support drill down functionality in reports.
• Responsible for communicating with the customers to understand their requirements and making changes according to their suggestions.
• Created a versioning scheme for the Sales Hierarchy to do what-if analysis and this gave the users an opportunity to analyze bookings through 3 versions of Sales Hierarchy.
• Implemented a unique solution enabling the users to pick weekly, monthly or quarterly reports by using a drop down on the dashboard.
• Created and implemented a unique data model for Forecast and Judgment data which doesn’t roll up additively along the hierarchy
• Configured the BI server and presented in a clustered environment.
• Work involved designing, developing, updating, coding, modifying computer applications or programs.

Environment: Business Objects, OBIEE, Informatica, Teradata

Confidential, Plano, TX

Business Intelligence Developer

Responsibilities:

• Interacted with System Engineering team to design - Facts & Dimensions for Repository.
• Involved in developing client/server, Data warehouse and web-based applications, Experience with Database objects designing and incorporating database security features.
• Configured Physical Layer - Import tables, Create Tables, add/change physical joins/keys, Configure Logical Layer - Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set levels to support Drill-down, Aggregation / Sum over Columns etc.. And Configure Presentation Layer - Create Folders/sub-folders, Standard Queries for different User Groups.
• Worked on Informatica ETL tool to load data from Siebel OLTP, flat files, into a Staging area and then to data warehousing tables as per the requirements. Coordinated with OLTP/Enterprise DW team for data mapping.
• Defined initial blocks and created repository variables to be used in the expressions mapped logical columns in BMM layer to physical columns in the physical layer.
• Performed systems analysis and programming tasks to maintain and control the use of computer systems software as a systems programmer.
• Analyzed information to determine, recommend and plan the installation of a new system or modification of an existing system.
• Documented the user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Handled tasks of developing and maintaining information software and systems like database structure design, implementation, and testing database structure design.
• Responsible for installation of administration application along with SQL server database server installation on UNIX and Windows NT.
• Identified Facts, Dimensions and Hierarchies of the business model.
• Prepared Detail Design Document for Repository.

Environment: OBIEE, Oracle Database, Informatica.