SUMMARY

• A self - driven software professional with over 8 years of experience in Data warehousing & Business Intelligence domain.
• Experience in developing DWH & OLAP solutions and extensive use of Databases (Oracle, SQL Server, SAP BW) and SAP Business Objects Enterprise 4.0/BOXI R3.1/R2/ 6.5, Universe Design Tool & Information Design tool, Designer, Desktop Intelligence, Web Intelligence Rich Client, BI Launch pad, Info View, Live Office, Central Management Console, Crystal Reports,Xcelsius,Dashboard Design and QAAWS.
• Experience in Business Explorer (SAP BW 7.X) tools like Query designer, Analyzer.
• Experience in Implementing Business Objects Explorer 4.0 and analysis office tool.
• Experience in BO 4.0 Installation and upgrading from BO 4.0 SP02 to BO 4.0 SP04 and patch installation.
• Experience in Business Objects Administration using CMC.
• Creation/Deletion and managing, groups, users, folders, objects, servers. Security implementation at group and user level. Granting appropriate access rights as per requirements.
• Implemented Security Features of Business Objects like row level, object level to make the data secure.
• Creation/Deletion and managing, groups, users, folders, objects, servers. Security implementation at group and user level. Granting appropriate access rights as per requirements.
• Security Implementation: Using manage restrictions in BO R3/4.0.
• Info view Layout Customization: Setting Info view layout as per user requirements.
• Involved in migration of business objects version 3.1 to Business objects 4.0.
• Hands on using Import wizard for creation of BIAR file and Migration of Reports.
• Experience in providing Business Objects Onsite Support and User Training in Singapore & Netherlands.
• Coordinating with users & understanding business requirements, functional/Business analysis, creating SRS documents and translates business reporting requirements into technical design and solution.
• Worked with Crystal Reports 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.
• Involved in full Life Cycle of a project, which includes Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Experience in SAP Business objects Data services/Data Integrator.
• Experience in Data Extraction, Transformation and Load process (ETL) using SAP Business Objects Data Services and populating the tables in Data ware house and Data marts.
• Excellent Skills in design, creation, and implementation of work flows, data flows, scripts and performing simple and complex transforms in dataflow using different data integrator, platform and data quality transforms.
• Worked extensively on complex mapping in BODS, loading data from various sources into Data Mart with different forms like Query, Table Comparison, Merge, Pivot, Reverse Pivot, Lookup, Key Generation, History Preserving, Date Generation, Map Operation and Validation etc.
• Excellent understanding of Dimensional Data modeling- Star Schema modeling, and Snowflake modeling.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.

TECHNICAL SKILLS

Business Intelligence Tools: BO 4.0/BOXIR3/BOXIR2/6.5,Crystalreports 2008/2011, XCelsius

ETL Tool: Business objects Data Services

RDBMS: Oracle 8i/9i/10g, MS SQL Server 2005/2008

Languages: SQL & PL/SQL

Database: Oracle, SQL server,SAP BW.

Office Productivity: MS-Word, MS-Excel, PowerPoint.

Operating Systems: Windows 2000/2003 Server/XP/ NT/ 98, UNIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential - Van Buren, MI

DW Admin/Developer

Responsibilities:

• Installed & configured Data Services XI 4.0 in Development, QA and Production Server.
• Installed Business objects 4.0 & explorer 4.0 and Patch installation from BO 4.0 SP2 to SP4.
• Creation/Deletion and managing, groups, users, folders, objects, servers. Security implementation at group and user level. Granting appropriate access rights as per requirements.
• Info view Layout Customization: Setting Info view layout as per user requirements.
• Scheduling Reports: Scheduling of reports as per user requirements. Including event based scheduling so as to Atomize complete process.
• Profiling & Publishing: In depth expertise in profiling and publication concepts on BO.
• Setting up alert E-Mail notifications in case of report success or failure.
• Involved in taking weekly backups. Involved in migration from development to production server.
• Involved in installing BO4.0 on Dev, QA and Prod with clustered and standalone environment.
• Extracted data (Delta and Full Load) from heterogeneous source systems such as Oracle, excel, and flat files and loaded the data in to target as SAP BW.
• Implemented different Data Integration Transforms like Table Compression, Merge, SQL Transform, Case, Query, History, Preserving, Reverse Pivot and Pivot Transformations.
• Prepared of TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents.
• Creating users, folders, Categories and groups assigning the access levels.
• Applied security features of Business Objects at row level in the universe to make the sensitive data secure.
• Interacted with the Business users and gathered the business requirements to design and develop Universes & reports.
• Performed analysis, design, develop, testing and Maintenance of Universes.
• Effectively handled setting up the objects as Dimension, Detail or Measure based on business rules.
• Presentation of the advanced features of Business Objects to end-users to enable them to develop reports easily.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters and Alerts for creating Complex Web intelligence reports.
• Created a report called home with all the report names as hyperlinks in the report using Opendoc Function in Web intelligence.
• Generated Web intelligence reports on top of Bex queries.
• Created Different type of Graphs (Bar, line, Pie chart etc) and Cross Tabs with all sorts of formatting for report level analysis.
• Performed data investigations and integrity checks and accountable for testing of Reports before sending to UAT.
• Created User conditions and Filters to improve the report generation. Also, used Alerts to improve the readability of the report.
• Indexing cubes in SAP BW and enabling them for Explorer and creating Information space on top of available cubes.
• Developed complex reports inCrystalReports from multiple data sources like Universes and SQL queries.
• Created complex Crystal reports with standard sub reports, cross-tab reports, formulas, Running totals, Grand totals and calculations.
• Also added sorting, grouping and summarizations to Crystal Reports.
• Developed Dashboards with Dashboard Design components using maps, Pie Charts, Staked Bar, List Views etc. creatively using best dash board components effects for better interaction.
• Used Dashboard to Visualize and to enhance the data presentation along with developing dynamic charts and graphics on top of Universe.
• Developed executive dashboards for the Regional Managers and Finance Directors.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Modified existing reports based on the business user’s requirement changes and successfully pushed them into Production.

