| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: Candidate's Name
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLE____________________________________________________________________________PROFESIONAL SUMMARY . 6+ years of IT experience in SAP BW/BI - Data Modeling, Extraction (ETL), Information Presentationand Analysis. . Experiencein SAP BOBJ/BOBI. . Excellent interpersonal & communication skills to work Cross- functionally with Enterprise Team members and handle multiple tasks. . Good knowledge in functional concepts of SAP ERP- MM, SD, and FImodules. . Good technical skills and willingness to learn new concepts and technologies. . Trained in HANA/BW on HANA.SAP EXPERTISE . Involved in Implementationof SAP BW/BO projects using ASAP methodology, including Development, Enhancement, Support andMaintenance projects. . Proficient in translating business requirements into multiple reporting solutions. . Experience in client facing,End-User training, documentation and specifications. . Experienced in Database Modeling & Design with Data Warehouse Concepts such as Star Schema, BW Schema -Dimensional& Fact tables. . Proficient in SAP OLTP extractions of LO-Cockpit, Application specific SD, FI, MM, PP, HR, Generic extraction, flat files and extraction from DB Connect for legacy data (non SAP). . Well versed in reporting tools including BEx Query Designer and BEx Analyzer, using Excel workbooks, Custom Query design, Variables, Structures, CKF, RKF,selections, formulas, filters, conditions, exceptions, cell definitions and Ad-hoc Reports using BEx Web Analyzer. . Expertise in working with SAP BOBJ Platform such as UDT,IDT, Web Intelligence, Crystal Reports 2008/2011, Crystal Reports for Enterprise,QAAWS, Live Office,Xcelsius Designer 2008 and SAP Dashboard Designer 4.0. . Skillful in, Basic understanding of ABAP Programming language related to SAP BW - Customer Exits, Transformation Routines and Data Source Enhancements. . Hands-on experience in Data Load Performance Tuning, Query Performance Tuning by using Partitioning, Aggregates, BI Accelerator, Infocube Compression techniques, parallel processing of loads and ensuring timely updated data. . Knowledge in Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services (BODS 4.1) for loading data from non-SAP system to SAP system. . Strong Knowledge in HANA Modeling Concepts; In creating HANA Attribute, Analytical, and Calculation Views, Analytical Privileges, SQL Functions, Open ODS views, Transient, Composite and Virtual providers on HANA views, BO Explorer view sets and Webi reports on HANA Analytical views. BOBJ Universes on HANA Views/Tables. . Proficient Knowledge with SAP BW 7.3 on HANA,Migration of BW Objects into In-Memory optimized DSOs &Infocubes and ETL- Data Provisioning Using BODS 4.0/4.1,SLT & DXCfrom SAP & non SAP systems into HANA. Excellent knowledge in SQL scripting and CE functions.Technical Skills:|ERP |SAP ECC 6.0, SAP R/3 4.7. ||Data warehouse and Reporting Tools |SAP BW (Versions 7.4, 7.3, 7.0, 3.5), || |SAP BO (Versions 4.1, 4.0 and XI 3.1) ||ETL Tool |SAP BODS 4.0, 4.1 ||In-memory RDBMS |SAP HANA 1.0 ||Languages |SQL ||RDBMS |Oracle 9i/11i, MS SQL 2005/2008, MS || |Access. ||Operating System |Windows 2003/2008/NT/XP/7/8 |PROFESSIONAL EXPEREINCE:Startekk Toronto, ON June 2013 - PresentProject: PerformanceKPI(Outsourced Development & Maintenance projects)Role: SAP BW/BODeveloperResponsibilities: . Coordinating all business requirements gathering efforts with the BW Project Manager,Designing the data solution to satisfy defined business requirements. . Supported ongoing development and enhancements for multiple businesses. . Discussions with team members and created business specifications and data flow diagrams. . After completion of SAP BI configuration based on SAP BW as source, creating BOBJ reports on top of BEx queries and presentation of information in corporate dashboards. . Successfully IntegratedSAP BW 7.3 with Business Objects 4.0/4.1. . Used Web Intelligence tool for web based query and reporting. . Created Technical specifications and standard modeling documents for BW and BOBJ. . Installing Business content in BW 7.3 and ECC R/3, Activated data sources in R/3 for Transaction data and Master Data. Mapping KPIs with Standard SAP business content and analysis. . Performed data modeling and developed BOBJ reports for FI, MM, SD and HR Master and Transactional data.Migrated content from DEV to QAS, DEV to PRD environment. . Created BW Infocubes and MultiProviders as per the requirement and maintained Aggregates and Rollup activities as a part of the Infocube Management. . Implemented 0PY_C02, 0PY_PP2 HR Cube and extracted the data from 0HR_PY_1, 0HR_PY_PP_2 & 0HR_PY_1_CE. . Extracting data from SAP R/3 by using LO Cockpit, Application Specific and customized Generic Extraction as per requirements. . Created Universes using IDT (Information design tool) on top of BW OLAP, Oracle/MSSQL DB tables/views, and Flat files and developed the Web Intelligence reports, dashboards and deploy them in BI launch pad. . Developed BEx Queries and defined Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Filters and Formulas, for customized reporting using BEx Query Designer BEx Analyzer & Developed several workbooks.Developed Web Intelligencereports and dashboards for different operations and KPI's forHR Personnel &Time Management and Financial data (Payroll) and analyzed in dimensions. . Worked with the ERP Consultants in configuring the Enterprise Structure and Employee Structure as per client requirements as part of sourcing Personnel Administration data. . Created and maintained Employee Hierarchy Reports, Employee Performance Reports using BEX Analyzer.Developed variety of reports like Employee Joining Report, Working Hours report, Payroll reports.Generated Payroll periods, Cumulative Periods, & Absentee Quotas through Reports (RPTQTA00).Utilized Hierarchies in the reporting to provide drilldown features. . Maintaining Reconciliation's to verify the data Integrity and data quality . Implemented Process Chains for automated master data and transaction data loads of all modules.Documentation of the project. . Monitoring of daily, weekly, monthly loads and notifications to multiple businesses as per requirements. . Daily support activities - PC monitoring, health checks and status updates to business users. Environment: SAP BI 7.0/BW7.3, SAP BOBJ 4.1/ BODS 4.1, and Atos Service desk tool,Oracle 11g, MSSQL and SAP ECC ERP 6.0.SHIRO Technologies Dallas, TX Sep 2012 - May2013Client: Celanese InternationalGlobal GT Project (Development & Maintenance)Role: SAP BW/BO DeveloperCelanese is a global technology and specialty materials company thatengineers and manufactures a wide variety of products essential to everydayliving. As part of the SAP-ERP program, SAP-BI (Business Intelligence) willbe implemented as an Enterprise Data Warehouse. SAP-BI will follow theEnterprise Data Warehouse approach to become single source of truth at thecorporate level. Existing data marts and Enterprise SAP will feed data tothis Enterprise Data Warehouse enabling centralized reporting and analyticsfor Operational, Managerial, Executive and Leadership Teams. Responsibilities: . Involved in Design & Development of SAP BI Data Modeling and Front-end Reporting. . Data availability dashboard activities in SAP BOBJ. . Worked with Business Users to determine their reporting requirements in SD and HR Area. . (BI 7.0) Performed Data Modeling and Reporting requirement analysis and creation of queries based on business requirements; Build Info Objects, Infocubes (Multidimensional, BW Star schema), Data Store Objects (DSO), Multi Providers, and Infosets. . Extracted ECC data for Personal Management, Payroll, and Personal Administration in HR, Delivery, Shipping Document in Sales and Distribution. . Worked extensively with Sales Order, Billing, Delivery/Schedule line and Document condition objects. Enhanced the data sources 2LIS_11_VAHDR, 2LIS_11_VAITM and 2LIS_11_VASCL. . Worked extensively with Inventory Management using standard data source 2LIS_03_BF, 2LIS_03_UM and 2LIS_03_BX. . Extensively worked on building Queries using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Filters and Formulas. . Designed and maintained Universes using different schemas in the Oracle Database. . Created several Crystal reports, Webi Rich client reports and graphical presentation. . Created new Universes, Reports and modified existing Universes and Z -reports in SD/MM/HR. . Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in Universe using BO Designer. Defined Aliases and Contexts to resolve the join issues in the Universe, Solved the issues such as loops, traps, cardinalitiesand data mismatch. . Developed Drill down, Link Report reports, sub reports, used various Charts and Graphs like Bar Chart (Side By Side, Stacked), Line graphs, Pie Charts using Web Intelligence Reporting Tool. . Published and Migrated reports in Development/Test to Production Domains . Worked along with Functional & ABAP consultants on various enhancements projects for existing BW Reports across modules like HR and FI. . Worked with Production Support team for performance Improvements of loads/Reports by creating Aggregates , Indexes for lookup & parallel processing of loads . Experience in improving query performance using Query Cache, RSRT debug and defining aggregates. Improve Loading performance through DSO staging, created multiple Infocubes, BEx query structure, aggregates, compression, PSA packet sizing, change log deletion & partitioning. . Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius. . Planning for Nightly data loads for any new Module implemented and working on various performance initiatives to reduce loading time for timely data availability. . Responsible for scheduling reports as email attachments in xls or pdf formats. . Trained Business Users to create BEx& BOBJreports. . Production support activities &ticket resolutions.Environment: SAP BI 7.0/BW7.3, SAP BOBJ suite 3.x/4.0, BODS 4.0, andService desk tool.Pacific Sunwear, Nov 2011 - Aug 2012Parsippany, New Jersey
Project: Planner-Reward forExcellence(Implementation &Support)Role: SAP BW/BO Developer
Pacific Sunwear is a United States-based retail clothing brand rooted inthe youth oriented culture and lifestyle of California. The company sellslifestyle apparel, along with footwear and accessories designed for teensand young adults. The company operated over 800 stores in all 50 states.Responsibilities: . Worked extensively on Data warehousing workbench RSA1 (BI 7.x) . Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications. . Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications . Created reports using multiple data providers. Created ODS, Infocubes & Multi-providers and extracted SD data (Data sources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL) of SAP R3 into SAP BW using LO Cockpit(LBWE) extraction. . Worked extensively with Inventory Management using standard data source 2LIS_03_BF, 2LIS_03_UM and 2LIS_03_BX. . Involved in different phrases of the project like analyzing requirement, planning, execution and Maintenance. Worked with Flat files systems to load data into SAP BI. . Extensively worked with PSA in Monitoring the Data Transfer from source systems into BI . Uploaded master and transactional data from flat files and SAP as the OLTP source worked extensively on administration workbench (RSA1). . Created the customized objects using BEx Query Designer according to the business requirement and Functional Specifications.Worked on BEx Query Designer & BEx Analyzer by defining Variables, Conditions, Filters, Exceptions, Calculated key figure, restricted key figures. . Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.Generated various reports on Daily, Weekly, Monthly and Yearly basis . Created complex Universes, Linked with existing Universes from Data marts. Resolved loops, & created complex Reports, using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerts, cross tabs and other features. . Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those into user interfaces like excel files, PowerPoint representations for better understanding. . Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports / Business Objects. Business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports. . Coordinated with SAP OLTP functional and ABAP Team for Enhancements through FM &Exits. . Tested about 80 Business Objects full Client reports in the BOBJ environment. . Generating and scheduling standard and Ad-hoc reports using BO and Crystal Reports. . Worked closely with technical peers to insure successful integration of developed applications. . Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process. Created various validation reports between BW systems and BOBJ system.Environment: BI 7.x, Business Objects 4.x, Web Intelligence, CrystalReports 2011, Oracle 9i, & MS SQL.Lumbini Elite Solutions & Services Jan 2011 to Oct2011Client:Tyco, USAPrinceton New Jersey and Bangalore IndiaProject:(Global)KPI Product Performance(Development, Enhancement andSupport)Role: SAP BW/BODeveloperResponsibilities . As a BW developer involved in development activities of the project. . Redesigned custom cubes to improve reporting performance. . Integrated all the data in BW using Infosets and MultiProviders to create reports as per requirement. . Worked on generic extraction using Table/View to extract data from SAP R3 ERP system. . Customizing and activation the Business Content Objects and Loading the data into data targets. . Used BEx Query Designer to develop reports and facilitate data analysis using CKFs, RKFs, free characteristics, Exceptions, Conditions, Filters, Jump targets (RRI), Structures, formulas and Variables. . Gathered requirements from the management for functionality, display and effectiveness of the reports, Created initial Classes & Objects, qualification for the Universes in both on/off line modes . Designed and maintained Universes using different schemas in the Oracle Database. . Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those into user interfaces like excel files, PowerPoint representations for better understanding. . Created cross tabs, Charts, folding, filters, prompts, alerters and variables in designing reports. . Worked on SAP Business Objects Data Quality XI to do address profiling, parsing, standardization, cleansing, matching for master data such as org structure, customer and vendors. . Post completion of SAP BI configuration based on SAP BI as source creating Universes on top of BI queries and developing the BO dashboards, WEBI reports and placing all this reports in corporate dashboard and presenting these dashboards through info view to the management . Published and Migrated reports in Development/Test to Production Domains . Developed complex reports using Business Objects functionality like Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc. . Maintaining Reconciliation's to verify the data in SAP R3 and SAP BW on monthly and quarterly Basis. Maintained both the Master and Transaction data for the Infocube created in ERP sources. . Error Handling on Extraction, Data loading and end user issues on Reporting. . Daily Discussions with Team lead, Team members and Modeling as per the requirements.Environment: SAP BI 7.x/BW3.5, SAP ECC6.0, BOXI 3.1/3.2, MS Suite,Oracle11g, and XML-WS.Circle Consulting Ltd., Feb 2010 to Dec2010Client: ALFALAVALBangalore IndiaProject: (Implementation, Support& Maintenance)Role: SAP BI/BOAssociate ConsultantResponsibilities: . Handling BW in SAP ERP Applications.Activated, Installed and Extended Business Contents based on Gap Analysis established on user requirements. . Worked on DWH Workbench: Data Model - Designing & testing of Info Objects, Infocubes, Data Store Objects (DSO), MultiProviders, Infosets and Open Hub Services. . Worked in keeping DSO as staging layer before transferring the contents to the Info Cube. . Making all the reporting data targets filled with the Master data and Transaction data correctly. . Worked extensively on generic extraction, standard LO extractors, Installed relevant SAP business content. Used LO Data sources for extracting sales order, delivery billing information and scheduled data extractions in LO cockpit. . Worked along with ABAP Developers in Enhancing Standard Extract structures with Sales Order, Billing, Delivery/Schedule line and Document condition objects. Enhanced the data sources 2LIS_11_VAHDR, 2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_11_VDITM and 2LIS_11_VAHDR as per user requirements on SAP ECC ERP. . Used BEx Query Designer to develop reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures. . Communicated with ABAP Team for Enhancements through user Exits in BEx Query Designer. . Designed and maintained Universes using different schemas in the Oracle Database . Created several Crystal reports, Webi Rich client reports and graphical presentation. . Created new Universes, Reports and modified existing Universes and reports . Detected cardinalities, loops, and checked the Integrity of Universes . Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in Universe using BO Designer . Worked on all advanced reporting features in WEBi XI like Drill Down, Drill Up, Breaks, Scope of Analysis, Ranking and report level variable based filtering to create complex reports. . Created the customized objects according to the Functional Specifications. . Updating the data load status and sending the status of the loads every hour. . Handling Change request, data load details and designed Process Chains to trigger Multiple Data Loads. . Analyzed, designed, developed and tested reports while working directly with end-users and technical members of the teamEnvironment: SAP BI 7.x, BEx, SAP ERP ECC 6.0, SAP BO XI 3.1, MSSQL,Oracle11g, XML-WS,SHIRO TechnologiesInc.,May 2009 to Jan 2010Client: Multiple Business VerticalsDallas Texas and Mysore IndiaProject: OTC, PTP, FIAR/AP ReportsRole: Business AnalystResponsibilities: . Responsible for conducting workshops, requirement documentation, design and configuration of Sales Order process (OTC), (PTP) and configuration changes in Logistics and Execution. . Involved in the requirement gathering for floor care, production planning & supply network planning, . Instrumental in preparation of Blue print and data flow diagrams. . Designed Functional and Technical Design according the Project Requirements. . Involved in activating SAP Business Content objects and prepared custom objects where necessary. . Developed Custom BI Queries likeActual vs planned production quantities reports as per Customer Specific requirements. . Involved in show and tell of BI reports to the end users. . Involved in preparing the test scripts, designs and test execution in testing tool. . Involved in product test by running the test scripts. . Client Liaison & Documentation, Internal and External presentations. . Technical mentor to team members. . Understanding and ensuring implementation of quality standards (QMS) . Transforming, migrating, validating and reconciliation of data.Environment: Microsoft Business Suite, Oracle9i, MSSQL 2005, SAP BusinessObjects XI R2/R3, MS Excel Based Reporting and Crystal Xcelsius DashboardDesigner. |
