SUMMARY

• Confidential is a Business Intelligence (BI) Consultant with over 9 years of experience in Analysis, Design, Prototyping, Coding, Implementation, Maintenance, Documentation, Dimensional Modeling, Planning and Scoping of Data Warehousing and Business Intelligence Applications.
• His skill set includes ETL, creating technical design documents and extracting data from DB2, Oracle, Informix, XML, SQL Servers and Flat Files etc.
• He also has experience in BI/BI - APPS Analytics components such as Interactive Dashboard, Answers, BI Reports, BI Publisher, BI Presentation, Adhoc Reports and Custom Analytics.
• Confidential has interacted with stakeholders at all levels of the organization, coordinated and facilitated the testing for enhancements and bug handling during implementations (Development, Quality Assurance, User Acceptance, and Production).
• He possesses excellent linguistic and interpersonal skills.

TECHNICAL SKILLS

Platforms and Architecture: Oracle BI Suite EE (OBIEE) 10g/11g, OWB, Oracle Data Integrator (ODI) 10g/11g, Informatica., Oracle 9i OLAP, Oracle ERP R12, Oracle Retail and Merchandising(RMS), Oracle Web Agent, Oracle 8i, SAP-BODI, Hyperion FDMEE, Oracle Reports 6i/6.0/3.0/2.5, Weblogic server Administration, Hyperion Financial Analytics, IBM- Cognos, Data Stage

Programming Languages: HTML, Express SPL, OLAP DML, C/C++, PL/ SQL, SQL*Loader

Hardware Operating Systems: Windows NT, Windows 2000, Unix, Red Hat Linux

Databases: Oracle 10/11g, MS SQL SERVER, MY SQL, Informix, MS Access, DB200

Methodologies: Data Warehouse, Software Development Life Cycle (SDLC), Ralph Kimball DW Methodology, Bill Inman DW Methodology

Industries: OIL&GAS, Banking, Finance, Beverage, Retail, Airline, Communication, Insurance, Education, Manufacturing

PROFESSIONAL EXPERIENCE

Confidential, CA

Senior Consultant

Responsibilities:

• Manage BI project and perform analysis, design and or package review, development, testing, quality assurance, deployment, and production support.
• Responsible for analyzing project requirements, specifications, impact to existing systems and business areas and preparing time and cost estimates for system development work.
• Report on status of systems and projects on a regular and timely basis
• Escalate anticipated risk with mitigation and contingency options to management promptly
• Develop strategic partnerships with systems and business management and develop understanding of business unit’s goals and processes
• Recognize the need for improvement in existing process/applications, present solutions and implementation plan to team.
• Lead the overall delivery of projects including the direct management of project team members.
• Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability and value.
• Identify opportunities for incremental and accelerated growth, coalition building, and collaborative project execution
• Project/Work request implemented on time, within budget and meets the business expectations.
• Perform project management duties including the creation of status reports, work plans and presentations to stakeholders and management.
• Acts as the key interface with all the offshore teams, manages project schedules and ensures that high quality code is delivered in a timely manner.

Confidential, Redwood City, CA

Senior Consultant

Responsibilities:

• Perform analysis and support in the choice of a BI Solution; formalize business needs, define functional, technical and financial choice criterions; a company end users in the choice of the most adapted solution.
• PLM Solutions Change management; analyze and harmonize business and design processes; formalize business needs; manage deployment technical aspects (migration, specifications...)
• OBI EE System configuration & architecture Leading practices definition; OBI EE 10g to 11g upgrade Assessment and Recommendations, OBIEE and BI Publisher Development leading practices definition
• Manage the project; organize and animate the project follow up meetings; supervise technical staff ( OBI EE / ODI consultant and function JD Edwards consultant); track the spent vs. budget project workload; analyze and define workload for new user change requests (maintenance); develop new change requests; train internal and customer teams on the software evolutions;
• OBI EE Architecture configuration; Active Directory Integration with OBI EE and security detailed design; Oracle BI Publisher Java Customization (Core API, Web services, Bursting, Data templates); Reporting Platform Configuration Design; Report Publication and Scheduling Design; Reporting Platform UI Interface design
• User acceptance phase coordination; Key users training (more than 160 engineers and designers)
• Organize and animate the requirement gathering meetings; define the preliminary, the functional and the detailed analysis; define the interfaces data feed schemas; write and maintain the functional and technical documentation.
• Built Physical, Business, Presentation model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Oracle BI Analytics platform.
• Mapped presentation layer objects to Oracle BI Answers.
• Configured and Managed OBIEE Catalog manger.
• Develop and optimize the ETL static and dynamic processes with Oracle Data Integrator; develop Oracle BI Publisher Template for invoices and other enterprise documents; train the customer technical team for set up and maintenance; perform and follow up unit and integration test phases; guaranty delivered development quality and consistency;
• Develop and optimize ETL processes with Oracle Data Integrator; design cubes (measures, KPI, dimensions and hierarchies) in Oracle Business Intelligence Administration Tool; define security; develop dashboards and guided navigations; answer to users need in terms of alerts generation and delivery; execute and follow up unit, integration and functional testing; guarantee deliveries consistency; install, configure and maintain development, test and production environments; document technical installations (Windows server 2003);
• Coordinate User Acceptance Tests; define and write functional and user test scenarios; define training strategy; write and maintain the training materials; set up and maintain the eLearning web site; train and support key users (20 people); manage maintenance of the Enterprise Performance Management system
• Organize and animate requirement gathering workshops with end users; define business use cases; realize preliminary studies, functional analysis; realize detailed analysis; define data warehouse loading schemas; write and maintain functional and technical specifications;
• OBI EE and Oracle BI Publisher Training Curriculum and material design; Developer and Key Users training; Oracle BI Publisher Developers supervision; prepare Deliveries Test Plan and scenario.

Confidential, Chicago, IL

Technical Specialist

Responsibilities:

• Worked on Informatica Power center and Designer tool
• Created and maintained interface in a heterogeneous environment.
• Used and modified different ETL modules for complex transformation
• Imported the metadata from a selected system into the Informatica repository source.
• Export / Import different projects in Informatica from Development environment to QA and production environments.
• Create Batch and Real time packages in Informatica
• Create Bi-Directional interface from Legacy system to oracle E-business suite for data Synchronization.
• Install and configure Oracle Stream packages on database for Data replication /change and data capture.
• Delivery of daily/weekly/monthly/yearly outbound client extracts.
• Involved in analysis and requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel/Oracle BI Analytics platform.
• Built business model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Mapped presentation layer objects to Oracle BI Answers.
• Developed new subject areas in the repository per business requirements
• Used BI publisher for static reports and configured IBOT to schedule the BI reports and alerts.
• Created Dashboard, portal, and ad-hoc reports In Oracle BI-presentation services.
• Integrate OBIEE with OAM to enable SSO and populate the OBIEE session variable from http header variable.
• Implement Data level and object level security in OBIEE.
• Work on Hyperion (HFM) model and configure ERPI for data loading.
• Write stored procedure, trigger, sequences and user functions in PLSQL.
• Trained user for OBIEE reports.
• Overall project delivery and hot fixes.
• Onsite and offshore coordination.
• Resource management

Confidential, Atlanta, GA

BI Consultant

Responsibilities:

• Migrated master and work repository from Sunopsis version to Oracle Data Integrator ETL Tool.
• Worked on Oracle Data Integrator (ODI) / Sunopsis Designer, Topology Manager, Operator and Security Manager
• Database sizing & CPU estimation on Data Base, ETL & OLAP for Development Server, Test Server and Production Server.
• Performed risk analysis, Business requirements, Project Plan and Hardware/Software Requirements.
• Extract data from CSV file as a source using Database SQLDR capabilities into oracle tables
• Created data flow diagrams to demonstrate data origination and data flow sources and the data warehouse.
• Designed and configured the initial ‘folder’ structure / Meta-Model for selected environments.
• Data Model: Logical and Physical Data Design and Star schema Modeling.
• Create Batch and Real time packages in ODI.
• Worked on OBIEE 10g (10.1.3.4.1 ) version.
• Built Physical. Presentation, business model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Pulled User and group’s information from OID/LDAP and stored in OBIEE Administrator.
• Configure and Managed OBIEE Cache on database/table/user level.
• Created Dashboard, portal, and ad-hoc reports In Oracle BI-presentation services.
• Implement Data level and object level security in OBIEE.
• Delivery of daily/weekly/monthly outbound client extracts.
• Involved in developers training for ODI.
• Trained user for OBIEE reports.
• Onsite and offshore coordination.

Confidential, Grand Rapid, MI

BI Consultant

Responsibilities:

• Worked on Oracle Data Integrator (ODI) / Sunopsis Designer, Topology Manager, Operator and Security Manager.
• Created and maintained interface in a heterogeneous environment.
• Deigned and configured the initial ‘folder’ structure / Meta-Model for selected environments.
• Imported the metadata from a selected system into the ODI repository.
• Involved in Data Profiling and Data Cleansing activities.
• Managed and created materialized views in a production environment.
• Managed and scheduled the agents in different packages.
• Export / Import different projects in ODI from Development environment to QA and production environments.
• Setup the table’s structure in QA and production environment for initial load.
• Provided Siebel expertise in application, integration and technical architecture to the team.
• Implemented Security by creating roles & web groups, checks with External tables & LDAP
• Technical Impact analysis on ETL/OLAP design.
• Mapped presentation layer objects to Oracle BI Answers.
• Used BI publisher for static reports and configured IBOT to schedule the BI reports.
• Created Dashboard, portal, and ad-hoc reports In Oracle BI Presentation services.
• Defined Security Level in OBIEE.
• Managed the catalog manger in OBIEE.
• Wrote database procedure, function, trigger and sequences.
• Managed the clusters in servers.
• Involved with business user in testing, documentation, production troubleshooting and support.
• Involved in developers training for ODI.

Confidential, San Francisco, CA

BI Consultant

Responsibilities:

• Migrated master and work repository from Sunopsis version to Oracle Warehouse builder (OWB)
• Worked on OWB Designer, Operator and Security Manager.
• Performed analysis, design, development, testing and implementation of business required Siebel Analytics Dashboards and reports.
• Managed the Informix database in UNIX environment.
• Extracted Financial Data from SAP R/3 4.7 using OWB SAP module and integrate into different target.
• Managed and built OWB repositories and created workflow in OWB Designer.
• Designed and configured the initial ‘folder’ structure/Meta-Model for selected environments.
• Worked on Oracle 10g/11g Database for target in mainframe environment and the Size of Database is 4TB.
• Used I-series navigator as a client tool for DB2 and used import / export and maintenance Utilities for data loading.
• Managed the clusters in servers.
• Managed and scheduled the agents in different packages.
• Configured the IBOT in OBIEE.
• Mapped presentation layer objects to Oracle BI Answers.
• Provided Siebel expertise in application, integration and technical architecture to the team.
• Built business model and mapping layer, which include hierarchies, dimensions, and aggregates.
• Used BI publisher for statics reports.
• Involved in developers training for OWB.
• Used rational configuration and change management system.
• Delivery of daily/weekly/monthly outbound client extracts.
• Onsite and offshore coordination.

Confidential

Software Developer

Responsibilities:

• Gathered requirement from user and create a feasibility analysis.
• Gathered user requirement and documented complete business flow diagrams.
• Created Financial Analysis report for various projects.
• Created DFD, ERD, Test cases using Microsoft Visio.
• Used XML for storing Data.
• Used XQuery to extract and manipulate data from XML Documents.
• Used Macromedia Dreamweaver in designer to generate HTML.
• Helped in Database development and integrations.
• Created database model and developed data driven application using Web Focus.
• Maintained Data extraction and manipulated data in the production database.
• Involved in process improvement, cost analysis.
• Modified and Built Database using SQL Server 2005 and Oracle 9i, 10g.
• Wrote Triggers, Stored procedures, Indexes and Views.
• Gathered user requirements for Forms and Reports developments.
• Coordinated complete testing and implementation.
• Data acquisition, transformations, production migration and support activities.
• Created and monitored remote distributed SQL statements.
• Built Logical and physical design of database.
• Prepared administrator application in Forms 5.0 and Reports 3.0.
• Applied patches to production and development database servers.
• Designed and created cubes in Oracle 10g OLAP.
• Configured Database performance tool includes Oracle Enterprise Manager, SQL Navigator and used them for tuning of applications.
• Prepared source to target mapping documents.
• Prepared software requirement specification document.
• Data modeling using Erwin 3.5.
• Created SQL, UNIX shell scripts and Express Data Loader Programs.
• Managed clusters in servers.
• Created and scheduled SQL packages.
• Used rational configuration and change management system.
• Overall project delivery and hot fixes.
• Designed and implemented backup strategy.
• Created and monitored the database schema objects.
• Managed physical database structure, database objects, and database usage.
• Involved in process improvement and cost analysis.
• Write test cases.
• On site and offshore coordination