PROFESSIONAL SUMMARY:

• Over 7 years of experience in software design, analysis and development of Business Intelligence and Data warehousing tools such as Business Objects XIR3/XIR2/6.x/5.x and Informatica PowerCenter 7.1/6.2/6.1/5.1 and PowerMart 6.2/5.1.
• Over 6 years of experience in Business objects XIR3/XIR2/6.x/5.x and different modules such as Desktop Intelligence/DeskI, Web Intelligence/ WebI, WebI Rich client, Infoview, Designer, Central Management Console (CMC)/Supervisor, Central Configuration Manager (CCM), Publishing Wizard, Scheduler/Broadcast Agent, Report Conversion tool and Import Wizard.
• Over 6 years of experience in SAP BW - Data Modeling, Report development and Performance tuning.
• Data Modeling: Experienced with creation and maintenance of Data Source, InfoPackage, InfoObjects, DSO’s, InfoCubes, Transformations, DTP’s and MultiProviders according to the reporting requirements. Building Process chains for Data Load Automation.
• Extraction: Data extraction from R/3 systems (LO) as well as non R/3 systems such as Flat Files, Enhancements of Data Source through Extract Structures. Experience in building Generic Datasources from Table and View.
• Experience in data extractions from Back-end Business Warehouse Component Extractors like LO-Cockpit, CO-PA, and Generic Extractors.
• Bex Reporting: Worked in BEx Analyzer and Query Designer with User Exits for Variables, Formulas, Hierarchy, Calculated and Restricted key figures, Structures, Exceptions aggregators and Conditions.
• Crystal Reports (Designing, Sub-reporting, Cubes, OLAP, Adhoc queries, Drilldown, Cross-tab etc.), Crystal Enterprise Server (Publishing, Scheduling, Creating Users/Groups/Roles, Export/Import, Mailing reports to respective target users in Intranet/Internet), Client/Server and Web application development.
• Designer: created universe connections, defining joins, aliases, context, resolving loops, chasm trap and fan trap, using @ functions, hierarchies, linking universes and aggregate awareness.
• Involved in creating users and groups, scheduling reports, publishing reports, planning security, authentication and single sign-on in for the reports developed using Business Objects XIR3/XIR2.
• Involved in upgrade of BW 3.5 to BI 7.0.
• Over 2 years of experience in Migrating Universes and reports from Business Objects 6.5 to XIR2 and XIR2 to XIR3.
• Over 1 year of Experience in architecture design of Extract, Transform, Load environment using Informatica Power Mart, Power Center 7.1/6.1.
• Exposure in Health Care, Pharmaceutical, Financial, Telecommunication, Production and Sales Data Warehouses.
• Excellent grasp of various methodologies like AGILE, SDLC, RUP, Waterfall.
• Followed the ASAP methodologies for the BW implementation.
• Excellent verbal and communication skills; Team building, Leadership and Project Management Skills.

EDUCATIONAL QUALIFICATION:

• Bachelors in Engineering

TECHNICAL SKILLS:

Technology/ Versions/ Functionalities

Reporting Tools

Business Objects XIR3/XIR2/6.x/5.x, 2008, BEx Analyzer, Crystal Reports, Xcelcius

Data Warehousing tool

SAP BI 7.0, BW 3.5, Informatica 7.1/6.2/6.1/5.1, PowerCenter/PowerMart, Data Integrator 6.5/XI

Designing Tools

Rational Rose, Microsoft Visio, Visual Studio 2005/2008, NetBeans 6.1, Drupal

Data Modeling Tools

Erwin 4.1, UML 2.0, MS Visio

Database Tools

TOAD, SQL*Plus, SQL* Loader

Databases

Oracle11i/10g/9i/8i, MS SQL Server 200/7.0, Teradata v2 r4., Microsoft Access 12/11/10/9.0

Application/Web Servers

IIS, Apache, Websphere

Networking protocols

TCP/IP, SMTP,HTTP

Languages

C, C++, Java, HTML, XML, JSP, JSF, Web Services, Servlets, C#, JavaScript, SQL

Operating systems

Windows 9X/XP, MS-DOS, Unix, Linux

Other

Quick Test Pro, LoadRunner, Clear Quest, Clear Case, Visual Safe

PROFESSIONAL EXPERIENCE:

Confidential,Boston MA Oct’11-present
Role: SAP BO Consultant

