AddThis Social Bookmark Button
preethi preethi ( Available )
Edison, NJ - 08817 USA
Expertise :business objects, crystal reports, Crystal XCelsius
Status :Have Work Visa
Job Type :
All -
Position :

Resume
 
Summary




Over 7+ Years of IT experience, in Business Intelligence and Data ware housing technologies.
5+ Years of Solid experience in Creating Complex Applications using Business Objects Designer, Desktop Intelligence, Supervisor or Administrator, Web Intelligence, Broadcast Agent, Info View, Report conversion tool, Migration Wizard, Crystal Enterprise XIr2/10/8.5, XCelsius, Live Office, QaaWS in Intranet and Extranet applications.
Worked with Business Users to analyze the business process and made necessary changes to schema objects to cater their reporting needs.
experience in building queries on different types of data providers like Universes, Personal data files, Stored Procedures, Free-hand SQL.
Hands on experience in business analysis, process modeling, data analysis, entity/data modeling, logical and physical database design and documentation of business requirements, functional and design specifications.
Involved in complete life cycle of application development, system study, interaction with users and management, performance of analysis, designing, coding and testing and implementation of the system.
Hands on experience of Migration from 1 version to another.
Proficient in all phases of the Software Development Lifecycle, Requirements gathering, Analysis, Design, System Implementation, Performance Tuning, Testing and Support
Job roles include gathering business requirements, establishing functional specifications, translating them to design specifications.
Strong understanding of Data Warehouse concepts, OLAP, Star Schema, Data Modeling using Normalization, Business Process Analysis, Dimensional Data Modeling, Fact and Dimensions tables, Physical and Logical Data Modeling.
Profound Knowledge of SDLC and Software Testing Life Cycle.
Experienced in Validation and Integration of data from disparate sources
Possess wide range of IT industry experience with Banking or Finance, Retail Store, Inventory Control and Distribution Systems
Strong analytical, problem-solving, organizational, communication, learning and team skills.
Proven ability to complete multiple assignments simultaneously and maintain high performance standards at client organizations and experienced with coordinating cross-functional teams.


Employment

July, 2000 -  2005

Oracle 7.x, 8i 9i 10g Sql Server Access Database Technologies SQL PL/SQL ErWin3.5/4.0 SQL Loader SQL Navigator TOAD


January, 2008 -  Present

UBS Wealth Management , NJ


February, 2007 -  December, 2007

EHRO Block Philadelphia


June, 2006 -  January, 2007

Neo Pharma Pharmaceuticals , CA


September, 2005 -  May, 2006

Kaiser Permanente Silver Spring , MD


October, 2004 -  July, 2005

Lexmark Lexington , KY


February, 2004 -  September, 2004

Sprint Telecom . VA


September, 2001 -  November, 2003

ICICI India


January, 2008 -  Present
Senior Business Objects Consultant

UBS Wealth Management , NJ

Project Description :
The Enterprise Data Warehouse EDW approximately a 4 terabyte data warehouse, formalized in 2001 with the merger of departmental reporting databases EDW, CIS and other operational systems. The Data Warehouse environment covers multiple subject areas, : Client, Employee and FA, Accounts, Costs, Product, Revenue, Trade and Order, Branch, Assets, Transactions etc. Data is propagated from the core data warehouse to a variety of data marts to support reporting and analysis. The Business Intelligence application is an implementation of Business Objects to support WM US s financial advisors.

Responsibilities : Involved in system analysis and design of the Data warehouse.

Participated in JAD sessions with Business users and finalized Universe Objects and Organization of classes and objects.
Gathered, analyzed and documented Business requirements, clarified Business rules and data design requirements, functional requirements and data specifications for Business Objects universes and reports.
Configured Business Objects with LDAP directory server for User Authentication
Designed Universes for applications Finance and Control, FA Compensation System and HCP system as per the User Requirement.
Implemented Object Level Security as per the User Roles.
Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
Developed and implemented Universes by defining joins, cardinality between tables, created derived tables, prompts and queries, applying contexts and alias tables to remove cyclic dependencies using Business objects Designer.
Created Hierarchies in the Universe to enable drill down functionalities in the reports.
Used Custom LOV s functionality in the Universe for performance improvement on the Prompt values.
Migrated users/groups, Universes, Reports, connections to BO XI R2 using Import Wizard and resolved several issues during migration.
Created folders and User groups and applied security access restrictions as per the user roles through CMC.
Used Business Objects Voyager for the analysis of multi-dimensional data sets.
Designed Report templates for standard reports.
Designed Test cases for UAT of Reports for end users.
Designed and created Canned Reports for Wealth Management users.
Responsible for Creating Complex and Multi Dimensional reports using Master/Detail, Cross Tab, Slice and Dice and Sub Queries.
Created technical and user documentation which contains migration issues and using the functionality of Business Objects.
Developed XCelsius Models, Using Crystal XCelsius 2008. Using Business Objects Web services.
Used the Web services WSDLs in the XCelsius Models which generated using Business Objects Query as a Web Service.
Integrated Crystal XCelsius 2008 with Business Objects Enterprise XI 3.0.
Published the XCelsius dashboards to Central Management Server.
Ran the Models in Infoview based on Business users requirement.
Documented the features of the New SIA Server Intelligent Agent.
Designed the custom Principals with in CMC tool based on the Business Requirements.
Delivered the Best Practices and Recommend settings documentation of Business Objects Enterprise XI 3.0 to the customer.

