SUMMARY:

Confidential is an SAP Data Solution Architect having 9 years of experience, which 9 years of Information technology Experience. He has very rich experience in the Software Products of SAP Business Warehouse, Business Planning and Consolidation, Data Services, Information Steward, Data Quality Management, Master Data Governance, Smart Data Quality, Smart Data Integration, Agile Data Preparation, HANA, Business Intelligence. He has 4 end to end implementation experience and also has expertise in execution services like support, rollouts, upgrades, POC’s.

TECHNICAL SKILLS:

Business Process and Application: Financial Management, Analytics

BI Reporting and Analysis: SBO Analysis(OLAP)

Enterprise Information Management: DS, IS, HANAIM,DQM, ADP

Enterprise Performance Management: SAP Planning and Consolidation

Documentation Tools: INFOPAK

CRM TOOLS: Remedy

Operating Systems: Windows, Unix

Presentation Tools: MS - Office

Methodology: ASAP

PROFESSIONAL EXPERIENCE:

Confidential

Business Analytics Consultant

Responsibilities:

• Sales Enablement by driving the delivery and roll out of demo content to support the Global Presales organization in the selling of the Enterprise Information Management product suite.
• Technical Lead in understanding and defining business requirements/problem(s) from the customer’s perspective to solve pain points and then defining, storyboarding, and architecting cutting edge demos that help customers envisage new possibilities.
• Responsible for the architecting the design, initial set-up, concept and implementation of SAP EIM Solutions. Covering the POC process to Big Date, Cloud, and Hadoop.
• Cross Team collaboration regarding acquisitions and complimentary partner solutions to ensure the inclusion of high value solutions to increase the value of SAP’s message. Working with Product Management to implement roadmap changes to the EIM footprint and proactively in corporate newly acquired solutions into the overall SAP demo offerings.
• Responsible for system administration and system lifecycle management (e.g. version lifecycle, point releases, etc.) system performance and quality, and safeguard the sustainability of the demo environments through collaboration with IT and other stakeholders.
• Oversee/Create processes and standards to increase efficiencies, via repeatable process, to decrease time to market, in turn streamlined staffing, cross-trained staff, and implemented a global distributed staffing model - creatively maintain crowd sourcing to mitigate technical restrictions to ensure timely delivery of new demo scenarios.
• Market Surveillance for new technologies/trends to the existing demo Infrastructure (In memory, Mobile, Virtual/Cloud etc..,).
• Research and understand SAP competition and how they demo their solutions. Design demo assets that highlight SAP’s competitive differentiators.
• Continued team analysis through SWOT analysis model in Good to Great.
• Oversee all hiring activities for new employees, consultants, and contractors
• Involved in discussions to define project scope and limitations
• Defining pre demo steps based on scope and limitation of landscape
• Configurations and customization to communicate between ERP, BW, BODS and CRM system.
• Responsibility to delivery Reports.
• Extensively Involved L2 and L3 Support Tickets.
• Responsible in Developing/Delivering POCs ( Standard and Customize)
• Involved Prepare Configuration documentations.
• Extensively Involved design Project, Work Flow, Data Flow, Batch Jobs and Real-time Jobs.
• Extensively worked on Data Integrator, Data Quality, Platform Text Data Processing, Formats and Data Stores.
• Extensively worked on Data Insight, Metadata Management, Matapedia and Cleansing package Builder.
• Extensively worked on Data management Console and Central Management Console
• Extensively Involved Pull the data from Different sources and Pump the data different Targets( SQL, Hana, BW, APO).
• Extensively Worked on BW- Modeling, Extraction and Reporting.
• Usage ofBackOffice / Cransofttool for data extraction, governance, and transformation
• Creating Source tables, Target tables, Source rules, Target rules, Views and usage of SQL functions,BackOffice - Cransoft defined functions for data extraction cleansing.
• Prepare and extract data from legacy systems to load intoBackOffice - CransoftData staging warehouse Migration Toolset
• UsedBackOfficetool set functionalities of - Data staging warehouse, Data Construction Server, Data Garage, Data Dialysis, Data Profiler, Data Governance
• Create data constructionWebApp formsin Cranberry/Cransoftfor the data not available in legacy systems
• Extensively involved Data Service, Information Steward, Data Quality Management ADP and BOA admin activities.
• Extensively worked IPS, Management console, Work bench, Data service Dashboard and Migration Services.

