INDUJA SUBRAMANIAM

(***) - *** ? ****

acewoe@r.postjobfree.com

SAP Certified Solution Consultant Netweaver 2004s (SAP BI 7.0)

SPECIALITIES:

● SAP Certified BW 3.5/SAP BI 7.0 Solution Consultant with 8 years of experience and proficiency in data modeling starting from back end development to front end reporting using SAP BW/BO tools.

● Experience in application development using SAP ABAP (ECC 6.0) to aptly support solution designing.

● Working knowledge of Business Object XI 3.1 including tools like Crystal Reports, Web Intelligence, Designer and Xcelsius. Designed executive dashboards using Xcelsius.

● Extensive experience in SAP Business Objects Data Services (BODS) 4.0 including Data Quality Management (DQM). Worked on extensive extraction, transformation and loading using SAP BODS 4.0.

● Extensive experience in designing ETL solutions using SAP Business Objects Data Services 4.0 connected to SAP BW and Oracle systems.

● Working knowledge of database design using SQL Server DDL and DML.

● Extensive experience in BW Accelerator support and maintenance.

SUMMARY

SAP Certified Solution Consultant ? Netweaver 2004s having Eight years of experience in the Information Technology industry with 7 and a half years of experience in SAP BW 3.5/BI 7.0/Business Objects XI 3.1/Business Objects Data Services 4.0.

Experience in SAP ABAP 4.6c and ECC 6.0 development.

Expertise in the functional and technical areas of SAP BI 7.0 with experience in all stages of an implementation lifecycle ? Modeling, Configuration, Extraction and Reporting. Expertise in the technical capabilities of BI 7.0 with extensive experience in BW 3.x as well.

Worked extensively on BW performance tuning methodologies like Aggregates, Cube Compression, Partitioning and Indexing for Improving the Load and Reporting performance.

Installed Business Content for various new solutions.

Extensively worked on the Pre and Post Up gradation activities while upgrading from BW 3.5 to BI 7.0.

Expert in creating Process Chains for Automation of the load process.

Extensive knowledge and expertise in the Analysis Process Designer for BI.

Extensively worked in Data Extraction from Multiple SAP and Non SAP Systems using Business Content.

LO (Worked on many standard datasources for Sales, Delivery and Billing in the SD side), LIS, CO-PA,FI-SL, PP (Including Purchase orders, purchase requisitions, scheduling agreements), MM, HR (Including Headcount and Personnel Actions, Benefits), QM, Flat File, Generic Extraction. Extensive knowledge of the BW Accelerator.

Designed and developed queries for reporting using Query Designer with complex Restricted/Calculated key figures and Report Designer tools. Worked on query views using BEx Analyzer.

Extensive experience in creating dashboards using SAP Web Application Designer.

Worked extensively with Universe Designer, Web Intelligence, Crystal Reports, Xcelsius 2008 and Infoview with knowledge of CMC. Created Universes over BEx queries and SAP BI Infocubes using Universe Designer. Experience in creating XCelsius dashboards using BI Connect.

Extensive experience in extraction, transformation and loading using SAP Business Objects Data Services 4.0 supporting SAP BW and Oracle systems.

Worked with Data Integrator and Data Quality Management tools in BODS 4.0.

Extensive experience in SAP Business Objects PostalSoft tools ? ACE and PRESORT to support address standardization and encoding.

Experience in query writing using SQL server to aptly support BODS to transform BW data into data loadable in Oracle database.

CERTIFICATIONS

SAP Certified Solution Consultant ? Netweaver 2004s ? SAP BW

Completed the OpenSAP Certification for Introduction to Software Development on SAP HANA.

PROFESSIONAL EDUCATION

Bachelor of Engineering in Computer Science and Engineering.

Technical Expertise

Technology SAP ECC/BW, SAP Business Objects Suite

SAP Skills SAP R/3 4.6C, SAP ECC 6.0 ABAP, SAP BW 3.5, SAP BI 7.0. BusinessObjects XI 3.1, Business Objects Data Services 4.0, BusinessObjects ACE, BusinessObjects PRESORT for address standardization (PostalSoft)

Database Environment SQL Server 2008

Reporting Tools SAP Business Explorer, SAP Web Application Designer, SAP Business Objects ? Crystal Reports, Web Intelligence and Xcelsius.

Operating Systems Windows NT/2000/2003/XP/2008

PROJECT EXPERIENCE

Company Wolters Kluwer Global Shared Services, Chicago, IL

Duration Period ? Oct 2013 ? Till date

Position SAP Business Warehouse 7.0 / SAP Business Objects Data Services 4.0 Technical Consultant

Background

Description ? Wolters Kluwer enables legal, tax, finance, and healthcare professionals to be more effective and efficient. We provide information, software, and services that deliver vital insights, intelligent tools, and the guidance of subject-matter experts.

Responsibilities

? Involved in development of BW data models for loading data from SAP ECC 6.0 into SAP BW 7.0 in various functional areas like Order to Cash, Incentive Commissions and Management, Finance, Procure to Pay etc.