Given training to the Business Objects End users on new features of BOE XI 3.0 which include new tool Web Intelligence Rich Client, Software Inventory Tool, Repository Diagnostic tools.

Technical Environment : Business Objects XI 3.0/XIR2 XCelsius 2008, Live Office, QaaWS, Oracle10g/9i PL/SQL, SQL Server, MS-Access, TOAD, Windows 2000/2003 server


February, 2007 -  December, 2007
Senior Business Objects Consultant

Philadelphia

Project Description :
EHRO

is the owned HR business of EDS and Towers Perrin. EHRO helps clients optimize their investment in human resource processes and programs while better aligning their HR agenda and delivery model with their business objectives. The programs of the Health and Welfare Ministries unit address the critical needs of children and adults. Responsibilities include building a data mart for Health and Welfare Benfits Adminstration, development and maintenance of adhoc reports on Warehouse using Business Objects tools. Ready access to this data enabled decision-making and enable efficiency by EHRO resources for value-added analytic assessments.

Responsibilities : Interacted with Business Analysts, Business Users and Managers in gathering business requirements.
Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
Interacted with the Data Warehouse team and suggested ideas to improve the model of the Data Mart which can help in tuning the SQL and improve the performance of generating reports.
Analyzed data from the Data Marts before designing the universe.
Created the repository and defined the users and privileges for the Users to access the System.
Created derived tables at the universe level to reduce the complexity of universe building.
used Web Intelligence, Info view, reporter and explorer for querying, reporting and analysis tasks.
Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOV s List of Values
Used , , to create predefined conditions and prompts to filter the data in the universes.
Linked the Universes to share the common components using Component approach.
Applied Multi dimensional analysis like slice and dice, drill functions on the reports.
used various techniques like Breaks, Sorting, Ranking, Report Filtering, Query Filtering, Alters and sections to develop the WebI reports.
Generated various numbers of reports on a daily, weekly and monthly basis using WebI and DeskI.
Created Calendars in CMS and scheduled reports to run on weekly, biweekly or monthly basis, according to end user requirements.
Exported the reports to PDF and Excel formats.
Involved in migrating Business Objects Universes and reports from Version 6x to Version XI R2 using the Import Wizard and migrated full-client reports to Web Intelligence reports using the Report Conversion Utility.
used Import wizard in Migration and development of some key reports.
Extensive knowledge in architecture design of Extract, Transform, Load environment using Data Integrator.
Specified the standards for universes, Classes, Aliases, Simple and complex objects.
Created filter objects and formatted objects and measures in the universe for faster report generation.
Created Measure class for measures and created separate class for conditional objects.
Defined cardinalities, Checked integrity, Detected loops and resolved them by using aliases and contexts to remove the cyclic dependencies.
Developed Ad hoc reports using Business Objects.
Resolved loops by creating aliases and contexts using Business Objects Designer.
Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.
Create and maintain database schemas required to support BO reporting needs.
Understand Extract, Transfer and Load ETL tooling used to populate the reporting schema.

Developed complex queries using different data providers universe, Personal Data Files, Free hand SQL in the same report and exported to Excel for the end users.
Created Predefined client reports with prompts and deployed these reports in the WebI Server.
Created formatted Reports in Crystal Reports XI.
Worked extensively on distribution, maintenance and optimization of universes for Business Objects and Web Intelligence deployments.

Trained and mentored less experienced BO and Crystal Reports developers on building their skills to assist in the development and testing of new reports.

Technical Environment : Business Objects XI R2/6.5 Crystal Reports XI r2, Publishing Wizard, Import Wizard, Oracle 9i, Informatica PowerCenter 8.1, Windows 2003 server


June, 2006 -  January, 2007
Business Object Developer

Neo Pharma Pharmaceuticals , CA

