Vijay

Professional Summary

• Over * years of IT experience in Data warehousing and all aspects of Systems Development using Client/Server technologies that includes Requirements gathering, Analysis, Design and Development.

• Experience in two Migration Projects from BO 6.x to BO XIR2.

• Worked on different versions of Business Objects 4.1/5.1.5 /6.0 /6.1b /6.5/XI R1/XI R2

• Business Objects Certified Professional.

• Certified Oracle 9i Database Administrator.

• Certified Software Tester from ISTQB (International Software Testing Qualification Board).

• Extensive experience in different Modules of Business Objects like Desktop Intelligence, Web Intelligence, Infoview, Designer, Supervisor/CMC.

• Sound understanding of Dimensional Modeling, designing Star and Snowflake Schemas.

• Performed Pre Migration Assessment, Migration & Post Migration.

• Identifying Reports Complexity, Implemented Row level/Column Level/Report Level Security.

• Experience in installation of business objects components including BO repository creation, support and administration of Web Intelligence.

• Experience in data retrieval methods using Universes, Personal Data files, Stored Procedures, and free hand SQL.

• Proficient in SQL and PL/SQL coding.

• Excellent Communication skills.

Datawarehousing Skills

ETL Tools : SQL Data Transformation Services

Data Modeling : Erwin

OLAP : MS SQL Analysis 2000, Business Objects Designer 4.1/5.1.5/ 6.0/ 6.1b, 6.5/XI R2

Reporting/DSS : Business Objects 4.1/5.1.5/6.0/6.1b, 6.5, XI R2, Web Intelligence, Info View

Crystal Reports 10/XIR2

Technical Skills

Operating Systems : UNIX, Windows NT, Windows 95/98/XP/2000/2003

Databases : Oracle 8/9i/10g, SQL Server 7.0, MS Access

Languages : PL/SQL, C

Internet

Technologies : XML, XSL, HTML, DHTML, VB Script, MTS, IIS

Development Tools : Visual Basic 5.0/6.0, Visual Interdev

Education: Bachelor of Engineering (Electronics & communication)

Professional Experience

Blue Cross Blue Shield, TX (May ’07 –Till date)

Senior Business Objects Consultant

Responsibilities:

• Mapping the database fields after developing the reports or after adjusting report as per the client requirement.

• Extensively used the Report Inspector tool to change, multiple reports database schemas, scheduling multiple reports, deploying and publishing.

• Customized the Infoview page with Company Logo, User required information and redeployed the WAR files.

• Publishing the reports and maintenance of daily, monthly and yearly.

• Applying the patches in cluster environment for Business Object Server, Crystal Enterprise Server and Crystal Reports.

• Configured the SMTP settings to send the reports to users email after scheduling the reports in Crystal Enterprise Server and Business Object Server.

• Installed and configured Business Objects Enterprise XI R2 Premium

• Presenting visual models using xcelsius.

• Created slides for data flow and process flows using PowerPoint and Microsoft Visio

• Designed, defined, developed, tested and maintained the universe and reports

• Using Import Wizard deploying the reports from Dev system to Test and to Production.

• Gathered the Users Information and Security levels in BO 6.5 to implement the new Security in BO XI R2.

• Used Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).

• Created reports in Web Intelligence XIR2

• Security implementation for both Webi and EPM.

• Resolved loops by creating Aliases & Contexts and checked integrity in universe.

• Added/created complex objects to the universe to enhance the report functionality.

• Optimized the usage of user objects, conditions and universe level filters

• Maintained existing reports and Created standard template for all reports.

• Involved in documenting the changes to the universe and reports functionality.

• Identified issues with some of the reports with ambiguous data and resolved the issues

• Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence

• Created Hierarchies to facilitate drill down

• Resolved the performance issues with the drill down report

