PROFESSIONAL SUMMARY:

Sr. SAPBW/HANA/Snowflake Architect with hands on experience on various full life cycle (FLC) implementations of HANA projects and has 14yrs of strong working experience in SAP BW 3.5/3.0/7.0/7.3/7.5 in different functional areas like Sales and distribution (S&D), OTC(Order to cash), PTC(Procure to Pay), CRM, Material management, Global Trade Management, Finance and Controlling, Human Resources and Production Planning(PP).

EXPERTISE HIGHLIGHTS:

Database: Oracle, My SQL, HANA.

Reporting Tool: Business Explorer (BEX), AFO, BOBJ /BO 3.x and 4.x (WEBI, Info view, BI Launch pad), Tableau.

BI Tools: SAP BI 3.5, 7.0, 7.3, 7.5, Native HANA, BW on HANA.

Cloud Technologies: Snowflake, AWS (S3 and IAM), ETL (IICS) and At scale.

Functional Areas: SD, MM (Inventory and Purchasing), FI (GL, AR and AP), GTM (Trading Contract information), COPA (controlling and Profitability analysis), HR (Payroll, Organizational Management, Personnel Actions and Time Mgmt), EWM.

Ticketing Tools: Service now, Remedy.

Agile Tools: Jira

Microsoft Packages: MS Office, MS Access.

Languages: SAP BI ABAP, HANA SQL, SNOW SQL, Python (Snowflake)

Platforms: Windows, Unix, Linux

WORK EXPERIENCE:

Confidential, Burlington, MA

Sr. Snowflake Architect/Consultant

Environment: Snowflake, Snow SQL, Python, IICS(ETL) and At scale.

Responsibilities:

• Requirement gathering has been done for Multiple projects (8 Projects) with respect to Flat files, HANA, Oracle and SQL server as source from Multiple stake holders across the locations.
• Analyzed the Requirements and Design the solution taking the best practices into consideration and Estimate the Timelines for the Projects and get the design approved by the management team.
• Created Functional specs and technical specs for the requirements we had gathered.
• Worked on complex SNOW SQL and Python Queries in Snowflake.
• Generated/ Created SQL in HANA, Oracle and SQL Server to pull the data to snowflake.
• Used AWS S3 Buckets to store the file and injected the files into Snowflake tables using Snow Pipe and run deltas using Data pipelines.
• Extensively worked on the AWS S3 and IAM Features to load the data to snowflake.
• Enabled Versioning, Data encryption, Requestor Pay, Setting up Storage areas and Life cycle Management, Replication in AWS S3.
• Used IICS (Intelligent Informatica Cloud services) as an ETL tool.
• Worked on UNIX commands for File operations for IICS.
• Created Connections in the ODBC Administrator by selecting the appropriate drivers for the ETL IICS.
• Generated the Source SQL Codes and used them in the Mapping and Synchronization Task in IICS.
• Used Transformations Like Source, Target, Aggregator, Normalizer, Joiner, Union, Expression, Data Filter, Sorter, Lookup, Sequence Generator Etc in the Mapping.
• Written Pre and Post SQL for Data Manipulations in the ETL Tool.
• Created the Mapping Tasks and Task Flows for automating the data loads with in the ETL IICS.
• Created DB, Schema, Virtual Warehouses, Tables, Views, Stages, Sequence and DB replication in Snowflake Cloud data warehouse.
• Used Replication Task to have the data back up in Snowflake.
• Worked on Snowflake advanced concepts like setting up virtual warehouse sizing, query performance tuning, Data Sharing, UDF, Zero copy clone, Time travel and Data Pipelines (Streams and Tasks).
• Managed RBAC Controls in building security Model for Snowflake Data warehouse and used Resource Monitors.
• Designed and developed the Atscale cubes for data analysis and created Excel reports on top of it.
• Followed the Snowflake best practices like Clustering the View and Tables, created Materialized views, enabled the Result cache, Resizing and Multi clustering to improving the Performance in Snowflake.
• Drafted User Manuals and given Knowledge Transfer to Business and support Teams.
• Experience in Redesigning and Migrating/ Other data warehouses to Snowflake Data warehouse.
• Extensively worked in Agile environment through Jira.
• Managed the Multiple vendor teams with a head count of 12 resources, use to review the Offshore development tasks in daily stand up’s, participate in the grooming sessions and assist the offshore and the user community in case of any issues.

Confidential, Nashville, Tennessee

Sr. SAP BW/HANA Architect

