Resume of Business Objects Developer

Title
Business Objects Developer

Primary Skills
UNIX, Windows NT/2000/XP/98

Location
US-VA-Herndon (will consider relocating)

Posted
Mar-03-08

SUMMARY
• About 7 years of total experience in Information Technology Industry with 4 plus years of expertise in developing Business Intelligence and Data Warehouse applications.
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.
• Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view , and Supervisor)
• Expert in tuning the performance of SQL queries and ETL process.
• Expertise in working and implementation of Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/XI/XIR2, Crystal Xcelsius
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.
• Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.
• Experience in server products like Web Intelligence, Broadcast Agent Server, ZABO, Auditor, Application Foundation, Set Analyzer
• Proficient knowledge on BO XI Architecture and new features.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Well experienced in writing Complex queries, stored procedures, functions, cursors and packages using PL/SQL Programming.
• Design, development and coding with ORACLE 10g/9.2/8.x/7.x, SQL Server 2000/2005
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.


TECHNICAL SKILLS
OLAP Tools Business Objects XIR2/XIR1/6.X/5.X, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, Info View, Broadcast Agent, CMC Performance Management, Report Conversion tool and Import Wizard
RDBMS Oracle8i/9i/10g, SQL Server 7.0/2000/2005, MS Access 2000, SQL*Loader.
Languages SQL, PL/SQL,C,C++
GUI Tools Crystal Reports 7.0/8.0/9.0/10/XI/XIR2, VisualBasic6.0, Oracle Forms and Reports, Oracle Toad, Developer/2000.
Multimedia &
Web Designing HTML/DHTML, MS Office, Adobe Photoshop, PageMaker
Operating Systems Windows NT/XP/2000/98 ,MS DOS and UNIX




EXPERIENCE:

Daily Press, Newport News, VA SEP'07-Till Date
Business Objects Developer
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Build the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• Created complex reports stating revenue generation per year using cascading and user objects like measure objects by using @aggregate_aware function to create the summarized reports.
• Exported the Universes to the Repository to make resources available to the users for ad-hoc report needs.
• Created reports containing all the information regarding the publishers, distributors and retailers using crystal reports xiR2.
• Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report for the distribution of news papers to different locations
• Created different reports containing charts showing revenue and operating income by different divisions, market share of newspaper by circulation.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Implemented the ETL process and business logic by using PL/SQL.
• Developed universe user documentation guide for the end users reference.
• Provided training for end users for generating their own report including complicated report.

Environment: Business Objects 6.5.1/ XI r2, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP

CIT Financial, Livingston, NJ AUG'06-AUG'07
Business Objects Consultant
Responsibilities:
• Directly coordinating with user to gather the new requirements and working with existing issues.
• Designed & Implemented security architecture for Financial Group.
• Involved in Data Modeling and SQL server Database
• Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI r2 Universe designing and establishing BO environment.
• Designed Universes for Financial Billing system and Order processing
• Created Objects and prepared Reports like financial reports, HR reports, standard and adhoc reports, and universes.
• Involved in joining the tables by creating aliases to resolve the loop
• Created Reports based on sub total of Currency and General Ledger category
• Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return
• Prepared reports for deals, facility and outstanding for the information of expiry date and effective date of each category
• Prepared report for CIT Net Investment Trial Balance
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user
• Tested the aggregate awareness to ensure the query is pulling correct level of aggregation.
• Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Developed universe user documentation guide for the end users reference

Environment: Business Objects 6.5.1/ XI r2,Crystal Report XIR2 Import Wizard, Conversion Tool, Web-Intelligence, Desktop-Intelligence, Designer, Info View, Toad9.0, SQL Server2000, Oracle 9i, SQL, PL/SQL Windows 2000/XP.

Bank of Montreal Financial Group, St. Louis, MO Jun'05-JUL'06
Business Objects Developer
Responsibilities:
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications about the financial system for Business Objects Universes and Reports.
• Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, marketing reports for marketing group users.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Created Universes by defining connections and retrieving data from database.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Monthly paper bill Reports
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Created New Classes and User Objects in designing the universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created and modified the Crystal Reports for various financial groups using the Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports.
• Involved in creating various reports by extracting data from Data Marts
• Created reports using Oracle Databases and Personal Data File Providers.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.

Environment: Business Objects XIR2/6.5 (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), Crystal Report XIR2, MS Access, Oracle 9i, SQL, PL/SQL and Windows 2003.

