SUMMARY

• A self - driven software professional with a strong foundation in Data warehousing & Business Intelligence domain with 8+ years of experience in IT industry.
• Association 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, Central Management Console, Crystal Reports 2011,Dashboard Design.
• Experience in Business Intelligence solutions in developing SAP Business objects Data services/Data Integrator and Data Quality Tools.
• Worked with different versions of Xcelsius 2008 & Dashboard Design to create visualizations/Dashboards.
• Designed and developed dashboards using Xcelsius by scheduling the Web Intelligence reports using Live Office.
• Expertise in working and implementation of Crystal Reports 2008 and 2011.
• 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.
• Experience in Implementing Business Objects & Explorer 4.0
• Experience in Business Explorer (SAP BW 7.X) tools like Query designer, Analyzer.
• Experience in SAP Business objects analysis office tool.
• Developed and supported in Extraction, Transformation and Load process (ETL) using SAP Business Objects Data Services to populate 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.
• Expert-level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Expertise in implementing Data Cleansing, Data Profiling, Transformation Scripts, Stored Procedures/Triggers and necessary Test plans to ensure the successful execution of the data loading processes.
• Worked extensively on complex mapping in BODS in 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.
• Hands on experience of Recovery Mechanism for unsuccessful batch jobs execution.
• Experience in debugging execution errors using Data Integrator logs (trace, statistics, and error) and by examining the target data.
• Extensively used Data Services Management Console to schedule and execute jobs, Manage repositories and perform metadata reporting.
• Experience in creating and administering the metadata Data Integrator repository in a multi user environment.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Indexing cubes in SAP BW and enabling them for Explorer.
• Experience in Implementing Business Objects 4.0 (Linux platform) on a clustered and standalone environment, FRS migration, performance optimization, LDAP configuration.
• Experience in upgrading from BO 4.0 SP02 to BO 4.0 SP04 and patch installation.
• Experience in Business Objects Administration using CMC.
• Hands on using Import wizard for creation of BIAR file and Migration of Reports.
• Proficient knowledge on Business Objects Architecture and new features.
• Involved in Providing Onsite Support Given for Elsevier Project in Amsterdam.
• Experience in providing Training on Business Objects to Users in Singapore.
• Strong Knowledge in DW Concepts.
• Coordinating with users & understanding business requirements, functional/Business analysis and translates business reporting requirements into technical design and solution.
• Experience in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @ Aggregate aware function.
• Implemented Security Features of Business Objects like row level, object level to make the data secure.
• Expertise in databases like ORACLE8i/9i/10g, SQLserver2005.
• Being a key project player, observed a full Life Cycle of a project, which included Requirement Analysis, Planning, Designing, Development, Test and Roll-Out / Go Live.
• Used a variety of data sources for reporting: Universe and free hand SQL.
• Migration of reports as well as Universes from one environment to other environment Using Import Wizard.
• Excellent understanding of Dimensional Data modeling- Star Schema modeling, and Snowflake modeling.

TECHNICAL SKILLS

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

ETL Tool: Business objects Data Services

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

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.

PROFESSIONAL EXPERIENCE

Confidential - Van Buren, MI

DW BI Lead/Developer

Responsibilities:

• Installed & configured Data Services XI 4.0 in Development & Production Server.
• Here we are extracting the data from heterogeneous source systems such as Oracle, excel, and flat files.
• We created different jobs for the different source system.
• We implemented a data model for converting the local currency and USD currency in to a single record.
• We implemented a Delta and Full load at the time of loading the data from different source system data.
• We implemented different Data Integration Transforms like Table Compression, Merge, SQL Transform, Case, Query, History, Preserving, Reverse Pivot and Pivot Transformations.
• Finally we load the data in to target as BW Target.
• We created an RFC connection in SAP System.
• Created a Data store type as BW TARGET and imported the Tables from SAP BW SYSTEM.
• Implemented the Performance tuning techniques to optimize the Load time.
• Configured the Central Repository to maintain the Versions.
• Scheduled the Batch Jobs by using the Management Console.
• Involved in creating the Documents like Unit test case and Execution Process documents.
• Involved in installing BO4.0 on Dev, QA and Prod with clustered and standalone environment.
• Exposure to security implementation
• Patch installation from BO 4.0 SP2 to SP4.
• Interacted with end users regularly for requirements gathering.
• Involved in installing Business objects 4.0 & explorer 4.0.
• Creating Information spaces on top of SAP BW cubes.
• Implementing SAP authentication
• Performance optimization
• Indexing cubes in SAP BW and enabling them for Explorer.
• Creating Information space on top of available cubes.
• Working with SAP on issue resolution.
• Created the User Groups and Users, Set up the privileges to them according to their requirement.
• Creating users and groups assigning the access levels.
• Creating folders and Categories.
• Involved in leading a team of 3 resources for the conversion.
• Working with the business users to understand the query functionality and create reports.
• Taken care on performance tuning.
• Presentation of the advanced features of Business Objects to end-users to enable them to develop reports easily.
• Involve in Dev & SIT testing.
• Migration of the system to SIT and PROD phase.
• Troubleshooting of problems in SIT and PROD phase (if any).
• Have a constant follow-up whether the defects for each task is been logged on to the defect tracking system.
• Applied security features of Business Objects like row level in the universe so as to make the sensitive data secure.
• Extensively used Calculations, Break points, Drill down, @Functions and Formulas, Filters & 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 and published web reports in Info View using Web intelligence.
• Worked along with the testing team to derive test cases for efficient Data reporting.
• Used Scheduled Based Events for scheduling the reports.
• Developed complex reports inCrystalReports 2011from 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.
• Modified existing reports based on the user’s requirement changes and successfully pushed them into Production.
• 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.
• Worked on building Dashboards on top of universes.
• Developed executive dashboards for the Regional Managers and Finance Directors.

