SUMMARY:

• Over 9 Years of Experience in Data Modeling, Data warehousing, ETL and Business Intelligence Development.
• Certified in both OBIEE11g and OBIA implementations
• Experience with Oracle Analytics Cloud
• Strong working experience in OBIEE 12C and in the process of learning OAC
• Expertise in implementing and supporting versions of Oracle Business Intelligence Applications.
• Extensive experience with OBIA 7963 and 7964 with Informatica for Data Integration
• Development of ODI Mappings, Stored Procedures, Packages, scenarios and Load Plans.
• Extensive Informatica PowerCenter development experience
• Working knowledge of OBIEE 12C end to end development in a POC environment
• Extensive OBIEE experience spanning across multiple versions from 10g to 12C
• Experience working with OBIEE Administration Tool developing the Physical, BMM and Presentation Layers

TECHNICAL SKILLS:

Data warehousing: Oracle Business Intelligence Applications 7.9.6.3/4, Informatica PowerCenter 9.5.1/9.01/8.6

BI Tools: OBIEE/OBIFS 10.1.3.4.1/11.1.5.0/ 11.1.6.0/11.1.7.0, Oracle Essbase / Smart View 11g

Databases: Oracle 12C/11g/10g MS SQL Server 2008/2005, MySQL

Languages: HTML, XML, Maxl Scripting, SQL and working knowledge of PL/SQL

Operating System: Windows 10/XP Professional, MS Windows 2003/2008 Server, Solaris, Lunux Redhat

Other Tools: MS Visual, IBM Rational Tools, PVCS, Mercury Quality Center, MS Sharepoint, Scrumwise.

DB Tools: Oracle Database 12C, 11g,10g, SQL*Plus, SQL Developer, TOAD 10.5/ 10.6./11 g

Testing Tools: IBM Rational ClearCase/ClearQuest/Cherwell

ERP: Oracle EBS on 12C./11g Databases, Peoplesoft Enterprise, Cobra, EBS R1213, Asset Suite 8

WORK EXPERIENCE:

Confidential, Westminster, Colorado

Sr. IT Systems Analyst

• Functions as a liaison between IT Technical resources and the Project Management Office (PMO).
• Leads a diverse team of developers and Business Analysts from various functional groups per the PMO’s service group project management model
• Attend weekly resource planning meetings with Project Managers to go over forecasted resource allocation projections
• Works with IT Project Management Office to resolve resource conflicts across all service groups.
• Organize meetings with stakeholders on a regular basis to provide updates on ticket progress, prioritize work, identify issues and identify new project proposals.
• Collaborate with project managers to track and report status of key efforts to the organization
• Creates an environment of Oracle BI self - service ensuring easy access of data from disparate source systems.
• Designs, develops and tests high quality Extract, Transform and load (ETL) processes using Informatica PowerCenter.
• Troubleshoot data integration issues and bugs analyzing reasons for failure and implement optimal solutions and revise procedures as needed.
• Create dashboards and visualizations displaying information that is actionable across the enterprise
• Engages and Supports the User community on data analytics through regular data governance meetings
• Current leading a project to integrate OBIEE with Microsoft Active Directory authentication
• Utilizes WebLogic Server Enterprise Manager to define Application Roles which facilitate the Integration of OBIEE with external authenticator
• Supports end to end Requirements in an OBIA 7.9.6.3 environment which features OBIEE 11.1.1.7 and DAC10g integrated with Informatica 9.0.1.
• Currently supports two out of the box reporting modules namely Financial Analytics and HR Analytics
• Translates business requirements and rules into technical designs and solutions in a timely manner.
• Utilizes best practices to test and deploy changes from lower environments to Production
• Responsible for Systems Administration of the three major components of OBIA including OBIEE 11g, Informatica PowerCenter 9.0.1 and Oracle Business Intelligence Data Warehouse Administration Console (DAC) 10g.
• Modified the instanceconfig.xml to increase the amount of downloadable rows of data out of OBIEE.
• Coordinates with Database Administrators on performance tuning of the Data Extract process.
• Manages schedule BI Publisher Reports that go out on the daily and weekly basis per requirements from the User community.
• Support OBIEE 11g Usage Tracking Subject Area to help management keep track of BI utilization across the Organization

Confidential, McHenry, Illinois

Sr. Oracle Business Intelligence Developer (Permanent Role)

