SUMMARY

• Over 8 years of experience in Information Technology with strong work experience asBusiness Objects Developer.
• Broad experience inAnalysis, Design, Development, Implementation, Deploymentand maintenance ofBusiness Intelligence applications.
• Contributed in all phases ofSoftware Development Life Cycle SDLC(RequirementAnalysis, Design, Development, Testing, Production and Documentation).
• Proficient in Business Objectsenterprise Products(Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM)and its deployment.
• Possess excellent communication, decision - making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. Capable of working as a Team Member or Individually with minimum supervision.
• Superb data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Skilled in identification of Business and Data requirements and converting them into conceptual and logicaldata models.
• Know-how in creating Ad hoc reporting ready universes usingBusiness Objects Universe Designer.
• Broadly used various features likeJoins,AliasandContextsin Universe designer to overcome varioustraps (Chasm, Fan)andLoops.
• Experience in building and retrieving data usingUniverses, Personal data files,and creating complexad-hoc Reportsusing theBusiness Objectssuiteapplications.
• Comprehensively used advanced reporting functionalities such as Master Detailed,Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Installation and configuration ofXcelsius, QaaWSClient Server Modules and designingcomplex reportsanddashboardsin monitoring business metrics.
• Hands-on experience in developing AnalyticalDashboardsusingXcelsiuswithQaaWSandLive Officeconnectivity.
• Organized work between onshore and offshore training & supporting end-user reporting needs using Business Objects.
• Develop system enhancements including requirements analysis, design, build, test, and deploy
• Experience in Dimensional Data modeling -Star Schema modelingandSnowflake modeling.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Solid database experience in usingOracle11g/10g/9i/8i, MS SQL Server 2008/2005, MS Access.
• Excellent understanding of Data Warehousing Design Methodology,Data Warehouse Concepts, Database design/architectureincluding bothOLAP & OLTP dataand complete lifecycle of project from design to development and implementation.
• Hands on experience in IDT of BO 4.0 version.
• Useful Knowledge on Tableau, Qlikview, IQ20/20 and Roambi tools.
• Vast experience on OPX2(Planisware P5) application which provides resource management and project planning capabilities

TECHNICAL SKILLS

Business Objects Tools: Business Objects XI 4.0/3.1/3.0, XI R1/R2,6.5, Web Intelligence XI 3.1/3.0/XI R2,Crystal Reports, Universe Designer XI 3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services(QaaWS), Live Office, BO Explorer, Tableau, Qlikview, IQ20/20,Roambi

Databases: SQL Navigator, MS SQL Server 2008, Oracle 11G/10G

Operating Systems: Microsoft Windows 2000, XP, Windows 7

Windows Utility: MS-Word, MS-Excel and MS-PowerPoint

Query Tools: TOAD, SQL Navigator, SQL *PLUS

Programming Languages: SQL,JAVA,C#

SDLC Methodologies: Agile, Waterfall, V-Model

Ticket Tracking Tools: Remedy, Vitalize

PPM Tools: OPX2/Planisware 5

Quality Management: Quality Center

Project Management: Microsoft Project Professional

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Business Objects Developer

Responsibilities:

• Involved in complete life cycle of the project.
• Interacted with users, gathering and analyzing requirements, logical and physical design of the reporting system.
• Designed Functional Specification Documents (FSD) and Technical Specification Documents (TSD) based on requirement.
• Installed and configured Business Objects Enterprise environment.
• Installed and configured Crystal Reports and Xcelsius Enterprise 2008.
• Installed SAP Integration KIT XI 3.1 and configured SAP GUI tools.
• Used Designer Module to design Universes, joining the tables and queries and applied Contexts and Aliases to remove loops.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Published Universes and Report documents to the Repository as part of the production deployment and made them available to the users.
• A custom hierarchy has been created for report level Drilling information.
• Developed Complex Reports using Web Intelligence Rich Client (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Tailored desktop intelligence reports based on end user’s Profile and Published those with destination Email, FTP and Infoview inbox.
• Involved in day to day Business Objects Server maintenance.
• Actively involved in Business Objects XIR3 and Performance Management, Service pack (SP2), Monthly Hot Fixes and Critical Hot Fixes on production, Acceptance and Development environment. Set up BO CMS and Auditing CMS for auditing for servers in CMC.
• Created/Administered users/user groups/Security in CMC.
• Designed Test cases for UAT of Reports for end users.

Environment: Business Objects XI-R3, Crystal Reports XI, Web Intelligence, Desktop Intelligence, BO Metadata Manager, TOAD, Oracle 10g and Microsoft windows server 2003.

Confidential, Abbott Park, IL

Sr. Business Objects Developer

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifyingUniverses and Reportsaccordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications forBusiness Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Appliedsecurity featuresof Business Objectslike row level, report level & object level security in the universe so as to make the sensitive data secure.
• Designed and maintainedcomplex Universes,resolved loopsby creatingaliasesandcontexts.
• Exported thead-hocready universes for makingsemantic layeravailable to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query as a Web Service (QaaWS) from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created theWeb Intelligence Reportand usedEventsforDaily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involvedin performance testingof all the reports, which helped in analyzing its performance before moving into production.
• Extensive experience on OPX2(Planisware P5) application which provides resource management and project planning capabilities

Environment: Business Objects XIR4.0/3.1, WebI, Xcelsius, Universe Designer, Oracle 10G, PL/SQL, Windows XP/7.

Confidential, Delaware, OH

Business Objects Developer

Responsibilities:

• Gathering Business requirements for Business Objects Universes, reports and Dashboards.
• Involved in Fit Gap analysis
• Designed Functional Specification Documents (FSD) and Technical Specification Documents (TSD) based on requirement.
• Interacted with Project Manager and Business Analyst to understand the requirements and modifying universe, report specifications.
• Designed, implemented entire Business Object architecture environment within the organization.
• Installed and configured Business Objects Enterprise environment and Crystal Reports.
• Actively involved in Business Objects XIR2 and Performance Management, Service pack (SP2), Monthly Hot Fixes (MHF) and Critical Hot Fixes (CHF) on production, Acceptance and Development environment. Set up BO CMS and Auditing CMS for auditing for servers in CMC.
• Created Universes as per the user requirements and implemented with best practices.
• Exported the universes to the Repository to make resources available to the users.
• Implemented Row Level security and User restrictions at universe level.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice to develop the reports.
• Created reports on the web using Web Intelligence and distributed them to different users through Infoview portals.
• Designed and developed several complex reports using Hyper linking, drill down features, sub reports, cross tab reports, labels, summary reports.
• Published report to Enterprise server, to get the report access from Infoview.
• Implemented Event Based scheduling and periodical scheduling.
• Created Publications for mass user’s distribution and scheduling.
• Responsible for developing complex reports by using Crystal Reports.
• Created folders, users, groups and assigned roles based on the business group using CMC.
• Involved in clustering Servers in the production environment to maintain High - Availability and tested the failover capability and load balancing.

Environment: Business Objects XI R3 (Web Intelligence, Designer, Dash Board Manager), Crystal Reports, Microsoft server windows 2000/2003, Oracle 9i, TOAD, and SQL*Plus

Confidential, San Antonio, TX

Business Objects Developer

Responsibilities:

• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
• Designed Universes, incorporating all the business requirements.
• Implemented object level security universe to in corporate security for sensitive information.
• Worked in migration of universe and reports between environments.
• Designed universes, solved loops by creating aliases, contexts and resolved traps.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in end user training and documenting the procedures.
• Involved in developing the financial reports for the Financial Services Department and successfully published the highly formatted reports and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation inCross Tabin Web I XI R2.
• Scheduled pre-canned reports through Scheduler for distribution and printing.

Environment: Business Objects XI3.1, Web Intelligence, Xcelsius 2008 Oracle 9i

Confidential, Phoenix, AZ

Business Objects Developer

Responsibilities:

• Information gathering - interacted with the end user to understand the requirement and business logic
• Analysed the existingOLTP systemand designed and manageduniversesbased on the Business Requirements
• Designed, Developed and Maintained Universesby definingjoins, cardinalitiesbetween tables applyingcontexts and aliastables to remove cyclic dependencies
• Used@functions like @select, @where and @prompt functionto createpromptswhich helps the user to select the values dynamically
• Customized thelist of values (LOV’s)which helps the end users to select the values.
• Created complexCondition Objectsfor easy reporting,Aggregate-Aware objectsfor better performance
• DevelopedBusiness Objects Universeswithclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Created reports usingBusiness Objects functionalitylikeslice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports bylinking datafrommultiple data providers, using free hand SQL and functionalities likeCombined Queries.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Scheduling reportsfrom the Broadcast Agent Server to only requested users.
• Worked extensively onWeb Intelligencefor any new requests and performance issues.
• Involved in installingWeb Intelligence, creating users, user groups and categories
• Generated reportsfor web users usingWeb Intelligence and Info View.
• CreatedWeb Intelligence documentsand published them to corporate documents.
• Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Migrating Business Objects6.5.1 version reports to new version XIR2.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Imported existingusers, groups, categories, WebI documents, connections, universes and restrictionsto BO XI environment usingImport Wizard.
• Created reports usingDesktop Intelligence and Web Intelligencein BO XI R2 environment.
• Synchronizedqueries frommultiple data providersby linking the common dimensions using merge dimensionsoption in Web XI R2.
• Extensive testing and migrating the reports or objects from development to Production system

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web Intelligence 2.x/6.x, BOXI R2 (CMS, CCM, CMC), Oracle 10g, PL/SQL, SQL Server 2000, Windows 2000, UNIX, Crystal Reports XI/9.0, Crystal Xcelsius.

Confidential, Santa Clara, CA

Business Objects Developer

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Add more groups and change the profile of users via supervisor.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Specified the Joins and checked the cardinalities.
• Implemented User Objects in Reports.
• Created Condition in Universe.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Resolved loops by creating Aliases and Context.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Environment: Business Objects 6.5, Web Intelligence, Oracle.