SUMMARY

• 9+ years of IT experience in Requirements gathering, Analysis, Design, Development, Implementation, Modeling, Testing and support for Data warehousing applications.
• Extensive DW/ETL 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.
• Experienced in ETL/ODI solution architecting, configuring, designing, development, and implementation (12C, 11g & 10g), and have a strong understanding on WebLogic as an Application server.
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Experienced working on Cloud Platform (Workday) and SAAS integration tolls like Dell Boomi
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Staging of operational sources using ELT processes and providing data mining features for data warehouses, and Scheduling.
• Experienced on creating BI reports in different subject areas, critical analysis and upgrade of the existing reports.
• Worked on BI Reporting tools like OBIEE, BIRT, Tableau, Cognos .
• Very good in Debugging, Optimizing the Analytics Dashboards/ Reports and Performance Tuning of Oracle BI / Siebel Analytical Dashboards / Reports.
• Extensive understanding on Oracle EBS and BI pre - build RPD s (Financial, HR, Sales, Supply Chain and Order Management, Marketing Analytics, etc.) and ETL Mappings according to business requirements. worked on Oracle Data Integrator (ODI) to reduce the dependency on Excel and other proprietary tools for data entry and reporting, and provide property and department level budgeting/forecasting so as to produce a consolidated budget and forecast.
• Expert in installing and configuring the Oracle Data Integrator (ODI) software tool in a three-tier environment and performing periodic upgrades, performing source-to-target mappings, storage capacity planning, developing ETL.
• Possess clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL/ELT and life cycle development Using Oracle Data Integrator (Repository Manager, Designer, Load Plan Generator and Operator).
• Worked on Slowly Changing Dimensions and its implementation to keep track of Historical data.
• Actively involved in Performance Tuning, Error handling and production support for various projects.
• Implemented different Caching techniques to improve the performance of BI server.
• Experienced in troubleshooting installation issues, production issues and production support for projects.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data
• Extensive experience in building Interactive Dashboards with drill-down, drill-across capabilities using global, local Filters, Guided Navigation, Business rules, selection steps, prompts, etc.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Experience in UNIX working environment, writing shell scripts for ODI pre & post session operations.
• Experienced on working actively with State/Government Clients.
• Strong knowledge and working experience on Simple Object Access Protocol (SOAP ) and Representational State Transfer (REST ) web services.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS

BI TOOLS (Infrastructure & Applications): OBIEE 10g/11g/12C, BI publisher 10g/11g, EBS Financial, OBIA R12, 7.9.6.3, 7.9.6.1(Financial Analytics, HR Analytics, Sales, Service, Apache BIRT, Marketing, Supply Chain, Manufacturing, Procurement.)

ETL TOOLS: ODI 12C/11g/10g, DAC 10.1.3.4.1 , Informatica Power Center 9x

DATA BASES/ RDBMS: Oracle 12c/11g/10g/9i/8i, SQL Server, DB2 UDB, TOAD, MS-Access, AS 400, Hyperion System 9

OPERATING SYSTEMS: MS Windows 10, 8.x, 7,xp, Vista, UNIX, Mac OS X, Linux, Solaris

LANGUAGES & Web Technologies: SQL, PL/SQL, XML, UNIX Shell Scripting, Java,JVS, C++,C, HTML/XHTML.

ERP / Applications Servers: Oracle Applications 11i & R12, Oracle Web Logic Server 10.3.5, 11g,12C, IBM Curam

METHODOLOGIES: Software Development Life Cycle(SDLC)- Waterfall Model, Agile, Rational Unified Process(RUP), JIRA(Ticket tracking)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. ODI/ETL Developer & Admin

Responsibilities:

• Involved in Analysis of the Project requirements.
• Working on ETLs process to extract data from various source systems and build oracle data ware house.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Create ODI Variables and used it into ODI interface, Procedure and Packages.
• Performed loading from flat files, CSV and XML files to Oracle tables.
• Installed and configured the Oracle Data Integrator (ODI).
• Identifying bottlenecks and tuned the complex ODI Interfaces for optimized performance.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Working with business team, Architect Designer, Test Team, BI Team to finalize some exist ETLs updates, and build new ETLs for the upcoming, overall to get the project flows. working with Off shore/On site team, and coordinate teams for the better.

Environment: Oracle Data Integrator (ODI) 12c, Oracle RDBMS R12, SQL/PL Sql, Agile, Scrum, Jira, Shell/DOS Scrips, MS Windows. OBIEE, Tableau V 2019, Oracle SIA, Workday Cloud Platform, SVN.

Confidential, Rochester, NY

Sr. ODI/ETL Developer & Admin

Responsibilities:

• Worked with business analysts, developers, and management, Testers, BI Reporters, and Modeler professionals from various locations to gather requirements and bring them to the end point DW .
• Built Data Warehouse in line with Star Schema methodology for analytic purpose.
• Architected and Implemented ETL routines using ODI.
• Installed and configured (Master and Work Repositories, ODI agents).
• Maintained DEV, TST, QA, and PRD environments.
• Maintained Topology connections in all environments.
• Maintained User's security in all environments.
• Migrated the packages, scenarios from one repository to another repository.
• Created numerous Mapping to load data from XML Files, Flat files, CSV files, and Oracle tables into staging tables and then into respective FACT/DIMENSION/Look-up Tables in the Data Warehouse.
• Implemented serial vs parallel data loading in ODI, and created Load plans for accordingly.
• Used ODI in-built scheduler to schedule Scenarios/Load Plan's in production.
• Implemented slowly changing dimensions (SCD) in various Mappings.
• Utilized ODI in-built Journalizing (J$ tables) methodology to manage and maintain Change Data Capture (CDC) from source data.
• Analyzed Session log files in operator navigator to resolve errors in mapping and managed session configuration.
• Created numerous data validation scripts using SQL, which were used by the Team (post ODI data loads) to validate the data brought into DW.
• Conducted UAT session with Business Users.
• Created numerous Views, Materialized Views, Stored Procedures, Synonyms, DB Link, Sequences, and which were used in ODI (during data load) and Cognos/Tableau (post ODI data loads and while building BI Reports).
• Conducted training session for both Administrators as well as End Users.
• Troubleshoot with the Files/records to make sure the right files/records as expected.
• Worked with the Workday Cloud Platform Team to get the right structure of the records/Files.
• Worked with SAAS Integration tool, Dell Boomi, to integrate between WorkDay Cloud platform, and DW(ODI).
• Worked with Dell Boomi to load some files from Cloud to use for ODI and DW .
• Worked with Tableau Team to identify the BI reports are fine as per ETL loads.
• Used Tableau and Cognos to cross check ODI loads with Report visualization.
• Troubleshoot the ODI/ETL jobs/run/build in all different technical environment to fix something quicker ways .
• Coordinating with the Off shore/On site Team as Senior/Lead ETL.
• Maintained Agile/Scrum meeting everyday along with others business/technical metings.
• Other tasks included were documenting ODI Installation and Configuration process, Design and Technical documentation for the developed ETL processes.

Environment: Oracle Data Integrator (ODI) 12c, Oracle RDBMS R12, SQL/PL Sql, Agile, Scrum, Jira, Shell/DOS Scrips, MS Windows. IBM Cognos, Tableau V 2019, Dell Boomi, Workday Cloud Platform, GIT Kraken.

Confidential

Sr. ODI/ETL Developer & Admin

Responsibilities:

