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 database 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 data, 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 data from various ECC modules, Salesforce, Teradata and third party systems to Global BW system.
• Developed data 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 Data 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:

Technical Excellance: BW Technical expertise version 3.0A to 7.4

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-PAGeneric & Business content

SAP Extractors: 2LIS*

FI: AP,AR,GL,CO, COPA

Reporting: BEx 3.x and 7.x, BO 4.1 Web IntelligenceTableau

RRI,Multi: Currency Translation keys, Workbook and WAD

Data Services 4.0: integration of Non-SAP systems / FIM / with BW using data services.

Tivoli: creation/ execution / Monitoring of batch jobs covering BW and DS process.

SEMBPS: Planning Area, Level, Profile

Planning function, Fox: formula, Planning Layout & folder, Integrated Planning

Configuration: V3 Updates (Serialized,Direct,Queued deltas)BusinessContents, OpenHubInfospokes (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-DP

PROFESSIONAL EXPERIENCE:

Confidential

SAP BW/BO Architect/Lead

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 reference 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, Data Services 4.0

Confidential, GA

Sr. BW/BPC Architect

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 data model design for Enterprise data warehouse layer, Architected data mart layer and reporting layer.
• Created Process chains for all Master data and transaction data loading from acquisition layer to data 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 Data 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 Data 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 data 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.0Data Services 4.0, Tivoli 8.4

Continental, NC

Sr. BI Lead Developer

Responsibilities:

• Integrated SAP R/3 data which is coming from COPA extractor with third party data (MODIAS).
• Compared Material Standard Price with frozen RDP data.
• 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
• Enhanced COPA extractor with the newly requested fields which are populated via CMOD
• Resolved performance issues via load balancing, parallel processes for DTP and SIDs activation, Number Range buffering to reduce NRIV reads
• Utilized tracing tools like ST05 for loading performance

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

Confidential

Responsibilities:

• Implemented LOCO module which includes Purchasing, Material movements and Inventory
• Harmonized these modules between newly acquired companies and Continental
• Conversion of material numbers and vendor numbers according to global Continental format
• Responsible for analyzing requirements, identifying the gaps between business content and the requirement and documentation of enhancement required for each plant.
• Involved in technical architecture and design of the overall implementation
• Worked with PMO in status tracking of the key deliverables involved in the implementation to be ready for go-live dates
• Worked with infrastructure team in upgrade and post upgrade activities for BWA revision 48.
• Responsible for monitoring and track the performance of back-end data loads and the front end query response time.
• Responsible for writing ABAP code in variable exits, start routines, expert routines, end routines and field level routines.

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

Confidential

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

Confidential

Responsibilities:

• Global implementation of Quality Tracking system from various regional ECC systems into Global BW system
• Created custom extractors to extract Quality data
• Master data 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

Confidential

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 data entered, reports are available to view this data by department, Task or Location.

Environment: SAP BI - 7.0, BW BPS.

Confidential

Sr. BI Lead Developer

Responsibilities:

• Created Cube’s for Key Performance Indicator to report on the data extracted from the custom application of R/3 which keep track of the customer notifications for the defective parts.
• Created Multiprovider to combine the data from deliveries, Quality notifications and also created Multiprovider to combine the data 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

Confidential, Dallas, TX

Sr. SAP BW Consultant

Responsibilities:

• Involved in modification of purchasing data 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 data extraction, transformation and loading.
• Worked with different users to gather business requirements and transformed them into a data model using extended star schema model.
• Extracted data 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 data to BW from R/3 in specific intervals.
• Created Multi Cube for analyzing the data 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

Confidential, Dallas, TX

BW Consultant

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 Data Sources, Info Sources, & PSA for Data 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 data.
• Created and maintained Info Spokes through Open Hub Services (OHS) to export data from the data 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.