Overview

• Sr. Business Intelligence Consultant with exceptional skills in Analysis, Development, Testing of Business Intelligence applications in the area of Business Objects, Data Warehouse, RDBMS, Client/Server environment applications on Windows platforms across various Business Units.
• Right blend of business and technology expertise with strong leadership, interpersonal communication, analysis, design, implementation and integration skills in providing enterprise-wide Business Intelligence solution.
• Expertise in migration, version control, and developing and testing Business Objects products including server and desktop products.
• Acquired very good Business Intelligence application development skills and delivered several projects for fortune 500 customers.
• Excellent working knowledge of Databases, Data Warehousing concepts and proficient in reporting Business Objects
• Over 9 years of IT experience in application development and providing Reporting Solutions in transactional and data warehousing environments
• Seasoned SAP Business Objects Consultant with 6 plus years experience in Designing, Developing and Implementing Reporting Systems.
• Proven expertise in different modules of SAP BO Products Suite that includes Business Objects / Desktop Intelligence reports, Designer, Supervisor/CMC, Infoview, WebIntelligence, Crystal Reports, Zabo, SAP BI/BW, Bex /MDX queries, XCelsius 4.5, XCelsius 2008, QAAWS, Live Office
• Worked on various versions of Business Objects like BO 6.5, XiR2, Business Objects 3.1 and 4.0
• Expert in trouble shooting issues and Installation Configuration of Business Objects Enterprise product Suite.
• Sound knowledge of Datawarehousing concepts like dimensional data modeling, star and snowflake schemas
• Proficient in SQL and PL/SQL
• Sound knowledge in Software Development Life Cycle
• Have been involved in raising various change requests, validation and the post production validation along with support and warranty
• Excellent interpersonal, communication, documentation and self-organizing, Managerial skills

Skills

• Operating System : Windows2003/2000/98/95/NT 4.0/XP, UNIX, DOS
• Business Intelligence Skills : Worked with Business Objects Enterprise 3.1, XI R2, XI, 6.x,5. x Suite, WebIntelligence 3.1, XI R2, XI, 6.x, 5.x, Xcelsius 2008, 4.5, QAAWS, XML, LiveOffice, BI Services, Crystal Reports XIR2, Business Objects XI R2 integration with SAPBW, Business Objects Designer, Xcelsius 4.5 / Xcelsius 2008Web Application Servers : IIS, Apache Tomcat Server
• Languages : C, HTML, DHTML, SQL, PL/SQL
• Databases : Oracle 7.x/8i/9i/10g, SQLserver6.5/7.0/2000, DB2, MS-Access

Experience

Confidential

Senior BI Consultant

• The Confidential is a diversified, privately held real-estate investment company and master-planner highly respected for stewardship and master-planning of The Irvine Ranch in Orange County, California. With operations throughout coastal California, Irvine Company plans and brings to life balanced, sustainable communities with a full range of housing, job and retail centers, schools, recreation, and permanently preserved open spaces.
• Involved in the architecture and development of Executive dashboard, Office Key Results Dashboards built on top of BEx queries using BICS Connection
• Worked closely with the top management to understand and build most critical KPIs like Health Ratio, Cost Of Occupancy, Guideline rates, Starting rates etc
• Worked closely with Business to come up with the architecture of Lead to Lease reporting solution that traces end to end how the potential customer is converted into a Opportunity and into an Executed Lease. As part of this, several stored procedures, views have been created that are used at the Universe level to build a dimensional model. This Universe is leveraged to churn out reports with several advanced metrics
• Designed SAP BW based Webi reports for the Apartments, Office and retail divisions
• Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Office division
• Data Analysis requirements analysis
• Closely worked with business users to train and understand the core issues which in turn are converted to simple and easily usable dashboards and Webi reports
• Requirements were exhaustively analyzed and best design approaches were brainstormed to come with an intended design plan before starting the development
• Worked with SAP to report and resolve product errors or find an alternative design approach in times of technical limitations
• Worked closely with BASIS team to translate security requirements and create specific roles to enable judicious use of SSO Vs Fixed user access
• Helped in testing User Security roles in Quality Environment before rolling out the BI solutions at backend level using RSECADMIN and at BOBJ level using Test IDs created with collaboration with the Business Objects administrator
• Created and maintained Design documents and Help templates to guide Users on navigation, usage of BI solutions

Environment: SAP Business Objects 4.0 SP8, Information Design tool 4.0, Universe design Tool 4.0, Web Intelligence 4.0, Dashboard Design tool 4.0 Xcelsius tool from Business Objects 3.1 , SAP BW Analyzer, Query As A Web Service QAAWS , BICS connection, SQL Server 2008, SAP BW 7.0

Confidential

Senior Business Objects / Xcelsius Developer/ Administrator

• Designed various Xcelsius dashboards for the Advanced Meter project, IT Dashboard etc.
• Designed Web Intelligence reports for the Productivity Reporting systems PRS project
• Administration of Business Objects XIR2, SAP Business Objects 3.1, SAP Business Objects 4.0 environments and servers
• User Security Folder Security management
• Designed SAP BW based reports for the Advanced Meter MTU projects
• Used Dashboard Design tool to design Dashboards in Business Objects 4.0 for the Advanced Meter KPI project.
• Used XML, BI Services, QAAWS data connectivity tools to design Dashboards
• Used Information Design tool to create multi source universes in Business Objects 4.0 for Productivity Reporting Systems
• Created wrappers to host the Dashboards for Advanced Meter KPI project
• Overall security analysis and User Groups management
• Converting Business Objects XIR2 universes to SAP Business Objects 3.1, 4.0 Universes
• Data Analysis requirements analysis