• Work with Oracle Extract, Transform and load ( ETL ) methods and tools (Oracle Data Integrator ODI ) to extract data from outside sources, transform it to Fit an organization’s business needs to load it into a target such as a organizations data warehouse or application database.
• Perform Data Mapping & Transformation, demonstrate skills and experience in architecting, designing, implementing, testing, reviewing, and operating applications and solutions that implement Data Mapping & transformation technologies and techniques.
• Handle Requirements Analysis, Provide skill to requirements analysis which may include defining applications, their capabilities and support.
• Develop Data Conversion & Migrations, Provide skills and expertise relates to the design and building of solutions that convert and move data from one system to another during the development of a new or existing system; typically complicated transformation that has cleansing and mapping issues.
• Develop Shell/Dos Command for UNIX/Linux and Windows machine to process, test, perform, execute, and load files to build Data Warehousing through Oracle Data Integrator ( ODI ).
• Develop and maintain ETL objects; such as packages, procedures, variables, mappings, load plans, schedulers etc. in oracle fusion middleware; such as ODI as ETL tools.
• Develop Complex SQL/PL sql objects such DB links, Packages, Procedures, Functions, Sequences, Index, Constraints, Tables, views, Synonyms, Explain plan, kill sessions, Trigger etc.
• Develop PL sql/SQL reports, batch process run, DB performance tuning.
• Use JIRA ticketing and follow Agile Scrum (methodology/ framework) to manage project/tasks.
• Develop of oracle fusion middleware ; such as ODI for ETL jobs/batch process.
• Work with DBAs , Data Architects, Application Team, Infrastructure team, and network team for application deployments and User acceptance tests and solution s.
• Develop and design RDBMS Logical and Physical data modeling in Oracle Data Modeler that facilitates and enhances communication between data architects, database administrators, application developers and users, and simplifies the process itself.
• Develop Data warehouse using Oracle RDBMS server, and create RDBMS objects such as; create, read, update and delete back-end data, and batch process etc.
• Work on SQL loader utilities.
• Used Shell and Dos command to figure out the Files, records, directories, and troubleshoot the .bad files/records.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Create ODI Variables and used it into ODI interface, Procedure and Packages
• Create ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Create Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Create Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Use Refresh, Set and Evaluate ODI variables types into ODI Packages
• Create Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrate Code from Development to Testing to production.
• Create Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Identify and fixed bottlenecks and tuned the complex ODI Interfaces for optimized
• Use ODI (Oracle Data Integrator) designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed, and create CDC (Change Data Capture) and SCD (Slowly Changing Dimensions) to keep up History records and live updated records.
• Communicate/follow the (NC State) clients/business/team for support in work flow, tests and new projects solution.
• Actively worked on SVN (subversion) to store and analyze jobs/code activities.
• Create Report throughout SQL and BIRT (Business Intelligence and Reporting Tools) for Business and App Dev Team for side by side test and high level info.
• Worked on the set up and migrating of ODI 11g & 12C studio.

Environment: Oracle Data Integrator (ODI) 12c, Oracle RDBMS R12, SQL/PL Sql, Agile, Scrum, Jira, Shell/DOS Scrips, MS Windows. IBM Curam. BIRT Eclipse 4.4.

Confidential, Franklin, TN

Sr. ETL/ODI Developer & Administrator

Responsibilities:

• Involved in Analysis of the Project requirements.
• Worked on ETLs process to extract data from various source systems and build oracle data ware house.
• Involved in the Installation and Migrating of ODI 11g & 12C.
• Performed loading from flat files, CSV and XML files to Oracle in Dev. UAT and Prod Environment.
• Worked on SQL loader utilities.
• Used Shell Scripting to figure out the Files, records, directories, and troubleshoot the .bad files/records.
• Created and Designed (ODI/ETL) Data Load process across the clients.
• Created ODI Package of various complexity and automated process data flow
• Configured the testing environment and process to export and Import ODI Objects into the Testing and Production (Execution) environment
• Performed source to Staging and staging to target mapping specifications and developed ETL / ODI code for the same.
• Created Topology connection for reading xml logs and writing into oracle db.
• Created ODI Interfaces for reading data from xml using external properties and loaded into staging table.
• Created ODI Interfaces to load data into ODS for downstream systems.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Used Refresh, Set and Evaluate ODI variables types into ODI Packages
• Created Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrated Code from Development to Testing to production.
• Created Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Identified and fixed bottlenecks and tuned the complex ODI Batches/Load plans and Scenarios for optimized performance.
• Troubleshoot the break & fix production issues, and created Service now ticket as well.
• Supported clients for any kinds of production & data Load issues.
• Created xml jdbc, .dtd, and loaded (.xml) files into the table, and .xls files.
• Created Unix Shell Scripts and SQL procedures.
• Maintained Agile to keep work flow updated.
• Invoke third party web services, and convert base64 files into asci and loaded into tables.

