SUMMARY:

• Over 7 years of experience in Business Objects Web Intelligence, Desktop Intelligence, Universe Designer, Crystal Reports, Crystal Xcelsius, Data Integrator XI R2, SSIS, SSRS.
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) Development, Testing, Migration, Administration, Security Management and Production Support on various platforms like UNIX, Windows NT/2000/XP/98.
• Skills include design and development of dashboards, balance scores cards and report analysis.
• In depth experience in testing and deployment of Business Objects XI Solutions with exceptional abilities in support and maintenance.
• Extensively worked on designing and developing complex universes, which has several hundreds of objects, contexts, and aliases, aggregate aware functions and cascading prompts.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Expertise in generating complex, Ad hoc, dashboard Reports, Business views, List of values along with User Acceptance Test and Data Accuracy Test.
• Experience in migration of several hundreds of BO 6.5.1 reports to XI 3.0 using Import Wizard
• Converted Desktop Intelligence report to WEB Intelligence reports using Report Conversion Tool.
• Created Analytics and Dashboards using Performance Manager and Xcelsius to enable executives track progress and compare current and historical performance against established targets.
• Strong Knowledge of financial reporting systems and Decision Support Systems (DSS) using Hyperion Essbase and developed Financial Budgeting and Forecasting OLAP applications.
• Extensive experience in Calc Scripts, Load Rules and Report scripts.
• Validate the reports/ report structure developed by the offshore team.
• Very good at debugging the business logic by keeping debug statements and storing flow sequences into tables.
• Experience in designing and implementing ETL process, Transformation Mappings and loading using Data Integrator 11.5/6.5.
• Configuration of LDAP and Site Minder agent for single sign - on authentication.
• Experience in Production and Technical Support activities and managing production rollouts
• Good Knowledge of Dimensional Modeling like Star Schema and Snow Flake Schema to fit Query, and Reporting and Analysis requirements.
• Created Report based indexes, Composite Indexes depending on the report. Dropped indexes based on the time taken for insertion and rebuilding them after insertion. Hints were used to force indexes.
• Excellent technical, logical, code debugging and problem solving capabilities.
• Good Knowledge of Business Objects Data Integrator Architecture.
• Good Knowledge of InfoBurst xcelsius add in.
• Good knowledge of Tableau and Qlikview Dashboarding technique
• Excellent communication, interpersonal skills and a team-worker with good customer interaction.
• Good Knowledge in various databases like SQL Server, DB2, Oracle, Ms Access.

TECHNICAL SKILLS:

BI Tools: Business Objects XI3.1-R2/6X, Reporter, Universe Designer, WEBI, Supervisor, Crystal Reports 10/2008 Crystal Xcelsius, Data Source Migration, Desktop Intelligence, Administrator, Confidential, CCM, Import Wizard, Migration Wizard, Data Integrator, Conversion tool and repository Migration Wizard, Essbase Administration Services, Hyperion Systems 6.5/9.3,Hyperion Essbase 6.5/9.3, Excel Add-in

Languages: SQL, Oracle PL/SQL, MS SQL,MDX, MaxL, ESSCMD, C, C++,UNIX Shell Scripting

Database Systems: SQL Server 2000/2005, DB2, MS Access,Teradata, Hyperion Essbase 6.5/9.3, Oracle 8i/9i/11i, Teradata.

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

Dimensional Modeling: Star Schema Modeling, Snow Flake Modeling, Fact and Dimensions Tables, Data Integrator.

Application Software: MS Word, MS Excel, MS Access, MS Power Point

Other Tools/utilities: SQL Navigator, TOAD, IIS5/6, apache, Web Sphere 6, BEA web logic 7

CORE COMPETENCIES:

• Business Objects Enterprise Architecture.
• Design and deploy BI solutions.
• Excellent Skills in Business Objects Administrator.
• Excellent in Crystal Reports Design
• Excellent Skills in Crystal Xcelsius(Crystal Dash boarding Technique).
• Business Objects Migration Specialist.
• Excellent skills in BO Performance Manager.
• Excellent skills in Universe & Report Design.
• Excellent analytical & problem solving skills.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

Business Objects/Crystal Reports/Xcelsius Developer/Admin

Responsibilities:

• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• 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.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Modified the Universes by creating the measure objects and complex filters.
• Created a reports in crystal reports some of the reports were Comp summary EAE, Comp summary EAE/SEAE, Monthly Activity etc
• Created a report in web intelligence like transaction detail, Ops Manager.
• Created a universes for transaction detail, Financial Approval, Ops and BI Universe and assign the security at the universe level.
• Assign the Security at the dashboard level by using the CELogon Token as a flash variable for the Finance Approval Dashboard.
• Uses an XML Data as a one of the connections in the Xcelsius to export the data out of an xcelsius.
• Created flash variables to pass the variables from the Master Dashboard to Detail Dashboard.
• Created a Dashboard called Business Intelligence by using Query as a Web service.
• Created a complex filters at the universe prior 12 months filter, added a logic to show All in the LOV in one of the object.
• Created a xcelsius dashboard - Financial Approval Dashboard by the using the Query as a web service.
• Created a drill down at the report level in crystal reports as well as in the web intelligence.
• Created a 3 level of drill down in the xcelsius dashboard, and build the functionality in the dashboard to export the data from the .swf file into excel sheet by using the xml data connection.

Environment: Business Objects XIR3.1, Crystal reports 2008, Xcelsius 2008 sp1& sp3, QAWS, Windows XP, Oracle10G, Callidus Trucomp, Actuate.

Confidential, Chesterfield, MO

Business Objects Developer/Administrator

Responsibilities:

• Involved in the production support issues and resolving the tickets which are related to the Business objects and figure out is it really a Universe or ETL issues and used to resolve it.
• Worked with Import wizard to move the objects between DEV, QA and Production systems, to create users in bulk.
• Created many complex reports for Operations, Sales,Finance Departments in the organization.
• Worked with Auditor database, implemented Purging policy using PL/SQL and designed reports based on organization specific custom requirements.
• Created Universes on top of both RDBMS systems and SAP-BW (Multi-providers, InfoCubes and BEx Queries) sources.
• Created a Universe on the top of Data Federator.
• Created Multi Dimensional analysis using Slice and Dice and Drill through methods to organize the data along a combination of “Dimensions” and “Drill-Down Hierarchies” giving the ability to the end-users to observe data from Heterogeneous viewpoints.
• Resolved fan traps and chasm traps in the schema using optimal solutions accordingly.
• Developed new BO documents against existing universe including universe-based full client report and free hand SQL reports.
• Created a report like all the individual policies that covered childrens 19 & under at anytime during the last five years and this is was created in Crystal Reports.
• Created new connection strings like ODBC, OLEDB, SAP, native Oracle, SQL Server and MySQL connections as per user requirements.
• Created templates for standardizing the structure of our corporate documents.
• Scheduled reports for the end users, business users and customers.Created custom LOVs, Prompts, Prompt conditions, cascading prompt dimensions, measures and details.
• Created reports using features like @functions, cross tab, master detail, queries, in Web Intelligence using the universes as main data providers and Crystal Reports as Qnxt Database which is a source system or directly using a Universe.
• Exported the Universes and Reports between Development, System Test, UAT and Production Environments.

Environment: Business Objects XIR3.1, Oracle 9i, SQL Server 2005, Data Federator, Windows XP,Crystal Reports XI, Pl/Sql, Toad,Oracle Sql Developer, Qnxt,Trizetto, Rx Navigator.

Confidential, Wilsonville, OR

