Professional Summary: Over 12 years of experience in the IT industry. Worked as an SAP BW/BI Consultant for 5+ years which include 3+ yrs of SAP BW 3.x and 2+ years of SAP Netweaver 2004s (7.0) and Over 9 years of experience in IT Enterprise Security Architecture Design, which includes Security Intelligence Management Systems Implementation and Support. Completed 3 Full Life Cycles of SAP Business Intelligence Solution Implementations A thorough Understanding of SAP BW 3.x and NetWeaver 2004s Architecture with the ability to design develop and implement business intelligence solutions to support business requirements.

SAP BW/BI Expertise Skills Summary:

• Strong understanding of the concepts and architecture of the SAP Business Information Warehouse.
• Hands-on experience of working with the SAP BW tools, focusing on Data Warehousing -Extraction, Transformation and Loading of data (ETL), Data Modeling, Staging, Analysis and Presentation, SAP BW BPS/IP.
• Good understanding of the functions of the SAP BW metadata repository.
• Good understanding of the concepts of SAP BW reporting including knowledge of business data modeling/analysis and a thorough understanding of relational data structures, star and extended star schemas and OLAP concepts.
• Ability to generate and process query definitions with both BEx Query Designer and the BEx Web Application Designer and proficiency with Business Explorer (BEx) Analyzer,WAD,WEB and creation of Calculated Key Figures (CKF), Restricted Key Figures (RKF), Report to Report Interface (RRI),Structures,Exceptions,Conditions,BEx Information Broadcasting etc.
• Ability to install and activate SAP BW predefined Standard Business Contents and Custom Business Objects.
• Ability to develop and create InfoPackages, Data Transfer Processes (DTP), InfoProviders, DataSources, InfoSources,Transfer,Update and Transformation rules and Communication Structures and also to create DataSource connections via SAPI , DB Connect,JDBC and flat files to enable loading of data into the SAP BW system.
• Strong exposures to functional areas like Sales and Distribution SD, Material Management MM, Financial Accounting & Controlling FI/CO, and Human Resources HR.
• Worked on SAP R/3 Version 3.1H/4.0B/4.6B/4.6C.4.7 and ECC Version 5.0, 6.0
• Business Areas - SD, MM, HR, FI-CO, CRM Success/Failure Analysis (Sales Manager Portal).
• BW- Info Cubes design, Info Sources, Info Object maintenance, ODS Objects, Info sets, Hierarchies, Multi providers, Update rules, Transfer rules, Info Packages using AWB.
• BW Reporting - Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting.
• BW Security- BW security Administration, Authorization objects, Profiles and Roles.
• BW-APO - Created BW Data marts in APO environment, developed queries based on the data marts of APO.
• BW-SEM - Transactional Cube design, Transactional ODS Object, Planning Area, Planning Levels, Planning Packages, Planning folders, Manual Planning Function, User Defined and Predefined Planning Function, Data Slicing.
• Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation , Direct and Flexible update of Master data.
• Experience in Design and Development of Queries, Reports, Workbooks and Web Report publishing using BEx Analyzer, BEx Query Designer, Web Application Designer, Business Objects Xcelsius and Crystal Reports.
• BW operations - Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.
• ABAP - Reporting, User Exits, Customer modifications.
• Testing - Master/Transaction data testing.
• Training - Capable of Conducting training sessions for users in BW reporting, Info Cubes design and data extraction, Flat file design.
• ASAP Methodology - ASAP for BW project plans and Accelerators
• Strong analytical and problem solving skills

TECHNICAL SKILLS:

Operating Systems : UNIX, LINUX,AS 400, AIX, Windows 2000/NT/XP ERP Systems : SAP R/3 4.7, 4.6C, 3.1H, MySAP ERP 2005 ECC 6.0 Functional Modules : MM, SD, FI/CO, mySAP SEM-BPS Data Warehouse Tools : SAP NetWeaver 2004s (BI 7.0), SAP BW 3.x Languages : SAP ABAP/4, VB.NET, SQL, JAVA 2, Perl, Shell. Databases : Oracle, MS SQL, DB2 Reporting Tools : Business Explorer (BEx), Web Application Designer (WAD), BEX Analyzer, Crystal Reports, BusinessObjects WEBI, Xcelsius. EPM Tools : SAP BPC 5.1, NW 7.0 Quality Assurance : HP QC 9.2

Confidential, Toledo, OH. SAP BW/BusinessObjects Developer September 2009 - date

