Parul Gupta

adk7m2@r.postjobfree.com

503-***-****

(Power BI Developer/ SAP HANA Consultant/ SAP BODS Developer)

Professional Summary

8+ years of Professional IT experience with strong Azure Data Factory, MS Power BI, SAP BASIS & HANA Administration, Data Migration, Data Conversion, Data Profiling BODS, Data Integrator, Data Quality, Data Provisioning, BW, Information Steward 4.2 experience involving several stages of implementation life cycle including Analysis, Design, Development, Testing, Implementation & Post-Implementation support involving end-to-end SAP implementation and support, SAP Upgrade projects and DATA & Report Migration projects:

4+ years of experience in SAP Data Migration / Conversion / Integration / SAP HANA Modelling and ETL Tools using SAP Data services- BODS 4.0/4.1/4.2 and SAP HANA Studio- HANA 1.0/2.0.

1+ years of experience as Power BI developer to create Enterprises Reports/ Sales Reports using Power BI desktop, Azure data factory (ADF) to perform ETL from different data sources.

Strong knowledge on Power BI to import data from various sources such as SQL server, Azure DB, MS Excel, SAP etc.

Strong knowledge on Azure services like ADF, ADL, Azure monitoring, Azure data storages etc.

Extensive experience in SAP implementation and operational basis support on multiple production servers along with project activities on customer landscapes.

Experience in SAP solution manager installation, SPS upgrades, Managed system configuration, Early watch alert configuration, Technical system monitoring configuration.

User and security administration in SAP system, IBP and QLIK Management console.

Hands-on experience in all aspect of ABAP Engine Administration including client Copy/Export/Import, System Refreshes, System copies, Support packages, Spool administration, Background Jobs, Workload analysis, Backup/Recover, Add-on installation, System monitoring/ Maintenance and applying SAP OSS notes.

Proficient in Data Migration / Data Conversion using BODS/LSMW/BAPI/IDOCS and LTMC.

Loaded data into Customer Master and Material Master using DEBMAS, MATMAS Idocs using BODS.

Proficient in Various Transformations like Validation, Merge, Case, Table Comparison, Hierarchy Flattening, Key Generation, Map Operation and Data Quality Transforms like Match, Data Cleanse transforms etc.

Proposed Best practices in SAP BODS and SAP HANA Modelling, Good in proposing Performance Optimization techniques.

Thorough knowledge in SAP HANA 1.x/2.0 and good in writing SQL query and creating Views (including Analytic, attribute and calculation view) in SAP HANA studio.

Proficient in advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter, currency conversion.

Proficient in execution of practical application of Agile framework components (user stories, scrum, sprints, sprint planning, release planning, backlog refinement, daily stand-up etc.)

Have expertise to review and gather business requirements and interpret these into an architectural design and information model in SAP HANA environment.

Expertise in Real time jobs using SAP Landscape Transformation (SLT).

Understanding of Tableau data visualization for HANA and Big Data.

Proficient in of SAP HANA Administration using SAP HANA Studio.

Good understanding of cross module integration and experienced in Planning and scheduling of objects to be migrated.

SQL Query optimization/tuning and learning effective SQL programming techniques.

Good knowledge of Data Warehouse Concepts including Schemas, Dimensions and Facts etc.

Proficient in Unix and MSSQL Server.

Educational Background

Bachelor of Technology (B. Tech) in Information Technology

Organizational Highlights

Agile Scrum.org "PSM1 Certified with 97%".

Internal certification on Data visualization on Tableau

Internal certification SAP BODS.

Microsoft Certified Data analyst (DA-100 Certification).

Certification on Azure Fundamental (AZ-900).

Designing an Azure Data solution (DP-201).

Key Technical Skills

ETL: SAP BODS (4.2 SP7-SP9), Azure Data Factory.

ERP: SAP HANA SP12, SAP ECC 6.0, S/4 HANA 1809

Databases: SAP HANA 2.x/1.x, Oracle10g/11g, PostgreSQL, MSSQL,

Development IDE: HANA Studio, SAP Data Service Designer, PL/SQL developer, pgAdmin4, Azure Portal

Visualization tool: Power BI Desktop, Power BI services Tableau, QlikSense

Configuration Management Tool: SVN, BODS Management Console, SharePoint, IBP Server, Qlik MC, Xandria

Programming Languages: Python, SQL

Other: Jira, ServiceNow, GitHub

Work Experience: Tata Consultancy Services (July 2012 – Till Date) as IT ANALYST.

Projects Summary:

PROJECT: TCS

Role: Power BI Developer

Period: Mar-20 to till date

Description: Client has become a global player in breastfeeding products and medical vacuum technology thanks to continued research, innovation and the evaluation of customers' needs. This has 18 subsidiaries in Europe, North America and Asia. This distributes its products in more than 100 countries, either directly or through independent partners.

Roles and Responsibilities:

Imported data from SAP to Power BI to generate sales report for Sales department for analysis.

Created Azure Blob storage for Import/Export data to/from .CSV File.

Used Azure Data Factory service to perform ETL.

Created DAX queries to generate computed columns in Power BI.

Published Power BI Reports and made Dashboards as per requirements.

Used Power BI gateways to keep dashboards and reports up to date.

PROJECT: TCS

Role: SAP BASIS/ Security/ HANA Consultant

Period: Apr-19 to Mar-20