Business Objects/Xcelsius Developer /Administrator/Qlik View

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the IT incident system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the Closed Incident Report, Closed Interactive Reports, Incident by Service and CI.
• Setting up rights to Business Objects Applications (Info view, WEBI, Designer, Dashboard Manager, Crystal reports, Desktop Intelligence(DESKI) for User groups in Central management console( Confidential ) .Setup access to WEBI reports in Info view for View on Demand reports, Ad-hoc reports, modify rights.
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically.
• Created a Qlikview dashboard.
• Created Dashboards using Dynamic data from data source options such as query as a web service and live office.
• Using live office imported Web Intelligence reports in Excel and Created Xcelsius visualization based on these reports.
• Implemented Business Objects security to do User/Group management, Folders, Universes and Reports management, job scheduling and monitor the job scheduler to optimize the server performance.
• Worked with Import wizard to move the objects between DEV, QA and Production systems, to create users in bulk.
• Created an IT Service Management Dashboard of dynamic data fetching from the oracle Database through a Live Office.
• Created an IT Change Management Dashboard, dynamic data fetching from oracle database through Query as a Web Service.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with Business Objects.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Worked for the other project remotely, this is in Philadelphia given the presentation on the SAP Business Objects.
• Assisting the client, through analysis of their existing system, challenges, and business needs. Documented the reporting requirements and interacted with Business users and collected business information and their requirements for developing the project Work Force Reports.
• Analyzed business model and created Business Intelligence Architecture plan, created Business Functional Specifications, Functional Design Specifications, and Detailed Design Specifications.
• Design the presentation for a strategy on SAP Business objects module like SAP BI Solutions, SAP EIM Solutions, SAP EPM Solutions and SAP GRC Solutions.
• Gathers the Client requirement for designing, configuring and implementation phases for Business objects BI solutions Architecture.
• Given the presentation on Business objects architecture design document.
• Design the Business objects architecture (3-tier) for the entire environment that is Dev, QA and Prod.

Environment: Business Objects XIR3.1, Xcelsius 2008, Windows XP, Oracle 10G, QAWS, Live office 3.1.

Confidential, Philadelphia, PA

Business Objects /Xcelsius Developer/Administrator

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the Health Care system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically.
• Created Dashboards using static data from Excel as data source. Also retrieved dynamic data using multiple options such as query as a web service and Live office.
• Using Live office imported Web Intelligence reports in Excel and Created Xcelsius visualization based on these reports.
• Involved in migration of reports, universes, users and groups from BO 6.5 to XIR 3.1.
• Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Universe on the Data Federator and followed by ad hoc reports.
• Designed and developed Universes in BOXI3.1 Designer for canned WEBI reports by selecting/joining tables in star schema (fact and dimension table) from Data warehouse, Indicating cardinalities, creating Aliases to resolve the Loops, subdividing into Contexts and creating the objects, which are grouped into classes for convenience in Business Objects Designer. Created custom Lists of Values.
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived table in universe.
• Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports
• Exported the Universes to the Repository to make resources available to the users.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Creation of Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
• Created complex conditions (Dates), Prompts and free hand custom SQL to create Derived table in universe. Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Addressed Chasm trap and Fan Trap using Multi Parse SQL.
• Scheduled reports through Confidential and Info view.
• Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab and Charts to create Web Intelligence reports.
• Linked reports in Web Intelligence using Open doc function.

Environment: Business Objects XIR3.1, Xcelsius 2008,Data Federator, Business Objects Explorer Windows XP, Oracle 10G, QAWS, Live office 3.0, BI Query.

Confidential, New York, NY

Business Object Developer

Responsibilities:

• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• 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.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Created and modified the Crystal 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.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Involved in creating various reports by extracting data from Data Marts
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with Business Objects.
• Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report
• Imported data from Excel to compare Actual Vs Budget.
• Addressed Chasm trap and Fan Trap using Multi Parse SQL
• Created Xcelsius Visualizations and published them to business objects Enterprise, which showed key performance indicators graphically.
• Using Live office imported Web Intelligence reports in Excel and Created Xcelsius visualization based on these reports
• Installation, migration, configuration, maintenance, technical support and troubleshooting of Business objects and Xcelsius implementation in a shared environment scheduled reports through Confidential and Info View.

Environment: Business Objects XIR3.1, Xcelsius 2008, Windows server 2003, SQL Server 2005, QAAWS, Live office 3.0, Netteza, Weblogic web server.

Confidential, Dallas, TX

Business Objects Developer

Responsibilities:

• Gathered requirements from end users to create universes and reports.
• Build the Universes for end user report generation using Designer module.
• Detected Joins and checked the Cardinalities.
• Resolved Universe problems like Loops and Traps using Alias and context.
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Implemented cascading prompts in universe.
• Exported the universes to the Repository for making resources available to the users.
• Created Master/Detail, Cross Tab and various Charts reports and exported to Repository.
• Created reports using Desktop Intelligence functionalities like Sections, Breaks, Filters, Alerter, slice and dice, drill down functions and formulas etc.
• Created Templates in the report generation.
• Was responsible for database connections, SQL joins, cardinalities, loops, aliases, views, parsing of Objects and hierarchies
• Used Business Objects free hand SQL to generate Ad-hoc reports
• Designed new security and implemented the Active Directory Authentication in Confidential .
• Created ad-hoc reports to the business users using Web Intelligence.
• Created Analytics and Metrics to build Dashboards using Dashboard Manager.
• Created Dashboards, Interactive Graphs and Charts Using Crystal Xcelsius.
• Designed Crystal Reports using Crystal report XI.
• Initiated Business Objects Xcelsius Project for DOL
• Tested the reports with Store Procedures in the backend tool.
• Trained the users about all the functionalities and analysis of the reports for their applications.
• Created Folders in the Confidential (Central Management Console) and granted permissions based on their usage levels.
• Created matrices, Dashboards and worked on Deski and Designer.
• Developed and deployed complex Web Intelligence reports
• Migrated universes and reports from Business objects XI 6.5 to Business Objects XIR2 using Import Wizard.

Environment: Business Objects XIR2, Crystal Reports 10, Xcelsius 4.5, Windows 2003, SQL Server 2000,Oracle 10g, Linux, Apache tomcat web server.

Confidential, Jacksonville, FL

Business Object Developer

Responsibilities:

• Designed & Implemented security architecture for Financial Group.
• Involved in Data Modeling process of the project.
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI R2 environment.
• Designed Universes for Financial Billing system and Order processing systems
• Created Objects and prepared Reports for financial and Human Resource departments.
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return.
• Prepared reports for deals, facility and outstanding for the information of expiry date and effective date of each category
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Developed universe user documentation guide for the end users reference.

Environment: Business Objects XIR2, Xcelsius 4.5, Crystal Repots 10, Windows 2003, Linux, Sql Server 2000.

Confidential, Rockville, MD

Business Objects Developer

Responsibilities:

• Designed different Universes as per the requirements for different Business user groups for canned and ad-hoc querying.
• Created number of classes and objects, table aliases, contexts, pre-defined conditions and defined hierarchies to organize the universe.
• Used shortcut joins for optimal use of Universes and fast retrieval of data from Summary tables.
• Exported the universes to the Repository to make resources available to the users.
• Developed various canned Reports that involved use of Prompts, Customized LOVs, Multiple data providers, Master/Detail, Alerts, Cross tab, filters and variables.
• Developed weekly and monthly Company Turnover Reports as per the requirements.
• Created Single, multiple Dashboards using Dashboard Manager.
• Published Documents to Corporate repository for access to authenticated users via Info View.
• Wrote documentation that includes Design details of Universe and Reports.
• Helped various user groups with any Business Objects related issues
• Created Business Objects Repository while building Business Objects solution
• Modified the Budget Universe for the purpose of generating ad-hoc reports.
• Helped the migration team for the universe update to export repository and modification of reports.

Environment: Business Objects 6.5, Web Intelligence, Oracle 9.2, Windows 2000.

Confidential, San Francisco, CA

BO /Essbase Developer

Responsibilities:

• Responsible for design, development and implementation of XI Publisher which involves Creating Publications using Enterprise and Dynamic Recipients, Created Program objects to delete touch file, File based Events to trigger Publications and Scheduled based Events to stagger Publications.
• Responsible for configuring Publication Job Server, Program Job Server, Destination Job Server and Adaptive Job Server as part of Publisher and Scheduler setup.
• Debugged several issues in converted WEBI reports such as #context errors related to merge dimensions, variable/formula errors, data type errors, data provider parse errors, prompt syntax errors, report filter and formatting issues.
• Responsible for converting and resolving conversion issues on most complex reports in BO XI 2 upgrade project.
• Migrated security and content (reports, universes, connections, folders and categories) from one environment to other in XI using import wizard .
• Involved in data model design reviews and performed impact analysis to identify reports and universes which would be impacted with the changes to CID(Customer ID)/CBF Model and implemented those changes in reports/universes as part of CID project.
• Designed and developed dimensional and analytical linked universes which involve creating universe schema, building classes and objects/conditions, resolving loops by defining contexts and aliases, used aggregate awareness for aggregate tables and setting up incompatibilities.
• Developed complex Desktop Intelligence & Web Intelligence reports consisting of several data providers, variables, sections, and many tabs with in the report.
• Involved in Performance tuning and Performance monitoring. Optimized cubes by altering the Dense/ Sparse settings for the different Dimensions.
• Created dimension building load rule and data load Rule for Dynamic dimension building, and Data loading in Essbase.

Environment: Business Objects 6.5, Essbase 9.3, Oracle 8.1.6, Windows NT.

Confidential

SQL Developer

Responsibilities:

• Involved in database design and developing of windows based application to tracking home and auto loan approval process on different branches.
• Imported flat files and excel data files to the customer table using bulk insert operation.
• Involved in design of relation database and different objects like table, stored procedures, triggers and views.
• Developed and integrated reports using Crystal Report 7.0, MS SQL Server 7.0 and Visual Basic 6.0.
• Monitored databases backup and copied to the tape storage for disaster recovery plan and instances on Windows server 2000 servers.
• Developed DTS packages to transfer data from FoxPro to MS SQL server 7.0.
• Created and registered ActiveX DLL and ActiveX EXE components