• Wellington ManagementCompany is one of the largest private independent investment management companies that provide diversified financial services. The objective of the project was to upgrade and make major revisions to Enterprise Data warehouse. This project is also centered on customer segmentation and aimed to design and build reports from historical summary of customer usage profiles, categorized based on different demographic criteria. Reports were built to facilitate the end user to retrieve detailed customer information, transactions, credit information, and account details and also provide meaningful insights to their customer defection and customer retention studies.

Responsibilities:
Reporting:

• As a Business Objects developer on a team was responsible for creating, maintaining, and migrating over 250 reports, 45 universes, and two different Business Objects versions in multiple environments.
• Interacted with Business Users to understand their Business needs to effectively develop and modify Universes and Reports.
• Migrated Business Objects 6.5 content (users/user groups, Universes, reports) in to Business Objects XI R3 environment using the Import Wizard.
• Created Business Objects Repository, created power users/operational user groups and maintained row level and object level security using Business Objects XICentral Management Console.
• Designed and developed Universes and reports in BO XI R3 according to the user requirements.
• Used Designer to create Universes and resolved join path problems utilizing contexts and Alias Tables.
• Created Prompts, Conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Scheduled Business Objects Documents and Metrics for automatic refresh and to different destinations.
• Extensively used Calculation contexts, Variables, Drill down, Slice and Dice, Breaks, Sections, Ranks and Alerts in the creation of reports.
• Created Analytics and Dashboards using Performance Management tools to enable executives track progress and compare current and historical performance against established targets.
• Developed 50+ Full client and Web Intelligence reports on customer segmentation.
• Created Crystal Reports using Crystal reports formulas, Grouping, Parameters, Selection criteria to handle the customers\' requests from Tables, Views and Command Objects.
• Provided extensive support for users on Web Intelligence, BO XI R3 usage and trained users in understanding the functionalities and capabilities of the software.
• Documented all the changes made to the Universes and Reports for future references.

Environment: Business Objects 6.5/XIR3 (CMS, CMC, CCM, Designer, DeskI, WebI, Performance Manager), Crystal Reports, Supervisor 6.5, Oracle 9i, SQL, UNIX, Apache Tomcat and TOAD.
Confidential,Morgantown, West Virginia Jan’10 – Sep’11
Role: SAP BI/BO Consultant
MYLAN Pharmaceuticals, a subsidiary ofMYLANInc. and is a market leader in researching, developing, manufacturing, marketing and distributinggeneric pharmaceutical productsin a variety of sophisticated dosage forms. The BW Project is to implement Sales & Inventory Modules for their reporting needs.
Responsibilities:
Data Modeling:

• Analyzed the reporting requirements from Users/Business Analysts for Sales, Inventory.
• Redesigned the existing Inventory model by implementing ODS for material movements InfoCube.
• Created generic datasource and loaded the material at storage location data.
• Enhanced sales item extract structure and reloaded the data into corresponding cubes.
• Created start routines, update routines and did look ups on Sales, Purchasing, deliveries ODS.
• Extracted the master and transaction data from R/3 and Flat files as necessary and Monitored loads.
• Built process chains for running daily Full loads to load the material at storage location data.

Reporting:

• Created Business Objects Repository, created power users/operational user groups and maintained row level and object level security using Business Objects XICentral Management Console.
• Managed the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console and CMS.
• Created various Reports by pulling data from Data Warehouse like Sales of Product, By Region wise and reports based on time like Year, Quarter, Month, Week, Geographic location and Comparative.
• Created dashboards in Crystal Reports.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulae etc.
• Created, developed, modified several universes and maintained existing universes.
• Created universes using functionalities such as created universe connections, defining joins, aliases, context, resolving loops, chasm trap and fan trap, using @ functions, hierarchies, linking universes and aggregate awareness.
• Developed and published reports on the web.
• Worked with Business Users on regression testing the Monthly/Quarterly Reports and convey the errors/issues to Developers and get them fixed on tight deadlines.
• Responsible for solving the production support issues with reports.

Environment: SAP BI 7.0, SAP BW, Business Objects XIR3 [CMC, CCM, Designer, Desk I/ Web I, Scheduler, Info view, Import Wizard], Crystal report, Oracle 9i/10g, Teradata SQL Assistant 12.0, Windows XP.
Confidential,Auburn Hills, MI Aug’08 - Dec’09
Role: SAP BI/BO Developer
Volkswagen is one of the world\'s largest producers of passenger cars and Europe\'s largest automaker. And it has different factories in many parts of the world, manufacturing or assembling vehicles for local markets. This project involved in extracting sales and distribution data from BW data model and provides data to Business Objects reporting.
Responsibilities:
Data Modeling:

• Migrated the Sales Overview cube data flow.
• Created necessary Data Transfer Processes (DTP) for the existing targets. Loaded Full & Delta loads from SAP and Non SAP systems and modified the existing process chains as necessary to include the new DTPs in BI 7 environment.
• Created Write-Optimized DataStore for some master data/lookup Datastore Objects (DSOs) and for some staging DSO’s.
• Used Derived tables for complex calculation.

Reporting:

• Worked with Analysis and Design mode toolbars in BEx Analyzer and designed Interfaces for the queries by inserting design items.
• Worked with BEx Analyzer specifically relates to Excel Formula integration and Cross sectional analysis to create Dashboard look in feel in sales reports.
• Worked with Universe designer and created reports using Crystal Reports.
• Worked with BEx Broadcaster to distribute the workbooks.
• Defined various row and column level security for the Business Objects Users.
• Assigned broadcast agent to various groups using WebI Admin Console.
• Created user groups and managed access privileges using Business Objects Supervisor.
• Coordinated with data warehousing team to make sure the data is up to date every day.
• Exported reports into various formats like PDF, HTML, EXCEL, and WORD for user.
• Created technical and functional user documentation.

Environment: SAP BI 7.0, SAP BW 3.5, Bex Analyzer, Crystal Reports, SQL Server 2005.
Confidential,India Sep’06 – July’08
Role: SAP BW/BI Architect Developer
Ugar Sugar Works is the largest sugar manufacturing company in Southern India. The company has been involved in the manufacture of white crystal sugar for over 65 years The Ugar Sugar Works Limited has been successfully operating its 44 MW Cogeneration Power Plant- one of the largest power plant of its type in the country for several years. Business of sugar, sugar ship, distillery & liquor and co-generation at Ugar and sugar & co-generation at Jewargi has been identified as the scope for the SAP implementation.
Responsibilities:

• Reviewing the Functional Specifications and Building Technical Specifications.
• Worked on BEx reporting, Data modeling and Extraction.
• Identifying the availability of Info Objects in SAP BW, Involved in installing the Business content objects and if not available creation of customized Info Objects when required.
• Implemented DSOs, Infocubes, and Multiproviders to support SD, MM, and FI reporting requirements.
• Configured and extracted Purchase Order data from LO Cockpit extractors by making use of the SAP defined DataSources like 2LIS_02_HDR and 2LIS_02_ITM.
• Worked with PSA in Monitoring the Data Transfer from source system to BW system.
• Built reports using Structures and Hierarchies in BEx reports.
• Developed BEx reports using Query Designer and BEx Analyzer by using Restricted Key Figures, Calculated key figures, Filters, Free Characteristics, Conditions, Exception Aggregators.
• Done ABAP coding to create User Exits with variables in BEx report.

Environment: SAP BW 3.5, SAP BI 7.0.
Confidential,India Nov’05 – Aug’06
Roles: Jr. SAP Consultant
Geometric Ltd. is a software services and consulting company and its portfolio includes product development lifecycle, global engineering services and offshore product development solutions and technology.
Responsibilities:

• Maintained different Data Object definitions like Tables, Data Elements and Domains.
• Transfer data from Legacy to SAP using SQL queries.
• Created custom Info sources & Info objects in BW and mapped them with R/3(ECC) fields using transfer rules.
• Data Dictionary Objects such as user-defined tables, Data elements and Data structures were developed.
• Created an interactive report, with a list of customer details in the basic list.
• An interactive report to display Sales Order data was created.
• Worked on sales order user exit MV45AFZZ.
• Supported Users and modified the changes as required.

Environment: SAP BW 3.5, SAP R/3.

Confidential,India May’05- Oct’05
Roles: System Analyst
BSNL provides outstanding Landline and DSL services to their customers. The main objective of the project is to integrate customers of the Landline into the DSL services by developing and maintaining Customer Information.
Responsibilities:

• Extracted data from sources like Oracle, Flat Files and Loaded the data into target Oracle database.
• Analyzing and Design the ETL mappings of all transactions.
• Created mapping of SCD type II – timestamp and versioning mappings to insert new transaction data into the Target and maintain detailed history data for accurate trend analysis.
• Developed complex mappings using a range of transformations on the extracted data according to the Transformation Business Rules and user requirements.
• Created various reports on the tables.
• Used session parameters whenever the same session was to be run using different values.

Environment: Informatica Power center 6.1/5.1, Business Objects XIR3, Oracle 9i, SQL, PLSQL, Windows 2000, ERWIN and UNIX.