PROFESSIONAL SUMMARY:

• 8 years of Information Technology experience with specialization in the field of SAP Business Objects 4.0, X1R3, XIR2/6.x/5.x, Data Warehousing and Business Intelligence.
• Experience on different versions of Business Objects Enterprise product Suite.
• Involved in Production Support projects by effective User Interaction.
• Over 2 years of experience with Crystal Enterprise product suite (Versions 8, 8.5, 9, 10 and XI).
• Worked with diversified fields of Application development: Software Analysis, Design and Development.
• Experience in the design and deployment of Universes, Business Views, WebI Reports, Full Client and Crystal Reports (8, 9, 10, XI).
• Installation, configuration and maintenance of servers in different cluster environments.
• Gathering requirements from Business Users and analyzing the data to create functional specs as per the requirements and implementing the BI project.
• Worked on Business Objects XI R2/R3, XI, 6.x, 5.x Desktop and Enterprise Product Suite, Web Intelligence (2.x, 6.x, XI R2/R3), XCelsius, Performance Management and Dashboard Manager.
• Worked on data modeling and building data marts for 2 different projects.
• Improved report run times across projects by following different strategies both at database and report level.
• Worked on Metric, created Corporate Dashboards using Application Builder generated Speedometer added Alerts, rules and created Goals.
• Extensive database experience using Oracle (10g, 9i & 8.x), MS SQL Server 2000/2005, MySQL and MS Access.
• Sound knowledge of different phases of Data Warehousing projects and Conversant with Quality procedures while executing the projects.
• Excellent Business Analysis skills: ability to transform business users input to software requirements and specifications.
• Excellent communication and written skills, problem solving skills and possess the ability to work well with staff and clients at all levels.
• Loaded data into data mart from transactional databases using Data Integrator.
• Unique ability to understand long - term project development issues at all levels, from interpersonal relationships to the details of coding scripts. A strong team member with good communication skills.

TECHNICAL SKILLS:

BI Technologies: Business Objects XI 3/XI R2/XI/6.x/5.x Suite (Desktop/Enterprise Server products suite), Web Intelligence (2.x, 6.x, XI R2), CMC, CMS, Broadcast Agent, Auditor, Application Foundation, Performance Management, Dashboards, Live Office, Crystal reports XI, Business view manager.

Database: Oracle 10g/9i/8i/7, MS SQL Server 2000/2005, MS-Access.

Languages: Java, C++, C, VB.

OS: UNIX, Windows NT/2000/XP and DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

Sr.BO Developer

Responsibilities:

• Maintained Universes and added new objects classes based on the Users requirement working knowledge of Linked Universes.
• Used Breaks and Sections in Webi reports; and used different graphical charts and bars.
• Scheduled Webi reports on daily basis and exported them in Excel/PDF format.
• Extensively worked with end user to understand the requirement.
• Created Universe on Stored Procedures.
• Involved in working with different database environments and moved the universes and reports between Dev,Test,Prod.
• Implemented Row level security to restrict the data to the respective divisions.
• 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.
• Created different types of reports like Cross Tab, Charts and Master Detail using multiple data sources.
• Multilevel hierarchies are set up enabling the drill down functionality.
• Created the complex Webi reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Implemented row and object level security in business objects supervisor module.
• Worked with Dimension modeling using Star Schema (ROLAP).
• Managed the scheduling options stored in the repository and also involved in changing the document descriptions.
• Created Business Objects reports, Queries with constant interaction with the end users. Trained end users in understanding the reports. Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.
• Used aggregate aware function and created derived tables in designer.
• Detected Joins and checked the Cardinalities, Resolved Universe problems like Loops, chasm trap fan Trap using Alias and Context, Implemented cascading prompts in universe.
• Written Complex SQL queries and PL/SQL procedures and cursors to retrieve the required information.
• Extensively worked on ETL, created Informatica workflows and sessions to write the data into the Staging tables
• Migrated the Workflows and mappings between Dev,Test,Prod using repository manager.
• Involved in testing universes and reports for correct mapping of the objects and data correctness.
• Created various simple and complex reports mainly using business objects universes as the data Providers.
• Used QaaWS (Query as a Web Service) and Live Office to feed data into Xcelsius 2008.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius.
• Assigned security privileges to users using Supervisor to meet security considerations.
• Installed Business Objects, WebI Intelligence, set up business objects repositories, created users, user groups and provided them access to the Universe and Documents.
• Crystal Reports 10/XI reporting environment and to Design the Universes to meet their reporting requirements. Writing SQL queries, PL/SQL Procedures Installation and Configuration Crystal Enterprise.
• Created the Universes using Business Objects Designer from different databases like Oracle and MS SQL Server.
• Created Joins, defined the cardinalities and also tested them to check for the occurrence of the loops.
• Resolved loops by creating aliases, defining contexts.
• Developed complex reports like Sub Reports, Cross Tab Reports by using Crystal Reports Version XI using SQL Server.
• Deployed Reports on the web by using Crystal Enterprise XI and Crystal Server Pages. Used Publishing wizard and Web Wizard for publishing Reports
• Responsible for tuning the existing universes for time management purposes by creating alternate views and indexes.
• Generated WEBI reports using Business objects WebIntelligence to pop in Java server pages.
• Created reports using Xcelsius 2008 for the business executives. This is used to monitor business through Key Performance Indicators (KPI).
• Created Custom LOV’s (List of Values) and Custom Hierarchies.
• Involved in Report Integration with Java using single sign on method.
• Created Business Objects and WebIntelligence reports using universe as the data provider.
• Provided support to the reporting team for errors encountered while scheduling business objects reports on Broadcast Agent Servers.
• Used Broadcast Agent Server to schedule and monitor reports.

Environment: Business Objects XIR3, Web Intelligence, Apache Tomcat, Broadcast Agent, Crystal reports XI, Oracle 9i, MS SQL Servers 2000, MS Access 2000, Windows 2003 Server/XP, Unix.

Confidential, Washington, DC

SAP BO Developer

Responsibilities:

• Responsible for installing Business Objects Service packs, Patches and critical hot fixes.
• Configure the Xcelsius component with Enterprise Business Objects System.
• Responsible for Design and create Security model like Power User, Report Viewer, QA, Login Administration, Production Support for the Business objects users.
• Developed the universes using the information design tool of BO 4.0 and publishedthem.
• Experience working with Crystal XCelsius to display summary-level business data in a rich and intuitive format.
• Converted the universes from BO 3.1 to BO 4.0 and published them
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Scheduling the migrated crystal reports using BI Launchpadand emailed to the end users
• Responsible for Design and created startup, stop and recycle scripts for Business Objects Server.
• Responsible for setting up the Tivoli alerts for the monitoring the Business Objects Daemons.
• Responsible for Design Promotion process through BIAR method and check the code into clear case.
• Used Import Wizards for migration of the Development to QA and QA to Production environment.
• Involved in the scalable of server based on Server performance and loads.
• Responsible for Centralize support for Business Object suite.
• Ensures the system can be recovered in the event of disaster.
• Ensures the smooth operation of the system from day to day and recovers system in the event of system failure to ensure continuity of service.
• Responsible for Analysis, Design, Migration and Implementation of Business objects suite XI 3.1 on Development environment.
• Involved in analysis of Architect changes and new features on XI 3.1 like Access level, Security Queries etc.
• Provides technical consultant and advice enhancement and modification of these systems
• Responsible for in gathering user requirements.
• Design, implement, distribute, and maintain universes based on Enterprise Data warehouse
• Implemented the rows level security to filter firms based on Sales Group user login.
• Used Star Schema and Snow Flake Schema in the data modeling phase and Contexts and Aliases for resolving for resolving Loops and context in the Universes
• Created breaks, master detail, sorting, drill down, slice and dice, alerts, joins, hierarchies, ranking features to generate Adhoc, automated and complex Web Intelligence and Desktop Intelligence reports.
• Created custom calendar to schedule the Web Intelligence reports.
• Utilized Business Objects built-in @functions (@aggregate aware, @select, @prompt, @where) to improve the performance and to overcome intricacies related to data integrity.
• Create custom Audit Webi and Crystal report to monitor user activity.
• Designed and Created Business Objects Voyager Workspace reports against OLAP cubes as data source.
• Designed and Created Dashboard using Xcelsius, Qaaws, Live Office for Proof concept for Xcelsius Products.
• Responsible for Xcelsius Dashboard System Implementation
• Implemented Single Sign on for Live Office Add on tools
• Created Qaaws(Query As Web service), Multi-Layer Dashboard, new components in Xcelsius charts like Line Chart, Pie Chart, Bar Char, Combination Chart, Container like Tab sets, Selectors like Accordion Menu, Check Box, Combo Box, List box, List view, Single value like Gauge, Slider, Alerts Dynamic Selection, Dynamic Visibility.
• Worked as Backup for Informatica Administrator and NDM Administrator.

