SUMMARY

• A detail oriented IT professional with around8 years of experience in SAP that includes over 3 years of SAP HANA. Skilled at operating in a wide range of platforms; excellent written and oral communication skills; capable of explaining complex software issues in easy - to-understand terms. Some highlights of my experience include:
• Hands on experience in SAP HANA Data provisioning using SLT Replication server and SAP BO Data Services 4.0.Experience in DATA Extraction Transfer Loading (ETL) for loading data from SAP ECC System to SAP HANA System. Having good knowledge on SAP HANA Architecture. Well versed with importing Meta data, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA IMCE (In Memory Calculation Engine) studio.
• Implemented BW reports using BEx Query Designer/analyzer with advanced features like Variables, Structures, Conditions, Exceptions, Restricted and Calculated Key Figures and distributed using Information Broadcaster. Developed Web templates using Web Application Designer and deployed to Enterprise Portal for end user access.
• Functional exposure and working experience on various modules such as FI-CO, COPA, SD, MM, BW-IP, HR, PS,PM, IS-Utilities and SAP CRM.
• Experience in different type of roles ranging from a Developer to Architect.
• Experience in building reports using Xcelsius, WebI& Crystal reports.
• Strong experience in configuration of SAP BW, MultiProviders, InfoCubes, DSO, InfoSources and different types of extractors based on the business requirement.
• Developed SQL Script procedures and HANA CE functions scripts, HANA views, tables, views as design time objects.
• Hands on experience in Performance tuning techniques for overall system performance (Cube Compression, Partitioning, Indexing) for improving reporting.
• Schema mapping in HANA studio for Export and Import transports from different lifecycle systems. Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit.
• Created SAP Lumira and Tableau reports, dashboards on top of HANA calculation views.
• Flat file data source creation in Business Objects Data services (BODS) and also imported the SAPBI tables into BODS which serves as the BI data source including importing the HANA tables.
• Extensively worked with ABAP Programs, Routines in Transfer rules, Update Rules, and Transformations routines.
• SAP Basis experience includes OS/DB migrations, refreshes, setting up transport routes, upgrades through SUM.
• Exceptional analytical, organizational, and leadership skills, coupled with the ability to research and evaluate business and information requirements to manage, architect, and implement automated solutions which enhance business productivity and competitive advantage. A quick learner, skilled at mastering new software techniques and delivering quality software.

TECHNICAL SKILLS

ERP skills: SAP R/3, SAP ECC 6.0(SD, PP, MM, FI/CO, HR), EHP 5/6/7, SAP NetWeaver 7.x, MS Dynamics AX 2012, SAP Basis

BI Skills: ETL, SAP BW 3.x/7.x, Business Explorer Query Designer and Analyzer, SAP HANA Design Studio, SAP Lumira

Business Objects: Xcelsius, Crystal Reports, WebI, Dashboard Designer, Business-Objects Analysis and Explorer, BODS, IDT

Mobility: Sybase Unwired Platform, SAP Fiori

Databases: MySQL, Oracle 10g/11g/12c, MS Access, MS SQL Server 2005/2008-R2/2012

Operating Systems: Windows 98/XP/7/8/10, Red Hat Linux 8

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Sr. SAP BW/HANA Developer

Responsibilities:

• Understanding the business process and creating the specifications document and get it reviewed before starting the development
• Analyzing the report requirements and creation of base HANA views which are re-usable for other reports
• Worked on design of Architecture of SAP S/4 HANA
• Interacted with senior business executives to review business requirements and propose optimal solutions based on SAP best practices
• Prepared project plans and effective systems development schedules, and monitored team work to ensure that tasks are performed according to schedules
• Guided the team in creating Design Document and technical detail level of Documents
• Reviewed all developments created by team members
• Developed Data models in BW based on LSA++ Architecture
• Developed the data flow that consist of Data Source, Transformation and Info Providers
• Worked on integration, loading, scheduling, and managing data for BW-IP
• Worked on development of Universes in BI/BO 4.1 using IDT from relational databases
• Worked on development of reports in BI/BO 4.1 using BO launch pad, BO Explorer, Crystal Reports, Design studio and Lumira
• Worked on troubleshooting and Performance improvement of BI/BO Universes and reports
• Worked on SQL Developments in creating procedures and Scripted views
• Worked on design and development of HANA XS APIs
• Worked on Creation of Information Models in S/4 HANA 1.9
• Created Analytical, Attribute,and Calculation Views based on Best Practices
• Worked on Data Provisioning using SLT Replication server from ECC
• Worked on ETL Process for Non-SAP Source using BODS
• Worked on Analytic Privileges
• Worked on various components of SAP S/4 HANA
• Worked on Projection, Join and Union in HANA calculation views
• Worked on filters, restrictions, calculated measures, restricted measures in HANA views
• Creation of input parameters, variables and mapping them to get the data filtered at lower level
• Mapping the Input parameters/variables in the SQL scripts and Mapping the Input parameters/variables to BO reports
• Formatting the reports in Calculation views
• Time generation in HANA studio and creation on SQL scripts for calculating time characteristics in HANA views
• Export and Import of HANA views between different lifecycle systems through Developer mode as well as through Delivery unit
• Schema mapping in HANA studio for Export and Import transports from different lifecycle systems
• Creation of BO universes in IDT on top of HANA calculation views
• Creation of WEBI reports on top of BO universes
• Testing the data in the models end to end and support the business users with any questions

Confidential, St. Louis, MO

Sr. SAP BI/HANA Developer& Basis Consultant

Responsibilities:

• Working with the business stakeholders to understand enterprise reporting requirements
• Developing and leading workshops with various business leaders
• Architecting a HANA solution for the OLAP analysis through leveraging data from source systems
• Leading a team of consultants for a BI Analytics enterprise reporting deployment
• Worked with the enterprise architecture team to build a scalable BI 4.0 environment
• Worked with multiple virtual team members across the globe
• Worked on Data Provisioning using SLT Replication server from ECC
• Developed Process Chains to automate the whole daily data loads
• Worked on Data Provisioning using BO data services
• Experience with various aspects of HANA modeling including creating schemas and importing source system metadata
• Developed the SAP 7.4 data mart technical specs for the delivered areas
• Analyzed the regulatory and non-regulatory reports with respect to the security implementation
• Created InfoCubes, DSOs, MultiProviders, process chains, transformations and other objects in SAP BW 7.4
• Enabled SAP Business Object reporting from SAP HANA and SAP BW using WebI, Dashboard, BO Explorer, Crystal reports and BO Analysis
• Created Universes using Information Design Tool (IDT) and used the universes to create reports using tools like WebI, and BO Explorer
• Creation of HANA optimized DSOs, BEx queries
• Creation of complex transformations with start, end routines ABAP logic
• Mapping different data sources and getting data to a single DSO without duplications
• BEx query for complex KPI's and creation of reports to integrate them to the portal
• Helping business users with all the testing
• Enhanced the business processes and SAP system performance by migrating SAP BW data flow and queries using Migration Monitor Wizardfrom 3.x to 7.x within a short time frame.
• Upgraded SAP ERP 6.0 EHP6 to EHP7 hosted on Windows/SQL Server
• Upgrade SAP NetWeaver 7.3 to 7.4 hosted on Windows/SQL Server
• System preparation and Basis configuration to setup managed systems in LMDB.
• Generated support pack stacks using Maintenance Optimizer
• System refreshes on quarterly basis
• Migrated ECC and BW systems from Solaris/Oracle to Windows/SQL server 2012 cluster
• Configured Fiori apps: My Timesheet, My Paystubs and Approve Timesheet
• Scheduling and monitoring the SQL server backups

Confidential, Hopkinton, MA

Sr. SAP BI/HANA Developer & Basis Consultant

Responsibilities:

• Involved in Quality review board meetings and understanding of functional flow from Functional Specifications, High Level Design (HLD), Technical Specifications (TD), Unit Test Plans (UTP), provide estimation details, review check list, and development and review the code of team members
• Understanding of business requirements, resolve the issues and development of new objects
• Understanding of project requirements, landscape, transportation mechanism and process flow
• Debugging, Optimization and Analysis of user defined and existing SAP programs. Solving of Incidents/Change requests/Problem reports within the time limits
• Involved in initial discussions to identify the scope, track, time lines and different activities for project with architect teams, business and QA team
• Involved and developed different type of objects like InfoObjects, InfoCubes, DSOs, DTP, Transformation & Multi-provider
• Using BADI RSU5 SAPI BADI, enhanced the standard BI Data Source or extractor
• Extracted data from data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 02 HDR and populated into the procurement InfoCubes 0PUR C07, 0PUR C08, and 0PUR C09 to evaluate service levels
• Created Transformation Routines, Start Routines, End Routines as per the requirement and for the lookups from one DSO to other
• Created Info packages and scheduled them in order to load Master and Transactional data from SAP R/3 as well as flat file source system into BI
• Extracted data from the finance modules like AR, AP, and GL and enhanced the standard DataSources 0FI AP 04, 0FI AR 04 to meet the client requirement
• Creation of Generic Data sources for Master and Transaction data
• Performance tuning is done to increase the loading as well as report execution speed
• Maintenance activities for a full load without disturbing the delta load is done by taking downtime from the users
• Sent CSV and Excel format data to 3rd party company using Open hub
• Assisted in defining complete test scenarios to cover full scope of the business and carry out the unit and integration tests
• Developed reports in SAP BO by using WebI and Universe
• Developed RICEF objects like Reports (both classical and ALV), Scripts (SAP Script, SMARTFORMS and Adobe forms), Screen designing using module pool programming, data migration techniques like BDC and tools like LSMW, Enhancements using user-exits and BADI in ECC (R/3) side

Confidential

SAP BW Consultant

Responsibilities:

• Resolved support issues and maintenance activities like Data loading, Job Monitoring, Scheduling the jobs, designing and use of the process chains
• Developed logic to bring Master data in Transactional data using transformation routine
• Performance tuning for InfoCube designing and data loading
• Query performance tuning using RSRT
• Created MultiProviders based on InfoCubes, andDSO Objects
• Customer Exit Variables as per reporting requirement
• Creating the Business objects WEBI reports based on BEx query
• Testing the BI reports
• Testing BI data loads(Full and Delta) and data
• Trained end users on Query creation, navigation, and Query designer, BEx analyzer and Web Application functionalities
• Built queries, variables and web templates from existing InfoCubes around supply chain management area. Assigned queries/web templates to security roles in consultation with business partners
• Enabling and testing the connection between other SAP systems
• Testing the connection between application servers and DataSources
• Worked on all the migration issues and applied required OSS notes as per SAP recommendation
• Worked on clean-up activities PSA deletion, Change log deletion and Compression
• Activated standard Business Content as per business requirements for IS-Utilities Module
• Creation and customization of SAP BW components including Extract Structure, Data Source, Info Objects, Transformation, DSO, Info Providers
• As per business requirement created Generic DataSources in ISU - DM, Billing, and FI-CO module and based on that created DSOs as per business Logics
• Created Master and Transactional Process Chains for Daily/Weekly/Monthly data loads and scheduled accordingly to upload the data into InfoProviders with appropriate dependencies
• Worked on Mass upload of ISU-Sales data process
• Created Web templates based on report requirement, assigned queries to template and generated PDF as well as Excel Format
• Created processes for Data Mining with Analysis Process Designer
• Extensively worked onauthorization concept inBW 3.5

Confidential

SAP BW Consultant

Responsibilities:

• Involved in two (2) full SAP BI implementations of SCM and Logistics
• Lead requirements gathering, process and data modeling, logical and physical system design processes
• Created and configured planning application, input-enabled query and user interface using BEx tools
• Assisted in defining and implementing Locking, security and worked on key points
• Developed reports and queries with exceptions, conditions, restricted and calculated key figures, variables and structures
• Analyzed BI statistics and built BI aggregates to optimize report performance
• Activated DataSources from SAP business content enhanced with custom fields
• Reviewed data model for SD modules and analyzed/improved loading performance using Aggregates, Statistics InfoCube, Partitions and Compressed Cubes
• Redesigned the cubes and DSO for better performance, adding InfoObjects, tuning transformations and Enhancement coding
• Built, documented, scheduled and monitored daily, weekly and monthly data loads using process chains
• Created and published Web Reports using Web Application Designer (WAD)
• Used Adhoc Query Designer web item to create, change and execute queries in Web Application
• Used Analysis Process Designer to generate data to help in decision making