Vikash Bala

PROFESSIONAL SUMMARY

Around * years of IT experience and Business Objects XI 4.0/3.1/R2/6.5 with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Designer, Reporter, Web Intelligence.

Experienced the features of Business Objects XI R2, Crystal reports XI R2/2008, Crystal Xcelsius 2008/4.5.

Experience in building Universes, retrieving data using Universes, Personal data files (MS Access, Excel) and creating complex ad-hoc Reports using the Business Objects Web Intelligence (WebI) modules.

Experience in Installation, Administration, Design Universe, Reporting (Desktop Intelligence & Web Intelligence) and Migration of Business Objects XI R3/R2 /6.5.

Experience in migration of Business Objects from BO XI 3.1 to 4.0.

Extensive knowledge in Business Objects Full client & thin client environment.

Worked on Web Intelligence (WebI) to develop and publish thin client reports.

Experienced in setting up of Repository, creating, managing users and user groups

Experience in migration from previous versions of Business Objects to its higher version

Expertise in designing Universe(s) from scratch, migrating to different environments, designing WebI documents and maintaining them on Business Objects XI.

Extensively worked in designing, implementing, distributing and maintaining Universes.

Experience in creating Crystal Reports using Crystal Reports XI/2008 with expertise in developing various standard, graphical, formula based, well-formatted, drill-down, drill through, Summary and Parameters based reports and profound experience in developing complex reports using Sub-Reports (Linked and Unlinked), Cross-Tab, Stored procedures and Views.

Expertise in developing dashboards using Xcelsius from Live Office. Used Query as a Web Service.

Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free-hand SQL, and Web connect.

Experienced in setting up of Repository, creating, managing users and user groups.

Good in development of Data warehouse/Data Marts, Data Modeling, designing the STAR and SNOWFLAKE schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling.

Have experience working with databases like Oracle, DB2, Teradata, SQL Server and MS-Access.

Expertise in Linux, UNIX and Windows environment. Good basic knowledge of Unix Shell Scripting

Experienced in web publishing and scheduling documents using Broadcast Agent or Publishing wizard.

Strong background in Data warehouse concepts - ETL, Data modeling, and Reporting

Proficient in working with error handling and performance tuning to enhance database performance.

Extensively worked with end-user requirements, business data requirements, analysis and study.

Unique ability to understand long-term project development issues at all levels

Strong Business Intelligence implementation knowledge of strategic planning, development and production in various core sectors

Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.

Capable of working in a team or individually, self-motivated with good problem solving skills.

TECHINAL SKILLS

Reporting Tools : Business Objects XIR1/R2/3.1/4.0,6.5/6.0/5.x,Crystal Reports 2008/XI/10/9, Crystal Xcelsius 2008/4.5, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Designer, Desktop Intelligence, Web intelligence, Crystal Xcelsius 2008

Application Servers : Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6

Business : MS Visio and MS Front Page

Microsoft Tools : Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook)

UML Diagram Tools : Microsoft Visio

Database : SQL Server 2000/2003/2005, Oracle9i/10g, DB2, Teradata V2R5/V2R4, Toad, MS Access 2000/XP/2007

Languages : SQL, PL / SQL

Web Technologies : HTML, DHTML

Operating Systems : Win XP SP2/SP3, Win 2000, Win NT 4.0 and UNIX

EDUCATION

Bachelors of Technology in Electrical Engineering

PROFESSIONAL EXPERIENCE

Capital One, Chicago, IL Feb 2015 - Till Date

BO Developer

Responsibilities

Worked in Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing, Testing and Deploying the Universe, Database Developments, Reports and Dashboards.

Strong Experience in Technical and Business Requirements Documentation.

Designed and Maintained Universes for Standard / Ad-hoc Reporting Requirements.

Developed Universe’s and Reports with more emphasis on Enterprise User Distribution and Best Practices both on Database and BOBJ Platform in order to minimize the Performance issues