Environment: SAP BW 7.3 on HANA, HANA SQL, Native HANA, EHP.

Responsibilities:

• Requirement gathering has been done to FI, CO, Work Order Material data (SQL Server), Business partner information, MM (Inventory and Purchasing), SD for Data Modeling.
• Had done Gap analysis and identified the Fields in ECC, SQL Server.
• Created Functional specs and technical specs for the requirements we had gathered.
• Provided the estimates for the project depending on the scope of work.
• Extracted the data from LO/LIS and Generic extractors into BW.
• Used HANA Studio for creating BW Objects.
• Created BW Models like ADSO, Composite providers in HANA Studio under BW Modeling tab and generated HANA Views for the same using Built in functionalities.
• Used Data Provisioning techniques like SLT and BODS to pull the data.
• Configured SLT (SAP Landscape Transformation) for Native HANA.
• Figured out the tables that need to be replicated using SLT (SAP Landscape Transformation) as per the business requirement.
• Using SLT (SAP Landscape Transformation) replicated the tables to HANA and Monitored the data loads for pulling the real - time data.
• Worked on BODS to pull the data from SQL Server into HANA Side Car.
• Extensive experience on Partitioning and dynamic tiering to improve the data performance.
• Created graphical Calculation Views on ECC and SQL server Tables.
• Worked on creating Staging table using SQL for increasing the portal performance.
• Used Input parameters for Dynamic variable restrictions for Trending Analysis.
• Created Stored procedures for various purposes in this project.
• Used Dynamic Tiering, Partitioning and Merge for increasing the performance.
• Knowledge on creating analytic privileges and providing access to Users.
• Exported the Views from Content and Catalog from Development Systems and provided to HANA admin team.
• Pulled the tables into to HANA Side for building the calculation views.
• Extensively worked on HANA AMDP Procedures.
• Hard coded the filters and created restricted and calculated measures using various HANA functions.
• Used HANA Life Cycle Manager for Migrating the code from one System to another across the landscape.
• Checked the Functionality of different views in Quality and Prod, whether they are working as desired or not.
• Participated in HANA performance tuning of HANA Views and SQL scripts using various techniques.
• Unit, Integration and Business acceptance testing was done in the respective systems.
• Prepared User Manuals and given Knowledge Transfer to Business and support Teams.
• Unit, Integration and Business acceptance testing was done in the respective teams.
• Used BEX, WEBI and Tableau for HANA reporting.

Confidential, Maumee, Ohio

SAP BW/HANA developer

Environment: SAP BW 7.3on HANA Studio, HANA Side Car, HANA cloud, SAP ABAPECC and SAPBO.

Responsibilities:

• Requirement gathering has been done for the SD(Order To Cash), GTM,PP,QM, FI, CRM for Data Modeling.
• Analyze the RDD's sent by the functional team and do the Gap Analysis.
• Identifying the Fields for the Data sources as per the RDD and extracting the data from the data sources using the Generic and (Logistics)LO extractors.
• Used the data provisioning techniques like SLT and DXC.
• SLT has been used to pull the data into tables from ECC To HANA for OTC and FI.
• DXC has been used to pull the data for the GTM, PP, CRM, IS-Retail Extractors.
• Created the Attribute and Analytical views for Master and Transaction data.
• Used Projection, Aggregation, Join and Union Process and followed the best practices to implement the Calculation Views.
• Written SQL Script for writing the stored procedures and Filters and used them in calculation views.
• Pulled the tables from ECC on to HANA using BODS and reported on top of Native HANA.
• Design the Reports as per the RDD's and stored in Solution Manager.
• Collected the view Backup from the respective systems as per the flow and provide them to the release manager for the release.
• Work on the Documentation like RDD, TDD's and User manuals at the time of hand over.
• Provided the End user and guiding them in executing the BI Reports.
• Experience in designing the Functional specs with respect to BOBJ and uploading them to SOLMON.
• Used Information design tool to create Universes.
• Created WEBI reports on top of HANA DB for SD, FICO, GTM, PP, QM etc...
• Created custom Hierarchies, cascading of LOVs at Universe level.
• Extensively used Business Objects Report formatting functionalities such as Drilling Methodology, Filters, Sorts, Ranking, Sections, Graphs, Query Prompts and Breaks .
• Performance tuning has been done to the WEBI reports using different techniques like Query stripping, reducing the no of sub reports and Grouping, performing most of the calculations on Backend, scheduling the reports to provide it to the user on time, removing the hierarchies if they are not used in BEX.
• Used Tableau for HANA reporting for creating dashboards
• Used various functionalities like Sorting, Sets, Bins, calculated measures and groups to create the dashboards.
• Created Storyboards in tableau by using the dashboards as per the client requirement.
• Wrote HANA Expert routine as per the business logic in ABAP Perspective for improving the performance and HAP (HANA APD’s) codes in HANA Modeling Perspective for Analysis purpose.