Project Description :
Neo Pharma plays a pioneering role in healthcare. As an innovator of products and services for the early detection, prevention, diagnosis and treatment of diseases, Neo Pharma contribute on a broad range of fronts to improving people's health and quality of life. The Project includes developing a Business Intelligence tool to help business to acquire a better understanding of market behavior. The Project provides aimed to provide historical, current and predictive views of business operations.
using data gathered into a data warehouse or a data mart. Responsibilities include developing Business Objects universe on the warehouse tables as a semantic layer for Adhoc and canned reporting purposes. The maintenance and support of adhoc reports is done using Webi

Responsibilities : Involved in Full project life cycle requirement gathering to implementation phase.
used Designer to design various universes for different business groups.
Created complex reports using cascading prompts, decode objects etc
Created filter objects and formatted objects and measures in the universe for Faster report generation
Created generic Measure class for generic measures and created separate class for Conditional objects
Created Universes, table joins, prompts, queries and removed cyclic dependencies with aliases and contexts
Defined aggregate SQL functions on measures to improve performance and applied aggregate awareness to speed up query time.
Worked on database connections, views, parsing of objects
Created user groups and managed access privileges using Business Objects Supervisor
Authorized the user access to 1 or more universes
Created restrictions on objects and classes based on universes privileges
Generated reports using business Objects Reporter
Created different types of reports, like Master/Detail, Cross Tab and Chart for Trend analysis. Used filters, conditions, calculations, etc.
Extensively used breaks for white spaces and sections for better navigability
Defined standards for tables, charts etc

Created detail and summary reports used to fold/Unfold sections corresponding to Breaks in current blocks
Created prompts in report to restrict data fetch and ease data load.
Created User groups, Users, Database connections, Managed user privileges, Import/export of universes in production environment.
used Web Intelligence Info view, reporter and explorer for querying, Reporting and analysis tasks
Used Broadcast agent for scheduled and batch processing of Business objects and Web intelligence documents.
Maintained BO repository using Business Objects Supervisor by enable/disable configurations, reset passwords and to create different categories.
Designed Test cases for UAT of Reports for end users.

Technical Environment : Business Objects XI-r2, Web Intelligence, Desktop Intelligence, TOAD, Oracle 10g, Sql Server 2000, SQL and PL/SQL.


September, 2005 -  May, 2006
Business Objects Developer

Kaiser Permanente Silver Spring , MD

Project Description :
Kaiser Permanente is an integrated managed care organization. Kaiser Permanente is a consortium of 3 distinct groups of entities : the Kaiser Foundation Health Plan, Inc Kaiser Foundation Hospitals and the Permanente Medical Groups. and is the largest managed care organization in the United States. The Project aimed to support better business decision-making. Responsibilities include developing a new reporting system to provide a data-based reporting system for users providing business value to the Business Users of the Kaiser.

Responsibilities : Designed and Implemented security architecture for Financial Group.
Designed Universes and implemented Linked Universes technology.
Designed Universes against Oracle warehouse.
Written BO SDK, VB code for automation of Execution of reports.
Implemented report bursting with Broadcast Agent Server and attached vb macros.
Designed universes for ad-hoc reporting capabilities.
Designed and documented Meta data dictionary.
Developed Complex Security set up for end users with Supervisor.
Defined categories of documents for different level of groups.
Installed the BO and WEB Intelligence on cluster environment.
Developed several Oracle stored procedures and functions for reports.
Installed BCA server on distributed environment.
Designed Universes for Financial Billing system and Order processing.
Worked on Linked Universes by kernel approach.
Maintenance of development and Production environments.
Exported Business Objects reports to WEBI 2.6 to be viewed by all users on the Internet.
used WEBI 2.6 to create and publish corporate documents to multiple users. Used Broadcast Agent Server for auto scheduling of Business Object Documents.
Designed and managed groups and users using Supervisor module and assigned them universes and documents specific to their domains.
Setting up batches and sessions to schedule the loads at the required frequency.
Developed PL/SQL stored procedures

Technical Environment : Business Objects 5.1, Web Intelligence 2.6, ZABO, BCA, WI COM, DB2 UDB 6.1, macros, VBA, BOSDK


October, 2004 -  July, 2005
Business Objects Developer

Lexmark Lexington , KY

Project Description :
Lexmark International, Inc is a leading developer, manufacturer and supplier of printing and imaging solutions for offices and homes. Lexmark's product line has expanded to include laser printers, inkjet printers and multifunction devices and associated supplies and services. Aimed at developing a data warehouse facilitate reporting and analysis. Project includes designing a reporting application is a contemporary BI reporting system that will help streamline reporting and insights on competitive market dynamics for Lexmark's business. The application will empower business users with easy access to increased amounts of Lexmark's data.