Scope of Work (Detail of duties and tasks) and environment(Reporting & Analytics) SAP NW BW 7.0 BEx, SAP BusinessObjects XI 3.1, SAP BusinessObjects Integration Kit 3.1,Infoview and WEBI 3.1

• Responsible for interacting with Business users for gathering reporting requirements and preparing technical specifications for several reports in, FI- AP,AR, COPA,INV,CCA.
• Worked with BEx Query Designer and OLAP Universe Designer, to create WEBI reports.
• Generated Xcelsius dashboards out of SAP BW data where the data is in the form of BEx Queries.
• Created OLAP Universes on BEx Queries and using them in Query As A Web Service (QAAWS) for data loading into Xcelsius.
• Worked with Query Designer to create various query elements such as Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions, and Variables.
• Create and design documents (technical and functional) for BEx Queries, Universe, Webi & Xcelcius reports.
• Build and design BEx Queries, Universe, Webi & Xcelcius reports from technical designs.
• Responsible for Designing and building Universes over existing SAP BW systems.
• Created Documents for all design build activities.
• Conducts Testing - Unit, and participates in Functional, Integration, User Acceptance)
• Responsible for Designing new and create modifications to existing queries using BEx Query Designer as part of query analysis and performance tuning.
• Creates query definitions with the BEx Query Designer
• Designing reporting templates with BEx Analyzer and Web Analyzer; Using key figures, features, hierarchies, variables, properties, exceptions... and conditions in the query definition; Integrating SAP BusinessObjects with SAP BW datasources
• Responsible for Universe Design with SAP BW Data Sources and BEX Queries
• Responsible for Creating WEBI query and documents
• Works with power users to adapt WEBI features and functionalities to the over all global user community.

Environment: SAP NW 2004s, SAP EP. 6.0, SAP BusinessObjects 3.1, HP QC 10,

Confidential, Greensboro, NC SAP BW Developer Feb 2009 - June 2009

• Performed and monitored daily and weekly loads
• Developed BEx queries on multiprovider for calculating price variance and volume variance
• Responsible for creating workbooks on some of the developed queries
• Transported the newly developed queries and query objects in to test, production environments
• Used RSRT, RSRT, RSRTRACE, ST05 to analyze queries.
• Performed various tuning techniques in order to improve query performance

Confidential, Santa Clara, California-October 2008 - December 2008 SAP BI Trainer. Iworked for Confidential the internal training division responsible for learning and development for Applied Materials Inc employees globally. I worked as an instructor responsible for conducting SAP BI Intermediate and Advance training for users. This training is focused on the front-end tools for SAP BI (SAP BEx and SAP Portal). The SAP BI Advanced class was for power users and SAP BI Intermediate class was for others. The training Classes conducted was focused on the following course objectives:

• Describe BI concepts and reporting tools.
• Understand the Data Flow concepts within BI
• Access the BI Portal and run reports using BEx Web Analyzer and BEx Analyzer using all functionality in these components
• Use the Query Designer to create Queries and Reports
• Configure and Implement the use of Characteristic Properties, Variables, and Hierarchies
• Configure and Implement the use of Key Figure Properties, Restricted Key Figures, Calculated Key Figures
• Understand the functionality of the Cell Editor and Exception Aggregation
• Configure the functionality of BI Exceptions and Conditions
• Understand the concepts of Documentation in BI
• Configure and Implement the use of Documentation in a BI report
• Create the Report to Report Interface component of BI
• Use the Information Broadcaster
• Configure the Information Broadcaster
• Understand the BEx Analyzer Workbook
• Configure the Functionality the BEx Analyzer Workbook

Environment: SAP NW 2004s, SAP EP. 6.0

July 2007 - September 2008 Confidential, Greensboro, - North Carolina, USA. Senior SAP BW/BI Developer Scope: To provide and implement SAP BW strategy for Sales and Financial analysis. Responsibilities Include creation, development and support of:

• Infocubes: Customer 0SD_C01, Delivery 0SD_C02, Sales overview 0SD_C03, Delivery Service 0SD_C04, Quotations and orders 0SD_C05,Custom Cubes, FI-AR Accounts Receivable, FI-AR Line Items, FI-AP Accounts Payable, FI-AP line items and Summary values,0FIGL_VC1 (general ledger: financial statements),0FI_GL_1 general ledger: transaction figures,0FI_GL_2 transaction figures -cost of sales.
• ODS: 0FIGL_O10: general ledger: transaction figures.
• Datasources:2LIS_11_VAITM,2LIS_11VAHDR,2LIS_11_V_ITM,2LIS_12_VCITM,2LIS_12_VCHDR,2LIS_13_VDITM,2LIS_13_VDHDR
• Extractions: Extracted Logistics data from SD using both LIS and LO Cockpit. Extracted data for financial analysis.
• Customizations: Created InfoObjects and datasources to enable data extraction from legacy systems, modified sap BC to conform to the business requirement.
• Modeling: Created InfoCubes, InfoSources, DataSources and InfoObjects, Update, Transfer and Transformation rules to enable Data Loading (initial / Delta Up-load), Scheduling and Monitoring.
• Reporting (BEx):Worked Extensively in BEx Analyzer (Query Designer) in building Queries, saving it in Workbooks (Excel workbook).Created Standard/ Custom queries using Bex Query Designer and WAD, created Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Web Reporting: Developed web reports using web items also designed graphs.
• Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization and also improved data load and query performance by doing InfoCube compression, aggregates.
• SAP BW Security: Developed and maintained authorization objects.
• Created and maintained security for all SAP BW authorizations, profiles and roles.
• Collaborated with other team members as necessary to translate business requirements into BW Security roles.
• Deep understanding of Roles & Templates provided by SAP in building security for the SAP BI 2004s system.
• Created Reporting Authorization Objects and assigned these objects to roles for securing the data to the InfoObject Level.
• Created Authorization Profiles for Query Definition, Background Users, Key Users and End Users using Profile Generator.
• Used Authorization templates S_RS_RREPU, S_RS_RDEAD & S_RS_ROPAD to define common roles.
• Used Authorization objects S_RS_COMP, S_RS_COMP1 & S_RS_ICUBE to create roles for reporting users.
• Assigned roles to users & maintained user master records.
• Created Composite roles to simplify user administration.
• Creating authorization profiles to restrict the data by InfoAreas & InfoProviders.
• Created roles to Limit Query access within the BEx Analyzer.
• Edited Predefined Authorizations as per the requirements.
• Integrated Profile Generator and BEx Browser.
• Conducted training for end-users.
• Documented the processes and procedures.

Environment: SAP Netweaver 2004 & 2004s, SAP ECC 6.0, AIX, DB2, MS SQL, ORACLE.

Feb 2005 - April 2007. SAP BW Consultant Confidential.

• Involved in the full life cycle of development and implementation of SAP BW for the Financial Services dept. - Cost Center Accounting.
• Involved in the design, development, testing and implementation of Business Warehouse using extended star schema and configuring the system and users
• Analyzing ERM and translated it to BW design. Identifying the key figures, strong entities and attributes of the entities, archiving, time frame for loading etc.
• Responsible for creation of InfoObjects, InfoCubes and ODS objects
• Responsible for extracting the data from R/3 and loading data into the InfoCubes
• Responsible for creation of Aggregates and Statistics to improve Query Performance
• Loaded master and transactional data with full and delta load using generic extraction
• Responsible for creating Queries by using BEx Analyzer.
• Responsible for creating the web templates by using Web Application Designer(WAD)

Environment: SAP BW 3.5, SAP R/3 4.7, Business Explorer (BEx), Web Application Designer (WAD)

April 2004 - Feb 2005 SAP BW Consultant Confidential, Nashville, TN

• Gathered and analyzed the requirements from Business Groups and Senior Executives.
• Data Extracted from SAP MM,CRM and FI/CO of SAP R/3 and from Flat File into SAP BW.
• Extensively worked in extractions, LO-Cockpit extraction 2LIS_02_HDR, 2LIS_11_VAHDR, 2LIS_11_VAITM and others using V3 update
• Enhanced Business Content as per the user requirements.
• Uploaded Master data and Transaction Data into SAP BW.
• Created ODS to stage the data before transferring the ODS contents to the Infocube.
• Created ODS update rules and InfoPackage to load data, installed Business Content.
• Created update rules, replicated Data Sources, and loaded Master Data from flat files and from OLTP.
• Extensively worked on BW Scheduler to load data into Info Cube.
• Created Aggregates to improve system query performance.
• Web Reporting - Developed web reports, web items, customized web templates using web application designer (WAD) and query designer.
• Created CRM queries for the following :
• Activities by Category
• Active/Passive Analysis
• Activities/Items per Activity Partner
• Activities per Category (Employee Responsible, Document Level)
• Activity Details
• Activity History
• Date of Last Activity
• Worked extensively on Administrator Workbench (AWB) including an in-depth knowledge of SAP's extended star schema modeling.

