SUMMARY

• Over 12 plus years of experience in IT involving analysis, design, development, implementation, deployment and maintenance of Business Intelligence Applications.
• Experienced Business Intelligence Developer with a demonstrated history of working in the Health Care, Automobile and Telecom Industries.
• Skilled in OBIEE, Dashboards/Visualizations, PL/SQL, SQL, Oracle BI Publisher, Data Analysis, Oracle Database, Vertica Database, Data Warehousing.
• Experience on OBIEE 12c/11g Analytics in designing Dashboards, Analytics/Oracle Administration Tool.
• Developed different types of reports in BI Publisher using RTF, EXCEL, XPT, ETEXT Templates.
• Experience on assigning Data security & UI level security to the users using OBIEE repository objects & external database.
• Worked extensively with Oracle BI (OBIEE) applications includes meta data configuration, dashboard report development, configuring Physical Layer, Business Model, Logical Table, Dimension, Column, Logical Table Source, Logical Joins, Aggregation Rules, Dimension Hierarchies, Complex Case Expressions, Facts, Dimensions, Repository Static/Dynamic Variables, Session Variable, adding multiple sources, executing direct Database requests, iBots, SSO(Single Sign On),Oracle BI Views (Compound Layout, Chart, Gauge, Title, Narrative, Table, Pivot Table, Funnel Chart) etc.
• Expertise in implementing Oracle BI Apps in all phases like implementing Out of order Box prebuilt mappings (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.), Designing ETL, metadata management using DAC, Creating Oracle provided Data Warehouse, OBIEE RPD development, OBIEE reports and Dashboards.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Executed OBIEE administrative tasks such as OBIEE Server Installation, Migration, Deployments, Security Privileges and Maintenance.
• Created numerous ODI Interfaces to implement Business Logic with ODI Components (Designer, Topology Manager, Operator, and Security Manager) & Knowledge Modules (Reverse-engineering, Journalizing, Loading, Check, Integration).
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model (Kimball and Inmon), Star and Snowflake schema design addressing slowly Changing Dimensions (SCDs)
• Expertise in design and development of OBI Metadata Repository using Oracle BI Administration Tool
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Performed Unit, Integration, Regression and UAT testing to validate reports, dashboards and mappings.
• Worked extensively in developing ETL Transformations, SSIS Packages for Dataflow with various transformations. Worked on Slowly Changing Dimensions and its implementation to keep track of historical data.
• Extensive experience in building Interactive Dashboards with drill-down, drill-across capabilities using global, local Filters, Guided Navigation, Business rules, selection steps, prompts, etc.
• Experience in enhancing OBIEE dashboard capabilities using Java Script and XML
• Experience in implementing Oracle Business Intelligence row level, Data Level and Object Level Security using LDAP.
• Expertise in implementing the LDAP, external table and database authentication in OBIEE 11g.
• Develop Visualizations/Dashboards using Tableau Desktop 2018,2019,2020,10.1.3/9.3 as per user requirements.
• Publishing Tableau Visualizations/Dashboards to Tableau Server. Management of Users and User groups in Tableau. Assigning of Permissions to access dashboards.
• Tableau Admin tasks using Tab Commands and TSM.
• Worked with Bi publisher 10g integrated with Siebel CRM 8.1.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, and Packages.

TECHNICAL SKILLS

Reporting Tools: OBIEE 11g/12c, BI Publisher 11g/12c, SSRS, Tableau 2020,2019,2018,10.1.3/9.3, Seibel Analytics

ETL/ELT: Informatica 9.0.1 Hot Fix2, Oracle Data Integrator 10g, DAC 10.1.3.4.1 , OWB 11gR2, SSIS

DataModelling: Dimensional Data, Star Schema, Snowflake, Tables, Physical and Logical

Versioning Tool: Rational Clear Case

DB Analysis Tools: SQL Developer, Toad, SQL Workbench, Azure Data Studio, SSMS

Languages: SQL, PL/SQL, TSQL, HTML, XML, PHP, ASP.NET, XML, UNIX Shell Scripting

Databases: Oracle 12c/11g/10g, SQL SERVER 2005,2014,2016,2017, MS Access, Vertica 7.2.3,8

