SUMMARY:

• Strong team leadership and multi - tasking skills with successful completion of projects within time & budget
• 13 years IT experience which includes 10 years in various roles as SAP BI HANA Lead, BW Architect and BW Analyst involved with Leading the project, design solution, data modeling and developing objects with Project Management and 03 years as Oracle DBA
• Successful 07 Full Life Cycle Implementations with Upgrade experience that includes 5 full lifecycle in SAP BW /BI implementation s and 02 HANA implementation s and 01 BW HANA Migration
• Technical Hands on experience enables high productivity but not limited which includes..
• Specialized in evaluating existing BI/ Suite on HANA /S4 HANA Data Warehouse architecture and suggesting the right areas of improvements/redesign options/optimization opportunities
• optimizing, performance tuning Native HANA, S4 HANA, BW on HANA based on SAPs proven best practices and standard design principles
• Expert in integrating SAP, N on-SAP data to sap BI,SAP Hana by designing best data provisioning ETL techniques, data flow and reporting solutions with Fine-tuned BW/HANA with ABAP and recommended corrective action
• Handled complete Architecture, Design and Integration with HANA, BW On HANA, BOBJ 4.x using layered scalable architecture++ (LSA++) with buildup of hybrid Analytic/BI application
• Hands on in SQL Scripts, Procedures and SQL calculation views in HANA
• BW 7.4 on HANA: Open ODS view using Hana tables and SAP Hana Live, Migration from LSA to LSA
• Knowledge of S4 HANA for real time reporting and positioning BW with S4 HANA CDS Views based on SAP best practices
• SAP HANA: information modeling using attribute, analytical, calculation views using SQL scripts and CE functions, data provisioning SLT, DXC, Business objects data services (BO DS),Reporting on Business objects 4.x Explorer, Webi, Analysis for OLAP, Dashboard
• SAP HANA End to End Functional and Non-Functional Qualifications across DB, Services & UI layers of the Product
• End-to-End Testing which includes Installation/Upgrade of HANA, configuration, administration of HANA, Backup/Recovery, Data transports, User management
• Data replication from SAP,N on-SAP systems using SAP Business Objects Data Services, SAP Landscape Transformation (SLT), Direct Extractor Connection (DXC), Sybase Replication Server
• Modeling, Consumption using clients such as Excel, Analysis office (AO), Business Objects Explorer, Information Designer Tool (IDT), Crystal Reports (CR), Dashboard Designer, Design studio, Web Intelligence (Webi), Lumira (SAP Visual Intelligence), Predictive analysis, Landscape Mgmt., Unit Testing, Functional Automation, Scope Coverage, Implementing Customer like Scenarios for qualifications, and Release Decisions of the Product.
• Hands on HANA from SP 7, 9 and 10 to best meet with technical solution for any client needs for Suite on HANA or Main Car HANA implementation
• SAP Best practices along with existing practices with customers that are in place like Life cycle Management, SCRUM/Master
• Hands on SLT replication that best to suite and utilize the HANA data base to support or optimize HANA space
• Broad overview and understand to work on Bigdata and analytics using Hadoop (Horton networks), Netezza and Greenplum database
• Strong SAP Functional knowledge to leverage in SAP HANA models for optimized build
• Hands-on experience in designing custom InfoObjects, DataSources, InfoSources, ODS/DSO Objects, and InfoCubes.
• Working and leading pool of max 15 consultants to build, assign and monitor tasks for each phase of the project to cover transition between team, migration, cutover with successful roll out
• Design and develop information models attribute, analytical, calculation views on HANA
• Design, trouble shoot and resolve problems related to integration of SAP and non-SAP data in HANA
• Establishing project plans within pre-set budgets and deadlines as well as monitoring project progress as per scheduled deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters
• Setting-up of master data and function locations, importing the relevant data, task lists and maintenance orders of system as per functional requirement
• Excellent communication and leadership skills and strong analytical Skills to analyze functional and technical gaps

SKILLS:

• ERP - S/4 HANA, ECC 6.0, 5.0, 4.7, 4.6C
• BI - 7.3, 7.0, 3.5, 3.1C, 3.0B
• Functional - Supply Chain, SD, MM, Purchasing, FI/CO and Product Costing
• Languages - SQL, PL/SQL
• Presentation and Project Management - Power Point, MS Excel and Clarity Management tool
• Reporting - BEx, WAD, MS Access and BO Webi, Crystal reports
• Training - HANA 1.0 training with SAP

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA 

Sr. SAP BW HANA Migration Lead

• The Project goal is to accomplish migration of BW Database (SQL Server DB to HANA DB) and BW Application from 3.5 to 7.4 and to sync BW System with HANA Migration
• Blueprint, Requirements, Analysis, User Interaction and Measure dependencies with List of reports, Objects and sources of Data
• Check Inactive objects and list the objects that has dependencies to activate data flows and delete unused objects
• Maintain and activate objects in sequence as per data flow and collection of transports in sequence
• Redesign solution by each functionality to store and maintain data Acquisition layer, Corporate memory (Historical data), Data Propagation and Reporting layer data
• Run BW Housekeeping template to perform BW housekeeping and clean-up activities
• Checked and clean up table change logs and delete old tRFC Queues
• Delete temporary BW database tables and Drop empty partitions in F tables
• Delete BW Statistic Tables, unused Master data, old PSA Data and Aggregates
• Check for inactive objects and repair missing tables and indexes
• A pply BI CONTENT 7.47 SP16 before activation of the Business Function based on the SAP Note 2257232 based on DMO Migration option
• Eliminate data redundancies providing one source of data and further propagate data based on storage and reporting needs
• Data consolidation, Activation and further storing and moving data leveraging ADSO’s at the appropriate levels and ensure data activation in HANA Layer
• Consolidated Multiprovider to Composite Providers and make sure the downwards data flows are HANA optimized
• Check /SDF/HANA BW SIZING to measure the required memory based on number and volume of objects
• Run SPDD and SPAU and applying notes based on errors and issues and collection of transports in sequence
• Migrate and Check Authorizations based on upgrade and tested authorizations
• ABAP Routine Analyzer to check routines working to the migration and fix the issues
• Check and Apply Pre-and-Post Migration steps to validate and prepare system before and after migration
• Run /ASU/UPGRADE to check application specific upgrade and apply SNOTES
• End to End System Validation for Sandbox/Dev/QA including Cutover tasks and activities
• Migration of developed objects from old system to New system (upgraded system)
• Checked all queries are migrated and working appropriate by executing queries with reports

Environment: BW 7.4 DMO SUM, SAP HANA, Web Intelligence, AO, Lumira, Design Studio, HANA Studio 1.12, BOBJ 4.2

Confidential, Houston, TX

Sr. SAP S4 HANA Solution Architect with Lead

Responsibilities:

• End to End solution design, Hands on Development, Team Management with Training for Power and End users
• Solution implementation for core functionalities SD. MM, FI/CO, PP, QM, EAM, HR to meet each and every level of Key Metrics for the business need
• KPI’s build to provide visibility of the performance for decision making such as Sr. VP’s, Directors and Managers
• Solution build using HANA live views and customized views based on customer demand to meet reporting needs
• HANA models build with leveraging standard views with customized Calculation views to bring multiple sources of data
• Business Case development and workshops for HANA Agile data marts and Sales applications
• Developed advanced Attribute Views, Analytic Views (standard and scripted), as well as unifying Calculation Views
• Developed advanced SQL Script procedures for integrating SAP and non-SAP data into Unified HANA Model
• Accomplished all integration via SLT replication, including filters written in ABAP exits on SLT.
• Performance improvement on modeling tuning the scripts, applying filters with Input Parameters
• Build models using Consumption, Composite and Basic views
• Copy and modify CDS views based on business facts using Associations and Annotations
• Build CDS views based on artifacts, catalog objects and Schema
• Allocated selected privileges to CDS views to build file based on assigned facts
• Assign ODATA services in ECC to view the result using HTTP via Web services
• Quick exhibition to show output using CDS views with Analysis for Office, Design Studio and Lumira
• Identify Key and right CDS views to suit business functionality
• Optimization techniques applied to meet the performance of the Hana models including plan cache
• Design studio reports are considered to show corporate KPI’s for executive decision making
• Web Intelligence and Analysis for Office reports are leveraged to end user analysis
• Lumira reports are circulated to executive level to measure the performance of production orders creation with accomplishment to track on daily/weekly/monthly status
• Administrative activities with user creation, role maintenance and assigning appropriate roles in HANA and BI Platform

