SUMMARY

• Eight years of experience in Business Intelligence Administration, Development solutions using Crystal Reports and Business Objects 4.0/XIR3/R2/6.5/6i/6.0/5.X Designer, CMC, , WEBI , Web Intelligence, Desktop Intelligence, Import Wizard, Crystal Reports XI, Crystal Xcelsius, Info View .
• Experienced in Business Intelligence/Business Objects BI/BO enterprise solutions that include Business Objects architecture, software deployment, Business Objects administration, Security, Universe/Report/Dashboard development, documentation, Production Support and user training.
• Extensive experience with Universe design, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along with performing User acceptance testing and Data accuracy test.
• Experience in Installation and Configuration, creation of repositories and security domain with user groups and security implementation.
• Expert in MS SQL Server suite of products i.e. SSRS Reporting Services , SSAS Analysis Services and SSIS Integration Services .
• Good experience in Data Warehousing technologies using Business Objects DataServices, Informatica Power Center 6.2/7.1/8.6/9.5, IBM Infoshere/Ascential Datastage 8.0.1, 7.5 Star Schema modeling, Snowflake Schema modeling.
• Extensive experience using Crystal Reports, Performance Manager, Crystal Xcelsius, Live Office, QaaWS.
• Good experience in Data Warehousing technologies using Informatica Power Center Star Schema modeling, Snowflake Schema modeling, MS Access.
• Experience in migration of Business Objects.
• Proven abilities in generating complex queries by linking data from multiple data providers using free hand SQL, PL/SQL, Stored Procedures, Triggers, Functions and packages besides writing DDL, DML, DCL, and transaction queries with development tools like TOAD.
• Thorough knowledge of different RDBMS like Oracle, SQL Server, DB2 and Sybase.
• Strong knowledge in all phases of Software Development Life Cycle SDLC such as Developing, Testing, Migrating, Administrating, Security Management and 24/7 Production supporting.
• Experience in eliciting client requirements through survey, facilitation of meetings directly with users. Good knowledge in writing Business requirement documents, Functional requirements, Use case documents and Software requirement documents.
• Extensive experience in tuning SQL queries and ETL processes.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS:

Reporting Tools: Business Objects BO 4.0/XIR3/R2/6.5/6.0/5.1 Designer, Web Intelligence, Desktop Intelligence, CMC, Dashboard Manager, Crystal Reports XI, InfoView, Crystal Xcelsius, BO Live Office, Import Wizard ,Crystal Reports 2008/XI/10/9.0, SSRS, Cognos.

ETL: Business Objects Data services, Data Federator, IBM Infosphere

/Ascential Datastage 8.0.1, 7.5 ,SSIS, Informatica Power Center

6.2/7.1/8.6/9.5.Ab Initio, SSIS.

Languages: C .Net, Oracle Pl/SQL, NET Platform, VB, C, C , Java, XML, AS/400.

Internet Technologies: ASP.Net, HTML, JSP

Scripting Languages: Java Script, VB Script, Unix Shell scripts Databases: Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000, Informix, DB2 UDB 7.x/8.x, DB2, MS Access, Teradata v2r6/v2r5/v2r4. Operating Systems: Windows 2000/2005 Server, Windows 98/95, UNIX, Sun Solaris

Web/Application Server: IIS, Apache Tomcat, JBoss, Web sphere.

PROFESSIONAL EXPERIENCE:

Confidential

Role: Business Objects Admin

Responsibilities:

• Extensively worked in the project of Upgrading Business Objects universes and reports from version XI 3.1 to 4.0.
• Installing, configuring and administering the Business Objects 4.0 SP6 environment.
• Designed and maintained Universes using different schemas in the Oracle Database.
• Managed Business Objects Administrator responsibilities, creating user groups, access rights, assigning rights and folder access, automation of reports, broadcasting reports and publications
• Migrated and converted Crystal 8.5 reports to Crystal Reports XI from Repository.
• Created user groups, users ID's folder level security by using Central Management Console XI .
• Created new Universes, Reports and modified existing Universes and reports using Business Objects XI R2.
• Extensively used the Clear quest and HP Quality centre to Migrate reports from Different Environments.
• Involved in testing the reports while migrating from XI 3.1 to 4.0.
• Used Crystal Report XI Enterprise to design the front end reports
• Created Drill down Reports, On Demand Sub Reports, Sub Reports for the Business Needs.
• Involved in design, configuration and integration of LDAP Authentication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security using extended user attributes on Business Objects Universes .unx
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Created custom hierarchy in Universe using BO Designer.
• Created and refreshed quarterly Dashboard using SAP Business Objects Xcelcius Dashboard and Live office.
• Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
• Documented different application architecture 's and dataflow across different applications and platforms.
• Trained people to use and create reports.
• Maintain and administer production and development repositories.
• Exported Reports on to WebI Server and Scheduled Reports as Daily, Weekly, Monthly using Info view in Web Intelligence
• Published and Migrated reports in Development/Test to Production Domains.
• Analyzed, designed, developed and tested reports while working directly with end-users and technical members of the team.
• Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Web intelligence/Crystal Reports XI.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the Crystal Reports
• Designed Crystal reports for daily and monthly reports.
• Created hyperlinks to link between reports
• Planned and designed web services using QAAWS to fed Xcelsius as a data provider.
• Extensively used QaaWS to query from Universes.
• Writing Custom SQL for reports performance.