Environment: SAP Business Objects 4.0 SP4, SAP Business Objects 3.1, Business Objects XIR2Information Design tool 4.0, Web Intelligence 4.0, Dashboard Design tool 4.0 Xcelsius tool from Business Objects 3.1 , Query As A Web Service QAAWS , Live Office, CMC, SQL Server 2005, SAP BW 7.0

Confidential

Senior Business Objects / Xcelsius Developer

• Designed various Xcelsius dashboards for the Foreign Agricultural Services FAS and OCFO Office of Chief Financial Officer
• Involved heavily with requirement gathering and a complex analysis for building the Xcelsius dashboards and Web intelligence reports for the Operational Reporting
• Involved in multiple working sessions with various users, managers to build prototypes for various dashboards for Financial Management, Budget Vs Actual Comparison, Human Capital Management etc.
• Documented Design documents, Technical Specifications documents, Functional Specifications Documents etc.
• Involved in the Financial Management Modernization Initiative FMMI and passed various tests for the access grants
• Worked with customized components and embedded them into Xcelsius 2008 successfully by creatively bypassing technical limitations of Xcelsius limited out of the box components

Environment: SAP Business Objects 3.1, Designer, WebIntelligence, Xcelsius 2008 SP3, Query As A Web Service QAAWS , Live Office, CMC, SQL Server 2005, SAP BW 7.0

Confidential

Senior BI Consultant

• Created Scotts Canada Garden WebIntelligence Reports using BW as a source
• Designed, developed Dashboards using Business Objects Dashboard Design 4.0 and connectivity tools such as BICS
• Handled overall Content Management and Security
• Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions
• Defined various Security roles and assigned users to custom groups defined for a better user rights administration and maintenance
• Handled migration of dashboards and reports
• Created Dashboard specific universes and created derived tables to cater to the dashboard requirements
• Heavily documented findings and environment details for a continued ease of maintenance
• Resolved various issues as an administrator which include, issues with Crystal reports and MS Access, SAP BW as a Database
• Resolved scheduling issues with various reports and streamlined the scheduling times in order to lower the processing burden on the servers
• Worked closely with the SAP BW developers and administrators to streamline the rights conflict with the user rights in the Business Objects Environment and import the SAP defined roles into the Business Objects Environment
• Raised tickets with SAP Support coordinated with them to get a closure on various technical issues and bugs and also to understand some of the best practices pertaining to the issues
• Assisted users with training and resolving any issues that come up on a time to basis

Environment: SAP Business Objects 4.0/3.1, Business Objects Administrator, BI Services, XML, WebIntelligence, Dashboard Design 4.0, BICS

Confidential

Senior Business Objects / Xcelsius Developer

• Created CSPMI Universe from the Remedy tables along with the respective Web Intelligence reports
• Created Monthly and Daily dashboards with each dashboard reporting up to 2 years of data monthly and daily level. The source data combines Customer Complaints, Ridership and the On Time Performance of the trains overall at route level, category wise and train level for different time dimension
• Integrated the Web Intelligence reports onto the Dashboards using Opendoc functions
• Performed Unit, Regression testing and also Capacity testing.
• Built derived tables in the universes by fetching only necessary data from the data base tables
• Merged various Web services into one big Web Service and thus reducing the number of times the clicks invoke the web services.
• Developed and maintained/appended the Mechanical/Expense YTD universes
• Developed Acela Continuous Maintenance Dashboard and integrated various Crystal reports onto the dashboard
• Developed various detail dashboards for Mechanical work floor project which would enable the dashboards to be displayed on the Mechanical work shop screen display as well as deliver a working model for interactive report churning for the management
• Proposed various prototypes for the Chief Operating Officer
• Worked for the Safety department and churned out prototypes
• Analyzed the nature of the data and delivered 6 dashboards for the Safety department for Injury/Illness reports
• Upgraded the Business Objects reports, dashboards, universes to the Business Objects 3.1 instance

Environment: SAP Business Objects XIR2, SAP Business Objects 3.1, Designer, WebIntelligence, Crystal Xcelsius 4.5, Xcelsius 2008 SP1/SP2/SP3, Query As A Web Service QAAWS , Live Office, CMC, SQL Server 2005, SSIS

Confidential

SAP Business Objects Developer

• Coordinated with the Business Owners to outline Business Requirements.
• Worked with Business Systems Analyst to understand the flow of data.
• Liasoned with the regional heads of Singapore, London and Taiwan to seamlessly connect all the requirements and help complete the Business Requirement Document.
• Acted as the lead developer for Sell-Thru reporting segment. Reports were reconstructed in Web Intelligence and Crystal Reports from SAP BW reports.
• Scheduled documents to different users using CMC Central management console
• Created Hierarchies to facilitate drill-down in the Desktop Intelligence reports
• Created and maintained Business Objects Web Intelligence reports.
• Built Cross Tab reports
• Concierge Project involved the study and analysis of the required data and pooling up different data from three different data warehouses for the sake of building up a common universe
• Created pre-defined conditions and universe level prompts making it easy for business users to utilize these objects
• Created complex objects in the universe to capture the business logic

Environment: Business Objects XiR2, WebI Reports, Crystal Reports, Infoview, CMC, SAP NetWeaver BI/BW, SQL Server, Apple Mac OS X, Windows XP/2003 Server, Oracle 10g.