SUMMARY

• Over 8 years of experience in Information Technology Industry out of which nearly 7 + years of experience into design, migrate, create and modify Business Objects Universes and Reports
• Expert in Business Objects BO 4.0/XI 3.1/ 3.0/R2/6.5
• Experience wif Installing and Administration of entire hardware, and software products like Tomcat, and Apache (Clustered and Standalone environments).
• Installed and tested teh BI4.0 application.
• Worked wif server team to provide them wif list of specifications need to build teh servers for BO4.0.
• Worked wif Developers to consolidate teh Business Objects repository before migrating to BO4.0.
• Expert in designing, developing, maintaining and optimizing teh Universes using Designer module.
• Substantial experience in Business Objects Migration (XIR 2/3.0/3.1/4.0 ).
• TEMPEffectively administered and supervised teh Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports.
• Knowledge about Business Objects Security Model and experience wif Business Objects Security Implementation (Row level, Object level, Command level in both 6.5 and XIR 2).
• Expertise in working wif all teh modules of Business Objects (All Versions including XIR3) like Supervisor, Designer, BO User, Web Intelligence, Desktop Intelligence, CMC, CMS, BCA, BO SDK and Crystal Reports.
• Extensive experience in migrating Single/Multi Server deployment on Windows/Linux from XI R2 to Business Objects Enterprise (BOE) XI 3.1 and XI 3.1 to 4.0 and importing R2 deployment into 3.1 to 4.0
• Technical hands - on expertise using Business Objects (BOBJ) suite of products XI 4.0/3.1/ R2, Crystal Reports XI R2/2008, Xcelcuis 2008/Dashboard Design and hands on experience wif IBM Information Server / Datastage ETL / Informatica ETL.
• Designing, developing and modifying BOBJ universes and expertise in creating various complex web, desktop Intelligence reports for business users scheduling teh processes and administering teh BOBJ activities using Central Management Console CMC.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks by linking teh data sources from multiple providers.
• Experience in creating folders/categories, users groups and setting user rights and managing security in Central Management Console (BOXIR3, BOXIR2) and BI 4.0.
• Strong experience in advanced Document Scheduling using Broadcast Agent, distribution and troubleshooting including: Report Bursting, publishing over teh World Wide Web, creating and managing Categories using Info View and Broadcast Agent.
• Excellent experience in creating interactive & executive dashboards using Dashboard Design, Xcelsius 2008 on relational databases.
• Extensive experience in designing Xcelsius dashboards using web service connectors QaaWS, Live Office and BI Web Services.
• Excellent experience wif DW concepts such as star schema, snowflake schema, fact and dimensional tables.
• Strong of experience analysis, design, development and implementation of Relational database and Data warehousing systems using IBM Datastage 8.0/8.1 (Information Server, Web Sphere).
• Excellent experience in designing, developing, documenting, testing of ETL jobs and mappings in server and parallel jobs using Datastage to populate tables in Data warehouse.
• Proficient in developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• Trained teh end users in working wif teh Business Objects suite of products and provided technical expertise.
• Possess excellent analytical, problem solving, communication, presentation and interpersonal skills to manage and interact wif users/customers and groups at all levels.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Business Intelligence Lead Developer/Administrator

Environment: Business Objects (BOBJ) XI 4.0/R3.1 SP5/R2 SP1 (BI launch pad, Universe Design tool, Promotion Management tool, Central Management Console, Web Intelligence, Web Service Query, Version Management, Auditing, Information Design Tool - IDT, Dashboards, Universe Designer, WebI Rich Client, CMC, InfoView), Dashboard Design 6.0, Xcelsius 2008, DB2 8, 9 and 10, Red Hat Linux 4 & 5, Tomcat 5.5, IBM Data stage ETL

Responsibilities:

• Understand business functional requirements and reporting tool functionality; synthesize teh requirements and business intelligence capabilities into functional specifications; prepare technical specifications; and develop and test teh final product. Teh solutions contain ad-hoc query, drill-down, slice and dice capabilities, static reporting, managed queries, and dashboards
• BO Upgrade from XIR2 to BI 4.0 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Ensured all teh environments are in synchronization and checked supported environments and hardware requirements from teh Products Availability Report (PAR) document for teh new installation.
• Identify teh servers for Installation, Decluster teh server wifout Apache Tomcat installation. Test CMS and CCM of independent servers, Performed Parallel installation BOXIR2, BOXIR3 and BI 4.0 on a Clustered environment.
• Uninstalled BOXI R2 from teh server to install and Removed Registry Entries wif keywords such as Business Objects, business objects, busobj, bobj, Crystal Decisions, Designer, Desktop Intelligence, Web Intelligence etc before teh installation.
• Transferred CMC data between old (XIR2) and new version either through CMC/BIAR File/Import Wizard.
• Migrated Universes, Reports, and Securities from teh Development to Production environment after System Integration Testing (SIT) and tan followed by Customer Acceptance Testing (CAT). Used Import Wizard for teh Migration process across teh environments.
• Administer and supervise teh BO environment by monitoring/granting permissions and rights to vast users, creating and publishing reports and implement Folder and object level restrictions.
• Importing teh groups and users from windows Active Directory into Business Objects and granting teh users and groups wif appropriate rights trough Central Management Console.
• Administer and supervise teh BO environment by monitoring/granting permissions and rights to vast users
• Designed and maintained Universes on DB2 tables by defining joins and cardinalities between tables. Addressed cyclic dependencies issues by either applying contexts or creating aliases.
• Created reports using Business Objects functionalities like queries, slice and dice, drill down, cross tab, master detail reports, formulas, etc using BI Launchpad and Web Intelligence Info View.
• Used various @Functions like @Aggregate Aware, @Prompt, @Script, @Select, @Variable and @Where
• Used hierarchies in Universe level and used Scope of analysis in report level to drill up and drill down teh reports.
• Designed .unx universes in Information Design Tool (IDT) for use of Dashboard Design (Xcelsius), which eliminates teh use of QaaWS tool.
• Built Xcelsius dashboards using Live Office, QaaWS and BI Web Services for live data connectivity.
• Optimizing Universe - Analyze teh report SQL for unnecessary joins, Analyze report query for indexes, Use Aggregation for measures, Use partitions for high volume fact tables, Configured Array fetch size in Universe Options screen, Universe Analysis for Shortcut joins which play important role in performance, Index Awareness, Universe cleaning (make sure LOV is disabled for measures & unnecessary dimension objects) and Try evaluating join by sql universe parameter
• Used teh Promotion Management to import existing user accounts, groups, categories, WebI documents, universes, connections and universe restrictions to BI 4 environment.
• Used Publishing feature to send daily/invoice e-statements to huge number of users
• Created Access Restrictions for individual users/groups wif Connections, Controls, SQL, Objects, Rows in teh universe and Row Level Security for users using Where clause
• Provided end user and production support after deploying teh application into teh production environment.

Confidential

Business Intelligence Lead Developer/Administrator

Environment: Business Objects (BOBJ) XI 4.0/R3.1 SP3 (WebI, DeskI, CMC, InfoView), BI Launch Pad 4.0, Xcelsius 2008, DB2 8, 9, 10, Red Hat Linux 4, 5, Tomcat 5.5 and Datastage ETL

Responsibilities:

• Work in conjunction wif Solutions Program Manager to ensure project team deliverables as assigned are completed accurately and on schedule in accordance wif teh project plan.
• Designed and maintained Universes on DB2 tables by defining joins and cardinalities between tables. Addressed cyclic dependencies issues by either applying contexts or creating aliases.
• Used @functions like @select, @where and @prompt to create prompts dat halp teh user to select teh values dynamically.
• Designed .UNX universes in Information Design Tool (IDT) for use in Dashboard Design(Xcelsius), which eliminates teh use of QaaWS tool
• Involved in teh creating teh reports using BI Launchpad and Web Intelligence Info View. Created teh Reports (Master/Detail, Brake, Cross Tab, Chart, and Templates) in Business Objects using teh Universe as teh main Data Provides and writing teh Complex queries including Sub-Queries.
• Used teh Publishing wizard to export different document types as objects to different folders in CMC.
• Created reports prototypes using Web Intelligence BI 4 for user presentation.
• Trained teh Business Users in report creation and also new features of Business Objects BI 4.
• Created classes, sub classes, objects, measures, details and conditions in universe level and created variables in report level.
• Used hierarchies in Universe level and used Scope of analysis in report level to drill up and drill down teh reports.
• Built WebI reports using tools Interactive Analysis, Web Intelligence Rich Client and BI Launchpad.
• Built Xcelsius dashboards using Live Office, QaaWS and BI Web Services for live data connectivity.
• Created reports on web using BI Launchpad and Web Intelligence Info View, distributed teh reports to different users.
• Involved in setting privileges to different user groups coordinating wif supervisor and DBA using CMC Module.
• Worked on scheduled and On-demand dashboards for Gaming Data using WebI & Universes.
• Used OpenDoc methodology to embed multiple .swf files into a parent .swf using SWF loader in Xcelsius.
• Deployed and tested dashboards across environments in BOE.

Confidential

Business Intelligence Developer

