PROFESSIONAL SUMMARY:

• Over 25 years of IT experience in design, development and implementation of business applications that includes more than 12 years of functional/technical expertise in SAP BI/BW.
• Involved in 4 life cycle implementations (including upgrade from BW 3.5 to BI 7.0) from blue - print to Go-Live stages.
• Well versed with ASAP Methodology and all the phases involved in Project implementation.
• Experienced in Data Analytics/ Data Mining utilizing different ERP tools and techniques using tools such as Bex, WebI, Analysis for Office.
• Experienced in working in BW Upgrade Projects from BW 3.5 to BI 7.0
• Extensively worked on different domains like SD, HR and FI/CO (GL/AR/AP).
• Strong expertise in SAP BI 7.0 features: Transformations, DTP, Error DTP, DSO, Start and End Routines using Data Warehouse Workbench.
• Experienced with new BI 7.0 features Real time data Acquisition, write optimized DSO, Open Hub destination, Admin Cockpit, BI Accelerator, Analysis Process Designer and Information Broadcasting.
• Expert in building SAP-BW Components like Info-cubes, Data Marts, Multi-Providers, Info Sources, Info-object, ODS Objects, Info Spokes, Update Rules, Transfer Rules and Routines.
• Expertise in data extraction from ECC (FI/CO, HR, CRM, SD, CO-PA) and Generic Data Sources.
• Customized Standard Business Content Extractors and Enhanced Data Sources in various applications using customer user exits to suit the user requirements.
• Extensive experience in Production Support. Created and Scheduled process chains to load master/transaction data for daily, weekly and monthly intervals.
• Experienced in Report Generation - Worked extensively in BEx Analyzer and Web Application Designer. Created custom queries using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures.
• Experienced in ABAP programming which helps in developing custom solutions using code in User exits, Start Routines and End Routines.
• Good knowledge in SAP HANA modelling using attribute view, Analytic view, and Calculation view. Good knowledge in Direct extractor connection.
• Completed full training on Business Objects Universes through SAP America.
• Able to adapt quickly to new technologies and work environments.
• Excellent communication, interpersonal, managerial skills and positive work attitude and self-motivated to work independently and as well as in a team.

TECHNICAL SKILLS:

SAP BW: SAP BI 7.0, BW 3.5, 3.1c

SAP ECC/R3: ECC 6.0, 5.0, SAP R/3 4.7, 4.6c.

Reporting Tools: Business Explorer, Web Application Designer.

Portals: Enterprise Portal 6.0

Programming Languages: ABAP/4, SQL. (1 Year)

Business Objects: Web Intelligence XI 3.0, Universe Design

PROFESSIONAL EXPERIENCE:

Confidential, Jackson, MI

SAP Business Intelligence Analyst

Responsibilities:

• Working as a senior level BI consultant on a large scale SAP finance implementation.
• As a principal consultant, responsible for working with the functional team to build BI data warehouse consisted of SAP delivered standard contents and large number of external interfaces and legacy systems.
• Also, a full implementation of SRM using standard extractors and internal SRM tables.

Confidential, Richardson, TX

Sr. SAP BI Consultant

Responsibilities:

• Worked as a Sr. BI consultant for the configuration and implementation of COPA.
• Developed and implemented VISTEX for BI reporting for Sales, Advertising and Inventory.

Confidential, Denver, CO

SAP BI Programmer

Responsibilities:

• Working as O&M lead, supporting production environment.
• Day to day operational incident monitoring and resolution.
• Working on several development projects in parallel.
• Mentoring the internal team members on developing BI skills.

Confidential, Greeley, CO

SAP BI Architect/Configurer

Responsibilities:

• Responsibilities include transition of existing business areas such as LOR, BPS, PCA, CCA, APO Lite, EDI etc.
• Responsible for all historical data development involving 2 years of data archiving.
• Also responsible for development of technical design/specs of new requirements for JBS.
• Development of new data marts. Involved in Business Objects implementation.
• Building Universes according to the reporting requirements.
• Developing queries in Bex to be used as source for the universes.
• Involved in heavy custom development for historical date extracted from PeopleSoft system that includes building of objects to map with the interface files.
• Also responsible for all the production support issues as on-call. Recently implemented Business Objects (Webi/Crystal) as our primary front-end tool for corporate reporting solutions.
• Was actively involved in BOBJ integration and development of Universes for critical reporting needs.
• Heavily involved in SAP FI implementation for our Australia operations.
• Solely responsible for resolution of CRM/BI and APO Lite/BI development and production issues.

Confidential, Queensbury, NY

Sr. SAP BI Architect/Manager DW

Responsibilities:

• Lead a team of 4 internal resources and 3 offshore developers.
• Responsible for all the data warehousing and reporting requirements of the business which includes development of custom BW components (IC’s, DSO’s, Objects, Datasources) and conversion of current crystal reports into Bex reports utilizing BW 3.5 reporting tools.
• Also, working on the layout of the roadmap from BW 3.x to BI 7.0 in the near future.
• Currently involved in working with local and global teams for the upcoming CRM (Services) implementation.
• Along with the project preparation, working on several operational issue such as COPA loads and reporting work orders etc.
• Communicating with global team on a regular basis on data loads from legacy systems into R/3 and subsequently to CRM.
• Upcoming projects include ECC 4.x upgrade to ECC 6.0 and BI 7.0 implementation.

