SUMMARY

• Over 10+ years of experience in SAP Business Warehousing (BW 7.5/7.4/7.3/ BI 7.0/BW 3.5) and SAP Business Objects 4.2/4.0/XI 3.1 and SAP Data Services 4.0/4.2.
• Strong hands on experience in full life cycle implementation of BW 7.4/7.3, BI 7.0, and BW 3.5 which includes Data modeling, Data Extraction, Data Loading (Full/Delta Up - Loads), scheduling, monitoring, BEx Analyzer, Query Designer, Application Designer, Testing, Go-live and Production support.
• Extensive experience in developing data models in HANA 1.0 SP6
• Strong experience in Business Objects 4.2/4.0/XI 3.1
• Extensively worked in Business Objects Data Services (BODS 4.0/4.2).
• Comprehensive knowledge on data extraction from SAP R/3(FI-CO, MM, SD, CRM, SRM, HR) using different Extractors such as LO Cockpit and CO-PA.
• Good knowledge of complete Software Development Life Cycle as worked in a CMM level-5, PCMM level2 companies.
• Good experience in onsite and offshore model.
• Experienced in writing Start routines, End routines, Field routines and Expert routines using ABAP.
• Expertise in building the Reporting Applications from scratch with OLAP/OLTP environments.
• Experience in transporting the Business Warehousing Objects from Development to Quality and Productions. Knowledge of Transport Connection to collect objects for transport.
• Experience and good knowledge in the migration of data sources and content from SAP BW 3.5 to SAP BW 7.3 maintaining the Transformations and DTP’s.
• Experience in the configuration and implementation of the Process Chains for the regular data loads and scheduling and monitoring the data loads.
• Strong Experience in transporting the BW objects from Development system to Quality system by using STMS.
• Experienced in SAP BW front end tools BEX Analyzer, Query Designer and Web Application Designer (WAD).
• Experience with Calculated Key Figures, Restricted Key figures, Structures, Characteristic Variables, Text variables, Exceptions and Conditions.
• Strong experience in Business Objects and Proficient in Business Objects tools: Universe Designer, Desktop Intelligence tool, Information Design Tool, Web Intelligence Rich Client, Info View, BI Launch Pad, Crystal Reports, Dashboards/Xcelsius, Query As A Web Service, Report Conversion tool, Import Wizard and Live Office.
• Experience in Design, Development and Deployment of Business Objects Solutions for corporate reporting requirements and experienced in building Universes, running queries and developing reports.
• Proficient in generating Xcelsius Dashboards using the components like Charts, Selectors, Maps.
• Expertise in Installation, migration, maintenance, troubleshooting and overall administration of the Business Intelligence and Business Objects Suite.
• Compile and analyze detailed, user requirements with teams of primary business users, and technically trained personnel within IT department.

TECHNICAL SKILLS

Business Intelligence Tools: SAP BI 7.5/7.4/7.3/7.0 , BW 3.x

Reporting Tools: SAP Business Objects 4.1 / 4.0, BOXI 3.1, Xcelsius, Business objects Query for Excel, Crystal Reports, Universe Designer, Information Designer, Business Explorer, Web Application Designer, Reporting Agent, Report Designer.

Performance Management Tools: BW Accelerator, HANA Studio

ETL/ERP Tools: SAP R/3 3.0/4.0B/4.6C/4.7, ECC 5.0/6.0/7.0

Data Migration Tools: Business Objects Data services (BODS), SAP Landscape Transformation (SLT)

Database Experience: MS SQL Server/Access w Sybase IQ w Oracle w DB2

Programming: ABAP w HTML/DHTML w SQL/PLSQLw C/C++ w UNIX w

Software: MS Excel / PowerPoint / Project / Word w Outlook

Operating Systems: Windows w UNIX w Linux w Citrix

Monitoring Tools: Clarify (CRM Tool) w HP Quality Center w Solution Manager w Share Point

Scheduling Tools: Tivoli w Control-M w Redwood w UC4

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. SAP BI Consultant

Environment: SAP BW 7.4/7.5, SAP ECC 6.0, VISTEX (Incentive and Payback module), Solution ManagerSAP BO 4.2

Responsibilities:

• Worked extensively on Data Modeling design like creating Info Objects, DSO’s (write-optimized), Info Cubes, MultiProviders, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc.in the new Confidential One BW system.
• Created open hub services for Master and Transactional objects to export data from Legacy BW system (running on HP server) to Confidential One BW system (running on IBM server).
• Created Master and Transactional datasources for the Legacy BW system objects in the Confidential One BW system and loaded data through the application server to the new system.
• Installed necessary objects from the business content in the new Confidential One BW system.
• Created write-optimized DSO’s ( corporate memory ‘A’ layer) for the standard ‘B’ layer DSO’s.
• Extensively worked on Vistex price request data sources /IRM/LIS RM GPRKON, /IRM/PQHDR ATTR and /IRM/PQHDR TEXT.
• Extensively worked on vistex price request data sources /IRM/GPPHDR ATTR, /IRM/LIS RM GPPKON and /IRM/GPPHDR TEXT.
• Worked with data sources 0CO OM WBS 2 (WBS Elements: Budget) and 0CO OM WBS 8 (WBS Elements: Budget Line Items).
• Re-Initialized datasource 2LIS 06 INV after the system copy from production to quality.
• Created a generic extractor for the table NAST (Message Details) to meet the reporting requirement.
• Developed an Open hub to send the monthly G/L Balance file from Confidential One BW system to Westlake BPC system for the month end closing in Khalix Migration project.
• Worked on Repetitive manufacturing extractors 2LIS 04 PEMATNR and 2LIS 04 PECOMP in Westlake Integration project.
• Participated in BW upgradation from 7.0 to 7.5.
• Created Process Chains for the month end closing and scheduled it for every 4 hours data refresh during the month end closing as per the business requirement.
• Created alerts for the daily process chain to send failure notifications to the BI team.
• Monitored daily and monthly closing process chains and opened incident tickets for the data load issues.
• Transported the BW objects upon the approval from the manager by using solution manager.
• Involved in resolving the tickets (Incident & Change Request) by using Service Now.
• Customized queries using navigational attributes and filters in BEX analyzer as per client requirements.
• Created WebI reports by using BICS connection on top of BEX queries.
• Created documentation to the archived objects for the audit purpose.

Confidential, New Hyde Park, NY

Sr. SAP BI Consultant

Environment: SAP BW 7.4, SAP ECC 6.0, SAP BODS 4.2, DB 2.0, Oracle 11g, SAP HANA 1.0

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.
• Analyzed and translated the client's business requirements and functional specifications into technical specifications, data flow diagrams and data models.
• Cooperated with the Client's process teams in identifying and documenting necessary reporting requirements to build a reporting architecture.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, MultiProviders, Info sets, Time dependent master data and also in ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc.
• Worked on generic extractors to meet the reporting requirement.
• Maintained Process Chains to automate and schedule the data loads.
• Customized queries using navigational attributes and filters in BEX analyzer and used customer exits as per client requirements.
• Designed report templates with BEX Analyzer and Web Analyzer using key figures, features, hierarchies, variables, properties, exceptions and conditions in the query definition.
• Created Data stores to connect different databases from DS (Oracle, DB2 and ECC).
• Created different objects in Data Services (Project, Batch Jobs, Work Flows, Abap Flows, Data Flows, Global Variables and scripts).
• Created Script logic in Data Services Batch Job, to fetch the previous month data if you run the job in current month.
• Loaded data from Data Services to SAP ECC custom tables by using custom IDOCS (ZUSTRB IDOC).
• Scheduling the jobs by using Business Objects Data Services Management Console.
• Export the project from one environment to another environment.
• Validation, Tracing and debugging Batch job; Capturing changes in data (Initial/Delta load) using Table Comparison, Map-operation, Key Generation Transforms.
• Extensively worked with Different Transformations like Table comparisons, Date generation, Key generation, Query, Merge, Map operations, Validations, Pivot etc.
• Debugging the jobs for data flow testing on each level.
• Created local and global variables and scripts for initializing the jobs, work flows, Data flows.
• Extensively worked with local Repositories, Central Repositories, Job Server and Web Admin client tools.

Confidential, Houston, TX

Sr. SAP BI Consultant

