SUMMARY

• A Seasoned OBIA/ODI Developer and Administrator with 7 years of experience in the analysis, design, prototyping, coding, implementation, maintenance, documentation, dimensional modeling, planning and scoping of Data Warehousing and Business Intelligence Applications.
• Skill set includes BI/BI - Apps Analytics components such as Interactive Dashboard, Answers, BI Reports, BI Publisher, BI Presentation, Adhoc Reports, and custom Analytics.
• Experienced in ODI (Oracle Data Integrator) creating technical design documents and extracting data from DB2, Oracle, Informix, JSON, XML, SQL Servers and flat files etc.
• Interacted with stakeholders at all levels of the organization and has worked in large environments while consulting at Confidential, Confidential and Confidential Corp.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

BI Tools: Oracle BI Suite (OBIEE),Oracle BI Apps

ETL: Oracle Data Integrator ODI / SUNOPSIS,DataStage

RBDMS: DB2, Microsoft Access,MS SQL Server,Oracle8i/9i/10g/11g,Informix

Operating System: ,Windows NT,S/390,UNIX,LINUX.

Programming Language: PL/SQL Programming,Unified Modeling Language (UML),Socket Programming,XML,Crystal Reports,MATLAB,Assembly Language

Methodologies: Software Development Life Cycle(SDLC),Ralph Kimball DW Methodology,Bill Inman DW Methodology

PROFESSIONAL EXPERIENCE

Confidential, Miami

FLBI Consultant

Responsibilities:

• Involved in Installation and configuration of OBIEE, ODI 11.1.7.0 with BI Application 11.1.1.7.0.
• Involved in requirement gathering, Fit-Gap Analysis, creation of Module design document to track functional and technical requirement
• Configure & Customize Out-of-box prebuilt OBIA RPD, web-Catalog, ODI master and work repository for BI Application 11.1.1.7.1
• Configured Source files, lookup files for Oracle Financials, Procurement & Spend, Supply Chain & HR Analytics in BIACM and FSCM.
• Performed functional configuration, Manage data load parameters, reporting parameters, export setup data, Manage Load plan through Configuration manager, functional setup manager and ODI Console.
• Monitored, executed and debugged ETL load on Development through Configuration manager and ODI Console, BIACM, FSCM.
• Developed custom data model for Customer Transaction, Category Management, Sales Support and Pricing subject area in OBIA RPD and Web-catalog.
• Setting up & testing performance parameter in BI Application environment to address performance issue on DEV, TEST and PROD.
• Installed & configured OBIEE 11.1.7.1 with BI Application 7.9.6.4 on Exalytics Development Environment
• Retrofitted all the BI objects post upgrade includes OBIA Repository Metadata, Web catalog, BI Application Configuration files and setting up parameters as per OBIEE 11g .
• Performedupgrade activities for OBIEE Custom RPD and Catalog.
• Configured, upgraded and Merged OBIEE/OBIA custom RPD, Catalog with Out-of-box prebuilt BIAPP7.9.6.4.

Environment: Oracle Data Integrator, OBIEE (OBI Answers, OBI Presentation, AD-Hoc, OBI Publisher, OBI Reports), Oracle E-Business Suite (R12), Oracle BI Apps 7.9. (11.1.1.9.2 And 11.1.1.10.1 ), Oracle GoldenGate, SQL Developer, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, Agile Methodology, PL-SQL Programming.

Confidential, Lombard IL

BI Consultant

Responsibilities:

• Implemented BIAPPS of a new OBIA Financial Analytics, Procurement &Spend, Project environment Analytics.
• Implemented and Integrated PSFT Financial Analytics, Procurement & Spend and Projects
• Responsible for managing the installation, Configuration, Customization and ETL Design, development, testing and deployment of custom ETL solutions for OBIA.
• Worked with functional and BI groups to make sure the ETL design is aligned with business requirements.
• Performed GAP Analysis, Fit Analysis and Customization in OBIA Financial modules and Procurement Modules.
• Built OBIEE Dashboard and Report for Financial, Procurement &Spend, Project Analytics.
• Responsible for build and environmental planning, disaster recovery, environment sizing and client signoffs.
• Function as the ODI expert; guide the team in implementing an optimal and robust ETL solution.
• Configured Oracle BIACM and FSM for BIAPPS functional configuration.
• Built Physical, Business, Presentation model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics platform.
• Mapped presentation layer objects to Oracle BI Answers.
• Configured and Managed OBIEE Catalog manger.
• Organized and animated requirement gathering workshops with end users; define business use cases; realize preliminary studies, functional analysis; realize detailed analysis; define data warehouse loading schemas; write and maintain functional and technical specifications;
• OBI EE and Oracle BI Publisher Training Curriculum and material design; Developer and Key Users training; Oracle BI Publisher Developers supervision; prepare Deliveries Test Plan and scenario.

