SUMMARY

• 9+ years of experience in using BA tools and methodologies and Development Support Solutions for SAP BI/BW, BI - BO, configuration, implementation, support, upgrade, monitoring, trouble shooting with a focus on delivering SAP solutions for Business issues.
• SAP Business Objects XI 3.0 / 3.1 / 4.0 / 4.1, Designer / Universe Design Tool (UDT), IDT, Supervisor, Desktop Intelligence, Web Intelligence, Web Intelligence Rich Client, Info View, Broadcast Agent, Central Management Console (CMC), Central Configuration Manager (CCM), Performance Management, Live Office, Dashboard, Import Wizard, Crystal Reports
• Enthusiastic, quick learning, project-oriented, team player with strong analytical and problem solving skills.
• Solid communication, interpersonal skills, leadership qualities, ability to develop creative solutions for challenging client needsInvolved in full cycle implementations on SAP BI/BW following ASAP methodologies.
• Strong consulting and product development experience in SAP BW, BI, and BO
• Experience with SAP NW BI 7.0 along with the capabilities like new Data source, DTP, Transformations, Real-Time Data Acquisition, BEX Analyzer, Web application designer and Integrated Planning.
• Experience in Production Support which include Process Chains maintenance. Data load monitoring and fixing the failed loads. Work experience on data cleansing, data modeling, and performance tuning and building aggregates.
• Expertise in Upgrading 3.5 to BI 7.0 Netweaver2004s Pre Upgrade and Post Upgrade tasks (collecting system objects, Security). Successfully executed the BI Upgrade Strategy. Capable of Architecting and designing end to end implementation of BW projects, right from requirement gathering, Business Blue print, preparing technical and functional specifications and development. Implemented Full life cycle projects.
• Experience on ABAP coding in BW, Start Routines, Update Rules, Transfer Rules and Customer Exit variables coding. Also Start Routine and End routine in BI 7.0.
• Experience in Reporting like Query development, Structures, Restricted /Calculated Key figures, Variables, Exceptions, Conditions, Cell Definitions and User/Customer Exits.
• Experience in Extraction of data from SAP source systems - SRM, SD, MM, FI/CO (GL/AP/AR/FM/GM/CCA/PCA),CO-PA, Logistics (Sales, Marketing, Billing & Procurement), Generic extractions and non-SAP Source systems using DB Connect, UD Connect extraction methods and Third party extraction. Extracted data from different systems like ECC. Data stage, Informatica, Flat file, DB2 and SRM.
• 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.
• Experience in integrating Business Objects with SAP BI, building Universes on top of BI Queries.
• Expert in creation of dashboards based on the Customer needs.
• Experience in broadcasting/publishing reports to the Enterprise Portals, Portal integration and Web Analyzer.
• Expert in BI Testing processes from Functional Unit Testing, Data Validation, System Testing &Integration Testing.
• Thorough exposure to SAP BI Best Practices, ASAP, and BA methodologies.
• Exposure to best practices in the areas of Financial, Chemical and Pharmaceutical.

TECHNICAL SKILLS

ERP: SAP R/3 4.6C/4.7EE, ECC 5.0/6.0, EP 6.0/7.0,CRM 5.0/7.0, SCM5.0/7.0.

Business Intelligence tools: SAP Net weaver 04/04S BI 7.0, BW 3.5, 3.1C, 3.0B

SAP Modules: FI/CO, SD, MM, PP, HR.

Reporting Services: BEx Reporting (BI 7.0/ BW 3.X), BO XI 3.0/3.1/4,Xelsius,Crystal Report

Methodologies: AGILE, Waterfall, Rational Unified Process

Project Management tools: MS Project, Rational Requisite Pro, Rational Rose, MS Visio, JIRADocumentation MS Office (Word, Excel, Power Point, Outlook)

Testing Tools: QTP, Rational TestManager, ClearCase, ClearQuest

Test Strategies: Integration, System, Regression, User-Acceptance, Black-Box, White-Box,Functional,ManualProgramming Languages SQL, PL/SQL, ABAP, C, C++, Java, Python, Perl, Ruby, PHP, Visual Basic Databases Oracle 10g/9i/8i, MS-SQL 2008/2005/2000, DB2 Operating Systems HP-UX 11i v3, AIX, Solaris, Linux,Windows Server 2000/2003/2008.

Big Data: Cloudera Developer Training for Apache Hadoop with Pig, Hive, Impala

PROFESSIONAL EXPERIENCE

Confidential, Middlebury,CT

Sr.SAP BI/BO Analyst

Responsibilities:

• Experienced in interacting with business users to analyze the business process and requirements. Transforming requirements into screens, designing database, documenting and rolling out deliverables.
• Participated in product requirements review sessions with business; understand the assumptions, dependencies and constraints.
• Analyzed business and user needs through research and interviews with key project stakeholders.
• Communicated the business needs clearly to the internal teams in the form of use-cases, sequence diagrams and process flows, as needed in Visio.
• Developed functional and/or technical requirement specifications adhering to standard templates.
• Reviewed, analyzed, and evaluated current and proposed application enhancements against enterprise business requirements and internal customer needs.
• Worked closely with development, testing and subject matter experts during the entire life-cycle of the project.
• Worked with the Database team for capacity planning.
• Fulfilled the role as a liaison between users, vendors and technical staff as needed.
• Worked with parties across multiple functional and departmental boundaries to conduct process development sessions, negotiate issues, and reach consensus.
• Managed meetings and facilitate projects by leading action item lists, schedules, status updates, etc.
• Performed gap analysis; estimation of the implementation for releases and documentation of high level requirements.
• Worked as a SME responsible for creating and maintaining functional requirements to handle all the queries and concerns of development and testing teams.
• Performed risk analysis and mitigation and managed requirements change control throughout project lifecycle.
• Identified the gaps and suggested necessary enhancements for transaction data and master data extractors.
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a Drill down or summarized way to give detailed levels of information.
• Expertise in Reports Generation using BEx Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
• Worked extensively on Data warehousing workbench and managed and monitored data loads with Full update and Delta mechanism.
• Extensively worked on BO XI 3.1 / BO XI 4 reporting purposes.
• Handled performance tuning of queries using aggregates, table partitioning, indexing of InfoCubes.
• Performed data integrity testing by executing Bex Queries validating against the backend ECC System.
• Created Drill through queries from summarized InfoCube to detail DSO data.
• Worked on BOBJ-BW Integration. (Created Universes, reports through WEB Intelligence, Xcelsius Dashboards, and Crystal Reports

Environment: SAP BI 7.0, SAP ECC 6.0, BEx Query Designer, BO XI, Web Intelligence, Xcelsius 2008, Crystal Reports, Agile, Windows 2000, MS Project, MS Word, MS Excel, Visio2010, Oracle 9i, DB2.

Confidential, Wayne, PA

Sr. SAP BI/BO Consultant

Responsibilities:

• Responsible for Requirement gathering, Business Process flow, Business Process Modeling and Business Analysis with Document and Records Management.
• Interacted with the project team to define system objectives and scope, identified constraints and the measures of success for the system to be developed.
• Developed and managed Software Development Life Cycle (SDLC) methodology which includes Configuration Management, Requirements Management, UML Analysis and Design
• Facilitated JAD sessions with management, users, subject matter experts (SME) and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
• Prepared and presented Business Requirement Document (BRD), System Requirement Specification (SRS) and Functional Requirement Document (FRD).
• Implemented agile methodology for rapid delivery of the high quality application and acted as a scrum master to organize sprint process.
• Created data mapping templates and aided the development team to reduce the bandwidth of the project.
• Review prototypes, solution blueprints, and project scope to ensure that the needs of the business are met.
• Participated in and contributed to as-is and to-be Process Modeling Sessions, and build process models responsible for analysis and reporting.
• Analyzed business requirements and segregated them into Use Cases. Created Use case diagrams, activity diagrams, Sequence Diagrams using Rational Rose according to UML methodology.
• Created Screen Mockups using Visio.
• Maintained various versions of the documents generated during the project using Rational Clear Case.
• Defined testing objectives and verify requirements are testable.
• Responsible for Test Planning, Test Case development and test script execution for Integration, Regression, Performance, Functional and System Testing.
• Created detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test.
• Extensively worked with requirement management tool and test management tool such as Mercury Quality Center.
• Provided support for User Acceptance Testing, writing test plans and developed different testing strategies like Black Box testing, and Load testing.
• Generated SQL queries for data-analysis and bug fixing.
• Involved in DB2 database upgrade project.
• Extensively worked on Modeling, Customize Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines, Business Content, Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting.
• Extensively worked on Generation of Data sources, activation of Info Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Master data (Texts, Attributes and Hierarchies)/Transaction data from ECC Data Sources and from Flat Files.
• Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales & Distribution generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Extensively involved in Activating Business Content for Standard Info Cubes, Info Sources & Info Objects of SD and HR-Payroll Modules as per the Client Requirements.
• Activated Info Cubes like Benefits 0PABN C01, Payroll Data 0PY C02 in HCM.
• Designed Transformations and DTPs as per the requirement. Developed ABAP routines and User -exits for this purpose.
• Analyzed the differences between different kinds of Order intakes in Sales and Distribution.
• Modified existing queries on various InfoCubes related to SD and HR-Payroll.
• Worked on SAP BI reporting which involves Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Extensively worked on BO XI 3.1 for reporting purposes.
• Involved in Adhoc query development and data mining.
• Extensively worked on Central Management Console (CMC) in configuring BO environment.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and Infocubes of SAP BI using Universe Designer
• Extensively worked in Infoview to create Web Intelligence Reports over the Universe Created.
• Created WebI reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked in creating Variables, Prompts in webI.
• Worked on Hierarchy Levels and developed hierarchies to support drill down reports.
• Created inventory accuracy Dashboards (Xcelsius) and for management reports for inventory management and wages and costs report from cost center accounting.
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business.

Environment: NW2004S/BI 7.0, ECC 6.0, MM, FI,SD,BO XI 3.1/4.1,crystal reports 08, Web Intelligence, Xcelsius 08.

Confidential, Chalmette,LA

SAP BI/BW Consultant

Responsibilities:

• Analyzed and investigated business user issues and worked with SME's and Managers to identify related defects and required enhancements in the application and captures business requirements.
• Extensively worked in defining business processes, identifying risks, base-lining acceptance criteria, and deliverables.
• Worked under Agile methodology.
• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement Ad-Hoc Analysis and documented the requirements.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business users' sentiments
• Developed BRD, FRD, Use Case diagrams, business flow diagrams, Activity/State diagrams and Wire Frame diagrams so that developers and other stakeholders can understand the business process.
• Conducted JAD sessions to develop architectural solution that application meets the business requirements, resolve open issues, and change requirements
• Created and maintained a project schedule using MS Project showing all of the deliverables target dates.
• Worked closely with the client base to understand and meet their needs by incorporating new functionality and features into the systems
• Facilitated the weekly meetings with the review teams to continuously improve the QA process for the application development
• Performed analysis, design, development and implementation of standard/customized InfoCubesand ODS Objects for MM and SD modules.
• Worked on customized and standard InfoCubes.
• Dealt with Time dependent/independent data in HR Cubes.
• Used MultiProviders and Infosets to extract data from tables and table joins.
• Extensively worked in LO-Cockpit Extraction to load sales, purchasing and inventory data.
• Extracted data from standard Business Content sales, PO and Inventory extractors and custom-built extractors depending on requirements.
• Defined transformations created DTP’s and InfoPackage for scheduling loads to data targets.
• Performed performance tuning of queries using indices, aggregates, compression and partition.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Involved in complete life cycle implementation of SAP BI / BO.
• Developed Universes, and used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.

Environment: SAP R/3, SAP BI 3.5, BExquery Designer, BEx Analyzer, Business Objects, Xcelsius, Crystal Reports, UML, Agile, Windows 2000, Oracle 9i, Rational Rose, Requisite Pro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

Confidential, Irving,TX

SAP BI/BW Consultant

Responsibilities:

• Involved in Full Life Cycle Implementation followed by an up-gradation of clients present SAP BW 3.5 to BI 7.0 Net Weaver 2004s and Performanceanalysis.
• Involved in design and strong background on data modeling.
• Designed the NewQueries and Modified the Existing Queries (SAP BI 7.0) according to requirements and generated reports.
• Analysis of Reporting Requirements and Translation of these requirements into Multi-Dimensional Data Models using Star-Schema and Extended Star-Schema Data Modeling Techniques, with an emphasis on actual implementation in BI.
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis.
• Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
• Extensively documented BI Reporting and Data Requirements.
• Extensively involved in Data Extraction from Non-SAP and SAP Systems.
• Participated in Strategic Customer Meetings to review and evaluate new technical challenges that are required to improve operating efficiencies.
• Handled Performance Tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
• Responsible for customizing and activating the Business Content Objects and loading the data into DSO and Info Cubes.
• Uploaded Master Data and Transactional Data to BI System.
• Used BEX Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BIInfo Providers to Generate Reports
• Design and developed query based and Info Provider based Universe and WebI Reports.
• Reporting designed and developed using BI query designer.
• WebI reporting design and developed with customer and Material hierarchy.
• Actual and Plan reports developed using WebIand QAAWS.
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users. Designed Universes for Financial billing system, Order processing and Supply chain planning.
• Build the New universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• System design and data model developed in SAP BI 7.0 for Actual and Plan data model developed for reporting in BI and BO reporting.
• Developed dashboards using Xcelsius 2008 and published in intranet portal.
• Xcelsius 2008 installed in client system as well as Development server and Production App server.
• Performance testing developed in all the application servers.
• Backup plan for execution created for the client development and production system.

Environment: SAP BI 7.0, ECC 6.0, BO XI 3.1, Web Intelligence, Xcelsius.