Environment: SAP S4 HANA 1610, HANA Studio 1.12, CDS, Web Intelligence, AO, Lumira, Design Studio

Confidential, Bridge Water, NJ 

Sr. SAP HANA Solution Architect with Lead

Responsibilities:

• Extensively in meetings and interviewing Business and Power users, to determine the flat file layouts, sources, data Layout, Business needs, and naming conventions of the column and table names
• Responsible for end to end technical design of the reporting solution with the intermediate deliverables like data model design and code development as well as data loading for reporting
• Business Case development and workshops for HANA Agile data marts and Sales applications
• Solution build for Audit requirement to track price create and modification by sales orders, Users, Date and Pricing condition with override
• High complex build to meet the performance and audit needs to view price before override, after override with difference
• Developed complex HANA model for pricing in processing up to 400+ million records in a matter of seconds
• Developed advanced Attribute Views, Analytic Views (standard and scripted), as well as unifying Calculation Views.
• Developed advanced SQL Script procedures for integrating SAP and non-SAP data into Unified HANA Model
• Solution build to meet SOX compliance and FDA regulations
• Direct report to Senior Management team to make understand to meet the audit and performance
• Sales order process to integrate with pricing changes to track changes and modifications with override
• Optimized models to meet the performance in applying filters at the appropriate level and pushing the data to the lower levels to best meet with Input parameters/best practices
• Accomplished all integration via SLT replication, including filters written in ABAP exits on SLT.
• Performance improvement on modeling tuning the scripts, applying filters with Input Parameters
• Data loads from MS SQL server using Data services and configuring data loads in DF Editor
• Setup Auto load from MS SQL server using Data services to load appropriate data based on required delta need in HANA
• Universe design and build in IDT and BOBI reports with formatted layout to meet SOX compliance
• Supporting and monitoring for preparing help manuals for all modules to reduce queries from implementation sites and conducting internal audits to ensure on-going improvements in the quality assurance systems
• Identify the production bugs and replicate the same in Dev and Stage and implement the code change through change management
• scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies

Environment: SAP HANA 1.10, SLT, BW 7.3, ECC 6.0, IDT, BODS 4.1, BOBJ 4.1

Confidential, Pittsburg, PA

 Sr. SAP HANA Solution Architect with Lead

Responsibilities:

• Analyze and reverse engineering EDW (Informatica) business model from BOBJ 4.0 Universes to models
• Blue print to identify scope between requirements and measure the gap between existing and HANA proposal
• Lead sessions to understand requirements, discussion with customers, demo the prototype solution that is part of the ‘Present’ and ‘To be’ in place.
• Measure the requirements to fit in the HANA solution to estimate the timeline, scope, sizing, performance and with end solution
• Identify tables and relationships and the models based on business KPI’s
• Strong Data foundation in HANA to match the EDW and reporting structure based on KPI’s
• SAP ERP metadata import using SLT and information packages that provisioning data
• Setup SLT replication from non SAP to HANA and SAP to HANA systems
• Replication of data from non SAP to HANA with load and incremental loads
• Modeling non SAP tables with SAP tables with design and data provision for BO reporting
• Log review with trouble shoot issues during setup and replication
• Create Attribute, Analytical and Calculation views (Graphical and SQL)
• Export and import Attribute, Analytical and Calculation views from DEV to QA to PROD
• Modeling Attribute, Analytical and Calculation views with best practices
• HANA performance improvement on modeling tuning the scripts, applying filters with Input Parameters
• SQL Scripting to handle cycle time of rail car such that to measure the run and idle time
• Data replication using Data services from MS SQL server using Data Services work bench
• Hands on Handling high complexity data from MS SQL server in configuring in DF editor
• Handling flat file loads from Data services and direct extract using HANA with high complex data in filtering records with performance
• Documented the present design based on reverse engineering to create technical specs and report requirements
• Integrate legacy systems and excel based reports in HANA to fit in one Rail Car solution using HANA
• Migrate BW objects and reports from 4.0 to 4.1 building one to one universes defining new data foundation and business layers
• Training Users with minimal effort to match the new reports with the existing
• Design to create data foundation identifying tables and table relationships with model
• Design to support optimization to meet and track the Rail Car cycle based on shipments, Deliveries, Sightings and onsite 
• Working with team of 08 consultants to help in build, resolve issues and monitoring activities to meet with time lines