Environment: : Crystal 11,Business objects XI 3.1,4.0, Info View, Business Objects Designer, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, SQL Server 2005, Crystal Reports , Xcelsius, QaaWS,CMC, BO Data Service 3.1,ASP.NET,C ,HTML,XML, ERWIN, MS OFFICE, Visio, JIRA,Subversion.

Confidential

Role: Business Object Admin/Developer

Responsibilities:

• Installing the Business Objects 4.0 SP04 on the server and setting up the environment, and configuring Secure Socket Layer SSL .
• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively worked on Crystal and Webi reports for Elections and Addendums in modifying the existing templates and in creating new ones and also worked on the functionality to reduce the number of Webi reports needed to a minimum.
• Created pages for the purpose of selecting particular addendums and contractors from the list that comes up for a particular department.
• Worked on making changes in the existing queries and renaming them, then on making the database up to date to make previous versions compatible to the existing ones.
• Extensively worked on Logic behind the Formula fields created and used in Webi reports according to the requirement.
• Tested the templates in 2-tier and 3-tier for different environments like Dev, New, Prod and Training.
• Developed various types of Charts and Graphs like Bar Chart Side by Side, Stacked , Line Graphs, Pie Charts, etc by using Chart expert of Webi.
• Extensively involved in using Formula fields, parameter Fields, Group Selection and Record Selection in Crystal Reports.
• Managed Business Objects Administrator responsibilities, creating user groups, access rights, assigning rights and folder access, automation of reports, broadcasting reports and publications.
• Performed ETL code migrations, test, debug, and documentation to maintain programs and deployed
• Building and publishing Xcelsius visualizations in SWF file format.
• Developed Webi Reports, which were embedded in JAVA Application.
• Implemented Publishing wizard Import wizard for migration of reports.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users and Free-hand SQL as data provider.
• Created New Classes and User Objects according to the requirements.
• Created various simple and complex reports using drill down, filters and alerts.

Environment: Business Objects 4.0/ XI R2, Web Intelligence, Crystal Reports XI R2, , Xcelsius, Ascential DataStage 7.2/7.5/8.0 , Oracle SQL Developer, Oracle 10g, PL/SQL, T-SQL, SQL SERVER 2008, Info Advantage, AMS Advantage, Java, J2EE Business View Manager.

Confidential

Role: Business Object Admin/Developer

Responsibilities:

• Development of the Advance Clinical System using Crystal Reports.
• Created nested and conditional groups and formatting features in reports.
• Created New Classes and User Objects in designing the universes.
• Created reports like Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Detail and Formulae for easy-to-use benefit information system by using Webi.
• Created Linked, Unlinked, Parameterized and On-demand reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF, HTML, EXCEL, EXCEL2K format.
• Modifying the existing universes, Adding new objects editing joins mapping the existing objects with renamed tables.
• Create/Modify/Troubleshoot Report issues in Webi, Deski and Crystal reports.
• Creating charts and drill down charts using Xcelsius.
• Participated in ETL code Reviews.
• Co-ordinate with Team members working on Power Center ETL Tool to extract data's from different OLTP Servers to OLAP Server.
• Designed and developed complex aggregate, join, look up transformation rules business rules to generate consolidated fact/summary data identified by dimensions using Informatica ETL Power Center tool.
• Orchestrated a proof-of-concept of BO's Xcelsius, Performance Dashboard Manager in order to resolve navigation and user load issues.
• Involved in managing users, groups, and folders and published reports using central management console, in exporting and scheduling of reports using Webi.
• Tuned sql querie s for improving the reports performance.

