SUMMARY:

Confidential have 12+ years experience in Business Intelligence, Siebel CRM and in DW work space. Hands on BI Solution Architect & developer and have done business case delivery in different Verticals - Pharma, Healthcare, Finance, Banking, Retail, Telecommunication, Supply Chain, Procurement & Spend and Aviation. Expert in technical and functional Architecture, Project management, Requirements gathering & documentation, OBIEE report development, Installation & configuration, production support and application development. Have diversified skills and can wear multiple hats as - BI / DW developer, Solution Architect/Designer, Tech Lead / Project Mgr. Also, engaged in Advance Technologies like - Big Data. A professional with 3 years in Siebel CRM & last 10+ years providing OBIEE (aka Siebel Analytics) BI solutions.

HAVE EXPERTISE IN:

• Business Intelligence BI Solution Architect & Design
• Develop, Implement OBIEE Dashboard Reports BI Apps Integration & Development OBIA, EBS & EPM
• DW - Dimension Modeling & Star Schema Design Deploy Diverse Subject Areas
• Business Analysis Tech Lead & Project Mgmt

SUMMARY OF TECHNICAL SKILLS:

Business Intelligence:

Tools: OBIEE, Siebel Analytics, Business Object

BI Analytics: Supply Chain & Procurement/Spend Analytics, Sales, Marketing & Financial Analytics, Financial Service Analytics, Pharma Analytics, Part Analytics

OBIEE: 10g, 11g - 11.1.1.6.6

OBIA: 7.9.6.3

DW Tools: Informatica Power Center (6, 7.1), 8.1.1, 9.0.1 ODI (10.1.3), Data Stage (7.5.2)

CRM: Siebel Sales (SFA), Field Service, EIM, Siebel Call Center, Siebel ePharma, Siebel Finance 2000, Siebel eTelecommunication, SAP Connector, eChannel

Essbase: 11.1.1.3.0

Financials: Oracle & People Soft

EPM & Supply Chain Mgmt.: Oracle EBS, SAP BW, OMAC, Avalon & Manugistics

RDBMS: Oracle (8i/8.0/7.0, 10g, 11g), DB2, Ingress (6.4/6.3/5.0), SQL Server 7.0, SQL/DS, Informix 9

Web Technologies: JAVA, Servlets, JDBC, Java scriptSystem Analysis, Project planning:

Case Tools: UML/RUP, Yourdon Workbench

Data Modeling: tool - ERwin

Project Mgmt: Scope, Time, Cost, Risk & Quality; Resource/Requirement analysis; identify tasks/ activities; Issue, Risk & Change Mgmt; Coordination with Application Integrators/Vendors

Methodologies: RAD (Agile) & PMI, OUM

Pre-sales support: Software Estimation (Function Point Analysis), Vendor negotiations, Technical proposals and presentations

Operating Systems: Solaris, MVS/ESA, AOS, HP-UX, Unix, AIX, VAX / VMS, Windows NT & 2003

Programming Languages: C++/C, Siebel VB & Smart Script, COBOL, PL1, FORTRAN, JAVA, J2EE, JSP, SQL-PL/SQL, UNIX Shell Scripting

BI PROJECTS & CLIENT DETAILS:

Confidential, Canton, OH

Solution Architect / BI Tech Lead

Responsibilities:

• Facilitate sessions to SME’s/Business Owner’s to show case Oracle’s OOB Supply Chain, Procurement/Spend Analytics Dashboards/Reports/KPI’s, Analyze existing BAAN based Custom Metrics, As Is reports/queries & Architect reporting solution
• Propose the Architecture, Provide Solutions for proposed Subject Area deployment, ensure best practices and present findings to Decision makers/Technology teams
• Assist Functional Lead to perform Gap Analysis, Create MoSCoW, RICE list- as per Oracle Unified Method (OUM)
• Propose Solution architecture for SCM, Procurement/spend & report deployment in phased manner
• Perform Data Lineage, Enhance OOB Data Model - Physical/Logical Design & Customize OOB Stars
• Customize Star schemas suiting to Confidential ’s data & Reporting needs
• Architect & Design Semantic Layer (Logical, Physical Layer) & Reporting - Presentation layer, and Create or customize OOB Dashboard/Reports
• Develop & Deploy Subject Areas - SCM & Procurement Spend
• Generate Custom reports - Gate (Score card) Report, External & Internal Sales Order report
• Set up .csv files, Perform Configuration Steps to control Initial Data Set for SCM Fact tables - Sales Order Lines data, Sales Schedule Lines, Sales Invoice Lines, Sales Backlog line & BOM explosion
• Create ETL Architecture/Design document & Mapping specifications, co-ordinate with Off-shore ETL development team
• Help/Assist setting up DAC, DAC Execution Plans, Run Full & Incremental loads