Walgreen's Pharmacy: SANTA CLARA, CALIFORNIA. OCT'04 - May'05
Business Objects Consultant
Responsibilities:
• Creating, developing, maintaining and testing the Universe for running the queries against the Database.
• Involved in Installation and Configuration of all products of Business Objects.
• Created Repository and assigned privileges to users and groups using Supervisor.
• Analyzed the existing database and designed Universes using Designer module for generating reports.
• Used various data providers like Freehand SQL and Stored Procedures to extract data from different sources and tuned for better performance.
• Resolved loops by creating Aliases & Contexts and checked integrity of universes.
• Exported universes to the repository to making resources available to the users.
• Created reports using the Universes and Free-hand SQL as data providers.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Involved in development and deployment of Complex Reports.
• Created Reports showing the sales of various Drug products in a particular Year, Quarter and Month using Business Objects and reports based on DDD (Drug Distribution Rx Data).
• Created the reports to monitor the 21CFR PART 11 Compliance information of various Drug's provided to Physicians.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.
• Involved in optimizing the universe developing time and SQL Tuning to increase the query performance.
• Used Designer as a part of Universe Development for Defining the Parameters of Universe, Inserting the table, making Joins, Resolving Loop's, Creating Classes, and Objects.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Exported the Universe to Repository for making available to Business Objects users and Web Intelligence users.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries.
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.

Environment: Business Objects 6.5, Designer, Full-client, Broadcast Agent, Supervisor, Oracle9i, PL/SQL, and Windows NT/XP.

T-Mobile, Philadelphia, PA NOV'03-Sep'04
Business Objects Developer

Responsibilities:
• Created Universes for various functional areas of high level reports group.
• Created Contexts and Aliases to resolve chasm and fan traps in Universes.
• Customized LOVs in Universes for quicker performance of reports.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Changed the universe parameter settings to optimize the performance of universe.
• Created different universes which contains the information about the customer like,cust_name,address,ph_no,plan_used,mins_used,mins_remaining,rollover mins.
• Gathered information like attempted calls, type of call (long distance, local),length of call, originated number, destination number,rates,time of call for creating report for billing of a customer.
• Worked on Business Objects Administration like CMC and CMS maintenance & security issues
• According to the customer information created complex report using Universe as main data provider.
• Exported the universes to the Repository making resources available to the users.
• Linked the Universes to share the common components between the universes.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Custom sorts, Cross Tab, Master Detail and Formulae's etc.
• Created reports according to different cell phone plans like individual plan, family plan, family time plan.
• Exported the Reports to the Broadcast Agent and used the Broadcast Agent server to Schedule and Monitor the Reports.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Created various analytical reports like Market Share, Trending, Rank reports from multiple data providers.
• Interacted with the various users for reporting requirements.
• Provided end user support and problem resolution for various issues related to BO.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies based on the business requirement.
• Used the Aggregate Awareness feature of Business Objects for the Optimization and Performance tuning of Universes.
• Involved in Working with Erwin tool in Data Modeling (both Physical and Logical Design).

Environment: Business Objects (Supervisor, Designer, Reporter) 6.1, Crystal Reports, Oracle 9i, PL/SQL, ERWIN.
Sach Electromech Pvt. Ltd., INDIA OCT'02-SEP'03
Programmer Analyst
Responsibilities:
• Preparation of Technical documents.
• Maintained comprehensive information on all inventory items, gave up-to-date status on their availability, usage, receipts, on-order, pending inspection, committed quantities, etc.
• Attended several business sessions with the business users and created Views and altered some of the dimensional tables to satisfy their reporting needs.
• Involved in the Requirement Analysis and Preparation of System Requirement Specification Document.
• Involved in the Database Design Preparing the Codification Schemes.
• Preparing the Data Dictionary.
• Designing the Screen, Report and Query layouts. Involved in Coding Using Developer/2000 (Forms 6.5 and Reports 6.5), PL/SQL Stored Procedures and Database Triggers.
• Involved in Unit Testing and Integration Testing.
• Involved in Acceptance Test by the Customer.
• Designed screens for billing module.
• Extensively involved in creating database packages, procuders, functions, cursors and triggers using PL/SQL.
• Developed Oracle Forms and Reports.
• Generated reports from the sales and distribution package such as sales analysis report, profile wise reports etc.
• Written Procedures and Functions of calculation of Receipts.

Environment: Oracle 8i, PL/SQL, Oracle Forms 6i, Reports 6i, Windows NT

Makers Polyfilms Pvt.Ltd, INDIA APR'01-SEP'02
Developer
Responsibilities:
• Analyzed the business requirements of the project by studying the Business Requirements Specification document.
• Creation of database objects like tables,views,procedures,packages using Oracle tools like PL/SQL,SQL *Plus,SQL*Loader and Handled Exceptions.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Developed functional specifications.
• Created PL/SQL stored procedures by using bulk bind for inserting, updating data in process tables.
• Optimize SQL queries for better performance.
• Created Dynamic generalized procedures for truncating current and old partition data.
• Designed the front end interface for the users using Forms 6i.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Developed numbers of reports using Reports 6i.
• Performed Unit Testing.

Environment: D2K 6i, Oracle 8i, PL/SQL, Windows NT

Education:

* Post graduation in Information Science
* Bachelor of Information Science

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-VA-Herndon »
View all resumes in US-VA »

View other Business Objects Developer resumes, Programmer / Developer resumes