Sr Business Objects Consultant

Amar Veeramalla

Phone: 408-***-**** E-mail: **********.****@*****.***

BUSINESS OBJECTS ARCHITECT/ LEAD/ANALYST/DEVLOPER

Proven Technical & Management Expertise in a Career Spanning 9+ Years

Professional Summary

o 9+ years progressive experience in Information Technology Industry, with 7+ years of experience as Business Objects Developer and Analyst

o Extensive experience in Study, Analysis, Design, Development, Implementation, Deployment and maintenance of Data warehousing, Data modeling, and Business Intelligence applications

o Good Experience in Installing, configuring Business Objects Enterprise XI R2/3.0, Troubleshoot XI Installation issues, Performance tuning/ optimization of XI, Multiple server configuration, clustering and fall over, XI security using reverse proxy and firewall configuration, and in Migrating BO 5.x/6.x to BO XI.

o Expertise in Business Objects, Crystal Reports (Broadcast Agent, Designer, Supervisor, Info View, Application Foundation, Web Intelligence Reporter).

o Expertise in designing, implementing, distributing and maintaining Universes.

o Expertise in implementing complex Data warehouse applications

o Experience in Linking / Including Universes and working with multiple universe development at the same time.

o Expertise in implementing row level security when needed according to the corporate standards.

o Expertise in developing Business Objects Dashboards, Xcelsius .

o Expertise in tuning and tweaking the query performances.

o Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.

o Expertise using data structures such as highly normalized data models, Star Schemas and Snowflake Schemas.

o Very good knowledge of Data Integrator, Informatica (Power Center 6.x and 7), Data stage and Ab Inito .

o Expertise in Installation and configuration of CallCon, Genesys Infomart (GIM)

o Very good understanding of the Data Warehouse Concepts , Database design/architecture experience, including both OLAP and OLTP data models

o Experience with Oracle 7/8i/9i,10g, MSQL, DB2 Databases

o Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals.

o Involved in End user training sessions. Prepared documentation for all the process involved clearly depicting the report to be generated as required by the client for future reference.

Skills

OLAP and Reporting Business Objects 5.x/6.5/XI (Supervisor, Designer, Business Object, Webi, Business Miner, Broadcast Agent Publisher, Application Foundation, Business Query), Crystal Reports, Essbase.

ETL Tools Data Integrator Informatica (PowerMart/PowerCenter 6.x and 7),

Ascential Data Stage, Ab Initio

Other Tools & Utilities Toad, SQL Station, Erwin 3.5

RDBMS Oracle 9iAs/9i/8.x/7.x, MS SQL Server 2000/7.0/6.5,

MS Access and Cobol.

Programming Languages C, SQL, PL/SQL, HTML, C++, JAVA

Web Servers Tomcat, Apache, Web sphere

Operating Systems Windows XP/ME/NT/2000/98, UNIX (Sun Solaris, Linux)

EDUCATION

• Master of Science in Computer Science Engineering, Ireland

• Bachelor of Engineering in Computer Science Engineering, India

Professional Experience

Union Bank Of California, San Francisco, CA June ‘07 – Sep ‘07 and May ‘08 to till to date

Business Objects Architect / Lead

The project included converting the existing Legacy system to an Operational and Analytical Data warehouse and a thorough analysis of the existing architecture of a highly secure deployment of 5x and migrating to XI. I worked with Business users in gathering requirements for new Business Objects reports and developed reports using the universe. Working in Credit Portfolios and Information services (CPIS) researching, analysis and defining the requirements for daily/monthly/quarterly/yearly reports and developing these ad hoc reports for board/executive meetings. The reports include Risk Grade concentration , Risk Grade Migration, Risk Grade Inflow outflow, criticized credits, Non performing assets, Shared national credits, Heat Map etc. These reports were created to view from different dimensions like CIF, SIC code(PRM Major and sub market segments), Credit product groups, Org Lvls. Designed and developed reports using Desktop Intelligence, Web Intelligence, Dashboard Manager and Xcelsius.

Responsibilities:

• Developed the architectural design of the Business objects Installation and Deployment.

• Configured the XI R2.

• Developed security, failover, cluster CMS.

• Firewall setup and Reverse proxy configuration.

• AD with single sign on configuration.

• Gathered report requirements like what business questions the report will answer, establish presentation method (should the report contain tables, graphs, or both?). Establish the delivery method

• Perform a gap analysis

• Prepare the Business Requirements Document (BRD).

• Designed and developed over 300 standard reports, 100 ad hoc reports for SOx Team, Auditors, and Credit line managers. Helped the Client in understanding the data in the data warehouse.

• Ran SQL queries to validate data against the Business Objects reports.

• Created the Migration plan and Migrated 5x to XI R2.

• Tested the Migration of reports/universe/security from BO 6.5 to X1 R2.

• Gathered xcelsius dashboard requirements.

• Understood the business logic and refresh time frames.

• Created Crystal Xcelsius objects within J2EE application.

• Developed advanced Xcelsius objects on concepts like What If Analysis, Dynamic Visibility, narratives, interactive charts, hierarchies.

• Passing parameters to the web services.

• Created interactive and connected models in xcelsius.

• Created shared xcelsius objects in the BO repository.

• Perform user acceptance testing (UAT) / validation to ensure a smooth launch of the report. Create validation scripts, establish the validation process to ensure if the data on the report correct, if the report formatted according to requirements?

• Worked on fixes.

• Make sure the reports are Sox compliance.

• Streamlined and documented the business rules.

• Documented and trained the Business users with the user adaption techniques in using the universe and the reports.

Environment: Business Objects Xi R2, Data Integrator, Web Intelligence, Desktop Intelligence, Windows 2000 Server, Oracle 10g , SQL, Tomcat

Business Object Americas, NY Oct’ 08 to Apr ‘08

Sr Business Objects Lead Consultant

As a well trained business objects consultant the project aims at developing HR Data warehouse reporting solution for Lehman Brothers, using Voyager, WebI, and Dashboard. I was involved in the plan, design, build and test of the ETL/Universe/Reports. I have designed and documented the processes, Test plan, and Test cases for the application.

Responsibilities:

• Gathered Requirements from users, created report from Business requirements document, translated them to create reports to the users. Requirement gathering process realized the business information set to the database schemas, tables and fields.

• Designed the business flow and designed ETL process flow.

• Created mappings as per business logic and created audit mapping to track the audit information.

• Set up ETL Best Practices and frameworks as developed by ETL center of excellence and automated ETL batch jobs for nightly run.

• Performance Tuning of ETL extract programs and reduced execution time of expensive jobs significantly.

• Developed BODI Restart-Recovery and Control wrappers.

• Designed and presented the report layout and business logic with the key stake holders and get agreement on the business logic at the report level.

• Suggesting the positioning and structuring of the reports

• Designed, developed and modified several BO Universes and Reports. Build Reports in WebI, Dashboard.

• Used Check integrity option in Designer to check universe structure, parse joins, Objects, Conditions and find (resolve) loops before a universe is exported to repository.

• Created users, user groups for User Acceptance Testing and set up the test environment for the Testers.

• Created standard reports that run at scheduled intervals and sent out to business users inbox.

• Created rich client reports.

• Prompts were used in the reports as well as in the Universe to create more interactive reports for Business users to see live data.

• Maintained Universes with new additions to classes, objects to reflect new change requests from time to time

• Validate the reports/ report structure

• Created Indexes and materialized views to improve query performances.

• Created Web Intelligence report embedding Xcelsius swf files.

• Created xcelsius swf files using QaaWS with live office, XML Maps, XML Data buttons.

• Created visual cues, interaction patterns, and application navigation conventions in Flex.

• Passed parameters to the web services.

• Involved in end user validations with current system reports to the existing systems reports and identifying the differences and educating the differences to the end users and changing as per business decisions.

• Help the client in UAT testing and made change requests as per review decisions.

• Assisted in end user training and documenting the procedures.

