We provide IT Staff Augmentation Services!

Senior Solution Architect Resume

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

Hire Now