We provide IT Staff Augmentation Services!

Solution Architect Resume

Houston, TX

SUMMARY:

  • Certified Business Intelligence Professional with over 18 years of IT experience in various roles and technologies.
  • Several years of IT consulting experience. Over 10 years of extensive experience with BI Technology including implementation and configuration of prebuilt Oracle BI solution, designing and building custom warehouse solutions, direct connect BI solutions.
  • Over 7 different full life cycle client’s implementation experience as BI Architect for deploying Oracle Business Analytics with Siebel/Oracle CRM, JD Edwards or EBS.
  • Expertise and implementation experience in Financial Analytics, Supply Chain and Order Management Analytics, Proc and Spend Analytics, Project Analytics, Sales Analytics, Marketing Analytics, Transportation Analytics
  • Comprehensive understanding of data warehouse concepts and architecture.
  • Comprehensive understanding and Trained in Big Data - Hadoop, MapReduce, PIG, Hive, HBase, Oozie technologies.
  • Deep understanding of Kimball and Inmon modeling techniques
  • Experience with architecting BI solutions, including custom data warehouse design, data-model design and development.
  • Very good knowledge of complex SQL with any major RDBMS and SQL performance tuning
  • Worked Multiple Direct Connect/Real-Time BI solutions for various customers.
  • Experience with multi-source BI solution.
  • Experience with all areas of Oracle Business Intelligence components. Performed various project roles throughout my career including developer, team lead, Tech Lead, Installation Specialist and Administration, Oracle BI SME, Configuration Expert, Custom warehouse design specialist and Oracle BI Architect.
  • Experience working with BI Security Model - working with weblogic security components(roles and groups), enterprise manager and console. Also experience with data level security for BI using standard security adaptors as well as custom external table authentication.
  • Experience working with Small, Medium as well as corporate level implementations.
  • Experience working in a large size team environment, midsize teams and also worked as Independent contributor for over 20 distinct clients.
  • Strong prioritization and multi-tasking skills with a track record of meeting deadlines
  • Team player, Excellent communication and documentation skills
  • Experience with corporate development and architecture standards, procedures and design/coding best practices including code reviews and mentoring of other developers.
  • Experience with managing and leading Development team(onshore and offshore),
  • Experience with Sales support, writing SOW, Estimation for LOE, Project planning, Demo’s, POC’s, RACI matrix, Using MS Project, etc.
  • Working experience with Scrum Lean Methodology and Agile development
  • Experience working on various industry clients to gain industry specific knowledge - Investment and Trading, Telecom, Sales, Service, Finance, Marketing, Manufacturing, Gaming Industry, Consulting Services, Insurance, Energy, Agriculture/Farming, Defense.
  • OBIEE 10g, OBIEE 11g (All the versions including the latest 11.1.1.7)
  • Worked on several upgrade projects from 10g to 11g
  • Worked on all the version since 7.9.5* including the latest version 7.9.6.4
  • Siebel (all the versions since Siebel 99, Siebel 7 upto Siebel 7.7), Oracle EBS (Supply Chain & OM, Procurement, Oracle Financials) JDE World, JDE E1 (up to version 9.* - for Supply chain Order management, Finance - Custom solutions for Procurement and Spend Analysis, Payroll, labor/HR analysis) Custom sources - Investment and Trading, Finance, HR and Payroll, Insurance processing system, Agricultural Credit union, Manufacturing.

TECHNICAL SKILLS:

Configuration: OBIEE 11g, OBIEE 10g, Oracle BI Applications for EBS, Oracle BI Applications for JD Edwards, Oracle Data Integrator (ODI) 10g and 11g, Oracle BI Publisher, Siebel Analytics, Informatica, Data Warehouse Console.

Server Components: Oracle Middleware Fusion Applications - OBIEE 11g, OBIEE 10g, Oracle BI Apps 7.*, Oracle Data Integrator(E-LT) 10g and 11g, OBIEE 10g and 11g, Oracle Application Server, Weblogic Server 11g, Oracle BI Administration, Oracle DAC, Siebel Analytics Server, DAC Server, Informatica Repository(ETL), Oracle Application Server

