SUMMARY:

• Successful information technology professional with more than 10 years of diverse and extensive experience focusing on systems analysis and design, training, documentation and systems migration.
• Proven achievements in providing hands - on guidance with SAP BW /BI, SAP HANA and other software applications deployment.
• Over five years of SAP Functional Experience in SAP BW/BI and BOBJ including reporting tools Web Intelligence, Xcelcuis, Crystal Report, Lumira, BEx Analyzer, Design Studio and Fiori.
• Experienced in SAP HANA data modeling using Attribute, Analytic and Calculation Views. Knowledge in using SAP BODS.
• Four SAP BW full lifecycle implementations with SAP BW 7.x including data modeling, extractions, data staging, loadings, transformations, and reporting.
• Extensive experience working with extractors for SD, MM, SRM, SCM, CRM, and FI.
• Strong expertise in ETL techniques. Extracted data from OLTP using LO Cockpit, BI Content, and Generic DataSource methodologies.
• Extracted data from Flat files.
• Modeled InfoCube and ODS objects, and installed Business Content objects.
• Experience in creating and monitoring Process Chains, Data Validation and Verification in BW and ECC. Strong expertise in BEx Reporting and Information Broadcasting.
• Expertise in using Variables, Conditions, and Exceptions. Worked InfoSets and Multiproviders.
• Experience in Data Maintenance and Performance Tuning, SAP BW Accelerator (BWA) and Aggregates.
• Expertise in using Open Hub Service for exporting data from BW server to flat files.
• Strong knowledge of all phases of a projects life cycle including requirement gathering, Design, Implementation, and Troubleshooting scenarios (ASAP Methodology). Strong analytical, troubleshooting, and problem solving abilities.

TECHNICAL SKILLS:

SAP: BW/BI 3.5, 7.0, 7.4, Hana.

Reporting Tools/Designing tools: BEx, Query Designer, BEx Analyzer, and SAP Business Objects BI

Languages: ABAP, Java, JavaScript, PearlScript, XML, ASP, JSP, SQL Plus and HTML

Database: Informix, Oracle,DB2,MS SQL.

PROFESSIONAL EXPERIENCE:

Confidential, Stafford, TX

SAP BW/BI/Hana Analyst

Responsibilities:

• Migrating standard Infocubes to In-memory optimized Infocubes using migration Tool.
• Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
• Importing the BW Models in to HANA using HANA Studio
• Design and Develop SAP HANA tables, procedures to extract data from SAP ECC, transform and load in SAP HANA, HDFS using DS jobs.
• Performed End-to-End BW Configurations and Customizations from Extraction, Staging, Loading, Performance, Transports, Reporting using BEx Analyzer.
• Identified and installed/activated different InfoSources in ECC 6.0
• Analyzed and Designed new data models using SAP BI 7.x objects i.e.
• MultiProviders, Infocubes, Info Objects, Data Store Objects, Extractors, Transformations, Start Routines, End Routines and DTP's to meet new reporting requirements.
• Conducted performance tuning of complex data loads and data conversion processes using advance BI 7.0 and 7.3 functionality to improved response times. Used BW Accelerator for query performance.
• Extracted data from SAP R/3 using LO Cockpit, Generic Extractions and data from flat files. Managing the SAP BW/BoBJ initiatives with high customer interaction at strategic and operational level.
• Responsible for management of the project tasks and activities, including resource coordination, status tracking and communication of project progress and issues.
• Leading Project Blue print phase of identifying BW upgrade from 7.0 to 7.4 for meeting minimum requirement for implementing BPC 10.1
• Apart from that involved in analysis of business processes, scope business requirements, shaping up of solution architecture, assessment and delivery.
• Participated in efforts to implement and support operational business intelligence application solutions to satisfy business requirements. Involved in source system analysis, identified key data issues and performed data profiling.

Confidential, Houston, TX

Sr. SAP BW/BI/Hana Consultant

Responsibilities:

• Created SAP HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Created Attribute Views, Analytic Views and Calculation Views to model data.
• Integrated BO with SAP ECC and SAP BI 7.0 to build Universes.
• Compiled and reviewed customer requirement regarding different phases of a projects life cycle.
• Gathering requirements, Design, Implementation, and Troubleshooting scenarios (ASAP Methodology).
• Involved with the functional specifications information gathering and translating to technical specification documents for data model designs.
• Active role in creating and customizing the SAP BW Interactive Center Manager in the CRM module.
• Creating reports to follow different performance reposts for inbound call center.
• Administered SAP BW including activating of new standard content and custom content.
• Utilized SAP BO tools (Universe & WEBI) integrated with BW to present, analyze and report data.
• Customer required visualization of key data analysis using BO tools.
• D esigned and executed functions to see data profile for customers calling inbound to a call center.
• Created automated data load process chains and designed transformations rules,
• Worked with Business Explorer tools including BEx Analyzer and Query Designer (Calculated and Restricted Key Figures, Structures, Exceptions, Formulas, Filters, and Conditions)

Confidential, Houston, TX

Software Developer

Responsibilities:

• Involved in the development of internal call center application in the Windows environment using Visual C++ and SQL database. Have in depth knowledge of testing and quality control standards.
• Experience in software selling. Involved with the market research through the use of various databases and cold call analysis. Based on the result, created a full cycle marketing plan with customer incentives and rewards strategy.
• The accounting module consists of handling complex medical office transactions. Create and analyze complex financial reporting; collections, aging and revenue analysis.
• Business revenue grew with the addition of a new product line of medical paper business; paper, file folders, pre-printed statements and etc.
• Developed and supported medical billing and accounting software based on Unix platform. Software coded in C. Software geared towards small to medium sized hospitals and clinics. Help maintain and design the company website.
• Prepared business plans and conducted due diligence; assisted other team members in capital raising efforts.

Confidential, Chicago, IL

Associate Consultant

Responsibilities:

• Involved in debugging code. Made changes to the existing code in Broad Vision to eliminate bugs.
• The fixed code was thoroughly checked using various methods. The client did the final testing and approval of the code.
• Enhanced code where browser detection took place. If the user’s browser was not capable to handle the graphic content of the website it was directed to the appropriate website. User was able to download a browser which was capable to handle the content of the website.
• Assisted in implementing and designing of various documentation regarding the project.
• From gathering client requirements and specifications to creating the Detail Design Solution (DDS) document.
• Developed JSP files using Broad Vision technology.
• Files performed various e-commerce functions which helped the client’s legacy system to integrate with it’s current web-based application.

Confidential, Chicago, IL

Sr. Paginator/Team Lead

Responsibilities:

• Role: Team Lead of 4 software engineers. Corresponded with several managers of various department to conduct testing, and compared the data to the live system. Involved in QA, software and database testing.
• Implemented a new classified paginating system database; From Cayote3-Enscribe database to SCP/EDB-SQL database.
• Testing of the new system required entering general parameters of advertising data. Validity of the data was checked with the live system making sure the right tables were hit for the correct data in the database.