SUMMARY

• 12+ years of IT experience this includes Analysis, Design, Development, Implementation/Deployment and Maintenance of Data Warehouses and BI applications.
• Experience in gathering and assessing Business Requirements. Developing strategies and Implementing BI solutions as per teh requirement.
• Hands on Expertise in design and development of teh three layers (Physical/Business Model and Mapping/Presentation) of OBI Metadata Repository using Oracle BI Administration Tool.
• Experience in Dimensional Data Modeling Star Schema, Snow - Flake Schema using Fact and Dimensional Tables.
• Proficient in using teh Time series functions, Level base measurements and Dimension Hierarchy to support historical time comparison analysis.
• Experience in creating Session, Repository and Request Variables using Initialization Blocks.
• Experience in creating Interactive Dashboards wif drill-down capabilities using global and local Filters.
• Experience in creating Agents and scheduling report/dashboards to Users or shared locations.
• Excellent Working Experience wif Multiuser Development Environment (MUDE).
• Implemented Object level and Data level Security in rpd and web catalog.
• Experience wif Set up LDAP (Single Sign On) Using External Table Authentication.
• Experience in Cache Management and Cache seeding to improve teh reports/dashboard performance.
• Implemented Usage Tracking by configuring EM and RPD. Created Usage tracking dashboards.
• Hands on Experience wif Performance tuning of teh Dashboard Reports SQL Queries. in debugging and optimizing teh OBIEE, Tableau Analytics Dashboards/Reports.
• Experience in working wif multiple data sources (Oracle, teradata, SQL Server, Excel etc.) in repository and Integrating/creating subject are using Cross Database join.
• Developed Complex database objects likeStored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in implementing complex business rules by creating re-usable transformations, robust mappings/mapplets, Sessions and Workflows and Worklets.
• Well organized wif interpersonal and developmental skills, strong work ethics and willingness to work hard to achieve employer goals and targets.

TECHNICAL SKILLS

BI Tools: Tableau Visualization 10.4, 10.2, 9.0, OBIEE 12c, 11.1.1.x, 10.1.3.x

Database: Oracle 12c, 11g /10g/9i/8i/7.x, SQL Server 2005/2000, Teradata 16.2, 14.0

DB2 9.x: ETL Tools

IBM Data Stage 11.7: Informatica 8.x/7.x/6.x Power Mart 6.2/5.1

Programming Languages: SQL, PL/SQL, C, C++, XML, HTML, CSS

Oracle Tools/Utilities: SQL*Loader, SQL Developer, Toad, SQL Navigator, SQL Assistance

Operating Systems: Red hat Linux 6.5, Unix and Windows 7/ XP/2008/2003

Scheduling Tools: Autosys, DAC 7.8 (Data warehouse Administration Console)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

OBIEE Consultant

Responsibilities:

• Identify data gaps by analyzing teh Enterprise Data, Develop, Deploy and provide support for Business intelligence solutions using Tableau and Oracle Business intelligence applications.
• Designs and develops Metadata repository dat consists of physical, business model layers wif aggregates & dimensions, presentation layers wif catalogs & folders and external table security wif session variables using Oracle BI Administration tool.
• Install Latest security and BI Publisher patches for OBIEE 12.1.3.4.
• Validates OBIEE environment, WebLogic console, enterprise manager, presentation server, BI Server and scheduler server.
• Develops and debugs dashboards and reports wif different analytics views (pivot table, chart, tabular and view selector), guided navigation, and dynamic interactive dashboards wif drill-down capabilities using global and local filters.
• Migrated more TEMPthan 150 interactive dashboards from OBI to Tableau 10.2.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts for better data analysis.
• Providing 24X7 Operational support for reporting tools like Tableau, OBI and BI Publisher reports and dashboards.
• Extensive use of tableau reports wif excel data files refresh using python scripting through windows event scheduler.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium laptop, pc, iPad.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Understanding existing business model and customer's new requirements.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Designed high-level view of teh current state BCBS files, leads, and website activity using Tableau.
• Worked extensively wif Advance Analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's
• Created workbooks and Dashboards using calculated metrics for different visualization requirements.

