Project Sap

PROFESSIONAL SUMMERY

● Over * years of Experience in BI technologies as a SAP Business Objects Consultant with a skill set of SAP Business Objects XIR3.1/XIR3/XIR1, Universe Designer, Desktop Intelligence, Web Intelligence, InfoView, Dashboard, Central Management Console, Crystal Xcelsius 4.5, Crystal Reports 10/9, Data Services 3.1, Oracle 11g/10g/9i, SQL Server 2008/2005/2000

● Completed my master’s in Information science and Technology at Missouri University of Science and Technology. My emphasis is on Enterprise Resource Planning and Data Warehousing.

● Course work at Missouri S&T helped me to gain hands on experience in the following modules of SAP like MM, PP, SD, FI/CO and APO. Apart from learning all these modules I got to learn the configuration side of the following modules of SAP like MM,PP,SD and FI/CO. I even had an opportunity to gain hands on experience in SAP BW 7 and SAP BI 7.0. With SAP BW Workbench I understood the underlying concepts in creating a Data Warehouse as well as loading data into Data Warehouse using Extraction, Transformation and Loading Process. SAP BI 7.0 helped me in understanding the reporting and analytical features used in generating reports for managers.

TECHNICAL SKILLS

● BI TOOLS: SAP Business objects Suite XIR3.1/XIR3/XIR1, SAP Business Objects Data Services XI 3.1, Designer, Desktop Intelligence, Web Intelligence, InfoView, Central Management Console, Crystal Reports 10/9,and Crystal Xcelsius 4.5.

● ETL TOOLS: SAP Business Objects Data Services.

● DATABASES: Oracle 11g/10g/9i, Microsoft SQL Server 2008/2005.

● DATA MODELING TOOLS: Toad 9.7.2

● LANGUAGES: C, C++, HTML, XML, CSS.

● OPERATING SYSTEM: Windows NT, Windows XP Pro/2000 server, UNIX

● SAP: SAP BW7, SAP MM, SAP PP, SAP SD Modules.

EDUCATION

Missouri University of Science and Technology Rolla, MO M.S. Information Science and Technology (IST), GPA – 4.0 May 2010

● Emphasis on Enterprise Resource Planning and Data Warehousing.

Birla Institute of Technology and Science Dubai, UAE

B.E. (Hons.) Computer Science, GPA – 3.3 June 2007

CERTIFICATIONS

Missouri S&T – SAP Excellence Certificate (authorized by the SAP Corporation) May 2009

ERP Graduate Certificate May 2010

PROFESSIONAL EXPERIENCE

Tempur-Pedic, KY

Client: Tempur-Pedic

Project Duration: October 2010 – Till date

Project Role: BO and ETL Developer

Working on an ETL project named “Customer Profitability” where data is extracted, transformed and loaded from Oracle Rapid marts into SQL Server Database. Worked on another ETL project named “Integrating Canada into Planning System” where data is extracted from Accpac ERP system into SQL Server database. The project involves building crystal reports, SSRS reports and Oracle Applications.

Project Responsibilities:

ETL Project 1: The main objective of the “Customer Profitability” project is to analyze the customer relationship based on gross revenue and costs associated with servicing the client. Reports will be generated based on the data to analyze the financial data in multiple views.

● Analyzed the Business Requirements (functional & technical) with the Business users.

● Analyzed on how the current SSIS package works.

● Mapped all the tables from Oracle 11i to Oracle Rapid marts.

● Built SQL queries for accounts like Gross Sales, Returns, Freight Costs, Cost of goods sold, Cost of returns, Sales Units, Sales Return Units, Other Discounts, Floor Model Discounts, Sales Allowances, AR trade Discounts, Exchange, Free Product Rebates, Rebates, Freight Costs, Freight Charges, Integrated Advertising Expense and ShowEx Expense .

● Implemented the Queries designed in Toad for all the accounts in Business Objects Data Services.

