PROFESSIONAL SUMMARY:

• Over 10 years of IT experience working in Data Warehouse and Business Intelligence environments.
• Extensive experience in analysis, design, development, testing, migration, implementation working in full cycle Data Warehouse/BI implementations.
• Hands on experience in SAP Business Objects (BOBJ) projects.
• Experience in installation/setup, configuration, migration and administration of Business Objects XI 4.1/R3.1/R2/6x/5x environments including SIA (Server Intelligence Agent), CMS (Central Management Server), tomcat application server and other Business Objects services.
• Outstanding experience in Central Management Console(CMC), Central Configuration Manager(CCM), IDT/Universe Designer, BI Launch pad/Infoview, Web Intelligence, Desktop Intelligence, Rich Client, Scheduler, Import Wizard, Report Conversion tool, Life Cycle Manager(LCM), Explorer etc.
• Have lead numerous Business Objects upgrade/migration projects, from 5x to XIR2, XIR2 to XIR3.1 and migration from XIR3.1 to XIR4.1 is going on.
• Hands on experience in building complex Business Objects universes using IDT/Designer and reports using Web Intelligence.
• Worked very closely with team of DBAs, ETL developers and BO developers to design, develop and implement Data Marts to be used in Business Objects.
• Have good exposure to different databases (Oracle/DB2/MS SQL Server/Teradata), ETL tools(Informatica), CRM tools (Salesforce)
• Experience in Production and Technical support activities and production rollouts.

TECHNICAL SKILLS:

BI Tools: Business Objects XI 4.1/3.1/R2/R1/6.X/5.X (CMC, CMS, IDT/Designer, Desktop Intelligence, Web Intelligence, Live Office, Scheduler, Publisher, Life Cycle Manager), Business Objects 6.x/5.x (Supervisor, Designer, Reporter, Web Intelligence, Broadcast Agent), Crystal Reports XI/2008, Xcelsius, Explorer.

RDBMS: Oracle 11g/10g/9i/8i/7x, MS SQL Server 2008/2005/2000 , DB2, MS Access, Sybase, Teradata 15.

Data Modeling Tool: ERWin, Toad, Power Designer.

ETL Tool: Informatica Power Mart and Power Center.

Languages: PL/SQL, VBA, Java, C, and C++.

Operating Systems : Windows XP/NT/2000/Server2003, UNIX, LINUX.

Other Tools: JIRA, Tidal, SQL Word, Toad, Visio.

PROFESSIONAL EXPERIENCE:

Confidential, New York

Consultant - Business Objects Administrator and Senior Developer

Responsibilities:

• Support installation of Business Objects XIR4.1/3.1 to meet enterprise wide Business Intelligence information needs. This included scoping the system/hardware requirements coordinating with enterprise infrastructure group to provision needed hardware for installation and installing Business Objects on Windows clustered environment.
• Migrate universes, connections, reports, users, user groups, instances and other content from Business Objects XIR3.1 to new XIR4.1 installation using Upgrade Management Tool.
• Configure Business Objects XIR4.1 installation to build security by defining custom Access Levels and applying the access levels to applications, folders, categories, universe and connections to insulate content of various business groups from each other and as per their user profile.
• Customize BO servers as per company need by setting up various limits/parameters, and SMTP settings on Job Servers and Processing Servers.
• Lead the testing of new environment by testing security, universes, reports, schedules and overall performance of the new environment.
• Prepare Dev, QA and BCP (Business Continuity Plan) BO XIR4.1 servers.
• Perform user/content/server management using CMC(Central Management Console) and CCM(Central Configuration Manager).
• Setup auditing database to monitor the BO usage activity through audit universe and reports.
• Coordinate with the infrastructure team for establishing process for backup of BO server.
• Coordinate with the DBAs and ETL developers to do analysis of new requirements, design and create new/modify Data Marts as needed for different projects/initiative undertaken by business.
• Lead development of/develop new universes or modify existing universe as needed using features like contexts, aliases, joins, aggregate aware, derived tables, pre-build filters etc.
• Lead development of new reports and modification of existing reports. These reports include multiple data providers using merge dimensions, and use features like cross tabs, master detail, sections, drill down, breaks, filters, complex formula ranks/ranking, alerter, graphs.
• Coordinate testing with QA team, UAT with business analysts/power users, obtain sign off and promote content to production environment.
• Coordinate monitoring of report schedules with the team and alter the schedules as needed.
• Converting Crystal legacy reports to Webi, convert linked Universes to standalone Universes, converting stored procedure based legacy reports to Webi Data Warehouse based reports.
• Responsible for trouble shooting any production problems, performance issues and provide technical support to users across various business groups to enable them create ad-hoc reports and facilitate data analysis needs.
• Have worked using agile software development methodology.

Confidential, New Jersey

Consultant - Business Objects Admin/ Developer

Responsibilities:

• Gather reporting requirements from Business Analyst/Project Manager.
• Create new BO universe or modify existing BO universe as needed using alias, aggregate aware, context, derived tables and various BO features..
• Create/Modify BO reports as per the requirements. These reports are complex reports using advance BO reporting features like sections, breaks, cross-tabs, alerters, ranks, ranking, fold/unfold, input controls, drill filters, query on query and graphs. These reports also use multiple data provider..
• Test/validate BO reports with the underlying data by writing free hand SQLs to run against the data marts.
• Based on the test result coordinate with the DBAs and ETL developers to fine tune the data/performance as needed.
• Coordinate with users to get user acceptance for the BO reports.
• Educate/train users to help them use the BO reports.
• Convert Deski reports to Webi reports using Report Conversion Tool and adjust the Webi reports as needed.