Environment: SAP BW 3.5 & SAP R/3 4.6C, Business Explorer(BEx)

Oct 2003- April 2004 Confidential, Houston .TX. IT Infrastructure Security Advisor/Consultant to multiple clients/projects.

• Configuration of LDAP server, writing LDAP schema for Cisco VPN concentrator and users using LDIF.
• Configuration of Cisco TACAS Radius server.
• Implementation of digital certificates process for remote access users, certificate enrollment and installation on Cisco VPN device.
• Installed and Configured checkpoint Firewalls. Document new Checkpoint environment.
• Performed Vulnerability Assessment using ISS tools and created Security Policy.

May 2002-Oct 2003 Confidential, Houston Texas (IDS Consultant) Intrusion Prevention/Detection Systems, Security Intelligence Solution - Global Program Manager

• Designed and implemented the security operations center (SOC) offering intrusion detection and prevention services for BHP Billiton's Internal Networks.
• Commissioned and led implementation of Enterprise Security Information Management systems using Archsight Security tools (a security data warehouse Systems) with MS SQL DB.
• Designed Enterprise Security Information Dashboard and Reporting System.
• Commissioned and led implementation of external BHP Billiton network Intrusion Detection Systems, outsourced to IBM (MSSP).
• Designed and led Intrusion Detection System implementation for company sites in S. Africa, London, S. America, Melbourne Australia, and Houston USA.
• Designed and facilitated standard operation processes for managing security services (Incident/Event tracking, forensic analysis, Correlation, Follow up to assure Implementation of corrective measures, Lessons learned etc.)
• Created a rapid response service team to coordinate incident response processes among all BHP Billiton's Business Units and to effectively communicate the mitigation process.
• Commissioned and led implementation of Host-Based Intrusion Detection Systems on some critical hosts in the enterprise worldwide.

Aug 2000-Dec 2001 Confidential. Houston, Texas. Internet Gateway Architecture/Security designer

• Worked with the project Manager as a technical design lead, Internet/Security Architecture Design & Implementation for 3 Regional Global Internet Gateway service for ExxonMobil's 80,000+ worldwide employees. Project was delivered on time.
• Installation, configuration of Checkpoint 2000 VPN-1/Firewall-1 security policy, created objects, set the rule base, configured CVP for virus checking, implemented NAT, DMZ design & Implementation.
• Installation, Configuration and Support of getAccess Runtime, Access Server, Admin Server & Backend Server.(setting up AARS,SSL,CAAS, PAAM,Logging services, Assigning roles and resources to be protected)Hands-on role administering Entrusts getAccess 4.5, 4.6
• (Solaris, Windows NT4 & 2000 platforms).

Sep 1998 - Aug 2000 Confidential. Zeeland, Michigan. (a fortune 500 company)Network Security Administrator.

• Installation, Configuration & Support Intrusion Detection Systems. ( Shadow & Snort)
• Implementation & administration of enterprise VPN
• Implementation of Internet/ Network Security policy.
• Installation, Configuration & day to day operations of Checkpoint firewall 1 v 3.0b,4.0 & 4.1
• Installation, Configuration & operations of ISS Internet scanner, system scanner & real secure.
• Installation & Configuration of Cisco Switches/routers
• Installation, Configuration & operations of Parketeer packet shaper. (bandwidth management tool)
• Installation, configuration of Cisco PIX 506 Firewall in the DMZ.

January 1997-Aug 1998 Confidential (SAP Senergy Solution Center) Houston, Texas.

• Network Administrator and Infrastructure support for SAP systems, performed SAP BASIS functions, profile generation, SAP GUI installation and configuration.
• Servers-Administrator for 400+ Multi-Client/Systems user environment
• Create user accounts; Rights, Permissions & User Access to Resources
• Establishing and Configuring Trust Relationships.
• Installation, Setup & Configuration of: RAS, DNS, DHCP, WINS Servers.

June 1996 - Dec 1996 Confidential. Houston, TEXAS. Tech Support

• Providing technical support for Gateway 2000 users across the U.S Network Admin for Novell 4.1 environment.

Education: BS Computer Science

Certifications and Trainings: CNA (Novell), MCP, MCSE+I (Microsoft), CCSE (Checkpoint), ITIL (foundation) SAP training classes-TBW 10, 20.30.