PROFESSIONAL SUMMARY:

• An OBIEE Developer and BI Analyst with over ten (10) years experience in IT and seven (7) years of Business Analysis analyzing and documenting requirements, designing, developing, and implementing Oracle Business Intelligence Enterprise Edition (OBIEE) 10g/11g; Proficiency in data integration processes; Expertise in using OBIEE tools to create Intuitive Reports, Interactive Dashboards, and Deliverables, Skilled in providing Unit, Peer, and User Acceptance Tests (UAT), trouble shooting, and performance tuning through aggregation, cache mechanisms and indexing; Knowledge of SQL Server to generate and maintain tables, indexes, views, functions, schedule jobs, query the database, and monitor performance. Knowledge of Oracle E - Business Suite for ERP Financials to improve performance and efficiency as well as to reduce operational costs;
• Work independently and/or as part of a team with minimal supervision and guidance; Effectively prioritize workload to meet deadlines and work objectives; Solution driven, Problem solver; Ability to assess performance and make sound decisions; Great time management skills; Ability to work under pressure; Ability to pay attention to detail; Excellent communication skills--verbal, written, as well as presentation with demonstrated ability to write clearly, succinctly, and in a manner that appeals to a wide audience; Disciplined and dependable with outstanding ability to build customer relationships; Focused, independent, and goal-oriented.
• Solid understanding of Oracle BI overview, architecture including BI best practices,
• Provide Key business stakeholders with operational support on existing and newly developed reports and BI Analytics.
• Skilled in developing robust intuitive meta data layers of the RPD and deliver custom reports and dashboards,
• Highly skilled in all phases of the System Development Life Cycle (SDLC) from understanding business requirements gathering, to functional and technical specifications, to solution production, to testing, and monitoring,
• Proficiency in analyzing requirements and converting requirements from functional documents and technical designs.
• Ability to perform impact analysis, solution design and build modules and unit test codes,
• Ability to perform Data manipulation and Modeling including ETL and OLAP using ODI and Informatica applications.
• Ability to model the OBIEE Repository (Physical, Business Model Mapping, and Presentation) Layers, and configure the MUD (Multi-User Development),
• Proficiency in designing Business Models, star and snowflakes Schemas, Dimensional Hierarchies, Logical Columns, Level Based Measures, Time Series, Reports, Dashboard, Prompts, and Ad Hoc reporting capabilities,
• Ability to create Single and Multiple Table Sources, provide both natural and complex joins, and create user friendly, intuitive reports, interactive dashboard, and deliverable--variables, guided navigation, prompts, filters, master detail reports, and agents to provide real-time intelligence,
• Ability to use SQL to generate queries, views, functions, set indexes, scheduled jobs, and execute ad hoc queries as needed,
• Ability to use Variable Manager and initialization blocks to define session and repository variables, streamline tasks, and modify metadata content,
• Ability to utilize pre-built and customized Business Intelligence modules (OBIA) such as Oracle E-Business Suite to design and implement ERP Financials,
• Skilled in end -to -end build out analytical tools to support various business goals delivery such as ad hoc reports including materialized views,
• Solid knowledge of Key Performance Indicators (KPIs) and scorecards, including creating and enhancing data visualization to include maps, trellis, pivot tables, graphs, and maps,
• Knowledge of trouble shooting and performance tuning using cache, aggregation, and indexing as well as configuring data and object level security in both LDAP and External Database Tables,
• Ability to provide unit, peer, and User Acceptance for product quality assurance.

TECHNICAL SKILLS:

Business Intelligence Tool: OBIEE Tool, Databases Oracle 10/10g, Oracle SQL Developer, Oracle Data Integration and Informatica (ODI) (OLTP, ETL, OLAP)Oracle Business Intelligence Applications: Oracle E-Business Suite, Oracle Release 11r2;

Languages: SQL, PL SQL, JavaScript, HTML, XML WindowsMicrosoft Business Tools: MS Project, SQL Server SQL Azure, Power BI, and Visio for Unified Modeling Language (UML)Methodologies: Software Development Life Cycle (SDLC), Agile /Scrum, and Waterfall

WORK EXPERIENCE:

Confidential

OBIEE Developer and Reports Architect

• Analyze business requirements, organize plan layout, and design Functional and Technical Requirements Documents using MS Visio,
• Design data models using star/snowflake data modeling schema and worked with administrators and users to manage reporting requirements,
• Support data administrators to install, upgrade, and configure ETL using Oracle BI tools,
• Create OBI Repository (Physical, Business Mapping and Modeling, Presentation) layers, and develop reports and dashboards,
• Configure level based measures, hierarchies and mapping to multiple logical table sources,
• Perform Data manipulation and Modeling ETL, OLAP using ODI and Informatica applications,
• Create conditional formatting, schedule agents, configure filters and send out timely alerts,
• Configure BI features such caching, write back, aggregation, sorting, and conditional formatting,
• Support Unit, Peer, and User Acceptance Testing for quality assurance.

Confidential, Rochester, PA

OBIEE-Developer. Project Team Lead

• Analyzed project requirements, designed, and developed the plan layout,
• Designed data models using star/snowflake data modeling schema,
• Worked with administrators and users to manage reporting requirements,
• Performed ETL, dimensional modeling in OBIEE, and ETL using Informatica,
• Identified production faults and critical issues that followed and troubleshoot them And Developed and deployed dashboards, analytics and interactive reports,
• Prepared and ensured scheduled monthly reports are presented to management on Various devices such as mobile phones and web browsers,
• Used SQL Server to generate queries, views, functions, set indexes, and scheduled jobs.
• Execute ad hoc queries as needed and provided performance tuning to process.

Confidential, Oklahoma

OBIEE Developer

• Analyzed data sources and carried out ETL using Informatica to populate the external database
• Developed Oracle BI Metadata repository using BI Administration tool,
• Developed Dashboards and Reports in OBIEE AS per the reporting specifications,
• Configured Initialization Blocks, Repository and Session Variables for filters and security,
• Created Hierarchies, Levels, and implemented Business Logic by creating level based measures in OBIEE business model & mapping layer,
• Developed time comparison using time functions—To Date, Ago and Period Rolling,
• Used Filters and provided Prompts appropriately to make interactive reports and to avoid excessive data showing up on Reports,
• Created presentation layer catalog folders for different views of the business model,
• Applied SQL to generate and maintain tables, indexes, views, functions, stored process, and as well as query database to perform scheduled jobs).

Confidential, Dallas, TX

BI Mortgage Analyst

• Interacted with Subject Matter Experts and IT to define business and functional specifications,
• Monitored and documented change requests to ensure requirements were met,
• Executed data collection, cleaning, transformation, modeling, and uploading
• Performed data Integration, OTLP, ETL, OLAP, modeling using Informatica and SQL Server
• Translated requirements into business, functional and use case documents,
• Created Flowcharts, User Stories, and Context diagrams;
• Defined the Business and Functional Business Requirements Documents;
• Worked with QA team and developers to clarify/resolve issues and provided feedback,
• Ensured logical and physical data models are developed in line with standards and guidelines.
• Created Use Case Specifications and UM diagrams including Use Case Activity.