Summary





Over 7 years of experience in implementing Business Intelligence and data warehousing solutions using Business Objects 4.3/5.0/5i/6i/XI, Crystal reporting.
Very fluent with business process documentation and end-users training/knowledge transfer.
Working knowledge of complex scheduling features in CMC, calendars and event based scheduling.
worked on Creating Dash Boards using Crystal Xcelsius and Performance manager.
Used import wizard, report conversion too, CMC, DESKI and WEBI features in XIR2
Worked with the DBA to create aggregate tables and used aware functions in the universe to improve the performance of the query by cutting down on the size of the result set at the data provider level.
Efficient in Optimizing, Debugging, Tuning and testing SQL queries, views and stored procedures in Oracle and SQL Server and check the Explain Plan to find the execution path.
Experience in dealing with various databases like Oracle, Teradata, SQL Server, Access and Flat files.
Expert in multiple successful implementation of Business Objects architecture and metadata management
Extensive knowledge on design and development of universes and best practices.
Experience in implementing Business Objects report management with in Finance and Telecom sectors.
Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports created 100+ reports in both crystal and business object.
Worked on migration assignments starting with road map to final implementation phase.
Performed production support and performance and SQL tuning in various projects.
Conducted user training and created training manuals
Troubleshoot the problems and customized the reports according to the specifications of the analysts.
Worked on of new features of Business Objects XI, Index awareness, Derived tables and Central management console.
Extensive knowledge of PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
Successfully implemented export to excel feature in lower versions of business objects.
Exposure and good understanding with the Supply chain management process
Involved in Data Modeling using Visio and Unified Modeling Language UML based on the user
Working Knowledge of BO XIR3.


Employment

September, 2008 -  Present
Role : Business Objects/Crystal Reports developer

Involved planning, Requirement gathering and Testing Phases of Migration Process
Prepared detailed documentation of all the Reports and Universes which need to be Migrated and Converted to BOXIR2 - WEBI.
Migrated Full Client Reports and Universes to BOXIR2 using Import Wizard.
Developed and Converted Complex DESKI Reports to BOXIR2 WEBI Using Report Conversion Tool.

Highly skilled and experienced Supply Chain Professional with experience in Logistics, Procurement and Materials Control mainly overseas.
Developed reports in Order Tracking Report, On Time Delivery Report, Carrier compliance report, Carrier capacity report, Stock location reports Freshness inventory reports which determines the shelf life be it raw material or finished goods, Vendor payment reports Order by demand. These reports will have details of when did the carrier deliver and the order time
Developed complex reports by designing complex universes using Crystal Reports.
Involved in writing complex views, stored procedures for generating complex reports using Crystal Reports XIR2.
Converted Full Client VBA Macro Reports which were developed for the purpose to leave parameters blank when refreshing the reports, using the complex features of DESKI/WEBI functionality.
Created several new objects and classes in the Universe based on the report creation requirements.
Worked with Complex formatting issues during Conversion to WEBI.
Developed Bar Graphs, Line charts, Pie charts using DESKI/WEBI functionality.
Worked with Complex Queries as per the user requirements.
Involved in designing and development of Security Model which was created in Central Management Console.
worked on Creating Dash Boards using Crystal Xcelsius and Performance manager
Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
Trained Users about the usage of Info view in the new environment.
Knowledge of all documentation related to version migration that is provided by business objects technical support, Business Objects Enterprise 6 Platform Support, recommended settings for migration, etc.
used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc
Working knowledge on new features of Business Objects XIR2, Index awareness, Derived tables and Central management console.
Recreated the reports from SQL server - 2000 to Business Objects XI and Crystal Reports.
Created reports to have unlinked sub reports like Outstanding Letters of Credit by Tran Subtype, Outstanding Letters of Credit by Business Unit and Outstanding Letters of Credit by Bank.
While migrating the universes across repositories Development, Test and Production, followed step by step process of testing the universe connection making sure that the migrated universe points to the new database
Implemented the best practice of naming the universe connection came across the repositories so that the migration would be seamless across repositories using import wizard
Replicated/Migrated reports created in crystal reports to Business Objects
Worked on cross-tab and master detail reports. Also represented the same as line charts/ bar charts or pie charts of the same.
Developed Parameterized reports, cross tab reports and Sub Reports involving complex formulas using Crystal reporter.
Involved in SQL tuning for better performance while generating Ad-Hoc reports.
Exposure and good understanding with the Supply chain management process.
Generated Reports on different data sources like Business Objects Universes, Stored Procedures etc.
Designed reports with complex variables, multiple breaks and sorts to meet the user requirements

Environment : Business Objects 6i/XIR2, Business Objects Info View WEBI, Crystal Reports XIR2, Crystal Xcelsius 2008, Oracle 10g, DB2, UNIX, WindowsXP, Rapid SQL, Web logic, SQL Server 2005.

June, 2007 -  August, 2008
Role : Senior Business Objects and Crystal Reports Developer

BMS is a global pharmaceutical company with offices, research and development labs, manufacturing plants and distribution facilities located in almost every country around the world. The project was for the Sales department of BMS. Reports are created to provide Sales analysts with Trend analysis and Benchmark with competitors related data.

