SUMMARY:

• Senior Enterprise Architect with more than 22 years of experience in Business intelligence, data warehousing, data integration and enterprise applications, including managing many projects for implementation, execution and delivery
• Excellent and proven track record for successful completion of projects, result - oriented solution design, planning and implementation of BI, Data Warehouse, Data Integration solutions
• Results-oriented achiever with excellent track record for identifying opportunities for accelerated growth
• Strong technical skill set in related areas along with new technologies - Oracle BI, ETL strategies etc

AREA OF EXPERTISE / CORE COMPETENCIES:

Business Intelligence: OBIEE R12c, OBIEE 11g, Tableau 9.x

Data Warehouse: Oracle BI Applications ( 11.1.1.10.1 ; 11.1.1.8.x ; 11.1.1.7.x; 7.9.6.x)

Data Integration (ETL): Oracle Data Integrator 11g; Informatica 9.x, 8.x; Advanced PL/SQL

HortonWorks Big Data: HortonWorks HDP 2.2 & 2.4; Apache Hadoop, HDFS, Pig, Hive and more …

Reporting Management: Project Management (BI, DW), Agile/Scrum; Waterfall; Kimball DW Methodology; Microsoft Projects

CORE COMPETENCIES:

Project Management: Project Delivery Management, Budget Control, Team management, Application Implementation Methodology (AIM), PMP Studies, Microsoft Projects

Business Intelligence & Data Warehousing: Exalytics, OBIEE 12c, OBIEE 11g, OBIEE 10g, Oracle BI Applications 11.1.1.8.1 / 11.1.1.7.1 / 7.9.6. x, Oracle BI Answers/Delivers/Interactive Dashboards, Metadata Repository (rpd), Data Modeling, Tableau 9.x, Business Objects, Discoverer, Hyperion IR/ Brio

Cloud Computing: Oracle Managed Cloud Services, Amazon AWS EC2 (Elastic Compute Clod), Redshift data warehouse, Microsoft Azure Cloud Computing Services (BI), Power BI

Big Data (HortonWorks HDP 2.2 & 2.4): Apache Hadoop, HDFS, YARN, Pig, Hive, HBase, HCatalog, HBase, Storm, Flume, Sqoop, MS Power View, MapReduce

BI Reporting: Predictive Analytics, OBIEE Reports/Dashboards/Delivers, BI Publisher, EBS Report Manager, FSG Reporting, SQL Server Analysis Services, SQL Server Reporting Services, Oracle-R, Oracle Data Miner

Source Applications: Oracle Applications EBS Release 12, 11i, 1103, PeopleSoft, Seibel 7.0 (CRM)

Databases: Exadata, Oracle 12c, 11g, 10g, 9i, 8i, SQL Server 2005

Data Integration: Oracle Data Integrator (ODI 11g, 10g), Informatica (9.1, 8.x), Microsoft SQL Server Integration Services (SSIS), SQL Server Data Transformation Services (DTS), SQL, PL/SQL, SQL*Loader, JDeveloper, Java, Stored Procedure/Packages, Unix Shall Script Programming, SOA, BPEL

Other Tools and Software: Oracle Forms, Reports, Financial Statement Generator (FSG), Workflow, PL/SQL Server Pages (PSP), Web Programming, HTML, JavaScript, VBScript, ADF, Unix, Windows, MS-Office (Power Point, Visio, Project etc)

PROFESSIONAL EXPERIENCE:

Sr. Enterprise Architect (BI Analytics)

Confidential, UT

Responsibilities:

• Analyzed, architected and provisioned solution for seamless BI reporting migration from existing OBIA 7.9.6.3 to latest Oracle Business Intelligence Application 11.1.1.0.1 (OBIEE 12c)
• Developed enterprise architecture including Oracle’s BI data model aligned with unique customer based customizations
• Implemented Oracle service cloud management for BI applications
• Managed and guided a large onsite and offshore team (ETL, OBIEE, QA) for timely completion
• Oversaw budget control and made sure completion of project phases by team coordination and delivery management

Environment: OBIEE 12c, Oracle BI Applications 11.1.1.10.1 (Financials, Procurement, Supply Chain Order Management, HR, Custom modules), Oracle Data Integrator 11g OBIEE 11.1.1.7.1 , Oracle BI Applications 7.9.6.3, Oracle EBS R12, PeopleSoft 9.2, Informatica 9.0, JIRA Issue Tracker

Sr. Enterprise Architect (BI/Data Warehouse)

Confidential, CA

Responsibilities:

