SUMMARY

• Confidential has over 20 years of work experience with many large firms such as Confidential
• He has experience as a Lead OBIEE Architect, Lead Enterprise Architect, Data Architect, Sr. OBIEE BIAPPS Developer/Analyst, Lead Oracle Apps DBA, Technical Team Lead, Project Manager, Systems and ERP Architect, OBIEE Technical Lead, OBIEE Administrator, IT Operations Manager, Functional Analyst and Course Instructor.

TECHNICAL SKILLS

Enterprise Architect: Lead Oracle Apps DBA, BIApps/OBIA, OBIEE Admin, Data Architect, Course Instructor, Divisional Level Management, Data Modeling

ERP Implementation: DWH Architect/Analyst, Operations Manager, Oracle Apps 11i, 12

System Architect: Performance Tuning, SQL Server, Data Warehouse, Hyperion, Noetix, Oracle RAC, BI APPS Install, Sales Proposals, Oracle 9i, 10g, 11g, 12c

Hardware: HP, Sun, Intel, Macs, Alpha, Storage Arrays, SANS

Operating Systems: UNIX (HP, Linux, AIX, Sun Solaris, DEC - Alpha) Windows

DBs: Oracle, Informix, SQL Server, Access, Teradata, Hyperion\Essbase, DB2

Systems: EPM, PeopleSoft, Oracle EBS, BAAN, JBA, MRAS, HFM, SAP

PROFESSIONAL EXPERIENCE

Lead Architect & Analyst

Confidential, Buffalo Grove, IL

Responsibilities:

• Directed performance-tuning effort for multiple Production systems.
• Produced technical plan for system wide tuning which included Oracle RDBMS, Oracle PL/SQL, AIX VM server.
• The systems include DB2, Oracle and SQL Server based.
• Created Performance tuning test plan, baseline performance Test Plan.
• Created project plan and engaged multiple teams.
• Ran explain plans and gave direction to architecture and SQL execution re-writes.

Lead OBIEE/OBIA/ETL(ELT) Application Architect & Analyst

Confidential, Silicon Valley CA

Responsibilities:

• Designed custom ERD logical and physical models via ERwin for BIAPPS subject area - Star Schema utilizing Financial Analytics, Project Analytics and OIC Oracle Incentive Analytics Subject areas.
• Created ODI ELT specifications for EBS R12 to BIAPPS 11.1.1.7 source to target (data lineage) mappings.
• Technical lead for BI APPS and ETL offshore team.
• Designed physical, BMM layer and presentation layer of the BIAPPS RPD modules.
• Interviewed business team and created specifications.
• Created custom SQL and views to map EBSR12 data to the BIAPPS DWH via DB links.
• Created custom SQL statements for use in ETL/ELT to utilize TCA Architecture to PA, AR, OE/OM and SC modules.
• Gave demos to user community and gathered feedback and scope impact.

Technical Team Lead

Confidential, Deerfield IL

Responsibilities:

• Hands-On Tech Lead of team to implement the first centralized Financials System for Confidential.
• The project was the first corporate wide EBS\BI Apps\OBIEE implementation at Confidential in an Exalytics \Exadata environment.
• The modules included Project Analytics and Financial Analytics.
• Personally performed many hands-on roles such as System & Data Architect, Essbase Administrator, Exalytics Admin, OBIEE Admin & Developer, Weblogic Admin, Times Ten Admin, OEM Admin, System performance tuning. Lead Architect for Corporate wide Financials Data Warehouse.
• Performed the Configuration Manager (BIACM) & Functional Setup Manager (FSM) of BI APPS. Installed OBIEE, BI APPS, Essbase and ODI. Tuned ODI BI APPS Loads. Implemented SSO / SSL.
• Implemented row level security.
• Performed Web Logic tuning.
• Performed Essbase Tuning. Performed OBIEE tuning. Performed DHW database tuning. Performed Exadata SQL tuning.
• Performed Exalytics tuning. Performed OBIEE, Essbase, DB migrations.
• Perform role as top level production support.
• Performed training classes for Exalytics, Essbase, OBIEE, BI APPS.
• Responsible for 22 BI APPS environments.
• Performed vertical scaling of OBIEE and Web Logic. Executed, monitored and resolved ODI BI APPS Load Plans.
• Integrated OBIEE with multiple Essbase ASO cubes.
• Created logical and physical Architecture design that included Exalytics, Exadata Oracle Database, WebLogic, EBS, BI APPS, Times Ten, Essbase, SSO, SSL.
• Hands on OBIEE Developer made custom changes to the OBIEE RPD repository. Built Oracle database and Essbase Cubes with OBIEE solution.

Technical Lead

Confidential

Responsibilities:

• Responsible for defining the corporate wide reporting strategy.
• Performed the role as system architect and data architect for corporate wide reporting/data warehouse solution.
• Team tech lead responsible for all EBS and BI APPS reporting, responsible for delivering 200 custom reports.
• Architect, Implementer, developer OBIA / BI APPS 7.9.6.4 Financial Analytics, Procurement and Spend Analytics, Human Resources Analytics, Product Lifecycle Analytics, Supply Chain and Order Management Analytics and Projects Analytics.
• Executed ETL via ODI 11.1.1.7. the BI APPS modules were installed with Informatica/DAC, management changed course to ODI later in the life cycle.
• Architect that produced physical and logical data warehouse ERD/data models.
• System wide Reporting physical architecture.
• Developer that personally completed over 40 OBIEE reports and multiple dashboards in an EBS R12 environment.
• Responsible for interviewing users and defining the Functional and Technical Specifications.
• Personally, created an executive dashboard for the CFO with multiple metrics that sourced EBS R12 via Noetix Views.