Wasat Ullah

· Created and maintain Data Warehouse data model following set standards, utilizing both Relational and

· Dimensional Modeling techniques.

· Created and maintain ETL jobs to effectively load Enterprise Data Warehouse with good data quality.

· Performed high level data extraction and manipulation from various healthcare databases and files to support organizational quality, utilization initiatives and other information needs.

· Created and maintained reports, reusable queries and/or dashboards to improve IHA’s operational reporting capability.

· Understood different data delivery and data consumption method and create reports and dashboards as needed.

· Created and maintained metadata and documentation, including data models, data dictionary, data mapping.

· Looked to ways to use data to support IHA’s quadruple aim.

· Keep up with industrial data technology trends and bring innovative ideas to the organization.

· Understood Business Intelligence, Advanced Analytics, Machine Learning and Robotic Processing.

· Imported data from Sql Server databases into OAC

· Created OAC worksheet

· Transformed data and created custom columns using OAC built in Functions

· Created level based and Time series Functions in OAC

· Built analytical visualization in OAC

· Performed Data profiling, Source to Target Mapping, Data analysis, Data quality, Database design, SQL Tuning, Query optimization, Data Architecture

· Understood and translated business needs into data models supporting long-term solutions

· Worked on Oracle BI-Apps (Financial, Procurement and HR) Analytics which also includes some custom subject area.

· Worked on Oracle OAC instance, configured and built BICS solution with on-prem database.

· Build Report and Dashboard on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.

· Created Dax Queries to generate computed columns in Power BI.

· Generated computed tables in Power BI by using Dax.

· Developed a strategy to Extract Data for Budget and planning from EBS and PeopleSoft source systems.

· Worked on Oracle OEMM (12.2.1.3) for Metadata annotation and labelling metadata comparison, integration and mapping.

· Developed ODI integration to extract data from EBS R12 source system and write to file in the format required by PBCS.

· Developed ODI integration to extract data from PeopleSoft source system and write to file in the format required by PBCS.

· Develop ODI integration to convert the data from PBCS output file in the format required by EBS and PeopleSoft to reload the data back.

· Prepare data from different source systems for OAC

· Presented several visualization options for OAC for various business use case scenarios

· Create OAC worksheet

· Transformed data and created custom columns using OAC built in Functions

· Created level based and Time series Functions in OAC

· Build analytical visualization in OAC

· Create Multiple Load plans based on the data loading strategy (Yearly, Monthly, Weekly and Daily)

· Architect and design Financial Management reports based an integrated data model wherein plan/projection data comes from Essbase and GL actuals from OBIA

· Architect the Real time GL reporting solution exploiting the Fragmentation capabilities of the OBIEE platform

· Customized the OOTB star schema and modified the BMM layer to meet the customer requirements.

· Worked hands-on in developing some of the reports in OBIEE 10g and later upgraded to 11g.

· Created the remaining reports in OBIEE 11g version.

· Created Custom dashboard reports with customer specific custom reports with different charts and graphs.

· Customize the OOTB dashboard reports to meet the customer specific reporting requirements.

· Merged a customer existing custom RPD/Webcat after upgraded to 11g into the newly design/developed RPD/Webcat.

· Lead – BIAPPS 7.9.6.2/7.9.6.3

· Customize the OOTB warehouse tables with additional attributes and modify

· To drive and deliver functional and technical specifications for the EP(Expense Payables) and P2P(Procure to Pay) BI modules

· To define and deliver the BI testing approach

· To frame a solution to deliver highly formatted, real time GL reports

· To establish Vendor evaluation criteria to select a vendor that provides pre-built real time apps for EBS GL reporting.

· Work closely with business SMEs and Analytics Analysts to understand map business needs into data warehouse and ETL design.

· Create and maintain Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.

· Create and maintain ETL jobs to effectively load Enterprise Data Warehouse with good data quality.

· Perform high level data extraction and manipulation from various healthcare databases and files to support organizational quality, utilization initiatives and other information needs.

· Create and maintain reports, reusable queries and/or dashboards to improve IHA’s operational reporting capability.