• Interacted with Company Executives, Managers and End Users to gather business requirements strategize on overall BI Adoption.
• Developed and supported a high visibility Daily Sales Report which showcased high level KPIs and forecast metrics
• Provided projected Sales to business Users by utilizing PLSQL functions to figure out Billing and Shipping Days within any given month based on Gregorian calendar.
• Worked with DBAs to upgrade Oracle Databases from 11g to 12C to improve reporting Performance.
• Worked on OBIEE security Integration with Oracle Financials as the ERP System of Records.
• Support end to end Requirements in an OBIA 7.9.6.4 environment which features OBIEE 11.1.1.7 and DAC11g integrated with Informatica 9.5.1.
• Currently supports two out of the box reporting modules namely Financial Analytics and Supply Chain and Order Management Analytics SCOM
• Optimized both ETL and Report Dashboard performance by range partitioning three main transactional Fact Table in the supply chain (SCOM) module of the prebuilt data warehouse.
• Created Query and ETL Bitmap Indexes to improve performance on both the frontend and backend processes.
• Developed PL/SQL procedures, for dropping/creating Bitmap Indexes before and after ETL data loads.
• Translates business requirements and rules into technical designs and solutions in a timely manner per SLAs.
• Creates standard custom reports in BI Answers and BIP publisher and present them to internal customers via scheduled Jobs and Dashboards
• .Collaborates with systems administrator to set up Object level Security which is used to control access to BI Metadata through the Administration tool and Presentation Services.
• Manages Data level security through data filters in Oracle Essbase for some Dashboard in our OBIFS.
• Responsible for all data integration requirements using Informatica Power Center 9.5.1 and Oracle Essbase.
• Extensive knowledge of Extracting, transforming, and loading of Data (ETL) from EBS R1213 as the main Data Source.
• In charge of the Administration of the three major components of OBIA including OBIEE 11g, Informatica PowerCenter 9.5.1 and Oracle Business Intelligence Data Warehouse Administration Console (DAC) 11g.
• Uses WebLogic Server Enterprise Manager to define Application Roles which facilitate the Integration OBIEE with Active Directory.
• Integrates Essbase Security in OBIEE via Enterprise Manager.
• Performs various types of customizations and extensions for modifying the Oracle Business Analytics Warehouse (OBAW) metadata Objects.
• Developed configuration and change management process which mirror the one already in place in the Source System (EBS).
• Modified the instanceconfig.xml to increase the amount of downloadable rows of data out of OBIEE.
• Coordinates with Database Administrators on performance tuning of the Data Extract process.
• Manages schedule BI Publisher Reports that go out on the daily and weekly basis per requirements from the User community.
• Closely work with Oracle Support through Metalink to fine tune data loading process.
• Provides training to new business Users to familiarize them with OBIEE 11g front end prior to granting them access to the Tool.
• Implemented OBIEE 11g Analytics Usage to help management keep track of BI utilization across the Enterprise

Confidential, Ashburn, VA

OBIA Consultant (Contract)

Responsibilities:

• Interacted with end users through regular meetings to gather business requirements.
• Worked on OBIEE security Integration with Oracle Financials (EBS).
• Worked on requirements for all the configured modules which included Financial Analytics, Procurement and Spend Projects Analytics and Supply Chain and Order Management Analytics.
• Translated business requirements and rules into optimal technical designs and specifications.
• Utilized PL/SQL procedures and DB links to integrate security authorization of OBIEE Users via EBS R1213
• Managed OBIEE/EBS Responsibilities by using PLSQL via Toad.
• Created custom reports in BI Answers and published them onto Dashboards as a way of presenting the reports to internal customers.
• Set up two levels of Security: Object level security was used to control access to Metadata through the Administration tool and Presentation Services.
• Managed Data level security through an Authorization Stored Procedure to restrict end user access to report contents.
• Extensive knowledge of Extracting, transforming, and loading of Data (ETL) from Oracle's EBS R1213 ERP and legacy systems into the Oracle Business Analytics Warehouse (OBAW)
• Extensive knowledge of the three major components of OBIA including OBIEE 11g, Informatica PowerCenter 9.01 and Oracle Business Intelligence Data Warehouse Administration Console (DAC) 10g.
• Used WebLogic Server Enterprise Manager to define Application Roles from EBS in OBIEE.
• Utilized Identity Manager of the OBI Administration tool to assign Users appropriate permissions to the OBIEE Metadata Repository.
• Experience with various types of customizations for modifying the Oracle Business Analytics metadata Objects.
• Extensively used the Oracle Process Manager and Notification Server (OPMN) domain from both the Command line and the Enterprise Manager change Center (GUI) to start and stop BI system components including OBIS, OBIPS, OBISCH, OBIJH and OBICCS.
• Participated in regular internal meetings to help define OBIEE Migration Process.
• Developed custom mappings to aid the understanding of how to extract data from Oracle PeopleSoft enterprise source system and other disparate sources to populate the OBAW
• Deployed OBIEE Metadata Dictionary through WebLogic Server Administration Console to enable internal Customers understand the origin of data elements.
• Created a global default Header and Footer for new Analyses to standardize all queries created by BIAuthors across all OBIEE environments.
• Modified the instanceconfig.xml file using Enterprise Manager to customize the amount of downloadable rows of data out of OBIEE.
• Coordinated with Database Administrators by submitting requests and following up on Database and OBI performance issues.
• Involved in generating and publishing standard reports to the User Community from old Data Warehouse.
• Interacted with Oracle Support through Metalink to follow up on pending Service Requests
• Provided training to functional Subject Matter Experts to familiarize them with OBIEE 11g front end components emphasizing the use of pivot tables.
• Implemented OBIEE 11g Analytics Usage Model to help management keep track of usage statistics and have a handle on identifying slow running queries.

Confidential, Tysons Corner, VA

Senior Associate (Contract at NSF)

