SUMMARY

• Having 7 years of IT experience in S/W development using SAP Business Objects XI 4.0, XI R3, XIR2/R1, 6.5 and Informatica.
• Working on SAP BO XI R3, Qwaas, Universe builder, Report conversion, importing from Crystal reports to SAP BO.
• Have knowledge on SAP BO XI 4.0, how to access data from SAP HANA servers, SAP ERP, ORACLE Essbase 11.x, SAP BW.
• In BO 6.5 - Reporting, Web Intelligence(Web I),BO Auditor, WebI SDK, Supervisor, Designer, BCA(Doc Agent/Publisher), Info view, ZABO
• Experience in retrieving data from Business Objects Universes, Personal Data Files, Stored Procedures and Free Hand SQL.
• Extensively created Business Objects Universes and Reports using the Designer and Reporting Modules.
• Designing the universe by 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 for convenience
• Proficient in using different databases like Oracle11g/10g/9i/8i, and MS Access 2000
• Thorough experience in using Central Management Console (CMC)
• Migrated Objects, Documents and universes from Business Objects 6.5 to Business Objects XI Enterprise
• Involved in scheduling and publishing report to BO repository
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems
• Extensive knowledge of Informatica client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.
• Expertise in working and implementation of crystal decisions, crystal reports 9.0/10/XI R2/crystal Xcelcius
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, analysis reports, data reports along with LOV.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Crystal Reports, Web Reports, WEBI, Xcelcius and Dash Boards.
• Self-motivated and dedicated fast learner with good communication and interpersonal skills.

TECHNICAL SKILLS

SAP Tools: SAP BO XI 4.0, SAP BW 3.x

Reporting Tools: Crystal Reports XI, Cognos Report Net, SSRS

Business Objects Tools: Business Objects XI 3.1/3.0, XI R1/R2, 6.5, Web Intelligence XI 3.1/3.0/XI R2, Universe Designer XI 3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion ToolData Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services (QaaWS), Live Office.

Databases: Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS AccessTeradata

Data Warehousing: Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.

Operating Systems: Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95DOS, UNIX.

Programming Languages: SQL, PL/SQL, JAVA, HTML, C, C++, C#, .NET

Dimensional Data Modeling Tools: Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2 ), Physical & Logical Data ModelingMultidimensional modeling, Snowflake Schema/ Star Schema modeling, Erwin, Visio.

Query Tools: TOAD, SQL*PLUS, SQL*Loader, SQLNavigator.

Testing tools: WinRunner, Load Runner, Test Director, Manual Testing

PROFESSIONAL EXPERIENCE

Confidential, MI

Business Objects Consultant

Environment: SAP BO XIR3,SAP BO 4.0,Crystal Reports XI, TOAD, ORACLE 11i

Responsibilities:

• Involved in designing new universes as per the business requirement and defining the universe connections
• Involved in universe designing by adding classes, dimension objects, measure objects and creating the joins between the tables, checking the cardinalities, creating universe level filters by using designer module in Business Objects XIR3
• Detected the loops and added aliases, contexts to resolve the loops
• Defining Joins by using related tables in the universe structure
• Maintained cardinalities to the related tables
• Created Classes, Dimensional and Measure Objects for Universe
• Created various reports on Bex cubes and Bex queries using WEBI
• Created reusable structures, Restricted Key Figures, Formulas and BEx Reports and published in Web for Good Year Daily Sales, Preventive Maintenance, Service Sales, Daily Feed, Consumer Tire Retail report for different brands Good Year/Dunlop/Kelly Tires
• Created prompts for restricting data access
• Testing universe by using the Check Integrity
• Designing the dashboards for business analysis in Xcelcius
• Created various reports like Slice & Dice, Master Detailed and Break
• Created various reports by using Alerts and Rank
• Generated various reports by using Charts
• Modify report content and export reports in multiple formats based on user input in Crystal XI.
• For report generation in Crystal Reports Bex query, Universe, Web Services(jreports), XML, ODBC as data sources
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting.
• Used Cross-tab expert to generate aggregate (SUM, Count, MAX, MIN) functions for a field or a column.
• Exported Reports into PDF, Excel, word & RTF from Enterprise
• Developed Reports using Sub reports and Sub report Links.
• Created complex report using with Sub reports, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Scheduled the Crystal reports & E-mail them to the necessary departments through Info view.
• Converted the reports into different formats like Excel, PDF and HTML based on the user’s requirement using Business Objects.
• Worked extensively with the different functionalities of BO like Breaks, Alerter, Filters, Sorts, and Query Prompts.
• Reports created, deployed through Infoview and scheduled reports

