The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
Key project objectives were to:
Duties included are:
2015 - 2016: CAF Implementation
Kunde: Ford Motor Company, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand and most luxury cars under the Lincoln brand. Ford Motors with excellent IT team, always look forward to new technologies which will help them to scale and optimize their business processes. As a result, Ford Motors has decided to implement SAP CRM Sales, Service and Marketing (Campaign, Segmentation, SAP BI) in one of their huge China market. He has been involved in the following
2014 - 2015: FordPass Mobility APP Implementation
Kunde: Ford Motors, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand. Ford is putting its stamp on modern mobility. Ford unveiled an all-new app called FordPass. With it, Ford owners - or anyone else - will be able to use the app to get around more easily thanks to car-sharing features and more. FordPass will help the customers with navigation, roadside assistance or restaurant reservations. Essentially, think of them as a personal mobility concierge. He has been involved in the following,
2012 - 2014: Predictive Analytics Service Implementation
Kunde: Ford Motors, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand.
Project Description - He has Planned projects defining goals, schedule, scope / deliverables, and budget with values to millions. Coordinated cross-functional teams up to a size of 15 in acquiring software and hardware resources, monitoring status, and controlling project changes. Coordinated outside vendors and contracts. Project experience controlling analysis, design, development, testing, and implementation phases.
Role - Designed the new BW model to satisfy the old features as well as enhanced features and integrate with front end like CRM planner and Business objects as well as the source systems CRM, ECC, legacy BW and Flat files
Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the enhanced design
Created various BW backend objects which includes real time cubes, Basic cubes , DSOs, Data sources, Info sources, Transformations, DTPs, Open hub spokes and Process chains
Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
Handled various tickets for business objects issues for the end users. Especially on authorizations issues
Was involved in training the end users over the newly developed webi reports.
Scheduled these webi reports from BI Launch pad and delivered to the respective end users in the expected format on periodical basis.
2011 - 2012: CRONUS SAP Business Warehouse
Kunde: Olympus Corporation, Singapore, Japan
Aufgaben:
Olympus Corporation is a Japan-based manufacturer of optics and reprography products, initially specializing in microscope and thermometer businesses.
Platform - SAP ECC 7.0, CRM 7.0, BI 7.0
Project Description - The objective of SAP BI Project was to provide SAP BI Data Modeling, Extraction and reporting solution to their G2M, P2P, S2S and P2M business functions.
G2M - The purpose of a Go to Market strategy is to provide a blueprint for delivering a product or service to the end customer, taking into account such factors as pricing and distribution.
P2P - Procure to pay is the process of obtaining and managing the raw materials needed for manufacturing a product or providing a service. It involves the transactional flow of data that is sent to a supplier as well as the data that surrounds the fulfilment of the actual order and payment for the product or service.
S2S - is stock-to-sales. Involves MM, Customer, CRM, inventory, SD, etc.
C2C - is Customer-to-cash. Implies FI, SD, something to sell - involve production planning, others.
Role -Participated in Blueprint preparation, conducted workshops to describe BI capabilities and advantages over legacy, assisted in determining if reports are BI or ABAP reports, done Fit-Gap analysis, involved in requirement gathering and preparation of technical specs for Purchasing and Inventory reports, assisted in preparing test specifications for BI reports, Involved in production support and user training.
Involved in designing the data model by identifying the characteristics for dimension and key figures for the fact tables and defined the display and navigational attributes for the BI extended star schema.
Conducted workshops to describe advantages of Enterprise Date warehouse Model and implemented Enterprise data warehouse model for Purchasing and Inventory.
Modified the R/3(SD, MM) transactional Data Sources by enhancing the extract structures using user exits to support the business needs.
Designed and developed Finance, human resource Sales data models, cubes, extracted data and created reports.
Responsible for Designing ODS (Data Staging Layer) for the Logistics transactional data sources.
Involved in production support activities in monitoring the daily data loads, fix report issues and reconciliation issues.
2011 - 2011: SAP HANA 1.0 POC Pilot Project
Kunde: Olympus Corporation, Singapore, Japan
Aufgaben:
Olympus Corporation is a Japan-based manufacturer of optics and reprography products, initially specializing in microscope and thermometer businesses.
Platform - SAP ECC 7.0, CRM 7.0, BI 7.0
Project Description - Created a proof-of-concept (POC) to elicit the support of key stakeholder. Installed and configured SAP HANA landscape.
Extracted source data and provided data loading services to SAP HANA
Role - Requirement gathering/ Application Design/ Development/ Testing/ Implementation/ Training/ Support
2008 - 2011: SAP BI 7.0 Implementation
Kunde: Autodesk Asia Pte Ltd, Singapore, USA
Aufgaben:
Autodesk, Inc. is a design software and services company. The Company offers solutions to customers in the architectural, engineering, construction, manufacturing, infrastructure and digital media markets. The Company?s horizontal design solutions include AutoCAD and AutoCAD LT. In addition, it offers a range of disciplinespecific design and documentation tools, including its AutoCADbased solutions and its three dimensional (3D) design solutions.
Platform - SAP ECC 7.0 ? ABAP 7
Project - Worked on complete life cycle implementation. Transfer of Business Content from MM, SD, HR, FICO AREA to active version with all its dependence objects.
Financial Planning: Responsible for execution of financial planning strategies, budgeting, forecasting, actual processing and consolidations.
Defined and configured Appsets, Application, Dimensions, Dimension Members and their properties.
Built Reports and Input Schedules using advanced OLS/SAP BPC functionality including EVGET & EVDRE.
Configured Data Manager Packages for uploading flat files using conversion file and transformation files
Conduct overview analysis of the BPC system to monitor daily loads, correcting the rejects and re-loading as needed.
Responsible for deliverables in all phases - Project Planning, Business Blueprint, Realization, go live and Post-Go live phases of the SDLC lifecycle.
Responsible for day to day production and maintenance support in a SAP BPC environment.
Develop training materials centered on functional areas of administration and user interface within the BPC application.
Production Support: Responsible for suggesting measures to improve the production system environment so that the queries have a better response time.
Performed design changes to improve the database utility and provide an efficient data warehousing environment.
Resolved security related issues in the design of roles needed for the assignment of the queries and transaction codes to the end users and super users.
Data load monitoring for Daily/weekly/monthly loads.
PSA Change Log deletion.
Developed various test case scenarios and validated the BW reports against the R/3 tables at various stages of development such as unit testing, functional unit testing and comprehensive integration testing.
2007 - 2007: SAP BW 3.5 Implementation
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Platform - SAP BW 3.5
Role - As a BW consultant, interact with Client, carrying out all the development activities as per the requirement, resolving the issues if any and ensuring the deliverables on time. Prepared technical
Specifications and Test Case Documents. Defined Master data and attributes (Navigational and Display). As a part of it , created Info objects required and assigned Oracle views to BW Info sources.
Worked extensively on cell restrictions and creating workbooks depending on the user requirement. Performance issues raised during the design have been handled effectively. Worked on variety of reporting requirements using concepts of variable offsets, Exceptions and Conditions. Created the Process Chains to automate the Data Loads according to client requirements.
2006 - 2007: Trillium Data Cleansing Software Upgrade
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Worked on key UCM project that are both foundational (such as the UCM Upgrade) and business value-add. With deep knowledge of the capabilities and constraints of the Siebel UCM application, Trillium Data Quality and Haley Rules and integrated/leveraged within the enterprise, coupled with good understanding of customer/ privacy mastering business, privacy and data quality processes/best
practices, and provided technical guidance and input to the application support and project teams.
2005 - 2006: Wisdom Data warehouse
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Wisdom Enterprise Data Warehouse delivers critical business information from operations around the world to thousands of business users across all levels of its worldwide organization, including finance, sales, and manufacturing. And since its original implementation, 3Com?s data warehouse has continued to add value and provide strong return on investment
2005 - 2005: Wisdom Hyperion Essbase Analytic Reports
Kunde: 3Com Asia Pacific Rim Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Developed extensive analytic applications to optimize business performance using Hyperion and to extend the value of data warehouse architectures with the market leading OLAP server, as well data integration tools, information delivery tools, and consulting services.
2005 - 2005: Basel ? II Global Data Warehouse FERMAT
Kunde: United Overseas Bank, Singapore
Aufgaben:
United Overseas Bank (UOB) is a market leader of banking products in Singapore. The UOB Group provides a wide range of financial services: Commercial and corporate banking, personal financial services, private banking, general insurance etc. Knowledge Dynamics is in the business of helping organization to efficiently and effectively utilize enterprise data. Knowledge Dynamics will help in data acquisition proficiency and provide data acquisition expertise.
Data acquisition is the task of bringing data from the identified data sources into the data warehouse. Extraction from various types of source systems, Integration of common data from different source systems, Cleansing of ?dirty? data based on business rules or using purpose built tools. Building a staging area to take a data source snapshot equivalent to an Operational Data Store. Apply any transformation business rule. Load the data into the target GDW
2002 - 2004: Allmerica Financial Group PeopleSoft Replacement
Kunde: Softek Solutions Private Limited, India
Aufgaben:
The People Soft Interface process is a program, which expects the feed to be sent to a particular location in UNIX server to load into People Soft tables on ORACLE database, data is edited for integrity, validity, and eventually inserted into the People Soft tables
Allmerica has decided to build these interfaces using Informatica ? Power Center as a data transmission tool instead of continuing with current custom process developed with C/C++/UNIX Shell Script.
04/1993 - 04/1996
Diploma in Elecctronics and Communication
04/1998 - 04/2002
Bachelor of Computer Applications University of Madras
SAP Technology
SAP Modules
Automotive
Banking
Consumer
Products
Healthcare
Retail
Service
Provider
Telecommunications
The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
The Oetiker Group is a global leader in clamping and connection solutions for a wide range of applications.
Key project objectives were to:
Duties included are:
2015 - 2016: CAF Implementation
Kunde: Ford Motor Company, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand and most luxury cars under the Lincoln brand. Ford Motors with excellent IT team, always look forward to new technologies which will help them to scale and optimize their business processes. As a result, Ford Motors has decided to implement SAP CRM Sales, Service and Marketing (Campaign, Segmentation, SAP BI) in one of their huge China market. He has been involved in the following
2014 - 2015: FordPass Mobility APP Implementation
Kunde: Ford Motors, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand. Ford is putting its stamp on modern mobility. Ford unveiled an all-new app called FordPass. With it, Ford owners - or anyone else - will be able to use the app to get around more easily thanks to car-sharing features and more. FordPass will help the customers with navigation, roadside assistance or restaurant reservations. Essentially, think of them as a personal mobility concierge. He has been involved in the following,
2012 - 2014: Predictive Analytics Service Implementation
Kunde: Ford Motors, Chennai, India
Aufgaben:
The Ford Motor Company is an American multinational automaker. The company sells automobiles and commercial vehicles under the Ford brand.
Project Description - He has Planned projects defining goals, schedule, scope / deliverables, and budget with values to millions. Coordinated cross-functional teams up to a size of 15 in acquiring software and hardware resources, monitoring status, and controlling project changes. Coordinated outside vendors and contracts. Project experience controlling analysis, design, development, testing, and implementation phases.
Role - Designed the new BW model to satisfy the old features as well as enhanced features and integrate with front end like CRM planner and Business objects as well as the source systems CRM, ECC, legacy BW and Flat files
Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the enhanced design
Created various BW backend objects which includes real time cubes, Basic cubes , DSOs, Data sources, Info sources, Transformations, DTPs, Open hub spokes and Process chains
Modified existing universes and implemented new universes according the reporting needs by detecting cardinalities, resolving traps and using contexts and also developed hierarchies and derived tables.
Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
Handled various tickets for business objects issues for the end users. Especially on authorizations issues
Was involved in training the end users over the newly developed webi reports.
Scheduled these webi reports from BI Launch pad and delivered to the respective end users in the expected format on periodical basis.
2011 - 2012: CRONUS SAP Business Warehouse
Kunde: Olympus Corporation, Singapore, Japan
Aufgaben:
Olympus Corporation is a Japan-based manufacturer of optics and reprography products, initially specializing in microscope and thermometer businesses.
Platform - SAP ECC 7.0, CRM 7.0, BI 7.0
Project Description - The objective of SAP BI Project was to provide SAP BI Data Modeling, Extraction and reporting solution to their G2M, P2P, S2S and P2M business functions.
G2M - The purpose of a Go to Market strategy is to provide a blueprint for delivering a product or service to the end customer, taking into account such factors as pricing and distribution.
P2P - Procure to pay is the process of obtaining and managing the raw materials needed for manufacturing a product or providing a service. It involves the transactional flow of data that is sent to a supplier as well as the data that surrounds the fulfilment of the actual order and payment for the product or service.
S2S - is stock-to-sales. Involves MM, Customer, CRM, inventory, SD, etc.
C2C - is Customer-to-cash. Implies FI, SD, something to sell - involve production planning, others.
Role -Participated in Blueprint preparation, conducted workshops to describe BI capabilities and advantages over legacy, assisted in determining if reports are BI or ABAP reports, done Fit-Gap analysis, involved in requirement gathering and preparation of technical specs for Purchasing and Inventory reports, assisted in preparing test specifications for BI reports, Involved in production support and user training.
Involved in designing the data model by identifying the characteristics for dimension and key figures for the fact tables and defined the display and navigational attributes for the BI extended star schema.
Conducted workshops to describe advantages of Enterprise Date warehouse Model and implemented Enterprise data warehouse model for Purchasing and Inventory.
Modified the R/3(SD, MM) transactional Data Sources by enhancing the extract structures using user exits to support the business needs.
Designed and developed Finance, human resource Sales data models, cubes, extracted data and created reports.
Responsible for Designing ODS (Data Staging Layer) for the Logistics transactional data sources.
Involved in production support activities in monitoring the daily data loads, fix report issues and reconciliation issues.
2011 - 2011: SAP HANA 1.0 POC Pilot Project
Kunde: Olympus Corporation, Singapore, Japan
Aufgaben:
Olympus Corporation is a Japan-based manufacturer of optics and reprography products, initially specializing in microscope and thermometer businesses.
Platform - SAP ECC 7.0, CRM 7.0, BI 7.0
Project Description - Created a proof-of-concept (POC) to elicit the support of key stakeholder. Installed and configured SAP HANA landscape.
Extracted source data and provided data loading services to SAP HANA
Role - Requirement gathering/ Application Design/ Development/ Testing/ Implementation/ Training/ Support
2008 - 2011: SAP BI 7.0 Implementation
Kunde: Autodesk Asia Pte Ltd, Singapore, USA
Aufgaben:
Autodesk, Inc. is a design software and services company. The Company offers solutions to customers in the architectural, engineering, construction, manufacturing, infrastructure and digital media markets. The Company?s horizontal design solutions include AutoCAD and AutoCAD LT. In addition, it offers a range of disciplinespecific design and documentation tools, including its AutoCADbased solutions and its three dimensional (3D) design solutions.
Platform - SAP ECC 7.0 ? ABAP 7
Project - Worked on complete life cycle implementation. Transfer of Business Content from MM, SD, HR, FICO AREA to active version with all its dependence objects.
Financial Planning: Responsible for execution of financial planning strategies, budgeting, forecasting, actual processing and consolidations.
Defined and configured Appsets, Application, Dimensions, Dimension Members and their properties.
Built Reports and Input Schedules using advanced OLS/SAP BPC functionality including EVGET & EVDRE.
Configured Data Manager Packages for uploading flat files using conversion file and transformation files
Conduct overview analysis of the BPC system to monitor daily loads, correcting the rejects and re-loading as needed.
Responsible for deliverables in all phases - Project Planning, Business Blueprint, Realization, go live and Post-Go live phases of the SDLC lifecycle.
Responsible for day to day production and maintenance support in a SAP BPC environment.
Develop training materials centered on functional areas of administration and user interface within the BPC application.
Production Support: Responsible for suggesting measures to improve the production system environment so that the queries have a better response time.
Performed design changes to improve the database utility and provide an efficient data warehousing environment.
Resolved security related issues in the design of roles needed for the assignment of the queries and transaction codes to the end users and super users.
Data load monitoring for Daily/weekly/monthly loads.
PSA Change Log deletion.
Developed various test case scenarios and validated the BW reports against the R/3 tables at various stages of development such as unit testing, functional unit testing and comprehensive integration testing.
2007 - 2007: SAP BW 3.5 Implementation
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Platform - SAP BW 3.5
Role - As a BW consultant, interact with Client, carrying out all the development activities as per the requirement, resolving the issues if any and ensuring the deliverables on time. Prepared technical
Specifications and Test Case Documents. Defined Master data and attributes (Navigational and Display). As a part of it , created Info objects required and assigned Oracle views to BW Info sources.
Worked extensively on cell restrictions and creating workbooks depending on the user requirement. Performance issues raised during the design have been handled effectively. Worked on variety of reporting requirements using concepts of variable offsets, Exceptions and Conditions. Created the Process Chains to automate the Data Loads according to client requirements.
2006 - 2007: Trillium Data Cleansing Software Upgrade
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Worked on key UCM project that are both foundational (such as the UCM Upgrade) and business value-add. With deep knowledge of the capabilities and constraints of the Siebel UCM application, Trillium Data Quality and Haley Rules and integrated/leveraged within the enterprise, coupled with good understanding of customer/ privacy mastering business, privacy and data quality processes/best
practices, and provided technical guidance and input to the application support and project teams.
2005 - 2006: Wisdom Data warehouse
Kunde: 3Com Asia Pacific Rim, Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Wisdom Enterprise Data Warehouse delivers critical business information from operations around the world to thousands of business users across all levels of its worldwide organization, including finance, sales, and manufacturing. And since its original implementation, 3Com?s data warehouse has continued to add value and provide strong return on investment
2005 - 2005: Wisdom Hyperion Essbase Analytic Reports
Kunde: 3Com Asia Pacific Rim Singapore, USA
Aufgaben:
3Com Corporation is one of the world's leading suppliers of data, voice, and video Communication technology. 3Com has more than 250 million customers worldwide. 3Com has implemented award
winning Wisdom Enterprise Data warehouse with several data marts with 4 analytical tools.
Developed extensive analytic applications to optimize business performance using Hyperion and to extend the value of data warehouse architectures with the market leading OLAP server, as well data integration tools, information delivery tools, and consulting services.
2005 - 2005: Basel ? II Global Data Warehouse FERMAT
Kunde: United Overseas Bank, Singapore
Aufgaben:
United Overseas Bank (UOB) is a market leader of banking products in Singapore. The UOB Group provides a wide range of financial services: Commercial and corporate banking, personal financial services, private banking, general insurance etc. Knowledge Dynamics is in the business of helping organization to efficiently and effectively utilize enterprise data. Knowledge Dynamics will help in data acquisition proficiency and provide data acquisition expertise.
Data acquisition is the task of bringing data from the identified data sources into the data warehouse. Extraction from various types of source systems, Integration of common data from different source systems, Cleansing of ?dirty? data based on business rules or using purpose built tools. Building a staging area to take a data source snapshot equivalent to an Operational Data Store. Apply any transformation business rule. Load the data into the target GDW
2002 - 2004: Allmerica Financial Group PeopleSoft Replacement
Kunde: Softek Solutions Private Limited, India
Aufgaben:
The People Soft Interface process is a program, which expects the feed to be sent to a particular location in UNIX server to load into People Soft tables on ORACLE database, data is edited for integrity, validity, and eventually inserted into the People Soft tables
Allmerica has decided to build these interfaces using Informatica ? Power Center as a data transmission tool instead of continuing with current custom process developed with C/C++/UNIX Shell Script.
04/1993 - 04/1996
Diploma in Elecctronics and Communication
04/1998 - 04/2002
Bachelor of Computer Applications University of Madras
SAP Technology
SAP Modules
Automotive
Banking
Consumer
Products
Healthcare
Retail
Service
Provider
Telecommunications
Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.