SUMMARY:

• Over 6+ years of professional work experience in designing, developing and successfully delivering large - scale enterprise data warehousing and business intelligence solutions.
• Knowledge and experience in Oracle Retail Data Warehouse(RDW)
• Proficient in writing and optimizing SQL queries
• Knowledge about Oracle database servers
• Knowledge and experience on Oracle Retail Analytics implementation and customization
• Worked extensively in developing ETL (Extract, Transform and Load) for supporting Data Extraction, Transformation and Loading using ODI (Oracle Data Integrator)
• Experience with customizing ETL process of RDW (Retail Data Warehouse)
• Extensive knowledge and experience on complex ETL with ODI package design, development, customization, testing and implementation.
• Extensively used ODI to perform ELT from heterogeneous sources using ODI tools - Topology Manager, Designer, Operator and Security Manger with versions ODI 11g and ODI 12c
• Extensive development experience in Extraction, Transformation and Loading of data from multiple sources such as Oracle, MS SQL Server, Legacy systems, Flat Files into EDW (Enterprise Data Warehouse) system
• Used Topology Manager to define data servers and physical schemas for various sources and target databases
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into dimensions and facts
• Worked extensively with complex interfaces using ODI
• Experience in debugging Interfaces
• Hands on experience on dealing with ODI Knowledge Modules like LKM, IKM, and CKM
• Technical skills in basics of UNIX, and TERADATA
• Experience with OBIEE(Oracle Business Intelligence Enterprise Edition) reporting
• Hands on experience with Micro Strategy reporting
• Experience with reporting using BIP(Business Intelligence Publisher)
• Strong ability to work in team as well as an individual
• Exposure in all stages of systems development life cycle, including requirements gathering, architecture design, coding, testing, tuning, integration, and support
• Provided significant contributions on multiple simultaneous projects with development of ETL and BI reports, while ensuring timely project delivery.
• Conducted new hire knowledge transfer sessions for ETL using ODI tools and the use of business intelligence tools for reporting to senior management.
• Provided 24/7 technical support for clients after projects went live.

TECHNICAL PROFICIENCY:

• Micro Strategy, OBIEE, BI Publisher
• Oracle, Teradata, Netezza, MySQL, Microsoft SQL Server 2017
• C, C++, Java, Python
• SQL
• Oracle Data Integrator (ODI) 11g and 12c
• Simio, Crystal Ball
• Excel, R

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

ODI/ ETL developer

Responsibilities:

• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Developed a new Confidential Enterprise Data Warehouse (EDW) to leverage the business intelligence data library of accelerators for data model, ETL and Teradata elements
• Built extraction and loading scripts with Oracle and Teradata as a backend
• Provided support in Oracle Retail application and technology platform best practices
• Conducted reviews for specifications and code development
• Involved in software program design, development, logical data modeling and physical data modeling using ER studio
• Defined ETL architecture for integrating data at real time and batch processing to populate the Warehouse and implemented it using Oracle Data Integrator 12c
• Involved in Data modeling as well as dimensional modeling of data at all the three levels: conceptual, logical & physical
• Responsible for creating complex mappings according to business requirements
• Created Contexts, Data Server, and both the Physical & Logical Schema in Topology Manager
• Worked on ODI Designer to reverse engineer the datastores under models, create mappings and packages under projects, customize the ODI Knowledge Modules (Loading, Check, Integration, Reverse Engineering) to create mappings to cleanse, load and transform the Data from Sources to Target databases
• Developed, maintained various Procedures, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances
• Used ODI Operator for debugging and viewing the execution details of mappings and packages
• Develop packages for the ODI objects and scheduled them as scenarios
• Managed user privileges using ODI Security Manager
• Supported with test script and scenario development activities
• Participated in system and integration testing, plus unit testing of application modules where needed
• Resolution of technical issues
• Responsible for running batches on daily, weekly and monthly basis
• Provided 24/7 technical support for the client

Environment: Oracle 11g, Teradata, Unix Scripting, Oracle SQL Server, ODI 12c

Confidential, Goleta, CA

OBIEE/ODI developer

Responsibilities:

• Enhanced business transformation with newer Retail Merchandising Analytics (RMA) version that provided a significant improvement in its reporting with addition of the As Is reporting capability. Prepared interactive dashboards and developed multiple reports.
• Built and tested ODI custom packages in the new RMA.
• Responsible for developing OBIEE repository (RPD). Worked closely with ETL team to understand and implement primary key, foreign key and Composition key relationship among physical facts and dimension tables
• Prepare, enhance and configure metadata and data model using OBIEE
• Provided content filtering at BMM (Business Mapping and Modeling) layer of RPD(Repository Development) and used complex joins on logical Table source (LTS) to join tables in BMM layer
• Design Schema /Diagram using Fact, Dimension, Physical, logical Alias and Extension tables
• Developed different Dashboards/Reports with different view (Calculation, Detailed, Pivot, Charts, Filters, drill down) using the Presentation services.
• Created new reports and trouble shoot OBIEE issues at the Report, RPD and made modifications to existing reports, to meet new needs
• Documented Installation Configuration manual
• Managing appropriate security privileges on dashboards according to the business requirements
• Improvising query performance using SQL Query and filters, cache management
• Train the end users (one-one) on reporting using BI answers
• Provided 24/7 technical support for the client

