SUMMARY

• Over 7+ years of IT experience including 5+ years expertise in SAP BW, SAP BODS, SAP BO and SAP R/3 design and development of LO, COPA FI and SD modules.
• 5 years of extensive experience in SAP BW/BI this includes Data Modeling, Extraction Transformation and loading (ETL) and Report Development.
• Expertise in the front end business warehouse components like BEx analyzer, Query designer, Web Application Designer, Crystal Reports, Web Reports, WEBI and Dash Boards.
• Working knowledge of SAP ASAP methodology in Software Development life cycle (SDLC).
• Expertise in SAP BW 7.0/3X/2X configuration, Reporting and OLTP Extraction.
• Experience in Business content activation, Data Extraction, Generic Extraction, Data Loading Scheduling, Monitoring, Info cubes, Info Source, LIS and LO Cockpit
• Proficient in 3 - Tier SAP BW Architecture including Extractors, Info Objects, Info sources, DSO, Info Cubes, Info Packages, and Hierarchies
• Participated in all phases of life cycle including Requirement Gathering, Development, Testing, Deployment solutions, Post production Support, Documentation, User training in SAP BW (Front-End)
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3 systems.
• Experience in design and development of Queries, Reports, Workbooks and Web reports publishing BEx and Web application designer (WAD).
• Expertise & Proficiency in BO (WEBI, Universe, Crystal Reports, Import & Publish Wizards etc.,) SQL / PL-SQL.
• Excellent communication skills and ability to work effectively in fast paced environments.

TECHNICAL SKILLS

BI Tools: SAP Business Objects XIR2/XI 3.1/XI 4.0 Designer, Central Management Console (CMC), Supervisor, Web Intelligence XIR2/XI 3.1/XI 4.0 Web Intelligence Rich Client, Import Wizard, Crystal Report XIR2/10.0/9.0, Xcelsius 2008, Live Office, and EBI Version Manager.ETL ToolsData Integrator, SAP Business Objects DataServices XI 4.1/4.0/3.1

Database Tools: MS SQL Server 6.5/7.0/2000 , Oracle 7i/8i/9i/10g, MS Access 97/2000, DB2 and Sybase

Programming Languages: C, C++, XML, SQL, PL/SQL and NT Shell Script

Data modeling Tool: Star Schema, Snowflakes Modeling, Fact and Dimension Tables

Scripting Languages: UNIX Shell Scripting, PERL, CGI

Operating System: UNIX, Windows 95/98/2000/2003/ NT/XP, Vista, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential, Durham, NC

SAP Business Objects Developer, Administrator

Responsibilities:

• Interacted with Business Owners / Users to gather, analyze, and document the requirements for reports and dashboards.
• Designed and built Universes, Classes and objects. Built Universes over BEx and relational sources
• Created WEBI reports with drill down capability using OpenDoc/Hyperlink functionality.
• Created reports using different Web Intelligence functionalities like Ranking, sectioning, breaking, Fold and unfold.
• Involved in bug fixing for invalid data flows, Work flows and projects, testing of Stored Procedures and Functions, testing of Data Integrator jobs, and the Confidential Data Worked with Contexts and Aliases to resolve the Loops in Universes.
• Created Derived tables in the Universes with Distinct, Union, Ranking etc. functionalities to meet the end user requirements.
• Created Crystal reports using Universes, Free hand SQL and stored procedures as data providers.
• Created complex Crystal reports with multiple sub-reports and OpenDoc functionality.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlines proposed solutions.
• Expertise in Resolving the Daily issues in the Daily Production Environment.
• Involved in full life cycle of Business Objects XIR3/R4.1.
• BO Upgrade from XIR3.1 to XIR4.1 and also responsible for applying service pack and fix pack to BO installation and also deployed WAR files after upgrade.
• Uninstalled BOXI R3.1 from the server to install and Removed Registry Entries with keywords such as Business Objects, Designer, Desktop Intelligence, Web Intelligence etc. before the installation.
• Migrated CMC data between old (XIR3.1) and new version either through CMC/Upgrade Management Tool.
• Apart from promoting info objects, used Life Cycle Manager to create, copy, Edit and scheduled a job.
• Maintained & managed different versions of the same document using Life Cycle Manager.
• Verified the remaining Business Objects installation works without any issues.
• Validated the installation by checking the public folders, Reports in Personal folders, Groups, Row level security, Scheduling and by running some sample reports.
• Created repository and security domain with user groups and security implementation.
• Extensively worked with security issues and user maintenance in XIR 3.1/XIR4.1.

