Executive Summary

• About 7 years of total experience in Information Technology Industry with 6 years in Business Objects (BO 4.0/BOXI R3/R2/R1/6.5) Development experience.
• With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as Development, Testing, Migrating, Administrating and Production Supporton various platforms like UNIX and Windows NT/2000/XP/98.
• Extensive experience in eliciting requirements, document analysis, business process descriptions, use cases and business analysis.
• Development of Reports using Business Objects version (BOXI R3/R2/R1/6.5) and Crystal Reports (2008/XI).
• Technical profeciency in creating interactive dashboards and scorecards using Xcelsius 2008 and Performance Manager.
• Used Live Office and QaaWS (Query as a Web Service) to feed live data into Xcelsius 2008.
• Created complex Xcelsius dashboards by connecting directly with existing Crystal Reports and XML files.
• Excellent communication, analytical, interpersonal, and presentation skills; expert at managing multiple projects simultaneously.
• Excellent track record of proactively communication and collaboration with external and internal customers to analyse information needs and functional requirements and deliver the following artefacts as needed: sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• 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.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

Computer Skills

• Databases Oracle DBMS
• Languages HTML, PHP, JavaScript, PL/SQL, Embedded SQL, C, C++, PeopleCode,XML
• Management Tools HP Service Centre 6.2, Service Manager, Microsoft SourceSafe, Microsoft Word, Excel, PowerPoint, Visio, One Note
• Software PeopleTools 8.49, Oracle Developer 2000, Oracle Forms & Reports6.0, SQL*Plus, Toad, Adobe Dreamweaver, Adobe Photoshop, Adobe Illustrator, Adobe Photoshop CS3
• Reporting Tools SAP Business Objects 4.0/XIR3/R2/R1/6.5,Reporter, Designer, Supervisor Web Intelligence, Broadcast Agent server, Oracle Reports 2.5, MS Excel, Crystal Reports 2008/XI, Crystal Enterprise Server XI/10/9.0/8.5, Xcelsius 2008, Live Office, QaaWS, Bex Query Analyzer
• Operating Systems Windows 7/ Vista/ 2000/ XP Professional/ 98, Linux, Mac Snow Leopard, Mac Lion OsX
  

Experience

Confidential, Orlando FL 06/2011 Present
SAP Business Objects Developer
Responsibilities:

• Worked with Business Managers, Architects and End users in documenting requirements, providing estimates, creating High Level Design and Detail design specifications.
• Worked with the PM group to identify the priorities, to know the Business Critical and complex universes and reports.
• Design universe on SAP Business Intelligence and prepare ad hoc reports for same.
• Responsible to provide support to all SAP business objects and provide appropriate upgrade on environment.
• Participated in the design, development, testing, implementation and documentation of the solution.
• Developed various reports using Web Intelligence using the Universes built.
• Worked extensively on Designer, Web Intelligence (WebI), Desktop Intelligence (DeskI), Xcelsius, Crystal reports and Central Management Console (CMC).
• Developed dashboards using Business Objects Xcelsius 2008 and fed live data onto dashboards using QaaWS from the Bex Queries provided by the BW team.
• Responsible for the Designing the universes by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Created different types of Ad Hoc reports like Master/Detail, Cross Tab and Chart using End User module in Business Objects.
• Wide usage of Drill mode and Slice and Dice techniques to modify the reports in accordance with the user’s analysis needs.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts).
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Imposed several Joins, Filters, and Alerter to restrict the unwanted data and highlight the required data.
• Provided training to end users to use various functionalities of Business Objects
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces
• Created the Universe and report check list templates, which are used as check points before moving the migrated objects into QA and Production environments
• Worked closely with the Architects to address the performance issues from the server side
• Created various Views and Stored procedures using PL/SQL for Crystal Reports.
• Created the reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, Functions and Formulas, Filters & Alerts for creating Complex reports.
• Published Crystal Reports on to Business Objects Infoview and provided access to the end users.

