PROFESSIONAL SUMMARY:

• Over 8 Years of professional IT experience, in Analysis, Design and Development of SAP with various industries implementing SAP BW/BI/HANA and SAP ECC,which includes Around 5 Years of US Exp.
• Experience in 3 full life cycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Documentation and end user .
• Experience in information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support.
• End - to-EndSAPHANAimplementation projects with both NativeHANAandSAPBWonHANALandscapes.
• Created NativeHANAmodeling scenarios and activities such as adding system, creating schemas, content models, attributes and measures.
• HANA Data modelling experience in creating Attribute View, Analytical View, Calculation View, CDS Views, Stored Procedure, SQL Scripting, Table Functions, Decision Tables and Analytical Privileges.
• Utilization of HANA best practices, and HANA performance Optimizations (HANA PlanViz, Expensive Statements Trace, and HANA Memory Consumption).
• Replication of data toHANAfrom bothSAPand non-SAPSystems using SLT, BODS
• Experience withSAPHANAupgrade projects and migration activities fromSAPECC to suite onHANA.
• Hands on experience withHanaSecurity activities like User Management, Assigning roles to user and develop Analytical privileges (both classical and SQL based Analytical Privilege)
• Experienced in all phases ofBWimplementation using ASAP methodology.
• Exposed to all phases ofBWimplementation like analysis, design specification, development, testing, documentation and trouble-shooting.
• Excellent Team Player and Team Handling Capabilities.
• Good interpersonal relations, strong communication skills, hardworking and high level of motivation.
• Experienced in all phases ofBWimplementation using ASAP methodology.
• Exposed to all phases ofBWimplementation like analysis, design specification, development, testing, documentation and trouble-shooting.
• Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.
• Strong experience in BW 3.x and BI 7.x version and upgrade technical and functional.
• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.
• Worked on BW support project activities data loading monitoring and troubleshooting the failures.
• Experience in system maintenance tasks Delta queue cleaning, Setup table deletion validation
• BW load/job automation through process chain and Control-M.
• Worked extensively in SD, MM, PP, and FI Modules.
• Strong in performance tuning Data loading and BEX reports and job failure reduction activities.
• Extensive experience with Requirement Gathering (from process design owners, Business Groups, Power Users and End users), Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design & Development of BI objects) and Post Production Support.
• Solid experience on BW 7.5 and its new features like Hybrid Providers, Advanced DSO, Composite Provider, HANA Views, HANA Optimized Cubes.
• Solid experience in construction of customized Info Objects, Basis Info Cubes, Remote Cubes, Transactional Cubes, Virtual cubes, Multi Providers, Info sets, ODS/DSO objects, Advanced DSO and Composite Provider.
• Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.
• Expertise in OLTP extractions from SAP R/3 using LO Cockpit, COPA, Generic Extractions and non-SAP extraction.
• Expertise in complete life cycle implementation inSAP BI 7.0module which includes Data Modeling, Data Extraction LIS,LO Cockpit, Generic and Flat File extraction, Data Loading Full /Delta Up-Load, Scheduling, Monitoring, Report generation and Production Support.
• BW Security—Experienced on Authorizations.
• Excellent ABAP programming skills.
• Good Knowledge in improving the performance of Applications.
• Excellent communication, interpersonal, managerial skills and positive work attitude and self-motivated to work independently and as well as in a team.
• Experience in Creating Universes (.UNX and .UNV) and Connections (Universe connections and BICS connections) using Business Objects Universe Design Tool, Information Design tool(IDT) for Web Intelligence (WebI) query and report making by connecting through BEx queries.
• Expertise in creating Xcelsius Dashboards by using Selectors, Filter Rows, According Menu, Check Boxes, List Builder, List view, Single Values, Maps, Charts, Dynamic Visibility, Alerts.
• Working knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer, Crystal reports.
• Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.
• Excellent understanding work Experience of building Complex Universe s of Normalized De-Normalized schemas using Information Design Tool IDT.
• Hands-on experience with Advanced Analysis Office edition, created Analysis reports over BEx queries and Converted BEx Workbooks into Analysis Workbooks.

TECHNICAL SKILLS:

ERP: S4/HANA, SAP ECC 6.0, R/3 4.6C/ 4.6B/ 4.5B