Operating Systems: Windows Server 2003/2008/2016 ,Windows XP,8,7,10, LINUX, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Albany, NY

Sr. Data Visualization/ETL Consultant

Responsibilities:

• Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents as per the business rules.
• Created Dashboards with the Reporting Standards and Requirements as per the Business requirement rules and documents.
• Created Dashboard subscriptions and customized views for specific user requirements.
• Configured Action links to and Go URL's to drilldown to same and different dashboards.
• Developed reports and Dashboards using Tableau 2018,2019,2020,SSRS.
• Involved in training users on developing, customization and scheduling reports in Tableau.
• Expert in Migrating reports, Dashboard and security between environments.
• Customized various SSRS Reports using report builder.
• Created SSIS packages as a part of ETL.
• Worked on various data transformations to load data from source to target.
• Worked on addressing performance issues during dataloads.
• Worked on Design and development of SSIS packages with various types of files and data as source and Deployment to SSIS server.
• Worked on the performance tuning of reports through SQL in backend.
• Worked on PL/SQL packages and procedures as part of reporting and data migration tasks.
• Worked on Tsql, TSQL stored Procedures, for various tasks of Data migration and reporting needs.
• Responsible for Unit and System Testing and performed Data Validation for all the reports.
• Restricting user access to reports based on the user group.
• Creating Dashboards using Tableau.

Environment: Tableau 2018,2019,2020,Tableau Desktop 2018,2019,2020, Oracle 12c, SSIS,SSRS, Oracle SQL Developer, ITSM Service Now, Microsoft SQL Server 2017,2016,2014, Microsoft Visual Studio 2017,2019, SSMS 16,18.5.1, SSDT 15,16, SSIS 16, SSRS 16.

Confidential, Albany, NY

Sr. OBIEE/ODI Consultant

Responsibilities:

• Worked on the Technical and Functional Design Business Requirements gathering, and documented the Technical Design Documents, Functional Design Documents and Data Lineage Documents as per the business rules.
• Created Dashboards with the Reporting Standards and Requirements as per the Business requirement rules and documents.
• Extensively worked on Federated queries in OBIEE 11g.
• Integrated Google Maps with Dashboards.
• Modeled Global temporary tables in RPD.
• Implemented the Union Reports to handle the string values in the OBIEE Dashboard
• Expertise in designing and building the OBI Subject Areas, Dashboards, OBIEE Reports and BI Publisher Reports, Oracle Warehouse Builder, SQL Developer.
• Designed the Physical layer, BMM layer, Presentation Layer in RPD, created the session variable and Dynamic variable in RPD.
• Configured Action links to and Go URL's to drilldown to same and different dashboards.
• Created Presentation variables on front end to meet certain business requirement such as case insensitive filters on dashboard prompts.
• Developed reports and Dashboards using OBIEE 11g (11.1.1.6) and 12c (12.2.1.1), BI Publisher, Tableau and Power BI.
• Developed complex reports using java scripts.
• Involved in training users on developing, customization and scheduling reports in OBIEE/ BI Publisher 11g.
• Worked on Upgrade from 11g to 12c.
• Used OOTB RPD and created new measures, calculated items and calculated groups.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Worked extensively on performance tuning including creating aggregate tables, caching and event polling tables.
• Expert in Migrating reports, Dashboard and security between environments.
• Customized various BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
• Created ODI interfaces, packages, procedures.
• Reverse engineer data stores from various source systems like Oracle, flat files and excel files.
• Worked on ODI options to customize Knowledge Modules.
• Worked on the LKM SQLLDR KM to load huge amounts of data from flat file to Oracle table.
• Extensively used ODI variables in various scenarios to developer ODI packages, scenarios as per requirements.
• Worked on ODI security manager to set up ODI users and privileges.
• Extensively used ODI designer and ODI Studio to create and manipulate source data stores, target data stores, packages, mappings, procedures, variables.
• Implemented Consistent set change data capture (CDC) for real time processing.
• Developed file processing utility for ODI, which can be easily adapted across the projects.
• Extensively worked with different ODI Knowledge modules (LKM, CKM and IKM) and customized the Knowledge modules multiple times especially IKM to implement SCD.
• Deployed various components of ODI, setup the topology navigator (physical and logical architecture, agents and context), security navigator (profiles and user permissions).
• Successfully invoked web services and restful services in ODI.
• Developed file processing utility for ODI, which can be easily adapted across the projects.
• Developed UNIX Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked on BI Publisher reporting and build complex Data Models, Templates as per the business requirement that had to return huge data volumes.
• Involved in unit testing and integration testing of OBIEE reports and dashboards
• Worked Closely with ODI/ELT and DBA Team to get the Data to DWH
• Expertise in developing EL-T (Extraction, Loading and Transformation) procedures and Data Conversion Scripts using Pre-Stage, Stage, Pre-Target and Target tables.
• Added New Fields in the Source Tables, Views, Packages, and Procedures and in the Target Tables modified the fields according to business requirements.
• Worked on the performance tuning of reports through SQL in backend.
• Worked on PL/SQL packages and procedures.
• Responsible for Unit and System Testing and performed Data Validation for all the reports.
• Restricting user access to reports based on the user group.
• Creating Dashboards using OBIEE and Tableau.
• Worked on visualization charts in Power BI to track hours consumed.
• Worked Extensively on developing RTF, ETEXT, Excel and XSL templates.

