| | | 20,000+ Fresh Resumes Monthly | |
|
|
| | Related Resumes Clerical, Customer Service, Data Entry, Medical Federal Way, WA Sql Server Data Engineering Seattle, WA Data Engineer Seattle, WA Data Entry Information Technology Seattle, WA Software Engineer Data Science Olympia, WA Software Development Data Center Bothell, WA Network Engineer Data Center Kent, WA |
|
Click here or scroll down to respond to this candidate
Candidate's Name
Mobile : (PHONE NUMBER AVAILABLE
EMAIL AVAILABLE@gmail.com
Senior Oracle data Integrator & Data Warehousing (ETL) Consultant
PROFESSIONAL ENGAGEMENT OVERVIEW:Overall 13+ Years of Multinational working Experience includes (7 Yrs. in USA, Dubai, Hong Kong, Malaysia and 6 Yrs. in Oracle Corporation India) on Requirement gathering, application Designing, Development, Up-gradation, Migration and Implementation using Oracle data Integrator 11g/12c, OBIEE 10g/11g/12c, OAS 5.9, OAC and BIAPPS.TECHNICAL PROFICIENCY:Business Intelligence Reporting ToolsOAC, OAS, BICS, OBIEE 10g/11g/12c, BIPublisher 11g, OTBI, Tableau, PowerBIData Warehousing (ETL) ToolsODI 11g/12c, Oracle Golden Gate 12c, Informatica Power Center, Microsoft SSISRelational and warehouse databasesOracle SQL/PLSQL 12c/11g/10g, Oracle Autonomous data warehouse, SQL Server 2005/2008, PostgreSQL, DB2Oracle ERP and Banking ProductsOracle EBS R12, Oracle Fusion EBS, Siebel CRM, Vantage, Core Banking Temenos, Anti Money Laundering, Loyalty system, Collection system, Loan dispersal System etc.Cloud ProductsAWS Redshift, AWS S3, AWS RDS, AWS EC2, Azure data factory, Azure data LakeTicketing ToolsHP Service Manager, HP ALM, JIRA cloud, CMS, BMC RemedyBigdata TechnologiesPyspark, SparkSQL, DatabricksOthersUnix, Shell Scripting, Java, Python, Putty, WinSCP, Jenkin and GitHub version ControlACADEMIC QUALIFICATION:2007 2010 master s in computer application (MCA) Biju Pattnaik University of Technology, India
ACHIEVEMENTS:Awarded as Pace Setter for the Financial Year 2012 by Oracle Corporation, IndiaAwarded as Outstanding Performer for the Financial Year 2021 by Ajman Bank, Dubai
Work Experience Overview: Oct 2022 to Present Senior Consultant-Oracle Business Intelligence Location: California, USA Client: Pacific Gas & Electric Company (PG&E), California, USA
Roles and Responsibilities: Lead and manage a team of data integration engineers, providing guidance, support, and mentoring to ensure the successful execution of ODI projects. Oversee the end-to-end development and implementation of data integration solutions using Oracle Data Integrator, optimizing ETL processes for efficiency and performance. Involved in designing and implementing the E-LT architecture using ODI12c that is required to build data warehouse, including source-to-staging, staging-to-target area, data transformations and EL-T process flows. Implemented the extraction, loading, and transformation EL-T of data using Oracle Data Integrator configuring the ODI master and work repositories. ODI models, defining and organizing the ODI project including interfaces, Packages, procedures, variables, user defined functions and knowledge modules. Loaded data from different source systems to target warehouse using ODI interfaces with Knowledge modules like RKM, LKM, IKM, JKM and CKM for data quality check. Involved in Data Warehouse architecture design like Star Schema, Snowflake Schema, Data Mart, Dimension and Fact tables. Created master and work repositories for ODI by coordinating with Oracle DBAs. Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files (txt, csv, xlsx) into oracle database. Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse. Implemented SCD type1, type2 and type3 as part of historical data capture. Created Indexes, Views, Materialized views, Table partition and hints for better performance of the query. Used ODI Operator for debugging and viewing the execution details of interfaces and packages. Used OAS/OAC to develop Interactive Reports, Dashboards, Briefing Books, Agents and developed underlying metadata layers including Physical, Business model and Mapping and Presentation layer. Involved in developing database views and their refresh mechanism, creating aggregation tables and configuring it with OBIEE and OAC environment for Reporting purpose. Designed OAS/OAC Dashboards, BI Answers and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse. Implemented solutions having data level as well as object level security and developed custom solution for security management in OAC environment. Developed BI Publisher reports and OTBI reports from Oracle Fusion ERP including Finance and SCM Module. Liaison with Oracle support for Service Requests (SRs) and resolution of any issues. Performed Query optimization, debugging, and performance tuning for improving performance. Developed and maintained project plans to manage scope and estimated delivery schedules on the project. Loaded data from multiple AWS S3 bucket to AWS Redshift data warehouse database tables. Applied slowly changing dimensions in various Mappings to load data from source to target and maintained current and historical data on year wise with specific dimensions. Led the integration of ODI12c with GitHub for version control and repository build, enabling collaborative development and code management for data integration workflows. Responsible for supporting Oracle 12c/19c, Microsoft SQL Server 2010 databases. Extensible involvement in developing Knowledge Based pool of Queries using Sql and PL/ SQL - Cursors, Function, Procedures, Packages, Triggers, Sequences, Records, PL/SQL Table, Exception Handling Mechanism. Involved in developing PLSQL procedures using Bulk Collect, for all and Save Exception to process large volume of data. Involved in implementing Dynamic Query using Ref Cursor and various kind of Collection datatypes. Involved in UNIX shell scripting for monitoring servers of OBIEE, ODI, OGG manager processes and process status. Implemented multiple ODI mapping and packages using UNIX shell scripting and loading data into target table.
June 2019 to Aug 2022 Senior Supervisor-Oracle Business Intelligence at Ajman Bank Location: Dubai, UAE Client: Ajman Bank, Dubai
Interface with business users to gather requirements for delivering complete Reporting solutions using OBIEE 11g, OAS, OAC, BI Publisher, ODI 12c and Oracle 12c/19c SQL/PLSQL Used OBIEE 11g, OAC and OAS to develop Interactive Reports, Dashboards, Briefing Books, Agents and developed underlying metadata layers including Physical, Business model and Mapping and Presentation layer. Responsible for supporting Oracle 12c/19c SQL Server 2010 databases. Extensible involvement in developing Knowledge Based pool of Queries using Sql and PL/ SQL - Cursors, Function, Procedures, Packages, Triggers, Sequences, Records, PL/SQL Table, Exception Handling Mechanism. Involved in developing PLSQL procedures using Bulk Collect, for all and Save Exception to process large volume of data. Involved in implementing Dynamic Query using Ref Cursor and various kind of Collection datatypes.
Involved in developing database views and their refresh mechanism, creating aggregation tables and configuring it with OBIEE environment for Reporting purpose. Implemented Change Data Capture (CDC) feature of ODI to refresh the data in Enterprise Data Warehouse (EDW). Implemented Slowly Changing Dimension Types like SCD type1, type 2 and type 3 as part of historical data capture. Liaison with Oracle support for Service Requests (SRs) and resolution of any issues. Performed Query optimization, debugging, and performance tuning for improving performance. Used ODI Operator for debugging and viewing the execution details of interfaces and packages. Developed and maintained project plans to manage scope and estimated delivery schedules on the project. Upgraded On-Premises OBIEE 11.1.1.9.0 to Oracle Analytics Server (OAS5.9) and OAC. Loaded data from multiple sources like CSV, MS SQL server, Parquet and JSON files to Azure Data Lake using ADF and Azure through Pyspark, PySQL and Scala. Implemented security at OBIEE Reports by creating roles & groups, checks with External tables and LDAP and Object Level Security. Setup Usage tracking option to monitor frequently run reports to provide caching for the reports and perform database optimization by analyzing query performance. Developed and supported Data warehouse applications mainly Extraction, transformation and loading (ELT) using ODI12c for multiple downstream systems like Financials, Profitability, Collections, Anti Money Laundering and Credit Card Reward Points. Worked in designing and developing interfaces, packages, procedures, variables, Load Plan and scenarios. Loaded data from different source systems to target warehouse using ODI interfaces with Knowledge modules like RKM, LKM, IKM, JKM and CKM for data quality check. Involved in Data Warehouse architecture design like Star Schema, Snowflake Schema, Data Mart, Dimension and Fact tables. Applied slowly changing dimensions SCD in various Mappings to load data from source to target and maintained current and historical data on year wise with specific dimensions. Involved in UNIX shell scripting for monitoring servers of OBIEE, OAC, OAS, ODI, OGG manager processes and process status. Implemented multiple ODI mapping and packages using UNIX shell scripting and loading data into target table.
Jul 2017 to May 2019 Senior Analyst- Business Intelligence at Oracle India Pvt. Ltd Location: Bangalore, India Client: Vale, South America & Canada and Selfridges Groups, UK Involved in preparation of Upgrade and Migration plan, man-day s estimation & documenting the steps and review updates. Migrated On-Premises OBIEE 11.1.1.9.0 and ODI 11.1.1.9.0 artifact to Oracle Public Cloud on IaaS and DBPaas. Involved in implementing Complex ETL process with source as Oracle Golden Gate and Oracle Data Integrator to build the Data warehouse. Involved in Unix shell scripting for monitoring servers of OAC, OAS, OBIEE, ODI, OGG manager processes and process status. Involved with Data Virtualization team to Source data for OAC, OAS, OBIEE 12c Reporting. Developed BI Publisher reports and OTBI reports from Oracle Fusion ERP including Finance and SCM Module. Communicated with Data services team (Business Analysts, Data Architects and Developers) regarding status, issues and risks on a timely basis. Involved in analyzing the business requirements and coordinating with PM team to solve any discrepancy in the requirements and provide suggestions to make changes if necessary. Implemented Variable Manager to define Session and Repository Variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically using OAC/OAS.Nov 2016 to Jun 2017 Senior OBIEE-ODI Consultant at AIA Financial Centre
Location: Hong Kong Client: AIA Financial Centre, Hong Kong Involved in gathering reporting requirements, documenting specifications, implementing the metadata layers including Physical, Business model and Mapping and Presentation layer using OAS, OBIEE 12c and BIP. Implemented Variable Manager to define Session and Repository Variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically. Designed OAS, OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse. Loaded data from different source systems to target warehouse using ODI 12c mappings with Knowledge modules like RKM, LKM, IKM, JKM and CKM for data quality check. Responsible to lead a team of three to redesign the OBIEE11g repository to improve performance and make it OBIEE Compatible. Responsible to do the Unit testing and data validation after the Repository is redesigned.
Implemented Write back functionality.
Developed BI Publisher reports and OTBI reports from Oracle Fusion ERP including Finance and SCM Module.Jul 2015 to Nov 2016 OBIEE Developer at CIMB Bank and Standard Chartered Bank Location: Kuala lumpur, Malaysia Client: CIMB Bank & Standard Chartered Bank Involved in gathering reporting requirements, documenting specifications, implementing the metadata layers including Physical, Business model and Mapping and Presentation layer using OBIEE 11g and BIP.
Developed and supported Data warehouse applications mainly Extraction, transformation and loading (ELT) using ODI 11g. Designed, developed ODI (Oracle Data Integrator) objects for ETL Project, gathering requirement specification documents and presenting and identifying data sources. Performed the unit testing, system integration testing and assist with user acceptance testing Documented the ETL detailed design and test results. Created and maintained integration process using ODI and load rules. Liaisoned with Oracle support for Service Requests (SRs) and resolution of any issues. Worked with multiple sources such as Relational databases, Flat files like CSV, TXT for Extraction, Transforming and Loading data into target tables. Involved in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by implementing Aggregate navigation, Cache management and materialized view.Jul 2011 to Jun 2015 Technical Analyst at Oracle India Pvt. Ltd Location: Bangalore, India Client: Engineers Australia & Asian Development Bank
Used OBIEE 10/11g to develop Interactive Reports, Dashboards, Briefing Books, Agents and the underlying data model. Developed and supported Production Environment of Data warehouse applications mainly Extraction, transformation and loading (ELT) using ODI11g. Involved in capturing change logs and apply Oracle Golden Gate for heterogeneous replication Installed, Configured, troubleshoot and supported Oracle Golden Gate Replication between different version of Oracle Database and across Golden Gate releases. Communicated with Data services team (Business Analysts, Data Architects and Developers) regarding status, issues and risks on a timely basis. Performed Unit, Integration, and Regression testing for SIT and UAT to validate reports. Test cases have been prepared and documented the results. Involved in developing stored procedures, functions, packages and database triggers using SQL Developer and PL/SQL to improve query performance.Designed OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data warehouse. |