Environment: OBI12c, BI Publisher, Oracle 12c, Tableau Visualization v10.4, Teradata 16.1, Windows 2003, Unix, TOAD, Service Now, Unified Desktop (UD), Jazz 5.02, Postman

Confidential, New Jersey

OBIEE Admin

Responsibilities:

• Colleting system requirements and Expectations from teh Business team.
• Provided requirements for system application and nfs mount requirements.
• Installed and configured OBIEE application in Linux environment Also upgraded rpd, web catalog and security model from OBIEE 11.1.1.7 to OBIEE 12.2.1.3.
• Prepared and build Horizontal Clustering, enabled AD authentication and External Tables Authorization.
• Creates organization employee region hierarchy and applied data level security.
• Adds teh out-of-teh box futures to dashboards using custom properties such as CSS style sheets and userscript.js scripts.
• Enabled Usage tracking and Impersonation Also created Multiple data sources in weblogic.
• Worked wif weblog and Enterprise Manager for improving and enabling performance and advance Struck thread size.
• Created shall scripts for monitoring and sending alert on application availability.
• Created tar files and worked wif memory/Size increasing.
• Supporting Existing application 24/7 and fixing teh production issue.

Environment: OBI12c, 11.1.1.x, Secure FX, Secure CRT, Oracle 11g, Windows 2003, Linu, SQL Server, Jazz 5.02

Confidential, New York

Sr. OBI/Tableau Developer

Responsibilities:

• Interacts wif business representatives to gather teh reports / dashboards requirements and define business and functional specifications.
• Designs and develops Metadata repository dat consists of physical, business model layers wif aggregates & dimensions, presentation layers wif catalogs & folders and external table security wif session variables using Oracle BI Administration tool.
• Creates connection pools, physical tables, defined joins and implements authorizations in teh physical layer of teh repository.
• Develops and deploys teh RPD and catalog for multiple domains BDR (Banks Off, Open Mains, MTA Critical Facilities), Utility Service Provide Data (OLTP).
• Creates organization employee region hierarchy and applied data level security.
• Develops and debugs dashboards and reports wif different analytics views (pivot table, chart, tabular and view selector), guided navigation, and dynamic interactive dashboards wif drill-down capabilities using global and local filters.
• Adds teh out-of-teh box futures to dashboards using custom properties such as CSS style sheets and userscript.js scripts.
• Designs, creates, and tests reports in teh dashboard and creates ad hoc subject areas according to business need.
• Develops dynamic column names using server variables.
• Creates BI Publisher reports from Oracle BI and other data sources.
• Creates test cases and loads them into quality center for testing teams.
• Defining teh KPIs(Number of calls answered in last 30mins, number of Outages resolved in last 3days etc.,) and build logic using OBI Admin tool.
• Creates test cases and loads them into quality center for testing teams.
• Migrated/Build teh WMS logica reports to OBIEE environment which involves rpd design, reports and interactive dashboards.
• Created procedures to store teh data into aggregated tables.
• Supporting teh existing WMS client services reports and data warehousing.

Environment: Tableau Visualization 10.2, OBI12c, 11.1.1.x, OBIEE Publisher, Oracle 10g/11g, Teradata, Windows 2003, Unix, SQL Developer, Jazz 5.02

Confidential, Charlotte, NC

Sr. OBIEE Developer

Responsibilities:

• Interacts wif business representatives to gather teh reports / dashboards requirements and define business and functional specifications.
• Identified gaps by analyzing teh DataMart Instance and provided alternative solutions as well recommended changes to database.
• Designs and develops Metadata repository dat consists of physical, business model layers wif aggregates & dimensions, presentation layers wif catalogs & folders and external table security wif session variables using Oracle BI Administration tool.
• Creates connection pools, physical tables, defined joins and implements authorizations in teh physical layer of teh repository.
• Installs and configures OBIEE 12c/11.1.1.7.x on new Windows servers.
• Upgrades teh environment from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.6.9 to OBIEE 11.1.1.7.x. And OBI 12c.
• Applies patches to upgrade OBIEE 11.1.1.7.0 to OBIEE 11.1.1.7.1 and validate teh environment.
• Validates OBIEE environment, WebLogic console, enterprise manager, presentation server, BI Server and scheduler server.
• Develops and deploys teh RPD and catalog for multiple domains BDR (Banking data Repository), Life Insurance, Financial and customer relationship data.
• Develops and debugs dashboards and reports wif different analytics views (pivot table, chart, tabular and view selector), guided navigation, and dynamic interactive dashboards wif drill-down capabilities using global and local filters.
• Adds teh out-of-teh box futures to dashboards using custom properties such as CSS style sheets and userscript.js scripts.
• Worked on different types of hierarchy (Ragged, Level base and Skip-Level hierarchy).
• Designs, creates, and tests reports in teh dashboard and creates ad hoc subject areas according to business need.
• Involved in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
• Defined best practices for Tableau report development andTEMPeffectively used data blending feature in tableau.
• Extensively used data blending, embed functionalities in Tableau
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server as well as to check daily tasks on teh server.
• Administrates BI Server and implements security by creating roles, web groups, checks wif external tables and LDAP.
• Sets up iBots to run reports at scheduled time for cache seeding to improve query performance using caching.
• Creates single/multi rows write back reports and provides access to users for updating teh data in database from dashboard.
• Creates Autosys and MQFT scripts for pre and post process for iBot / agents.
• Integrates OBIEE dashboard pages on external web servers such as Unified Desktop.
• Creates change requests for code migration and coordinates wif users for UAT testing.
• Creates Tableau Heat Map repots, geographical and various views for higher management to for quick analysis purpose.
• Supports Enterprise data reconciliation, data quality, HR Organization chart and banking data repository dashboards.
• Creates stories and assigns tasks for every technical aspect in RTC and ensures complete tasks wifin allocated sprint/deadlines.
• Conducts performance tuning of dashboards/reports and makes recommendations for changes to database by implementing teh materialized views, partitions, re-building of indexes and overwriting SQL execution path by making use of hints.

Environment: OBI12c, 11.1.1.x, BI Publisher, Tableau Visualization 9.0, 10.2, Oracle 10g/11g, Teradata, Windows 2003, Unix, TOAD, Service Now, Unified Desktop (UD), Jazz 5.02

Confidential, Columbus, IN

Sr. OBIEE Developer

Responsibilities:

• Understood client requirements, source data, business objectives and key performance indicators.
• Worked wif Account Receivables (AR) to make sense of business performance by adding context to real-time business measure.
• Installed, configured and administered OBIEE 10.1.3.4 Metadata for Physical, Business Model and Presentation services.
• Identified teh Gaps by analyzing teh DataMart Instance and provided alternative solutions as well recommended changes to database.
• Worked closely wif Data Modeler in designing teh Logical Data Model/Physical Data Model (star schema).
• Developed Financial Module Repository (RPD) by importing database metadata into physical layer.
• Applied business rules in business modeling and mapping layer, and created customized user view in teh presentation layer.
• Created business model to support ad hoc reports for user access based on requirements.
• Created reports wif appropriate views such as charts, pivot, scatter and legend.
• Applied filters, prompts, dashboard prompts, calculations, and conditional high lightning for reports.
• Developed dashboards wif drill-down capabilities and applied local and global filters.
• Saved requests onto dashboards and made them available to intended users.
• Created catalog groups, set permissions for items in teh presentation catalog, set privileges and rights to users and groups, and managed BI Publisher users, permissions, jobs, files and folders.
• Applied optimization techniques for better report performance.
• Implemented OBIEE Security (Object Level and Data Level Security in teh OBIEE Repository and Answers) using repository variables, session variables, initialization blocks and single sign-on.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Designed, developed, and customized existing reports/dashboards in Financial Analytics module such as Account Receivables (AR) and Cash Flow.
• Performed migration of teh RPD and web-cat from Dev to QA and QA to DR environments.
• Performed unit testing of reports and involved in writing test vases to test teh generated reports.
• Trained power users to use BI Analytics TEMPeffectively.
• Provided client wif technical and user documentation.

Environment: Oracle Business Intelligence (OBIEE) 10.1.3.4, & OBIEE11g BI Publisher Enterprise, MS Office Plug-Ins, Oracle 11g.

Confidential, San Jose, CA

