SUMMARY

• Business Intelligence Architect/Developer with an in - depth experience in end-to-end implementations.
• Over 18 years IT experience, with Multiple Full Life Cycle projects involving SAP ECC, SAP BW, QLIKVIEW, Data Services, SAP BW on HANA, SAP HANA, Business Objects, Data Lake, Power BI, Tableau, Hadoop, Power BI, Cognos….and Service-Now.
• In-depth understanding of ERPs, SAP BW, BOBJ, Service-Now, Tableau, Hadoop,Power BI with knowledge of ABAP and SQL
• Involved in over 23 full-life cycle implementation across various industries.
• Primary BI solutions used recently are BEx, Business Objects, Power BI, Qlikview, Tableau, Cognos and Incorta
• Good understanding of Data Modeling, Data Analytics and Security.
• Experience with work across a wide range of methodologies and processes and interacted with stakeholders/partners across the company and with our customers.
• A large amount of experience working on data warehousing projects using agile methodologies.
• Worked directly with functional (process) teams to prioritize, understand, design, plan, manage, and deliver reporting solutions for the business. Met with business stakeholders to identify the enhancement needs of the activated business content and customized content.
• Experience in Building Reports, Dashboards and Scorecards to help Business easily analyze and access data for Planning.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Business Intelligence Architect /BW Developer

Environment: SAP BI 7.3 & 7.4, SAP BO 4.2, Design Studio, BEx Suite, ECC 6.0, Business Object Data Services, Tableau, Hana, Power BI, Hadoop, SQL.

Responsibilities:

• Work closely with Business Analysts, SME's and end users to understand the requirements in order to determine feasibility.
• Designs technical solutions that are in line with business needs while staying consistent with application architecture.
• Design and develop solutions using BW, BEx, Power BI, Business Objects, SQL development and Tableau.
• Navigate, understand, analyze and leverage existing complex data structures.
• Coordinate to implement best practices and methodologies in mastering data management and in designing physical data models.
• Investigate and troubleshoot data quality workflows or data quality issues.
• Design, develop, and test production fixes and enhancements per specifications.
• Proactively communicate issues to team to assist in managing defects .
• Ensured that development activities adhere to the team’s standards and best practices so that the overall business intelligence data integrity is maintained.
• Ability to design and develop in BW on HANA with SAP ECC as ERP
• Deep understanding of BW, BW-on-HANA. Eclipse based Modeling Tool, Advanced DSO, HANA composite provider. HANA Custom development, Calculation Views, modelling through HANA Graphical calculation views. ABAP and SQL, BW transformations
• Ability to understand and develop extraction methodology from SAP ECC
• Performance Tuning ability for end-to-end data load and reporting. Other major Responsibilities include
• Worked directly with functional (process) teams to prioritize, understand, design, plan, manage, and deliver reporting solutions for the business. Met with business to identify the enhancement needs of the activated business content
• Involved in complete life cycle implementation of SAP BW involving: project preparation, blue print, realization, Go-live and production support following several Implementation methodologies.
• Had series of meetings with business users and Stake holders to understand requirements and articulate solutions
• Implemented standard delivered content involving the activation of cubes, DSOs, multiproviders, queries among others.
• Solely responsible for the architecture of the several data flows. Determined data flows to utilize and what the right extractors were.
• Converted the activated objects from 3.5 to 7.0 versions and a later upgrade to 7.3
• Handled complex routine problems that came up due to the conversion from one version to the other. Identified what the issue was and fixed those errors.
• Good exposure to SAP functional areas and hands on experience with SAP modules -GTS, SRM, SD-sales Order, Plant Maintenance,
• Designing and developing the Technical specification document based on the functional specification document approved by Business.
• Performed several enhancements on most of the Sales and Service related Logistic Extractors in SAP ECC based on the Technical specification.
• Data source extraction optimization
• Built custom Function module based generic extractor for SAP Vendor Invoice management and replicated these data source into BW
• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Populated various data targets like Info objects, DSO’s and Info cubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area.
• Built POC based on SAP HANA for Confidential
• Built attribute view on MARA, MARC and MAKT tables to support operational report.
• Consumed BW Models in HANA for BOBJ Reporting. Global Spend reporting rolled out on BEx and Power BI
• Built analytical views and consumed in BW via Operation DSO and designed Virtual Data marts
• In- Memory content activation for BW on HANA. DSO, In Memory cubes and Composite providers, Hybrid providers for Reporting and analysis.
• Testing various Hardware architecture for HANA enterprise version and Schema setup for multiple systems on Single Node system.
• Designed BW Workspace using Master data in real time from HANA Views
• Requirement gathering sessions for analytics PTP, QTC, PTR and FI.
• Reporting Strategy for business objects. Designed Self Service Model for Adhoc Reporting.
• Designed Training Material for User Adoption for BI tools.
• Debugging the Extractor checker, Start routines and End routines
• Performance Tuning - Evaluated statistical performance and provided recommendations for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, init fills, roll up, attribute change run and DB stats etc.,
• Performed huge data loads into DSO and Info cubes from ECC as well as the legacy systems
• Developed Queries to access data from various BW Info providers like DSO, Info cubes, Info objects, Multiproviders and Infosets using BEx query designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures
• Currently involved in Integration Projects between Cameron and SLB for SLB Acquisition.