Environment: Business Objects 3.0, Xcelsius 4.0 Data Integrator, Windows 2000 Server, Oracle 10g, SQL, Essbase, Flex.

Apple Inc, CA

Business Objects lead/Architect June'06 – May ‘07

Apple Inc one of the world's best computers manufacturing company, a pioneer in music industry that sells ipods, shuffles, itunes and macs. To enable its customers a high quality customer support and state of art Genesys Call Center Management Application is build. This project aims at building call center reporting system for efficient Management of the Call center for optimum utilization of call centre resources and best customer satisfaction. Apple care, Telesales and Order management business users like Supervisors, Managers, and Regional Managers from different geographical units all over the world uses this application.

Responsibilities:

• Gathered Requirements from users, created report from Business requirements document, translated them to create reports to the users. Requirement gathering process realized the business information set to the database schemas, tables and fields.

• Report classes and objects were identified and created in the universe. Filters, sorts, ranks, prompts etc were applied according to the end user requirements. Reports were tested for connectivity and data imports and sent for UAT.

• Created HCCR universe for the 3 business units in the designer. Created row level security such that agent level security and site level security is maintained as per requirements.

• Used Check integrity option in Designer to check universe structure, parse joins, Objects, Conditions and find (resolve) loops before a universe is exported to repository.

• Created users, user groups for User Acceptance Testing and set up the test environment for the Testers.

• Created standard reports that run at scheduled intervals and sent out to business users inbox.

• Created Full client/ Deski reports.

• Prompts were used in the reports as well as in the Universe to create more interactive reports for Business users to see live data.

• Maintained Universes with new additions to classes, objects to reflect new change requests from time to time

• Validate the reports/ report structure developed by the offshore team.

• Created Indexes and materialized views to improve query performances.

• Involved in end user validations with current system reports to the existing systems reports and identifying the differences and educating the differences to the end users and changing as per business decisions.

• Installation and configuration of GIM (Genesys Infomart Application). Installed and configured the Data Integrator as ETL tool. Monitor ETL jobs.

• Develop and Maintain ETL processes / jobs using Business Objects Data Integrator

• Perform basic administrative duties within Business Objects, monitor jobs loads/schedule jobs of deployed data warehouses.

• Assisted in end user training and documenting the procedures.

Environment: Business Objects Xi R2, Data Integrator, Web Intelligence, Windows 2000 Server, SQL, Oracle 10g, Teradata, Safari.

NYKline, NJ May '05 - May '06

Business Objects Developer/Analyst

NYK Line (established in 1885) is the world's leading shipping company that offers customer's high level of integrated transport services. NYK offer services like container Transport, car transport, Bulk / Energy transport to customers all over the world. NYK line has over 650 ships (vessels) working all over the world. The aim of the project is to develop Business objects reports to help control office, Customer and vendor in their day to day activities.

Responsibilities:

• Gathered Requirements from users, created report requirements document, translated them to create reports to the users. Requirement gathering process realized the business information set to the database schemas, tables and fields.

• Report classes and objects were identified and created in the universe. Filters, sorts, ranks, prompts etc were applied according to the end user requirements. Reports were tested for connectivity and data imports and sent for UAT.

• Created a Consolidated Universe where five independent Universes (controlling, shipment, credit rating, Human resource and marketing) each representing an independent application under the engineering domain were incorporated into one using Designer.

• Used Check integrity option in Designer to check universe structure, parse joins, Objects, Conditions and find (resolve) loops before a universe is exported to repository.

• Implemented row level security at supervisor level according to corporate requirements and specifications.

• Created users, user groups for User Acceptance Testing and set up the test environment for the users using Supervisor.

• Prompts were used in the reports as well as in the Universe to create more interactive reports for Business users to see live data.

• Broadcast agent was used to schedule daily reports, event triggered reports and send to specific user groups.

• Maintained Universes with new additions to classes, objects to reflect new change requests from time to time

• Migrated from Business Objects 6.5 to Business Objects XI R2

• Assisted in end user training and documenting the procedures.

Environment: Business Objects 6.5/Xi, Web Intelligence 6.5/Xi, Windows 2000 Server, Full Client, Oracle 9i, SQL .