Environment: Business objects Data Services XI 4.0,Business Objects Enterprise 4.0/3.1 (Designer, Web intelligence, Crystal reports 2011, Dashboard Design), SAP Analysis, Explorer 4.0,SAP BI, Business Explorer(SAP BW 7.X),Query designer, Analyzer, Windows Server 2003/2000, Linux.

Confidential - St. Louis, MO

DW BI Lead/Developer

Responsibilities:

• Created universe classes, objects (measures, dimensions and details).
• Involved in Installation, Configuration and Deployment of Business Objects Suite.
• Participated in gathering Business Requirements and client Meetings.
• Migrated Business Objects XI R2 content in to Business Objects XI R3 environment using the Import Wizard.
• Prepared Templates, Rationalized data by analyzing the requirements, prepared documentation.
• Preparing of TS (Technical Specification), UTP (Unit Test Plan) and Release Plan Documents.
• Run import Wizard using BOXI R3 to Move the contents from source to destination.
• Took the backup of the content using BIAR File.
• Created the User Groups and Users, Set up the privileges to them according to their requirement.
• Performed analysis, design, develop, testing and Maintenance of Universes.
• Developing Canned Crystal Reports using Business View as the Data source in Crystal.
• Created initial Classes & Objects, qualification for the Universes.
• 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.
• Extensively Created Derived Tables in the Universe
• Developed reports using various functions, operators, Calculation Contexts, report filters and variables
• Interacted with the Business users and gather the business requirements to design and develop reports
• Created canned and Ad-hoc reports using WebI/Deski Reports
• Scheduled the Reports by using trigger file and events.
• Successfully handled analyzing the Business Strategy based on the client requirement and accountable for testing of Reports before sending to UAT.
• Effectively handled setting up the objects as Dimension, Detail or Measure based on business rules.
• 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.
• Taken care on performance tuning.
• Facility to export reports in PDF and excel formats and can be scheduled to send via e-mail.
• Created User conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Implemented various types of joins including equi-joins, outer joins and self-joins on tables in schema.
• Testing the reports thoroughly before releasing it to production.
• Implemented Row & Object level security for different user group requirements.
• Created the reports using Business Objects functionalities like Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc In Web intelligence.
• 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.
• Creation of Hyperlinks in Reports for Report linking.
• 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).
• Customization of reports as per Client's change requirements.
• Regularly synchronized the QA, DEV environments with Production reports and Developed, Customized and Implemented reports using Crystal reports.
• Reviewing the tasks before sending the final status to clients that is done by team and communicating with clients over the conference call.

Environment: SAPBOXIR2/3.1, Designer, CMC, Desktop Intelligence, Web Intelligence, 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.
• Involved in designing 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.
• Extensively used various techniques Sectioning, Ranking, and Filtering to develop the reports.
• 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.
• Extensive testing and migrating the reports or objects from Test to Production system.
• 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

Consultant

Responsibilities:

• Developed Universe as per the Business requirements.
• Used various joins, when creating the Universe.
• Created Aliases and Contexts for Solving the Join problems in Universe.
• Defined various predefined conditions while creating Universe.
• Used @ functions like @prompt to create user interactive objects.
• Developed and created classes with dimension, detailed and measure object and specified hierarchies.
• Created BIAR file using Import wizard for daily backup.
• Written the test cases according to the requirements.
• 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.
• Resolved loops by creating alias and contexts to remove cyclic dependencies between the tables.
• Responsible for the System Study & Business Requirements Analysis & Documentation.
• Designing Business Objects Universes and reports based on the Specifications.
• Created Universe Classes, Objects, Measure Objects, Conditions, and Joins in the process of building the universes.
• 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 for supporting ad hoc queries and canned reports.
• Created detailed Technical Specifications for each mapping based on these Functional Specs.
• Used Aggregate awareness in universes to speed up the queries.
• 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.
• Involved in-group meetings to analyze business requirements by close interaction with the Users and Business Analyst team.
• Designed the Universe as per the Business requirements using Business Objects.
• Involved in resolving the loops using Contexts and Alias and checked the cardinalities, Integrity of the Universes.
• Formatted reports as per the users’ requirements using all the facilities in Business Objects, which allows the users to analyze the data.
• Worked with supervisor module in creating users and users groups for different areas and setting privileges to them.
• 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.

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