SUMMARY:

• Overall 19+ years of Information Technology experience with over 10 years of experience in SAP BI/BW with four life cycle implementations in HR, SD, MM, PM and FI/CO modules. This includes 4+ years in BW HANA environment.
• Expertise in SAP BW (various versions s 3.5 - 7.5) configuration, reporting and OLTP extraction.
• Possess strong backend Data Modeling skills, including the design, architecture and data model.
• Experience in Data-Modeling, Data Extraction, ABAP Generic Extraction, Data Loading Scheduling, Monitoring, Infocubes, DSOs and creating process chains and troubleshooting BI issues.
• Strong functional side experience includes requirements analysis, Gap Analysis for business system and business processes.
• Participated in all phases of life cycle including requirement gathering, GAP analysis, designing, development, testing, deployment solutions, post-production support, documentation, and user training in SAP BW.
• Experience in creating HANA Attribute Views, Analytical Views, Calculation views, Creating Schemas, Packages using HANA modeler in HANA Studio.

TECHNICAL SKILLS:

Sap: SAP ECC 5.0, 6.0, SAP BW 3.5, BI 7.0 (NetWeaver 2004s), BI 7.3, BI 7.4, SAP BW on HANA 7.4 SP9 Business Objects Enterprise XI 3.1, 4.1, 4.2.

Languages: SQL, ABAP/4

Operating Systems: UNIX, Windows95/98/2000/NT and XP

Databases: MS Access, ORACLE 8i/9i, SQL Server

Office Automation: Microsoft Office (All versions).

Reporting: MS Excel, BEx, Information Broadcasting, Web Application Designer (WAD), Business Objects, Microsoft Analysis for Excel 2.3

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. SAP BW HANA Developer

Responsibilities:

• Worked extensively on Finance and Controlling module with functional users as well as business users to gather requirements and implementing them to report data accurately.
• Worked with business to implement re-organizational changes, which included making changes on both front-end as well as back-end.
• Implemented SAP Plant Maintenance module and implemented reports by enhancing models to meet users’ requirements.
• Helped Security team in streamlining the security model for both developers and users to reduce the number of roles resulting in less maintenance for security team.
• Conduct user training for BI power users to train them on how to use Analysis for Microsoft Excel.
• Provide leadership role to a team of four on-shore contractors and two offshore resources.
• Worked on different performance related issues to help reports perform better as well as back-end loading by implementing different strategies in place.
• Created various control reports in FI/CO subject area and made them available to users to spot reconciliation issues among ECC/BW and BPC systems.
• Support Finance closings throughout the year in SAP BW for the company.
• Wrote ABAP function modules to support newly built BW models as well as troubleshooting ABAP code written in existing models.
• Created new and modified existing Bex queries using Query Designer.
• Participated in upgrading BW on HANA system from 7.3 to 7.4 (application layer) and HANA database to different versions by working extensively with Basis and performing testing for them.
• Coordinated efforts with Basis team and business users to upgrade SAP Business Objects system from 4.1 to 4.2 as well as their client tools for all assets of the company in different regions.
• Participated and led a project to integrate BW on HANA to Enterprise HANA using Smart data access (SDA) technology.
• Designed and implemented SAP HANA data modeling using Attribute Views, Analytical Views, and Calculation Views.
• Built a strategy to expose BW models (BW on HANA 7.4) to HANA by making them available to spot fire/tableau.

Environment: SAP BW on HANA 7.3/7.4/7.5, ECC 6.0, BEx, BOBJ 4.2, BODS, MS. Analysis for Excel, Tibco Spot Fire 7.0, Tableau 10.0

Confidential, Houston, TX.

Sr. SAP BI Developer

Responsibilities:

• Gathered and analyzed reporting requirements related to SD, FI/CO modules.
• Optimized Process chains to load targets (both master data and transactional data) to improve performance.
• Created generic data sources to extract data from ECC system in addition to the standard SAP data sources as result of GAP analysis.
• Involved in production support of the system to fix/troubleshoot issues related to loads and reports including Cost&Allocations, SD and other modules’ reports.
• Worked with APO resources to implement changes in BW to support the model built in APO environment.
• Worked with ETM Functional team to create a customized hierarchy for 0Equipment Infoobject and get it successfully loaded into BW on weekly basis from ECC source system.
• Worked with highly customized SD solution created in ECC to duplicate it in BW environment and fixing it using SD standard data sources later on.
• Worked with Basis team to setup Business Objects 4.0 environment for business users/developers to use components such as WEBI, Crystal Reports and BOBJ Dashboards.
• Gathered requirements from Functional users to build dashboards using Business Objects 4.0 toolset for different SAP modules in Xcelsius as well as Design Studio in SAP BI.

Environment: SAP BI 7.3, ECC 6.0, BEx, BOBJ 4.0.

Confidential, Houston, TX.

Sr. SAP BI Developer

Responsibilities:

• Participated in all parts of ASAP methodology for the implementation of FI/CO module in SAP BI.
• Gathered and analyzed executive reporting requirements.
• Presented BI strategy and solution blueprint to steering committee for approval.
• Worked with upper level management to get SAP BI Data Flow approved and other necessary documents signed off.
• Worked with basis team in providing input for setting up BI environment.
• Set up info providers in BI system for BPC system.
• Created generic datasources to extract data from ECC system as well as utilizing standard SAP data sources.
• Created data targets to load data from MS SQL server into BI using DB Connect.
• Involved in Business Content activation, enhancement of data sources and writing user exits using ABAP (where necessary) on R/3 and BW.
• Implemented semantically partitioned object (SPO) for data provider, which stored data for GL to improve performance.
• Involved in production support of BW system, which included fixing defects both at back-end as well as front-end side.
• Utilized Information Design Tool and WEBi tool to create reports as well as creating some pixel perfect formatted reports in Crystal Reports tool.
• Published universes and WEBi reports to CMS repository to support reports built in Business Objects environment.
• Held training classes for super users on WEBi and other classes to make sure users are familiar with Infoview portal layout and its navigation.
• Held initial training classes for end users as well as Functional users on utilization of reporting tools provided by SAP in BI module.

Environment: SAP BI 7.0, ECC 6.0, BEx, Business Objects XI 4.0, Crystal Reports 4.0.

Confidential, Houston, TX

SAP BI Consultant

Responsibilities:

• Responsible for optimizing both back-end and front-end performance based on best practices and on project performance guideline documents.
• Provide guidelines to junior developers in designing and provide training to end-users on reports.
• Gathered requirements directly from users and functional users.
• Responsible to monitor process chains and troubleshoot any issues with loads.
• Provided on-call production support to resolve issues.
• Worked extensively on CO Module and re-defined back-end for Actuals, Planning, SKFs that involved analysis work of data sources and designing of all info providers (DSOs, info cubes, infoobjects).
• Re-designed previous BI builds to meet SAP quality standards and worked on performance issues.
• Created custom data sources with generic deltas for info providers in MM and FI/CO modules.
• Responsible to build and modifying existing queries according to client needs using BEx Query Designer.
• Designed Jump queries between IM and MM queries to find out the non-consumption materials across different locations.
• Integrated queries into roles supplied by portal group.
• Worked with other developers to provide input on technical designs across BI system to improve performance.

Environment: SAP BW 3.5/7.0, BEx Analyzer, Enterprise Portal, ECC 6.0.

Confidential, Cleveland, OH

SAP BI Developer

Responsibilities:

• Gathered business requirements and deliverables along with functional analysis in different business areas.
• Responsible for analyzing issues/problems, proposing solutions and implementing them as well.
• Configured and extracted data from LO Cockpit extractors, particularly in MM and SD by making use of the SAP defined datasources as well as writing user exit to populate newly added fields.
• Created new generic extractors and extracted data using Function Modules and different tables for Finance modules.
• Implemented BI Statistics to keep track of reports usage and utilized information broadcaster to present reports to senior management on weekly basis.
• Implemented openhub to transfer data from the system to flat files as well as sending data to other BI systems.
• Created Bex web application templates as iViews and published them on Enterprise portal.
• Monitored nightly process chains and corrected issues.
• Oversaw the project in which another BI system would get direct loads from U.S. BI system making U.S. BI System as source system.
• Utilized different techniques to improve performance on cube level as well as on reporting side.
• Analyzed report performance for statistics and implemented proposals for making the performance better.
• Involved in proof of concept project for Business Objects in which web intelligence and Universe Designer were utilized as well as publishing reports on the portal for users to view (Finance and SD Reports).
• Created universes based off of the cube and BI queries as well as exporting them to the repository to make available to the users for ad-hoc report needs.
• Utilized different techniques in Business Objects including graphs, drilldown, filters, cross tabs, sections, breaks, calculation, formula, trending and others.
• Trained end-users on newly developed reports as well as troubleshooting issues with existing reports.

