Objective: Secure a position in SAP as a Consultant/Developer SAP BW/BI.

QUALIFICATION SUMMARY:

• Over 14 years cumulative direct IT experience including 3 years of SAP BW and SAP R/3 experience in design and development.
• Involved as a key member of project teams through all phases of realization, go-live, rollout and post implementation support of SAP BW in SD and MM modules.
• Experience in working with standard and custom Info Cubes, Info Objects, Info Sources, ODS, ETL process and performance tuning.
• Worked with extensively with Business Explorer and Web Application Designer for web based reporting..
• Sound knowledge of various data design models – Entity Relationship, Multi Dimensional Star Schema and the Extended Star Schema model.
• Excellent technical, analytical, verbal, and written communication skills capable of working independently with minimum supervision as well as in a team.
• Detail and result oriented corporate trainer with vast experience with writing and facilitating training materials via Classroom, WBT and CBT.
• Experienced in presenting, facilitating, and refining technical or soft skills for product, sales, and/or service presentations.
• Managed projects following corporate best practices and ASAP methodology.

SAP BW\\BI Experience:

• Data Modeling – Extensively worked on data modeling- info cubes and ODS objects, designing custom info objects, source systems, Data Sources, Info sources, info packages, Info Providers, Multi providers and Info Sets. Installation and Customization of Business content depending on the user requirements.
• Data Extraction – Experience in data extraction from SAP R/3 (SD/MM/FI/CO/AR) using extract structures extensively worked on DSO and Info cube and Generic Extractions as well as from other database sources using DB Connect.
• Expertise in Scheduling and monitoring of data upload into Info Providers such as Info Objects, ODS, Info Cubes as well as PSA. .
• SAP Data Integration.
• Experience in process chain management, automation of the extraction, transformation and loading data.
• Production Support experience in handling batch jobs, load failures, delta failures, performance issues and system issues.
• Performance Tuning – Expertise in performance enhancement features. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection, and Data Compression. Analyzed OLAP performance using BW statistics.
• Reporting – Extensive knowledge of custom queries using Restricted and Calculated Key figures, Variables, Structures, Conditions and Exceptions. Info Set queries, Query Builder, BEx Analyzer, BEx Browser and Web Application Designer.
• Proficient with planning, Gap analysis, Design Implementation, troubleshooting and user training of SAP Business Intelligence Reporting Tools.
• Multiple Software Development Life Cycles (4).

TECHNICAL SKILLS:
Software: SAP BI 7.0X, SAP R/3, 4.6C, SAP Netweaver 7.X, SAP Data Warehouse 3.5, 7.X.
OLAP Tools: SAP Business Explorer, Web Application designer, Business Objects 7.X
RDBMS: Oracle, MSSQL, and MS Access.
Web Tools: HTML 4.0.
Operating System: Windows XP, Windows 7, and Linux\\Unix, Windows Server 2000 Active Directory, and Novell 6.5.
Reporting Software – Crystal Reports X and 2008, BEx Reporting Tool, and Crystal Xcelcius Dashboards 2008.

WORK HISTORY:
Confidential,Jan.2011 – April 2011
SAP BW Consultant

• Consulted with corporate training management to define performance levels and assisted in training platform for Financial Advisors and their staff.
• Provided training to all Financial Advisor staff levels on the proprietary software systems.
• Coordinated and administered proprietary systems training in a classroom and conference room setting.
• Conversion training specialist for the Morgan Stanley\\Smith Barney merger.

Confidential,August 2010 – Jan 2011
SAP BW Consultant

• Customized Info Objects, Info Sources, ODS, Info Cubes and Multi Cubes.
• Used the ODS to stage the data before transferring the ODS contents to the Info Cube. ODS reporting to give detailed level data.
• Uploaded master and transactional data from flat files and SAP R/3 as the OLTP source. Worked extensively on administration workbench (RSA1).
• Monitored complete data loads for the Info cubes and effectively handled many data loading errors during data loads.
• Customized Business Content Info Sources, Info Cubes and activated Business Content to meet business requirements.
• Created process chains for the effective scheduling of various batch processes to load info cubes, data store objects and aggregate rollup objects.
• Installed Business Content and activated the SAP delivered Standard Info cubes, Info packages, and Info Sources for transaction data as well as master data.
• Scheduled and monitored data loads from OLTP systems and flat files.
• Extensively used FI-SL extractor to transfer data from R/3 Source system to BW.
• ASAP methodology project management for corporate IT best practices.

Confidential,July 2009 – July 2010
SAP Data Modeling ETL Consultant/End User Training