Environment: Business Objects 4.0 SP05 (Web Intelligence, CMC, Information Design Tool, Designer), Oracle 11g, SAP Data Services 4.0, SAP BW, SAP BEx Query Designer, SAP BEx Analyzer 7.x, Windows 2010, Microsoft Excel 2010.

Confidential, Atlanta, Georgia

SAP BI/BODS Consultant

Responsibilities:

• The business need is to design and develop a common source for information to improve accuracy and the ability to Automate and Govern.
• Prepared the mapping documents as the requirements
• Automate & Govern the data flows between all systems (SAP,BW,HFM, BPC) using BODS tools.
• Developed complex jobs, workflows, data flows to load the data into SAP BW from various systems using various transformations like table Comparison, Merge, Pivot, Case, Query etc in Data flows
• Worked in Business Objects Data Quality (Address Cleansing) tool for cleansing customer master data using Data Services.

Environment: SAP BODS.

Confidential, Chicago, IL

SAP BOBJ Consultant

Responsibilities:

• Designed and built Universes, Classes and objects for investment management system.
• Created contexts, aliases, joins and cardinalities to resolve the loops and checked the Integrity of the universes.
• Defined multiple contexts and aliases to resolve Chasm Traps and Fan Traps.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters) and @Select.
• Exported the Universes to the Repository to make resources available to the users.
• Extensively used Calculations, Variables, Drill down, Slice and Dice, Alerts, Cross Tab, Master Detail for creating Business Objects reports.
• Created prompts in the reports as well as in the Universe to create more interactive reports with the users for running different kind of campaigns.
• Created User conditions, Filters to improve report generation & readability of report.

Environment: Business Objects XI 4.0 (Supervisor, Designer & Reporter), Oracle 8i, SQL.

Confidential, Houston

SAP BODS Developer

Responsibilities:

• Gathered and documented all functional requirements and converted all functional requirements into technical specifications documents.
• Installed Business Objects Data Services 4.0.
• Involved in the Business Objects Data Services migration from 3.2 to 4.0.
• Upgraded all client machines with BODS 4.0.
• Involved setup and configured Business Objects data services central repository.
• Installed the data cleansing package after the installation of the BODS on server as well as on BODS client machine.
• Extracted data from different source systems like Oracle, SQL server, flat files and loaded into the Data warehouse & Data Marts.
• Implemented the Type2 slowly changed dimensions (SCD) by using history preserving transformation.
• Loaded the data into Customer Master IDOC (DEBMAS06).
• By referencing AIO CUSTOMER MASTER JOB, created the job to load into customer master segments.
• Used the query transform and English North American data cleansing, USA noncertified address cleansing, Match transform(to cleanse the Firm data) and Associate transform to generate Customer Master Basic data.
• Used the case, validation, merge transforms and lookup function to validate the CUSTOMER MASTER basic data (to find whether that record already exist in SAP or not).
• Using the ABAP dataflow, extracted the data from R3 table and generated the lookup tables.
• Implemented the Data Enrichment step as per the AIO schema.
• Extracted and loaded the data from SAP BW source.
• Extensively used the validation transformation in order to perform any validation rules before we load data into the warehouse.
• Scheduled and monitored jobs using Business Objects Management Console.