Environment: OBIEE/BI Publisher 11g/12c, Oracle 11g, BI Publisher 12.2.1.1, ODI 12.2.1.0/11.1.1.9. x, Oracle 12c, Oracle SQL Developer, Rational Clear Case, Remedy Salesforce, Tableau 10.1.3/9.3, OWB 11.2.0.4, OBIEE 12c, 12.2.1.1/11.1.1.6.0 , Microsoft Power BI

Confidential, Indianapolis, IN

BI Reporting Lead

Responsibilities:

• Worked Extensively on developing XPT, RTF layouts.
• Integrating BI Publisher with WAM to access reports.
• Developed reports in Bi publisher 11g (11.1.1.7).
• Involved in development of new reports.
• Worked Extensively on Charts in RTF and XPT layouts.
• Involved in training users on developing, customization and scheduling reports in BI Publisher 11g.
• Worked on Year to Date reports in RTF layouts.
• Worked on PL/SQL packages and procedures for complex reports.
• Involved in Migrating reports from one environment to other environments.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Used the OBIEE Administration tool to develop and enhance meta-data
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository
• Configured and Created repository using OBIEE Admin tool
• Worked extensively with Physical Layer, Business Layer and Presentation Layer
• Created numerous executive level reports. ‘Dashboards’ were generated to provide insight into the sales/marketing/financial data
• Worked on BI Publisher importing data from the data source and delivered Reports, common dashboards, metadata, security, calculation, caching, and intelligent request generation services.
• Created different kinds of Parameters and list of values according to the user requirement.
• Changed the query in the View level and Data model level according to the user requirements.
• Worked on Expression Builders and Calculation Wizards to generate certain expressions and formulae, created new logical columns based on the requirement
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector and Table).
• Developed different brand level Reports, Filters, and Prompts using Oracle Business Intelligence Answers.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users which include business users from various parts of the world.
• Successfully implemented the code in DEV and deployed in SIT and UAT, Debugged and tested in final Test and deployed in Production.
• Designed and Developed the RPD and reports by using the column selector, pivot table view selector.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Configured security in Administration console for Authentication and created Application roles.
• Setup the visibility of dashboard reports to employees with respect to their responsibilities. Administered permissions and privileges for dashboard visibility and modifications to users based on their groups or responsibilities.
• Designed and Configured Intelligent Dashboards in Analytics for different groups of users.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables
• Created different types of Customized Reports (Drilldown, Aggregation) to meet client requirements
• Built Business model and established relationships & Foreign Keys (Physical & Logical) between tables
• Implemented the Time Series Wizard (YTD, QTD, and MTD) for comparing measures in different time Periods.
• Responsible for Unit and System Testing and performed Data Validation for all the reports.
• Restricting user access to reports based on the user group.

Environment: OBIEE/BI Publisher 11g, 11.1.1.7, Oracle 11g, Oracle SQL Developer, Oracle WAM.