Environment: SAP NetWeaver 7.2, SAP Business Objects 4.0/XIR3, SAP Xcelsius Dashboards 2008, SAP Crystal Reports 2008/XI, LCM, SAP BW BExQueries, Oracle 9i, Teradata, SQL Server 2005,SSRS, Windows NT.

Confidential,Atlanta GA 01/2010 06/2011
SAP Business Objects Developer
Responsibilities:

• Assisted in the Full Life Cycle Development (FLCD) including Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Elicit requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business analysis, task and workflow analysis.
• Worked with Crystal Xcelsius Dashboards.
• Developed Universes and Reports for Quality Control Systems.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the SQL Server database.
• Extensively worked on DataStage jobs for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Responsible for designing and developing Universes for reporting purposes.
• Existing Universes were fine tuned for time management purposes by creating alternate views, derived tables and indexes. Resolved loops using aliases and contexts.
• Developed complex Web Intelligent, Client and Ad Hoc reports for corporate data, which was stored in the Oracle database.
• Trained the end user in basic and advanced Ad Hoc reporting as well as create queries, format results, and share them with others within the enterprise beyond using Web Intelligence.

Environment: SAP NetWeaver 7.2, Business Objects XIR3, LCM, BExQueries, Oracle 9i, Teradata, SQL Server 2005,SSRS, WindowsNT, Business Objects Enterprise and Crystal Xcelsius

Confidential,St. Louis MO 10/2008 12/2009
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
• Designed and developed ETL processes using DataStage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Involved in performance tuning and optimization of DataStage mappings using features like Pipeline and Partition Parallelism and data/index cache to manage very large volume of data.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• 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, Teradata, Oracle 9i, DB2, SQL, PL/SQL and Windows 2003.

Confidential,Newport News VA 07/2007 09/2008
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 newspapers 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.
• Performed ETL coding using Hash file, Sequential file, Transformer, Sort, Merge, Aggregator stages compiled, debugged and tested. Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• 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 XIR2/6.5.1, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP

Confidential, BostonMA 05/2006 06/2007
Business Objects Developer
Responsibilities:

• Created Universes for various functional areas of high level reports group.
• Interacted with the various users for reporting requirements.
• Customized LOVs in Universes for quicker performance of reports.
• Used SQL against the database to check data retrieved.
• Created the joins strategies while designing the universes.
• Worked extensively in designing universes using Designer. Developed universes for development of various forms of reports.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Developed Reports using Business Objects 6.5, various Report Formats developed include Standard Reports, Cross Tab Reports and Master/Detail Reports.
• According to the customer information created complex report using Universe as main data provider.
• Developed complex reports like Sub Reports, Cross Tab Reports by using Crystal Reports Versions 10.0/9.0.
• Universes and Reports were exported through the Web Intelligence to the respective users.
• Deployed Reports on web by using Web Wizard, and Publishing Wizard components of Crystal Enterprise.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• 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.

Environment:Business Objects 6.5, Web Intelligence, Business Objects Designer, Supervisor, Oracle, UNIX, Crystal Enterprise10, Visual Basic 6.0, SQL Server 2000, Windows NT, Crystal Query, Crystal Reports 10, PL/SQL, SQL*Plus, Toad

Confidential,Herndon VA 06/2004 04/2006
Business Objects Developer
Responsibilities:

• Created Business Objects universes. Responsible for tuning the existing universes for time management purposes by creating alternate views and indexes. Resolved loops using Aliases and contexts.
• Created Master Detail reports using Slice and Dice panel. Developed complex reports like Sub Reports, Cross Tab Reports by using Crystal Reports Version 10.0/8.5 using Databases DB2, SQL Server 2000.
• Created new Business Objects users and User Groups using Business Objects Supervisor Module. Scheduled reports using Broadcast Agent (BCA).
• Developed several Stored Procedures and Views on Microsoft SQL Server 2000 to be used in various Reports.

Environment:Business Objects (6.5/6.1), BCA, Web Intelligence, Oracle, SQL Server 7.0,Sybase, Windows NT, UNIX, Crystal Reports 9.0, Crystal Enterprise 9.

Education
B.S. Electrical & Electronics Engineering