Professional Summary

• 10 + years of industrial experience in IT operations, planning & management, a Business Objects (BO) certified professional for Business Objects Enterprise XI R2/XI 3.1.
• Extensive experience in leading, developing and implementing report solutions on Business Objects XI R2 Administration, Crystal Reports Server XI, Crystal Enterprise 10/9/8.5, Web Intelligence XI, Desktop Intelligence, Business Objects (BO) Universe Designer, Crystal Reports Explorer, Performance Manager, Dashboard Manager, Xcelcius, Migration of BO 6.5 to BO XIR2.
• Design, build and deploy the most appropriate technical infrastructure for Business Objects solutions implementation.
• Developed BO Universes using the Designer XI R2 for the reporting solution for operational reporting system.
• Created interactive and ad-hoc reports with features like drill down, slice and dice, ranking, alerts, section and grouping.
• Responsible for designing & managing Universes, Reports and Dashboards, Migration of BO 6.5 to BO XIR2 & Administration of Business Objects XI R2, Business Objects 6.5
• Good working knowledge in all the phases of software development life cycle like and developing, scheduling, and publishing the documents.
• Responsible for analyzing business activity, developing, and deploying business solutions.
• Analyze, design, develop, and test the Extraction, Transformation and Loading (ETL) of Source data into target Data Warehouse or Data Mart
• Having data modeling capability, SQL skills, stored procedures and an understanding of database optimization and performance tuning.
• Profiled data, using the data profiler and explaining, setting, adding, configuration and connecting data profiler.
• Responsible for designing and implementing physical data models based upon physical database structures to support business reporting and analytics.
• Knowledge of designing the database, making the data relationship & data modeling.
• Handling errors, auditing, and providing recovery mechanism, auditing in data flow.
• Responsible for creating, managing & administration of Oracle database
• Sound knowledge in SAS 9.1, SSAS, SSRS, SSIS.
• 1 + years experience as Manager of IT - Operations involving ERP Implementation, IT Infrastructure, Project Management & Strategic IT Planning.
• Analyze, design, develop, and test the Extraction, Transformation and Loading of Source data into target Data Warehouse or Data Mart
• Sound data modeling capability, SQL skills, stored procedures and an understanding of database optimization and performance tuning.
• Domain expertise of Sales & Distribution, Human Resource and Accounting & Finance Engineering.

Technology Expertise:

• OLAP Tools: Business Objects XI 3.0/3.1/R3/R2,6.x,Desktop Intelligence, Import Wizard ,Central Management Console, Universe Designer, Broadcast Agent, Web Intelligence XIR2, Info View, Report Conversion Tool, Data Source Wizard, Dashboard Manager, Performance Manager, Configuration Tool Repository Migration Wizard, Xcelsius, Crystal Reports XI , SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS).
• ETL: Data Integrator, SSIS.
• Operating System: Windows XP/ 7, Windows NT / 2003.
• Programming Languages: C, C++, Java, Visual Basic 6.0 , SQL, PL/SQL, HTML , XML.
• Databases: ORACLE 8i/9i, MS-Access, Teradata ,SQL Server 2000/2005
• Web Server Tools: IIS, Apache.
• Data Modeling Tool: MS Visio and Erwin

Professional Experience

Confidential San Francisco, California
Business Objects Administrator/Developer Jan 2009 - Till Date

Confidential is an American multinational diversified financial services company with operations around the world. Wells Fargo is the fourth largest bank in the US by assets and the second largest bank by market capitalization. The company is located in San Francisco. The main objective of the project was building a Client Management Information System (CMIS) which is a bank-wide repository of data for client management, reporting and analysis. The system links information from numerous front- and back-office systems, standardizing and formatting the data for use by management, marketers and investment bankers.

Responsibilities:

• Working with Business Analysts, Data Analysts, Business IT Leaders, Security Team, and Server support team.
• Working with the team, which is moving Business Objects 6.5 to XIR2.
• Install and configure Business Objects 6.x\\XI r2 on more then 12 Business objects windows Servers with different environment Like QA, Development and test.
• Install and configure BO XI on windows based server for testing purpose.
• Upgrade the Business Objects server with Patches and Hot fixes on Servers.
• Scheduled and refreshed reports using Broadcast Agent.
• Implementing row-level and class\\object security.
• Designed, developed and maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
• Customized the list of values (LOV\'s) which helps the end users to select the values.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Scheduled reports from the Broadcast Agent Server to only requested users.
• Responsible for performance testing of all the reports, which helped in analyzing its performance before moving into production.
• Installed and configured Business Objects XI r2 using Tomcat and Apache as Application and Web Servers.
• Migrating Business Objects 6.5.1 version reports to new version XIr2.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Created Reports using Alerters (conditional formatting) and also generated Rank reports.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.
• Recreated repository Tables using Central Configuration Manager.
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console
• Scheduled pre-canned reports through WebI XI R2 Scheduler for distribution and printing.

Technologies: - [Business Objects XIR2, Web Intelligence, Universe Design, CMC, CCM, Infoview , Teradata 12/8.2 ]

Confidential is an integrated managed care consortium, based in Oakland, California. Kaiser Permanente is made up of three distinct groups of entities: the Kaiser Foundation Health Plan and its regional operating subsidiaries; Kaiser Foundation Hospitals; and the autonomous regional Permanente Medical Groups. Kaiser Permanente operates in nine states and the District of Columbia, and is the largest managed care organization in the United States. Project involved design of a Business Intelligence system to incorporate logistics, patient data, details of facilities and details of construction projects.

Responsibilities

• Created users and groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module
• Created universes based on the user requirements for different business units.
• Created classes and objects and logically grouped them together and defined business names for the classes and objects
• Responsible for creation of BOXI R2 Universe and Reports based on the requirements gathered from the end user and working closely with the database expert.
• Created reports using both DeskI and Web Intelligence based on the business requirements
• Used @functions to create predefined conditions and prompts to filter the data and dynamic user selection
• Created custom LOV\'s and Hierarchies which helps the report users to select the list of values and also to drill down to lower levels
• Resolved issues like loops by creating contexts to remove the cyclic dependencies.
• Created complex variables to calculate the local market values, base market values, market value plus accrued interest etc.
• Used prompts in the reporter level to create more interactive reports.
• Used business objects functionalities like breaks, sorts, alerters, filters and conditions.
• Analyzed reports by using Slice and Dice, Drill down and Master Detail.
• Develop and maintain Business Objects universes for two business units: CRM and HR. PeopleSoft is the source of HR data and Siebel is the source of CRM data.
• Experienced in conversation of data from different sources using Data Integrator.
• Developed complex ETL (Extract/Transform/Load) procedures were developed using SQL Server\'s DTS and T-SQL package to provide a way to update/insert/delete data from multiple heterogeneous sources.
• Creating new reports after gathering the requirements from business user or modifying the existing ones using Business Objects XI.
• Worked with the team for migrating BO version 6.5.1 to BO XI R2.
• Worked on installation and configuration of Business Objects XI Rel2 Enterprise Suite (Desktop Intelligence, Central Management Server, Central Management Console, Auditor and Dashboard Manager).
• Created users, groups, folders and categories using Central Management Console (CMC), and also managed user /group privileges.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Created reports using Crystal reports XI version with flat files as the data source.
• Used Crystal Xcelsius 4.0 to convert report type data in Excel spreadsheets to more interactive Dashboard type reports.
• Mentored junior Business Objects developers and trained the end users with the basic understanding of report development.

Technologies: - [Business Objects XI R2 (Universe Designer, Reporter), Web Intelligence XI (Info view), BO XI R2 (CMC, CMS, Designer, Desk I, Web I), Crystal Reports XI, Crystal Xcelsius 4.0,SQL, PL/SQL ]

Confidential is a diversified global financial services company headquartered in New York City. The company is best known for its credit card, charge card, and traveler\'s checks businesses. Amex cards account for approximately 24% of the total dollar volume of credit card transactions in the US, the highest of any card issuer. The project involved design of a new system to manage American Express' travel line of business where sales, customer details, facilities details and vessel details were unified to report desired information at a rapid delivery speed.

Responsibilities:

• Analysis of the specifications provided by the client, understanding the business.
• Responsible for designing and developing Universe for reports generation.
• Worked on linking of the Universes using Business Objects Designer.
• Created users and user groups and granted the security access rights.
• Created Multiple Objects through Central Management Console in various formats including MS Excel, Word and Adobe Acrobat.
• Designed Universe classes, objects and qualifications.
• Detected cardinalities and checked the integrity of Universes.
• Created database objects such as views, functions, and stored procedures per client's requirements.
• Extracted data from MS Access to SQL Server by utilizing an ODBC data source.
• Customized list of values in Universe to decrease displayed list of values.
• Created prompts, conditions, and filters for reports.
• Created ad-hoc reports using cross-tab, slice and dice, drill down, list of values and master details.
• Created contexts and aliases to resolve the loops in the Universe
• Used complex functions including @ Aggregate aware, @Select, @Prompt, @Variable commands.
• Created presentation dashboards utilizing Xcelcius.
• Scheduled reports using Broadcast Agent for refreshing.
• Used Crystal Xcelsius 4.5 to convert report type data in Excel spreadsheets to more interactive Dashboard type reports.
• Scheduled reports based on required schedule including on-demand, one-time event, daily, hourly, etc.
• Automated refresh of reports per desired schedule (hourly, daily, monthly, quarterly, etc.)
• Reports incorporated documents from various sources including MS Word, PDF, and Webi documents.
• Tested reports to ensure and verify client's requirements.

Technologies :- [Business Objects XI R2, Business Objects 6.5.1(Supervisor, Designer and Reporter), Oracle9i, Web Intelligence XIR2,Xcelsius 4.5, SQL 2005, Windows NT/2000.]

Confidential Cincinnati - Ohio
Business Intelligence Developer Feb 2005 to Oct 2005

Confidential is a recognized industry leader in the design, manufacture and distribution of specialty construction products sold to the civil engineering infrastructure sector of the heavy construction industry. It has three key business segments: Stormwater Drainage & Control, Engineered Spans (Bridges) and Environmental Stormwater Management. Contech provides the broadest suite of integrated solutions for the site construction industry in the US.

Responsibilities:

• Analyzed business requirement documents and converted it into BO universes and reports.
• Created user objects including Dimensions, Details and Measures.
• Created Alerts using Business Objects to highlight columns based on business criteria.
• Extensively used Calculations, Variables, Filters, Conditions, Breaks, Sorting, Drill down, Slice and Dice, Master/Detail and Charts for creating Business Objects reports.
• Designed and developed extensive BO Reports using combination of Chart and Tables.
• Created reports using Web I functionality, like Queries, Slice and Dice, Drill Down/ up.
• Created reports using @functions like @prompt, @variables, @aggregations etc
• Developed the Universe & Solved the loop using alias & context in designer module.
• Report creation with SSRS and deployment in Microsoft Dynamics CRM.
• Created drill down reports in SSRS and published it in MS Dynamics CRM.
• Using built-in Transforms and Functions to support data flow and
• Optimize data flow, Using variables, parameters and Data Integrator
• Scripting Language

Technologies: - [Business Objects XIR2, Web Intelligence, Universe Design, SQL Server 2008, SSRS, MS Dynamics CRM, Data Integrator]

Confidential Ahmedabad - India
Manager - IT Aug 2003 to Feb 2005

Confidential, India's leading manufacturer of switchgear, empower each of its products to superior performance, adding incomparable strength and value to your business with an annual turnover of Rs 200 Crore.

Responsibilities:

• Managed the entire IT department for the organization.
• In-house ERP Implementation. Conduct gap analysis, assess scope of studies & suggest solutions through ERP.
• Support & guide the software development team for customizations & implementation.
• Developed Universe, check the integrity of the Universes, and export the Universes to Repository, making it available to the users.
• Business Objects Project Implementation, analysis of the specifications provided by the client & understanding the business requirements.
• Designing and developing Universe for reports generation.
• Worked on linking of the Universes using Business Objects Designer.
• Involved in creating the objects with hierarchical list of values, Creating User Prompts, Cascading Prompts, Conditions and Filters to improve the report presentation
• Resolved Loop and Join problem by creating Aliases and Contexts and checked the Integrity of the universe.

Technologies: - [Business Objects XIR2, Web Intelligence, Universe Design, MySQL, SQL Server 2005, Crystal Reports, ERP]

Confidential Ahmedabad - India
Software Engineer Jan 2002 to Aug 2003

Confidential is a prominent IT & ITES solutions provider with leadership in critical solutions like Business Intelligence (BI), DW Architecture (DWA), and Systems Integration (SI) for strategic business management through IT in today\'s information intensive and competitive markets requiring precision management.

Responsibilities:

• Wide experience in Business Objects administration activities like installing, configuring, troubleshooting, and backup/restore.
• Design, develop and maintenance of universe.
• Administration of Business Objects Enterprise using Central Management Console (CMC), Central Configuration Manager (CCM), and Publishing.
• Worked in CMS / CCM / CMC administration (user management, content management, and server administration).
• Used Publishing wizard to export different document types as objects in CMC.
• Created users and groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module
• Using Data Integrator Designer, created, tested and executed jobs to populate Data Warehouse.
• Provided Corporate Training to different MNC (HP, Wipro, Cambridge, Accenture, Capgemini, TCS) on SAP - Business Intelligence.
• Responsible for Universe Testing and Bug fixing.

Technologies: - [Business Objects XIR2, Web Intelligence, Universe Design, MySQL, SQL Server 2005, Crystal Reports, Data Integrator]

Confidential Ahmedabad - India
Developer May 2001 to Jan 2002

Confidential is an end-to-end Information Technology Consulting and Software Services provider. VMF Soft has an impressive track record of delivering technology-driven business solutions to various clients in the US and in India. VMF Soft has been providing Application Software Development & Maintenance Services, IT Program & Project Management, Systems Integration and Consulting Services for over 15 years globally.

Responsibilities:

• Developing Quality Management System to establish quality policy and quality objective as per quality standards of ISO -9001 - 1994 certification.
• Implementation of QMS System with all required controls, restrictions and in accordance to management policy.
• Created reports using Crystal reports for QMS.

Technologies: - [Visual Basic 6.0, Crystal Reports, SQL Server 2005]

Education Qualifications

• SAP Certified Business Objects Administration XIR2, November 2008
• B.E in Information Technology
• Diploma in Information Technology