Responsibilities : Worked with the end users and Database developers to identify the critical data needs for reporting.
Worked with the ETL and data load teams to load data from the mainframes.
Identified the aggregate reports that analyze yearly and quarterly sales figures and worked with the DBA to create the relevant aggregate tables

Designed, developed and provided training in creating Ad-hoc reports, modifying universes, scheduling options in XI, Creating fiscal calendars in XI, XI Desktop Intelligence/Web Intelligence to End users/Power user
Developed various Charts, Graphs and drill down reports used Toad to verify if the data pulled by the report is correct compared to the database data and also to verify if the joins used in designing the universe are correct.
Generated Custom variables, groups and formulas in Business Objects.
Generated Reports on different data sources like Business Objects Universes, Stored Procedures etc.

Worked on User/System report documentation, user training and testing developed reports for final deployment.
Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.
Worked on creating groups, conditions, filters, ranking in reports
Scheduled the weekly, monthly, quarterly reports using business objects
Worked on improving performance of reports with aggregate aware and using indexed columns in reports.
Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Extensively used breaks for white spaces and sections for better navigability
Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
Provided complete documentation and presentation at the end of the contract to help users in developing various reports using different functionalities and methods used in creation of reports.

Environment : Business Objects 6.5/XI, WEBI, Crystal Reports 10, Oracle 8i/9i, Windows 2000 and HP UNIX, SQL Server 2003

October, 2005 -  May, 2007
Role : Senior Business Objects Developer

Description : Capital Group of Companies is an Investment Management Company which manages the investments of individuals and large institutions through mutual funds, managed accounts and pooled investment.

This Project Involves in Migration and Conversion of Business Objects 6.5.4 to Business Objects XIR2 WEBI Version.

Responsibilities : Involved planning, Requirement gathering and Testing Phases of Migration Process
Prepared detailed documentation of all the Reports and Universes which need to be Migrated and Converted to BOXIR2 - WEBI.
Migrated Full Client Reports and Universes to BOXIR2 using Import Wizard.
Developed and Converted Complex DESKI Reports to BOXIR2 WEBI Using Report Conversion Tool.
Converted Full Client VBA Macro Reports which were developed for the purpose to leave parameters blank when refreshing the reports, by allowing user to enter 1, many or All Values to get the prompt values.
Created several new objects and classes in the Universe based on the report creation requirements.
Worked with Complex formatting issues during Conversion to WEBI.
Developed Bar Graphs, Line charts, Pie charts using DESKI/WEBI functionality.
Worked with Complex Queries as per the user requirements.
Involved in designing and development of Security Model which was created in Central Management Console.
tested the migrated and converted reports by validating the data and fixed the issues relating to them.
Involved in Migration of Repositories from Development, Test and Production environment using import wizard.
Created a backup of WEBI Reports and Universes in BIAR format using Import Wizard.

Created training manual s for users and trained about the usage of Infoview in the BOXIR2 environment.
Knowledge of all documentation related to version migration that is provided by business objects technical support, Business Objects Enterprise 6 Platform Support, recommended settings for migration, etc.
used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc

Environment : Business Objects 6i/XIR2, Business Objects Info View Web I, Oracle 10g, UNIX, Windows, Rapid SQL, Web logic

Client : WARNER BROTHERS. July 04 - Aug05
Role : Business objects Supervisor-Developer Burbank, CA

Project involved the creation and maintenance of Business Objects Universes and reports to assist the Business Users in decision-making. Worked extensively on the Designer, Reporter, Broadcast agent server, Web I, Supervisor modules.

Responsibilities :
Involved in full project life cycle implementation requirement gathering to production phase.
Prepared the following business/technical writing of requirements, design templates, development standards document and detailed design documents.
Involved in extensive testing of universes and reports during version migration of business objects.
Involved in performance tuning of Business Objects reports by tuning the SQL.
Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository.
created Business Objects reports like matrix reports, tables, Pareto charts and pie charts.
Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
Involved in report bursting using Broadcast agent server
Implemented row and object level security in business objects supervisor module
Knowledge of all documentation related to version migration that is provided by business objects technical support, Business Objects Enterprise 6 Platform Support Stacks, recommended settings for migration.
Defined documentation standards, the creation of Entity relationship diagram ERD for universes.
Responsible for fitting Business Objects into the Information Architecture of the company and creating users privileges with supervisor. Also for developing and maintaining universes.
Managed categories that were created and assigned to document by users.
Managed the scheduling options stored in the repository and involved in changing the document descriptions.
Specified the standards/best practices for universes like maintaining design consistency. Also defined standards for tables, charts, etc.
Extensively used breaks for white spaces and sections for better navigation. And created template documents with header, footer and company logo.
Created user groups and managed access privileges using Business Objects Supervisor.
Developed various Metadata and operational definitions.
Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily.
Responsible for managing the Business Objects repository.

Environment : Business Objects 6i, Broadcast Agent Server, Business Objects Web I, Informatica Power Center 5.0, Crystal reports, Info View, Visual Basic 6.0, DB2, Oracle 9i, Windows NT.

