SUMMARY

• 8 years of experience & expertise in developing Business Intelligence and Data Warehouse applications.
• Wif Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Technical hands - on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, and Supervisor)
• Expert in tuning the performance of SQL queries and ETL process.
• Experience in developing BO universes on SAP BI(Business Intelligence)/BW (Business Warehouse) Objects, including universe creation on BEx(Business Explorer) reports, Infocubes and DSO (Data Store Objects)
• Expertise in working and implementation of Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, Crystal Xcelsius
• Change Management Experience, Project time estimate preparation & Identifying end user training requirements
• Business Objects (BO) Upgrade & Support Experience
• Experienced in interacting wif business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experience in Installation and configuration, Creation of repositories and security domain wif user groups and security implementation.
• Experience in server products like Web Intelligence, Broadcast Agent Server, ZABO, Auditor, Application Foundation, Set Analyzer
• Proficient knowledge on BO XI Architecture and new features.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along wif User Acceptance Test 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.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked wif Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along wif LOV.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Experience in Business Objects training material preparation and training super users/ users on SAP BO Webi / Deski report creation
• Design, development and coding wif ORACLE 10g/9.2/8.x/7.x, SQL Server 2000/2005
• An enthusiastic and project-oriented team player wif solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

OLAP Tools: Business Objects XIR2/XIR1/6.X/5.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard

RDBMS: Oracle8i/9i/10g, SQL Server 7.0/2000/2005 , MS Access 2000, SQL*Loader.

Languages: SQL, PL/SQL, C, C++

GUI Tools: Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, VisualBasic6.0, Oracle Forms and Reports, Oracle Toad, Developer/2000.

Multimedia & Web Designing: HTML/DHTML, MS Office, Adobe Photoshop, PageMaker

Operating Systems: Windows NT/XP/2000/98, MS DOS and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Marshall, MN

Sr. Business Objects Developer

Environment: Business Objects XI 3.1/ XI R2, SAP BI7.0/BW, Teradata, Crystal Reports XIR2, Xcelsius, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP

Responsibilities:

• Participated in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Configured Business Objects client tools on user machines.
• Directly coordinated wif user to gather the new requirements and working wif existing issues.
• Built the new universes as per the user requirements by identifying the required data from SAP BI (Business Intelligence / Business Warehouse) and Teradata.
• Used BEx (Business Explorer) reports and Infocubes to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects.
• Created different reports containing supply planning data like inventory reports, shipments report, Die bank aging reports using alerter, user responses and cross-tabs.
• Used input controls to include/exclude different type of demands like forecast, safety stock, and sales orders in the report during run-time and their-by created a user interactive dynamic report.
• Created change requests and suggested solutions to resolve the issues while using universes and BEx queries.
• Coordinated wif functional team, BI team and Business to get the appropriate mapping for the fields used in the report.
• Opened tickets for data refresh and any data related issues, fixed and delivered the reports on time.
• Joined different universes from APO and BW and created complex reports using crystal and received appreciation from the client.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according to user requirements.
• Exported reports to Excel and PDF for further analysis and decision making.
• Created an interactive dashboard using Xcelsius.
• 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.

Confidential, Rochester, MN

Sr. Business Objects Developer

Environment: Business Objects XI 3.1/ XI R2, SAP BI7.0/BW, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Linux, Windows XP

Responsibilities:

• Build the new universes as per the user requirements and defined the universe connections.
• For best performance, used BEx reports and Infocubes to create the universe.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate aware function to create the summarized reports.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports XIR2.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Developed critical reports like drill down, input controls report for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers to create the common report for the distribution of news papers to different locations
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided time estimates for new proposals and change orders
• Provided training for end users for generating their own report including complicated report.
• Transport Management from Development to Quality to Production
• Coordination wif security team on role setup and providing report access to various user groups
• Upgrade & Support experience to BO 3.1 Version.

Confidential, Livingston, NJ

Business Objects Consultant

Environment: Business Objects 6.5.1/ XI r2,Crystal Report XIR2 SAP BI 7.0, Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Toad9.0, SQL Server2000, Oracle 9i, SQL, PL/SQL Windows 2000/XP.

Responsibilities:

• Directly coordinating wif user to gather the new requirements and working wif existing issues.
• Configured Business Objects client tools on user machines.
• Designed & Implemented security architecture for Financial Group.
• Involved in Data Modeling and SQL server Database
• Identified business objects best practices and documented the same and adhered to naming convention document
• Combined data from SAP BI and SQL Server database in the universe design
• Universe created on BW (Business Warehouse) BEx reports, Multi provider(Multi cube) and DSO (Data Store Objects) in SAP BI
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI r2 Universe designing and establishing BO environment.
• Designed Universes for Financial Billing system and Order processing
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes.
• Involved in joining the tables by creating aliases to resolve the loop
• Created Reports based on sub total of Currency and General Ledger category
• 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 report for Confidential Net Investment Trial Balance
• 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.
• 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.

Confidential, St. Louis, MO

Business Objects Developer

Environment: Business Objects XIR2/6.5 (Supervisor, Designer, Reporter, SAP BW, Broadcast Agent, Web Intelligence and Info View), Crystal Report XIR2, MS Access, Oracle 9i, SQL, PL/SQL and Windows 2003.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial 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.
• Interacted wif 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 Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• 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 wif Drill down option in reports and Predefined Conditions to use in Business Objects.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Involved in creating various reports by extracting data from Data Marts
• Created reports using Oracle Databases and Personal Data File Providers.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Confidential, SANTA CLARA, CA

Business Objects Developer

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

Responsibilities:

• Creating, developing, maintaining and testing the Universe for running the queries against the Database.
• Involved in Installation and Configuration of all products of Business Objects.
• Created Repository and assigned privileges to users and groups using Supervisor.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Exported universes to the repository to making resources available to the users.
• Created reports using the Universes and Free-hand SQL as data providers.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in development and deployment of Complex Reports.
• Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month using Business Objects and reports based on DDD (Drug Distribution Rx Data).
• Created the reports to monitor the 21CFR PART 11 Compliance information of various Drug's provided to Physicians.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Exported the Universe to Repository for making available to Business Objects users and Web Intelligence users.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.

Confidential, Philadelphia, PA

Business Objects Developer

Environment: Business Objects (Supervisor, Designer, Reporter) 6.1, Crystal Reports, Oracle 9i, PL/SQL, Unix, ERWIN.

Responsibilities:

• Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Customized LOVs in Universes for quicker performance of reports.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created different universes which contains the information about the customer like,cust name,address,ph no,plan used,mins used,mins remaining,rollover mins.
• Gatheird information like attempted calls, type of call (long distance, local),length of call, originated number, destination number,rates,time of call for creating report for billing of a customer.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues.
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Linked the Universes to share the common components between the universes.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created reports according to different cell phone plans like individual plan, family plan, family time plan.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
• Created reports using Crystal Reports wif Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers.
• Interacted wif the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Involved in Working wif Erwin tool in Data Modeling (both Physical and Logical Design).