• Achieved success by architecting a redesign of existing flawed data mart implementation to win back huge user’s adaptability
• Analyzed and developed OBIEE based solution to replace Essbase cube based application
• Guided client to progress from silo data mart to new enhanced enterprise data warehouse application
• Gathered Business requirements for issue resolutions and better ETL optimizations
• Managed and guided a mid-size onsite and offshore team (ETL, OBIEE, QA) for timely completion

Environment: OBIEE 11.1.1.7.1 , Informatica 9.0

Sr. Solution Architect (BI Analytics)

Confidential, PA

Responsibilities:

• Provided recommendations and best practices to be implemented and process governance
• Guided client to review and identify issues in existing single and multi-user development processes, migration governance processes
• Created process documents for OBIEE Multi-User development (MUD) Environment governance processes document design, migration management (Repository, Patches, ODI ETL objects, Catalog)

Environment: OBIEE 11.1.1.7.1 , Oracle BI Applications (Student Information Analytics), PeopleSoft, Oracle Data Integrator 11g, Custom Data Warehouse

Sr. Enterprise Architect (BI/ Data Warehouse )

Confidential, TN

Responsibilities:

• Guided client to achieve success by identifying pain-points in data warehouse and provided recommendations along with proposed solutions
• Managed and executed BI discovery and health-check sessions with business users, IT teams
• Developed heath-check documents, Architected proposed BI solution/remediation document
• Collaborate with Oracle Corporation and client IT teams for optimized solution

Environment: OBIEE 11g, OBIA 7.9.6.3, Oracle BI Applications (Financial, HR), PeopleSoft 9.1, Informatica, MS Project

Sr. Solution Architect (BI/ Data Warehouse )

Confidential

Responsibilities:

• In this unique solution design, I collaborated with Oracle Corporation in a specialized PoC project for architecting and solution predictive BI analytics on ‘Oceanic Seismic Survey Data’ which allowed client ( Confidential in Oslo, Norway) to save huge amount of money in survey operations
• This project was very unique in nature and challenging in terms of technologies and processes.
• Achieved success for main challenges i.e. unique data ingestion approaches, real-time reporting and detection/prediction analytics
• Designed data ingestion mechanism for very large volume of data with high velocity
• Developed predictive analytics for early detection of equipment failures to save time and money
• Developed hybrid data model to achieve unique requirement of near real-time and offline BI reporting
• Developed business requirement design Documents, Architected proposed BI solution document

Environment: OBIEE 11g/12c, JSON, C++, Oracle R, Statistical Algorithms, Oracle Data Integrator 11g, Exadata, Exalytics, Predictive Analytics, Detection Analytics

Sr. Enterprise Architect (BI Analytics)

Confidential, PA

Responsibilities:

• Achieved success in designing and enhancing Oracle BI manufacturing Analytics (from Discrete to Process manufacturing)
• Developed business requirement design documents, Architected proposed BI solution document
• Managed and guided a mid-size onsite and offshore team (ETL, OBIEE, QA) for timely completion
• Functional and Technical design document, Enterprise Data Warehouse data integration (ETL) design

Environment: OBIEE 11.1.1.8.1 , Oracle BI Applications (Manufacturing Analytics - OPM), Oracle EBS R12.2.3, R11i, Oracle Data Integrator 11g, BugZilla (software development issue tracker)

Sr. Manager/Architect (BI Analytics)

Confidential, CA

Responsibilities:

• Helped client to achieve targeted project roll-out due to organization split/spin-off company
• Planned and executed large scale conversion from BRIO/Hyperion IR to OBIEE 11g with hundreds of work products with tight timelines
• Managed project execution, resource planning, task assignment, collaboration (team of onsite and offshore developers)
• Oversaw migration of complex Hyperion IR reports to OBIEE 11g across many functional areas (Manufacturing, Supply Chain, Procurement and Customer Service) in a flawless execution
• Implemented re-deployment of a highly complex security model, Authentication and Authorization processes from HIR to OBIEE
• Analyzed/designed new custom reports involving DB Design, ETL modeling by understanding offline BRIO Bqy files and reporting requirements

Environment: OBIEE 11g, OBIA 7.9.6.4, Hyperion IR/ Brio, Oracle BI Applications (Manufacturing, Supply Chain, Procurement and Customer Service, Financial)

Sr. Enterprise Architect (BI/ Data Warehouse )

Confidential, GA

Responsibilities:

• Achieved architecture and design of enterprise level reporting framework involving global applications within Confidential corporate/organization.
• Executed discovery and assessment sessions with business users, Fit-Gap Analysis, Developed business requirement design Documents, Architected proposed BI solution document