Nexstar Financial Corporation, MO Sept '04 - Mar '05

Business Objects Developer

Nexstar Financial Corporation is one of the leading home financing companies in the Midwest. Total account administration support, transactional execution and comprehensive tracking and reporting capabilities has made the decision to incorporate the Business Objects reporting tool as part of their product offering. In the new business process a set of core reports were identified and run through the Business Objects Web reporting tool. Nexstar offers more then 200 reports addressing financial and management reporting requirements. Based on internal review of the existing reports, there was a decision to streamline the reports to increase overall report usability.

Responsibilities:

• Successfully Installed Business Objects products (Client and Server) on windows Platform.

• Created the repository according to the corporate standards and designed the Universes with incorporating all the existing requirements.

• User profiles are created in Supervisor module and security profiles are set up at the group level depending on the line of Business user belongs to.

• Object level security was implemented in Universe to incorporate security for sensitive information.

• Solved loops using Aliases and contexts.

• Multiple contexts were created for catering different functional areas in a single user query.

• Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts.

• Created materialized views in the database for retrieval of data in reports.

• Identified all possible critical fields in the queries and created indexes on those fields for better data retrieval performance.

• Aggregate tables were created for calculating year-end PNL statistics by which grouping of data was done at the back end and hence report response times are much faster.

• Created derived tables to incorporate SQL from the existing MS Access queries.

• Divided reports into batch and non-batch. Batch reports run overnight. Non-batch reports also called as live reports run by user through infoview and show the live data as it was entered into system.

• Broad Cast Agent BCA was used for report scheduling and deployment

• DB2 data base was being used in the development environment and testing the transition to production

• Report templates were created to have uniformity of reports throughout the organization.

Environment: Business Objects Enterprise 6.5, Web Intelligence 6.5, DB2 and UNIX.

Bristol Myers Squibb, NY Apr '03 to Aug '04

Business Objects Developer

Business Data Warehousing (BDW)

GMA-IMPACT enables the Global Medical Affairs team of BMS to use IMPACT, the standard pharmaceutical industry software used globally, for capturing post-marketing clinical trial information for management of all planned activities.

Created the GMA reporting system using Business Objects suite of products, created GMA universe and reports that tracked trial information - total number of patients planned and % patients entered study, variance for total study country budget vs. total projected spent for parameters like Country, Therapeutic Area, Product, PMT Type, Protocol No, for all post-marketing trials (PMTs).

Responsibilities:

• Documented detail design documents for universes and reports.

• Created Universe for ad-hoc and canned reports based on the relational data model and exported to repository.

• Created functions for use as conditions in creating pre-defined condition objects.

• As a part of the team designed and developed a universe based on the star schema, identified surrogate keys in the data warehouse and created joins based on these surrogate keys.

• Created predefined conditions and list of values (LOVs) enabling users to select one, many or all values of an object in response to a prompt.

• Setup custom hierarchies enabling drill down.

• Created reports allowing data from free-hand SQL report to be combined with data from a universe, with list of values coming from the universe in order to allow one, many or all selection of values for an object.

• WebI Reports were created and deployed through Info View.

• Tested the system test scripts encapsulating GMA Role security matrix within impact.

• Created test scripts and performed unit and system testing for reports and universes.

Environment: Business Objects 6.1, Oracle 9i/10G, WEBI 2.7

Nextel Communications, VA Oct '02 to Mar '03

Business Objects Developer/Analyst

Enterprise Data Warehouse (Phase I & II)

Business Objects universe was built for consolidating multiple universes from across multiple applications and form one schematic layer where users from multiple applications could perform powerful ad-hoc reporting and or use canned reports for common information and gives them the ability to perform in-depth analysis across common multiple applications of engineering systems.

Responsibilities:

• Data Analysis was done by identifying the underlying database schemas, the data warehouse star schemas, data mappings and transformations. Analysis involved logical model design using dimensional modeling to generate physical data model.