Confidential

SD, MRO, CRM Team Lead

Responsibilities:

• Involved in complete life cycle implementation of SAP BW/BI involving: project preparation, blue print, realization, Go-live and production support using ASAP Implementation methodology. Built Reports and Dashboards for analysis.
• Extensively worked on activating standard business content and major customizations as the project progressed based on Business scenarios.
• Worked directly with functional (process) teams to prioritize, understand, design, plan, manage, and deliver reporting solutions for the business. Met with business to identified the enhancement need of the activated business content
• Had series of meetings with business users and Stake holders to understand requirements and articulate solutions
• Implemented standard delivered content involving the activation of cubes, DSOs, multiproviders, queries among others.
• Solely responsible for the architecture of the selected data flows.
• Converted the activated objects from 3.5 to 7.0 versions and a later upgrade to 7.3
• Handled complex routine problems that came up due to the conversion from one version to the other. Identified what the issue was and fixed those errors.
• Good exposure to SAP functional areas and hands on experience with SAP modules -GTS, SRM, SD-sales Order, Plant Maintenance,
• Implemented a good part of logistics and CRM. Project deliverables covered SD, MRO, CRM PM and CS.
• Worked on several customizations needed to fulfill go-live critical reports involving ECC, CRM and BW configuration.
• Created several process chains to automate daily loads to over 40 cubes for all logistics and CRM objects implemented.
• Solely responsible for collecting transports to the test environment and testing objects as well
• Handled series of tests to validate BW data against ECC data.
• Solely responsible for creating data dictionaries and key figure matrix for all functional areas.
• Implemented some SAP notes to resolve certain issues that came up.
• Trained end users on how to navigate their way and run their reports.
• Production support. Participated in the workshops with the power users, business analysts and team members to analyze business requirements that were missed before Go-live
• Installed and configured Business Object3.1 and a later upgrade to B.O 4.0.
• Conducted several proof of concepts for BOBJ front end tools to the power users and the BW technical/functional team members.
• Created OLAP Universes to create webi reports and Xcelsius dashboards

Confidential, Dallas TX

SAP BI / BW Consultant

Responsibilities:

• Involved in complete life cycle implementation of SAP BW involving: project preparation, blue print, realization, Go-live and production support using ASAP Implementation methodology.
• Worked on activating the standard delivered business content of SAP HR-Learning Solution LSO 200 ( 0HR LSO 1, 0HR LSO 2 ) and Info cubes OLSO C02, OLSO C01, for Resource reservations AND training Management and was responsible for customizing it.
• Main queries worked on included Annual Comparison of Resource costs, Training and Education by Organizational Assignments.
• Involved in the activation and customization of Payroll, Personal Time Management Web Templates.
• Extensively worked on activating the standard delivered business content of Benefits and Benefits Area- 0HR PA BN 1, and created various workbooks based on Cost and Participation.
• Extensively worked on activating the standard delivered business content of FI like FIAR CO2, FIAR C03, FIAP C02, FIAP C03, in the form of InfoObjects, InfoSources, InfoCubes, DSO and customizing it.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals. Created InfoSources, InfoCubes, Aggregates, DSO for incoming sales orders according to sales organization
• Involved in volume and stress test - testing the extractors, data loads and reports before going into production.
• Used Open Hub Service per client’s requirement to transfer data from InfoCubes, ODS and Info Objects to external Data marts.
• Used Process Chains to automate data load processes, maintaining BW statistics, rollup of BW aggregates.
• Created Info packages for uploading master and transaction data, Process chains for daily delta loads.
• Worked on performance optimization with Aggregates & BI Accelarator, creating secondary indexes for ODS, Improved BEx query performance using query read modes and aggregates. And general load and extraction performance by load balancing and data packet sizing.
• Designed flexible reports using web application designer, query designer in Business Explorer Analyzer to facilitate data analysis in a summarized manner or drill-down to more detail levels
• Utilized some ABAP codes in generating some complex reports.
• Identified and resolved issues during production support.

