SUMMARY

• Over 8 Years of IT Experience in Business Intelligence Technologies and Database with expertise in ETL process and Reporting using OBIEE 10/11g,SQL Server 2008/2005, SSIS, SSRS, Power BI and Tableau.
• Experienced in all phases of Software Development Life Cycle (SDLC).
• Worked in gathering and analysis of business requirements and produced specification documents for new project requests. Developed ad - hoc queries and reports for clients and provide analytical support and recommendation as necessary.
• Extensive experience in Tableau Desktop and Tableau Server in various versions of Tableau.
• Expertise in Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Proficient with SharePoint Document Library and Publishing SSRS reports and PowerPivot Workbooks to those SharePoint Document Library.
• Expertise in creating Reports, Dashboards and Scorecards using OBIEE 10/11g, Tableau, MS Power BI, SSRS and Excel Power Pivots
• Worked with JDE 9.1 Vanilla front end interface and One View reporting.
• Expertise in installation and upgrading version from OBIEE 11.1.1.5 to 11.1.1.7.1 and also from OBIEE 10g to 11g.
• Expertise with Oracle Web logic Administration Console and Enterprise Manager.
• Experience in gathering business requirements, analysis, design, data modeling, development, client interaction and compiling end-user specifications, modification and testing.
• Experienced in OBIEE Analytics 11g, 10g, and in configuring repository/ (.rpd), create/manage Dashboards, reports/Answers.
• Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Intelligent Dashboards and OBIEE Delivers with Siebel Analytics/OBIEE stand-alone/integrated Applications.
• Expertise in Configuring Metadata and Building Physical, Business Model and Presentation Layer.
• Expert in creating SSIS packages to manage SQL Server databases and SQL Server objects between instances of SQL Server.
• Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions.
• Competency in understanding business application, business dataflow, and data relation.
• Excellent skills in understanding business needs and converting them into technical solution.

TECHNICAL SKILLS

• Microsoft BI Stack
• SSIS
• SSRS
• SSAS
• MS Power BI
• Tableau 8.0
• OBIEE 11.1.1.7 11.1.1.5 10 g
• Oracle BI Publisher /Delivers (Agents)
• SAP Business Objects
• JDE 9.1
• JDE One View Reporting
• Informatica Power Center 8.x/7.x/6.x/5.x.
• Oracle 9i
• SQL
• PL/SQL
• Toad
• MS Visio
• MS Project
• MS Office
• Microsoft SharePoint 2013.

PROFESSIONAL EXPERIENCE

Confidential, CA

BI Lead/ Sr.BI Analyst/ OBIEE Architect

Responsibilities:

• Worked with Executives, Super users and users from Business to understand business requirements and translate to appropriate technical solutions.
• Worked with various functions and end users to identify, document, and communicate standard business processes.
• Responsible and supported all the BAU (Business As Usual) activities in Americas region.
• Worked with management to identify new and creative opportunities to leverage existing applications or improve processes through effective innovation to support additional business strategy.
• Coordinated with various business operations group to prioritize and resolve issues.
• Responsible for assisting the needs of business with respect to the design and management of new, modified and enhanced technology for their day to day usage.
• Trained the business users and executives on usability of the new application and Conducted workshops for various functional areas across the business and help them on best practices for effective tool usage.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom.
• Created complex Reports, Dashboards and Scorecards using OBIEE, SSRS, Excel Power Pivots and MS Power BI.
• Worked on reconciliations of Data with different Sources like ERP (JDE 9.1), Nielsen, VIP Data and files.
• Delivered the data dumps and reports from JDE 9.1 and One View Reporting.
• As a day to day activities managed and monitored all the external data files which need to be uploaded in to data warehouse.
• Coordinated with offshore teams in understanding the new requirements and assisted in development process.
• Responsible and coordinated for UAT validations with business users and approvals.
• Worked on decommission project for some legacy systems and old BI tools like OBIEE.
• Managed and worked on remedy force incident ticketing system, created new change requests and incidents tickets and worked with development team towards resolutions.
• Develop and support the Data Warehouse using Extract, Transform and Load (ETL) methodologies. Extracted data from External sources and transform the data to fit business needs including verification and cleansing.
• Installed and configured OBIEE 11g, 10g for development, test and production environments with SQL Server.
• Configured and installed database using Repository creation utility (RCU), web logic console (console), enterprise manager (EM).
• Involved in upgrading from OBIEE 10g to 11g and applied Bundle patches on 11g.
• Installed and upgraded to latest version of OBIEE 11.1.1.7.1 from 11.1.1.5.
• Used the Administration Tool to configure the physical, logical and presentation layers of the RPD.
• Configured the RPD by creating level-based and time series measures, dimensions and their hierarchies, aggregates and variables that provided business analysts the ability to easily slice and dice data in Answers.
• Successfully created pervasive and interactive dashboards with scorecards, year over year analysis, distribution void and business trending reports using bins, guided navigation links, conditional formatting and variety of views. This allowed the sales team to spend more time selling than creating reports and managers reconciling reports.
• Performed Presentation Services Administration tasks like managing privileges, managing groups and users, and managing interactive dashboards and sessions.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Responsible for migrating the web catalog and RPD from DEV, UAT and Training, Production environments.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).