· Understand different data delivery and data consumption method and create reports and dashboards as needed.

· Create and maintain metadata and documentation, including data models, data dictionary, data mapping.

· Look to ways to use data to support IHA’s quadruple aim

· Keep up with industrial data technology trends and bring innovative ideas to the organization.

· Understand Business Intelligence, Advanced Analytics, Machine Learning and Robotic Processing.

· Imported data from Sql Server databases into OAC

· Created OAC worksheet

· Transformed data and created custom columns using OAC built in Functions

· Created level based and Time series Functions in OAC

· Build analytical visualization in OAC

· Retrofitted all the BI objects post upgrade includes OBIA Repository Metadata, Web catalog, BI Application Configuration files.

· Configured, upgraded and Merged OBIEE/OBIA custom RPD, Catalog with Out-of-box prebuilt BIAPP7.9.6.4.

· Analyze source systems – operational and transactional applications to identify the data elements of business interest to build relational and dimensional data models for Data Warehouse and Data Marts.

· Develop Logical data modeling, physical data modeling, conceptual data modeling ER modeling, dimensional modeling, Normalization, De-normalization

· Perform Data profiling, Source to Target Mapping, Data analysis, Data quality, Database design, SQL Tuning, Query optimization, Data Architecture

· Understand and translate business needs into data models supporting long-term solutions.

· Created Dax Queries to generate computed columns in Power BI, also applied DAX calculated measures and columns.

· Installed and configured Enterprise gateway in Power BI service.

· Scheduled Automatic refresh and scheduling refresh in Power BI service.

· Experienced on how to publish, schedule reports and dashboards to meet business requirements

· Migrated ETL mappings, interfaces, packages from SSIS to ODI

· Worked on Oracle Data Integrator (ODI) 12C version.

· Managed and built ODI repositories and created workflow s in ODI designer.

· Created and maintained interface in a heterogeneous environment.

· Used and modified different ODI knowledge modules.

· Developed visual reports, dashboards, and KPI scorecards using Power BI desktop.

· Created calculated columns, Measures queries in Power BI desktop to show good data analysis techniques and Generated reports in Power BI Modelling and usage of DAX.

· Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

· Implementation of Row-level security with Power BI (RLS).

· Involved in Installation and configuration of OBIEE, ODI 11.1.7.0 with BI Application 11.1.1.7.0.

· Involved in requirement gathering, Fit-Gap Analysis, creation of Module design document to track functional and technical requirement

· Configure & Customize Out-of-box prebuilt OBIA RPD, Web-Catalog, ODI master and work repository for BI Application 11.1.1.7.1

· Performed functional configuration, manage data load parameters, reporting parameters, export setup data, Manage Load plan through Configuration manager, functional setup manager and ODI Console.

· Setting up & testing performance parameter in BI Application environment to address performance issue on DEV, TEST and PROD.

· Installed & configured OBIEE 11.1.7.1 with BI Application 7.9.6.4 on Analytics Development Environment

· Retrofitted all the BI objects post upgrade includes OBIA Repository Metadata, Web catalog, BI Application Configuration files and setting up parameters as per OBIEE 11g.

· Performed upgrade activities for OBIEE Custom RPD and Catalog.

· Configured, upgraded and Merged OBIEE/OBIA custom RPD, Catalog with Out-of-box prebuilt BIAPP7.9.6.4.

· Migrated ETL mappings, interfaces, packages from ODI to ODICS

· Connected Oracle Cloud storage to ODICS

· Extracted and loaded data from on prem database to cloud database using ODICS

· Design, develop, and enhance ETL and BI Solutions using the Microsoft SSIS and SQL Server Relational Database technologies

· Participate and deliver on new data warehouse project and be the main ETL support member after the go-live

· Monitor production jobs, maintain, and enhance legacy ETL processes on a regular basis. Improve slow running jobs with the help of redesign and better ETL processes to meet business needs

· Work very closely with the existing DBA to design, model, develop, and maintain existing and new SQL databases objects required for all business solutions

· Take directions, follow recommendations provided by data architecture, Info Security and data governance organization