Description: Client has become a global player in breastfeeding products and medical vacuum technology thanks to continued research, innovation and the evaluation of customers' needs. This has 18 subsidiaries in Europe, North America and Asia. This distributes its products in more than 100 countries, either directly or through independent partners.

Roles and Responsibilities:

Responsible for system administration and support of technical architecture, including Basis support of SAP NET WEAVER and BW platforms, with the goal of providing excellent system reliability, performance

Provide SAP Basis administration Support, Performance monitoring &tuning, Problem analysis & resolution, and other activities required to maintain system integrity and maximize uptime.

Responsible for roles and objects creation.

Raised SAP incident to SAP and registered the SAP Router static IP address at SAP global.

Incidents and Service requests handled on daily basis production issues.

User administration and role assignment in S4 system, IBP, QLIK, Solman.

Transported change requests from Dev system to Test, Quality and Production system.

Scheduling and monitoring the background jobs.

NWA administration for Java systems across the Landscape.

SAP system monitoring using BASIS t-codes and Xandria tool.

Involved in Monthly maintenance window and System refresh/Upgrade activities.

Creating OSS connection to SAP and maintaining system details in service marketplace.

Applied OSS notes and support packages based on functional consultant requirement.

Environment: S/4 HANA 1809, Hana DB 2.0, SUSE Linux SP12

PROJECT: TCS

Role: S4 HANA Migration Lead/ Developer

Period: Apr-18 to Mar-19

Description: Client is a Swiss company that supplies machinery and services to the packaging industry. Products include machines for the manufacture of packaging and its derivatives (such as labels, bags, and adhesive strips) from solid board, corrugated board or flexible materials (plastic films, etc.).

Roles and Responsibilities:

Responsible for driving the entire data migration effort to migrate data from several legacy applications and legacy SAP environments to new SAP implementation.

Responsible for Pre-Load and Post Load data validation and for creation and distribution of preload and post load reports related to legacy and SAP data.

Responsible for the development of SAP BODS ETL jobs, workflows, dataflows and loading of data using IDOCs and LSMW. To create workflow and dataflow using different transforms like Merge, Table comparison, Query etc. to get the desired data into target DB.

Coached team in optimal time utilization through concepts of scrum and agile management methodologies.

Led sprint reviews and daily scrum meetings to touch base with whole team and ensure that all members were performing satisfactorily.

Implemented CDC (Changed Data Capture) to load delta load.

Scheduling and monitoring the jobs in CMC.

Involved in ETL Testing.

Implemented Slowly Changing Dimensions type -1&2 techniques to load current and Historical Data.

Environment: SAP BODS 4.2, SAP HANA Studio, Oracle10g/11g, pgAdmin4, Windows

PROJECT: TCS

Role: Senior SAP HANA and BODS Developer

Period: May-16 to Feb-18

Description: This Sales application manages all sales related web reports based on various Sales KPI, which we need to show/load within 5sec benchmark time. This application uses HANA in memory DB for faster processing of data.

Roles and Responsibilities:

Developed HANA Information views for smart sales report graphs as on date, as on 1st of the current month, quarterly trend analysis of the last 8 quarters + current quarter for selling, servicing and horizontal units according to the users’ access data & usage report.

Dimensional Modeling and optimization of SQL queries. (memory utilization of view should be less than 10 GB and execution time should be less than 5sec are the benchmarks set by higher management).

Developed BODS jobs for monthly historical data.

Being a SPOC for performance and responsible for reviewing HANA views and BODS jobs to improve the design, performance and memory utilization.

Involved in integration testing and deployment activities.

Implemented Slowly Changing Dimensions type -1&2 technique to load current and Historical Data using different transforms (Transformation: Table Comparison, Historic preserving, key generation, case, query, merge, validation and map operation)

Environment: SAP BODS 4.2, SAP HANA Studio, Oracle10g/11g, Windows

PROJECT: TCS

Role: Siebel EIM Consultant

Period: Dec-14 to Mar-16

Description: Smart Sales CRM provides TCS sales users with an application to store and manage all the sales specific information. This application helps the Sales users to create new clients for TCS as well as track all the deals that are carried out with them. The CRM team of Ultimatix thus manages the Siebel Sales application and continuously enhances the functionality by gathering requirements from various sales users.

Roles and Responsibilities:

Created complex views which are used by Enterprise Reporting Team.

Performed data migration from Oracle to Postgre DB.

Created procedures and functions to implement complex business requirements

Created EIM jobs to carry out data migration, data clean-up and data synchronization processes.

Environment: Oracle10g/11g, PL/SQLDeveloper, Windows, SiebleTools8.1.1.11

PROJECT: TCS

Role: SAP BI Consultant

Period: Nov-12 to Dec-14

Description: One of the leading players in branded retail industry in India. It offers an exclusive range of its own branded fashion apparel and is the mainstay of the retailing business of the company. The company has already established 143 stores across 82 cities.

Roles and Responsibilities:

Monitoring the data loads to targets, running on daily, weekly and monthly through process chains.

Worked on flat file extraction of master and transactional data of Non-SAP R/3 system into BW.

Involved in creating and maintaining Info Cubes, Datastore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process and Info Packages.

Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Variables, etc. For customized reporting using BEx Analyzer, BEx Query Designer.

Change request implementation for each BW job failure.

Environment: SAP BW 7.0, 3.5, BO 3.1/ 4.0, SAP ECC 6.0, SAP R/3 4.7, BEx Analyzer, Query Designer

Contact this candidate