Worked extensively on Optimizing Report / Query Performance using BOBJ based Improvements (Index Awareness, Aggregate Awareness) and Database based Optimization (Index, Partition, Statistics, Hints)

Analyzed the requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.

Developed SAP Universe, Created Classes with Dimension, Detail & Measure Objects and specified the hierarchies.

Developed web intelligence reports for the SAP exported universe related to pay-down curves of home loans mortgage.

Created the reports by using BO functionalities like filters, sections & breaks, combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and formula.

Written Complex SQL queries and PL/SQL procedures and cursors to retrieve the required information.

Maintained Universe, Reports in Web Intelligence and Crystal reports.

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.

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 Web Intelligence 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.

Followed Best Practices for Database and Business Objects Platform in order to minimize the Performance issues at later stage

Automated Production reports by scheduling them on a daily/weekly as required by the Business.

Worked extensively in Optimizing Report/ SQL Query Optimization (Explain plans, Collect statistics, Primary and Secondary indexes).

Responsible for resolution of reporting issues and created new reports as per the Business Requirement.

Designed Universe Technical Design, Report Design and necessary Documentation.

Worked on SAP Business Objects 4.0 Migration Plan.

Worked with the ETL Team to create new database objects that needs to be added to the Databases and monitor data refresh on a daily basis.

Worked across teams to fix the outstanding Data Quality Issues and remediate the reports to meet timelines.

Used Live Office for daily report management and presentation purposes.

Involved in developing and performing UAT of the Presentation Layer for Building reports from 3NF data models in Teradata.

Environment: SAP Business Objects XI 3.1 / 4.0, Crystal Reports 2008, Crystal XCelsius 2008, Oracle 10g, Teradata V12/13., MS-Excel, Live Office, Windows XP.

Anthem WellPoint, Richmond, VA Oct 2013 - Feb 2015

Business Objects Developer

Responsibilities

Involved in Analyzing the End users functional and technical requirements and respective impacts on reports.

Used Business Objects XIR3 extensively and Involved in Full SDLC (software development life cycle) rules are followed for designing new components.

Designed, created and maintained Universes for Business Objects and Web Intelligence users using Business Objects Designer Module.

Performed integrity testing of the Universes (Universe Structure checking, Object parsing, Joins parsing, Conditions parsing, Cardinalities checking, Loops checking and Contexts checking) after any modifications to them in terms of structure, classes, and objects.

Created classes and objects by retrieving the data from various data sources and defining the necessary connections

Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.

Responsible for creating & managing the Business Objects repository and coordinating/performing universe development.

Created predefined conditions, prompts and custom hierarchies in the process of building the universes

Created Contexts and Aliases for resolving Loops and join problems in the Universes.

Deployed universes in the repository by exporting and importing universes between universe domains, and over different repositories.

Created both full client(DeskI) reports and Web I reports using Info view and WebI Rich Client with many features of drill down and alerters and filters.

Generated various reports on a daily, weekly and monthly basis using Business Objects Report module.

Created reports using Business Objects functionality such as Slice and Dice, Drill Down, Master/detail, Crosstab, Prompts and Formulas, Breaks, Sorters and Alerters etc.

Created Universes using @functions like @select, @where, @aggregate awareness and @prompt in the process of building the universes.

Created derived tables and aggregated tables at the Universe level to reduce the complexity of universe building and increase the performance.

Created and deployed WEBI Reports through Info View

Created various report specific formulae based on calculation contexts of the report.

Involved in writing free hand SQL, as data provider for retrieving data when universe doesn’t provide required data.

Worked with Business Objects Professional services to build a online training material using the SAP Knowledge Accelerator tool for reporting

Rich ETL and OLAP experience using Oracle 10 g, SQL Loader, Reveleus and Business Objects

Involved in Scheduling reports based on Specific time, events and calendars and in various formats such as Excel and PDF in web Infoview portal.

Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Involved with the group which provided support and ideas for migration from BO XI 3.1 to BO 4.0