Confidential, Denver, CO

SAP BI Consultant

Environment: SAP BI 7.0/BW3.5, SAP ECC 6.0, Enterprise Portal 6.0

Responsibilities:

• Developed FI-CO (AP, AR, GL) functional and technical specs. Submitted the data model design after successful completion of gap analysis of the GL DSO and Cube.
• Activated/installed all required business contents including cubes, dso’s into BI.
• Activated all AR, AP, GL, CO and CATS master data (phase one)
• Created Transformations, DTPs and InfoPackages for all above master data
• Migrated all the v3.5 datasources to Netweaver 2004.
• Loaded all the transactional data for FI and CO.
• Deleted and reloaded all HCM master data per requirements.
• Created ad-hoc queries for SCM, HCM, FI, and CO requirements
• Activated content Datarources such as 2LIS 12 VCHDR (Delivery), 2LIS 02 ITM (PUR) etc.
• Mainly responsible for transporting the entire project contents (Infoproviders, Reports, Process chains, Portal content, Security Roles) from development to Q/A.
• Closely worked with Basis team and Oracle DBA and FICO functional leads to create ODBC connection between BI and data mart for the FICO data feed for the Cognos planning/reporting.
• Worked extensively on Historical Data Archiving into BI from several Legacy systems (ARS, BAAN etc) creating several DSO’s for reporting requirements. Also developed functional and technical specs (Custom and SAP objects, Datasources, DTP’s, Transformations, Infopackages etc) for all archiving requirements.

Confidential, Dallas, TX

Sr. SAP BI Consultant

Environment: SAP BI 7.0/BW3.5, SAP ECC 6.0, Enterprise Portal 6.0

Responsibilities:

• FICO and IP project implementation.
• Worked as a Co-Lead, training other developers on design, back-end development and reporting.
• Managed entire projects from requirement gathering to production implementation. Delegated work load among junior developers. Interacted with different user groups for project specifications. Performed user training.
• Submitted the data model design after successful completion of gap analysis of the GL DSO and Cube.
• Involved in writing the required start routine, end routine and update routines for data transformation and Cleansing.
• Activated BI contents for Integrated Planning such as Planning Functions and Planning Process management (PPM).
• Enhanced the 0FI AR 4 datasource according to the user requirements.
• Was mainly responsible for transporting the entire project contents (Infoproviders, Reports, Process chains, Portal content, Security Roles) from development to Q/A.
• Designed the entire data loading process for all the master/transaction data loads.
• Created the cut over plan and implemented it for successful Go-Live process.
• Scheduled the process chains and successfully monitored and fixed the load failures.
• Experienced with new features and data load process in BI 7.0
• Experienced in new error handling techniques using Error Stack DTP.
• Installed the required OSS Notes to fix issues in SAP BI 7.0.
• Document detailed business process procedures (BPPs) according to the requirements.
• Performed routine basis tasks including monitoring locks, object transportation to production using t-code STMS, setting up user roles/ authorizations, monitoring system performance, applying OSS notes (Direct/Manual) from SAP, cube partitioning etc.
• Performed BI Security tasks on a daily basis. (See ‘Basis Experience’)
• Created the project plan for the entire migration of the BW data flow and the components.
• Involved in the migration of BW 3.5 data sources/queries to BI 7.0 data sources.
• Created Transformation by migrating update/transfer rules from 3.x to 7.0
• Migrated the queries from 3.x to 7.0 and resolved the issues during migration.
• Created test plans to perform regression testing.
• Referred OSS notes to resolve issues while migrating to 7.0.
• Designed and developed different types of FI reports in GL and AR like Profit and Loss reports, Income statement report, Annual reports by company, region, AR Aging reports by company, region.
• Created summary and detailed reports to analyze the AR reports at customer and document detail level. Created jumps from summary to detail reports with required restrictions.
• Created Hierarchy and Hierarchy Node Variables and used them extensively in reports to display reports in Hierarchy/non-hierarchy view according to the user requirements.
• Created structures to display Current Year/Period, Prior Year/Period, and Year to Date data.
• Created and used exceptions extensively for exceptional reporting.
• Created customer exit variables extensively in reports to meet user requirements.
• Created complex cell definitions to calculate variances for Revenues and Costs as per the requirements in the P&L reports.
• Designed and created simple to complex Web Templates using different web items like Tab Pages, Container Layout, Buttons for PDF Print, Export to Excel, Analysis items, Charts etc.
• Created Iviews for web templates and published them into Portal.
• Installed BI Administration Cockpit useful for data load/query runtime analysis.
• Was extremely successful in redesigning and fixing the existing reports that could not satisfy user requirements and failed Integration testing.
• Extensive experience in fixing regular user complaints about report inconsistencies.
• Transportation of objects from QA to Production environment.
• Install, configure, tune and patch SAP systems.
• Maintaining user sessions, lock entries.
• Creating user Id’s.
• Setting up user roles and authorizations.
• Monitoring system performance.
• Applying OSS notes (manual/direct) from SAP.
• Checking short dumps (ST22)

