OBIEE Architect
Resume:
Rijo Cherian
****.*******@*****.***
SUMMARY
A Techno- Functional Business intelligence, ERP & CRM consultant with 12 + years as Project Manager, Architect, and Analyst. Advance level expert in BI, ERP & CRM, spanning across different industry segments and business areas. Extensive experience on working very closely with business & IT teams for various global customers. Successful in driving and delivering small to large scale projects by applying a balance of project management skills, functional and technology skills.
Personal attributes include excellent organizational skills, high self-motivation for quality results and excellent multi-tasking capabilities. Excellent inter-personal skills enhance communication at all levels of the organization. Exceptionally able to influence and manage large and diversified project resources.
HIGHLIGHTS
Experienced Solution Architect for designing & developing data models for OBIEE/ Tableau & Hyperion reporting solutions.
SME on Functional domains (Financials (AP,AR,GL)/Procurement/Supply chain/ Order Management) and Siebel CRM.
SQL Expertise and an ETL Designer.
Lead planning meetings, JAD sessions (Joint Application Design), analysis development, test inspections, and other project meetings throughout product life cycle.
Experienced with the Hyperion financial applications & reporting tools.
Experienced with the Tableau reporting tool.
Extensive experience working in an onsite/offshore model for deriving value and cost effectiveness.
Excellent stakeholder relationship skills.
Proficient in MS Office tools including Word, Project, Excel and PowerPoint
Effective team mentoring skills and an independent task owner as well as a leader for coordinated efforts.
Extensively involved in interacting with business/Stakeholders and IT teams for implementation and maintenance of BI (OBIEE / Hyperion / Tableau ) & CRM systems.
BI experience summary
Data modeling – Designed& Build DW tables on Star & snowflake schemas.
Data Extraction/Transformation/Load- Designed ETL(Informatica) process & SQL’s to populate data from different source to data warehouse and Informatica Administration.
OBIEE Reporting – Designed & developed reports in OBIEE, Developed joins on RPD to facilitate star/snowflake functionalities.
OBIEE Security – Designed & developed Active Directory for OBIEE11g.
OBIEE Administration – Administration of Managed server, Weblogic & BI Servers.
BI Publisher Reporting – Designed & developed reports in BI Publisher.
Other BI Applications: - Hyperion, Tableau, QlikView, Hadoop, BIRST
Functional Domain: - Finance (AP,AR,GL),Procurement, Supply chain, Order Management, Manufacturing, HR, Customer Registry & Project Allocation.
Siebel CRM experience summary
Siebel Development -Design &Customize Business Objects, Business Components, Applets, Views and Screens.
Workflow -Workflows for automating Business Processes. Rule Sets, Validation Messages for approval process.
EIM -EIM mapping to Party & Non Party tables on Siebel from external sources.
Scripting -Written Scripts on Applets, BC’s & Business Services
PROFESSIONAL EXPERIENCE
Client: Cisco Systems, CA, Nov 2013 - Present
Role: BI Architect/ Data Analyst
Environment: OBIEE 11.1.1.7 / 12 C Tableau 9.x, Teradata
Client is worldwide leader in networking. The OBI application provides 360-degree view of Cisco Products & Services installed at customer/partner locations. This application helps Marketing and Sales Account Managers/Operational Directors/ VP’s about the potential opportunities with existing customers in order to up-sell & cross-sell Cisco Products & Services on their sales territories. This application also provides min/max opportunity amount/quantities based on Opportunity Business Rules and Bookings Amount details to Partner/Customer’s. A Tableau application which tracks the usage analytics on OBI application & analyze on the opportunities generated.
As a BI Architect/ Data Analyst my responsibilities include:
-Communicates objectives and approaches with business and technical team members.
-Architect the data model for dimensions and facts for business requirements.
-Customize OBIEE UI with Java in accordance to requirements.
-Production support & development on enhancements in BI applications.
-Designed OBIEE Fragmentation content to split the query against a table or another depending of a value of column.
-BI Applications Administration & Migration (Dev 2 PROD) (Weblogic, Enterprise Manager, RPD & Webcatalog), Tableau
-Provide technical insights to improve processes and performance of the overall BI landscape.
-Experienced in configuring Usage Tracking and Multiuser Development Environment.
-Build PL/SQL’s for data load & for views on top of 3NF Schema.
Client: Cisco Systems, CA, Dec 2012 – Oct 2013
Role: BI Architect/ Data Analyst
Environment: OBIEE 11.1.1.5, Teradata
Client is worldwide leader in networking. This project aims to integrate HR data for a specific technology group from eternal applications which does project allocation for resources, budget allocation & spent details to Oracle BI application to generate reports on current resource status.
As a BI Architect/ Data Analyst my responsibilities include:
-Requirement gathering from stakeholders
-Generate and maintain project status updates to business team
-Communicates objectives and approaches with business and technical team members.
-Design DW structure for HR, Project Allocation & Budget data reporting in Oracle BI Application.
-Designed & developed OBI reports to transfer Tableau reports & new reporting from budget Allocation & spent application.
-OBIEE Administration(Weblogic, Enterprise Manager, RPD & Webcatalog)
-Build PL/SQL’s for data load & for views on top of 3NF Schema.
-Designed & developed star schema & object level security to facilitate the functionality.
-Created multiple reports which includes Drill down, Go-Url, Union of Subject areas, etc in Table, Pivot & charts views.
-Created logical dimension level based hierarchies & repository and session variable to achieve the functionalities.
Client: ATiAllvac, NC, Mar 2010–Nov 2012
Role: Project Manager/OBIEE Architect
Environment: OBIEE 10g & 11g, Oracle 11g
Client is world's leading and most diversified specialty metals producers. This was a green field implementation with EBS as source. This project aims to customize OBIEE Apps (prebuild analytics) on (financials (AP,AR& GL), supply chain, procurement, and inventory), design and develop BI reporting solutions for Manufacturing, Planning (ASCP), & Quality functional areas. Data flows from multiple source systems for these areas.
As a Project Manager my responsibilities include:
-Creates/executes work plans and revises as needed to meet changing needs/requirements.
-OBIEE training to Client IT& business team as well as developed training materials for business team& end users.
-Manages day-to-day operational aspects of a project and scope.
-Prepare for engagement reviews and quality assurance procedures.
-Minimizes our exposure and risk on project.
-Ensures project documents are complete, current, and stored appropriately.
-Co-ordinate & assign work schedules for Offshore team of 14 consultants.
-Holds regular status meetings with project team(s)
-Effectively communicates relevant project information to executive team.
-Resolves and/or escalates issues in a timely fashion.
As Technical Architect
-Design data model to generate reports from for Manufacturing, Planning (ASCP)& Quality world.
-Designed data model to integrate Manufacturing date to seeded analytics (Financials/Procurement/Supply chain/Inventory/Sales).
-Responsible for OBIEE administration through Weblogic & Enterprise Manager.
-Designed & developed star & snowflake schema to facilitate the functionality.
-Administration of OBIEE, DAC & Informatica.
-Troubleshoot/Design Informatica Mapping/Workflow for ETL execution.
-Created procedures/methods for Dev to PROD migration of all 5 components of OBIEE in-line with client Audit process.
-Identify areas for performance improvements by following best practices and suggest solutions.
Client: ATiAllvac, NC
Project : OBIEE 11g Upgrade Aug 11–Dec 11
Role: OBIEE Architect/Project Manager
Environment: OBIEE 10.1.3.4 to OBIEE 11.1.1.5, Oracle 11g
The key objective was to upgrade ATiAllvac OBIEE environment from 10.1.3.4.1 platform to 11.1.1.5.0. In addition to seeded analytics Allvac BI contains Manufacturing, Planning (ASCP), Quality areas. This includes upgrade of existing customization on seeded & custom DW, Informatica, DAC, RPD & web catalog changes.
As OBIEE Upgrade Architect my responsibilities included:
-Prepare GAP Analysis, upgrade Approach& project blue print.
-OBIEE 11g security implementation with Active directory
-Work in close co-ordination with the upgrade team to identify pre and post upgrade activities, issues, maintain a risk management plan, creation of test scripts and report validation
-Monitoring data loads and apply fixes to failures thereby ensuring business continuity.
-Provide technical insights to improve processes and performance of the overall BI landscape.
-Maintain issue logs and user query log to help identify risk patterns and suggest solutions.
-Project execution, delivery& documentation
Role: Solution Architect Oct 2009 – Feb 2010
Client: All India Council for Technical Education, INDIA
Environment: Siebel 8.0, Oracle 10g
The engagement with AICTE was to build an e-governance system to bring efficiency, transparency, and accountability to the organization. The project involved developing a portal that enabled institutes to submit applications online and provided a payment gateway and automated the approval process for setting up new institutes. For existing institutes with accreditation and business processes in addition to introducing reporting capabilities, improving identity management, and revamping the AICTE Web site to make it more user-friendly.
My major responsibilities as a Solution Architect:-
-Participate in application design and architecture of e-governance portal.
-Break down user requirements further to create work packages and assigning appropriate resource to complete the task
-Prepared technical specification and conducted periodic reviews with the client business team
-Manage change control during project execution
-Mentor and train the team members.
-Identify areas for performance improvements and suggest solutions.
Role: Principal Consultant Oct 2008 – Sep 2009
Client: Lafarge North America, ON, Canada
Environment: OBIEE 10g/Hyperion, Oracle 10g
The project was to implement financial management reporting solution for Lafarge North America region. Users were manually sent the consolidated reports to head office (Paris).The challenge was to identify the reporting tool & to convert excel sheet & manual calculation to online reports.
My responsibilities as a Principal Consultant:-
-Identify the tool & Design system to meet requirements.
-Layout the road map for project execution by creating the project plan.
-Successful in building a dedicated offshore team of 2 OBI and 2 Hyperion resources for production support
-Analyze the data flow from the basic system to OBI DW in order to address key user queries relating to report functionality, usage and handling.
-Participate in dry runs and integration testing of OBIEE 10g & Hyperion applications prior to system roll out.
-Provide technical support related to OBI enhancements & Hyperion development and reports.
-Actively involved in post go-live production support activities
Role: Principal Consultant-Siebel, Mar 2008 – Sep 2008
Client: Lehman Brothers Inc, Mumbai (Worked from Offshore)
Environment: Siebel 7.8, Oracle 10g
Client was a global financial services firm. Client have Siebel financial application & financial analytics to support their business in investment banking, equity and fixed-income sales, investment management, private equity, and private banking. My responsibilities as a Principal Consultant-Siebel were
-Created and executed EIM mapping to EIM tables (party & non-party) for base/extended columns on Siebel tables.
-Worked on Thin BC’s & Integration Objects.
-Involved in creating workflows for automating Business Processes.
-Created new Rule Sets, Validation Messages for approval process.
-Written Scripts on Applets, BC’s & Business Services to achieve business needs.
-Provide technical support related to Siebel Analytics enhancements, Analytics development and reports.
-Designed & developed applets, views, MVL, custom BC’s according to the requirement.
Role: Senior Consultant Siebel CRM, Jun 2004 – Feb 2008
Client: Hyperion Inc, CA (Worked from Offshore)
Environment: Siebel 7.8, Oracle 9i
The client was the global leader in Business Performance Management software. This Project aims the entire automation of the quote life cycle, beginning with the generation of a Quote by the sales rep, getting approvals for the terms of a quote, generation of a quote output for customer, entering the accepted quote into the order management system, and finally the conversion of an order into an asset. As a Senior Consultant Siebel my responsibilities were:
-Lead a team of 6 team consultants from offshore
-Handled Enhancement Requests (ER’s).
-Designing and customizing Workflow objects, Policies and Run time Events.
-Requirement specifications for different screens, views and applets according to particular ER’s.
-Configured Static and Dynamic Pick lists, and specialty objects such as Drilldown and Toggles for Applets.
-Break down user requirements further to create work packages.
-Compilation of Development & Test Servers.
-Customized object definitions in the business object layer, as per customer requirements.
-Helped Technical teams to convert the Functional specs to Technical specification documents.
-Used Siebel Tools for modification, enhancement and customization of Siebel Business Components, user interfaces
-Written Business Services to achieve business requirement.
-Configured Thread bars, hierarchical Pick Lists and specialty objects such as Drilldown and Toggles for Applets.
ACHEIVEMENTS
Received Excellent Performance Award from CEO, L&T Infotech for Outstanding Delivery, meeting Customer satisfaction and demonstrating exceptional Offshore Lead.
Highly appreciated by Lafarge North America for my role as Project Lead to identify the tool and design, develop & implement BI solution for financial management.
Earned client (Hyperion, AICTE, ATi Allvac, Cisco) appreciation for implementing best practices in the development process by identifying gaps, problem resolution and non-standards.
EDUCATION
Master of Computer Applications, Madras University, INDIA
Bachelors of Science (Computer Science), Mahatma Gandhi University, INDIA
Contact this candidate