Environment: Oracle Data Integrator, OBIEE (OBI Answers, OBI Presentation, AD-Hoc, OBI Publisher, OBI Reports), Oracle E-Business Suite (R12), Oracle BI Apps 7.9. (11.1.1.9.2 And 11.1.1.10.1 ), SQL Developer, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, Agile Methodology, PL-SQL Programming.

Confidential, Fairfax VA

ODI Developer

Responsibilities:

• Developed the enterprise BI application with the team usingone or more of Oracle Technologies that include:Oracle Data Integrator (12C),OracleGoldenGate, and PL/SQL.
• Participated in scope definition for code/maintenance releases, decompose user needs into technical requirements, contribute to defining of life-cycle milestones, and interact with internal teams such as Configuration Management, System Testing, and Operations.
• Provided solutions and best practices while building the BI applicationfor questions or concerns raised by internal and external stakeholders.
• Identified, documented, and corrected defects or suggested improvements to the Data Warehouse/Data Mart.
• Reviewed, updated, and maintained documentation on the existing Data Warehouse/Data Mart capabilities. This includes design documents, as well as, logical and physical diagrams.
• Performed analysis of existing Data Warehouse/Data Mart related System Problem Reports (SPRs) and provide recommended solutions and engineering estimates to resolve.
• Identified, evaluated, documented, and reported any data access and security concerns to existing Program Management and Information Assurance.
• Involved in Data Profiling and Data Cleansing activities.
• Created Bi-Directional interface from Legacy system tooracleE-business suite for data Synchronization.
• Installed and configured OracleStreampackagesondatabase forData replication /changeanddata capture.

Environment: Oracle Data Integrator (12C), Toad 9.1, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, Agile Methodology, PL-SQL Programming, Oracle GoldenGate

Confidential, San Francisco CA

OBIEE/ODI Consultant

Responsibilities:

• Worked on Oracle Data Integrator (ODI) 11g version.
• Managed and built ODI repositories and created workflow s in ODI designer.
• Created and maintained interface in a heterogeneous environment.
• Used and modified different ODI knowledge modules.
• Designed and configured the initial ‘folder’ structure / Meta-Model for selected environments.
• Imported the metadata from a selected system into the ODI repository source.
• Export / Import different projects in ODI from Development environment to QA and production environments.
• Create Batch and Real time packages in ODI.
• Create Bi-Directional interface from Legacy system to oracle E-business suit for data Synchronization.
• Install and configure Oracle Stream /Log miner packages on database l for change data capture.
• Performed analysis, design, development, testing and implementation of business required Siebel Analytics Dashboards and reports
• Built business model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Support users of our suite of reporting and analytic tools, which currently include OBIEE 11G, BI Publisher.
• Mapped presentation layer objects to Oracle BI Answers.
• Used BI publisher for static reports and configured IBOT to schedule the BI reports and alerts.
• Created Dashboard, portal, and ad-hoc reports in Oracle BI-presentation services.
• Transform and loaddata to data marts to support the dashboards.
• Built and modified OOTB (Out of the Box) ODI Work Repository for Oracle E-Business suites R12.
• Built and modified OOTB (Out of the box) Load Plans packages, interface and procedures.
• Built and modified OOTB (Out of the box) dashboards and reports.
• Performed data analysis and Design, implement, document (e.g. data models, metadata), and maintain relational (normalized and de-normalized) and multi-dimensional data stores. (i.e. tables, databases, views, data marts).
• Managed the settings, server, web-catalog, log parameter files, promotion of data repositories associated with OBIEE.
• Configuration of Presentation Services and BI Services
• Physical & Logical architecture design understanding in OBIEE
• Wrote stored procedure, trigger, sequences and user functions.
• Delivery of daily/weekly/monthly outbound client extracts.
• Involved in developers training for ODI.
• Trained user for OBIEE reports.
• Over all project delivery and hot fixes.
• Onsite and offshore coordination.
• Resource management

Environment: Oracle Data Integrator, OBIEE (OBI Answers, OBI Presentation, AD-Hoc, OBI Publisher, OBI Reports), Oracle E-Business Suite(R12), Oracle BI Apps 7.9.7.1, Toad 9.1, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, Agile Methodology, PL-SQL Programming.

Confidential, Atlanta GA

