Summary:

• Around six years of software experience including expertise in Business Objects XIR3/R2/6.x/5i, Crystal Reports (2008, XIR2, 10/9/8), Crystal Xcelsius, Voyager, SSIS, SSRS, SSAS.
• Proven track record of successful implementation of Full Lifecycle (Requirement gathering through implementation and enhancement) of Business Objects reporting.
• Extensively worked on the following sub modules of Business Objects: Designer, Desktop Intelligence, Web Intelligence, Info View, Central Management Console, Supervisor & Broadcast Agent.
• Experience in developing Universes from different databases including Oracle, SQL server, DB2, Teradata.
• Proficient knowledge on BO XI Architecture and new features.
• Expert in tuning the performance of SQL queries and ETL process also fine performance tuning of universes and reports.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values(LOV) along with User Acceptance Test(UAT) and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Worked with Crystal Report for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports.
• Experience in Crystal Xcelsius creating interactive dashboards by using QAAWS and Live Office.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Design, development and coding with ORACLE 11i/10g/9.2/8.x/7.x, SQL Server 2008/2005/2000.
• Worked on BO XIR2 administration - User/group security, application security, data row level security, scheduling and distribution strategies.
• Designed and developed Data-Warehousing and Data Marts.
• Demonstrated understanding of Dimensional Modeling (Star Schema and SnowFlake) and other Data -Warehousing Concepts.
• Identified business requirements, requirements management, functional design, prototyping, process design (including scenario design, flow mapping), testing, training, defining support procedures and supporting implementations.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.
• Diversified domain experience in Finance, Insurance, Banking and pharmaceuticals.

Reporting Tools

Business Objects XI R3/R2/6.5/5.x/4.x, Universe Designer, Xcelsius 2008/4.5, Crystal Reports2008/ XIR2/10.0/9.0/8.0,SSRS,Cognos.

Business Intelligence Tools

Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, CMC CCM, Designer, Report Conversion tool and Import Wizard, SSIS, Informatica.

Databases

SQL Server 2005/2000/2008/2008R2, Oracle 8i/9i/10G/11g, MS Access 2007/2003/2000/97, Teradata.

Operating Systems

WINDOWS7/Vista/XP/2003/2000 /98/95, WindowsNT/2000/2003/2008,
UNIX, LINUX, MS-DOS.

Languages

C, C++, PL/SQL, T-SQL, VB.NET, Shell Scripting.

Web Servers

IIS 7.0/6.0/5.1.

Confidential, Chicago, IL Feb 2010 Till Date
Role: Senior Business Objects Consultant

Confidential, is a financial corporation whose primary business focus is to provide commercial property and casualty insurance to businesses and professionals.
Responsibilities:

• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Used Aggregate tables and Shortcut joins to improve the Query Performance.
• Implemented Aggregate Awareness through Business Objects Enterprise extensively.
• Used ,functions (,select, ,where, ,prompt) to create complex predefined conditions, and prompts to filter the data in the universes.
• Solved Chasm Traps, Fan traps and Loops using Contexts and Alias methods.
• Created Universes and complex reports against huge Teradata database.
• Interacted with Business Users to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in the creation of database objects like tables, views, Sequences, stored procedures, function, packages, DB triggers and indexes.
• Controlling Reports data by working with Universe and Queries using Filters, Sorts and Rankings.
• Involved in performance tuning of reports that were running slowly. Did performance tuning at the report level, Designer level and database level.
• Worked oncrystal complex reportsthat require running totals, sub-totals, sub-reports, hierarchies, cross-tab, multiple groups and conditional display of groups, fields, and messages.
• Developed full client and WEBI reports on Info View.
• Designed, developed, tested and supported reports in Web Intelligence, and Crystal Reports 2008.
• Involved in resolving issues relating to pre implementation of Reports.
• Converted Desktop Intelligence reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
• Managed Crystal Reports Explorer, Designer, Desktop Intelligence, Discussions, Info View, and License Information.
• Designed and developed dozens of reports for various modules of legacy application (MDDB & Trial works) using Crystal 2008 for comparison of migrated data and for application documentation purpose.
• Developed and maintained Dashboards for detailed analysis using Crystal Xcelsius.
• Used QAAWS (Query as a Web Service) to pull data from the universe and use that data to build personalized Xcelsius dashboards.
• Tuned Teradata SQL Statements performance in various schemas across databases.
• Created users, groups, folders and managed security to the end-users in CMC in BO XIR3.
• Involved in Migrating the reports and Universes from Business Objects XI R2 to XI R3.
• Assisted Sales staff by coordinating departmental purchasing order activities via the Web.
• Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.
• Interacted with the end users and provided Production Support.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Business Objects XI R2/XI R3, (CMC, CCM, CMS), BO Designer, Web Intelligence, Desktop Intelligence, Xcelsius, Cognos 8, Crystal Reports XI, Erwin, SQL Server 2008/2008R2, Windows XP/2003, UNIX, Teradata.

Merck & Co., Inc, North Wales, PA Aug 2008 Jan 2010
Role: Business Objects Developer/Admin Support

Description: It is one of the largest pharmaceutical companies in the world. Currently, it is one of the seven largest pharmaceutical companies in the world both bymarket capitalization and revenue. Merck discovers, develops, manufactures and markets a broad range of innovative products to improve human andanimal health, directly and through its joint ventures.
Responsibilities:

