SUMMARY

• Over 19+ years of rich experience in IT and over 12 years of expertise in Oracle BI EE and Oracle BI Apps implementations. Expertise in implementing Big Dat a Projects(using Hadoop 2.X Hive,MapReduce), Oracle BI Apps and OBIEE11g on Exalytics especially Oracle Utility Analytics, Siebel Sales, Service, Sales Force dot com, Oracle Finance, HRMS, iExpense, Procure to Pay (PTP), Fixed Assets, Demand Planning, Forecasting and Supply Chain domains
• Over 1 9 + years of work experience in Information Technology.
• Expert in setting up OBIEE 11g on Exalytics server architecture.
• Expert in setting up overall Oracle Business Intelligence Architecture.
• Expert in setting up overall Oracle Business Intelligence Apps (OBIAPPS) - EBS based analytics
• Expert in implementing Oracle Business Intelligence Best Practices.
• Expert in implementing Oracle Life Sciences Products (ePharma, Medical & Clinical Applications).
• Expert in implementing Business Process Management for Business Intelligence.
• Expert in Creating Business Cases / Proof of Concepts for BI implementations.
• Expert in Project Management from Initiation, Design, Develop, Deploy and End (IDDDE).
• Implemented 30+ Projects using different applications and technologies.
• Lead Business Analyst for all Siebel Analytics Projects.
• Highly motivated, with strong analytical, communication and interpersonal skills.
• Strong leadership and entrepreneurial skills.
• Confident and poised in interactions with all individuals at all levels.
• Detail-oriented and resourceful in completing complex projects.
• Exceptionally well organized and initiative to achieve both personal and corporate goals.
• Passionate about converting complex issues into simple.
• Very Knowledgeable in setting up Big Data Architecture.(Data Nodes, Name Nodes)

TECHNICAL SKILLS

ETL Tools: ODI 10g, ODI 11g, Hadoop 2.7. MapReduce.Hive,Informatica (Power Center 9.5.1/9.0.1/8.6 ) Informatica Cloud,DAC (7.9.4, 7.9.5,7.9.6 and 10.1.3.4, 10.1.3.4.1 )

OBIEE/OBI Apps: OBI EE 10.x,11g,12c, Exalytics X2 Oracle BI Apps 11.1.1.7, 7.9.4/7.9.5/7.9.6 & Siebel Analytics (7.8).

OBI Apps Modules: Siebel Sales, Call Center, Finance, Oracle Finance, Supply Chain, Demand Planning, Forecasting, Fixed Assets, iExpenses, PTP (Procure to Pay), HRMS & Saleforce.com

ERP: People Soft (HRMS&Finance) (7.5), PeolpeTools(7.5),People Code, SQR.

CRM: SiebelCallCenter (7.8/7.7./7.0/6.3 ),Siebel eFinance

Siebel Tools: (7.8/7.7/7.0.4/6.2.1 ), SiebelVB/COM,eFinance.

Databases: Golden Gate, Oracle 9i/10g/11g, Teradata SQL Server2000/2005, Db2V8,V9

Operating Systems: MS Windows XP/NT/2000/98, Linux,UNIX (Solaris/ AIX/ HP)

Application Servers: IIS, OC4J, Tomcat,Weblogic

PROFESSIONAL EXPERIENCE

Confidential

OBIEE ETL Architect

Responsibilities:

• Performance tuning on complex BI Publisher Reports
• Create Complex reports based on CC&B data.using BI Publisher and OBIEE dashboards.
• Created Customer Care reports like Delinquent Account report, SONP Reports etc
• Created Accounting reports to validate AR, GL and BILLING and Financial Transactions.
• Created Position Management Dashboard for HR,Dept Heads and CEO.
• Configure and Set Up Department wise security
• Setup and configure LDAP(Microsoft AD) to support SSO.
• Create Complex RTF and Excel templates to create BI Publisher Reports
• Converted 10g OBIEE Dashboards to 11g OBIEE Dashboards.
• Followed the SOX compliance Change Order process to Migrate Dev to Test to Prod
• Used SourceSafe to Version Control of reports
• Very good understanding of CC&B business processes
• Quality Assurance support for all the Customer Info reports.
• User and Production Support

Environment: OBIEE 10g/11g,BI Publisher 11g on Windows Servers, Oracle DB 11g on Linux,, Confidential &B 2.4.2 on Linux.

Confidential, Milwaukee,WI

OBI ETL Architect

Responsibilities:

• Plan and implement OBIEE 11g System Consolidation Strategy.
• Install,Setup and Configure Horizontal Scaleout of OBIEE 11g to support BIG IP F5 Load Balancer for High Availability OBIEE system to support 3 OBIEE Implementations on two linux servers.
• Saved Time and Resources to support Production Environment.
• Minimized the complications in routine Production support.
• Improved performance by recommending optimum Memory and Space.
• Created the production support document of new consolidated environment which helps the clients sys admins to start and stop OBIEE Servers and OPMN services.
• Resolved all the port conflicts
• Setup LDAP security for EU OBIEE and EBS SSO integration FOR ADTi OBIEE

Environment: OBIEE 11g (11.1.1.1.7 ) on Linux Server (6.X), Oracle DB 11g.

Confidential, Los Angeles CA

OBI ETL Architect

Responsibilities:

• The Confidential is a Los Angeles based private company and the following brands are among those of The Confidential and its subsidiaries,FIJI Water,JUSTIN Wines,Landmark Wines,POM Wonderful,Suterra,Teleflora,Wonderful Almonds,Wonderful Citrus,Wonderful Pistachios,Wonderful Sweet Scarletts.
• The project involved in consolidating its supplier base of around 20,000 suppliers for 9 of its brands using Oracle Spend Classification tool.My responsibilyty was to load Taxanomy data to generate the knowledge base.

Environment: OBIEE 11g/ OBIEE 12c, ODI11g, Oracle BI Applications 11.1.1.10.1 (Procurement and Spend), Oracle DB 11g