Confidential

Team Lead

Responsibilities:

• Extensively involved in Monitoring and production support
• Preparation of Process documentation, rotational shift management and incident management Rota.
• Documentation of business models for the different regional reports.
• Worked in the incident management.
• Coordinating the team activities and providing weekly update to project management and customer.
• Integration of ECC with BW and Non-SAP systems..
• Analyze the errors occurred while uploading the data if the request fails and make the latest data available in data target.
• Used BEX to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Expertise in creation of Bex Analyzer Queries, Workbooks, structures, variables, calculated key figures, restricted key figures, and RRI reporting.
• Extensively worked in reconciliations.
• Worked Retraction through Bex query to ECC
• Created variables for different user requirements, and also worked on User Exit variables.
• Developed BEx queries to validate the master data in info objects and ODS.
• Developing flexible queries using Filters, Free Characteristics, and Navigational attributes in BEx analyzer to facilitate data analysis in a drill down version to enable the easy access of information at various levels.
• Handling a team of 6 SAP experts with the responsibility of analyzing their work.
• Designed and implemented SAP HANA data modeling using attribute view, analytic view and calculation view.
• Involved load data Hana via BODS
• Reporting- Accessing analytical and calculation views from excel. involved in IDT (Information design tool) creation of data foundation, universe for Hana reporting
• Creating users, roles, privileges, packages, schemas and part of Hana security and development
• Designed and implemented SAP HANA data modeling using attribute view, analytic view and calculation view.
• Designed an executed migration plan to migrate data from existing SAP ECC and CRM to the SAP HANA database.
• Developed Input Schedules and Reports as per the requirement using EPM 10 EXCEL Addin.
• Created Users and Assigned the Roles
• Migrated BPC7.5 Appset to BPC10 Environment
• Involved in requirement gathering for new enhancements
• Maintain additional master data and transaction data
• Worked on Transformation & conversion files, Data Manager Packages
• Involved in the Setup of Security, Work status and Business Process Flow (BPF)
• Involved in Testing the Performance of the Reports, Input schedules and Data Manager Packages according to the test cases provided
• Migrated the Evdre Reports
• Developed new Input Schedules and Reports as per the requirement using EPM 10 EXCEL Addin.
• Created new and modified the existing development of phase I with the required Applications, Dimensions, Properties and Securities in BPC 7.5 based on the design
• Configured Parallel processing for data manager package to improve allocation logic performance
• Develop Actual vs Forecast management reports
• Configured Dimension validation
• Created the required Applications, Dimensions, Properties and Securities in BPC 7.5 based on the design
• Created Input Schedules based on the design layout to capture the Fixed Cost Expense and the Split percentages for 3 different Dimensions
• Developed Complex Evdre Reports such as Financial Analysis, Cost Centre Analysis, Dimensional Analysis and FX Verification
• Configured Currency Conversion Business Rules to convert the 30 local country currencies to Group currency EURO
• Involved in preparing the technical specifications for BPC Master data Load
• Data Manager will automates the master data load from either a CSV file.
• Developed and maintained appsets/ applications according to the Design for Sales Planning
• Extensively usedEVDREfunction in building simple and nested report/ input templates.
• Extensively used functions like EVDRE, EvGTS, EvSND, EvCOM, EVDPS, etc., for the reporting of data to meet the Customer Requirements
• Involved in End user Training.
• Prepare documentation for user training manual.
• Experience in creating projects, Jobs, Data stores, Data Flows, Work Flows, Transformations and Functions
• Good experience in SCD types implementation
• Extensively worked on Integration and Platform transforms
• Experience worked on deployment.
• Experienced in writing Data Integrator Scripting languages and variables
• Experience in Tuning ETL Jobs and CDC using Timestamp, and also set up validation rules
• Extensively knowledge on Repository manager, Job server, Metadata Integrator in generating ETL Project and creating Batch & Real time jobs.
• Experience in publishing batch jobs & experience in implementation of Recovery Mechanism for unsuccessful batch job execution
• Worked on Rapid marts.
• Created the dataflow, workflows, transformations and SAP target data formats. Analyzed the existing processes using Data Integrator and provided the best possible technical solutions to the production team and for bug fixing
• Involved in complete life cycle of a data migration from DEV TO PROD.
• Involved in data migrationfrom legacy systems to SAP using AIO methodologyand also LSMW.
• Extensively used SAP Best practices to load the data.
• Worked with most complex, medium and as well as low level objects while loading the data.
• Involved in meetings with the process team in order to help the process team work effectively. And accurately completely the mapping of data from legacy system to the SAP system.
• Involved in technical design of all the objects that are involved with SAP AIO methodology and LSMW.
• Worked extensively in loading of master data from the legacy system to the SAP system.
• Involved in meetings with the process team in order to implement business rules and in scoping for the objects.
• Used Global variables and scripts to control the execution of the job
• Coordinate with ERP Techno/Functional consultant and Business to map existing legacy system data and structures to/from the SAP ERP system.
• Extensively used Error Handling Techniques during the job processing, to write the failing records in an exceptional (error) file. The load will not stop for other records.
• Performed various profiling activities on the data to check the completeness and reliability of the data
• Converted the data from the legacy format to the oracle format using the BODS jobs
• Used Global variables and scripts to control the execution of the job
• Used scripts to delete the duplicate records after the validation part
• Worked on different versions to generate Flat file structure for LSMW and flat structures for analysis
• Created jobs to extract and load the lookup tables data from source and target system
• Used Pivot, Reverse Pivot transformations and Platforms like Merge, Query Transformations to obtain the desired output
• Involved in production support activities like scheduling and monitoring the jobs inCMC.
• Worked with data quality features such as data validation to improve the quality of source data and Audit data flow feature
• Used various transforms to get the desired output.
• Analyzed data to make sure, correct data is loaded to the target system.
• Implemented Change Data Capture to load only the changed rows from the source table, as to improve the performance.
• Used Central Repository to check in and check out of the jobs to maintain version history
• Developed ATL jobs using BusinessObjects Data Services based on the requirements.
• Extensively Involved in Business Objects Data Integrator to extract data from several data sources, applied transformations and loaded to target data tables.
• Implemented data quality feature to improve the quality of source data.
• Applied transformations on the source data using transformation functions such as query transform, data validation, case transform and loaded the resultant data to target tables.
• Generated reports using personal data files like MS Excel.
• Extensively experienced in managing, publishing and scheduling reports using Central Management Console (CMC) in Business Objects Enterprise.
• Extensivly Involved Design the data flows, workflows, transformations and SAP target formats.
• Extensively Involved in scheduling, Creating ATL files for backup