Environment: ODI 12C, 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12, UNIX, Agile, MS windows, SOaPUi

Confidential

Sr. ETL/ODI Developer & Administrator

Responsibilities:

• Responsible for developing & administrating the ELT processes using Oracle Data Integrator (ODI).
• Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Develop complex interfaces to load the data from the various sources into dimensions and facts.
• Testing and fixing the bugs in the interfaces and migrating them to stage and production environments.
• Participating in team planning sessions.
• Loaded Data from Oracle cloud (ICM) by calling SOAP/REST API.
• Created ODI Package of various complexity and automated process data flow
• Created ODI Interfaces to load data into ODS for downstream systems
• Gathered ELT requirements from Business team and designed its high level documents.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
• Debug the mappings using debugger to resolve code issue.
• Worked in importing data from heterogeneous data sources like Flat files, AS 400, MDMS, Hybris,database, XML files, excel etc.
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Migrated Code from Development to Testing to production.
• Involved in Unit testing, User Acceptance Testing and System Testing to verify accuracy and completeness of ETL process, Prepared & documented unit test plans
• Created ODI jobs to replicate the existing process of SQL scripts Created ODI Interfaces with simple to complex transformation rules while migrating from Source to the target.
• Conducted thorough Unit Testing, System Integration testing, UAT, MTP and Production Support Co - ordination effectively.
• Used PLSQL Developer for running SQL queries.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Teradata, MS Access, and Flat files.
• Performed Data Validation of data in the reports and dashboards.
• Customized the Oracle stored procedures to aggregate the data into different metrics based on Business Unit using PL/SQL.

Environment: ODI 12C, 11.1.1.7, 11.1.1.9, OBIA 11g, OBIEE 12c, RDBMS Oracle 12C, 11g, Toad (12.5, 11.x), PL SQL. EBS R12. DB2, SOAPui.

Confidential, Irvine, CA

Sr. ODI Developer & Administrator

Responsibilities:

• Analyzed business requirements of the project and wrote technical specs for the implementation.
• Involved in the Installation and Migrating of ODI 11g & 12C.
• Created test cases for end to end and rated testing of ELT Packages.
• (Execution) environment Performed source to Staging and staging to target mapping specifications and developed ETL / ELT ODI code for the same
• Created ODI Interfaces to load data into dimension and fact tables for billing data mart.
• Installed and configured the Oracle Data Integrator (ODI) software tool in a three - tier environment and performing periodic upgrades, performing source-to-target mappings.
• Created Logical Tables, Logical Columns and calculated measures and metrics as per the business need.
• Created complex requirements like Dimension hierarchies, time comparisons and share measures along with ranks.
• Created and involved on creation of Views, Functions, Procedures and Packages in PL/SQL for ODI process.
• Identified and fixed bottlenecks and tuned the complex ODI Interfaces for optimized performance.
• Effectively interacted with the users for requirement gathering and performed GAP analysis.
• Created Master/Work repositories, Physical/Logical schemas, Agents, and Context into ODI Topology Manager Tool.
• Discover and model dependencies between Oracle Data Integrator (ODI) and various components such as databases or other Oracle Fusion Middleware products automatically using the Oracle Enterprise Manager Cloud Control framework
• Used ODI 11.1.1.7.x designer and implemented knowledge modules like LKM, IKM, CKM, RKM and JKM when needed.
• Created complex Interfaces and implemented Slowly Changing Dimensions (Type 1, Type 2 and Type 3) for data loads.
• Created Interfaces to implement one time as well as Incremental loads.
• Used Interface Variables, Interface Parameters and Session Parameters to increase the re-usability of the Interfaces.
• Implemented performance tuning logic on targets, sources, interfaces, sessions to provide maximum efficiency and performance.
• Included the custom mappings in DAC Execution plan.
• Used ODI knowledge modules to implement SCD logic and Update logic.
• Developed load plans using Load Plan Generator and monitored the results using ODI Operator.

