SUMMARY:

• 9+ years of experience, including 3 full life cycle implementation projects, in SAPBOBJ/BI4.1/4.0, XI - R3.1/R2/6.x with Universe Designer (IDT, UDT), Web Intelligence Rich Client (WEBI), Desktop Intelligence (DESKI), Crystal Reports 9/10/11/13, SAP Data Services 3.x/4.x (BODS), Xcelsuis 4.5/2008, Info view/launch Pad, Central Management Console (CMC), Central Configuration management (CCM), Live Office, SAP Promotional manager to Migrate Universes/Reports.
• Specialize in BI Tool selection, requirement gathering, analysis, design, development, and testing architecture analysis of data warehouse, Business Model and Data Mart system. Excellent understanding of relational database concepts and reporting tools.
• 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 complex Crystal/WEBI Reports, using multiple Data sources, includingCross Tab Reports, Top N Reports for highlighting significant data, using Variables, Parameters (Cascading & Inherited), LOVs, summary reports with drill-down capabilities, Charts & Bar reports, 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 Reports, SAP Xcelsuis and Tableau.
• Strong experience in Data Warehousing and ETL using SAP Data Services (BODS)/ SSIS.
• Strong SDLC knowledge including entire life cycle of analysis, design, build, test and deployment.
• Extensive experience in ETL design, development and maintenance using Aginity for Netezza, Oracle SQL, PL/SQL, SQL Loader, Toad for ORALCE and Toad for SQL.
• Strong experience in data modeling using Erwin, Star Schema modeling and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling. Experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in database programming in PL/SQL (Complex Queries, Views, Functions, Stored Procedures and Triggers).
• Extremely diligent, responsible, fast learner, leader, hardworking and detail oriented with strong written and verbal communication.

TECHNICAL SKILLS:

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

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

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

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

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

Operating System: Window, UNIX, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

SAP Business Objects/Business Intelligence/ ETL Developer

Responsibilities:

• Working on extraction, transformation and loading (ETL) data from heterogeneous sources like Excel sheets, Flat files, DataStore using Data Services Designer.
• Worked on setting up Local and Central Repositories and in migration of reusable objects by doing Import
• Export directly, checking in/out of Central Repository and also by generating the ATL files.
• Used various transformations like Table Comparison, Query, SQL, Key Gen, Effective Date, Merge, History Preservation, Case, Map Operation, Hierarchy, Flattening Pivot and Reverse Pivot for staging the data.
• Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data Cleansing and Data Profiling process.
• Created various Local and Global Variables, Parameters to populate default values in the target system.
• Corrected the Time Dimension to accommodate the changes like Fiscal Year/Period/Week using TSQL and also taken care of creating indexes and monitor the query execution plan.
• Created Global variables to read the files from the shared location from the BODS Designer and also worked
• Used Try and Catch mechanism to handle errors and scripts objects, variables and parameters at data flow and work flow level.
• Experience in debugging execution errors using Data Integrator logs (trace, monitor and error) and by analyzing the target data using debug mode.
• Tuned Data Integrator Mappings and Transformations for better performance of jobs in different ways like indexing the source tables and using Data Transfer transformation.
• Performed Job Validation and Syntax checks and to evaluate for errors, execution time and bottlenecks.
• Design a universe on top of database that suffice the reporting requirements and create reportsusing WEBIwith features like Drill, Functions, Prompts, Breaks, Custom Sorts, Conditions, Ranking, Filtering, Master/Detail, Cross tab, Element Linking, Report Linking, Charts like Pie, Bar, Bar with dual axes.
• Write SQL custom queries, create views, functions, to do an analysis of upcoming/PROD data. Also, using SQL as a source in ETL jobs as well as in WEBI reports.

Environment: SAP BusinessObject4.x, Web Intelligence Rich Client (WEBI), SAP Data Services (BODS) 4.x, SQLServer 2012, SSMS 2012, Visual Studio 2013 (TFS), ServiceNow, Oracle 11g.

SAP Business Objects/Business Intelligence/ ETL 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.
• Created On-Demand/Complex reports with Cascading parameters, Formulas, Grouping, cross tabs, charts (Bar Chart, Line, Pie, Stacked), Cascading Parameter, Cascading LOV’ susing Crystal Reports with the source of Universes as well as Custom PL/SQL command (SQL, ORALCE).
• Take a backup of BOBI Server in UNIX environment before, upgraded to 3.1 to 4.1.
• Created a BIAR Files for backup on monthly basis.
• Give users to proper Access/Security/Restriction on Data/Reports.
• 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 and also created dashboard to show In-Details Charge/Payment/Adjustments information on patient level using Tableau.
• Created Information Spaces in Business Object Explorer and Performed Indexing on them.
• Used SQL Server Integration Services (SSIS) for ETL purpose to fulfil vendor’s requirements.
• 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,Tableau 8.1.10, SQL Server 2012/2008, SQL Server Integration Services 2012/2008(SSIS), Oracle 11g, Toad.

SAP Business Objects/Business Intelligence/ ETL 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.
• Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.
• Worked on customization and enhanced the extract structure to support business needs.
• Created Tableau dashboard to represent the high level summary for finance management. (Crosstabs, Charts, Heat Map. Geographical maps, etc.)
• 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, Tableau 7.0, Info view, CMC, SQL Server 2008, T-SQL, Oracle PL/SQL.

SAP Business Objects/Business Intelligence/ ETL Developer

Responsibilities:

• Fulfilled Business Analyst requirements by Completing Universe Development Life Cycle to Prepare, Analyze, Plan, Implement, Test, and Deploy & Maintain to Successfully Develop Universes meeting 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-in functions (like prompt, select, where, and aggregate), complex SQL queries and joins. Thus Considering best business Practices using Web intelligence Rich Client.
• Involved in creation of Reports, formatting reports, generation of charts, bars, etc. as per user requirements usingWebi, Xcelsuis 2008.
• Developed new set of standard Web Intelligence reports against the new universe. Completed ad-hoc data requests as required.
• Used SSIS (Sql Server Integration Services) for ETL extraction, transformation and loading data from heterogeneous source system.
• Developed Charts (Bars, Lines and Pie, make looks like Dashboard), Cross Tab Reports, Sub Reports, Linked Reports, Formulas, and Parameters by using Crystal Reports 2008.
• Worked on certain issues and dealt with Info View, CMC.

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

SAP Business Objects/Business Intelligence/ ETL Developer

Responsibilities:

• Analyzing system functionality requirements, documents and scope of the work.
• Work included Developing, Testing, enhancing existing Business Objects Universes; work required modifying, testing and promoting to the Repository.
• Responsibilities required acting as the Key Person for maintaining Universe's with creation of joins, Cardinalities, Contexts, and solving the loops, Testing and Data analysis.
• Have resolved Loops, Fan Traps and Chasm traps using 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 like Slice and Dice, Drill Down, Cross Tab, Alert and Formula using Web 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 Xcelsuis and connected dashboards to live data sources using web-services.

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