SUMMARY:

• Have 18years of IT Industry experience and 15 plus years in Data Warehouse Architect, Solutions, Delivery, Consulting, Managing, and executing multiple projects.
• Analyzed business requirement and Directed, Managed Projects and provided development solutions from beginning to end.
• Define project scope, goals and deliverables that support business goals in collaboration with senior management and stakeholders
• Discussed with Enterprise Architects on SAP HANA Installation and Operations on how many cores we need to use on the History of Data.
• Developed full scale project plans and associated communication documents, defined SAP System Landscape Architecture, worked on SAP Upgrade and Migrations.
• Hands on SAP S4 HANA, HANA Live, HANA VDMs, CDS Views, SLT, UAT, Analytical Security Features.
• SAP working experience in Manufacturing, Utilities, Oil and Gas, AFS (fashion management solution) and Beverages.
• Analyze business analytics and reporting requirements, implementation, and data validation, testing and developing ETL solutions for leading clients.
• Worked on SDLC ASAP methodology, DMO for Upgradation and LSA, LSA++ Architecture for Modeling
• Interfacing with clients for business requirement gathering, conducting system analysis and finalizing functional/technical specifications.
• Designing, developing, testing, troubleshooting and debugging of the applications.
• Expertise in using SAP Business Objects Data Services(BODS) 4.1/4.0 (Designer, Repository Manager, Server Manager, Configuring / Controlling Job Server and Web Admin)
• Extensively used stored procedures for Data Cleansing and Data Profiling.
• Have good hands on experience in ETL and Data Cleansing applications using Informatica Power Center, Data services, and PL/SQL.
• Effective in communicating complex technical information to both top - level management and end-users. Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time/budget, in pressure and aggressive timelines.
• Strong communication and interpersonal skills. Experienced effective team leader as well as team player.

TECHNICAL SKILLS:

ETL Tools: Data Stage, SAP BO DS, Oracle Warehouse Builder, Informatica, SSIS

OLAP/BI: BO Web i, Xcelsius, Lumira, Cognos and Tableau

ERP: SAP ECC/EHP SD, MM, PP, QM, HR, OTC, PTP (P2P), FI AR, AP, GL, CO PA.

DW/Planning: SAP BW 3.0C, 3.1C, 3.5, SAP BI 7.0, 7.3& 7.4, BPS and BPC.

Data Modeling: SAP Sybase Power Designer, ERwin

Databases: HANA IM DB, SQL, DB2

Languages: SQL, PL/SQL.

Operating & Testing: UNIX, Windows, MS-DOS, Linux, QTP, ALM

EXPERIENCE:

Confidential, Carmel, IN

SAP BW4HANA Sr. Consultant

Responsibilities:

• Technically Hands on, leadership, direction and guidance to design and develop a sustainable Business Intelligence reporting framework and solutions.
• Assess and cultivate long-term strategic goals for SAP data warehousing in conjunction with data users, department managers, clients, and other key stakeholders.
• Responsible in providing leadership, guidance, and mentoring Business Intelligence members.
• Design comprehensive BI solutions, translating complex requirements into an optimal BI design and data validation.
• Suggesting BW-HANA Blend scenario solutions for specific requirements where high volume of detailed data reporting is required.
• Major changes were discussed with Finance and Order to Cash (OTC) functional team on Single Source of Truth and Universal Accounting S4HANA ACDOCA Table.
• Providing solutions to the complex requirements using BW4HANA Data Providers (Composite Provider, Advanced DSO, Master Data Info Objects, Hierarchies) for HANA Models.
• Identifying the area to improve the performance by utilization of HANA In-Memory Computing feature, Column Store, Calc Engine features.
• Directing solutions to push the calculations to the HANA DB engine.
• Optimizing the Design of the data flows in BW4HANA, HANA for the requirements.
• Created Calculation View for Excess & Obsolete Materials and Composite Provider for Reporting.
• Managing Onsite/Offshore resources to run the project in a smooth way.
• Involved in Offshore queries clarification and coordinating with end users to bring everybody to same page.
• Developed Productivity Earned hours S4HANA backend CDS View, created data source for extraction to ADSO deployment and Coordinated with Business and Functional Teams.
• Integrated Data Warehouse Tables in HANA through SDI/SDA with SAP Sales and Accounting tables.
• Providing the solutions in HANA-BO reporting using Input Parameters, Variables, Hierarchies, Variable, and Input Parameters.

Environment: S4HANA 1610, BW4HANA and SAP BO Web I.

Confidential, MN

SAP HANA Sr. Consultant

Responsibilities:

• Interacted with PFI Business Team and gathered requirement on PFI (Processing Food and Ingredients) and Reporting.
• Technically Hands on, leadership, direction and guidance to design and develop a sustainable PFI (Processing Food and Ingredients) Business Intelligence reporting framework and HANA solutions.
• Non-SAP Data Migration for Master Data and Transactional data from Flat File to HANA DB and integrated with SAP Views
• Created new Data flows in SAP HANA on OTC, RTR and PTP, have extensively worked on HANA data models such as Calculation Views, Scripted views and CDS Views.
• Created Calculation views and SQL scripts and involved in creation of Technical Design documentation and Test scripts.
• Performance Tuning- Analyzing Calculation view performance using Visualization plan, Explain plan, SQL Plan, SQL Tracing and take decisions based on the statistics, optimizing HANA views for better performance.
• Change Manager/ALM- Using Change Manager/ALM tool to create/maintain Change Id's.
• ChaRM- Working as a ChaRM lead for HANA object migration, creating Change documents, maintaining HANA Change id's using ALM tool and HANA studio. Migrating objects to QA and Production.

Environment: SAP SoH, BW on HANA, SAP BO and BPC.

Confidential, San Ramon, CA

SAP BW|HANA Solution Architect

Responsibilities:

• Technically Hands on, leadership, direction and guidance to design and develop a sustainable Geographical Wide Business Intelligence reporting framework and solutions
• Assess and cultivate long-term strategic goals for data warehousing in conjunction with data users, department managers, clients, and other key stakeholders
• Responsible in providing leadership, guidance, and mentoring for a team of 5 Business Intelligence members
• Geographical Margin allocated Across Global Plants, Refinery, Sales Organizations sales wise.
• Worked on BW4HANA Cockpit and Created data flow in for SD and FI modules.
• Created Push down transformations in SAP BW4HANA and by written AMDP View code.
• Inter Company transfer of Products in SD Billing, FI GL and COPA.BPS is used for Planning and Allocation of Intercompany Margins across Geographical based on Material, Customer and Plant.
• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed and tested the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script/procedures. Joins/Union used in various Attribute, Analytic and Calculation Views for LO report consumption with time dimensions, data provision is done through SLT and used SDA/SDI as virtual model. Transport request created through Life Cycle Management.

Environment: SAP, S4HANA, BW4HANA, SAP BO and BPC.

Confidential, Montvale, NJ

SAP BW|HANA Consultant

Responsibilities:

• SAP BW-HANA blend scenario solutions for specific requirements where high volume of detailed data reporting is required.
• SAP BODS & Extracting data from Flat Files and Loading in to Staging Environment and Preparing SAP BODS Custom Functions for handling deferent derivate calculations for business Steps to Integrate SAP ECC and Data Services, Transformation, loading and execution into HANA DB
• Process involved in the data extraction between SAP ECC and BODS to HANA.
• Integrate new data sources from operational infrastructure including databases, applications, networks, and servers.
• ETL Based replication to provision the data from Legacy systems to BW to BPC on HANA system.
• Providing solutions to the complex requirements using BW 7.4 SP11 Info providers with BW 7.5 Business Content SP 8 (Created Info Objects, Master Data Info Objects, Advance DSOs and Composite Providers) for Business Models.
• SAP HANA Studio (Eclipse) is used to create Advance DSO, Open ODS and Composite Providers for Business Models.
• Extracted data from COPA, GL, Sales and Material Management data into BW info cubes to do Plan in BPC.
• Developed the Attribute Views based on Master Data Tables in the SAP ECC.
• Used filters for data to minimize the data and increase the performance.
• Created Variables for applying filter values at Runtime.
• Created calculated columns in analytic Views in Attribute Views
• Created the Analytic Views based on the Info cube models in SAP BW/BI system.
• Worked with Calculation Views for master and Transaction Data.
• Created the Graphical Calculation Views by including the analytic views using Unions, Projections and Joins based on the business logic.
• Created calculation views using SQL Script and Aggregations.
• Used CE Functions for reading the data of information Views.
• Developed the Analytic privilege for end user security based on the current BW Models and validated data.
• Created Decision for implementing for implementing business rules and for performing what - if analysis.
• Used Data Replication Techniques DXC, SLT and ETL BASED via BODS
• Created on designing SAP BW ADSO, OODSO data Flows (ADSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio.
• Imported and exported the HANA Models from development to Production system using Delivery Units.
• Knowledge in SQL, PL/SQL, HANA SQL Script, Stored Procedures and worked on Testing phase integration with various modules.
• Developed Complex Be Queries using Calculated Key figures, Restricted Key figures, Variables, Structures, Filters, Free Characteristics, Conditions, Exceptions, and RRI. Built variable exits to prompt with dynamic values.
• Worked on Business Objects and created Aggregation levels, Filters, Variables, Planning functions, Planning Sequences, input ready queries, workbooks, etc
• Written/Programed code to get Hierarchy structure data into table columnar format, which will help in break down reporting in SAP BO Web I.
• Worked on developing Visual Composer reports to Design studio with a different User Interface using different customized cascaded style sheets.

Environment: SAP BW on HANA, SAP BO, BODS, SAP SD, PP, MM, SAP BPC and Tableau

Confidential, Auburn Hills, MI

SAP HANA Architect

Responsibilities:

• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW/BI reporting and applications
• Design comprehensive BI solutions, translating complex requirements into an optimal BI design and data validation.
• Design data structures to optimize data load times and end-user data access response times
• EDW Data flow design and Solutions from end to end.
• SDA (Smart Data Access) to extract structured extraction from Oracle
• Created data modeling for sales integrated with warehouse and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views using SAP HANA SQL Script and CE functions.
• HANA database from external end user report portal using real time jobs in data services 4.0 designers
• Created Analytical views for the transactional data, Attribute views for the master data
• Created users and role management, Analytic privileges, Application privileges, Repository privileges
• User administration and role design and assignment, administrators can use either the graphical user
• Interfaces in the SAP HANA studio, the SAP HANA Web-Based Development Workbench (Web IDE), or use direct SQL commands.
• Couple of projects on Side car approach to build the Warehouse and Sales Models.
• SAP HANA security patches are published according to the general SAP security patch strategy in SAP Security
• Select InfoCubes tcode => RSSM
• Manually integrate authorization object in role tcode => PFCG
• Worked on various joins like Text, Inner, Left outer joins.
• Export and Import used to transport developed objects.
• Filtered data flow with Returned orders raised by the Dealers
• Involved in Testing and in initiation of Parallel data loads for large Tables and Clustered tables extraction from ECC
• Created calculation view of type SQL script in procedures
• Input Parameters and Variables created to various modules to select the data dynamical by filtering
• Created Analytic Privilege and assign restriction
• Assign the Analytic Privilege to User to restrict the data on HANA Views
• Integrated HADOOP (HDFS/Hive) with HANA using BODS and through SDA for required customer/dealers summary issues.

Environment: Oracle, BODS, SAP ECC 6.0,HR, FIORI, HADOOP, SAP HANA 1.0 and SAP BW 7.4.

Confidential, Jackson, MI

SAP BW|HANA Consultant

Responsibilities:

• Plan Business Analysis approach, stakeholder analysis, business activities, communication and
• Management process.
• Prioritizing, organizing on specific requirement (CCA, COPA, Open and Clear Items).
• Responsible for the deliverables of projects in scope assessment, risk assessment, mapping, business
• Cases, use cases, and business process documentation.
• Assist clients to draw business and insights from complex data sets.
• Close communication with business stakeholders on requirement of Projects
• Manage solutions scope & requirement, traceability and communication.
• Design and implement proof of concept solutions and create advanced BI visualizations
• Keep abreast of current trends related to BI/Analytics/Big Data technologies
• Apply structured data requirements analysis and data modeling techniques and methods as part of the Enterprise Performance Life Cycle

Confidential

SAPSr.Consultant/Manager

Responsibilities:

• Gathering Requirement and Analysis on the requirement.
• Provide Recommendation on Hardware Sizing and Architecture.
• Interacting with Client, Managers, SME's, BA and Database team.
• Extensively in meetings and interviewing Business and Power users, to determine the sources, data Layout, Business needs, and naming conventions of the column and table names.
• Performed complex troubleshooting, root cause analysis, solution development and implement reporting systems to address the issue.
• Worked on Ralph Kimball methodology for Star and Snowflake Schemas, Fact and Dimensions tables, Physical and Logical Data Modeling.
• Coordinate with other teams to ensure availability of Source Data.
• Enterprise wide Data Quality Dashboard
• Worked with various teams to setup user access levels, and server sizing.
• Guiding the development team right from requirement to deployment.
• Involved in ETL end to end implementation.
• Utilize standard functionality Business Content of the systems
• Build a global platform enabled through SAP BI functionality
• Legacy system database source and fields identify with SAP Data Source
• Lead the Project and Guiding to the Tech & Functional consultant to freeze the requirement.
• Initially we started with few Financial Modules from SAP and EDW view and integrated/consolidated the data SAP BI.
• Identified standard Data Targets and changed the existing structure to Store Data in Column level.
• Developed the Reports that includes Shopping Cart Analysis, Procurement Detailed Report, Price variance Monitoring, Supplier Receiving Analysis, AP Ageing Report and Goods Received vs Invoiced
• Created InfoCubes for CO-PA for Costing Based.
• Created InfoCube for Gift Eligibility and MultiCube with Gift Eligibility and FI-GL for the Gift Eligibility accounting report.
• Business Objects Data Service (BODS)
• Designed ETL framework& jobs.
• Created source to target mapping documents, job dependency charts.
• Defined Technical Design document.
• Created Custom ABAP programs to pull CLOB data from ECC.
• ETL Design & use of Complex ETL routines to extract data from ODS (converting business functional specifications into mappings/workflows).
• Liaise with Business users and Business Analysts regarding requirements.
• ETL Design (converting business functional specifications into mappings/workflows)and testing
• Tuned performance for large data files by increasing block size, cache size and implemented performance tuning logic on sources, workflows, and data flows.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow.
• Involved in writing DS scripts and also used some built-in functions like Search, Replace, Lookup ext and Custom Functions for ETL audit process.
• Created Data Services mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like SQL Query Transform, Table Comparison, Query, etc. in Data flows.
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using SAP Redwood (CPS) during pre-production phases.
• Involved in code enhancement, testing based on change request (CR) from end users.
• Experience in debugging execution errors using Data Services logs (trace, statistics and error) and by examining the target data.

Environment: SAP BW, HANA,IBM Cognos 8.4 Data manager 10.2/10.1.1/10.0/8.4 , MS SQL server 2008, Oracle 10g, TOAD, Cognos Framework Manager and Cognos Report Studio.

Confidential

SAP BW Sr. Consultant& SAP BI Manager

Responsibilities:

• Proposal, Project Plan and Time Estimation.
• New Source system to Sand box connectivity.
• Setup table for LO modules and Initialization in BI.
• Gap analysis between existing and future versions
• Client visit and demonstrated SAP BI functionalities, advantages of SAP-BI Product and capabilities of Confidential BI consultants.
• Prepaid Business Case study by taking inputs on their daily business.
• Supporting Project Proposal Signoff.
• Design Process Chains for daily extraction of data and maintenance for day-to-day schedule.
• Involved in master data loading and transaction loading.
• Design and develop master data for further analysis
• Mapping data from source to target, create transformation,PSA and DTP
• Map loads and integration with SAP ERP data.
• BI error analysis and skills to debug.
• Daily monitoring on Supporting Team
• Checking on the requirements changes on reports and Data loads
• Involved in System integration testing along with other team members using various source data scenarios.
• Experienced in scheduling and monitoring of jobs using Control - M during pre-production phases.

Confidential

SAPBW Sr. Consultant

Responsibilities:

• Actively participated in Project Preparation, Business Blueprint Requirements Discussion and Realization.
• Activated required standard reports and did customized reports.
• Transferred the Application Component.
• Process chains.
• Performed Business data modeling and analysis and have thorough understanding of relational data structures, Extended Star Schema and OLAP concepts.
• Benchmarking report from Inventory, Purchase, Sales and Pricing Cube. Created a new cube for Pricing
• Daily Process Chains and Info Package Group Load monitoring.
• Defining Sources(i) Database as a source(ii) Flat Files sources, Defining Targets(i) Importing from database(ii) Creating a new target(iii) Creating target database objectsInformatica Designer, Mapping Introduction, Source Qualifier, Ports, Mapping - Table to Table, Mapping flat file to Table, Connected / Unconnected Transformations, Active and Passive Transformations, Source Qualifier Transformation, SQL override in Source Qualifier Transformation, Mapping Source Qualifier as Filter, Source Qualifier to join data, Filter Transformation, Expression Transformation, Sequence Generator Transformation, Rank Transformation, Router Transformation, Aggregator Transformation, Joiner Transformation, Stored Procedure Transformation, Connected and unconnected Transformation, Union Transformation, XML Transformation, Mapping Wizards, Implementing Type-I, Type-II and Type-III mappingsInformatica Workflow Manager, Workflow Introduction, Tasks, Workflow Tools, Connections, Defining Tasks.
• Reporting from Other Data Sources, Introducing Web Intelligence, Accessing corporate information with Web Intelligence,
• Understanding how universes allow you to query databases using everydaybusiness terms.
• Managing documents in InfoView, Viewing a Web Intelligence document in InfoView, Customizing InfoView, Setting InfoView Preferences, Creating Web Intelligence Documents with Queries.

Confidential

Programmer/Consultant

Responsibilities:

• Continuous job monitoring using BW Monitor; Handling tickets which involve solving issues in the area of data Extraction from R/3 and Flat File, data staging and BEx reporting.
• Worked on BI Upgrade project which involved pre upgrade and post upgrade activities.
• Worked on EARS REMEDY as ticketing tool to support several clients.
• Developed Complex Be Queries using Calculated Key figures, Restricted Key figures, Variables, Structures, Filters, Free Characteristics, Conditions, Exceptions, and RRI. Built variable exits to prompt with dynamic values.
• Worked on Business Objects and created Aggregation levels, Filters, Variables, Planning functions, Planning Sequences, input ready queries, workbooks, etc.
• Oracle Cursors, Procedure, Triggers and VB application forms
• Created Tables, Synonyms, View and Cluster Tables
• Joined referential Integrity
• Creating Reports in the Benefits module