We provide IT Staff Augmentation Services!

Bw Development Manager Resume

SUMMARY

  • Architect with overall 20 Years of IT experience with 14+ years of experience in SAP BW, BOBJ, ABAP/4 and HANA.
  • 3 years of Technical experience on Tableau Reporting, Tableau Admin activities, Multidimensional dbase and writing SQL queries
  • Extensively worked with Operations Team, Business Analysts and with core Business Team to design and build reports that exceed functional expectations.
  • Owns the ultimate responsibility for the technical solutions provided to the Business like displaying operational & strategic d, drill - down functionality, Financial KPIs and Sales Pipeline.
  • Communicates and accurately documents all architectural decisions, plans, goals and functional requirements.
  • Successfully completed multiple life cycle implementations in complex environment.
  • Designed and developed solutions to extract d from various ECC modules, Salesforce, Terad and third-party systems to Global BW system.
  • Developed d migration strategies and impact analysis on system consolidation projects
  • Trouble shoot and identifying root cause of issues and resolved production tickets.
  • Profound knowledge in taking necessary measures towards Performance improvements
  • Handled D load management, event processing and reporting optimization.
  • Maintained User profiles, Reporting authorizations and roles.
  • Supported Version and Support Package upgrades
  • Performed Pre- and Post-upgrade BW scripts for migration of 3.5 7.0 7.4.
  • Conducting workshop for analysis of the BRDs, gap analysis and creating technical specifications.

TECHNICAL SKILLS

  • BW/BI: Administration workbench, InfoCubes, ODS/DSO, Remote Cube,SEM-BPS,MDM, APD,OpenHub Dest,Archiving,BIA/BWA,Multicubes & virtual Cubes,ABAP Workbench on user exits, functions etc.,
  • SAP (ECC) QTC, RTC, PTP, GTS, HR, SD, MM, PP, QM, FI-AP, AR, CO, CO-PA, Generic & Business content,
  • SAP Extractors: 2LIS*, FI-AP, AR, GL, CO, COPA,
  • Reporting:BEx 3.x and 7.x, BO 4.1 Web Intelligence,, Tableau, RRI, Multi-Currency Translation keys, Workbook and WAD,
  • D Services 4.0: integration of Non-SAP systems / FIM / with BW using d services.
  • Tivoli: creation/ execution / Monitoring of batch jobs covering BW and DS process.
  • SEM-BPS: Planning Area, Level, Profile, Planning function, Fox-formula, Planning Layout & folder, Integrated Planning,
  • Configuration: V3 Updates (Serialized, Direct, Queued deltas), BusinessContents, OpenHub, Infospokes (Flatfile, XML),Reporting Agent (Precalculated Queries), Monitoring, Process chain & Extractors,
  • Security: 3.x and 7.x,
  • SAP R/3: ECC 6.0, 4.0B, 4.6B & C
  • BW: BW 7.4, 7.3, 7.01, 3.5, 3.1C, 3.0A, SEM-BPS/IP & BPC 7.5, 10.0
  • Other Skills COBOL, Jcl, Easytrieve Plus, VSAM, FORTRAN, PL/I, SAS, Pascal, C, C++, JAVA, JDBC, Java Script, HTML and Visual Basic, CICS (subsystem), IMS/DB and IMS/DC, DBASE, FOXPRO, STORED PROCEDURES, DB2 (ES/9000), Oracle 7.1, XPEDITOR, REVOLVE 2000, ENDEVOR 3.7.2, CHANGEMAN, SPUFI, FILE-AID/TSO 8.0, COMPAREX/ISPF, CA-7, ROSCOE 6.0, PANVELET, QMF 3.3, PLATINUM, SYNCSORT.
  • Upgrades: Planned and executed several functional and Technical upgrades, 3.0 to 3.1c, 3.1c to 3.5, 3.5 to 2004s, 2004s 7.0, 7.3 to 7.4 and support packages upgrades,
  • Functional Experience: Sales and Distribution (SD), CO-PA, FICO, MM, QM, Production Planning (PP) and APO,

PROFESSIONAL EXPERIENCE

BW Development Manager

Confidential