Environment: SAP HANA 1.7 (Native), BW 7.3 -> 7.4 (Migration), ECC 6.0, SLT, SCEM, BODS 4.1, BOBJ 4.0 to 4.1

  Confidential, Fort Worth, TX 

Sr. SAP BI Lead and Architect

Responsibilities:

• Interaction with EAM functional team to understand the goal of implementation
• Requirements gathering and analysis to study the KPI’s to attain the reporting needs
• Design and Demo the prototype with Adhoc reports to help in understand the scopes and needs from BW
• Build EAM Master data custom extractors based on Function modules with timed dependency
• Configuring EAM Master data with Cost center for staging and consolidation as per the business
• Design and Model with development of solution includes development of InfoCubes, Data sources, DSO’s, Transformations, DTP’s, Process chains, Start and End routines.
• Unit and Integration testing on coordination with Functional team to apply and test based on business rules
• Monitor cutover and production activities to move from Quality and production environment
• End user training to build reports based on required KPI’s to comfort with accessing data
• Gather requirements to study performance effected reports and queries
• Build Technical content query to gather queries statistics
• Meeting with end users to analyze the reports that are mostly effected to prioritize the queries according to business
• Analyze and implement data model between DSO’s vs. InfoCubes, Multiprovider and Logical partitioning, Dimensions of InfoCubes (Include line item and time dimension)
• Analyze Dimension Characteristics and navigational attributes used time-dependent objects
• Analyze and implement Data package size with parallelization and best options to leverage the loads
• Analyze and implement traces with change log and PSA history retention
• Analyze and implement Aggregates, Compressions with rollup options
• Best practices follow to implement the SAP standards that includes table spaces, log monitoring
• Best practices to build queries and changing query model at appropriate level in leveraging the calculation of key figures in backend instead of front end
• Build End to End technical documentation with approach and solution
• End user training to show best practices to build queries and reports

Environment: SAP Net weaver (BW) 7.3, ECC 6.0, EAM, BOBJ Webi, Crystal

Confidential , Akron, OH 

Sr. SAP BI SCM Architect with Lead

Responsibilities:

• Analysis, Requirements gathering, Project estimate, Solution Planning and budgeting
• Solution discussion with Business and End users, Proto development with demo, which includes standard business content vs. custom requirements
• Designed solution to implement as per the Enterprise structure model for Sales, Production Planning with Quality Management and Product costing
• Activation of standard content for SD, PP, QM and CO (PC) as per the needs and verified to meet end to end process
• Design, Development and customization of Multiprovider, InfoCubes, DSO’s - Standard, Optimized,
• InfoObjects, Transformation, DTP’s and Process chains as per the requirements
• Development of Custom code to enhance DataSources using user exits to provide with additional
• Information to meet reporting requirements between SD, PP and QM, PP and Product Costing
• Provided with navigational attributes according to the business needs and drive the functionalities Based on KPI’s
• Designed and developed to provide Delivery data for Demand Planning on exporting data source from BW to SCM
• Developed InfoCubes to provide Sales History for Forecasting needs
• Analysis to understand the data volume to provide with quick and error free loads on optimizing Performance
• Developed prime BEx queries to support with Super users, End users and BO requirements
• Provided detailed report between Production order vs. Direct labor costing, Production order vs. Resource consumption by Variable and Fixed costing
• Designed, Developed to load the flat file loads of legacy systems to give comparative analysis between history and ECC loads
• Designed and developed to provide comparative analysis between Sales history with Attributes Vs. Daily Sales (ECC) Vs. Daily POS sales flow from Vistex thru SAP
• Designed solution to provide with data analysis between Sales, Sales History and Trace data (transaction register) to handle promotions and deals for customers based on POS data from Vistex thru SAP and BW
• Developed to provide Trace Membership list (Vistex) details through from SAP ECC to BW based on Member Id
• Developed to provide Customer and Purchase rebates data from SAP ECC to BW according to Customers and Purchase volume
• Designed to Publish reports using Webi according to Functionalities of business
• HANA Model and setup with BW to access Vistex Transaction data to facilitate to analyze End user data
• Designed and implemented the model with Customer Master and Material Master to drive to get the Global Buying group details
• User roles creation and Authorizations to support with access for Super and End users