Responsible for Analysis, Design, Migration and Implementation of Business objects suite XI 3.1 on Development environment

Used Central Management Console (CMC) in creating users and groups and assigning privileges to different groups and users.

Applied row level and object level securities to different groups and users in the designer wizard.

Created all types of reports using different functionality like Cascading Prompts, Cascading LOVs, Formulae and Grouping.

Involved with a team in creating Dashboards using various visual analytics, themes to meet corporate standards using XCelsius.

Involved in the development of the Unified Database, which is a data warehouse application, which stored and reported on repair data for over two thousand dealerships, using Teradata as its data repository

Designed analytics sales Vs Inventory using the Crystal XCelsius analytics for the high end users

Created Xcelsius dashboards using Query As A Web Service (QAAWS) and Live Office

Created multiple Crystal and Web Intelligence reports and transformed into a single dashboard using Xcelsius

Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications in a EDW warehouse.

Coordinated with BO Admin in managing the Central Management Server to add/delete, enable/disable BO Servers.

Coordinated with DBA and ETL in solving various technical issues and also to stream-line universe design and optimize query performance

Worked on Informatica Power Center Source Analyzer, Data warehousing Designer, Mapping & Mapplet Designer and Transformation Designer.

Conducted presentations training sessions and created training documents for the Business users on the use of Business Objects reporting tool and overview of the Universe.

Environment: Business Objects XI 4.0/R3/R2, Tomcat 5.5.20/5.0.27, Designer XI R3/R2, Desktop Intelligence, Crystal Reports 2008, Xcelsius 4.5/2008, Teradata, SQL, PL/SQL, UNIX

Fannie Mae, Herndon VA Jan 2013 – Oct 2013

Business Objects Developer

Responsibilities

Performed an initial study of the current reporting application, to finalize the data elements required for reporting.

Installed and configured BO Software on client machines and created User groups and users of PROD, DEV, TEST environments.

Created Repository for BO development, created Universes and Complex Reports.

Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.

Involved in analysis of Architect changes and new features on XI 3.1 like Access level, Security Queries etc

Created Complex Crystal Xcelsius Reports from the output of Business Objects report data.

Created Xcelsius dashboards for the ORM (Owner Relation Management) application

Used QaaWS to provide dynamic functionality.

Used Sliders, Pie charts, column charts, Gauges, Dials, maps and other features in Xcelsius

Extensively used Alerts while creating the Dashboards (Xcelsius).

Added users, user groups and managed the access privileges of the user community using the CMC module

Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.

Maintained universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.

Developed Xcelsius dashboards, based on WebI reports

Tuning of SQL queries for better performance.

Working on creating Universes, Business Intelligence Layer for end users to develop the Adhoc/Canned reports.

Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes

Involved in creating the Aggregate tables at different levels.

Created user objects including Dimensions, Details, Measures, Filters and Prompts, LOV

Converted the universes from BO 3.1 to BO 4.0 and published them

Multilevel hierarchies are set up enabling the drill down functionality.

Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.

Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WebI.

Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.

Created Report Level Variables, Objects and Formula to create new columns based on the result set.

Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required.

Resolved loops by creating aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting.

Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies

As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.

Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.

Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence

Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.

Worked on Import and Export of the Universes, with the changes in Database Objects by using Import wizard and Designer module.

Ensured appropriate BO integration requirements for access of information on Teradata using Teradata recommended views. Worked with Teradata SQL assistant to run SQL queries to cross reference results obtained from the BO Universe. Sound understanding of Teradata concepts, constraints and rules that affect performance from a BO perspective

Generated ad hoc and canned reports for Business objects.

Developed Crystal reports, which include the following features – parameter fields, formulas, conditional formatting, multiple grouping and running totals

Developed Crystal reports using various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts.

Generated various report templates for standardizing the reports throughout the organization.

Troubleshoots system errors and bugs and rectifies them.

Involved in Training the Users in using this robust system.