Confidential, Dallas, TX

SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, Enterprise Portal 6.0

Responsibilities:

• Worked extensively on standard and custom defined LIS, LO extractors. Installed relevant SAP business content. Used LO structures for extracting sales order, delivery information. Logistics Cockpit configuration and customization
• Managed and monitored data loads with Full update and Delta update
• Involved in upgrade process from BW 3.5 to BI 7.0.
• Experienced in migrating BW 3.5 data sources to BI 7.0 data sources
• Created test plans to perform regression testing and implemented them successfully before and after migration to validate the migration process.
• Implemented the required OSS Notes after upgrade to resolve the issues.
• Created Data Transfer Process(DTP) to schedule the update in BI 7.0
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and FI.
• Extensively worked on query development and formatting techniques in both BEx and Web Application Designer(WAD) of key BW reports and created Web Templates
• Worked on BEx Analyzer and WAD. Created queries using BW- Reporting variables, navigational attributes and Filters. Developed workbooks, info set Queries.
• Defined reports as per reporting requirements.

Confidential, St. Louis, MO

SAP BW Consultant

Responsibilities:

• As a part of the BW implementation team, involved in gathering user requirements and data modeling using ERM, star schema concepts.
• Analyzed Business and Query Requirements, designed data model.
• Worked extensively on administration workbench and business content.
• Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW. Used extended star schema for data modeling.
• Worked on configuration of BW by identifying the needs of customer, modeling the data, defining data sources at OLTP and reporting data by using Administrator Workbench’s Business explorer.
• Installed and extended standard Business Content based on client requirements for enhancing DataSources for transaction data and master data.
• Worked on standard cubes (sales orders, billing and delivery orders).
• Modified data sources for certain Info cubes (0SD C01, 0SD C03).
• Used purchasing cube 0PUR C01 for purchasing information. Designed and created a Custom ODS object for purchasing line item level details.
• Involved in developing extract structure in R3 and communication structures in BW to in corporate the changes for the end user acceptance.
• Developed reports on InfoCubes/ODS objects using BEx Analyzer to facilitate summarization of data. Created local workbooks, global workbooks, Infoset queries and template workbooks using Calculated Key figures, Restricted Key Figure, Filters, Exceptions, Variables, Conditions and Structures. Created and maintained roles.
• Involved in end-user training and documentation.

Confidential, Atlanta, GA

SAP BW Consultant

Responsibilities:

• Involved in gathering Business Requirements and preparation of Information template used for identifying data elements for future reporting needs.
• Involved in analysis of data requirements & translation of these requirements into dimensional data models using star schema and extended star schema, with an emphasis on actual implementation in BW.
• Worked with the Data management group during the process of Data Analysis & Data Mapping exercise.
• Installed and extended standard Business Content based on client requirements for enhancing DataSources for transaction data and master data.
• Created Info Objects, DataSources, InfoSources, Data targets, InfoPackages and InfoProviders to load Master and Transactional data from SAP R/3 system into BW system.
• Involved in customizing LO-Cockpit extract structures (2LIS 11 VAHDR, 2LIS 11 V SSL) and data sources in sales and distribution, and material management to facilitate the data extraction to BW and to reporting using classification of various data elements.
• Created Info package groups to automate the data transfer when and what intervals the data to be extracted from R/3 to BW.
• By using Open Hub Service the data, which is in Info, cube and ODS is passed to Flat files and db tables.
• Enhanced the Communication Structures to add new fields for Purchase Orders.
• Developed Transfer Rules to extract data from various DataSources to transfer structures.
• Created Custom InfoCube for Key Performance Indicators (KPIs) defined by business.
• Created a generic structure to extract data from the custom tables.
• Designed and created an ODS object which gets data from the generic structure.
• Loading of third party tools data through flat files periodically as required.
• Worked on performance tuning of Queries by creating aggregates, indexing and cube Compression.
• Created variables restricted, calculated Key Figures for the Queries. Created Conditions, Exceptions, Structures and Variables that are used in BEx Reporting.
• Provided help in end-user training and documentation.
• Worked with DBAs and Business Object developers in defining the data mart star schema model and building staging areas to load the multiple data sources. In total 4 source systems are used and that many extract programs were built on the source systems.
• The fact tables and dimension table were defined and created. Wrote ETL programs to extract data sets for fact and hierarchy tables from Enterprise Data warehouse and Mainframe. ETL routines are written in Unix shell script and SQL language to load data into staging areas
• Four years historical data was loaded into the data mart with a total size of around half a terabyte. Performed overall system tuning to reduce the batch cycle time and improving report performance.
• Load routines were written to update dimension table and load current fact data into the Fact table. Weekly OPC batch jobs were written and scheduled to load the data-mart every week. Supported production environment for more than 3 years and the entire user base of around 200.

Environment: Oracle 9i, Business Objects 5.x, Unix, Windows 2000, Mainframe, Informix