Environment: OBIEE 11g, Oracle 11g, Oracle SQL developer

Confidential, Cranston, RI

ODI/Micro Strategy Developer

Responsibilities:

• Developed complete specifications for required ETL mappings
• Worked with multiple sources such as Relational database, SQL server, Flat files for Extraction, Transforming and Loading data
• Worked on ODI Designer to create Interfaces, procedures, packages and Scenarios to extract the data from multitude of sources, cleaned and loaded into target
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages
• Successfully migrated data from development to production environment
• Developed and maintained project plans to manage scope and estimated delivery schedules on the project
• Created a utility to take the daily backups of the repositories
• Developed reports using Micro Strategy for C-level management requiring business insights for critical decision-making and strategy planning
• Successfully delivered metrics validation

Environment: ODI 11g, Oracle Database 11g, Oracle SQL developer, SQL Server, Micro Strategy

Confidential

ETL / Business Intelligence Developer

Responsibilities:

• Provided significant contributions on multiple simultaneous projects with development of ETL and BI reports, while ensuring timely project delivery.
• Conducted new hire knowledge transfer sessions for ETL using ODI tools and the use of business intelligence tools for reporting to senior management.
• Provided 24/7 technical support for clients after projects went live.

Confidential

ODI developer

Responsibilities:

• Requirements Gathering and Business Analysis. Project coordination, meetings with End User
• Installing ODI 11g and 12c on all the environments and configuring ODI
• Responsible for configuration of Master and Work Repository on Oracle
• Involved in software program design, development, logical data modeling and physical data modeling using ER Studio
• Good understanding of the Data modeling (Dimensional & Relational) and dimension tables modeling of data at all the three levels: view, logical & physical
• Responsible for designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files, Oracle) feeds using ODI
• Responsible for creating complex mappings according to business requirements, which are scheduled through ODI Scheduler
• Support in full legacy to ODI data conversion and Integration task
• Worked on ODI Designer for designing the interfaces, defining the data stores, interfaces and packages, modify the ODI Knowledge Modules (Reverse Engineering, Loading, Check, Integration, Service) to create interfaces to cleanse, load and transform the Data from Sources to Target databases, created mappings and configured multiple agents as per specific project requirements
• Development and design of ODI interface flow for data mapping
• Develop packages for the ODI objects and scheduled them as scenarios
• Develop the customized RMA migration packages in ODI 11g
• Used ODI Operator for debugging and viewing the execution details of interfaces and packages
• Performed the unit testing of the custom packages
• Prepared the release notes to implement the packages in the client's environment
• Prepared the Technical Design Documents from the Korn shell scripts to implement in ODI 12c
• Developed extraction packages from the technical documents in ODI 12c
• Conducted Knowledge Transfer sessions for new hires on use of ODI tool for ETL

Environment: ODI 11g, ODI 12c, Oracle 11g, UNIX scripting

Confidential

ODI/BIP developer

Responsibilities:

• Worked on extraction, loading, transformation using ODI from Oracle, SQL SERVER, and FLAT FILES
• Used ODI Knowledge Modules (Loading, Check, Integration) to create interfaces to cleanse, load and transform the data from Sources to Target
• Identified the Facts and Dimensions based on the design specification
• Created database connection, physical and logical schema using ODI Topology Manager in order to achieve the whole infrastructure. Imported tables from database, developed projects, released scenarios using ODI Designer
• Maintained various Packages, Interfaces, Variables, and Models, which populated the Data into the Target Star Schema on Oracle Instances
• Created source definitions for relational and flat file sources and implemented target definitions based on star schema design
• Migrated mappings from Development to Testing
• Monitored sessions for executions using ODI Operator. Managed user privileges using ODI Security Manager
• Create Data models and Datasets for the reports that need to be implemented
• Create BIP templates (rtf templates in both word and excel)
• Formatting of the template according to the RDD (Report Design Document)

Environment: ODI 11g, Oracle, BI Publisher, Microsoft Office, SQL server

Confidential

ODI/BIP developer

Responsibilities:

• Analyzed the business requirement for ODI and mapped the architecture
• Designed the interfaces to implement ETL strategy to populate the data from various sources based on the requirement
• Scheduled and administered database queries for off hours processing by creating ODI Load plans and maintained schedules
• Created ETL design documents from the existing legacy mappings. Used these design documents in development of ODI interfaces/packages
• Estimated ETL project tasks and helped project manager define scope
• Analyzed data issues reported by production team and provided solutions
• Involved in fine-tuning complex ETL processes for better performance
• Designed RTF template, developed BIP reports and performed job scheduling

Environment: ODI 11g, Oracle 10g, BI Publisher 11.1.1.9.0 , Microsoft Office 2013

Confidential

Oracle Developer

Responsibilities:

• use database concepts for logical/physical schema design and development understand the concept of transactional RDBMS like Oracle use OLTP/OLAP concept in designing data warehouse design and develop Oracle Data Warehouse for analytical and reporting purpose implement the concept of SCD type1, type 2 and Type 3 in designing data warehouse to keep track of current and historical data build strong database analytical skills ptimization of SQL queries use DDL, DML language for defining and modifying Oracle database objects

Environment: Oracle 10g, Oracle SQL developer