CAREER PROFILE:

• Around 10+ years of overall SAP BI/BO, Universe designing experience & Business Integration Analysis.
• Experience as a Business Systems/Data Analyst in dealing with Business Requirement gathering, Business Process flow, Business Process Modeling (BPM) and Reengineering (BPR)/ Business Change Management, Transaction processing, ETL, SAP SCM, SAP Business Objects Xi, HANA, SAP Lumira, Business Intelligence database/data warehousing, mining, BW Bex Query designer etc with a keen awareness of developer needs and end - users and able to deal with clients efficiently.
• Solid Knowledge with Systems Development Life Cycle including analysis, design and review of business and software requirement specifications, testing methodologies and techniques.
• Extensive experience in various industry sectors such as IT, Financial, and implementation sectors such as ERP, SRM, SCM, CRM etc.
• Extensively worked on different SAP Modules such as SAP BIW (Business Information Warehouse), SAP SD (Sales & Distribution), SAP FI/CO (Finance & Controlling), SAP ECC 5.0/6.0.
• Extensive experience in SAP Business Objects (XI 4.0, XI 3.1, XIR2, 6.5,6.X and 5.X) including Full Client, Supervisor, Designer, Reporter, Web Intelligence, Info View, ZABO, Broadcast Agent Publisher, Import Wizard, Central Management Console, Central Configuration Manager, Application Foundation/Performance Manager (Dashboards, KPI's),Live Office, QaaWS. 
• Experience creating dashboards using dashboard manager and Crystal Xcelsius 2008, built universe, reports, dashboards, scoreboards using Webi and Deski in Business Objects XI 4.0, by using QaaWS and Live office in Xcelsius. 
• Solid business communications, and presentation skills adept at creating and coordinating extensive communication networks (facilitation of joint application design (JAD) sessions and interviews, written correspondence, web-based products, reports, project status reports, oral presentations, e-mails, etc.), to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Good working knowledge on different languages such as C, SQL, T-SQL, HTML, XML, .Net, JavaScript, etc., Web Services, Mac, Windows and other applications.
• Excellent organizational, communication and interpersonal skills while being Self-motivated, adaptive and able to work in a team or independently in a deadline-driven environment.

TECHNICAL SKILLS:

Methodologies &Concepts: RUP, Agile, Waterfall, UML, Forecasting analysis, Business Intelligence, Data Analysis, Data mapping, Data Warehouse, Data Cleansing, Data modeling for data staging & Data Mart, Extraction, Transformation, Loading (ETL), Indexing.

Testing Tools: Rational Enterprise Suite, Test Director, Mercury Quality Center, Win Runner

Change Management Tools: Rational Clear Quest, Test Director

Business Modeling Tools: Rational Rose, Microsoft Visio, OmniGraffle Professional

Version Control Systems: Rational Clear Case, PVCS.

Project Management: Microsoft Project, Microsoft Office.

Programming Languages: C,C++, SQL, Unix Shell Scripting, PERL, PHP, Visual Basic, .Net, HTML, XML,

Databases: Oracle 8i/9i/10g/11g, 12 MS SQL Server, Teradata, MS-Access, IBM DB2

Reporting Tools: HANA, SAP Lumira, Design Studio, Xcelcius 2008, Dashboards 4, Infoburst 2012.5.119 , SAP Business Objects (Business Intelligence) XI 4.0/3.1/R2(release 2)- Hyperion Essbase v11.1.2.1, Hyperion Analyzer, Crystal Reports 08, Oracle Business Intelligence Enterprise Edition 10.1.3.3 (OBIEE), Micro strategy, Cognos

Other Tools: Lotus Notes, Adobe Photoshop, Adobe Acrobat, FLASH, Adobe Dream Weaver, TOAD, Discoverer v4i, XML Publisher, ERP SCM APO 4.0, 5.0, 7.0, SAP R/3 4.6C, 4.7, ECC 5.0, 6.0, 7.0Oracle Apps E Business Suite 11i, IBM Datastage, XML Spy, Informatica - Power Mart/Power Center 5.1/6.2/7.1/8.0 , Abinitio

O/S & Server Environments: Mac 10.6.4, Windows NT,XP 95/98, Outlook, Unix, SAP Net Weaver

PROFESSIONAL EXPERIENCE:

Cedar Rapids, IA

Sr. SAP BI Data Warehouse Admin/Lead Business Systems Analyst

Responsibilities:

• Built BO Universes, dashboards/Reports using Xcelcius/Dashboards 4, SAP Design Studio, IDT(Information design Tool), Lumira, Xcelcius, SAP BO (Business Objects), BW Analyst tools etc.
• Defined BO classes, objects in the non - SAP data source Universes. Defined Cardinalities, Contexts, Joins and Aliases and resolved loops. Checked the Universes for integrity and exported to the Repository to make resources available to the users and groups and created Adhoc Reports by accessing the Universe
• Used LCM to move the BO objects reports from Dev to QA and prod systems
• Extensive experience in Requirements gathering, universe and reports designing.
• Built queries/aggregate data using different datasources such as SQL Server, Bex Query Designer, Crystal Reports, Business Objects, Infoburst etc for use in Xcelcius.
• Designed/Prototypes & developed more than 20-30 complex dashboards using dashboard manager and Crystal Xcelsius 2008/Dashboards 4, built universe, reports, dashboards, scoreboards using Webi and Deski in Business Objects XI 4.0, By using QaaWS, Live office, SAP Netweaver BI & Infoburst connections in Xcelsius. 
• Successfully Integrated data from Infoburst & BI Connections into a single view in Xcelcius, Created the Prototypes using Xcelcius for the inventory, Quality Management & supply chain projects while learning the usage of Bex Query & BI Connections in Xcelsius.
• Staged data from WEBI reports into Infoburst and write simple to complex SQL statements to generate a specific report format for use in Xcelcius.
• Done advanced Excel programming for analytical models and Xcelsius dashboards. Achieved data acquisition using QAAWS, Live Office, XML Data connection and Flash Variables.
• Ensured to complete tasks within timelines so as to meet cost & schedule
• Met with customers & involved in requirements gathering sessions and presentations. Translated business needs into data warehousing solutions. Assisted in establishing development standards.
• Created respective technical and functional specification documents.
• Coordinated project work with offshore Rockwell Team (India Design Center) and provided training sessions.
• Developed solutions to a variety of complex problems with dashboards and reports and provides production support.
• Reviews object and data models and the metadata repository to structure the data for better management and quicker access. Troubleshoots and tunes existing data warehouse applications.
• Involved in data modeling, data extraction and data staging.
• Involved in managing of InfoCubes, which involves InfoCube Content, Performance issues like Indexes, Compression of InfoCube and Rolling up the data to the Aggregates in BW
• Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Free Characteristics, Navigational attributes, Filters, Structures, Variables, Text Variables, Conditions, Formulas, Exceptions within SAP BW Bex Query Designer.
• Created new or enhanced components of the data warehouse. Using configuration setting and coding, coordinated the use of data available through a computerized system. Conducted performance tuning of SQL, indexes and BW database.
• Provided direction and guidance to less experienced team members.
• Reviewed data loaded into the data warehouse for accuracy. Responsible for the development, maintenance, support of an enterprise data warehouse system and corresponding data marts. Defined, designed, and built medium to high complexity dimensional databases.
• Conducted research into new data warehouse applications and recommended methods for implementation and involved in project management activities.

Cupertino, CA

GBI Business Integration/ Systems Analyst

Responsibilities:

• . Built complex reports/Reporting Solutions using SAP Business Objects, created Dashboards, Universes using SAP Business Intelligence, XCelsius, BW Web Application Designer etc.
• 2. Conducted Data modeling, performance tuning, Debugged Reporting issues, and provided alternative design solutions to business users.
• 3. Worked on different GBI projects related to Warehouse Management of all APPLE Products such as iPhone, iPod, iPad, MAC etc. Enhanced, Developed/Built Webi reports using SAP Business Intelligence using SQL custom queries & variables
• 4. Conducted extensive Data Analysis and built reports within SAP Business Objects and used SQL to query Teradata & Oracle, Hyperion ESSBASE databases.
• Reviewed ETL process flows via Informatica & analyzed the Teradata Semantic Data Models.
• 5. Extensively worked on SAP Modules such as SAP BIW (Business Information Warehouse), SAP SD (Sales & Distribution), SAP FI/CO (Finance & Controlling), SAP ERP 6.0, etc.
• 6. Configured SAP FI/CO modules, SAP SCM, for GBI specific requirements and built Webi reports related to Apple Sales Order Types. Done cost based planning and analysis of supply and demand.
• 8. Assisted in the whole D2P process. Assisted with Apple Reseller Management e - commerce website designing process. Created Functional Specifications documents from Business Requirements documents, Techno functional Design documents, created use cases, As-is, To-Be, process flows using OmniGraffle Pro etc.
• 9. Dealt with WW users on different issues about resolving them, created Test plans, Test Cases documents, conducted Functional Testing, Impact Analysis, Risk Analysis, Gap Analysis, Regression Testing etc., provided supported for UAT & production deployment, built WeBi reports within SAP Business Intelligence as per business requirements
• 10. Coordinated with various APPLE World Wide & internal groups and delivered informative and well-organized documentations & continuous presentations.
• 11. Involved in project management activities and extensively used MAC and its corresponding APPLE applications such as RADAR for document Management, Test Script & Bug tracking tool. ESPRESSO for Production tickets etc

DesMoines, IA

SAP Business Systems/Data Analyst

Responsibilities:

• Performed Data Extraction Transformation and Loading (ETL) process using BW, Built OLAP Universes iN BO
• SAP Business Intelligence using Business Objects & Cognos
• Created Statement of Need (SON) and Impact matrix, Business Requirements Documents, Functional Specifications, on ETL process flows documents for various projects, for CDW LOB.
• Assisted in the design and documentation of Oracle CRM applications and all modules of the Supply Chain Sales, Marketing and Manufacturing extensively used SQL for data analysis and extensively queried ORACLE database.
• Extensively worked Warehouse Management in SAP BW, BO, SD,MM, QM Modules.
• Created BEx queries and used in the Business Objects
• Configured Credit card process (credit card types, credit card plan assignments, checking groups), developed authorization/settlement of credit card process and also created functional specs for credit card user exits.
• Used RUP methodology for defining process and Requirements Management Plan for iterations in SDLC (Software development Life Cycle).
• Prepared Data Element mapping documents, provided transformation rules, identified, researched, investigated, analyzed, defined and documented business processes.
• Conducted Hyperion Financial Reporting, Web Analysis, Shared Services and SmartView.
• Conducted extensive Risk based analysis, gap analysis, analyzed and researched on extensive cleansing of source data before loading into the data warehouse into ADS & ODS
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML and Business Process Modeling using MS Visio.
• Led the ETL process/data warehousing effort of creating business rules for data transformation and cleansing and to load into ORACLE database using Abinitio and IBM Datastage respectively
• Dealt as a Subject matter expect for the CRM applications such as CREDE (customer relationship event detection engine) which is used to created complex SQL triggers, stored procedures & POE (Portfolio Offer Engine) and analyzed its end to end ETL process provided input &feedback to various users on impacts to cross blocks and applications.
• Extensively analyzed & created ETL business rules in ilog rules engine in POE.
• Extensively worked on conceptual and physical Data Modeling using ErWin, Data Requirement Analysis, Data Warehouse and Data Mapping for ETL process on ORACLE and DB2 database. Extensively used COBOL on mainframes system and assisted in data migration.
• Created test plans and test cases, conducted System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Delivered informative and well - organized documentation & presentations and pushed creative thinking beyond the boundaries of existing industry practices and client mindsets.
• Extensively used Livelink for document management, Mercury Quality Center for preparation of trace matrices, test plans and test case scenarios, raised defects using JIRA tool

Washington, DC

SAP BW/BI Consultant

Responsibilities:  

• Led facilitation process to drive out requirements from all levels of business and technical clients using group and collaborative methods for Federal & Marketing business functions. RUP Methodology
• Offered data architecture recommendations for Master Data Management (MDM).
• Developed highly formatted P& L, Balance Sheet and Cash Flow Crystal Reports based on Bex Queries using formatting options like charts, grouping, alerts, parameters, formula fields, special fields and running total fields.
• Developed intuitive and captivating departmental Xcelsius dashboards using Query as web service and the new Sap BI connector.
• Partnered with other Business Intelligence and IT - related teams to provide data requirements for all related systems. Developed detailed as-is & to-be business process models & Performed transaction processing and used SAP Business Objects XI (SAP AG) solutions through SAP Business Objects Enterprise software, as well as software for information discovery and delivery; information management; querying, data analysis while establishing a business intelligence (BI) platform which provided immediate access to confidential business information on EDW.
• Configured the Business Objects BW Publisher to publish Crystal Reports from SAP BI to BOE server.
• Designed and tested ABAP document customer functions within the SAP R/3 software. Worked on SAP QM, ABAP Objects SAP modules.
• Extensive experience with the SAP Implementation Configuration Tool (IMG).
• Developed Use cases, created and modified the Document Builder application test plans/test cases and test scenarios.
• Configured the business parameters in the CRM model and done extensive modification and extreme configuration to the CRM system to change the CRM model to SAP own special business model.
• Configured Master Data for Customer, Material, and Customer-Material Info Records.
• Created Various Sales Documents like Inquiries, Quotations, Sales orders, Scheduling agreements, and Contracts.
• Configured Special Business Processes in sales like Consignment stock Processing, Third party Order processing and Returnable packaging.
• Configured Billing components comprising billing document types, Invoices based deliveries and services, Periodic and milestone billing, and Collective processing of billing documents.