Environment: OBIA (11g,12.0.0), ODI 12c, 11g, OBIEE 12c, 12C/11g, Oracle 12c/11g, SQL Developer, Toad 10.x, PLSQL, EBS R12.

Confidential, Norfolk, VA

ODI/OBIEE Developer

Responsibilities:

• Gathered requirements from the customer, designed the technical specs and technical documentation, developed Interfaces and Workflows as per the business requirement, tested the application and deployed it to production.
• Built the Interfaces with ODI 11g Designer using transformations like Source Qualifier, Expression, Filter, Router, Joiner, Sequence developer, Update Strategy, Lookup, Sorter, Aggregator, Normalizer, XML Source Qualifier, Stored procedures.
• Extensively worked with Slowly Changing Dimensions Type1 and Type2 for Data Loads and Data Transformations.
• Conducted data investigations and assisted the business partners with complex data analysis and ad - hoc queries
• Used BI Publisher and created complex pivot table reports and cross-tabular reports using connected queries of data models with parameters passed from data model as well as parameters.
• Created Dashboards with Dashboard prompts, Charts, Pivot tables.
• Performed Data Validation of data in the reports and dashboards.
• Created iBots to send pre-processed reports using OBIEE Delivers.
• Monitor Oracle Data Integrator (ODI) components availability and performance out-of-the box; access historical data, track logs, and receive notifications of potential problems.
• Conducted thorough Unit Testing, System Integration testing, UAT and Production Support Co-ordination effectively.
• Worked in the development of OLAP Databases and Structures used in the Health Care sector.
• Extracted data from various heterogeneous sources like Oracle, SQL Server, DB2, MS Access, and Flat files.
• Responsible for creating interfaces, procedures, packages and load plans using ODI and monitored the workflow run and statistic properties on ODI Operator.
• Involved in Performance tuning for sources, targets, interfaces and sessions.

Environment: OBIA, ODI 11.1.1.7, Oracle 11g, ODI 11g, OBIEE 11.1.1.7

Confidential, Billerica, MA

ODI/ETL Consultant

Responsibilities:

• Created several ODI Interfaces to implement Business Logic with ODI Graphical (Designer, Topology Manager, Operator, and Security Manager) & Knowledge modules (Reverse - engineering, Journalizing, Loading, Check, Integration and Service).
• Responsible for issue resolution and performance tuning of ODI Interfaces.
• Created Source and Target systems physical and logical data server connections into ODI Topology Manager
• Created ODI Variables and used it into ODI interface, Procedure and Packages
• Created ODI Interfaces using LKM, CKM & IKM Knowledge Modules.
• Created Interfaces to load data from source systems to staging area, staging area to dimension and fact tables of Target
• Created Process flows using ODI Packages for loading data from source system to staging area, staging area to dimension and fact tables
• Used Refresh, Set and Evaluate ODI variables types into ODI Packages
• Created Scenarios of ODI Packages for migrating code into Prod execution repository
• Migrated Code from Development to Testing to production.
• Participated in the weekly meeting to structure the timelines for the project.
• Documented the data loading scenarios in Oracle Data Integrator (ODI).
• Performed Unit, Integration and Regression testing to validate reports and data.
• Implementation of the logic and developing the Reports, and Gap Analysis and Data Sanity Check.
• Taking up the calls with the users/customers for gathering the change requests and feedback on the resolved defects

Environment: OBIEE 11.1.1.7/10.1.3.4 , SQL, Oracle 11g, Toad, MS VISIO,ODI 11g, EBS 11.