SUMMARY

• IT professional with over 8 years of experience in the Business Intelligence industry with concentration on Business Objects. I have extensively worked on various versions of Business Objects including 4.0/XI3.1/XIR2, Web Intelligence 4.0/XIR3/XIR2, Business Objects Designer XIR3/XIR2 and also the new Information Design Tool (IDT) in 4.0.
• Extensive Experience in Creating Web Intelligence/Full Client/Desktop Intelligence Reports in Business Objects 4.0/XIR3/XIR2
• Worked on Web Intelligence to develop and publish thin client reports.
• In - depth knowledge in creation of WEBI reports and Dashboards using Crystal and Xcelsius
• Expertise in retrieving data using Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• Accomplished several projects governed by full SDLC model, from Requirement gathering, Analysis, Planning, Designing, Development, Test and deployment to production
• Good analytical and documentation skills with ability to communicate at all levels
• Exposure in ETL tools namely Business Objects Data Services (BODS) and Informatica.
• Integrated data from various data sources like Oracle and SQL Server
• Knowledge in Data Modeling using Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling
• Utilized all business objects tools including CMC, Supervisor, Designer, BO Reporter, Web Intelligence, Broadcast Agent, BCA Publisher, Configuration tool, Performance Manager, Dashboard Manager, import wizard, Data Integrator in various projects
• Good Experience in maintaining and scheduling reports in production environment and supporting users in creating Web Intelligence reports and administering the BO activities
• Efficient in Optimizing, Debugging and testing SQL queries and stored procedures
• Excellent communication skills, strong decision making skills, organizational skills, and customer service oriented
• Excellent analytical and problem solving skills

TECHNICAL SKILLS

BI Tools: Business Objects 4.0/XI R3.1/R3.0/R2, Web Intelligence 4.0/XIR3/XIR2, Designer, Desktop Intelligence, Crystal Reports 2008, Xcelsius 2008/2010

Data Modeling: Star-Schema Modeling, Snowflake- Schema Modeling

Languages: HTML, XML, T-SQL PL/SQL, SQL*Plus, C++, C, Java

Reporting Tools: Crystal Reports 8/8.5/9/10, SQL Server Reporting Services (SSRS)

Data Modeling Tools: Erwin 4.0, Microsoft Visio

Database Technologies: MS Access, ORACLE 10g/9i/8i, MS SQL Server 2005

ETL Tools: Data Services, Informatica

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles CA

Sr. Business Intelligence Consultant

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements and data specifications for Business Objects Universes and Reports.
• Converted universes from unv to unx and then modified reports respectively.
• Created several Universes to meet the reporting and dashboard requirements
• Worked on Business Objects XIR3.1 environment
• Involved in joining the tables by creating aliases to resolve the loop
• Interacted 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
• Converted Deski Reports from XIR2 environment into Webi 4.0 then repointed the data sources to unx
• 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 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.
• Performed UAT testing on the converted universe and reports in 4.0 to assure data was accurate and the formatting was correct
• Designed and created reports based on technical specifications provided.
• Defined logical classes and objects and hierarchies for analysis and drilling on hierarchies in the WEBI reports.
• Developed universe user documentation guide for the end users reference
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Created Dashboards using static data from Excel as data source. Also retrieved dynamic data using multiple options such as query as a web service, XML and Live office.
• Using Live office imported Webi reports in Excel and Created Xcelsius visualization based on these reports.
• Created Queries, Cross Tab tables, Master Detail reports using formulae’s and variables.
• Applied slice-and-dice, drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks. Linked reports in Web Intelligence using Open doc function.
• Connected to Business Objects Repository as a Business View and created reports
• Scheduled reports through CMC and InfoView. Developed and deployed complex Webi reports

Confidential, Thousand Oaks, CA

Business Objects Consultant

Responsibilities:

• Migrated universes, reports and security domain from 6.5 to Business Object XIR3 Using Import Wizard
• Produced technical document and user manual for migration from one built to another built of Business Object
• Converted Deski (Desktop Intelligence) reports to Webi (Web Intelligence) reports using Report Conversion Tool
• Used Crystal Report XI Enterprise to design the front end reports
• Defined KPI’s Metrics (Key Performance Indicators) to analyze the user adoption to BI as a part of Data Governance Goal.
• Used QaaWs (Query as a Web Service) to feed data into Xcelsius.
• Created complex Xcelsius dash boards to reflect User Adoption Metrics.
• Used Web connector in Xcelsius to import data from QaaWs.
• Maintained business and process metadata collected for data related Work Flow Enhancement projects within Bank tools Business Objects, and or designated bank database.
• Configured the Webi, Deski Server. Configured Apache Tomcat, IIS 6.0, VM Ware.
• Created different CMS clusters and also different server groups to gain performance.
• Set up LDAP and NT authentication for Crystal and Business Objects users.
• Analyzed specs and database model to generate the reports for the sign-off specs
• Wrote procedures for the complex reports and list of values for the parameters
• Established user groups and users and assigned privileges.
• Wrote functions to reduce code in procedures like Address, Full Name, Active members
• Created Business Objects Web Intelligence & Desktop Intelligence reports and published on the INFOVIEW.
• Involved in migration and deployment of the universes and reports across multiple repositories.
• Published report to Enterprise server, to get the report access from INFOVIEW.
• Used Team Track to track the status of the report by developer, state and comments.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs and Grouping.
• Worked in Crystal Reports including creating reports from various formats including: Access, SQL, Oracle, XML, Txt files etc.
• Optimized Crystal Reports performance for large reports(reduced page generation time)
• Prepared user documentation for hands on training for end user community
• Created alerts, breaks, filters and ranks in the report

Confidential, New York, New York

Business Objects Developer

Responsibilities:

• Designed and implemented oracle based security in Business Objects
• Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL
• Created Custom Hierarchies for several groups
• Was involved in Star Schema customization / Design session
• Oversee daily activities of the project SDLC process and coordinate activities of team members, ensuring that module goals are met within predetermined time frames.
• Provide the first level support to approximately seven groups
• Design and develop the best practices
• Re-define the security in XI R2 and implemented the best security model in XI R2 using new security features
• Optimized the XI R2 system performance by fine tuning the XI R2 servers
• Implemented the minimal customizations of Info View in XI R2
• Co-ordinate with MSI team on Business Objects full client deployment
• Developed reports in Desktop Intelligence & Web Intelligence XIR2
• Participated in designing the Oracle to Business Objects XI R2 Security Bridge.
• Wrote a full functional specification document for the security to be implemented in Business Objects XI R2.
• Acquired an excellent understanding and work experience of EXCEL functions in Xcelsius
• Developed General Ledger and Accounts receivable universes using Designer 6.5.
• Developed reports in Web Intelligence. Created complex Universes and report for GL, AP and AR
• Customized Rapid Marts of PeopleSoft GL, AP and AR
• Designed and Developed Xcelsius dashboards / analytics and exported to several formats
• In Xcelsius used single value, selector, mapped, chart, background, collaboration and text components
• Migrated repositories from Development, System Test, Performance Test, UAT, Production, SLA and to Disaster Recovery using migration tool by creating BIAR files and moved it to the Destination System
• Performed ETL tasks using SSIS (SQL Server Integration Services)
• Help client to deploy Business Objects XI 2.0 on 7 different environments (Development, System Test, Performance Test, UAT, Production, SLA, Disaster Recovery)
• Created KPI visualization for the client dashboard using Live data (Query As a Web Service) which address the performance of the LOB at the Organization Level
• Used Data Integrator to Import data from various sources into data warehouse

Confidential, New York, New York

Business Objects Developer

Responsibilities:

• Business Object Universe, Business Objects Reports and Business Objects repository were used extensively.
• Created Universe level objects and measures using the business rules provided.
• Created complex views to overcome loops and contexts.
• Derived Tables, Aggregate awareness are used in universes. Involved in building the data repository.
• Involved in Administration of Business Objects. Maintained user security on the BO Universes.
• Deployed, Scheduled published the developed and tested reports on BOXI R2 Production Servers.
• Web I Reports are created and deployed through Info View and Customized Web I Front end.
• Complex Crystal XI Summary as well as Detail reports are created based on business request.
• Created Auditor reports and tracked user access of reports and Universes.
• Created Dashboards and Speedo meters for churning analysis-using Xcelsius.
• Customized the dashboards for better manageability of overall performance
• Maintained and Applied patches to Development, UAT and Production Servers to keep them in sync.
• Worked with Business Users to develop system requirements, analyze data Elements and continuous end-user support. Performed data validation and analyzed test results.
• Used BCA scheduler to run recursive reports Daily, Weekly, Monthly as requested by the end users and stores the output in their inboxes.
• Created different categories to simplify it to the users to locate the reports.

Confidential, Cincinnati, Ohio

Reports Developer

Responsibilities:

• Created several Deski reports and Crystal Reports
• Analyzed existing database and Designed Universe by using BO 6.5 Designer Module
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality
• Analyzed data using Slice/Dice and Drill Mode
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Combined Budget with actual data Spreadsheet from Oracle using Linking Feature
• Created and Published Reports through Web Intelligence, Info view portal
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Used Alert in various reports according to user requirement
• Updated and maintained Universes based on changing user requirements and data source changes
• Created templates to standardize the structure of corporate documents