Responsibilities:

  • Worked on Estimates project to create reports and dashboards for future estimates for particular division and company code.
  • D extraction from non-SAP d.
  • Modeling HANA views in studio and Virtual Providers in BW to consolidate plan/actuals for Sales, spend and funds.
  • Developing Reports like, plan vs actual comparisons, ROI on promotions in BEX, WEBI and Tableau.
  • Automation of reconciliation processes to ensure d quality.
  • Creating Graphical and SQL Script HANA Views
  • Remodeling of HANA views to improve performance and maintenance.
  • Involved to get new requirements from the business.
  • Preparation of Impact Assessments and Design documents based on the technical specs.
  • Responsible for converting traditional BW d flows to HANA model.
  • Managing and handling enhancements to the existing HANA models.
  • Point of contact to handle Incidents/Enhancements/Service requests.
  • Handling end to end developments and enhancements on user requirements.
  • Handling of issues related to production support.
  • Maintain SLA adherence.
  • Managing of daily and weekly jobs.
  • Consolidation of a newly acquired business of worth $1b into Estimates Model.

Environment: BW 7.4 SP12, HANA 1.0.122, and ECC 6.0

SAP BW/BO Architect/Lead,

Confidential

Responsibilities:

  • Played an instrumental role in Organizing and conducting requirement gathering sessions with key users and management.
  • Played an instrumental role in Organizing and conducting requirement gathering sessions with key users and management.
  • Played an instrumental role in Organizing and conducting requirement gathering sessions with key users and management.
  • Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.
  • Worked closely with the end users on a day-to-day basis for their reporting needs. Created Architecture documents for the BW implementations with the naming standards
  • Based on Early Watch Reports recommendations by SAP, implemented the necessary changes to the systems like (Service Pack Upgrades, Missing Indexes, applying SAP Notes & housekeeping activities).
  • Generated tableau dashboards for sales with forecast and lines.
  • Used excel sheet, flat files, CSV files to generated Tableau ad-hoc reports.
  • Generated tableau dashboards with combination charts for clear understanding
  • Accountable for BI reporting for Sales, Billing, Purchasing and Finance modules which includes Service Profitability, Modified Open PO, Material Can build and Revenue reports.
  • Extensively worked on implementations of SAP HANA by creating information models like Attribute View, Analytical View and Calculation View.
  • Proficient in developing new features such as publishing HANA Models using Analytical Indexes, Composite Providers, SPO’s, Open ODS and Advanced DSOs.
  • Worked with Functional Teams to finalize design changes and involved in the Development.
  • Worked closely with team and improved several process execution durations.

Environment: SAP BW 7.4, BI 4.1, HANA 1.0, Salesforce CRM, D Services 4.0

Sr. BW/BPC Architect

Confidential, GA

Responsibilities:

  • Worked as a consultant leading a group of team members Developer in various phases of the project.
  • Coordinated and worked with Onsite and Offshore teams for the various project deliverables.
  • Worked and communicated with different teams associated with the project implementation.
  • Involved in d model design for Enterprise d warehouse layer, Architected data mart layer and reporting layer.
  • Created Process chains for all Master d and transaction d loading from acquisition layer to d warehouse layer, and finally to Architected data mart layer. Optimize system by means of RRI, compression, aggregation, partitioning, line-item dimension.
  • Involved in complete redesign of D flows for BPC System from SAP & Non- SAP Systems.
  • Performed knowledge sharing sessions with the team about the design process.
  • Conducted several meetings with Business and IT team to explain the logic on how the solution is derived.
  • Worked and communicated with different teams associated with the project implementation to integrate Solution and resolve any D quality related questions.
  • Expertise in Integrating Business Objects solutions including Web Intelligence, SAP Dashboards, Analysis for Office and BO Explorer with SAP BW solutions
  • Gathered User requirements, analyzed reporting requirements and created technical specifications for Budgeting and Financial Planning process
  • Handled Tableau admin activities granting access, managing extracts and Installations.
  • Create complex WEBI reports using multiple queries, merged dimensions, filters, variables for various Budget and LTFP scenarios reports connecting Live with SAP BW BEx query
  • Created ad-hoc reports to users in Tableau by connecting various d sources.
  • Worked closely with the client in all phases to design, build, test and deploy SAP BI 4.0 solutions

Environment: SAP BI 7.0 & 7.4, AIX, DB6, HANA, TD, BPC 7.5 and 10.0, D Services 4.0, Tivoli 8.4

Sr. BI Lead Developer

Confidential, NC

Responsibilities:

  • Integrated SAP R/3 d which is coming from COPA extractor with third party d (MODIAS).
  • Compared Material Standard Price with frozen RDP d.
  • Did Reporting against Plant/Segment/BU/DIV/Cluster/Category
  • Valuated Budget BOM with outside material cost (summary and detail)
  • Implemented Conti Vendor number and Master logic

Environment: SAP BI - 7.3, ECC 6.0. & ABAP/4

SAP BI

