SUMMARY

• Highly motivated BI specialist with a solid track record of building teams and delivering products. Over 18 years of extensive technical experience with Business Intelligence solutions and Data Warehouse environments. Including all the major commercial Relational Databases (Oracle, DB2 udb, MS/SQL Server), Data Modeling, OLAP systems (Oracle OLAP, Microsoft Analysis Services, SAP/BW), Query-Report tools (Business Objects, Crystal reports, Oracle Discoverer) and ETL tools (Oracle Data Mart Suite, Oracle DI, Microsoft DTS, and Business Objects Data Integrator).
• Extensive experience in designing, architect, data modeling (star schema, snowflake, dimensions, aggregation/summary tables, Oracle MV, tables partitions & indexes, Slow changing dimensions – type 1,2,3, ROLAP, OLAP cubes) of business intelligence and Data warehouse in client environments.
• Deep experience and knowledge of BusinessObjects Enterprise (XIR2, XI 3.1) and Business Objects Data Integrator (11.7). Experience in fulfilled designing, implementation, customer support and consulting.

Confidential, Silicon Valley, CA
Senior Business Intelligence
/SAP Business Objects Specialist Dec 2008 – Present

SAP Business Objects XI 3.1

• Experience with implementing Business Objects XI 3.1 with SAP BI/BW as a data source
• Experience with the new features in Business Objects 3.1 (Example: tracking feature)
• Active participant in full-cycle implementation of SAP Business Objects XI 3.1(from project planning to go-live and post go-live support)
• Experience with strategy and Concept of Operations development around Business Objects and SAP BI/BW integration
• Experience with SAP BI/BW, including ODS, InfoCubes, MultiProvider, and BEx query development
• Has merged data between SAP BI/BW and other external data sources (e.g., an Oracle database, flat files, etc.)
• Understanding of integration (pros, cons, etc.) between Business Objects and SAP BI/BW
• Hands-on development experience with Business Objects Webi, Universe Designer, Webi Rich Client, and Xcelsius 2008, SAP MDX
• Experience with SAP Business Objects MDX (Predefined filters and calculated Key Figures)
• Experience and Hand-on with universes/reports/security migration from Business objects XIR2 to XI 3.1
• Expert with Business Object XI 3.1: Universe-Designer; Reports- Full client (Deski),Webi and Webi Rich Client; Central Management Console (CMC)- security, scheduling, publisher and administration.
• Developing a high level Webi and Deski reports including design and implementation.
• Testing, data validation and deployment activities for universes and reports
• Troubleshooting, diagnosing, supporting and resolving issues and complex requirements.
• Gathering requirements and develop logical & physical data models and translate business information into BI solution requirements.
• Experience with CMC 3.1 –security level for user (and user group), Webi reports, folders, universe, data connection.
• Experience with Voyager tool, providing dashboards based on OLAP connection
• Responsible of SAP Business Objects XI 3.1 User guide and training documents, for basic and power users.
• Writing Business Objects user courses and training documents.
• Training/course instructor for local and International users.
• Interface to Sales & Distribution, Inventory, Revenue, Forecast and Finance experience
• Ability to quickly learn the important aspects of new technologies.

Confidential, Los Angeles, CA
Senior Business Intelligence
/Business Objects Specialist Aug 2008 – Nov 2008

BI team: Lead the Business Objects query & report