Environment: Oracle 10g , Business Objects Enterprise XI R2, Business Objects Designer, Web intelligence XIR2, Desktop Intelligence XIR2 Windows XP/2003/2000, Crystal Reports XI R2, Crystal Enterprise 10, Weblogic BEA 9.2

Washington Mutual, CA (Jun ’06 – Feb '07)

Senior Business Objects Consultant

Responsibilities:

• Installed and configured Business Objects Enterprise XiR2 Professional edition in test and production environments.

• Troubleshooting the Business Objects 6.5 installation issues.

• Migrated Business Objects 6.5 version reports to Business Objects Enterprise XiR2.

• Migrated Crystal Reports to BO XIR2.

• Tested the Business Objects XIR2 migration to ensure the reports are functioning as per expectations

• Created new security for the migrated reports and users.

• Scheduled the crystal reports to users by email

• Resolved issues that were raised during the scheduling

• Created a document for the migration of Business Objects 6.5 to Business Objects XI R2

• Wrote a Business Objects best practices document

• Utilized the capability of Aggregate Awareness to improve on query performance

• Created Hierarchies on Region and Time classes and created customized LOVs.

• Resolved the Loops by using Aliases and Contexts.

• Created customized prompts, cascading prompts and GUI based prompts with VBA macros also developed the customized tool bars & functions to export to excel.

• Developed Statistical Process Control Charts -SPC Analysis and standard control charts, hazard plots, and automated reports.

• Designed, developed and maintained dashboard using Excel

• Generated various Drill down reports and Alerts. Business Intelligence reports using Web Intelligence module.

• Generated ad hoc and canned reports for Business objects.

• Created reports for various portfolios using universe as the main data provider.

• Created & tested reports using Business Objects functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.

• Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements.

• Developed Desktop Intelligence and Web Intelligence reports.

Environment: Oracle 9i/10g, Business Objects 6.5, Business Objects Enterprise XI R2 Professional, Business Objects Designer, Web Intelligence, and Desktop Intelligence, Windows XP/2003

Prime Therapeutics, MN. (Sep ’05 – Apr’ 06)

Business Objects Lead

Responsibilities:

• Modified, tested and maintained universes

• Created and maintained around Business Objects reports and Web Intelligence reports.

• Built Cross-Tab reports

• Resolved major issues affecting the reporting environment.

• Provided solutions for the most complex scenarios of “linking” objects

• Added/created complex objects to the universe to enhance the report functionality.

• Built Custom Hierarchies in universe to facilitate drill down in the reports

• Analyzed the reports using Slice and Dice, and Drill Down

• Created graphical representation for existing reports.

• Performed data validation by creating ad hoc reports.

• Created derived tables at the universe level to reduce the complexity of universe building.

• Created cascading prompts at the universe level. These cascading prompts were used within full client and thin client reports to narrow down the selection parameters.

• Created different types of reports, like Master/Detail, Cross Tab and Charts (for trend analysis).

• Created complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).

• Involved in documenting the changes to the universe and reports functionality.

• Documented the deviations from the original specifications.

• Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications

• Enhanced the reports by providing event-handling features.

• Optimized the usage of user objects, conditions and universe level filters

• As a Supervisor created Users and Groups.

• Extensively used multiple data providers for building reports

• Tested objects in the universe, to ensure the correct mapping of the objects.

• Tested resolved loops and contexts to ensure the correct results from the query.

• Tested the universe structure to ensure the tables are properly updated along with the database.

• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation

Environment: Oracle 8/9i, Business Objects 6.1b, 6.5, BO Designer6.1b, Web intelligence 6.1b, Windows XP.

ESPN, Bristol, Connecticut- USA (Nov ’04 – Jul ’05)

Business Objects Consultant

Responsibilities:

• Designed, developed, tested and deployed Accounts Receivable Universe

• Maintained and supported the old and the new universe.

• Developed strategy for implementing Row-level security utilizing the feature of Oracle Policies.

• Trained the users, developers in creating reports, universe and its deployment.

