Home

Lakshman - OBIEE / OTBI / Power BI

[email protected]

Location: Remote, Remote, USA

Relocation: Yes

Visa:

Lakshman PROFESSIONAL SUMMARY: BI Consultant with 11 years of overall experience in the areas of Business Intelligence and Data warehousing tools like OAC, OTBI, BI Publisher, OBIEE, OAS, ODI 12c, Microsoft Power BI. CERTIFICATIONS: Oracle Business Intelligence Foundation Suite 11g Essentials TECHNICAL SKILLS: BI Tools OAS, OAC, OBIEE, Microsoft Power BI, BI Publisher ELT Tools ODI 12c ETL Tools Informatica 8.6 Databases Oracle 19c, 18c, 12c, 11g, 10g Ticketing Tools Jira, ServiceNow, HP Quality Center Operating systems Windows and Linux Roles and Responsibilities: OTBI Experience implementing or supporting Cloud applications in Finance and SCM. Ability to create reports using Financial Reporting Studio (FRS), SmartView, and Oracle BI/Transactional Business Intelligence (OTBI). Experienced of Fusion's schema, subject areas, and expertise with reporting tools such as Data Extracts, BI Publisher and OTBI Reports using different methodologies. Experienced Cloud-native tools like File-Based Data Import (FBDI), ADF Desktop Integration (ADFdi), and scheduling Oracle Cloud ESS Jobs. Expertise in OTBI using subject area, getting data by writing SQL queries, using RTF templates, jobs and job sets etc. Configuring Cloud applications with setups, rules, workflows including flex fields and personalization. Maintainedapplication security including assigning user access controls based on roles and responsibilities. Developed and supported SQL queries and related reports. BI Publisher Expertise in Managing the BI Publisher administration task with all the installation, configuration, and migration activities. Translating Business requirement to functional design document and preparing technical design which talks about technical details on ETL side including Data model changes followed by reports design. Expertise in developing new reports, testing, and customizing existing reports using SQL procedures, Reports in XML/BI Publisher by interacting with the business analysts and end users. Extensive experience in building template format using RTF, Excel and XSLT. Hands on dealing with complex RTF templates with multiple formats and complex coding. Good hands-on creating Bursting reports across enterprise level business users. Experience in performance tuning at the Database level by creating Aggregate tables and Tuning Reports. BICC Experienced in working with BICC jobs to extract data from Oracle Fusion. Configure an external storage location that works for data needs. Extracting complete or partial data by selecting offerings or specific objects. Extracts on-demand or schedule them to run at specified intervals during the day, in a week, or throughout the month. Run incremental extracts if you need only the data that changed since your last extract. Scheduled multiple independent extracts at convenient intervals. Monitoring extracts and review logs. Oracle Analytics Cloud (OAC) Expertise in gathering businessrequirements for new Oracle Analytics Cloud (OAC) dashboards and new Oracle Analytics Cloud (OAC) reports. Ensure change/test coordination with the Oracle Analytics Cloud (OAC) development team membersPerform root cause analysis for Oracle Analytics Cloud (OAC) issues and develop permanent code fixes / tuning / configurations. Worked with business leaders, business users, and IT teammates to plan, define, design, develop, test, implement and support primarily Oracle Analytics Cloud (OAC) data modelling, dashboard and report activities. Building data environment to support existing and emerging data visualization and metrics requirements Develop data visualization solutions. OAC data in your choice of data visualization tools. Extensive experience in building template format using RTF, Excel and XSLT. Hands on dealing with complex RTF templates with multiple formats and complex coding. Good hands-on creating Bursting reports across enterprise level business users. Improve the data modelling application for Oracle Analytics Cloud. OBIEE Expertise in Business Intelligence, Data Management, Data Modelling, Data Mining and Data Visualization. Expertise in maintaining Business Intelligence entire system, and in providing end-to-end Business Intelligence solution by dimensional modelling design, developing, and configuring OBIEE Repository (RPD), Interactive Dashboards, OBIEE Answers, Security implementation, Analytics Metadata objects, Web Catalog Objects (Dashboard, Pages, Folders, Analysis) and Scheduling Agents. Expertise in Installation, Configuration, Up-Gradation, Customization, Migration and Administration of OBIEE. Translating Business requirement to functional design document and preparing technical design which talks about technical details on ETL side including Data model changes and RPD design followed by analysis design. Extensive experience in implementing various Authentication and Authorization mechanisms in OBIEE using External Database, LDAP, Native OBIEE Security. Participation in all phases of the Quality Assurance Life Cycle (QALC), Agile Model and Software Development Life Cycle (SDLC) including planning, requirements determination, current state analysis, solution design, estimating, construction, testing, training, implementing, and ongoing support and improvement. Expert in implementing and handling the complex environments which include clustering of servers, back up and Failover Strategies with connected and disconnected analytics. Experienced in performance tuning at the Database level by creating Aggregate tables, Bitmap, B-Tree Indexes, RPD level by creating Database hints in Physical Layer and Tuning Reports. Strong experience in hierarchies, complex and foreign joins, initialization block, session and non-session variables, calculations, aggregates, partitions, fragmentations and slowly changing dimensions. Oracle Analytics Server (OAS) Hands on experience in designing and developing reports using Oracle Analytics Server (OAS). Good Exposure in working for upgrade from OBIEE 12.x version to Oracle Analytics server 5.X versions. Working experience with Oracle Support team on both OAS and OBIEE 12.x versions. Open to considering OAS developers who are hands-on in data engineering space and understands the business benefits /objectives behind creating the work products. ETL Hands on experience in troubleshooting informatica out of the box Informatica workflows, Mapplets & mappings to the source systems tables, and enhancing the customization in ETL mappings. Good experience on developing new Informatica Workflows, worklets, Mapping and sessions as part of OBIA Stack or custom development. Exposure in working with ETL performance issues and improving daily ETL load timings. Hands on experience in handing ODIexporting and importing scenarios, Load Plans, Work Repositories and Master Repositories from one environment to other. Expertise in OLTP/OLAP System Study, Analysis and E-R Modelling, developing data warehousing concepts like Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional Modelling. Extensive experience with Fact and dimensional tables, and slowly changing dimensions. Expertise in gathering business requirements from end users and develop technical solutions. Proven ability to quickly learn and apply new technologies. Excellent analytical, problem-solving skills and ability to follow through with projects from inception to completion. Power BI Expertise in Power BI modelling. Experience in DAX function. Hands on Power BI Desktop version and pinning to dashboards with various views. Created Workspace and Content packs for business users to view the developed reports, Visualization and Dashboards. Scheduled Automatic refresh in Power BI Service. Weekly presentation to the business users about the reports and their changes as required. Worked on all types of transformations that are available in Power BI query editor. Posting power BI reports to Microsoft SharePoint Sites for easy use of internal teams. Integration Microsoft Flow to post files into SharePoint using One Drive for business tool. EDUCATIONAL QUALIFICATION: Bachelor's degree in computer science (2010) from JNTU, Anantapur, Andhra Pradesh. PROJECTS: Project Name Enbridge Surge & Unify Reporting Client Location Houston, TX Duration Feb 2023 to Till Date Role OAC Developer Responsibilities: Involved in Detailed Impact analysis on the existing reports & new changes into the reports and Repository. Involved in providing technical solutions to the scenarios as part of the support enhancement and redeveloped the reports as per new requirement. Develop reporting standards and best practices to ensure data standardization and consistency. Created new reports in Usage tracking to monitor the usage of different reports and dashboards. Created saved filters using dynamic repository variables so business users can use these filters for ad-hoc reporting. Experience in handling OAC enhancements and providing support for the same during the cut over time. Experienced in working with BICC jobs to extract data from Oracle Fusion. Environment: OAC, OTBI, BI Publisher. Project Name Oracle Client Redwood Shores, CA Duration Oct 2022 to Jan 2023 Role Technical Analyst Responsibilities: Global OBIEE/OTBI technical support through service requests. Experience implementing or supporting Cloud applications in Finance and SCM. Ability to create reports using Financial Reporting Studio (FRS), SmartView, and Oracle BI/Transactional Business Intelligence (OTBI). Provides a high level of customer satisfaction through the effective delivery of technical support and service programs. Customer support specifications may include product performance / maintenance. Proactively coordinates resources, problem resolution, problem escalation, and the use of system level diagnostics. Understands service processes and options that are linked with the customers specifications. Needs a 24-hour commitment to support customer specifications which may also be fulfilled by participation in the regional standby rotation. Working on different issues mentioned in different severity SR s. Environment: Oracle Business Intelligence Enterprise Edition 12c, BI Publisher, OTBI. Project Name Western Union Client Location Denver, CO Duration Jan 2021 to Oct 2022 Role BI Consultant Responsibilities: Working closely with Enterprise Data warehousing Team for providing updated date to Data Lake (holds all different projects data) and support with power BI reports. Worked on Migrating small set of analytics to Power BI, Convert all safety reports from OBIEE to Power BI. Participated in POC using third part plugins (BI Connect Driver tool) to connect OBIEE RPD from Power BI so that we can reuse all the existing models without rebuilding from scratch. Engaged in providing support to upgrade from obiee12 version to Oracle Analytics Server. Hands on experience handling new enhancements in OAS 5.X version and worked with oracle support team on new issues for quick fixes. Experience in handling OAS enhancements and providing support for the same during the cut over time. Good Hands-on Creating reports and models in Power BI using multiple sources available. Environment: Microsoft Power BI, OAS 5.x, Oracle Business Intelligence Enterprise Edition 12c, BI Publisher. Project Name Fidelity Investments Upgrade Client Location Durham, NC Duration Apr 2019 to Dec 2020 Role BI Consultant Responsibilities: Upgraded reports, dashboards, and BI Publisher reports from OBIEE 11.1.1.7 to 12.2.1.4. Retrofit activities in multiple phases to make reports available up to date. Experienced in migrating security from 11g to 12c and created SQL DB authentication. Experienced in creating custom messages and custom skins as per requirement. Installed Interim and Bundle patches in OBIEE 12.2.1.4. Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer (design of hierarchies, dimensions, and aggregates). Sharing access to multiple groups of users, to avoid traffic to application for same set of reports again. Created new reports in Usage tracking to monitor the usage of different reports and dashboards. Environment: Oracle Business Intelligence Enterprise Edition 12c, BI Publisher. Project Name Taubman Client Location Indianapolis, IN Duration Jul 2017 to Apr 2019 Role BI Consultant Responsibilities: Experienced of Fusion's schema, subject areas, and expertise with reporting tools such as Data Extracts, BI Publisher and OTBI Reports using different methodologies. Experienced Cloud-native tools like File-Based Data Import (FBDI), ADF Desktop Integration (ADFdi), and scheduling Oracle Cloud ESS Jobs. Expertise in OTBI using subject area, getting data by writing SQL queries, using RTF templates, jobs etc. Configuring Cloud applications with setups, rules, workflows including flex fields and personalization. Maintained application security including assigning user access controls based on roles and responsibilities. Developed and supported SQL queries and related reports. Created report templates using BI Publisher and scheduler report using Bursting concept to distribute reports to multiple sets of users in real-time. Environment: Oracle Sales Cloud, Oracle Business Intelligence Enterprise Edition 11.1.1.9, BI Publisher 11g. Project Name Tecumseh Client Location Ann Arbor, MI Duration Jul 2017 to Apr 2019 Role BI Consultant Responsibilities: Hands-on Experience in configuring Interactive Dashboards with drill-down capabilities using Filters and Dashboard Prompts, OBIEE Security Setup groups, access privileges, Metadata objects and Web Catalog objects Dashboard, pages, folders, and reports. Experience in setting up Security and architecture with OBIEE 11g by using web logic admin console and enterprise manager Configured and scheduled Intelligence Agents to send real-time alerts to the end users using Delivers and created reports using BI Publisher. Worked with business leaders, business users, and IT teammates to plan, define, design, develop, test, implement and support primarily Oracle Analytics Cloud (OAC) data modelling, dashboard and report activities. Improve the data modelling application for Oracle Analytics Cloud. Creating variables, sequences, user functions, scenarios, procedures, interfaces, and packages in ODI. Good Hands on developing new ETL mapping using various transformations and loading data to new warehousing tables or with into existing tables new enhanced columns. Involved in building new report through multiple chart view like Bar, gauge, Pie, Line, Rader and Scatter charts along with traditional Table and pivot views. Environment: Oracle Business Intelligence Enterprise Edition 12.2.1.2, BI Publisher, ODI 12.x, Oracle AnalyticsCloud (OAC). Project Name Accenture Client Location Organization Internal Duration Oct 2016 to Jan 2017 Role BI Developer Responsibilities: Troubleshooting production support issues, identifying the root cause and migrating fixes. Working on Change requests to implement changes. Perform on-call duties for the production support issues and outages occurring across different environments. Extensive Development of the repository according to the BRD (Business Requirements Document) and building the metrics in accordance with the FSD (Functional Specification Document). Analysis of existing legacy Oracle Reports to define business requirements and logic Experience developing, modifying, and deploying Oracle Forms and Reports in an Oracle database environment. Environment: BI Publisher 11g, Datawarehouse. Project Name APL Logistics Client Location Scottsdale,AZ Duration Sep 2014 to Oct 2016 Role BI Developer Responsibilities: Interacted with business users to gather business report requirements. Hands on experience in RPD and Web catalog Migrations. Created Application Roles using Oracle Enterprise Manager assigned different permissions on dashboards and reports. Created Shell scripts to start and stop the OBIEE instances in Linux environments. Used/Suggested Views, Indexes, and Aggregated Tables to improve performance of reports/dashboards. Created Proactive Agents / iBots using Delivers delivered using Scheduler services. Create, maintain, and manage documentation for all data warehouse and reporting development efforts. Modifying existing ETL jobs in Oracle Data Integrator. Provided on-call support and worked with onsite and offshore teams. Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.9, BI Publisher, ODI Project Name Covance Client Location Burlington, NC Duration Apr 2014 to Sep 2014 Role BI Developer Responsibilities: Attended defect review meetings and weekly status meetings. Implemented, Configured and Tested Data security and Dashboard security in OBIEE 11g. Configured the BI Delivers scheduler to schedule reports. Enhanced the performance of Reports/Dashboards by implementing the Aggregate tables. Configured clusters on WebLogic using the WebLogic Console. Experience in creating dimension table type1 and type 2 mappings. Created Analytical Views Compound Layout, chart, pivot etc. and Global/Local Prompts. Created Aggregations and Logical Based Measures in Business Model and Mapping Layer. Developed and customized some of the existing Dimensions Drill down Hierarchies Logical Objects in Business Model and Mapping Layer. Environment: Oracle Business Intelligence Enterprise Edition 11.1.1.6, Informatica 8.6. Project Name SCSBI Client Location Irving, TX Duration Jul 2012 to Apr 2014 Role BI Developer Responsibilities: Experienced in upgradation from OBIEE 10g to 11g. Enables Caching for better performance and implemented Event Pooling for Automatic Purging of Stale data. Creating Source/ Target definitions, building Mappings/ Mapplets and Creating and monitoring Sessions/ Workflows. Experienced in creating Sessions, Workflows, Mappings, Mapplets using various available transformations in Informatica, including Router, Aggregator, and Lookup. Extensively worked on Full & Incremental Loads. Environment: OBIEE 11.1.1.6, Informatica 8.6 Project Name CEVA Logistics Client Location Marseille, France Duration Mar'2011 to Jun'2012 Role BI Developer Responsibilities: Worked with Oracle BI(OBIEE) 10g and 11g Installations, Oracle BI Server, Presentation Server, Oracle BI Repository (RPD), Oracle BI Administration. Established the logical joins/keys required to support drill-down aggregation. Created Dimensional Hierarchy, Level based Measures and aggregation rules in BMM layer. Creation of Time Series functions using AGO & TODATE functions. Keywords: business intelligence database active directory rlang information technology hewlett packard Arizona California Colorado Michigan North Carolina Texas Keywords: business intelligence database active directory rlang information technology hewlett packard Arizona California Colorado Michigan North Carolina Texas