Environment: Business Objects (BOBJ) XI R2/R3.1 SP2 (WebI, DeskI, CMC, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, DB2 8.1, Red Hat Linux 4 and Tomcat 5.

• Involved in requirements gathering from teh business users to build teh reporting application.
• Closely worked wif business stakeholders as well as teh BI Application Team developers and analysts to develop guiding principals and best practices
• Designed Universe by creating teh Business Objects Data Model selecting/joining tables, indicating cardinalities, creating aliases to resolve teh loops, subdividing into contexts and creating teh objects like Dimensions, Details and Measures which are grouped into Classes and checked teh integrity of teh universe.
• Created Hierarchies to setup dimensional hierarchies for multidimensional analysis
• Created Customized Hierarchies, complex objects using various @functions, Aggregate objects in teh universe. Used Aggregate Navigation to setup alternate aggregate tables and used to specify incompatible objects
• Defined Customized LOVs, Predefined Conditions, Dynamic Filters and Dynamic Conditions in universe. Examples, Select Trailing N Weeks, Prev Year 1 Weeks Sales, 1 Week Sales, Prev Year 13 Weeks Sales, 13 Week Sales, Prev Year 26 Weeks Sales, 26 Week Sales, FYID (Previous), FYID (Current), Enter Date Range (Last Week), Cal Week To Date, Cal Month To Date, Cal Qtr To Date, Cal Year To Date
• Designed cascading prompts in teh universe to filter teh list of account names based on teh business units.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and Formulas etc.
• Created & Used Linked universe to get core classes/objects - Kernel approach (core universe is not hidden), Master approach (core universe class & objects are hidden according to relevance), Component approach (merging 2 universe to one) - universes are linked in Universe Parameters screen
• Used derived tables - created nested derived tables using @DerivedTable and its advantage create derived table using already created derived table
• Resolved Chasm traps, Fan Traps & Loop problems.
• Used hyperlinks in webi to open another report, dimensional hiding/conditional column hiding on webi reports
• Used Scope of Analysis and Drilling - Single Dimension Drilling in Headings, Multiple Dimension Drilling in Cross Tabs & Drilling in Charts
• Used Scope of Analysis in report level & Custom Hierarchies in universe level
• Designing Xcelsius dashboards using web service connectors QaaWS, Live Office and BI Web Services.
• Created users and groups and applied row level and objects level securities using Central Management Console.
• Performed universe optimization for universes existing/newly created.
• Interacting wif teh cross functional users to analyze teh business process and gather teh specific requirements for data warehousing and reporting. Responsible for producing functional and technical specifications documents by capturing teh information from teh requirements gathering sessions.
• Develop departmental design policies and procedures.
• Address and resolve routine design issues using standard issue resolution methodologies.
• Identify opportunities for continuous improvement of design, development, and integration processes.

Confidential

Business Intelligence Developer

Environment: Business Objects XI R3/R2 (WebI, DeskI, SDK, CMC, CCM, Broadcast Agent, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, IBM DB2 8.1, DB2 PL

Responsibilities:

• Interacted wif teh Business Users to analyze teh business process and gathered teh requirements made necessary changes to schema objects to fulfill their reporting and business needs. Involved in Installation and Configuration of all Components of Business Objects.
• Designed new Universes using various @functions, aliases, contexts, user objects and modified teh existing Universes based on teh report requirements.
• Expertise in creation of WebI & DeskI reports, formatting reports, generation of charts, as per user requirements.
• Interacted wif teh users to analyze teh changes for improvement they need in existing reports and developed teh reports to satisfy their needs and requirements.
• Tuned teh queries to improve teh performance of teh existing reports for various functional areas.
• Used Derived tables to create teh universe for best performance, and use context and alias tables to solve teh loops in Universe.
• Created reports on web using Info View Portal and Web Intelligence, distributed teh reports to different users.
• Extensively used teh Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Managed teh resources, granted permissions to Business Objects product users, Webi users, managed teh connections, teh Universes and repository domain.
• Extensive experience in developing static and dynamic dashboards using Xcelsius Enterprise 2008/4.5 via teh web service connectors QAAWS and Live Office.
• Used open document command to pass a parameter to Xcelsius to filter teh data.
• Created Hierarchies, complex objects using various @functions, aliases, contexts, Aggregate objects in teh universe. Setup user profiles, created BCAs for groups, Categories and Channels using CMC.
• Worked on complex Crystal reports dat require running totals, sub-totals, cross-tab, multiple groups, and Conditional display of groups, Combined Queries, Drill Down, and Master Detail to make teh reports easier for analysis.
• Developed Stored Procedures Using DB2 PL programming to improve teh performance of teh reports using complex queries.
• Developed universe user documentation guide for teh end users reference.
• Involved in providing Production support to teh end users. Dealt wif various user issues/technical problems, providing technical support.
• Monitored and solved teh issues encountered in Universes and reports while migration and tested before moving to production.
• Training teh end users on using teh WebI environment by highlighting teh user friendly concepts and teh ease in developing Ad-hoc reports. Provided teh end users wif easy to read and understand documentation for teh WebI reporting tool.

Confidential

Business Intelligence Developer

Environment: Business Objects R2 (WebI, DeskI, SDK, CMC, CCM, Broadcast Agent, InfoView), Xcelsius 2008/4.5, Crystal Reports 2008/XIR2, IBM DB2 8.1, DB2 PL, Red Hat Linux 4 and Tomcat 5

Responsibilities:

• Worked extensively wif teh Business Analyst team in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about teh financial system for Business Objects Universes and Reports.
• Exported universes to teh Repository for making resources available to teh users.
• Extensively used teh Business Objects functionality such as Master-Detail, Slice and Dice, Drill Down and Hierarchies for creating reports.
• Designed, developed and Maintained Universes by defining joins, and cardinalities between tables. Addressed cyclic dependencies issue by either applying contexts or creating aliases.
• Involved in designing brand new universes in teh BO XI R2 environment. Teh universes were designed to satisfy both Ad-hoc and canned reporting purposes.
• Used @functions like @select, @where and @prompt to create prompts dat halp teh user to select teh values dynamically.
• Analyzed migration strategies for Business Objects Universes and reports across multiple Business Objects Repositories (Development, QA and Production).
• Migrated from Business Objects earlier versions to XI R2.
• Monitored and solved teh issues encountered in Universes and reports while migration and tested before moving to production.
• Created many complex WebI and full client reports which include special field, user variables and complex calculations using report level contexts (In context & Out Context).
• Developed, tested and implemented new DB2 PL, Functions and Stored Procedures, Triggers etc.
• Scheduled jobs and reports through Broad Cast Agent server for automation on timely fashion, Daily, Monthly reports, file watcher reports.
• Involved in providing Production support to teh end users. Dealt wif various user issues/technical problems, providing technical support.
• Responsible for coding, unit testing, design and code review and maintaining system documentation.
• Training teh end users on using teh WebI environment by highlighting teh user friendly concepts and teh ease in developing Ad-hoc reports. Provided teh end users wif easy to read and understand documentation for teh WebI reporting tool.
• Recommended and implemented design changes to warehouse, fact tables and indexes to improve query performance.

Confidential

Business Intelligence Developer

Environment: Business Objects XI R2 Enterprise, IBM DB2 8.1, Windows 2003 Server, Informatica 7.1.3

Responsibilities:

• Work closely wif Business Analyst team to create teh necessary BO reports to replace teh existing legacy system reports, creating detailed templates for Business/users needs and educate them to utilize teh report for business requirements, Adhoc, report modifications, BI query objects.
• Administrate and Configure Business Objects Environment wif respect to teh project plans.
• Administration of Business Objects environments including monitoring, security administration, performance management and capacity planning. Administrate user privileges, user groups and Universe development.
• Designed teh conversion project for teh existing Legacy Reports in to teh Business Objects Webi Reports and work closely wif Architects to upgrade teh existing BO version to BO XI R2 system. Interpreted meaning and relevance from raw data and perform detailed analysis and transforming in to teh powerful Webi Reports.
• Responsible for gathering and conducting analysis, developing functional & technical designs solutions. Coding, Reviewing, Formatting, Testing, Bug fixing & Integration wif different classes. Analyzing system functionality requirements, documents and scope of teh work.
• Schedule jobs and reports through Broad Cast Agent server for automation on timely fashion, Daily, Monthly reports, file watcher reports.
• Perform Unit test, UAT, Smoke test on teh reports. Perform complete analysis on teh life cycle of teh project. Forecasting teh issues, Project evaluation, Report usability and analysis.
• Data quality testing, assisting wif user acceptance testing. dis includes in building enhance and deploy new and existing Business Objects reports/universes as required as well as assist team in delivering complex Adhoc analysis and reports via teh data warehouse.
• Worked Extensively on Informatica (Designer, Workflow) for data extraction, transformation and loading.
• To analyze inputs and devise strategy based on best practices and future supportability.
• Assist my team members in troubleshooting, diagnosing and resolving complex Business Object problems to ensure high performance and minimal disruption of critical systems.
• Creation of technical and user documentation preparation of Migration document from development environment to production system.
• User Training on ad-hoc reporting and Demonstrations for various universes at sites.

Confidential

BO Reporting Developer

Environment: BO 5.1.6, BOE XI R2, DB2, Microsoft Windows Server 2003

Responsibilities:

• Attended user meetings to clarify/analyze teh user requirements.
• Migrated teh reports, universe, universe connections, users, user groups, folders, events, calendars, server groups, servers using teh Import wizard from BO 5.1.6 to BO XI R2.
• Updated User groups and granting user rights to users.
• Migrating teh universes, reports, documents from DEV to QA to Prod using import wizard.
• Converted Desktop report to Web reports using report conversion tool.
• Designed, developed and managed universes.
• Used optimization strategies for improving teh performance.
• Created new classes & new objects in designing teh universes, Importing/Exporting teh universe from/to repository to make it accessible to end users.
• Created metrics and dashboards/ Performance management for high level management for teh analysis of teh business.
• Created teh Business Objects reports (webI, deskI) for analysis, and forecast.
• Scheduled reports on daily and weekly bases.
• Performed both unit and integration quality assurance testing prior to release.
• User Training on ad-hoc reporting and Demonstrations for various sites.
• Attending user calls and finds solutions to high-level issues (on-call support).

Confidential

Enterprise Series Database/PL Lead Developer

Environment: Linux 4.2 Update 4, DB2 9.1 Fix Pack 2, Apache HTTP Server, Jakarta Tomcat Connector Module, JBoss Application Server, Apache Ant, C, J2EE, and FaircomCtreePlus servers.

Responsibilities:

• Analysis of teh existing system functionalities.
• Analysis of teh new requirements dat is specific to teh Lotteries.
• Design, development and implementation of teh new functionalities for teh Washington Lotteries.
• Writing teh test cases and Unit testing.
• Making teh host code to interact wif Terminal and teh ESIPS GUIs.
• Releasing teh software to teh QA system and teh customer acceptance testing and providing teh technical support.