OBJECTIVE:

Seeking a career as a BI Consultant/Admin position to support the Data Warehouse and Business Intelligence needs of the organization making use of my education, skills and experience.

SUMMARY:

• Completed 4 implementation/upgrade OBIEE, OBIA11g, BI Apps/OBIEE 11g, DAC, Informatica projects
• 9 Years of Strong OBIEE/Seibel Analytics/ Informatica, DAC,ODI Dev/Prod Support
• 9 Years of business intelligence/OLAP/OLTP/data mining experience
• Managed Projects for OBIEE/ Informatica, DAC, BIAPPS, OBAW, ODI 11g, 12c, BI Publisher, Axiom
• Proficient in Oracle 10g, 11g DB, DB2, SQL Server, PeopleSoft as Data Sources
• Management experience in Data Warehouse, Integration Efforts, Enterprise Data Management, MDM
• Ability to create DW/BI solutions accommodating all BI and Reporting requirements
• Ability to design Data and Financial Integration/ETL strategy for real - time data replication using Golden Gate
• Developed ELT/ETL in ODI and Informatica Power Center, Designer, Mapping Tools and Workflows
• Administered Oracle Data Relationship Management (DRM)
• OFSAA Data Model Architectue using ERwin tools (PFT, GL Recon, FTP and ALM)
• Integration Specialist of IBM Cast Iron/Mulesoft with SalesForce.com and Oracle EBS/PeopleSoft

TECHNICAL SKILLS:

RDBMS: Oracle 10g,11g, 12c, DB2, Informix, MySQL, SQL Server, Essbase

Operating Systems: Linux, UNIX-Solaris/HP-UX, AIX, Windows 2008R2

GUIs: Oracle Apps 11.i, R12, OEM-Grid Control, Hyperion, Apex-HTML DB, BMC-Remedy, Oracle Fusion Middleware

Management Tools: OBIEE, Informatica, DAC, ODI, Erwin, Axiom, TOAD, Hyperion, Erwin, Fusion Financials, IBM Cast Iron, Visio, SQL*Plus, Shell Scripts, Oracle Golden Gate, MDM, Apex-HTML-DB, BMC-Remedy, SOA, SSO, OID, OAM, OWB, ODI, WebCenter, EBS, OFSAAI, OFSAA, OFSDF, Mulesoft, Oracle DRM, Axiom

Hardware: IBM, Sun, Cisco, Intel, Dell, HP

Languages: SQL, PL/SQL, Abap4, Java, C, C++, Perl, Pro*C, Shell scripts, VB, Java Script, TCL

PROFESSIONAL EXPERIENCE:Confidential, TX

OBIEE, BI Apps, ODI, OFSAA, DAC and Informatica Consultant

Responsibilities:

• Modify SDE, SIL, PLP workflows to meet the customization requirements in ODI, OBIA.
• Managing multiple projects based on On-Site/Off Shore effort model
• Create Repository and Application Design documents
• Create Data Mapping Rules to map data from Source to Target database
• Create Migration Design and Data Analysis documents
• Create Conceptual and Logical Data Models
• Create and manage Federated Queries for sourcing multiples databases
• Prepare Data conversion reports for Data Analysis and Migration (ORCL, PSFT, and SQL)
• Prepare OFSAA/EBS/WebCenter integration with OIBEE
• Create Logical Database Model to be used in the module
• Leading the off-shore development teams in Analysis, Design, Development and implementation of Oracle front-end process using Oracle Developer10g Forms/Reports and Back-end processes (using SQL, PL/SQL (Procedures, Functions, Packages, Triggers, SQL*Loader scripts) for Oracle 11i/R12 EBS

Confidential, Dallas TX

OBIEE Architect

Responsibilities:

• Prepare Data Exception Reports for the Client and the development team
• Liaison with the development team for the migration efforts and resolution of issues
• Create and manage Federated Queries for sourcing multiples databases
• Create Repository and Application Design documents
• Create Logical Database Model to be used in the module
• Create Data Mapping Rules to map data from Source to Target database
• Support development teams in Analysis, Design, Development and implementation of projects
• Create Migration Design and Data Analysis documents
• Create Conceptual and Logical Data Models
• Design and Create Database Models for Data Cleansing and Migration
• Prepare Data conversion reports for Data Analysis and Migration (SAP, ORCL, and SQL)

Confidential, St Louis, MO

OBIEE Oracle Consultant and Oracle Apps DBA

Responsibilities:

• Create Data Mapping Rules to map data from Source to Target database
• Create Migration Design and Data Analysis documents
• Create Conceptual and Logical Data Models
• Design and Create Database Models for Data Cleansing and Migration
• Prepare Data conversion reports for Data Analysis and Migration(SAP, ORCL, PSFT, SQL)
• Prepare Data Exception Reports for the Client and the development team
• Liaison with the development team for the migration efforts and resolution of issues
• Managing multiple projects based on On-Site/Off Shore effort model
• Create Repository and Application Design documents
• Create Logical Database Model to be used in the module
• Leading the off-shore development teams in Analysis, Design, Development and implementation of Oracle front-end process using Oracle Developer10g Forms/Reports and Back-end processes (using SQL, PL/SQL (Procedures, Functions, Packages, Triggers, SQL*Loader scripts) for Oracle 11i/R12 EBS

Confidential, Irving TX

BI Consultant/Oracle Oracle Apps EBS DBA

Responsibilities:

• Prepare Data Exception Reports for the Client and the development team
• Liaison with the development team for the migration efforts and resolution of issues
• Managing multiple projects based on On-Site/Off Shore effort model
• Create Repository and Application Design documents
• Create Logical Database Model to be used in the module
• Create Data Mapping Rules to map data from Source to Target database
• Support development teams in Analysis, Design, Development and implementation of projects
• Create Migration Design and Data Analysis documents
• Create Conceptual and Logical Data Models
• Design and Create Database Models for Data Cleansing and Migration
• Prepare Data conversion reports for Data Analysis and Migration(SAP, ORCL, SQL)