? Working on custom extraction, transformation and loading (ETL) workflows from SAP BW and other Oracle Legacy systems using SAP BODS to finally update an Oracle Data Warehouse called TAL BI.

? Working extensively on production support activities ensuring job failures are fixed within SLA?s.

? Creating Business Objects Web Intelligence Reports for business users to use in the areas of Revenue reporting, Inventory reporting, Activity reporting etc.

? Provide user assistance for data issues/report issues and worked on enhancements logged in by customers via incident tickets.

? Working diligently with offshore team to ensure deliverables are top notch and timely.

Company Wolters Kluwer Global Shared Services, Chicago, IL

Duration Period ? Jan 2013 ? Sept 2013

Position SAP Business Objects Data Services (BODS)/SAP Business Objects PostalSoft (ACE and PRESORT) Technical Consultant

Background

Description ? Wolters Kluwer enables legal, tax, finance, and healthcare professionals to be more effective and efficient. We provide information, software, and services that deliver vital insights, intelligent tools, and the guidance of subject-matter experts.

Responsibilities

? Involved in development of custom extraction, transformation and loading (ETL) workflows from SAP BW and other Oracle Legacy systems using SAP BODS to finally update an Oracle Data Warehouse called TAL BI.

? Worked extensively on production support activities ensuring job failures are fixed within SLA?s.

? Involved in SAP BusinessObjects PostalSoft ACE and PRESORT job development to facilitate address standardization and encoding.

? Responsible for administration of Data Services and Data Quality services ensuring the services are up and running. Resolving any issues if needed.

? Provided user assistance for data issues/report issues and worked on enhancements logged in by customers via incident tickets.

? Worked diligently with offshore team to ensure deliverables are top notch and timely.

Company Rockwell Collins, Cedar Rapids, IA

Duration Period ? May 2008 ? Dec 2012

Position SAP BI/BO Technical Consultant

Background

Description ? For over 70 years, Rockwell Collins (NYSE: COL) has been recognized as a leader in the design, production, and support of communication and aviation electronics for customers worldwide. The company's unique balance of commercial and government customers helps it to maintain stability in a volatile marketplace. Leveraging developments across both markets enables Rockwell Collins to reduce costs, extend product viability, and enhance the capabilities of its systems.

Responsibilities

? Involved in development of custom data flows for new BI development with Data Modeler, SAP Front End Tools like BEx Analyzer, Query Designer, Report Designer, Web Application Designer, BO Tools like - Crystal Reports, Web Intelligence and Xcelsius.

? Created complex Web Application Designer templates to create a WAD based dashboard deployed on the netweaver portal. It is called the Quality Information Portal which contains metrics like On time delivery, Defects, Customer quality etc which are widely used by customers and provide high value to them.

? Configured BI Admin Cockpit to automate monitoring of Daily Loads and ensure timely fix of load failures.

? Created Crystal Reports in the inventory analysis space for ad-hoc reporting.

? Created Xcelsius dashboards for Production and Purchasing/Sales to Delivery Lead time analysis using BI Connect connections. Also created an Xcelsius dashboard for Master Data Governance.

? Created Webi reports for broadcasting reports on Remedy ticket status, SLA compliance, Worklog compliance to ensure SLAs are not missed and worklogs are appropriately updated.

? Worked extensively on production support activities especially in the SD, MM/PP, HR, LMS, QM, logistics modules ensuring job failures are fixed within SLA?s.

? Provided user assistance for data issues/report issues and worked on enhancements logged in by customers via incident tickets.

? Worked diligently with offshore team to ensure deliverables are top notch and timely.

? Extensively worked on the HP Quality Center tool for tracking Project Defects and working towards their completion.

Deliverables

? Lead time Analysis tool helped improve the on hand inventory situation where Rockwell Collins now knew about the excess inventory lying in their warehouse.

? Master Data Governance tool helped the stewards tighten the guidelines around material master changes.

Company Armstrong World Industries, Lancaster, PA

Duration Sept 2006 ? April 2008

Position SAP BW Consultant

Background

Description ? Armstrong World Industries, Inc. is a global leader in the design and manufacture of floors, ceilings and cabinets with a focus on innovation, design and environmental sustainability. In 2009, Armstrong?s consolidated net sales totaled approximately $2.8 billion. Based in Lancaster, PA, Armstrong operates 35 plants in nine countries and has approximately 10,200 employees worldwide.

Responsibilities

? SAP BW Technical Consultant involved in the maintenance of the BW system.

? Concentrated on the data load monitoring, design and development of Process Chains for automating the load process.

? Performance improvement activities like Indexing, Compression, Partitioning, Data Archiving, PSA Deletion etc.

? Performing year end/month end activities per processes.

? Worked on Informatica mappings and jobs scheduled for loading data from a legacy system. Gained experience in debugging an existing Informatica mapping to identify load issues if any.

Contact this candidate