SUMMARY

• Result oriented SAP BI professional with 8 years of progressive experience working in various Domains - Pharmaceuticals, Manufacturing, Retail and Telecommunications
• Exceptional record of delivering effective, high performance technology solutions to meet challenging business demands.
• Full Life cycle implementation experience in SAP BW implementation - Modeling, Configuration, Extraction and reporting
• SAP BPC 7.5 Net weaver implementation - Create Dimensions, Properties, Appsets and Reports for planning
• Configure data manager extraction from ECC and BI system for the actual, plan data
• Expertise in Business Warehouse Components - Info Objects, Standard and Custom Info Cubes, DSO’s and Extractors, Info packages, DTP’s and transformations
• Expertise in translating Business needs into end-user Reports with Business Intelligence Tools like Business Objects Xi R3/R2, Crystal Reports and Crystal Enterprise.
• Extensively worked on customizing CRM data Sources.
• Experience in data modeling, enhancements, bug fixing in data extraction and reporting in Supply Chain and APO Demand Planning functional areas.
• Extensive Working knowledge in performance tuning techniques which involving- evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Proficient in interpreting and writing complex ABAP routines and translating business needs into Data Modeling and Reporting Solutions.
• Experience in Analysis Process Designs (APD), Real Time Data Acquisition.
• Designed Complex and Ad-Hoc queries in BEx Query Designer and created work books using BEx Analyzer using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures
• Working Knowledge on Business objects- universe design, Desktop Intelligence, Web Intelligence, Business View Manager, Info view, CMC
• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer
• Updated the static models with live data connecting via Web Service connectors-QAAWS, Live Office
• Working knowledge of ASAP Methodology
• Conducted training for end-users, Developed business process documentation
• Strong planner and organizer with demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability
• Created charts and Dashboards for flash reports, reports based on SD, AP and AR.
• Included in End User training in navigating reports, post go live maintenance, web application, and designer portal.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, C, C++, Java2.0, JDBC, JSP

Reporting Tools: Crystal Reports XI/10/9.0, Crystal Enterprise XI/10.0, Business Objects (6.5.1/BOXIR3/R2)

Tools: MS Office, MS Outlook, MS Access, MS Project

Databases: Oracle 11g/10g / 9i / 8i, Microsoft SQL Server, Teradata v12.0/13.0

SAP Proficiencies: SAP BO, SAP R/3, SAP ECC 6.0 SAP BW 3.5, BI 7.0

Operating Systems: Windows NT/2000/XP/2003, UNIX

Web Technologies: HTML, DHTML, XML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, VA

BOXI Crystal Reports Developer / Admin

