Profile ELT and BI developer with 6.4 years of experience inData Warehousingdomain. Proficient in ODI, OBIEE, IBM Info sphere, SAP BI. Knowledge in PLSQL, SQL. Experiencein Financial reporting domain and HR Project 4 ODI & OAC Developer

• Designed, developedODI(OracleData Integrator)objects for ETL Project, gathering requirement specification documents.

• Involved in optimization techniques for to Increase run time performance and Load Plan executions

• Created the KPI’s as per the requirement on OAC. . Internal Associate, Cognizant Technology Solutions, Chennai Apr’16 – July’21 ASSIGNMENTS Project 3 ODI Developer

• Designed, developed ODI(OracleData Integrator) objectsforETLProject, gathering requirement specification documents and presenting and identifying data sources.

• Worked on ODIDesigner to create Interfaces, procedures, packages and Scenarios to extract the data from multitudeof sources, cleaned and loaded into target.

• Designed and developed interfaces to load the data from multiple sources like Relational databases, flat files(.txt, .csv) into Oracle Database • Created data model, Tables, Indexes,Views, Materialized views, Synonyms, Sequences for betterperformanceof theDB. • Created reusable mappings to implement inmain mappings.

• Implemented Change DataCapture(CDC)featureof ODIto refreshthe datain EnterpriseDataWarehouse(EDW).

• Implemented datatransformationstrategies by usingLKM,RKM, IKM,CKM and JKM Knowledge modules

• Knowledge on Admin Activities

• Worked closely withBusinessAnalystin understanding theAnalytical requirements and generated reports as perthe userspecifications.

• Populated theindicators by implementing businessrules,measuring the overall accuracyof thedata by setting up data quality rules

• Employ best practicesfordesign,development,unit testing and test plan development Project 2 OBIEE Developer

• Worked as an OBIEE developerfor developing dash boards.

• Created and maintained dashboards using different design styles like, linking dashboards, linkingdashboard pages, using appropriatepromptson different pages.

• Gathered business requirementsfortheFinance project by coordinating with BusinessAnalysts and data warehousing teammembers

• Worked in designing and developing the RPD

• Worked in creating theReusable templates

• Involved in SQLPerformance tuning whenreports ran slow.

• Create documents, process flows and architecture diagrams related to Planning Solutions developed

• Provide support toclients, including dataanalysis, discovering and fixingdata issues, and assisting withOBIEEdashboard/reportingquestions toend usersand trained the users inAnalysis creation. Project 1 SAP BI 4.1 Admin & Developer

• Design and develop canned and Adhocreports as perthebusiness requirements

• Design, develop, maintainand optimize theUniverses using Designermodule

• Employ best practicesfordesign,development,unit testing and test plan development

• Good technical background in networking, operating system,system administration and performance monitoring