Confidential, MI

Business Object Consultant

Environment: Business Objects XI R3, Oracle 11i, SQL, PL/SQL

Responsibilities:

• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies
• Created derived tables in Universe
• Extensively used Designer to design various universes for different business groups
• Created Classes, Measure Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators
• Exported the universes to the Repository to make resources available to the users
• Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.
• Responsible for asserting data needs data analysis, data extraction, report maintenance and design.
• Responsible for report development, report testing and report implementation for Performance Measurement.
• Created Crystal Xcelsius documents, prepared dashboards and presentations (for external users).
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
• Created Joins, Contexts, and Aliases for resolving Loops and Universe Tuning and checked the Integrity of the Universes.
• Worked with different data sources and when the need arises had to combine data from different sources to generate a single report
• Created Daily, Weekly, Biweekly and Monthly reports
• Created complex variables, multiple breaks, sorts in the reports
• Aided in setting up Multi-Dimensional Analysis, the Slice/Dice & Drill using the Hierarchies Editor
• Formulated Data to appear in Master-Detail, Cross-Tab Reports
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• Published Documents on the World Wide Web for access to authenticated users via Info View
• Responsible for analyzing business requirements and developing queries and reports using BO full client and other web development tools like info view to provide Web-enabled data analysis solutions to business clients

Confidential, MI

Report Developer

Environment: Business Objects XI R2/6.5, Crystal Reports XI

Responsibilities:

• Created different types of reports like Master/Detail, Cross Tab and Chart
• Designing and implementation of Universe using the designer module
• Construct complex SQL queries with sub-queries as per the functional needs in the Business Requirements Document (BRD).
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
• Created customized existing reports using sub-reports and charts to present information.
• Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Wrote formulas to calculate the group summaries based on the group levels in Crystal Reports.
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the data in Crystal Reports.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Creation of reports like, reports by product, reports by supplier, reports by period.
• Working with database connections like SQL Joins, Cardinalities, Loops, Aliases, Views, parsing of objects and hierarchies
• Creation of various reports by applying filter, conditions, calculations etc.,

Confidential, OH

Report Developer

Environment: Crystal Reports XI, Business Objects Enterprise XI R2/6.5, Oracle 11i, DB2 UDB, Java, Windows NT/2000, Microsoft.Net, IIS & JSP

Responsibilities:

• Designed and developed reports using Crystal Reports XI version.
• Designed and developed cross tab reports, reports with sub-reports (linked and unlinked) and chart reports. Reports were based on a command object. Wrote several SQL queries to accomplish the task.
• Created Crystal Reports using Crystal Reports formulas, Grouping, Parameters, Selection criteria to handle the customer's requests from Tables, Stored Procedures, Views and Command Objects.
• Extensively worked on reports that contained several Static and Dynamic prompts.
• Set filters, suppression formulae and used highlighting expert to show the data the users would like to see in a more concise and presentable format.
• Deployed and managed reports with the aid of Crystal Management Console.
• Exported the reports into various formats such as Excel (including data only, Excel export), PDF, text and XML formats.
• Assisted the team working on the scheduling the reports via AutoSys.
• Converted Access reports to Crystal Reports XI version.
• Developed various charts and graphs like Bar chart (side-by-side, stacked), line graphs, Gantt Chart etc by using Chart Expert using Crystal Reports XI.
• Generated report for web-based query using Business Objects Enterprise XI.
• Used Central Management Console for deploying and managing the reports.
• Responsible for giving user access and setting restrictions to view the reports.