Confidential

Analytics Consultant

Responsibilities:

• Prepared POC Documentation for one of the customers with the scope of data migrations from non-SAP source to ECC target..
• Involved in Architecture actives for data migration frame work.
• Involved in preparing data migration process (ETL) from source to target.
• Non SAP source -> BODS > LSMW >ECC 6.0
• Prepared reconciliation process for source to target records counts and data auditing.
• Implemented the POC on material master object in SAP ERP

Confidential

Team Member

Responsibilities:

• Reponsible in Developing/Delivering Reports in Finance and Controlling
• Realized/Suggested BI solutions across Accounts Payable,Accounts Receivables,General Ledger, Cost Center Accounting and Financial Supply Chain using an EDW architecture.
• Realized BI queries using SAP Tools: Query Designer,Bex analyzer
• Realized highly formatted reports using Bex and formulae within excel based workbooks.
• Responsible in creating/suggesting more modular/flexible approach to the BI solution.
• Modularized user exits and Variable exits to reduce the dependency among different teams.

Confidential

Team Member

Responsibilities:

• Reponsible in Developing/Delivering Reports in SD, MM.
• Realized BI queries using SAP Tools: Query Designer,Bex analyzer,Web Application Designer.
• Realized highly formatted reports using Bex and formulae within excel based workbooks.
• Responsible in creating/suggesting more modular/flexible approach to the BI solution.
• Modularized user exits and Variable exits to reduce the dependency among different teams.
• Responsible in getting the customer acquainted with the BI reports available in areas of SD, Procurement, Inventory.
• User acceptance tests of BI reports.
• Setting up the Load schedule.
• Involved Prepare Configuration documentations.
• Involved in data migrationfrom legacy systems to SAP using AIO methodology and also LSMW.
• Extensively used SAP Best practices to load the data.
• Worked with most complex, medium and as well as low level objects while loading the data.
• Involved in meetings with the process team in order to help the process team work effectively. And accurately completely the mapping of data from legacy system to the SAP system.
• Involved in technical design of all the objects that are involved with SAP AIO methodology and LSMW.