Environment: OBIEE 11g - 11.1.1.6.12 , BI Apps - 7. 9.6.4 Oracle EBS - R12.1.3, Informatica 9.0.1 DAC 10.1.3, OUM

Confidential, Minneapolis, MN

Solution Architect/Report Developer

Responsibilities:

• Architect Reporting solution based on Solarc (movement of Oil & Gasoline) data, Red Prier (POS) Retail data and Oracle financial data
• Integrate Red Prairie Retail db, Solarc POS data & Financial data based out of Essbase cubes
• Architect, design new star schemas (Custom tables) suiting to Confidential business process
• Perform OBIEE & Essbase integration, Create RPD based on - Essbase cubes, Solarc Production Volume data & Point of Sales Retail/Sales data
• Create Financial reports by vertical federation, Performance Tuning of Federated queries
• Generate reports based on Essbase GL cubes, Develop reports like - Monthly/Daily Category Margin, Monthly Labor as % sales, Daily Score card, Daily Ranking of Stores by Category etc.

Environment: OBIEE - 11.1.1.6, Oracle EBS 11gR12.1.3 Essbase - 11.1.2.1, Informatica 9.01 HotFix 2 DAC 10.1.3.4-1 BI Apps - 7.9.6.3

Confidential, Houston, TX

Solution Architect

Responsibilities:

• Install OBIEE 11g, apply patches to installed software, Install Informatica, Install & configure DAC
• Perform OBIEE & Essbase integration, Create RPD based on Essbase cubes & Relational Production Volume tables
• Create Financial & Production Volume forecast Reports based on vertical federation, Performance Tuning of Federated queries
• Deploy report level as per Essbase cube’s data level security to users, user groups
• Generate reports - Income Statement, Balance Sheet, Cash Flow, Daily Volume
• Financial & Project Analytics - Perform Source Independent Configuration - set up Initial Extract date, Global Currencies, Exchange Rate types, Fiscal Calendar, Configure different types of calendars, Reloading Time Dimension, Configure Data Source Num ID values etc
• Perform Oracle EBS-Specific Configuration Steps - Configuration for product hierarchy in Product dimension & Inventory Product dimension table, Configure Product Category Sets, Configure DAC parameters for product hierarchy, Configure Master Inventory Organization in Product Dimension Extract for Oracle Adapters
• Set up .csv files - Mapping Oracle GL Natural Accounts to Group Account Numbers, map General Ledger accounts to group account codes, map Financial Statement Item Codes to Group account codes, Set Up the GL Segment Configuration File etc.
• Configure Dims like - Project, Task, Financial Resource, work type, Project Classifications, and Fact table like - Budget Fact, Funding Fact, and Forecast

Environment: OBIEE - 11.1.1.6.0 , WLS - 10.1.3.0, OBIA - 7.9.6.3, Oracle EBS R12.1.3 Essbase - 11.1.1.3.0 , sql server 2008, Informatica 9.01 Client HotFix 2

Confidential

Sr. Principal Consultant / Architect

Responsibilities:

• Interact with client Technology teams, understand current Architecture, scrutinize the objects (RPD, Web catalog, configuration files etc), Identify bottlenecks, ensure deployment follows BI best practices
• Propose Architecture, Provide Solutions to existing deployments, ensure best practices and present findings to Decision makers & Technology teams and Propose Architecture & Solutions
• Propose 11g architecture solutions - Single/Multi-node/Cluster and/or to “Scale out” existing Architecture for Banking client
• Help/assist installing 11g & upgrading from 10g to 11g for Entertainment industry/client
• Performed BI Health check, Performance Tuning to Payroll & Pharma client
• Hands on training in VM ware to provide services to upcoming technologies - OBIEE - 11g, Fusion middleware & Big Data

Environment: OBIEE - 11g, 10g, Oracle 11gR2, VM Ware - OBIEE & Big Data

Confidential, Raleigh, NC

OBIEE Technical Lead

Responsibilities:

• Manage & Lead technical (Data & Reporting) team to develop & implement BI solution
• Set technical direction, establish best practices & contribute setting the vision for future BI architecture - Subject Area delivery
• Development & delivery of two Subject Areas: (1) Book Mgmt - manage Customer portfolio, Asset Mgmt & investment advice and (2) Case Mgmt - Financial Services Request Analytics
• Client, Client Activity, Accounts & Contacts, Branch Info, Assets at RiskAssets allocation, Sales Opportunity, Client Drill down pages, FILI Annuities Develop dashboards - Client Notification & Opportunity, Client/Customer personal & Asset info
• Develop ODS & OBAW based Dashboard reports - Open Service Requests; Orphan SR’s by RegionArea; Case Activity by Market, Branch, Team; Case Activity by Site, Service Hub/Region, Mgr, Rep
• Create OBIEE Repository (RPD) – Architect & Design Semantic Layer (Logical, Physical layer) & Reporting/Frond end (Presentation layer),and Create Dashboard/Reports
• Design, Build, Test, Implement & Maintain RPD and WebCat objects
• Administer RPD merge of 3 Subject Areas – Books, Leads (Opportunity Mgmt), Case
• Manage web catalog migration, User Group Administration for above 3 Subject Areas
• Performance Testing: Lead the team of HP LoadRunner team to meet specified TPS; monitor performance measurement components like – CPU at all load levels, Memory, GC, Heap Size etc in order to isolate bottlenecks; Spool OBIEE Query of various dashboards drill paths, Graphs; if required, implement new index or re-configure SQL; Ask DBA to generate AWR & ADDM reports for each run & do Performance Analysis
• Coordinate with Environment/Support team for Code/report promotion from/to: Dev->QA->Perf->Prod
• Prepare Release & Code Migration requests

Environment: OBIEE - 10.1.4.1, Oracle 10g, OBIA 7.9.6, Informatica 8.6.1, DAC 10g, Windows server 2003, HP Load Runner 11

Confidential, Winfield, IL

Sr. OBIEE Consultant / Architect

Responsibilities:

• Create OBIEE Repository (RPD) - Architect & Design Semantic Layer (Logical, Physical Layer) & Reporting/Frond end (presentation) layer, and Create Dashboard/Reports using Oracle Answers
• Develop & Deploy Subject Areas – Financial Transformation and Part Analytics
• Develop dashboard to show transition from the “old” Chart of Accounts (CoA) to the “new” Enterprise CoA and provide descriptions for Accounts, Departments, Entities, Operating Units, and Sub-accounts
• Develop Financial Analytics reports/dashboards – Trial Balance (Summary & Detail), Journal Entry line item details, Historical Financials report for Business Units – Corporate, Finance, Engine, Parts, Truck
• Develop Financial Forecasting Reports for next Fiscal Year for different BU’s - Corporate, Finance, Engine, Parts, Truck
• Develop SAS 99 dashboard – A Financial Auditing statement showing transaction sources for all BU’s Accounts & Entities
• Develop Historical Balance Sheet reports to provide users an ability to see the Balance Sheet in Variance & in Trend formats. The Balance Sheet reports contain the total assets, liabilities and stockholder's equity for Confidential entities
• Develop Diagnostics dashboards to support the validation of NDW data integrity, daily processing. These reports also supported the validation of Essbase cubes versus HFM data
• Part Analytics: dashboard/reports developed – Plan & Performance, Sales Performance by Month, Sales Performance by Programs, Part Look-up, Trend & Returns,
• Scheduled canned report delivery at specified time thru iBots for different Financial Forecasting Business Users
• Migration of objects – web catalog, report, prompt etc from Dev to Test, Test to Prod environments
• Dashboard/Report level Security set up to users, user groups, and set privileges

Environment: People Soft v8.9, OBIEE - 10.1.3.4.0 , Tera data v12, Oracle 11g, Informix 9 (for Part Analytics Subject area)

Confidential, Chicago, IL

OBIEE Consultant / Architect

Responsibilities:

• Develop BI applications using the ORACLE BI suite
• Develop meta data layer using Oracle Business Intelligence (OBIEE) Administration tool
• Customize OBIEE Repository - Architect & Design Semantic Layer (Logical, Physical Layer) & Reporting/Frond end (presentation) layer, and Create Dashboard/Reports
• Developed 4 Subject Areas – Bag Fee Waiver, Event Reporting Systems, Line Buster, Security
• Generated reports, dashboards against heterogeneous data sources – Oracle, DB2
• Schedule canned report delivery at specified time thru iBots
• BI tool installation, maintenance and upgrades, trouble shooting & Performance tuning
• Dashboard/Report level Security set up to users, user groups, and set privileges