· Confer with relevant business and IT team members where necessary. Study systems flow, data usage, and work processes

· Deliver functional work product that has been thoroughly tested

· Follow development team’s SDLC process. Accurately estimate time required to complete projects and tasks

· Meet mutually agreed upon deadlines for completion of modules throughout the program development

· Works well independently; capable of self-motivating and managing

· Developed the enterprise BI application with the team using one or more of Oracle Technologies that include: Oracle Data Integrator (12C) and PL/SQL.

· Participated in scope definition for code/maintenance releases, decompose user needs into technical requirements, contribute to defining of life-cycle milestones, and interact with internal teams such as Configuration Management, System Testing, and Operations.

· Provided solutions and best practices while building the BI application for questions or concerns raised by internal and external stakeholders.

· Identified, documented, and corrected defects or suggested improvements to the Data Warehouse/Data Mart.

· Reviewed, updated, and maintained documentation on the existing Data Warehouse/Data Mart capabilities. This includes design documents, as well as, logical and physical diagrams.

· Performed analysis of existing Data Warehouse/Data Mart related System Problem Reports (SPRs) and provide recommended solutions and engineering estimates to resolve.

· Identified, evaluated, documented, and reported any data access and security concerns to existing Program Management and Information Assurance.

· Involved in Data Profiling and Data Cleansing activities.

· Created Bi-Directional interface from Legacy system to oracle E-business suite for data Synchronization.

· Installed and configured Oracle Stream packages on database for Data replication /change and data capture.

· Worked on Oracle Data Integrator (ODI) 11g version.

· Managed and built ODI repositories and created workflow s in ODI designer.

· Created and maintained interface in a heterogeneous environment.

· Used and modified different ODI knowledge modules.

· Designed and configured the initial ‘folder’ structure / Meta-Model for selected environments.

· Imported the metadata from a selected system into the ODI repository source.

· Export / Import different projects in ODI from Development environment to QA and production environments.

· Create Batch and Real time packages in ODI.

· Worked on Oracle OEMM (12.2.1.3) for Metadata annotation and labelling metadata comparison, integration and mapping.

· Develop ODI integration to extract data from EBS R12 source system and write to file in the format required.

· Develop ODI integration to extract data from Oracle Retail and Merchandising (RMS)

· Develop ODI integration to convert the data from Custom Build Application output file in the format required by EBS and Oracle Retail and Merchandising (RMS) to reload the data back.

· Create Bi-Directional interface from Legacy system to oracle E-business suit for data Synchronization.

· Install and configure Oracle Stream /Log miner packages on database l for change data capture.

· Performed analysis, design, development, testing and implementation of business required Siebel Analytics Dashboards and reports

· Built business model and mapping layer, which include hierarchies, dimensions, and

aggregates.

· Support users of our suite of reporting and analytic tools, which currently include OBIEE 11G, BI Publisher.

· Mapped presentation layer objects to Oracle BI Answers.

· Used BI publisher for static reports and configured IBOT to schedule the BI reports and alerts.

· Created Dashboard, portal, and ad-hoc reports in Oracle BI-presentation services.

· Transform and load data to data marts to support the dashboards.

· Built and modified OOTB (Out of the Box) ODI Work Repository for Oracle E-Business suites R12.

· Built and modified OOTB (Out of the box) Load Plans packages, interface and procedures.

· Built and modified OOTB (Out of the box) dashboards and reports.

· Performed data analysis and Design, implement, document (e.g. data models, metadata), and maintain relational (normalized and de-normalized) and multi-dimensional data stores. (i.e. tables, databases, views, data marts).

· Managed the settings, server, web-catalog, log parameter files, promotion of data repositories associated with OBIEE.

· Configuration of Presentation Services and BI Services

· Physical & Logical architecture design understanding in OBIEE

· Wrote stored procedure, trigger, sequences and user functions.

· Delivery of daily/weekly/monthly outbound client extracts.

· Involved in developers training for ODI.

· Trained user for OBIEE reports.

· Overall project delivery and hot fixes.

· Onsite and offshore coordination.

· Resource management