PROFILE:

• I am an ambitious Senior Business/Systems Analyst, EDW Architect, IT Project Management Professional and Senior Business Intelligence Consultant with over 20 years of diversified experience on Large Scale Implementation Projects.
• I have been involved in preparing project documentation, designing, and development of IT Architecture, Integration with legacy applications, Modeling, Extraction, Authorization, Transportation, Trainings, and Development of dashboards & analytics.
• I also carry Project Management and Team Management skills that include project management documentation, requirement - gathering skills, managing large-scale projects right from pre-sales presentation to writing technical proposal and project charters to carrying out implementation the project.
• I have extensive subject matter expertise in IT Services Management (ITSM) and ITIL, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.
• I also bring in the perspective and vision gained by the education in IT, Marketing and Business Management, having excellent interpersonal and communication skills.
• Excellent in building client relationship
• Strong in writing technical documents e.g., Data Warehouse Architecture, BI Audit Plans, BI Audit Reports, Functional & Technical Specs, Project Planning, Project Documentation, Requirement Gathering, KPI Analysis, GAP Analysis, Project Implementation, Quality Assurance & Testing, Training Plans
• Solid in project management essentials of initiating, planning, executing, monitoring, and closing as well as processes, methodologies, tools, scope of management, budgeting, financial tracking, scheduling, resource management, solution identification and assessment, vendor selection, procurement, contract negotiations, and business case creation. Proficient in Waterfall, Agile, PMBOK, PMLC/ SDLC project management methodologies.
• Good Knowledge of SAP HANA
• Effective interpersonal, communication, analytical, technical and leadership skills
• Proactive, self-motivated and a good team player
• Ability to work under pressure
• Quick learner, flexible and adaptable
• Data Warehouse: Ralph Kimball’s Methodology
• BI and Analytic Solutions: Business Objects (BO 5.0- SAP BO 4.1):SAP BO Business Intelligence Platform, SAP BO Web Intelligence, SAP BO Dashboards, SAP BO Analysis Edition for OLAP, SAP BO BI Launch pad, SAP BO BI workspaces, SAP BO Explorer, SAP Crystal Reports, Information Design Tool, Universe Design Tool, Lifecycle Management Console, Qlikview, Qliksense.
• Database: Oracle 8, 8i, 9i, 10g, 11g. Sql Server.
• ETL: SAP BO Data Services (BODS), SmartDB

PROFESSIONAL SUMMARY:

• More than 20 years’ experience in full life cycle implementations, involved in all ASAP phases mainly in requirement gathering, workshops, designing, development, testing, training, transportation, go-live and post go-live support
• Experience in leading BW team and BW projects for technical realization of BW/BO solutions
• Experience in project management documentation mainly Project Planning, Project Documentation, Requirement Gathering, KPI Analysis, GAP Analysis, Project Implementation, Quality Assurance & Testing, Training Plans
• Experience in creating ad hoc reports using Web Intelligence. Sound knowledge and expertise in creating dashboards using Dashboard Designer and Universes using Universe designer/Information Design Tool
• Experience in setting up BO server, administration and integration with SSO services
• Expertise in Data Modeling using Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models.
• Strong Analytics/Data warehouse experience using SAP Business Objects Data Services. Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms(Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target. Strong experience in cleansing the data using Data Quality transforms. Proficiency in data warehousing techniques for Slowly Changing Dimension phenomenon, surrogate key assignment and Change Data Capture. Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting. Data modelling (Dimensional & Relational) concepts including Star-schema modelling, Snowflakes modelling, fact and dimension tables. Worked on Change Data Capture on both Source and Target level for SCD (Slowly changing Dimension) Type 1, Type 2 and Type 3.
• Experience in creating views, tables, and data files in Oracle.
• Involved in the post go-live support, which required performance tuning/optimization of the system using indices, remodelling etc.
• Experience in implementing BO authorization using groups/roles and data level authorization
• Good knowledge of ASAP methodology
• Achievements
• Implemented BI solution for SAP ECC & E&P Industry.
• Data Warehouse project for E&P Confidential .
• BANNER Student Registration System for group of Colleges
• Hogatex Hotel Management Implementation for various reputable Hotels.

IT SKILLS:

Proficient in: Microsoft Project, Ms Visio and Ms Office 2000/2003/2007 Expert user of all Microsoft Windows Platforms including Advance Server

Technical knowledge of computer troubleshooting and Networking:

HW & OS: Sun Enterprise 3000 (Solaris 2.6), HP-9000 (HP-UX), Data General (DG-UX), PC (Windows XP, NT & 2000), VAX & Alpha (Open VMS), IBM 4381, MV (AOS/VS), DG-10 (RDOS), HP3000 (MPE).

RDBMS: Oracle Server 7.0.x - 10g Rel 2, Access, Power House, Dbase, Icobol.

Oracle: 7 - 11g SqlPlus, PL/SQL.

Oracle Developer: SQL*Forms, SQL*Reports, RPT

Oracle Designer: Repository Object Navigator, Design Editor, Entity Relationship Diagrammer, Server Model Diagrams Oracle Enterprise Manager, SQL*Net, SQL*Loader, Import, Export Toad

ETL: BO Data Integrator - Business Objects Data Services (BODS) Implementation. Smart DB Complex Implementation. Visio Professional 2003 SQL * XL Universal Business Objects (5.0) - SAP BO 4.1

BI Platform: Installation, Administration, Support, Training

Crystal Reports: Product Demos, Implementation, Support, Training

Universe Designer - Information Design Tool: Product Demos, Implementation, Support, Training

Web Intelligence: Product Demos, Implementation, Support, Training

Central Management Console: Information Design Tool Product Demos, Implementation, Support, Training

InfoView: Training, Consultancy, Product Demos

Dashboard Manager, Performance Manager, Xcelsius - Dashboard Design: Training, Product Demos, Implementation.

Languages: SQL, PL/SQL, C, Cobol, UNIX Programming, HTML

Application: FINDER Data Management System (Exploration & Production Data Base), BANNER Student Registration Systems, Accounting / Finance / Inventory Packages, HOGATEX Hotel Management System.

PROFESSIONAL EXPERIENCE:

Senior Systems Integrator - SAP Business Intelligence

Confidential

Responsibilities:

• Project Manager for Maintenance Release Cycles related to Facilities Maintenance and Real Estate modules. The tasks involved are defining scope, monitoring progress and ensuring the deployment is achieved in the allocated time.
• Service Management process improvements utilizing HP Service Management and Solution Manger tools.
• Involved in Solution Manager 7.2 functional specifications
• Business Intelligence reporting for statistics related to Solman Service Management.
• Proving triage for all Solution Manager Service Requests / Incidents related to Business Intelligence.

Technical Lead

Confidential

Responsibilities:

• Collaborating with Enterprise Business Intelligence Foundation Project in order to ascertain that the ML& S Data Mart project follows the City's BI methodology & framework.
• Collaborate with City's SAP division in order to follow the technology, guidance that is in place for all SAP BI Projects.
• Overseeing sustainment of ML&S DataMart Phase 1 sustainment project.
• Responsible for planning & implementation of ML&S DataMart Phase 2 project.

SAP Business Objects Consultant

Confidential

Responsibilities:

• Lead for SAP Business Objects Upgrade from BOBJ 4.1 SP5 Patch 5 to BOBJ 4.1 SP7 Patch 3 for all the BOBJ Clustered Environments on cloud & on premise.
• Provide Solution Architecture and subject matter expertise to implement SAP Business Objects 4.1 as a reporting solution for the entire RISE Reporting program.
• Provide experience in Data Modelling, Enterprise Infrastructure, Universes and Report development to meet the Basel regulatory requirements for Confidential 's Risk related reporting.
• Experience with Data Services, Information Steward.

Manager, Technology Advisory

Confidential

Responsibilities:

• Assisted in Business Development activities related to projects with respect to Business Intelligence.
• Provided consultancy as a Solution Architect.
• SAP Business Objects Infrastructure Setup, various Web Intelligence reports on BW queries for Dominion Diamond Corporation. Underlying database was Sqlserver.
• Designed and developed ETL routines in Business Objects Data Services (BODS), modified or created new Data Services jobs to meet project requirements. Sound understanding of end to end Data Migration process including Extraction, Data Profiling, Transformation and Generation of Load ready data files.
• POC implementations done using Lumira. Familiarity with SAP Design Studio.
• Data Migration Audit for Trillium Health Partners.
• Qlikview & Qliksense Agile Dashboards for various clients. Extracted data from various sources using Qlikview script editor, designed dashboards, and created various Qlikview solutions.
• Qualtrics Survey development & results Dashboards for various surveys.
• Dashboard development for ADP, Ontario Media Development Corporation.
• Intermediate knowledge of Birst product suite.

Confidential

Technical Environment: SAP ECC 6.0, SAP BW 7.3, BusinessObjects 4.0 suite including Web Intelligence, Dashboard, IDT and BO Mobile

Senior SAP BOBJ Analyst/BI Team Lead (Full Implementation)

Responsibilities:

• Led group discussions, conducted one to one interviews to elicit requirements from business unit teams and external/internal clients, and documented them in a Business Requirement Document (BRD). Created Systems Requirement Specification (SRS).
• Led the project and team of 6 BI consultants for this large scale project
• Allocated resources on different assignment according to their strengths
• Conducted regular meetings with management and team for project status
• Proposed technical solution for each individual Business Unit within this group project
• Coordinated foundation of Business Warehouse by team members who implemented SAP BW
• The infrastructure consisted of Oracle 10g Database.
• Created Universes & canned ad-hoc reports using WebI for on-the-fly customizable analysis of data. Created dashboard layout and presented before management. Created fixed format Crystal Reports which were called from Xcelsius Dashboards for drill down analysis. Created SAP BO Explorer reports for search and exploration.
• Utilized SAP BO Data Services (BODS) to extract data from excel, flat files, which was transformed & then loaded to the target tables. Various transformations such as lookup, join etc. were utilized in the workflows as needed.
• Helped and supported team members on difficult situations
• Trained junior resources and internees on BI platform
• Gave final product demo of Xcelsius dashboard to higher management
• Responsible for managing Data Centre and IT operations, in addition to capital budget preparation and oversight; IT disaster recovery; capacity planning and infrastructure; project management.

Confidential

Technical Environment: SAP ECC 6.0, SAP BW 7.3, BusinessObjects 4.0 suite including Web Intelligence, Xcelsius, IDT

Senior SAP BOBJ Analyst/BI Team Lead

Responsibilities:

• The Confidential Industries HR BI Project comprised on the seamless integration between SAP ECC, SAP BW and SAP BusinessObjects
• SAP and Non-SAP data from Natpet, XENEL, Safra and only Non-SAP data (in Excel format) from SCC, Hidada and Alujain.
• SAP ECC: Created INFOSETS/INFOSET query in SAP ECC and connected to Crystal reports.
• The non-SAP (Excel format) data was pulled, at regular intervals, to SAP Business Warehouse (BW).
• SAP BW was used to Model and Load the Non SAP data (i.e. Excel Sheets) on scheduled intervals into SAP BW.
• SAP BW carried out the Extraction, Transformation & Loading (ETL) process.
• Crystal Reports was used to feed data into the Xcelsius using LiveOffice connection. Crystal Reports were based on ECC Tables / Infosets or BW Queries.
• All the Xcelsius KPIs were created based on LiveOffice connection.
• When user executed/refreshed the Xcelsius Dashboard, the LiveOffice refreshed the underlying Crystal Report which in turn requested fresh data from the underlying database thus forwarding the latest available data to the Dashboard.
• Data Governance: Created data governance and privacy policies; Defined accountability procedures governing data access, processing, storage, retention, reporting and auditing

Confidential

Technical Environment: Oracle EBS, INFOR, SAP BO 4.0 suite including Web Intelligence, Crystal Reports, Xcelsius Dashboard Designer and BO Mobile

Project Manager

Responsibilities:

• Meeting with clients for their requirements, providing liaison between SAP KSA and client, prepared technical proposal, presented the technical proposal before business heads and explained the proposed solution
• Kicked off the project, created the project documentation such as project plan, resource allocation plan, project charter, communication plan, issue escalation plan etc.
• Gathered client’s requirements, corroborated in business blue print document
• Created Universes to model data from various sources, which supplied data to Crystal Reports & Xcelsius Dashboards.
• Daily status updates from BI team.
• Resolved issues that could have resolved at my end. Escalated the severe issues to steering committee
• Followed up issues resolution with Steering Committee

Confidential

Technical Environment: Business Objects clustered installation

Senior SAP Business Objects Support Consultant

Responsibilities:

• Providing Support, Trouble Shooting, Enhancing current setup related to Business Objects Enterprise R2 & 3.1 SP2, Crystal Reports XI R2 SP2 & 2008 V1 SP2, Web Intelligence & Xcelsuis.
• Business Objects 3.1 SP2 is installed in a clustered mode on two Windows 2008 servers with Web Component Adapter installed on two Solaris 10 servers with Weblogic 10.3. The Weblogic 10.3 servers are running in active passive mode, being load balanced by Resonate.
• Implemented AD Authentication with Kerberos along with Single Sign On via Vintella to Business Objects Enterprise.
• Giving POC demonstrations on BOE, Universe Designer, Live Office, Query as a Web Service, Web Intelligence & Xcelsius.
• Architected, managed, and implemented Disaster Recovery Test.

Confidential

Technical Environment: Diversified Landscape

IT Consultant

Responsibilities:

• Have been involved in preparing various Technical Solutions Proposals.
• Proposal for Confidential ’s Material Management Division to enable them to have a control on their Stocks at Hand, what needs to be procured from various suppliers, suppliers distribution schedule etc.,
• Proposal for Implementing Business Intelligence & Data Warehousing System at King Fahd University of Petroleum & Mineral Sciences
• Proposal for achieving NCAAA accreditation at Prince Mohammed University, as well as Developing & Implementing Balanced Scorecard.

Confidential

Technical Environment: IBM Servers running Oracle

Data Warehousing Consultant

Responsibilities:

• Prepared Data Warehousing Framework, Requirements Gathering & Dimensional Model for Prod/Inj Data Mart
• Evaluated Bill Inmon’s & Ralph Kimball’s approaches & chose Kimball’s Business Dimensional Lifecycle methodology for preparing a framework document for Planning, Requirements Gathering, Implementation & Deployment phases.
• Gathered requirements based on Interviews, studying analytic matrices & current reports.
• Created matrix listing facts & dimensions
• Implemented Dimensional Model for Production/Injection Data.

Confidential

Senior BOBJ Analyst / Corporate Solutions Manager

Responsibilities:

• Responsible for Requirements Analysis, Technical Evaluation, POC’s & Implementation for Oil & Gas sector clients.
• Following up on Leads, giving Technical Presentations, Requirements Analysis, proposing the right solution, carrying out Proof of Concept studies
• Providing Training & Consultancy on Bobj tools such as CMS, Infoview, Universe Designer, Web Intelligence, Crystal Reports.
• Powerful modeling of business processes and enterprise architectures & requirements-driven development of advanced systems and software using Telelogic.
• Preparation of Tender specification documents. Negotiation on Service Level Agreement’s clauses with Clients.

BOBJ Analyst / Project Coordinator

Confidential

Responsibilities:

• Created Procedures, Functions, Triggers & Views to implement Business Logic.
• Implemented Oracle role based security, Performance Tuning & resolved Schema Inconsistencies related to Data integrity.
• Installation & Configuration of Oracle Server & Tools.
• Tuning & Troubleshooting the Database and the Application. Recognizing bottlenecks in the Architecture and specifying effective ways to overcome them.
• Involved in Software evaluation such as Front End Tools, Reporting Tools etc.
• Involved in planning future storage needs for all the Applications.
• Provided training to technical staff in the following areas: Oracle, Unix, SmartDB, Business Objects, Microsoft Project, Excel etc.
• Provided training on Applications used in Confidential Department to end users such as: Finder, LogDB, Business Objects developed Universes & Reports
• Provided Training on Data Model Specifications related to Oil & Gas Applications, Project Management Methodologies, Software Development Lifecycle, Data warehousing / Business Intelligence Methodologies.