Confidential, New York

Consultant - Business Objects Developer

Responsibilities:

• Migrate BO universes, connections, reports from BO XIR2 to BOXIR3.
• Test the migrated universe and reports to check the integrity of the universe and reports and make any adjustments as needed.
• Gather new reporting requirements from Business Analyst and end users.
• Based on reporting need, work closely with Database developers to create/alter database, procedures, views or functions as needed.
• Coordinate with the ETL team to get data populated as needed for new reports.
• Test the populated data using standalone SQLs against them and coordinate with the team to correct any data errors.
• Create new BO universe or modify existing BO universe as needed.
• Build or modify BO XI R3 reports using multiple data providers with complex features of Business Objects.
• Demo the reports to Business Analyst and end users to get their acceptance.
• Coordinate with the DBAs to make any changes needed to the database to improve the performance of the reports.
• Coordinate with support team to promote universe and reports from one environment to other environment.

Confidential, New Jersey

Consultant - Business Objects Developer

Responsibilities:

• Gather reporting requirements from Business Analyst and end users.
• Conduct a gap analysis to see if the existing reporting marts cover needs of new report requirements.
• Modify the existing marts by adding dimensions or measures as needed.
• Design new mart/tables as needed.
• Coordinate with the ETL team to discuss the business rule/logic used to develop mapping /maplets and processes to populate the marts/tables.
• Test the data populated running stand alone SQLs against them and coordinate with the team to correct any data errors.
• Create new BO universe or modify existing BO universe as needed.
• Create and test BO/Crystal reports. These reports use multiple data providers and involve complex features of Business Objects.
• Demo the reports to Business Analyst and end users to get their acceptance.
• Coordinate with the DBAs to make any changes needed to the database to improve the performance of the reports.
• Assist the IT team in migration from BO 6.5 and XI R2 to BO XI R3 which involves migration, testing and fixing reports as needed.
• Facilitate documentation of development work and change management/ version change.

Confidential, New Jersey

Business Objects Consultant

Responsibilities:

• Interact with business users/IT team to gather and finalize the reporting requirement.
• Interact with the Data Warehouse team to make modifications to the Data Mart as needed.
• Create/Modify Universe on Data Warehouse/ Data Mart/s to support the reporting needs.
• Develop Business Objects/Crystal Reports/SQL Word reports as per the specification finalized.
• Test the reports for accuracy of data by running stand alone query against the Data Warehouse/Data Mart/s.
• Interact with the users to get approval of the developed reports, Promote reports in the production environment through Change Management.
• Modify existing Business Objects/ Crystal / SQL Word reports as needed.
• Interact with DBA to tune the report queries to enhance the performance of the reports.
• Maintain Business Objects Universe on Oracle reporting Data Warehouse to enable ad-hoc querying.
• Have developed complex reports comprising of multiple data providers and report tabs using Business Objects features like filters, alerter, ranks/ranking, sections, cross tabs, graphs, sort etc.
• Have worked on creating BO universes and have used alias, aggregate aware, context, derived tables and various BO functions.

Confidential, New York

Business Objects Consultant

Responsibilities:

• Interact with Lead Business Analyst to study and discuss the reporting requirement of their marketing group.
• Create Business Objects Universes on the Oracle mart tables using multiple alias, context and aggregate aware function.
• Create standard reports in Business Objects as per the specs finalized. Most of these reports are complex reports having multiple data providers and use advance formatting like sections, master detail, cross-tab and graphs and usage of functions like alerter, ranks and ranking.
• Test the reports along with UAT users.
• Schedule jobs on Broadcast agent and arrange distribution of reports to the users using report-bursting feature of Business Objects.
• Modify existing Business Objects Universes, reports/Queries etc as per changing requirement of the users.
• Create ad-hoc reports for the marketing group as needed.
• Train users to help them install Business Objects on their workstations from Webi server using ZABO.
• Design new tables needed for reporting using Erwin, coordinate with DBA for creation of these tables in Oracle, create informatica mappings to populate these tables, test the data upon population.
• Coordinate with the DBA to make changes to the Data Mart tables like getting additional indexes created or have tables partitioned to enhance the performance of reports.

Confidential, New York

Business Objects Consultant

Responsibilities:

• Worked as part of a large Business Objects development team with developers located at multiple locations in New York and Zurich.
• Create and test Business Objects universes on the development Data Marts in DB2 and SQL Server of IPS, based on the documented reporting requirement.
• Create canned Business Objects reports for the Under-writing and Claims data.
• Work with the IPS core committee to test the Universes and the reports.
• Present the reports to the Business Analysts and Power Users and incorporate the feed back
• Migrate the Universes and reports to the Production repository.
• Roll out the Universe and reports to the users and conduct training sessions for them to educate them about the data in the marts, Universes and their capabilities in terms of their ad-hoc reporting requirement.
• The reports were deployed on Webi using extranet allowing the major international clients to be able to login and see reports on their Insurances programs, their pending and settled claims.
• Design Aggregate tables as needed for reporting using Power Designer. Create these tables in SQL Server/DB2 and write procedures to populate these tables.
• Create Business Objects users using BO supervisor for the New York Under-writing team and grant them privileges.
• Coordinate with the members of project management team working on documenting the reports.
• Worked on optimization of report performance by coordinating with the database team.
• Provided support to the users in terms of helping them to build ad-hoc reports, validate the result of their ad-hoc reports, incorporate the changes in the Data Marts into Universe and reports and add/ delete users and/or change user privileges in BO supervisor.
• Schedule jobs on Broadcast agent and monitor the jobs.