Responsibilities :
Responsible for development of Technical design documentation for reporting system.
Participated in Reporting Scope Verification.
Involved in analyzing multi-dimensional reports in Crystal Analysis
Installed and deployed Crystal Integration Pack.
Designed Complex reports using sub reports, manual cross tabs using Crystal syntax with extensive usage of Local, Global and Shared variables at report formulas.
Displayed reports for users on web browser by e-launch pad, e-portfolio using Crystal Enterprise
Converted active reports to crystal reports
Identified the number of reports.
Developed Universe on Supply Chain Module and generated reports for Clinical Trials.
Defined standard CAN reports for Cost Analysis, routing and Clinical trials with drug formulas.
Analyzed the report related source data from HR, ACCOUNTING applications to make it sure that all these data are present in the data mart.
Developed Automated reports and Scheduled to run daily to designated printer and make documents ready for auditing that assigned for that day using Crystal Enterprise, Seagate info.
Setup of folders, users, accounts and user privileges in Crystal enterprise.
Defined security for People Soft users at Application level, OS level and at data level.
Set up of Users, Groups, User Ids, Report viewing privileges for Users in Crystal Enterprise.
involved in using of formulas fields, parameter fields, Group selection, record selection and Crystal syntax in Crystal reports.

Technical Environment : Crystal Reports 10.0 Oracle 9i, Microsoft Excel, Active reports and Windows.


February, 2004 -  September, 2004
Business Objects Developer

Lexmark Lexington , KY

Project Description :
Sprint Nextel Corporation is a telecommunications company. The company owns and operates the third largest wireless telecommunications network in the United States, with 50.5 million customers. Sprint is a global Internet carrier. Responsibilities include developing an OLTP database and generating BO reports to help Business Users to access, view, summarize and report on trends in key Sprint telecommunications and competitive products for markets across multiple time periods.
Ready access to this data enabled decision-making and enable efficiency by SBC resources for value-added analytic assessments.

Responsibilities : Responsible for fitting Business Objects into the Information Architecture of the company and supporting business users and developing new and maintaining existing Universes.
Installed and configured Web Intelligence and Broad cast Agent server on AIX 4.3
Developed CAN reports with PIE charts, BAR charts.
Upgraded business objects from 4.1.4 to 5.0.
Migrated repositories and domains and all user security structures.
Migrated reports, scripts and universes and web intelligence 2.0 to 2.5.
Designed universes with BO designer and implemented row level restrictions with supervisor.
Designed VB interfaces and integrated BO Full client reports.
Written VBA macros and BOSDK for automation of execution of BO reports
Scheduled reports with BAS.
Plan, coordinate and execute Business Objects 5.0 deployment for End users

Train user community in basic and advanced Business Objects reporting skills.
Provide ongoing administration for the Business Objects 5.0 environment.
Customized WebI prompts
Developed Budget reports for different level of users.
Developed Budget vs. Actual reports for different periods in Oracle reports.
Created power users for different departments and assigned as Designers and Supervisors
Defined several categories for different set of reports.

Technical Environment : Business Objects 5.0, web Intelligence 2.5, ZABO, BCA VBA, BOSDK, Oracle 8.0


September, 2001 -  November, 2003
Report Developer

India




Education

BTech Bachelor of Technology from JNTU .



Skills


BI Tools Business Objects XI 3.0/R2/6. x/5.1.4 Supervisor, Designer, Desktop Intelligence, Publishing Wizard, CMC, Import Wizard, Web Intelligence 6.5.1/2.7, Business Objects Enterprise Java Info view, Broadcast Agent 6.5.1/2.7, Business objects Voyager, Crystal Reports 9/XI, Crystal XCelsius, Live Office, Query as a Web Service. Operating Systems Win 95/98/NT/2000, Win XP, Sun Solaris 2.6, UNIX Databases



Miscellaneous

Project Description : ICICI
Bank is 1 of the biggest Banking and Financial Company with wide range of Business Areas. The project involved creation of Reports for a Central Data warehouse for the Debit division of ICICI Bank. This warehouse is projected to assist Sales and Marketing Department to categorize their customers based on significant portfolio of services, checking accounts, savings accounts, personal loans and geographical area. Using different ad-hoc analysis, Reports assisted in defining strategy for each customer category.
Responsibilities : Gathered the Reporting Requirements from the Business.?
Created Reports using Crystal Reports and Business Objects.?
Created Business Objects Reports for day-to-day Analysis and Calculations.
Worked with BO reporting features like Breaks, Alerter, Filters, Sorts and Query prompt and Drill filters.?
Analyzed the reports using the Drill Through, Slice and Dice.?
Setup Print Setup and Configurations for all the Reports.
Technical Environment : Crystal Reports 6.0, Business Objects 4.X, Oracle 8.1, Excel, SQL, PL/SQL and Windows NT/2000, Sun Solaris