Environment: SAP BW 7.3, SAP ECC 6.0, SAP BPC 10.0, SAP HANA 1.0

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.
• Involved in implementation for SAP BW/BI back-end and front-end which included Data modeling, Generic/Custom Extraction, Data Loading, Scheduling, Monitoring.
• Involved in gathering user requirements, functional requirements, analyze, design, implementation, testing, and training with Clients.
• Managing the Offshore team and ensuring the co-ordination is happening within the team for internal/external reviews for timely delivery.
• Generated export data sources on Business Area (0BUS AREA), Functional Area (0FUNCARE), Profit Center (0PROFTCTR) and loaded hierarchies from LHBW to VPS BW.
• Generated export data sources on BCS (ZBCS CD2C, ZBCS CD2P, ZBCS CD2O) Info Cubes and loaded the data from LHBW to VPS BW.
• Created start routines, end routines and field routines in the system using ABAP.
• Maintained variables in the TVARVC table and used the same variables in the routines.
• Loaded data from external systems to BW using data services.
• Triggered DM Packages to load data from BW to BPC.
• Monitor the data loads (daily/weekly/monthly) from source systems by means of process chains.
• Involved in performance enhancement features such as cube partitioning, aggregates and compression.
• Prepared test scripts to validate the data between BW and BPC.
• Actively involved in PSA and change log deletions for reducing the table space issues.
• Created documents for the developed objects according to the user requirement specifications for support testing and for further guidance.

Confidential, Manchester, CT

Sr. SAP BI Consultant

Environment: SAP BW 7.3, SAP ECC 6.0, BO 4.0

Responsibilities:

• Involved in full life cycle implementation, which includes Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Worked on Data modeling, Data extraction, Generic/Custom Extraction, Data Loading, Scheduling and Monitoring.
• Worked on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, time-dependent master data and also worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules and Data Transfer Process (DTP).
• Worked on MM, SD, FI modules and loaded the data from ECC to BW and used initialization with delta update and full update methods.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube.
• Extensively worked on data sources 2LIS 11 VAITM, 2LIS 11 VAHDR, for sales orders, and 2LIS 11 VASTI for order item status.
• Created start routines, end routines, field routines and expert routines by using ABAP as per the business requirement.
• Created and activated transformations (both DSO and InfoCube level) and wrote start routine and end routines.
• Involved in scheduling the data loads, debugging and monitoring load failures, process chains, solving the tickets like delta loads.
• Worked on performance tuning and trouble shooting of BW issues, connector issues and reporting errors.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.
• Worked on query development and formatting techniques in BEX Query Designer.
• Directly used SAP BEX queries to build a WebI documents by using BICS connection.
• Experience in using IDT (Information Design Tool) used to design the Universe on more than one relational database. Also created queries using IDT.
• Extensive experience with WebI in creating queries and reports that further used in the Dashboard Designer.
• Developed Interactive reports and dashboards using Xcelcius and WebI reports.
• Sound knowledge over Dashboard Designer components.

Confidential, Clayton, MO

Sr. SAP BI Consultant

Environment: SAP BW 7.0, SAP ECC 6.0, BO 4.0

Responsibilities:

• Installed BI Content and enhancements based on business needs.
• Identified the needs for data staging layers in BI.
• Loaded data from external system CAS to BW using DBCONNECT.
• Extensively worked on data sources 0FI GL 4, 0FI AP 4 and 0FI AR 4to load financial transactions to the BW system.
• Created expert routines in BW to load data from propagation layer to transformation layer.
• Responsible for job schedules for loading Master Data (Texts, Attributes and Hierarchies) for Materials and Transaction Data into the corresponding DSO Objects and InfoCubes.
• Monitored Process chains and fixed the issues daily.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Worked on BW Production support issues based on severity, Analyzing the issue and providing solutions accordingly.
• Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using custom extractors.
• Developed BO Web Intelligence reports (Ex-Brew and Ex-Dealer) by using BICS.
• Technically involved in the responsibilities of security/authentication on the folder level for the Web Intelligence reports.
• Scheduled Web Intelligence reports using Central Management Console (CMC) for the management team daily.
• Validated the source to target data by using the sql test scripts.
• Have worked on doing testing during BO 3.1 to BO 4.0 Migration.
• Created BICS connection using IDT tool to broadcast Bex query for reporting purpose.
• Worked on Performance tuning of Webi reports and BW backend design.
• Conducted End User training on BO Web Intelligence upon request from HR.

Confidential, WA

Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, BO 3.X

Responsibilities:

• Involved in the design, development and implementation of the Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load Master and Transactional data from SAP R/3 system into BW system.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and DSO objects.
• Loaded data into Maintenance Orders costs and allocation and operations into cubes (0PM C01 and 0PM C04) using standard data sources 2LIS 17 ORDER, 0PM OM OPA 1 and 2LIS 17 OPERATION respectively.
• Loaded Equipment master data into info object 0Equipment using data source 0EQUIPMENT ATTR and using standard hierarchy 0EQUIPMENT HIER.
• Created Transformation, Data Transfer Process, Update rules, and Transfer rules.
• Created and scheduled Process Chain for loading Master Data and Transaction Data and monitored the loads.
• Developed reports using Bex Query Designer, using restricted key figures, calculated key figures, filter and formula as per the requirement of the query.
• Worked on Cutover Activities (TCO & ACO) on monthly and quarterly basis which involves execution of cookbooks during the cutover activity.
• Worked on front end level, created Web Templates according to the user requirements.
• Worked on SIR (System Investigation Request), CR (Change Request) tickets.
• Involved in extraction of full, delta loads and resolved data load related issues.
• BIA Monitoring and BIA Index Maintenance for necessary cube.
• Prepared Technical Specification documents as per the functional specification.
• Monitoring process chains and fixing data load issues.
• Prepared Unit test script documents for the UAT.
• Created Incident tickets, Interaction tickets and change tickets in SM7.
• Good experience in creating Universes over the Bex queries using Universe Designer.
• Created many Variables and Prompts in BOBJ according to the user requirement.
• Extensive experience in working with Infoview in creating and maintaining the WEBI reports.

Confidential, Framingham, MA

Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SQL SERVER 2008, QLIK VIEW

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.
• Activating the business content according to the functional requirements.
• Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.
• Converted all Sql server tables and fields names from lower case to upper case and also reduced the length of fields to 16.
• Created views in Sql server, based on that views designed cubes in SAP BW and loaded data from Sql server to SAP BW using DBCONNECT.
• Worked with infopackages, transformations and DTP to load the data.
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL, and 2LIS 03 S194 and populated into the procurement info cubes 0PUR C07, 0PUR C08, and 0PUR C09 to evaluate service levels.
• Created setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.
• Write ABAP routines to convert Sql server date format (Char) to BW date format (YYYYMMDD).
• Created generic datasource by using table (TCURR) and loaded exchange rates data from SAP R/3 to BW.
• Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.
• Created Process chains to load last month and current month data daily.
• Monitoring process chains and fixing data load issues.
• Prepared Unit test script documents for the UAT.
• Participated in transporting the BW objects from development server to testing server for unit testing and regression testing.
• Maintained Reconciliation’s to verify the data in SAP BW and QLIK VIEW are same or not after the data loads.

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7, BO 3.X

Responsibilities:

• Involved in gathering business requirements, GAP Analysis, design and development of technical specifications.
• Activated and utilized the business content according to the functional requirements.
• Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.
• Created generic extraction by using View and functional module to extract data from SAP R/3 to BW.
• Extensively worked on enhancing the standard data sources as per client requirement.
• Created custom InfoCube, ODS, Multiprovider, Infoset and InfoObjects.
• Involved in solving performance-related issues and also involved in Creation of Aggregates to optimize.
• Monitoring process chains and fixing data load issues.
• Involved in resolving the Tickets (Incident & Change request).
• Maintained Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Maintained Aggregates, Rollup and compressed Infocubes to improve the query performance.
• Developed front-end queries and reports using BExAnalyzer, BEx Browser, and Info set Query, BEx Web Reporting tool and Web Application Designer.
• Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Worked extensively on Web application designer to set up the template to test the web printing options.
• Extensively worked in SAP Live Office to create connections between WEBI and Xcelsius Dashboards.
• Sound Knowledge over Xcelsius Dashboard Components.

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7, BO 3.X

Responsibilities:

• Involved in gathering the requirements from users and Data Modeling.
• Interfaced with Business Analysts and performed Gap Analysis.
• Configuration of BW by identifying the Info Objects, Info Sources, Info Cubes, ODS from Business Contents.
• Developed ODS objects to support Delta Upload.
• Extracted data from Flat files to InfoCubes.
• Scheduled InfoPackage for loading Master Data and Transaction Data and Monitoring.
• Defined Process Chains for the data loads and scheduled accordingly.
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded.
• Enhance standard data source for master data attribute and transaction data.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Involved in resolving the Tickets like SR, MR&CR.
• Prepared Unit test scripts documents.
• Involved in System checks whenever required.
• Maintained Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.
• Scheduling and Monitoring background jobs.
• Analyzing short dumps using ST22.
• Coordinating with on-site team lead and updating day to day activities.