● Working on a Rapid Mart dependency script as well as the script which performs First Load and Delta Load.

● Worked on a script which runs the Batch file at the End of the ETL jobs to load data from SQL Server Database into Hyperion Essbase cubes.

● Worked with Data Services management Console to schedule jobs, monitor log files and managing access rights to users.

● Documented the ETL specification and migration document.

ETL Project 2: The main objective of the “Integrating Canada into Planning System” project is to integrate Canada into the planning systems using SAP BO Data Services for the sales and operations planning in Zemeter.

● Analyzed the Business Requirements (functional & technical) with the Business users.

● Analyzed the existing Planning ETL jobs in the BO Data Services.

● Built SQL queries on extracting Purchase orders with status as open, Demand history and inventory history.

● Implemented the queries in the SAP BO Data Services that will fetch data from Accpac ERP system.

● Documented ETL specification and migration document.

ETL Project 3: The main objective of this project is to get the “OrdersonHold” Historical information into the Rapid Marts.

● Analyzed the Business Requirements (functional & technical) with the Business users.

● Added new ETL code to the existing Rapid marts ETL code to fetch the “OrdersonHold” Historical information from Oracle Applications.

● Calculated how long an order has been on hold.

● Documented ETL specification and migration document.

Reports:

● Worked with the operations department for gathering the business requirements.

● Built SQL query in toad which will fetch all the cancelled load plans with “PC” as status.

● Built SQL query in toad which will fetch the entire pending inventory with “PW” as status.

● Implemented the SQL query in Crystal Reports and designed the “Pending Warehouse Cancellation report”.

● Implemented the SQL query in Crystal Reports and designed the “Pending Inventory Check report”.

● Worked on Central management Console and InfoView in deploying and scheduling the designed Pending Warehouse Cancellation Report and pending Inventory Check Report.

● Documented and trained users on how to schedule and run an On-Demand Pending Warehouse Cancellation Report and pending Inventory Check Report using InfoView.

● Generated DoorSlot and StoreVisits SSRS reports for the US sales department using Microsoft Visual Studio 2008.

● Generated StoreVisits summary SSRS reports for the Canada sales department using Microsoft Visual Studio 2008.

● Deployed US DoorSlot, StoreVisits and Canada StoreVisits summary SSRS reports using Reporting Services Configuration Manager on the web.

Oracle Applications project:

● Worked on the Order Management Sysadmin module in Oracle Applications.

● Worked on a PL/SQL package which calls the procedures and cursors to generate an Email Alert when a concurrent program in Oracle Application fails.

● Worked on a PL/SQL package which calls the procedures, functions and cursors to generate an XML file for the 3rd party carriers.

Environment: SAP Business Objects XI 3.1, SAP Business Objects Data Services XI 3.1, Crystal Reports 10, Oracle9i/10g/11i, SQL Server 2005, Oracle Applications, Microsoft Visual Studio 2008, Microsoft Visual Source Safe, and Windows Server 2008/2003.

Bajaj Auto Ltd., Pune India

Client: Bajaj Auto Ltd.

Project Duration: May 2007 – Dec 2008

Project Role: BOBJ Developer

Project Responsibilities:

● Interacted with Business community to gather and analyze the Business Requirements in developing and modifying Universes and building the reports.

● Resolved Chasm traps, Fan Traps & Loop problems by using contexts and aliases to reduce the complexity of the universes.

● Improved the performance and reduced the coding with the use of @functions like @Prompt (for user defined queries), @Where (for creating conditional filters), and @Select to create duplicate objects in the process of building the Universes.

● Created custom List of Values (LOVs) for better understanding of prompts by the end users.

● Applied User and Group Restrictions in selected objects in universe level based on User and Group types.

● Designed and Developed WEBI reports, created charts and graphs for quick analysis.

● Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with the Alerter.

● Preparation of Critical, Master Detail, Sub Reports, Cross Tab and Summary reports using Crystal Reports, features includes functions, running totals, parameters and conditional formats.

