SAP BW BI Consultant Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

BELLA CHANDRASEKAR

614-726-9876

bella@gmail.com

Objective:                                                                                                                             

To seek a position in a challenging and rewarding work environment in an organization wherein, I can hone my technical abilities as a SAP BW/BI Consultant and contribute a significant part to its growth and success.

Summary of Experience:                                                                                                                              

·      Over 8 Years of IT experience as SAP BW/BI Consultant with knowledge in Data Modeling, OLAP, Testing, Performance tuning, Implementation and Troubleshooting and error handling in the field of Data warehousing and Application Development and gathering Business User Requirements.

·      Strong Data Warehousing experience specializing in RDBMS Concepts.

·         Experience in integration of various data sources with Multiple Relational Databases like DB2, Oracle, Sybase, SQL Server, Netezza, MS Access, and Worked on integrating data from  Flat Files, COBOL files and XML Files.

·         Extensive experience working with MS Word, MS Excel, MS PowerPoint.

·         Undergone training in Order fulfillment, Supply Chain and Record to Report (RTR) and complete understanding of Order fulfillment and Supply chain cycle of various Industries.

·         Extensive Data modeling experience in Star Schema/Snowflake schema design, Fact and Dimensions tables and Physical and Logical data modeling.

·         Experience in Study, Design, Analysis, Development and Implementation of Data Warehousing Concepts.

·         Experienced in integration of various data sources. Experience in supporting large Databases, troubleshooting the problems.

·         Experienced in Business Objects Reporting using Crystal Reports, XCelsius and Web Intelligence Reports.

·         Experienced in Project Management i.e. Project Planning, Estimating, Scheduling, Organizing, Implementation and Support.

·         Experienced in developing realistic strategies to resolve problems and effective decision making.

·         Held various responsibilities including monitoring SAP system, Interacting with clients and fulfilling their needs, Planning, Development and Implementation.

·         Coordinated with Off-shore teams during projects and provided maximum assistance and encouragement to ensure highest efficiency.

·         Highly motivated team-player with the ability to work independently in multiple projects, excellent Interpersonal skills and proven organizational, analytical and leadership qualities.

·         Created knowledge documents on SAP HANA involving column store.

·         Helped in the creation of training materials and related documents for Business Objects.

·         Have presented white papers and webinars to help communicate the knowledge to others and also share ideas within the company.

·         Worked on documentation on Data Services for sharing within the company.

·         Have been an active member in helping the community through sdn.sap.com.

Education:                                                                                                                              

B.Tech in Electronics and Communication Engineering, India.

Technical Skills:                                                                                                                             

ETL/Middleware Tools	Business Objects Data Services
Data Modeling	Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling.
Business Intelligence Tools	Business Objects Enterprise Reporting 3.x/4.0 - WEBI
RDBMS	Oracle 10g/9i/8i/7.3, Netezza, MS SQL Server 2000, DB2 UDB 7.1, MySql, MS Access.
Programming Skills	Oracle SQL Developer 1.5.5, Unix Shell Scripting, Autosys, Control-M, SQL, PL/SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0,  L, DHTML, XML, C, C, C++, Java.
Modeling Tool	MS Visio.
Operating Systems	Win 95/98/2000, HP-Unix 11/10/9.
Scheduling Tool	Autosys, Informatica Scheduling.

Professional Experience:                                                                                                                              

GENERAL ELECTRIC, WI                                                                        Apr ’10 - Present

SAP BW/BI Consultant

Description:

General Electric is an American Corporation working through various segments such as Energy, Finance and Technology transfer. The project requirement was to maintain the Financial and Logistics Module of the BW system and create customized queries and subsequently, reports. The planning and design of the entire project was done meticulously right until the final stages of the Deployment phase.

Few of the Reports handled during the project including the relevant Logical Data Model:

Annual Values (R to R)                      Transactions (R to R)

Customer Profitability (R to R)            Incoming Sales Orders (R to R)

Accounts Receivable (R to R)              Accounts Payable (R to R)

Purchase Order Quantities (SC)           Purchase Order Values (SC)

Ordering Activities (SC)                     Goods Receipt (SC)

Responsibilities:

·         Involved in the design area of work estimation, knowledge management and resource allocation.

·         Involved in risk management, developing optimal solutions and also implementing them.

·         Trained and helped offshore team in document design and creation.

·         Assisted the Master Data Management team in identification of datasources and error corrections to ensure consistency.

·         Worked with LO-Cockpit data source extraction.

·         Special reporting requirements of logistics of merging header data of purchase orders along with relevant sales orders to produce client specific reports to drill down on purchase information’s with vendor information for confirmed sales orders.