Environment: Business Objects XI 3.1/R1/R2/R3, Designer XI R1/R2/R3, Desktop Intelligence, Sun Active Directory, Web sphere 6.0, Sun one 6.1 SP1, Site minder 5.5, Business Objects Voyager R2/R3, Dashboard Manager, Performance Manager XI R2/R3, Xcelsius 4.5/2008, Live Office R2/R3, Crystal Reports R2, SSL,Tomcat, Oracle 9i/10g, SQL, PL/SQL, Sun Solaris 5.8/5.10., QAAWS (Query as Web Service), Auditor Xi R2/R3, Tivoli, Informatica 7.1.5

Confidential, Chicago, IL

SAP BI / Business Objects Developer

Responsibilities:

• Involved in requirement gathering from the users for the reports and worked along with business analyst and architect.
• Designed Universe classes and objects for the reports.
• Actively participated in meetings with the team and ensured the reports are completed in timely manner.
• Researched about data issues in the report and reported them to the team to correct them in ETL.
• Helped team to resolve the issues they have in other reports like Client report.
• Actively involved in tuning of the report sql’s with architect, DBA and other team members for the performance of the reports by creating indexes and following best practices in Universe and report designs.
• Created security in CMS for the data to be viewed by respective persons.
• Designed and developed various Metrics, Analytics like speedometer, Interactive Charts, Alerters and Goals for creating Dashboards using Dashboard Manager
• Developed the universes using the information design tool of BO 4.0 and publishedthem.
• Experience working with Crystal XCelsius to display summary-level business data in a rich and intuitive format.
• Converted the universes from BO 3.1 to BO 4.0 and published them
• Involved in using Crystal Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Publishedthe migrated crystal reports to the BI Launchpad.
• Scheduling the migrated crystal reports using BI Launchpadand emailed to the end users.
• Created Dashboards using data in Live Office Excel Spreadsheet
• Resolved many production support issues that came up with the reports created by analysts.
• Installed/Configured Auditor in Dev, QA and Prod environments for user activity logging.
• Understood the business in detail and helped, adviced team in resolving many issues with the data.

Environment: Business Objects XIR2, Crystal Xcelsius Designer4.5, Performance Management, WEBI, Import Wizard, MS Sql Server, Oracle 9.2, PL/SQL, Java, JSP, Java/SDK,HTML.

Confidential - Knoxville,TN

SAP BI /Business Objects Developer

Responsibilities:

• System study, interaction with users & management, performance of analysis, designing, coding, and testing & implementation of the system.
• Involved in complex report designs using Sales Data..
• Developed Functional (Business terms) and Technical Design documents.
• Interacted with users to gather requirements for HR data
• Implemented best practices throughout the project
• Tuning of SQL queries for better performance.
• Creation of different types of reports, such as; Master/Detail, Cross Tab and Chart (for trend analysis). Use of filters, conditions, calculations, etc.
• Maintained repository by Security and document domains successfully using best practices
• Gathered requirements by talking with different end users in HR department across different departments.
• Worked on Universes and maintained different universes in designer.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Instrumental in fitting the Business Objects Architecture into the System.
• Involved in development of reports like Reports like Hired Candidates, Filled Requisitions, Offer Status, Offer Compensation, Open Requisitions, Pending Requisitions, Requisitions on Hold, Candidate Step Aging reports etc. were developed on the data mart.
• Trained the user community to create and publish reports.
• Testing of Reports and deploying them over web.

