SUMMARY:

• Over 16+ years Informational Technology experience with 8 years of SAP Net Weaver BW 7.0 - 7.3 and SAP ECC 6.0 with 4 Life Cycle implementations.
• Excellent technical knowledge of “Backend” BW Development balanced with substantial “Frontend” BEx Query Designer/Analyzer and BOBJ 4.0 - 4.1 Reporting Skills.
• SAP BI Trainer and SME Mentor to Jr. Users.
• A team player with the proven ability to influence and foster collaborative relationships to push projects across the finish line.
• Consistently maintains the highest standards of personal and professional performance with integrity, “Creatively I get the job done”.
• In an effort to offer the best in SAP BI/BW support I am pairing my
• 16 YEARS IT industry Development.
• 8+ years SAP Enterprise Data Warehouse (EDW) Development with
• 4 Life cycle Implementations, Bridgestone OTC, Southwire SD, Confidential SD, Equifax FI
• SD, MM, FI-AR, FI-AP, FI-GL, PURCHASING, CRM, LO and ISU
• Government, Public Sector, Manufacturing, FI, Aerospace/Defense, Healthcare and Pharmaceutical.
• 8+ Years SAP BW Back-end Data Modeling:
• SAP BW Back-end Data Modeling with Numerous Projects has given me a Broad experience in BW Architectural, “BEST PRACTICE” Methodologies and Standards; such as the “Agile” and the “ASAP” Methodology as the Road Map to a successful BW implementation.
• Business requirements meetings using Gap Analysis and KPI workshops applying business functional requirements to technical specification documents, RICEFW functional design development and Solution Manager.
• Leveraging SAP BW technical solutions to enhance and optimize Client’s business performance.
• Successful BW upgrades from 3.5 to 7.x, (rules, datasource and infosources) and Data migrations from legacy data-warehouses
• Multidimensional Data Modeling, Extended Star Schema. Data Sources, IP, PSA, DTP, DSO, Transformation, CUBE AND MP, PROCESS CHAINS.
• Conducted UNIT, SIT and UAT testing, creating Batch Jobs SM36/SM37
• ETL, leveraging standard BW extractors, Logistics and Generic Extractors
• Cut-Over, Stabilization, Post Go-Live, Ticket Resolution with HP QC
• Performance tuning, Aggregation, BIA, Compression, DTP, Partitioning
• Coordination of the 24x7 Production support with the offshore team. 8 Years SAP BI Front-end Analytical Reporting:
• Creating, enhancing and “tuning” of SAP BEx Query Designer Reports,
• Proficient with BEx Analyzer, and training users with BEx tool suite.
• BOBJ 4.x, using the BOBJ Tool suite; IDT, WEB Intelligence, DESIGN STUDIO and BODS.
• Hands on Modeling experience on BW 7.3 on HANA Studio, in design of artifacts & mechanisms.
• Design and Development of HANA Attribute, Analytic, and Calculation Views to be consumed by either Business Objects report, dashboard, an all-inclusive Business Objects self-service universe
• Implement: create database schemas, compose views, and develop scripts.
• Identify and develop procedures for Attribute Views, Time Attribute Views and Derived Attribute Views
• Familiar with HANA BODS Data Services
• Managing Attribute Mapping, Creating Joins by connecting Tables
• Creation of Restricted Columns and Input Variables.
• Creating Filters and Calculated Columns
• Leveraged ASAP methodology as roadmap to successful OTC implementation with CRM.
• Estimated Work Effort to create Project Time Line from Phase 1 - Project Preparation through GO-LIVE and Performance tuning.
• Leveraged GAP analysis discoveries and identified KPIs to drive Client’s key business decisions to support the OTC, P2P and C2C Project
• Working closely with the User Community to interpret functional documents and logical modeling to create Technical Specification documents addressing and enhancing Clients OTC, P2P and C2C Business Strategies. Conducted SAP Tester from Unit testing to UAT and ETL Tester.
• Using the BW AWB (Administrative Workbench) to Load, Develop, enhance and activate SAP BI Standard Content to maximize Client ROI.
• Experience with SAP BW/BI Tools such as BEx Analyzer, Process chains, BEx Web, OLAP, MDX, BW Administrator Workbench and BEx Query Designer.
• Architect experience with e xpert understanding of MDM (Multidimensional Data Modeling) Development of BW Back-end, created InfoObjects such as InfoProviders, DSOs, Write optimized DSOs, Standard DSOs, InfoCubes and MultiProviders to Transformations, ABAP Start Routines and End routines. SAP Trainer.
• Experience with analyzing system performance, database loading performance, system health checks, and implementing tuning improvements in an SAP BI/BW environment.
• Developed of BW back-end loading strategies to optimize the daily production data loads to effectively reduce the nightly run-times by incorporating “Event Driven” Process chains.
• BI/BW experience in implementation, support & maintenance operations including BPC
• Conducted User Acceptance Testing “UAT” using HPQC and Remedy Ticket Management.
• Coordinated 24/7 monitoring of data loading efforts with “off-shore” resources supporting BW Production systems.
• Expertise in developing BI Reports using the BEx (Business Explorer) tool set as the Data set for Business Objects Tool suite and Design Studio for analytical reporting.
• Strong experience in implementing Web Intelligence Reports using BICS connections BOBJ 4.0 - 4.1 using the BEx Queries as the Report Data set.
• Skilled at developing reports in Design Studio graphical Analytical Reporting with Charts and graphs and BODS for data transformation skills.
• Experience at training the Stake holders and Power users principals of BW design overview as it pertains to Points of Report Data Validation.
• Experience with Business Objects Design Studio BW and HANA . Building Universes on top of HANA using HANA Studio IDT.
• Trained User community on BI BEx Analyzer and BEx Query Designer as tool set to create BOBJ 4.0 WEBi, Advanced Analysis Reports for “Self Service Analytic Reporting”.
• Created the BEx OTC “Billing Finance Score Card” Report as Client KPI to customer satisfaction matrix.
• Experienced in BW and BOBJ Integration, created BOBJ 4.0 and 4.1 reports in WEBI and Analysis for OLAP, training users on BO 4.1 environment. Class room led SAP Trainer.
• Responsibilities included working with the BASIS team and Security teams to handle BOBJ Report Promotions and User access.
• Created highly formatted Financial Balance sheets with Crystal Reports for USA and Canadian OTR (Off the Road) and AG (Agricultural) Tire Sales reports to Japan
• Strong communication skills, oral and written including ability to conduct informal presentations and workshops.
• Ability to work in a fast-paced, dynamic business environment.
• Ability to provide timely response, updates and technical resolution to ensure client Satisfaction is maintained at all times.
• Ability to work independently as well as in a team environment.
• Ability to work well with others and collaborate to get project and tasks done.
• Ability to consistently meet project deliverable deadlines.
• Excellent communication and Soft skills for Client “Face to face” meetings
• Ability to work non-traditional business hours in support of IT operations and assist in the design and deployment of systems at other global sites including ability to travel +/- 25%