·         CO PA data flow designs involving project systems and internal orders for custom made reporting. Special client specific master data was designed to meet the drill down requirements in the report.

·         Worked on special designs to harmonize legacy planning systems data with ECC data and then to subsequently forwarded to reports for KPI comparison in client reports.

·         Worked on Asset Accounting and Customer/Vendor Analysis modules with BO Universe Designer, XCelsius and Crystal Reports.

·         Installed queries Asset acquisitions, Accounts Receivable, Accounts Payable using BI Content.

·         Handled a team of six off-shore and monitored their activities on a daily basis and communicated status to higher management of the project team.

·         Conducted periodical status meetings for both onsite and offshore team and kept everyone informed with latest updates.

·         Worked closely with end users and played a key role in training them.

·         Wrote Test cases and executed test scripts in Data warehouse.

Environment:

SAP ECC, SAP BW 7.0, Business Objects Data Services, Business Objects Enterprise, MS Visio, Oracle, My SQL, MS SQL Server 2008, Flat Files – Fixed Width, Tab Delimited and Spread Sheets, UNIX AIX 5.4  

EBAY INC., AZ                                                                                        Jan ’09 - Mar ’10                                                                          

SAP BW/BI Consultant

Description: 

EBay Inc. is an American Corporation that manages ebay.com, a website where people and businesses sell and buy goods and services worldwide. The BW project was to design, develop and deploy various required objects and reports. The team consisted of about 40 members at any given time, spread across various responsibilities. The testing phase included various techniques as performance testing and regression testing.

Few of the Reports handled during the project including the relevant Logical Data Model:

Customer Profitability (R to R)               Sales Volume Sales Revenue (R to R)

Incoming Sales Orders (SC)                  Asset List (R to R)

Asset Acquisitions (R to R)                   General Ledger: Balances (R to R)

Asset Turns (R to R)                            Return on Assets (R to R)

Customers: Balances (R to R)               Customers: DSO Analysis (R to R)

Responsibilities:

·         Actively involved in requirements gathering, analysis and design of FD.

·         Assigned tasks to the offshore team and tracked them on a day to day basis.

·         Configured BO Explorer to use data from SAP BW.

·         Involved in creation of role based security and authorization for certain objects.

·         Maintained documents of daily progress, data loads, process chain activities, etc.

·         Created Super queries on Profitability Analysis using BO Universe Designer.

·         Developed reports on Customer Profitability and Sales Volume as per the requirements using XCelsius as well as Crystal Reports.

·         Transported the objects including the queries to testing and production systems.

·         Assisted in the preparation of test cases, and executing and documenting them.

·         Oversaw cut-over activities by maintaining a schedule and assigning roles to each team member to ensure efficient delivery.

·         Wrote Test cases and executed test scripts

·         Supported during QA/UAT/PROD deployments

·         Extensive experience with Data Transition and Production Support and Error-Handling.

Environment:

SAP ECC, SAP BW 7.0, Business Objects Data Services, Business Objects Enterprise, MS Visio, Autosys, Oracle, My SQL, SQL Server 2005, MS Excel, Flat Files, Windows XP  

COOPER TIRES, NJ                                                                                Mar’07 – Nov ’08

SAP BW/BI Consultant

Description:

Cooper Tires specialize in design and manufacturing of a variety of tires used in various types of automobiles. The requirement of the project was implement and integrate their reporting needs. Various datasources were used and standard queries were customized, in addition to creating new ones.

Few of the Reports handled during the project including the relevant Logical Data Model:

Purchase Order Quantities (SC)          Purchase Order Values (SC)

Vendor Evaluation Data (SC)              Vendor Service Level (SC)

Production: Analysis (SC)                 Production: Detail (SC)

General Ledger: Balances (R to R)

Responsibilities:

·         Involved in requirements gathering and fit gap analysis.

·         Coordinated with Off-Shore team, by providing them with daily feedbacks for their development work.

·         Tracked the work progress of the off-shore team on a day-to-day basis to ensure that the work is aligned with the project plan consistently.

·         Worked with the SAP BW Implementation team and the Support team.

·         Worked on the Financial and Sales and Purchasing modules, mainly Controlling, Financial Accounting and Procurement.

·         Experienced in data extraction using Standard Extractors, Customized Extractors and Flat files.

·         Evaluated and improved query performance using compression and partitioning techniques.

·         Created aggregates for better reporting performance.

·         Developed several workbooks using BEx Analyzer according to the requirements.

·         Trained in Business Objects and its various reporting tools.

·         Worked with the clients and the off-shore team to design the desired reports.