Responsibilities:

• Maintained and Supported OBIEE 11.1.1.6.0 environment closely following Agile as the project Life Cycle methodology.
• Created objects such as Tables, Views, materialized views, Indexes, and synonyms to help support a custom data warehouse which was the OLAP source for OBIEE.
• Validated source system data with the staging data using SQL and Pl/SQL scripts
• Involved in Sprint Planning by going over project backlog to prioritize Deliverables for the four week Sprints.
• Interacted with various Team Members through daily Tag Ups as a way to maintain team momentum and identify potential issues (Blockers) early on in the Sprint.
• Created project daily tasks and publish them on the team Burndown chart to help management track Sprint Progress.
• Interacted with Technical Lead on a regular basis to address client specific needs as part of routine production support.
• Translated business requirements and rules into optimal technical designs and implement them by modeling a dimensionally consistent RPD.
• Helped with the patching efforts to upgrade OBIEE 11.1.1.6.0 to OBIEE 11.1.1.6.5 by applying OBI Bundle patch.
• Led the effort to implement OBIEE Multiuser Development Environment (MUDE) as part of the Change management Process which will integrate IBM Rational Tool Set.
• Installed and configured OBIEE 11g client tools to facilitate the implementation of the MUDE.
• Involved in the Migration OBIEE Artifacts including Web Catalog and Metadata repository changes from both Development to Acceptance and Acceptance to Production deployments every Sprint.
• Based on Business requirements suggests innovative solutions for the OBIEE semantic and presentation layers to support adhoc reporting and analysis.
• Helped design and develop standard reports and dashboards to serve both as a starting point for report authors and landing page into the OBIEE production environment.
• Participated in creating proof of concept for the BI environment with the Data warehousing Team to design optimal dimensional design for the BI environment.
• Coordinated with other project teams to understand requirements and figure out strategies to bring in new data elements and help launch new functionalities.
• Added calculated measures to the existing attributes by creating derived columns to enhance the reporting platform of various Departments.
• Used WebLogic Server Administration Console to help define the security model by creating Users and assign them to Groups and appropriate Application roles.
• Applied various types of customizations for modifying the Oracle Business Analytics metadata Objects..
• Configured OBIEE 11g Usage Tracking to help Project management keep track of usage statistics and have a handle on potential performance issues.
• Deploy enhancements to the BI environment by prioritizing customer requested features and functionalities.

Confidential, Lexington, SC

OBIEE Analyst (Contract at SRNS)

Responsibilities:

• Exposure to various reporting modules including Financial Analytics, Supply Chain and Management Analytics and Projects Analytics.
• Interacted with business Users regularly to gather functional business requirements.
• Provided near real-time data by utilizing database Triggers and loops to facilitate increment data updates throughout production business hours.
• Developed working knowledge of the OBIA 7.9.6.3 Configured with OBIEE 11.1.1.5.0 on windows server 2008 environment.
• Upgraded OBIEE10g Repository to OBIEE11g to provide solutions for functional business requirements..
• Created custom reports in BI Answers and published them onto Dashboards as a way of presenting the reports to internal customers.
• Experience with two levels of Security: Object level security was used to control access to Metadata through the Administration tool and Presentation Services. Data level security was used to restrict end user access to report contents.
• Working knowledge of Extracting, transforming, and loading of Data (ETL) from Oracle's PeopleSoft ERP and legacy systems into the Oracle Business Analytics Warehouse (OBAW).
• Used WebLogic Server Administration Console to define Users and assign them to Groups and appropriate Application roles to help manage security.
• Utilized Oracle Enterprise Manager to manage Application Roles that were created from WebLogic
• Used the Identity Manager of the OBI Administration tool to assign Users appropriate permissions to the OBIEE Metadata Repository.
• Familiarity with various types of customizations for modifying the Oracle Business Analytics metadata Objects.
• Extensively used the Oracle Process Manager and Notification Server (OPMN) domain from both the Command line and the Enterprise Manager change Center (GUI) to start and stop BI system components including OBIS, OBIPS, OBISCH, OBIJH and OBICCS.
• Participated in internal workshops designed for interaction with the business community to help gather business requirements based on changing business needs.
• Deployed OBIEE Metadata Dictionary through WebLogic Server Administration Console to enable internal Customers understand the origin of data elements.
• Worked on a global default Header and Footer for new Analyses to standardize all queries created by BIAuthors across all OBIEE environments.
• Modified the instanceconfig.xml file using Enterprise Manager to customize the amount of downloadable rows of data out of OBIEE.
• Collaborated with team lead from client side on migrating standard reports from legacy systems
• Interacted with Oracle Support through Metalink to follow up on pending Service Requests
• Attended periodic training sessions for regular and super end-users to familiarize them with OBIEE 11g front end components emphasizing the use of pivot tables.
• Deployed OBIEE 11g Analytics Usage Model to help management keep track of usage statistics and have a handle on identifying slow running queries.
• Created a custom Data Dictionary to help user Map OBIEE Answers and Dashboard Objects back to the OLTP System by using OBIA 7.9.6.2 Datalineage and Informatica Mappings.