Environment: SAP BW 3.5/7.0, BEx Analyzer, Enterprise Portal, WAD, ECC 6.0, Business Objects XI 3.0

Confidential, Cleveland, OH

SAP BI Developer

Responsibilities:

• Responsible for SD and Finance modules, which included data modeling as well as working with Front-End (Reporting) tools.
• Worked with different business analysts and end-users to gather requirements for new developments as well as working with them to perform data validation and testing.
• Created Profit Center Accounting cube and worked with various parties to gather requirements, data validation etc.
• Created a custom infocube to help company’s managers analyze where they can cut cost to save money.
• Created ODS objects to serve as data staging environment in most scenarios.
• Involved in writing routines in ABAP/4 to perform data manipulations as well as writing user exits for reporting variables to serve business needs.
• Modified master data objects and used information broadcaster to report newly added Cost Centers and Profit Centers to Finance managers.
• Responsible for data monitoring, performance tuning (creating aggregates, compression on BW side and creating indexes on PCA related table in R/3) as well as working on front-end to better query performance etc.
• Worked with security team to implement analysis authorization in BI environment.
• Worked on re-designing BI process chains (Master data and transactional data) scheduling (automation) and their maintenance.
• Created web templates using Web Application Designer mainly for global issue number project, which demonstrated the status of tickets, assigned to users.
• Utilized Information Broadcasting functionality to make it convenient for end-users to see their reports as well as creating links between different reports using report to report interface.
• Participated in training end-users to use reports and to demonstrate how BI tool can reduce strain on OLTP system.

Environment: SAP BW 3.5/7.0, BEx Analyzer, WAD, ECC 6.0

Confidential, Huntsville, AL

SAP BW Consultant

Responsibilities:

• Responsible for HR integrations, which included Data Modeling and Query building.
• Responsible for developing ODSs and infocubes on BW side for non-SAP source systems (Oracle and Flat Files) which include requirements gathering and working with Business Analysts for queries.
• Designed and developed custom data targets in HR module as well as implementing SAP delivered content.
• Responsible for creating Update rules to update data from multiple ODS objects to other levels.
• Responsible for extracting data from different source systems as well as monitoring nightly loads.
• Developed and maintained process chains for master data loads and transaction data loads.
• Created HR Headcount dashboard using web application designer as a prototype as well as creating in Cognos.

Environment: ECC 5.0, SAP BW 3.5/7.0, BEx Analyzer, Cognos, WAD

Confidential, Houston, TX

SAP BW Consultant

Responsibilities:

• Involved in the life cycle implementation of SAP BW, which included data gathering, gap analysis, Data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and web reporting for SD subject area.
• Worked and resolved issues with forecast, budget and actuals reports with the assistance of functional analysts to perform validation of reports.
• Actively involved in transports, troubleshooting and data validation with business analysts.
• Performance tuning of Queries by maintaining aggregates, compression, info cube partition.
• Worked on a project in which sales cube had to be re-designed due to poor query performance.
• Involved in Business Content activation, enhancement of data sources and writing user exits using ABAP (Master data and transaction data) on R/3 and BW.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements.
• Created Process chains for Master data and transaction data loads.
• Participated in GO LIVE and post go-live support.
• Worked on front-end and generated reports using Query Designer.
• Involved in production support, which included modifying and creating new queries as well as making modifications to the back-end objects.

Environment: SAP BI 3.5/7.0, ECC 6.0, BEx