SUMMARY

• Over 10 years of in - depth experience in analysis, design, and development of Business Intelligence (BI), Data Warehousing and Data Analysis applications.
• Over 3 years of experience as team lead, supportive and sharing roles with strong communicative (both verbal and written) and interpersonal skills in team tasks and over 2.5 years of experience as Business Objects technical architect.
• As BO XI Team Lead coordinated the work of consultants in the team, had one to one meetings with Business Analysts and Business users to gather and document requirements, responsible for business review of planning process to perform gap-analysis, understanding of the client’s business model and existing information system architecture.
• As a BI analyst, performed planning, oversight and leading activities related to implementation, define technical solution documents and facilitated business partners in technical analysis, development, and maintenance.
• As a BO developer, having good understanding knowledge with all modules in BO 5.x/6.5/XI R2/XI R3.1 (CMC, CMS, CCM, Infoview, Desktop Intelligence, Web Intelligence, Import Wizard, Report Conversion Tool ).
• Experienced in advance reporting using BOBJ tools (Reporter, Designer, Web Intelligence, Supervisor, Broadcast agent and Info View).
• Worked with Business Analysts (BA) to balance short-term business needs and deliverables with long term design implications.
• Involved in creating universes, designing and maintaining various reports using Business Objects 5.x, 6.5 and XI R2/XI R3.1.
• Experience in developing canned / ad-hoc reports, scheduling and processing of reports, assigning privileges using BCA and Supervisor with high level of expertise in creating ad hoc reporting and fine tuning reports using variables calculation, multilevel breaks etc.
• Excellent understanding of data architecture, relationship modeling and effective aggregation of data.
• Designed and maintained security objects such as Users, User groups, permission and access rights through Supervisor/CMC.
• Experienced in Migration from version 6.5 to version XI R2.
• Team-Oriented and focused on delivering exactly what the client needs to succeed in a timely and efficient manner, with amazing communication skills and a strong desire to excel.
• Worked with End-To-End implementation with Data warehousing team and Strong understanding of Data warehouse (DW) concepts Star Schema, Snowflake Schemas and Multi-Dimensional Models for query and analysis requirements.

TECHNICAL SKILLS

BI Tools: Business Objects XI 3.1, R1/R2/R3/ 6.5.x/5.x/- Supervisor, Performance Management XI R2, Reporter, Designer, Broadcast Agent, Publisher, Web Intelligence, Rich Client, Live Office Business Objects 4.1/5.0/5.1.3/5.1.6/6.1 a/6.5 Reporter, Designer, Supervisor, Web Intelligence (Webi), Broadcast Agent (Document Agent/Publisher), BO Auditor, Info View, ZABO.

ETL Tools: Informatica Power Mart and Power Center 8.5/7.1.

Platforms: Windows, LINUX, UNIX

Databases: Oracle 11g/10g/9i, MS SQL Server 2005/2000, MS Access.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Business Objects Developer

Responsibilities:

• As a member of the Global Data Management (GDM) group, self was responsible for both delivery and maintenance of various Business Objects related projects supported by the group.
• Worked in partnership with thebusiness, assisted inbusinessanalysis and perform data source analysis.
• Assisted in creatingbusinessrequirements specifications and responsible for building the functional and technical specification.
• Designed Business Objects Universes for various data models including, Star schema, Snow flake schema and OLTP data models.
• Participated in the entire system development life cycle, followed the ELC (enterprise life cycle) methodology to ensure accuracy of the deliverables.
• Responsible for unit testing of reports to confirm that they work as expected in Development environment, both in Crystal Reports and when published toBusinessObjectsEnterprise XI R2/3.1 environment.
• Enabled aggregate awareness to encompass the aggregate logic using summary tables.
• Prepared user documentation for hands on training of end user community.
• Resolved loops by creating alias and contexts to remove cyclic dependencies between the tables.
• Provided the supporting role in designing the Security Architecture in the Business Objects XI.\
• Acted as the performance specialist by tuning the reports and underlying queries.
• Currently acting as the post production support lead to support a global user base of over 400 users with 10 universes and close to 150 reports.
• Working with the business to gather support tickets, enhancement requests and major projects and managing releases.
• Working with the on-site and the off-shore support team to manage support tickets and production releases.