Environment: Business Objects XIR2/6.5.1, Web Intelligence, Desktop Intelligence, InfoView ,Crystal Server 10/XI, SQL Server 2005/2008, T-SQL, Xcelsius, Informatica 6.x/7.x,, Windows

Confidential

Role: Business Objects Developer

Responsibilities:

• Extensively interacted with business users, business owners for requirements gathering, analyzing business process and making necessary changes to schema objects to fulfill reporting needs.
• Create/Modify/Troubleshoot Report issues in Webi, Deski and Crystal reports.
• Experience in documenting Functional, Technical Specifications and Test Cases.
• Use of Designer module to implement Universes, linkages between tables, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Knowledge on BO XI Architecture set up for development, production test repositories.
• Modified the Universes, added additional Dimension, Detail, and Measure Objects according to the requirements.
• Created canned and ad-hoc Reports Using Business Objects Web Intelligence Rich client and Infoview.
• Created reports like Customers, Suppliers, Purchase orders Receipt.
• Worked extensively with the major functionality of Web Intelligence like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Create custom hierarchies while designing universe and make them available to end users through Web Intelligence.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart for trend analysis . Use of filters, conditions, calculations, etc.
• Extensively used Aggregate awareness function to enhance the performance of SQL transaction.
• Work on the reports performance is sues and optimization at the reports level.

Environment: : Business objects XI 3.1, Info View, Business Objects Designer, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, SQL Server 2005, Crystal Reports , Xcelsius, QaaWS,CMC, BO Data Service 3.1,ASP.NET,C ,HTML,XML, ERWIN, MS OFFICE, Visio, JIRA,Subversion.

Confidential

Role: Business Objects Developer

Responsibilities:

• Involved in gathering the requirements to create the reports by conducting user interviews.
• Designed and created the Business Objects Universes.
• Created contexts and aliases for resolving loops in the Universes.
• Use of Business Objects Designer module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Creation of different types of reports, such as: Master/Detail, Cross Tab and Chart for trend analysis . Use of filters, conditions, calculations, etc.
• Creation of reports like, reports by product, reports by customer, reports by period and comparative reports.
• Designed Complex Crystal Reports using sub Reports, cross tabs using Crystal syntax Involved in analyzing multi-dimensional Crystal Reports in Crystal Analysis. Published Crystal Reports on the Web using Crystal Enterprise.
• Extensively involved in using of formulas fields, parameter fields, Group selection, record selection and Crystal syntax in Crystal Reports.
• Created various simple and complex reports using drill down/up, slice and dice, breaks, filters and alerts.
• Created reports using free hand SQL when the existing universe is not supported the report.
• Remedy Ticket Support for Business Objects and Crystal reports for Production Environment.
• Written PL/SQL programs on Oracle Database. Performed performance tuning.
• Linking reports in Webi using OpenDoc function.
• Maintained Supervisor by creating user accounts and assigning privileges.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts for creating Business Objects reports.
• Extensively used Crystal Xcelsius to build Dashboards and Scorecard presentation.
• Created interactive excel dashboards and charts and graphs, created scorecards, metric analytics with Crystal Xcelsius.
• Migration of universes and documents from one domain to another.
• Presentation of the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.

Environment: Crystal Reports XI, Business Objects XI R2, Oracle 9i, SQL Server 2005/2008, T-SQL, PL/SQL, SQL Developer,WEBI.

Confidential

Role: Business Objects Developer

Responsibilities:

• Interacted with the Business Users to analyze the business process and gather requirements.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Defined BO Classes, Objects, in the Universe. Also responsible to create derived table to facilitate the creation of new context paths.
• Responsible for creating Cardinalities, Contexts, Joins and Aliases to resolve the loops in Universes.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and created ad-hoc reports by accessing the Universe.
• Enabled dynamic report linking by passing Variables prompts between reports.
• Designing, developing and deploying Universes using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Created Master/Detail, Cross tab, Chart templates reports using Crystal Reports.
• Worked on Hierarchy Levels and developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts Bar chart, Pie chart etc , Cross-tabs and Sub-reports.
• Responsible for designing Data Warehouse schema for Oracle Warehouse.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Performed Unit Testing and involved in training to the Users on creating reports and walkthroughs on general issues.

Environment: Business Objects XIR2, Web Intelligence, Desktop Intelligence, InfoView, Crystal Reports, Crystal Xcelsius, Informatica Power Center 8.1.0, Oracle, SQL Developer, Mercury Quality Center, UNIX.