Prakashkumar Patel Email & Phone Number

Gainesville, Virginia, United States

* Deep understanding of ODI architecture and components like sources and targets including agent, master, and work repositories, ODI studio including designer, operator, security, and topology navigator.* Worked along with business analysts, developers, management professionals and Offshore team to gather requirements and planning for implementation.* Design and develop stored procedures, functions, triggers, packages, and other database objects to meet the requirements of applications also load historical data into Datawarehouse tables.* Responsible for performance tuning of SQL queries and PL/SQL code to ensure optimal database performance.* Implemented end to end Migration Project from DataStage to Oracle Data Integrator.* Created PL/SQL Procedures, Packages for complex aggregate tables logic which is not handle via oracle tools ODI.* Implemented mappings in ODI 12c using different components like Set, Pivot Tables, Aggregate, Expression, Filter, Join, distinct, Lookup and Split.* Customized ODI integration knowledge module both incremental update and slowly changing dimensions based on business requirement.* Migrating ODI code from Dev environment to QA using ODI smart import export utility and DB incremental using Jenkins tool.* Code review for offshore team after development completed then import into test and production environment using ODI smart import utility.* Developed ODI Mappings, Reusable Mapping, Package, Procedures, Project, and Global Variables.* Created and Scheduled multiple ODI Load Plan using context and agent with exception raising error and email confirmation for multiple projects.* Completed Data analysis and Data Modeling on User Recertification and IVR call center data end to end Automation process.* Used different Tool like OdiPurgeLog, OdiSendMail, OdiZip for better debugging, performing, and monitoring purpose.

Columbia, Maryland, United States

* Experience in Analysis, Design, and Development including implementation of Business Intelligence BI solutions using ODI/OBIEE.* Worked along with business analysts, developers, management professionals and with business users of customer to gather requirements.* Good understanding of ODI architecture and installation of Topology, Agent, Context, Security, Designer, Operator, Master repository and Work repository.* Created ODI Load Plan, Package, Mappings, Reusable Mapping, Procedures, Variables in ODI 12c using Join, Aggregate, Expression, Filter, Dataset, Pivot, distinct, Lookup, Split and Subquery Filter components. Created Load Plan for deployment in different environment (Test/ Volume Test/ Production) with exception raising error and email confirmation. Scheduling Nightly Load Plan using context and agent.* Customized ODI integration knowledge module based on business logic.* Worked on slowly changing dimensions SCD, Change data capture CDC as part of data warehousing concepts.* Increased ETL performance of loads by implementing the parallelism hints, using indexes, and Analyzing tables.* Golden Gate will be configured to extract and replicate data to the staging layer as transactions happen. Analysis data correctly populate to staging schema based on latest commit sequence number (CSCN) and row sequence ID (RSID) number.* Assist in development of complex ad hoc queries, analysis and replacing transaction tables to data warehouse tables.* Imported the Physicals tables, Primary keys, and foreign keys as per the business requirements. Created star schemas in the repository Used foreign key join in the physical layer to perform relationships between fact and dimensional tables. Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE Administration tool. OBIEE Answers/Analysis, and OBIEE Dashboards.* Added column/data level security at the repository level. The data was restricted with respect to the group user belongs too.

Fairfax, Virginia, United States

* Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support.* Did extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.* Created ODI design documents from the existing PL/SQL code. Used these design documents in development of ODI mapping/packages.* Existing PL/SQL logic converted into ODI logic.* Good understanding of ODI architecture and installation of Topology, Security Manager, agents, Designer, Operator, Master repository and Work repository.* Used Security Manager for managing privileges to the users, set up the Topology including physical architecture, logical architecture and context.* Golden Gate will be configured to push data to the staging layer as transactions happen. Analysis data correctly populate to staging schema based on latest CSCN and RSID number.* Implemented mappings in ODI 12c using Aggregate, Expression, Filter, Dataset, Join, distinct, Lookup and Split components. Created load plan for deployment with exception raising error.* Customized ODI integration knowledge module based on requirements. (Incremental update and slowly changing dimension).* Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment.* Worked on OBIEE semantic layer (RPD) Physical layer adding the connectivity and tables, Business Model and Mapping adding business requirements and Presentation Layer adding report columns.* Data Science and Data Visualization collects, analyzes, and interprets vast amounts of data using analytical, statistical, and programming skills.* Implementing Repository variables as well as system variables as per business requirements.

Danbury, Connecticut, United States

* Gathered ELT requirements from Business team and designed its high level and low-level technical documents.* Design Data integration strategy from JDE and Accustart source systems* Understood Source systems attributes and come up with gap analysis and target system attributes mapping.* Created multiple interfaces to migrate data from JDE system and load them into reporting data mart.* Implemented Advance interface to integrate data from JDE and Accustart systems and loaded them into staging tables.* Created staging, dimensions and fact loading odi packages.* Wrote unit test case to test packages.* Involved in UAT with business and reporting team to make sure that the ETL processes populating correct data.* Analysis of data issue reported by business team and provided its resolutions.* Analyzed current packages and provided suggestion for performance improvement.* Participated in daily stand-up meeting to give update on project tasks.