SUMMARY

• Having 10+ years of Dynamic experience & extensively worked on Accelerated SAP Methodology in Upgrade, Enhancements, Supporting and Implementation of Project Designing, Development and deploying solutions as SAP HANA Modeler, SAP BW/BI & SAP BOBJ Reporting Consultant.
• Knowledge on SPS09 new Concepts of SAP HANA Live for Modeling Views.
• Experienced in using CE functions, SQL, PL/SQL, Procedures, decision tables in SAP HANA.
• Good exposure with data replication to SAP HANA using DXC, SLT, BODS and Flat files.
• Expertise in using SAP HANA Studio Modeling Views and created complex Information Models.
• Worked on different types of data related for Actual, Plan & Forecast data Value types, Versions & Currency types to build HANA complex Information modeling views.
• Using SAP Net Weaver BW 7.3 & BW 7.4 powered by SAP HANA, done migration from BW on HANA.
• Used Hierarchies, Attributes and Measures for Master Data & Transactional Data for Daily, Weekly and Monthly depending on the requirement from Users.
• Experience on SAPNativeHANAData Provisioning (LT, DS), Data Replication, Modeling and Reporting.
• Experienced in SAP Lumira Visualization application tool & built story boards for Business Users for their detailed analysis. SAP Lumira cloud edition makes it easy to Analyze and collaborate on data.
• Using SAP Lumira cross tab capabilities and multidimensional analysis that easily swap rows and columns, display hierarchies and data formatting using Prepare, Visualization, Compare the Story board and Sharing the information by exporting and Publishing to other areas.
• Objects Transportation to SAP HANA is done using life cycle management & Delivery Unit.
• Worked on FI - CO finance models & Logistics Models.
• Used SAP BO Reporting tools WEBI, Crystal Reports, Explorer, Analysis Office, Dashboard & Lumira.
• Experienced in migration BO 3.x to BI 4.x and developed end-to-end BO Reporting tools.
• Expertise in BO for Breaks, Alerts, Global and local Filters, Sorts, Rank, Query Prompt, Drilldown, filters, Crosstab reports, Charts, prompts, Filters, Calculations, Query Panel, Prompts in WEBI.
• Created Technical specifications documents by understanding business functionality from the client’s requirement and provided standard modeling documents for SAP HANA.
• Creating Artifacts- packages, attribute views, analytic views, calculation views Analytic Privileges, Procedures, Functions, Sequences, Views, Synonyms, Triggers, Decision tables, CE Functions.
• Experienced in using DXC for extracting data from BW to HANA DB
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA.
• Replicated data from ECC to HANA using SLT based table Data Provisioning and also performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning
• Experience with SAP HANA programming including SQL, SQL Script, and CE Script.
• Created and managed Delivery Units to move across different environments
• Worked on SAP HANA administration including managing schemas, import/export content.
• Extensively worked on SAP HANA Analytical privileges, granting access and restrictions to users on various views within the data modeling.
• Using IDT created connections to SAP HANA databases, Create data foundations and also created Business layer and publish these connections and layers to SAP BO Repository.
• Managed offshore Team & suggested tweaks whenever required. Quick learner and good team player with strong interpersonal & communication skills. Well organized & committed to timely delivery of work.

TECHNICAL SKILLS

Operating Systems: Windows XP/ Windows 7/ NT/ and UNIX.

ERP: SAP R/ 3 4.7, ECC 6.0

Data warehousing & ETL: SAP BW 3.5, BI 7.0, BI 7.3, BI 7.4, SAP BODS.

Programming Language: ABAP Basics-Specific to BW, SQL and CE Functions.

Databases: SAP HANA, SQL & Oracle

Reporting Tools: Crystal Reports, Explorer, WEBI, SAP Lumira, Dash Boards, BEx and AO.

ENVIRONMENT: SAP ECC 6.0, SAP BI 7.3/7.4 BOBJ 4.1 SAP BO Suite, Webi Universe, IDT, Explorer, Crystal Reports,SAP Lumira, Analysis office & OLAP.

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. SAP HANA/BO Consultant

Responsibilities:

• Worked on FI-CO finance models & Logistics Models.
• Using Trigger based SLT, fetched the data records from ECC tables filtering and transformation applied and with skip new base structure applied to write module in SAP HANA.
• Information Models for Attribute Views, Analytic Views & Calculation views created based on Application Specific Modules FI, COPA, CO-OM & CO-PC using OLTP & OLAP data.
• Created designed time objects OLAP data & made SAP BO reporting possible with run-time objects.
• Applied SQL and PL/SQL, stored procedures and functional experience to new enhanced objects.
• Using Analytical views for transactional data, Attribute views for master data and calculation views as final model created both Graphical & SQL scripting in HANA.
• Experienced in SQL, PL/SQL and dimensional STAR schema data models of data warehouse/data mart life cycle, development of dimensional and relational models.
• Using delivery unit collected Packages (which contains Attribute Views, Analytic Views and Calculation Views) Procedures and transported from D-Q-P using life cycle management with Admin role.
• HANA Admin Activities performed in creating the Developer & Supporting roles for the team and Business users as on requirement comes.
• HANA models reporting is done using IDT to build Business Layers for OLAP Connections that used for each of the Application modules and used them in Central repository available for Reporting.
• Information models for Actual data, plan data & forecast data created and loaded to SAP HANA.
• In Confidential, GST (Goods and Services Tax) monthly tax reports for Input tax and output tax is created based on specific tables extracted from ECC. Applied specific requirements and conditions for that fields and created Information models and generated the reports on it.
• Reporting tools SAP Lumira, WEBI, Crystal Reports, Dashboard and Explorer used for developing the reports based on business layers created in IDT & BICS connection for OLAP.
• Using Information models, COPA reports for Income Statement flexible analysis for Actual, Plan, forecast reports, and profit center accounting data that developed in reports.
• Using Information models, Finance (FI) reports for open items & closed items and general ledger items reports are developed.
• Built Calculation Views to join multiple tables and implemented complex business logic to meet reporting requirements.
• Designed and developed the data models in HANA from multiple sources system via SLT using (SAP and non-SAP) for Real-time replications and BODS for Batch Job replications.
• Creating users and assigning the roles and data level security using Analytic Privilege with HANA Studio. Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• Creation & maintenance of Crystal reports Database expert, Grouping expert & Cross tab expert.
• Involved in Unit Testing, Integration testing and Business acceptance Test and updated at wiki share point folder documentum.
• Data Replication of SAP HANA which include SLT, BODS (ETL Extraction), DXC and Flat files.
• Good exposure at Schemas, Attributes, Measures, table definitions & Hierarchies in HANA.
• Performed data analysis visualizations using BO Reports and SAP Lumira for Reports for Comparison.
• Preparation of utilization reports and analysis of resource utilization
• Analyzing the KPI reports and review on SLA issues.
• Schedule the meetings and trainings regularly on updates
• Conducting periodic trainings and knowledge transfer to the team members.

Confidential, YOUNGSTOWN, OH

Sr. SAP BO/BW Consultant

Responsibilities:

• Interacted with Client frequently in understanding the requirements gathering and handling of new enhancements as per client requirements and creating various type of reports.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages
• Developed load strategy & created process chains to schedule the loads on daily, weekly and monthly
• Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions. Also Developed Custom Generic Data Sources through Views.
• Experience in data modeling using different types of attributes, standard and custom Info Cubes, Infoobjects, InfoSources, DSO, Multiproviders, Datasources, Transformations and routines.
• Creation of BEx queries from Query designer and Creating workbooks using BEx Analyzer and Extensively Worked on SAP BO-Analysis Office.
• Installing standard data sources from R/3 and testing the data from RSA3.
• Transporting the newly created flow, Infoproviders, Chains, and Queries.
• Preparing the status reports and follow-ups for periodic meetings with the Global team.
• Development system and Quality system Testing and Upload the test cases to the intranet database for approvals.
• Experience on SAP Solution manager to create Change request document for transporting of Objects from DEV-QA-PROD.
• Co-ordination with Data Load Monitoring, Basis and other Functional teams in solving loading problems, dump and functional related issues.
• Preparing the KT documents on special issues, updating them in common portal and discuss them in the meetings.
• Resolving all tickets within SLA and without escalations from client.
• Handling Flat File loading in various requirements.
• Involved as a Creator, SME, Implementation manager and Tester for change of requests using SAP solution manager.
• Extensively worked on Performance issues like Indexes, Statistics, Compression of Info Cube and rolling up the Data to the Aggregates.
• Preparation of Test scenarios and Test case Documents for Unit, Integration and User acceptance testing before and after transporting of Objects into Production system.
• Involved in debugging the data load failures that found the exact failure.

Confidential, Moline, IL

SAP BI/BW Consultant

Responsibilities:

• Extensively involved in setting up the procedures for extracting the data from ECC using LO COCKPIT and GENERIC extractions
• Created Generic Data sources using Tables and Views for extracting Master and Text Data.
• Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
• Successfully scheduled repair full loads for Master Data Attributes, Texts, Hierarchies whenever new Master Data enhanced.
• In case of data load failures, involved in analyzing the errors, and took corrective actions
• Involved in understanding the functional concepts of cost centers, orders, WBS elements, Income statement that helps to handle the reconciliation issues from R/3 to BW.
• Data loading was monitored and failed data packets analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to targets.
• Involved in postponement of transaction data whenever there is a master data load failure.
• Scheduled data loads from SAP R/3 to BW, Monitored data loads that are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
• Designed queries using BEx Analyzer Reporting tool for data presentation.
• Handling on reconciliation issues by checking the data between R/3 and BW systems.
• Worked on process chains to automate delete indexes in Infocube, creating indexes, DSO activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Creating aggregates, drop Indexes & build Indexes to improve the loading & query Performances.
• Performance tuning of queries using aggregates, indexing of InfoCube.
• Daily monitoring of Info Cubes, DS objects requests, and back ground Batch Jobs (SM37).
• Actively involved in Load monitoring of daily, weekly & monthly Data Loads using Process chains.
• Analyzed production load errors and rectified the same in stipulated time.
• Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain good teamwork.
• Attending day-by-day meetings for Internal Review Meeting, Quality status & Client Review Meetings. Interaction with users to resolve BW reporting issues