OBIEE/ODI Consultant

Responsibilities:

• Migrated master and work repository from SUNOPSIS version to Oracle Data Integrator 10.1.3.
• Worked on Oracle Data Integrator (ODI) / SUNOPSIS Designer, Topology Manager, Operator and Security Manager.
• Managed and built ODI repositories and created workflow s in ODI designer.
• Extract data from CSV file as a source using Database SQLDR capacities into oracle tables
• Created and maintained interface in a heterogeneous environment.
• ManagedOBIEE repository, security setup, system patching/upgrades, migrations of Web Catalog objects (Dashboard, Pages, Folders, Reports).
• Maintained and configured WebLogic to support the Business Intelligence platform
• Designed and configured the initial ‘folder’ structure / Meta-Model for selected environments.
• Developed best in class OBIEE solutions and providing our internal customers with new and existing business enhancements.
• Participated in the design, development, and maintenance of ongoing Analysis and BI Publisher solutions and dashboards to drive key business decisions.
• Developed dashboards, alerts and reporting utilizing OBIEE against Oracle OLAP or DB2 relational data sources.
• Worked in conjunction with Business Analysts to help refine and gather requirements.
• Provided technical support to the OBIEE RPD as well as the Oracle based data mart.
• Delivery of daily/weekly/monthly outbound client extracts.
• Applied data analysis, data quality, and data cleansing methods through XML
• Created dashboards and reports for output of XML data
• Developed XML queries on large XML data stores.
• Involved in developers training for ODI.
• Onsite and offshore coordination.

Environment: Oracle Data Integrator, OBIEE (OBI Answers, OBI Presentation, AD-Hoc, OBI Publisher, OBI Reports),),Oracle OLAP, DB2,Toad 9.1, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, XML,Agile Methodology, PL-SQL Programming

Confidential, Chicago IL

BI Consultant

Responsibilities:

• Worked on Oracle Data Integrator (ODI) / Sunopsis Designer, Topology Manager, Operator and Security Manager.
• Created and maintained interface in a heterogeneous environment.
• Deigned and configured the initial ‘folder’ structure / Meta-Model for selected environments.
• Imported the metadata from a selected system into the ODI repository.
• Involved in Data Profiling and Data Cleansing activities.
• Managed and created materialized views in a production environment.
• Managed and scheduled the agents in different packages.
• Export / Import different projects in ODI from Development environment to QA and production environments.
• Setup the table’s structure in QA and production environment for initial load.
• Provided Siebel expertise in application, integration and technical architecture to the team.
• Implemented Security by creating roles & web groups, checks with External tables & LDAP
• Technical Impact analysis on ETL/OLAP design.
• Mapped presentation layer objects to Oracle BI Answers.
• Used BI publisher for static reports and configured IBOT to schedule the BI reports.
• Created Dashboard, portal, and ad-hoc reports In Oracle BI Presentation services.
• Defined Security Level in OBIEE.
• Managed the catalog manger in OBIEE.
• Wrote database procedure, function, trigger and sequences.
• Managed the clusters in servers.
• Involved with business user in testing, documentation, production troubleshooting and support.
• Involved in developers training for ODI.

Environment: Oracle Data Integrator, OBIEE (OBI Answers, OBI Presentation, AD-Hoc, OBI Publisher, OBI Reports), PeopleSoft Financial, Toad 9.1, Windows XP/2003 PL/SQL, Oracle 10g/11g, SQL Developer, Agile Methodology, PL-SQL Programming

Confidential, Detroit MI

Developer

Responsibilities:

• Analyzed business / systems requirement.
• Completed successful SDLC.
• Designed GUI Using Swing, File menu, jivider, and component.
• Gathered user requirement and document complete business flow diagrams.
• Designed and implemented backup strategy.
• Capacity planning, free space Fragmentation.
• Database auditing and capacity planning.
• Created and monitored the database schema objects.
• Managed physical database structure, database objects, and database usage.
• Managed snapshots and snapshot logs.
• Created and monitored remote distributed SQL statements.
• Created Data Flow Diagrams, Entity Relationship Diagrams.
• Wrote Triggers, Stored procedures, Indexes, and Views.
• Used Crystal Reports to generate financial reports.
• Coordinated complete testing and implementation.
• Documentation, Testing and User training to make system use with efficiency.
• Applied data analysis, data quality, and data cleansing methods through XML
• Developed XML queries on large XML data stores.

Environment: JAVA, Oracle 9i/8i, Borland JBuilder 2005, PL/SQL,XML, TOAD, Microsoft Visio, Crystal Reports