• Working with Project Lead, Data Warehouse Architect and Business Analyst to design and maintain Business Objects XI R2 reports and universe
• Gathering requirements and develop logical & physical data models and translates business information needs into BI solution requirements
• Date Warehouse: Define, design and build a comprehensive reporting data warehouse
• Gathering requirements and providing solutions for internal departments as well as implementing complex data models, architecting the data warehouse and reporting using Business Objects with SAP/BW.
• Supporting all facets of the company by performing reporting duties, administration and data analysis
• Expert with Business Object XI R2: Universe-Designer; Reports- Full client (Deski) and Webi; Dashboard –PM; Central Management Console (CMC)- security, scheduling and administration.
• Developing a high level Webi and Deski reports including design and implementation.
• Driving business objects technology architecture and infrastructure design activities.
• Leading, maintaining and supervising universe and reports
• Testing, data validation and deployment activities for universes and reports
• Migration reports and universe to variety environments
• Involved in the full lifecycle of Business Objects and data Warehouse implementations
• Troubleshooting, diagnosing, supporting and resolving issues and complex requirements. Examples: user reports (ad-hoc, on demand and predefine reports), query performance, Business objects universe design and structure, software error messages, data migration, installation issues.
• Gathering requirements and develop logical & physical data models and translate business information into BI solution requirements.
• CMC – responsible on the security level for user (and user group), Webi reports, folders, universe, data connection security level.
• CMC – responsible on the report scheduling, destination and notification.
• Responsible for Business Objects Auditing, tracking user activities and events.
• Troubleshooting and resolutions – query performance, tuning Business objects universe and Relational Database, software error messages, data migration, installation issues, report issues
• Experience with SQL (understanding, writing) and data modeling (start schema, snowflake..)
• Develop process and design documentation
• Execute data migration test plans, repository migration
• Ability to quickly learn the important aspects of new technologies.

Confidential, Los Angeles, CA
Senior Business Intelligence Specialist Dec 2007 – Jun 2008

• Expert in primary aspects of data warehouse and business intelligence technologies including:
• ETL - Extract, Transform and Load (e.g. MS DTS, Oracle -ODI, Business Objects-Data Integrator)
• Database modeling and storage (e.g. MS SQL/Server, Oracle 10g, IBM UDB)
• Reporting and analysis delivery tools and applications (e.g. Crystal report, Business Objects, Oracle OLAP)
• Trouble shooting and resolutions – query performance, tuning Business objects universe and Relational Database, software error messages, data migration, installation issues.
• Business Intelligence Architect - able to set and enforce standards and overall architecture for the enterprise information. Gathering requirements and develop logical & physical data models and Translates business information needs into BI solution requirements.
• Assist in sessions with subject matter experts in an effort to formulate application design requirements.
• Driving technology architecture and infrastructure design activities
• Leading and supervising technology build, test and deployment activities
• Troubleshooting, diagnosing, and supporting application development.
• Focus on data warehouse and business intelligence solution implementation
• Skilled to develop a technical vision based on industry standard and architectures for implementation of data warehousing and business intelligence solutions
• Expert with Business Object XI R2: Universe; Reports- Full client (Deski) and Webi; Dashboard –PM and XCelsius ; Central Management Console (CMC)- security and administration).
• Developing a high level design which supports a robust technology solution, taking into account the user requirements, security, technical requirements, etc.
• High level of design and develop Business Objects (XIR2) reports (Full Client (Deski), Webi), Universes (designer and universe builder), dashboard (Performance Management , XCelsius); analytical metrics and queries integrating with other corporate applications.
• Architected & implemented the BODI (Business Objects Data Integrator) and ETL environment. Gathered and documented ETL specifications which were used by the BODI to develop the mappings Installed, patched and administered BODI
• Hands on development of ETL mappings and workflow. Debugged mapping and tuned existing mappings

Confidential, Torrance, CA
Business Intelligence Specialist/Lead Jul 2006 – Oct 2007

The company is a full service broker, dedicated to providing superior insurance products and services. IT department– Variety of external applications on Oracle Database. Business Objects XIR2 is the primary BI repot tool and dashboard. BusinessObjects Data Integrator 11.7 is the primary ETL tool
DWH Architect