Responsibilities:

  • Responsible to come up with upgrade checklist.
  • Involved in assessment and feasibility study for BWA implementation of TEMIC and CAS
  • Responsible for pre-upgrade activities like redesign of queries written on ODS.
  • Executed most of the transitions after the system upgrade and make sure everything is working fine.
  • Involved in the Migration of 3.x objects to newer version.
  • Verified most recent OSS notes which are belongs to upgrade process.

Environment: SAP BI - 7.3 / 7.0 / 3.5/ 3.0

CQTS

Responsibilities:

  • Global implementation of Quality Tracking system from various regional ECC systems into Global BW system
  • Created custom extractors to extract Quality d
  • Master d alignment by conversion of Customer numbers to Global Continental format
  • Utilized WAD to build web reports

Environment: SAP BI - 7.0, ECC 6.0 and ABAP/4

IV Capacity Planning

Roles and Responsibilities:

  • Suggested BPS tool for this requirement
  • This tool has forms that allow team members and/or key users to enter forecast for the person based on the Task.
  • This tool has forms that allow team members and/or key users to enter forecast for the overall capacity for the selected person.
  • Based on the capacity planning d entered, reports are available to view this d by department, Task or Location.

Environment: SAP BI - 7.0, BW BPS.

V GQMCC

Responsibilities:

  • Created Custom Cubes for loading the d from Warranty System Application of customers which keeps tracks of the customer complaints and helps minimize the defective parts and hence the complaints from the customer.
  • Created Cube’s for Key Performance Indicator to report on the d extracted from the custom application of R/3 which keep track of the customer notifications for the defective parts.
  • Created Multiprovider to combine the d from deliveries, Quality notifications and also created Multiprovider to combine the d from different source systems for a global implementation
  • Created Variables, Filters, Exceptions, calculated key figures, restricted key figures, Global and Local structures and other features to meet user requirement.
  • Used WAD extensively to develop a web based application for Quality Management, created custom CSS and uploaded them to MIME Repository, uploaded company specific Logos and images, JS Files to mime repository and used them in Web Reporting.
  • Used Jump Queries to get to the detail level of information on quality notifications and also used the jump queries to jump to the R/3 Transaction.

Environment: SAP BI - 3.5/ 3.0, SAP R/3 4.7, ABAP/4

Sr. SAP BW Consultant

Confidential, Dallas TX

Responsibilities:

  • Involved in modification of purchasing d InfoCubes for scheduled lines and purchasing order item cube. Enhanced fields, purchase requisition number, cost center, company code, tax on sales/purchases, etc.
  • Extensively worked on d extraction, transformation and loading.
  • Worked with different users to gather business requirements and transformed them into a d model using extended star schema model.
  • Extracted d from SD and FI/CO modules of SAP R/3 and from flat files into SAP BW system using Generic Business Content and LO Extractors.
  • Created custom Info sources & Info objects in BW and mapped them with R/3 fields using transfer rules and Generic Extractors.
  • Used Delta Update, V3 update process for loading the d to BW from R/3 in specific intervals.
  • Created Multi Cube for analyzing the d between different modules and ODS for storing document level data and restricted the duplicate data.
  • User Exits/Enhancements in MM, and SD modules.
  • Used Query Designer, Web Application Designer to develop web reports.
  • Extensively used BEX analyzer and browser to build queries and worksheets to access SAP BW Info cubes. Hands on experience obtained on building queries by defining rows, columns, and free characteristics providing drill-downs, filters and other features.

Environment: SAP BW 3.1C, SAP R/3 4.6C, BEx Analyzer/Web Browser/Business Explorer, ABAP/4, Development Workbench, SD, MM and PP modules, Oracle 8i/8x, Windows 2000/NT

BW Consultant

Confidential, Dallas, TX

Responsibilities:

  • Interacted with management and end-users to gather the requirements and conducted GAP analysis.
  • Extensively worked on extraction, transformation and loading. Involved in creation of D Sources, Info Sources, & PSA for D extraction, transformation and loading from SAP R/3 system to SAP BW.
  • Analyzed and configured Info Objects, Info Cubes, Info Sources and Source Systems within the Administrator Workbench.
  • Installed the technical content cubes to update the Statistics d.
  • Created and maintained Info Spokes through Open Hub Services (OHS) to export d from the d targets to external logical source.
  • Extensively worked on FI/SL (Special ledger) extraction and reporting in SAP BW.

Environment: SAP R/3 4.6, SAP BW 3.0, SD, FI, MM, BEx Analyzer/Browser, Crystal Reports 8.5, ORACLE 8.1.7.2.0, UNIX. Windows NT.

Hire Now