Environment: SAP Net weaver (BW) 7.3, ECC 6.0 SD, PP, QM, Purchasing, Vistex, SCM, BO Webi, HANA 1.0

Confidential , Houston, TX 

Sr. SAP BI-New GL Solution Architect and Lead

Responsibilities:

• Requirements gathering, Analysis, Estimate and Planning
• Scope with analysis of the reporting needs of the project comparatively between existing and future reporting needs
• Designed solution to implement NEW GL needs and legacy data build in SAP BW
• Prototype to present the solution based on Legacy (Policy data) Vs. ECC data (New GL basing on Ledgers) in BW
• Activated business content for GL requirements
• Generated data sources for Ledger specific based on GAAP, Statutory and TAX
• Build InfoCubes, DSO’s, Multiprovider for extracting NEW GL data from ECC
• Modeled and build Custom InfoCubes and DSO’s for storing Legacy and BPC needs
• Designed to provide data based on Ledger specific for BPC reporting requirement
• Implemented solution to derive the complexity through BW to bring policy data from LEGACY to BW to ECC
• Team management to help on developing with Functional and Technical specs
• Income Statement, P&L, Monthly A/c Analysis and Balance sheet reports using crystal tool
• Designed work authorizations with security according to priority of users from executive to user level
• Display Crystal reports in web areas according to the LOB’s and segments
• Webi, Crystal reports, CMC Console using 4.0
• Direct usage of Crystal reports through CMC console with BO 4.0
• Extend usage of Content AWB for Authorization, publishing and for, web content
• Planning at each level of ITS with cutover and data loads with transports verification
• Monitoring and preparing the team for successful rollout as per the plan
• User training and support

Environment: BW 7.3, BPC, ECC 6.0, and BO 4.0

  Confidential , Lake forest, IL

Sr. SAP BI Architect and Lead

Responsibilities:

• Blue Print, Data Modeling, Designing, Documentation and Development to till Go Live and Support
• End-to-End BW Configurations and Customizations
• Worked on Budgeting and Estimation from Small, Mid-size and Large Projects
• Worked on monitoring effectively on Cost & Time based planning for each phase with successful rollouts
• Efficient understanding in process flows and proper suggestions in implementing changes w.r.t version changes
• Monitored Resources, Budget and Timelines using Clarity management tool
• Extraction, Staging, Loading, Performance, Transports, and Reporting
• Hands on Multiple Projects with Project estimation, Budget Planning, Task handling, Issue resolving with successful rollouts
• ETL, Data Consolidation and Data Handling with Multiple sources
• Designing according to the committee standards as per the regulatory approvals
• Designing InfoCubes, DSO Objects, Data marts, Logical Models, Process Models, and Enterprise Models.
• Configuration and design of Transfer Structure, Transfer Rules & Update Rules and Process chains.
• Performance based routine design and modification
• Construction of Info cubes, DSO’s, Remote Cubes and Multiprovider
• Data design and extraction between APO <-> BW with Live cache reporting
• Worked on handling Load errors on doing load balances by changing packet size
• Implemented BW Accelerator to improve the performance of load time and query execution time
• Analyzed solution using trace monitor tool to measure the performance of queries
• Applied partitions, indexing and build aggregates to improve the performance of InfoCubes
• Checked change logs to measure the performance on each individual object which has deep performance impact
• Optimized DB statistics usage to keep and track the history changes as per the requirement
• Applied parallel servers to execute the data loads to improve the performance of data loads
• Handled data loads by resolving errors and by following the proper delta loads between each source and target
• Handling 24/7 support with weekend loads
• Emergency fixes with Immediate Problem solving based on prioritized Incidents and Requests

Environment: BW 7.0/3.5, BWA, ECC 5.0/6.0, SD, MM, FI/CO, SCM 5.0 and Solution Manager