SUMMARY

• Competent Information Technology (IT) professional with 7 plus years of experience as a Sr. SAP Business Objects, Xcelsius, and Crystal Reports Consultant with Two Full Life Cycle implementations, three migrations/Up - gradations and Production support.
• Experienced in various versions- SAP Business Objects 4.0/XIR3.1/XIR3/XIR2/XIR1/XI/6x/5x and Tool components- Information Design Tool (IDT), Universe Designer, Web Intelligence (WEBI), BI Launchpad / InfoView, Live Office, Xcelsius, Explorer, Advanced Analysis (Microsoft Edition), Desktop Intelligence (DESKI), Life Cycle Manager/Import Wizard, Publishing Wizard, SAP Integration Kit.
• Hands on experience in designing and building Universes using Information Design Tool / Designer by Objects data model selecting/joining tables, indicating cardinalities, creating aliases/ contexts to resolve the loops and creating the classes /objects.
• Created dashboards using Crystal Xcelsius 2011/2008/4.5 with connectivity like Query as a Web Service (QaaWS), Live Office and BICS.
• Mastered in designing Simple, Complex Ad hoc Reports and fine-tuning the reports using Calculations, User Report Level Variables, Multiple Data providers, Merged Dimensions, Synchronization, Combined Queries, Subqueries, Report Level Details, Charts, Crosstabs, Sections, Ranking, multilevel Breaks, Sorting, Drill, Slice and Dice and Alerts for creating Web Intelligence (WEBI) reports.
• Expertise in designing complex Crystal Reports 2011/2008/XI/10.0/8.5 including Cross-tab, Conditional, Drill-down/summary, Top/Bottom N and also reports involving multiple Subreports, On Demand Subreports, Charts, Conditional formatting, Summaries and Complex formulae.
• Expertise in creating and maintaining Information spaces using SAP Business Objects Explorer 4.0/3.2 on top of Universes, SAP BW Accelerator.
• Developed Database Design, Data Modeling experience using Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions tables, Physical & logical data modeling, Erwin Data Modeler 4.1.2 with data source/Data Extracted from various sources like Oracle, Flat files, SQL Server and MS access.
• Experienced on working databases like Teradata 12/13, SAP BI 7.0, SAP ECC, Sybase IQ, IBM DB2, Oracle 11g/10g/9i/8i, MS SQL Server 2000/2005/2008/2012
• Worked in ETL design, development, testing and implementation using tools like SAP Data Service, Data Integrator, Data Federator, Informatica Power Center 8.1/8.5/8.6, SAP BW/BI 7.0, SAP ECC, Qlikview, and Data Stage.
• Knowledge of SAP Business Warehouse BW 3.x/BI 7.x, Business Explorer (BEx), SAP R/3 and ETL process.
• Worked and Prototyped additional tools like Business Objects Mobile (MOBI), Roam BI, Widgets, Infobrust, APOS and additional plug-ins in Xcelsius.

TECHNICAL SKILLS

• SQL
• Data Modeling
• Dimensional Modeling
• Seibel
• DB2
• Windows (7/2008/2003/2000/ NT)
• Oracle (11,10g)
• SQL Server(2008)
• Informix
• Teradata 13/12
• ERWIN/TOAD
• Unix
• HTML
• MS Office Applications
• Mentor/Training
• Informatica 8.6/7.1/6.1/5.1 Power Center
• Linux (Debian/Redhat)

PROFESSIONAL EXPERIENCE

Confidential, Hoboken, New Jersey

Business Objects Developer Onsite Lead

Responsibilities:

• MSurety Replacement Project involved developing the Erlon Application, Data migration from Surety to Erlon, Data Mapping, Data Conversion, Designing Universe and Creating WEBI and Crystal Reports
• Gathered functional requirements from the Business Users and Analysts and translated them to technical requirements and SRD (Specification Requirement Documentation) to create Universes.
• Worked with the Power Users, Data modeling team, ETL team and Higher Management to define the requirements. Review the requirements and convert them into design specifications.
• Created RPT MSurety Reporting Universe using Oracle 10g and Pl/SQL data sources
• Designed the Universe by defining necessary Joins, Cardinalities and applying Contexts/Aliases to maintain the overall integrity of the Universes by resolving loops and traps
• Created derived tables and aggregate tables for maximum optimization and efficient performance of the Universe and worked on Importing/Exporting the Universe from/to repository to make it accessible to end users
• Created Customer and System WEBI reports of high complexity which involved multiple data providers, Report level and Block level drill filters, Alerters for conditional output and Input Controls
• Converted few existing WEBI reports to Crystal reports to overcome the limitations of output data rows in WEBI and scheduled the reports on a Daily/Weekly/Monthly basis
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards (scorecards) to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPIs).
• Tested and checked the integrity of the reports after migration. Worked with business users and SME’s to identify and fix bugs occurred during migration
• Trained the end users in working and handling the Business Objects user module, Web Portal Infoview and Marsh & McLennan Companies’ Reporting Portal