TECHNICAL SUMMARY:

OPERATING SYSTEMS, DATABASES, UTILITIES AND SERVERS: Microsoft Windows XP, Vista, Windows 7, Server 2K and 2003, Solaris 9-10, AIX 5.3, Linux CentOS, Ubuntu, Oracle 9-10g,2003/2007, MS Visio, MS Outlook, Symantec Antivirus, Norton Ghost, RIM Blackberry, PostgreSQL, FTP, LAN/WAN, LOTUS NOTES, MS Project, Remote access RDP, Terminal Services, Remote Administrator, VNC, VPN, PC Anywhere, MS Visio, ERP, SAP R/3, ECC 6.0, ETL, BI 7.0, BW, OLTP, OLAP, FI CO, IMG, SPRO

WORK HISTORY:

Confidential

SAP BI/BW Developer-Lead

Environment: HANA 1.0 SP9, BW 7.4, BO 4.1, BODS 4.2, ECC 6.4 EHP6

Responsibilities:

• Architect experience, was tasked with the responsibility to design, define, develop, and deliver Global analytical reporting for the “Sales Compensation Tool” following the ASAP methodology from BW Data flow to Front-end BOBJ WEBi
• Created the SAP BW Data flow (from Data source to MultiProvider) On the Confidential Sales Compensation Tool data feed a FF to include the Creation of the BEx Query Designer to be consumed by BOBJ Web Intelligence 4.x for Analytical Reporting.
• Supporting the Sales Compensation OTC Tool by loading the Confidential FF data into the SAP BW data flow through to the “Dream Cube” and MultiProvider. Create BEx Query Designer queries to be consumed by the BOBJ WEBi Analytical reports.
• Multidimensional Data Modeling of Confidential ’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Using SAP BW 7.4 Experienced in Collecting and Installing Standard BI Content, Loading data using LBWE and Generic Extractors.
• Experience in SAP ECC 6.x with Purchasing and AP Module.
• Back up to OTC Production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule and ETL Tester.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing BW Queries and Modeling Data for Business Objects reporting using WEBi and Advanced Analysis. Conducted SAP Tester from Unit testing to UAT
• Work with end users on the Systems, Applications and Products (SAP) application's integration and functionality; determine those technology inadequacies and/or deficiencies that can affect the functional area's ability to meet the organizational goals.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries.
• Customized FF extractions to transport JDE data into Data flow to PSA, DSO, and cube and to the MultiProvider, for reporting Analytics.

