Ayal Vizhi

Project #2 . Payroll : ADECCO India Pvt Ltd Project Title:ATCO Duration:June‘21 toJuly’22 Designation: SoftwareDeveloper Roles and Responsibilities

⮚ Gathered elt requirements from business team and designed its high level and low level technical documents.

⮚ Involved with the odi integrator development and understood source systems attributes and come up with gap analysis and target system attributes mapping.

⮚ Extensive dw experience using oracle data integrator(odi), configured and setup odi, master repository, work repository, projects, models, sources, targets, packages, knowledge modules, interfaces, scenarios,filters,condition,metadata.

⮚ Used oracle data integrator designer(odi) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

⮚ Created master/work repositories, physical/logical schemas, agents, and context into odi topology manager tool.

⮚ Configured odi agents on windows server and tested them to execute and schedule odi scenarios.

⮚ Setup security for accessing odi s/w by creating groups and users into security manager.

⮚ Reverse engineered source and target data stores using reverse engineering knowledge modules.

⮚ Installed and configured odi 12c on windows environments.

⮚ Created and configured odi 12c agent and installed it window services.

⮚ Implemented mappings in odi 12c using aggregate, expression, filter, dataset, join, lookup and split components and implemented odi 12c mapping to load multiple target tables.

⮚ Created and implemented physical data bases from relational and dimensional logical data models.

⮚ Debug the mappings using debugger to resolve code issue.

⮚ Designed interfaces to load data from flat files, csv files into staging area(oracle) and load into oracle data warehouse.

⮚ Export/import interfaces, packages and its scenarios across different environments.

⮚ Created load plans to run the scenarios in a hierarchy of sequential and parallel steps.

⮚ Performed unit and system testing of elt packages.

⮚ Analyzed session log files in operator navigator to resolve errors.

⮚ Mapping and managed session configuration.

⮚ Improved performance and stability of database systems.

⮚ Investigated and implemented solutions for data quality issues.

⮚ Created PL/SQL scripts.

Project#1 Company:TATAConsultancyServices. Payroll : Teamware Solutions ProjectTitle:THREEUK Duration:Mar'19 toMar’21 Designation: Senior Software Developer Roles and Responsibilities

⮚ Good exposure to business domains like telecommunication, Logistics/transport.

⮚ Worked Extensively used ODI(Oracle Data Integrator) to perform ELT from hetero generous sources like using ODI tools - Designer and Operator also good knowledge in Security Manger & TopologyManager.

⮚ Working experience in Creating ODI packages, Load Plans, scenarios, mappings/interfaces, variables, procedures and Topology including physical architecture, logical architecture.

⮚ Created UNIX frame work to control ODI jobs and generate UNIX log files to capture odi session details.

⮚ Schedule ODI Jobs to Control M.

⮚ Good experience in setting up new ODI environment and Migrating Load plans/Scenarios from one environment to another environment with required topology.

⮚ Experience in Extracting data from SAPR/3, SAPBW/BI, Flat file, XML,CSV, Oracle and DB2.

⮚ Analyzing processes and recognizing are as that need improvement.

⮚ Involved in Test Scenarios , Unit & Integration test cases preparation and execution.

⮚ Creating API requests through ODI to move files.

⮚ Creating PL/SQL Packages and Procedures to load Daily/Weekly Ad-hoc Data loads to Data Warehouse.

⮚ Create and schedule Control m via job and MFT to load data from vendor source files to database.

⮚ Sanity check of each report via SQL statements in SQL Developer and physical

⮚ Provide support and fix issues in the PL/SQL packages and ODI mappings.

⮚ Understanding and preparing LLD’s for the requirement and system use cases provided.

⮚ Created various test scenarios and test cases and Performed unit and integration testing.

⮚ Customized knowledge modules to generate desired generic sql code.

⮚ Involved in performance tuning of ODI mappings.

⮚ Involved in Moving and deploying ODI objects in multiple environments.

⮚ Drafted the Technical specification documents along with the architecture diagram in Vision.

⮚ Documentation of every step involved in the process.

⮚ Involved in setting up new ODI Environment and Creating users with required permissions.

⮚ Reverse Engineer source and target models(flat files, XML, Excel, Oracle).

⮚ Developing the Test cases based on the Design document.

⮚ Involved in installation of ODI, Creation of master repository, Creation of Work repository.

⮚ Involved in creation of ODI security settings (User creation, assigning of necessary scenarios and other objects to respective users).

⮚ ODI Topology settings (Creation of Data servers, Physical servers, Logical schema).

⮚ ODI Designer Creation of Models, Projects, Packages, Interfaces, Procedures, scenarios.

⮚ Deploying of scenarios in the execution Repository.

⮚ Gathered Business requirements by interacting with the Business Analysts and the business users and created mockup reports ⮚ Created RPDs, defined Physical Layer, and developed Business Model & Mapping and Presentation Layer using Admin Tool

⮚ Created dimension hierarchies, aggregates, and logical sources in the BMM layer

⮚ Worked on repository variables and session variables

⮚ Used the security settings in the Console and Enterprise Manager to setup users, Groups and Access privileges

⮚ Generated Reports by using Report features like Pivot tables, charts and view selector

⮚ Created Dashboards with Dashboard prompts, Charts, Pivot tables

⮚ Performed Data Validation of data in the reports

⮚ Setup Meta data Objects (Subject Area, Table, Column) security and Data level security.

⮚ Created Physical and Complex Joins.

⮚ Exposed custom attributes in Presentation Layer

⮚ Developed several mappings to load data from multiple sources to data warehouse.

⮚ Created and Developed Custom Styles, Skin, and Messages in Oracle OBIEE 11g Analysis.

⮚ Tested and debugged Oracle PL/SQL packages.