Confidential

SAP BW Functional Consultant

Responsibilities:

• Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
• Customized LO cockpit by using enhancements and wrote User-Exit programs to populate the enhanced fields.
• Involved in creating Generic Extractors using Table, Function Module and View.
• Involved in creating of new data flow & data model. Created new InfoCube, DSO and InfoSources data sources, new Characteristics and Key figures.
• Also involved in Re-initialization of Data Sources from SAP R3 and Business Content Activation.
• Created analytical reports using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure, Exception, Conditions, Cell Restriction, Filter & different Variables with processing types.
• Designed the Process Chains with different ways of loading Master data & Transaction data.
• Responsible for job schedules for loading data and monitoring Process Chains to run periodic loads.
• Designed queries using BEx Analyzer Reporting tool for data presentation.
• Extensive experience in Designing Analysis Office, Queries by using BEx Analyzer.
• Loading of Master Data Hierarchies from different source systems on Daily, Weekly Monthly depending on the User requirement of Data.
• Excellent skill set in building queries using Reusable structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.
• Proficient in extracting the data from SAP R/3 to BW. Expert in LO Cockpit & Generic Extraction
• Involved in managing of Infocube data which involves Infocube contents, performance issues like Indexes, partition, Aggregates, Line item Dimension, compression of Infocube and roll-up.
• Expertise in production support issues which involved in debugging ABAP Routines, Process Chains Monitoring, Data source Enhancement, Remote Cubes, Multicubes, fixing errors and daily ETL Data load (Full/Delta upload) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.
• Monitoring of whole system like of BIA indexes, checking reporting indicator, checking RFC connections, checking the reporting indicator.
• Involved in daily, weekly, monthly Application Monitoring activities.
• Dropping and rescheduling chains of daily loads.
• Data loading was monitored and failed data packets analyzed and if possible manually edited in PSA for invalid characters and re-loaded data to targets.
• Involved in postponement of transaction data loads, whenever there is a master data load failure.
• Monitoring the data loads from various source systems by means of process chains/batch jobs.
• Error Debugging and rectification, solving issues, problems faced during Data loads.
• Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Interacting with business partners and gathering information about the key points and BI Key reports.
• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Involved in solving high-prioritized tickets for extractions, performance issues & data load failures.
• Scheduled data loads from SAP R/3 to BW, Monitored data loads that are running hourly, daily, weekly & monthly basis and solving errors when occurred.
• Handling on reconciliation issues by checking the data between R3 and BW systems.
• Involved in bug fixing that occurred because of the issues in routines.
• Maintaining Work History for all the tickets until it is closed.
• Preparation of utilization reports and analysis of resource utilization
• Analyze KPI reports & review on SLA issues by scheduling meetings and trainings resources.
• Conducting periodic trainings and knowledge transfer to the team members.

Confidential

SAP BW Functional Consultant

Responsibilities:

• Involved in postponement of transaction data loads, whenever there is a master data load failure.
• Monitoring the data loads from various source systems by means of process chains & batch jobs.
• Error Debugging and rectification, solving issues, problems faced during Data loads.
• Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Monitored data load activities & recovered failures in Dev, Quality system as a part of unit testing.
• Involved in solving high-prioritized tickets in extractions, performance issues & data load failures.
• Scheduled data loads from SAP R3 to BW, Monitored data loads that are running hourly, daily, weekly & monthly basis and solving errors when occurred.
• Handling on reconciliation issues by checking the data between R3 and BW systems.
• Involved in bug fixing that occurred because of the issues in routines.
• Preparation of utilization reports and analysis of resource utilization.
• Involved in daily, weekly, monthly Application Monitoring activities.
• Dropping and rescheduling chains of daily loads.

Confidential

SYSTEM Engineer

Responsibilities:

• Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
• Customized LO cockpit using enhancements for User-Exit programs to populate enhanced fields.
• Involved in creating Generic Extractors using Table, Function Module and View.
• Involved in creating new data flow / data model. Created new InfoCube, ODS, Info-sources, data sources, new Characteristics and Key figures.
• Involved in Re-initialization of Data Sources from SAP R/3 and Business Content Activation.
• Created analytical reports using formulas, selections, structures, Calculated Key Figure, restricted key figure, exception, conditions, filters and variables with different processing types.
• Designed the Process Chains with different ways to load the data.
• Responsible for job schedules, loading data and monitoring Process Chains to run periodic loads.
• Designed queries using BEx Analyzer Reporting tool for data presentation.