SUMMARY:

• OBIEE / ODI developer with 4+ years of experience in the design and development of Oracle Fusion Applications such as Oracle Data Integrator 11g/12c, OBIEE, SOA Suite 11g, and WebLogic server 10.3.
• Extensive experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE).
• Expertise in designing customized analytical reports and creating Interactive dashboards with drill-down capabilities using OBIEE 12c and 11g
• Good understanding of business requirements and how to translate them into data warehouse dimensional modeling.
• Extensive experience in design, development, testing and production support for Data Warehouse Applications.
• Experience in building Tableau workbooks for weekly reporting by establishing connections to Teradata, Oracle Data Integrator and Excel worksheets.
• Excellent team player with critical, problem solving and integrative thinking skills, capable of working in internal, external, independent and team environments.
• Providing references for users by writing and maintaining user documentation; providing help desk support; training users.
• Worked on Oracle BI components like Clustering, Security, Cache, Usage Tracking, Dimensional Hierarchy, Aggregate Navigation, Variables/Initialization Blocks configuration etc.
• Experience in Dimensional Modeling such as Star and Snowflake schemas.
• Experience in developing Mapping/Interfaces, Packages, Scenarios, Load plans and Job scheduling.
• Complete understanding of ODI architecture and infrastructures like ODI Studio and Runtime components (Agents).
• Sound understanding of Knowledge Modules (KM) like RKM, LKM, CKM, IKM and JKM.
• Acquire data from primary or secondary data sources and the ability of handling data changes such as addition and deletion of fields in the source.
• Identifying operational objectives by studying business functions; gathering information; evaluating output requirements and formats.
• Good Knowledge of dimensional and relational data modeling. The usage of Fact and Dimensional tables to create a star schema or snow-flake data model.
• Experience in using Microsoft Excel and Access for analytical purposes.
• 4+ years of experience in SQL and PLSQL.
• Experience in Tableau Enterprise Environment.
• Hands on experience in MS SQL Server and SSIS Query tuning and performance optimization.
• In depth knowledge on SSIS components and SQL server database architecture

PROFESSIONAL EXPEREINCE:

Confidential, McKinney, TX

Senior Data Integrator/ETL Developer

Responsibilities:

• Experience in Data modeling, Data warehouse and Data mart design in tools like Oracle Business Analytics Warehouse, and/or Microsoft SQL Server.
• Installation and Configuration of Oracle Data Integrator (ODI) software tool in a three-tier Environment, configuration of Master and Work Repository and performed periodic upgrades.
• Responsible for creating Physical & Logical schemas and Contexts for ELT process designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source to target systems (Flat files, Oracle, DB2) feeds using ODI and CDC.
• Worked on ODI Designer to design interfaces, define data stores, interfaces and packages, used and/or modified ODI Knowledge Modules (Reverse Engineering, Journalizing, Loading, Check, Integration, Service) to create interfaces to cleanse, Load and transform Data from source to target databases, create mappings, packages, scenarios & load plans, schedule jobs and configure multiple agents as per specific project requirements.
• Used ODI components for transformations such as Join, Merge, Filter, Expression, Lookup, Modify, Transformer, Change Capture, Funnel and Aggregation like SUM, MIN, and MAX.
• Created PL/SQL stored procedures to retrieve various types of data such as employee details, store details, customer details from databases
• Created Oracle SQL/PL/SQL procedures to Load, Edit, Truncate and Delete tables from source tables to target tables without the use of mappings both at the database level and ODI level.
• Worked on Bulk data loading on Oracle EBS environments and performed troubleshooting and resolving of production issues.
• Designed parallel jobs using various stages like Sequential File, Complex Flat File and ODBC.
• Performed unit, integration, and regression testing of ETL jobs.
• Performed Requirements Gathering and Business Analysis, Project coordination, End User meetings
• Translated business requirements into technical specifications to build the Enterprise Data Warehouse
• Involved in system study analysis for logical/physical data model thereby defining strategy for implementing Star Schema with Fact and Dimension tables.

Confidential, Carrollton, TX

ETL Developer

Responsibilities:

• Perform and troubleshoot ETL processes using various ETL tools such as ODI and SSIS.
• Write SQL queries to automate processes for the analytics department.
• Create and Implement SSIS packages to perform ETL data messaging operations (data profiling, cleansing, and verification).
• Use ODI 11g/12c for extraction, loading and transformation ETL of data in the data warehouse
• Assist in maintaining the database collection system, data informatics and other tasks that optimize efficiency and quality through the Enterprise Data Warehouse
• Create Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Mentor and oversaw the activities of all ETL developers.
• Involved in complete end to end code deployment process in Production.
• Configure Oracle Data integrator ODI Master Repository Work Repository on Oracle Database.
• Performance tuning of targets, sources, mappings, and sessions.
• Develop and maintain ETL (Data Extraction, Transformation and Loading) mappings using ODI and Informatica
• Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle, SQL Server, flat files to the Staging area, EDW and then to the Data Marts.
• Write, debug, and troubleshoot complex SQL queries.
• Created SSIS Packages, and designed database security.
• Modeled business and functional rules/requirements using physical SQL Server database system (MS SQL Server).

Confidential, AL

ODI & OBIEE Developer

Responsibilities:

• Coordinate with business and other IT departments to analyze and in corporate business requirements into ODI design.
• Create and customize ETL integrations using ODI by leveraging Oracle and non-Oracle data sources (like Teradata and Sybase) through database gateway to populate target data warehouses, data marts or Oracle ESSBASE for analytical purposes.
• Build and execute ODI mapping/interfaces, packages and procedures using ODI 12c and 11g.
• Create Physical and Logical schemas, and Contexts for ELT process designing, developing, and testing.
• Create load plans, schedule jobs and configure multiple agents based on project and business specific requirements.
• Apply various Knowledge Modules to Extract, Load and Transform claims and personnel Data.
• Uses ODI CDC (by utilizing JKM) to track changes in source data when running interfaces/mappings.
• Use various ODI components like Joins, Filter, Expression, Lookup and Aggregation (SUM, MIN, MAX) to transform data.
• Develop stored procedures and functions using Oracle SQL developer to improve query performance.
• Perform Bulk data loading on Oracle EBS environments and perform troubleshooting.
• Utilize Control-M to schedule and monitor ODI ETL batch jobs on a daily, weekly or monthly basis.
• Responsible for Data Modeling.
• Work with offshore teams to ensure that deliverables a met.
• Design and developed OBIEE 12c reports and dashboards.
• Design OBIEE data models, perform enhancement tuning, implement security and best practices on dashboards.
• Responsible for building complex financial reports as wells as human resource reports.
• Implement and design OBIEE RPD Physical, BMM and Presentation layers.
• Configure, develop and deploy RPD and Catalog.
• Create interactive dashboard catalog objects.
• Install and configure WebLogic domain.
• Initiate root cause analysis to identify recurring outages and issues on OBIEE.
• Configure LDAP and External DB Authentication for BI applications.
• Clean and Standardize data to meet business requirement using SQL various commands.

Confidential, Dallas, TX

Business Intelligence Analyst

Responsibilities:

• Created data blending in case of merging two different datasets using Tableau
• Extracted, compiled, tracked and analyzed data to generate reports for managements.
• Wrote and run SQL queries in Oracle database and SQL server to analyze and manipulate data.
• Developed Tableau Dashboards with interactive views, trends and drill downs along with user level security to assist end users’ decision making.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Extensively used set analysis to calculate/aggregate the fact data as per the requirements.
• Restricted data for users using Row level security and User filters.
• Analyzed reporting requirements with business users to come up with the technical specifications.
• Created action Filters, Parameters and Calculated Sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool for most of the sales force
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis
• Updated existing and created new reports using Microsoft SQL Server Reporting Services.
• Created role-based dashboards, pages, reports with various views and prompts associated with Security for Users.

Confidential, Irving, TX

Railcar Support Analyst

Responsibilities:

• Analyzed and responded to customer inquiries for railcar repair and maintenance
• Analyzed shop repair estimates and invoices for accuracy and potential cost savings and ensure all billing and repair met the Association of American Railroads (AAR) standards.
• Helped prepare scopes of work and job packets for the facility.
• Developed an understanding of SQL programming and Tableau reporting tool with no prior knowledge and used them to create reports and dashboards.
• Updated existing and created new reports using Microsoft SQL Server Reporting Services.
• Identified areas for operational improvement.