Environment: BO 4.0, BO XIR3.1, Pl/Sql Developer, Oracle 10g/11g, Launch Pad/InfoView, Information Design Tool/Universe Designer, Web Intelligence, Crystal Xcelsius 2011/2008, Live Office, Crystal Reports 2011/2008, Import Wizard, Publishing Wizard, Windows AD

Confidential, OKC, OK

Business Objects Developer/Universe Architect

Responsibilities:

• Measurement Project involved developing the FlowCal Application, Data migration from Esuite to FlowCal, Data Mapping, Data Conversion, Designing Universe and Creating WEBI and Crystal Reports
• Gathered functional requirements from the Business Users and Analysts and translated them to technical requirements and SRD (Specification Requirement Documentation) to create Universes.
• Worked with the Power Users, Data modeling team, ETL team and Higher Management to define the requirements. Review the requirements and convert them into design specifications.
• Created EX Measurement FlowCal - (LIVE DATA) Universe using Oracle 11g and Pl/SQL data sources
• Designed the Universe by defining necessary Joins, Cardinalities and applying Contexts/Aliases to maintain the overall integrity of the Universes by resolving loops and traps
• Created derived tables and aggregate tables for maximum optimization and efficient performance of the Universe and worked on Importing/Exporting the Universe from/to repository to make it accessible to end users
• Created Customer and System WEBI reports of high complexity which involved multiple data providers, Report level and Block level drill filters, Alerters for conditional output and Input Controls
• Converted few existing WEBI reports to Crystal reports to overcome the limitations of output data rows in WEBI and scheduled the reports on a Daily/Weekly/Monthly basis
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards (scorecards) to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPIs).
• Tested and checked the integrity of the reports after migration. Worked with business users and SME’s to identify and fix bugs occurred during migration
• Trained the end users in working and handling the Business Objects user module and Web Portal Infoview

Environment: BO 4.0, BO XIR3.1, Pl/Sql Developer, Oracle 11g, Launch Pad/InfoView, Information Design Tool/Universe Designer, Web Intelligence, Crystal Xcelsius 2011/2008, Live Office, Crystal Reports 2011/2008, Import Wizard, Publishing Wizard, Windows AD

Confidential, NYC, NY

Business Objects Consultant

Responsibilities:

• Participated in project planning sessions with project managers,businessanalysts and team members to analyzebusinessrequirements, equity capital raising requirements and outline the proposed solution.
• Interacted with Business users and Business Analysts in gathering requirements and to understand their business view in designing the Universe and modifying the reports accordingly
• Project mainly involves in developing enterprise reporting system called FUSION. Fusion application provides both canned and ad-hoc reporting solution for more than 200 external clients.
• Involved in identifying Key Performance Indicators (KPI) and Metrics for the Dashboards.
• Designed universes and maintained for Wealth and Investment Management data both from Sybase IQ and Oracle 11g data sources.
• Resolved loops and traps using Aliases, Contexts and short cut Joins.
• Designed row level security by creating restriction sets and applying to Users & Groups.
• Developed Revenue, Annuity and Mortgage reports using Web Intelligence (WEBI) tool on top of multiple universe, using combined queries, hierarchies, Sub-queries and also developed and maintained linked Universes.
• Used features and functions like Userresponse(), Rank, DrillFilters(), Merged Prompts, Merged Dimensions, hyperlink & Opendocument, Input Control.
• Developed dashboards like Investment Analytics, Sales & Demand Planning Dashboards using Crystal Xcelsius using connectivity like Query as a Web Service (QaaWS) and live office. Feature includes Dynamic Visibility, Drill down.
• Scheduled Reports & Dashboards on Daily, Weekly, Monthly basis with different Destinations & Formats (pdf, csv, excel).
• Involved in training the end users on accessing/handling web portal InfoView to execute the reports based on selection parameters and in-charge for training and handling the entire project to the employees/developers

Environment: BO 4.0, BO XIR3.1, Sybase IQ 15, Oracle 11g, Launch Pad/InfoView, Information Design Tool/Universe Designer, Web Intelligence, Crystal Xcelsius 2011/2008, Live Office, Crystal Reports 2011/2008, Import Wizard, Publishing Wizard, Windows

Confidential, Bentonville, AR

Sr. Business objects Consultant

Responsibilities:

• Member of an engineering team for business intelligence, data warehouse, marketing system, customer support system to deliver customized e-commerce platform solutions to global customers.
• Designed universes named Accounts Payable, Purchasing and Capital Projects using Oracle 10g/11g, Teradata 13.
• Converted DESKI reports to WEBI reports using Report Conversion Tool as per business users’ needs.
• Met various Business users’ teams and involved in heavy interaction with the Business Analysts in the process of gathering Reporting requirements, preparing specification documents and report writing
• Created many WEBI reports like Balance Sheet, Profit and Loss Statements, G/L Balance, and Statement of Cash flow reports with high complexity which involved multiple data providers, Report level and Block level drill filters, Alerts for conditional output and also created few WEBI reports using Input Controls.
• Converted few existing WEBI reports to Crystal reports to overcome the limitations of output data rows in WEBI.
• Developed Crystal Reports on top of Universes, SAP ECC and Oracle. Implemented row level security in the crystal report using the security table and Current CE User function.
• Scheduled and published WEBI and Crystal Reports using Info view, and trained users on creating reports.
• Developed Xcelsius Dashboards with multiple selector components and Bar/Pie charts for MTD, QTD and YTD data comparison. Used Live Office to import data from necessary WEBI and Crystal reports
• Administered and supervised the Business Objects environment by monitoring/granting permissions and rights to users for viewing, creating and publishing reports and implement Row and object level restrictions
• Migrated all the developed reports from Business Objects development team to test and then test to production using LCM (Life Cycle Manager).

Environment: Business Objects XIR3.1, Teradata 13, Oracle 10g, Universe Designer, WEBI, DESKI, Xcelsius 2011/2008, Live Office, Crystal Reports 2011/2008, SQL server 2008, Publishing Wizard, Windows

Confidential, Kansas City, MO

Business Objects Consultant

Responsibilities:

• Involved in high level discussions with business users, Business Intelligence technical team to understand the requirements needed to setup Business Objects platform at client location
• Responsible for designing and building of Universes with classes, objects and sub classes. Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes.
• Involved in developing Reports using Business Objects XI R3.1.
• Used Live Office and Query as a Web Service (QaaWS) to feed live data into Xcelsius 2008 to show product portfolio
• Primarily responsible for migrating Sybase, Business Objects (6.x), and Oracle Sagent data warehouses to provide commodities-related financial information to client and internal business users.
• Migrated three reporting systems to Business Objects XI and Crystal Reports XI, with SQL Server 2008.
• Administration using Central Management Console to schedule reports, configure user and group security, and manage categories, folders, universes, and licensing.
• Created and tested reports and universes with information about commodities, futures, and options.
• Used PL/SQL Stored Procedures, cursors and functions as input of data into Crystal Reports
• Created reports like Drill Down, Functions, Cross Tab, and Formulae for easy-to-use benefit information system by using Crystal Reports
• Designed Complex reports using sub Reports, cross tabs using Crystal syntax with extensive usage of Local, Global, and Shared variables at report formulas.
• Involved in managing users, groups, folders and published reports using crystal management console, in exporting and scheduling of reports using Crystal Enterprise
• Also installed, tested, and maintained Business Objects XI (including Crystal) client and server software worked on data dictionary objects (tables, structures, match code objects, views, data elements and domains) ABAP/4 tools (Menu painter, Screen painter, debugging tools and Function modules), User exits, and Performance tuning
• Extensive Experience in Object-Oriented ABAP Programming, and Troubleshooting SAP
• Participated in design meetings and code reviews. Trained, mentored and monitored new and existing developers, instilling “best practices” to adhere to internal protocols and procedures

Environment: Business Objects XI R2, Crystal Reports, Crystal Xcelsius, Info View, Sybase, DB2, SQL Server 2008, ABAP/4, Windows NT, UNIX

Confidential, Lexington, Kentucky

Business Objects Consultant

Responsibilities:

• Leaded Reporting projects, working with customer, collecting requirements, analysis, designing, developing and testing of BI projects.
• Designed Business Objects reporting solutions on top of SAP Integration Kit: Web Intelligence, Xcelsius, and Crystal Reports.
• Designed Universes from multiple data providers by creating prompts, queries and applied Contexts and Aliases to remove loops
• Published Crystal Reports in web based environment using Crystal Enterprise.
• Designed and developed Interactive Dashboards using Crystal Xcelsius and developed various visualizations using Menu Components, Gauges and Sliders.
• Extended the Siebel tables through Custom tables and columns and created User keys and Indexes
• Collaborated with key internal and external decision makers to recommend process enhancements, including creation of conversion utility for perfecting Word and Excel files from Excel exports
• Conducted highly successful training programs for end-users.

Environment: Business Objects XI R2, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2, Oracle 10g, Crystal Xcelsius 2008, Seibel7.7, Seibel tools, SQL, PL/SQL, TOAD, Windows

Confidential

Business Analyst/ Crystal Report Developer

Responsibilities:

• Performed Requirements Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements while leading the technical requirements analysis, driving the system design and construction
• Designed and developed software applications using Software Development Life Cycle (SDLC) method and conducted user and business meetings
• Communicated with the Database team and other programmers to guide them with the reports integration to implement Crystal Reports in web based applications
• Used SQL, PL/SQL to develop Views, Stored Procedures and Functions, which in turn were used to create reports
• Full life-cycle development and performance tuning of 54 flawless reports using Business Objects Reporter, Designer, Crystal reports, Supervisor and Broadcast Agent

Environment: MS Office, MS Visio, Windows, SQL, PL/SQL