Environment : Business Objects XI R3/R2, Designer XI R3/R2, Desktop Intelligence, Web Logic 6.0, Crystal Reports 2008, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQL, UNIX.

Charles Schwab, AZ Nov 2011 – Dec 2012

Business Objects Developer

Responsibilities

Responsible for system study & Business Requirements Analysis & Documentation (Technical).

Created business documents and technical documents before developing the reports.

Applied command restrictions to various existing groups and users restricting different functionalities in Business Objects suite.

Created user profiles in CMC module with varying security profiles for each user.

Implemented Row Level Securities and Object level security universe to incorporate security for sensitive information.

Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.

Documented the Tables required from the Underlying database to build the universes

Involved in the designing and building of Universes from different data sources like Oracle/SQL Server

Created local objects in the Universes with complex SQL functions to manipulate the data based on the report requirements

Created Derived Tables to reduce the complexity of the Metadata Universes. Defined @Aggregate Awareness, @Prompt, @Select, @Where functions in universe level.

Created Cascading Prompts in the universe to filter the list of Account names based on the Business Units.

Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex Formulas in the report variables.

Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required

Created Report Level Variables, Objects and Formula to create new columns based on the result set.

Resolved Migration issues both in Designer, Reporter and created test cases to check the Migrated Reports

Created Universes specific to dashboard development with various measures defined.

Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WebI.

Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.

Defined User Response function in Report Level to display the data selected by the users in the Report Headers

Enabled/Disabled different servers in Central Configuration Manager and Central Management Console

Involved in the creating the reports using the Web XI R2. Created the Reports (Master/Detail, Brake, Cross Tab, Chart, Templates) in Business Objects using the Universe as the main Data Provides and writing the Complex queries including Sub-Queries.

Modified the Parameter file in Universe Parameters to enhance the reporting on Teradata.

Enhanced the Reports with the functionalities like Ranking and synchronizing the data using the merge dimensions option

Actively working with Database design team to add new business rules and logic for the universe design.

Created and customized application dashboards using Performance Manager to meet the requirements Upper Level Management.

Worked with performance tuning tools to improve the performance.

Developed dashboards and scoreboards for detailed analysis.

Scheduled reports through Web I Scheduler for distribution and printing.

Created complex Crystal reports against Teradata.

Created Crystal Reports using both universes and business views based on business requirements

Environment: Business Objects XI R2/R3 (CMC, Designer, Desk I, Web I), Crystal Reports XI, Teradata, SQL Server 2005, Oracle 10g/9i, Tomcat, Apache server, PL/SQL, Window XP.

Wipro, India Mar 2008 - Sep 2011

Business Objects Developer

Responsibilities

Interacted with functional / end users to gather requirements of core reporting system to understand exceptional feature users expecting with reporting system and to implement business logic.

Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports

Worked on Business Objects DeskI and WebI Reports of BO XI Environment.

Worked on User Management, Server Management and Content Management.

Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, Pdf and Instances to Production, Development and Test Environments using Import Wizard from BO 6.5 to BO XI.

Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.

Added users, user groups and managed the access privileges of the user community using the CMC module of Business Objects.

Created complex variables, breaks, sorts, filter and conditions for various reports.

Linked multiple universes and reports using stored procedures, visual basic procedures, flat files and excel files.

Responsible in publishing and scheduling business intelligence documents to large number of end users.

Involved in migrating and deploying -- universes and reports across multiple domains.

Solved many Universe problems. (Loops, Fan and Chasm Traps)

Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.

Creating, maintaining and modifying the universes using Business Objects designer

Creating reports using Crystal Reports XI when needed.

Aided in the multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.

Created jobs to Extract, Transform and Load data into data warehouse using Datastage7.0

Responsible in maintaining Development, Test and Production repositories and providing round the clock support during the production stage.

Involved in scheduling the documents for monthly, weekly and daily.

Environment: Business Objects XI, Infoview, PL/SQL, Oracle 10g/9i, ERWIN 4.0, Crystal reports XI, Data Stage 7.0, UNIX.

Contact this candidate