Customization: Oracle BI Repository(OBIEE), BI Publisher, IBots(Delivers), Informatica Mappings and Workflows, DAC Configuration, OBIEE Dashboard Reports., OBIEE Security Model, Oracle Data Integrator, Siebel Tools, Siebel VB, Siebel eScriptRDBMS:Oracle 7.x, 8.x, 9i,10g,11g, MS SQL Server 2000, 2005,2008, 2012. IBM DB2 AS/400, MS Access, MySql 5.1

Tools: Informatica 9.* and 10 Designer, Monitor.*,Siebel Analytics,OBIEE Siebel DAC, ODI Designer, ODI Topology Manager, Oracle SQL Developer, SQL Server Management Studio, MySQL Query browser, SQL*Loader, Siebel Tools, JavaScript, Siebel eScriptOperating Systems:Windows NT, XP, Vista, Windows 95/98/00/03, MS-DOS, Linux, Oracle Linux RHEL

WORK EXPERIENCE:

Confidential, Houston, TX

Solution Architect

Environment: OBIEE 11.1.1.7, Informatica v9.1.0 and v10, SQL Server 2012

Responsibilities:

  • Implementing Custom warehouse solution for Investment and strategy analysis tool.
  • Part of huge Business Intelligence team for company’s Multi-year OVID initiative.

Oracle BI Architect

Confidential, San Antonio TX

Responsibilities:

  • Implementing OBIEE and custom data-warehouse solution for Payroll and Labor Analysis

Environment: OBIEE 11.1.1.7, ODI 11g

Confidential

Oracle BI Architect

Responsibilities:

  • Implementing Oracle Business Intelligence Apps for JDE E1 9.0
  • Modules Implemented: Financial Analytics, Custom Proc & Spend, Custom Project Analytics

Environment: OBIEE 11.1.1.6.8 , Informatica v9.1.0, DAC 11g, Oracle BI Applications v 7.9.6.4

Oracle BI Architect

Confidential, Milwaukee, MI

Responsibilities:

  • Installed OBIEE 11g for Oracle Transportation Analytics

Environment: OBIEE 11.1.1.6.8 , OTM (Oracle Transportation Management) as source, Oracle on Linux, ODI 11g.

Oracle BI Architect

Confidential, NYC, NY

Responsibilities:

  • Implementing Oracle Business Intelligence Apps for JDE E1 9.0
  • Modules Implemented: Financial Analytics, Supply Chain and Order Management Analytics

Environment: OBIEE 11.1.1.6.7 , Informatica v9.0.1, DAC 10.1.3.4, Oracle BI Applications v 7.9.6.3, Oracle on Linux, Oracle On-Demand environment.

Oracle BI Architect

Confidential, Baltimore, MD

Responsibilities:

  • Upgrade of Informatica 8.6.1 to 9.0.1 and OBIEE 10g to 11.1.1.6

Environment: OBIEE 11.1.1.6.2 , Informatica v9.0.1., DAC 10.1..3.4, Oracle BI Applications v 7.9.6.3, Oracle 11g on Windows

Oracle BI Architect

Confidential, Chicago, IL

Responsibilities:

  • Upgrade from 10g to 11g and implementing new 11g features to financial reports for EBS R12

Environment: OBIEE 11.1.1.6.2 , Informatica v9.0.1., DAC 10.1..3.4, Oracle BI Applications v 7.9.6.3, Oracle 11g on Linux

Oracle BI Architect

Confidential, La Grange/Atlanta, GA

Responsibilities:

  • Implementing Oracle Business Intelligence Apps for JDE E1 9.0
  • Modules Implemented: Financial Analytics
  • Supply Chain and Order Management Analytics

Environment: OBIEE 11.1.1.6.2 , Informatica v9.0.1, DAC 10.1..3.4, Oracle BI Applications v 7.9.6.3, DB2 on AS-400 and DB2 on Windows

Confidential

Oracle BI Architect

Environment: OBIEE 11g, 10.1.*, Oracle Data Integrator 10g and 11g, Informatica, DAC, Oracle BI Applications, MS SQL Server 2000, 2005 and 2008 MySql 5.1, Oracle 10g, 11g

Responsibilities:

  • Independently Implemented the Accelerate solutions for over 10 clients and assisted other consultants for over 15 Accelerate implementations.
  • BI Architect
  • OBIA 7.9.6.3
  • OBIEE 11.1.1.5
  • Informatica 9.0.1

Hire Now