Environment: OBIEE - 10.1.3.4.0 , Oracle 11g, Tera data v12, DB2, BI Publisher

Confidential, Richmond, VA

OBIEE Consultant / Architect

Responsibilities:

• Implementation of integrated multiple Oracle Product suite – Oracle EBS (Finance - GL, HR & Payroll), Oracle BI, Hyperion Financial & Hyperion Planning
• Oracle Aps (EBS) framework integration with OBIEE: to have a single source of truth for – Finance (General Ledger), HR, Payroll, Supply Chain; OBIEE Inherits User, User Groups, responsibilities from EBS, configure user/user groups in OBIEE framework, and deploy single sign-on/responsibilities across organization; deploy Dashboards/Reports immaterial of application – Oracle Aps or Hyperion
• General Ledger & HR integration with OBIEE – design & configure OBIEE metadata for - GL Financial Accounting & HR Analytics, create semantic layer, business model for – General Ledger & HR modules
• Hyperion integration with OBIEE - Configure OBIEE repository by importing Hyperion Financial Mgmt objects - Hyperion Cubes, Scenario, Generations (Account, Cost Center Hierarchies etc), Create Business Model/Semantic: layer and Generate Dashboards/Reports thru OBIEE (Oracle Answers) for Hyperion users
• Design & develop Dashboard Reports – Chart of Accounts; P & L statements; Journal Summary; YTD Balance; GL 12 Month Comparison; Business in Balance by Region Month QTD YTD; Income Statement – Auditor, by Mid Level, High level; Expense report by Region; etc
• Define Security matrix & Visibility criteria that allows Dashboard access to users, set up object & data level security for Users, User Groups

Environment: OBIEE 10.1.3.4.0 , BI 7.9.5, Hyperion – 9.3.1, Oracle (Financial) EBS - 11.5.10.2, DB - 10.1.0.5, Linux (Red Hat 4.6), Informatica 8.1.1

Confidential, Silver Spring, MD

OBIEE Consultant / DW Designer

Responsibilities:

• Identify SAP BW ODS & DW data sources/Cubes for reporting requirements, Analyze whether Dashboard/Reports are based on SAP/BW’s ODS or DW Cubes, Study SAP BW Supply Chain Dashboards/Reports in the context of OBIEE dashboard - Prompts & Filters
• Architect, Design OLAP Data Model for ODS based dashboards/Reports, Design/Architect new Star Schemas to support SAP/BW ODS based Dashboard/reports
• Create OBIEE Technical Design document which encompass – OBIEE Repository & Business Model Layer, Dashboard/Report & define User/User Group level access - Object & data level security
• Customize OBIEE Repository - Architect & Design Semantic Layer (Logical, Physical Layer) & Reporting/Frond end (presentation) layer, and Create Dashboard/Reports
• For Proof Of concept, Develop Forward/Reverse Logistics Dashboard, Reports,
• Define Security matrix & Visibility criteria that allows Dashboard access to users, set up object & data level security for Users, User Groups

Environment: OBIEE 10.1.3.4, Oracle10g, SAP 4.5, BW 3.5, BI – 7.9.4

Confidential, Cincinnati, OH

OBIEE Technical Lead

Responsibilities:

• Develop & Deploy Consumer Goods OBIEE/BI application from Dev-to-QA-to-Production
• Interact with Business Owners to identify KPI’s, EBS/ERP data Interface; understand Dashboard reporting requirements, Perform Meta data Analysis and Architect, Design OLAP Data Model
• Perform Data Modeling - Create physical/logical data structures of proposed Stars
• Architect/Design 10 Customized Facts/Stars & 16 associated dimensions, Created ADL & Shipment Fact to populate EBS (SCM) data. Designed new Stars/Facts - Fund Adjustment, Liability, SKU & (Trade) Promotions/Targets and Performance (of the trade promotion)
• Architect 2 new Facts - Settlement & Resolution to build data interface between OBIEE application and Oracle Financial EBS to capture GL, Payables & Receivables info
• Create Business Model, Develop Repository, Manage Snow flaking, Aggregate Navigation etc
• Build OBIEE Repository having data interface with EBS (Oracle/Siebel CRM) OLTP, SCM and SAP BW for Orders data, Design, Develop customized Informatica ETL – SDE/SIL mappings
• Develop Dashboard, Reports, Charts & Performance tuning - Event poling, Cache, iBots etc
• Define Security matrix & Visibility criteria that allows Dashboard access to users, set up object level security for Users/User Groups, Manage Users/User groups
• Perform data refresh thru DAC, Manage Trouble Tickets when application went live
• Coordinate/mange BI application integration team of 6 located – On & Offshore

