SUMMARY

• 10+ years of experience & 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.
• Experience in developing BO universes on SAP BI(Business Intelligence)/BW (Business Warehouse) Objects, including universe creation on BEx(Business Explorer) reports, Infocubes and DSO (Data Store Objects)
• Expertise in working and implementation of Crystal Decisions, Crystal Reports 7.0/8.0/9.0/10/ XI/XIR2, Crystal Xcelsius
• Change Management Experience, Project time estimate preparation & Identifying end user training requirements
• Business Objects (BO) Upgrade & Support Experience
• 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 noledge 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.
• Experience in Business Objects training material preparation and training super users/ users on SAP BO Webi / Deski report creation
• 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

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. SAP BI / BO Consultant

Environment: BO XI 4.1 / XI 3, BEx Analyzer

Responsibilities:

• Participated in user meetings to discuss project concept, design and schedule.
• Created technical specifications from client requirements.
• Used BODS 3.2 x to extract the data from different source systems to Data warehouseing.
• Define and maintain Source and target database in BODS, created Data Flows for dimension and fact tables and loaded the data into targets.
• Created Data mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transformations, Case Validation, Merge, lookup etc. in Data flows.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs indifferent ways like indexing the source tables and using Data transformations.
• Maintaining and Scheduling the Extraction jobs.
• Provided production support in analyzing and fixing the issues raised by the jobs while running in production.
• Assisted users in creating Web-intelligence reports in business XI 3.1.
• Developed Complex Reports using WEBI and crystal reports against OLAP Universes.
• Created executive summary reports Using Web intelligence rich client utilizing prompts, alerts etc.
• Provided performance reports to managers, representatives and directors as dash boards in Xcelsius using Line, Bar, Combination Charts, Selectors for Wat-If Analysis.
• Modified the Web-intelligence reports by adding characteristics and key figures and changed the formats depending upon the requirements of the end user. Added additional features to the reports by introducing the graphical analysis in the form of tables, charts, pie diagrams and comparison charts.
• Created Crystal reports for detailed analysis of issues during particular time period in materials and delivery dates in production planning. .
• Developed and delivered dashboards using Xcelsius with charts, Selectors, Containers and advanced features.
• Involved in transport collection and release of transports from Quality to production and worked with the basis team for successful release of the transports.
• Involved in solving the tickets in the production depending upon the priority level allotted.
• Used Query designer for building the queries and generated the PO/ SA detail line report and PO/SA summary reports and embedded them into the workbooks.
• Supported end user testing and Go-Live Process and resolved the issues dat occurred during the process.

Confidential, Marshall, MN

Sr. Business Objects Developer

Environment: Business Objects XI 3.1/ XI R2, SAP BI7.0/BW, Teradata, Crystal Reports XIR2, Xcelsius, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Windows XP

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Configured Business Objects client tools on user machines.
• Directly coordinated with user to gather the new requirements and working with existing issues.
• Built the new universes as per the user requirements by identifying the required data from SAP BI (Business Intelligence / Business Warehouse) and Teradata.
• Used BEx (Business Explorer) reports and Infocubes to create the universe for best performance, and use context and alias tables to solve the loops in Universe.
• 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.
• Created different reports containing supply planning data like inventory reports, shipments report, Die bank aging reports using alerter, user responses and cross-tabs.
• Used input controls to include/exclude different type of demands like forecast, safety stock, and sales orders in the report during run-time and there-by created a user interactive dynamic report.
• Created change requests and suggested solutions to resolve the issues while using universes and BEx queries.
• Coordinated with functional team, BI team and Business to get the appropriate mapping for the fields used in the report.
• Opened tickets for data refresh and any data related issues, fixed and delivered the reports on time.
• Joined different universes from APO and BW and created complex reports using crystal and received appreciation from the client.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according to user requirements.
• Exported reports to Excel and PDF for further analysis and decision making.
• Created an interactive dashboard using Xcelsius.
• 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.

Confidential, Rochester, MN

Sr. Business Objects Developer

Environment: Business Objects XI 3.1/ XI R2, SAP BI7.0/BW, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Oracle 9i, SQL, PL/SQL, Linux, Windows XP

Responsibilities:

• Build the new universes as per the user requirements and defined the universe connections.
• For best performance, used BEx reports and Infocubes to create the 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, input controls report for analysis of parts benefits and headcount.
• Created complex reports using the multiple data providers 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.
• 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 time estimates for new proposals and change orders
• Provided training for end users for generating their own report including complicated report.
• Transport Management from Development to Quality to Production
• Coordination with security team on role setup and providing report access to various user groups
• Upgrade & Support experience to BO 3.1 Version.

Confidential, Livingston, NJ

Business Objects Consultant

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

Responsibilities:

• Directly coordinating with user to gather the new requirements and working with existing issues.
• Configured Business Objects client tools on user machines.
• Designed & Implemented security architecture for Financial Group.
• Involved in Data Modeling and SQL server Database
• Identified business objects best practices and documented the same and adhered to naming convention document
• Combined data from SAP BI and SQL Server database in the universe design
• Universe created on BW (Business Warehouse) BEx reports, Multi provider(Multi cube) and DSO (Data Store Objects) in SAP BI
• 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 no 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 TEMPeffective date of each category
• Prepared report for Confidential 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.

Confidential, St. Louis, MO

Business Objects Developer

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

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.

Confidential, SANTA CLARA, CA

Business Objects Developer

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

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.