Confidential, OH

Report Developer

Environment: ORACLE 9i, Win, Business Objects6.5, Crystal Reports 10

Responsibilities:

• Designed standard reports and cross-tab reports according to the specifications using Crystal Reports 9.0.
• Responsible for Upgrading Reports from Crystal 8.5 to Crystal Reports 9.
• Created linked and unlinked Sub Reports to create applicants experience/qualifications reports.
• Published reports on the web using Crystal Enterprise 9.0 and Crystal Reports 9.0.
• Extensively involved in writing various formulas for calculations and combining the data.
• Created various charts using the Chart Expert in Crystal Reports 9.
• Involved in generating the reports in PDF and Excel Formats depending on the user requirements.
• Ad-hoc reports used in Business Objects modules from various User Profiles using the universes as central data providers
• Generating complex reports by building multiple queries
• Scheduling the reports to end-user as required in hourly, daily, weekly and monthly
• Generating the reports by using BO functionalities like combined queries, Slice and Dice, Drill down, Cross tab, Master/Detail reports and formula

Confidential, CT

Report Developer

Environment: ORACLE 9i, Business Objects6.5, Crystal Reports 10

Responsibilities:

• Generated reports using Business Objects
• Producing various reports as per the requests of client
• Created different types of reports like Master/Detail, Cross Tab and Chart
• Created reports using universe as data provider.
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports
• Good at using shared and global variables across crystal reports
• Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, aging reports)
• Deployed reports on the web using Crystal publishing wizard and scheduled reports using e-Portfolio and Crystal management console
• Extensive knowledge in pre defined functions like string, date, numeric, conversion and null functions of Crystal like isnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweek etc.
• Expert in writing complex formulae at the summary level and group level to implement the business logic
• Developed various charts and graphs like bar chart (side by side, stacked), line graphs, pie -charts etc. by using chart expert of Crystal Reports.
• Based on the users requirement, created parameter driven reports to restrict the volume of data.

Confidential, CA

ETL CONSULTANT

Environment: Informatica Power Center8.1, Business Objects6.5, Web Intelligence, Info view, and Oracle9i/8i

Responsibilities:

• Analyzed business requirements for ETL
• Worked closely with business analysts to understand the business needs for decision support data
• Prepared business-mapping requirements
• Developed end-to-end ETL processes for Trade Management Data Mart
• Leveraged Informatica to extract data from heterogeneous source systems and aggregate the data and load into the target warehouse
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Aggregator, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers
• Performed extensive analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized City Data from various sources
• Imported various heterogeneous and homogenous sources using Informatica PowerCenter6.2 Source Analyzer
• Developed various transformations using the Transformation Developer in the Informatica Power Center Designer
• Created various reusable transformations in designer such as Time Dimension using Informatica Power Center Mapplet Designer
• Extensively worked on Confirmed Dimensions for the purpose of incremental loading of the target database
• Tuned the Session Parameters to increase the efficiency of the sessions in Workflow Manager
• Tuning of the mappings and scripts for a better response
• Implemented Materialized view for persistent data and for faster processing
• Created and Maintained Universes using Business Objects Designer
• Developed various reports in Business Objects that have drill down capabilities
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Modifications, additions, deletion of user profiles in the supervisor module in Business Objects
• Helped in maintenance work related to reports
• Generated Ad-hoc reports as requested by the team lead using Business Objects free hand SQL

Confidential, CA

ETL CONSULTANT

Environment: Informatica 8.1

Responsibilities:

• Involved in development of Informatica mappings and also tuned for better performance.
• Administered the Informatica repository by creating and managing user profiles and metadata
• Created Informatica mappings with stored procedures to build business rules to load data.
• Various transformations (Source qualifier, Aggregators, Connected &unconnected lookups, Filters &Sequence) were used to handle situations depending upon the requirement
• Called stored procedures perform database operations on post-session and pre-session commands
• Created partitions to concurrently load the data in to sources
• Loaded bad data using reject loader utility
• Performed Unit Testing and tuned for better performance.