Environment: Business Objects XI R2/ 6.5.1(Designer, Reports, Supervisor, Miner), Web Intelligence, ZABO, Broadcast Agent Server, Data Stage 7.5, TOAD, Version Manager, Oracle 9.2, WEBI.

Confidential - FAIRFAX, VA

Business Objects Developer

Responsibilities:

• Implemented logical and physical data modeling.
• Created the Repository structure to manage the security and deployment options throughout the installation.
• Designed, developed, deployed and maintained Universes using Business Objects Designer.
• Resolved the loops using Aliases and Contexts.
• Checked the Integrity of the Universes and Exported the Universes to Repository for making available to users.
• Generated various reports as per the client's requirements
• Created universes on various sources that could be joined at a report level to create reports from heterogeneous sources.
• Exported the Business Objects reports to WEBI, to be viewed by all users on the intranet and extranet.
• Created many simple, complex and Ad hoc reports using universes as main data providers and having the Powerful business objects functionalities like @functions and formulae.
• Created queries for multidimensional analysis using slice, dice and drill modes.
• Analyzed complex business needs presented by the user community and/or clients and recommend technical solutions for improve the reporting environment.
• Developed PL/SQL stored procedures for the end-user report requirements.
• Trained end users in basic and advanced ad hoc reporting skill.

Environment: Windows NT, UNIX, SQL-Server 7.0, Oracle, Erwin, Business Objects(Designer, Reporter, Supervisor), Web Intelligence, ASP and Visual Basic.

Confidential

Business Objects Developer/ Report Analyst

Responsibilities:

• Analyzed the existing Database Application and designed a Prototype of Universe based on the Business Requirements
• Involved in the installation and configuration of BO XI R2 SP2 and BO XI R3 on the various BO users workstations with the backend RDBMS (Oracle 9i) client.
• Designed and developed Universes by defining Joins, Cardinalities and applied contexts and aliases to remove dependencies.
• Created reports for the users on a regular and ad-hoc basis using Business Objects and WebI, which were used by the managers to make key decisions.
• Created reports using Business Objects functionalities like slice and dice, drill down, cross tab, master detail tables and formulae.
• Converted existing MS Access Reports to BO XI R2 Deski reports by analyzing the previous created reports.
• Created complex reports by linking data from multiple data providers, using free hand SQL, PL/SQL and functionalities like Combined Queries.
• Involved in the Performance tuning of the reports both at the Universe level and the report level.
• Created Prompts, Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created different types of reports like Master/Detail, Cross Tab and Charts (for trend analysis).
• Trained the various functionalities of BO XI R2 to the Business Objects Users.
• Formatted the reports as per business requirements and design.
• Generated reports for web users using Web Intelligence.
• Tested the developed universes and reports for final deployment.
• Scheduling and Maintaining the Unix jobs
• Built several Universes and Reports as per the requirement and design.
• Coordinated with users to determine existing issues and also involved in gathering new requirements.
• Used Designer Module to create prompts and queries, applied aliases and contexts to resolve loops.
• Writing PL/SQL Scripts for some data marts
• Migrated universes and reports across Development, Testing and Production Domains.

Environment: Business Objects XI R3, Info view, Web Intelligence XI R3, Crystal reports, Xcelsius 4.5 Professional, Teradata SQL assistant 7.2

Confidential

Software Developer

Responsibilities:

• Involved in developing web site in Java Server Pages, JavaBeans and Servlets.
• Created the User Interface using Java Server Pages.
• Designed Database Tables and implemented Database Connectivity using JDBC.
• Client side validations done using JavaScript, and Server side coding using Servlets.
• Added additional fields to existing Oracle database tables, change tables, updating sourcing programs.
• Written SQL programs to extract data from Oracle databases based on user requests.
• Updated documentation/logical design diagrams to reflect database changes.
• Worked with COBOL VSAM files for Master file update and Data validation.

Environment: Windows NT, UNIX, SQL-Server, Java, JSP, COBOL, JCL, Assembler, VSAM,BSAM, PL/SQL and Oracle.