Environment: Tableau 8.0, MS Power BI, OBIEE 11.1.1.7.1 , 11.1.1.5, 10.1.3.4, Microsoft BI Stack 2014, 2012 (SSIS, SSRS, SSAS), Tableau 8.0, JDE 9.1, JDE One View Reporting, SAP Business Objects, MS Visio, MS Project, MS Office, Microsoft SharePoint 2013.

Confidential, NC

OBIEE Developer

Responsibilities:

• Created, Administered and Tested the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Involved in Coordinating with the Business Analysts/Technical Analysts and the Data Architecture Team for Requirements gathering, Data Analysis from the Oracle Database Perspective.
• Developed metadata and BI reports for Finance subject area.
• Used the security settings in OBIEE Admin tool to setup users, Groups and Access privileges.
• Verified metrics and report functionalities, ad hoc capabilities and corporate standards across all the dashboards and reports.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• By using Saw Migrate Utility migrated Siebel analytics web cat to OBIEE.
• Created aggregates & non-aggregated tables for Treasury management system & Customer Profitability.
• Configured Web Catalog Objects (Dashboards, Pages, Filters, Reports).
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Configure the BI Publisher scheduler to schedule reports and view the saved data.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Analytics.
• Involved in user trainings on the generated reports for this project.
• Participated in Post implementation reviews with the Project teams.
• Strengths include ability to work independently and to deliver defect free results on time.
• A Team Player with excellent communication, analytical, verbal and writing skills.
• Wrote SQL queries to extract and join data from different sources.

Environment: OBIEE 10.1.3.3, Informatica Power Center 8.1, Oracle 9ig/10g, PL/SQL, Toad, Windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Extensively used OBIEE Administration Tool for creating physical, business and presentation layers of repository.
• Merged two different Repositories using administration tool and Web Catalogs using Catalog Manager. Used job manager to manage and monitor iBots.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Installed and Configured OBIEE Environment in the Organization.
• Involved in the Installation and Configuration of Oracle BI Suite.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Did troubleshoot performance and solving issues related to BI team, Responsible to monitoring and fixing bugs in production box.
• Understand the Architecture and Server Configurations (Database, OBIEE Source System).
• Did supported and responsible for implementation, administration and configuration of OBIEE functionality.
• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Implemented security by creating roles & web groups, checks with External tables and LDAP
• Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions
• Performance Tuning of Dashboards/Reports and made 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, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Answers and Dashboards.

Environment: OBIEE 10.3.3, Informatica Power Center 8.1, Oracle 9i, SQL, PL/SQL, Toad, Windows 2003.

Confidential

Programmer/Analyst

Responsibilities:

• Analyzed the requirements and translate them into design documents, prototypes and other design artifacts so that they can be verified with users.
• Prepared Functional and Program Specification Documents.
• Involved in Data cleansing activities.
• Generated PL/SQL stored procedures and database triggers to load data into target structures.
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Fixed the bugs raised during User Acceptance Testing (UAT).
• Provided Technical Support and End User Training.
• Prepared user manuals for easy understanding of system.
• Prepared proper backup and recovery plans.
• Debugged the queries using TOAD.
• Assisted the Business Analysts and Project Managers in assessing impact of requirement changes.

Environment: Oracle 9i, PL/SQL, Oracle Reports, TOAD, Windows 2000 and Linux