● Created new users in XIR3 using Central Management Console and set restrictions, assign privileges based on their profiles.

Environment: SAP Business Objects XIR3, Universe Designer, Web Intelligence, Crystal Xcelsius 4.5, Crystal Reports 9, Oracle 10g, MS SQL Server 2005, Windows NT.

Eversendai Engineering LLC, Dubai UAE

Client: Eversendai Engineering LLC

Project Duration: July 2006 – Jan 2007

Project Role: BO Trainee

Project Responsibilities:

● Understanding requirements for report generation

● Created desktop intelligence reports

● Created reports with break, sections, merging columns.

● Created reports with combined queries.

● Developing Dashboard static and dynamic reports using Crystal Xcelsius 4.5

● Created dashboards with combo box, filter, radio buttons as inputs to column, bar and Stacked charts

Environment: SAP Business Objects XIR1, Universe Designer, Web Intelligence, Crystal Xcelsius 4.5, MS SQL Server 2000, Windows NT.

Academic Projects:

SAP Business Objects (Universe, Webi, Xcelsius, Crystal Reports) Summer’10

● Performed detailed training on Universe Designer, Web Intelligence, Desktop Intelligence, Xcelsius and

● Crystal Reports.

● Level One Certified by SAP in SAP Business Objects.

● Extensively trained in SQL for Performance tuning in reports and to follow best practices while designing Universes and Reports etc.

● Good understanding of Excel Lookup functions and other functionalities to inbuilt these features with in Xcelsius to get better interactive reports.

● Good Understanding of Contexts , Aliases, Fan Traps, Chasm Traps and Linked Universes Concept and also good understanding of Universe Designing Best Principles to Optimize Performance and Enhance the Operability of the Universe.

● Good working Knowledge of Web Intelligence Ad Hoc Reporting, SQL Performance Tuning and Charts, Variables etc.

SAS Project Spring’10

● Worked towards building a Logistic Regression Model for a campaign based on the data set provided.

● Utilized SAS software to calculate Factor Analysis on the data set provided and after that clusters have been plotted based on the co-ordinates obtained from Factor Analysis.

Managed SCM for a Virtual Bike Company Spring’10

● Performed semester long individual project designing a virtual Bike Company right from scratch to a fully developed company to understand the role of Supply Chain Management in a global organization using SAP SCM 5.0

● Created plants, Distribution Centers, Work Centers, BOM, Material Master Records etc and then generating and activating integration models for performing master data and transactional data transfer from ECC R/3 to APO client.

● Performed various activities like heuristic based planning and Releasing feasible SNP plan to DP, Performing PP/DS planning run, Running repair based planning run using Deployment and Transport Load Builder in APO client.

ERP Simulation Game Fall’09

● Simulated a sample company in mySAP IDES environment. Created Master data and configured data for functional modules like MM, PP, SD, and FI/CO. The project involved P2P (Procure to Pay Cycle), Order to Cash (O2C) Cycle and financial management.

● Competed with six other teams and came first during fourth quarter and also profitable during most of the quarters.

More on ETL (Generic Data Extractors) Fall’09

● Focused on how to extract information from SAP (Z tables) into Data Warehouse which was created using SAP BW 7 client using Generic Data Extractors.

● Learnt how to eliminate unnecessary data by creating new views as well as establishing connection between two SAP clients using ALE.

Virtual Snack Bar Company Spring’09

● The main objective of this project is to create and sell a Snack Bar and also to understand the relationship between the following modules of SAP like MM, PP, SD and FICO.

● Created Master Data records for MM and SD modules.

● Carried out Purchase to payment cycle in SAP MM, Production Planning in SAP PP, Order to Cash cycle in SAP SD module. Carefully studies financial statements in FI/CO module and how it is connected to modules like SAP MM and SAP SD.

● Created test cases for each transaction which we carried out for following modules of SAP like MM, PP, SD, and FICO.

Contact this candidate