• Interacted with the end users, Project Manager and other resources in understanding the requirements and writing universe, report specifications

• Coordinated with technology group in deploying optimal solution

• Defined and created classes, objects, conditions, user and measure objects to capture complex formulae

• Managed user accounts and security using Business Objects Supervisor

• Captured the information from the financials universe and included the functionality in the new universe

• Tested the universes and reports in Business Objects 6.0

• Created variables, formulae and detail objects at report level

• Resolved the performance issues in report generation

• Tuned the universe for better performance.

• Responsible for knowledge transition, documentation of every aspect of Universe and Report creation

• Created reports using Business Objects functionalities like Slice & Dice, Drill Mode, @Functions, Cross Tab, Master/Detail and Formulas etc.

• Created Universes and Linking of multiple universes.

Environment: Oracle 8, Oracle Applications 10.7, Business Objects 4.1/5.1.5/6.0, BO Designer, Supervisor, Windows citrix environment

Walgreen’s Pharmacy, CA (Feb’04 – Oct ’04)

Business Objects Analyst

Responsibilities:

• Preparation of technical documentation.

• Created universe for various functional areas of high level repots group

• Created Contexts and Aliases to resolve chasm and fan traps in Universes

• Created the joins strategies while designing the universes

• Exported the Universe to Repository for making available to Business Objects users and Web Intelligence users

• Involved in Installation and Configuration of all products of Business Objects.

• Changed the universe parameter settings to optimize the performance of universe.

• Used SQL against the database to check data retrieved.

• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.

• Generated various reports on Daily, Weekly, Monthly and Yearly basis.

Environment: Business Objects 6.5, Designer, Full-client, Broadcast Agent, Supervisor, Oracle9i, PL/SQL, and Windows NT/XP.

Polaris Software Solutions, Chennai, India (Mar' 03 – Dec’ 03)

Client: NEC Solutions Asia Pacific Pvt Ltd

Business Objects Developer

Responsibilities:

• Developed the EIS universes in phases depending on the business unit's deployment of the organization. The data sources are oracle and sql server 2K.

• As a supervisor created users, user groups, domains and executed various security policies from row level to dimension level access.

• Exported the reports to Broadcast Agent Server to Schedule and Monitor the reports

• Extracted data from all different data sources & loaded in to the database like Oracle and SQL Server.

• Interacted with the end users for requirements, training and production support.

Environment: Business Objects 5.1.5, Informatica, Web Intelligence, SQLServer 2K, IIS

Virtusa Technologies, India (July ’02 – Feb ’03)

Client: LINDT Chocolates (U.S.A)

QA Engineer

Responsibilities:

• Involved in Test plan and Test case preparation.

• Prepared reusable function in QTP to use across the automation scripts

• Involved in Installation testing.

• Responsible for setting up the QA Environment and execute the regression suite for each build.

• Executed SQL Queries to check table updates and data retrieval

• Developed test cases and test scripts for Functionality and Regression Testing using Win Runner

• Conducted Data Driven Testing using different sets of external data

• Involved in Hindi based Localization Testing.

• Reporting defects to development team through the Test Director.

• Involved in Test Summary Report preparation

Environment: Oracle 8, QTP, Win Runner, Test Director.

CCS Computers Pvt Ltd, New Delhi, India (Jan ’01 – June ’02)

Software Test Engineer

Worked in LG Electronics as IT Administrator on behalf of CCS Computers Pvt. Ltd.,

Responsibilities:

• Prepared / Maintained / Executed Manual Test Cases for Functional, Integration and System Testing.

• Extensively involved in Database Testing.

• Involved review meetings.

• Involved in Installation Testing.

• Identified, Classified, Reviewed and Resolved Defects in consultation with Developers and other team members.

• Involved in bug reporting.

Environment: Windows NT, Lotus Domino, Oracle Applications 10.7, Visual Basic 6.0, windows citrix environment.

Contact this candidate