Environment: SQL Server 2005/2008, SQL, T-SQL, SQR, Teradata, Crystal Reports XI, Business Objects XI R3/R2 (Import Wizard, Report Conversion Tool, Data Source Migration Wizard, Central Management Console (CMC), Crystal SDK, Xcelsius, Quest STAT, Lotus Notes, CA Unicenter, AIX UNIX, Windows XP.

Responsibilities:

• Involved in many BO Universe modifications according to the new requirements using the best practices of the industry.
• Taking care in the Universe modifications for fields that have changed field name or length works with the old reports and test the old reports are compatible for the modified universes
• Did extensive testing of the universe changes in the DEV environment, again tested it in the TEST environment, also migrated to PROD and checked again in the PROD environment
• Built BO Universes and Reports using XI R3 Suite.
• Worked Extensively in Crystal SDK, JRC component and familiar with integrating complex report containing Parameters and sub reports with Java.
• Developed Webi reports for GL Account Data and migrated to BOXI environment.
• Developed Drill down Reports and used Open Document Syntax in Crystal to give the drill down functionality to the report.
• Involved in preparation of monthly entries and financial reporting package reports for the Financial Department.
• Installed BOXI and published reports on Enterprise Server and got involved in BOXI Enterprise Administration.
• Created Dashboard, Chat and Containers, Selectors using the Xcelsius components
• Involved in integrating the reports with reporting portal built on .net frame work.
• Involved in customization of the Web Reporting portal using asp.Net.
• Developed .mdf templates, IFD files for Adobe forms and successfully integrated with the. Net application
• Created tables, views in Teradata, according to the requirements.
• Written many of the MACROS in Teradata to generate less channel traffic and easy execution of frequently used SQL operations and improve the performance.
• Involved in installation and configuration of SQL Server 2005 and SQL Server 2008 with latest Service Packs
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Proficient in utilizing the crystal reports and Xcelsius 2008 Query as a web service.
• Involved in Scheduling the Reports using BOXI (Crystal) Enterprise Portal.
• Published Reports in Crystal Enterprise via. Crystal Publishing Wizard and Central Management Console.
• Created many complex reports which derives data from more than One data providers/Universes
• Corrected all reporting issues including context errors, and multivalue errors after the migration
• Improve Business Objects report speed
• Developed number of complex reports utilizing Business Objects to its fullest potential using advanced functions, contexts, formulas, and formatting
• Mapped data from multiple sources to universes so that the data became “user friendly”
• Worked on team to implement a data warehouse, mapped fields, and tested legacy data against data warehouse data.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Installed Crystal Enterprise and published reports on Enterprise Server and got involved in Crystal Enterprise Administration.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Executing/Testing the new/modified load scripts for Extraction and Loading the data into the DW on the test environment
• Monitoring Job executions in CA Unicenter
• Migration of all the tested code from DEV to TEST environment
• Collecting and comparing the extract from OLTP and load/run times of the data on DW
• Documenting the changes and verifying the change requests are done as needed
• Interacting with the end users of the BO report users for their feedback
• Worked in the Financial, Higher Education and HR modules while working in Business Objects.
• Attended Design meetings to take inputs from the Functional consultants and modifying the code as per new changes.

Confidential, TX

SAP BI/BO/BPC consultant

Environment: SAP R/3, ABAP, SAP BI 7.0, BO XI 3.1, APO, MM, SD, FI-CO, PP

Responsibilities:

• Involved in the implementation of full life cycle of BI 7.0 which includes project preparation, business blue print, realization, final preparation and go- live. Interacted with teams with the functional teams of MM, SD and PP in order to gather the information required to meet the client requirements.
• Involved in requirement analysis, data modeling and technical implementation analyzed the business reporting requirements and understood the requirements for the installation of the necessary objects.
• Responsible for gathering requirements from super users and functional & ABAP team and provided the design options to meet the business requirements. Analyzed and mapped business process and worked on writing the blueprints. Analyzed and activated relevant business content. Performed and setup ECC, Flat File and BW as source systems.
• Worked extensively on the data, which involved Purchasing, billing, orders, general ledger,
• Accounts Receivable, and Profitability Analysis (CO-PA).
• Configured Generic and Custom BI data sources, created generic extractors for payroll data, planned production data, planned cost data and standard labor rate data.
• Extracted the data from different modules such as Sales and Distribution, MM, FI and PP by using standard extractors 0FI GL 4, 0FI AR 4, 2LIS 02 SCL, 2LIS 04 P MATNR.
• Created the custom extractors and replicated the data source and loaded the data using info packages into BI.
• Extracted data from LO cockpit by using the extractors 2LIS 13 VDHDR, 2LIS 13 VDKON and loaded the data from Sales & Distribution billing document and PP.
• Enhanced the extract structures by adding new fields and populating them with the user/function exits by wiring the ABAP code.
• Worked on SAP Business information warehouse and created info objects, DSO’s, info cubes, transformations, process chains.
• Used start routines whenever it is possible to process transformations.
• Created the data transfer process to load data from the ECC to BI by loading the info packages and replicating data sources. Initialized the Full & Delta process. Created APD‘s for DSO’s.
• Loaded the data into the BI system from flat files. Customized the data flow right from ECC to BI.
• Worked on scheduling the process chains and event triggers.
• Extensively worked in performance tuning the queries by maintaining aggregates, indexes, statistics and compression on Info cubes.
• Involved in the BPC process chain development. Created planning applications such as revenue planning, inventory planning, cost planning, HR planning, etc and also, input schedule sales quantity, stocks, adjustments, rounding, entering planned amount for sales, inventory planning, HR planning.
• Prepared Planning and consolidation design documents, and process flows.
• Created Hierarchy Grant access to applications BPC logic. Loaded currency exchange rates.
• Loaded actual and budget data, created forecast data and Loaded data BPC for excel working with dynamic report templates
• Prepared Process Definition Document (PDD), Report Definition Document (RDD) for the financial planning, budgeting and forecast processes, business unit planning & Analysis.
• Worked on data extraction procedures to SAP BPC system from different source systems. Executed the optimization tool for lite and full optimization.
• Develop and unit test reports using the EVDRE functions.
• Worked on income statement reports, Balance sheet reports, Audit report, cash flow report, consolidated summary of operations and consolidated balance sheet by company code
• Worked with the members involved in BPC teams working with both Technical & application consultants to help them solve all kind BPC related problems.
• Worked with the APO team and involved in creating transports, raising OSS messages related to APO.
• Configured and customized theAPOdata mart - basic Info cubes and remote/backup Cubes, characteristics, key Figures, navigational attributes to collect data and support the demand planning hierarchy.
• Worked on the open hub destinations to transport the data from BI info providers to other Source.
• Created queries in the Query designer by using attributes, variables, filters, calculated key figures, restricted key figures, different conditions and exceptions.
• Generated the reports for the analysis of Sales, finance and materials and planning.
• Worked with the federation tool in BI.
• Created Web-intelligence reports in business objects XI 3.1 for creating the pie charts for analysis of information about the Sales and Shipment.
• Modified the Web-intelligence reports by using adding characteristics and key figures and changed the formats depending upon the requirements of the end user. Added additional features to the reports by introducing the graphical analysis for a detailed view.
• Created the Crystal reports for the detailed analysis of issues for particular time period in materials and delivery dates in production planning. Modified the reports as per the client demands by introducing different ways of representation in the form of tables, charts, pie diagrams and comparison charts.
• Developed dashboards in Xcelsius reports by using different charts, Selectors, Containers and design features having advanced properties and delivered several Xcelsius dashboards.

Confidential, PA

Sr. SAP BI/BO Consultant

Environment: SAP ECC 6.0, BI 7.0, Business Objects XI 3.1(BOBJ), FI/CO, COPA, SD, MM, HR, CRM, SCM, SRM ABAP/4, BEx Analyzer, Crystal Reports, Live Office, Xcelsius, WebI Reports, Ad-hoc Reports

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support..
• Extensively worked on Data design and Data modeling using Extended Star Schema.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Worked extensively on Data modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service, Info Spokes etc.
• Worked extensively on FI-CO, SD, HR, MM, and Warranty. Loaded the data from ECC to BI and used initialization with delta update and full update methods.
• Extracted the data from HR modules and uploaded the data into HR Info Cubes for 0PY C02 Payroll data, 0PABN C01 Benefits, Staffing Assignments 0HR PA OS 1 0HR PA CM 1, and 0PT C01 Time and Labor Data and worked on transformations.
• Implemented standard content for Personal administration (0PA C01, 0PAPA C02 cube) to analyze personal data such as head count based on nationality, gender, language, personnel area, employee group and organizational unit.
• As a part of the production support, involved in the debugging and monitoring load failures, update routines, transfer routines, process chains, scheduling data loads, solving the high priority tickets like delta loads, planning ECC outage for filling up of setup tables.
• Created and enhanced new and existing Analysis Process Designs (APD) to load the data in to direct update DSO and further into Metrics using DTP’s.
• Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.
• Created many test cases and test scenarios for Unit testing, Integration testing of many BI reports. Conducted many training and Brown Bag sessions to help the end client understand the SAP BI system and also to gather the requirements.
• Performed unit testing on the complete data flow of the model developed from source system through BI, user acceptance testing and data validation testing and prepared documentation.
• Planned the cut over activities before go live and performed the downtime activities.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Used Business View Manager to create Business Elements, Business Views to use data in different sources and generated reports using Crystal Reports.
• Created inventory accuracy Dash Boards (Xcelsius) and for management reports for inventory management and wages and costs report from cost center accounting.

Confidential, TX

SAP BI Analyst/Developer

Environment: SAP BI 7.0, SAP ECC 6.0, SAP CRM, Business Objects 3.1, BEx Analyzer, ABAP/4, FI/CO, SAP SCM, SD, HR, and Oracle.

Responsibilities:

• Gathered requirements from Business users for Historical data modeling of different schemas from the legacy systems such as OMS, VISTA, Hyperion, PeopleSoft and worked on the development of modeling master data and transactional according to the change of business.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets in BI to support the architecture.
• Responsible for the analysis of the historical architecture and reports of the Order Management Systems to identify the required fields and transformations of KPI’s from Legacy to IS-Media implementation.
• Worked with SAP IS-Media implementation design so as to align the historical data model with the Media implementation.
• Worked extensively on Media Data sources 0BP MEDIA ATTR, 0ME MED PROD ATTR and even created custom DS for Customer Master Extraction.
• Worked extensively on CRM Data Sources, primarily on 0BPARTNER for Customer master enhancement and maintaining different SHIP TO and SOLD TO party information of Customers for legacy data from OMS systems.
• Worked with Flat file Data sources and established DBConnect to extract data from the OMS systems into SAP BI.
• Worked on transformation logic using ABAP at start routine, expert routine and end routine and involved in creation and maintenance of DTP and Info Packages for loading data into data targets.
• Worked in the development of the historical data model at different layers of the LSA architecture.
• Created WO DSO’s, standard DSO’s, Info cubes and adjusted Multi providers so as to harmonize granular data from the actuals and history for reporting needs.
• Worked on transformation logic needed to model data for Business Partner, Media Product, Media Issue, Sales BOM, Sales Org, Order Type, Customer Class and Customer Groups.
• Created and released transports from DEV to QA to PROD and performed Unit testing and Integration testing and UAT for the OTC environment.
• Interacted with the business for constant changes in the requirements and was solely responsible for delivery of corporate memory.
• Worked on modeling data at reporting level based on user requirements for transactional data for Subscriptions, Contracts, Orders and Issues.
• Developed many queries as per the business requirement such as Customer Listing, Cross Purchase Subscriptions, Product Sales analysis, Cancel reasons and BTC’s.
• Developed standalone history queries using filters and navigational attributes in BEx to facilitate data analysis and also used Calculated and Restricted Key Figures, Structures, Conditions and Cell Definitions within queries.
• Tweaked many Queries in BEx Query Designer so as to report on Actual versus History and developed universes for creation of cross tab reports, dashboards on WEBI and Xcelsius respectively.
• Provided development documents and was author of all handover documents as part of the implementation strategy requested by the business.

Confidential, CA

SAP BO Developer

Environment: Business Objects 6.5 (Universe, Designer, Business Objects), Crystal Reports 10/XI, Crystal Enterprise 10/XI,WebIntelligence2.7/6.0, Broadcast Agent, Xcelsius, UNIX, Windows NT/2000.

Responsibilities:

• Created new Desk I reports in Business Objects 6.5.1
• Involved in the BO Universe modification testing the new modified universe
• Interacting with the end users for their input to create reports in BO
• Capturing and analyzing historical data on batch jobs.
• Proactively studying the impacts of data growth / Ensemble Releases and making recommendations on reducing the load and access time for the Data warehouse.
• Worked on Performance and Tuning on SQL queries.
• Installation of Business objects 5.1 and installation of Web Intelligence server v 2.6
• Involved in Creating Repository, Creating Users and User Groups.
• Designing and developing Universe for reports generation.
• Development of Dashboards using Crystal Xcelsius 2008
• Created Classes and objects using inner/outer joins based on user requirement.
• Resolved the loops, cardinalities by contexts and aliases and checked the Integrity of the Universe.
• Developed Universes with Information Design Tool.
• Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligent, Live Office, Xcelsius.
• Exporting the universe to the Repository to make resources available to the users.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Used Crystal Management Console for scheduling the reports.
• Involved in managing users, groups, folders and published reports using crystal management console, in exporting and scheduling of reports using Crystal Enterprise and generated Web reports by using eportfolio.
• Worked Extensively in Crystal SDK, JRC component and familiar with integrating complex report containing Parameters and sub reports with Java.
• Created user objects including Dimensions, Details and Measures.
• Formatting the Reports to the Users requirements using all the requirements in Business objects like Slice and Dice, Drill Down, @Functions and Formulas etc.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Used the Doc Agent server to Schedule and Monitoring the Reports.
• Extensively involved in writing PL/SQL stored procedures, database triggers. Also carried out performance tuning and optimization of critical queries using Explain Plans, Analyze etc.
• Communicating systems/components issues and concerns (IO, CPU consumption issues) to different groups within the Data Warehouse.

Confidential, TX

SAP BI/BO Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, FI-AR, FI-AP, FI-GL, FI-SL, MM, CRM,IM, ABAP/4, MM,PP, APO, HR, BEx Analyzer, Query Designer, Web Focus, Micro strategy, Web Application Designer, BO Designer (XIR 2.1, 3.1), WEBI (XI R 2.1, 3.1), Xcelcius 2008, SAP Net Weaver portal.

Responsibilities:

• Involved in the full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
• Understanding the business challenges and translating them into requirements.
• Activation of the Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA),General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA) and customizing them as per the client requirement.
• Developed write optimized DSO’s for EDW layers and standard DSO for consolidation layers and created direct update DSO’s for creating history data and for snapshot scenario reports.
• Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Created generic data sources with ability of delta functionality.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Web Reports, WEBI, Xcelcius and Dash Boards.
• Scheduled training sessions for end users for Reporting tools.
• Extensively involved in supporting SAP BW application and involved in data loading, fixing issues related to data loading, load monitoring, performance tuning, write and modifies existing ABAP codes for better performance and issues
• Performance tuning to improve query performance using Partitioning, Aggregation and Cube compression.
• Experience in the enhancement of the master data and transaction data sources with Z-fields and are populated using User Exits.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement for US and Turkey.
• Enhanced the business content data sources by appending structures, User Exits and customized delta built up for the data sources.
• Designed a process for HR to work with Employee Census information. Data loads are performed using Flat file source system. The data comes in as an Excel file and is converted to Flat files before loading.
• Worked on Accounts payable cubes ZUAPC01, ZAAPC001 and accounts receivable cubes ZUARC001, ZAARC002 and created Info Sets and MultiProviders according to the requirement.
• Created Info Objects, Info Sources, Info Cubes and developed transfer structure, update rules and transfer rules as per business requirement and extracted data from external sources.
• Created process chains for periodic upload of master data, transactional data, text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• 0BPARTNER enhancement for reporting to pull data from SAP CRM and SAP SRM source. 0bpartner attr from SAP CRM and 0bbp bpven attr from SAP SRM.
• Interacted with the external company in gathering their need, for further assisting them to use the data extracted from SAP BW system. Business Content CRM cube activation was done, Marketing Management, Business partner etc.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and MultiProviders
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources
• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Created exception aggregations, cell editors, formula variables, RFK’s and CKF’s in the queries.
• Extensively used WAD and published reports on Enterprise portal as iView
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created inventory accuracy Dash Boards (Xcelcius) and for management reports for inventory management and wages and costs report from cost center accounting
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Preparation of project plan and HDD, LDD of universe reports
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and implemented index awareness.