Environment: Business objects Data Services XI 4.0,Business Objects Enterprise 4.0 (IDT,UDT,BI Launch Pad, SAP Business Objects Interactive Analysis,SAP Analysis, Explorer 4.0),SAP BI, Business Explorer(SAP BW 7.X),Query designer, Analyzer, Crystal reports 2011, Dashboard Design, Windows Server 2008.

Confidential - St. Louis, MO

DW BI Lead/Developer

Responsibilities:

• Participated in gathering Business Requirements and client Meetings.
• Involved in Installation, Configuration and Deployment of Business Objects Suite.
• Prepared TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents.
• Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.
• Performed analysis, design, develop, testing and Maintenance of Universes.
• Created universe classes, objects (measures, dimensions and details).
• Defined Aliases and Contexts to resolve the join issues in the Universe.
• Solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps.
• Created reports for various Portfolios using the Universes as the main data Providers.
• Implemented various types of joins including equi-joins, outer joins and self-joins on tables in schema.
• Developed reports using various functions, operators, Calculation Contexts, report filters and variables.
• Scheduled the Reports by using trigger file and events.
• Used Business Objects report level properties like Breaks, Rank and Customized filters to display relevant data.
• Created Different type of Graphs (Bar, line, Pie chart etc) and Cross Tabs with all sorts of formatting for report level analysis.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc In Web intelligence.
• Worked with CMC for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Implemented Row & Object level security for different user group requirements.
• Extensive testing and migrating the reports or objects from development to Production system.
• Automated the reports for refreshing the data every month and quarter details.
• Trained user community in basic and advanced Business Objects reporting skills.
• Created Cross-Tab reports based on the user requirement for multidimensional analysis.
• Regularly synchronized the QA, DEV environments with Production reports and Developed, Customized and Implemented reports using Crystal reports.
• Developing Canned Crystal Reports using Business View as the Data source in Crystal.
• Created Running Totals, Formulas and different functionalities like Hyperlinks, Graphs, Charts, and sub reports based on report requirements in Crystal reports.
• Configured the environment, Developed, Scheduled and Tested reports using Crystal reports and Business Objects (Business View Manager, Infoview).
• Developed XCelsius reports using maps, Pie Charts, Staked Bar, List Views etc. creatively using best dash board components effects for better interaction.

Environment: SAPBOXIR2/3.1, Designer, CMC, Desktop Intelligence, Web Intelligence, XCelsius,Crystal Reports2008, Oracle 10g, SQL, Win 2003.

Confidential - New York, NY

Business Objects Developer

Responsibilities:

• Studied the existing business rules and understood the client’s new reporting requirements by interacting with the Business managers and users.
• Involved in BOXIR2 Software installation.
• Design universes and objects by retrieving the data from various data sources and defining the necessary connections.
• Used various join methods like Equi-join, Theta join, Outer-join while creating Universe.
• Created new reports from the scratch for new requirements and modified some of the existing reports in three different Universes.
• Created new Attributes, Filters and Complex measure objects in the Universe.
• Provided support to the Web Users and Full client users for any specific or performance issues related to the reports.
• Resolved Loops, Fan traps and Chasm traps with Aliases and Contexts.
• Creating Measure objects and hierarchies to enable drill down functionality in the reports.
• Created custom LOV’s and Hierarchies for easy user selection drill down purposes.
• Exported the Universe/Reports to the Repository.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Deploying Business objects contents in production environment by Importing BIAR file using Import wizard.
• Worked with multiple Data providers in a report and added slice and dice capabilities.
• Developed Cross-Tab and Drill Down reports.
• Formatted the Reports as per the Users requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Involved in Development of reports using Business Objects in monthly transaction (MTD) and year to date transactions (YTD).
• Extensively used Calculations, Variables, Breaks, Sections, Ranking and Sorted inputs Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Prepared Unit test cases using Quality Center and developed detail design documents for each report.
• Performed the knowledge transfer to other team members, provided application and user on-call support.

Environment: BO XI R2/3.1, Designer, CMC, Desktop Intelligence, Web Intelligence, Oracle 10g, SQL, Win XP.

Confidential

Business Objects Developer

Responsibilities:

• Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.
• Developed Universe as per the Business requirements.
• Resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.
• Used @ functions like @prompt to create user interactive objects.
• Developed and created classes with dimension, detailed and measure object and specified hierarchies.
• Designing Business Objects Universes and reports based on the Specifications.
• Actively worked with the end users in finalizing the Functional Specifications.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces.
• Prepared user documentation for hands on training of end user community.
• Created reports using functionalities like Alerts, filters, break etc.
• Created variables, formulae and detail objects at report level to create new columns based on the result set of the report.
• Designed, developed, maintained and tested universes to supporting ad hoc queries and canned reports.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Developed complex queries using different data providers in the same report and synchronized the data.
• Formatted reports as per the users’ requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Variables, Alerts, Formulas, Calculated data items, Filters, Sorts, and Query prompt and Drill filters.
• Worked with CMC for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Created BIAR file using Import wizard for daily backup.

Environment: BO XI R2, Web Intelligence, Designer, CMC, Info View, Oracle 9i, SQL, PL/SQL, Win XP.