Confidential

SAP BI Consultant

Responsibilities:

• Translated complex Functional Specifications to detailed Technical Designs.
• Modelled and built SAP BI Infocubes and underlying DSOs in order to deliver complex reports.
• Loaded BI system from different source systems (including R/3 or ECC) and flat files and tables using different extraction tools.
• Managed BI content and support through upcoming upgrades and patching.
• Extracted data using CO-PA (cost based) for analyzing the data on various criteria’s/partitions like cost centers, companies, controlling area, regions to compare cost of sales or overhead costs, product costs using business content
• Created data sources for CO-PA, performed extraction and activation of CO-PA published key figure and quickstart and management
• Created InfoSources, ODS objects, InfoCubes and developed update rules for the CO-PA InfoCube.
• Activation of standard extractors for the required application component in LO Cockpit, Worked on the data sources 2LIS 11 VAITM, 2LIS 12 VCITM, and 2LIS 13 VDITM.
• Worked extensively on configuration using Administrator workbench.
• Loaded Data on a Daily and Monthly basis, Monitoring data loads, Analyzing and fixing any failed data loads.
• Developed key reports on data targets at Sales organization, Distribution channel and division level.
• Worked extensively on BEx Analyzer and created queries using BW-Reporting Variables, Navigational attributes and Filters. Developed workbooks, InfoSet Queries and used RRI jump queries to drill down to other queries and R/3 transactions.
• Extensively used calculated and restricted key figures, restricted characteristics, structures, variables and conditions for the queries.
• Developed front-end queries and reports using Web reporting tool and Web Application designer.
• Developed reports using Business Explorer that had exceptions, conditional formatting, restricted key figures and calculated key figures.
• Improve system performance by maintenance of aggregates
• Transported developed objects into QA for testing and subsequently to Production
• Extensively used BEx analyzer and the Web Application Designer to generate Sales analysis,
• Applied restricted key figures, calculated key figures, variables, conditions and exceptions to query definitions as dictated by client requirement.

Confidential

SAP BW Consultant

Responsibilities:

• Translated Functional Specifications into Technical Specifications and performed full life cycle implementation of SAP BW using ASAP methodology
• Extensively used prominent functionalities of BI 7.0 - DTP, Transformations, and DSO.
• Successfully installed and activated the appropriate business content for FI/CO and SD.
• Leveraged query designer in handling various reporting requirements.
• Responsible for testing extractors, data loads and reports before transport into production.
• Effectively monitored the Data Transfer from Source Systems into BW using the PSA.
• Enhanced extract structures with the user/function exits in CMOD
• Performed Delta Management processes.
• Created and maintained process chains for automation of data loads - transaction data, master data, and currency exchange rate tables.
• Designed and developed several Custom Cubes, DSO, Infosets and Multiproviders. Performed enhancements on Accounts Receivables (AR) cube 0FIAR CO2.
• Modeled Data targets to suit the reporting requirements presented.
• Optimized system performance by leveraging Transfer Structures, Communication Structures, Update Rules and Start Routines.
• Developed various analysis reports (such as Customer Sales Trend, Days overdue, Current Period, Incoming Orders and Product Profitability in SD, Actual Contribution margin in Sales)
• Worked with translation keys to do Currency conversions. RKF and CKF for reporting needs
• Performed standard, application specific and generic extractions( LO Cockpit, LIS, CO-PA, and FI/GL extractions)
• Sent data from BW to External Systems using the SAP Open Hub service.
• Provided comprehensive end user training and knowledge transfer to permanent staff.