SUMMARY

• Over 7 years of experience in SAP BOBI 4.1/4.0,XI - R3.1/R2/6.x with Universe Designer (IDT, UDT), Web Intelligence, Webi Rich Client, Desktop Intelligence, Crystal Reports 9/10/11/13, Xcelsuis 4.5/2008, SAP Dashboard Designer, Infoview, Central Management Console (CMC), Central Configuration management (CCM), Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Specialize in BI Tool selection, requirement gathering, analysis, design, development, and testing and architecture analysis of data warehouse and data mart system.
• Exclusive Experience in Designing/Developing and update/maintain Universes (IDT & UDT)/Data-Model, Developing Canned/Ad-hoc Reports, Scheduling and processing of reports using CMC.
• Experience in Installation, Administration, Reporting (using Desktop Intelligence & Web Intelligence, Crystal Reports) and Migration from one server to another server (using Promotion Management) of Business Objects.
• Experience in developing Crystal Reports, the Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Design reports where data has been shared across Sub reports.
• Create, maintenance and scheduling of Crystal/WEBI Reports to be printed/saved at regular intervals.
• Technical proficiency in creating interactive dashboards and scorecards using Crystal Xcelsuis and SAP Dashboard Designer.
• Created complex Crystal reports by using different data sources, and also created reports implementing Dynamic and Cascading Parameter and LOVs using BVM (Business View Manager).
• Developed various Charts and Graphs like Bar chart (Side By Side, Stacked), Line graphs, Pie charts, and Numeric Axis etc. by using Chart expert of Crystal Reports.
• Designed different types of SQL Server Integration Services (SSIS) packages to accomplish OLTP data extraction and loading. As well as OLAP cubes/Star, Snow flack schema for Data Warehouse for staging and to create target tables.
• Excellent understanding of relational database concepts and reporting tools.
• Extremely diligent, responsible, fast learner, leader, hardworking and detail oriented with strong written and verbal communication.

TECHNICAL SKILLS

Business Objects: SAP BOBI 4.1/4.0,XI-R3.1/R2/6.x, IDT (Information Design Tool), UDT (Universe Design Tool), SAP Crystal Reports 9/10/11/13, Xcelsuis 4.5/2008, SAP Dashboard Design Studio, SAP Explorer, Crystal Enterprise XI 9/10/11, Infoview, CMC (Central Management Console), Central Configuration Management (CCM), Live Office.

ETL Tools: Data Services, Informatica, SSIS (Sql Server Integration Services)

Database: Oracle 11g/10g/9i, SQL Server 2012/2008/2005 , MySQL, MS Access

Project Management Tool: Liquid Planner, Remedy, MS Word, MS Excel, MS Outlook, MS One Note

Application/Web Servers: 3M, Siemens (PA & PM), Clinical HCI (McK), QeM, STAR (ADT), Tomcat, Apache, IIS

Operating System: Window, UNIX, Linux.

PROFESSIONAL EXPERIENCE

SAP Business Objects/Crystal Reports Developer

Responsibilities:

• Gathering user requirements and analyze the ICD 9 Coding Reports/Data Extract and convert then to ICD 10 Codes (tested in Test environment) and Prepare Work Bench Structure (WBS).
• Modified exiting Universe (UDT) and implemented new Universes (IDT) according to the reporting needs, by creating LOVs, detecting Cardinalities, Resolving Traps (Chasm, Fan) and using Contexts, also developed Hierarchies and Derived Tables.
• Modified the existing universe for performance tuning and maintained common dimensions across all the universe with unique naming as a part of clean up activity.
• Worked extensively with @function (i.e. @select, @prompt, where, @aggregate aware) to create Universe Objects (Dimension, Measure or Details).
• Create a WEBI (Web Intelligence) using Universe as of source and Crystal Reports using Universes and custom PL/SQL (SQL, ORALCE) Command.
• Created a Complex WEBI reports with multiple queries, custom sql, using complex function, merging dimensions at report level, drill down, drill up, drill across, complex filter etc. Also, scheduled them on Infoview/CMC to run on frequent basis, based on the requirements.
• Create Sub reports called/linked from the main report to implement the business logic by using Crystal Reports.
• Created a Custom Crystal Reports that reflect the information on NJ State’s DSRIP program requirement.
• Created On-Demand/Complex reports with Cascading parameters, Formulas, Grouping, cross tabs, charts (Bar Chart, Line, Pie, Stacked), Cascading Parameter, Cascading LOV’s using Crystal Reports with the source of Universes as well as Custom PL/SQL command (SQL, ORALCE).
• Publish the Crystal Reports on repository to run on Demand/Frequent basis, based on the requirements.
• Created and Maintained Users, folders, scheduled and published reports to Crystal Management Console. Monitored failed reports. Exported reports in Excel, PDF and saved on Shared Network drive, E-mailed to users as per the requirements.
• Created a Dashboard to reflect the patient’s flow from one system to another using SAP Explorer and created Dashboard to show In-Details Charge/Payment/Adjustments information on patient level using SAP Dashboard Design Studio.
• Created Information Spaces in Business Object Explorer and Performed Indexing on them.
• Created a Sequence Container, Control Flow, Data Flow, Script Component, Email Task, For Loop, For Each Loop, Fuzzy Lookup, Variables, Data Conversion, Derived Columns, Merge Join, Multitask, Flat files Destination (with different Delimited), Excel Destination and OLE DB Destination in SSIS (SQL Server Integration Services) packages using multiple Data source, and generate reports and setup scheduling email/scheduling to send the output file to user based on the requirement.
• Created a Schedule Job for SSIS packages and set up an Alert on Job activity monitor.
• Worked on SQL Querying, Tuning and Optimization of reports custom command in SQL and ORALCE.