• Designed new Universes and modified the existing Universes based on the business requirements.
• Created new events, folders, profiles, users and groups in CMC.
• Involved in Installation and Configuration of all products of Business Objects.
• Created Repository and assigned privileges to users and groups using CMC.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Created User Objects including Dimensions, Details and Measures.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Resolved the fan and chasm traps.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries.
• Exported universes to the repository to making resources available to the users.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.
• Involved in creation of Filters, ,prompts, ,functions and setup Hierarchies for Multidimensional Analysis.
• Involved in Migration of BO reports and universes from 6.5 to XI R2.
• According to the user rights, used to give security to the folders, Universes and Reports.
• Used to deactivate the account if any User leaves and created Aliases.
• Involved in creating new Templates for the Report.
• Developed Dashboards for detailed analysis.
• Worked on Linked Universes by kernel approach.
• Solved complex issues in Reports by working with Business Objects team.
• Created accurate and detailed project documentation, estimates, functional and technical specification documents, and product configuration throughout the solution delivery process.
• Involved in bug tracking and bug fixing.
• Conducted user training sessions, prepared training material and tips. Trained users on how to use the Info view and using WEBI for building Ad hoc Reports
• Involved in Data modeling of the Data mart tables using ERWIN.

Environment: Business Objects XI R2 (CMC, Designer, Crystal Reports, Web Intelligence Rich Client, Info View, Voyager), SAP BW, SQL, PL/SQL, Toad, Oracle 9i, ERWIN, TOAD, Windows 2003, UNIX.

Confidential,San Francisco, CA Feb 2007 Aug 2008
Role: Business Objects /Crystal Report Developer

Description: The Group\'s principal activity is to provide credit card and deposit products throughout the United States. Providian Group markets consumer loans and deposits using distribution channels such as mail, telephone, and the Internet. The present project included development and deployment of a Business Intelligence System for Global E-commerce vision. Business Objects was used to support the middle management and executives for their planning activities.
Responsibilities:

• Interacted with Business Owners to know their Business views in creating/modifying Reports accordingly.
• Developed reports using Crystal Reports 10 Various Report Formats developed include parameterized Reports, Sub Reports, Cross Tab Reports, Standard Reports, OLAP Reports, and Master/Detail Reports and also developed reports in MS Access and Excel.
• Worked on Data Warehousing Design Methodology, Data Warehouse Concepts.
• Gained experience in designing, implementing, distributing and maintaining Universes.
• Assisted clients to provide reporting solution and develop/maintain universes against their SAP R/3 warehouse using WebI, Business Objects and Designer.
• Analyzed the reporting requirements with the business users and come up with the technical specifications.
• Developed various canned Reports that involved use of Prompts, Customized LOVs, Multiple data providers, Master/Detail, Alerts, Cross tab, filters and variables.
• Created graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
• Supported and lead developers in creating reports using Universe, Stored Procedures and Excel files as Data Sources.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Used Built-in and External strategies for creating components of a universe.
• Created Aliases and Contexts for solving the Join Problems in Business Objects.
• Created New Classes and User Objects in designing the universes.
• Scheduled various reports on Daily, Weekly, Monthly and Yearly basis.
• Created the Reports for various financial groups using the Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources.
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Examined and transformed the business logic behind the existing Crystal Reports into Business Objects environment.

Environment: Business Objects 6.1/ 5.1 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), MS Access, Oracle 9i, SQL, PL/SQL and Windows 2000, UNIX.

Confidential,Austin, TX May 2006 Jan 2007
Role: Business Objects Developer

Description: Priceline is one of the leading Airline Ticketing Company in US. The project deals with the Sales & Marketing Data collected from various sources. The System was primarily designed to provide canned reports for our Performance Analysts who could use the Daily Operational Reports to investigate discrepancies, thereby creating a streamlined and efficient process.
Responsibilities:

• Worked closely with Business Analysts to produce reports based on the requirements.
• Converted high-level design specifications to detailed functional and technical specifications.
• Worked on creatingUniversesusing the Business Objects Designer and connected to the database using ODBC.
• Created queries for multidimensional analysis using Slice and Dice, Drill Down, Drill ByandDrill Through.
• Submitted and presented the reports in user-defined formats likeTabular, Master Detail,andCross Tab.
• Created Derived tables and involved in creating aggregate tables.
• Migrated Business Objects Universes, User groups, and reports from Version 5x to 6x.
• Made the Reports user friendly by implementing user prompts, conditions and filters.
• Created reports and compared the daily sales using both tabular reports and 3-D graphical chart reports (bar graphs and pie charts.)
• Created variables, formulae and objects at report level.
• Developed queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Used Version Control for checking in all versions of the objects used in creating the Joins in the Universe to keep track of the changes in the development, test and production environment.
• Trained end users in basic and advanced ad hoc reporting skill.

Environment:Business Objects 5.x, 6.x, BO (Designer, Business Objects, BCA), ERWIN, MS SQL Server, Windows NT.

Confidential, India Oct 2005 May 2006
Role: SQL Server Developer

Description: OBC is the Largest Public Sector Bank.Oriental Bankof Commerce is the nation\'s leading financial institution provides personal financial needs. OBC has more than 100 branch offices in India and abroad.

Responsibilities:

• Configured SQL Server 2005 Environment.
• Involved in the development of a normalized database using Data Definition Language (DDL), DML in T-SQL.
• Involved in database design, development of database, Created tables, views, Primary keys, indexes, constraints, Views in SQL Server.
• Developed Stored Procedures, Functions, Packages and Triggers in SQL server.
• Involved in Performance Tuning and Optimization.
• Created user interface forms in Visual Basic.
• Developed DTS, SSIS packages (Control Flow task, Data Flow task) to migrate data from flat-files, spreadsheets to other databases.
• Conducted data import and export operations using the Import export wizard in SSIS.
• Generated various reports using SSRS.
• Involved in application Testing and Debugging.

Environment: MS SQL Server 2000/2005, SSIS, SSRS, Data Transformation Services, Visual Basic 5.0.

Education:

• Bachelor of Engineering

Certification:

• MCITP Certified.