Confidential, Jackson, MS

SAP BI/BW BOBJ Developer-Lead

Environment: SAP BI 7.3, ECC 6, Business Object 4.1

Responsibilities:

• Technical Lead and architect of 8 person team conducting SAP activities from architecture development of BW backend Data Modeling to BI front-end enhancements to be consumed by Web Intelligence and OLAP Analysis Reporting Tools.
• Developed Webi Training syllabus to “Lecture” train State employees Webi and OLAP Analysis reporting, to create a Self Service Analytical Reporting environment.
• Responsibilities for coordination of Team of 7 resources to support and respond to State Reporting issues from Back end, Business Warehouse data loads, to Front end Published BOBJ Reports to the Public Web Site.
• Deliverables include creating custom Confidential ’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Work with end users on the Systems, Applications and Products (SAP) application's integration and functionality; determine those technology inadequacies and/or deficiencies that can affect the functional area's ability to meet the organizational goals and mission requirements.
• Experience in SAP ECC 6.x with Purchasing and AP Module.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries.
• Back up to Production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule and ETL Tester.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing BW Queries and Modeling Data for Business Objects reporting using WEBi and Advanced Analysis.
• Maintaining the Data Dictionary to support the BOBJ UDT Reporting Structures.
• Design, develop and maintain reporting and analytic elements as required to support BOBJ/BW environments, training users on BO 4.1 environment. Class room led SAP Trainer. Conducted SAP Tester from Unit testing to UAT
• Customized LO-Cockpit (LBWE) to transport data into DSO InfoObjects, Using Extractors

Confidential, West Chester, PA

SAP BI/BW Developer

Environment: HANA 1.0 SP8, SAP BI 7.03, ECC 6, Business Object 3.0

Responsibilities:

• Responsibilities for deliverables include Creating custom OTC Multidimensional Data Modeling of Confidential ’s, info-objects, Cubes and Multi-providers.
• Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes.
• Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries
• Back up to OTC Production, Monitors Billing data loads, researches load failures and resolves issues. Maintains production load schedule.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experience designing BW Queries and Modeling Data for Business Objects reporting using WEBi and Advanced Analysis.
• Maintaining the Data Dictionary to support the BOBJ UDT Reporting Structures.
• Design, develop and maintain reporting and analytic elements as required to support BOBJ/BW environments. As SAP Tester for COE conducted testing from Unit testing to UAT.
• Customized LO-Cockpit (LBWE) to transport data into DSO InfoObjects, Using Extractors