Confidential, New Britain, Connecticut

SAP HANA Developer

Environment: SAP BI 7.0 and BW 7.3, BW, SAP ABAP, ECC.

Responsibilities:

• Requirement gathering has been done for the SD (Order to Cash and Procure To Pay(P2P), Point of Sales, PP, MM, FICO, SAP SCM (Supply chain) and COPA for Data Modeling.
• Gap Analysis has been done and designed the Report Design Documents (RDD).
• Designed the Technical Specification Document for the data flow objects as per the RDD.
• Worked on Logistics (LO) and Business content data sources to extract the data from ECC to BI.
• Designed the data flows and build the structures like Cubes, DSO, Multi providers, SPO, Transformations, Start Routines, End Routines and Field routines.
• Configured the systems in client system for Dev, QA and Production systems.
• Created schemas and Packages as per the usage.
• Used SLT (SAP Landscape Transformation) for replicating the data in table.
• Worked on SLT (SAP Landscape Transformation) data load monitoring.
• Imported the info objects, DSO and cubes as per the requirement into HANA DB to form Attribute, analytical views and created Connections where ever necessary.
• Data source enhancement codes User Exits configuration and customization done in predefined Function modules, transformations including start, end, expert and individual routines (Field routines) and DTPs, Transformation modifications.
• Modified Attribute views, Analytical views for storing the master, transaction data.
• Had done information modeling in designing the calculated views from multiple analytical and Attribute views.
• Written SQL expressions for hard coding the filters and restricting the data as per the business requirement.
• Created Table types and stored procedures using SQL Scripts.
• Extensively worked on Merge and Partitioning for increasing the performance in HANA.
• Written stored procedures and used them in Views.
• Created calculated measures, restricted measures for performing various calculations in modeling.
• Excellent understanding of the In-memory columnar database functionality.
• Created Analytical Privileges as per users’ access rights.
• Exporting the Models from individual systems and pass It to the HANA Admin team.
• Used the BICS OLAP connection to connect to BW BEX report.
• Extensively worked on Tableau , Business Objects web intelligence for HANA reporting.

Confidential, Illinois

Senior BW/HANA Consultant

Environment: HANA,SAP BI 7.0, ECC 6.0, SAP ABAP, SAP BO XI 3.1(WEBI).

Responsibilities:

• Got the RDD’s from Onshore for functional areas like SD(OTC) and FICO (AP, AR and GL)for Data Modeling.
• GAP Analysis has been done with functional team and reported to onshore for additional information if required any.
• Imported the Column tables into HANA DB from SAP and few of them from SQL Server using BODS.
• Created Information views on the tables imported like Attribute, Analytic and Calculation Views.
• Created Variables for pulling the data selectively to the output.
• Involved in creating Hierarchies for the drill down effect.
• Worked extensively on customized requirements with respect to SQL scripting.
• Use to Export the view and its dependencies to into a folder and provide it to the Admin to Import it to other system.
• Worked extensively on data validation in DEV, QA and PROD.
• Concentrated on fine tuning of SQL Procedures and Views.
• Prepared Unit, SIT and UAT documentation all with User Manuals.
• Used WEBI as the reporting tool to analyze the reports.
• Provided KT to Team on the Project developments.
• Gathering the requirements for functional areas like SD, Inventory, Purchase, HR.
• GAP Analysis has been done with functional team and discussed with them if there are any issues.
• Had created the RDD as per the requirement and created Technical specs.
• Designed the info cubes, multi providers, DSOs, transformations, rule groups according to the specifications in technical specs. migration has been done from BW on Legacy RDBMS to BW on HANA.
• Had done data source enhancements as per the client requirements for the SD data sources and master data sources like Sales order header and material master.
• Open Hub Destinations has been created to move the data for SAP to Non SAP targets.
• Data has been extracted from ECC and flat files using LO extraction and flat file extraction.
• Designed the BEX reports for the data reconciliation with SAP BO.
• Had done transportation with the help of REV-TRAC form DEV to QA.
• Unit testing had been done in Dev, S.I.T in QA and User acceptance testing in Production.
• Scheduled the reports to users using Info View periodically.
• Designed Universes for Inventory and Sales for the reports like sales analysis by location, Sales Analysis by country reports.
• Build the new universes(Using Information design tool) as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Used the formatting functionalities like dynamic filters, report filters, block filters, hierarchies, LOVs, Cascading of LOVs, formulas, variables, drill methodology in hierarchies.
• System design and data model developed in SAP BO XI 3.1 for Actual and Plan data model developed for reporting in SAP BI and SAP BO reporting
• Provided the UAT and End User documentation to the end users.
• Performance tuning is done on Web-I reports.

Confidential

SAP BW consultant

Environment: SAP BW 3.5 BI 7.0, SAP ABAP, ECC, R3.

Responsibilities:

• Worked on system and user generated tickets of service type Change requests (CR), Bug Fix, Bug fix extended, Data Loading, PMRs and resolved them according to S.L.A’s.
• Monitor the data loads by means of process chains for daily sales, open orders, back orders, inquiry, quotations, sales order, delivery, billing, inventory, FICO, Payroll , Personnel Actions, Organizational Management.
• Involved in reconciliation to data in different functional areas like SD, MM, FI, CO.
• Used to trigger manual loads as a part of daily and month end activity.
• Maintained Work history for each and every defect until it is closed down.
• Used to reconcile the row count from ECC to BI after the data load monitoring.
• Performance tuning had been done to increase the query performance by taking the Stats in to Consideration.
• Fine-tuned the ABAP Codes to increase the loading performance.
• Had involved in assigning the defects to the respective group or person.
• Captured objects and releasing objects in the specific order during cutover.
• Providing Missing authorizations to the users.
• Tracking Requests and correcting them if there are any issues, when the Go live is on.
• Flushing out the queues and the row count during the transportation.
• Extensively used BEX to report on BW.
• Used BPS for planning the data.
• Creating and Unlocking users in SAP system.
• Locking the T-codes in the Production system during INIT operation.

Confidential

SAP BW consultant

Environment: SAP BW 3.5 and 7.0, R3, ECC, SAP ABAP,BEX, Wrapper Tool and TP Tool.

Responsibilities:

• Requirement gathering and GAP analysis has been done for the functional modules SD, MM, PP, FICO, QM and HR.
• RDDs has been build with the help of the functional team and distributed the task between the team members.
• Created a custom info object by copying the fields of the standard info object ‘0EMPLOYEE’ and adding some more fields from other info objects.
• Extracted the data for 0PERSON in to BI from the data source 0PERSON ATTR and maintained the text and hierarchy data for other info objects that need to be displayed in report.
• Activated the Business content data sources like 0HR PY 01, 0HR PA 1, 0HR PA OS 1, 0HR PT 2 in RSA5 and enabled the properties of the extract structures.
• Replicated the data sources on to BI Side and build the objects like info areas, info object catalogs, cubes, DSO, Multi providers, info sets etc depending on the properties of the data sources.
• Business content installation is done for the objects that are necessary as per the descriptions in the source in RSOR.
• Designed and Developed a DSO from scratch to load (Delta) for the info types 08: Basic pay, 14 recurring payments and 15 additional payments the data source used in ECC side for this load is ‘0HR PY 01’ Pay roll.
• Designed and Developed a DSO from scratch to load (Full) for the info types 0000 Actions or 0302 Additional Actions the data source used in ECC side for this load is ‘0HR PA 01’ Personnel Actions.
• Designed and Developed a DSO from scratch to load (Full) for the info types Absences (2001) Attendances (2002) Employee Remuneration Information (2010) the data source used in ECC side for this load is ‘0HR PT 2’ Actual and Labor Times.
• Loaded the test data and involved in UAT, SIT and BAT for testing the quality of data in DEV, QA and PROD.
• Written Start routine, End routine to filter the data records and to look up the data from source table and field routine for simple business logics i.e. for merging CRM data with GTM in the data flow.
• Involved in writing the customer/User Exit codes in the FM EXIT SAPLRRSO 001 for time characteristics.
• Reports have been designed in Query designer using variables, restrictions, Exceptions, Exception Aggregations, Conditions, RKF and CKFs.
• Created BEX Reports on top of the Multi providers and Info sets.
• Worked extensively on BPS in Planning the data.
• Performance tuning has been done in the BI System using Aggregates, Compression, Pre calculated Web templates, partitioning in Cube and DSO and fine-tuned the ABAP codes.
• Performed Support Activities like Process chain Monitoring and Handling the Incidents.