Trupti D. Thakur
Summary
Results-driven professional with over 10 years of experience in developing and supporting Oracle Enterprise Data Quality processes, including OEDQP, OEDQ, and OWS. Proven expertise in implementing robust data quality measures through various OEDQ processors, ensuring data correctness, completeness, and effective matching logic. Skilled in Business Rules Checks (BRC) and adept at generating detailed reports on data quality metrics while facilitating smooth migrations to production systems. Strong communicator with a meticulous approach to tasks, capable of collaborating with clients for requirement clarification and delivering high-quality results both independently and within a team environment.
Overview
11
11
years of professional experience
Work History
Oracle OWS Developer
EY
05.2024 - Current
- Responsible for OWS process development based on the requirements and quality to be provided to data, and data correctness.
- Developed various match rules to filter the data based on the given scenario.
- Involved in various support tasks for data migration activities and the decommissioning process.
- Worked on Control-M schedulers to execute the jobs.
- Involved in various testing activities.
- Train new joiners.
- Working on the RTS application to send real-time data for screening.
- Handling the RTS application to send a request or response back to the sources.
Oracle EDQ Developer
Syneos Health
11.2023 - Current
- EDQ is accepting the data from Database tables or from Excel to process the rules and developer will be implementing the rules given in the requirement and raising the flags for the incoming records and that report will be shared to business for the review to take the action or to correct the data accordingly.
- Focused on developing the EDQ processes based on the rules given.
- Review the report and share it with business for further review.
- Precisely worked on documentation creation for the ongoing activities which helps for newcomers as well.
- Active interaction with business on daily progress.
- Train new joiners.
Oracle EDQ Consultant
Tesco Limited
09.2021 - Current
- Extracting the various colleague's information from different sources in ODI. ODI is doing the main transformation by using logic sets/ calling procedures. Also, ODI will trigger EDQ to do some more transformation or cleansing of the data via business rules checks and using various EDQ processors and pushing transformed data back to ODI and ODI will generate HDLs(.dat file) and those HDLs will get loaded into Fusion.
- Responsible for EDQ Process Development based on the requirement and quality to be provided to data.
- Implemented various business rules checks in the process development to send a report to the client where data is not in good shape.
- Client will verify and correct the data and quality data will go to Target systems i.e. Fusion.
- I will be pushing extract files to the database using MFTCS.
- Creating folder structure in WinSCP with the help of Putty Commands.
Oracle EDQ Consultant
National Oilwell Varco CaPS
11.2019 - Current
- Project provides a comprehensive data quality environment, used to understand, improve, protect and govern data quality. It facilitates to ensure data quality and data correctness by providing efficient solution while screening customer data.
- To design and implement feasible solution to the business requirement.
- To ensure data quality and data correctness by providing efficient solution while screening customer data.
- To analyze data which includes Inspecting, Cleansing, Transforming and Modeling Data with the goal of highlighting useful information.
- To process data by applying multiple set of OEDQ processors to ensure data correctness, data quality, data completeness, data matching logics and fuzzy rules.
- Worked on creating multiple simple and complex processes to validate and transform the data and writing the results into write processors.
- Successfully implemented the processes and scheduled the needed jobs.
- Worked on extraction and conversion processes.
Oracle EDQP Consultant
National Oilwell Varco
11.2014 - Current
- Project intend to provide high quality, govern and consistent data to end user. Data comes from any legacy system like Files, Excel, databases and EDQP will standardize, categorize and govern the data and the process will give complete and consistent data to JDE, Target Systems or Teamcenter.
- Responsible for Datalens and DSA development to convert the unstandardized legacy data to consistent standardized data.
- Created project using Oracle EDQP tool which is simple, interactive and produces complete and governed data.
- Involved in requirements gathering from end users directly and full fill the scenarios by analyzing in Technical Area and proceed for EDQP development.
- Developed the datalens in Knowledge studio which will categorize the data by validating implemented business rule and provides standardized data.
- Worked on attribution to populate valid values against the attributes and implemented numeric rules for numeric attributes by analyzing items.
- Worked on simple and complex DSA (Workflow) development in Application Studio to process the legacy data as per the customer requirement and the end to end processed data will get deployed to JDE, Target Systems or Teamcenter.
- Worked on SQL or PL/SQL procedures to capture the EDQP related task in SQL Server 2008 R2 or 2012.
- Prepared the Technical and designed document based on the Client Requirement for EDQP.
- Successfully implemented Datalens and DSAs in Knowledge studio and Application Studio respectively.
- End to End communication with users from requirement gathering to module delivery.
Oracle OWS Developer
Barclays Customer data
08.2022 - 11.2023
- Accepting the customer data in OWS Director and pass it through various lists and world-check data to find the true match or false positive results based on match rules. Then the result will go through further review by Ops team.
- Responsible for OWS Process Development based on the requirement and quality to be provided to data and data correctness.
- Involved in various support tasks for data migration activity and decomm process.
- Worked on TWS schedulers to execute the jobs.
- Involved in various testing activities.
- Train new joiners.
Education
BE - Computer Engineering
Sandip Foundation SIEM
Nasik, MH01.2014
Diploma - IT
SSVPS College
Dhulia, MH01.2011
Skills
Data Quality: Oracle Enterprise Data Quality (OEDQ) Version 122140, Oracle Enterprise Data Quality for Product Data (Version 11G, 12C), Oracle Watchlist Screening (OWS)
Accomplishments
- Awarded with best fresher for National Oilwell Varco Project.
- Won SPOT AWARD at KPIT Technologies for best performance.
- Star Recognized in Teamwork and Responsibilities category by Managers.
- Hosted Fun Event for entire MDM Team.
- Participating in Fashion show event.
Timeline
Oracle OWS Developer
EY
05.2024 - Current
Oracle EDQ Developer
Syneos Health
11.2023 - Current
Oracle OWS Developer
Barclays Customer data
08.2022 - 11.2023
Oracle EDQ Consultant
Tesco Limited
09.2021 - Current
Oracle EDQ Consultant
National Oilwell Varco CaPS
11.2019 - Current
Oracle EDQP Consultant
National Oilwell Varco
11.2014 - Current
Diploma - IT
SSVPS College
BE - Computer Engineering
Sandip Foundation SIEM