Data Sap

AKHIL GUPTA

** ****** ******** ********, *******, L6Y 0L4

Cell: 416-***-****, E-mail: *****.****@*****.***

SUMMARY AND OBJECTIVES

Engineering graduate having 7 years of diversified experience in ETL Solutions, Business Analytics & Data Solutions

Technical Expertise for SAP Implementation projects.

Architect Experience in Data Migration methodologies, specifically around legacy to SAP migration through SAP BODS 4.2

Developed and Supported mappings using Informatica PowerCenter 9.x that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations

Experience in building Complex Data Models for enterprise level Business Intelligence Solution, Data Warehouse Solution and associated processes

Expert in realizing the business demands and proposing solutions, system handling, continuous demand management and development of changes (customizing)

End to end implementation of Project which Includes Requirement gathering, Creation of technical document, Developing, Testing, Deployment and Warranty support of ETL jobs

Strong understanding of the SAP BODS landscape and architecture

Experience in SAP HANA and Provisioning methods

Expertise in SQL, Teradata, UNIX, Remedy, Autosys tools

Knowledge of SAP Business Objects including Web Intelligence, Information Design Tool

PROFESSIONAL EXPERIENCE

Solution Designer and ETL Specialist– PC Plus Loyalty

Accenture - Loblaws Companies Limited

April 2013 – February 2018

Loyalty program at Canada’s largest Retailer

Involved in Implementing, Enhancing and Supporting Loyalty Program at Canada’s largest Retail company (Loblaws)

Responsible for delivering all New /Existing jobs related to Loyalty ETL Interfaces

Worked with the client to understand and design the business requirements for the project`

Worked on ETL Development that includes Data transformation, Conversion, Loading and data analysis, Design and Development, testing of Jobs.

Design and development of Data Marts and Data modelling

Worked in Production Support that involves identifying root causes, trouble shooting, data recovery and implementing change/enhancements in production.

Experience in querying, data extraction, data transformations and Performing ADHOC analysis using complex SQL queries. Proficient in performance analysis, monitoring and SQL query tuning.

Involved in creating technical documentation in the work assignments

Resolve moderate problems and defects associated with the designed Jobs

Involved in Unit Test Case Preparation

Co-ordinating with Production Support team to help in analyzing Production Failures/Issues and help in getting that resolved

ETL Support Practitioner

Accenture – Best buy Cooperation

April 2011 – March 2013

Production Support of Retail applications at consumer electronics corporation Best Buy US

Performing critical & non-critical support activities and resolve complex problems

Ownership of critical issues and provide timely solutions and analysis

Resolving production issues/failures within Service level agreements(SLA)

Working independently with production application support and cross functional teams to resolve production issues

TECHNICAL EXPERTISE

SAP Business Objects Data Services v 4.x

Strong understanding of the SAP BODS landscape and architecture

Developed Job connecting to various Sources like SAP CRM Extractors, SAP application/ SAP BW, Oracle 11g, Teradata and all types of delimited flat files

Implementation knowledge of all types of loading mechanism Like SCD1, SCD2, delta Full/Incremental Load in job creation

Developed Jobs Fetching Data from Different Source Systems like Oracle, ECC/BW, Teradata, Flat Files and loading into Teradata, XML and Flat Files, Oracle.

Worked on Various BODS Transformations like SQL, Validation, Case, Merge, Pivot, Table Comparison, History Preservation, Row Generation and Query.

Expertise on Performance tuning and Push down methodologies involved in BODS

Strong Hands on experience of data Extraction, Transformation, Loading processes

Data cleansing, modelling, enterprise data architecting, data quality and data governance

Worked on Many Platform and Data Integration Transformations

Worked on Design and Development of Autosys - Tool used for Scheduling BODS Jobs in DEV, QA and Production environment.

AKHIL GUPTA

69 Oblate Crescent Brampton, Ontario, L6Y 0L4

Cell: 416-***-****, E-mail: *****.****@*****.***

Informatica PowerCenter v 9.x

Expertise in creating the ETL source to Target specification documents by understanding the business requirements

Developed and Supported mappings that perform Extraction, Transformation and load of source data into Derived Masters schema using various power center transformations like

Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, SQL, Normalizer and update strategy

Implementation knowledge of all types of loading mechanism Like SCD1, SCD2, delta Full/Incremental Load in job creation

Build Reusable transformations wherever redundancy is needed

Worked at Performance tuning at the Mapping level as well as the Database level to increase the data throughput

End to end implementation of Project which Includes Requirement gathering, Creation of technical document, Developing, Testing, Deployment and Warranty support of ETL jobs

SAP HANA

Strong understanding of SLT

Providing effective solution on HANA and SLT as per client requirement.

SAP HANA Modelling Knowledge.

Knowledge of designing of attribute views, analytic views, Calculation views.

Experience with SAP Data Services and other data provisioning methods

EDUCATION

UP Technical University (Raj Kumar Goel Institute of Technology, Ghaziabad, India)

Bachelor of Technology, Information Technology (2010)

SKILLS AND COMPETENCIES

- SAP BODS Data Services v 4.x

- Informatica PowerCenter v 9.x

- Teradata, SAP HANA, Structured Query Language (SQL), SQL Server, Data modelling, UNIX

Contact this candidate