Data Warehouse: SAP BI/BW 3.5,7.0,7.3, 7.4, 7.5

SAP HANA: HANA Studio

Languages: ABAP/4, C, C++ and VB.

Reporting Tools: BEx Reporting, Web Reporting, Report Designer, Crystal Reports, and Business Objects XI 4.2

Operating Systems: Windows 95/98/2000/XP and Windows/NT

RDBMS: MS-Access, Oracle, SQl and HANA.

WORK EXPERIENCE:

Confidential, Minneapolis, MN

SAP BW/HANA Consultant

Responsibilities:

• Developed BW HANA migration strategy, re-design requirements, system architecture and landscape.
• Prepared pre-migration and post-migration task lists for HANA migration.
• Experience on both SAP BW 7.4 and 7.4 platforms, including integration with SAP Business Objects
• Executed remediation and build activities such as ADSOs, IMO conversion, composite provider conversion to HANA composite providers.
• Prepared sizing estimates for BW on HANA migration.
• Conducted workshops and led design activities for dual maintenance, Oracle and HANA parallel operations to keep both PRD systems in sync until end of support.
• Extensively worked with SAP Post Copy Automation (PCA) tool for BW system copy activities and delta queue cloning to load data to both BW Oracle and migrated BW HANA systems in parallel.
• Performed clean up tasks in source BW system to reduce storage space.
• Involved in HANA hardware procurement, identifying target application software versions and support pack levels.
• Piloted DSO based reporting eliminating redundant Reporting layers to move to LSA++ architecture.
• Designed and developed reporting solutions using BI reporting tools such as Webi, AOLAP, Analysis office, Dashboard designer.
• Designed and built complex Dashboards for trending and exception reporting
• Built transient and Composite providers to merge Historical data in BW with HANA models providing real time information loaded using SLT.
• Migrated BW Web template reports to BO reports using Webi and AOLAP tools.
• Designed framework and deployed BW Workspaces for end user self-service needs.
• Interfaced with stakeholders to gather reporting requirements and translated requirements into BI solutions.
• Developed an overall reporting strategy for SAP BW & SAP HANA.
• Prepared sizing estimates and involved in HANA hardware procurement.
• Led overall solution design, architecture and production deployment of Native HANA environment.
• Designed solutions in HANA for complex business requirements.
• Designed and built a data foundation platform for Indirect taxation reporting.
• Developed Information models using Attribute Views for master data and text, Analytical and Calculated views.
• Built Calculation Views to join multiple tables and implemented complex business logic to meet reporting requirements.
• Possess Strong knowledge/experience of HANA View Modeling using Analytical views, Attribute views, Calculation views and Performance tuning.
• Developed BODS data flows to extract data from SAP BW and non-SAP systems to HANA.
• Configured and set up SLT jobs to load data from SAP ECC to HANA.
• Replicated Sales and Billing tables via SLT from ECC to develop Customer Pattern Analytics reporting to predict customer behavior and Customer invoice analysis reporting to identify errors.
• Replicated tables from ECC and CRM to build data quality checks on customers and contacts. Extracted data from non-SAP system as well using BODS for this use case.
• Designed and developed a Tax solution in HANA using finance data extracted from ECC and Tax tool for Tax reconciliation reporting.
• Built HANA reports using front end tools like BO Webi, Lumira and Tibco Spotfire.

Environment: SAP S4 HANA, HANA 1.0 SP9/SP10, Simple Finance 2.0, HANA Live, Business Objects 4.1, IDT, SAP Solution Manager.

Confidential, St. Louis, MO

SAP BI/BW HANA Consultant

Responsibilities:

• Involved in Collaborating with Client managers, DBA's, Reporting team, Business users and other Stake holders to understand SAP HANA, the existing landscape and identify key business use cases for the Proof of Concept.
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, User stories, business rules for finance, sales and marketing domains.
• Worked on conducting workshops to go over the new tasks with the system administrators and SAP Basis Consultants and also created an application by application migration approach from SAP BW to HANA system.
• Using Import selective Meta data for SAP BODS 4.1 imported Meta data in the ETL Process prior to on boarding data into sap HANA, created schemas and data provisioned using SAP LT Replication Server SLT.
• Developed Business Object Data Services BODS4.1 jobs to pull external data from Flat files and Oracle into HANA database.
• Developed jobs to complete remediation of legacy data, data quality management, data profiling using both built in and custom functions.
• Worked with various transformations like Query, SQL, Key Generation, Merge, Case, Map Operation and Table Comparison in Platform and DI Transforms and extracted data according to the business rules and Technical Specifications.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, in order to address complex business requirements created SQL Script based Calculation views.
• Involved in creation of Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA IMCE STUDIO
• Used Information Design Tool IDT to create connections to SAP HANA databases, create data foundations and also created Business layer and publish these connections and layers to Repository.
• Created Dashboard for Supply chain and Inventory executive dashboards using Design Studio.
• Extensive working experience with different components of Designer Studio like Charts, Selectors, Text, Maps and Containers.
• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.
• Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Enabled Business Objects Explorer to search data present in HANA.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through BOBJ Crystal Reports, BOBJ Dashboard Design, BOBJ Web Intelligence Webi, BO Analysis.

Environment: SAP BI 7.31/7.4, HANA 1.0 SP9/SP10, HANA Live, ECC 6.0, PS, PM, QM, FI, HR,WEBI .

Confidential, West Palm, FL

Sr. SAP BW/BOBJ Consultant

Responsibilities:

• Expert in requirement gathering, documenting the requirements, designing and then implementing the solution for different complex Requirement.
• Designed North America Supply Chain Management Dashboard in design studio 1.4
• Created Dashboard to represent Sales Quality performance metrics.
• Design Master /detail Dashboard with Design studio by connecting to bex queries
• Designed Technical and Functional specifications for SCM Scorecard.
• Designed Analysis process designer to source data into A/P DSO to consume into Design studio applications.
• Designed PPC Sales Dashboard in Design studio 1.4
• Given Knowledge transfer and sessions to BI support team.
• Created bex reports, BICS connections to source Dashboard.
• Hands on SAP lumira.
• Modeling of infoproviders to provide data for SAP BOBJ applications.
• Implemented Design studio applications using Archius ChartsPlus components.
• Installation of 3rd party components for design studio on BOBJ server.
• Created Account model to load flat files for planning data.
• Created CSS files to link Design studio applications.
• Created Jobs, Work flows and Data flows according to the Business requirements and implemented the business logic.
• Created Process chains to load from flat files and load planning and actual data into reporting DSO.
• Testing of Advanced Analysis 2.0 workbooks.
• Involved in Testing of BOBJ Upgrade to 4.1
• Promotion of Content design studio applications using LCM Jobs.

Environment: SAP BI 7.0 Ehp1, ECC 6.0, MM (Purchasing and IR), PC, FI and WEBI 4.0

Confidential

SAP BI/BW Consultant

Responsibilities:

• Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.
• Analyzed and mapped business processes to BW and wrote Business Blue Print.
• Built a custom delta extractor on Deferred Revenue based on Revenue Recognition ‘VBREVE’ table in combination with CO-PA (CE1XXXX), SD (VBAK, VBRP, VBKD) and FI (BKPF) tables.
• Handled various scenarios in the extractor function module and BW start routines to enable snap shot reporting of Deferred Revenue.
• Extensively involved in creation and maintenance of Update rules, transfer rules as per client requirements.
• Created financial Multi cube in order to obtain the desired result.
• Extensively used Process Chains for master and transaction loads.
• Created a Meta Chain for all the sub process chains for a smooth run.
• Built a custom flow for McAfee eBiz to load orders and payments data into BW from Siebel.
• Worked closely with Production Planning PP, material management MM, Sales and Distribution SD, Logistics LE, Financials FI AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale POS data via DataStage and other integrated solutions.
• Designed Data Marts as per the System landscape, created Functional and technical BW specifications, considered proper data modeling techniques and data management strategies and created Technical BW Specifications for BW Objects.
• Worked with SAP ABAP team and created code that will result in the highest performance possible.
• Provided Knowledge transfer KT and to BW team members and Super Users and guidance to team members on Excel-to-SAP project related to Manufacturing during all phases of project.
• Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, InfoSources, DataSources and corresponding extract, transformation, communication structures.
• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0
• Created Service Level Objectives SLOs, Solution Documents with the BW team that will guide the production support team when issues occur.

Environment: SAP BW3.5, SAP R/3 4.6C/4.7, ABAP/4, FI/CO modules, Windows 2000/NT.