Environment: Business objects data services 4.0/3.2 ((Desktop Intelligence, Web Intelligence, Central Management Server, Central Management Console), Oracle 11g, Microsoft SQL server 2008, Flat files, Windows 2008 Server, Tomcat 5.5.

Confidential, Atlanta, GA

SAP BI/BOBJ Consultant

Responsibilities:

• Designed and developed Fleet Dashboard that will provide the increased visibility of their operations to the Business Finance teams and Management teams.
• The dashboard provides an executive and toolkit view to support the decision making process across the organization.
• The dashboard was built for 9 sub areas thereby providing access to cross domain information in one shot.
• Detail and Dashboard WEBI reports are built for each sub area.
• HANA is used to provide on the fly data to replace KPI Store for performance.
• Performance tuning is done using the KPI Store model and data is migrated into these data stores using SAP Data Services.
• Part of end to end project lifecycle and proudly rolled out the project to the Business Groups with proper training and transition.
• Worked closely with SAP dev team to iron out the various product bugs in the latest BOBJ toolset
• Worked with the latest BOBJ toolset like Data Federation, Information Steward, Universe Design Tool, WEBI Rich Client etc.

Environment: Business Objects XI 4.0, Web Intelligence XI 4.0 Web Intelligence Rich Client, BI Launchpad, Dashboards, Universe Design Tool, Live Office, Oracle 10g, Toad.

Confidential, Minneapolis, MN

SAP BW Consultant

Responsibilities:

• Created the Regression Test Suits for BW extracts / reports.
• Maintained the Regression Test Suits based on the changes implemented as part of Change of Request.
• The new reporting tools being used are WEBI and Crystal Reports.
• Worked in creation of Regression Test scenario in BW Reporting related to SAP FICO
• Worked in execution of Regression Test scenario related to BW, EDW, SAP BPC, Opportunity to Cash and Reconciliation; update the test result in HPQC.
• Involved in the postproduction support, which required Info cube management using Compression, Rollup, and Reconstruction, Indexes and Partitioning and performance tuning using Aggregates/ Multi providers.
• Liaison with Business to understand the impact of Change Request.
• Involved in complete phase of testing (Unit testing, User acceptance testing, Data validation testing) and validated data between BW and R/3. Involved in testing of BW reports in SD & MM and validated the data between R/3 system and BW. Conducted training on BEx usage for Business Users and Web training and new features for Team Members.
• Discuss with the Business scenarios to be tested for the Regression for the impact of Change Request.
• Coordinate with the team member to execute the Regression Testing and update the results in share point.
• Creation of business process test cases and upload to solution manager.
• Create the SAP FICO Reporting Business Scenario for Regression Testing
• Execute the Regression Test Script and update the test results in HPQC and generates the report in HPQC.
• Work with Business to explain the impact analysis and finalize the Test script to be executed during regression testing.
• Coordinate with Offshore team to write the test script and to monitor the test execution.

Environment: SAP ECC 6.0, SAPBI 7.0, BI Portal, BO 4.0, EDW, SAP CRM, HR, SAP BPCPPM, SRM, ESSBASE, DB2, Oracle, Teradata, BO WEBI, Crystal reports 2008, X Celsius, MicroStrategy, Web Focus, HPQC 9.0, Test Director, Quick test Pro, SAP Net weaver Portal, LoadRunner.

Confidential

SAP BW Consultant

Responsibilities:

• FSS (Finance), PGS & GAME (PGS - Procurement & Goods Services, GAME - Global Asset Management Excellence)
• Managed development of Maintenance reporting and Physical Inventory clusters.
• Developed Real Estate cluster without BWSP model
• Created RRI reports
• Supported the client onsite for a month at London for the launch at UK and Malaysia.
• Worked with control-m team on designing job schedules
• Additionally performed QA lead role
• Developed and implemented a QA process for the project.
• Optimized the QA workload by modifying TS template etc. and review process.
• Generated monthly and quarterly project metrics.

Environment: BW 3.5, R/3 4.6C, SCM 5.0

Confidential

Java Developer

Responsibilities:

• Involved in development of Order status and Performance analysis modules of the project including requirements gathering, analysis, design and development and testing.
• Extensive use of HTML/Servlets/JSP/XML for the presentation layer along with JavaScript for the customer validation for Order tracking.
• Used Java Servlets, JSP, JavaScript, XML, HTML, and CSS for developing the Web component of the application.
• Participated in all the phases of the development namely Web Component Creation, Enterprise Bean Creation, Application Assembly, Application Deployment and maintenance.
• Developed the application using industry standard design patterns like Façade, Service Locator.
• Developed JSP pages, custom tags as part of the view component.
• Extensively implemented Stateless and Stateful Session beans to capture user conversation and to achieve scalability, memory management and transactions, and Entity beans to bring the relational data to the object world.
• Used RAD as IDE, Tomcat as App server and Oracle as the database to develop and deploy the application.