Confidential, Wichita, Kansas

SAP BI/BW DEVELOPER

Environment: SAP BI 7.01, ECC 6, Business Object 4.0

Responsibilities:

• Created custom Confidential, info-objects, OTC Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes.
• Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, ABAP conversion tables, Process chains, Info Sources and Quarries
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Strong functional side experiences using SAP ASAP Methodology coupled with Gap Analysis to in corporate the latest technology to develop business solutions that increase customer efficiency, productivity and profitability.
• BW operations: Data load management, ETL, experience in scheduling Process Chains and Loading (Full Init / Delta Up-Load), Monitoring, Data Mart, BW Transports
• Customized LO-Cockpit to transport OTC data into Data source to DSO, Using Extractors (LBWE)
• Created calculated and restricted key figures. Defined default variables, Off-set queries and created Reports using Formula Variables with Processing Type Replacement Paths.

Confidential, Carrollton, GA

SAP BI/BW Developer BOBJ

Environment: SAP BI 7.3, ECC 6, Business Object 4.0

Responsibilities:

• Interact with business users to analyze and gathered requirements for reporting, both for detailed and executive level of Sales & Distribution and Inventory.
• Design the High level overview of the architecture.
• Built and enhanced BW objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, DSO, Extractors, Infosets, Aggregates, Process Chains, DTPs, ABAP conversion tables, User Exits, BADI.
• Worked with Business Stakeholders, IT Infrastructure teams, and Development teams to capture business requirements to develop business solutions that increase customer efficiency, productivity and profitability.
• Work on standard and custom defined LO and LIS extractors. Install relevant SAP business content.
• Used LO structures for extracting sales order, delivery billing information.
• Created custom Confidential ’s, info-objects, Cubes and Multi-providers.
• Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes.
• Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Create Bex Queries for the Commissions, Transfer Pricing, Billing and Sales Order Reporting that requires to the users which initially estimated for every two hours.
• Conducted Customer requirement workshop sessions to discover KPI’s and actively involved in requirement analysis for reports analysis.
• Created calculated and restricted key figures. Defined default variables, Off-set queries and created Reports using Formula Variables with Processing Type Replacement Paths.
• Involved with hands on development, lending technical expertise to developers and successfully meeting timelines.
• Performance Tuning, Data loads optimization and Technical Support during stabilization.
• Meetings with Solutions Leadership team on a weekly basis communicating status, suggestions and negotiating any scope creep.
• Actively involved in design and implementation of integrating the Financial and Operational business requirement and Operational of FI
• Troubleshoots and corrects BW application problems by using appropriate SAP tools and implementing OSS Notes.

Confidential, Nashville, TN

SAP BI/BW OTC Developer

Environment: SAP BI 7.03, ECC 6, Business Object 4.0

Responsibilities:

• Built and enhanced OTC BW objects such as InfoObjects, InfoCubes, InfoSources/Data Sources, Master Data, Transformations, Update Rules, DSO, Extractors, Infosets, Aggregates, Process Chains, DTPs, User Exits.
• Worked with Business Stakeholders, IT Infrastructure teams, and Development teams to capture business requirements to develop business solutions that increase customer efficiency, productivity and profitability.
• Created custom OTC Billing and Sales Analytical Confidential ’s, info-objects, Cubes and Multi-providers. Loaded and Activated BI standard business content and enhanced InfoCubes and created Custom Cubes. Defined and set-up hierarchies, Navigational attributes, aggregates and Roll-ups.
• Experienced in Collecting and transporting Business Content from Development environment to Quality and Production with all its dependent objects like Cubes, DSOs, Process chains, Info Sources and Quarries
• Improved data loading performance for sales and delivery by limiting data packet sizes, scheduling index deletion and rebuilding jobs through Process Chain Configuration. As a result of these efforts data loads were conducted successfully with reduced loading time.
• Experienced in OTC BW and BOBJ Integration, created BOBJ 4.0 reports in WEBI and Advanced analysis. Portals for Dashboards, training users on BO 4.0 environment. Class room led SAP Trainer.
• Conducted Customer requirement workshop sessions to discover KPI’s and actively involved in requirement analysis for reports analysis.
• Created calculated and restricted OTC key figures. Defined default variables, Off-set queries and created Reports using Formula Variables with Processing Type Replacement Paths.
• Performance Tuning, Data loads optimization and Technical Support during stabilization.
• Trained the Power Users BOBJ skills in Stand up Lecture environment, teaching the skills of BEx Query Designer, WEBi and Advanced Analyzer.
• Troubleshoots and corrects BW application problems by using appropriate SAP tools and implementing OSS Notes.