Environment: SAP Business Object 4.1/4.0,SAP Crystal Reports 2013/2011, SQL Server 2012/2008, SQL Server Integration Services 2012/2008(SSIS), Oracle 11g, Toad.

Confidential, Livonia, MI

SAP Business Object/Crystal Report Developer

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Experience in creating universes using information design tool 4.0 and also connecting to multiple data sources.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created new universes based on the reporting needs, by resolving Traps, Loops using Context.
• Also, Developed Hierarchies and Derived tables in new universes based on the reporting needs.
• Created custom List of Values (LOVs) for better understanding of prompts by the end users.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alert, inserted calculations, Filters, Sorts.
• Schedule the WEBI/Crystal Reports on Infoview and also, maintain default setting on CMC.
• Created standard reports, Cross-tab, Sub reports, Drill down reports, on demand sub reports, variables (Global & Local), Formula, Running Totals, Conditional Formats, Cascading parameters, cascading LOV’s using Crystal reports.
• Used custom SQL & ORALCE PL/SQL Query command to create Complex Crystal Reports using Crystal reports.

Environment: Business Objects 4.0(IDT), Crystal Reports XI 2011, Infoview, CMC, SQL Server 2008, T-SQL, Oracle PL/SQL.

Confidential, IL

SAP Business Object/Crystal Report Developer

Responsibilities:

• FulfilledBusiness Analystrequirements by CompletingUniverseDevelopmentLife Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universesmeeting User Needs and Requirements from both technical and strategic views of an organization.
• Implemented Universes by detecting Cardinalities, resolving loops, Chasm Traps and Fan Traps using Contexts and Aliases etc., and also Developed Hierarchies to support users with the option to drill down on reports. Also implemented User Security.
• Designed complex reports based on discussions with user groups and created various objects using built-infunctions (like prompt, select, where, and aggregate),complexSQL queriesand joins. Thus Considering best business Practices usingWeb intelligence Rich Client.
• Involved increation of Reports, formatting reports, generation of charts, bars, etc. as per user requirements using Webi, Xcelsius 2008.
• Developed new set of standardWeb Intelligencereports against the new universe. Completed ad-hoc data requests as required.
• UsedSSIS (Sql Server Integration Services) for ETL extraction, transformation and loading datafrom heterogeneous source system.
• Developed Charts (Bars, Lines and Pie, make looks like Dashboard), Cross Tab Reports, Sub Reports, Linked Reports, Formulas, and Parameters by usingCrystal Reports2008.
• Worked on certain issues and dealt withInfo View, CMC.

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, T-SQL, SSIS, InfoView, CMC.

Confidential, NYC, NY

SAP Business Object/Crystal Report Developer

Responsibilities:

• Analyzingsystem functionality requirements, documents and scope of the work.
• Work included Developing, Testing, enhancing existingBusiness Objects Universes; work required modifying, testing and promoting to the Repository.
• Responsibilities required acting as the Key Person for maintainingUniverse's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing and Data analysis.
• Have resolvedLoops, Fan Traps and Chasm trapsusing context and alias and also have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Created reports using Business Objects functionalities likeSlice and Dice, Drill Down, Cross Tab, Alert and Formula usingWeb intelligence.
• Developed, Tested, Promoted and Maintained the WEBI Reports, also had modified the existing reports based on user requirements and also, schedule them on the Server to run on frequency basis.
• Created complex reports using, Formula, Running Total, Variables (local, global), Sub Report, Run on Demand Report, multiple grouping, conditional formatting, providing cascading dynamic parameter prompts and enhanced visualization and Interactive sorting using Crystal Reports 2008.
• Developed dashboards and data visualizations using Crystal Xcelsius and connected dashboards to live data sources using web-services.

Environment: SAP Business Objects 3.1,Crystal Reports 2008, Crystal Xcelsius 2008, SQL Server 2008, MS Access 2003,SQL T-SQL.

Confidential, Delray Beach, FL

SAP Business Object/ Crystal Reports Developer

Responsibilities:

• Identified and defined Universe structure required by business users to build the reporting application.
• Developed Universe objects and report mappings for Reports, Modified the universe, created classes and objects by retrieving the data from various data sources.
• Worked extensively with @functions like (@select, @prompt, @where @aggregate aware) to write flexible SQL queries.
• Created predefined conditions, prompts and custom hierarchies in the process of building the universes.
• Created Crystal Reports with multiple Formula, Grouping, Running Total, Summary based on the Grouping, Static & Dynamic Parameter, Sub Report, linked Reports, Run on Demand Reports.
• Created standard Desktop Intelligence and Web Intelligence reports, using Breaks, Alerts, Rank, Sections and also used Highlighted conditional formatting.

Environment: SAP Business Objects XIR2/6.5 Universe Designer, Inforview, Central Management Console, SQL Server 2005, TOAD for SQL, Window XP.