Saloni Sharma
Carnegie,VIC
Summary
Over 10 years of specialized experience in IT, with expertise in Data Warehousing, Data Migration, Data Integration, and Reporting. Proficient in designing, developing, testing, troubleshooting, and implementing ETL (Extract Transform Load) and ELT (Extract Load Transform) processes and creation of OBIEE reports. Skilled in collaborating with end-users for requirements determination, analysis, and documentation. Capable of defining system scope, performing gap analysis, estimations and conducting user acceptance testing. Highly effective communicator with exceptional facilitation skills, able to work independently and deliver with precision in fast-paced environments. Proficient in the Software Development Life Cycle (SDLC), with a demonstrated ability to efficiently deliver projects using Agile (Scrum) methodology. Results-driven Migration Consultant with expertise in ODI 12c, OBIEE 12c, and data analytics. Proven ability to lead teams and execute complex data migrations, ensuring seamless transitions and optimal data performance.
Overview
10
10
years of professional experience
Work History
Migration Consultant
Westpac
Melbourne, Australia
06.2023 - 06.2024
- Data and business analyst for report migration implementation for Westpac.
- Analysis of existing OBIEE reports and subsequent data mappings and sources for data availability and remapping in the TO-BE system.
- Responsibilities include business and data requirements analysis and documentation, engaging users for requirement gathering, acceptance testing and understanding various data and tool requirements and documenting the data flows for technical as well as business stakeholder consumption and approvals.
- Facilitated various functional and solution definition workshop for end users and domain consumers.
- Identified potential risks and devise strategies to keep the project on track.
- Tracking true sources for diversified mappings and conducting feasibility study for TO-BE big data platform.
Principal Consultant
Hero MotoCorp
India
11.2022 - 05.2023
- Customized and created OBIEE reports to meet new reporting requirements.
- Led a team of 5 analysts in the Services track, delivering valuable insights through data analytics and advanced data-driven methods.
- Created BRD and performed impact analysis and facilitated technical walk-throughs and communicated complex concepts to non-technical stakeholders.
- Oversaw support team in monitoring daily loads, resolving data issues, and creating service requests with Oracle.
Data Migration Lead
Alticor – Amway
US, United States
12.2020 - 11.2022
- Conducted feasibility studies to assess the impact of new features on the existing product.
- Analyzed and resolved issues in case of load failure and identified root causes of data discrepancies, modifying OBIA logic and tuning ODI code for optimal performance.
- Led requirement gathering for various conversion entities and conducted technical research on new ETL requirements, developing ODI code for selected entities.
ODI – OBIA Consultant
Rheem Manufacturing Company
US, United States
02.2020 - 12.2020
- Initiated and proposed process improvements to enhance business operations – Error handling in data loads.
Senior Technology Analyst – OCI migration
Lloyd’s Register
UK, United Kingdom
08.2019 - 01.2020
- Assisted in migrating the solution from on-premises to OCI and setting up 5 environments for Informatica and OBIEE.
- Migrated client’s OBIEE and Informatica infrastructure from on-premises to OCI environment, including upgrading Informatica 9.5.2 to 10.2 and OBIEE 11g to 12c.
- Implemented security using EBS-OBIEE SSC through ICX_SESSION_COOK in the RPD.
Senior Analyst: Qualitative and Quantitative sources (Onsite)
Care Quality Commission
United Kingdom
12.2017 - 07.2019
- Utilized Oracle Endeca web acquisition toolkit to scrape data from multiple websites.
- Performed data integration by uploading and mashing diverse data sources in Endeca studio.
- Configured more than 34 Endeca discovery applications for guided navigation and data filtering.
- Phase 2 – Informatica to ODI migration in Oracle Data Integrator, based on Informatica mappings, and segregated them by subject area.
- Developed load plans, scenarios, procedures, and other relevant components in ODI and scheduled them to replicate the mappings called in DAC.
Technology Analyst – Integration Track
Cavium (now acquired by Marvell Technology)
California, United States
06.2016 - 12.2017
- Responsible for technical build of the application, including integration design and creation of over 150 custom ODI interfaces/mappings.
- Designed fact and dimensions in ODI using star or snowflake schemas required in RPD, analyzing report queries.
- Migrated and maintained various environments (KUT to SIT, UAT and Production) and provided ODI trainings to key users.
Senior System Engineer – BI Reporting
GAP Inc.
California, United States
12.2015 - 06.2016
- Assisted business in upgrading legacy system from Discoverer to BI by converting, creating, and migrating reports.
- Designed data warehouse and data schemas.
- Developed BI reports on top of the opaque views in the physical layer of RPD.
ODI-OBIA developer
Al Ghurair Group
Dubai, United Arab Emirates
10.2014 - 12.2015
- Successfully implemented OBIA 11.1.1.9.2 with ODI for various functional areas including Procurement and Spend Analytics, Project Analytics, Enterprise Asset Management Analytics, Supply Chain and Order Management and Human Resource Analytics, while ensuring data lineage.
System Engineer – Historical Data Migration
Hyatt Hotels Corporation
USA, United States
02.2014 - 09.2014
- Streamlined data loads by developing simple ODI mappings that loaded data into Hyperion applications and converting modelled rules to ODI lookups for staging load.
- Established data servers, schemas, interfaces, procedures, and packages to ensure efficient data management.
Education
Bachelor of Science -
Western Sydney University
Sydney, New South Wales, NSWSkills
- ETL Tools: ODI 12c
- OBIA 111192 (BIApps)
- ODI 11g
- Clover ETL
- Informatica
- WAT
- Reporting: OBIEE 11g
- OBIEE 12c
- Power BI
- Administration: OBIA and ODI installation and configuration
- Methodology: Agile
- JIRA
- Waterfall model
- Scrum
- Source Systems: Unstructured
- Websites
- Web portal
- Online attachments
- Structured
- EBS
- SRM
- Data files
- Custom tables
- Cloud Exposure: PaaS
- OBIEE to OAC implementation
- IaaS
- OCI migration
Personal Information
Date of Birth: 10/12/91
Timeline
Migration Consultant
Westpac
06.2023 - 06.2024
Principal Consultant
Hero MotoCorp
11.2022 - 05.2023
Data Migration Lead
Alticor – Amway
12.2020 - 11.2022
ODI – OBIA Consultant
Rheem Manufacturing Company
02.2020 - 12.2020
Senior Technology Analyst – OCI migration
Lloyd’s Register
08.2019 - 01.2020
Senior Analyst: Qualitative and Quantitative sources (Onsite)
Care Quality Commission
12.2017 - 07.2019
Technology Analyst – Integration Track
Cavium (now acquired by Marvell Technology)
06.2016 - 12.2017
Senior System Engineer – BI Reporting
GAP Inc.
12.2015 - 06.2016
ODI-OBIA developer
Al Ghurair Group
10.2014 - 12.2015
System Engineer – Historical Data Migration
Hyatt Hotels Corporation
02.2014 - 09.2014
Bachelor of Science -
Western Sydney University