OBIEE Developer

Responsibilities:

• Understood client requirements, source data, business objectives and key performance indicators.
• Worked wif supply chain management to make sense of business performance by adding context to real-time business measure.
• Worked in Agile Methodology Environment, scheduling meetings every day and updating teh status of teh project to teh manager.
• Interacted wif business management representatives for gathering metadata/ dashboards requirements and to define business and functional specifications.
• Designed technical design documents by understanding functional design documents for sales performance.
• Installed BI Publisher, Publisher Desktop, integrated wif OBIEE to develop template. Utilized MS Office add-ons in reports, dashboards and answers.
• Worked wif application solution security to define users and groups, set permissions, group inheritance, authentication methods, query limits, timing restrictions, filters and LDAP.
• Provided dimensional data modeling and technical documentation and presentations.
• Identified gaps by analyzing teh DataMart Instance and provided alternative solutions as well recommended changes to database.
• Analyzed data components and document and data strategy to identify key metrics for reporting.
• Configured Analytics Metadata (RPD) and implemented security to authenticate and authorize Oracle users.
• Integrated OBIEE wif ERP.
• Utilized ERP for data importing, making repository, assigning functional and aggregation roles, and creating reports.
• Built physical layer, logical layer, business model, mapping layer, and presentation layer of a repository by using star schemas.
• Worked wif historical depth and subject-area breadth which set teh data warehouse apart from other information (files, application databases, report caches, content stores and data marts).
• Identified facts, dimensions, and grain of dimensional mode and referential joins.
• Used SQL*Loader to import data from large flat files and Excel sheets to Oracle tables.
• Created facts & dimensions and defined logical relation between them in BMM layer.
• Created dimensional hierarchies for teh drill down functionality and implemented Business Logics for Facts.
• Created reports using different analytics and materialized views (pivot table, chart, column selector and table).
• Designed executive dashboards to provide business critical analytical view of written sales power users.

Environment: OBIEE 10.1.3.4.1, BI Apps 7.9.6, ERP 11.5.10, Oracle 11g, UNIX, SQL DEV, SQL*Loader

Confidential, Cheshire, CT

OBIEE Developer

Responsibilities:

• Understood client requirements, source data, business objectives and key performance indicators.
• Worked wif Financial, HR Analytics to make sense of business performance by adding context to real-time business measure.
• Interacted wif business management representatives for gathering Metadata/ Dashboards requirements and to define business and functional specifications.
• Designed technical design documents by understanding functional design documents for sales performance.
• Installed, configured and administered OBIEE 10.1.3.4 metadata for physical, business model and presentation services.
• Worked wif repository migration (.rpd), and cache management on UNIX environment.
• Provided dimensional data modeling and technical documentation and presentations.
• Identified gaps by analyzing teh data mart instance and provided alternative solutions as well recommended changes to database.
• Worked wif Essbase products, organized and presented data along familiar business dimensions, thus enabling users to view and explore data intuitively and to turn teh data into actionable information.
• Analyzed data components and document data strategy to identify key metrics for reporting.
• Configured analytics metadata (RPD) and implemented security to authenticate and authorize Oracle users.
• Utilized WebSphere and integrated wif SOA environments dat enables dynamic, interconnected business processes, and delivers highly TEMPeffective application infrastructures for all business situations.
• Configured iBots to deliver analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
• Configured existing dashboards, metadata objects and report level security to set up position based functional dashboard access.
• Worked wif historical depth and subject-area breadth which set teh data warehouse apart from other information (files, application databases, report caches, content stores and data marts).
• Identified facts, dimensions, and grain of dimensional mode, and referential joins.
• Used SQL*Loader to import data from large flat files and Excel sheets to Oracle tables.
• Created facts & dimensions and defined logical relation between them in BMM layer.
• Tested and implemented stored procedures, triggers, functions, and packages at database level.
• Designed executive dashboards to provide business critical analytical view of teh written sales for a set of power users.
• Designed and implemented Informatica Power Center 8.1.1 for ETL to load target Oracle 10g database.

Environment: OBIEE 10.1.3.4, Oracle 11g R1, UNIX, SQL DEV, SQL*Loader