Experience Summary

• Highly personable IT Specialist of 5 years of expertise in all aspects of Business Analytics Applications including analysis, design, development, configuration, customization, validation and deployment.
• Ability to analyze and generate application and technical requirements for Oracle BI applications
• Posses functional knowledge of Data Extraction, OLAP processes, data warehousing and data modeling utilizing Oracle AWM
• Created, modified, and administered analytics Intelligence Dashboards with links to web sites HTML text links to documents and embedded content, such as images, text, charts, and tables
• Experience in Configuring Interactive Dashboards with Drill-Down capabilities using Filters and Dashboard prompts, Security Setup groups, access privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector, Tabular with local and global filters using Oracle Business Intelligence Enterprise Edition OBIEE .
• Utilized BI Delivers for sending real-time, personalized alerts via intelligence agents iBots to intelligence dashboards for subscribed users.
• Implemented Security by creating roles web groups, checks with External tables LDAP
• Expertise in debugging and optimizing Analytics Dashboards / Reports.
• Understanding of Software Development Life Cycle SDLC .
• Ability and aptitude in scheduling, tracking and prioritizing activities
• Excellent analytical, interpersonal, problem-solving, trouble-shooting skills
• Ability to set and achieve goals, work well independently or in team, skills in identifying problems and meeting goals
• Familiarity with Oracle Applications including HR, Financials, Supply Chain, Order Management, Procurement and Spend Analytics
• Expertise in utilizing robust organization and analytical thinking skills to successfully meet business objectives completing multiple tasks in a fast paced environment to transition quickly from one request to another.
• Ability to set process improvement goals and priorities and provide guidance for quality processes, while providing a point of reference for appraising current business practices.
• Possess excellent organizational skills, excellent interpersonal communication skills written and oral and be detailed oriented.

Technical Skills

• Business Intelligence Tools: Oracle OBIEE 10g, OBIEE 11g, Oracle OLAP, and Oracle Analytic Workspace Manager
• Databases: Oracle 9i, 10g and 11g Windows XP, NT , Oracle and SQL SERVER database systems
• Middleware: J2EE and Fusion
• Computer Languages: Oracle-PL/SQL, HTML, and XML
• Software: Microsoft Project, Microsoft Office 2000/07, Visio, Adobe Illustrator, Adobe Photoshop, Oracle Application Express, Adobe Acrobat Professional, Adobe Captivate, and Quest TOAD for Oracle
• Concepts: Object Oriented Analysis, Object Oriented Design, Module and System Level Testing, Sales, Software Marketing
• Oracle Applications: HR, Procurement and Spend, Supply Chain and Order Management, Financials

Professional Experience

Confidential

OBIEE Developer/Report Writer

Major Accomplishment:

• Created corporate Award Management Dashboards
• Designed Repository for Corporate Dashboard and Reporting systems

Responsibilities:

• Worked with Functional Analyst and SMEs to interpret requirements to deliver Financial Dashboards
• Utilized unix programming to migrate instances utilizing WinSCP

Confidential

BI Architect

Major Accomplishment:

• Developed Oracle BI Publisher Training Course
• Developed Oracle Applications Data Training Course

Responsibilities:

• Worked with Team to develop Dashboards and Reports for Medical Claims Processing Organization
• Lead Team to develop Strategic plan for implementation of Oracle Data Warehouse
• Corporate Trainer for OBIEE, Publisher and Oracle Apps.

Confidential

Federal Contractor at U.S. Department of Energy

Oracle BIEE Application Developer/ Functional Business Analyst Lead

Department of Energy/ Chief Financial Office

Major Accomplishments:

• Created Corporate Budget Dashboards
• Created CFO Score Cards
• Created CFO Human Resource Dashboard
• Provided Training to CF Directors
• Invited to attend the CFO Conference

Confidential

Created OBIEE 11g showcase using CFO data

Responsibilities:

• Worked with departmental teams to assist in the creation new business model ensuring functional requirements answer the business drivers Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle BI Analytics platform.
• Involved in the detailed design of the reports/dashboards and data model.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Enhance performance by creating Aggregate tables, Indexes and managing cache.
• Modified some of the existing reports and dashboards, and fixing some of the issues related to performance, data quality etc., during production support.
• Created user test cases, and modeling requirements, while participating in reviews of test procedures.
• Participated in quality assurance analysis of new system.
• Created training manuals for BI Answers and Dashboards
• Facilitated implementation of training courses and coordinated training program and trained training team.
• Participated in the installation and configuration of Oracle BI EE 11g in Linux environment.
• Created an OBIEE 11g showcase of 11g features.