Confidential

Team Member

Responsibilities:

• Involved in Full Life Cycle of BW implementation from blue print, realization, user training.
• Realized highly formatted reports using Bex and formulae within excel based workbooks.
• Realized BW queries using SAP Tools: Query Designer,Bex analyzer,Web Application Designer.
• User acceptance tests of BW reports.
• End user training
• Prepare documentation for user training manual.
• Gathered requirements from the Business and applied the look-up functions to meet their requirements, used if then else function.
• Prepared the Business/Technical Requirements, Design Templates, Development Standards document and detailed design documents.
• Involved in Knowledge transfer to certain users, like explaining the functionality of different transforms (merge, validation, key-generation, query) etc.
• Developed number of Complexdata integrator Mappings and Reusable Transformationsto facilitate Daily, Weekly & Monthly Loading of Data.
• Involved in data migration from legacy systems to SAP using AIO methodology and also LSMW.

Confidential

Team Member

Responsibilities:

• Extensively used RRI feature to jump between the queries to analyze the data.
• Involved in partition of infocube for loading of data month wise.
• Created Drill through queries, from summarized Info Cube to ODS object.
• Created Info packages and Info package groups scheduled them in order to load Master Data and Transactional Data from SAP R/3 and Flat file into BI system.
• Involved in creation and maintaining of Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, MultiProviders, Info Sources, Data Sources, and Info Packages.
• Worked with the info cubes, to boost the Performance by using Indexes, Statistics and also the query performance by using techniques like Compression of Info Cube, Rolling up the data to the Aggregates
• Involved in Data loading, Scheduling, Monitoring of master data and transactional data loads
• Worked with the fixing of process chain load failures in Production system.
• Uploaded master and transactional data from flat files, SAP R/3.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit.
• Worked in designing queries based on user requirements, changing of existing queries suiting the ad-hoc requirement of the client from time to time.
• Created Reports using variables, conditions, exceptions, RRI and calculated key figures provided drill-down functionality.
• Worked on Source to Target-Mapping for legacy systems (Target SAP RETAIL)
• Worked on transforms, Jobs, Workflows, Data flows, scripts etc in Data Service to extract, cleanse and load into target Data Base.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs

Confidential

Team Member

Responsibilities:

• Involved in the activities of scheduling, monitoring, and error-handling of Process Chains, and Info packages by analyzing the reasons for the failures of loads, jobs, and Change runs etc.
• Extensively involved in Monitoring and production support.
• Actively participating in reporting of Month ends and Year end activities
• Involved in performing Production Support activities like Ticket Analysis report.
• Created new SD Cube and loaded data from old SD cube to new SD cube.
• Expertise in creation of Bex Analyzer Queries, Workbooks, structures, variables, calculated key figures, restricted key figures, and RRI reporting, Ad-Hoc Queries, Authorization and role maintenance.
• Created new Aggregation levels at year end.
• Created/Changing the reporting filters at year end.
• Solved the problems related to the input queries
• Extensively used RRI feature to jump between the queries to analyze the data.
• Used delta mechanisms for uploading the data to BW from R/3.
• Involved in partition of info cube for loading of data month wise.
• Worked on extracting SD, and MM from R/3 using Generic data sources, by using Table and View.
• Maintained Aggregates, Compression, Partition and indexes of Info cubes for performance tuning of Queries.
• Created Info packages and Info package groups scheduled them in order to load Master Data and Transactional Data from SAP R/3 and Flat file into BW system.
• Worked on Business Objects Data-Integrator, and used functions like lookup, date, conversions, etc in mappings..
• Responsible forcreating mapping and transformationspecifications based on the business requirements from various business teams and implement inData Integrator jobs.
• Used Merge, Merge Join, Union All, Derived Column, Audit etc for transformations & to add columns with lineage metadata and other operational audit data.
• Validated and executed batch jobs. Tested data flows and scripts against sample data and real data. Creation of initial and incremental load jobs.
• Developed the web-intelligence reports, provided a supporting role in building the universes.