Environment: Oracle EBS, Siebel Analytics 7.8.5, OBIEE 10.1.3, Oracle10g, Informatica 7.1.4, SAP 4.5 Data Stage (7.5.2)

Confidential, Fairfax, VA

BI Consultant / Architect Designer

Responsibilities:

• Enhance capability of Service Request Subject Area, Analyze Siebel Analytics TRAX# (Service Requests), Customer Survey data & Legacy Survey data
• Interact with Business Owners to Architect, Design & build new Subject Area - Satmatrix. Created Business Model, Configured Repository to cater Extension Fact/Dimension columns
• Developed Subject Area - Sales Analytics Pipe Line – worked on back-end (Informatica) to create customized Informatica ETL mappings/workflows to capture Siebel OLTP Extension columns, Create Informatica workflows, and Execute Informatica SDE/SIL custom ETL mappings to populate Siebel Dimension extension tables. Create business model, configure repository and create Sales Pipe Line dashboards
• Develop Subject Area - Inside Sales Analytics and Sales Lead Management - converting the existing Excel spreadsheet (Non Dimensional Data) into Physical Layer of Siebel Analytics Repository, identifying reporting fields, Configure Repository & Create Ad-hoc Siebel/Oracle Answers reports

Environment: Siebel Analytics 7.8.4, Windows, Oracle 10g, Informatica 7.1.4,Sales/Marketing Analytics

Confidential, Philadelphia

OBIEE Tech Lead

Responsibilities:

• Facilitate sessions with Business Owners to know Sales/Trade Promotions Pharma Analytics KPI’s & Reporting requirements, Assist BA in Functional specs, Perform Data Modeling - Create logical/physical data structures, Create Technical design doc for - Front End & Informatica ETL
• Develop Shire Business Model, Configure repository (.RPD)
• Design/Customize OOB & new Dashboards/Reports using Siebel/Oracle Answers and Create/Deliver Briefing Books to 700 Sales Rep using Siebel/Oracle Deliver/iBots
• Develop Dashboards - Pharma Contact Call Effectiveness (Call reach, Frequency), Pharma Objective achievement (by Product, Patient age, zone, region territory, Ranking/Deciling Physician Rx effectiveness (Specialty, Prescriber and TRx / NRx)
• Execute Informatica SDE/SIL ETL mappings to populate Pharma Stars/facts, dimensions
• Set up visibility for Users & User Groups at Dashboard & Data/presentation column level
• Create Mobile Analytics data schemas, reporting queries. Mobile Analytics (Disconnected Client), deploy Mobile Analytics functionality for Regional Directors (with limited Dashboard)
• Assist Data team to load IMS Syndicated Prescriber (RXDM) Monthly & Early View data in to Staging tables of Siebel Rx fact tables. Involved in identifying Rx Facts/table & column mapping.

Environment: Pharma Analytics 7.8.4, Oracle 10g, Mobile Analytics, Informatica 7.1, Briefing Books, iBots, Erwin 4.1

Confidential, Piscataway, NJ

Sr BI Architect/Designer

Responsibilities:

• Understand business requirements of existing 300 reports as well Interact with Business Owners to enhanced Dashboard requirements and convert them into BI/Analytics Subject Area perspective
• Create Functional/Technical design doc based on existing reports, perform GAP analysis, perform data mapping between reporting requirements and Siebel OLTP (tables/columns) & Siebel SRMW OLAP (Facts/measures, Dimension/attributes)
• Customize Repository (.RPD) for Order Header/Detail problems and resolve data issues
• Develop generate/customize Dashboard Reports for Sales & Order Subject area
• Execute Informatica SDE/SIL ETL mappings to populate Siebel OLAP database, create Customize Informatica ETL mappings/workflows to capture Siebel OLTP Extension columns in Siebel OLAP
• Co-ordinate & manage Off shore team of Informatica developers to populate data warehouse

Environment: Siebel eMedia, Windows NT, Oracle 9i, Siebel Analytics 7.8, Siebel RMW, Informatica 7.1