·         Trained end users on handling BEx reports and explained the functionality of BEx features.

·         Coordinated integration testing with teams to validate data and seek end user acceptance.

·         Responsible for migrating the folders or mappings and sessions from development to production environment.

·         Used various debugging techniques for Performance tuning.

Environment:

SAP ECC, SAP BW 7.0, Business Objects Data Services, Business Objects Enterprise, MS Visio, Autosys, Oracle, My SQL, SQL Server 2005, MS Excel, Flat Files, Windows XP  

FORD, MI                                                                                                Nov’ 05 – Feb’07

SAP BW/BI Consultant

Description:
Ford is a multinational company involved in the manufacturing of automobiles and its parts. The project mainly involved the design and implementation of various Logistics related objects and queries.

Few of the Reports handled during the project including the relevant Logical Data Model:

Stock Quantity (SC)              Inventory Aging (SC)

Stock Overview (SC)             Inspection Stock (SC)

Sales Values (SC)                 Incoming Orders per Customer (SC)

Order, Delivery and Sales Quantities (SC)

Responsibilities:

·         Handled creation of functional design and technical design documentation.

·         Assisted in fine-tuning the design documents of the project and communicated the necessary changes with the off-shore team.

·         Carried out fit gap analysis of the available standard objects provided by BI content and made the necessary modifications to meet the needs of the clients.

·         Worked with Logistics datasources (LO Cockpit) – Logistics Transactional and Master Data.

·         Handled Standard SAP, flat file and LO Cockpit extractions.

·         Verified objects and queries and carried out assessments to ensure quality.

·         Interacted with clients and assisted the Off-Shore team in the testing of the developments and handled User Acceptance Tests (UAT) for the queries.

·         Performed function enhancements to alter the tables according to changing needs.

·         Worked with Analysis Process Designer (APD) to extract data into flat files and other data targets for evaluation of the data.

Environment:

SAP ECC, SAP R/3, SAP BW 3.x, SAP BW 7.0, Business Explorer, MS Visio, Autosys, Oracle, My SQL, SQL Server 2000, MS Excel, Flat Files, Windows XP  

Nestle, TX                                                                                               Sept’04 – Oct’05

SAP BW/BI Developer

Description: 

Nestle is a worldwide leader in food and nutrition products. Their requirement was to migrate data from their legacy systems to the SAP system and create some reports and the objects required for the same.

Few of the Reports handled during the project including the relevant Logical Data Model:

Billing Documents (R to R)                 Fulfillment Rates (R to R)

Invoice Variances (R to R)                 Goods Receipt Variances (R to R)

Responsibilities:

·         Interviewed System-Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the Project Manager.

·         Involved in identifying the data sources as per the requirements.

·         Installed and customized all BW objects pertaining to the Financial Accounting module.

·         Handled data loads for the system and monitored their status so as to update the involved teams.

·         Developed Process Chains and handled Process Chains Monitoring and Maintenance.

·         Created Infoareas, Data targets, and the necessary InfoObjects.

·         Developed indices and carried out partitioning of the Infocubes to enhance the query performance.

·         Designed various Multiproviders according to the requirements of the end-users and implemented queries.

·         Experienced in handling BEx Query Designer for creating queries on data objects.

Environment:

SAP R/3, SAP BW 3.x, Business Explorer, MS Visio, Autosys, Oracle, My SQL, SQL Server 2000, MS Excel, Flat Files, Windows XP  

PROCTER AND GAMBLE, INDIA                                                              Feb’03 – Aug’04

SAP BW/BI Developer

Description: 

P&G is a multinational company handling various consumer goods. To manage their sales, the company required implementing and maintaining the Logistics module by managing and consolidation of the data along with various processes involved, to create reports.

Few of the Reports handled during the project including the relevant Logical Data Model:

Material Analysis (SC)                       Vendor Analysis (SC)

General Ledger (R to R)                     Purchase Order Quantity (SC)

Responsibilities:

·         Worked with the Business Analysts for requirements gathering, business analysis, testing, and project coordination.

·         Extracted data from various datasources using the Generic extractor.

·         Handled migration, replication of datasources and creation of Infopackages.

·         Assisted in installing all objects as per the requirements.

·         Created InfoObjects, display attributes and navigational attributes.

·         Created customized DataStore Objects and Infocubes and loaded data.

·         Performed partitioning and compression of cubes for improved performance.

·         Assisted in the creation of queries and reports.

Environment:

SAP R/3, SAP BW 3.x, Business Explorer, MS Visio, Autosys, Oracle, My SQL, SQL Server 2000, MS Excel, Flat Files, Windows XP, Windows   2000

Download Resume Format