Confidential

Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design create a successful financial reporting solutions.
• Created Oracle Application Express Web application to capture Financial Plans.
• Utilized CMMI business practice.
• Trained users on BIEE and APEX Web Application.

Responsibilities:

• Lead Team of developers to develop new Financial reporting tool
• Involved in modifications of physical, business and presentation layers of metadata repository using BI Analytics Administration Tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.

Confidential

Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design create a successful financial reporting solutions.
• Utilized CMMI business practice.
• Dashboard was featured in Government Publication, The Partnership for Public Service

Responsibilities:

• Lead Team of developers to develop new Hiring Process tracking tool
• Involved in modifications of physical, business and presentation layers of metadata repository using BI Analytics Administration Tool.
• Created Testing Plan and Scripts. Implemented a series of testing with group of participants

Confidential

Security Administration-

Major Accomplishments:

• Participated in a RFP process that resulted in a 3 million dollar project.
• Created proposal documentation, participated in vender interviews and presentations.

Confidential

Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design create a successful financial reporting solutions.
• Created Oracle Application Express Web application to capture Financial Plans.
• Created Dashboards and custom Answers queries, utilized OBIEE Delivers iBots
• Created training materials for users on BIEE and APEX Web Application.

Responsibilities:

• Lead Team of developers to develop new Financial reporting tool
• Involved in modifications of physical, business and presentation layers of metadata repository using BI Analytics Administration Tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Created proactive agents iBots and interactive Dashboards to alert the DSW Budget team about business changes.
• Managed security privileges for each subject area and dashboards according to user requirements
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Design Oracle Web Application utilizing Oracle Application Express to incorporate Performance metrics and create Business Intelligence Scorecards

Confidential

Lead Developer-

Major Accomplishments:

• Participated in RFP process to implement a Performance Metrics Web Application and Business Intelligence Scorecards and iBots
• Created Performance Metrics, Accounting and Procurement Scorecards and Dashboards

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle BI Analytics platform.
• Involved in the detailed design of the reports/dashboards and data model.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Enhance performance by creating Aggregate tables, Indexes and managing cache.
• Modified some of the existing reports and dashboards
• Design Oracle Web Application utilizing Oracle Application Express to incorporate Performance metrics and create Business Intelligence Scorecards
• Department of Energy/ Advanced Research Projects Agency-Energy, Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design create a successful financial reporting solution in OBIEE
• Created first Accounting and Procurement Dashboards. System was used to track 400 million in Recovery money.

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle BI Analytics platform.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.

Confidential

Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design and create a successful financial reporting solution in OBIEE
• Created Accounting, HR and Procurement Scorecards and Dashboards for Executive Directors

Responsibilities:

• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions Metadata and Dashboards/Reports using the Oracle BI Analytics platform.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance

Confidential

Lead Developer

Major Accomplishments:

• Captured and translated all requirements, through a variety of interviewing, analysis and facilitation techniques, to design create a successful financial reporting solutions
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Trained directors and users on BIEE Dashboards.

Responsibilities:

• Lead Team of developers to develop new Financial System.
• Involved in modifications of physical, business and presentation layers of metadata repository using BI Analytics Administration Tool.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Developed custom reports/Ad-hoc queries using Answers and assigned them to application specific dashboards.
• Created proactive agents iBots and interactive Dashboards to alert the EIA Budget team about business changes.
• Managed security privileges for each subject area and dashboards according to user requirements

Confidential

QA Analyst/FTL Initiative:

Major Accomplishments:

• Initiative resulted in a 90 productivity increase for the Financial Analysts allowing Wells Fargo to save 50 in overtime costs
• Access Database developed was a groundbreaking business process upgrade resulting in transforming the line of productivity for mortgage companies

Responsibilities

• Participated in test strategy for modifications to existing applications and implementation of new functionality. Utilize RDBMS and SQL Server database systems to manipulate data.
• Implement quality assurance review, implement application test scripts, analyze and track systems issues and work with the Client groups to prioritize issue resolution.
• Performs testing of 3rd party product upgrades.
• Perform System Integration Testing for financial software initiatives and reports the status of issues resolution and testing to the SRG business group and FLT application manager.

Business Systems Analyst/SRG Initiative:

Major Accomplishments:

• Manages a 98 load rate with tier 3 servicers
• Managed 3 Tier one Banks into utilizing web application.

Responsibilities:

• Tier 3 Lead
• Assists VP with strategic planning and implementation of new web application.
• Reviewing and analyzing financial data and determining the soundest direction for the business objective.
• Working in collaboration with Business Operations to implement an auto-load, a ground-breaking endeavor for the corporation.
• Provided ETL support for data files that were received from mortgage companies
• Utilized Data Mapping and Data Mining skills to resolve loading issues