Environment: OBIEE 11.1.1.8.1 , Oracle BI Applications (Financial, Procurement & Spend Analytics), Oracle EBS R12.2.3, R11i, SAP, External Sources/Applications, Oracle Data Integrator 11g

Technical Manager/Architect

Confidential, IL

Responsibilities:

• Achieved and rolled-out architecture and design of organization level reporting framework
• Executed business requirement gathering, analysis, end-user interaction sessions and translated into design documents, Architected proposed reporting framework solution document
• Managed team of technical developers and monitoring deliverables
• Implemented ‘Change Control Process’ for code migration and deployment

Environment: BI Publisher 11g, Oracle Report Manager, Oracle Financial Statement Generator (FSG) Reports, and AIM project documentation methodology

Technical Manager/Architect

Confidential, IL

Responsibilities:

• Contributed in in-house product development initiative which transformed into a flagship BI analytics product for our company
• Designed OLAP and Star schemas for Confidential product Data Warehouse; Dimensional data modeling
• Created technical specifications and mapping documents for data warehouse schema and ETL processes
• Development of ETL, OBIEE RPD metadata and BI reports/dashboards

Environment: OBIEE 10g/11g (Repository Metadata, Dashboards/Reports/iBots), Oracle Data Integrator (ETL processes)

Solution Architect (Data Warehouse)

Confidential, IL

Responsibilities:

• Designed and developed data warehouse solutions which helped Confidential insurance company to integrate data for mandatory reporting and compliance governance
• Implemented analysis & evaluation of data feeds from a large number of premium and claim systems and matched the available entities with the reporting requirements
• Designed data integration strategies using Microsoft SQL Server Integration Services, Data Transformation Services to bring source system data from various third party database servers into an SQL Server data warehouse
• Designed and developed analytical report application ‘Exposure Management System’ for field representatives/insurance underwriters as decision support tool (client/server application)
• Prepared strategies for Data Cleansing, Data Governance, Data Validation

Environment: Microsoft SQL Server Integration Services (SSIS), SQL Server Data Transformation Services (DTS), Transact-SQL, MS Access Programming (Macros, VBA)

Sr. Manager (BI Analytics)

Confidential, WI

Responsibilities:

• Maintained production issue resolution time within acceptable limits and minimize issue backlogs, Enhanced existing application in AP/AR area
• Directed and managed onsite lead and small size offshore team
• Managed Incidents - Issue analysis, Business requirement gathering, Task assignments, Delivery management

Environment: OBIEE 11.1.1.7.1 , Oracle BI Applications 7.9.6.3 (Financials, Procurement), Informatica 9.1, SharePoint, JIRA Issue Tracker

Sr. Manager (BI Analytics)

Confidential, FL

Responsibilities:

• Successful managed a team responsible for 24x7 production support for all production issues and resolutions
• Directed and managed onsite lead and small size offshore team

Environment: OBIEE 11.1.1.7.1 , Oracle BI Applications 7.9.6.4 (Financials, Procurement), Fixed Assets, Oracle EBS R12, Informatica, SharePoint, JIRA Issue Tracker

Sr. Manager (DW/BI Analytics)

Confidential, TX

Responsibilities:

• Contributed in development of a key decision making solution dedicated to get insight of enterprise level operations data for work optimization and expenditure saving tool
• Business requirement gathering and BI solution design, Enterprise Data Warehouse data integration (ETL)
• Directed and managed onsite lead and small size offshore team

Environment: OBIEE 11g, Oracle Data Integrator 11g, Advanced OBIEE Visualizations, Dashboards

Sr. Solution Architect (BI Analytics)

Confidential, PA

Responsibilities:

• Successfully executed discovery and BI assessment of existing implementation and source systems which resulted into a full blown BI implementation project for my organization
• Business requirement gathering and BI solution design (Enterprise Data Warehouse)

Environment: OBIEE 11g, BI Applications 7.9.6.4, Oracle EBS, External Applications (3rd Party, Custom)

Sr. Solution Architect (BI Analytics)

Confidential, MI

Responsibilities:

• Data modelling and BI solution design

Environment: OBIEE 11g

Sr. Solution Architect (BI Analytics)

Confidential, TX

Responsibilities:

• Successfully executed discovery, BI assessment and fit/gap analysis of existing implementation and source systems which resulted into a full blown BI implementation project for my organization
• Business requirement gathering and BI solution design (customizations and extensions)

Environment: OBIEE 11g, BI Applications 11.1.1.7.1 , JD Edwards 9.1