Environment: s: Business Objects XI R2, XIR3.1 (Designer, WEBI, Web Rich Client, Desktop Intelligence), Crystal Xcelsius, Oracle 10g, SQL Server 2005, TOAD.

Confidential, CA

Sr. Business Objects Developer

Responsibilities:

• Implemented & migrated complete BO life-cycle from version XI R2 to the new 3.1 environment.
• Gathered, analyzed, and documented business requirements, functional requirements, and data specifications for BO universes & reports.
• Worked with team closely with the functional analyst, DBA and technical architects to analyze the data requirements and then performed designing and developing of universe and report enhancements.
• Deployed BO Universes and Reports in a Secure Environments from one server to other servers using Import Wizard and BIAR file methodology.
• Involved in unit-testing of over 1000 reports which includes WEBI, Desktop Intelligence reports and crystal- reports.
• Performed debugging & bug-fixing during the process of migration & upgrade.
• Performed documentation and delivery of the validated reports.
• Designed, developed & maintained universes using BO designer.
• Tuned and enhanced universes to improve report performance.
• Worked on the post-production activities for the enhancement purpose.
• Created Reports using BO functions such as drill down, prompts and alerters.
• Used complex reporting functions such as ForAll and ForEach for enhanced calculations.
• Used universe functions such as “@AggregateAware”, “@Prompt”, “@Select” and “@Variable”
• Implemented row-level security in the universe designer.
• Set up groups and users and managed application security using CMC.
• Worked extensively on TOAD to execute and analyze queries.

Environment: Business Objects XI R3.1 life cycle manager, Web Intelligence XiR3.1, Oracle 10g, Crystal Reports 2008, PL/SQL, SQL Server 2005, Data Integrator XI R2, Web Sphere, Windows 2003 Server, and Solaris.

Confidential, San Jose, CA

Business Objects Technical Lead

Responsibilities:

• Gathered and documented Business Requirement for all applications specifying KPIs (Key Process Indicators) based on regions and platforms to be operated.
• Produced functional and non-functional business requirements and functional specification documents, and worked with the business to obtain signoff.
• Performed upgrade from Business Objects 6.5 to XIR2 with repository migration tool and Import Wizard of BO 6.5 users, Groups, Folders, Universes and Reports to XI R2.
• Designed and developed Universes in BOXI/R2 designer for canned WEBI reports by selecting/joining tables in star schema from SAP BW Data marts.
• Used Business Objects Data Integrator XI for Enterprise wide class data integration, including maintaining complex weekly batch jobs and Real time data extraction from many data sources.
• Indicated cardinalities, creating Aliases to resolve the Loops, subdividing into Contexts and creating the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom Lists of Values and used @Aggregate Aware, @Where, @Select, @Variable, @Prompt and @script functions when required.
• Developed View on Demand and Canned reports with Date functions, Drill Filters, Breaks, grouping data, custom sorts displaying data in Free-standing cell.
• Developed Visual interactive presentations using Crystal Xcelsius.
• Developed Reports used with Crystal Reports.

Environment: Business Objects XI /R2/6.5.1,, Crystal Reports, Web Intelligence, Info view, Broadcast agent, Oracle 9i, PL/SQL, Business Objects Data Integrator (ETL), Power Builder, TOAD and SQL.

Confidential, MD

Business Objects Developer

Responsibilities:

• Performed user acceptance testing on test and production environments.
• Worked with Business Objects Supervisor for creating and managing domains, creating and managing universes, creating categories, creating and managing users and managing access and permissions.
• Created Universe Classes, Objects, Measure Objects, Conditions and Joins.
• Scheduled pre-canned reports through Broad Cast Agent Publisher for distribution and printing.
• Created dashboard and scorecards using dashboard manager.
• Created and deployed Web-Intelligence reports.
• Installed Web Intelligence (Thin Client) and set up in a clustered environment.
• Customized configuration of Business Objects - Web Intelligence by fine-tuning and Optimization for good performance.
• Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports.
• Intensive experience in parameter and formula fields’ group selection and record selection in Crystal Reports.

Environment: Business Objects 5.1.8 (Designer, Supervisor, Web Intelligence 2.7, Broad Cast Agent, Publisher, IIS Server, Web-i, Windows 2003, Oracle, SQL.