• Created complex universes with Designer to give ad-hoc-reporting capability to the users. Also published the reports to Web Intelligence for high availability.

• Created and maintained reports like for different portfolios and modified based on the CR (Change Requests).

• Set up Broadcast Agent report schedules to run the reports on periodic basis.

• Always made the deliverables on time, in proper quality and to the user satisfaction.

• Developed Reports, which will allow monitoring the business metrics of the Organization.

• Performed gap analysis between the current state and future data warehouse environment and identified the data gaps and quality issues plus recommends potential solutions. Worked closely with the data warehouse development team to ensure user requirements and issues are being addressed while controlling scope.

• Worked closely with users and IT groups for overall coordination of user acceptance testing and training.

Environment: Oracle, Business Objects 5.1 , WebI, BCA, Windows 2000 Adv Server, MS Access, SQL, Visual Basic, VBA , Microsoft Project, Erwin 3.5.2

Perkins Manufacturing Company, Chicago. Feb '02- Sept '02

Business Objects Developer Consultant

Perkins is specialty item manufacturer and distributor with a large product catalog. In Order to support the Business executive in decision-making and identifying key factors effecting sales, productions, and marketing and etc business objects was implemented The Reports generated are total sales revenue - by week, month, quarter and year - based on the region, sales channel and the Product.

Responsibilities:

• Interacted with the end users and business analysis to identify and develop business requirements and transform it into technical requirements and ultimately will be responsible for delivering the solution.

• Created data warehousing to achieve optimum user requirements and created structure of different universes.

• Developed user defined objects in the universe to customize the objects of it.

• Used drill-down and slice and dice analysis in Business Objects, which will allow the user to view data at a more detail level and from different angle.

• Generated BO reports for comparison of Revenues and Profits using Business objects as end user Query tool.

• Developed variables on existing results of query to customize the reports.

• Developed the Revenue, Expense and Profitability reports with multiple data provider in Business Objects.

• Combined query's in Business objects to generate documents for different combination of Objects. Created and edited LOV (List of Values) for objects.

• Generated different kinds of charts in Business Objects.

• Developed the multidimensional reports in Business Objects by translating the business validations.

• Designed and linked the universe for query reporting and analysis using designer module. Import and Export business object's reports and universe to repository.

• Performed unit testing of the designed universe

Environment : Oracle, Business Objects 5.1 , WebI, BCA, Windows 2000 Adv Server, MS Access, SQL, Visual Basic, VBA , Microsoft Project, Erwin 3.5.2

Retronix, Ireland July '01 - Jan '02

Oracle Developer

Information Management System

Accessing purchase orders planning, tender scheduling, quotation entry, ' quotation comparison and purchase order generation.

Responsibilities:

• Extensively involved in requirements gathering and data gathering to support developers in handling the design specification

• Involved in designing and coding of functional specifications for the development of user interfaces

• Involved in designing of Entity Relationship Diagrams

• Created tables, indexes, sequences, constraints and snapshots

• Developed packages , procedures, functions and PL/SQL blocks for data validation

• Developed PL/SQL scripts to validate and load data into interface tables

• Helped in writing proposals, documentation and training

• Designed and developed a Generic Billing system for the company

Environment: Java1.2, Servlets, JSP, JDBC, Applet, Oracle 8, MS Excel, Windows NT

Micro Edge Technologies, Ireland Mar '00 to June '01

Sr. Java Programmer

Business Management and Information System

This was an ecommerce website. The various users of the application were distributors, dealers, and organization employees that include Managing director, divisional managers, area managers, and sales representatives. This application was also used as intranet system which includes email system for effective communication within the organization.

Responsibilities

• Analysis, design build & implementation (full life cycle)

• Application design/implementation of requirements through build team

• Implementation and data conversion management / planning

• Business and Technical Issue and Risk Analysis and Management

• Performance management - identification and agreement of performance targets, analysis and tuning.

• Software evaluation, selection and acquisition.

• Overall technical quality assurance

Environment: Java1.2, Servlets, JSP, JDBC, Applet, Oracle 8, MS Excel, Windows NT

Contact this candidate