SUMMARY
- Fifteen (15) years of professional experience, which includes more than twelve (12) years of experience in the Oracle Business Intelligence domain.
- Extensive hands on experience in Analytics and Reporting, Dimensional Model Design techniques, Data management techniques, Data Cleansing, Data Integration and ETL techniques.
- Areas of expertise include Enterprise Analytics, Data Warehouse and Application Integrations.
- Experience implementing custom BI projects, Oracle delivered BI Application projects as well as BI extension projects.
- Managed development/delivery teams up to 10 people.
- Responsibilities included requirements gathering, conducting workshops, installation and configuration, integration, development, process set up, training, mentoring, knowledge transfer, offshore co - ordination, team lead and assisting with project management.
- Experience as a successful BI Solution Architect along with strong analytical skills, best practice knowledge, organization skills and leadership abilities.
- Experience with on premise, cloud and hybrid BI implementation and support.
TECHNICAL SKILLS
Oracle Applications: BI Applications (Human Resource, Financials, Projects, Procurement and Spend, Supply Chain & Order Management, Pharma), Oracle Transactional Business Intelligence (OTBI) and OTBI - Enterprise
Application Versions: 7.9.5, 7.9.6.2, 7.9.6.3, 11.1.1.6, 11.1.1.8.1 , 11.1.1.9.2
Technical Skills: BI Strategy/Reporting Strategy and Roadmap Design, Technical Architecture, Custom Data Warehouse
Semantic Layer Design: Dimensional Modeling, ETL (Informatica, Oracle Warehouse Builder, Oracle Data Integrator), Oracle Database 10g, 11g, 12c, Reporting Solutions (Siebel, OBIEE, OTBI, BI PublisherDiscoverer), PL/SQL, DAC, UNIX Shell Scripting, SQL Tuning, Source (Oracle Cloud HCM, Oracle e-Business Suite 11/12, Siebel CRM, JDE, PeopleSoft)
Office: MS Word, MS Power Point, MS Excel, MS Access, MS Projects
PROFESSIONAL EXPERIENCE
Confidential
Senior Solution Architect
Environment: Oracle Transactional Business Intelligence (OTBI) 11g Release 11
Responsibilities:
- Responsible for developing reporting strategy
- Responsible for training business users
- Responsible for providing OTBI best practices
- Responsible to gather and document the reporting requirements
- Responsible for creating custom OTBI reports
Confidential, Washington, DC
BI Solution Architect
Environment: Oracle BI Application 11.1.1.9.2 (HR Analytics, OBIEE11g, ODI 11g), BI Publisher 11g, OTBI, Linux, Oracle 12c, TOAD
Responsibilities:
- Responsible to lead a team of 5 members and assist with Project Management
- Lead workshops for requirement gathering (reports, source data, security and report delivery)
- Responsible for Fit Gap analysis and provide solution for custom reporting
- Define functional and technical specifications
- Develop data models for Performance and GOAL Subject Area
- Develop ODI11g interface and packages to load custom data
- Develop OBIEE repository for extensions
- Develop reports and dashboards using OBIEE Answers
- Responsible for installation and configuration (SSL, SSO)
- Responsible for configuring out of the box reports
- Responsible for data loads using ODI from HCM cloud
- Responsible for creating OTBI dashboard and configure security
- Define and Lead migration process
- Lead UAT sessions, resolve UAT issues and support Post Go-Live
- Provide end user training and knowledge transfer
Confidential, Grand Rapids, MI
Onshore BI Lead
Environment: Oracle Transactional Business Intelligence Enterprise (OTBIE) 11g Release 10, ODI 11g, BIACM, BICC
Responsibilities:
- Responsible for implementing OTBI-E
- Work with Oracle support to get access to required tools
- Configured data loads for fusion HCM extract and Data warehouse
- Resolved data load issues
- Configured the out of box HCM Dashboard
- Prepared OTBI- E Implementation Guide and provided knowledge transfer
Confidential, Northbrook, IL
BI Solution Architect
Environment: Oracle BI Application 7.9.6.3 (Extensions and Custom Subject Area, OBIEE 11g, Informatica 9.x, DAC), SQL Developer
Responsibilities:
- Responsible to lead a team of 6 members and co-ordinate offshore development
- Responsible for requirement gatherings
- Responsible for creating technical specification document
- Responsible to develop custom subject area (OBIEE repository) and dashboards (BI Answers)
- Responsible to create custom Informatica mappings and workflows along with extensions to out of the box mappings
- Responsible for configuring DAC
- Responsible to assist with UAT and migrations
- Responsible to support production issues and assist with Project Management
- Responsible for Knowledge Transfer