Confidential, Atlanta, GA

Consultant SAP BI BW

Responsibilities:

• OTC Data Extraction, cleansing, Implementation and Enhancement of Business Content for Ad-hoc reporting and forecasting to support a multi-site, multi-country customer base.
• Strong functional side experiences using SAP ASAP Methodology coupled with Gap Analysis to in corporate the latest technology to develop business solutions that increase customer efficiency, productivity and profitability.
• OTC BW operations: Data load management, ETL, experience in scheduling Process Chains and Loading Monitoring, Data Mart, BW Transports
• Customized LO-Cockpit (LBWE) to transport data into DSO InfoObject, Using Extractors 2LIS 11 VAHDR, 2LIS 11 VAITM to set the extraction process.
• Deliverables include: # Generation of BW Extractors in BI System. # includes creation of Confidential /CUBE for Sales order management. # Creation for master data extracts for order type/ Plant/ Sales/org/ Material/Customer BEx Reports.
• Experience Integrating FI-AR to Sales in the SD Module and Integrating FI-AP module to the Procurement cycle in the MM Module.
• Responsible for creating Queries and BW reports using Web Application Designer (WAD) and BEx/Analyzer filtering with Calculated Key Figures, Structures, Variables Exceptions and Conditions.
• Materials Management and Inventory Control of Finished Product assembly and Shipping logistics.
• Created and scheduled Process chains for daily delta loads to the data mart.

Confidential, Atlanta, GA

Consultant BI BW

Responsibilities:

• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using Business Content.
• Define Master Records for G/L, A/R, A/P and Reconciliation accounts.
• Designing Queries for reporting on GL, AP, and AR using BEx and Crystal Reports.
• Worked with the Power Users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEx Query Designer.
• Conducted multiple workshop sessions with Customer to discover KPIs during the requirement gathering to analyze the business requirements, worked on gap analysis and identified existing business content as well as areas for enhancements.
• The team configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, Confidential, Cubes, Aggregates, queries and workbooks.
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.

Confidential, Alpharetta, GA

SAP BI BW ANALYST

Responsibilities:

• Participated in all phases of life cycle including Requirements Gathering, SAP ASAP Methodology, Analysis, Design, Development, Testing, Deployment solutions, Post production Support, Documentation, User training for knowledge transfer.
• Configure different Variants, Master records, group accounts, G/L settings with AR, AP.
• Responsible for cross training and providing knowledge transfer to Power users.
• Configured DataSources by using LO Cockpit (LBWE) initialized the setup tables.
• Responsible for creating Queries and BW reports using BEx Query Designer and BEx Analyzer filtering with Calculated Key Figures, Structures, Variables Exceptions and Conditions.
• Experience designing BW Queries and Modeling Data for Business Objects reporting and highly formatted Financial Balance sheets with Crystal Reports.
• Conducted unit tests, component integration tests and Customer acceptance testing (UAT) to ensure adherence to test plan and functional requirements.
• ID Administration and Client side configuration on Oracle 9-10g DB Warehousing.