• Loaded data into standard Infocubes 0FIAP_C03 and 0FIAR_C03 using DSO objects 0FI_AP_3, 0FI_AP_4 data sources.
• Created ODS objects and loaded data into ODS for data staging in BW
• Involved in designing multi cubes, ODS Structure, and multi dimensional universes.
• Actively involved in Data extraction from ODS Structure and through Flat Files
• Developed extractors and developed specifications for custom extractors to be sent to the ABAP team.
• Worked on enhancements and the integration of standard data sources.
• Developed strategies for nightly/weekly/monthly production data loads using info package groups, process chains and scheduler.
• Created and Activated Communication Structure, Transfer Structure, Transfer Routine, Update Rules (both ODS and Info Cube level). Built and loaded cubes. Validated results.
• Involved Info Package Management for data loads (Daily Job Monitoring) via IDoc or PSA, Flat file creation/load PSA (used to source 1` xdata from legacy system into BW)
• Activated Standard Business Content and loaded large volumes of production data into the Sales Info cubes

Info Cube, Info Source, Data Source, Info Object and Update Rules from Business Content

• Modified standard and created custom Info Source/Data Source, ODS, and Info Cubes (standard and Multi Cubes).
• Created, executed and adjusted project plans as needed. Prepared weekly Project Status Reports for upper management (PMO, Working and Steering Committee). Recognize and mitigate both potential risk and issues (RASIC).
• Developed reports in Crystal Reporting.
• Project procurement assignments but not limited to meeting with outside vendors to ensure project implementation success.
• Responsible for wide variety of facets related to IT projects including, but not limited to: Ensuring project success while staying within budget; executing meetings between various sources. SME on at the plant.

Confidential,May 2008 – April 2009
SAP BW/BI Consultant

• Designed, developed, and enhanced Info Cubes, ODS Objects, Info sources, Transfer Rules and Created Update Rules. Worked extensively with finance and accounting streams on Account Receivables, Cost Center Accounting and Inventory Management.
• The development and enhancements of standard business content extractors for Data Store Objects and Info Cubes.
• Completed three full software life cycle development implementations from Gap Analysis to post user training.
• Coordinated and managed the logistics of SAP BO training, review sessions, scheduling, and reporting.
• Assessed client training needs and requirements, and delivered viable coaching solutions and software/coursework presentations.
• Provide technical training for the implementation and management of updated ERP systems and CRM systems for SAP BI content management.
• Debriefed weekly with managers on what was accomplished in training and end user assessments.
• Subject Matter Expert on all SAP Business Objects and its contents for Direct Energy Utility company.
• Data Center Infrastructure support on various IT ERP systems.
• Managed and monitored data loads involving thousands of records with full upload and delta mechanisms
• Worked on data loads and scheduling with the creation and management of process chains.
• Some data center maintenance or ERP systems.

Confidential,Houston, TX. Feb 2007 – Dec 2007
Systems Analyst/Technology Trainer

• Responsible for training new Customer Relationship Management Software Systems to various internal clients.
• Coordinated and provided class room trainings on MS SharePoint Forms and MS Vista O\\S for the technical support team.
• Coordinated and provided class room trainings on Microsoft Vista and the O\\S inner workings for daily productivity before the migration from MS XP to MS Vista.
• Created, developed and implemented a plan of action for each team member to develop skill sets aligned with performance standards through classroom technical PC training and online coaching.
• Assisted in the development of a knowledgebase for the internal use of clients and their technical skills development.
• Performed QA for our technical staff’s training solution and delegated SME..

Confidential,Houston, TX March 2006 – Sep 2006
Technical Support Manager/ Technical Training Management

• Responsible for documenting functional requirements for the development team.
• Responsible for training new Relationship Managers and Trust Associates
• Provided training/updates to technical associates onsite and for remote locations.
• Coordinated and provided classroom training on Trust Agreements, Policy and Procedures, and understanding of Service Level Agreements and contracts.
• Instrumental in preparing approximately 200 employees in Back Office functions with VOIP implementation training.
• Disaster Recovery planning and site testing
• Active Directory – end user management and enterprise resource management.
• Responsible for researching current systems policy and procedures within and
• Performed Reports and suggestions on how to streamline work processes with the implementation of the new Cisco VOIP and MS Back Offices System.
• Responsible for the success of 5 technical analyst and training strategy implementation.
• Responsible for overseeing and organizing all required training in an effort to assist with the final due diligence of company systems.

Confidential,Houston, TX March 2001 – March 2006
Infrastructure Support Analyst/Help Desk Manager

• Performed enterprise-level network administration duties at various client sites. Supported an enterprise which had 10,000 workstations, 8,000 devices overall, over 17,000 user accounts, and over 1,000 deployed applications.
• Support of Windows XP and Windows 2000 workstation\\2003 Active Directory support.
• Performed general network administration duties by administrating user accounts, mailboxes, user and departmental shares, file restoration, back-ups, applying/removing permissions, etc.
• Provided the technical training and training guidelines for all of our new technicians for the oil and gas contracts.
• Assisted in the development of a web based knowledge base that helped raise our team’s resolution rates in dealing with the client’s SLA’s.
• Managed team of 12 technical analyst in the oil & gas, and medical sectors for UTMB and Seton Health.

Confidential,Houston, TX July 1998 – March 2001
Help Desk Manager

• Managed a 32 person technical support help desk that provided 24x7 help each day. Provided first-class customer service oriented 1st level and 2nd level phone support to national and international corporate clients for various software packages on various platforms.
• Supervised a staff of 32 employees, in Maryland and Houston that oversaw the support for our clients outsourced IT needs that provided 24X7 help on a weekly basis.
• Responsible for call monitoring and call mentoring program for the entire global service desk technicians.
• Provided the overall technical training and strategy for our team members to meet our clients Service Level Agreements.
• Interviewed applicants for positions within the team and trained new employees for technical work support for our clients.
• Confidential,Houston, TX
• Technical Support\\Training Representative Oct 1997 to June 1998
• Provided Technical Assistance in the testing phase of the Argus Financial Software package.
• Provided technical training support for our clients end users on the software package.
• Provided help desk software support for all end user related issues as well as assisting in implementing the software at client sites before the training stage.
• Administered the training aspect of the application in an advanced computerized class setting.

EDUCATION:
B.B.A. Business Administration (Management Information Systems)

SAP Business Objects\\Business Intelligence