• Architected the BI environment
• Architected and designed robust and scalable star schema EDW (Enterprise Data Warehouse) using common dimensions, historical, trending, and comparative facts.
• Using Universal Data Model (UDM) standards to design logical and physical data models
• Designed EDW using Type 1, 2 dimensional models using Ralph Kimball’s methodologies.
• Design aggregation tables and rollup tables to tune the EDW performance.
• Architected the ETL Loading and Archive strategy for the EDW loading process
• Gathered requirements from both technical and business and documented the findings.
• Analyzed the source data and created technical specifications with minimal information and supervision
• Designed ETL, Meta data management, and dynamic load management processes.
• BODI & ETL
• Architected & implemented the BODI (Business Objects Data Integrator) and ETL environment. Gathered and documented ETL specifications which were used by the BODI to develop the mappings Installed, patched and administered BODI
• Hands on development of ETL mappings and workflow. Debugged mapping and tuned existing mappings
• Developed aggregate ETL mappings and used partitioning to improve performance.
• Implemented and enforced a deployment policy to minimize deployment errors.
• Implemented a load control and error handling techniques to prevent and capture loading errors.
• Prime responsible for the design, architect, implementation of Data Warehouse and Business Objects in the organization
• Responsible for gathering and analyzing data to give users a better way for business decisions.
• Leading Business Intelligence projects
• Responsible for overall architecture of Oracle Business Intelligence solution including database structure, Meta data, data modeling (such as star schema, snowflake, dimensions and cube (OLAP), ).
• Responsible on the Data Warehouse implementation (including create tables, performance tuning and SQL).
• Responsible on the ETL process and implementation using Business Objects Data Integrator ETL tool
• Responsible on metadata and repository management.
• Business Objects XIR2
• Gathering business requirements from users and clients and working with Business Analyst
• Managing expectations and making decisions about data warehouse development and business objects reports and dashboard
• Support existing Business Objects user’s community.
• Educate users to develop ad-hoc reports for quick reporting needs.
• Generate and optimize Business Objects Universes (Designer).
• Troubleshoot reports issues, including poor performance and bad data.
• Design and develop Business Objects (XIR2) reports (Full Client (Deski), Webi), dashboard (Performance Management , XCelsius), analytical metrics and queries integrating with other corporate applications.
• Training business analyst team
• Responsible on Business Objects administration, including security, authorization, definition and installation.
• Prime contact person with Business Objects support

Confidential,CA
Business Intelligence and Data Warehouse Specialist Apr 2000–Apr 2006

HyperRoll develops high-performance aggregation engine that significantly improves data load and retrieval time for OLAP and data warehousing environments.

Product: “HyperRoll for Relational” - Integration of Multi-dimensional structure and relational Databases.

• Joined an early stage startup that was designing software based on advanced algorithms for Business intelligence. Assembled and managed a technical team that turned those algorithms into an actual software product.
• Prime responsible for the design, architecture and guidance of the development of “HyperRoll for Relational”.
• Interacted with customers on requirements gathering.
• Collaborated withsenior management, marketing, field salesand professional serviceson solution architecture and market requirements that led to winning sales and revenue increase.
• Currently responsible for the new generation product that seamlessly integrates with all the leading databases (Oracle, DB2, Microsoft SQL Server), and BI/reporting tools (Business Objects, Cognos, MicroStrategy).
• Results: The product was sold so far to over 35 customers worldwide including CitiGroup, Sabre, Procter & Gamble and Merrill Lynch, and became HyperRoll’s strategic product.
• Led teams (up to 10 people) in proof-of-concept projects, design requirement, configuration, and implementation.
• Owned and resolved complicated cases that produced satisfied customers and helped turn potential customers into actual customers.
• Defined the strategic direction, planned the road map, and analyzed market needs for the Relational product line.
• Performed market research, interacted with the customers, involved in POC, helped turn unique technology that enables BI solutions to become massively scalable – improving access speed by up to 100 times!
• Led Beta Site programs as part of the “go to market” program; defined the methodology of identifying, analyzing and positioning the product with a relational product customer.
• Highly technical and long experience Business intelligence tool, took an active part in OEM activities with leading Business Intelligence tools, participated in strategy meetings, recommended and demonstrated technical solutions.
• Took a full active role in benchmarking activities by designing, making decisions, leading a team and implementing the benchmark environment.