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