ETL Consultant

Personal summary

 Oracle Data Integrator 11g Certified Implementation Specialist  Active SC Clearance Holder  Currently working as a Senior ODI Test Analyst with Navy Command (MOD), having 22 years of IT experience, in Requirement/Data analysis, Design, Oracle Database/ Data warehouse Architecture, Development, Testing, Relation Data model (3-nf)/Snowflakes/Star Schema Model, Data Migration and Integration, OTBI, SQL, Reporting, T-SQL, PL/SQL, ODI, OBIEE, SSIS, BI Publisher, Tableau, Oracle GoldenGate, Oracle Schema design, Oracle E-business Suite 11i/R12, Hyperion Essbase, SQL/Database/Data warehouse performance tuning, SQL Plus, UML, LINUX/UNIX, Shell scripting, Crystal Reports, & HP Quality centre.  Involved in many full life cycle implementations, Greenfield implementations including obtaining user requirements, architecture, analysis, design, development, Quality Assurance (Reviews & all testing phases), maintenance, support and implementation of application software in the Client/ Server & other large scale applications with system standards for performance and scalability.  Worked in agile development methodology in several projects including the creation of user stories and assigning Story points, Participating in Spring Planning, Daily Stand-up, Review and Retrospective meetings  Worked in other SDLCs like Waterfall, prototyping and other software development processes including unit testing driven approaches & Integration/Test Driven Development approaches.  Understanding the business requirements and modifying the functional specification document.  Carrying out data analysis to generate data mapping specifications document  Creation of Logical and Relational data models  Doing technical design of Data warehouse, dimension and fact tables using Snowflake/star schema structure, source to target mappings, and preparing technical design document.  Creation of Oracle/SQL server objects like tables, views, procedures, stored procedures and functions using T-SQL and PL/SQL programming.  Oracle SQL Performance tuning and Performance tuning of database of larger data volumes using indexes, compression and partitioning etc  Played a key role in various projects incorporating various ODI best practices, approaches and standards  Installation and configuration of ODI 11g, 12c , master and work repositories.  Heavily involved in the customization and configuration of ODI Knowledge Modules RKM, LKM, CKM, IKM as per business need  Maintaining Physical and logical architecture, creating Data servers, Physical Schemas, logical schemas, contexts  Setup Security for accessing ODI by creating groups and users into Security Manager  Creation and configuration of physical and logical agents as Standalone and Java-EE agents  Design, development and execution of ELT programs and batch based solution using ODI Models/data stores, mappings, interfaces, Procedures, Packages, Scenarios and load plans etc using ODI Designer and Topology  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.  Used various ODI Tools and Implemented complex ELT logic using Reusable Mappings.  Scheduling and monitoring of the Scenario and Loadplan runs using ODI Operator Navigator, troubleshooting and fixing any issues found.  Worked on slowly changing dimensions SCD , Change data capture CDC as part of data warehousing concepts  Deployment of ODI Build to various testing environment using ODI Export/Import  Used RCC (Repository consistency check) utility to check consistency of both master and work repositories  Migrating ODI11g interfaces to ODI12c mappings and resolving any issues.  Configuration and Development of ODI processes for various legacy sources and targets like files (Comma delimited, Fixed, Excel spread sheet), XML, RDBMS (Oracle, DB2,SQL Server, Informix, JDE AS400) to get the best performance out  Generating Data Lineage and Flow Map using ODI Console  Assuring Quality by conducting Unit/Integration & Regression testing for ODI development  Delivered nearly 100% bug free ODI code and received loads of appreciation by various clients.  Worked for several clients like Hitachi Capital (UK) plc, Reed Elsevier, Motability Operations, Total Gas and Power, Gala Coral, Ordnance Survey, Experian Limited, Merrill Lynch Investment Managers, Serco Integrated Transport, Skandia, and Indian Air Force.  Proven ability to take up responsibilities and deliver high quality results under adverse situations.  Excellent communication / inter personal skills & capable of maintaining very good client relationship.  Has expertise in quality process initiatives.  Ability to delegate work, lead and motivate a team with Good communication and inter personal skills.  Detail-oriented, multi tasked, learning & organizing skills matched with the ability to manage stress, time & people effectively.

Skills

Oracle Business Intelligence Enterprise Edition Plus (OBIEE+)10 ODI20 Oracle20 ETL20 SQL20