August, 2003 -  June, 2004

Description : Lucent Technologies designs and delivers the systems, services and software that drive next-generation communications networks. Backed by Bell Labs research and development, Lucent uses its strengths in mobility, optical, software, data and voice networking technologies and services, to create new revenue-generating opportunities for its customers, while enabling them to deploy and better manage their networks. Data from the data warehouse is used to design and develop reports using Business Objects 5.1.3 Broadcast agent server, Business Objects Web I.

Responsibilities : Involved in the Requirements gathering, Development, UAT and Production support phases of Business Objects Report development.
Installed the Business Objects version 5.1.3
Created user groups and managed access privileges using Business Objects Supervisor.
Responsible for Business Objects repository, Web Intelligence maintenance and tuning.
Performed release management of Business Objects reports using Broadcast Agent Server.
used Designer to design various universes for different business groups. Created complex reports using cascading prompts, decode objects, etc.
Created user groups and managed access privileges using Business Objects Supervisor.
Designed, built, maintained Business Objects universes and repository.
used Web Intelligence Info view for exploring querying, reporting and analysis tasks.
Used Broadcast agent for scheduled, batch processing of Business objects and Web intelligence documents.
Designed, built and maintained Business Objects universes.
Authorized user access to 1 or more universes, created restrictions on objects and classes based on universe privileges.
Developed various metadata and operational definitions.
Customized Business Objects web interface intranet to access the enterprise reports developed in Business Objects full client.
Troubleshoot the problems and customized the reports according to the specifications of the analysts.

Environment : Business Objects 4i/5i, Broadcast agent server, Business Objects WebI, Informatica Power Center 5.0, Crystal reports 7.0, Visual Basic 6.0, Oracle 8i, Windows NT.

July, 2002 -  May, 2003
Developer

Responsibilities : Involved in implementation and maintenance of SAP R/3 4.5b for BW integrating with SD, MM and FI-CO modules. Involved in Data Modeling, Extraction and Reporting using BW for assisting in strategic decisions on company s business.
Involved in analysis and design of extended star schema for data modeling.
Configuration of BW by identifying the needs of customer, modeling the data, defining the data sources at OLTP and reporting the data by using Administrator Workbench s business explorer BEx. Actively done extraction, transformation and loading ETL of data from R/3, Non-R/3 to BW.
worked on activating the standard delivered business content of LIS in the form of InfoObjects, InfoSources, InfoCubes, ODS and customizing it by creating new business content.
Involved in understanding the requirements from Business Owners and created the requirement document from functional requirements.
Extracted data using CO-PA KEB0 cost or account based for analyzing the data on various criteria s/partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs.
Created Process Chains to automate the Master and Transaction data loading process, Rollups of Aggregates, periodic Deletion of PSA data. Monitored the data loading
Responsible for extracting the data from the existing systems and load data into the repository. Involved in Data Modeling of the Data mart tables using ERWIN 3.5.2
Developed complex formulae and running totals for business measure calculations as per requirements.
Created nested and conditional groups and formatting features in reports. Developed Stored Procedures, Cursors, Functions to input data into Crystal Reports.
Generated reports with parameters, sub reports, cross tabs, charts using Crystal Reports8.5/9.0.
Developed and implemented ad-hoc reporting system using Crystal Reports. Wrote ref cursors to extract data from Oracle database as input to Crystal Reports.
Created users and user groups, restricted access of the users as needed using Crystal Reports Management Console. Involved in managing users, groups, folders and published reports using Crystal management console.
Involved in loading the reports developed using the Crystal Reports to the web using Crystal Enterprise.
Published reports on web using Crystal Enterprise ePortfolio.
Defined various parameters required to run a report on web using Crystal Management Console.

Education

Skills


Business Intelligence Business Object suite XI R2/6. x/5 .x, Web I 2.6/6i/XI Designer, Reporter/Desktop Intelligence, Supervisor, Broadcast Agent, Info view, Crystal Reports 10.0/XI/9.0/8.0, Cognos, Crystal Enterprise, Central Management Console. Modeling Tools TOAD, SQL Loader, ERWIN, VISIO, Endeavor, Expeditor, $avers, File-Aid Programming Languages C, C++, Java, PL/SQL, T-SQL, SAP-ABAP Web Technologies HTML, Java Script, XML, .Net RDBMS Oracle 8i/9i/10g, Sql Server 6.5/7.0/2000/2005, Access 97/2000, DB2, MS-Access, Excel Business Intelligence Tools : SAP BW 2.0b, 3.0b, 3.1c, 3.5 and 7.0 Operating Systems Windows 95/98/2000/XP/2003, UNIX Environment : Crystal Reports 8.5/9.0, Crystal Enterprise 8.5/9.0, : SAP BW 2.0b, R/3 4.5b, ABAP/4, SD, MM, FI-CO Visual Basic 6.0, HTML, Java Script, ASP 2.0, ODBC, ADO, IIS 4.0, Oracle 8.1.6 DB2 8.0, SQL Server 2000, SQL* Loader, PL/SQL, Sun Solaris and Windows 2000.