SUMMARY

• 8+years of IT experience which includes functional and technical expertise in SAP BW/BI, SAP BOBJ
• Has good experience in developing Analytic Solutions usingSAPHANA andSAPBusiness Objects toolset like Web Intelligence, IDT, Design Studio,Explorer,Lumiraetc.
• Involved in three full life cycle implementations (including SAP BI 7.0 Netweaver 2004s) from blue - print to Go-Live stages.
• Expertise in BW - Analysis, Configuration, multi-dimensional modeling.
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources.
• Excellent Experience working on Business Objects 4.0,4.1 Releases XI R2/3.1 (CMC, CMS, LCM, Information Designer tool, Business Intelligence Consumer Services (BICS), Universe Design (Unv and Unx), Web Intelligence 4.0, Business Intelligence Web Services (BIWS), Report Conversion Tool, Crystal Reports 2001, Dashboard Design using Xcelsius, Live Office, Query As a Web Service (QaaWS), SAP Business Objects Explorer, Good understanding of BEX.
• Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.
• Extensively converted reports from Xcelsius to Design Studio.
• Worked on SAPNet Weaver 2004sBI (Transformations&Data Transfer Process) and migrating 3.X data sources into BI 7.X.
• Expertise in creating and formatting reports usingMacros, VB Script in BEx, BOBJ Reports and Qlik view reports.
• Developing Xcelsius dashboard using Universe queries and web services; andLumiradata sets for analysis
• Worked onLO Cockpit, General Ledger, FI-AR, FI-AP, Supply & Demand Planning (APO)andGenericExtractions.
• Expertise IN OLTP extractions from SAP R/3 using LO Cockpit, COPA, Generic Extractions and non-SAP extraction.
• Knowledge in SAP HANA modeling and reporting, predictive analytics projects.
• Having strong knowledge on SAP HANALSA Data Modeling using AttributeViews, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT ReplicationServer (SLT).
• Good exposure on Schemas, table definitions,Attributes,Measures & Hierarchies in HANA.
• Developed multiple BOBJ Executive Dashboards and Reports using the latest BOBJ tool (Design Studio).
• Immense experience in solving loops and traps using Contexts and Alias, setting up Custom Hierarchies, Derived Tables, Aggregate Awareness to enhance the performance of SQL
• Generated various reports with Features like Drill down, Alerts, Data Suppressing and Change Highlighting.
• Developed Financial Cockpit (FCC) Dashboard usingSAPLumiraand Xcelsius
• Experience in different kinds of OLTP AND OLAP Systems.
• Knowledge on ETL tools BODI and BODS

TECHNICAL SKILLS

ERP: SAP ECC 6.0, R/3 4.6C/ 4.6B/ 4.5B

Data Warehouse: SAP BW 7.3, BI 7.0, BW 3.5

Languages: ABAP, C, C++, Java, VB

Databases: Oracle, DB2, SQL Server

Operating System: MS-DOS, Windows 95/98/NT/XP/2000/Vista/7, UNIX.

Web Technologies: HTML, ASP, XML and PHP.

Reporting Environment: SAP BEx, Design Studio 1.1/1.2/1.3, WAD, Crystal Reports, Business Objects (BOBJ 4.1, 4.0/3.1/WEBI)

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. SAP BW-BOBJ Consultant

Responsibilities:

• Involved in building reports usingSAPBO 4.0 and integrating BO with BW and HANA
• Implemented various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Installed and configuredBOBJ4.1, BODS 4.1,BOBJExplorer 4.1, BI Mobility 4.1 on Windows platform
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Modified BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Developed WEBI reports on SAP BEx Queries using BICS in Webi Rich client.
• Involved in multiple POC's related to new BOBJ products like Explorer,Lumira& Design Studio,SAPBusiness Objects 4.1 and SAPHANA based BOBJ Reporting.
• Created WEBI reports & Crystal reports and deployed them through BI Launch Pad with BEx as source.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined Conditions to use the Business Objects.
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Created Universe in IDT and connectedSAPLumirato the Universe.
• UtilizedLumirato create visualization dashboards preparing for 2015 AnalyticsMarketing Plans including accountanalysis within various categories and trending information acknowledgement
• Created Dynamic Dashboards using SAP BI data/ BEx Queries. Have Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: SAP BW 7.3, Business Objects 4.1 (CMC, CMS, CCM, Designer, Lumira, Web Intelligence Rich Client, Info View, Import Wizard),SAPW 7.3,SAPHANA1.0 SP7, Sql Server 2005/2008, Oracle 10g/11g and Windows XP, Erwin, UNIX, UML, Dashboard Designer.

Confidential, Atlanta, GA

SAP BI-BOBJ Consultant

Responsibilities:

• Involved in requirement gathering, writing specifications for generation of reports.
• Enhanced Standard DataSources 2LIS 11 VAHDR and 2LIS 13 VDITM to meet the Client Requirements.
• Extensively worked on Open Hub Destination
• Created joins, contexts and Aliases for resolving loops and Universe Tuning and checked the integrity of Universes build against Oracle 11g.
• Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports
• Developed various Ad-hoc reports with complex functions including aggregate aware, @prompt, report level objects, filters and Derived Tables to speed up and fine tune the performance.
• Installed and ConfiguredBOBJ4.0 and configured Windows authentications with SSO
• Created several universes on Oracle and SQL server database.
• Helped admin managed all CMC content including reports, universes, folders, scheduling and Business Objects application and custom access levels.
• Developed reports in Web Intelligence Rich Client using Excel as data provider and exported as WebI documents into the repository.
• CreatedLumiraanalytical views for highermanagementusing multi data sets.
• Extensively converted reports from Xcelsius to Design Studio.
• Created Xcelsius dashboards using charts, bar graphs, selectors, Container, Single Value, Accordion menu and map Components and exported to InfoView.
• Extensively used the Open Document functionality to link master (Summary) and child (Detail) reports.
• Developed Executive Level Reporting Dashboards using Business Objects Xcelsius with Live Data Connectivity and passed parameters to Web Services (QaaWS) in Xcelsius to generate Critical Business Reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, Colours.
• Used Functions like @Prompt, @Select and @Where and also created custom objects, custom prompts and custom hierarchies to meet the reporting requirements.
• Converted Desktop Intelligence reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
• Scheduled several reports to run Daily, Weekly and Monthly as per custom calendars.
• Extensively created and used alerter, rankings, sorts, and drill-down in reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Preparation of Technical design document for reports based on the functional specifications.

Environment: SAP BI 7.0, Business Objects XI 4.0, 4.1 (Designer, Desktop Intelligence, Web Intelligence, Publishing Wizard, Design Studio 1.1/1.2, Xcelsius, LiveOffice, QaaWS), Oracle 10g, SQL Server 2008, SQL Server Management Studio, MS Excel 2007, Toad, Windows XP, Windows Server 2003.

Confidential, Framingham, MA

Sr. Business Objects Developer

Responsibilities:

• Created reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @functions, Cross tab, Chart, Master/Detail, Formulas as per the requirement of the end-user and troubleshooting complex reports, increasing performance of reports.
• Designing, developing and analyzing Reports using Crystal Reports.
• Create complex Web Intelligence Reports against multiple data providers.
• Involving in the administration of Central Management Console (CMC) for implementation of security at Report level, Folder level. Created Users, user groups.
• Involved in creation of Universes, Classes, Objects and Hierarchies for multi-dimensional analysis of database using Business Objects XI 3.1 for technical and sales departments.
• Developing Cross Tab Reports linked Sub Reports and graphs using Crystal Reports.
• Developing formulae using both the crystal syntax and the basic syntax to use in the reports and for reusability.
• Developed reports using drill down and hierarchal grouping functionalities of crystal.
• Exporting reports into various formats like Editable RTF, XML, PDF, HTML, EXCEL, and WORD using Crystal Reports XI for user.
• Wrote several database objects like package, stored procedure, views etc using Oracle PL/SQL.
• Worked closely with Business Systems Analysts (BSA) and business owners to collect and analyze reporting requirements, and profile source systems data to identify data structures anomalies and data definitions inconsistencies.

Environment: SAPBusiness Objects 4.0/ XI 3.1, IDT, Universe Designer, Management Console,SAPBW/BI 7.0, IBM DB2,SAPECC 6.0,SAPNetweaver, SQL server-2008, Windows 2007 server.

Confidential, San Francisco, CA

SAP BI Consultant

Responsibilities:

• Conducted User Requirements, gathering Workshops and interacted with the Management and Business Users to identify Business Requirements.
• Extensively involved in Designing KPI reports for SD, MM and FI-CO.
• Involved in the development of BW data models including DataSources, InfoPackages, Transformations, Data Transfer Processes (DTPs), DataStore Objects (DSOs), InfoCubes and Routines (Start, End, Field).
• Customized and maintained Datasources such as 2LIS 13 VDITM, 2LIS 11 VAITM, 2LIS 02 ITM
• Extensively worked on start routine and end routines.
• Activated the business content for FI AR & GL, SD Sales and Billing & Product Costing.
• Worked on BEx Query Designer, BEx analyzer.
• Involved in automation of the broadcasting process of the reports for several users.
• Created BWA Indexes on the huge volume Cubes to improve the reporting performance.
• UsedSAPBusiness Objects Data Integrator for ETL extraction, transformation and loading data from heterogeneous source system.
• Created single or multi line chart for showing tendency over a period of time particularly used in revenue history using Dashboard Designer.
• Created interactive reports using different types of selectors with dynamic visibility and alert features.
• Created Derived tables in the designer to achieve customized requirements of the Universe.
• Create classes and user objects in designing universes and defining aliases and contexts to resolve loops in the universe.
• Involved in Process chain Design, Scheduling, Monitoring and Support.

Environment: SAPBusiness Objects XI 3.1, Xcelsius 2008, oracle 11G,SAPRapid Marts, SQL server-2008, MS Access 2000, Windows 2003 server/XP.

Confidential, Ardmore, PA

SAP BI-BOBJ Consultant

Responsibilities

• Involved in defining the scope and defining business rules of the project. Also involved in gathering business requirements, documented them textually or within models.
• Interview business owners and external vendors to understand and document expected outcomes of sessions.
• Increase management’s access to day-to-day and summary level information to assist in the evaluation and understanding of the risk and opportunities within the business.
• Conduct workflow, process diagram and GAP analysis to derive requirements for existing systems enhancements.
• Worked closely with the project managers to monitor progress, and the deliverables for the project.
• Created Dashboards for senior management for business decision-making.
• Customized and maintained Datasources such as Delivery Item (2LIS 12 VCITM) and Sales Document Schedule Line (2LIS 11 VASCL) for the SD module and Purchasing Order Item (2LIS 02 ITM) for MM.
• Enabled drill down functionality in Dashboards from one component to another component.
• Created and maintained DTPs and transformations for FIGL, AR, COPA, Sales and AP cubes.
• Responsible for creating Analytics, Metrics, Corporate Dashboards and applied the alerts, rules using Dashboard Manager, these Dashboards will provide users a top-level view of key metrics and the ability to drill down from any metric to the operational detail.
• Created Dashboards in Xcelsius using Qaaws and Excel as Data providers.
• Extensively worked on start routine, expert routine and end routines.
• Analyzed data from Clarity and developed reports for management.
• Responsible for documenting the whole process.

Environment: SAP BI 7.0, Business Objects XI R3.1, Crystal Professional XI R2,Xcelsius2008,Clarity Systems, SQL Server 2000/2005, Oracle 10g/9i, PL/SQL, Window 2003 Server/XP

Confidential

SAP BW Developer

Responsibilities:

• Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
• Converted business requirements to technical requirement documents.
• Performed GAP Analysis to determine the need for developing custom extractors and custom model.
• Enhanced Data source to add custom fields for 2LIS 11 VAITM, 2LIS 11 VAHDR.
• Designed and created Info cubes, ODS and Info source to extract data from SD in to BW.
• Created transfer rules and update rules.
• Uploaded master and transactional data from source system R/3 and Flat File.
• Activated Business Content Info Sources, Info Cubes, Roles, Queries, and Info Objects.
• Re-developing and re-design the Data Models, BW Cubes, ODSs, BEx queries in the BW system.
• Joined Customer Master Tables(R/3) in BW (Info Objects and ODS) using Info Set.
• Created Tab and Role Menu Interfaces for the end-users.
• Daily Data load Monitoring of the BW jobs. Ensuring daily data uploads from R/3 to BW is successful, mail notification on status of upload.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition.

Environment: SAP BW 3.5, SAP R/3 5.0, Windows XP